Error updating community edition from 5.3.3 to 7.0.1
Error updating community edition from 5.3.3 to 7.0.1
Hi,
When updating a get this error.
Please see attached file.
Br,
Henrik
When updating a get this error.
Please see attached file.
Br,
Henrik
Re: Error updating community edition from 5.3.3 to 7.0.1
And if you try to update to 7.0.0 first you get this error.
Pls. see attached file
Br,
Henrik
Pls. see attached file
Br,
Henrik
Re: Error updating community edition from 5.3.3 to 7.0.1
If you try to run the exact command specified in the first screenshot manually at a command prompt, do you get any error message?
Re: Error updating community edition from 5.3.3 to 7.0.1
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
- Attachments
-
- error3.jpg (10.68 KiB) Viewed 12117 times
Re: Error updating community edition from 5.3.3 to 7.0.1
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.
Re: Error updating community edition from 5.3.3 to 7.0.1
What is the exact error that you receive trying to upgrade from v5.3.3 to v7.0.1?
Re: Error updating community edition from 5.3.3 to 7.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"
.
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"
.
Re: Error updating community edition from 5.3.3 to 7.0.1
Is your TimeTrex installation currently in working order?
Can you attach your c:\timetrex\install.log file here as well?
Can you attach your c:\timetrex\install.log file here as well?
Re: Error updating community edition from 5.3.3 to 7.0.1
Yes, it is in working order.
Here's the install log from may 2'nd 2013
Here's the install log from may 2'nd 2013
- Attachments
-
- install.log
- (323.69 KiB) Downloaded 274 times
Re: Error updating community edition from 5.3.3 to 7.0.1
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...
Re: Error updating community edition from 5.3.3 to 7.0.1
Passwords seems to be identical.
- Attachments
-
- timetrex.ini.txt
- Renamed since extension php is not allowed
- (1.39 KiB) Downloaded 272 times
-
- backup_database.txt
- Renamed since extension php is not allowed
- (504 Bytes) Downloaded 270 times
-
- install.log
- (323.69 KiB) Downloaded 266 times
Re: Error updating community edition from 5.3.3 to 7.0.1
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?
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?
Re: Error updating community edition from 5.3.3 to 7.0.1
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
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
Re: Error updating community edition from 5.3.3 to 7.0.1
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.
I would see if that version allows the upgrade to happen.
Re: Error updating community edition from 5.3.3 to 7.0.1
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
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
Re: Error updating community edition from 5.3.3 to 7.0.1
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
Br,
Henrik
Re: Error updating community edition from 5.3.3 to 7.0.1
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)
- Attachments
-
- error_app.jpg (10.41 KiB) Viewed 12008 times
Re: Error updating community edition from 5.3.3 to 7.0.1
And the error too (Pls. see error_app_2.jpg)
- Attachments
-
- error_app_2.jpg (10.08 KiB) Viewed 12007 times
Re: Error updating community edition from 5.3.3 to 7.0.1
I tried to solve by upgrading to 7.0.2. But the problem still remains. Attached is install and error log.HenrikH wrote:And the error too (Pls. see error_app_2.jpg)
- Attachments
-
- install.log
- (3.02 MiB) Downloaded 269 times
-
- upgrade_sql_error.log
- (455 Bytes) Downloaded 272 times
Re: Error updating community edition from 5.3.3 to 7.0.1
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?
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?
Re: Error updating community edition from 5.3.3 to 7.0.1
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
Thanks for the info. All systems are now green After a restart of the server and a update to 7.0.2.
Br,
Henrik