Hey Fernando,
Quick question, did you upgrade to the latest versions or did you
upgrade from previous versions?
Depending on what versions you started with, the order in which you
upgraded the binaries could make a difference.
In the mean time, you could try to add "wait_timeout = 432000" to the
[mysqld] section of your my.cnf and restart the mysqld service
On 10/29/06, Fernando Azevedo <[EMAIL PROTECTED]> wrote:
As you can see I do have all the lateste versions installed... Is there
anything else to do besides having all teh latest versions with patches?
Regards,
FA
________________________________
De: Eric "Shubes" [mailto:[EMAIL PROTECTED]
Enviada: dom 29-10-2006 3:33
Para: [email protected]
Assunto: Re: [qmailtoaster] vmysql: sql error[3]: MySQL server has gone away
I'm under the impression that vpopmail was patched to fix this.
EE?
Fernando Azevedo wrote:
> 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
>
<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#When_using_MySQL_for_authentication.2C_I_get_the_error_vmysql:_sql_error.5B3.5D_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
>
--
-Eric 'shubes'
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
