<html><body><div style="font-family: lucida console,sans-serif; font-size: 12pt; color: #000000"><div data-marker="__QUOTED_TEXT__"><div style="font-family: lucida console,sans-serif; font-size: 12pt; color: #000000" data-mce-style="font-family: lucida console,sans-serif; font-size: 12pt; color: #000000;"><div>Hello Everyone, <br></div><div>Thank you for help, fixed by adding to dialog module parameters.</div><div><br data-mce-bogus="1"></div><div>modparam("dialog", "db_url", DBURL)</div><br><div>Slava.<br></div><br><div><br><br><br><hr id="zwchr"><div><b>From: </b>"Carsten Bock" <carsten@ng-voice.com><br><b>To: </b>"sr-users" <sr-users@lists.sip-router.org><br><b>Sent: </b>Sunday, January 25, 2015 8:36:52 AM<br><b>Subject: </b>Re: [SR-Users] remote mysql server<br></div><br><div>Hi Slava,<br><br>is most modules a default database connection is defined. Probably<br>this is the case here.<br>As this error is coming from the dialog module: Did you configure some<br>sort of "db_mode"?<br>e.g.:<br>modparam("dialog", "db_mode", 1)<br><br>Thanks,<br>Carsten<br><br>2015-01-25 9:27 GMT+02:00 Slava Bendersky <volga629@skillsearch.ca>:<br>> Hello Everyone,<br>><br>> I am trying start kamailio 4.2 with remote mysql server and on debug I see<br>> DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): opening<br>> connection: mysql://xxxx:xxxx@localhost/kamailio<br>> but in cfg defined actual mysql server ip and not localhost<br>><br>> 0(28885) DEBUG: <core> [sr_module.c:695]: find_mod_export_record():<br>> find_export_record: found <db_bind_api> in module db_mysql<br>> [/usr/lib64/kamailio/modules/db_mysql.so]<br>> 0(28885) DEBUG: <core> [db.c:213]: db_bind_mod(): using db bind api for<br>> db_mysql<br>> 0(28885) DEBUG: <core> [db.c:318]: db_do_init2(): connection 0x7faca59eced8<br>> not found in pool<br>> 0(28885) DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection():<br>> opening connection: mysql://xxxx:xxxx@localhost/kamailio<br>> 0(28885) ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection():<br>> driver error: Can't connect to local MySQL server through socket<br>> '/var/lib/mysql/mysql.sock' (2 "No such file or directory")<br>> 0(28885) ERROR: <core> [db.c:322]: db_do_init2(): could not add connection<br>> to the pool 0(28885) ERROR: dialog [dlg_db_handler.c:147]: init_dlg_db():<br>> unable to connect to the database<br>><br>><br>> Slava.<br>><br>> _______________________________________________<br>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>> sr-users@lists.sip-router.org<br>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users<br>><br><br><br><br>-- <br>Carsten Bock<br>CEO (Geschäftsführer)<br><br>ng-voice GmbH<br>Schomburgstr. 80<br>D-22767 Hamburg / Germany<br><br>http://www.ng-voice.com<br>mailto:carsten@ng-voice.com<br><br>Office +49 40 5247593-0<br>Fax +49 40 5247593-99<br><br>Sitz der Gesellschaft: Hamburg<br>Registergericht: Amtsgericht Hamburg, HRB 120189<br>Geschäftsführer: Carsten Bock<br>Ust-ID: DE279344284<br><br>Hier finden Sie unsere handelsrechtlichen Pflichtangaben:<br>http://www.ng-voice.com/imprint/<br><br>_______________________________________________<br>SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>sr-users@lists.sip-router.org<br>http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users<br></div>oon why I see in log connection attempt to localhost ?<br></div><br><hr id="zwchr"><div><b>From: </b>"Carsten Bock" <carsten@ng-voice.com><br><b>To: </b>"sr-users" <sr-users@lists.sip-router.org><br><b>Sent: </b>Sunday, January 25, 2015 8:36:52 AM<br><b>Subject: </b>Re: [SR-Users] remote mysql server<br></div><br><div>Hi Slava,<br><br>is most modules a default database connection is defined. Probably<br>this is the case here.<br>As this error is coming from the dialog module: Did you configure some<br>sort of "db_mode"?<br>e.g.:<br>modparam("dialog", "db_mode", 1)<br><br>Thanks,<br>Carsten<br><br>2015-01-25 9:27 GMT+02:00 Slava Bendersky <volga629@skillsearch.ca>:<br>> Hello Everyone,<br>><br>> I am trying start kamailio 4.2 with remote mysql server and on debug I see<br>> DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): opening<br>> connection: mysql://xxxx:xxxx@localhost/kamailio<br>> but in cfg defined actual mysql server ip and not localhost<br>><br>> 0(28885) DEBUG: <core> [sr_module.c:695]: find_mod_export_record():<br>> find_export_record: found <db_bind_api> in module db_mysql<br>> [/usr/lib64/kamailio/modules/db_mysql.so]<br>> 0(28885) DEBUG: <core> [db.c:213]: db_bind_mod(): using db bind api for<br>> db_mysql<br>> 0(28885) DEBUG: <core> [db.c:318]: db_do_init2(): connection 0x7faca59eced8<br>> not found in pool<br>> 0(28885) DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection():<br>> opening connection: mysql://xxxx:xxxx@localhost/kamailio<br>> 0(28885) ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection():<br>> driver error: Can't connect to local MySQL server through socket<br>> '/var/lib/mysql/mysql.sock' (2 "No such file or directory")<br>> 0(28885) ERROR: <core> [db.c:322]: db_do_init2(): could not add connection<br>> to the pool 0(28885) ERROR: dialog [dlg_db_handler.c:147]: init_dlg_db():<br>> unable to connect to the database<br>><br>><br>> Slava.<br>><br>> _______________________________________________<br>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>> sr-users@lists.sip-router.org<br>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users<br>><br><br><br><br>-- <br>Carsten Bock<br>CEO (Geschäftsführer)<br><br>ng-voice GmbH<br>Schomburgstr. 80<br>D-22767 Hamburg / Germany<br><br>http://www.ng-voice.com<br>mailto:carsten@ng-voice.com<br><br>Office +49 40 5247593-0<br>Fax +49 40 5247593-99<br><br>Sitz der Gesellschaft: Hamburg<br>Registergericht: Amtsgericht Hamburg, HRB 120189<br>Geschäftsführer: Carsten Bock<br>Ust-ID: DE279344284<br><br>Hier finden Sie unsere handelsrechtlichen Pflichtangaben:<br>http://www.ng-voice.com/imprint/<br><br>_______________________________________________<br>SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>sr-users@lists.sip-router.org<br>http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</div></div><br></div></div></body></html>