[prev in list] [next in list] [prev in thread] [next in thread]
List: asterisk-dev
Subject: Re: [Asterisk-Dev] Database backed Asterisk
From: Mark Aiken <aiken.mark () gmail ! com>
Date: 2005-09-27 18:26:59
Message-ID: 1a4a318005092711261fd88cf0 () mail ! gmail ! com
[Download RAW message or body]
http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime+Static
There is a perl script on this page that will insert data from your config
files to your database. You must create the table first before using the
script.
Regarding the ones that dont work, here is what I've found:
asterisk.conf extconfig.conf logger.conf modules.conf res_odbc.conf
There also seems to be an issue with the dnsmgr.conf requiring a reload
after starting asterisk.
Note also your modules.conf need to force the odbc config to load first or
the config files will be loaded from text files rather than the DB.
here is my modules.conf file:
[modules]
autoload = yes
preload => res_odbc.so
preload => res_config_odbc.so
Obviously your unixODBC setup must be working with the DSNs properly
configured and username/passwords in the odbc.ini file. Then you need to
define the DSN again in res_odbc.conf.
The extconfig.conf would look like this (asterisk is a DSN defined in
odbc.ini and also in res_odbc.conf) :
[settings]
; static files
sip.conf => odbc,asterisk,sip
extensions.conf => odbc,asterisk,extensions
features.conf => odbc,asterisk,features
voicemail.conf => odbc,asterisk,voicemail
musiconhold.conf => odbc,asterisk,musiconhold
rtp.conf => odbc,asterisk,rtp
cdr_odbc.conf => odbc,asterisk,cdr_odbc
func_odbc.conf => odbc,asterisk,func_odbc
meetme.conf => odbc,asterisk,meetme
zapata.conf => odbc,asterisk,zapata
indications.conf => odbc,asterisk,indications
adsi.conf => odbc,asterisk,adsi
enum.conf => odbc,asterisk,enum
festival.conf => odbc,asterisk,festival
agents.conf => odbc,asterisk,agents
alarmreceiver.conf => odbc,asterisk,alarmreceiver
queues.conf => odbc,asterisk,queues
cdr.conf => odbc,asterisk,cdr
dnsmgr.conf => odbc,asterisk,dnsmgr
codecs.conf => odbc,asterisk,codecs
privacy.conf => odbc,asterisk,privacy
manager.conf => odbc,asterisk,manager
cdr_manager.conf => odbc,asterisk,cdr_manager
sip_notify.conf => odbc,asterisk,sip_notify
On 9/27/05, Serge Sozonoff <serge@sozonoff.com> wrote:
>
> Hi Mark,
>
> > The 'static' realtime will map database tables to conf files so there is
> > no need to generate conf files from database records anymore, unless you
> Great this was the answer I wanted to here.
>
> > just enjoy that sort of thing. There are about 4 .conf files that cannot
> Is there a document which explains which config files do what and which
> config
> files can't be loaded from the database?
>
> Thanks,
> Serge
>
[Attachment #3 (text/html)]
<div><br><a href="http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime+Stati \
c">http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime+Static</a></div> \
<div> </div> <div>There is a perl script on this page that will insert data from \
your config files to your database. You must create the table first before using the \
script. </div> <div> </div>
<div>Regarding the ones that dont work, here is what I've found:</div>
<div> </div>
<div>asterisk.conf extconfig.conf logger.conf modules.conf \
res_odbc.conf</div> <div> </div>
<div>There also seems to be an issue with the dnsmgr.conf requiring a reload after \
starting asterisk.</div> <div> </div>
<div>Note also your modules.conf need to force the odbc config to load first or the \
config files will be loaded from text files rather than the DB.</div> \
<div> </div> <div>here is my modules.conf file:</div>
<div>[modules]<br>autoload = yes</div>
<div>preload => res_odbc.so<br>preload => res_config_odbc.so<br> </div>
<div>Obviously your unixODBC setup must be working with the DSNs properly configured \
and username/passwords in the odbc.ini file. Then you need to define the DSN again in \
res_odbc.conf.</div> <div> </div>
<div>The extconfig.conf would look like this (asterisk is a DSN defined in odbc.ini \
and also in res_odbc.conf) :</div> <div> </div>
<div>
<p>[settings]</p>
<p>; static files<br>sip.conf => odbc,asterisk,sip<br>extensions.conf => \
odbc,asterisk,extensions<br>features.conf => \
odbc,asterisk,features<br>voicemail.conf => \
odbc,asterisk,voicemail<br>musiconhold.conf => odbc,asterisk,musiconhold \
<br>rtp.conf => odbc,asterisk,rtp<br>cdr_odbc.conf => \
odbc,asterisk,cdr_odbc<br>func_odbc.conf => odbc,asterisk,func_odbc<br>meetme.conf \
=> odbc,asterisk,meetme<br>zapata.conf => \
odbc,asterisk,zapata<br>indications.conf => \
odbc,asterisk,indications<br>adsi.conf => odbc,asterisk,adsi<br>enum.conf => \
odbc,asterisk,enum<br>festival.conf => odbc,asterisk,festival<br>agents.conf => \
odbc,asterisk,agents<br>alarmreceiver.conf => odbc,asterisk,alarmreceiver \
<br>queues.conf => odbc,asterisk,queues<br>cdr.conf => \
odbc,asterisk,cdr<br>dnsmgr.conf => odbc,asterisk,dnsmgr<br>codecs.conf => \
odbc,asterisk,codecs<br>privacy.conf => odbc,asterisk,privacy<br>manager.conf \
=> odbc,asterisk,manager<br>cdr_manager.conf => \
odbc,asterisk,cdr_manager<br>sip_notify.conf => odbc,asterisk,sip_notify<br></p> \
<p> </p> <p> </p>
<p> </p></div>
<div> </div>
<p> </p>
<p><br><br> </p>
<div> </div>
<div><br> </div>
<div><span class="gmail_quote">On 9/27/05, <b class="gmail_sendername">Serge \
Sozonoff</b> <<a href="mailto:serge@sozonoff.com">serge@sozonoff.com</a>> \
wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px \
0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi Mark,<br><br>> The 'static' \
realtime will map database tables to conf files so there is<br>> no need to \
generate conf files from database records anymore, unless you <br>Great this was the \
answer I wanted to here.<br><br>> just enjoy that sort of thing. There are about 4 \
.conf files that cannot<br>Is there a document which explains which config files do \
what and which config<br>files can't be loaded from the database? \
<br><br>Thanks,<br>Serge<br></blockquote></div><br>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic