31 Aug
2018
31 Aug
'18
9:07 a.m.
Hi,
In a previous post ([SR-Users] Questions about changes between 5.0.1 and
5.0.7
<https://lists.kamailio.org/pipermail/sr-users/2018-August/102442.html> ), I
reported problem to upgrade my kamailio from 5.0.1 to 5.0.7-7 level.
With help from some people, it was finally fixed on my test server in my
lab.
Now I was expecting to do the same upgrade on a real server using these
packages:
kamailio-5.0.7-7.el7.x86_64.rpm
kamailio-ims-5.0.7-7.el7.x86_64.rpm
kamailio-mysql-5.0.7-7.el7.x86_64.rpm
kamailio-perl-5.0.7-7.el7.x86_64.rpm
kamailio-snmpstats-5.0.7-7.el7.x86_64.rpm
But kamailio failed to connect the local MySQL server :
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
DEBUG: <core> [db.c:209]: db_bind_mod(): using db bind api for db_mysql
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
DEBUG: <core> [db.c:314]: db_do_init2(): connection 0x7fef779958f8 not found
in pool
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
DEBUG: db_mysql [km_my_con.c:98]: db_mysql_new_connection(): opening
connection: mysql://xxxx:xxxx@localhost/siprouter
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
ERROR: db_mysql [km_my_con.c:129]: db_mysql_new_connection(): driver error:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13 "Permission denied")
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
ERROR: <core> [db.c:318]: db_do_init2(): could not add connection to the
pool
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
ERROR: htable [ht_db.c:92]: ht_db_open_con(): failed to connect to the
database
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
ERROR: <core> [core/sr_module.c:974]: init_mod(): Error while initializing
module htable (/usr/lib64/kamailio/modules/htable.so)
My "kamailio.cfg" contains the following command:
modparam("htable", "db_url",
"mysql://siprouter:password@localhost/siprouter")
The service unit : "/usr/lib/systemd/system/kamailio.service" content is :
[Unit]
Description=Kamailio (OpenSER) - the Open Source SIP Server
After=network.target mysql.service
[Service]
Type=simple
User=kamailio
Group=kamailio
Environment='CFGFILE=/etc/kamailio/kamailio.cfg'
Environment='SHM_MEMORY=1024'
Environment='PKG_MEMORY=8'
EnvironmentFile=-/etc/sysconfig/kamailio
ExecStart=/usr/sbin/kamailio -DD -P /var/run/kamailio/kamailio.pid -f
$CFGFILE -m $SHM_MEMORY -M $PKG_MEMORY
Restart=on-failure
[Install]
WantedBy=multi-user.target
The "/etc/sysconfig/kamailio" content is :
#
# Kamailio startup options
#
#
# Kamailio startup options
#
# Set to yes to enable kamailio, once configured properly.
RUN_KAMAILIO=yes
# User to run as
USER=kamailio
# Group to run as
GROUP=kamailio
# Amount of shared memory to allocate for the running Kamailio server (in
Mb)
SHM_MEMORY=1024
# Amount of per-process (package) memory to allocate for Kamailio (in Mb)
PKG_MEMORY=8
Below the existing user in mysql :
mysql:root:(none)> use mysql;
Database changed
mysql:root:mysql> select user,host from user;
+-----------+-----------+
| user | host |
+-----------+-----------+
| myadmin | % |
| siprouter | % |
| kamailio | localhost |
| root | localhost |
+-----------+-----------+
I have a symlink to locate the my.cnf : ln -s /myqdata/mysiprdb/data/my.cnf
/etc/my.cnf
And also this link to fix a htable reload problem : ln -s
/myqdata/mysiprdb/data/mysiprdb.sock /var/lib/mysql/mysql.sock
I don't find what the problem is this time.
So if there is people that could help on the issue, thanks in advance.
Cordialement.
Patrick GINHOUX
31 Aug
31 Aug
7:06 p.m.
Am Freitag, 31. August 2018, 09:07:51 CEST schrieb Ginhoux, Patrick:
In a previous post ([SR-Users] Questions about changes
between 5.0.1 and
5.0.7
<https://lists.kamailio.org/pipermail/sr-users/2018-August/102442.html> ), I
reported problem to upgrade my kamailio from 5.0.1 to 5.0.7-7 level.
With help from some people, it was finally fixed on my test server in my
lab.
Hello Patrick,
the mysql module will usually just give you the error message back from the
server/mysql client library.
Can you try to connect with the "mysql" client command on the command line to
connect to the local server, with the same username/password as in your
Kamailio configuration?
Now I was expecting to do the same upgrade on a real
server using these
packages:
kamailio-5.0.7-7.el7.x86_64.rpm
kamailio-ims-5.0.7-7.el7.x86_64.rpm
kamailio-mysql-5.0.7-7.el7.x86_64.rpm
kamailio-perl-5.0.7-7.el7.x86_64.rpm
kamailio-snmpstats-5.0.7-7.el7.x86_64.rpm
But kamailio failed to connect the local MySQL server :
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
DEBUG: <core> [db.c:209]: db_bind_mod(): using db bind api for db_mysql
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
DEBUG: <core> [db.c:314]: db_do_init2(): connection 0x7fef779958f8 not found
in pool
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
DEBUG: db_mysql [km_my_con.c:98]: db_mysql_new_connection(): opening
connection: mysql://xxxx:xxxx@localhost/siprouter
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
ERROR: db_mysql [km_my_con.c:129]: db_mysql_new_connection(): driver error:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13 "Permission denied")
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
ERROR: <core> [db.c:318]: db_do_init2(): could not add connection to the
pool
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
ERROR: htable [ht_db.c:92]: ht_db_open_con(): failed to connect to the
database
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr /usr/sbin/kamailio[6365]:
ERROR: <core> [core/sr_module.c:974]: init_mod(): Error while initializing
module htable (/usr/lib64/kamailio/modules/htable.so)
My "kamailio.cfg" contains the following command:
modparam("htable", "db_url",
"mysql://siprouter:password@localhost/siprouter")
The service unit : "/usr/lib/systemd/system/kamailio.service" content is :
[Unit]
Description=Kamailio (OpenSER) - the Open Source SIP Server
After=network.target mysql.service
[Service]
Type=simple
User=kamailio
Group=kamailio
Environment='CFGFILE=/etc/kamailio/kamailio.cfg'
Environment='SHM_MEMORY=1024'
Environment='PKG_MEMORY=8'
EnvironmentFile=-/etc/sysconfig/kamailio
ExecStart=/usr/sbin/kamailio -DD -P /var/run/kamailio/kamailio.pid -f
$CFGFILE -m $SHM_MEMORY -M $PKG_MEMORY
Restart=on-failure
[Install]
WantedBy=multi-user.target
The "/etc/sysconfig/kamailio" content is :
#
# Kamailio startup options
#
#
# Kamailio startup options
#
# Set to yes to enable kamailio, once configured properly.
RUN_KAMAILIO=yes
# User to run as
USER=kamailio
# Group to run as
GROUP=kamailio
# Amount of shared memory to allocate for the running Kamailio server (in
Mb)
SHM_MEMORY=1024
# Amount of per-process (package) memory to allocate for Kamailio (in Mb)
PKG_MEMORY=8
Below the existing user in mysql :
mysql:root:(none)> use mysql;
Database changed
mysql:root:mysql> select user,host from user;
+-----------+-----------+
| user | host |
+-----------+-----------+
| myadmin | % |
|
| siprouter | % |
|
| kamailio | localhost |
|
| root | localhost |
+-----------+-----------+
I have a symlink to locate the my.cnf : ln -s /myqdata/mysiprdb/data/my.cnf
/etc/my.cnf
And also this link to fix a htable reload problem : ln -s
/myqdata/mysiprdb/data/mysiprdb.sock /var/lib/mysql/mysql.sock
I don't find what the problem is this time.
So if there is people that could help on the issue, thanks in advance.
Cordialement.
Patrick GINHOUX
--
Henning Westerholt
https://skalatan.de/blog/
9:01 p.m.
New subject: Can't connect to local MySQL server (13 "Permission denied")
Hi Henning,
Usually I connect on a command line like this ;
su- mysql
mysql
use siprouter;
If now I use
mysql -u siprouter -p
Enter password:
mysql:siprouter:(none)> use siprouter;
Database changed
So I can connect the local server.
Cordialement.
Patrick GINHOUX
Unisys | +33 1 46 69 52 12 | +33 6 60 32 24 74 | patrick.ginhoux(a)unisys.com
-----Message d'origine-----
De : Henning Westerholt <hw(a)kamailio.org
Envoyé : vendredi 31 août 2018 19:07
À : sr-users(a)lists.kamailio.org
Cc : Ginhoux, Patrick <patrick.ginhoux(a)fr.unisys.com>
Objet : Re: [SR-Users] Can't connect to local MySQL server (13 "Permission
denied")
Am Freitag, 31. August 2018, 09:07:51 CEST schrieb Ginhoux, Patrick:
In a previous post ([SR-Users] Questions about changes
between 5.0.1 and
5.0.7
<
<https://lists.kamailio.org/pipermail/sr-users/2018-August/102442.html>
https://lists.kamailio.org/pipermail/sr-users/2018-August/102442.html> ), I
reported problem to upgrade my kamailio from 5.0.1 to
5.0.7-7 level.
With help from some people, it was finally fixed on my
test server in my
lab.
Hello Patrick,
the mysql module will usually just give you the error message back from the
server/mysql client library.
Can you try to connect with the "mysql" client command on the command line
to
connect to the local server, with the same username/password as in your
Kamailio configuration?
Now I was expecting to do the same upgrade on a real
server using these
packages:
kamailio-5.0.7-7.el7.x86_64.rpm
kamailio-ims-5.0.7-7.el7.x86_64.rpm
kamailio-mysql-5.0.7-7.el7.x86_64.rpm
kamailio-perl-5.0.7-7.el7.x86_64.rpm
kamailio-snmpstats-5.0.7-7.el7.x86_64.rpm
But kamailio failed to connect the local MySQL server
:
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr
/usr/sbin/kamailio[6365]:
DEBUG: <core> [db.c:209]: db_bind_mod(): using
db bind api for db_mysql
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr
/usr/sbin/kamailio[6365]:
DEBUG: <core> [db.c:314]: db_do_init2():
connection 0x7fef779958f8 not
found
in pool
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr
/usr/sbin/kamailio[6365]:
DEBUG: db_mysql [km_my_con.c:98]:
db_mysql_new_connection(): opening
connection: mysql://xxxx:xxxx@localhost/siprouter
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr
/usr/sbin/kamailio[6365]:
ERROR: db_mysql [km_my_con.c:129]:
db_mysql_new_connection(): driver
error:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13
"Permission denied")
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr
/usr/sbin/kamailio[6365]:
ERROR: <core> [db.c:318]: db_do_init2(): could
not add connection to the
pool
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr
/usr/sbin/kamailio[6365]:
ERROR: htable [ht_db.c:92]: ht_db_open_con(): failed
to connect to the
database
Aug 31 08:16:20 in52inmvt2router1-mvt-tpm-sipr
/usr/sbin/kamailio[6365]:
ERROR: <core> [core/sr_module.c:974]:
init_mod(): Error while initializing
module htable (/usr/lib64/kamailio/modules/htable.so)
My "kamailio.cfg" contains the following
command:
modparam("htable", "db_url",
"mysql://siprouter:password@localhost/siprouter")
The service unit :
"/usr/lib/systemd/system/kamailio.service" content is :
[Unit]
Description=Kamailio (OpenSER) - the Open Source SIP
Server
After=network.target mysql.service
[Service]
Type=simple
User=kamailio
Group=kamailio
Environment='CFGFILE=/etc/kamailio/kamailio.cfg'
Environment='SHM_MEMORY=1024'
Environment='PKG_MEMORY=8'
EnvironmentFile=-/etc/sysconfig/kamailio
ExecStart=/usr/sbin/kamailio -DD -P
/var/run/kamailio/kamailio.pid -f
$CFGFILE -m $SHM_MEMORY -M $PKG_MEMORY
Restart=on-failure
[Install]
WantedBy=multi-user.target
The "/etc/sysconfig/kamailio" content is :
#
# Kamailio startup options
#
#
# Kamailio startup options
#
# Set to yes to enable kamailio, once configured
properly.
RUN_KAMAILIO=yes
# User to run as
USER=kamailio
# Group to run as
GROUP=kamailio
# Amount of shared memory to allocate for the running
Kamailio server (in
Mb)
SHM_MEMORY=1024
# Amount of per-process (package) memory to allocate
for Kamailio (in Mb)
PKG_MEMORY=8
Below the existing user in mysql :
mysql:root:(none)> use mysql;
Database changed
mysql:root:mysql> select user,host from user;
+-----------+-----------+
| user | host |
+-----------+-----------+
| myadmin | % |
|
| siprouter | % |
|
| kamailio | localhost |
|
| root | localhost |
+-----------+-----------+
I have a symlink to locate the my.cnf : ln -s
/myqdata/mysiprdb/data/my.cnf
/etc/my.cnf
And also this link to fix a htable reload problem : ln
-s
/myqdata/mysiprdb/data/mysiprdb.sock
/var/lib/mysql/mysql.sock
I don't find what the problem is this time.
So if there is people that could help on the issue,
thanks in advance.
Cordialement.
Patrick GINHOUX
--
Henning Westerholt
<https://skalatan.de/blog/> https://skalatan.de/blog/
4 Sep
4 Sep
8:34 a.m.
Am Freitag, 31. August 2018, 21:01:13 CEST schrieb Ginhoux, Patrick:
Usually I connect on a command line like this ;
su- mysql
mysql
use siprouter;
If now I use
mysql -u siprouter -p
Enter password:
mysql:siprouter:(none)> use siprouter;
Database changed
So I can connect the local server.
Hello Patrick,
just some ideas to help you troubleshoot the problem:
- maybe there is an issue with the socket file, that kamailio uses the wrong
socket file?
- maybe kamailio don't have file system access rights to the socket file?
- maybe there is a mistake in the kamailio cfg or an old cfg file is used?
- enable mysql server logging and try to spot something in the log during the
kamailio start
Best regards,
Henning
--
Henning Westerholt
https://skalatan.de/blog/
9:39 a.m.
Make sure the password is correct and try with "localhost" and if that
doesn't work, try with 127.0.0.1
On Tue, Sep 4, 2018, 07:35 Henning Westerholt <hw(a)kamailio.org> wrote:
Am Freitag, 31. August 2018, 21:01:13 CEST schrieb
Ginhoux, Patrick:
Usually I connect on a command line like this ;
su- mysql
mysql
use siprouter;
If now I use
mysql -u siprouter -p
Enter password:
mysql:siprouter:(none)> use siprouter;
Database changed
So I can connect the local server.
Hello Patrick,
just some ideas to help you troubleshoot the problem:
- maybe there is an issue with the socket file, that kamailio uses the
wrong
socket file?
- maybe kamailio don't have file system access rights to the socket file?
- maybe there is a mistake in the kamailio cfg or an old cfg file is used?
- enable mysql server logging and try to spot something in the log during
the
kamailio start
Best regards,
Henning
--
Henning Westerholt
https://skalatan.de/blog/
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
9:40 a.m.
You should paste your failing cfg line.
On Tue, Sep 4, 2018, 08:39 David Villasmil <david.villasmil.work(a)gmail.com>
wrote:
Make sure the password is correct and try with
"localhost" and if that
doesn't work, try with 127.0.0.1
On Tue, Sep 4, 2018, 07:35 Henning Westerholt <hw(a)kamailio.org> wrote:
Am Freitag, 31. August 2018, 21:01:13 CEST
schrieb Ginhoux, Patrick:
Usually I connect on a command line like this ;
su- mysql
mysql
use siprouter;
If now I use
mysql -u siprouter -p
Enter password:
mysql:siprouter:(none)> use siprouter;
Database changed
So I can connect the local server.
Hello Patrick,
just some ideas to help you troubleshoot the problem:
- maybe there is an issue with the socket file, that kamailio uses the
wrong
socket file?
- maybe kamailio don't have file system access rights to the socket file?
- maybe there is a mistake in the kamailio cfg or an old cfg file is used?
- enable mysql server logging and try to spot something in the log during
the
kamailio start
Best regards,
Henning
--
Henning Westerholt
https://skalatan.de/blog/
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
10:43 a.m.
New subject: Can't connect to local MySQL server (13 "Permission denied")
Hi,
Looking at your message, I checked again the installation and mainly the symlink I had
created for Kamailio to get the socket file.
For some reason, this link were corrupted. Hereafter what was the issue:
The initial symlink for the socket file was : ln -s /myqdata/mysiprdb/data/mysiprdb.sock
/var/lib/mysql/mysql.sock
But actually a locate command : returns strange
locate *.sock
/myqdata/mysiprdb/data/mysiprdb.sock
/var/lib/gssproxy/default.sock
/var/lib/mysql/mysql.sock
/var/lib/mysql/mysql.sock/mysiprdb.sock
The “/var/lib/mysql/mysql.sock/mysiprdb.sock” doesn’t make sense here.
And the “/var/lib/mysql/mysql.sock” was actually a directoty
[root@in52inmvt2router1 ~]# ll /var/lib/mysql/
total 4
drwx------ 2 root root 4096 Sep 4 10:21 mysql.sock
Removing all of these files/directories, then recreate the symlink have fixed the issue.
Thanks everybody for your ideas of things to check..
Cordialement.
Patrick GINHOUX
Unisys | +33 1 46 69 52 12 | +33 6 60 32 24 74 | patrick.ginhoux(a)unisys.com
De : David Villasmil <david.villasmil.work(a)gmail.com>
Envoyé : mardi 4 septembre 2018 09:41
À : Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>
Cc : Ginhoux, Patrick <patrick.ginhoux(a)fr.unisys.com>
Objet : Re: [SR-Users] Can't connect to local MySQL server (13 "Permission
denied")
You should paste your failing cfg line.
On Tue, Sep 4, 2018, 08:39 David Villasmil <david.villasmil.work(a)gmail.com
<mailto:david.villasmil.work@gmail.com> > wrote:
Make sure the password is correct and try with "localhost" and if that
doesn't work, try with 127.0.0.1
On Tue, Sep 4, 2018, 07:35 Henning Westerholt <hw(a)kamailio.org
<mailto:hw@kamailio.org> > wrote:
Am Freitag, 31. August 2018, 21:01:13 CEST schrieb Ginhoux, Patrick:
Usually I connect on a command line like this ;
su- mysql
mysql
use siprouter;
If now I use
mysql -u siprouter -p
Enter password:
mysql:siprouter:(none)> use siprouter;
Database changed
So I can connect the local server.
Hello Patrick,
just some ideas to help you troubleshoot the problem:
- maybe there is an issue with the socket file, that kamailio uses the wrong
socket file?
- maybe kamailio don't have file system access rights to the socket file?
- maybe there is a mistake in the kamailio cfg or an old cfg file is used?
- enable mysql server logging and try to spot something in the log during the
kamailio start
Best regards,
Henning
--
Henning Westerholt
https://skalatan.de/blog/
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org>
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
2065
days inactive
2069
days old
6 comments
3 participants
participants (3)
-
David Villasmil -
Ginhoux, Patrick -
Henning Westerholt