[kronolith] Fwd: kronolith pgsql problem

[Jan Schneider]

----- Weitergeleitete Nachricht von kappel at clunet.edu -----
    Datum: Tue, 18 Nov 2003 16:36:40 -0800
    Von: Kevin Appel <kappel at clunet.edu>
Antwort an: Kevin Appel <kappel at clunet.edu>
 Betreff: Re: [kronolith] Fwd: kronolith pgsql problem
      An: Jan Schneider <jan at horde.org>

Hi Jan,

I have granted full access to the database user and I am still
having a problem of no records showing up.
Inside kronolith/config/conf.php,
I have set the following options:
$conf['calendar']['driver'] = 'sql';
$conf['calendar']['params']['phptype'] = 'pgsql';
$conf['calendar']['params']['hostspec'] = 'localhost';
$conf['calendar']['params']['username'] = 'hordemgr';
$conf['calendar']['params']['password'] = 'password';
$conf['calendar']['params']['database'] = 'horde';
$conf['calendar']['params']['table'] = 'kronolith_events';

Is there something that I am missing?

Thank you very much for your help,

Kevin Appel
California Lutheran University
Information Systems and Services
60 W. Olsen Rd.
Thousand Oaks, CA 91360
(805) 493-3431

At 08:12 PM 11/16/2003 +0100, you wrote:
>Zitat von Chuck Hagenbuch <chuck at horde.org>:
>
> >
> >
> > ----- Forwarded message from kappel at clunet.edu -----
> >     Date: Thu, 13 Nov 2003 11:06:35 -0800
> >     From: Kevin Appel <kappel at clunet.edu>
> > Reply-To: Kevin Appel <kappel at clunet.edu>
> >  Subject: kronolith pgsql problem
> >       To: chuck at horde.org
> >
> > Hi Charles,
> >
> > We have been running the IMP/horde framework on a tru64 unix machine and
> > have had great success with it.  We use postgresql as our database and
in
> > combination with turba, it works very well.  However, we recently
> > attempted
> > to add kronolith but are having some troubles.
> >
> > Whenever you add a new entry to the calendar, it never actually stores
> > anything.  There are no entries created in the database and when I
> > tracked
> > it in ../lib/Driver/sql.php I found that it actually never inserts the
> > entry into the database.  There are of set of commands which it fails
on:
> > $id = $this->_db->nextId($this->_params['table']);
> > if (PEAR::isError($id) {
> >          return $id;
> > }
> > Everytime an entry is added, it allows stops at this point and I am not
> > sure a) why  and b) how to fix it.
>
>The db user you use in Horde/Kronolith must have the right to create db
>tables.
>
>Jan.
>
>--
>http://www.horde.org - The Horde Project
>http://www.ammma.de - discover your knowledge
>http://www.tip4all.de - Deine private Tippgemeinschaft
>
>--
>*** Incoming / Outgoing Mail scanned for known Viruses by CLUnet ***


--
*** Incoming / Outgoing Mail scanned for known Viruses by CLUnet ***



----- Ende der weitergeleiteten Nachricht -----


Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - discover your knowledge
http://www.tip4all.de - Deine private Tippgemeinschaft