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@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'@'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@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@lists.kamailio.org>, "Kamailio (SER) - Users Mailing List" <sr-users@lists.sip-router.org>, raghavender goud <raghu6519@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@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'@'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@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users