Servoy and Kubuntu 10.10 64 bit

Classic Servoy
1

I performed an out-of-the box install of Servoy 5.2.6 on a Kubuntu system
I had no error during the install.
The problem now is that PostgreSQL won’t start, I get the error that pg_ctl cannot be found.
pg_ctl is located in the postgres_db/bin folder and executable.

Does anyone know how to do an out-of -the box install of Servoy ?
( without a separate installation of a database server )

2

is pg_ctl marked as executable ? (that should be done by installer)

3

yes

4

maybe current folder is somehow wrong, can you start postgres from command line ? which is the exact error you have in log ?

5

I get the same error if I try to start Postgres from the command line.

6

dozo,

Do you have postgres from ubuntu installed?
Maybe there is some conflict.

Try removing a system-installed postgres:

sudo apt-get remove --purge 'postgresql-8.4*'

Rob

7

There is no other PostgreSQL installed, I get the following error.

patrick@ubuntu:~/servoy/application_server/postgres_db/bin$ ./pg_ctl
bash: ./pg_ctl: Bestand of map bestaat niet

time/date of pg_ctl is 2010-05-04 10:44

8

dozo,

What does this output?

strace ./pg_ctl

Rob

9

Hi guys,

By the sound of it I’m having the same problem on Ubuntu 10.04.2 LTS. I’m not able to start postgres from the command line and there is no other install of postgres on the server.

strace ./pg_ctl outputs the following:

strace: ./pg_ctl: command not found

Any assistance would be much appreciated!

Thanks,

Phil

10

Hi Phil,

The error message is very confusing. We found out recently that this was due to the fact that servoy installs a 32 bit binary of postgresql on a 64 bit linux system. To be able to run this 32 bit binary it must have some libs installed. On kunbuntu this does not seem to be the case default.

sudo apt-get update
sudo apt-get install ia32-libs

Will install the libraries and afterwards postgresql will run (reinstall servoy, because the installation process also suffered under the lack off the 32bits libraries).

Question remains: will a 64 bit version of postgresql be shipped with Servoy (windows and linux)? Running 32 bit applications on 64 bit systems is not a problem but performance drops, for what i’ve read approximately 30%…

11

Michel,

Great that you found this.
All Linuxes I have been using must have these libs pre-installed, apparently ubuntu does not.

You can always install postgres 64 bit from the ubuntu repository, this is especially handy for the server (assuming you will run server on Linux) because you will also get boot-scripts etc.

Rob

12

rgansevles:
You can always install postgres 64 bit from the ubuntu repository, this is especially handy for the server (assuming you will run server on Linux) because you will also get boot-scripts etc.

Okay, we can do an install without database then, but is there an easy (automated) way to create the databases (servoy_repository and user_data) and let servoy point to it (adjust servoy.properties)?

13

The ubuntu documentation site has a nice set of instructions for installing and managing postgres:
https://help.ubuntu.com/community/PostgreSQL

The server definitions in Servoy are the same for the bundled postgres or the self-installed postgres.

You can create the repository tables by starting the server once with the -upgradeRepository flag

Rob

14

Rob,

This has cost us a lot of time. Can you take care of documenting this on the servoy site.

15

Hi Michel,

I ran ```
sudo apt-get install ia32-libs


As a newcomer to Servoy I have spent a lot of time trying to figure this out on two different servers so I think it would definitely be useful to document this info for other users. 

Cheers, 

Phil