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]
