[SOLVED] RoundCube - DATABASE ERROR - PHP Warning: PDO::__co - OLD Forum of Users and Developers of Epesi BIM

[SOLVED] RoundCube - DATABASE ERROR - PHP Warning: PDO::__co

scrfix

See http://www.scrfix.com/computer-repair-h ... f=18&t=149 for a detailed description of how to repair this issue.

=======================================================================
UPDATE! 10-29-13
This is definitely something to do with version 1.5.4 and RoundCube. I removed everything, database & files and started back installing 1.5.3 and then signed the customer up for the Comcast IMAP Server and viola I have email that showed up... Yes! Yes! Yes!
I then upgrade it to 1.5.4 and POW! :shock: all hopes die out... Same Error as below!
=======================================================================

I just installed 1.5.4 version of Epesi onto an addon domain runing on linux CentOS. (An addon means it is sharing the same IP as another domain.)
I have two different epesi installs on the same server running on two separate databases.
The first works no problem with round cube with my email address
The second will not load round cube even attempting to use the same exact email as the first one with the same information.
Everything else works except for round cube.

Server version: 5.5.32-cll MySQL Community Server (GPL)
PHP 5.4.14 (cli) (built: May 3 2013 14:21:44)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
with the ionCube PHP Loader v4.2.2, Copyright (c) 2002-2012, by ionCube Ltd.

When I go to email I receive a Round Cube Logo and the following error instead of my email showing up:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

It doesn't matter if I use <mail server>:143,<mail server>:143,<mail server>,<mail server>:110,<mail server>:995 or the like with the smtp server. This will not connect. Setting up the "mail settings" using the php.ini file works but I cannot get either installation to connect using remote smtp server method.

I have tested the msyql hash select password('myPassword') and select old_password('myPassword') and both hashes are exactly the same. I ran the SQL command to fix the error below to no avail. As you can see below the password hash is exactly the same.

mysql> select password('myPassword');
+------------------------+
| password('myPassword') |
+------------------------+
| 2e96eedb7c8bf893 |
+------------------------+
1 row in set (0.00 sec)

mysql> select old_password('myPassword');
+----------------------------+
| old_password('myPassword') |
+----------------------------+
| 2e96eedb7c8bf893 |
+----------------------------+
1 row in set (0.00 sec)

I have looked through the apache log files, modsec files to no avail... there are no errors about this

ERRORS LOG FILE FOR ROUNDCUBE
[29-Oct-2013 11:23:16 America/New_York] PHP Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password] in /<home directory>/crm/modules/CRM/Roundcube/RC/program/lib/Roundcube/rcube_db.php on line 144

[29-Oct-2013 11:23:16 -0400]: DB Error: SQLSTATE[HY000] [2054] The server requested authentication method umknown to the client in /<home directory>/crm/modules/CRM/Roundcube/RC/program/lib/Roundcube/rcube_db.php on line 154 (GET /crm/modules/CRM/Roundcube/RC/index.php?_autologin_id=3)

[29-Oct-2013 11:23:16 -0400]: DB Error: SQLSTATE[HY000] [2054] The server requested authentication method umknown to the client (GET /crm/modules/CRM/Roundcube/RC/index.php?_autologin_id=3)

Someone please assist.

Thanks,

Wayne

ajb

Isn't this a similar issue like here described by you(?)
http://forums.laravel.io/viewtopic.php?id=8667
?

scrfix

LOL....
That's me! I am the one that wrote those instructions. No, that is not working. This is definitely a problem with 1.5.4 not working properly with RoundCube.

Wayne

scrfix

Okay! This is solved. (A more descriptive detail will be available at the scrfix forums. PHP Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password]) or http://www.scrfix.com/computer-repair-h ... f=18&t=149

First of all one of the main issues is that my hosting companies mysql version function of PASSWORD() is not working properly. The apparently was the problem so I doubt that anyone else will run in to this unless they are on the same server as me trying to set EPESI up but here is the fix.

The problem:
The MySQL PASSWORD function was outputting a 16 character hash instead of a 41 character hash. When EPESI connects to RoundCube it uses PHP and it is looking for that 41 character HASH hence the errors that were being reported. After many hours back and forth I finally decided to have them test the has returns for me and found out that both hash whether we utilize the OLD_PASSWORD or PASSWORD functions return only 16 characters so nothing you find on the Internet is going to assist with this because the PASSWORD function is broken.

The solution:
1. I have access to a MySQL server that actually functions properly so I was able to get the correct HASH in order to update the password which is a pre-requisite for this repair.

2. Run the following command in a SQL prompt on the working MySQL server:
SELECT PASSWORD('Enter-Your-Password-Here'); /* This will return a 41 character Hexadecimal Digits. Copy all 41 characters */

3. Give this command to your hosting company to run:
UPDATE mysql.user SET Password='Enter-41-Character-Hex-Here' WHERE User='Enter-Your-User-Here-That-You-Want-ToFix' AND Host='localhost'; /* localhost presumes that your MySQL server is on the same server as your website. If that is not the case then you will have to change localhost to whatever the mysql server computer name is. Your hosting company will know that. */

ajb

Thanks for a such detailed instruction and I'm glad that you've solved this!

Regards,
Adam

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge