[horde] How to activate PostgreSQL

[c.reiter at roteskreuz-schwaz.at]

Zitat von Eric Rostetter <eric.rostetter at physics.utexas.edu>:

> Quoting c.reiter at roteskreuz-schwaz.at:
> 
> > Yes, there are actual big problems with database access:
> 
> Are you using sql for anything except turba?  If so, do they work or fail?

I tried to use it for prefs, but this also did fail.

> > $cfgSources['localsql'] = array(
> >     'title' => 'Mein Adressbuch',
> >     'type' => 'sql',
> >     'params' => array(
> >         'phptype' => 'pgsql',
> >         'hostspec' => 'localhost',
> >         'username' => '[MY USER HERE]',
> >         'password' => '[MY PASSWORD HERE]',
> >         'database' => 'horde',
> >         'table' => 'turba_objects'
> >     ),
> 
> Looks okay as far as it goes.  But I don't know anything about your
> system, so I can't say if it is correct or not.
> 
> > The database is up and running, i can access it
> > using psql on the shell (User and Pass are set correct).
> 
> But, what about other parameters like sockets/tcpip, or port number, or
> authorization for pgsql or firewalls and so on?

Sockets and TCP/IP are enabled in Postgres, they are also tested from
antother host and the localhost.
Authorization to Postgres is done via MD5.
Might this be the problem? Should i try unencrpyted passwords?

> > But when it try to add a contact in turba or try to
> > view the contacts, i get the following message:
> >
> > ====================Error Message====================
> > Failed to connect to the specified directory.
> > ====================Error Message====================
> 
> That isn't so useful, now is it...
> 
> > I've not found any log-file (expect httpd's logs) where
> > i can check for the error.
> 
> Sounds like turba could use some better error logging....

Yes, i think so...
 

............Chris.............




-------------------------------------------------
Dieses Mail wurde mit dem WebMail Gateway des
Roten Kreuzes Schwaz versendet.