[Asterisk-Users] Mysql and SIP real time configuration...

[Vamsi Pottangi]

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 at 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 at 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
> 
>