Planner-list PostgresSQL connection problem

[Chris Kottaridis <chriskot quietwind net>]

I was trying planner on a Fedora 14 installation and it looks like a good way to track some personal projects I have going on.

I wanted to try and save the work I had done to a Database in order to be able to access it from multiple locations around the house. So, I followed the instructions to setup a PostgresSQL
database. I seemed to have gotten that going. I can use pgAdmin III to connect to the database and see there is a planner database. I can also see that there is at least something listening on the port using telnet:

$ telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.

Of course I don't know how to talk to it but it accepts a connection. Here is what pgAdminIII is showing:

So, it seems the database is going and I got the plannerdb database initialized by passing in the 

I went to export->Save to Database, but the "Save to Database option wasn't there! Apparently, it wasn't configured in at compile time when the Fedora 14 package was made.

So, I went to the planner home page and saw 0.14.5 was just made available via git. So, I followed the steps to check it out of git and built with the --with-database option. Basically, this:

  670  git clone git://git.gnome.org/planner
  671  cd planner
  672  git checkout PLANNER_0_14_5
  673  ./autogen.sh --prefix=${HOME}/local --with-database
  674  make install
  675  ~/local/bin/planner

Except every so often having to add some packages like gda, actually compat-gda-3.0. But, once all of them were in place these seemed to be the steps

The tool came up and I read in my project from a file and went to export->Save to Database, which was there this time!!!

So, I entered:

Server: servy.quietwind.net
Database: plannerdb
User: chrisk
Password: <nothing because I don't think there is one because I didn't need it for pgAdminIII>

But, it fails saying it can't contact the server. On the command line I fired up planner from I get:
======================================================
(planner:606): GLib-WARNING **: GError set over the top of a previous GError or uninitialized memory.
This indicates a bug in someone's code. You must ensure an error is NULL before it's set.
The overwriting error message was: Datasource configuration error: could not find provider 'PostgreSQL'

(planner:606): GLib-WARNING **: GError set over the top of a previous GError or uninitialized memory.
This indicates a bug in someone's code. You must ensure an error is NULL before it's set.
The overwriting error message was: Datasource configuration error: could not find provider 'PostgreSQL'

(planner:606): Planner-WARNING **: Can't connect to database server in order to check/create the database: HOST=servy.quietwind.net;DB_NAME=plannerdb
======================================================

My understanding is that gda is in the middle of planner and PostgreSQL. So, I am wondering if I may not have some sort of gda thing configured correctly. I used:

$ gda-config-tool-3.0 --list-datasources
Warning: this datasources are listed from /home/chrisk//.libgda/config
---Datasources list---
Datasource name: planner-auto
Provider: PostgreSQL
Description: planner project
DSN: HOST=servy.quietwind.net;DB_NAME=plannerdb
User name: chrisk
---

Which as far as I know looks OK. I did not create this file in my home directory it seems that was magically done for me at some point. I ran using the list-providers option and this looked kind of ugly:

$ gda-config-tool-3.0 --list-providers
Warning: this providers are listed from /home/chrisk//.libgda/config

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: gtype.c:2710: You forgot to call g_type_init()

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: gtype.c:2710: You forgot to call g_type_init()

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: gtype.c:2710: You forgot to call g_type_init()

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: gtype.c:2710: You forgot to call g_type_init()

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: g_type_interface_add_prerequisite: assertion `G_TYPE_IS_INTERFACE (interface_type)' failed

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: g_type_add_interface_static: assertion `G_TYPE_IS_INSTANTIATABLE (instance_type)' failed

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: gtype.c:2710: You forgot to call g_type_init()

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: gtype.c:2710: You forgot to call g_type_init()

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: gtype.c:2710: You forgot to call g_type_init()

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: gtype.c:2710: You forgot to call g_type_init()

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: g_type_interface_add_prerequisite: assertion `G_TYPE_IS_INTERFACE (interface_type)' failed

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: g_type_add_interface_static: assertion `G_TYPE_IS_INSTANTIATABLE (instance_type)' failed

(gda-config-tool-3.0:645): GLib-GObject-CRITICAL **: g_object_new: assertion `G_TYPE_IS_OBJECT (object_type)' failed

** (gda-config-tool-3.0:645): CRITICAL **: gda_dict_type_set_sqlname: assertion `dt && GDA_IS_DICT_TYPE (dt)' failed

** (gda-config-tool-3.0:645): CRITICAL **: gda_dict_type_set_g_type: assertion `dt && GDA_IS_DICT_TYPE (dt)' failed

** (gda-config-tool-3.0:645): CRITICAL **: gda_dict_declare_object: assertion `G_IS_OBJECT (object)' failed

** (gda-config-tool-3.0:645): WARNING **: Invalid format for provider 'Berkeley-DB' DSN spec : Can't find a data type for parameter 'Database file'
---Providers list---
Provider name: Berkeley-DB
Description: Provider for Berkeley databases
DSN parameters:No DSN (or wrong) DSN spec
Location: /usr/lib64/libgda-3.0/providers/libgda-bdb.so
---

Since pgAdminIII and telnet seem to connect to PostgresSQL and they don't use GDA, and planner can't connect to PostgresSQL and does use GDA I assume there is some GDA configuration that I am missing.

Any pointers on how I can get planner to talk to my postgresSQL server I'd appreciate it.

Along the way I opened TCP 5432 in my firewall and also tried localhost for the server name since the database is running on the same host. Using localhost didn't work either so I don; think there is a routing or firewall issue.

Is there some GDA thing I need to setup to get planner to access the database ?

Thanks
Chris Kottaridis