Lost my email

[phoenixisp]

Hi Scott, I believe I have a mysql problem. It started with qmail not working on a RH 9 box with plesk 7.5.4. Webmail gives a message:

Warning: fsockopen(): unable to connect to 127.0.0.1:25 in /usr/share/psa-horde/pear/Net/Socket.php on line 108

I can't telnet to port 25, can't connect. I tried to do:

/usr/local/psa/admin/sbin/mchk -v

And get back:

mchk: db_connect: failed to connect to database: Error: Too many connections
mchk: db_connect: failed to connect to database: Error: Too many connections
mchk: Unable to connect to the Plesk database
mchk: Unable to connect to the Plesk database

If I change anything in the my.cnf file, I can't connect to mysql due to a socket error.

While digging into things I did:

[root@host1 root]# rpm -qa | grep mysql
php-mysql-4.3.11-8.rh90.art
mysql-4.0.24-2.rh90.art
mysql-server-4.0.25-1.rh90.art
mysql-4.0.25-1.rh90.art
mysql-compat-4.0.25-1.rh90.art
mysql-server-4.0.24-2.rh90.art
mysql-compat-4.0.24-2.rh90.art

(You can tell I'm a big ART fan.) The component page of Plesk only shows the 4.0.24-2 version. I tried downloading the 4.0.25-1 and installing it, but got warnings :

error: Failed dependencies:
mysql = 4.0.24 is needed by (installed) mysql-server-4.0.24-2.rh90.art
mysql = 4.0.24 is needed by (installed) mysql-compat-4.0.24-2.rh90.art

I'm lost and have no email. Any ideas?

Thanks,

Sonny

[phoenixisp]

Well, I have my email back, it was a typo in smtp_psa. But I still get the error when doing mchk. Any ideas?

[scott]

that fsockopen message is generally indicative of a high file descriptor environment (do you have over 250 domains?). It typically requires a recompile of apache, imap, and php.

On mysql, you should try upgrading with yum, it will save you a lot of time. The too many connections message is related to the above I'll bet, lots of stuff going on the system (high # of domains, busy sites, etc).