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

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
keatingk
Posts: 5
Joined: Fri 08 Jan 2010 20:37

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

Post by keatingk » Mon 04 Nov 2013 11:22

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

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

Post by AlexP » Mon 04 Nov 2013 13:16

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

keatingk
Posts: 5
Joined: Fri 08 Jan 2010 20:37

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

Post by keatingk » Mon 04 Nov 2013 15:05

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

keatingk
Posts: 5
Joined: Fri 08 Jan 2010 20:37

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

Post by keatingk » Mon 04 Nov 2013 15:21

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

keatingk
Posts: 5
Joined: Fri 08 Jan 2010 20:37

Problem Solved!!

Post by keatingk » Mon 04 Nov 2013 20:06

Found my problem!

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

Thanks!

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

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

Post by AlexP » Tue 05 Nov 2013 07:02

Hello,

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

Post Reply