On 5 December 2012 00:54, Andre Hasekamp <[email protected]> wrote:

>
> Hello,
>
> At the moment I have an application which directly uses PostgreSQL, but
> why not try and incorporate Gnome DB in the application? The (excellent)
> GNOME Data Access 5 book describes several command line tools. So, before
> writing any code, I thought it wise to first try and set up a connection
> with my PostgreSQL database by means of:
>
> gda-control-center-5.0
> or
> gda-test-connection-5.0
>


Good idea! However I would advise you to use the gda-sql-5.0 program, which
has more features and can be use like the psql tool.


>
> No luck so far.
>
> gda-control-center-5.0 gives the following error message as soon as I
> start typing the user id / password:
> couldn't connect to dbus session bus: Did not receive a reply. Possible
> causes include: the remote application did not send a reply, the message
> bus security policy blocked the reply, the reply timeout expired, or the
> network connection was broken.
>

This is indeed a strange error, but I don't think it makes the program fail
anyway.


>
> gda-test-connection-5.0 I gives the following error message:
> WARNING **: Can't open connection to DSN PostgreSQL: Could not set
> search_path to /var/lib/pgsql/data
>

Can you send me the command line you used, and the result of executing
"gda-sql-5.0 -l" and "gda-sql-5.0 -L"?


>
> Of course, as a GNOME Data Access beginner I may do something very stupid.
> Maybe you can help me out.
>

I don't think so ;-) The software should work or report useable error
messages, even if you don't know how to use it.


>
> Otherwise, since PostgreSQL runs fine and the Gnome DB command line tools
> will undoubtedly function correctly, could there be a problem of
> compatibility among versions of software packages?
>

This seems unlikely.


>
> Here is a list of software versions which I think might be of interest in
> the current context.
>
> - Linux distro: openSUSE 12.2
>
> The following packages all come from the openSUSE 12.2 repository.
>
> - Current kernel, version 3.4.11-2.16
> - PostgreSQL, version 9.1-7.16.1
> - libgda, version 5.0.3-3.1.2
> - libgda-postgres, version 5.0.3-3.1.2
> - D-bus Message Bus System, version 1.5.12-4.10.1
>
> Since I program in C++, after I succeed in setting up a connection with
> PostgreSQL through Gnome DB, I would use:
> - libgdamm, version 4.99.6-2.1.2
>
> Any idea what is going on?
>

Libgdamm is the C++ bindings, so I guess it's Ok to use them (they are used
in the Glom program, so they should work properly even if the version
nomber is 4.99).

Regards,

Vivien
_______________________________________________
gnome-db-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnome-db-list

Reply via email to