[asterisk-users] Asterisk Realtime and MD5 authentication

[Edwin Pauli]

Hi,

I've troubles with setting up Asterisk Realtime and MD5 authentication.
With clear text passwords everything is working fine.

    -- Registered SIP 'edwin' at 10.0.0.37 port 5060 expires 600
    -- Saved useragent "Cisco-CP7940G/8.0" for peer edwin
[2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:651 mysql_reconnect: 
MySQL RealTime: Everything is fine.
[2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:355 update_mysql: MySQL 
RealTime: Update SQL: UPDATE SipUser SET ipaddr = '10.0.0.37', port = '5060', 
regseconds = '1168853292', username = 'edwin', fullcontact 
= 'sip:edwin at 10.0.1.121:5060;transport=udp' WHERE name = 'edwin'
[2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:369 update_mysql: MySQL 
RealTime: Updated 1 rows on table: SipUser
[2007-01-15 10:18:13] NOTICE[28528]: chan_sip.c:12001 
handle_response_peerpoke: Peer 'edwin' is now Reachable. (328ms / 2000ms)


After changing clear text passwords in MD5, and rename the md5-field in the 
database to 'md5secret' no SIP account can register.

[2007-01-15 11:06:23] DEBUG[28528]: db.c:236 ast_db_del: Unable to find 
key 'edwin' in family 'SIP/Registry'
[2007-01-15 11:06:23] DEBUG[28521]: res_config_mysql.c:651 mysql_reconnect: 
MySQL RealTime: Everything is fine.
[2007-01-15 11:06:23] DEBUG[28521]: res_config_mysql.c:139 realtime_mysql: 
MySQL RealTime: Retrieve SQL: SELECT * FROM SipUser WHERE name = 'edwin'
[2007-01-15 11:06:23] DEBUG[28521]: acl.c:199 ast_append_ha: 
0.0.0.0/255.255.255.255 appended to acl for peer
[2007-01-15 11:06:23] DEBUG[28521]: acl.c:199 ast_append_ha: 
10.0.1.77/255.255.0.0/255.255.0.0 appended to acl for peer
[2007-01-15 11:06:23] DEBUG[28521]: db.c:197 ast_db_get: Unable to find 
key 'edwin' in family 'SIP/Registry'

I've added user:secret at realm in the auth-field and created the md5-password 
(in the field md5secret) as follow: md5 -s edwin:secret at realm (with secret 
and realm as the correct values).

I'm using Asterisk 1.4.0.

-- 
Edwin