Help me how to connect mysql with asterisk


#1

i installed asterisk and can use SIP phone to communicate from one to another,now i want to find a way to add some information from database,but i try more and not connect mysql with asterisk, can you give me some advice how to connect mysql with asterisk? thank you!


#2

reinstall using asterisk@home. comes preinstalled with mysql.


#3

thanks dswartz very much, a little long before i had installed and used asterisk@home to make a sip-phone group,but now i find it’s very different that between asterisk and asterisk@home, asterisk is more difficult to configue and most parts had been configued in asterisk@home. i try again and again ,but find little .how to connect mysql with asterisk,does somebody give me some advices? thank you very much!


#4

Let me know what exactly you would like to do?
If you want to keep your users (peer and friends) in databese you must setup your MySQL, and:
extconfig.conf
sipusers => mysql,asterisk,sip_buddies
sippeers => mysql,asterisk,sip_buddies

res_mysql.conf
[general]
dbhost = XXX.XXX.XXX.XXX
dbname = [name of data base]
dbuser = [name of user]
dbpass = [password]
dbport = 3306
dbsock=/var/run/mysqld/mysqld.sock

You can find more at:
voip-info.org/wiki/view/Aste … alTime+Sip