Hi,

I just tested on Linux.
It seems there in an issue on latest step of DB generation.
Check content of table parameter.
First line has parameterCode='dbVersion';
If parameterValue='V0.0.0' , it is source of issue.
Just change to V7.2.4, all should work fine then.

We'll soon provide a fix for this issue.

I've been quite busy so hadn't time to try and complete the install - - - trying to complete things this evening.
I was able to do the changes required in the php.ini files and that worked well.

Sorry - - - it is not clear where I find this 'content of table parameter' .
Where do I find this file (directory)?
I am on Debian stretch running postgresql 9.6 and php7.0.

TIA

Hello,

Sorry - - - it is not clear where I find this 'content of table parameter' .
Where do I find this file (directory)?

This is not a file, it is in your database, in table " parameter ".

Hello,

Sorry - - - it is not clear where I find this 'content of table parameter' .
Where do I find this file (directory)?

This is not a file, it is in your database, in table " parameter ".

(Sorry I copied the information from a text screen and it doesn't look good but I don't know how to edit it to look like on my machine - - - - sorry!!!)

>postgres=# l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_CA.UTF-8 | en_CA.UTF-8 |
projeqtor | postgres | UTF8 | en_CA.UTF-8 | en_CA.UTF-8 | =Tc/postgres +
| | | | | postgres=CTc/postgres+
| | | | | admin=CTc/postgres
template0 | postgres | UTF8 | en_CA.UTF-8 | en_CA.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_CA.UTF-8 | en_CA.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
test1 | postgres | UTF8 | en_CA.UTF-8 | en_CA.UTF-8 | =Tc/postgres +
| | | | | postgres=CTc/postgres+
| | | | | admin=CTc/postgres
(5 rows)

postgres=# c projeqtor
You are now connected to database "projeqtor" as user "postgres".
projeqtor=# dt
No relations found.

I'm no database expert but the above command sequence is what I find to list any and all tables.

The screenshot attached shows where the config page (in projeqtor) indicates that there IS a database but with errors for the various directories where setup is needed.

Please advise re: next step(s).

TIA

Your configuration is not complete.
Resolve issues pointed ou in red.
There you'll a a button "Continue".
At last, first connection of admin will populate database

Your configuration is not complete.
Resolve issues pointed ou in red.
There you'll a a button "Continue".
At last, first connection of admin will populate database

Worked on removing the problems but am now stuck on what I think might be the last issue.
Used
># chmod -R 777 /home/projeqtor/files/
root@machine4:/home/projeqtor/files# ls -l
total 0
drwxrwxrwx 1 root root 0 Oct 8 07:03 attach
drwxrwxrwx 1 root root 0 Oct 8 07:03 attachments
drwxrwxrwx 1 root root 48 Oct 9 08:30 config
drwxrwxrwx 1 777 root 0 Oct 9 08:36 logs
drwxrwxrwx 1 root root 0 Oct 8 06:00 reports

so I think the permissions are wide open. Yet

> incorrect value for 'Log file name', cannot write to such a file : check access rights

I am not sure how to have more open access rights.
Please advise on how to resolve this issue.
(Running on Debian stable using apache2 and postgresql9.6)

Look at your folders description.
you made a "chown 777" on files/logs
I guess user 777 is unknown

NB : you should make a

chown -R www-data: /var/www/hrml/projeqtor

adapt path to your config,
and change www-data to apache if you are on red-hat like distro.
Idea is to give onwnership of whole folder to php user.

Then you may

chmod -R 755 /var/www/hrml/projeqtor

(read access is enought for other users)

Look at your folders description.
you made a "chown 777" on files/logs
I guess user 777 is unknown

(Interleaving for clarity)
Sorry - - - -had also done chmod 777 on the same files (directories).

>NB : you should make a

chown -R www-data: /var/www/hrml/projeqtor

adapt path to your config,
and change www-data to apache if you are on red-hat like distro.
Idea is to give onwnership of whole folder to php user.

So www-data is what ???? (a user, a group, a directory or ????)

>Then you may

chmod -R 755 /var/www/hrml/projeqtor

(read access is enought for other users)

OK - - - I understood that I only need to have 0755 permissions but as things just aren't installing very well I thought to throw things wide open in the hope that would allow the install to proceed (not happening though!).

I'm not understanding how with wide open permissions I'm still getting responses like:

incorrect value for 'Log file name', cannot write to such a file : check access rights

I hope my questions are not too stupid but I have no real experience in managing a server so some of the self evident items are for me quite opaque (question on what www-data is).

root@machine4:/home/projeqtor/files/config# chmod -R apache2: /home/projeqtor/files/
chmod: invalid mode: u2018apache2:u2019
Try 'chmod --help' for more information.
root@machine4:/home/projeqtor/files/config# chmod -R root: /home/projeqtor/files/
chmod: invalid mode: u2018root:u2019
Try 'chmod --help' for more information.
root@machine4:/home/projeqtor/files/config# chmod -R admin: /home/projeqtor/files/ (admin is master postgresql user for projeqtor)
chmod: invalid mode: u2018admin:u2019
Try 'chmod --help' for more information.
root@machine4:/home/projeqtor/files/config# chmod -R www-data: /home/projeqtor/files/
chmod: invalid mode: u2018www-data:u2019
Try 'chmod --help' for more information.

The just previous is my attempts to implement your suggestions.

Thanking you for your assistance

Look at your folders description.
you made a "chown 777" on files/logs
I guess user 777 is unknown

>NB : you should make a

chown -R www-data: /var/www/hrml/projeqtor

adapt path to your config,
and change www-data to apache if you are on red-hat like distro.
Idea is to give onwnership of whole folder to php user.

Then you may

chmod -R 755 /var/www/hrml/projeqtor

(read access is enought for other users)

Sorry - - - -doing some more experimenting and finding things.
Wow is it obvious that I really don't know what I'm doing.
It wasn't clear that there are files in directories controlled by apache, then there are the directories controlled by php, then there are the directories controlled by projeqtor, then there are the directories that the system uses - - - maybe not for control but they are also involved.

I tried your above suggested chown and chmod (to www-data in the /var system) that didn't achieve completion.
Also tried the same using root - - - that also didn't achieve completion.

So I have wide open permissions on the directories:
/home/projeqtor/
/var/www/example.com
~/web/projeqtor/

are there more directories that are part of this 'system' (all the pieces that make up the website and the specific software) that need to have the permissions changed?

TIA

are there more directories that are part of this 'system' (all the pieces that make up the website and the specific software) that need to have the permissions changed?

No, unless you move some projeqtor folders, that are by default on /var/www/html/projeqtor/files, but that you can (and possibly should) move outside web reach through global parameters screen

are there more directories that are part of this 'system' (all the pieces that make up the website and the specific software) that need to have the permissions changed?

No, unless you move some projeqtor folders, that are by default on /var/www/html/projeqtor/files, but that you can (and possibly should) move outside web reach through global parameters screen

I am quite prepared to have these directories outside of web reach but I'm thinking that it would be quite useful to actually have something working before I try to modify things even more. Just know that I'm quite confused and that nothing that I have been able to find or do has allowed the configuration and set up of projeqtor to run to completion.

Any suggestions as to what else needs doing?

TIA

I am quite prepared to have these directories outside of web reach but I'm thinking that it would be quite useful to actually have something working before I try to modify things even more

It is a good approach 😉

Any suggestions as to what else needs doing?

Check messages.
If configuration of log file is correct, you may find issues logged on log file.
Please post them here.

I am quite prepared to have these directories outside of web reach but I'm thinking that it would be quite useful to actually have something working before I try to modify things even more

It is a good approach 😉

Any suggestions as to what else needs doing?

Check messages.
If configuration of log file is correct, you may find issues logged on log file.
Please post them here.

All log file locations (~/web/ . . . , /home/projeqtor/ . . . , and /var/www/example.com/logs . . . are either non-existent or are empty.

incorrect value for 'Log file name', cannot write to such a file : check access rights

is what I still have in the configuration screen.

Regards

You must look for log file as defined during the configuration.
It's defined in projeqtor/files/config/parameters.php
Default location is projeqtor/files/log
If folder is emprty, possibly error is logged in apache error log file.

You must look for log file as defined during the configuration.
It's defined in projeqtor/files/config/parameters.php
Default location is projeqtor/files/log
If folder is emprty, possibly error is logged in apache error log file.

From projeqtor/files/config/parameters.php :
$logFile = '/home/projeqtor/files/logs/projeqtor_${date}.log';

You are correct. Not only are there no files - - - there is nothing! (in projeqtor/files/log)

The only error I can see (in /var/log/apache2/error.log) is:

[Sun Nov 04 20:07:45.177992 2018] [:error] [pid 850] python_init: Python version mismatch, expected '2.7.5+', found '2.7.13'.
[Sun Nov 04 20:07:45.178092 2018] [:error] [pid 850] python_init: Python executable found '/usr/bin/python'.
[Sun Nov 04 20:07:45.178100 2018] [:error] [pid 850] python_init: Python path being used '/usr/lib/python2.7:/usr/lib/python2.7/plat-x86_64-linux-gnu:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload'.

Using logic - - - the error doesn't make any sense - - - 2.7.13 is greater than 2.7.5 but there likely is something else that has changed.

Any ideas on how to resolve the issue?

You defined

$logFile = '/home/projeqtor/files/logs/projeqtor_${date}.log';

So directory "/home/projeqtor/files/logs/"
- must exist
- php user (www-data) must have write rights on this folder (try a cmod 777 to try)