[Asterisk-Users] Making Asterisk run on Mysql backend

Bharat M. Sarvan Thu, 12 May 2005 04:39:22 -0700

Hello there,

I have configured my asterisk to run on Mysql backend. But the Asterisk was unable to pick the peer details from the database. This is how I configured the Asterisk to run with mysql on the backend.

Edit /usr/src/asterisk/channels/Makefile, change it to enable the MYSQL_FRIENDS

USE_MYSQL_FRIENDS=1

USE_SIP_MYSQL_FRIENDS=1

cd /usr/src/asterisk

make clean

make

make install

Created the database with the following structure:

CREATE TABLE `sipfriends` (
   `name` varchar(40) NOT NULL default '',
   `username` varchar(40) default '',
   `secret` varchar(40) NOT NULL default '',
   `context` varchar(40) NOT NULL default '',
   `ipaddr` varchar(20) NOT NULL default '',
   `port` int(6) NOT NULL default '0',
   `regseconds` int(11) NOT NULL default '0',
   PRIMARY KEY  (`name`)
) TYPE=MyISAM;

And there was no dial tone on the phone. Can you please tell me as to what’s wrong in the configuration and how as to how does asterisk fetch the details of the peers from the database.

Thanks in advance…

Regards,

Bharat M. Sarvan

_______________________________________________
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

[Asterisk-Users] Making Asterisk run on Mysql backend

Reply via email to