29 Dec
2017
29 Dec
'17
11:35 p.m.
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(a)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(a)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'(a)'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(a)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(a)lists.kamailio.org>rg>,
"Kamailio (SER) - Users Mailing List" <sr-users(a)lists.sip-router.org>rg>,
raghavender goud <raghu6519(a)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(a)gmail.com>
wrote:
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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'(a)'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