I deployed my first MERN stack app on Heroku, it is basically a liquor inventory manager : https://stockify-inventory-manager.herokuapp.com/
However it is unable to access database. Whenever I make an Axios call, my requests get rejected. I’ve wasted 7 hours trying to fix it today but to no avail. Any help is appreciated.
Here is my server.js
const express = require('express')
const dotenv = require('dotenv').config()
const connectDB = require('./config/db')
const {errorHandler} = require('./middleware/errorMiddleware')
const port = process.env.PORT || 5000
const app = express()
const path = require('path')
const cors = require('cors')
const mongoose = require('mongoose')
connectDB()
app.use(express.json());
app.use(cors());
app.use('/api/users', require('./routes/userRoutes'))
app.use('/api/inventory', require('./routes/inventoryRoutes'))
app.use('/api/weekly', require('./routes/weeklyRoutes'))
mongoose.connect( process.env.MONGODB_URI, { useNewUrlParser: true })
// Serve frontend
if (process.env.NODE_ENV === 'production') {
app.use(express.static(path.join(__dirname, '../frontend/build')))
app.get('*', (req, res) =>
res.sendFile(
path.resolve(__dirname, '../', 'frontend', 'build', 'index.html')
)
)
} else {
app.get('/', (req, res) => res.send('Please set to production'))
}
app.use(errorHandler)
app.listen(port, () => {
console.log(`Server up on ${port}`)
})
This is my package.json
{
"name": "stockify-inventory-manager",
"version": "1.0.0",
"description": "Manage your Alcohol Inventory easily",
"main": "server.js",
"scripts": {
"start": "node backend/server.js",
"server": "nodemon backend/server.js",
"client": "npm start --prefix frontend",
"dev": "concurrently "npm run server" "npm run client"",
"heroku-postbuild": "NPM_CONFIG_PRODUCTION=false npm install --prefix frontend && npm run build --prefix frontend"
},
"author": "Steve Yoo",
"license": "MIT",
"dependencies": {
"bcryptjs": "^2.4.3",
"bootstrap": "^5.1.3",
"colors": "^1.4.0",
"cors": "^2.8.5",
"dotenv": "^16.0.0",
"express": "^4.17.3",
"express-async-handler": "^1.2.0",
"font-awesome": "^4.7.0",
"jsonwebtoken": "^8.5.1",
"mongoose": "^6.2.3",
"react-router-dom": "^6.2.1"
}
}
Here are checklists of what I tried:
- Whitelist IP on mongoDB with 0.0.0.0/0
- Double check connection string from mongoDB and way it is set up in .env
- Check if any item is stuck in devdependencies instead of dependencies
- Double check my Heroku config variables and ensure they match .env
- Update nodejs to latest
If you need more clues source code is in my GitHub: https://github.com/dun1007/Stockify-Inventory-Manager
