Forum

New Install 5.0.3 F...
 
Notifications
Retirer tout

New Install 5.0.3 Fails.

10 Posts
2 Utilisateurs
0 Reactions
9,490 Vu
(@verncon)
Posts: 41
Active Member
Début du sujet
 
[#2476]

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.


 
Posté : 31 Juil PM 16:077
(@babynus)
Posts: 14952
Membre Admin
 

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

Change write rights to this folder.
The /tool/parametersLocation.php is a fixed value : it contains value of location of parameters.php file.

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

But are they 755 ?


 
Posté : 31 Juil PM 18:077
(@verncon)
Posts: 41
Active Member
Début du sujet
 

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)


 
Posté : 31 Juil PM 19:077
(@babynus)
Posts: 14952
Membre Admin
 

These PG errors are not important.
They are normal suring setup process as several parameters are fetched, and they a serched in the db (which is not built yet).
These errors are trapped in ProjejeQtOr and don't lead to any issue.


 
Posté : 31 Juil PM 20:077
(@verncon)
Posts: 41
Active Member
Début du sujet
 

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.


 
Posté : 31 Juil PM 22:077
(@babynus)
Posts: 14952
Membre Admin
 

Could you post log of last update, for a check ?


 
Posté : 1 Août AM 02:088
(@verncon)
Posts: 41
Active Member
Début du sujet
 

Log file with new V4.5.6 install, then V4.5.6 => V5.0.3 attached.

Cheers,
VERNCon.


 
Posté : 1 Août PM 12:088
(@babynus)
Posts: 14952
Membre Admin
 

Setup process ended with no error.
Any remainong issue ?


 
Posté : 1 Août PM 13:088
(@verncon)
Posts: 41
Active Member
Début du sujet
 

At least not with the install - currently battling to get the phpMail to talk to Dovecot -> Postfix 3.0 (SMTP via SASL) for the out-going mail function.

Is there anywhere I need to reference the SSL cert & key files in Projeqtor's mailer system, or is that all handled elsewhere?

Cheers,
VERNCon.


 
Posté : 1 Août PM 14:088
(@babynus)
Posts: 14952
Membre Admin
 

SMTP connection via SSL Cert & key files is not taken into account in ProjeQtOr.
SSL connection requires user/password.


 
Posté : 1 Août PM 19:088
Share:
Retour en haut