Asterisk Realtime

asterist
Joined: Thu 24 of Oct, 2013

Asterisk Realtime

Posted:Thu 24 of Oct, 2013 (03:26 UTC)
Dear all,

I am a new learner about asterisk, I very sad because of trying many time but i still cannot have good luck.
I want my Asterisk sip peers work with MySQL, please help me what i am doing wrong with this

mysql> SELECT asteriskrealtime
-> CREATE TABLE `bit_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;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `bit_sipfriends` (
`name` varchar(40) NOT NULL default '',
`username` v' at line 2

thanks with best regard,