Page 1 of 1

Problem using PostgreSQL with UNIDAC on MAC OS/X with trials

Posted: Mon 04 Nov 2013 11:22
by keatingk
I'm using Rad Studio XE5 Trial with UNIDAC Trial and have a Firemonkey desktop app that connects to a PostgreSQL server. I have it running under Windows 32, but when I deploy to MAC OS/X, all I get is a hang and a bouncing project icon on the Mac screen.

Can anyone help, as I am evaluating all these products for a db app I'll be working on.

Thanks,
Ken

Re: Problem using PostgreSQL with UNIDAC on MAC OS/X with trials

Posted: Mon 04 Nov 2013 13:16
by AlexP
Hello,

1. Try to connect (open DataSet, etc.) at run-time and detect the operation, on which the application hangs.
2. Check whether you specify the server parameters correctly (try to specify the server IP-address instead of its name)
3. Wrap all method calls with Try...Except blocks, and display messages on errors.

If these steps don't help find out what causes the error, please send a small demo sample reproducing the problem to alexp*devart*com

Re: Problem using PostgreSQL with UNIDAC on MAC OS/X with trials

Posted: Mon 04 Nov 2013 15:05
by keatingk
Here are the steps I've taken:

1) Create a new FireMonkey HD app
2) Drop a TPostgreSQLUniProvider component on form
3) Drop a TUniConnection on form and fill in my login info and connect (From Windows)
3a) In TUniConnection properties, set Connected to FALSE
4) Drop a TButton on form and set OnClick handler to do "UniConnection1.Connect;"
5) Select compilation target as WIN32 & run
6) Click button & all is well UI still responds
7) Close program
8) Select compilation target as MAC OS/X Normal application & run
9) Click Button & GUI HANGS, wait for the timeout (socket error 60)

My PostgreSQL 9.1 server is on a Linux box (32 bit Ubuntu) and my pg_hba.conf file has the following entry:

HOST ALL ALL 10.0.0.0/24 md5

Does the trial version of UNIDAC support MD5 for the Mac OS/X?

What more can I try for you?

Thanks for any help you can give.

Ken

Re: Problem using PostgreSQL with UNIDAC on MAC OS/X with trials

Posted: Mon 04 Nov 2013 15:21
by keatingk
Also, the same is true for pgDAC.

I've turned off my mac firewall to no avail.

I can't imagine the issue is on my PostgreSQL server since the windows app connects. Let me know if there is anything else I can do.

Ken

Problem Solved!!

Posted: Mon 04 Nov 2013 20:06
by keatingk
Found my problem!

Firewall in Linux server needed rule added for MAC OS/X ip address.

Thanks!

Re: Problem using PostgreSQL with UNIDAC on MAC OS/X with trials

Posted: Tue 05 Nov 2013 07:02
by AlexP
Hello,

Glad to see that you solved the problem. If you have any other questions, feel free to contact us