4 replies to this topic

[framirez]

Im installing Zurmo on CentOS 5.8 with Virtualmin LAMP installation.

I've upgrade the PHP version to 3.5

After the Database configuration page I got the following:

Failed Required Services Mysql is not installed
Minimum version required: 5.0.0 | FAIL
Database is in strict mode. | FAIL
| FAIL
| FAIL


The weird thing is that mySQL version is 5.0.95 and the DB and user is created by the installation wizard.

What is missing?
The wizard access MySQL with the admin credentials because it create the user and the db to be use by Zurmo.

Please help me with this issue.

[Ivica]

It seems that there are problem with connection with mysql server.
You can try to create empty php file, and upload following code to it, and replace db, username and password with your settings:

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

and access this script via browser, and you will get info if it can connect to db or not.

[framirez]

For the root user is OK
Connected successfully

For the user created by the wizard I got the following:
Could not connect: Access denied for user 'zurmo'@'localhost' (using password: YES)

I change the Host type in MySQL to local host and now I grant the access and got the following comments.
Failed Required Services Database max_sp_recursion_depth size is: 0 minimum requirement is: 20 FAIL Database thread_stack value is: 262144 minimum requirement is: 524288 FAIL Database optimizer_search_depth value is 62. It is required to be set to 0. FAIL

[framirez]

Installation Completed =)

[Ivica]

Great