TimeTrex Time and Attendance

Hi,

When updating a get this error.

Please see attached file.

Br,

Henrik

And if you try to update to 7.0.0 first you get this error.

Pls. see attached file

Br,

Henrik

If you try to run the exact command specified in the first screenshot manually at a command prompt, do you get any error message?

If I first upgrade to 7.0.0 and the installer stops at the httpd.exe error. Running the command manually I get and error regarding MSVCR100.dll

When you try to upgrade from 5.3.3 to 7.0.1 and the installer stops at the postgresql error. Running the command manually you get prompted for password.

What is the exact error that you receive trying to upgrade from v5.3.3 to v7.0.1?

The installer fails when trying to run pg_dumpall.exe
Looking at the event viewer it look like a password error for the user postgres.

Event Type: Error
Event Source: PostgreSQL
Event Category: None
Event ID: 0
Date: 20-06-2013
Time: 09:30:30
User: N/A
Computer: XXXX
Description:
The description for Event ID ( 0 ) in Source ( PostgreSQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: FATAL: password authentication failed for user "postgres"
.

Is your TimeTrex installation currently in working order?

Can you attach your c:\timetrex\install.log file here as well?

Yes, it is in working order.

Here's the install log from may 2'nd 2013

Can you also attach your timetrex.ini.php file and c:\timetrex\backup_database.bat ? I'm guessing that the database passwords in each may be different for some reason...

Passwords seems to be identical.

The error is definitely a password error according to your event log, which the only way I can see as being possible is if in fact the passwords are different than what are specified in your timetrex.ini.php and backup_database.bat file. The installer basically runs the exact command in the backup_database.bat file, so if that file is working and is creating a backup of your database, there should be no reason why the installer fails.

Do you have recently dated .SQL files in your c:\timetrex\ directory? Would it be possible to attach a screenshot showing all the files in c:\timetrex\. If you edit your backup_database.bat file and remove the first @ECHO OFF line, then run that file from the command prompt, what output do you see?

It's an password error. If I create a new superuser in Postgres, change backup_database.bat to use the new user an run it. Then it runs correctly. But I can see that the .sql file get's named wrong. Instead of adding _yyyy mm dd to the filename it adds _on.

I don't have any .sql file in the c:\timetrex directory.

If I run backup_database.bat without changes I get the password error as seen in the attached file error_echo_off.jpg

If I change the backup_database.bat to fit the new user an runs it. Then it works, but I get an .sql file with the wrong name as seen in error_reg_on.jpg

Br,

Henrik

Okay, so because its a password issue, there isn't much our installer can do as it has no knowledge of the Postgres user's password to properly migrate the database. Having said that though the installer for TimeTrex v7.0.2 (due out in the next day or two) will try to work around this case (without knowing the password) and still allow the upgrade to occur.

I would see if that version allows the upgrade to happen.

Ok, thanks.

I have tried to solve the problem by changing the password for the user postgres in postgreSQL to the same password as in backup_database.bat. By doing so the update from 5.3.3 to 7.0.1 seems to work now

Br,

Henrik

And it works. Thanks for pointing to a solution. I know some people that will be mighty happy when then come to work.

Br,

Henrik

Small issue apparently still exists after upgrade. The maintenance job will not run. If I try to run the command C:\TimeTrex\php\php-win.exe "C:\TimeTrex\timetrex\maint\cron.php" manually. I get this error (pls. see error_app.jpg)

And the error too (Pls. see error_app_2.jpg)

HenrikH wrote:And the error too (Pls. see error_app_2.jpg)

I tried to solve by upgrading to 7.0.2. But the problem still remains. Attached is install and error log.

The libintl.dll can be copied from c:\timetrex\postgresql\bin\ to c:\timetrex\php to fix that error message. This issue was fixed in v7.0.1 but if you already upgraded to v7.0.0 it has to be fixed manually.

As for the kernel32.dll error, that appears to be caused by the PHP-APC extension, but just to confirm what operating system are you running?

I'm running Windows 2003 r2 64.

Thanks for the info. All systems are now green After a restart of the server and a update to 7.0.2.

Br,

Henrik