Hi,

First, Welcome to ProjeqTor Community.

To answer your problems.

1) If configuration page does not load, you may have some issue that you should solve instead of using a workaround
(even if I wrote the workaround, I really advide to take to normal way)
=> Try patch 5.0.2, it fixes some issues on some PHP distribs. it may help.

2) I looked at all projeqtor code : nowhere the host is configured to 127.0.0.1.
Fortunately, it does not replace your $paramDbHost with any value (it should lead to failure on any set-up where database is not local)
So, either the configuration is now what you expect : make sure that you check parameters.php file whose location is defined in /tool/paraletersLocation.php
either it is a local network setup that redirects the connection ; for instance check you /etc/host file

I don't think about other point to help you now.
Please try above advises and give us news.

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 httpdpgsql, 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.

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?

Wigth PostgreSql, database must be created first (with mySql it does not matter)

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

When do you get waiting spinner C? After configuration screen ?
What happens after 5 seconds ? Spinner stops ?
Don't you have new "continue" button ? (on some screen resolutions, you may need to scroll page to see it)

Do you have possibility to disable SELinux to test how setup works without it ?

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

The STRACE file for all the processes of HTTPD and POSTGRESQL for this is attached

No attached file 🙁

Could you also check browser console for errors ?

Well, not sure what happened to them....

I have worked around it as a temporary measure, to try and get the DB up, but will need to sort out why it will not connect through 127.0.0.2, or shut it down and revert to original before Monday AM.....

I have changed the server IP to 127.0.0.1 and now it connects, as well as trying to configure from the "normal" config page.

BUT..... no matter what name I give the logs file name. it keeps throwing up an error:

incorrect value for 'Log file name', cannot write to such a file
or
incorrect value for 'Log file name', does not include a valid directory name

WHAT is a valid file name, as it certainly does not like the default with the full path added.....

Cheers,
Verncon.

The STRACE file for all the processes of HTTPD and POSTGRESQL for this is attached

No attached file 🙁

Could you also check browser console for errors ?

Browser console has been wiped ,,,,, sorry.

you can define any valid file name for log file, absolute or relative
default is '../files/logs/projeqtor_${date}.log' (relative way)
you can use absolute way such as '/var/logs/projeqtor/projeqtor_${date}.log'
(adding {date} will generate 1 file per day)

Important : the folder must exist (it is not created dynamically) and php user must have write rights in the folder.

OK, finally got it to accept the parameters (chown apache:apache, chmod 777 and Selinux Permissive), but now It says "invalid login parameters"

Have tried various combinations of admin, projeqtor and my DB login, none will let me in - any clues?

Cheers,
Verncon.

Hi,

I have played around with permissions, etc, and at least on my Fedora 22 server the minimum is CHMOD 755, the projeqtor directory & sub-directories owned by the php user, with those directories and associated files set to SELINUX context httpd_sys_rw_content_t

Moving on tho the next problem, I cannot login.

In the documentation it is given as "admin" and "admin", but that appears to not work.
I have created a new user for the database, with a valid password, and that does not work either.

When searching the forum archives I cannot find any responses to people's questions as to how to access the system once it is configured.

I would appreciate your assistance on this.

Cheers,
Verncon.

OK, DONE!!!

I shall leave you in peace and quiet for a while now, I finally figured out from other comments on the initial login issue what had to be done to gain access.

Many thanks for your assistance.

Cheers,
Verncon.

Hi,
I encounter the same problem as you.
Installing CentOS 6 projeqtor under x86_64 and postgresql 9.4 does not. I took the parameters in configuration in the "main view" GUI, and the system hangs. The log file is empty.
How have you solved the problem?
Can you help me?
Thanks for your answer.

Hi,

I had a couple of issues, here are the points that I found not so clear:

1. All of the external files (logs, cofig, etc) MUST be relative to the projeqtor install base, i..e if you have installed projeqtor in /var/www/html/, then all the files must be in a directory under the projector directory.

2. When you get the login screen and it returns "invalid password" or something similar, you need to go into the DATABASE, to Table "Parameter", find "dbVersion" and change it to "V5.0.x" (without " ", and x being the last version digit, i.e. 2 or whatever you have loaded).

Cheers.