Hello Everyone,

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

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

Slava.

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