I install Servoy 5.2.1 in a Windows Server 2003 to test my solution,
the installation works OK , but when I run servoy_server.bat the server don’t start
and reports a problem with the database , when I go in the directory application_server
the database directory is empty , the postgres database isn’t installed.
When I install the application server in Windows XP all works OK.
Has someone this problem ? , it’s necesary doing something special to deploy the solution.
Thanks Armin Kessler
Servoy 5.2.1
Java 1.6.0_18-b07
Windows Server 2003
I’m installing Servoy 5.2.1 on the same machine where I installed Servoy 5.1.0 , Servoy 5.1.0
works OK , but Servoy 5.2.1 don’t work ( Directory database is empty ) , in this machine the
operating system is Windows Server 2003 . The user for the installation is Administrator,
the directory for installation was c:\Archivos de programa\Servoy 521
When I install Servoy 5.2.1 in Windows XP all works OK , and servoy application server starts OK.
I also install Servoy 5.2.1 in a machine with Windows 7 and all works OK.
Tomorrow morning I install Servoy 5.2.1 in a machine with Windows Server 2008 R2 and have the same
problem, the installation works OK and do not report errors but the database directory is empty.
The user was idem Administrator and the directory c:\Program files (x86)\Servoy 521
I think that Servoy 5.2.1 has problem installing postgres in Windows Server 2003 / 2008 R2.
I installed Servoy 5.2.1 on Windows Server 2003 this morning in the directory C:\Aplicaciones\Servoy_521
and database directory is empty ( see image attached ).
I read in the forum that Microsoft visual C++ 2005 redistributable must be installed , and I check in the
control panel / installed programs and it is installed.
A observation: In the installation process , step 11/11 take much time compared with the isntallation of
Servoy 5.1.0 , but do not reports error.
that is weird, if step 11 does take a lot of time, then it should generate the db’s
because that is what we do then as far as i know.
We will try to check this out.
If you are actually installing Servoy on a real server, you should NOT include database on the installation. Servoy just includes it for developer’s convenience. My recommendation is to install Servoy without the database. Then download posgtreSQL separately and install it. That will allow postgres to install things into the server where they belong. In addition, it will also install the postgres windows service for you, so you can easily set Servoy and Postgres to run automatically on startup. Lastly, the recommended configuration for any database related app (especially on Windows), is to install the database on a separate drive to limit fragmentation. So Servoy should go in C:\Program Files, and then Postgres database storage should be on the D:. Otherwise you’ll be defragmenting a lot more.
After you install both, you’ll need to manually create the repository database in Postgres using PGAdmin, then open Servoy Developer and add the repository connection, then restart developer and it will setup the repository tables for you when it opens back up. Then you can close developer and startup the application server.
Scott is right, the best option on a real server is to install and manage your own server (whatever the database you choose).
And a good advice too about putting you database files on another disk.
Now to setup the repository if you didn’t install developer, you would need to
1/ create an empty database in your database server of choice.
2/ edit the servoy.properties file to set the relevant jdbc connection (you can get rid of all the ‘sample’ database if present, the one you are looking for is the one with the name ‘repository_server’ (your actual database can be name whatever you want)
3/ on the command line in /application_server/ type:
on Windows:
servoy_server.bat -upgradeRepository
on Linux/Mac OS X:
./servoy_server.sh -upgradeRepository
This will create and populate the repository for you.
Many Thanks to Scott and Patrick for your sugestions and recomendations.
When you read Upgrade notes of Servoy 5.2.0 :
Installing a clean Servoy 5.2 environment, but keep using Sybase SQL Anywhere
When a clean Servoy 5.2 installation is done, it contains the PostgreSQL database engine and sample databases. When wanting to continue to develop using Sybase SQL Anywhere, the following steps need to be taken:
Remove the {servoy_install}/application_server/database and {servoy_install}/application_server/postgres_db directories from the 5.2 installation
Copy the {servoy_install}/application_server/database and {servoy_install}/application_server/sybase_db directories from an existing Servoy installation to the new Servoy 5.2 installation.
Edit the “nativeStartupLauncher” property in the {servoy_install}/application_server/servoy.properties file to contain the following value: “%%user.dir%%\sybase_db\dbspawn.exe|%%user.dir%%\sybase_db\dbsrv11.exe|@sybase_db\sybase.config#Path=%%Path%%;sybase_db;sybase_db
scripts”
Is this aplicable to the instalation of Servoy 5.2.1 for a real server ?
Patrick:
1/ create an empty database in your database server of choice.
You are talking about: repository_server ?
Armin_kessler:
Patrick:
1/ create an empty database in your database server of choice.
You are talking about: repository_server ?
Yes, he means creating the “servoy_repository” database. It really can have any name. You can create the micky_mouse database, but its connection, however, must be called ‘repository_server’.
Hence, using the ‘micky_mouse’ database as the repository, then the definition of the repository_server (in the servoy.properties file) will be as follow:
# Definition of the repository_server
server.0.serverName=repository_server
server.0.URL=jdbc:postgresql://localhost:5432/micky_mouse
server.0.driver=org.postgresql.Driver
server.0.maxConnectionsActive=10
server.0.maxConnectionsIdle=10
server.0.userName=YourUserName
server.0.password=
server.0.schema=<none>
server.0.catalog=<none>
Armin, did you resolve the problem with your installation of Servoy 5.2.1?
jcompagner:
that is weird, if step 11 does take a lot of time, then it should generate the db’s
because that is what we do then as far as i know.
We will try to check this out.
