23 Dec
2017
23 Dec
'17
4:11 a.m.
Hi All,
We are using *Kamailio IMS VM* image and we are able to run HSS(/hss.sh)
successfully. But while running PCSCF (kamailio -f
/usr/local/etc/kamailio/kamailio-pcscf.cfg), we are getting below errors.
0(1772) DEBUG: <core> [db.c:209]: db_bind_mod(): using db bind api for
db_mysql
0(1772) DEBUG: <core> [db.c:314]: db_do_init2(): connection 0x7f208368d1b8
not found in pool
0(1772) DEBUG: db_mysql [km_my_con.c:98]: db_mysql_new_connection():
opening co nnection: mysql://xxxx:xxxx@server.net1.test/pcscf
0(1772) ERROR: db_mysql [km_my_con.c:124]: db_mysql_new_connection():
driver er ror: Access denied for user 'pcscf'(a)'pcscf.net1.test' (using
password: YES)
0(1772) ERROR: <core> [db.c:318]: db_do_init2(): could not add connection
to the pool 0(1772) ERROR: ims_usrloc_pcscf [usrloc_db.c:79]: init_db():
unable to co nnect to the database
0(1772) ERROR: ims_usrloc_pcscf [ul_mod.c:203]: mod_init(): Error
initializing db connection
0(1772) ERROR: <core> [sr_module.c:962]: init_mod(): Error while
initializing module ims_usrloc_pcscf
(/usr/local/lib64/kamailio/modules/ims_usrloc_pcscf.so)
ERROR: error while initializing modules
To fix the above error, we tried below commands
*mysql -u root -p GRANT ALL ON *.* TO root IDENTIFIED BY 'root'; quit*
- replace bind-address in /etc/mysql/my.cnf to 0.0.0.0
But still we are getting the same issue.
Could any one please help us to resolve this issue. Could any one please
guide us the troubleshooting steps.
Thank you so much in advance.
Regards,
-kranti
23 Dec
23 Dec
6:19 a.m.
You should try to set the bind-address in /etc/mysql/my.cnf to the corresponding physical
address.
BR Franz
Von: sr-users [mailto:sr-users-bounces@lists.kamailio.org] Im Auftrag von Kranti Kumar
Gesendet: Samstag, 23. Dezember 2017 04:11
An: Kamailio (SER) - Users Mailing List <sr-users(a)lists.sip-router.org>rg>;
sr-users(a)lists.kamailio.org; raghavender goud <raghu6519(a)gmail.com>
Betreff: [SR-Users] PCSCF Access denied issue
Hi All,
We are using Kamailio IMS VM image and we are able to run HSS(/hss.sh) successfully. But
while running PCSCF (kamailio -f /usr/local/etc/kamailio/kamailio-pcscf.cfg), we are
getting below errors.
0(1772) DEBUG: <core> [db.c:209]: db_bind_mod(): using db bind api for db_mysql
0(1772) DEBUG: <core> [db.c:314]: db_do_init2(): connection 0x7f208368d1b8 not
found in pool
0(1772) DEBUG: db_mysql [km_my_con.c:98]: db_mysql_new_connection(): opening co nnection:
mysql://xxxx:xxxx@server.net1.test/pcscf
0(1772) ERROR: db_mysql [km_my_con.c:124]: db_mysql_new_connection(): driver er ror:
Access denied for user 'pcscf'(a)'pcscf.net1.test' (using password: YES)
0(1772) ERROR: <core> [db.c:318]: db_do_init2(): could not add connection to the
pool 0(1772) ERROR: ims_usrloc_pcscf [usrloc_db.c:79]: init_db(): unable to co nnect to
the database
0(1772) ERROR: ims_usrloc_pcscf [ul_mod.c:203]: mod_init(): Error initializing db
connection
0(1772) ERROR: <core> [sr_module.c:962]: init_mod(): Error while initializing module
ims_usrloc_pcscf (/usr/local/lib64/kamailio/modules/ims_usrloc_pcscf.so)
ERROR: error while initializing modules
To fix the above error, we tried below commands
mysql -u root -p
GRANT ALL ON *.* TO root IDENTIFIED BY 'root';
quit
- replace bind-address in /etc/mysql/my.cnf to 0.0.0.0
But still we are getting the same issue.
Could any one please help us to resolve this issue. Could any one please guide us the
troubleshooting steps.
Thank you so much in advance.
Regards,
-kranti
26 Dec
26 Dec
10:46 a.m.
Hi,
We have modified bind address to Physical address of the server, but still
we have the same error message.
Following is the list of severs and their IP addresses:
HSS- xx.xx.xx.171
PCSCF- xx.xx.xx.175
Could you please help.
Regards,
Raghu
On 23 Dec 2017 10:49, "Franz Edler" <franz.edler(a)kabsi.at> wrote:
You should try to set the bind-address in
/etc/mysql/my.cnf to the
corresponding physical address.
BR Franz
*Von:* sr-users [mailto:sr-users-bounces@lists.kamailio.org] *Im Auftrag
von *Kranti Kumar
*Gesendet:* Samstag, 23. Dezember 2017 04:11
*An:* Kamailio (SER) - Users Mailing List <sr-users(a)lists.sip-router.org>rg>;
sr-users(a)lists.kamailio.org; raghavender goud <raghu6519(a)gmail.com>
*Betreff:* [SR-Users] PCSCF Access denied issue
Hi All,
We are using *Kamailio IMS VM* image and we are able to run HSS(/hss.sh)
successfully. But while running PCSCF (kamailio -f
/usr/local/etc/kamailio/kamailio-pcscf.cfg),
we are getting below errors.
0(1772) DEBUG: <core> [db.c:209]: db_bind_mod(): using db bind api for
db_mysql
0(1772) DEBUG: <core> [db.c:314]: db_do_init2(): connection 0x7f208368d1b8
not found in pool
0(1772) DEBUG: db_mysql [km_my_con.c:98]: db_mysql_new_connection():
opening co nnection: mysql://xxxx:xxxx@server.net1.test/pcscf
0(1772) ERROR: db_mysql [km_my_con.c:124]: db_mysql_new_connection():
driver er ror: Access denied for user 'pcscf'(a)'pcscf.net1.test' (using
password: YES)
0(1772) ERROR: <core> [db.c:318]: db_do_init2(): could not add connection
to the pool 0(1772) ERROR: ims_usrloc_pcscf [usrloc_db.c:79]: init_db():
unable to co nnect to the database
0(1772) ERROR: ims_usrloc_pcscf [ul_mod.c:203]: mod_init(): Error
initializing db connection
0(1772) ERROR: <core> [sr_module.c:962]: init_mod(): Error while
initializing module ims_usrloc_pcscf (/usr/local/lib64/kamailio/
modules/ims_usrloc_pcscf.so)
ERROR: error while initializing modules
To fix the above error, we tried below commands
*mysql -u root -p GRANT ALL ON *.* TO root IDENTIFIED BY 'root';
quit*
- replace bind-address in /etc/mysql/my.cnf to 0.0.0.0
But still we are getting the same issue.
Could any one please help us to resolve this issue. Could any one please
guide us the troubleshooting steps.
Thank you so much in advance.
Regards,
-kranti
28 Dec
28 Dec
6:13 a.m.
Hi, i don't know what pcscf is but it's seems to be a privilege issue.
Have you tried this?
* GRANT ALL privileges ON *.* TO '*pcscf'(a)'pcscf.net1.test'
*IDENTIFIED
BY 'passconfigured';*
**.* should be the database you are trying to connect to. *
*Cheers,*
*Diego*
El El mié, 27 dic. 2017 a las 05:01, Raghavender <raghu6519(a)gmail.com>
escribió:
Hi,
We have modified bind address to Physical address of the server, but still
we have the same error message.
Following is the list of severs and their IP addresses:
HSS- xx.xx.xx.171
PCSCF- xx.xx.xx.175
Could you please help.
Regards,
Raghu
On 23 Dec 2017 10:49, "Franz Edler" <franz.edler(a)kabsi.at> wrote:
You should try to set the bind-address in
/etc/mysql/my.cnf to the
corresponding physical address.
BR Franz
*Von:* sr-users [mailto:sr-users-bounces@lists.kamailio.org] *Im Auftrag
von *Kranti Kumar
*Gesendet:* Samstag, 23. Dezember 2017 04:11
*An:* Kamailio (SER) - Users Mailing List <sr-users(a)lists.sip-router.org>rg>;
sr-users(a)lists.kamailio.org; raghavender goud <raghu6519(a)gmail.com>
*Betreff:* [SR-Users] PCSCF Access denied issue
Hi All,
We are using *Kamailio IMS VM* image and we are able to run HSS(/hss.sh)
successfully. But while running PCSCF (kamailio -f
/usr/local/etc/kamailio/kamailio-pcscf.cfg), we are getting below errors.
0(1772) DEBUG: <core> [db.c:209]: db_bind_mod(): using db bind api for
db_mysql
0(1772) DEBUG: <core> [db.c:314]: db_do_init2(): connection
0x7f208368d1b8 not found in pool
0(1772) DEBUG: db_mysql [km_my_con.c:98]: db_mysql_new_connection():
opening co nnection: mysql://xxxx:xxxx@server.net1.test/pcscf
0(1772) ERROR: db_mysql [km_my_con.c:124]: db_mysql_new_connection():
driver er ror: Access denied for user 'pcscf'(a)'pcscf.net1.test' (using
password: YES)
0(1772) ERROR: <core> [db.c:318]: db_do_init2(): could not add connection
to the pool 0(1772) ERROR: ims_usrloc_pcscf [usrloc_db.c:79]: init_db():
unable to co nnect to the database
0(1772) ERROR: ims_usrloc_pcscf [ul_mod.c:203]: mod_init(): Error
initializing db connection
0(1772) ERROR: <core> [sr_module.c:962]: init_mod(): Error while
initializing module ims_usrloc_pcscf
(/usr/local/lib64/kamailio/modules/ims_usrloc_pcscf.so)
ERROR: error while initializing modules
To fix the above error, we tried below commands
*mysql -u root -p GRANT ALL ON *.* TO root IDENTIFIED BY 'root';
quit*
- replace bind-address in /etc/mysql/my.cnf to 0.0.0.0
But still we are getting the same issue.
Could any one please help us to resolve this issue. Could any one please
guide us the troubleshooting steps.
Thank you so much in advance.
Regards,
-kranti
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
27 Dec
27 Dec
7:06 a.m.
Thank you so much Franz.
As suggested, We have modified bind address to Physical address of the
server, but still we have the same error message.(Access denied for user
'pcscf'(a)'pcscf.net1.test' (using password: YES))
Please fund the attached my.cnf file for your reference.
We tried to bind with 0.0.0.0 , HSS IP and P-CSCF IP.
Following is the list of severs and their IP addresses:
HSS- xx.xx.xx.171
PCSCF- xx.xx.xx.175
Could you please help us to resolve this issue.
Regards,
-kranti
From: Franz Edler <franz.edler(a)kabsi.at>
Date: Sat, Dec 23, 2017 at 10:49 AM
Subject: AW: [SR-Users] PCSCF Access denied issue
To: "Kamailio (SER) - Users Mailing List"
<sr-users(a)lists.kamailio.org>rg>, "Kamailio (SER) - Users Mailing List"
<sr-users(a)lists.sip-router.org>rg>, raghavender goud
<raghu6519(a)gmail.com>
You should try to set the bind-address in /etc/mysql/my.cnf to the
corresponding physical address.
BR Franz
On Sat, Dec 23, 2017 at 8:41 AM, Kranti Kumar <krantikumara(a)gmail.com>
wrote:
Hi All,
We are using *Kamailio IMS VM* image and we are able to run HSS(/hss.sh)
successfully. But while running PCSCF (kamailio -f
/usr/local/etc/kamailio/kamailio-pcscf.cfg),
we are getting below errors.
0(1772) DEBUG: <core> [db.c:209]: db_bind_mod(): using db bind api for
db_mysql
0(1772) DEBUG: <core> [db.c:314]: db_do_init2(): connection 0x7f208368d1b8
not found in pool
0(1772) DEBUG: db_mysql [km_my_con.c:98]: db_mysql_new_connection():
opening co nnection: mysql://xxxx:xxxx@server.net1.test/pcscf
0(1772) ERROR: db_mysql [km_my_con.c:124]: db_mysql_new_connection():
driver er ror: Access denied for user 'pcscf'(a)'pcscf.net1.test' (using
password: YES)
0(1772) ERROR: <core> [db.c:318]: db_do_init2(): could not add connection
to the pool 0(1772) ERROR: ims_usrloc_pcscf [usrloc_db.c:79]: init_db():
unable to co nnect to the database
0(1772) ERROR: ims_usrloc_pcscf [ul_mod.c:203]: mod_init(): Error
initializing db connection
0(1772) ERROR: <core> [sr_module.c:962]: init_mod(): Error while
initializing module ims_usrloc_pcscf (/usr/local/lib64/kamailio/
modules/ims_usrloc_pcscf.so)
ERROR: error while initializing modules
To fix the above error, we tried below commands
*mysql -u root -p GRANT ALL ON *.* TO root IDENTIFIED BY 'root';
quit*
- replace bind-address in /etc/mysql/my.cnf to 0.0.0.0
But still we are getting the same issue.
Could any one please help us to resolve this issue. Could any one please
guide us the troubleshooting steps.
Thank you so much in advance.
Regards,
-kranti
29 Dec
29 Dec
1:57 a.m.
Hi Diego,
We have tried to execute given command to grant all permissions to
database, but still we get the same error.
Regards,
Raghu
On Wed, Dec 27, 2017 at 11:36 AM, Kranti Kumar <krantikumara(a)gmail.com>
wrote:
Thank you so much Franz.
As suggested, We have modified bind address to Physical address of the
server, but still we have the same error message.(Access denied for user
'pcscf'(a)'pcscf.net1.test' (using password: YES))
Please fund the attached my.cnf file for your reference.
We tried to bind with 0.0.0.0 , HSS IP and P-CSCF IP.
Following is the list of severs and their IP addresses:
HSS- xx.xx.xx.171
PCSCF- xx.xx.xx.175
Could you please help us to resolve this issue.
Regards,
-kranti
From: Franz Edler <franz.edler(a)kabsi.at>
Date: Sat, Dec 23, 2017 at 10:49 AM
Subject: AW: [SR-Users] PCSCF Access denied issue
To: "Kamailio (SER) - Users Mailing List" <sr-users(a)lists.kamailio.org>rg>,
"Kamailio (SER) - Users Mailing List" <sr-users(a)lists.sip-router.org>rg>,
raghavender goud <raghu6519(a)gmail.com>
You should try to set the bind-address in /etc/mysql/my.cnf to the
corresponding physical address.
BR Franz
On Sat, Dec 23, 2017 at 8:41 AM, Kranti Kumar <krantikumara(a)gmail.com>
wrote:
Hi All,
We are using *Kamailio IMS VM* image and we are able to run HSS(/hss.sh)
successfully. But while running PCSCF (kamailio -f
/usr/local/etc/kamailio/kamailio-pcscf.cfg), we are getting below errors.
0(1772) DEBUG: <core> [db.c:209]: db_bind_mod(): using db bind api for
db_mysql
0(1772) DEBUG: <core> [db.c:314]: db_do_init2(): connection
0x7f208368d1b8 not found in pool
0(1772) DEBUG: db_mysql [km_my_con.c:98]: db_mysql_new_connection():
opening co nnection: mysql://xxxx:xxxx@server.net1.test/pcscf
0(1772) ERROR: db_mysql [km_my_con.c:124]: db_mysql_new_connection():
driver er ror: Access denied for user 'pcscf'(a)'pcscf.net1.test' (using
password: YES)
0(1772) ERROR: <core> [db.c:318]: db_do_init2(): could not add connection
to the pool 0(1772) ERROR: ims_usrloc_pcscf [usrloc_db.c:79]: init_db():
unable to co nnect to the database
0(1772) ERROR: ims_usrloc_pcscf [ul_mod.c:203]: mod_init(): Error
initializing db connection
0(1772) ERROR: <core> [sr_module.c:962]: init_mod(): Error while
initializing module ims_usrloc_pcscf (/usr/local/lib64/kamailio/mod
ules/ims_usrloc_pcscf.so)
ERROR: error while initializing modules
To fix the above error, we tried below commands
*mysql -u root -p GRANT ALL ON *.* TO root IDENTIFIED BY 'root';
quit*
- replace bind-address in /etc/mysql/my.cnf to 0.0.0.0
But still we are getting the same issue.
Could any one please help us to resolve this issue. Could any one please
guide us the troubleshooting steps.
Thank you so much in advance.
Regards,
-kranti
1:35 p.m.
Hi,
I'm sorry. I thought you did it just for root.
Cheers.
El El vie, 29 dic. 2017 a las 07:32, Raghavender <raghu6519(a)gmail.com>
escribió:
Hi Diego,
We have tried to execute given command to grant all permissions to
database, but still we get the same error.
Regards,
Raghu
On Wed, Dec 27, 2017 at 11:36 AM, Kranti Kumar <krantikumara(a)gmail.com>
wrote:
Thank you so much Franz.
As suggested, We have modified bind address to Physical address of the
server, but still we have the same error message.(Access denied for user
'pcscf'(a)'pcscf.net1.test' (using password: YES))
Please fund the attached my.cnf file for your reference.
We tried to bind with 0.0.0.0 , HSS IP and P-CSCF IP.
Following is the list of severs and their IP addresses:
HSS- xx.xx.xx.171
PCSCF- xx.xx.xx.175
Could you please help us to resolve this issue.
Regards,
-kranti
From: Franz Edler <franz.edler(a)kabsi.at>
Date: Sat, Dec 23, 2017 at 10:49 AM
Subject: AW: [SR-Users] PCSCF Access denied issue
To: "Kamailio (SER) - Users Mailing List" <sr-users(a)lists.kamailio.org>rg>,
"Kamailio (SER) - Users Mailing List" <sr-users(a)lists.sip-router.org>rg>,
raghavender goud <raghu6519(a)gmail.com>
You should try to set the bind-address in /etc/mysql/my.cnf to the
corresponding physical address.
BR Franz
On Sat, Dec 23, 2017 at 8:41 AM, Kranti Kumar <krantikumara(a)gmail.com>
wrote:
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi All,
We are using *Kamailio IMS VM* image and we are able to run
HSS(/hss.sh) successfully. But while running PCSCF (kamailio -f
/usr/local/etc/kamailio/kamailio-pcscf.cfg), we are getting below errors.
0(1772) DEBUG: <core> [db.c:209]: db_bind_mod(): using db bind api for
db_mysql
0(1772) DEBUG: <core> [db.c:314]: db_do_init2(): connection
0x7f208368d1b8 not found in pool
0(1772) DEBUG: db_mysql [km_my_con.c:98]: db_mysql_new_connection():
opening co nnection: mysql://xxxx:xxxx@server.net1.test/pcscf
0(1772) ERROR: db_mysql [km_my_con.c:124]: db_mysql_new_connection():
driver er ror: Access denied for user 'pcscf'(a)'pcscf.net1.test' (using
password: YES)
0(1772) ERROR: <core> [db.c:318]: db_do_init2(): could not add
connection to the pool 0(1772) ERROR: ims_usrloc_pcscf [usrloc_db.c:79]:
init_db(): unable to co nnect to the database
0(1772) ERROR: ims_usrloc_pcscf [ul_mod.c:203]: mod_init(): Error
initializing db connection
0(1772) ERROR: <core> [sr_module.c:962]: init_mod(): Error while
initializing module ims_usrloc_pcscf
(/usr/local/lib64/kamailio/modules/ims_usrloc_pcscf.so)
ERROR: error while initializing modules
To fix the above error, we tried below commands
*mysql -u root -p GRANT ALL ON *.* TO root IDENTIFIED BY 'root';
quit*
- replace bind-address in /etc/mysql/my.cnf to 0.0.0.0
But still we are getting the same issue.
Could any one please help us to resolve this issue. Could any one please
guide us the troubleshooting steps.
Thank you so much in advance.
Regards,
-kranti
2333
days inactive
2339
days old
6 comments
4 participants
participants (4)
-
Diego Nadares -
Franz Edler -
Kranti Kumar -
Raghavender