Installation problem with MYSQL

[Mark]

I am stuck during the installation with the below message when I
browse to the website to complete setup:

Test Failed (Unable to verify MySQL)

I get the following OK's and am presented with a setup page but
everytime I try to do anything that error message pops up:

Installation CheckPHP version: 5.2.13 (OK)
GD version: bundled (2.0.34 compatible) (OK)
PHP.INI value for 'memory_limit': 200M (OK)
PHP.INI value for 'post_max_size': 100M (OK)
PHP.INI value for 'upload_max_filesize': 100M (OK)
Write access to config directory: (OK)
Write access to storage directory: (OK)


And when I check my PHP install (via a phpinfo page) i get the
following MySQL section:


mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.1.48

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off


I'm pretty new to the whole PHP/MySQL thing so I've run out of ideas
for troubleshooting... MySQL appears to be installed and running OK -
I can createa database but ResourceSpace does not seem to be happy
with it.

Any ideas/help much appreciated.

Cheers,
Mark

[njenney]

Check includes/config.php and ensure your mysql db parameters are
correct. Should look something like this.

/* ---------------------------------------------------
BASIC PARAMETERS
------------------------------------------------------ */

$mysql_server="localhost"; # Use 'localhost' if MySQL is installed on
the same server as your web server.
$mysql_username="admin"; # MySQL username
$mysql_password="adminpasswd"; # MySQL password
$mysql_db="rsdbname"; # MySQL database name

[Mark]

Thanks njenney - I'm assuming that in IIS the equivalent file is
wwwroot\include\config.default.php

I have the below - it did not have my password in there so I tried
adding that but still no luck.

/* ---------------------------------------------------
BASIC PARAMETERS
------------------------------------------------------ */
$mysql_server="localhost"; # Use 'localhost' if MySQL is installed on
the same server as your web server.

$mysql_username="root"; # MySQL username
$mysql_password="xxxxxxxxx"; # MySQL password
$mysql_db="resourcespace"; # MySQL database name
# $mysql_charset="utf8"; # MySQL database connection charset,
uncomment to use.

# The path to the MySQL client binaries - e.g. mysqldump
# (only needed if you plan to use the export tool)
$mysql_bin_path="/usr/bin"; # Note: no trailing slash

# Force MySQL Strict Mode? (regardless of existing setting) - This is
useful for developers so that errors that might only occur when Strict
Mode is enabled are caught. Strict Mode is enabled by default with
some versions of MySQL. The typical error caused is when the empty
string ('') is inserted into a numeric column when NULL should be
inserted instead. With Strict Mode turned off, MySQL inserts NULL
without complaining. With Strict Mode turned on, a warning/error is
generated.
$mysql_force_strict_mode=false;

[Mark]

More information:

On my setup page all the the only setting below which is not
surrounded by a red box (I assume this means that the setting is
invalid) is the MySQLDatabase setting... Does this mean that it is
not happy with the Servername, user and password?



Basic Settings
These settings provide the basic setup for your ResourceSpace
installation. Required items are marked with a *


Database Configuration
MySQL Server: localhost
MySQL Username: root
MySQL Password: rootpassword
MySQL Database: resourcespace

[njenney]

Don't make your changes to wwwroot\include\config.default.php. You
should alway make your config changes in wwwroot\include\config.php.
If you do not have a config.php then copy the contents of
config.default.php and create and edit config.php.

If that does not work I am not sure what the issue might be.

[Tech Patriot]

Hi Mark,

Try replacing the following line in includes/config.php from this:

$mysql_server="localhost";

To this:

$mysql_server = '127.0.0.1';

Like njenney said too, make sure to not edit the includes/
config.default.php. Technically your changes there will work, but be
overwritten if you ever do an upgrade to ResourceSpace.

Thanks,
John

[Mark]

Hi John - still no joy with the loopback address...

From what I can gather the config.php file must get created during the
initial setup phase that I am trying to complete now? I definitely do
not have a config.php file yet and when I created one and copied the
contents from config.default.php to it then i get a The Website cannot
display this page error... Or if I browse to the http://server/pages/setup.php
then I get a message saying that the setup phase had now been
completed if I want to run it again then delete config.php...

I really thinnk that for some reason ResourceSpace thinks there is
something wrong with MySQL...

I'll have time for a bit more of a play tomorrow...