Jan Aabyevester
2005-Feb-13 23:13 UTC
[Asterisk-Users] Mysql and SIP real time configuration...
<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>
Vamsi Pottangi
2005-Feb-14 00:30 UTC
[Asterisk-Users] Mysql and SIP real time configuration...
You need to mention the DB deatils in sip.conf file .. please check
the WiKi pages
[general]
dbname dbhost dbuser dbpass
Also you need to mention the DB details in res_mysql.conf
~Vamsi
On Mon, 14 Feb 2005 06:13:10 +0000, Jan Aabyevester
<aabyevester@hotmail.com> wrote:>
>
> Dear all,
>
>
>
> My question is probably very trivial but I'll try my luck anyway.
>
>
>
> 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.
>
>
>
> 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.
>
>
>
> Next I configured the file Extconfig.conf with the following lines:
>
> Sipfriends=>mysql,sipusers,sip_buddies
>
>
>
> 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 ?
>
>
>
> Looking forward to your reply
>
> Jan
> ________________________________
> Bestil din ferie i dag p? MSN Rejser
> _______________________________________________
> 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
>
>