<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
In a nutshell:<br>
used to have SQL for SIP phones and Voicemail.<br>
Upgraded to latest asterisk.<br>
<br>
I am unable to puzzle out the docs for what I need to put in extconfig,<br>
and what I need to add to my system for this to work like it used to
prior<br>
to the update.<br>
<br>
For example, I have database friends, table sipfriends, which contains<br>
phone data (worked fine with MYSQL_PEERS, MYSQL_USERS, etc.)<br>
I also have a database asterisk_vm, table users, which contains
voicemail<br>
data. Below is my extconfig.<br>
<br>
I am confused. I need help. I can't figure out from the docs what the
point<br>
of /etc/asterisk/configs/res_odbc.conf is if the subdir isn't a typo<br>
/etc/asterisk/res_odbc.conf (sample below sans passwords)<br>
/etc/asterisk/extconfig.conf (no, the README.extconfig is good for
table details but not how to map to the table)<br>
Note that the contents of those files are Pure Guesses based on my lack
of<br>
understanding of what's going on.<br>
<br>
I did try and read /usr/src/asterisk/config.c, but the lack of comments
dissuaded<br>
me... and the lack of ast_verbose() dissuaded me from trial and error.<br>
<br>
Any advice appreciated. <a class="moz-txt-link-abbreviated"
href="mailto:gavron@wetwork.net">gavron@wetwork.net</a><br>
<br>
Ehud<br>
<br>
<small><font face="Courier New, Courier, monospace">[settings]<br>
;<br>
; Static configuration files:<br>
;<br>
; file.conf => driver,database[,table]<br>
;<br>
; maps a particular configuration file to the given<br>
; database driver, database and table (or uses the<br>
; name of the file as the table if not specified)<br>
;<br>
;uncomment to load queues.conf via the odbc engine.<br>
;<br>
;queues.conf => odbc,asterisk,ast_config<br>
<br>
;<br>
; Realtime configuration engine<br>
;<br>
; maps a particular family of realtime<br>
; configuration to a given database driver,<br>
; database and table (or uses the name of<br>
; the family if the table is not specified<br>
;<br>
;iaxfriends => odbc,asterisk<br>
sipfriends => odbc,friends,sipfriends<br>
voicemail => odbc,asterisk_vm,users</font></small><br>
<br>
and res_odbc.conf:<br>
<small><font face="Courier New, Courier, monospace">[friends]<br>
dsn=friends<br>
username=asterisk<br>
password=nyuck<br>
<br>
[asterisk_vm]<br>
dsn=asterisk_vm<br>
username=asterisk<br>
password=nyuck</font></small><br>
</body>
</html>