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.
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/
Hi Kamailio: I use Kamailio with Amazon EC2 virtual machine, it has a private ip such as 172.31.7.164, kamailio listened on this, I assigned a float public ip 54.X.X.X on it, and all the client send traffics to the public ip and it work well(REGISTER), but now I would relay kamailio's traffic to another real public server, the server found the INVITE's via header's ip address is 172.31.7.164, so it failed to response 100 trying and 200 OK to my kamalio, because it send to a private 172.31.7.164, so my question is can I change Kamailio's via header's ip value with my specified public ip? How can I do? Thanks a lot!
On 25 Jan 2015, at 14:48, dongwf <dongwflj@163.com> wrote:
Hi Kamailio: I use Kamailio with Amazon EC2 virtual machine, it has a private ip such as 172.31.7.164, kamailio listened on this, I assigned a float public ip 54.X.X.X on it, and all the client send traffics to the public ip and it work well(REGISTER), but now I would relay kamailio's traffic to another real public server, the server found the INVITE's via header's ip address is 172.31.7.164, so it failed to response 100 trying and 200 OK to my kamalio, because it send to a private 172.31.7.164, so my question is can I change Kamailio's via header's ip value with my specified public ip? How can I do? Thanks a lot!
The core cookbok documents the "advertise" parameter to the "listen" config setting for this case. http://www.kamailio.org/wiki/cookbooks/4.2.x/core#listen Go ahead and try that one. /O
Thanks, the public ip is not a real device ip, it is a NAT external public ip, so if I listen on that, server will not work. Anyway, I found my problem is caused by firewall, so even the via header is priviate ip, I still can get response, so please ignore this question, thanks for your help. At 2015-01-26 17:14:46, "Olle E. Johansson" <oej@edvina.net> wrote: On 25 Jan 2015, at 14:48, dongwf <dongwflj@163.com> wrote: Hi Kamailio: I use Kamailio with Amazon EC2 virtual machine, it has a private ip such as 172.31.7.164, kamailio listened on this, I assigned a float public ip 54.X.X.X on it, and all the client send traffics to the public ip and it work well(REGISTER), but now I would relay kamailio's traffic to another real public server, the server found the INVITE's via header's ip address is 172.31.7.164, so it failed to response 100 trying and 200 OK to my kamalio, because it send to a private 172.31.7.164, so my question is can I change Kamailio's via header's ip value with my specified public ip? How can I do? Thanks a lot! The core cookbok documents the "advertise" parameter to the "listen" config setting for this case. http://www.kamailio.org/wiki/cookbooks/4.2.x/core#listen Go ahead and try that one. /O
participants (4)
-
Carsten Bock -
dongwf -
Olle E. Johansson -
Slava Bendersky