OJS 3.1.1-2 - Postgre not default port

Hi,

How can I configure a postgresql database with no default port?
In 2.X I used to:

;;;;;;;;;;;;;;;;;;;;;
; Database Settings ;
;;;;;;;;;;;;;;;;;;;;;

[database]

driver = postgres
host = hostname:port

I tried keep this the same, but I’m getting error in some parts of the system. like:

[Wed Aug 01 12:05:20.418841 2018] [:error] [pid 78943] [client 200.144.210.111:54468] PHP Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[08006] [7] n\xc3\xa3o p\xc3\xb4de traduzir nome da m\xc3\xa1quina “angrboda:6432” para endere\xc3\xa7o: Nome ou servi\xc3\xa7o desconhecido’ in /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php:47\nStack trace:\n#0 /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php(47): PDO->__construct(‘pgsql:host=angr…’, ‘revistas’, ‘revistas’, Array)\n#1 /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/PostgresConnector.php(35): Illuminate\Database\Connectors\Connector->createConnection(‘pgsql:host=angr…’, Array, Array)\n#2 /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/ConnectionFactory.php(59): Illuminate\Database\Connectors\PostgresConnector->connect(Array)\n#3 /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/ConnectionFactory.php(47): Illuminate\ in /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php on line 47, referer: http://www.revistas.usp.br/revusp

Looks like ojs is using the port number as part of the hostname.

Is there a new way to configure, or I’m facing a bug?

Regards,
Tarcisio Pereira.

Hi,

It’s very important to us use alternative port.
Is there a solution?

Regards,
Tarcisio Pereira.

Hi @Tarcisio_Pereira,

See Allow to connect on custom ports / socket · Issue #3860 · pkp/pkp-lib · GitHub.

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @asmecher

Even after changing the BaseQueryBuilder.inc.php file the error still there:

[Mon Aug 27 09:33:11.545293 2018] [:error] [pid 56114] [client 200.144.210.111:46356] PHP Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[08006] [7] n\xc3\xa3o p\xc3\xb4de traduzir nome da m\xc3\xa1quina “angrboda:6432” para endere\xc3\xa7o: Nome ou servi\xc3\xa7o desconhecido’ in /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php:47\nStack trace:\n#0 /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php(47): PDO->__construct(‘pgsql:host=angr…’, ‘revistas’, ‘revistas’, Array)\n#1 /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/PostgresConnector.php(35): Illuminate\Database\Connectors\Connector->createConnection(‘pgsql:host=angr…’, Array, Array)\n#2 /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/ConnectionFactory.php(59): Illuminate\Database\Connectors\PostgresConnector->connect(Array)\n#3 /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/ConnectionFactory.php(47): Illuminate\ in /var/www/revistas3/html/lib/pkp/lib/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php on line 47

Hi @Tarcisio_Pereira,

The implementation on that issue has not been completed yet. It looks to me like it’s implemented for ADODB but not for PDO. (OJS uses two different kinds of database connections at the moment.)

Regards,
Alec Smecher
Public Knowledge Project Team

1 Like

Thank you @asmecher

I will be waiting for it.

Regards,
Tarcisio Pereira.

Hi, I have OJS 3.2.1-4, postgres and php 7.2. We are encountering this same error that @Tarcisio_Pereira and the database is getting too select, so it is locking the machine. Do you know what I could do?
It started to get pretty bad after an attempt to upgrade to php 7.3.
This is the error:

PHP Fatal error:  Uncaught PDOException: SQLSTATE[08006] [7] FATAL:  sorry, too many clients already in /var/www/ojs-3.2.1-4/lib/pkp/lib/vendor/illuminate/database/Connectors/Connector.php:70\nStack trace:\n#0 /var/www/ojs-3.2.1-4/lib/pkp/lib/vendor/illuminate/database/Connectors/Connector.php(70): PDO->__construct('pgsql:host=loca...', 'postgres', 'mypasswd', Array)\n#1 /var/www/ojs-3.2.1-4/lib/pkp/lib/vendor/illuminate/database/Connectors/Connector.php(46): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('pgsql:host=loca...', 'postgres', 'mypasswd', Array)\n#2 /var/www/ojs-3.2.1-4/lib/pkp/lib/vendor/illuminate/database/Connectors/PostgresConnector.php(33): Illuminate\\Database\\Connectors\\Connector->createConnection('pgsql:host=loca...', Array, Array)\n#3 /var/www/ojs-3.2.1-4/lib/pkp/lib/vendor/illuminate/database/Connectors/ConnectionFactory.php(182): Illuminate\\Database\\Connectors\\PostgresConnector->connect(Array)\n#4 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\C in /var/www/ojs-3.2.1-4/lib/pkp/lib/vendor/illuminate/database/Connection.php on line 664

Regards

@Adriano_Jose,

This is an older forum post - using a different version of OJS. Can you please make a new post describing your issue and link back to this one?

-Roger
PKP Team

1 Like