Page 1 of 1

Installing Servoy App Server: Catalog and Schema?

PostPosted: Mon Feb 20, 2017 2:29 pm
by Bernd.N
I am currently trying to install my first Servoy application server, closely following the docs from this source:
https://wiki.servoy.com/display/Serv7/Installing+the+Application+Server

I first installed Postgres 7.4.11 and the latest Java 8u121 on the target server.
Then I downloaded the Servoy App Server installation package and started it.

I choosed the third option stating that I already installed postgres separately.

Now I got stuck on the two fields Catalog and Schema in the window below.
What am I supposed to put in there?
servoy_catalog_schema.png
servoy_catalog_schema.png (22.2 KiB) Viewed 3674 times

Re: Installing Servoy App Server: Catalog and Schema?

PostPosted: Mon Feb 20, 2017 4:04 pm
by ROCLASI
Hi Bernd,

Bernd.N wrote:I first installed Postgres 7.4.11...

:shock:


Okay, now you're scaring me.
PostgreSQL 7.4.11 was released on January 9, 2006. I assume you are talking about PostgreSQL 9.4.11. ;)

Bernd.N wrote:Now I got stuck on the two fields Catalog and Schema in the window below.
What am I supposed to put in there?

You can put in <none> in both fields if you didn't setup your own schema.
Also your server URL should include the database name, i.e.; jdbc:postgresql://localhost:5432/myDatabase.

Hope this helps.

Re: Installing Servoy App Server: Catalog and Schema?

PostPosted: Mon Feb 20, 2017 4:12 pm
by Bernd.N
Yes, you are right, it is certainly 9.4.11, I mixed it up with Servoy :?

Re: Installing Servoy App Server: Catalog and Schema?

PostPosted: Mon Feb 20, 2017 4:12 pm
by ROCLASI
Oh wait, you are talking about the installer, not the servoy-admin pages (reading is hard!) :oops:
You can simply leave them empty and no need to add the database name/

Re: Installing Servoy App Server: Catalog and Schema?

PostPosted: Tue Feb 21, 2017 6:20 pm
by Bernd.N
Yes that is also my experience.
When adding a database name at the end of the URL, like bob in our case, the servoy.properties file will contain
server.0.URL=jdbc\:postgresql\://localhost\:5432/bob/servoy_repository
instead of the proper
server.0.URL=jdbc\:postgresql\://localhost\:5432/servoy_repository

Then the proper creation of the repository will certainly fail.