[Asterisk-Dev] Making Asterisk run on Mysql backend

[Brian West]

This is a users list question.

/b

On Apr 16, 2005, at 6:32 AM, Bharat M. Sarvan wrote:

> 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/asteriskmake cleanmake 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-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev