[vchkpw] MySQL server has gone away
Hi all, I'm facing this error: dovecot: auth(default): vmysql: sql error[3]: MySQL server has gone away I've been googling about this but it seems to be a resolved issuem(back to 2005), so it should just reconnect but it does not so. If I just restart dovecot (my IMAP server) it works OK. I'm using vpopmail 5.4.25 Any ideas why it's not reconnecting? Thanks you! -- Jordi !DSPAM:48dba63f32311193016743!
Re: [vchkpw] MySQL server has gone away
Jordi Prats wrote: Hi all, I'm facing this error: dovecot: auth(default): vmysql: sql error[3]: MySQL server has gone away I've been googling about this but it seems to be a resolved issuem(back to 2005), so it should just reconnect but it does not so. If I just restart dovecot (my IMAP server) it works OK. I'm using vpopmail 5.4.25 Any ideas why it's not reconnecting? Thanks you! Mysql 5 ? If so it may be that MySQL is closing the connection after a period of inactivity. If that's the case you need to increase the idle timeout or eliminate it completely. We set ours at 4 days to allow for long weekends etc. Regards, Rick !DSPAM:48dbae0d32311477465604!
Re: [vchkpw] MySQL server has gone away
Jordi Prats wrote: Hi all, I'm facing this error: dovecot: auth(default): vmysql: sql error[3]: MySQL server has gone away I've been googling about this but it seems to be a resolved issuem(back to 2005), so it should just reconnect but it does not so. If I just restart dovecot (my IMAP server) it works OK. I'm using vpopmail 5.4.25 Any ideas why it's not reconnecting? Thanks you! Maybe dovecot was compiled with pre 2005 libraries? Did you check when was the version you are using updated last time? Does restarting dovecot fix the problem? Thanks, Evren !DSPAM:48dbb22d32315313413817!
Re: [vchkpw] MySQL server has gone away
I'm using dovecot 1.1.3 with MySQL 5.0.67. I think that disabling idle timeout it's not a good idea since MySQL could die for too many useless idle conections too. There is not any better solution? Any vpopmail parameter that I'm missing? Thank you ! On Thu, Sep 25, 2008 at 5:57 PM, Evren Yurtesen [EMAIL PROTECTED] wrote: Jordi Prats wrote: Hi all, I'm facing this error: dovecot: auth(default): vmysql: sql error[3]: MySQL server has gone away I've been googling about this but it seems to be a resolved issuem(back to 2005), so it should just reconnect but it does not so. If I just restart dovecot (my IMAP server) it works OK. I'm using vpopmail 5.4.25 Any ideas why it's not reconnecting? Thanks you! Maybe dovecot was compiled with pre 2005 libraries? Did you check when was the version you are using updated last time? Does restarting dovecot fix the problem? Thanks, Evren -- Jordi !DSPAM:48dbb5ce32317541862933!
Re: [vchkpw] MySQL server has gone away
Restarting dovecote solve the problem, yes. Also if I restart MySQL I must restart dovecot too. regards, On Thu, Sep 25, 2008 at 6:01 PM, Jordi Prats [EMAIL PROTECTED] wrote: I'm using dovecot 1.1.3 with MySQL 5.0.67. I think that disabling idle timeout it's not a good idea since MySQL could die for too many useless idle conections too. There is not any better solution? Any vpopmail parameter that I'm missing? Thank you ! On Thu, Sep 25, 2008 at 5:57 PM, Evren Yurtesen [EMAIL PROTECTED] wrote: Jordi Prats wrote: Hi all, I'm facing this error: dovecot: auth(default): vmysql: sql error[3]: MySQL server has gone away I've been googling about this but it seems to be a resolved issuem(back to 2005), so it should just reconnect but it does not so. If I just restart dovecot (my IMAP server) it works OK. I'm using vpopmail 5.4.25 Any ideas why it's not reconnecting? Thanks you! Maybe dovecot was compiled with pre 2005 libraries? Did you check when was the version you are using updated last time? Does restarting dovecot fix the problem? Thanks, Evren -- Jordi -- Jordi !DSPAM:48dbb83332311147716080!
Re: [vchkpw] MySQL server has gone away
Jordi Prats wrote: I'm using dovecot 1.1.3 with MySQL 5.0.67. I think that disabling idle timeout it's not a good idea since MySQL could die for too many useless idle conections too. There is not any better solution? Any vpopmail parameter that I'm missing? Thank you ! Have a network monitor login to IMAP every half hour to keep the connection open ? There really is no downside to increasing the timeout unless you also have user generated code that can do pconnects instead of connects. Rick !DSPAM:48dbbb5b32311497813221!
Re: [vchkpw] MySQL server has gone away
On Thu, Sep 25, 2008 at 6:24 PM, Rick Macdougall [EMAIL PROTECTED] wrote: Have a network monitor login to IMAP every half hour to keep the connection open ? That's a good workaround because I can check it is dovecot alive while I'm keeping the connection open. I like it :) Anyway this is a problem that should be fixed, isn't it? If I have enough spare time I'm going to try to fix it, but I can't promise anything ;) There really is no downside to increasing the timeout unless you also have user generated code that can do pconnects instead of connects. Rick -- Jordi !DSPAM:48dbbe2f32311438796153!