[SR-Users] PCSCF Access denied issue

[Raghavender]

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 at 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 at 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 at lists.kamailio.org>, "Kamailio (SER) - Users Mailing List" <sr-users at lists.sip-router.org>, raghavender goud <raghu6519 at 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 at 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/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
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20171229/9dfeb2ee/attachment-0001.html>