Page 1 of 1

Trouble installing application server as a service

PostPosted: Mon Jun 13, 2016 1:32 pm
by irene.meyer1422261887
Hi,

I'm trying to install Servoy application server as a service on a Windows Server and I encounter several problems:

1. If I try to install EDB i get a message from Postgres Installer "Could not launch the installer".
2. If I install the bundled database and check "service" i get following message at the end of the installation.

Screen Shot 2016-06-13 at 13.04.48.png
Screen Shot 2016-06-13 at 13.04.48.png (29.14 KiB) Viewed 3983 times


Any clou what could be the problem?

Irene

Re: Trouble installing application server as a service

PostPosted: Mon Jun 13, 2016 1:55 pm
by patrick
Sounds like you have no rights to install a service. Try running the installer as administrator.

Re: Trouble installing application server as a service

PostPosted: Mon Jun 13, 2016 2:29 pm
by irene.meyer1422261887
Thank you Patrik,

It worked. Even if I don't understand it, I have admin privileges on the server I could install Tomcat and other stuf without problems. It have probably something to do with my poor knowledge of Windows. :D

Just another question, if I want to install Servoy in the Program Files I get a warning that it is not recommended, it seems to me the place to install an application. What directory would be recommended?

Thank you for the support.
Irene

Re: Trouble installing application server as a service

PostPosted: Mon Jun 13, 2016 4:29 pm
by irene.meyer1422261887
Ok, next problem...

I want to start the PostgreSQL service in the service panlel but it start and stops immediately with following message:

Screen Shot 2016-06-13 at 16.28.23.png
Screen Shot 2016-06-13 at 16.28.23.png (11.49 KiB) Viewed 3958 times

Re: Trouble installing application server as a service

PostPosted: Mon Jun 13, 2016 8:40 pm
by lwjwillemsen
Check the postgres_log.txt file.

Re: Trouble installing application server as a service

PostPosted: Tue Jun 14, 2016 2:48 pm
by irene.meyer1422261887
Hi Lambert,

the logs says nothing, is empty. If I start the database manually it's working, but the service just refuses.

Re: Trouble installing application server as a service

PostPosted: Tue Jun 14, 2016 3:01 pm
by ROCLASI
Hi Irene,

Sometimes the EDB installer can't initialize the database cluster and therefor the PostgreSQL service has nothing to manage and quits.
Can you check if you have anything in your data directory? It usually can be found under C:\Program Files (x86)\PostgreSQL\<PgVersion>\data.
So if you installed PostgreSQL 9.5 then the path is C:\Program Files (x86)\PostgreSQL\9.5\data.

If it doesn't have anything in there you can initialize it manually via the command line or perhaps you can uninstall and reinstall it again (run the installer as administrator).

Hope this helps.

Re: Trouble installing application server as a service

PostPosted: Tue Jun 14, 2016 3:16 pm
by irene.meyer1422261887
Hi Robert,

I didn't install EDB because the Servoy installer wouldn't let me, the message was "Couldn't launch the installer". So I installed the embedded database. I'm not a Windows guru but in the past I did it a few times and it worked without problems.

I checked the Event Viewer and it seems that he is looking for a file at the wrong place.

Screen Shot 2016-06-14 at 15.09.41.png
Screen Shot 2016-06-14 at 15.09.41.png (58.79 KiB) Viewed 3908 times


Thanks for the help

Irene

Re: Trouble installing application server as a service

PostPosted: Tue Jun 14, 2016 3:24 pm
by ROCLASI
Hi Irene,

Be aware that the Servoy bundled PostgreSQL is only recommended for development use. Not for production.
I suggest you download the EDB installer and right-click on the installer to run it as administrator.

Re: Trouble installing application server as a service

PostPosted: Tue Jun 14, 2016 3:58 pm
by lwjwillemsen
Hi Robert,

Where can I read the official Servoy recommendation for Postgresql use in Developer / Application server?

Re: Trouble installing application server as a service

PostPosted: Tue Jun 14, 2016 4:35 pm
by patrick
https://wiki.servoy.com/display/tutoria ... PostgreSQL

There it says:

Which installation to choose
For production purposes, it's advised to use the EnterpriseDb Standard Server installer. For development and test purposes, both the embedded PostgreSQL database engine and the EnterpriseDB option would be sufficient.

Re: Trouble installing application server as a service

PostPosted: Tue Jun 14, 2016 4:51 pm
by ROCLASI
Hi Irene,

EnterpriseDB (EDB) has some commercial products as well so make sure you download the community installer.
You can find this PostgreSQL community installer here:
http://www.enterprisedb.com/products-se ... pgdownload


Hope this helps.

Re: Trouble installing application server as a service

PostPosted: Tue Jun 14, 2016 5:06 pm
by irene.meyer1422261887
Thank you Robert,

Thankfully I did download and installed the right one. but now I'm a bit lost in space.
The service is running and I can open it in PGAdmin

I followed the instructions of https://wiki.servoy.com/display/public/ ... +Databases but when I execute the command {servoyInstall}/application_server/postgres_db/bin/psql postgres DBA it ask for a password. I created a login role DBA without password but it wont swallow it.

Following the instructions on viewtopic.php?f=5&t=16027&p=86430&hilit=password+dba#p86430 doesn't work either.

What's next?

Re: Trouble installing application server as a service

PostPosted: Tue Jun 14, 2016 5:45 pm
by ROCLASI
Hi Irene,

It means that it won't allow use without a password. Something that is set in the pg_hba.conf file (located in the data directory).
But why use a username without a password ? Especially in production environments you want to secure your database.

Re: Trouble installing application server as a service

PostPosted: Wed Jun 15, 2016 10:34 am
by irene.meyer1422261887
Hi Robert, Patrik and Lambert,

Finally it is working. Thank you all so much for your help.

Cheers
Irene