[INFO] Installation of Parallels Presence Builder 11.x fails with error "Unable to connect to database"

Created:

2016-11-16 13:11:27 UTC

Modified:

2017-04-24 11:55:09 UTC

0

Was this article helpful?


Have more questions?

Submit a request

[INFO] Installation of Parallels Presence Builder 11.x fails with error "Unable to connect to database"

Applicable to:

  • Web Presence Builder 11.1 for Linux
  • Web Presence Builder 11.5 for Linux

Symptoms

The following error appears during installation of Parallels Presence Builder 11.1 or 11.5 :

[INFO]Initializing the Parallels Presence Builder's database...
[INFO]Creating database...
[INFO]Creating database user
PHP Warning: PDO::__construct(): Premature end of data (mysqlnd_wireprotocol.c:553) in /usr/local/sb/include/Zend/Db/Adapter/Pdo/Abstract.php on line 129
PHP Warning: PDO::__construct(): OK packet 1 bytes shorter than expected in /usr/local/sb/include/Zend/Db/Adapter/Pdo/Abstract.php on line 129
[ERROR]Unable to connect to database. System message: SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

The " Try " page is not available ( http://sitebuilder.<HOSTNAME>/Try ):

Internal Parallels Presence Builder error.
File: /usr/local/sb/include/Zend/Cache.php; Line: 209
Message: Datas must be string or set automatic_serialization = true; Code: 0

Cause

Old insecure authentication enabled in MySQL ( /etc/my.cnf ):

# Default to using old password format for compatibility with mysql 3.x
old_passwords=1

" old_passwords " is enabled by default in MySQL version 5.0 shipped with CentOS5.

Parallels Presence Builder version 11.x uses new authentication.

Resolution

Before installing Parallels Presence Builder 11.x verify " old_passwords " is disabled. You may use the following command to verify the variable:

~# mysql -u<MYSQL_USER> -p<MYSQL_PASSWORD> -e"show variables like 'old_passwords'"
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| old_passwords | OFF |
+---------------+-------+
~#

To disable the variable add line " old_passwords=0 " into section " [mysqld] " of /etc/my.cnf . Remember to restart mysqld to apply new settings:

/etc/my.cnf
--->8--
[mysqld]
old_passwords=0
---8<---

~# /etc/init.d/mysqld restart

To resolve error " Datas must be string or set automatic_serialization = true " shown on the Try page it's needed to run post-install configuration:

~# sw-engine /usr/local/sb/utils/post_configure.php
Started updating Parallels Presence Builder resources.
Updating Parallels Presence Builder resources is successfully finished.
~#
Have more questions? Submit a request
Please sign in to leave a comment.