12 Apr
2011
12 Apr
'11
12:34 p.m.
I have set up kamailio 3.1.2 on an install of Debian Squeeze, using the default config but
with the following defines enabled:
WITH_MYSQLWITH_AUTHWITH_USRLOCDBWITH_NAT
Everything works as expected when starting Kamailio from a terminal, e.g.service kamailio
start
But after a reboot, the service fails to start and all SIP requests are dropped with
a ICMP port unreachable error.
The following is an extract of /var/log/syslog when this problem occurs. It looks like
Kamailio is failing to access the mysql socket, as the mysql service has not yet started?
Apr 12 10:08:31 SIPServer /usr/sbin/kamailio[1347]: ERROR: db_mysql [km_my_con.c:109]:
driver error: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)Apr 12 10:08:31 SIPServer
/usr/sbin/kamailio[1347]: ERROR: <core> [db.c:289]: could not add connection to the
poolApr 12 10:08:31 SIPServer /usr/sbin/kamailio[1347]: ERROR: usrloc [dlist.c:486]:
failed to open database connectionApr 12 10:08:31 SIPServer /usr/sbin/kamailio[1347]:
ERROR: registrar [reg_mod.c:396]: failed to register domainApr 12 10:08:31 SIPServer
/usr/sbin/kamailio[1347]: ERROR: <core> [route.c:1161]: fixing failed (code=-1) at
cfg:/etc/kamailio/kamailio.cfg:569Apr 12 10:08:31 SIPServer /usr/sbin/kamailio[1347]:
ERROR: <core> [route.c:1161]: fixing failed (code=-1) at
cfg:/etc/kamailio/kamailio.cfg:572Apr 12 10:08:31 SIPServer /usr/sbin/kamailio[1347]:
ERROR: <core> [route.c:1161]: fixing failed (code=-1) at
cfg:/etc/kamailio/kamailio.cfg:574Apr 12
10:08:34 SIPServer mysqld_safe: Starting mysqld daemon with databases from
/var/lib/mysqlApr 12 10:08:34 SIPServer mysqld: 110412 10:08:34 [Note] Plugin
'FEDERATED' is disabled.Apr 12 10:08:36 SIPServer mysqld: 110412 10:08:36 InnoDB:
Started; log sequence number 0 44233Apr 12 10:08:36 SIPServer mysqld: 110412 10:08:36
[Note] Event Scheduler: Loaded 0 eventsApr 12 10:08:36 SIPServer mysqld: 110412 10:08:36
[Note] /usr/sbin/mysqld: ready for connections.Apr 12 10:08:36 SIPServer mysqld: Version:
'5.1.49-3' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
Both the Kamailio and mysql services start with priority 18 on run levels 2345. I tried
adjusting the Kamailio service to priority 19, but the problem still occurs.
I am relatively new to Kamailio and mysql as well as Linux / Debian administration, so
I'm not really sure how to solve this problem. Any ideas would be greatly
appreciated.
Regards,Rick Aldred