View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Installation blocked at fist login - Page 2 - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Installation blocked at fist login

More
23 Mai 2022 16:07 #7 by GISP
As soon as I have connexion (issu of box) I show you apache configuration...

I usé wget to download zip file. 
I use unzip on the server 

The apache configuration is very simple. 
Just use http to https.

On documentation, there is no specific indication for rewriting URL. 

Regards 

 

Please Connexion or Create an account to join the conversation.

More
24 Mai 2022 01:11 - 24 Mai 2022 01:18 #8 by GISP
Hi,

My connexion come back...

Well, I see you :
  1. All commande for beginning to luch projeqtor
  2. Files of configuration apache (http)
  3. files of configuration apache (https)

1 - All commande

1 - VPS with ubuntu 22.04 LTS
2 - apt update
3 - apt upgrade
4 - echo Europe/Paris > /etc/timezone
5 - dpkg-reconfigure locales fr_FR.UTF-8 UTF-8
6 - add-apt-repository ppa:ondrej/php
7 - apt install php7.4 php7.4-bcmath php7.4-bz2 php7.4-cli php7.4-common php7.4-curl php7.4-fpm php7.4-gd php7.4-geoip php7.4-imagick php7.4-imap php7.4-json php7.4-mbstring php7.4-odbc php7.4-opcache php7.4-soap php7.4-xml php7.4-xsl php7.4-zip apache2 mariadb-server mariadb-client certbot python3-certbot-apache zip unzip
8 - a2enmod http2 ssl proxy_fcgi setenvif rewrite headers mpm_worker
9 - a2enconf php7.4-fpm
10 - systemctl reload apache2
11 - service php7.4-fpm reload
12 - nano /etc/apache2/sites-available proj.conf
12 - a2ensite proj.conf
13 - certbot --non-interactive --agree-tos --apache --redirect -m *****@***** -d proj.gest-plus.fr
14 - cd /var/www/html
15 - wget https://sourceforge.net/projects/projectorria/files/projeqtorV9.5.3.zip
16 - unzip projeqtorV9.5.3.zip
17 - mv projeqtor projeqt
18 - mariadb -u root -p
18.1 - create database...
18.2 - create user...
18.3 - grant all privileges for user tot database of projeqtor...
19 - chown 33:33 ./ -R

20 - Afer all this commande, with a browser... You know the story


2. Configuration http apache

<VirtualHost *:80> # or 443 for SSL support
  Protocols h2 http/1.1
  ServerName proj.gest-plus.fr
  DocumentRoot /var/www/html/projeqt

  RewriteEngine on
  RewriteCond %{SERVER_NAME} =proj.gest-plus.fr
  RewriteRule ^ https://%{SERVER_NAME}%{REQUEST_URI} [END,NE,R=permanent]

  <Directory /var/www/html>
    # enable the .htaccess rewrites
    AllowOverride All
    Options +Indexes
    Require all granted
    
    # Disable back office token
    # SetEnv _TOKEN_ disabled
  </Directory>

    ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>


3. https apache configuration

<IfModule mod_ssl.c>
  <VirtualHost *:443> # or 443 for SSL support
    Protocols h2 http/1.1
    ServerName proj.gest-plus.fr
    DocumentRoot /var/www/html/projeqt

    <Directory /var/www/html>
      # enable the .htaccess rewrites
      AllowOverride All
      Options +Indexes
      Require all granted
      
      # Disable back office token
      # SetEnv _TOKEN_ disabled
    </Directory>

    ErrorLog ${APACHE_LOG_DIR}/proj.error.log
    CustomLog ${APACHE_LOG_DIR}/proj.access.log combined

    SSLCertificateFile /etc/letsencrypt/live/proj.gest-plus.fr/fullchain.pem
    SSLCertificateKeyFile /etc/letsencrypt/live/proj.gest-plus.fr/privkey.pem
    Include /etc/letsencrypt/options-ssl-apache.conf

  </VirtualHost>
</IfModule>


I try an older version later...
It's time to sleep 

Regards
Last edit: 24 Mai 2022 01:18 by GISP.

Please Connexion or Create an account to join the conversation.

More
25 Mai 2022 08:50 #9 by babynus
Hi,

May issue is the rewrite rule

 RewriteRule ^ https://%{SERVER_NAME}%{REQUEST_URI} [END,NE,R=permanent]

I don't understand what it does, I'm not an expert on that side, but Projeqtor does not need any rewrite rule.
So tyry and remove it, it may work better.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
25 Mai 2022 22:53 #10 by GISP

RewriteEngine on
  RewriteCond %{SERVER_NAME} =proj.gest-plus.fr
  RewriteRule ^ https://%{SERVER_NAME}%{REQUEST_URI} [END,NE,R=permanent]
 

Well, when you write hhtp://... (port 80), the rule rewritte https://...

It's existe only on port 80. But if you wriite url with https, the rule doesn't apply

http is not secure, and some information on your soft can be sensitive... https is a basic protection

Apache listen to port :
First : port 80 (https) => <VirtualHost *:80>
Second : port 443 (https) => <VirtualHost *:443>

When you write an URL, you don't write the protocole. So, https is the fist
This rule change http to https. That is the only function of this rewritting rule

Projeqtor don' run with https ?

Please Connexion or Create an account to join the conversation.

More
26 Mai 2022 10:23 #11 by babynus
Of course projeqtor work over https
We also use rewrite rule but with slightly different syntax
RewriteRule ^(.*) https://subdomain.projeqtor.org$1 [QSA,L,R=301]
I don't know if the rewrite rule is really the source of your issue, but I don't know where the problem can come else.
It is the stange syntax in your logs refering to ".js.qversion=9.5.3" where code writes ".js?version=9.5.3" that leads le to this possible source.



 

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
26 Mai 2022 12:49 - 26 Mai 2022 12:51 #12 by GISP
Hi,

I try yous suggestion. It's the same result
I try wthout https. It's the same result

This week-end, I try to re-install the VPS and I note all action and résult...

Like you, it's the first time I see a problem like that.

I used to install servers and installations.
I know and I know ProjeQtOr and I know it works really well.

There must be either:
- A bad deed on my part
- An incompatibility with a parameter...

I will find and I will tell you

The VPS is intended to have several applications (ProjeQtOr, PrestaShop, Dolibarr)
All work fine on ubuntu 22.04 with php 7.4 and apache 2

This week-end :
Test with fresh install (ubuntu 22.04, apache2, php7.4, MariaDB)
Test with fresh install (ubuntu 22.04, Nginx, php7.4, MariaDB)

To be continued 

Where can I find initial file.sql for an manual installation ?

Regards

Note : I you went, You can access into the VPS
Last edit: 26 Mai 2022 12:51 by GISP.

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.044 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.