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

[Ronald Wiplinger]

Ronald Wiplinger wrote:

> Matthew Boehm wrote:
>
>>>>> INSERT INTO sip_buddies VALUES
>>>>>
>>>>>       
>>>>
>> (1,'621',NULL,NULL,NULL,'\"Demo\",<621>','yes','inhouse',NULL,'rfc2833',NULL 
>>
>> ,N
>>  
>>
>> ULL,'dynamic',NULL,NULL,NULL,NULL,'621 at other',NULL,'yes',NULL,NULL,NULL,'1', 
>>
>> ''
>>  
>>
>> ,'999',NULL,NULL,NULL,'Password','friend','621','ulaw;alaw','all',NULL,0,'', 
>>
>> 'y
>>
>> Try using commas instead of semicolons. I'm using commas and its 
>> working:
>>
>>  Codecs       : 0x10c (ulaw|alaw|g729)
>>  Codec Order  : (g729|ulaw|alaw)
>>  
>>
>
> I tried to use comas as well, rebooted the phone, reladed * and still 
> the same: 601 can call 621, but 621 cannot call 601
>
>  Codecs       : 0x0 (nothing)
>  Codec Order  : (none)



I am still on the same spot. I also tried to use:   g729,ulaw,alaw    
(just to see if sip show peer 621 will pop up now) No changes! Codecs 
remains empty!
Is there anything I can do to track down the problem? e.g., is there a 
command in *CLI to read the database record? push a record, see the 
differences, ...

Is it a spelling error/missing in the table structure, I have overlooked?

CREATE TABLE sip_buddies (
  id int(11) NOT NULL auto_increment,
  name varchar(80) NOT NULL default '',
  accountcode varchar(20) default NULL,
  amaflags varchar(7) default NULL,
  callgroup varchar(10) default NULL,
  callerid varchar(80) default NULL,
  canreinvite char(3) default 'yes',
  context varchar(80) default NULL,
  defaultip varchar(15) default NULL,
  dtmfmode varchar(7) default NULL,
  fromuser varchar(80) default NULL,
  fromdomain varchar(80) default NULL,
  host varchar(31) NOT NULL default '',
  incominglimit int(2) default NULL,
  outgoinglimit int(2) default NULL,
  insecure varchar(4) default NULL,
  language char(2) default NULL,
  mailbox varchar(50) default NULL,
  md5secret varchar(80) default NULL,
  nat varchar(5) NOT NULL default 'yes',
  permit varchar(95) default NULL,
  deny varchar(95) default NULL,
  mask varchar(95) default NULL,
  pickupgroup varchar(10) default NULL,
  port varchar(5) NOT NULL default '',
  qualify char(3) default NULL,
  restrictcid char(1) default NULL,
  rtptimeout char(3) default NULL,
  rtpholdtimeout char(3) default NULL,
  secret varchar(80) default NULL,
  type varchar(6) NOT NULL default 'friend',
  username varchar(80) NOT NULL default '',
  allow varchar(100) default 'g729;ilbc;gsm;ulaw;alaw',
  disallow varchar(100) default 'all',
  musiconhold varchar(100) default NULL,
  regseconds int(11) NOT NULL default '0',
  ipaddr varchar(15) NOT NULL default '',
  cancallforward char(3) default 'yes',
  PRIMARY KEY  (id),
  UNIQUE KEY name (name),
  KEY name_2 (name)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC;