<html><div style='background-color:'><DIV class=RTE>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Dear all,</FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>My question is probably very trivial but I’ll try my luck anyway.</FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Currently I have my asterisk PBX up and running but now I would like to perform real time SIP configuration. I have been reading the article “Asterisk RealTime SIP”, and been creating a mysql database called sipusers, also I have created a Table called sip_buddies. My database is running on a machine called dbserver. The asterisk PBX is running on a machine called PBX which is “running” Fedora Core 1. So in my scenario there are two machines the actual PBX and a Database server.</FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Next I started the apache web server service on PBX and via a browser loaded a PHP script which connect to the sipusers db on dbserver, just to make sure that I can connect to the db called sipusers from PBX to dbserver. So far so good I can connect to the database.</FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Next I configured the file Extconfig.conf with the following lines:</FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Sipfriends=>mysql,sipusers,sip_buddies</FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Now if I have understood it correct, the above should instruct the asterisk PBX to look in the Database called sipusers and use the table sip_buddies. But how do I instruct the asterisk PBX on how to actually connect to the database, meaning how to I tell the PBX the user name, password and name of the machine where the sipusers database reside ? I guess there must be another file where this information should be added? Also I would appreciate if you could tell me if I forgot any other configuration tasks etc. to make real time sip config work ?</FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Looking forward to your reply</FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>Jan </FONT></FONT></P></DIV></div><br clear=all><hr>Bestil din ferie i dag på <a href="http://g.msn.com/8HMAENDK/2731??PS=47575" target="_top">MSN Rejser</a> </html>