Error Host Not Reachable when connecting to mySQL database

1

Hello, I been trying to deploy my app on Render but for some reasons it can’t connect to my mySQL database on db4free. It was working fine on my local computer. I did add .env file on Environment. Anyone can’t help me?

Mar 4 05:24:59 PM  HostNotReachableError [SequelizeHostNotReachableError]: connect EHOSTUNREACH 85.10.205.173:8080
Mar 4 05:24:59 PM      at ConnectionManager.connect (/opt/render/project/src/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:98:17)
Mar 4 05:24:59 PM      at processTicksAndRejections (internal/process/task_queues.js:95:5)
Mar 4 05:24:59 PM      at async ConnectionManager._connect (/opt/render/project/src/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:220:24)
Mar 4 05:24:59 PM      at async /opt/render/project/src/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:174:32
Mar 4 05:24:59 PM      at async ConnectionManager.getConnection (/opt/render/project/src/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:197:7)
Mar 4 05:24:59 PM      at async /opt/render/project/src/node_modules/sequelize/lib/sequelize.js:305:26
Mar 4 05:24:59 PM      at async MySQLQueryInterface.select (/opt/render/project/src/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)
Mar 4 05:24:59 PM      at async Function.findAll (/opt/render/project/src/node_modules/sequelize/lib/model.js:1134:21)
Mar 4 05:24:59 PM      at async getImg (/opt/render/project/src/src/controllers/imgController.js:16:16) {
Mar 4 05:24:59 PM    parent: Error: connect EHOSTUNREACH 85.10.205.173:8080
Mar 4 05:24:59 PM        at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1146:16) {
Mar 4 05:24:59 PM      errno: -113,
Mar 4 05:24:59 PM      code: 'EHOSTUNREACH',
Mar 4 05:24:59 PM      syscall: 'connect',
Mar 4 05:24:59 PM      address: '85.10.205.173',
Mar 4 05:24:59 PM      port: 8080,
Mar 4 05:24:59 PM      fatal: true
Mar 4 05:24:59 PM    },
Mar 4 05:24:59 PM    original: Error: connect EHOSTUNREACH 85.10.205.173:8080
Mar 4 05:24:59 PM        at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1146:16) {
Mar 4 05:24:59 PM      errno: -113,
Mar 4 05:24:59 PM      code: 'EHOSTUNREACH',
Mar 4 05:24:59 PM      syscall: 'connect',
Mar 4 05:24:59 PM      address: '85.10.205.173',
1 Like
2

Hi,

You may need to check the documentation of you database provider, e.g. MySQL usually has a port of 3306.

Alan

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.