Problem in installing Timetrex on debian

[dkarora]

Hi
I am new to linux. I am using the debian version of it. I get the following error


Warning: Error parsing /var/www/apache2-default/includes/../timetrex.ini.php on line 46 in /var/www/apache2-default/includes/global.inc.php on line 59
1. License Acceptance

The installer has already been run, as a safety measure it has been disabled from running again. If you are absolutely sure you want to run it again, or upgrade your system, please go to your timetrex.ini.php file and set "installer_enabled" to "TRUE". The line should look like:

"installer_enabled = TRUE"

After this change has been made, you can click the "Start" button below to begin your installation. <b>After the installation is complete, you will want to change "installer_enabled" to "FALSE".</b>

Please help and suggest what to do to get it installed

[shaunw]

Please post your copy of:
/var/www/apache2-default/includes/../timetrex.ini.php

[dkarora]

adsad

[shaunw]

Put your password in quotes, or remove the "!" from it.

ie:

password = "shot!put"

or:

password = shot1put

[dkarora]

I put the password in double codes as you said but still the problem exists and it gives the same error

Please help

[dkarora]

will this software br used through the web browser or i have to use this using the command line

[shaunw]

TimeTrex is all web based once it is fully installed.

Are you still getting the _exact_ same error? There is a parse error on line 46 of your timetrex.ini.php file, I thought your password was line 46, but I could have been wrong. Did you try it without the quotes and without the exclamation mark, numbers or letters only?

[dkarora]

i got it installed with some warnings.......

Installation done

[dkarora]

i solved many of the probs but it still gives me the following errors
tell me how do i solve it

In order for your TimeTrex installation to function properly, please ensure all of the system check items listed below are marked as OK. If any are red, please take the necessary steps to fix them.
For installation support, please join our community forums or contact a TimeTrex support expert for Implementation Support Services.
TimeTrex Version: OK (v2.0.3)
PHP Version: OK (v5.2.0-8+etch7)
Database Engine: Invalid
PHP BCMATH Enabled: OK
PHP GETTEXT Enabled: OK
PHP CALENDAR Enabled: OK
PHP SOAP Enabled: OK
PEAR: OK
Writable TimeTrex Configuration File (timetrex.ini.php): OK
Writable Cache Directory: OK
Empty Cache Directory: OK
Writable Storage Directory: OK
Writable Log Directory: OK
PHP Safe Mode Turned Off: OK
PHP Magic Quotes GPC Turned Off: magic_quotes_gpc is On. (Please disable it in php.ini)
PHP Memory Limit: Warning: 16M (Set this to 128M or higher)

* Your TimeTrex configuration file (timetrex.ini.php) is located at:
/var/www/apache2-default/includes/../timetrex.ini.php

* Your PHP configuration file (php.ini) is located at:
/etc/php5/apache2/php.ini, the include path is: ""

[shaunw]

Database Engine: Invalid
PHP Magic Quotes GPC Turned Off: magic_quotes_gpc is On. (Please disable it in php.ini)
PHP Memory Limit: Warning: 16M (Set this to 128M or higher)

Looks like you don't have the PHP MySQL or PHP PostgreSQL (depending on which database you plan to use) extensions installed. You also need to disable magic quotes GPC and increase your memory limits in your php.ini file.

In debian the package names for PHP MySQL or PostgreSQL are usually:

php5-mysql
php5-pgsql

[dkarora]

I installed the software successfully.

It just doesnt allow me to login...... when I try to register into the system it gives me this message

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

Please help
What should i do now ??

Thanks

[shaunw]

Chances are there is an issue with your database. Either it can't connect, or there is a SQL/Permission issue. Check your PHP error log, or your MySQL error log.

You can also try running through the installation process completely again. When you get to the database page, click the "Test Connection" button to ensure the connection does in fact work.

[dkarora]

Test connection works perfectly........

When I press next after test connection is stops and doesnt proceed
so i directly go to login page and try to login it says invalid username

so the thing is i m nt allowed to register or login

so i m stuck

how do i check mysql or php error log ???

[shaunw]

Okay, the installation process is failing then. I would guess its a permission issue, please follow this FAQ entry on creating the MySQL database and TimeTrex users:

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

Re-run the installer when you done of course.

[dkarora]

Its installed properly i suppose it doesnt run or doesnt allow me to login

I used create timetrex but it gave me error timetrex exists
that means database is made by it.......


wat should i do now ?

[dkarora]

I tried changing password and also gave the permissions as you suggested

Still it gaves the same error

Timetrex is under maintenance !!

[shaunw]

Did you delete the TimeTrex database and re-create it from scratch as per that FAQ entry?

[dkarora]

Yes i did and still it shows me the same error

TimeTrex is under maintenance !!

[shaunw]

Okay, you are going to have to check your PHP error log and TimeTrex error logs to see if anything useful is in there. That maintenance page usually only appears when there is a SQL error of some sort.

Of course you can always try our automated Linux installer if you want.

[dkarora]

how do i use that ??
can you tell me ??

I am working on it from the last 2 weeks
Please tell me how to do it. I need to install it as my boss wants it as soon as possible

[shaunw]

Simply download the Linux Installer binary from the following link, then execute it on your Linux server.
http://sourceforge.net/project/showfile ... _id=549364

If you are in a hurry to get TimeTrex installed, you may want to consider our Installation Support package where we can install it for you. Contact sales@timetrex.com if you are interested in this.

[dkarora]

I have installed the software

It gives me a warning that

WARNING: TimeTrex was unable to set your time zone. Please contact your TimeTrex administrator immediately. For more information please click here.


I clicked on the link and downloaded the zip file and followed the instructions too

But those instructions were for Windows and not for linux or debian

so please suggest what i need to do now ?

[shaunw]

Follow the Linux instructions here:
http://forums.timetrex.com/viewtopic.php?t=40

[dkarora]

I run those commands but still it gives the same problem !!

It also gave me some warnings which i am posting below

INSERT INTO time_zone_transition_type (Time_zone_id, Transition_type_id, Offset, Is_DST, Abbreviation) VALUES
(@time_zone_id, 0, 3600, 1, 'WEST')
,(@time_zone_id, 1, 0, 0, 'WET')
;
INSERT INTO time_zone (Use_leap_seconds) VALUES ('Y');
SET @time_zone_id= LAST_INSERT_ID();
INSERT INTO time_zone_name (Name, Time_zone_id) VALUES ('right/Zulu', @time_zone_id);
INSERT INTO time_zone_transition_type (Time_zone_id, Transition_type_id, Offset, Is_DST, Abbreviation) VALUES
(@time_zone_id, 0, 0, 0, 'UTC')
;
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
ALTER TABLE time_zone_transition ORDER BY Time_zone_id, Transition_time;
ALTER TABLE time_zone_transition_type ORDER BY Time_zone_id, Transition_type_id;

[shaunw]

Okay, which timezone do you have selected in your preferences?

Have you tried a different one? Like GMT to see if it works?

MySQL doesn't support all the time zones that TimeTrex does, so sometimes that can be the issue.