TimeTrex Time and Attendance

Wonderful!

Found out how to back up the database.

Tried upgrading from 3.0.8 to 3.3.1 it got to Upgrading database, please wait... 91% and froze there.

Should I have upgraded through intermediate versions?

As I said above My install was using the Zip file. I had previously tried the automated installer but it didn't work correctly and you advised me to use the Zip. I have a TimeTrex folder with those files dated Sept 18 through Sept 30th from that automated install attempt but my current install is in...

OK but Synaptec sees a postgresql client as installed but not the server. what connection settings should I be using? timtrex.php.ini says port 5433 but nothing else. If I install the postgresql server will it damage my TimeTrex database? Will it see the timetrex database. I never installed Postgres...

Ref my last post. Doesn't the result I'm getting suggest that PostgreSQL server is not running? If so how is TimeTrex accessing it?

Except that I get this:

sudo psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Zip file

In preparation for an upgrade I wish to back up my TimeTrex Postgresql database but nowhere do I see instructions for doing this.

I have the timetrex.ini.php etc.

How does one backup and if neccesary restore the database?

O/S is Ubuntu 10.10

Thanks, deleting the contents of the cache seems to have fixed it.

I attempt to log in. If I use an invalid UserID or password it behaves exactly as it should. If I use a correct User ID and password it goes to the URL: http://localhost:8085/interface/DownFor ... on=DBError which displays: TimeTrex is unable to connect to its database, please make sure that the dat...

http://localhost:8085/interface/Login.php.
I enter a valid login and password.
Then click Submit
Oh invalid Username or password gives what I would consider a correct failure to log in.

After Ubuntu upgrade from 10.04 to 10.10 - 32 bit TimeTrex log in goes to: http://localhost:8085/interface/DownForMaintenance.php?exception=DBError which displays: TimeTrex is unable to connect to its database, please make sure that the database has been started and is running. If I change the URL t...

The command in the crontab is:
su root -c "php /var/www/TimeTrex/timetrex/classes/modules/core/../../../maint/cron.php" > /dev/null 2>&1

I replaced with the line in the install_cron which seems to work. Thanks

Pretty much working now except i get: WARNING: TimeTrex maintenance jobs have not run in the last 48hours. Please contact your TimeTrex administrator immediately. The crontab entry seems to not be working but the manual operation shows as this: mick@mick-desktop:~su root -c "php /var/www/TimeTr...

$ : /var/www/TimeTrex$ /var/www/TimeTrex/stop Syntax OK /var/www/TimeTrex/apache2/scripts/ctl.sh : apache not running LOG: received smart shutdown request LOG: autovacuum launcher shutting down LOG: shutting down LOG: database system is shut down /var/www/TimeTrex/postgresql/scripts/ctl.sh : postgre...

I have to figure that out but initially I just ran it manually in a terminal. I was subsequently able to connect but got this: LOG: database system was shut down at 2010-04-08 12:22:37 EDT /var/www/TimeTrex/postgresql/scripts/ctl.sh : postgresql started at port 5433 LOG: autovacuum launcher started ...

Further to an earlier topic I installed on Ubuntu using the 3.0.8 auto installer since my mysql database was deemed unsuitable. The installation was to /var/www/TimeTrex all installed and started OK and I was able to initialize the company and log in filling in user and company details. I was even a...

Problem is I already have an active database on mySQL and it seems exported scripts will not run on PostgreSQL to reinstall that Db to Postgresql

Still trying to get a correct connection to my mysql db

That installed on the Postgresql db and ran ok including menus and US States.

The auto install with postgres came up with this: Error running gksu -u postgres "/var/www/TimeTrex/postgresql/bin/pg_ctl" start : child process exited abnormally Problem running post-install step. Installation may not complete correctly Error running /var/www/TimeTrex/postgresql/bin/psql ...

I have firebug installed and running

Auto install uses Postgres I am using MySQL

Yes, no luck. But I can try again over the weekend. Going to judge a 'Band' competition today.

I'll work on it. As a SQA man it shouldn't be too hard to familiarize.

Ajax server? So how do I approach diagnosing that?