[Asterisk-Users] Realtime Problems

[scott]

Hi

Thank you for your reply.
I have tried various definitions in the sipusers table but none seem to be working :-(

I have attached mey structure  and content export below for your attention.

Many thanks
Scott Pinhorne

-- 
-- Table structure for table `sip_users`
-- 

CREATE TABLE `sip_users` (
  `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,
  `fullcontact` varchar(80) default NULL,
  `host` varchar(31) NOT NULL default '',
  `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 'no',
  `deny` varchar(95) default NULL,
  `permit` 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 '',
  `disallow` varchar(100) default 'all',
  `allow` varchar(100) default 'g729;ilbc;gsm;ulaw;alaw',
  `musiconhold` varchar(100) default NULL,
  `regseconds` int(11) NOT NULL default '0',
  `ipaddr` varchar(15) NOT NULL default '',
  `regexten` varchar(80) NOT NULL default '',
  `cancallforward` char(3) default 'yes',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `name_2` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `sip_users`
-- 

INSERT INTO `sip_users` VALUES (1, '114', NULL, NULL, NULL, '114', 'yes', 'default', '192.168.10.136', 'info', NULL, NULL, '114', '192.168.10.136', NULL, NULL, NULL, NULL, 'no', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '114', 'friend', '114', 'all', 'g729;ilbc;gsm;ulaw;alaw', NULL, 0, '', '', 'yes');



-----Original message-----
From: Are london3 at gmail.com
Date: Mon, 21 Nov 2005 09:07:43 -0600
To: Asterisk Users Mailing List - Non-Commercial Discussion
	asterisk-users at lists.digium.com
Subject: Re: [Asterisk-Users] Realtime Problems

> You have error: Username/auth name
> mismatch<http://fast.turbosite.net/phpmyadmin/tbl_properties_structure.php?> lang=en-utf-8&server=1&collation_connection=utf8_general_ci&db=mans> ionpbx&table=asv_sip>
> 
> So there is clearly and issue with the content in your table.
> 
> In our setup the column name and username have the same value = 114
> the fromuser and authuser column = NULL
> 
> If this is not helping send your table definition and the content of your
> record 114 and we will sort it out.
> 
> --
> Are Casilla
> http://astartelecom.com - Independent VOIP Telecoms Broker. Asterisk
> Consultants
> http://astbill.com - Open Source Billing, Routing and Management software
> for Asterisk and VOIP
> AstBill DEMO: http://demo.astbill.com
>