mysqlnd cannot connect to MySQL 4.1+ using the old insecure

[twen88]

Thank you velden, here is the config info and system info:

$config['dbms'] = 'mysqli';
$config['db_hostname'] = 'myhostname.com';
$config['db_username'] = 'username';
$config['db_password'] = 'password';
$config['db_name'] = 'cmsdatabase';
$config['db_prefix'] = 'cms_';
$config['timezone'] = 'America/Toronto';
$config['show_base'] = '';
$config['url_rewriting'] = 'mod_rewrite';
$config['page_extension'] = '.html';
$config['use_hierarchy'] = '1';

----------------------------------------------

Cms Version: 1.11.11

Installed Modules:

CGExtensions: 1.44.3
CMSMailer: 5.2.2
CMSPrinting: 1.0.5
FileManager: 1.4.5
MenuManager: 1.8.6
MicroTiny: 1.2.7
ModuleManager: 1.5.8
News: 2.14.4
Search: 1.7.11
ThemeManager: 1.1.8
FrontEndUsers: 1.24.1
FEUMailer: 0.9.4
CustomContent: 1.10
FEmessages: 1.2
SelfRegistration: 1.8.2
TinyMCE: 2.9.12
CGCalendar: 1.14.3
CGSimpleSmarty: 1.7.4


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 20000000
url_rewriting: mod_rewrite
page_extension: .html
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding: utf-8
admin_encoding: utf-8
set_names: true


Php Information:

phpversion: 5.3.13
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
E_DEPRECATED: 0
memory_limit: 128M
max_execution_time: 120
output_buffering: On
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 20M
upload_max_filesize: 20M
session_save_path: /home/users/web/b1905/as.hdeaa/cgi-bin/tmp (0775)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)


Server Information:

Server Api: cgi-fcgi
Server Db Type: MySQL (mysqli)
Server Db Version: 5.5.32
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable
Server Time Diff: No filesystem time difference found


----------------------------------------------

[twen88]

I use cmsms 1.11.11 under php 5.6.4 without any problem.

I never doubt a new installation of 1.11.11 will work fine under 5.6.4, it just weired to see this type of errors when upgrading the server from php5.3x to 5.5x.

[staartmees]

it was an upgraded cmsms.

[velden]

I don't think it has something to do with new install on a php version vs. upgrading later to an higher php version.. That would be very easy to check out by the way (install cmsms in a new subdir on another database or same database using other table prefix).

If you Google for the errors it comes up with a lot of suggestions. Many of those about the password length!

[twen88]

Resovled by simplly change this line in config file:

$config['dbms'] = 'mysqli';

to $config['dbms'] = 'mysql';

and that is all.