Install error on MYSQL database create step

[Nox]

Installing on UBUNTU 8.04 LTS
Business Edition 2.2.16
Manual Install

I get to the part in the install where it is asking for the database information. I choose the following options:

MYSQL w/InnoDB
database (timetrex)
hostname (localhost)
username (timetrex)
password (********)

I also also specify the root account credentials... (which I have double and triple checked the spelling of the password).

When I click test connection:

Connection test to your database as a non-privileged user has FAILED! Please correct them and try again.

If I open mysql as the root account, it appears that the timetrex database is being created, but the timetrex user account is not.

It has got to be something simple because I have had this running on Fedora Core 8 with the TimeTrex Standard Edition for our test environment. What am I missing?




As a side note: I was originally going to install TimeTrex Business edition on Fedora Core 8, but we are trying to standardize our Linux server installs and we chose Ubuntu 8.04 LTS.

[shaunw]

Please see this FAQ entry:
http://forums.timetrex.com/viewtopic.php?t=65

[Nox]

Oh, I can create the items, but step 5 in the README says:


5. Edit timetrex.ini.php and confirm that all paths are correct.
The installer will create and configure the database
for you, as well as modify other non-path settings for you.


I'll create the database and user account and test it.

[Nox]

Now I am getting this error:

Warning: Error parsing /var/www/timetrex/includes/../timetrex.ini.php on line 46 in /var/www/timetrex/includes/global.inc.php on line 65

Down for Maintenance

TimeTrex-Debug is unable to connect to its database, please make sure that the database has been started and is running.

This appears after I click next when it successfully says I can connect to the database using a non-privileged user.

[shaunw]

There is a parse error in your timetrex.ini.php file.

If you have any values with spaces, or special characters in them, make sure you have quotes around it, for example:

This would cause a parse error:

password = my password here

This would also:

password = p$ssw@ord

Instead use:

password = "my password here"

or

password = "p$ssw@ord"

[Nox]

I was using special characters in the password. Thanks shaun!

Now, just to clarify, is the software supposed to create the MYSQL database and user on the fly, or do the database and user need to be created before running setup?

[shaunw]

The user/password and database should be created before.