Automatically reconnect to ODBC sources?

Posted by stefan.at.wpf on Server Fault See other posts from Server Fault or by stefan.at.wpf
Published on 2012-08-31T22:01:15Z Indexed on 2012/09/08 21:40 UTC
Read the original article Hit count: 378

Filed under:

mysql

|

asterisk

|

odbc

|

unixodbc

I am using Asterisk 1.8.10.1 and a MySQL database connected via ODBC to store CDRs. When my MySQL database isn't available when Asterisk starts or has an outage while Asterisk is running, I would expect Asterisk to retry to connect to the database, but this doesn't happen! Anyone knows where I can enable some kidn of automatic reconnect to databases in Asterisk?

My res_odbc.conf looks like this:

[asterisk]
enabled => yes
dsn => asterisk-connector
username => user
password => pass
pre-connect => yes
pooling => no
limit => 1
idlecheck => 1
negative_connection_cache => 1

© Server Fault or respective owner

Related posts about mysql

How to remove MySQL completely with config and library files on ubuntu 12.04 gnome 3.0

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried everything till now: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get autoremove and even more commands... But whenever I am trying to locate mysql. I get a no. of files related to mysql command: shell>>… >>> More
mysql: Cannot load from mysql.proc. The table is probably corrupted

as seen on Server Fault - Search for 'Server Fault'
Mysql was started: /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 but when I'm trying to do something: ERROR 1548 (HY000) at line 1: Cannot… >>> More
Why is there a /etc/init.d/mysql file on this Slackware machine? How could it have gotten there?

as seen on Server Fault - Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin. As far as I can tell, the only copy of MySQL… >>> More
mysql: Bind on unix socket: Permission denied

as seen on Server Fault - Search for 'Server Fault'
Can't start mysql with: sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 120222 13:40:48 mysqld_safe Starting mysqld daemon with databases… >>> More
MySQL – Learning MySQL Online in 6 Hours – MySQL Fundamentals in 320 Minutes

as seen on SQL Authority - Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which… >>> More

Related posts about asterisk

How to send REGISTER request periodically from my SIP client to Asterisk server using Asterisk Manag

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am using Asterisk 1.4 server and I have created a desktop client using the Asterisk.NET Library. I am able to log into the AMI (as a manager) using Asterisk.Net, but I cannot find a way to send the REGISTER command using the AMI, to share my client's location information with the server. I… >>> More
asterisk : Unable to connect to remote asterisk (does /var/run/asterisk.ctl exist?)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I am learning asterisk. After I have installed asterisk I have tried to connect with it using asterisk -rvvvvc. But it gave me an following error message. Unable to connect to remote asterisk (does /var/run/asterisk.ctl exist?) How can I solve this issue.Please help me. Thanks in advance. >>> More
Ubuntu: package installed, but files missing?

as seen on Server Fault - Search for 'Server Fault'
I have been playing around with the /etc/asterisk directory, installing the related pacakge (asterisk-config), removing it, removing the directory manually (just playing around to get the configuration synced to my configuration repo). Now I just want to reinstall the official package, so I do: root@tethys:/etc#… >>> More
Can we manage incoming call number landing on asterisk?

as seen on Server Fault - Search for 'Server Fault'
I am using Asterisk 1.4.2 in two different machine. I have configured some extensions in asterisk. When any caller, dial my extension number with local number then if I see asterisk console (asterisk -r) then incoming number is starting with 0, but if caller dial same extension number using STD number… >>> More
Asterisk SIP digest authentication username mismatch

as seen on Super User - Search for 'Super User'
I have an asterisk system that I'm attempting to get to work as a backup for our 3com system. We already use it for a conference bridge. Our phones are the 3com 3C10402B, so I don't have the issue of older 3com phones that come without a SIP image. The 3com phones are communicating SIP with the… >>> More