[qmailtoaster] vmysql: sql error[3]: MySQL server has gone away

[Fernando Azevedo]

Hi all,   Here is the problem: When I try to access a few accounts via IMAP I always get access denied.   The logs show:   ==> /var/log/qmail/authlib/current <== 2006-10-28 21:49:06.325971500 vmysql: sql error[3]: MySQL server has gone away   ==> /var/log/qmail/imap4/current <== 2006-10-28 21:49:06.305007500 DEBUG: Disconnected, ip=[192.168.1.252], time=28 2006-10-28 21:49:06.305111500 tcpserver: end 2725 status 0 2006-10-28 21:49:06.305113500 tcpserver: status: 0/40 2006-10-28 21:49:06.318065500 tcpserver: status: 1/40 2006-10-28 21:49:06.318068500 tcpserver: pid 2728 from 192.168.1.252 2006-10-28 21:49:06.318070500 tcpserver: ok 2728 kalimero.netlandia.net:192.168.1.250:143 :192.168.1.252::2189 2006-10-28 21:49:06.318072500 DEBUG: Connection, ip=[192.168.1.252] 2006-10-28 21:49:06.326045500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252]   ==> /var/log/qmail/authlib/current <== 2006-10-28 21:49:20.917956500 vmysql: sql error[3]: MySQL server has gone away 2006-10-28 21:49:20.925457500 vmysql: sql error[3]: MySQL server has gone away     I’ve followed the wiki section: 9.2.2 When using MySQL for authentication, I get the error vmysql: sql error[3] MySQL server has gone away from page http://qmailwiki.inter7.com/Vpopmail#When_using_MySQL_for_authentication.2C_I_get_the_error_vmysql:_sql_error.5B3.5D_MySQL_server_has_gone_away   However… When following these instructions the results is as follows in the lines bellow.   [EMAIL PROTECTED] ~]# [EMAIL PROTECTED] ~]# cat /etc/passwd | grep vpopmail vpopmail:x:89:89:Vpopmail User:/home/vpopmail:/sbin/nologin [EMAIL PROTECTED] ~]# [EMAIL PROTECTED] ~]# su vpopmail This account is currently not available. [EMAIL PROTECTED] ~]# [EMAIL PROTECTED] ~]#   In spite of this first drawback I kept on following the instructions…   [EMAIL PROTECTED] ~]# [EMAIL PROTECTED] ~]# mysql -u vpopmail -p vpopmail Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A   Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 45 to server version: 5.0.22   Type 'help;' or '\h' for help. Type '\c' to clear the buffer.   mysql> show tables; +------------------------+ | Tables_in_vpopmail     | +------------------------+ | dir_control            | | kalimero_netlandia_net | | lastauth               | | valias                 | +------------------------+ 4 rows in set (0.00 sec)   mysql>     hey… it worked!!! But… where is table vpopmail mentioned in the instructions???   Anyhow… the wiki mentions “Pick a table. vpopmail is a good one to use” so, it is not mandatory to count the rows of vpopmail table, so let’s try another one:   mysql> mysql> select count(*) from kalimero_netlandia_net; +----------+ | count(*) | +----------+ |        3 | +----------+ 1 row in set (0.00 sec)   mysql> mysql>   Hummm it worked!!! So… Let’s try again to have this IMAP account working from a remote machine:     ==> /var/log/qmail/authlib/current <== 2006-10-28 23:42:12.328840500 vmysql: sql error[3]: MySQL server has gone away 2006-10-28 23:42:12.333209500 vmysql: sql error[3]: MySQL server has gone away   ==> /var/log/qmail/imap4/current <== 2006-10-28 23:42:12.317860500 tcpserver: status: 1/40 2006-10-28 23:42:12.317864500 tcpserver: pid 6355 from 192.168.1.252 2006-10-28 23:42:12.317866500 tcpserver: ok 6355 kalimero.netlandia.net:192.168.1.250:143 :192.168.1.252::2694 2006-10-28 23:42:12.317881500 DEBUG: Connection, ip=[192.168.1.252] 2006-10-28 23:42:12.319273500 tcpserver: status: 2/40 2006-10-28 23:42:12.319277500 tcpserver: pid 6356 from 192.168.1.252 2006-10-28 23:42:12.319279500 tcpserver: ok 6356 kalimero.netlandia.net:192.168.1.250:143 :192.168.1.252::2695 2006-10-28 23:42:12.319281500 DEBUG: Connection, ip=[192.168.1.252] 2006-10-28 23:42:12.328919500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252] 2006-10-28 23:42:12.333281500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252]   ==> /var/log/qmail/authlib/current <== 2006-10-28 23:42:18.855156500 vmysql: sql error[3]: MySQL server has gone away   ==> /var/log/qmail/imap4/current <== 2006-10-28 23:42:18.855219500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252]   ==> /var/log/qmail/authlib/current <== 2006-10-28 23:42:19.624392500 vmysql: sql error[3]: MySQL server has gone away   ==> /var/log/qmail/imap4/current <== 2006-10-28 23:42:19.624424500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252]   It looks like it still does not work. Anyhow, I’ve changed nothing so… why should it be working now???   The alphabetical list of packages installed in this Fedora Core 5 machine is:   [EMAIL PROTECTED] ~]# [EMAIL PROTECTED] ~]# rpm -qa | grep toaster | sort autorespond-toaster-2.0.4-1.3.1 clamav-toaster-0.88.5-1.3.4 control-panel-toaster-0.5-1.3.1 courier-authlib-toaster-0.58-1.3.1 courier-imap-toaster-4.1.1-1.3.2 daemontools-toaster-0.76-1.3.1 ezmlm-cgi-toaster-0.53.324-1.3.1 ezmlm-toaster-0.53.324-1.3.1 isoqlog-toaster-2.1-1.3.1 libdomainkeys-toaster-0.68-1.3.1 maildrop-toaster-2.0.2-1.3.1 maildrop-toaster-devel-2.0.2-1.3.1 qmailadmin-toaster-1.2.9-1.3.1 qmailmrtg-toaster-4.2-1.3.1 qmail-pop3d-toaster-1.03-1.3.3 qmail-toaster-1.03-1.3.6 ripmime-toaster-1.4.0.6-1.3.1 simscan-toaster-1.2-1.3.1 spamassassin-toaster-3.1.7-1.3.5 squirrelmail-toaster-1.4.8-1.3.3 ucspi-tcp-toaster-0.88-1.3.1 vpopmail-toaster-5.4.13-1.3.2 vqadmin-toaster-2.3.4-1.3.2 [EMAIL PROTECTED] ~]# [EMAIL PROTECTED] ~]#   Anyone can help on this issue?     Thanks in advance, FA