[Asterisk-Users] Asterisk configuration from database withres_config

Wei Kun wei-kun at mediaring.com
Thu Aug 18 00:22:21 MST 2005


is your Asterisk compiled from cvs head?

Kun

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com]On Behalf Of Frank
Aartman
Sent: Thursday, August 18, 2005 3:10 PM
To: asterisk-users at 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 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
-------------- 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


More information about the asterisk-users mailing list