New Install 5.0.3 Fails.

Hi,

Since I am getting no progress attempting to correct the ongoing Audit issues, I have cleaned EVERYTHING out and doing a complete clean install of the database instance & Projeqtor using 5.0.3, I am getting the following:

"impossible to write \'../tool/parametersLocation.php\' file, cannot write to such a file" when I try to send the initial configuration file.

Below this line is a "Continue" button, which bounces me back to the original default parameters screen.
I do not know WHERE this file location \'../tool/parametersLocation.php\' is coming from, as I have defined the following file locations for the files (following Babynuz' advice earlier);

Configurations => /var/www/wwwFiles/config/
Logs => /var/www/wwwFiles/logs/
Reports => /var/www/wwwFiles/report/
Attachments => /var/www/wwwFiles/attach/

All these directories are created, and owned by httpd owner (apache:apache).

Please help me get this sorted......

Regards,
VERNCon.

Hi,
The files created by "unzip projeqtorV5.0.3.zip" were not owned by apache:apache, but by root:root, and they were 755.

I have since changed the ownership to apache:apache, so now at least it will attempt to send the parameters to the database - but NOT successfully.....

I have:

1. Set SELINUX to Permissive
2. Cleaned out all directories on both the server and the browser PC of anything related to old installations & restarted both units
3. Created a new database named "projeqtor" with ownership of "projeqtor" (same names as used on previous install)
4. Checked the unix socket connection to postgresql, it is working fine, bound and carrying traffic.

I am now getting the following log output on the PGSQL logs, when I try to get projeqtor installation to build the DB.

This is the log from one attempt at getting the system to start up, taken from the DB restart after the server reboot.

Please advise what this means, and if there are other steps to take to isolating this problem.

Regards,
VERNCon.

FATAL: the database system is starting up
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where parameter.idUser is null and parameter.idProject is null and parameter.parameterCode='dbVersion'
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)
ERROR: relation "parameter" does not exist at character 15
STATEMENT: select * from parameter where (idUser is null and idProject is null)

Got it solved.

Had to go back and install 4.5.7 (actually showed as V4.5.6 after install), as no matter what I did I could not get 5.0.3 to install.

Faults varied from doing nothing after entering the initial data, to accepting the data but not writing anything into the tables - waited for over 1 hour , but still nothing.

Once V4.5.6 was installed the upgrade to 5.0.3 appeared to go smoothly, but still have not completed running my own checks on everything, so I will not say all is perfect, yet.

VERNCon.