Step 3: DB config error

Shaun · Post by **Shaun** » Fri Oct 31, 2008 11:08 am

Prereq Info:
We are using the following....
OS: Windows Server 2003
DB: MySQL 5.0
PHP 5.2.6
Time Trex Standard Edt v2.2.15
Our timetrex.php.ini file debug section is as follows...
enable = TRUE
enable_display = TRUE
buffer_output = TRUE
enable_log = TRUE
verbosity = 11
I have commented out the "skip-innodb" line in the my.ini file
-----
After insalling both MySQL and PHP we have run into some problems getting the Time Trex install to work. The error occurs during the thrid step of the install (database configuration). After the test connection phase of the install takes place (which is successful for both the user name for time trex and the privileged DB user name) we are getting a red header error which states...
"Your MySQL databse does not support the InnoDB storage engine
which is required for Time Trex to use transactions and ensure data
integrity. Please add InnoDB support to MySQL before continuing."
We are using the root account for access. We have Innodb enabled in MySql. We have successfully created tables in the DB with the root account and they reflect the InnoDB type. We do not know how to troubleshoot this error as it seems the error message is not valid. Any assistance you can provide would be very much appreciated.

Thanks
-Shaun

Post by **shaunw** » Fri Oct 31, 2008 12:05 pm

At the MySQL console, can you copy and paste the output of the following SQL command here:

show engines;

Shaun · Post by **Shaun** » Fri Oct 31, 2008 12:13 pm

Code: Select all

Engine	Support	Comment
MyISAM	YES	Default engine as of MySQL 3.23 with great performance
MEMORY	YES	Hash based, stored in memory, useful for temporary tables
InnoDB	DEFAULT	Supports transactions, row-level locking, and foreign keys
BerkeleyDB	NO	Supports transactions and page-level locking
BLACKHOLE	YES	/dev/null storage engine (anything you write to it disappears)
EXAMPLE	NO	Example storage engine
ARCHIVE	YES	Archive storage engine
CSV	NO	CSV storage engine
ndbcluster	NO	Clustered, fault-tolerant, memory-based tables
FEDERATED	YES	Federated MySQL storage engine
MRG_MYISAM	YES	Collection of identical MyISAM tables
ISAM	NO	Obsolete storage engine

Post by **shaunw** » Fri Oct 31, 2008 12:23 pm

It should be working for you, TimeTrex checks to make sure that MySQL reports either "YES" or "DEFAULT" for InnoDB, which according to that output it is.

I would maybe try making MyISAM tables default temporarily (while keeping InnoDB enabled of course) to see if TimeTrex allows that.

Also, I would check your TimeTrex log file, and search for:

Available Storage Engines

If you find that string in the log file, copy and paste it and about the next 100 lines after it here so we can find out what MySQL is telling TimeTrex.

Post by **shaunw** » Fri Oct 31, 2008 1:07 pm

Were you getting this error before you set debug verbosity to 11 in your timetrex.ini.php file?

Having it set to 11 will show this error everytime, so you need to test it with the setting at 10 or less.

Shaun · Post by **Shaun** » Fri Oct 31, 2008 1:16 pm

Shaun,

Below I have posted to separate logs to clearly identify the process behind both the connection test step as well as the subsequent function (click next) once the connection test has succeeded. We are most interested in the access deny messages for the root user account which appears in both logs. Thanks for your help.

Connection Test Log:

Code: Select all

---------------[ Fri, 31 Oct 2008 16:06:07 -0400 (PID: 3576) ]---------------
DEBUG [111]:	<b>TTDate::setTimeZone()</b>: Setting TimeZone: America/New_York<br>
DEBUG [54]:	<b>[Function]()</b>: Bypassing Authentication<br>
DEBUG [404]:	<b>TTi18n::chooseBestLocale()</b>: Choosing Best Locale...<br>
DEBUG [375]:	<b>TTi18n::getBrowserLanguage()</b>: HTTP_ACCEPT_LANGUAGE: en-us<br>
DEBUG [458]:	<b>TTi18n::chooseBestLocale()</b>: cSetting Locale: en_US<br>
DEBUG [322]:	<b>TTi18n::setLocale()</b>: Generated/Passed In Locale: en_US<br>
DEBUG [256]:	<b>TTi18n::generateLocale()</b>: Array of Locales to try in order: en_US,en<br>
DEBUG [207]:	<b>TTi18n::tryLocale()</b>: Found valid windows locale: English_United States.1252 Linux locale: en_US<br>
DEBUG [215]:	<b>TTi18n::tryLocale()</b>: Found valid locale: en_US<br>
DEBUG [328]:	<b>TTi18n::setLocale()</b>: Attempting to set Locale(s) to: en_US Category: 0 Current Locale: <br>
DEBUG [331]:	<b>TTi18n::setLocale()</b>: Setting currency/numeric Locale to: en_US<br>
DEBUG [344]:	<b>TTi18n::setLocale()</b>: Setting translator locale to: en_US<br>
DEBUG [361]:	<b>TTi18n::setLocale()</b>: Set Master Locale To: en_US<br>
DEBUG [467]:	<b>TTi18n::chooseBestLocale()</b>: Using Locale: en_US<br>
DEBUG [94]:	<b>Install::isInstallMode()</b>: Install Mode is ON<br>
DEBUG [279]:	<b>Install::checkDatabaseExists()</b>: Database Name: timetrex<br>
DEBUG [289]:	<b>Install::checkDatabaseExists()</b>: Exists - Database Name: timetrex<br>
DEBUG [140]:	<b>[Function]()</b>: Testing connection as priv user<br>
---------------[ Fri, 31 Oct 2008 16:06:07 -0400 (PID: 3576) ]---------------
---------------[ Fri, 31 Oct 2008 16:06:07 -0400 (PID: 3576) ]---------------
DEBUG [77]:	<b>[Function]()</b>: Error connecting to the database!<br>
DEBUG [43]:	<b>DBError::__construct()</b>: mysqlt error: [1045: Access denied for user 'root'@'ohtadc.ohtacoding.com' (using password: YES)] in CONNECT(ohtadc, 'root', '****', timetrex)
<br>
---------------[ Fri, 31 Oct 2008 16:06:07 -0400 (PID: 3576) ]---------------
---------------[ Fri, 31 Oct 2008 16:06:08 -0400 (PID: 3576) ]---------------
DEBUG [77]:	<b>[Function]()</b>: Error connecting to the database!<br>
DEBUG [43]:	<b>DBError::__construct()</b>: mysqlt error: [1045: Access denied for user 'root'@'ohtadc.ohtacoding.com' (using password: YES)] in CONNECT(ohtadc, 'root', '****', timetrex)
<br>
---------------[ Fri, 31 Oct 2008 16:06:08 -0400 (PID: 3576) ]---------------
---------------[ Fri, 31 Oct 2008 16:06:08 -0400 (PID: 3576) ]---------------
DEBUG [111]:	<b>TTDate::setTimeZone()</b>: Setting TimeZone: America/New_York<br>
DEBUG [54]:	<b>[Function]()</b>: Bypassing Authentication<br>
DEBUG [404]:	<b>TTi18n::chooseBestLocale()</b>: Choosing Best Locale...<br>
DEBUG [375]:	<b>TTi18n::getBrowserLanguage()</b>: HTTP_ACCEPT_LANGUAGE: en-us<br>
DEBUG [458]:	<b>TTi18n::chooseBestLocale()</b>: cSetting Locale: en_US<br>
DEBUG [322]:	<b>TTi18n::setLocale()</b>: Generated/Passed In Locale: en_US<br>
DEBUG [256]:	<b>TTi18n::generateLocale()</b>: Array of Locales to try in order: en_US,en<br>
DEBUG [207]:	<b>TTi18n::tryLocale()</b>: Found valid windows locale: English_United States.1252 Linux locale: en_US<br>
DEBUG [215]:	<b>TTi18n::tryLocale()</b>: Found valid locale: en_US<br>
DEBUG [328]:	<b>TTi18n::setLocale()</b>: Attempting to set Locale(s) to: en_US Category: 0 Current Locale: <br>
DEBUG [331]:	<b>TTi18n::setLocale()</b>: Setting currency/numeric Locale to: en_US<br>
DEBUG [344]:	<b>TTi18n::setLocale()</b>: Setting translator locale to: en_US<br>
DEBUG [361]:	<b>TTi18n::setLocale()</b>: Set Master Locale To: en_US<br>
DEBUG [467]:	<b>TTi18n::chooseBestLocale()</b>: Using Locale: en_US<br>
---------------[ Fri, 31 Oct 2008 16:06:08 -0400 (PID: 3576) ]---------------

Next Step Log:

Code: Select all

---------------[ Fri, 31 Oct 2008 16:07:55 -0400 (PID: 3576) ]---------------
DEBUG [111]:	<b>TTDate::setTimeZone()</b>: Setting TimeZone: America/New_York<br>
DEBUG [54]:	<b>[Function]()</b>: Bypassing Authentication<br>
DEBUG [404]:	<b>TTi18n::chooseBestLocale()</b>: Choosing Best Locale...<br>
DEBUG [375]:	<b>TTi18n::getBrowserLanguage()</b>: HTTP_ACCEPT_LANGUAGE: en-us<br>
DEBUG [458]:	<b>TTi18n::chooseBestLocale()</b>: cSetting Locale: en_US<br>
DEBUG [322]:	<b>TTi18n::setLocale()</b>: Generated/Passed In Locale: en_US<br>
DEBUG [256]:	<b>TTi18n::generateLocale()</b>: Array of Locales to try in order: en_US,en<br>
DEBUG [207]:	<b>TTi18n::tryLocale()</b>: Found valid windows locale: English_United States.1252 Linux locale: en_US<br>
DEBUG [215]:	<b>TTi18n::tryLocale()</b>: Found valid locale: en_US<br>
DEBUG [328]:	<b>TTi18n::setLocale()</b>: Attempting to set Locale(s) to: en_US Category: 0 Current Locale: <br>
DEBUG [331]:	<b>TTi18n::setLocale()</b>: Setting currency/numeric Locale to: en_US<br>
DEBUG [344]:	<b>TTi18n::setLocale()</b>: Setting translator locale to: en_US<br>
DEBUG [361]:	<b>TTi18n::setLocale()</b>: Set Master Locale To: en_US<br>
DEBUG [467]:	<b>TTi18n::chooseBestLocale()</b>: Using Locale: en_US<br>
DEBUG [94]:	<b>Install::isInstallMode()</b>: Install Mode is ON<br>
DEBUG [85]:	<b>[Function]()</b>: Next<br>
DEBUG [279]:	<b>Install::checkDatabaseExists()</b>: Database Name: timetrex<br>
DEBUG [289]:	<b>Install::checkDatabaseExists()</b>: Exists - Database Name: timetrex<br>
DEBUG [279]:	<b>Install::checkDatabaseExists()</b>: Database Name: timetrex<br>
DEBUG [289]:	<b>Install::checkDatabaseExists()</b>: Exists - Database Name: timetrex<br>
DEBUG [109]:	<b>[Function]()</b>: yDatabase does exist...<br>
DEBUG [237]:	<b>Install::writeConfigFile()</b>: Modified Config File!<br>
DEBUG [38]:	<b>Redirect::page()</b>: Redirect URL: DatabaseSchema.php?external_installer=<br>
---------------[ Fri, 31 Oct 2008 16:07:55 -0400 (PID: 3576) ]---------------
---------------[ Fri, 31 Oct 2008 16:07:55 -0400 (PID: 3576) ]---------------
DEBUG [77]:	<b>[Function]()</b>: Error connecting to the database!<br>
DEBUG [43]:	<b>DBError::__construct()</b>: mysqlt error: [1045: Access denied for user 'root'@'ohtadc.ohtacoding.com' (using password: YES)] in CONNECT(ohtadc, 'root', '****', timetrex)
<br>
---------------[ Fri, 31 Oct 2008 16:07:55 -0400 (PID: 3576) ]---------------
---------------[ Fri, 31 Oct 2008 16:07:56 -0400 (PID: 3576) ]---------------
DEBUG [77]:	<b>[Function]()</b>: Error connecting to the database!<br>
DEBUG [43]:	<b>DBError::__construct()</b>: mysqlt error: [1045: Access denied for user 'root'@'ohtadc.ohtacoding.com' (using password: YES)] in CONNECT(ohtadc, 'root', '****', timetrex)
<br>
---------------[ Fri, 31 Oct 2008 16:07:56 -0400 (PID: 3576) ]---------------
---------------[ Fri, 31 Oct 2008 16:07:56 -0400 (PID: 3576) ]---------------
DEBUG [111]:	<b>TTDate::setTimeZone()</b>: Setting TimeZone: America/New_York<br>
DEBUG [54]:	<b>[Function]()</b>: Bypassing Authentication<br>
DEBUG [404]:	<b>TTi18n::chooseBestLocale()</b>: Choosing Best Locale...<br>
DEBUG [375]:	<b>TTi18n::getBrowserLanguage()</b>: HTTP_ACCEPT_LANGUAGE: en-us<br>
DEBUG [458]:	<b>TTi18n::chooseBestLocale()</b>: cSetting Locale: en_US<br>
DEBUG [322]:	<b>TTi18n::setLocale()</b>: Generated/Passed In Locale: en_US<br>
DEBUG [256]:	<b>TTi18n::generateLocale()</b>: Array of Locales to try in order: en_US,en<br>
DEBUG [207]:	<b>TTi18n::tryLocale()</b>: Found valid windows locale: English_United States.1252 Linux locale: en_US<br>
DEBUG [215]:	<b>TTi18n::tryLocale()</b>: Found valid locale: en_US<br>
DEBUG [328]:	<b>TTi18n::setLocale()</b>: Attempting to set Locale(s) to: en_US Category: 0 Current Locale: <br>
DEBUG [331]:	<b>TTi18n::setLocale()</b>: Setting currency/numeric Locale to: en_US<br>
DEBUG [344]:	<b>TTi18n::setLocale()</b>: Setting translator locale to: en_US<br>
DEBUG [361]:	<b>TTi18n::setLocale()</b>: Set Master Locale To: en_US<br>
DEBUG [467]:	<b>TTi18n::chooseBestLocale()</b>: Using Locale: en_US<br>
---------------[ Fri, 31 Oct 2008 16:07:56 -0400 (PID: 3576) ]---------------

Shaun · Post by **Shaun** » Fri Oct 31, 2008 1:19 pm

Shaun,

The logs for the errors mentioned so far are consistent with a verbosity setting = 10.

We did try to use a verobisty setting = 11, however this yielded a different error message. This error message indicated the connection could not be established to the DB and to make sure the MySQL service was running.

Thanks
-Shaun

Post by **shaunw** » Sat Nov 01, 2008 12:41 pm

DEBUG [43]: <b>DBError::__construct()</b>: mysqlt error: [1045: Access denied for user 'root'@'ohtadc.ohtacoding.com' (using password: YES)] in CONNECT(ohtadc, 'root', '****', timetrex)

Yup, that is definitely causing a problem, it looks like your root password is either incorrect, or your MySQL isn't setup to allow root access from the web server or remote computers.

TimeTrex Time and Attendance

Step 3: DB config error

Step 3: DB config error

show engines results

Logs

verbosity settings

Time and Attendance