[Asterisk-Users] Asterisk configuration from database with res_config

2005-08-18 Thread Frank Aartman

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


Re: [Asterisk-Users] Asterisk configuration from database with res_config

2005-08-18 Thread 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@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




___
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