Article ID: 115756, created on Mar 20, 2013, last review on May 9, 2014

  • Applies to:
  • Web Presence Builder 11.1
  • Web Presence Builder 11.5


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      


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

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

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

Parallels Presence Builder version 11.x uses new authentication.


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/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.

Search Words

install Sitebuilder

Unable to connect to database


Datas must be string or set automatic_serialization = true

18f5eb2d7a7972323627b40f015d5a19 56797cefb1efc9130f7c48a7d1db0f0c 9305481d3bd31663b68451e3bfdec5a5 25a1611eb95ea6cb4b7c7f9c88e99a58

Email subscription for changes to this article
Save as PDF