Planner-list PostgresSQL connection problem

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

_______________________________________________
planner-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/planner-list