ProjeQtOr free project management software - [SOLVED] error config check posgresql - ProjeQtOr
 

[SOLVED] error config check posgresql

More
26 Jun 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?

Please Log in or Create an account to join the conversation.

More
30 Jun 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

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.030 seconds