| View previous topic :: View next topic |
| Author |
Message |
michiel at vanbaak.info
Guest
|
 Posted: Tue Jun 24, 2008 3:09 am Post subject: [asterisk-users] Loose connection with MySql. |
 |
|
On 09:54, Tue 24 Jun 08, Catalin S. wrote:
| Quote: | Hello,
I configured asterisk to use mysql for CDR. Well when i check from time to
time I realize
that asterisk loose connection with mysql (i use phpmyadmin and i watch the
processes).
Can anybody tell me how can i solve that problem? I want to have all cdr
statistics logged in mysql,
is very important for billing.
Thank you for support.
|
Use cdr_adaptive_odbc backport for 1.4.
That one does a check if the connection is still working, and if not it
will reconnect.
--
Michiel van Baak
michiel at vanbaak.eu
http://michiel.vanbaak.eu
GnuPG key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x71C946BD
"Why is it drug addicts and computer aficionados are both called users?" |
|
| Back to top |
|
 |
bwentdg at pipeline.com
Guest
|
| Posted: Tue Jun 24, 2008 4:43 am Post subject: [asterisk-users] Loose connection with MySql. |
|
|
errr -you mean Asterisk doesn't ALWAYS check this and reconnect with the
database ?!?
WTF
Since the CDRs are the literal Cash and Life Blood of many application
why the heck would it NOT do this as part of its minimal basic operation ???
If it Doesn't do this for CDRs does it NOT do it for RealTime ??
If not, one could it up,screwed,blued and tatoed
Is this "functionality" or lack there of documented anyplace ???
Michiel van Baak wrote:
| Quote: | On 09:54, Tue 24 Jun 08, Catalin S. wrote:
| Quote: | Hello,
I configured asterisk to use mysql for CDR. Well when i check from time to
time I realize
that asterisk loose connection with mysql (i use phpmyadmin and i watch the
processes).
Can anybody tell me how can i solve that problem? I want to have all cdr
statistics logged in mysql,
is very important for billing.
Thank you for support.
|
Use cdr_adaptive_odbc backport for 1.4.
That one does a check if the connection is still working, and if not it
will reconnect.
|
|
|
| Back to top |
|
|
tilghman at mail.jeffa...
Guest
|
| Posted: Tue Jun 24, 2008 7:21 am Post subject: [asterisk-users] Loose connection with MySql. |
|
|
On Tuesday 24 June 2008 01:54:11 Catalin S. wrote:
| Quote: | Hello,
I configured asterisk to use mysql for CDR. Well when i check from time to
time I realize
that asterisk loose connection with mysql (i use phpmyadmin and i watch the
processes).
Can anybody tell me how can i solve that problem? I want to have all cdr
statistics logged in mysql,
is very important for billing.
|
Are you actually missing CDRs, or are you just concerned that you MIGHT be?
The only reason that you might be missing CDRs from the MySQL backend is if
the MySQL server was completely down (i.e. not just disconnected from
Asterisk, but completely down) at the time that the CDR was posted. All
SQL insertions (for this backend) are automatically retried if the initial
query failed.
--
Tilghman |
|
| Back to top |
|
|
tilghman at mail.jeffa...
Guest
|
| Posted: Tue Jun 24, 2008 7:22 am Post subject: [asterisk-users] Loose connection with MySql. |
|
|
On Tuesday 24 June 2008 04:43:19 Al Baker wrote:
| Quote: | errr -you mean Asterisk doesn't ALWAYS check this and reconnect with the
database ?!?
WTF
Since the CDRs are the literal Cash and Life Blood of many application
why the heck would it NOT do this as part of its minimal basic operation
???
If it Doesn't do this for CDRs does it NOT do it for RealTime ??
If not, one could it up,screwed,blued and tatoed
Is this "functionality" or lack there of documented anyplace ???
|
You might want to check your facts before launching into a diatribe. Both the
MySQL backend driver for CDR as well as the MySQL backend driver for Realtime
reconnect if possible during a query.
--
Tilghman |
|
| Back to top |
|
|
|
Search
