[SR-Users] remote mysql server

Slava Bendersky volga629 at networklab.ca
Sun Jan 25 21:10:22 CET 2015


Hello Everyone, 
Thank you for help, fixed by adding to dialog module parameters. 

modparam("dialog", "db_url", DBURL) 

Slava. 





From: "Carsten Bock" <carsten at ng-voice.com> 
To: "sr-users" <sr-users at lists.sip-router.org> 
Sent: Sunday, January 25, 2015 8:36:52 AM 
Subject: Re: [SR-Users] remote mysql server 

Hi Slava, 

is most modules a default database connection is defined. Probably 
this is the case here. 
As this error is coming from the dialog module: Did you configure some 
sort of "db_mode"? 
e.g.: 
modparam("dialog", "db_mode", 1) 

Thanks, 
Carsten 

2015-01-25 9:27 GMT+02:00 Slava Bendersky <volga629 at skillsearch.ca>: 
> Hello Everyone, 
> 
> I am trying start kamailio 4.2 with remote mysql server and on debug I see 
> DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): opening 
> connection: mysql://xxxx:xxxx@localhost/kamailio 
> but in cfg defined actual mysql server ip and not localhost 
> 
> 0(28885) DEBUG: <core> [sr_module.c:695]: find_mod_export_record(): 
> find_export_record: found <db_bind_api> in module db_mysql 
> [/usr/lib64/kamailio/modules/db_mysql.so] 
> 0(28885) DEBUG: <core> [db.c:213]: db_bind_mod(): using db bind api for 
> db_mysql 
> 0(28885) DEBUG: <core> [db.c:318]: db_do_init2(): connection 0x7faca59eced8 
> not found in pool 
> 0(28885) DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): 
> opening connection: mysql://xxxx:xxxx@localhost/kamailio 
> 0(28885) ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection(): 
> driver error: Can't connect to local MySQL server through socket 
> '/var/lib/mysql/mysql.sock' (2 "No such file or directory") 
> 0(28885) ERROR: <core> [db.c:322]: db_do_init2(): could not add connection 
> to the pool 0(28885) ERROR: dialog [dlg_db_handler.c:147]: init_dlg_db(): 
> unable to connect to the database 
> 
> 
> Slava. 
> 
> _______________________________________________ 
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list 
> sr-users at lists.sip-router.org 
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 
> 



-- 
Carsten Bock 
CEO (Geschäftsführer) 

ng-voice GmbH 
Schomburgstr. 80 
D-22767 Hamburg / Germany 

http://www.ng-voice.com 
mailto:carsten at ng-voice.com 

Office +49 40 5247593-0 
Fax +49 40 5247593-99 

Sitz der Gesellschaft: Hamburg 
Registergericht: Amtsgericht Hamburg, HRB 120189 
Geschäftsführer: Carsten Bock 
Ust-ID: DE279344284 

Hier finden Sie unsere handelsrechtlichen Pflichtangaben: 
http://www.ng-voice.com/imprint/ 

_______________________________________________ 
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list 
sr-users at lists.sip-router.org 
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 
oon why I see in log connection attempt to localhost ? 


From: "Carsten Bock" <carsten at ng-voice.com> 
To: "sr-users" <sr-users at lists.sip-router.org> 
Sent: Sunday, January 25, 2015 8:36:52 AM 
Subject: Re: [SR-Users] remote mysql server 

Hi Slava, 

is most modules a default database connection is defined. Probably 
this is the case here. 
As this error is coming from the dialog module: Did you configure some 
sort of "db_mode"? 
e.g.: 
modparam("dialog", "db_mode", 1) 

Thanks, 
Carsten 

2015-01-25 9:27 GMT+02:00 Slava Bendersky <volga629 at skillsearch.ca>: 
> Hello Everyone, 
> 
> I am trying start kamailio 4.2 with remote mysql server and on debug I see 
> DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): opening 
> connection: mysql://xxxx:xxxx@localhost/kamailio 
> but in cfg defined actual mysql server ip and not localhost 
> 
> 0(28885) DEBUG: <core> [sr_module.c:695]: find_mod_export_record(): 
> find_export_record: found <db_bind_api> in module db_mysql 
> [/usr/lib64/kamailio/modules/db_mysql.so] 
> 0(28885) DEBUG: <core> [db.c:213]: db_bind_mod(): using db bind api for 
> db_mysql 
> 0(28885) DEBUG: <core> [db.c:318]: db_do_init2(): connection 0x7faca59eced8 
> not found in pool 
> 0(28885) DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): 
> opening connection: mysql://xxxx:xxxx@localhost/kamailio 
> 0(28885) ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection(): 
> driver error: Can't connect to local MySQL server through socket 
> '/var/lib/mysql/mysql.sock' (2 "No such file or directory") 
> 0(28885) ERROR: <core> [db.c:322]: db_do_init2(): could not add connection 
> to the pool 0(28885) ERROR: dialog [dlg_db_handler.c:147]: init_dlg_db(): 
> unable to connect to the database 
> 
> 
> Slava. 
> 
> _______________________________________________ 
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list 
> sr-users at lists.sip-router.org 
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 
> 



-- 
Carsten Bock 
CEO (Geschäftsführer) 

ng-voice GmbH 
Schomburgstr. 80 
D-22767 Hamburg / Germany 

http://www.ng-voice.com 
mailto:carsten at ng-voice.com 

Office +49 40 5247593-0 
Fax +49 40 5247593-99 

Sitz der Gesellschaft: Hamburg 
Registergericht: Amtsgericht Hamburg, HRB 120189 
Geschäftsführer: Carsten Bock 
Ust-ID: DE279344284 

Hier finden Sie unsere handelsrechtlichen Pflichtangaben: 
http://www.ng-voice.com/imprint/ 

_______________________________________________ 
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list 
sr-users at lists.sip-router.org 
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20150125/62f88306/attachment.html>


More information about the sr-users mailing list