Hi, I'm sorry. I thought you did it just for root.
Cheers. El El vie, 29 dic. 2017 a las 07:32, Raghavender <[email protected]> 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 <[email protected]> > 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 <[email protected]> >> Date: Sat, Dec 23, 2017 at 10:49 AM >> Subject: AW: [SR-Users] PCSCF Access denied issue >> To: "Kamailio (SER) - Users Mailing List" <[email protected]>, >> "Kamailio (SER) - Users Mailing List" <[email protected]>, >> raghavender goud <[email protected]> >> >> >> 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 <[email protected]> >> 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:[email protected]/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 > [email protected] > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >
_______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
