Re: [SR-Users] PCSCF Access denied issue

2017-12-22 Thread Franz Edler 
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

Re: [SR-Users] Kamailio-IMS VM image issue

2017-12-20 Thread Franz Edler 
But the error log „Cannot assign requested address:8080” says different.

There must be a process which already uses port 8080. Check with a proper Linux 
command.

 

Franz

 

Von: ponnam.g...@wipro.com [mailto:ponnam.g...@wipro.com] 
Gesendet: Mittwoch, 20. Dezember 2017 08:51
An: 'Franz Edler' <franz.ed...@kabsi.at>; 'Kranti Kumar' 
<krantikum...@gmail.com>; 'Kamailio (SER) - Users Mailing List' 
<sr-us...@lists.sip-router.org>
Cc: 'raghavender goud' <raghu6...@gmail.com>
Betreff: RE: Kamailio-IMS VM image issue

 

Hi Franz,

 

Thank you so much for the reply.

 

We have verified mysql db permissions, could not find issue with access 
permissions. Following is the output on console when we try to execute hss.sh 
script

 

root@server:~# ./hss.sh

Building Classpath

Classpath is 
lib/xml-apis.jar:lib/xercesImpl.jar:lib/xerces-2.4.0.jar:lib/xalan-2.4.0.jar:lib/tomcat-util.jar:lib/tomcat-http.jar:lib/tomcat-coyote.jar:lib/struts.jar:lib/servlets-default.jar:lib/servlet-api.jar:lib/naming-resources.jar:lib/naming-factory.jar:lib/mysql-connector-java-3.1.12-bin.jar:lib/mx4j-3.0.1.jar:lib/log4j.jar:lib/junit.jar:lib/junitee.jar:lib/jta.jar:lib/jsp-api.jar:lib/jmx.jar:lib/jdp.jar:lib/jasper-runtime.jar:lib/jasper-compiler-jdt.jar:lib/jasper-compiler.jar:lib/hibernate3.jar:lib/FHoSS.jar:lib/ehcache-1.1.jar:lib/dom4j-1.6.1.jar:lib/commons-validator.jar:lib/commons-modeler.jar:lib/commons-logging.jar:lib/commons-logging-1.0.4.jar:lib/commons-lang.jar:lib/commons-fileupload.jar:lib/commons-el.jar:lib/commons-digester.jar:lib/commons-collections-3.1.jar:lib/commons-beanutils.jar:lib/cglib-2.1.3.jar:lib/catalina-optional.jar:lib/catalina.jar:lib/c3p0-0.9.1.jar:lib/base64.jar:lib/asm.jar:lib/asm-attrs.jar:lib/antlr-2.7.6.jar::log4j.properties:..

2017-12-20 08:15:58,551 INFO  de.fhg.fokus.hss.main.TomcatServer - startTomcat 
Tomcat-Server is started.

2017-12-20 08:16:10,188 ERROR org.apache.coyote.http11.Http11Protocol - init 
Error initializing endpoint

java.net.BindException: Cannot assign requested address:8080

at 
org.apache.tomcat.util.net.PoolTcpEndpoint.initEndpoint(PoolTcpEndpoint.java:297)

at org.apache.coyote.http11.Http11Protocol.init(Http11Protocol.java:142)

at 
org.apache.catalina.connector.Connector.initialize(Connector.java:928)

at org.apache.catalina.startup.Embedded.start(Embedded.java:794)

at de.fhg.fokus.hss.main.TomcatServer.startTomcat(TomcatServer.java:128)

at de.fhg.fokus.hss.main.HSSContainer.(HSSContainer.java:74)

at de.fhg.fokus.hss.main.HSSContainer.main(HSSContainer.java:110)

2017-12-20 08:16:10,291 ERROR de.fhg.fokus.hss.main.HSSContainer -  
Exception occured during starting Tomcat!

Exiting from HSS...

LifecycleException:  Protocol handler initialization failed: 
java.net.BindException: Cannot assign requested address:8080

at 
org.apache.catalina.connector.Connector.initialize(Connector.java:930)

at org.apache.catalina.startup.Embedded.start(Embedded.java:794)

at de.fhg.fokus.hss.main.TomcatServer.startTomcat(TomcatServer.java:128)

at de.fhg.fokus.hss.main.HSSContainer.(HSSContainer.java:74)

at de.fhg.fokus.hss.main.HSSContainer.main(HSSContainer.java:110)

 

All servers(HSS, PCSCF, SCSCF, ICSCF) can communicate with each other and on 
HSS server no other service is using port 8080. Could you please guide us to 
resolve this issue?

 

 

Regards,

Raghavender

 

From: Franz Edler [mailto:franz.ed...@kabsi.at] 
Sent: Wednesday, December 20, 2017 2:01 AM
To: 'Kranti Kumar' <krantikum...@gmail.com <mailto:krantikum...@gmail.com> >; 
'Kamailio (SER) - Users Mailing List' <sr-us...@lists.sip-router.org 
<mailto:sr-us...@lists.sip-router.org> >
Cc: 'raghavender goud' <raghu6...@gmail.com <mailto:raghu6...@gmail.com> >; 
Ponnam Raghavender Goud (NEPC) <ponnam.g...@wipro.com 
<mailto:ponnam.g...@wipro.com> >
Subject: AW: Kamailio-IMS VM image issue

 

** This mail has been sent from an external source. Treat hyperlinks and 
attachments in this email with caution**

Hi Kranti,

 

you obviously have an error in the mysql configuration.

When you changed some parameters in the architecture you have to adapt also the 
configuration parameters.

Look at the access permissions for MySQL.

 

Von: Kranti Kumar [mailto:krantikum...@gmail.com] 
Gesendet: Dienstag, 19. Dezember 2017 17:35
An: Kamailio (SER) - Users Mailing List <sr-us...@lists.sip-router.org 
<mailto:sr-us...@lists.sip-router.org> >; franz.ed...@technikum-wien.at 
<mailto:franz.ed...@technikum-wien.at> ; franz.ed...@kabsi.at 
<mailto:franz.ed...@kabsi.at> 
Cc: raghavender goud <raghu6...@gmail.com <mailto:raghu6...@gmail.com> >; 
ponnam.g...@wipro.com <mailto:ponnam.g...@wipro.com> 
Betreff: Kamailio-IMS VM image issue

 

Hi,

I’m trying to build a testbed using the VMware image you kindly have shared