16 Jan
2024
16 Jan
'24
3:33 p.m.
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?
18 Jan
18 Jan
11:55 a.m.
So, nobody knows where does he get this path from?
16 янв. 2024 г., в 15:33, iglov via sr-users
<sr-users(a)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(a)lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
12:18 p.m.
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
______________________________________________________
12:33 p.m.
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(a)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
______________________________________________________
1:56 p.m.
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(a)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(a)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(a)lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to
the sender!
Edit mailing list options or unsubscribe:
3:06 p.m.
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(a)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(a)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 :(
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe: 18 янв. 2024 г., в 12:18, Benoit Panizzon
<benoit.panizzon(a)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(a)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: 
12:35 p.m.
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-t…
Cheers,
Henning
-----Original Message-----
From: iglov via sr-users <sr-users(a)lists.kamailio.org>
Sent: Donnerstag, 18. Januar 2024 11:56
To: Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>
Cc: iglov <iglov(a)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(a)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(a)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(a)lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the
sender!
Edit mailing list options or unsubscribe:
1 p.m.
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(a)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-t…
Cheers,
Henning
-----Original Message-----
From: iglov via sr-users <sr-users(a)lists.kamailio.org>
Sent: Donnerstag, 18. Januar 2024 11:56
To: Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>
Cc: iglov <iglov(a)avalon.land>
Subject: [SR-Users] Re: How to change uri for db_mysql ?
So, nobody knows where does he get this path from?
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe: 16 янв. 2024 г., в 15:33, iglov via sr-users
<sr-users(a)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(a)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(a)lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the
sender!
Edit mailing list options or unsubscribe:
123
days inactive
125
days old
7 comments
4 participants
participants (4)
-
Benoit Panizzon -
Henning Westerholt -
iglov -
mohsen khashei