> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On
> Behalf Of Brent S. Clark
> Sent: Thursday, June 02, 2005 2:04 AM
> To: squirrelmail-users@lists.sourceforge.net
> Subject: Re: [SM-USERS] new Login Error!
>
> 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.
>
Thanks a lot Clark,
First :
My Mysql version is: mysql-max-3.23.57
My php version is: php-4.2.2-17
So you think that I don't supposed to see such as this problem !!
Second:
My databases is exists and I can connect to it and query it well.
How can I find the phpinfo file ??
Worm Regards,
Samir.
> 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
>
-------------------------------------------------------
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
