asterisk users - Jan 2010 - Asterisk Database Configuration

Hello

I need to add sip extensions from my UI so without going through sip.conf so
i created table
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
then i put sip.conf
[general]
hostname=localhost
dbname=asterisk
table= sipfriends
password=ahmed
user=root
then i insert in sql this statment  insert into sipfriends values
('555','555','1234','555','192.168.50.149',5060,2);
i tried from Xlite to register with 555 but i couldn't
any help please

-- 
Ahmed Magdy Mahmoud
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100127/e9603986/attachment.htm

Can you link the howto or other documentation you are following to set this up?
What version of asterisk?
Did you edit extconfig.conf?

Heres a howto for 1.4.x
http://hostseries.com/asterisk-realtime-installation-guide/

On Wed, Jan 27, 2010 at 8:39 AM, ahmed magdy <amagdy.ibrahim at gmail.com>
wrote:
> Hello
>
> I need to add sip extensions from my UI so without going through sip.conf
so
> i created table
> 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
> then i put sip.conf
> [general]
> hostname=localhost
> dbname=asterisk
> table= sipfriends
> password=ahmed
> user=root
> then i insert in sql this statment? insert into sipfriends values
>
('555','555','1234','555','192.168.50.149',5060,2);
> i tried from Xlite to register with 555 but i couldn't
> any help please
>
> --
> Ahmed Magdy Mahmoud
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> ? http://lists.digium.com/mailman/listinfo/asterisk-users
>