DailyAutomations
Can't reconnect to wordpress database
@thomas I was able to connect to the database to pull the information I needed (workflows from a table in this case) but still can't get it to reconnect to wordpress. Not a huge issue right now as would be less work to redploy a new instance and import what I pulled previously.
I will say it's the first time I'm seeing data tables in the "data" tab and that's pretty sweet!
47 replies
Can't reconnect to wordpress database
gotcha, based on the redeploy I just did, no affect.
Thanks for the quick responses, I'll have to revisit another time, I gotta log off. I'm more or less just trying to get it back up and running so I can do a wordpress export for my client. If any alternatives including somehow migrating the db, I'm all ears in the AM
47 replies
Can't reconnect to wordpress database
4-01-12T08:20:18.276324Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-01-12T08:20:18.276360Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-01-12T08:20:18.279662Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-01-12T08:20:18.304929Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-01-12T08:20:18.305044Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.2.0' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
47 replies
Can't reconnect to wordpress database
Error: connect ETIMEDOUT
at A._handleTimeoutError (C:\Users\masha\AppData\Local\Programs\dbgate\resources\app.asar\packages\plugins\dbgate-plugin-mysql\dist\backend.js:11:92918)
at listOnTimeout (node:internal/timers:557:17)
at processTimers (node:internal/timers:500:7)
Error JSON: {
"errorno": "ETIMEDOUT",
"code": "ETIMEDOUT",
"syscall": "connect",
"fatal": true
}
Connection: {
"server": "",
"engine": "mysql@dbgate-plugin-mysql",
"sshMode": "userPassword",
"sshKeyfile": "",
"port": "3306",
"user": "",
"password": "",
"unsaved": true,
"_id": "***"
}
Platform: win32
47 replies
Can't reconnect to wordpress database
from db logs: 2024-01-12 08:20:17+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-01-12T08:20:17.665179Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-01-12T08:20:17.897118Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-01-12T08:20:17.899234Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.2.0) starting as process 7
2024-01-12T08:20:17.908853Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-01-12T08:20:18.062031Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-01-12T08:20:18.276324Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-01-12T08:20:18.276360Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-01-12T08:20:18.279662Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-01-12T08:20:18.304929Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-01-12T08:20:18.305044Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.2.0' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
47 replies
Can't reconnect to wordpress database
Error: Connection lost: The server closed the connection.
at Socket.<anonymous> (C:\Users\masha\AppData\Local\Programs\dbgate\resources\app.asar\packages\plugins\dbgate-plugin-mysql\dist\backend.js:11:91460)
at Socket.emit (node:events:390:28)
at TCP.<anonymous> (node:net:687:12)
Error JSON: {
"fatal": true,
"code": "PROTOCOL_CONNECTION_LOST"
}
Connection: {
"server": "",
"engine": "mysql@dbgate-plugin-mysql",
"sshMode": "userPassword",
"sshKeyfile": "",
"port": "55851",
"user": "",
"password": ""
}
Platform: win32
47 replies
Can't reconnect to wordpress database
Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or that contact with the database server at roundhouse.proxy.rlwy.net:52618 could not be established. This could mean your host’s database server is down.
Are you sure you have the correct username and password?
Are you sure you have typed the correct hostname?
Are you sure the database server is running?
If you are unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress support forums.
47 replies