Re: Planner-list PostgresSQL connection problem

[Chris Kottaridis <chriskot quietwind net>]

Well I loaded some more gda RPM's and now I have some providers:

$ gda-sql-4.0 -L
          Installed providers list
Provider    │ Description                      
────────────┼──────────────────────────────────
Berkeley-DB │ Provider for Berkeley databases  
Web         │ Provider for web server proxies  
PostgreSQL  │ Provider for PostgreSQL databases
SQLite      │ Provider for SQLite databases    
MySQL       │ Provider for MySQL databases     
(5 rows)

And also it seems that a planner-auto DSN, which I am beginning to understand what a DSN is, seems to automagically be there:

$ gda-sql-4.0 -l
                                   List of defined data sources
DSN          │ Provider   │ Description     │ Connection string                          │ Username │ Global
─────────────┼────────────┼─────────────────┼────────────────────────────────────────────┼──────────┼───────
planner-auto │ PostgreSQL │ planner project │ HOST=servy.quietwind.net;DB_NAME=plannerdb │ chrisk   │ FALSE 
(1 row)

One of the RPMS's has a GUI tool called Database Browser and I can start it up and select DSN of planner-auto and get a connection:

So, I seem to be able to get connected to the DB through gda libraries using Database Browser. Clicking on the different tables seems to show expected fields for planner.  However, the planner application still seems to have a problem:


(planner:3925): 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:3925): Planner-WARNING **: Can't connect to database server in order to check/create the database: HOST=servy.quietwind.net;DB_NAME=plannerdb

I can use Database Browser's specify connection instead of DSN and it connects just fine:

This seems to use the same parameters that planner asks me for, instead of using the DSN planner-auto, and it can find the PostgesSQL provider and make a connection leading to the same screen as above.

I assume this is just some configuration issue on my side, but I just can't seem to zoom in on it.

Thanks
Chris Kottaridis

On Thu, 2011-07-07 at 16:55 -0600, Chris Kottaridis wrote:

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
planner-list gnome org
http://mail.gnome.org/mailman/listinfo/planner-list