<div><br><a href="http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime+Static">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>