[SR-Users] PCSCF Access denied issue

[Raghavender]

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 at 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 at lists.kamailio.org] *Im Auftrag
> von *Kranti Kumar
> *Gesendet:* Samstag, 23. Dezember 2017 04:11
> *An:* Kamailio (SER) - Users Mailing List <sr-users at lists.sip-router.org>;
> sr-users at lists.kamailio.org; raghavender goud <raghu6519 at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20171226/bde5597b/attachment-0001.html>