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'@'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@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@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@lists.sip-router.org>; sr-users@lists.kamailio.org; raghavender goud <raghu6519@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'@'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