search

OpenIotOrg / openiot

The Open Source Project for the Internet of Things
459 stars 189 forks source link

http://localhost:8080/lsm-light.server/ not working #116

Open Zoya2385 opened 8 years ago

Zoya2385 commented 8 years ago

Hello,

I followed the tutorial to install openIOT. In the step 6, the deployment of the module "Lsm-light Server" is failed :

18:49:27.275 [MSC service thread 1-14] INFO o.o.lsm.pooling.ConnectionManager - Loading property file 18:49:27.291 [MSC service thread 1-14] INFO o.o.lsm.pooling.ConnectionManager - loading database server driver virtuoso.jdbc4.Driver 18:49:48.897 [MSC service thread 1-14] ERROR o.o.lsm.pooling.ConnectionManager - Error making pool: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:virtuoso://lsm.deri.ie:1111/log_enable=2, username = . Terminating connection pool. Original Exception: ------ virtuoso.jdbc4.VirtuosoException: Connection failed: Connection timed out: connect at virtuoso.jdbc4.VirtuosoConnection.connect(Unknown Source) at virtuoso.jdbc4.VirtuosoConnection.connect(Unknown Source) at virtuoso.jdbc4.VirtuosoConnection.(Unknown Source) at virtuoso.jdbc4.Driver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:256) at com.jolbox.bonecp.BoneCP.(BoneCP.java:305) at org.openiot.lsm.pooling.ConnectionManager.init(ConnectionManager.java:75) at org.openiot.lsm.http.ContextListener.contextInitialized(ContextListener.java:33) at org.apache.catalina.core.StandardContext.contextListenerStart(StandardContext.java:3392) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3850) at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:90) at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745)

have you an idea of the problem ?

Zoya2385 commented 8 years ago

When modifying the openiot.properties files as follow, the deployement works :

LSM-LIGHT Properties

lsm-light.server.connection.driver_class=virtuoso.jdbc4.Driver lsm-light.server.connection.url=jdbc:virtuoso://localhost:1111/log_enable=2

lsm-light.server.connection.username=dba lsm-light.server.connection.password=dba lsm-light.server.minConnection=10 lsm-light.server.maxConnection=15 lsm-light.server.acquireRetryAttempts=5

for local virtuoso instance

lsm-light.server.localMetaGraph = http://test/sensormeta# lsm-light.server.localDataGraph = http://test/sensordta#

lsm-light.client.connection.server = #http://localhost:8080/lsm-light.server/

lsm-light.client.openiot.ontology.namespace = #http://openiot.eu/ontology/ns/

lsm-light.client.openiot.resource.namespace = #http://localhost/resource/

then, the second step is the deplyement of the module "Security Management and Server". the deployment of the two war is failed (see the log file in attachement).

The openiot.properties file as follow : ###############################################################

Privacy and Security Module

############################################################### security.lsm.sparql.endpoint=http://localhost:8890/sparql security.lsm.graphURL=http://lsm.deri.ie/OpenIoT/OAuth# security.signup.useCaptcha=true security.automaticServiceSetup=true security.initialize.admin.username=admin

md5 hashed of 'secret': 5ebe2294ecd0e0f08eab7690d2a6ee69

security.initialize.admin.password=secret security.initialize.admin.email=admin@openiot.eu security.initialize.lsmserver.username=lsmuser security.initialize.lsmserver.password=lsmuserpass security.initialize.scheduler.username=scheduleruser security.initialize.scheduler.password=scheduleruserpass security.initialize.sdum.username=sdumruser security.initialize.sdum.password=sdumuserpass security.initialize.xgsn.username=gsnuser security.initialize.xgsn.password=gsnpass security.initialize.cas.prefix=https://localhost:8443/openiot-cas security.initialize.management.prefix=http://localhost:8080/security.management security.initialize.management.secret=openiot-security-manager-app-secret security.initialize.management.key=openiot-security-manager-app security.initialize.reqDef.prefix=http://localhost:8080/ui.requestDefinition security.initialize.reqDef.secret=requestDefinitionUI-secret security.initialize.reqDef.key=requestDefinitionUI security.initialize.reqPres.prefix=http://localhost:8080/ui.requestPresentation security.initialize.reqPres.secret=requestPresentationUI-secret security.initialize.reqPres.key=requestPresentationUI security.initialize.schemaEditor.prefix=http://localhost:8080/ui.schemaeditor security.initialize.schemaEditor.key=schemaEditor security.initialize.schemaEditor.secret=schemaEditor-secret security.initialize.scheduler.key=scheduler security.initialize.scheduler.secret=scheduler.secret security.initialize.sdum.key=sdum security.initialize.sdum.secret=sdum.secret security.initialize.xgsn.key=xgsn security.initialize.xgsn.secret=xgsn.secret

is there a problem in the openiot.properties file ?

How can i modify it?

For the rest of war files, couls you please indicate me the modifications to do in the openiot.properties file to deploy all the war files ?

I'm working on localhost.

nkef commented 8 years ago

Dear Zoya,

Since you are working on localhost you should replace all the properties pointing to "lsm.deri.ie" with the "localhost" (as you corectly did for LSM-Light properties). For example i see that the "security.lsm.graphURL" points to "http://lsm.deri.ie/OpenIoT/OAuth#"

I hope this will help. Nikos.

Zoya2385 commented 8 years ago

Thank you for your answer, i will replace all "lsm.deri.ie" by "localhost". i comment the following lignes to deploy successfully "lsm-light.server.war" :

lsm-light.client.connection.server = #http://localhost:8080/lsm-light.server/

lsm-light.client.openiot.ontology.namespace = #http://openiot.eu/ontology/ns/

lsm-light.client.openiot.resource.namespace = #http://localhost/resource/

is it correct ?

Zoya2385 commented 8 years ago

I replaced all "lsm.deri.ie" by "localhost" (see the openiot.properties in attachement) I always have errors when deploying the two war : lsm-light.server.war and openiot-cas.war. In C:\Program Files\jboss-as-7.1.1.Final\standalone\deployments, i have just the two war : lsm-light.server.war and openiot-cas.war.

Have you an idea of this problem ?

Thank you in advance log.txt

Zoya2385 commented 8 years ago

openiot_properties.txt

jefersonla commented 7 years ago

I have faced this same error and found the solution here https://github.com/OpenIotOrg/openiot/wiki/OpenIoT-Virtual-Box-Image---Documentation , to make this easier, I've created the following snippet with sed that change change all lsm.deri.ie to localhost or OpenIoT.eu db.

sed --in-place \
        -e "s/scheduler\.core\.lsm\.openiotMetaGraph=.*$/scheduler\.core\.lsm\.openiotMetaGraph=http\:\/\/openiot\.eu\/OpenIoT\/sensormeta\#/g" \
        -e "s/scheduler\.core\.lsm\.openiotDataGraph=.*$/scheduler\.core\.lsm\.openiotDataGraph=http\:\/\/openiot\.eu\/OpenIoT\/sensordata#/g" \
        -e "s/scheduler\.core\.lsm\.openiotFunctionalGraph=.*$/scheduler\.core\.lsm\.openiotFunctionalGraph=http\:\/\/openiot.eu\/OpenIoT\/functionaldata#/g" \
        -e "s/scheduler\.core\.lsm\.sparql\.endpoint=.*/scheduler\.core\.lsm\.sparql\.endpoint=http\:\/\/localhost\:8890\/sparql/g" \
        -e "s/scheduler\.core\.lsm\.remote\.server=.*$/scheduler\.core\.lsm\.remote\.server=http\:\/\/localhost\:8080\/lsm-light\.server\//g" \
        -e "s/sdum\.core\.lsm\.openiotFunctionalGraph=.*$/sdum\.core\.lsm\.openiotFunctionalGraph=http\:\/\/openiot\.eu\/OpenIoT\/functionaldata#/g" \
        -e "s/sdum\.core\.lsm\.sparql\.endpoint=.*$/sdum\.core\.lsm\.sparql\.endpoint=http\:\/\/localhost\:8890\/sparql/g" \
        -e "s/sdum\.core\.lsm\.remote\.server=.*$/sdum\.core\.lsm\.remote\.server=http\:\/\/localhost\:8080\/lsm-light.server\//g" \
        -e "s/lsm-light\.server\.connection\.url=.*$/lsm-light\.server\.connection\.url=jdbc\:virtuoso\:\/\/localhost\:1111\/log_enable=2/g" \
        -e "s/lsm-light\.server\.connection\.username=.*$/lsm-light\.server\.connection\.username=dba/g" \
        -e "s/lsm-light\.server\.connection\.password=.*$/lsm-light\.server\.connection\.password=$VIRTUOSO_DBA_PASS/g" \
        -e "s/lsm-light\.server\.localMetaGraph.*$/lsm-light\.server\.localMetaGraph\ =\ http\:\/\/openiot.eu\/OpenIoT\/sensormeta#/g" \
        -e "s/lsm-light\.server\.localDataGraph.*$/lsm-light\.server\.localDataGraph\ =\ http\:\/\/openiot.eu\/OpenIoT\/sensordata#/g" \
        -e "s/lsm\.deri\.ie/localhost\:8080/g" \
        "$JBOSS_HOME/standalone/configuration/openiot.properties"

Despite of the fact that this is inted to be used on virtualbox image, these modifications are needed on the default deploy too.