Hi, I am trying to install an OJS 3.3.0-13 with a connection to a managed database in Digital Ocean but I get the following error: [Thu Nov 17 19:10:29.447146 2022] [php7:notice] [pid 29116] [client 162.158.91.189:64030] SQLSTATE[HY000] [2002] Connection timed out (SQL: create table announcement_ty…

Gracias. Si, está solucionado. En config.inc.php está la opción de definir un puerto. Por lo menos en la versión 3.3.0-13. Saludos.

Hi, thanks @touhidur . The error comes from this side. The installer uses the default port and Digital Ocean uses a custom one. I used the first recommendation mentioned here and at least it no longer throws TimeOut and the installation runs. What I have done is to add to the hostname, the port :21…

Dear @touhidur , is it possible that the connection port definition is in some of these folders? /lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php /lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/

Hi @Ppantaleo I believe it’s possible to define custom port for DB connection . Try adding a new config option for Database Settings in the config.inc.php file as port . You can also check possible DB options here at pkp-lib/PKPApplication.inc.php at stable-3_3_0 · pkp/pkp-lib · GitHub

PKP Community Forum

Error database conection Digital Ocean

Software Support

touhidur November 18, 2022, 8:19am 2

Maybe this can help you https://docs.digitalocean.com/support/when-connecting-to-my-database-i-get-a-connection-timed-out-error/ .

Regards
PKP Team