[imp] MySql prefs problem
Seth Fitzsimmons
seth@note.amherst.edu
Thu, 19 Jul 2001 09:29:55 -0400 (EDT)
I was having this problem too. Not sure if this solution has been
provided yet (as they're not directly Horde related), but here goes.
Make sure 'mysql.default_socket' (in php.ini) is set right. It doesn't
always pick the right mysql.sock automatically (php was looking for
/tmp/mysql.sock when it was really /var/lib/mysql/mysql.sock).
Another thing to check is the permissions on the directories leading up to
mysql.sock are open enough so that the apache user can actually get at the
socket (on a rackspace system, this was forcing me to use the hostname
rather than localhost until I figured out what it was).
Hope this helps.
seth
On Wed, 18 Jul 2001 impuser@bitrealm.com wrote:
> I've read everything I can find, but can't get this to work. I have the latest
> horde/imp from CVS. I'm running php-4.0.5 (4.0.6 doesn't want to compile at
> the moment). The test.php shows everything fine, I can log into imp no problem
> and send mail. What doesn't work is saving prefs.
>
> Running MySql-3.23-28-1, Linux PPC kernel 2.4.7-pre2, imap 2000, and php-4.0.5.
>
> I think IMP is just not connecting to the database at all, but the "Options"
> icon appears when I log into IMP. I was running the released version of
> Horde/IMP with MySql no problem before. I dropped the horde database, re-
> created it using the scripts in horde/scripts/db. I edited
> horde/config/horde.php with:
>
> $conf['prefs']['driver'] = 'sql';
> $conf['prefs']['params'] = array();
> $conf['prefs']['params']['phptype'] = 'mysql';
> $conf['prefs']['params']['hostspec'] = 'localhost';
> $conf['prefs']['params']['protocol'] = 'unix';
> $conf['prefs']['params']['username'] = 'hordemgr';
> $conf['prefs']['params']['password'] = '****';
> $conf['prefs']['params']['database'] = 'horde';
> $conf['prefs']['params']['table'] = 'horde_prefs';
>
> I can log into the database fine from the command line as hordemgr. I can't
> find any log files showing errors. When I try to go to Options>Personal
> Information, Edit Your Identities, then create a new identity, it says the new
> identity has been saved and it shows up in the drop-down, but if I go back to
> Options>Personal Information, the drop-down doesn't show the new identity I
> created.
>
> Anything else I can check? I feel like I'm soooo close.
>
> Brent Olson
> impuser@bitrealm.com
>
>