[SR-Users] PCSCF Access denied issue

[Diego Nadares]

Hi,

I'm sorry. I thought you did it just for root.

Cheers.



El El vie, 29 dic. 2017 a las 07:32, Raghavender <raghu6519 at gmail.com>
escribió:

> 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/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/20171229/61bcf38a/attachment-0001.html>