[imp] Log or a $var_dump to check MySQL prefs connection?

[Mike Coughlan]

I restarted Apache, and now the mysql logs show horde at work.  I didn't
think a HUP was necessary.

     8 Query       insert into horde_prefs (uid, scope, pref_name,
pref_value) values(test, imp, max_msgs, 40)
     8 Query       update horde_prefs set pref_value = 40 where uid = test
and pref_name = max_msgs and scope = imp

Despite comands like these in mysql.log, and an empty mysql.err, the
horde_prefs table is still empty.

    mysql> select * from horde_prefs;
    Empty set (0.00 sec)

I'm going to have to take a closer look at MySQL now.

Thanks all


> -----Original Message-----
> From: Mike Coughlan [mailto:mcoughlan@gothambroadband.com]
> Sent: Tuesday, October 23, 2001 4:14 PM
> To: imp@lists.horde.org
> Cc: Chris Kalos
> Subject: [imp] Log or a $var_dump to check MySQL prefs connection?
>
>
> Thanks, Chuck, I cutted and pasted improperly!  This should be better:
>
> $conf['prefs']['driver'] = 'sql';
> $conf['prefs']['params']['phptype'] = 'mysql';
> $conf['prefs']['params']['hostspec'] = 'localhost';
> $conf['prefs']['params']['username'] = 'root';
> $conf['prefs']['params']['password'] = '*******';
> $conf['prefs']['params']['database'] = 'horde';
> $conf['prefs']['params']['table'] = 'horde_prefs';
>
> Unfortunately, prefs are still not saving.  I can access the tables with
> myssql, but the mysql logs indicate no activity from horde only from the
> prompt.
>
> Is there a log option, or a $var_dump I can do to check the connection
> status, or the status of php4-MySQL?  The test.php thinks it's
> installed, as
> does the Debian Testing package list.
>
> Thanks again
>
>
>
>
> > -----Original Message-----
> > From: Chuck Hagenbuch [mailto:chuck@horde.org]
> > Sent: Tuesday, October 23, 2001 12:29 PM
> > To: imp@lists.horde.org
> > Subject: RE: [imp] MySQL Prefs setup problems with 2.3.7
> >
> >
> > Quoting Mike Coughlan <mcoughlan@gothambroadband.com>:
> >
> > > Warning: Undefined index: params in
> /usr/share/horde/imp/lib/IMP.php on
> > > line 144
> >
> > [snip]
> >
> > > > > conf['prefs']['driver'] = 'sql';
> > > > > $conf['auth']['params']['phptype'] = 'mysql';
> > > > > $conf['auth']['params']['hostspec'] = 'localhost';
> > > > > $conf['auth']['params']['username'] = 'root';
> > > > > $conf['auth']['params']['password'] = '*******';
> > > > > $conf['auth']['params']['database'] = 'horde';
> > > > > $conf['auth']['params']['table'] = 'auth';
> >
> > Maybe a bunch of those should say 'prefs' instead of 'auth'?
> >
> > -chuck
> >
> > --
> > Charles Hagenbuch, <chuck@horde.org>
> > "What was and what may be lie, like children whose faces we
> > cannot see, in
> > the arms of silence. All we ever have is here, now." - Ursula K. Le Guin
> >
> > --
> > IMP mailing list: http://horde.org/imp/
> > Archive: http://marc.theaimsgroup.com/?l=imp&r=1&w=2
> > Frequently Asked Questions: http://horde.org/faq/
> > To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> >
>
>
> --
> IMP mailing list: http://horde.org/imp/
> Archive: http://marc.theaimsgroup.com/?l=imp&r=1&w=2
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>