Re: [SR-Users] PCSCF Access denied issue
Hi, I'm sorry. I thought you did it just for root. Cheers. El El vie, 29 dic. 2017 a las 07:32, Raghavender 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 > 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 >> Date: Sat, Dec 23, 2017 at 10:49 AM >> Subject: AW: [SR-Users] PCSCF Access denied issue >> To: "Kamailio (SER) - Users Mailing List" , >> "Kamailio (SER) - Users Mailing List" , >> raghavender goud >> >> >> 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 >> 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: [db.c:209]: db_bind_mod(): using db bind api for >>> db_mysql >>> >>> 0(1772) DEBUG: [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://: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: [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: [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 -pGRANT 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 > ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] PCSCF Access denied issue
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 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 > Date: Sat, Dec 23, 2017 at 10:49 AM > Subject: AW: [SR-Users] PCSCF Access denied issue > To: "Kamailio (SER) - Users Mailing List" , > "Kamailio (SER) - Users Mailing List" , > raghavender goud > > > 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 > 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: [db.c:209]: db_bind_mod(): using db bind api for >> db_mysql >> >> 0(1772) DEBUG: [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://: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: [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: [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 -pGRANT 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
Re: [SR-Users] PCSCF Access denied issue
Hi, i don't know what pcscf is but it's seems to be a privilege issue. Have you tried this? *GRANT ALL privileges ON *.* TO '*pcscf'@'pcscf.net1.test' *IDENTIFIED BY 'passconfigured';* **.* should be the database you are trying to connect to. * *Cheers,* *Diego* El El mié, 27 dic. 2017 a las 05:01, Raghavender escribió: > Hi, > > We have modified bind address to Physical address of the server, but still > we have the same error message. > > Following is the list of severs and their IP addresses: > HSS- xx.xx.xx.171 > PCSCF- xx.xx.xx.175 > > > Could you please help. > > > > Regards, > Raghu > > > On 23 Dec 2017 10:49, "Franz Edler" wrote: > >> You should try to set the bind-address in /etc/mysql/my.cnf to the >> corresponding physical address. >> >> >> >> BR Franz >> >> >> >> *Von:* sr-users [mailto:sr-users-boun...@lists.kamailio.org] *Im Auftrag >> von *Kranti Kumar >> *Gesendet:* Samstag, 23. Dezember 2017 04:11 >> *An:* Kamailio (SER) - Users Mailing List ; >> sr-users@lists.kamailio.org; raghavender goud >> *Betreff:* [SR-Users] PCSCF Access denied issue >> >> >> >> 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: [db.c:209]: db_bind_mod(): using db bind api for >> db_mysql >> >> 0(1772) DEBUG: [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://: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: [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: [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 -pGRANT 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 > ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] PCSCF Access denied issue
Hi, We have modified bind address to Physical address of the server, but still we have the same error message. Following is the list of severs and their IP addresses: HSS- xx.xx.xx.171 PCSCF- xx.xx.xx.175 Could you please help. Regards, Raghu On 23 Dec 2017 10:49, "Franz Edler" wrote: > You should try to set the bind-address in /etc/mysql/my.cnf to the > corresponding physical address. > > > > BR Franz > > > > *Von:* sr-users [mailto:sr-users-boun...@lists.kamailio.org] *Im Auftrag > von *Kranti Kumar > *Gesendet:* Samstag, 23. Dezember 2017 04:11 > *An:* Kamailio (SER) - Users Mailing List ; > sr-users@lists.kamailio.org; raghavender goud > *Betreff:* [SR-Users] PCSCF Access denied issue > > > > 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: [db.c:209]: db_bind_mod(): using db bind api for > db_mysql > > 0(1772) DEBUG: [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://: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: [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: [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 -pGRANT 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
Re: [SR-Users] PCSCF Access denied issue
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 Date: Sat, Dec 23, 2017 at 10:49 AM Subject: AW: [SR-Users] PCSCF Access denied issue To: "Kamailio (SER) - Users Mailing List" , "Kamailio (SER) - Users Mailing List" , raghavender goud 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 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: [db.c:209]: db_bind_mod(): using db bind api for > db_mysql > > 0(1772) DEBUG: [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://: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: [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: [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 -pGRANT 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 > # # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # For explanations see # http://dev.mysql.com/doc/mysql/en/server-system-variables.html # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes # escpecially if they contain "#" chars... # Remember to edit /etc/mysql/debian.cnf when changing the socket location. [client] port= 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice= 0 [mysqld] # # * Basic Settings # user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address= 10.200.8.175 #bind-address = 0.0.0.0 #bind-address = 10.0.0.10 #bind-address = 10.0.0.11 #bind-address = 10.0.0.12 # # * Fine Tuning # key_buffer = 16M max_allowed_packet = 16M thread_stack= 192K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover = BACKUP #max_connections= 100 #table_cache= 64 #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_limit = 1M query_cache_size= 16M # # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. # As of
Re: [SR-Users] PCSCF Access denied issue
You should try to set the bind-address in /etc/mysql/my.cnf to the corresponding physical address. BR Franz Von: sr-users [mailto:sr-users-boun...@lists.kamailio.org] Im Auftrag von Kranti Kumar Gesendet: Samstag, 23. Dezember 2017 04:11 An: Kamailio (SER) - Users Mailing List ; sr-users@lists.kamailio.org; raghavender goud Betreff: [SR-Users] PCSCF Access denied issue 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: [db.c:209]: db_bind_mod(): using db bind api for db_mysql 0(1772) DEBUG: [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://: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: [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: [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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
[SR-Users] PCSCF Access denied issue
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: [db.c:209]: db_bind_mod(): using db bind api for db_mysql 0(1772) DEBUG: [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://: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: [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: [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 -pGRANT 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