Matthew Boehm wrote:
*CLI> Urgent handler -- SIP Seeding peers from Astdb: '3044' at [EMAIL PROTECTED]:64718 for 120 Urgent handler -- Registered SIP '3044' at 64.XX.XX.XX port 17524 expires 120
Codecs : 0x10c (ulaw|alaw|g729) Codec Order : (g729|ulaw|alaw)
Using the following table:
CREATE TABLE customer_stations ( name varchar(30) NOT NULL default '', callgroup varchar(30) default NULL, callerid varchar(50) default NULL, restrictcid char(3) default 'NO', canreinvite char(1) default NULL, context varchar(30) default NULL, dtmfmode varchar(7) default NULL, host varchar(31) NOT NULL default 'dynamic', mailbox varchar(50) default NULL, md5secret varchar(32) default NULL, nat varchar(5) default NULL, pickupgroup varchar(10) default NULL, port varchar(5) NOT NULL default '0', qualify varchar(4) default NULL, secret varchar(30) default NULL, `type` varchar(6) NOT NULL default 'friend', username varchar(30) default NULL, disallow varchar(100) default NULL, allow varchar(100) default NULL, regseconds int(11) NOT NULL default '0', ipaddr varchar(15) NOT NULL default '0.0.0.0', PRIMARY KEY (station_id), KEY name (name) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
And this entry:
INSERT INTO `customer_stations` (`name`, `callgroup`, `callerid`, `restrictcid`, `canreinvite`, `context`, `dtmfmode`, `host`, `mailbox`, `md5secret`, `nat`, `pickupgroup`, `port`, `qualify`, `secret`, `type`, `username`, `disallow`, `allow`, `regseconds`, `ipaddr`) VALUES ('3044', NULL, NULL, 'NO', NULL, 'cytel-internal', NULL, 'dynamic', '[EMAIL PROTECTED]', 'd2756499745e254f52a224713f1a7d91', 'no', NULL, '5060', NULL, NULL, 'friend', '3044', NULL, 'g729,ulaw,alaw', 1109176184, '10.0.0.36');
Run this command from MySQL CLI: "show create table sipusers\G". <-- exactly like that
If the "allow" column is 'above' the "disallow" column, then that is
probably your problem.
I changed the sequence first disallow and than allow. After restarting * it is working now!
I am sure I copied the table and did not change it, ... somewhere it must have the wrong order.
Thanks for your patient with me!
bye
Ronald
ARA works by returning all columns in a table (SELECT *). So your column order is most important. If the allow column comes before disallow in the table schema, then the allow stuff will be processed by chan_sip and THEN the disallow will be processed.
You need to make sure that disallow is processed first.
Let me know..
-Matthew
_______________________________________________ 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
-- Ronald Wiplinger (CEO of ELMIT) http://www.elmit.com +886 (0) 939--77-55-16 or FWD 511208 - I'm a SpamCon Foundation Member, #694, Verify it at http://www.spamcon.org
PS: Spam prevention!
Our system is protected with a spam prevention program. If you send us an e-mail, our system will send you a confirmation message back. Just reply to this confirmation message please. After receiving this confirmation message, our system will send the hold message (one) and all future messages (after the received confirmation message) to me without asking you again.
_______________________________________________ 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
