View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] error config check posgresql - 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)

 

 

 
 

[SOLVED] error config check posgresql

More
26 Jui 2020 07:00 #1 by redneurocom
hi, i cannot install projeqtor in centos 8 with PHP 7.4 and posgresql 12.1,
when i choose postgresql engine and save all details it shows an error in dev console


dojo.js?version=V8.5.1.0255:2 _4c0 {message: "Unable to load ../tool/configCheck.php?destination…nType=&xhrPostTimestamp=1593147228479 status: 500", response: {…}, status: 500, responseText: "<div class='messageOK'><i>PHP version is 7.4.7 : O…n = pgsql:host=127.0.0.1;port=3306</i></div><br/>", xhr: XMLHttpRequest, …}message: "Unable to load ../tool/configCheck.php?destinationWidth=560&destinationHeight=65&isIE=&xhrPostDestination=configResultDiv&xhrPostIsResultMessage=false&xhrPostValidationType=&xhrPostTimestamp=1593147228479 status: 500"response: data: "<div class='messageOK'><i>PHP version is 7.4.7 : OK</i></div><br/><div class='messageOK'><i>Module PDO is available : OK</i></div><br/><div class='messageOK'><i>Module PDO for 'PGSQL' is available : OK</i></div><br/><div class='messageOK'><i>Module MBSTRING is available : OK</i></div><br/><div class='messageOK'><i>Class ZipArchive is available : OK</i></div><br/><div class='messageOK'><i>Module DOMDocument is available : OK</i></div><br/><div class='messageOK'><i>GD Library is available and correctly installed : OK</i></div><br/><div class='messageOK'><i>Module IMAP is available : OK</i></div><br/><div class='messageOK'><i>Module OPENSSL is available : OK</i></div><br/><div class='messageOK'><i>Module XML is available : OK</i></div><br/><div class='messageOK'><i>max_input_vars=5000 : OK</i></div><br/><div class='messageOK'><i>max_execution_time=30 : OK</i></div><br/><div class='messageOK'><i>memory_limit=1024M : OK</i></div><br/><div class='messageOK'><i>file_uploads=1 : OK</i></div><br/><div class='messageOK'><i>session.auto_start is disabled : OK</i></div><br/><div class='messageOK'><i>register_globals is disabled : OK</i></div><br/><div class='messageERROR'><i>SQLSTATE[08006] [7] could not connect to server: Permission denied↵ Is the server running on host "127.0.0.1" and accepting↵ TCP/IP connections on port 3306?<br/>dsn = pgsql:host=127.0.0.1;port=3306</i></div><br/>"getHeader: ƒ _338(_339)loaded: 1396options: TMP {method: "POST", handleAs: "text", ioArgs: {…}, data: "param%5BDbType%5D=pgsql&pname%5BDbType%5D=paramDbT…%3D&location=..%2Ffiles%2Fconfig%2Fparameters.php"}status: 500text: "<div class='messageOK'><i>PHP version is 7.4.7 : OK</i></div><br/><div class='messageOK'><i>Module PDO is available : OK</i></div><br/><div class='messageOK'><i>Module PDO for 'PGSQL' is available : OK</i></div><br/><div class='messageOK'><i>Module MBSTRING is available : OK</i></div><br/><div class='messageOK'><i>Class ZipArchive is available : OK</i></div><br/><div class='messageOK'><i>Module DOMDocument is available : OK</i></div><br/><div class='messageOK'><i>GD Library is available and correctly installed : OK</i></div><br/><div class='messageOK'><i>Module IMAP is available : OK</i></div><br/><div class='messageOK'><i>Module OPENSSL is available : OK</i></div><br/><div class='messageOK'><i>Module XML is available : OK</i></div><br/><div class='messageOK'><i>max_input_vars=5000 : OK</i></div><br/><div class='messageOK'><i>max_execution_time=30 : OK</i></div><br/><div class='messageOK'><i>memory_limit=1024M : OK</i></div><br/><div class='messageOK'><i>file_uploads=1 : OK</i></div><br/><div class='messageOK'><i>session.auto_start is disabled : OK</i></div><br/><div class='messageOK'><i>register_globals is disabled : OK</i></div><br/><div class='messageERROR'><i>SQLSTATE[08006] [7] could not connect to server: Permission denied↵ Is the server running on host "127.0.0.1" and accepting↵ TCP/IP connections on port 3306?<br/>dsn = pgsql:host=127.0.0.1;port=3306</i></div><br/>"transferType: "download"url: "../tool/configCheck.php?destinationWidth=560&destinationHeight=65&isIE=&xhrPostDestination=configResultDiv&xhrPostIsResultMessage=false&xhrPostValidationType=&xhrPostTimestamp=1593147228479"xhr: XMLHttpRequest {onreadystatechange: null, readyState: 4, timeout: 0, withCredentials: false, upload: XMLHttpRequestUpload, …}__proto__: ObjectresponseText: "<div class='messageOK'><i>PHP version is 7.4.7 : OK</i></div><br/><div class='messageOK'><i>Module PDO is available : OK</i></div><br/><div class='messageOK'><i>Module PDO for 'PGSQL' is available : OK</i></div><br/><div class='messageOK'><i>Module MBSTRING is available : OK</i></div><br/><div class='messageOK'><i>Class ZipArchive is available : OK</i></div><br/><div class='messageOK'><i>Module DOMDocument is available : OK</i></div><br/><div class='messageOK'><i>GD Library is available and correctly installed : OK</i></div><br/><div class='messageOK'><i>Module IMAP is available : OK</i></div><br/><div class='messageOK'><i>Module OPENSSL is available : OK</i></div><br/><div class='messageOK'><i>Module XML is available : OK</i></div><br/><div class='messageOK'><i>max_input_vars=5000 : OK</i></div><br/><div class='messageOK'><i>max_execution_time=30 : OK</i></div><br/><div class='messageOK'><i>memory_limit=1024M : OK</i></div><br/><div class='messageOK'><i>file_uploads=1 : OK</i></div><br/><div class='messageOK'><i>session.auto_start is disabled : OK</i></div><br/><div class='messageOK'><i>register_globals is disabled : OK</i></div><br/><div class='messageERROR'><i>SQLSTATE[08006] [7] could not connect to server: Permission denied↵ Is the server running on host "127.0.0.1" and accepting↵ TCP/IP connections on port 3306?<br/>dsn = pgsql:host=127.0.0.1;port=3306</i></div><br/>"status: 500xhr: XMLHttpRequest {onreadystatechange: null, readyState: 4, timeout: 0, withCredentials: false, upload: XMLHttpRequestUpload, …}stack: "Error: Unable to load ../tool/configCheck.php?destinationWidth=560&destinationHeight=65&isIE=&xhrPostDestination=configResultDiv&xhrPostIsResultMessage=false&xhrPostValidationType=&xhrPostTimestamp=1593147228479 status: 500↵ at new _4c0 (sispro.redneurocom.com/external/dojo/doj...V8.5.1.0255:2:128459)↵ at _3fc._31e [as handleResponse] (sispro.redneurocom.com/external/dojo/doj...=V8.5.1.0255:2:85907)↵ at XMLHttpRequest._32c (sispro.redneurocom.com/external/dojo/doj...=V8.5.1.0255:2:86343)"__proto__: Error
_3da @ dojo.js?version=V8.5.1.0255:2
(anonymous) @ dojo.js?version=V8.5.1.0255:2
_18b @ dojo.js?version=V8.5.1.0255:2
_189 @ dojo.js?version=V8.5.1.0255:2
reject.errback @ dojo.js?version=V8.5.1.0255:2
_18b @ dojo.js?version=V8.5.1.0255:2
_189 @ dojo.js?version=V8.5.1.0255:2
reject.errback @ dojo.js?version=V8.5.1.0255:2
_18b @ dojo.js?version=V8.5.1.0255:2
_189 @ dojo.js?version=V8.5.1.0255:2
reject.errback @ dojo.js?version=V8.5.1.0255:2
_18b @ dojo.js?version=V8.5.1.0255:2
_189 @ dojo.js?version=V8.5.1.0255:2
reject.errback @ dojo.js?version=V8.5.1.0255:2
(anonymous) @ dojo.js?version=V8.5.1.0255:2
_3fd @ dojo.js?version=V8.5.1.0255:2
_3f7 @ dojo.js?version=V8.5.1.0255:2
_415.reject @ dojo.js?version=V8.5.1.0255:2
_403 @ dojo.js?version=V8.5.1.0255:2
_3fd @ dojo.js?version=V8.5.1.0255:2
_3f7 @ dojo.js?version=V8.5.1.0255:2
_415.reject @ dojo.js?version=V8.5.1.0255:2
_403 @ dojo.js?version=V8.5.1.0255:2
_3fd @ dojo.js?version=V8.5.1.0255:2
_3f7 @ dojo.js?version=V8.5.1.0255:2
_415.reject @ dojo.js?version=V8.5.1.0255:2
_403 @ dojo.js?version=V8.5.1.0255:2
_3fd @ dojo.js?version=V8.5.1.0255:2
_3f7 @ dojo.js?version=V8.5.1.0255:2
_415.reject @ dojo.js?version=V8.5.1.0255:2
_403 @ dojo.js?version=V8.5.1.0255:2
_3fd @ dojo.js?version=V8.5.1.0255:2
_3f7 @ dojo.js?version=V8.5.1.0255:2
_415.reject @ dojo.js?version=V8.5.1.0255:2
_31e @ dojo.js?version=V8.5.1.0255:2
_32c @ dojo.js?version=V8.5.1.0255:2
load (async)
_325 @ dojo.js?version=V8.5.1.0255:2
xhr @ dojo.js?version=V8.5.1.0255:2
dojo.xhr @ dojo.js?version=V8.5.1.0255:2
dojo.rawXhrPost.dojo.xhrPost @ dojo.js?version=V8.5.1.0255:2
loadContent @ projeqtor.js?version=V8.5.1.0255:999
eval @ VM1580:7
_onSubmit @ projeqtorDojo.js:2
(anonymous) @ dojo.js?version=V8.5.1.0255:2
__onClick @ projeqtorDojo.js:2
(anonymous) @ dojo.js?version=V8.5.1.0255:2
Show 6 more frames



i see in destination URL that shows configcheck.php this:

PHP version is 7.4.7 : OK

Module PDO is available : OK

Module PDO for '' is not available - check your php configuration (php.ini)

Module MBSTRING is available : OK

Class ZipArchive is available : OK

Module DOMDocument is available : OK

GD Library is available and correctly installed : OK

Module IMAP is available : OK

Module OPENSSL is available : OK

Module XML is available : OK

max_input_vars=5000 : OK

max_execution_time=30 : OK

memory_limit=1024M : OK

file_uploads=1 : OK

session.auto_start is disabled : OK

register_globals is disabled : OK


i see that dont recognize pdo posgresql,
i have this modules

# php -m
[PHP Modules]
bz2
calendar
Core
ctype
curl
date
dom
exif
fileinfo
filter
ftp
gd
gettext
hash
iconv
imagick
imap
json
libxml
mbstring
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_pgsql
pdo_sqlite
pgsql
Phar
posix
readline
Reflection
session
shmop
SimpleXML
sockets
sodium
SPL
sqlite3
ssh2
standard
sysvmsg
sysvsem
sysvshm
tokenizer
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zip
zlib

also in my PHP in has this
extension=php_pdo_pgsql.dll
extension=php_pgsql.dll
extension=pgsql.so
extension=pdo_pgsql.so

otherwise when i choose MySQL it seems with no errors, but i want to install wit the latest postgresql engine, how can i fix it?
The topic has been locked.
More
30 Jui 2020 09:28 #2 by babynus
You try and connect to postgrsql using port 3306.
3306 is default port for MySql.
Default port for postgresql is 5432.

Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
Moderators: babynusprotion
Time to create page: 0.041 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.