Re: [Asterisk-Users] asterisk down because of cdr
On Tue, 17 Jan 2006, Jean-Michel Hiver wrote: Dov Bigio a ?crit : Ok.. but I don't use Real Time at all. I just use cdr_mysql. It would be smarter if it simply ignored MySQL outages or at least just logged, but without stopping. What would be even nicer would be for * to buffer it for a while before it starts dropping cdrs... Might want to use cdr_odbc instead. The issue that you are discussing was brought up by BKW last year, and I was under the impression that it had been patched. I.E. that when MySQL died, Asterisk would deadlock. I'm pretty sure that cdr_odbc (which is cake configure) handles this situation properly. -- Vice President of N2Net, a New Age Consulting Service, Inc. Company http://www.n2net.net Where everything clicks into place! KP-216-121-ST ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] asterisk down because of cdr
On Tue, 17 Jan 2006, Alexander Lopez wrote: Buffer! For how long? How big of a buffer? If I can buffer 10-20 calls that might work if I have a light use PBX but 100-2000 buffered calls may not hold a busy PBX. OK so make it configurable, With any luck you won't know how much to put so you will allocate more than you need, using more memory for a single senario. My solution, make sure your DB is stable. I would rather put my effort in building a better solution than counting on insurance to bail me out. Hehehe.. it should be a dynamic buffer that should grow / shrink as neccessary and consume as much memory as it needs until the database backend comes online. It should do periodic checks of the server to see if it is available and then spool the buffered calls out to it, but only spool stuff in the event the connection is not available. -- Vice President of N2Net, a New Age Consulting Service, Inc. Company http://www.n2net.net Where everything clicks into place! KP-216-121-ST ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] asterisk down because of cdr
On Tue, 17 Jan 2006 [EMAIL PROTECTED] wrote: Buffers don't have to be in memory. My suggestion on the solution would be to buffer the CDR info into a backup file based database (configurable filename/path) on the local filesystem (or NFS mounted system for redundancy) and then when the SQL database connection is restored then it spends a second dumping the buffered CDR info from the file into the database and erases the file (or empties it). Why not just use the astdb instead of a file? Dundi does it.. -- Vice President of N2Net, a New Age Consulting Service, Inc. Company http://www.n2net.net Where everything clicks into place! KP-216-121-ST ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] asterisk down because of cdr
When using asterisk real time, every time somehting occurs in asterisk it goes to the DB. If the DB isnt up natrually it dosent know what to do. So yes this behavior is perfectly normal. Dovid (Sorry about the spelling mistakes) --- Dov Bigio [EMAIL PROTECTED] wrote: Hello, After 2 weeks and 4 days without a problem, Asterisk went down. What happened is that I am using Asterisk 1.2.1 on a machine and have a MySQL for CDR on another machine. The machine with MySQL went down and the Asterisk box was unable to connect to MySQL. This made Asterisk to go down and it was unable to restart until MySQL was back. I know that Asterisk displays a lot of warnings, but still works, when the cdr table is corrupt. But isn't it a strange behaviour to go down when MySQL is down? Thank you Dov ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] asterisk down because of cdr
Ok.. but I don't use Real Time at all. I just use cdr_mysql. It would be smarter if it simply ignored MySQL outages or at least just logged, but without stopping. Regards dov - Original Message - From: Dovid Bender [EMAIL PROTECTED] To: Dov Bigio [EMAIL PROTECTED]; Asterisk Users Mailing List - Non-CommercialDiscussion asterisk-users@lists.digium.com Cc: asterisk-users@lists.digium.com Sent: Tuesday, January 17, 2006 2:43 PM Subject: Re: [Asterisk-Users] asterisk down because of cdr When using asterisk real time, every time somehting occurs in asterisk it goes to the DB. If the DB isnt up natrually it dosent know what to do. So yes this behavior is perfectly normal. Dovid (Sorry about the spelling mistakes) --- Dov Bigio [EMAIL PROTECTED] wrote: Hello, After 2 weeks and 4 days without a problem, Asterisk went down. What happened is that I am using Asterisk 1.2.1 on a machine and have a MySQL for CDR on another machine. The machine with MySQL went down and the Asterisk box was unable to connect to MySQL. This made Asterisk to go down and it was unable to restart until MySQL was back. I know that Asterisk displays a lot of warnings, but still works, when the cdr table is corrupt. But isn't it a strange behaviour to go down when MySQL is down? Thank you Dov ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] asterisk down because of cdr
Dov Bigio a écrit : Ok.. but I don't use Real Time at all. I just use cdr_mysql. It would be smarter if it simply ignored MySQL outages or at least just logged, but without stopping. What would be even nicer would be for * to buffer it for a while before it starts dropping cdrs... ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] asterisk down because of cdr
Buffer! For how long? How big of a buffer? If I can buffer 10-20 calls that might work if I have a light use PBX but 100-2000 buffered calls may not hold a busy PBX. OK so make it configurable, With any luck you won't know how much to put so you will allocate more than you need, using more memory for a single senario. My solution, make sure your DB is stable. I would rather put my effort in building a better solution than counting on insurance to bail me out. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jean-Michel Hiver Sent: Tuesday, January 17, 2006 12:38 PM To: Dov Bigio; Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] asterisk down because of cdr Dov Bigio a écrit : Ok.. but I don't use Real Time at all. I just use cdr_mysql. It would be smarter if it simply ignored MySQL outages or at least just logged, but without stopping. What would be even nicer would be for * to buffer it for a while before it starts dropping cdrs... ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] asterisk down because of cdr
Buffers don't have to be in memory. My suggestion on the solution would be to buffer the CDR info into a backup file based database (configurable filename/path) on the local filesystem (or NFS mounted system for redundancy) and then when the SQL database connection is restored then it spends a second dumping the buffered CDR info from the file into the database and erases the file (or empties it). This is would be a fairly solid buffering solution. Of course you better get that SQL database back online ASAP or else there is the issue of running on of diskspace on heavily used systems. Just an idea, doesn't seem that hard but I know I don't have time to implement it now. Ryan Buffer! For how long? How big of a buffer? If I can buffer 10-20 calls that might work if I have a light use PBX but 100-2000 buffered calls may not hold a busy PBX. OK so make it configurable, With any luck you won't know how much to put so you will allocate more than you need, using more memory for a single senario. My solution, make sure your DB is stable. I would rather put my effort in building a better solution than counting on insurance to bail me out. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jean-Michel Hiver Sent: Tuesday, January 17, 2006 12:38 PM To: Dov Bigio; Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] asterisk down because of cdr Dov Bigio a écrit : Ok.. but I don't use Real Time at all. I just use cdr_mysql. It would be smarter if it simply ignored MySQL outages or at least just logged, but without stopping. What would be even nicer would be for * to buffer it for a while before it starts dropping cdrs... ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[Asterisk-Users] asterisk down because of cdr
Hello, After 2 weeks and 4 days without a problem, Asterisk went down. What happened is that I am using Asterisk 1.2.1 on a machine and have a MySQL for CDR on another machine. The machine with MySQL went down and the Asterisk box was unable to connect to MySQL. This made Asterisk to go down and it was unable to restart until MySQL was back. I know that Asterisk displays a lot of warnings, but still works, when the cdr table is corrupt. But isn't it a strange behaviour to go down when MySQL is down? Thank you Dov ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users