[asterisk-users] Problem with Asterisk Realtime (MySQL)

Edwin Pauli edwin at sping.nl
Mon Sep 18 05:46:08 MST 2006


I have installed and configured Asterisk and that's working without problems 
in static mode.

To use Realtime, i have created a table (sipuser) and put this line in 
extconfig.conf

sipusers => mysql,asterisk,sipuser

The connection to the database is alive.

bechtoldsheim*CLI> realtime mysql status
Connected to asterisk at davenport.*.*.*, port 3306 with username asterisk for 10 
minutes, 34 seconds.
2006-09-18 14:36:25 DEBUG[23680]: res_config_mysql.c:674 mysql_reconnect: 
MySQL RealTime: Everything is fine.

There is one record in the table sipuser, with the name 'edwin'.

name    edwin
context    edwin
host    dynamic
type    friend  
deny    0.0.0.0/0.0.0.0 	
permit    10.0.0.37/255.255.255.255

But when i try to register the sipuser 'edwin' with kphone (KDE SIP phone), 
the following error is shown in the Asterisk log.

2006-09-18 14:34:43 NOTICE[23672]: chan_sip.c:11084 handle_request_register: 
Registration from '"Edwin Pauli" <sip:Edwin at bechtoldsheim.*.*.*>' failed 
for '10.0.0.37' - Username/auth name mismatch

This information is in sip.conf (the same as what i have insert into the 
database).
	
[edwin]
type=friend
host=dynamic
context=edwin
deny=0.0.0.0/0.0.0.0
permit=10.0.0.37/255.255.255.255

What is the problem?

-- 
Edwin


More information about the asterisk-users mailing list