I suddenly have a client's access_SSL_log.processed file growing at a ridiculous rate. Very small website. The log file had grown to 6BG before I realized the problem. I removed it and two days later there was a 3GB log file that replaced it. Nothing strange that I can see regarding the traffic to the website, which is quite small. Only 80 visitors.
My mail queue is growing up. I've stopped qmail but the queue goes on growing I must have an script running injecting mail in the queue, how can I find the script? I looked the running process (ps ) but I can not find anything (there is a lot of process!!!!)
I would like to install a tomcat application on my domain. Where do I upload the .war file and how can I manage the tomcat and access this application? I have root access to my Cpanel/WHM box. Also, I did apply a servlet already via WHM.
Also, I need to restore my postgres backup file as well but its too big to be done via pgmyadmin. How can I go about doing this via command line?
I'm aware of how to restore a mysql db via command line (1st create db in cpanel, 2nd run command in ssh). Never done so with a postgresql database.
I am looking for a webhost with a package that supports both ASP.NET *and* Postgres. So far, I have been able to find ones that support one but not the other.
Take a look what moderator of MySource Matrix forums says (enterprise-CMS based on PHP4+pgSQL):
Quote:
Yes, installing onto a virtual server is great, because its like you have an entire server to yourself. However, running PostgreSQL in a VM is not recommended for performance reasons. Obviously this isn't a concern on low-traffic sites. The ultimate solution would be a virtual server for Apache/PHP/MySource Matrix and a dedicated server for PostgreSQL. Though, I don't know of any virtual server providers that also provide dedicated database server access.
(...)
The problem with PostgreSQL (or any database) under virtualisation is that there is no IO prioritization given. So, the database just waits along with everything else for the hypervisor to deliver IO, with no consideration for priorities. This leads to a performance hit of about 70-80%. In testing, we've seen PostgreSQL under VMware ESX/GSX perform horribly, even with fibre-attached SAN storage. Though, sticking PostgreSQL on a Xen DomU seems better. The sysadmins have done some testing on this too.
If you run PostgreSQL across multiple virtual servers on the same hardware, you're just compounding the IO bottlenecks, so I can't recommend it at all.
Transferred a domain from one cpanel server to another using whm > copy account feature, but now this error arises
--------------- pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: database "udre" does not exist ---------------
Found this in the copy accounts log
Grabbing PostgreSQL databases............ could not change directory to "/root" could not change directory to "/root" could not change directory to "/root" ............... Done Grabbing PostgreSQL privileges...could not change directory to "/root" could not change directory to "/root" could not change directory to "/root"
The postgresql not start on my server. Use REDHAT Enterprise 4, I tried to install the command:
/scripts /installpostgres
But I returned the following error:
[root@s2 backups]# /scripts/installpostgres This script will install Postgres 7.3.x or later If you have an older version installed you wil need to Dump your databases to a file and then restore them after the install as 7.3.x is not backwards compatible. If you do not have any databases, you can just run: mv /var/lib/pgsql /var/lib/pgsql.old /sbin/service postgresql stop /sbin/service postgresql start to force creating a 7.3.x style setup. Do not do this if you have databases that you wish to keep!
Are you sure you wish to proceed? y
Fetching Obsoletes list for channel: rhel-i386-es-4...
Fetching rpm headers...
Name Version Rel ----------------------------------------------------------
The following packages you requested were not found: rh-postgresql rh-postgresql-devel rh-postgresql-libs rh-postgresql-server
The following packages you requested are already updated: postgresql-libs postgresql-server postgresql postgresql-devel Stopping postgresql service: [FAILED] postmaster: no process killed postmaster: no process killed Starting postgresql service: [FAILED] You should now configure postgresql from WHM! You should now configure postgresql from WHM! You should now configure postgresql from WHM! You should now configure postgresql from WHM!
Looking for dedicated server that allows adult and proxy hosting and comes with PostgreSQL. Really looking for a more established host and not some one that’s going to steal my money and run. am open for your ideas on what you think is the best.
I saw the note about Request threads, but I've had no luck with the requester form or sponsors and my requirements are perhaps a little uncommon. I just opened an account with a certain host only to find that the inode thing will be an issue, so already searching for a new place. Recommendations?
I'm flexible on pricing.. up to $20 / month?
My sites:
3x domains 3x Gallery2 installs 20Gb total (~ 70k inodes)
REQUIREMENTS:
PostgreSQL * PHP 5 30Gb storage (and no harsh inode limit) 5-20Gb traffic (typically closer to 1Gb, if that) SSH & rsync
PREFERABLE:
PostgreSQL 8.x (many times faster than 7.x) PHP 5.2.3+ (supports phpdoctrine) Proper domain management (ability to add arbitrary records)
A customer is asking to open the port to access PostgreSQL on a shared server because he needs remote access to his database. Is it a good idea to grant remote access to PostgreSQL?
Haven't seen much debate lately on what processors to use within dedicated database servers. We're currently considering Dell 2950s and 2970s with the following:
8GB RAM, single SAS, 3.5-inch, 15K RPM Hard Drive for OS, single SAS, 3.5-inch, 15K RPM Hard Drive for SWAP, and four SAS, 3.5-inch, 15K RPM Hard Drives in a RAID10 array for database storage.
We'll be getting one server just for MySQL applications and one server for just PostgreSQL applications.
I have installed Apache 2.4.3, and PHP 5.4.5 64-bit, and I have installed PostgreSQL 9.2 64-bits under my new system windows 7 64 bits. Apache and PHP could work nicely, and PostgreSQL run fine too. However, PHP couldn't access the PostgreSQL. pg_connect(), and followed by echo select version(), didn't give any error. When PostgreSQL module was not loaded (because my php dir was d:php, but inside httpd.conf i type D:/PHP), I got message saying something like "undefined pg_connect()." I fixed it, but select version() or any other echo after pg_connect() didn't give any output.
I would like to ask you what software I need to control VPS - stop it when it expires the owner's account and he must pay agan to use it.
Software must work with VMware, Solaris conteiners (xVM server), Virtuozzo and etc.
What software for billing the VPS can you recommend me?
Is there a second way to control the access to the VPSs? Can I install hardware firewall before the servers witch host VPSs and install billing software on that firewall so when the owner don't pay for the VPS the firewall cuts the access to the VPS.
I have VmWare VPS hosting, I just started and I have few questions. How can I see how much bandwidth each VPS consumes? How can I know if someone is doing illegal activities like spam, file sharing, IRC, etc.? I ask this because I give complete control over VPS to my customers so I don't have access to it, only thing I do is backup of whole VPS image on spare HDD, and network/hardware troubleshooting. So how to control whats happening on my VPS-es?
I tried contacting the live support from fatcow, and he was no help. It was probably just the guy i had but thats not the point. I think i am going to go with them but what control panel do they use?