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

Mon, 30 Oct 2006 02:23:44 -0800

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

Hello all!

 

As you can see by the logs bellow the problem continues… L

 

 

==> /var/log/qmail/authlib/current <==

2006-10-30 10:04:47.087934500 vmysql: sql error[3]: MySQL server has gone away

 

==> /var/log/qmail/imap4/current <==

2006-10-30 10:04:47.050416500 tcpserver: status: 1/40 2006-10-30 10:04:47.050420500 tcpserver: pid 28978 from 192.168.1.252 2006-10-30 10:04:47.050422500 tcpserver: ok 28978 kalimero.netlandia.net:192.168.1.250:143 :192.168.1.252::1106 2006-10-30 10:04:47.050424500 DEBUG: Connection, ip=[192.168.1.252] 2006-10-30 10:04:47.088013500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252]

 

==> /var/log/qmail/authlib/current <==

2006-10-30 10:04:58.590092500 vmysql: sql error[3]: MySQL server has gone away

 

==> /var/log/qmail/imap4/current <==

2006-10-30 10:04:58.590130500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252]

 

==> /var/log/qmail/authlib/current <==

2006-10-30 10:04:59.462576500 vmysql: sql error[3]: MySQL server has gone away 2006-10-30 10:04:59.496322500 vmysql: sql error[3]: MySQL server has gone away

 

==> /var/log/qmail/imap4/current <==

2006-10-30 10:04:59.453594500 tcpserver: status: 2/40 2006-10-30 10:04:59.454707500 tcpserver: pid 28980 from 192.168.1.252 2006-10-30 10:04:59.454710500 tcpserver: ok 28980 kalimero.netlandia.net:192.168.1.250:143 :192.168.1.252::1108 2006-10-30 10:04:59.454712500 DEBUG: Connection, ip=[192.168.1.252] 2006-10-30 10:04:59.462651500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252] 2006-10-30 10:04:59.485831500 tcpserver: status: 3/40 2006-10-30 10:04:59.485835500 tcpserver: pid 28981 from 192.168.1.252 2006-10-30 10:04:59.485836500 tcpserver: ok 28981 kalimero.netlandia.net:192.168.1.250:143 :192.168.1.252::1109 2006-10-30 10:04:59.485839500 DEBUG: Connection, ip=[192.168.1.252] 2006-10-30 10:04:59.496393500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252]

 

==> /var/log/qmail/authlib/current <==

2006-10-30 10:05:06.573071500 vmysql: sql error[3]: MySQL server has gone away

 

==> /var/log/qmail/imap4/current <==

2006-10-30 10:05:06.573111500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252]

 

==> /var/log/messages <==

Oct 30 10:05:09 kalimero snmpd[1699]: Connection from UDP: [127.0.0.1]:33091

 

==> /var/log/qmail/authlib/current <==

2006-10-30 10:05:16.363951500 vmysql: sql error[3]: MySQL server has gone away

 

==> /var/log/qmail/imap4/current <==

2006-10-30 10:05:16.363987500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252]

 

==> /var/log/qmail/authlib/current <==

2006-10-30 10:05:22.533286500 vmysql: sql error[3]: MySQL server has gone away

 

==> /var/log/qmail/imap4/current <==

2006-10-30 10:05:22.533326500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[192.168.1.252]

 

 

Is there any way I can solve this issue for good? Even if it implies removing and re-installing any packages I’ll be willing to do whatever it takes…

 

Thanks in advance,

FA

 

 

 

From: Fernando Azevedo [mailto:[EMAIL PROTECTED]
Sent: segunda-feira, 30 de Outubro de 2006 0:04
To: [email protected]
Subject: RE: [qmailtoaster] vmysql: sql error[3]: MySQL server has gone away

 

Hi Erik,

 

I upgraded FROM previous versions.

 

I've added the wait timeout to my.cnf and I will now check for this strange IMAP behaviour.

 

Thak you all,

FA

 

De: Erik Espinoza [mailto:[EMAIL PROTECTED]
Enviada: dom 29-10-2006 21:53
Para: [email protected]
Assunto: Re: [qmailtoaster] vmysql: sql error[3]: MySQL server has gone away

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]

Reply via email to