26 Jan
2015
26 Jan
'15
7:10 a.m.
Hello Everyone,
Thank you for help, fixed by adding to dialog module parameters.
modparam("dialog", "db_url", DBURL)
Slava.
From: "Carsten Bock" <carsten(a)ng-voice.com>
To: "sr-users" <sr-users(a)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(a)skillsearch.ca>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(a)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(a)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(a)ng-voice.com>
To: "sr-users" <sr-users(a)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(a)skillsearch.ca>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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users