TimeTrex is currently undergoing maintenance

[tmdog]

Help I get this message after the 4th step.

TimeTrex is currently undergoing maintenance. We're sorry for any inconvenience this may cause. Please try back later.

I'm using a Windows XP Box with XAMPP installed on it.

Thanks

[shaunw]

Please see this FAQ entry:

http://forums.timetrex.com/viewtopic.php?t=89

[tmdog]

When I first post my issue the problem that I am having was: ( TimeTrex is currently undergoing maintenance. We're sorry for any inconvenience this may cause. Please try back later.)

Since then when I recieved your reply to follow this link (http://forums.timetrex.com/viewtopic.php?t=89)

I have preform the changes, now I am not getting pass the Licence page.

The follow information is be low.

What version of TimeTrex you are running, specifically. (stating "the latest version" is not specific enough)

What version of PHP you are using? PHP Ver. 5.2.1

What operating system you are running? Microsoft Windows XPsp2

What web server you are using? Apache 2.2.4 (Win32) (XAMPP 1.6.1)

MYSQL ver. 5.0.37

Debug Buffer
============================================================================
Memory Usage: 3010392
----------------------------------------------------------------------------
DEBUG [167]: [Function](): URI: /timetrex/interface/install/License.php
DEBUG [169]: [Function](): Production: 1
DEBUG [50]: [Function](): Bypassing Authentication
DEBUG [263]: TTi18n::chooseBestLocale(): Choosing Best Locale...
DEBUG [305]: TTi18n::chooseBestLocale(): cSetting Locale: en_us
DEBUG [191]: TTi18n::setLocale(): Attempting to set Locale to: en_us Category: 0
DEBUG [194]: TTi18n::setLocale(): bAttempting to set Locale to: en_us
DEBUG [196]: TTi18n::setLocale(): Failed setting i18n locale: en_us
DEBUG [316]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [89]: Install::isInstallMode(): Install Mode is ON
============================================================================

============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 0.0000 ms (0.00 %) unprofiled

3382.6330 ms (100.00 %) Missed
============================================================================
3382.6330 ms (100.00 %) OVERALL TIME
============================================================================

[tmdog]

TimeTrex Version is v1.6.4

Thanks

[shaunw]

Okay, if you set your debug verbosity to 10 in your timetrex.ini.php file, then edit interface/install/DatabaseConfig.php and under the line:

case 'install_schema':

Uncomment the Debug::Verbosity line so it looks like this:

Code: Select all

//Need to create the tables after the database
//exists and Database.inc.php has made a connection.
//Otherwise we can't use objects yet.
Debug::setVerbosity(11);

Then try running the installer again.

[tmdog]

Down for Maintenance

TimeTrex is currently undergoing maintenance. We're sorry for any inconvenience this may cause. Please try back later.



Server response time: 0.186 seconds.
Copyright © 2007 TimeTrex. All Rights Reserved.



Debug Buffer
============================================================================
Memory Usage: 2648328
----------------------------------------------------------------------------
DEBUG [167]: [Function](): URI: /timetrex/interface/DownForMaintenance.php?exception=DBError
DEBUG [169]: [Function](): Production: 1
DEBUG [50]: [Function](): Bypassing Authentication
DEBUG [263]: TTi18n::chooseBestLocale(): Choosing Best Locale...
DEBUG [305]: TTi18n::chooseBestLocale(): cSetting Locale: en_us
DEBUG [191]: TTi18n::setLocale(): Attempting to set Locale to: en_us Category: 0
DEBUG [194]: TTi18n::setLocale(): bAttempting to set Locale to: en_us
DEBUG [196]: TTi18n::setLocale(): Failed setting i18n locale: en_us
DEBUG [316]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
============================================================================

============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 0.0000 ms (0.00 %) unprofiled

179.0709 ms (100.00 %) Missed
============================================================================
179.0709 ms (100.00 %) OVERALL TIME
============================================================================

[shaunw]

If the debug verbosity is set to 11 properly you should never be sent to the down for maintenance page. So you missed a step somewhere.

[tmdog]

Should I change the timetrex.ini.php verbosity back to 11 ? I am at a stand still as to what I should do.

Thanks

[tmdog]

I made the changes to timetrex.ini.php verbosity 11, know the License screen is all that I get.

is there anything I could do or check?

[shaunw]

The way it works is debug verbosity setting of 11 tells TimeTrex not to redirect you to other pages. So when its set to 11 you won't be able to get past any page, which you are currently seeing by not being able to get past the license page.

However, when you get to the database config page, by enabling debug verbosity 11 in a specific part of the file as I described, it should stop TimeTrex from redirecting you to the down for maintenance page so we can actually capture the errors to see what is going on.

Please post the first 50-100 lines of your interface/install/DatabaseConfig.php

[tmdog]

<?php
/*********************************************************************************
* The contents of this file are subject to the TimeTrex Public License Version
* 1.1.0 ("License"); You may not use this file except in compliance with the
* License. You may obtain a copy of the License at http://www.TimeTrex.com/TPL
* Software distributed under the License is distributed on an "AS IS" basis,
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License
* for the specific language governing rights and limitations under the
* License.
*
* All copies of the Covered Code must include on each user interface screen:
* (i) the "Powered by TimeTrex" logo and
* (ii) the TimeTrex copyright notice
* in the same form as they appear in the distribution. See full license for
* requirements.
*
* The Original Code is: TimeTrex Open Source
* The Initial Developer of the Original Code is TimeTrex Payroll Services
* Portions created by TimeTrex are Copyright (C) 2004-2007 TimeTrex Payroll Services;
* All Rights Reserved.
*
********************************************************************************/
/*
* $Revision: 700 $
* $Id: DatabaseConfig.php 700 2007-03-22 20:38:51Z ipso $
* $Date: 2007-03-22 13:38:51 -0700 (Thu, 22 Mar 2007) $
*/
if ( !isset($_GET['action'])
OR ( isset($_GET['action']) AND strtolower($_GET['action']) != 'install_schema' ) ) {
$disable_database_connection = TRUE;
}
require_once('../../includes/global.inc.php');
ini_set( 'max_execution_time', 3600 );

//Debug::setVerbosity(11);

$authenticate = FALSE;
require_once(Environment::getBasePath() .'includes/Interface.inc.php');


$title = '3. Database Configuration';
$smarty->assign('title', $title);

/*
* Get FORM variables
*/
extract (FormVariables::GetVariables(
array (
'action',
'data',
) ) );

$install_obj = new Install();
if ( $install_obj->isInstallMode() == FALSE ) {
Redirect::Page( URLBuilder::getURL(NULL, 'install.php') );
}

$database_engine = TRUE;

$action = strtolower($action);
switch ($action) {
case 'back':
Debug::Text('Back', __FILE__, __LINE__, __METHOD__,10);

Redirect::Page( URLBuilder::getURL(NULL, 'Requirements.php') );
break;

case 'install_schema':
//Need to create the tables after the database
//exists and Database.inc.php has made a connection.
//Otherwise we can't use objects yet.
Debug::setVerbosity(11);
Debug::Text('Install Schema', __FILE__, __LINE__, __METHOD__,10);

$install_obj->setDatabaseConnection( $db ); //Default connection
if ( $install_obj->checkDatabaseExists( $config_vars['database']['database_name'] ) == TRUE ) {
if ( $install_obj->checkTableExists( 'system_setting') == TRUE ) {
$install_obj->setIsUpgrade( TRUE );
$upgrade = TRUE;
} else {
$install_obj->setIsUpgrade( FALSE );
$upgrade = FALSE;
}

//Create SQL, always try to install every schema version, as
//installSchema() will check if its already been installed or not.
$install_obj->setDatabaseDriver( $config_vars['database']['type'] );
$install_obj->createSchemaRange( NULL, NULL ); //All schema versions
//FIXME: Notify the user of any errors.
$install_obj->setVersions();
} else {
Debug::Text('bDatabase does not exist.', __FILE__, __LINE__, __METHOD__,10);
}

if ( $upgrade == TRUE ) {
Redirect::Page( URLBuilder::getURL( NULL, 'PostUpgrade.php') );
} else {
Redirect::Page( URLBuilder::getURL( NULL, 'SystemSettings.php') );
}

break;
case 'next':
Debug::Text('Next', __FILE__, __LINE__, __METHOD__,10);
//Debug::setVerbosity(11);

if ( isset($data) AND isset($data['priv_user']) AND isset($data['priv_password'])
AND $data['priv_user'] != '' AND $data['priv_password'] != '' ) {
$tmp_user_name = $data['priv_user'];
$tmp_password = $data['priv_password'];
} elseif ( isset($data) ) {
$tmp_user_name = $data['user'];
$tmp_password = $data['password'];
}

$test_db_connection = $install_obj->setNewDatabaseConnection($data['type'], $data['host'], $tmp_user_name, $tmp_password,'');
if ( $install_obj->checkDatabaseExists($data['database_name']) == FALSE ) {
Debug::Text('Creating Database', __FILE__, __LINE__, __METHOD__,10);
$install_obj->createDatabase( $data['database_name'] );
}

//Make sure InnoDB engine exists on MySQL
if ( $install_obj->getDatabaseType() != 'mysql' OR ( $install_obj->getDatabaseType() == 'mysql' AND $install_obj->checkDatabaseEngine() == TRUE ) ) {
//Check again to make sure database exists.
$db_connection = $install_obj->setNewDatabaseConnection($data['type'], $data['host'], $tmp_user_name, $tmp_password,$data['database_name']);
if ( $install_obj->checkDatabaseExists($data['database_name']) == TRUE ) {
//Create SQL
Debug::Text('yDatabase does exist...', __FILE__, __LINE__, __METHOD__,10);

$install_obj->writeConfigFile( $data );

Redirect::Page( URLBuilder::getURL( array('action' => 'install_schema'), 'DatabaseConfig.php') );
//Redirect::Page( URLBuilder::getURL( NULL, 'Requirements.php') );

break;
} else {
Debug::Text('zDatabase does not exist.', __FILE__, __LINE__, __METHOD__,10);
}
} else {
$database_engine = FALSE;
Debug::Text('MySQL does not support InnoDB storage engine!', __FILE__, __LINE__, __METHOD__,10);
}
default:
if ( $action == 'test connection' ) {

//Test regular user
//This used to connect to the template1 database, but it seems newer versions of PostgreSQL
//default to disallow connect privs.
$test_connection = $install_obj->setNewDatabaseConnection($data['type'], $data['host'], $data['user'], $data['password'], $data['database_name']);
if ( $test_connection == TRUE ) {
$database_exists = $install_obj->checkDatabaseExists($data['database_name']);
}

//Test priv user.
if ( $data['priv_user'] != '' AND $data['priv_password'] != '' ) {
Debug::Text('Testing connection as priv user', __FILE__, __LINE__, __METHOD__,10);
$test_priv_connection = $install_obj->setNewDatabaseConnection($data['type'], $data['host'], $data['priv_user'], $data['priv_password'], '');
} else {
$test_priv_connection = TRUE;
}
} else {
$test_connection = NULL;
$test_priv_connection = NULL;
}

$data['test_connection'] = $test_connection;
$data['test_priv_connection'] = $test_priv_connection;
$data['database_engine'] = $database_engine;

//Get DB settings from INI file.
if ( $action != 'test connection' ) {
$data = array(
'type' => $config_vars['database']['type'],
'host' => $config_vars['database']['host'],
'database_name' => $config_vars['database']['database_name'],
'user' => $config_vars['database']['user'],
'password' => $config_vars['database']['password'],
'test_connection' => $test_connection,
'test_priv_connection' => $test_priv_connection,
'database_engine' => $database_engine,
);
}

$data['type_options'] = $install_obj->getDatabaseTypeArray();

$smarty->assign_by_ref('data', $data);
break;
}

if ( !isset($data['priv_user']) ) {
$data['priv_user'] = NULL;
}
$handle = @fopen('http://www.timetrex.com/'.URLBuilder::getURL( array('v' => $install_obj->getFullApplicationVersion(), 'page' => 'database_config', 'priv_user' => $data['priv_user']), 'pre_install.php'), "r");
@fclose($handle);

$smarty->assign_by_ref('install_obj', $install_obj);
$smarty->display('install/DatabaseConfig.tpl');
?>

[shaunw]

The file looks fine. So if you go through the installer again, you should get to the Database Config page and when you press Next you get a screen with all kinds of debug info on it.

Are you seeing this?

If you are still seeing the down for maintenance page it must be failing at some other point.

[tmdog]

This is the Debug info. that I am currently getting with the verbosity set to 11. It will not le me go to the next page unless I set the verbosity to 10.

Hope this help.

Thanks again ( debug info below)

Debug Buffer
============================================================================
Memory Usage: 3096016
----------------------------------------------------------------------------
DEBUG [167]: [Function](): URI: /timetrex/interface/install/License.php
DEBUG [169]: [Function](): Production: 1
DEBUG [50]: [Function](): Bypassing Authentication
DEBUG [263]: TTi18n::chooseBestLocale(): Choosing Best Locale...
DEBUG [305]: TTi18n::chooseBestLocale(): cSetting Locale: en_us
DEBUG [191]: TTi18n::setLocale(): Attempting to set Locale to: en_us Category: 0
DEBUG [194]: TTi18n::setLocale(): bAttempting to set Locale to: en_us
DEBUG [196]: TTi18n::setLocale(): Failed setting i18n locale: en_us
DEBUG [316]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [53]: [Function](): Start
DEBUG [35]: Redirect::page(): Redirect URL: Requirements.php
DEBUG [89]: Install::isInstallMode(): Install Mode is ON
============================================================================

============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 0.0000 ms (0.00 %) unprofiled

565.5420 ms (100.00 %) Missed
============================================================================
565.5420 ms (100.00 %) OVERALL TIME
============================================================================

[shaunw]

Unfortunately we don't seem to be making any progress, so I'm going to recommend that you purchase our installation support package so we can help you further.

If you would like to do this please call 1-800-714-5153 for more information.

[vincently]

I found the same issue when the IP of the server changed. The solution is to edit the configuration file my.cnf of mysql and make sure the parameter "bind-address" matches with the IP of the server.