Re: [asterisk-users] Asterisk Database Handling

2008-05-24 Thread Matthew J. Roth
Tilghman and Jay, Thanks for the licensing advice. If anyone is interested in replicate, I'm now ready to distribute it under the GPL. Regards, Matthew Roth InterMedia Marketing Solutions Software Engineer and Systems Developer ___ -- Bandwidth and

Re: [asterisk-users] Asterisk Database Handling

2008-05-22 Thread Jay R. Ashworth
On Thu, May 22, 2008 at 10:05:13AM -0500, Tilghman Lesher wrote: > > I've never released replicate publicly, because I'm not sure how taking > > a program like tail and adapting it to a new purpose is handled by the > > GPL. However, I'm sure someone on this list more knowledgeable than > > myself

Re: [asterisk-users] Asterisk Database Handling

2008-05-22 Thread Jay R. Ashworth
On Wed, May 21, 2008 at 06:02:07PM -0400, Alex Balashov wrote: > Douglas Garstang wrote: > > We are sending CDR's to MySQL via odbc. It seems that Asterisk is > > sometimes dropping CDR's, and they aren't being sent to the database > > (they ARE in the Master.csv file though). We suspect that whe

Re: [asterisk-users] Asterisk Database Handling

2008-05-22 Thread Alex Balashov
Matthew J. Roth wrote: > Alex Balashov wrote: >> A program like netcat? >> > Alex, > > You're not the first person to suggest nc for this purpose. As I > understand it, it's a TCP/UDP swiss army knife so I'm sure it's up to > the task. However, in reading the man page, I don't see any trivi

Re: [asterisk-users] Asterisk Database Handling

2008-05-22 Thread Matthew J. Roth
Alex Balashov wrote: > A program like netcat? > Alex, You're not the first person to suggest nc for this purpose. As I understand it, it's a TCP/UDP swiss army knife so I'm sure it's up to the task. However, in reading the man page, I don't see any trivial way to buffer failed writes and r

Re: [asterisk-users] Asterisk Database Handling

2008-05-22 Thread Alex Balashov
A program like netcat? Matthew J. Roth wrote: > Douglas Garstang wrote: >>> Not at all, just offering a workaround. If your master.csv is >>> complete and correct then it makes sense to use that data unless >>> someone can identify your problem and offer a fix. >> Unfortunately, not really feesib

Re: [asterisk-users] Asterisk Database Handling

2008-05-22 Thread Tilghman Lesher
On Thursday 22 May 2008 09:29:24 Matthew J. Roth wrote: > It operates almost identically to "tail -F" except every new write to > the file is written over a socket connection. The remote end of the > connection is responsible for sending back an acknowledgment. If it > doesn't, replicate will spo

Re: [asterisk-users] Asterisk Database Handling

2008-05-22 Thread Matthew J. Roth
Douglas Garstang wrote: > >Not at all, just offering a workaround. If your master.csv is > >complete and correct then it makes sense to use that data unless > >someone can identify your problem and offer a fix. > > Unfortunately, not really feesible. I didn't design the system but we > are using

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Alex Balashov
Pezhman Lali wrote: > using odbc+( postgres or mysql) is more stable, > but at all odbc + postgres is recommended Really? -- Alex Balashov Evariste Systems Web: http://www.evaristesys.com/ Tel: (+1) (678) 954-0670 Direct : (+1) (678) 954-0671 Mobile : (+1) (706) 338-8599

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Pezhman Lali
using odbc+( postgres or mysql) is more stable, but at all odbc + postgres is recommended --- Sherwood McGowan <[EMAIL PROTECTED]> wrote: > Steve Prior wrote: > > Tilghman Lesher wrote: > > > >> Correct; it's actually a workaround for a bug in > the MySQL drivers. It was > >> discovered lo

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Sherwood McGowan
Steve Prior wrote: > Tilghman Lesher wrote: > >> Correct; it's actually a workaround for a bug in the MySQL drivers. It was >> discovered long after 1.2 was end-of-lifed. >> >> > > I got bit by MySQL reconnects on some other software I wrote I think when I > jumped from MySQL 4.* to 5.*.

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Tilghman Lesher
On Wednesday 21 May 2008 19:36:11 Steve Prior wrote: > Tilghman Lesher wrote: > > Correct; it's actually a workaround for a bug in the MySQL drivers. It > > was discovered long after 1.2 was end-of-lifed. > > I got bit by MySQL reconnects on some other software I wrote I think when I > jumped from

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Steve Prior
Tilghman Lesher wrote: > Correct; it's actually a workaround for a bug in the MySQL drivers. It was > discovered long after 1.2 was end-of-lifed. > I got bit by MySQL reconnects on some other software I wrote I think when I jumped from MySQL 4.* to 5.*. If memory serves, here is the relevant

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Tilghman Lesher
On Wednesday 21 May 2008 19:03:25 Douglas Garstang wrote: > On Wednesday, May 21, 2008 4:39:24 PM, Tilghman Lesher wrote: > > On Wednesday 21 May 2008 17:02:07 Alex Balashov wrote: > > > Douglas Garstang wrote: > > > > We are sending CDR's to MySQL via odbc. It seems that Asterisk is > > > > somet

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Douglas Garstang
Looks like an Asterisk 1.4 option? - Original Message From: Tilghman Lesher <[EMAIL PROTECTED]> To: Asterisk Users Mailing List - Non-Commercial Discussion Sent: Wednesday, May 21, 2008 4:39:24 PM Subject: Re: [asterisk-users] Asterisk Database Handling On Wednesday 21 May 2008

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Tilghman Lesher
On Wednesday 21 May 2008 17:52:45 Alex Balashov wrote: > Sherwood McGowan wrote: > > I personally can tell you I've never had a problem with either the > > PostgreSQL or MySQL cdr apps themselves losing records. However, I can't > > say personally how well the ODBC method works. I'll just stick to

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Tilghman Lesher
On Wednesday 21 May 2008 17:02:07 Alex Balashov wrote: > Douglas Garstang wrote: > > We are sending CDR's to MySQL via odbc. It seems that Asterisk is > > sometimes dropping CDR's, and they aren't being sent to the database > > (they ARE in the Master.csv file though). We suspect that when the MySQ

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Sherwood McGowan
Douglas Garstang wrote: > >I personally can tell you I've never had a problem with either the > >PostgreSQL or MySQL cdr apps themselves losing records. However, I can't > >say personally how well the ODBC method works. I'll just stick to saying > >that if you're considering using the cdr_mysql add

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Sherwood McGowan
Douglas Garstang wrote: > >I personally can tell you I've never had a problem with either the > >PostgreSQL or MySQL cdr apps themselves losing records. However, I can't > >say personally how well the ODBC method works. I'll just stick to saying > >that if you're considering using the cdr_mysql add

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Alex Balashov
Douglas Garstang wrote: > >Not at all, just offering a workaround. If your master.csv is > >complete and correct then it makes sense to use that data unless > >someone can identify your problem and offer a fix. > > Unfortunately, not really feesible. I didn't design the system but we > are us

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Steve Totaro
On Wed, May 21, 2008 at 7:11 PM, Douglas Garstang <[EMAIL PROTECTED]> wrote: >>Not at all, just offering a workaround. If your master.csv is >>complete and correct then it makes sense to use that data unless >>someone can identify your problem and offer a fix. > > Unfortunately, not really feesibl

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Douglas Garstang
>Not at all, just offering a workaround. If your master.csv is >complete and correct then it makes sense to use that data unless >someone can identify your problem and offer a fix. Unfortunately, not really feesible. I didn't design the system but we are using CDR's not only for billing purpose

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Douglas Garstang
>I personally can tell you I've never had a problem with either the >PostgreSQL or MySQL cdr apps themselves losing records. However, I can't >say personally how well the ODBC method works. I'll just stick to saying >that if you're considering using the cdr_mysql addon, I would highly >suggest

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Alex Balashov
Douglas Garstang wrote: > It's interesting you say that Sherwood. Does your MySQL server have some > sort of keep alive setting? I suspect this is a general problem that > would affect any and all Asterisk database connectivity. I would actually expect it to affect only specific types of databa

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Steve Totaro
On Wed, May 21, 2008 at 7:00 PM, Douglas Garstang <[EMAIL PROTECTED]> wrote: >>I personally can tell you I've never had a problem with either the >>PostgreSQL or MySQL cdr apps themselves losing records. However, I can't >>say personally how well the ODBC method works. I'll just stick to saying >>t

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Douglas Garstang
>I personally can tell you I've never had a problem with either the >PostgreSQL or MySQL cdr apps themselves losing records. However, I can't >say personally how well the ODBC method works. I'll just stick to saying >that if you're considering using the cdr_mysql addon, I would highly >suggest

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Alex Balashov
Sherwood McGowan wrote: > I personally can tell you I've never had a problem with either the > PostgreSQL or MySQL cdr apps themselves losing records. However, I can't > say personally how well the ODBC method works. I'll just stick to saying > that if you're considering using the cdr_mysql add

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Steve Totaro
On Wed, May 21, 2008 at 6:42 PM, Douglas Garstang <[EMAIL PROTECTED]> wrote: >>> >>> So... surely this must be a general problem with ANY Asterisk module that >>> uses the database. Do all modules use the same common database code or do >>> they all use their own? If they all use their own, I guess

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Sherwood McGowan
TED]> > To: Asterisk Users Mailing List - Non-Commercial Discussion > > Sent: Wednesday, May 21, 2008 3:02:07 PM > Subject: Re: [asterisk-users] Asterisk Database Handling > > Douglas Garstang wrote: > > > We are sending CDR's to MySQL via odbc. It seems that A

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Douglas Garstang
>> >> So... surely this must be a general problem with ANY Asterisk module that >> uses the database. Do all modules use the same common database code or do >> they all use their own? If they all use their own, I guess idle database >> connection issues may be fixed in some modules and not others.

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Douglas Garstang
>- Original Message >From: Alex Balashov <[EMAIL PROTECTED]> >To: Asterisk Users Mailing List - Non-Commercial Discussion > >Sent: Wednesday, May 21, 2008 3:30:06 PM >Subject: Re: [asterisk-users] Asterisk Database Handling > >Douglas Garstang wrote

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Steve Totaro
On Wed, May 21, 2008 at 5:37 PM, Douglas Garstang <[EMAIL PROTECTED]> wrote: > General Asterisk question. > > We are sending CDR's to MySQL via odbc. It seems that Asterisk is sometimes > dropping CDR's, and they aren't being sent to the database (they ARE in the > Master.csv file though). We suspe

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Alex Balashov
Douglas Garstang wrote: > I couldn't find one for cdr_mysql.conf. > We're using odbc anyway. MySQL directly might be an option if it works. > Don't think we want to modify the server. Perhaps there's a keepalive option to be set on the UnixODBC DSN, then? -- Alex Balashov Evariste Systems Web

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Douglas Garstang
ial Discussion Sent: Wednesday, May 21, 2008 3:02:07 PM Subject: Re: [asterisk-users] Asterisk Database Handling Douglas Garstang wrote: > We are sending CDR's to MySQL via odbc. It seems that Asterisk is > sometimes dropping CDR's, and they aren't being sent to the database >

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Alex Balashov
Sanjay Rajdev wrote: > I had a similar problem, but in my case we had a custom application that > was throwing an segmentation exception which was causing Asterisk to > Restart. And in that case It use to miss the log in database. > You can determine the same by looking at the UNIQUEID being logg

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Sanjay Rajdev
hursday, May 22, 2008 3:32:07 AM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi Subject: Re: [asterisk-users] Asterisk Database Handling Douglas Garstang wrote: > We are sending CDR's to MySQL via odbc. It seems that Asterisk is > sometimes dropping CDR's, and they aren't

Re: [asterisk-users] Asterisk Database Handling

2008-05-21 Thread Alex Balashov
Douglas Garstang wrote: > We are sending CDR's to MySQL via odbc. It seems that Asterisk is > sometimes dropping CDR's, and they aren't being sent to the database > (they ARE in the Master.csv file though). We suspect that when the MySQL > socket is idle, it gets disconnected, either by the MyS

[asterisk-users] Asterisk Database Handling

2008-05-21 Thread Douglas Garstang
General Asterisk question. We are sending CDR's to MySQL via odbc. It seems that Asterisk is sometimes dropping CDR's, and they aren't being sent to the database (they ARE in the Master.csv file though). We suspect that when the MySQL socket is idle, it gets disconnected, either by the MySQL se