[Asterisk-Users] Asterisk configuration from database with res_config

[Matthew Boehm]

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 at 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
>