<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font face="Helvetica, Arial, sans-serif">Hello<br>
<br>
I have already several Asterisk servers running with similar
configuration, but now I stumble into a problem.<br>
<br>
I have mysql configuration res_config_mysql.conf :<br>
<br>
[MyAsteriskDB]<br>
dbhost = 127.0.0.1<br>
dbname = MyAsteriskDB<br>
dbuser = astadmin<br>
dbpass = mysecret<br>
dbport = 3306<br>
dbsock = /var/lib/mysql/mysql.sock<br>
requirements=warn ; or createclose or createchar<br>
<br>
<br>
Realtime seems to be loaded :<br>
<br>
*CLI> realtime mysql status <br>
general configured for asterisk on socket file
/var/lib/mysql/mysql.sock with username asterisk.<br>
MyAsteriskDB connected to </font><font face="Helvetica, Arial,
sans-serif"><font face="Helvetica, Arial, sans-serif">MyAsteriskDB</font>@127.0.0.1,
port 3306 with username astadmin for 12 minutes.<br>
[May 22 10:32:02] ERROR[11269]: res_config_mysql.c:1599
mysql_reconnect: MySQL RealTime: Failed to connect database server
asterisk on /var/lib/mysql/mysql.sock (err 1045). Check debug for
more info.<br>
*CLI><br>
<br>
However, SIP-registration for SIP peer can not be found :<br>
<br>
[May 22 10:32:50] NOTICE[11077]: chan_sip.c:24957
handle_request_register: Registration from
'<a class="moz-txt-link-rfc2396E" href="mailto:sip:testacc66@my.ip.ast.ser"><sip:testacc66@my.ip.ast.ser></a>' failed for
'11.22.33.44:5060' - No matching peer found<br>
<br>
Debug logs say :<br>
<br>
[May 22 10:48:06] DEBUG[11077] res_config_mysql.c: MySQL RealTime:
Connection okay.<br>
[May 22 10:48:06] DEBUG[11077] res_config_mysql.c: MySQL RealTime:
Retrieve SQL: SELECT * FROM sip_buddies WHERE name = 'testacc66'
AND host = 'dynamic'<br>
[May 22 10:48:06] DEBUG[11077] res_config_mysql.c: MySQL RealTime:
Connection okay.<br>
[May 22 10:48:06] DEBUG[11077] res_config_mysql.c: MySQL RealTime:
Retrieve SQL: SELECT * FROM sip_buddies WHERE name = 'testacc66'<br>
<br>
<br>
But sip peer </font><font face="Helvetica, Arial, sans-serif">testacc66
really exists in my database in table sip_buddies. It can not be
found ?!<br>
<br>
<br>
What else is there for me to investigate ? Can u help me ?<br>
<br>
Thanks !<br>
<br>
Jonas.<br>
</font>
</body>
</html>