I found this in the Squirrelmail FAQ under PHP Errors. The second part
worked for me when I upgraded MySQL.
````````````
Preference database error (connect failed). Exiting abnormally - when
trying to use Mysql as a preference database.
One such possible solution is that your using Mysql 4.08 and it is using
Safe mode, it seems when PHP is compiled it sets sql.safe_mode to being
on. Check phpinfo to see if it is, if it is then mysql logs will show up
with the user of PHP not the user you specified in the DSN of
squirrelmail.
Find the line sql.safe_mode = on and set it to sql.safe_mode = off
And rehash/restart your webserver.
ALSO, if you have restored your settings after a backup... make sure your
database exists (!)
---------------
I ran into this problem and the above 2 solutions didnt help. What I
discovered was that MySQL 4.1+ and PHP < 5 has problems talking to each
other when using pear. The issue is the in MySQL 4.1+ it uses a new hash
for encrypting passwords and PHP < 5 doesnt take the new hash into
account.
I had to do the following to solve this error:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('somepassword')
-> WHERE Host = 'localhost' AND User = 'someuser';
mysql> FLUSH PRIVILEGES;
More on the can be found @ http://dev.mysql.com/doc/mysql/en/old-client.html
``````````````````
> Message: 1
> From: "Samir Noshy" <[EMAIL PROTECTED]>
> To: "'[EMAIL PROTECTED] Sourceforge. Net'"
> <squirrelmail-users@lists.sourceforge.net>
> Date: Wed, 1 Jun 2005 12:50:28 +0300
> Subject: [SM-USERS] new Login Error!
>
> Hi Everybody,
>
> I m using squirrelmail-1.4.4 with qmail 1.03 and mysql Backend.
>
> When trying to login , I got the following error:
>
> Preference database error (connect failed). Exiting abnormally
>
> This happened after some upgrade of the mysql db , but I m sure that the
> user privileges does not changed.
>
> Any help /comment is highly appreciated
>
>
> Best Regards.
>
> Samir Noshy
>
> Senior Systems Engineer
> EgyptCyberCenter
> Mob: 010 1778653
> Tel: +202 8284571
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> www.eccsolutions.net <http://www.eccsolutions.net/>
-------------------------------------------------------
This SF.Net email is sponsored by Yahoo.
Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
Search APIs Find out how you can build Yahoo! directly into your own
Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
--
squirrelmail-users mailing list
Posting Guidelines:
http://squirrelmail.org/wiki/wiki.php?MailingListPostingGuidelines
List Address: squirrelmail-users@lists.sourceforge.net
List Archives:
http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.user
List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995
List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
