[SR-Users] PCSCF Access denied issue

[Diego Nadares]

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 at 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 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
>>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20171228/0c19f34b/attachment.html>