# Application Server in Servoy 5.2.1 don't work !!! **URL:** \ **Category:** Classic Servoy\ **Created:** [September 17, 2010, 2:34pm UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890 "2010-09-17T14:34:59Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Armin\_kessler](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@Armin\_kessler](https://forum.servoy.com/u/Armin_kessler)\ **Post date:** [September 17, 2010, 2:34pm UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/1 "2010-09-17T14:34:59Z")
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 ---
**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\ **Post date:** [September 17, 2010, 3:18pm UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/2 "2010-09-17T15:18:30Z")
in what dir do you install servoy? maybe in 2003 you also dont have enough rights for that to write in some dirs (like program files under vista/win7) ---
**Author:** ![Armin\_kessler](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@Armin\_kessler](https://forum.servoy.com/u/Armin_kessler)\ **Post date:** [September 22, 2010, 10:42pm UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/3 "2010-09-22T22:42:32Z")
Johan: Thanks for your response. 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. Armin ---
**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\ **Post date:** [September 23, 2010, 7:17am UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/4 "2010-09-23T07:17:18Z")
do not install it in the c:\program files do we give that as a default location? (then we should fix that in the installer for Windows Server 2003) program files cant be written in without elevated rights… So database files dont belong there. ---
**Author:** ![Armin\_kessler](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@Armin\_kessler](https://forum.servoy.com/u/Armin_kessler)\ **Post date:** [September 23, 2010, 3:32pm UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/5 "2010-09-23T15:32:23Z")
Johan: 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. Thanks Armin ![Dir database empty.JPG](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/1X/15d3693a3c5c8ba502b54c112adf7556b27ad5f6.jpeg) ---
**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\ **Post date:** [September 23, 2010, 5:15pm UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/6 "2010-09-23T17:15:37Z")
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. ---
**Author:** ![sbutler](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/sbutler/32/4393_2.png) [@sbutler](https://forum.servoy.com/u/sbutler)\ **Post date:** [September 23, 2010, 5:33pm UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/7 "2010-09-23T17:33:08Z")
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. ---
**Author:** ![ptalbot](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/ptalbot/32/4952_2.png) [@ptalbot](https://forum.servoy.com/u/ptalbot)\ **Post date:** [September 23, 2010, 6:56pm UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/8 "2010-09-23T18:56:42Z")
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: ```auto servoy_server.bat -upgradeRepository ``` on Linux/Mac OS X: ```auto ./servoy_server.sh -upgradeRepository ``` This will create and populate the repository for you. ---
**Author:** ![Armin\_kessler](https://avatars.discourse-cdn.com/v4/letter/a/45deac/32.png) [@Armin\_kessler](https://forum.servoy.com/u/Armin_kessler)\ **Post date:** [September 24, 2010, 3:32am UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/9 "2010-09-24T03:32:53Z")
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 ? Thanks Armin ---
**Author:** ![jcarlos](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@jcarlos](https://forum.servoy.com/u/jcarlos)\ **Post date:** [September 27, 2010, 9:22pm UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/10 "2010-09-27T21:22:18Z")
> 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: ```auto # 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= server.0.catalog= ``` Armin, did you resolve the problem with your installation of Servoy 5.2.1? I am having problems. I tried it in a XP machine and it’s not working for me. Read the post here: [http://www.servoy.com/forum/viewtopic.php?f=11&t=14955](http://www.servoy.com/forum/viewtopic.php?f=11&t=14955) JC PS: I haven’t tried in my Server Windows 2003 yet! ---
**Author:** ![ptalbot](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/ptalbot/32/4952_2.png) [@ptalbot](https://forum.servoy.com/u/ptalbot)\ **Post date:** [September 27, 2010, 9:24pm UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/11 "2010-09-27T21:24:41Z")
Yes, Carlos is right! mickey\_mouse is how I call all my repositories database ![;)]( "Wink") But they are all declared as repository\_server in servoy.properties ---
**Author:** ![jcarlos](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@jcarlos](https://forum.servoy.com/u/jcarlos)\ **Post date:** [September 27, 2010, 10:01pm UTC](https://forum.servoy.com/t/application-server-in-servoy-5-2-1-dont-work/12890/12 "2010-09-27T22:01:40Z")
> 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. Hi Johan, Have you figured out what the problem was? I am having problems even after carefully following recommendations. Please check my post at: [http://www.servoy.com/forum/viewtopic.php?f=11&t=14955&p=79780#p79780](http://www.servoy.com/forum/viewtopic.php?f=11&t=14955&p=79780#p79780) JC