[gnome-db] No connections to postgresql databases

["Antonio G. - Geotronix" <antonio sunstone it>]

Hi.

In followups to my previuos messages I can now send some debugging info
to my non connections to postgresql Dbs with mergeant.

All debug settings are set in /etc/postgresql/postgresql.conf and this
is what I get in the log when connecting to a DB with 'pslq database':

...
....
2002-11-05 01:40:51 [15635]  DEBUG:  BackendStartup: forked pid=15667
socket=9
2002-11-05 01:40:51 [15667]  DEBUG:  connection: host=[local]
user=antonio database=rubrica
2002-11-05 01:40:51 [15667]  DEBUG:  StartTransactionCommand
2002-11-05 01:40:51 [15667]  DEBUG:  query: select getdatabaseencoding()
2002-11-05 01:40:51 [15667]  DEBUG:  CommitTransactionCommand
2002-11-05 01:40:51 [15667]  DEBUG:  StartTransactionCommand
2002-11-05 01:40:51 [15667]  DEBUG:  query: SELECT usesuper FROM pg_user
WHERE usename = 'antonio'
2002-11-05 01:40:51 [15667]  DEBUG:  CommitTransactionCommand
2002-11-05 01:41:02 [15667]  DEBUG:  StartTransactionCommand
2002-11-05 01:41:02 [15667]  DEBUG:  query: SELECT c.relname as "Name",
  CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i'
THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as
"Type",
  u.usename as "Owner"
FROM pg_class c LEFT JOIN pg_user u ON c.relowner = u.usesysid
WHERE c.relkind IN ('r','v','S','')
  AND c.relname !~ '^pg_'
ORDER BY 1;
2002-11-05 01:41:02 [15667]  DEBUG:  CommitTransactionCommand
2002-11-05 01:42:29 [15635]  DEBUG:  reaping dead processes
2002-11-05 01:42:29 [15635]  DEBUG:  child process (pid 15667) exited
with exit code 0
2002-11-05 01:44:56 [15635]  DEBUG:  reaping dead processes (exited from
psql)

When I try connecting with mergeant absolutly nothing happens. I would
like to let you guy s know that in the 'database properties' settings
the provider keeps sitting on 'Default' even when I change it to
'postgres', and even though:

[Tue Nov  5, 01:42am][antonio gaia:~]cat .libgda/config 
<?xml version="1.0"?>
<libgda-config>
  <section path="/apps/libgda/Datasources/Rubrica">
    <entry name="DSN" type="string"
value="PASSWORD=francy01;HOSTADDR=127.0.0.0;USER=antonio;DATABASE=rubrica;HOST=gaia"/>
    <entry name="Description" type="string" value="Rubrica personale"/>
    <entry name="Password" type="string" value="francy01"/>
    <entry name="Provider" type="string" value="PostgreSQL"/>
    <entry name="Username" type="string" value="antonio"/>
  </section>
...
....


Any ideas on why I can't get connected to postgres databases? 
BTW. After I try getting connected to a DB with the 'connect to sql
server' function and it fails with the '-1 Can't bla bla bal' error,
there is no way of getting that little 'connect' window back up.

Any ideas?

Bye.