Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] error conf...
 
Notifications
Clear all

[SOLVED] error config check posgresql

2 Posts
2 Users
0 Reactions
2,263 Views
(@redneurocom)
Posts: 3
Active Member
Topic starter
 
[#6783]

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: "

PHP version is 7.4.7 : O…n = pgsql:host=127.0.0.1;port=3306

", 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: "

PHP version is 7.4.7 : OK

Module PDO is available : OK

Module PDO for 'PGSQL' is available : OK

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

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?
dsn = pgsql:host=127.0.0.1;port=3306

"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: "

PHP version is 7.4.7 : OK

Module PDO is available : OK

Module PDO for 'PGSQL' is available : OK

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

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?
dsn = pgsql:host=127.0.0.1;port=3306

"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: "

PHP version is 7.4.7 : OK

Module PDO is available : OK

Module PDO for 'PGSQL' is available : OK

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

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?
dsn = pgsql:host=127.0.0.1;port=3306

"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 ( https://sispro.redneurocom.com/external/dojo/dojo.js?version=V8.5.1.0255:2:128459)↵ at _3fc._31e [as handleResponse] ( https://sispro.redneurocom.com/external/dojo/dojo.js?version=V8.5.1.0255:2:85907)↵ at XMLHttpRequest._32c ( https://sispro.redneurocom.com/external/dojo/dojo.js?version=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

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?


 
Posted : 26 Jun 2020 9H00
(@babynus)
Posts: 14952
Member Admin
 

You try and connect to postgrsql using port 3306.
3306 is default port for MySql.
Default port for postgresql is 5432.


 
Posted : 30 Jun 2020 11H28
Share:

Scroll to Top