Problems with new install of Projeqtor 5.0.1.

I am a new user of Projeqtor software, so please forgive any basic errors.
My server uses Fedora 22 x86_64 system, Kernel 4.0.6.

On initial startup the configuration file did not load, so I followed the instructions for the alternate method, as per the "Configuration" page of the manual.

First Problem - the parameters.php file is missing the line:

$paramDbPort = '5432'

It tries to load the $paramDbUser value as the port if this line is not placed in the file between the lines beginning with $DbHost and $DbUser

Second Problem (SHOW-STOPPER)
I have configured Projeqtor to connect to my PGSQL 9.4.4 database using port 5432, on IP address 127.0.0.2, PGSQL's PG_HBA.conf is set correctly for access via this address and port, as is the Postgresql.conf file.

I can see from the logs that the connection (127.0.0.2:5432) is being passed through to the database, but THEN,

PROJEQTOR sends a further connection request on 127.0.0.1:5432, which is being blocked at PG_HBA, as this port is allocated for use by other software.

Nowhere in my configuration file for Projeqtor have I given it permission to use 127.0.0.1, as it is used by a higher-priority software package.

WHY is Projeqtor attempting this connection, and HOW can it be prevented from doing so, and use the IP address configured?

EDIT: Selinux has been "tuned" to accept TCPIP connections from web applications (httpd) to PGSQL, so that is not the cause. Same result is achieved with "Permissive" setting.

This is as "show-stopper" and I need to get it sorted out. It may well be something I am doing (or not doing...). Please help.

Cheers,
Verncon.

Hi,

1. I have commented out the two default entries in /etc/hosts file, with NO CHANGE.

2. I confirmed that the parameters.php file is being seen and used - when I remove the SELINUX Boolean settting which permits TCP/IP traffic between httpd<->pgsql, I see the initial connection being blocked (and logged. When I change the IP Address in the parameters.php file, I see that change reflected in the log.

3. The redirect to 127.0.0.1 occurs only when the SELINUX Boolean setting is enabled, or "Permissive" mode is enabled.

4. I completely deleted the projeqtor 5.0.1 package and installed a fresh install of 5.0.2, the symptoms are the same. The initial attempt to set the database parameters from the initial web-page fails - the "waiting" symbol is spinning for about 5 seconds, and I cannot find any logs that show a connection attempt to the PGSQL database.

I have a database "projeqtor" created in PGSQL, does PROJEQTOR need to create it's own database, or will it use a pre-created one?

Cheers,
Verncon.

1. OK, not a problem - I have a created db, and also tried without it - did NOT like that

2. After configuring the settings, when I press the "OK" button, spinner runs for 2-5 secs, then nothing more - no "Continue" button or anything changed.

3. I MAY have a window to play around with SELINUX fully disabled over the weekend - will try to fit it in and post the results.

4. Attached is a STRACE dump of all the processes running for httpd and postgresql whilst I tried three (3) times pressing the "OK" button, with about 10 seconds between each attempt.

PGSQL Proceeses are:

• 3146
  
• 3147
  
• 3149
  
• 3150
  
• 3151
  
• 3152
  
• 3153

The HTTPD Processes in the file are:

• 3163
  
• 3164
  
• 3165
  
• 3166
  
• 3167
  
• 3168
  
• 3170
  
• 3171
  
• 3172
  
• 3173
  
• 3176

I am no expert at all on these traces, I hope you can see some anomaly or problem from them.

Cheers,
Verncon.

Hi,

I have disabled SELINUX, reloaded Projeqtor 5.0.2 and attempted to connect again, still the same problems as before.

The initial configuration screen will not load - after pressing OK, the spinner runs for a few seconds, then stops, with no "continue" button appearing. The STRACE file for all the processes of HTTPD and POSTGRESQL for this is attached, see "projeqtor_strace_11072015_selinux_disabled"

When I pre-load the parameters and set up the "parametersLocation" file, the result has not changed from what was reported previously. The STRACE file for all the processes of HTTPD and POSTGRESQL for this is attached, see "projeqtor_strace_11072015_selinux_disabled_preload"

Cheers,
Verncon