[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