如何在Digital Ocean上部署Adonis-js 5 ?

Question

我正在尝试在数字海洋上使用Adonisjs 5 API。我遇到了一个与。env相关的错误。下面是错误的代码库:

gmh@ubuntu-gmh:~/www/gmh-api$ cd build
gmh@ubuntu-gmh:~/www/gmh-api/build$ node ace migration:run --force
Exception 
E_MISSING_ENV_VALUE: Missing environment variable "DB_CONNECTION"

gmh@ubuntu-gmh:~/www/gmh-api/build$ 

我在。env文件中声明了DB_CONNECTION

PORT=3333
HOST=127.0.0.1
NODE_ENV=production
DRIVE_DISK=local
DB_CONNECTION=mysql

下面是数据库配置代码:

connection: Env.get('DB_CONNECTION'),
connections: {
/*
|--------------------------------------------------------------------------
| MySQL config
|--------------------------------------------------------------------------
|
| Configuration for MySQL database. Make sure to install the driver
| from npm when using this connection
|
| npm i mysql2
|
*/
mysql: {
client: 'mysql2',
connection: {
host: Env.get('MYSQL_HOST'),
port: Env.get('MYSQL_PORT'),
user: Env.get('MYSQL_USER'),
password: Env.get('MYSQL_PASSWORD', ''),
database: Env.get('MYSQL_DB_NAME'),
},

n/b: mysql安装在nginx server on Digital Ocean

朋友们，欢迎提供有用的见解。

我试着运行:

node ace migration:run --force  

在构建文件夹根，之后我得到:

Exception 
E_MISSING_ENV_VALUE: Missing environment variable "DB_CONNECTION"

Answer 1

移动到项目的根目录并运行迁移命令:

node ace migration:run --force  

如果你遇到这个错误:

create table `adonis_schema_versions` (`version` int not null) - Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set.

在这个链接中访问这个答案。