项目部署到服务器上连不上数据库,egg.js部署上线，结果连不上服务器里的MySQL数据库，好难受~（更新：终于解决了）...

最新推荐文章于 2022-07-19 17:03:25 发布

weixin_39968823

最新推荐文章于 2022-07-19 17:03:25 发布

阅读量1.5k

点赞数

文章标签：项目部署到服务器上连不上数据库

在网上找了好久，egg.js部署上线教程几乎都和egg官方文档一样。

但是都没有提到MySQL数据库这一块

我是直接 sudo apt-get install mysql-server mysql-client 进行安装MySQL的

难受，难道真的要从入门到放弃么

更新：几个小时后，数据库终于连上了，但是在执行 npm start 时报错了

报错信息：

ubuntu@VM-0-8-ubuntu:/var/www/html/loveapi$ npm start

> loveapi@1.0.0 start /var/www/html/loveapi

> egg-scripts start --daemon --title=egg-server-loveapi --ignore-stderr

[egg-scripts] Starting egg application at /var/www/html/loveapi

[egg-scripts] Run node /var/www/html/loveapi/node_modules/egg-scripts/lib/start-cluster {"title":"egg-server-loveapi","baseDir":"/var/www/html/loveapi","framework":"/var/www/html/loveapi/node_modules/egg"} --title=egg-server-loveapi

[egg-scripts] Save log file to /home/ubuntu/logs

[egg-scripts] Wait Start: 1...

[egg-scripts] Wait Start: 2...

[egg-scripts] tail -n 100 /home/ubuntu/logs/master-stderr.log

[egg-scripts] Got error when startup:

[egg-scripts] 2019-12-28 22:35:56,008 ERROR 2722 [app_worker] server got error: bind EACCES 127.0.0.1:80, code: EACCES

[egg-scripts] 2019-12-28 22:35:56,021 ERROR 2704 nodejs.AppWorkerDiedError: [master] app_worker#1:2722 died (code: 0, signal: null, suicide: false, state: dead), current workers: []

[egg-scripts] at Master.onAppExit (/var/www/html/loveapi/node_modules/egg-cluster/lib/master.js:510:21)

[egg-scripts] at Master.emit (events.js:210:5)

[egg-scripts] at Messenger.sendToMaster (/var/www/html/loveapi/node_modules/egg-cluster/lib/utils/messenger.js:137:17)

[egg-scripts] at Messenger.send (/var/www/html/loveapi/node_modules/egg-cluster/lib/utils/messenger.js:102:12)

[egg-scripts] at EventEmitter. (/var/www/html/loveapi/node_modules/egg-cluster/lib/master.js:353:22)

[egg-scripts] at EventEmitter.emit (events.js:215:7)

[egg-scripts] at ChildProcess. (internal/cluster/master.js:188:13)

[egg-scripts] at Object.onceWrapper (events.js:300:26)

[egg-scripts] at ChildProcess.emit (events.js:210:5)

[egg-scripts] at Process.ChildProcess._handle.onexit (internal/child_process.js:272:12)

[egg-scripts] name: "AppWorkerDiedError"

[egg-scripts] pid: 2704

[egg-scripts] hostname: VM-0-8-ubuntu

[egg-scripts]

[egg-scripts] 2019-12-28 22:35:56,021 ERROR 2704 [master] app_worker#1:2722 start fail, exiting with code:1

[egg-scripts] 2019-12-28 22:35:56,021 ERROR 2704 [master] exit with code:1

[egg-scripts] 2019-12-28 22:35:56,029 ERROR 2711 [agent_worker] receive disconnect event on child_process fork mode, exiting with code:110

[egg-scripts] 2019-12-28 22:35:56,031 ERROR 2711 [agent_worker] exit with code:110

[egg-scripts]

[egg-scripts] Start got error, see /home/ubuntu/logs/master-stderr.log

[egg-scripts] Or use `--ignore-stderr` to ignore stderr at startup.

/home/ubuntu/logs/master-stderr.log 文件里的内容：

2019-12-28 22:30:54,738 ERROR 1761 [app_worker] server got error: bind EADDRINUSE 127.0.0.1:80, code: EADDRINUSE

2019-12-28 22:30:54,753 ERROR 1739 nodejs.AppWorkerDiedError: [master] app_worker#1:1761 died (code: 0, signal: null, suicide: false, state: dead), current workers: []

at Master.onAppExit (/var/www/html/loveapi/node_modules/egg-cluster/lib/master.js:510:21)

at Master.emit (events.js:210:5)

at Messenger.sendToMaster (/var/www/html/loveapi/node_modules/egg-cluster/lib/utils/messenger.js:137:17)

at Messenger.send (/var/www/html/loveapi/node_modules/egg-cluster/lib/utils/messenger.js:102:12)

at EventEmitter. (/var/www/html/loveapi/node_modules/egg-cluster/lib/master.js:353:22)

at EventEmitter.emit (events.js:215:7)

at ChildProcess. (internal/cluster/master.js:188:13)

at Object.onceWrapper (events.js:300:26)

at ChildProcess.emit (events.js:210:5)

at Process.ChildProcess._handle.onexit (internal/child_process.js:272:12)

name: "AppWorkerDiedError"

pid: 1739