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 <krantikum...@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.ed...@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@lists.kamailio.org>, > "Kamailio (SER) - Users Mailing List" <sr-us...@lists.sip-router.org>, > raghavender goud <raghu6...@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 <krantikum...@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:x...@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 >> > >
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users