thanks!!!<br>
<br>
ask.<br>
<br>
the fullcontact varchar(128) is added to <br>
<br>
<br>
#
<br>
# Table structure for table `sip_buddies`
<br>
#
<br>
<br>
CREATE TABLE `sip_buddies` (
<br>
<span style="font-family: monospace;"> `id` int(11) NOT NULL auto_increment,
</span><br>
<span style="font-family: monospace;"> `name` varchar(80) NOT NULL default '',
</span><br>
<span style="font-family: monospace;"> `accountcode` varchar(20) default NULL,
</span><br>
<span style="font-family: monospace;"> `amaflags` varchar(7) default NULL,
</span><br>
<span style="font-family: monospace;"> `callgroup` varchar(10) default NULL,
</span><br>
<span style="font-family: monospace;"> `callerid` varchar(80) default NULL,
</span><br>
<span style="font-family: monospace;"> `canreinvite` char(3) default 'yes',
</span><br>
<span style="font-family: monospace;"> `context` varchar(80) default NULL,
</span><br>
<span style="font-family: monospace;"> `defaultip` varchar(15) default NULL,
</span><br>
<span style="font-family: monospace;"> `dtmfmode` varchar(7) default NULL,
</span><br>
<span style="font-family: monospace;"> `fromuser` varchar(80) default NULL,
</span><br>
<span style="font-family: monospace;"> `fromdomain` varchar(80) default NULL,
</span><br>
<span style="font-family: monospace;"> `host` varchar(31) NOT NULL default '',
</span><br>
<span style="font-family: monospace;"> `insecure` varchar(4) default NULL,
</span><br>
<span style="font-family: monospace;"> `language` char(2) default NULL,
</span><br>
<span style="font-family: monospace;"> `mailbox` varchar(50) default NULL,
</span><br>
<span style="font-family: monospace;"> `md5secret` varchar(80) default NULL,
</span><br>
<span style="font-family: monospace;"> `nat` varchar(5) NOT NULL default 'no',
</span><br>
<span style="font-family: monospace;"> `deny` varchar(95) default NULL,
</span><br>
<span style="font-family: monospace;"> `permit` varchar(95) default NULL,
</span><br>
<span style="font-family: monospace;"> `mask` varchar(95) default NULL,
</span><br>
<span style="font-family: monospace;"> `pickupgroup` varchar(10) default NULL,
</span><br>
<span style="font-family: monospace;"> `port` varchar(5) NOT NULL default '',
</span><br>
<span style="font-family: monospace;"> `qualify` char(3) default NULL,
</span><br>
<span style="font-family: monospace;"> `restrictcid` char(1) default NULL,
</span><br>
<span style="font-family: monospace;"> `rtptimeout` char(3) default NULL,
</span><br>
<span style="font-family: monospace;"> `rtpholdtimeout` char(3) default NULL,
</span><br>
<span style="font-family: monospace;"> `secret` varchar(80) default NULL,
</span><br>
<span style="font-family: monospace;"> `type` varchar(6) NOT NULL default 'friend',
</span><br>
<span style="font-family: monospace;"> `username` varchar(80) NOT NULL default '',
</span><br>
<span style="font-family: monospace;"> `disallow` varchar(100) default 'all',
</span><br>
<span style="font-family: monospace;"> `allow` varchar(100) default 'g729;ilbc;gsm;ulaw;alaw',
</span><br>
<span style="font-family: monospace;"> `musiconhold` varchar(100) default NULL,
</span><br>
<span style="font-family: monospace;"> `regseconds` int(11) NOT NULL default '0',
</span><br>
<span style="font-family: monospace;"> `ipaddr` varchar(15) NOT NULL default '',
</span><br>
<span style="font-family: monospace;"> `regexten` varchar(80) NOT NULL default '',
</span><br>
<span style="font-family: monospace;"> `cancallforward` char(3) default 'yes',
</span><br>
<span style="font-family: monospace;"> PRIMARY KEY (`id`),
</span><br>
<span style="font-family: monospace;"> UNIQUE KEY `name` (`name`),
</span><br>
<span style="font-family: monospace;"> KEY `name_2` (`name`)
</span><br>
) TYPE=MyISAM ROW_FORMAT=DYNAMIC;
<br>
<br>
<br>
<br>
i am install script into data base and no work fine<br>
<br>
i am command CLI>sip show peers<br>
and no list users into data base.<br>
<br>
<br>
<br><br><div><span class="gmail_quote">2005/11/1, Tod Detre <<a href="mailto:tod_detre@campuseai.org">tod_detre@campuseai.org</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
-----BEGIN PGP SIGNED MESSAGE-----<br>Hash: SHA1<br><br>I ran into a problem with 1.2-beta2 with using realtime sip. It looks<br>like chan_sip.c has a new field fullcontact. I just added this column<br>to my database as a VARCHAR(128) and things seem to be working now.
<br><br>I just thought someone else might want to know this.<br><br>- --<br><br>Regards,<br>Tod Detre<br>Technical Lead<br>Global Information Technology<br>CampusEAI Consortium<br>1940 East 6th Street, 11th Floor<br>Cleveland, OH 44114
<br>Tel: 216.589.9626<br>Fax: 216.589.9639 <a href="http://www.campuseai.org">www.campuseai.org</a><br><br>-----BEGIN PGP SIGNATURE-----<br>Version: GnuPG v1.4.1 (GNU/Linux)<br>Comment: Using GnuPG with Thunderbird - <a href="http://enigmail.mozdev.org">
http://enigmail.mozdev.org</a><br><br>iD8DBQFDZ4y87RbSd+ar6dMRAqZuAKCRZXqkF/GrjWTDy6rq1yoS6VFL0QCggCJW<br>OZZd5djRFw1cLzh/YSf+dzA=<br>=t6d5<br>-----END PGP SIGNATURE-----<br>_______________________________________________
<br>--Bandwidth and Colocation sponsored by <a href="http://Easynews.com">Easynews.com</a> --<br><br>Asterisk-Users mailing list<br><a href="mailto:Asterisk-Users@lists.digium.com">Asterisk-Users@lists.digium.com</a><br><a href="http://lists.digium.com/mailman/listinfo/asterisk-users">
http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users
</a><br></blockquote></div><br>