[Asterisk-Users] Realtime does not work yet, ...

[Ronald Wiplinger]

Matthew Boehm wrote:

>*CLI> Urgent handler
>    -- SIP Seeding peers from Astdb: '3044' at 3044 at 64.XX.XX.XX: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', '3044 at cytel',
>'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 at 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.