[SR-Users] Re: How to change uri for db_mysql ?

2024-01-18 Thread iglov via sr-users 
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 
>  написал(а):
> 
> 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  > 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 > > > написал(а):
>> > 
>> > 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 PrattelnFax  +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-le...@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-le...@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-le...@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the 
sender!
Edit mailing list options or unsubscribe:

[SR-Users] Re: How to change uri for db_mysql ?

2024-01-18 Thread mohsen khashei via sr-users 
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 
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 
> написал(а):
> >
> > 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 PrattelnFax  +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-le...@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-le...@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the 
sender!
Edit mailing list options or unsubscribe:

[SR-Users] Re: How to change uri for db_mysql ?

2024-01-18 Thread iglov via sr-users 
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 
>  написал(а):
> 
> 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-tcp-instead-of-a-unix-socket
> 
> Cheers,
> 
> Henning
> 
>> -Original Message-
>> From: iglov via sr-users 
>> Sent: Donnerstag, 18. Januar 2024 11:56
>> To: Kamailio (SER) - Users Mailing List 
>> Cc: iglov 
>> 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 
>> написал(а):
>>> 
>>> 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-le...@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-le...@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-le...@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-le...@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the 
sender!
Edit mailing list options or unsubscribe:

[SR-Users] Re: How to change uri for db_mysql ?

2024-01-18 Thread Henning Westerholt via sr-users 
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-tcp-instead-of-a-unix-socket

Cheers,

Henning

> -Original Message-
> From: iglov via sr-users 
> Sent: Donnerstag, 18. Januar 2024 11:56
> To: Kamailio (SER) - Users Mailing List 
> Cc: iglov 
> 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 
> написал(а):
> >
> > 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-le...@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-le...@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-le...@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the 
sender!
Edit mailing list options or unsubscribe:

[SR-Users] Re: How to change uri for db_mysql ?

2024-01-18 Thread iglov via sr-users 
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  написал(а):
> 
> 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 PrattelnFax  +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-le...@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the 
sender!
Edit mailing list options or unsubscribe:

[SR-Users] Re: How to change uri for db_mysql ?

2024-01-18 Thread Benoit Panizzon via sr-users 
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 PrattelnFax  +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-le...@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the 
sender!
Edit mailing list options or unsubscribe:

[SR-Users] Re: How to change uri for db_mysql ?

2024-01-18 Thread iglov via sr-users 
So, nobody knows where does he get this path from?

> 16 янв. 2024 г., в 15:33, iglov via sr-users  
> написал(а):
> 
> 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-le...@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-le...@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the 
sender!
Edit mailing list options or unsubscribe: