[sr-dev] [tracker] Task opened: db_mysql doesn't work

[sip-router]

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY.

A new Flyspray task has been opened.  Details are below. 

User who did this - Ilimit Comunicacions (Ilimit) 

Attached to Project - sip-router
Summary - db_mysql doesn't work
Task Type - Bug Report
Category - DB interface
Status - Unconfirmed
Assigned To - 
Operating System - All
Severity - Medium
Priority - Normal
Reported Version - Development
Due in Version - Undecided
Due Date - Undecided
Details - Module db_mysql doesn't works in kamailio 3.2.0 (stable since 2011-10-18)

On localhost:

# cat kamailio.cfg | grep mysql
loadmodule "db_mysql.so"
modparam("auth_db|usrloc|uri_db|domain|avpops|siptrace|alias_db|group|pdt|lcr", "db_url", "mysql://openser:kkaammaalliioo@localhost/kamailio")

# mysql -h localhost -u openser -pkkaammaalliioo kamailio
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 106
Server version: 5.1.49-3-log (Debian)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

# /etc/init.d/kamailio restart
Restarting Kamailio:
loading modules under /usr/lib/kamailio/modules_k/:/usr/lib/kamailio/modules/
Listening on 
             udp: 80.94.3.27 [80.94.3.27]:5060
Aliases: 

kamailio error, failed to start.

# tail -6 /var/log/syslog
Nov  8 18:25:29 kamailio kamailio: INFO: <core> [tcp_main.c:4724]: init_tcp: using epoll_lt as the io watch method (auto detected)
Nov  8 18:25:29 kamailio /usr/sbin/kamailio[29677]: INFO: usrloc [hslot.c:53]: locks array size 512
Nov  8 18:25:29 kamailio /usr/sbin/kamailio[29677]: INFO: auth [auth_mod.c:312]: auth: qop set, but nonce-count (nc_enabled) support disabled
Nov  8 18:25:29 kamailio /usr/sbin/kamailio[29677]: ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'openser'@'localhost' (using password: YES)
Nov  8 18:25:29 kamailio /usr/sbin/kamailio[29677]: ERROR: <core> [db.c:302]: could not add connection to the pool
Nov  8 18:25:29 kamailio /usr/sbin/kamailio[29677]: ERROR: presence_xml [presence_xml.c:193]: while connecting to database
Nov  8 18:25:29 kamailio /usr/sbin/kamailio[29677]: ERROR: <core> [sr_module.c:925]: init_mod(): Error while initializing module presence_xml (/usr/lib/kamailio/modules_k/presence_xml.so)

On remote host:

# cat /etc/kamailio/kamailio.cfg | grep mysql
loadmodule "db_mysql.so"
modparam("auth_db|usrloc|uri_db|domain|avpops|siptrace|alias_db|group|pdt|lcr", "db_url", "mysql://kamailiorw:k4m41l10rw@mysql.proves-jaume.ilimit.net/kamailio")

# mysql -h mysql.proves-jaume.ilimit.es -u kamailiorw -pk4m41l10rw kamailio
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 455
Server version: 5.1.49-3-log (Debian)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

# /etc/init.d/kamailio restart
Restarting Kamailio:
loading modules under /usr/lib/kamailio/modules_k/:/usr/lib/kamailio/modules/
Listening on 
             udp: 80.94.3.35 [80.94.3.35]:5060
Aliases: 

kamailio error, failed to start.

# tail -7 /var/log/syslog 
Nov  8 17:31:48 kamailio2 kamailio: INFO: <core> [tcp_main.c:4724]: init_tcp: using epoll_lt as the io watch method (auto detected)
Nov  8 17:31:48 kamailio2 /usr/sbin/kamailio[14620]: INFO: usrloc [hslot.c:53]: locks array size 512
Nov  8 17:31:48 kamailio2 /usr/sbin/kamailio[14620]: INFO: auth [auth_mod.c:312]: auth: qop set, but nonce-count (nc_enabled) support disabled
Nov  8 17:31:48 kamailio2 /usr/sbin/kamailio[14620]: 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)
Nov  8 17:31:48 kamailio2 /usr/sbin/kamailio[14620]: ERROR: <core> [db.c:302]: could not add connection to the pool
Nov  8 17:31:48 kamailio2 /usr/sbin/kamailio[14620]: ERROR: presence_xml [presence_xml.c:193]: while connecting to database
Nov  8 17:31:48 kamailio2 /usr/sbin/kamailio[14620]: ERROR: <core> [sr_module.c:925]: init_mod(): Error while initializing module presence_xml (/usr/lib/kamailio/modules_k/presence_xml.so)


More information can be found at the following URL:
http://sip-router.org/tracker/index.php?do=details&task_id=174

You are receiving this message because you have requested it from the Flyspray bugtracking system.  If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above.