Greg - Cirelle Enterprises
2004-Dec-21 09:12 UTC
[Asterisk-Users] What is sip-friends.sql??????
maybe a dumb question but what do we have here??? sip-friends.sql # # Table structure for table `sipfriends` # CREATE TABLE `sipfriends` ( `name` varchar(40) NOT NULL default '', `secret` varchar(40) NOT NULL default '', `context` varchar(40) NOT NULL default '', `username` varchar(40) 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; Realtime SIP # # Table structure for table `sip_buddies` # CREATE TABLE `sip_buddies` ( `uniqueid` int(11) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `accountcode` varchar(30) default NULL, `amaflags` char(1) default NULL, `callgroup` varchar(30) default NULL, `callerid` varchar(50) default NULL, `canreinvite` char(1) default NULL, `context` varchar(30) default NULL, `defaultip` varchar(15) default NULL, `dtmfmode` varchar(7) default NULL, `fromuser` varchar(50) default NULL, `fromdomain` varchar(31) default NULL, `host` varchar(31) NOT NULL default '', `incominglimit` char(2) default NULL, `outgoinglimit` char(2) default NULL, `insecure` char(1) default NULL, `language` char(2) default NULL, `mailbox` varchar(50) default NULL, `md5secret` varchar(32) default NULL, `nat` varchar(5) default NULL, `permit` varchar(95) default NULL, `deny` varchar(95) default NULL, `pickupgroup` varchar(10) default NULL, `port` varchar(5) NOT NULL default '', `qualify` varchar(4) default NULL, `restrictcid` char(1) default NULL, `rtptimeout` char(3) default NULL, `rtpholdtimeout` char(3) default NULL, `secret` varchar(30) default NULL, `type` varchar(6) NOT NULL default '', `username` varchar(30) NOT NULL default '', `allow` varchar(100) default NULL, `disallow` varchar(100) default NULL, `regseconds` int(11) NOT NULL default '0', `ipaddr` varchar(15) NOT NULL default '', PRIMARY KEY (`uniqueid`), UNIQUE KEY `name` (`name`), KEY `name_2` (`name`) ) TYPE=MyISAM; Regards Greg Cirino
Its a way of storing ur sip stuff in a database rather than using the flat files. Sip friends - extensions.conf stuff. Sip_buddies - sip.conf stuff
Greg - Cirelle Enterprises
2004-Dec-22 09:19 UTC
[Asterisk-Users] What is sip-friends.sql??????
At 09:44 AM 12/22/04, you wrote:>Its a way of storing ur sip stuff in a database rather than using the >flat files. Sip friends - extensions.conf stuff. Sip_buddies - >sip.conf stuff >_______________________________________________this is the database to flat file storage I take it. Regards Greg Cirino
You are not quite correct. sip-friends is the STABLE 1.0 method of storing sip.conf info on peers/users. sip_buddies is the CVS (RealTime) method of storing sip.conf info on peers/users. -Matthew ----- Original Message ----- From: "Giovanni Powell" <giovanni.powell@gmail.com> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> Sent: Wednesday, December 22, 2004 8:44 AM Subject: Re: [Asterisk-Users] What is sip-friends.sql??????> Its a way of storing ur sip stuff in a database rather than using the > flat files. Sip friends - extensions.conf stuff. Sip_buddies - > sip.conf stuff > _______________________________________________ > 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