I don?t have access to MySQL administration! :( I?m using a remote database to store... -----Mensagem original----- De: Steve Davies [mailto:davies147@gmail.com] Enviada em: quinta-feira, 6 de outubro de 2005 09:48 Para: Jozeph Brasil Assunto: Re: [Asterisk-Users] CDR MySQL The usual "fix" is to reconfigure MySQL - It is the database that is causing the timeouts. I do not know how this is done. Perhaps Google for "MySQL connection timeout" and go from there? Regards, Steve On 10/6/05, Jozeph Brasil <jozeph@globalmedia.com.br> wrote:> Hi Steve, > > Thank you for reply! :) Do you know if anyone have been patched to solvethis?> > Quoting Steve Davies <davies147@gmail.com>: > > > I do not know for sure, but in my experience, the most common cause of > > this error is an application which assumes a database connection will > > stay open forever. > > > > Some MySQL installs have a timeout on idle connections. It should be > > possible to set this to a very-long or infinite timeout. > > > > Hope that helps, > > Steve > >
There is a recent fix to cdr_addon_mysql.c that added 5 retries and a timeout variable to the conf file. You might want to try that. Brett On 10/6/2005, "Jozeph Brasil" <jozeph@globalmedia.com.br> wrote:>I don?t have access to MySQL administration! :( >I?m using a remote database to store... > >-----Mensagem original----- >De: Steve Davies [mailto:davies147@gmail.com] >Enviada em: quinta-feira, 6 de outubro de 2005 09:48 >Para: Jozeph Brasil >Assunto: Re: [Asterisk-Users] CDR MySQL > >The usual "fix" is to reconfigure MySQL - It is the database that is >causing the timeouts. I do not know how this is done. Perhaps Google >for "MySQL connection timeout" and go from there? > >Regards, >Steve > >On 10/6/05, Jozeph Brasil <jozeph@globalmedia.com.br> wrote: >> Hi Steve, >> >> Thank you for reply! :) Do you know if anyone have been patched to solve >this? >> >> Quoting Steve Davies <davies147@gmail.com>: >> >> > I do not know for sure, but in my experience, the most common cause of >> > this error is an application which assumes a database connection will >> > stay open forever. >> > >> > Some MySQL installs have a timeout on idle connections. It should be >> > possible to set this to a very-long or infinite timeout. >> > >> > Hope that helps, >> > Steve >> > > > >_______________________________________________ >--Bandwidth and Colocation sponsored by Easynews.com -- > >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-users >To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
where can i found it? thanks ----- Original Message ----- From: <brett@websmyths.com> To: <asterisk-users@lists.digium.com> Sent: Thursday, October 06, 2005 9:26 AM Subject: Re: RES: [Asterisk-Users] CDR MySQL There is a recent fix to cdr_addon_mysql.c that added 5 retries and a timeout variable to the conf file. You might want to try that. Brett On 10/6/2005, "Jozeph Brasil" <jozeph@globalmedia.com.br> wrote:>I don?t have access to MySQL administration! :( >I?m using a remote database to store... > >-----Mensagem original----- >De: Steve Davies [mailto:davies147@gmail.com] >Enviada em: quinta-feira, 6 de outubro de 2005 09:48 >Para: Jozeph Brasil >Assunto: Re: [Asterisk-Users] CDR MySQL > >The usual "fix" is to reconfigure MySQL - It is the database that is >causing the timeouts. I do not know how this is done. Perhaps Google >for "MySQL connection timeout" and go from there? > >Regards, >Steve > >On 10/6/05, Jozeph Brasil <jozeph@globalmedia.com.br> wrote: >> Hi Steve, >> >> Thank you for reply! :) Do you know if anyone have been patched to solve >this? >> >> Quoting Steve Davies <davies147@gmail.com>: >> >> > I do not know for sure, but in my experience, the most common cause of >> > this error is an application which assumes a database connection will >> > stay open forever. >> > >> > Some MySQL installs have a timeout on idle connections. It should be >> > possible to set this to a very-long or infinite timeout. >> > >> > Hope that helps, >> > Steve >> > > > >_______________________________________________ >--Bandwidth and Colocation sponsored by Easynews.com -- > >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-users >To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >_______________________________________________ --Bandwidth and Colocation sponsored by Easynews.com -- Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Yes! I?m using latest version... I see: int retries = 5;. -----Mensagem original----- De: brett@websmyths.com [mailto:brett@websmyths.com] Enviada em: quinta-feira, 6 de outubro de 2005 10:27 Para: asterisk-users@lists.digium.com Assunto: Re: RES: [Asterisk-Users] CDR MySQL There is a recent fix to cdr_addon_mysql.c that added 5 retries and a timeout variable to the conf file. You might want to try that. Brett On 10/6/2005, "Jozeph Brasil" <jozeph@globalmedia.com.br> wrote:>I don?t have access to MySQL administration! :( >I?m using a remote database to store... > >-----Mensagem original----- >De: Steve Davies [mailto:davies147@gmail.com] >Enviada em: quinta-feira, 6 de outubro de 2005 09:48 >Para: Jozeph Brasil >Assunto: Re: [Asterisk-Users] CDR MySQL > >The usual "fix" is to reconfigure MySQL - It is the database that is >causing the timeouts. I do not know how this is done. Perhaps Google >for "MySQL connection timeout" and go from there? > >Regards, >Steve > >On 10/6/05, Jozeph Brasil <jozeph@globalmedia.com.br> wrote: >> Hi Steve, >> >> Thank you for reply! :) Do you know if anyone have been patched to solve >this? >> >> Quoting Steve Davies <davies147@gmail.com>: >> >> > I do not know for sure, but in my experience, the most common cause of >> > this error is an application which assumes a database connection will >> > stay open forever. >> > >> > Some MySQL installs have a timeout on idle connections. It should be >> > possible to set this to a very-long or infinite timeout. >> > >> > Hope that helps, >> > Steve >> > > > >_______________________________________________ >--Bandwidth and Colocation sponsored by Easynews.com -- > >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-users >To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >_______________________________________________ --Bandwidth and Colocation sponsored by Easynews.com -- Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users