Frank Aartman
2005-Aug-18 00:09 UTC
[Asterisk-Users] Asterisk configuration from database with res_config
I want to let Asterisk read its configuration from a mysql database. I configured everything according to the wiki page: http://www.voip-info.org/tiki-index.php?page=Asterisk+res_config. However it doesn't work. I am using 1.0.8 asterisk version and here are my config files: Extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf => odbc,mysql1,ast_config ;extensions.conf => odbc,mysql1,ast_config sip.conf => odbc,mysql1,ast_config res_odbc.conf: ;;; odbc setup file [mysql1] dsn => MySQL-asterisk username => blaat password => blaat pre-connect => yes [mysql2] dsn => MySQL-asterisk username => myuser password => mypass pre-connect => yes odbc to mysql is working fine, I tested it. here is my odbc.ini from /etc/ [MySQL-asterisk] Description = MySQL Asterisk database Trace = Off TraceFile = stderr Driver = MySQL SERVER = localhost USER = blaat PASSWORD = blaat PORT = 3306 DATABASE = asterisk I used the load_res_config.pl to put the sip.conf into the database in ast_config. Via phpMyadmin I can see the data in there correctly. When booting or reloading Asterisk I don't see anything indicating it is connecting to odbc. I tried removing the sip.conf from /etc/asterisk, leaving an empty sip.conf, and only leaving the general section of sip.conf there. Nothing works. Cheers, Frank
Wei Kun
2005-Aug-18 00:22 UTC
[Asterisk-Users] Asterisk configuration from database withres_config
is your Asterisk compiled from cvs head? Kun -----Original Message----- From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com]On Behalf Of Frank Aartman Sent: Thursday, August 18, 2005 3:10 PM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] Asterisk configuration from database withres_config I want to let Asterisk read its configuration from a mysql database. I configured everything according to the wiki page: http://www.voip-info.org/tiki-index.php?page=Asterisk+res_config. However it doesn't work. I am using 1.0.8 asterisk version and here are my config files: Extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf => odbc,mysql1,ast_config ;extensions.conf => odbc,mysql1,ast_config sip.conf => odbc,mysql1,ast_config res_odbc.conf: ;;; odbc setup file [mysql1] dsn => MySQL-asterisk username => blaat password => blaat pre-connect => yes [mysql2] dsn => MySQL-asterisk username => myuser password => mypass pre-connect => yes odbc to mysql is working fine, I tested it. here is my odbc.ini from /etc/ [MySQL-asterisk] Description = MySQL Asterisk database Trace = Off TraceFile = stderr Driver = MySQL SERVER = localhost USER = blaat PASSWORD = blaat PORT = 3306 DATABASE = asterisk I used the load_res_config.pl to put the sip.conf into the database in ast_config. Via phpMyadmin I can see the data in there correctly. When booting or reloading Asterisk I don't see anything indicating it is connecting to odbc. I tried removing the sip.conf from /etc/asterisk, leaving an empty sip.conf, and only leaving the general section of sip.conf there. Nothing works. Cheers, Frank _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2624 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20050818/e4dc7c9e/winmail.bin
Matthew Boehm
2005-Aug-18 07:45 UTC
[Asterisk-Users] Asterisk configuration from database with res_config
That wiki page is old, ugly and out of date. There are many like it and if I only knew how to delete wiki pages, I would clean it up some. The easiest way, Frank, to do what you want is to download CVS-HEAD and use ARA to store your config files. Also download addons from HEAD and you can use the native mysql realtime driver. http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime -Matthew Frank Aartman wrote:> I want to let Asterisk read its configuration from a mysql database. I > configured everything according to the wiki page: > http://www.voip-info.org/tiki-index.php?page=Asterisk+res_config. > However it doesn't work. I am using 1.0.8 asterisk version and here are > my config files: > > Extconfig.conf: > > [settings] > ;uncomment to load queues.conf via the db engine. > ;queues.conf => odbc,mysql1,ast_config > ;extensions.conf => odbc,mysql1,ast_config > sip.conf => odbc,mysql1,ast_config > > res_odbc.conf: > > ;;; odbc setup file > > [mysql1] > dsn => MySQL-asterisk > username => blaat > password => blaat > pre-connect => yes > [mysql2] > dsn => MySQL-asterisk > username => myuser > password => mypass > pre-connect => yes > > odbc to mysql is working fine, I tested it. here is my odbc.ini from > /etc/ > > [MySQL-asterisk] > Description = MySQL Asterisk database > Trace = Off > TraceFile = stderr > Driver = MySQL > SERVER = localhost > USER = blaat > PASSWORD = blaat > PORT = 3306 > DATABASE = asterisk > > I used the load_res_config.pl to put the sip.conf into the database in > ast_config. Via phpMyadmin I can see the data in there correctly. When > booting or reloading Asterisk I don't see anything indicating it is > connecting to odbc. I tried removing the sip.conf from /etc/asterisk, > leaving an empty sip.conf, and only leaving the general section of > sip.conf there. Nothing works. > > Cheers, > > Frank > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >