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
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 long after 1.2
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
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 CDR's
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 spool
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 feesible. I
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
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 trivial way
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 when the
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 can
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
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 MySQL
: Thursday, 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 being sent
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 logged
@lists.digium.com
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
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
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 suspect
- Original Message
From: Alex Balashov [EMAIL PROTECTED]
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Sent: Wednesday, May 21, 2008 3:30:06 PM
Subject: Re: [asterisk-users] Asterisk Database Handling
Douglas Garstang wrote:
I couldn't
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. If it's
-Commercial Discussion
asterisk-users@lists.digium.com
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
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 idle
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 addon,
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 it
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
that if
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 database
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 it
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 purposes,
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 feesible. I
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
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 addon, I
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 addon, I
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 MySQL
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 saying
Looks like an Asterisk 1.4 option?
- Original Message
From: Tilghman Lesher [EMAIL PROTECTED]
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Sent: Wednesday, May 21, 2008 4:39:24 PM
Subject: Re: [asterisk-users] Asterisk Database Handling
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
sometimes dropping
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
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 MySQL
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.*. If memory
38 matches
Mail list logo