Hi,
I’m trying to install Servoy application server as a service on a Windows Server and I encounter several problems:
[attachment=0]Screen Shot 2016-06-13 at 13.04.48.png[/attachment]
Any clou what could be the problem?
Irene
Sounds like you have no rights to install a service. Try running the installer as administrator.
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.
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
Ok, next problem…
I want to start the PostgreSQL service in the service panlel but it start and stops immediately with following message:
[attachment=0]Screen Shot 2016-06-13 at 16.28.23.png[/attachment]
Check the postgres_log.txt file.
Hi Lambert,
the logs says nothing, is empty. If I start the database manually it’s working, but the service just refuses.
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.
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.
[attachment=0]Screen Shot 2016-06-14 at 15.09.41.png[/attachment]
Thanks for the help
Irene
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.
Hi Robert,
Where can I read the official Servoy recommendation for Postgresql use in Developer / Application server?
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.
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.
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?
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.
Hi Robert, Patrik and Lambert,
Finally it is working. Thank you all so much for your help.
Cheers
Irene
