[vchkpw] vchkpw can't connect to mysql update server
Hi friends I am using vpopmail-5.2.1 with mysql running vchkpw authentication. Once in a while, the qmail-send show me this error message: 2002-08-25 04:32:50.580965500 status: local 16/100 remote 0/250 2002-08-25 04:32:50.601224500 delivery 4226: deferral: could_not_connect_to_mysql_update_server_To o_many_connections_with_database/could_not_connect_to_mysql_update_server_To o_many_connections/ 2002-08-25 04:32:50.601241500 status: local 15/100 remote 0/250 And when I make a connection pop3 show me this: [root@linux /root]# telnet localhost 110 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. +OK [EMAIL PROTECTED] user [EMAIL PROTECTED] +OK pass XX could not connect to mysql update server Too many connections with database could not connect to mysql update server Too many connections could not create lastauth table CREATE TABLE vlog ( id BIGINT PRIMARY KEY AUTO_I NCREMENT, user char(32), passwd CHAR(32), domain CHAR(64), logon VAR CHAR(200), remoteip char(18), message VARCHAR(255), timestamp bigint default 0 NOT NULL, error INT, INDEX user_idx (user), INDEX domain_ idx (domain), INDEX remoteip_idx (remoteip), INDEX error_idx (error), INDE X message_idx (message) ) error inserting into lastauth table -ERR authorization failed In order to solve this problem, I erase the table vlog using this mysql command: delete from vlog; and I have shutdown qmail and mysql services. In addition I have than fix the table vlog using the command: myisamchk -r -q /var/lib/mysql/vpopmail/vlog Somebody has an idea of which it can be happening? Thanks for your replies. Bye
Re: [vchkpw] vchkpw can't connect to mysql update server
You might want to bump up the number of connections allowed on your mysql server. Juan Enciso - DNSQ wrote: Hi friends I am using vpopmail-5.2.1 with mysql running vchkpw authentication. Once in a while, the qmail-send show me this error message: 2002-08-25 04:32:50.580965500 status: local 16/100 remote 0/250 2002-08-25 04:32:50.601224500 delivery 4226: deferral: could_not_connect_to_mysql_update_server_To o_many_connections_with_database/could_not_connect_to_mysql_update_server_To o_many_connections/ 2002-08-25 04:32:50.601241500 status: local 15/100 remote 0/250 And when I make a connection pop3 show me this: [root@linux /root]# telnet localhost 110 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. +OK [EMAIL PROTECTED] user [EMAIL PROTECTED] +OK pass XX could not connect to mysql update server Too many connections with database could not connect to mysql update server Too many connections could not create lastauth table CREATE TABLE vlog ( id BIGINT PRIMARY KEY AUTO_I NCREMENT, user char(32), passwd CHAR(32), domain CHAR(64), logon VAR CHAR(200), remoteip char(18), message VARCHAR(255), timestamp bigint default 0 NOT NULL, error INT, INDEX user_idx (user), INDEX domain_ idx (domain), INDEX remoteip_idx (remoteip), INDEX error_idx (error), INDE X message_idx (message) ) error inserting into lastauth table -ERR authorization failed In order to solve this problem, I erase the table vlog using this mysql command: delete from vlog; and I have shutdown qmail and mysql services. In addition I have than fix the table vlog using the command: myisamchk -r -q /var/lib/mysql/vpopmail/vlog Somebody has an idea of which it can be happening? Thanks for your replies. Bye
