Jump to content


Photo

Installing on CentOS error on MySQL Services Recognition

MySQL Installation

  • Please log in to reply
4 replies to this topic

#1 framirez

framirez

    Newbie

  • New Members
  • Pip
  • 8 posts

Posted 14 May 2012 - 02:17 PM

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.

#2 Ivica

Ivica

    Advanced Member

  • Moderators
  • 565 posts

Posted 15 May 2012 - 08:49 AM

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.

#3 framirez

framirez

    Newbie

  • New Members
  • Pip
  • 8 posts

Posted 15 May 2012 - 04:08 PM

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

#4 framirez

framirez

    Newbie

  • New Members
  • Pip
  • 8 posts

Posted 15 May 2012 - 05:43 PM

Installation Completed =)

#5 Ivica

Ivica

    Advanced Member

  • Moderators
  • 565 posts

Posted 16 May 2012 - 03:16 AM

Great :)





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users