Problem when SOS restarts!

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem when SOS restarts!

kanishk3687
Hello all,

I am facing a strange issue and hoping if anyone could suggest me a solution!

I have a running Tomcat instance (7.0) on my server and I have deployed 52n-sensorweb-sos-bundle-4.3.9 on the Tomcat. I have configured the SOS with my SOS Postgres database and it works perfectly fine. I can access the observations in the client as well as I can visualize them on Helgoland/JS Client.

However, whenever I restart the service (or whenever the server restarts after installing updates), the SOS loses its connection with the database. I have to manually provide the database connection details everytime the service is restarted.

Strangely, I also have a running SOS 4.3.5 on the same server, but that doesn't get affected whenever the service/server restarts.

Could you please suggest what might be an issue and how could I resolve.

Thanks in advance,
Kanishk
Reply | Threaded
Open this post in threaded view
|

Re: Problem when SOS restarts!

Carsten Hollmann
Hi Kanishk,

such a behavior I have not yet observed and it sounds weird.

Because the SOS stores the database connection information in the
datasource.properties files which is stored after the installation and
read after a restart but it would not be deleted by the SOS itself.

The datasource.properties would be removed by the SOS if you execute the
Reset function in the Admin interface.

Have you deployed both SOS instances in the same Tomcat?

Or have you changed the default Tomcat configuration?

Best,
Carsten
_______________________________________________
SWE mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/swe
http://sensorweb.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines
Reply | Threaded
Open this post in threaded view
|

Re: Problem when SOS restarts!

kanishk3687
Hi Carsten,

thank you for your response! It is helpful!

Surprisingly, there is no datasource.properties file in the WEB_INF folder in case of deployed SOS 4.3.9. I guess this is the reason, it asks for the database connection every time I restart. And the datasource.properties file exists in the SOS 4.3.5.

I configured my databases in the same way for both the SOS instances and the set up was successful also. However, I am not sure why the datasource.properties file is not creating in the case of 4.3.9.

Yes - both the instances are running on the same Tomcat and I did not change any default Tomcat configuration.

Any suggestion would be appreciated to solve this issue!

Thanks & best regards,
Kanishk
Reply | Threaded
Open this post in threaded view
|

Re: Problem when SOS restarts!

Carsten Hollmann
Hi Kanishk,

have you checked if the datasource.properties (\WEB-INF folder) was
created after you have executed the installation process?

Since both instances are running in the same tomcat, have you renamed
the war files or have you deployed them with the default name?

Because Tomcat allows the deployment of versioned webapps (##4.3.x) and
only the latest is accessible.

Best,
Carsten
_______________________________________________
SWE mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/swe
http://sensorweb.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines
Reply | Threaded
Open this post in threaded view
|

Re: Problem when SOS restarts!

kanishk3687
Hi Carsten,

Thanks! No - the datasource.properties was never created when I executed the installation process for SOS 4.3.9.

I renamed the WAR file when I deployed the new version. In that case, SOS 4.3.5 was named as 52n-sos-webapp. It was deployed earlier and contains the datasource.properties file, and then SOS 4.3.9 was named as 52n-sos-webapp-v2 and deployed and this did not create the datasource.properties file.

Does that mean, I need to change the deployed application name somewhere else in order to get the properties file?

Thank you,
Kanishk
Reply | Threaded
Open this post in threaded view
|

Re: Problem when SOS restarts!

Carsten Hollmann
Hi Kanishk,

okay, than there should be no conflicts between the deployed SOS instances.

Maybe you try the current version of the SOS [0]and check whether the
same behavior occurs.

Which OS do you use? Linux or Windows?

Best,
Carsten

[0] https://github.com/52North/SOS/releases
_______________________________________________
SWE mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/swe
http://sensorweb.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines