[asterisk-users] Asterisk Database

ahmed magdy amagdy.ibrahim at gmail.com
Thu Jan 28 04:02:16 CST 2010


Hello

I am trying to attach a database to asterisk , can anyone help me?
in extconfig.conf sipusers => mysql,general,sip
in res_mysql.conf [general]
dbhost = 192.168.50.125
dbname = asterisk
dbuser = root
dbpass = ahmed
dbport = 3306
dbsock = /tmp/mysql.sock

i created a table in MySql
CREATE TABLE `sip` (
   `name` varchar(40) NOT NULL default '',`username` varchar(40) default
'',`typee` varchar(6) NOT NULL default '',`secret` varchar(40) default '',
   `context` varchar(40) NOT NULL default '',
   `host` varchar(31) NOT NULL default 'dynamic',
   PRIMARY KEY  (`name`)
 ) TYPE=MyISAM

I insreted a data which is insert into sip values
('555','555','peer','1234','555','dynamic')
but i couldn't register from X-lite because Asterisk doesn't see this peer
please help me urgent
-- 
Ahmed Magdy Mahmoud
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100128/817e6bef/attachment.htm 


More information about the asterisk-users mailing list