Sup guyz! On debian 12 i have kamailio 5.6.3 and when I try to use db_mysql module I always get an error: kamailio[2842268]: ERROR: db_mysql [km_my_con.c:163]: db_mysql_new_connection(): driver error: Can't connect to local server through socket '/run/mysqld/mysqld.sock'
I have no idea where it finds this socket cuz I don’t have it and don’t want to. Where I can change it?
So, nobody knows where does he get this path from?
16 янв. 2024 г., в 15:33, iglov via sr-users sr-users@lists.kamailio.org написал(а):
Sup guyz! On debian 12 i have kamailio 5.6.3 and when I try to use db_mysql module I always get an error: kamailio[2842268]: ERROR: db_mysql [km_my_con.c:163]: db_mysql_new_connection(): driver error: Can't connect to local server through socket '/run/mysqld/mysqld.sock'
I have no idea where it finds this socket cuz I don’t have it and don’t want to. Where I can change it? __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
Hi
Just a guess:
https://www.kamailio.org/docs/modules/devel/modules/sqlops.html#idm85
If you define 'localhost' then the default socket (probably somewhere in your MySQL config) ist taken.
Mit freundlichen Grüssen
-Benoît Panizzon-
Hey Benoit! Thanx 4 attention!
Yep, I thought so too and the first thing I did was check all my configs. So, I have only one /etc/mysql/my.cnf in whole OS with [mysqld] socket = /var/lib/mysql/mysql.sock
[client] socket = /var/lib/mysql/mysql.sock
I even tried to find this like that: grep -rH mysqld / So, why Kamailio despite everything try to connect with /run/mysqld/mysqld.sock ? And if I defined ‘localhost’ why it use local socket? What if I want it to use network? I can’t even find default settings in kamailio sources :( It makes me crazy :(
18 янв. 2024 г., в 12:18, Benoit Panizzon benoit.panizzon@imp.ch написал(а):
Hi
Just a guess:
https://www.kamailio.org/docs/modules/devel/modules/sqlops.html#idm85
If you define 'localhost' then the default socket (probably somewhere in your MySQL config) ist taken.
Mit freundlichen Grüssen
-Benoît Panizzon-
I m p r o W a r e A G - Leiter Commerce Kunden ______________________________________________________
Zurlindenstrasse 29 Tel +41 61 826 93 00 CH-4133 Pratteln Fax +41 61 826 93 01 Schweiz Web http://www.imp.ch ______________________________________________________
As you say your socket address is /var/lib/mysql/mysql.sock not /run /mysqld/mysql.sock
On Thu, Jan 18, 2024, 15:23 iglov via sr-users sr-users@lists.kamailio.org wrote:
Hey Benoit! Thanx 4 attention!
Yep, I thought so too and the first thing I did was check all my configs. So, I have only one /etc/mysql/my.cnf in whole OS with [mysqld] socket = /var/lib/mysql/mysql.sock
[client] socket = /var/lib/mysql/mysql.sock
I even tried to find this like that: grep -rH mysqld / So, why Kamailio despite everything try to connect with /run/mysqld/mysqld.sock ? And if I defined ‘localhost’ why it use local socket? What if I want it to use network? I can’t even find default settings in kamailio sources :( It makes me crazy :(
18 янв. 2024 г., в 12:18, Benoit Panizzon benoit.panizzon@imp.ch
написал(а):
Hi
Just a guess:
https://www.kamailio.org/docs/modules/devel/modules/sqlops.html#idm85
If you define 'localhost' then the default socket (probably somewhere in your MySQL config) ist taken.
Mit freundlichen Grüssen
-Benoît Panizzon-
I m p r o W a r e A G - Leiter Commerce Kunden ______________________________________________________
Zurlindenstrasse 29 Tel +41 61 826 93 00 CH-4133 Pratteln Fax +41 61 826 93 01 Schweiz Web http://www.imp.ch ______________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
Yes, correct, my socket address is /var/lib/mysql/mysql.sock but kamailio still trying to connect to /run/mysqld/mysqld.sock
18 янв. 2024 г., в 13:56, mohsen khashei via sr-users sr-users@lists.kamailio.org написал(а):
As you say your socket address is /var/lib/mysql/mysql.sock not /run/mysqld/mysql.sock
On Thu, Jan 18, 2024, 15:23 iglov via sr-users <sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org> wrote:
Hey Benoit! Thanx 4 attention!
Yep, I thought so too and the first thing I did was check all my configs. So, I have only one /etc/mysql/my.cnf in whole OS with [mysqld] socket = /var/lib/mysql/mysql.sock
[client] socket = /var/lib/mysql/mysql.sock
I even tried to find this like that: grep -rH mysqld / So, why Kamailio despite everything try to connect with /run/mysqld/mysqld.sock ? And if I defined ‘localhost’ why it use local socket? What if I want it to use network? I can’t even find default settings in kamailio sources :( It makes me crazy :(
18 янв. 2024 г., в 12:18, Benoit Panizzon <benoit.panizzon@imp.ch mailto:benoit.panizzon@imp.ch> написал(а):
Hi
Just a guess:
https://www.kamailio.org/docs/modules/devel/modules/sqlops.html#idm85
If you define 'localhost' then the default socket (probably somewhere in your MySQL config) ist taken.
Mit freundlichen Grüssen
-Benoît Panizzon-
I m p r o W a r e A G - Leiter Commerce Kunden ______________________________________________________
Zurlindenstrasse 29 Tel +41 61 826 93 00 CH-4133 Pratteln Fax +41 61 826 93 01 Schweiz Web http://www.imp.ch http://www.imp.ch/ ______________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave@lists.kamailio.org mailto:sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
Hello,
just to double check, so you are setting a db_url? Maybe you need to change the db_url, refer e.g. to this: https://serverfault.com/questions/337818/how-to-force-mysql-to-connect-by-tc...
Cheers,
Henning
-----Original Message----- From: iglov via sr-users sr-users@lists.kamailio.org Sent: Donnerstag, 18. Januar 2024 11:56 To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Cc: iglov iglov@avalon.land Subject: [SR-Users] Re: How to change uri for db_mysql ?
So, nobody knows where does he get this path from?
16 янв. 2024 г., в 15:33, iglov via sr-users sr-users@lists.kamailio.org
написал(а):
Sup guyz! On debian 12 i have kamailio 5.6.3 and when I try to use
db_mysql module I always get an error: kamailio[2842268]: ERROR: db_mysql [km_my_con.c:163]: db_mysql_new_connection(): driver error: Can't connect to local server through socket '/run/mysqld/mysqld.sock'
I have no idea where it finds this socket cuz I don’t have it and don’t want to.
Where I can change it?
Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the
sender!
Edit mailing list options or unsubscribe:
Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
Hey Henning! Thx 4 suggestion!
Are we talking about db_url somewhere in kamailio settings? Cuz refer by ur link there was a problem with local Drupal config, but guyz offered to globally change mysql settings to use ONLY network socket - I can’t do this. If we are talking about kamailio settings that what I have there:
#!ifndef DBURL #!define DBURL "mysql://kamailio:kamailiorw@localhost/kamailio" #!endif
modparam("topos", "db_url", DBURL) modparam("rtpengine", "db_url", DBURL) modparam("acc", "db_url", DBURL) modparam("usrloc", "db_url", DBURL) modparam("auth_db", "db_url", DBURL) modparam("permissions", "db_url", DBURL) modparam("alias_db", "db_url", DBURL) modparam("domain", "db_url", DBURL) modparam("presence", "db_url", DBURL) modparam("presence_xml", "db_url", DBURL) modparam("uac", "reg_db_url", DBURL); modparam("dispatcher", "db_url", DBURL); modparam("acc", "db_url", DBURL) modparam("usrloc", "db_url", DBURL) modparam("auth_db", "db_url", DBURL) modparam("permissions", "db_url", DBURL) modparam("alias_db", "db_url", DBURL) modparam("speeddial", "db_url", DBURL) modparam("domain", "db_url", DBURL) modparam("presence", "db_url", DBURL) modparam("presence_xml", "db_url", DBURL)
Is there some db_url I should define?
18 янв. 2024 г., в 12:35, Henning Westerholt via sr-users sr-users@lists.kamailio.org написал(а):
Hello,
just to double check, so you are setting a db_url? Maybe you need to change the db_url, refer e.g. to this: https://serverfault.com/questions/337818/how-to-force-mysql-to-connect-by-tc...
Cheers,
Henning
-----Original Message----- From: iglov via sr-users sr-users@lists.kamailio.org Sent: Donnerstag, 18. Januar 2024 11:56 To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Cc: iglov iglov@avalon.land Subject: [SR-Users] Re: How to change uri for db_mysql ?
So, nobody knows where does he get this path from?
16 янв. 2024 г., в 15:33, iglov via sr-users sr-users@lists.kamailio.org
написал(а):
Sup guyz! On debian 12 i have kamailio 5.6.3 and when I try to use
db_mysql module I always get an error: kamailio[2842268]: ERROR: db_mysql [km_my_con.c:163]: db_mysql_new_connection(): driver error: Can't connect to local server through socket '/run/mysqld/mysqld.sock'
I have no idea where it finds this socket cuz I don’t have it and don’t want to.
Where I can change it?
Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the
sender!
Edit mailing list options or unsubscribe:
Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
-
Benoit Panizzon -
Henning Westerholt -
iglov -
mohsen khashei