I'm trying to register an extension but when I do so I get the following mesage:
Sep 24 06:22:46 WARNING[18152]: res_config_mysql.c:135 realtime_mysql: MySQL RealTime: Failed to query database. Check debug for more info.
Sep 24 06:22:46 NOTICE[18152]: chan_sip.c:10774 handle_request_register: Registration from '1001 <sip:[EMAIL PROTECTED]>' failed for ' 10.8.5.51' - Username/auth name mismatch
I checked wether asterisk was connected to the MySQL database and it appears to be connected.
asterisk1*CLI> realtime mysql status
Connected to [EMAIL PROTECTED], port 3306 with username **blahblah** for 2 days, 12 hours, 33 minutes, 42 seconds.
My database looks like this
sip-peers
| Field | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| name | varchar(80) | No | ||||
| type | varchar(6) | No | friend | |||
| username | varchar(80) | No | ||||
| secret | varchar(80) | No | ||||
| qualify | char(3) | No | ||||
| callerid | varchar(80) | No | ||||
| host | varchar(31) | No | ||||
| dtmfmode | varchar(4) | No | info | |||
| ipaddr | varchar(15) | No |
Indexes:
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 2 | id | |
Space usage:
|
Row Statistics:
| |||||||||||||||||||||||||||||
I filled my database with 2 extension like this:
SQL result
Host: localhost
Database: asterisk
Generation Time: Sep 24, 2005 at 06:27 AM
Generated by: phpMyAdmin 2.6.4 / MySQL 4.1.14-log
SQL query: SELECT * FROM `sip-peers` LIMIT 0, 30 ;
Rows: 2
| id | name | type | username | secret | qualify | callerid | host | dtmfmode | ipaddr |
|---|---|---|---|---|---|---|---|---|---|
| 1 | friend | 1006 | 1006 | yes | Extensie 1006 | dynamic | info | ||
| 2 | friend | 1001 | 1001 | yes | Extensie 1001 | dynamic | info |
I think I did something wrong making the database or filling it, might just be some missing field or something. But somehow I can't figure out what's going wrong.
Any ideas?
Thanks in advance
Tijmen
--
Tijmen van den Brink
Wilhelminaweg 46
3441 XC Woerden
Tel: 0642233831
MSN: [EMAIL PROTECTED]
Skype: [EMAIL PROTECTED]
SIP:[EMAIL PROTECTED]
_______________________________________________ --Bandwidth and Colocation sponsored by Easynews.com --
Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
