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?
Search found 144 matches
- Thu Dec 02, 2010 8:26 pm
- Forum: Installation Help
- Topic: How to back up the database on Ubuntu
- Replies: 13
- Views: 8422
- Thu Dec 02, 2010 6:27 pm
- Forum: Installation Help
- Topic: How to back up the database on Ubuntu
- Replies: 13
- Views: 8422
Re: How to back up the database on Ubuntu
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...
- Thu Dec 02, 2010 11:54 am
- Forum: Installation Help
- Topic: How to back up the database on Ubuntu
- Replies: 13
- Views: 8422
Re: How to back up the database on Ubuntu
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...
- Wed Dec 01, 2010 8:31 pm
- Forum: Installation Help
- Topic: How to back up the database on Ubuntu
- Replies: 13
- Views: 8422
Re: How to back up the database on Ubuntu
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?
- Sun Nov 28, 2010 3:33 pm
- Forum: Installation Help
- Topic: How to back up the database on Ubuntu
- Replies: 13
- Views: 8422
Re: How to back up the database on Ubuntu
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"?
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"?
- Sat Nov 27, 2010 5:18 pm
- Forum: Installation Help
- Topic: How to back up the database on Ubuntu
- Replies: 13
- Views: 8422
- Sat Nov 27, 2010 2:42 am
- Forum: Installation Help
- Topic: How to back up the database on Ubuntu
- Replies: 13
- Views: 8422
How to back up the database on Ubuntu
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
I have the timetrex.ini.php etc.
How does one backup and if neccesary restore the database?
O/S is Ubuntu 10.10
- Sun Nov 21, 2010 5:43 pm
- Forum: Help
- Topic: TimeTrex login error after Ubuntu upgrade to 10.10
- Replies: 7
- Views: 5472
Re: TimeTrex login error after Ubuntu upgrade to 10.10
Thanks, deleting the contents of the cache seems to have fixed it.
- Sun Nov 21, 2010 5:51 am
- Forum: Help
- Topic: TimeTrex login error after Ubuntu upgrade to 10.10
- Replies: 7
- Views: 5472
Re: TimeTrex login error after Ubuntu upgrade to 10.10
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...
- Fri Nov 19, 2010 11:27 am
- Forum: Help
- Topic: TimeTrex login error after Ubuntu upgrade to 10.10
- Replies: 7
- Views: 5472
Re: TimeTrex login error after Ubuntu upgrade to 10.10
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.
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.
- Fri Nov 19, 2010 2:51 am
- Forum: Help
- Topic: TimeTrex login error after Ubuntu upgrade to 10.10
- Replies: 7
- Views: 5472
TimeTrex login error after Ubuntu upgrade to 10.10
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...
- Sun Apr 11, 2010 5:51 pm
- Forum: Installation Help
- Topic: postgres fails on reboot after successful install
- Replies: 8
- Views: 6086
Re: postgres fails on reboot after successful install
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
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
- Sun Apr 11, 2010 8:55 am
- Forum: Installation Help
- Topic: postgres fails on reboot after successful install
- Replies: 8
- Views: 6086
Re: postgres fails on reboot after successful install
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...
- Thu Apr 08, 2010 10:39 am
- Forum: Installation Help
- Topic: postgres fails on reboot after successful install
- Replies: 8
- Views: 6086
Re: postgres fails on reboot after successful install
$ : /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...
- Thu Apr 08, 2010 9:32 am
- Forum: Installation Help
- Topic: postgres fails on reboot after successful install
- Replies: 8
- Views: 6086
Re: postgres fails on reboot after successful install
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 ...
- Wed Apr 07, 2010 6:05 pm
- Forum: Installation Help
- Topic: postgres fails on reboot after successful install
- Replies: 8
- Views: 6086
postgres fails on reboot after successful install
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...
- Wed Mar 31, 2010 12:56 pm
- Forum: Installation Help
- Topic: Migration to a new server
- Replies: 31
- Views: 14892
Re: Migration to a new server
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
- Wed Mar 31, 2010 10:37 am
- Forum: Installation Help
- Topic: Migration to a new server
- Replies: 31
- Views: 14892
Re: Migration to a new server
Still trying to get a correct connection to my mysql db
- Wed Mar 31, 2010 8:55 am
- Forum: Installation Help
- Topic: Migration to a new server
- Replies: 31
- Views: 14892
Re: Migration to a new server
That installed on the Postgresql db and ran ok including menus and US States.
- Tue Mar 30, 2010 5:26 am
- Forum: Installation Help
- Topic: Migration to a new server
- Replies: 31
- Views: 14892
Re: Migration to a new server
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 ...
- Tue Mar 30, 2010 4:32 am
- Forum: Installation Help
- Topic: Migration to a new server
- Replies: 31
- Views: 14892
Re: Migration to a new server
I have firebug installed and running
- Tue Mar 30, 2010 4:32 am
- Forum: Installation Help
- Topic: Migration to a new server
- Replies: 31
- Views: 14892
Re: Migration to a new server
Auto install uses Postgres I am using MySQL
- Fri Mar 26, 2010 9:30 am
- Forum: Installation Help
- Topic: Migration to a new server
- Replies: 31
- Views: 14892
Re: Migration to a new server
Yes, no luck. But I can try again over the weekend. Going to judge a 'Band' competition today.
- Fri Mar 26, 2010 5:43 am
- Forum: Installation Help
- Topic: Migration to a new server
- Replies: 31
- Views: 14892
Re: Migration to a new server
I'll work on it. As a SQA man it shouldn't be too hard to familiarize.
- Thu Mar 25, 2010 9:12 pm
- Forum: Installation Help
- Topic: Migration to a new server
- Replies: 31
- Views: 14892
Re: Migration to a new server
Ajax server? So how do I approach diagnosing that?