Trouble installing application server as a service

Q&A regarding installation and issues getting started with Servoy

Trouble installing application server as a service

Postby irene.meyer1422261887 » Mon Jun 13, 2016 1:32 pm

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 12318 times


Any clou what could be the problem?

Irene
User avatar
irene.meyer1422261887
 
Posts: 34
Joined: Mon Jan 26, 2015 10:44 am

Re: Trouble installing application server as a service

Postby patrick » Mon Jun 13, 2016 1:55 pm

Sounds like you have no rights to install a service. Try running the installer as administrator.
Patrick Ruhsert
Servoy DACH
patrick
 
Posts: 3703
Joined: Wed Jun 11, 2003 10:33 am
Location: Munich, Germany

Re: Trouble installing application server as a service

Postby irene.meyer1422261887 » Mon Jun 13, 2016 2:29 pm

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
User avatar
irene.meyer1422261887
 
Posts: 34
Joined: Mon Jan 26, 2015 10:44 am

Re: Trouble installing application server as a service

Postby irene.meyer1422261887 » Mon Jun 13, 2016 4:29 pm

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 12293 times
User avatar
irene.meyer1422261887
 
Posts: 34
Joined: Mon Jan 26, 2015 10:44 am

Re: Trouble installing application server as a service

Postby lwjwillemsen » Mon Jun 13, 2016 8:40 pm

Check the postgres_log.txt file.
Lambert Willemsen
Vision Development BV
lwjwillemsen
 
Posts: 680
Joined: Sat Mar 14, 2009 5:39 pm
Location: The Netherlands

Re: Trouble installing application server as a service

Postby irene.meyer1422261887 » Tue Jun 14, 2016 2:48 pm

Hi Lambert,

the logs says nothing, is empty. If I start the database manually it's working, but the service just refuses.
User avatar
irene.meyer1422261887
 
Posts: 34
Joined: Mon Jan 26, 2015 10:44 am

Re: Trouble installing application server as a service

Postby ROCLASI » Tue Jun 14, 2016 3:01 pm

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Trouble installing application server as a service

Postby irene.meyer1422261887 » Tue Jun 14, 2016 3:16 pm

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 12243 times


Thanks for the help

Irene
User avatar
irene.meyer1422261887
 
Posts: 34
Joined: Mon Jan 26, 2015 10:44 am

Re: Trouble installing application server as a service

Postby ROCLASI » Tue Jun 14, 2016 3:24 pm

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Trouble installing application server as a service

Postby lwjwillemsen » Tue Jun 14, 2016 3:58 pm

Hi Robert,

Where can I read the official Servoy recommendation for Postgresql use in Developer / Application server?
Lambert Willemsen
Vision Development BV
lwjwillemsen
 
Posts: 680
Joined: Sat Mar 14, 2009 5:39 pm
Location: The Netherlands

Re: Trouble installing application server as a service

Postby patrick » Tue Jun 14, 2016 4:35 pm

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.
Patrick Ruhsert
Servoy DACH
patrick
 
Posts: 3703
Joined: Wed Jun 11, 2003 10:33 am
Location: Munich, Germany

Re: Trouble installing application server as a service

Postby ROCLASI » Tue Jun 14, 2016 4:51 pm

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Trouble installing application server as a service

Postby irene.meyer1422261887 » Tue Jun 14, 2016 5:06 pm

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?
User avatar
irene.meyer1422261887
 
Posts: 34
Joined: Mon Jan 26, 2015 10:44 am

Re: Trouble installing application server as a service

Postby ROCLASI » Tue Jun 14, 2016 5:45 pm

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Trouble installing application server as a service

Postby irene.meyer1422261887 » Wed Jun 15, 2016 10:34 am

Hi Robert, Patrik and Lambert,

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

Cheers
Irene
User avatar
irene.meyer1422261887
 
Posts: 34
Joined: Mon Jan 26, 2015 10:44 am


Return to I'm just getting started

Who is online

Users browsing this forum: No registered users and 1 guest

cron