NodeJS API在本地工作，但对Heroku不起作用。

Question

因此，我有一个MERN应用程序(M -> MySQL)，我在智能云上部署了MySQL DB。

我将各自的字段(主机、用户、密码和数据库)替换为我从智能云中获得的值，而db正在正常工作(在Workbench上测试，并在本地运行后端服务器)。

现在，当我将我的NodeJS API部署到Heroku时，我所能访问的只有"/“路由，所有其他路由都提供一个404。我通过Heroku仪表板添加了所有env变量。我搞不懂为什么会发生这种事。

我的MySQL连接如下所示：

const connection = mysql.createConnection({
  host: <the host address I got from clever-cloud>,
  user: process.env.MYSQL_REMOTE_USER,
  password: process.env.MYSQL_REMOTE_PASS,
  database: <the db name I got from clever-cloud>,
  timezone: "UTC+0"
});

我的app.js

const express = require("express");
const path = require("path");
const cookieParser = require("cookie-parser");
const logger = require("morgan");
const cors = require("cors");
require("dotenv").config();
require("./db/db");

const fileupload = require('express-fileupload'); 


const indexRouter = require("./routes/index");
const studentRouter = require("./routes/students");
const teacherRouter = require("./routes/teachers");
const classroomRouter = require("./routes/classroom");
const timetableRouter = require("./routes/timetable");
const quizRouter = require("./routes/quiz");
const assignmentRouter=require("./routes/assignment");
const resourceRouter=require("./routes/resource")

const app = express();


app.use(fileupload({useTempFiles: true}))

app.use(logger("dev"));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(cors());
app.use(express.static(path.join(__dirname, "public")));

app.use("/", indexRouter);
app.use("/students", studentRouter);
app.use("/teachers", teacherRouter);
app.use("/classroom", classroomRouter);
app.use("/timetable", timetableRouter);
app.use("/quiz", quizRouter);
app.use("/assignment",assignmentRouter);
app.use("/resource", resourceRouter);

app.listen(process.env.PORT || "3001", () =>
{
    console.log("Connected.");
});

Answer 1

现在已经成功部署了。当我在其他树枝上的时候，我在推给赫鲁库大师，而我自己的主人却在我假设的位置后面有几次提交。

现在很好用。