Notifications

Clear all

Projeqtor under Nginx

Chri.s · 2015-06-25T00:45:24Z

Hi Guys, at first (as i think it is my Problem at the moment) it would be very nice if there would be an addition how i could handle Projeqtor with Nginx. Kind regards, Chris

Page 2 / 2 Prev

Propose evolutions

Last Post by Chri.s 11 years ago

46 Posts

2 Users

0 Reactions

49.6 K Views

RSS

babynus

(@babynus)

Posts: 14952

Member Admin

Attached is the dump of a brand new DB.

projeqtor.sql.zip

Posted : 01 Jul 2015 17H12

Chri.s

(@chri-s)

Posts: 32

Active Member

Topic starter

OK, Upgrade is in Progress isn'nt show anymore.

[object Error]
{
description: "Die Eigenschaft "replace" eines undefinierten oder Nullverweises kann nicht abgerufen werden.",
message: "Die Eigenschaft "replace" eines undefinierten oder Nullverweises kann nicht abgerufen werden.",
name: "TypeError",
number: -2146823281
}

in IE

Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check http://xhr.spec.whatwg.org/.
The XMLHttpRequest progress event property 'position' is deprecated. Please use 'loaded' instead.
TypeError: Cannot read property 'replace' of undefined
at Object.Utf8.encode ( https://site/external/phpAES/aes.js?version=V5.0.1.0116:425:22)
at Object.Aes.Ctr.encrypt ( https://site/external/phpAES/aes.js?version=V5.0.1.0116:185:19)
at cryptData ( https://site/view/js/projeqtor.js?version=V5.0.1.0116:2626:46)
at Object.dojo.xhrGet.load ( https://site/view/js/projeqtor.js?version=V5.0.1.0116:2671:9)
at https://site/external/dojo/dojo.js?version=V5.0.1.0116:15:101248
at _189 ( https://site/external/dojo/dojo.js?version=V5.0.1.0116:15:36950)
at _187 ( https://site/external/dojo/dojo.js?version=V5.0.1.0116:15:36642)
at resolve.callback ( https://site/external/dojo/dojo.js?version=V5.0.1.0116:15:37707)
at _189 ( https://site/external/dojo/dojo.js?version=V5.0.1.0116:15:37250)
at _187 ( https://site/external/dojo/dojo.js?version=V5.0.1.0116:15:36642)

in Chrome...

?! Just Questioning...Sorry

Posted : 01 Jul 2015 22H58

Chri.s

(@chri-s)

Posts: 32

Active Member

Topic starter

any ideas?

Posted : 03 Jul 2015 12H57

babynus

(@babynus)

Posts: 14952

Member Admin

There is an issue in the encryption phase.

Please try and add traces in /view/js/projeqtor.js, line 2620, like this :

function cryptData(data) {   
   console.log(data);
   var arr=data.split(';');

Try again (be sure to clean browser cache to use correct jabascript code) and post browser console content here.
Thanks

Posted : 03 Jul 2015 18H41

Chri.s

(@chri-s)

Posts: 32

Active Member

Topic starter

Hi Babynus,

tried it once

actually seems like the same result except the Connection broken..? Could it be, that this is a problem with https? or xss with new browsers?

The System is running under Debian 8, nginx 1.6.2, php-fpm, mysql-server-

Posted : 03 Jul 2015 22H02

babynus

(@babynus)

Posts: 14952

Member Admin

Hi,

It is not exactly the same : have reponse

Verbindung abgebrochen. Bitte neu anmelden.

It is not at all result expected for cryptData (should be some ; separated fields)
In fact, result is a generic message that occurs when session is lost.
So it seems Nginx does not support PHP session.
Maybe it should be configured to use sessions. If it is not possible, so Nginx will never be able to run ProjeQtOr.

Posted : 03 Jul 2015 22H16

Chri.s

(@chri-s)

Posts: 32

Active Member

Topic starter

<?php
// Start Session
session_start();
// Show banner
echo 'Session Support Checker';
// Check if the page has been reloaded
if(!isset($_GET['reload']) OR $_GET['reload'] != 'true') {
   // Set the message
   $_SESSION['MESSAGE'] = 'Session support enabled!
';
   // Give user link to check
   echo 'Click HERE to check for PHP Session Support.
';
} else {
   // Check if the message has been carried on in the reload
   if(isset($_SESSION['MESSAGE'])) {
      echo $_SESSION['MESSAGE'];
   } else {
      echo 'Sorry, it appears session support is not enabled, or you PHP version is to old. Click HERE to go back.
';
   }
}
?>

i've tested your idea with this script. Runs fine -> Session Support enabled. Therefore i think that it's not the problem or how do you think?

Posted : 04 Jul 2015 0H48

babynus

(@babynus)

Posts: 14952

Member Admin

I have an idea, that could explain behavior : content of $_SERVER variable.

Could you please try and add a debug line on line 30 (about) of /tool/projeqtor.php :

 debugLog($_SERVER);

Try again.
Then post log file here.

Posted : 04 Jul 2015 1H50

Chri.s

(@chri-s)

Posts: 32

Active Member

Topic starter

i placed it beyond the session_start(): directive.

After that the Server returns a 502 Bad Gateway - after removing the Site is loading again. Do you think that this could lead us to a solution?

Posted : 04 Jul 2015 12H33

babynus

(@babynus)

Posts: 14952

Member Admin

Yes, this may be the point going wrong with Nginx.

The $_SERVER PHP varialbe (an array) depends on ... the server.
ProjeQtOr works fine with $_SERVER provided by Apache and has been adapted to fit IIS.
But it seems Nginx is very restrictive with this variable.
Data ha to be explicitly defined.
Here are some examples :
https://ma.ttias.be/setting-https-server-variables-in-php-fpm-with-nginx/
http://wiki.nginx.org/HttpCoreModule#.24hostname
http://serverfault.com/questions/324420/nginx-doesnt-send-serverdocument-root-to-php-fpm
and also, with an explicit list of standard params expected in $_SERVER :
http://kbeezie.com/php-self-path-nginx/

So please try and configure Nginx so the the

debugLog($_SERVER);

returns something, then we'll be able to check which params may be mission.

Posted : 04 Jul 2015 13H41

Chri.s

(@chri-s)

Posts: 32

Active Member

Topic starter

it does not seem to be a Problem with "$_SERVER" in general

trying to run a

returns

array(35) { ["USER"]=> string(8) "www-data" ["HOME"]=> string(8) "/var/www" ["FCGI_ROLE"]=> string(9) "RESPONDER" ["PATH_INFO"]=> string(0) "" ["SCRIPT_FILENAME"]=> string(27) "/var/www/project/maxexe.php" ["QUERY_STRING"]=> string(0) "" ["REQUEST_METHOD"]=> string(3) "GET" ["CONTENT_TYPE"]=> string(0) "" ["CONTENT_LENGTH"]=> string(0) "" ["SCRIPT_NAME"]=> string(11) "/maxexe.php" ["REQUEST_URI"]=> string(11) "/maxexe.php" ["DOCUMENT_URI"]=> string(11) "/maxexe.php" ["DOCUMENT_ROOT"]=> string(16) "/var/www/project" ["SERVER_PROTOCOL"]=> string(8) "HTTP/1.1" ["HTTPS"]=> string(2) "on" ["GATEWAY_INTERFACE"]=> string(7) "CGI/1.1" ["SERVER_SOFTWARE"]=> string(11) "nginx/1.6.2" ["REMOTE_ADDR"]=> string(13) "" ["REMOTE_PORT"]=> string(5) "53818" ["SERVER_ADDR"]=> string(14) "" ["SERVER_PORT"]=> string(3) "443" ["SERVER_NAME"]=> string(23) "project.certifiedit.net" ["REDIRECT_STATUS"]=> string(3) "200" ["HTTP_HOST"]=> string(23) "project.certifiedit.net" ["HTTP_CONNECTION"]=> string(10) "keep-alive" ["HTTP_CACHE_CONTROL"]=> string(9) "max-age=0" ["HTTP_ACCEPT"]=> string(74) "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8" ["HTTP_USER_AGENT"]=> string(110) "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.130 Safari/537.36" ["HTTP_DNT"]=> string(1) "1" ["HTTP_ACCEPT_ENCODING"]=> string(19) "gzip, deflate, sdch" ["HTTP_ACCEPT_LANGUAGE"]=> string(35) "de-DE,de;q=0.8,en-US;q=0.6,en;q=0.4" ["HTTP_COOKIE"]=> string(36) "PHPSESSID=s61rb043dk81cufdjco8f5c4o5" ["PHP_SELF"]=> string(0) "" ["REQUEST_TIME_FLOAT"]=> float(1436008843.7384) ["REQUEST_TIME"]=> int(1436008843) }

just the debugLog Funktion seems to break the Server

array(39) { ["USER"]=> string(8) "www-data" ["HOME"]=> string(8) "/var/www" ["FCGI_ROLE"]=> string(9) "RESPONDER" ["PATH_INFO"]=> string(0) "" ["SCRIPT_FILENAME"]=> string(36) "/var/www/project/tool/loginCheck.php" ["QUERY_STRING"]=> string(40) "destinationWidth=300&destinationHeight=0" ["REQUEST_METHOD"]=> string(4) "POST" ["CONTENT_TYPE"]=> string(33) "application/x-www-form-urlencoded" ["CONTENT_LENGTH"]=> string(2) "81" ["SCRIPT_NAME"]=> string(20) "/tool/loginCheck.php" ["REQUEST_URI"]=> string(61) "/tool/loginCheck.php?destinationWidth=300&destinationHeight=0" ["DOCUMENT_URI"]=> string(20) "/tool/loginCheck.php" ["DOCUMENT_ROOT"]=> string(16) "/var/www/project" ["SERVER_PROTOCOL"]=> string(8) "HTTP/1.1" ["HTTPS"]=> string(2) "on" ["GATEWAY_INTERFACE"]=> string(7) "CGI/1.1" ["SERVER_SOFTWARE"]=> string(11) "nginx/1.6.2" ["REMOTE_ADDR"]=> string(13) "" ["REMOTE_PORT"]=> string(5) "54164" ["SERVER_ADDR"]=> string(14) "" ["SERVER_PORT"]=> string(3) "443" ["SERVER_NAME"]=> string(23) "site" ["REDIRECT_STATUS"]=> string(3) "200" ["HTTP_HOST"]=> string(23) "site" ["HTTP_CONNECTION"]=> string(10) "keep-alive" ["HTTP_CONTENT_LENGTH"]=> string(2) "81" ["HTTP_ORIGIN"]=> string(31) "https://site" ["HTTP_X_REQUESTED_WITH"]=> string(14) "XMLHttpRequest" ["HTTP_USER_AGENT"]=> string(110) "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.130 Safari/537.36" ["HTTP_CONTENT_TYPE"]=> string(33) "application/x-www-form-urlencoded" ["HTTP_ACCEPT"]=> string(3) "*/*" ["HTTP_DNT"]=> string(1) "1" ["HTTP_REFERER"]=> string(45) "https://site/view/main.php" ["HTTP_ACCEPT_ENCODING"]=> string(13) "gzip, deflate" ["HTTP_ACCEPT_LANGUAGE"]=> string(35) "de-DE,de;q=0.8,en-US;q=0.6,en;q=0.4" ["HTTP_COOKIE"]=> string(36) "PHPSESSID=s61rb043dk81cufdjco8f5c4o5" ["PHP_SELF"]=> string(0) "" ["REQUEST_TIME_FLOAT"]=> float(1436009111.9144) ["REQUEST_TIME"]=> int(1436009111) } Verbindung abgebrochen. Bitte neu anmelden.

(Connection Broken)

above shown when trying to login at the space (line30) of the projeqtor. If you say that there is something wrong with the server directive i will take a deeper look. As it seems to me just the debugLog Function breaks the Server

Posted : 04 Jul 2015 15H28

babynus

(@babynus)

Posts: 14952

Member Admin

Hi,

If there is an issue with debugLog, then possibly you have access right issue to target folder.
Try and set access rights as wide as possible (777 would be good to test).

Then, all expected params are not all there.
At least ['PHP_SELF'] is missing, what explains invalid connection.

I'll check all requested params and let you know what must be added in server and what can be provided through a patch

Posted : 04 Jul 2015 18H46

babynus

(@babynus)

Posts: 14952

Member Admin

Hi,

I found an issue : $_SERVER['PHP_SELF'] is empty.
Here is a workaround to configure Ngnix :
http://thehungrycoder.com/tutorial/php_self-is-empty.html

I'll try and add a patch to define PHP_SELF when it is not set.

Posted : 04 Jul 2015 19H18

babynus

(@babynus)

Posts: 14952

Member Admin

About debugLog() issue, it is just that this function must be called after

include_once "../tool/parameters.php";

where paraeters to log file are defined 😉

Posted : 04 Jul 2015 19H22

babynus

(@babynus)

Posts: 14952

Member Admin

Hi,

Here is a patch to avoid changing Nginx configuration :
just add these line about line 47 or /tool/projeqtor.php

// some servers provide empty PHP_SELF, fill it
if (! isset($_SERVER ['PHP_SELF']) or ! $_SERVER ['PHP_SELF']) { // PHP_SELF do not exist or is empty
  $_SERVER ['PHP_SELF']=$_SERVER ['SCRIPT_NAME'];
}

Tell me if this help.

Posted : 04 Jul 2015 19H35

Chri.s

(@chri-s)

Posts: 32

Active Member

Topic starter

thank you this helped but...wondering why...

2015-07-04 18:51:41.225 ===== TRACE ===== Migrating from version < V4.0.0 : previous errors are expected for Class 'User' on fields 'loginTry', 'salt' and 'crypto'
2015-07-04 18:51:41.235 ===== TRACE ===== Login error for user '9Z▒?b'
2015-07-04 18:52:11.437 ===== TRACE ===== Migrating from version < V4.0.0 : previous errors are expected for Class 'User' on fields 'loginTry', 'salt' and 'crypto'
2015-07-04 18:52:11.451 ===== TRACE ===== Login error for user '
                                                                ▒H▒'
2015-07-04 18:53:57.050 ===== TRACE ===== Migrating from version < V4.0.0 : previous errors are expected for Class 'User' on fields 'loginTry', 'salt' and 'crypto'
2015-07-04 18:53:57.060 ===== TRACE ===== Login error for user '▒q▒▒▒'

but now i am getting a bit angry...

which modules does the programm all in all need for running fine.

ok does not seem as the server would import the Databases. Tried it now within an hosted server under apache, therefore i had to comment lines 2528++ with replacing time limits before it runs. There it seems to have problems with UTF8/ German Special Chars (äöü and €)

array(39) { ["USER"]=> string(8) "www-data" ["HOME"]=> string(8) "/var/www" ["FCGI_ROLE"]=> string(9) "RESPONDER" ["PATH_INFO"]=> string(0) "" ["SCRIPT_FILENAME"]=> string(36) "/var/www/project/tool/loginCheck.php" ["QUERY_STRING"]=> string(55) "destinationWidth=300&destinationHeight=37.2727279663086" ["REQUEST_METHOD"]=> string(4) "POST" ["CONTENT_TYPE"]=> string(33) "application/x-www-form-urlencoded" ["CONTENT_LENGTH"]=> string(2) "81" ["SCRIPT_NAME"]=> string(20) "/tool/loginCheck.php" ["REQUEST_URI"]=> string(76) "/tool/loginCheck.php?destinationWidth=300&destinationHeight=37.2727279663086" ["DOCUMENT_URI"]=> string(20) "/tool/loginCheck.php" ["DOCUMENT_ROOT"]=> string(16) "/var/www/project" ["SERVER_PROTOCOL"]=> string(8) "HTTP/1.1" ["HTTPS"]=> string(2) "on" ["GATEWAY_INTERFACE"]=> string(7) "CGI/1.1" ["SERVER_SOFTWARE"]=> string(11) "nginx/1.6.2" ["REMOTE_ADDR"]=> string(13) "" ["REMOTE_PORT"]=> string(5) "57070" ["SERVER_ADDR"]=> string(14) "" ["SERVER_PORT"]=> string(3) "443" ["SERVER_NAME"]=> string(23) "site" ["REDIRECT_STATUS"]=> string(3) "200" ["HTTP_HOST"]=> string(23) "site" ["HTTP_CONNECTION"]=> string(10) "keep-alive" ["HTTP_CONTENT_LENGTH"]=> string(2) "81" ["HTTP_ORIGIN"]=> string(31) "https://site" ["HTTP_X_REQUESTED_WITH"]=> string(14) "XMLHttpRequest" ["HTTP_USER_AGENT"]=> string(110) "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.130 Safari/537.36" ["HTTP_CONTENT_TYPE"]=> string(33) "application/x-www-form-urlencoded" ["HTTP_ACCEPT"]=> string(3) "*/*" ["HTTP_DNT"]=> string(1) "1" ["HTTP_REFERER"]=> string(45) "https://site/view/main.php" ["HTTP_ACCEPT_ENCODING"]=> string(13) "gzip, deflate" ["HTTP_ACCEPT_LANGUAGE"]=> string(35) "de-DE,de;q=0.8,en-US;q=0.6,en;q=0.4" ["HTTP_COOKIE"]=> string(36) "PHPSESSID=s61rb043dk81cufdjco8f5c4o5" ["PHP_SELF"]=> string(0) "" ["REQUEST_TIME_FLOAT"]=> float(1436029539.6774) ["REQUEST_TIME"]=> int(1436029539) }

Posted : 04 Jul 2015 20H55

babynus

(@babynus)

Posts: 14952

Member Admin

Hi,
first log show normal "traces" : this show try to migrate from version < V4.0.0 and just points out that some errors may be displayed, without affecting correct execution.
You get connection error : only admin/admin is allowed during migration.
Maybe you should try brand new install from scratch with this configuration.

I don't understand why you had to comment function projeqtor_set_time_limit().
What was the error ?

About german characters, as many german users have contributed to the forum, I really thing it is a simple configuration issue.
Server must accept UTF8, and maybe you should play with ProjeQtOr parameter

$enforceUTF8 = '1';

This parameter has been introduced in V4.4 to fox some UTF8 transposition, maybe it is an issue in your case.
You can for instance try to set it to '0'.
Maybe you can ask climb4fun for hints.

Posted : 04 Jul 2015 21H54

Chri.s

(@chri-s)

Posts: 32

Active Member

Topic starter

Hi,

i already tried to do a full new installation. Same failure - and as it seems the db isnt populated at all (zero Tables). - no failure ecxept that one.

with UTF i will give it a try.

Therefore under Apache => .htaccess ->
AddDefaultCharset UTF-8

# vim nginx.conf
Append/modify the following directive in http, server, or location:
charset UTF-8;
(originated in the other problem untested)

reasonable for the needed outcomment was, that the server doesn't allow to set the execution time to populate the db - but runs smooth after this outcomment-job.

Posted : 04 Jul 2015 23H28

Chri.s

(@chri-s)

Posts: 32

Active Member

Topic starter

Seems as 5.0.2 has fixed the problem. Projeqtor is now running under nginx.

Posted : 10 Jul 2015 19H01

babynus

(@babynus)

Posts: 14952

Member Admin

Great :woohoo:

I'd like to understand what made it work, but not sure I will get this answer.

Posted : 10 Jul 2015 20H00

Chri.s

(@chri-s)

Posts: 32

Active Member

Topic starter

it's a miracle but don't blame me for not searching for the reason 😉

i set everything on start (deleted whole dir) and placed the 502 in a new one - aimed the browser on, it filled the logs with the "install db" entries and went smooth forward - even this didn't run properly on 501.

Therefore thank you for your help, may we just had to wait for 502 and the by the way problems fixed in this release 🙂

Posted : 11 Jul 2015 23H43

Page 2 / 2 Prev

13 Forums
10.1 K Topics
39.7 K Posts
5 Online
16.6 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Discover the ProjeQtOr roadmap!

View the update history

Plan projects & manage work

Planning

Program

Ticketing

Work

Agile

Measure, adjust,and master.

Steering

Financial

Administration

Collaboration

Discover all the features

Even more from ProjeQtOr

Free demo

Training

Store

Resources

100% free? Where's the catch?

Learn all about our business model!

All plugins included and without limits?

Discover our hosting service which includes all plugins!

Subscription services

Hosting

Support

Subscription

Users Qlub

One-off services

Training

Assistance

On-demand evolution

Plugins

Discover all the services

Even more from ProjeQtOr

Free demo

Training

Store

Ressources

Visit our Forum

Testimonials

Stay informed

Our Community

Our articles and news

Project Management Blog

Join a thriving ecosystem

User Qlub

Roadmap ProjeQtOr

Suggestions

Discover our community

More of ProjeQtOr

Free demo

Training

Store

Resources

Latest version

Need an explanation?

Documentation & support

FAQ

Forum

Manual online

Installation & prerequisites

More of ProjeQtOr

Free demo

Training

Store

Resources

Projeqtor under Nginx

Plan projects
& manage work

Measure, adjust,
and master.

Even more
from ProjeQtOr

100% free?
Where's the catch?