Install blues (V2.0.2)

[WCC-gro]

I'm trying to install Timetrex V2.0.2 on SuSE Linux ES10, php 5.2.3, MySql 5.0.41.

On step 2:
Button Next greyed out, even with memory limit set to 128M, and everything showing OK.

Used the URL: ...../install/DatabaseConfig.php to go to step 3.

On step 3, cliking Next, got the following error:

EXCEPTION!
=============================================
Error message: Invalid Data, not saving.
Error code: 0
Script Name: /datas/httpd-data/timetrex/classes/modules/core/Factory.class.php
Line Number: 765
=============================================
EXCEPTION!


Looking on MySql, the database and the tables appears to be created OK.

The Apache error log is as follow:

[Fri Jul 13 09:27:43 2007] [error] [client 10.10.3.100] PHP Warning: fopen(pre_install.php?v=2.0.2S&page=postupgrade) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Connection timed out in /datas/httpd-data/timetrex/interface/install/PostUpgrade.php on line 71, referer: [removed] timetrex/interface/install/DatabaseConfig.php?data%5Btype%5D=mysqlt&data%5Bhost%5D=localhost&data%5Bdatabase_name%5D=timetrex&data%5Buser%5D=timetrex&data%5Bpassword%5D=timetrex4m%25u&data%5Bpriv_user%5D=&data%5Bpriv_password%5D=&action%3Atest_connection=Test+Connection

[Fri Jul 13 09:27:43 2007] [error] [client 10.10.3.100] PHP Warning: fclose(): supplied argument is not a valid stream resource in /datas/httpd-data/timetrex/interface/install/PostUpgrade.php on line 72, referer: [removed] timetrex/interface/install/DatabaseConfig.php?data%5Btype%5D=mysqlt&data%5Bhost%5D=localhost&data%5Bdatabase_name%5D=timetrex&data%5Buser%5D=timetrex&data%5Bpassword%5D=timetrex4m%25u&data%5Bpriv_user%5D=&data%5Bpriv_password%5D=&action%3Atest_connection=Test+Connection

Note: I have removed part of the referer in the above logs.


Best regards
Georges Rosset
World Council of Churches
Geneva / Switzerland
http://wcc-coe.org

[shaunw]

Can you try installing v2.0.1 and see it works any better?

[shaunw]

Oh yeah, your MySQL version is buggy too, see:
http://forums.timetrex.com/viewtopic.php?t=298

[WCC-gro]

Thank you for your answers.

I have tried to install version 2.0.1. I have the same error.

I can't install an older version of MySql. The machine has other applications in production and using MySql.

So, I guess I will have to go on without Timetrex.

Georges Rosset
World Council of Churches
Geneva

[shaunw]

Yeah, unfortunately MySQL is taking their time releasing the next version. You could always install PostgreSQL for TimeTrex.

The issue you are seeing shouldn't happen regardless of the version of MySQL you are using, which we would be happy to further diagnose with you. But even after it installs there are other issues that will crop up due to the MySQL bugs. So its up to you if you want to continue or not.

[WCC-gro]

Thank you for your answer.

We would like to try Timetrex. So we would be very happy for any help to get the product installed. Then, if it suit our need (we only need the Time management) we would build a dedicated server, with the right version of MySql needed.

So far I'm at the same point as my first message. As we have updated all our MySql servers to version 5.0.45, I have tried also the install TimeTrex on a server with this version of MySql. I have the same error message on step 4, and on step 2 the Next button is greyed out.

Thanking you,
Best regards.

Georges Rosset
World Council of Churches
Geneva / Switzerland.

[shaunw]

Try installing the php-calendar extension, that should hopefully fix the "Next" button being grayed out issue.

As far as the invalid data issue, we will need more information to figure out what is going on. It could be related to manually skipping the Requirements page though. So lets try to fix one thing at a time.

[WCC-gro]

Dear Shaunw,

I have now re-compiled PHP with the php-calendar enabled.

In Step 2, the button Next is now available.

To make a clean start, I have deleted the MySql timetrex database and user, and recreated them. The timetrex database is set with the latin1_general_ci collation. I have given the timetrex user full rights to the timetrex database. Checked again that all the required timetrex directories are set with writing rights for the Apache user. In timetrex.php.ini, the base usrl is set to /timetrex/interface. Note that this machine has no access to the Internet.

In Step 3, testing the connection return OK.

In Step 4, accepted default values for directories.

Next step return with the following Exception:

======================================
Error message: Invalid Data, not saving.
Error code: 0
Script Name: /datas/httpd-data/timetrex/classes/modules/core/Factory.class.php
Line Number: 765
======================================

However, 91 tables are ceated in the timetrex database. The field salt in the timetrex.php.ini has been modified from 0 to a 32 cacacters value.

The Apache error log contains the following:

======================================
[Wed Jul 18 11:15:55 2007] [error] [client 10.10.3.100] PHP Warning: fopen(pre_install.php?os=Linux&php_version=5.2.3&redir=1&web_server=Apache%2F2.0.59+%28Unix%29&url=[removed]%3A80%2Ftimetrex%2Finterface%2Finstall%2Finstall.php) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Connection timed out in /datas/httpd-data/timetrex/interface/install/install.php on line 89

[Wed Jul 18 11:15:55 2007] [error] [client 10.10.3.100] PHP Warning: fclose(): supplied argument is not a valid stream resource in /datas/httpd-data/timetrex/interface/install/install.php on line 90

[Wed Jul 18 11:16:00 2007] [error] [client 10.10.3.100] PHP Warning: fopen(pre_install.php?v=2.0.2S&page=license) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Connection timed out in /datas/httpd-data/timetrex/interface/install/License.php on line 62

[Wed Jul 18 11:16:00 2007] [error] [client 10.10.3.100] PHP Warning: fclose(): supplied argument is not a valid stream resource in /datas/httpd-data/timetrex/interface/install/License.php on line 63

[Wed Jul 18 11:16:26 2007] [error] [client 10.10.3.100] PHP Warning: fopen(pre_install.php?v=2.0.2S&page=require&0=Require) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Connection timed out in /datas/httpd-data/timetrex/interface/install/Requirements.php on line 77, referer: [removed]/timetrex/interface/install/License.php

[Wed Jul 18 11:16:26 2007] [error] [client 10.10.3.100] PHP Warning: fclose(): supplied argument is not a valid stream resource in /datas/httpd-data/timetrex/interface/install/Requirements.php on line 78, referer: [removed]/timetrex/interface/install/License.php

[Wed Jul 18 11:17:30 2007] [error] [client 10.10.3.100] PHP Warning: fopen(pre_install.php?v=2.0.2S&page=system_setting) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Connection timed out in /datas/httpd-data/timetrex/interface/install/SystemSettings.php on line 132, referer: [removed]/timetrex/interface/install/DatabaseConfig.php?data%5Btype%5D=mysqlt&data%5Bhost%5D=localhost&data%5Bdatabase_name%5D=timetrex&data%5Buser%5D=timetrex&data%5Bpassword%5D=[removed]%25u&data%5Bpriv_user%5D=&data%5Bpriv_password%5D=&action%3Atest_connection=Test+Connection

[Wed Jul 18 11:17:30 2007] [error] [client 10.10.3.100] PHP Warning: fclose(): supplied argument is not a valid stream resource in /datas/httpd-data/timetrex/interface/install/SystemSettings.php on line 133, referer: [removed]/timetrex/interface/install/DatabaseConfig.php?data%5Btype%5D=mysqlt&data%5Bhost%5D=localhost&data%5Bdatabase_name%5D=timetrex&data%5Buser%5D=timetrex&data%5Bpassword%5D=[removed]%25u&data%5Bpriv_user%5D=&data%5Bpriv_password%5D=&action%3Atest_connection=Test+Connection

[Wed Jul 18 11:18:34 2007] [error] [client 10.10.3.100] PHP Warning: Cannot modify header information - headers already sent by (output started at /datas/httpd-data/timetrex/classes/modules/core/Exception.class.php:83) in /datas/httpd-data/timetrex/classes/modules/core/Redirect.class.php on line 38, referer: [removed]/timetrex/interface/install/SystemSettings.php
======================================

Please note that I have [removed] some fields in the logs above.

PHP version is 5.2.3, MySql version is 5.0.45, OS is Suse ES10 all patched uptodate.

We appreciate your support. Thank for your help.

Georges Rosset
World Council of Churches
Geneva / Switzerland

[shaunw]

Okay, so something on the System Setting page is causing the error then is what it sounds like. This page doesn't do much, so I wonder if the issue is that fact that your server doesn't have internet access. Try modifying interface/install/SystemSettings.php and find the following code about 20 lines from the bottom of the script:

Code: Select all

		$ttsc = new TimeTrexSoapClient();
		$ttsc->saveRegistrationKey();

Change them to:

Code: Select all

		//$ttsc = new TimeTrexSoapClient();
		//$ttsc->saveRegistrationKey();

See if that helps.

[WCC-gro]

Dear Shaunw,

That fixed the problem and I was able to complete the installtion normally. Timetrex is now working. Our HR department will now test it.

As I'm using MySql 5.0.45 instead of 5.0.37, could you tell me were should I expect some problems due to this version compability?

Thank you for all your help.
Best regards.
Georges Rosset
World Council of Churches
Geneva / Switzerland

[shaunw]

Great to hear that fixed the issue. As far as MySQL is concerned, they claim the bug is fixed in any version newer then 5.0.42, but we haven't had a chance to test it fully yet.

The bug in question only affected pay stub generation, so everything else should work fine regardless.

This is the MySQL bug:
http://bugs.mysql.com/bug.php?id=28936

So if you are knowledgeable in that area, you can definitely do a test on your own to confirm that the bug is fixed or not.