Can't Connect to Databases

[rsthomas]

Suddenly, I am unable to connect to any of the databases including the default Servoy postgres system files. They all connected fine last month (early August). Access to the workspace is otherwise OK, showing all of my Solutions.

Windows 7.

Servoy Developer 5.2.19 build 1029.

I also have a recent installation of 6.0.9 build 1239 with the same problem.

[mboegem]

Hi rsthomas,

First of all welcome here, as I noticed this is your first post!

Your problem, sounds like Postgres is not even running.
Did you install the bundled version of Postgres or do you use a separate install?

In case of the bundled install you might want to have a look here:
http://wiki.servoy.com/display/public/D ... 898E0609E3

Hope this helps

[rsthomas]

Bundled version of Postres was installed.

The big question here, Marc, is what happened? Postgres and the MySQL files have always opened correctly in both the 5.2.16 and 6.0.9 versions since I installed them.

Here are the startup launcher codes in Windows > Preferences > Servoy > Startup:
5.2.16 -- %%user.dir%%\postgres_db\bin\pg_ctl|start|-D|database|-l|postgres_db\postgres_log.txt

6.0.9 -- C:\Servoy6\application_server\postgres_db\bin\pg_ctl|start|-D|Z:\Servoy|-l|C:\Servoy6\application_server\postgres_db\postgres_log.txt|-o|"-p 3306"

Assuming their syntax is correct (automatically configured during installation) they should both start Postgres.

Starting MySQL is another issue, and actually more important to me, but I figured that since Postres isn't even starting then something must truly be wrong!

[mboegem]

The only relation between Postgres and MySql is these are both DB Engines.
Technically I don't think they can conflict with each other, apart from you make them use the same port.

Can you try to connect to the databases using an external tool like PGAdmin and/or MySQL Administrator?

[ROCLASI]

Hi Thomas,

So it all worked and suddenly stopped working ?
Did you change anything in the mean time ? Perhaps renamed some directories ?
Also do you see anything in the postgres log ?