Linux Setup - InveTrack Documentation

Prerequisites

Before installing InveTrack on Linux, ensure you have:

Ubuntu 18.04+ or CentOS 7+ or similar Linux distribution
Root or sudo privileges
At least 4GB of RAM (8GB recommended)
2GB of free disk space
Internet connection for downloading packages
Basic knowledge of Linux command line

Step 1: Install Node.js

1

Update Package Lists

sudo apt update

2

Install Node.js 22

Add NodeSource repository and install Node.js:

# Add NodeSource repository
                  
curl -fsSL https://deb.nodesource.com/setup_22.x | sudo -E bash -
                  
# Install Node.js
                  
sudo apt-get install -y nodejs

3

Verify Installation

node --version
                  npm --version

1

Install EPEL Repository

# For CentOS 7
                  sudo yum install -y epel-release

                  # For CentOS 8/RHEL 8
                  sudo dnf install -y epel-release

2

Install Node.js

# For CentOS 7
                  sudo yum install -y nodejs npm

                  # For CentOS 8/RHEL 8
                  sudo dnf install -y nodejs npm

Note

If the default version is too old, use NodeSource repository as shown in Ubuntu section.

1

Install Node.js

sudo pacman -S nodejs npm

Step 2: Install MySQL

1

Install MySQL Server

sudo apt install -y mysql-server

2

Secure MySQL Installation

sudo mysql_secure_installation

Follow the prompts to set root password and configure security options.

1

Install MySQL Server

# For CentOS 7
                  sudo yum install -y mysql-server

                  # For CentOS 8/RHEL 8
                  sudo dnf install -y mysql-server

2

Start and Enable MySQL

# For CentOS 7
                  sudo systemctl start mysqld
                  sudo systemctl enable mysqld

                  # For CentOS 8/RHEL 8
                  sudo systemctl start mysqld
                  sudo systemctl enable mysqld

1

Install MySQL

sudo pacman -S mysql

2

Initialize MySQL

sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

3

Create Database

# Login to MySQL
                
sudo mysql -u root -p

                # Create database
                
CREATE DATABASE invetrack_db;

                # Create user (optional but recommended)
                
CREATE USER 'invetrack'@'localhost' IDENTIFIED BY 'your_password';
                
GRANT ALL PRIVILEGES ON invetrack_db.* TO 'invetrack'@'localhost';
                
FLUSH PRIVILEGES;
                EXIT;

Step 3: Install InveTrack Server

1

Navigate to Server Directory


cd /path/to/inventory-manager/server

2

Install Dependencies

npm install

3

Create Environment File

nano .env

Add the following configuration:

# Database Configuration
                
DB_HOST=localhost
                
DB_PORT=3306
                
DB_NAME=invetrack_db
                
DB_USERNAME=root
                
DB_PASSWORD=your_mysql_password

                

# JWT Configuration
                
JWT_SECRET=your-super-secure-jwt-secret-key-change-this-in-production
                
JWT_EXPIRES_IN=24h

                

# Server Configuration
                
PORT=3000
                
NODE_ENV=development

                

# CORS Configuration
                
ALLOWED_ORIGINS=http://localhost:5000,http://localhost:3000

                

# Rate Limiting
                
RATE_LIMIT_MAX=1000
                
AUTH_RATE_LIMIT_MAX=1000
                
API_RATE_LIMIT_MAX=1000

                

# Logging
                
LOG_LEVEL=info
                

                
# OpenAI Configuration (Optional - for AI-powered reports)
                
# OPENAI_MODEL=gpt-4o-mini

AI Features

The OpenAI API key is configured through the application settings after login, not in the .env file. The OPENAI_MODEL variable is optional and defaults to 'gpt-4o-mini' if not specified.

4

Set Up Database

# Run migrations
                npm run db:migrate

                # Seed initial data
                npm run db:seed

5

Start the Server

npm run dev

Step 4: Configure OpenAI API Key (Optional)

InveTrack includes AI-powered features that generate intelligent reports and insights. To enable these features, you need to configure an OpenAI API key.

AI Features Available

With OpenAI API key configured, you can access:

Demand Forecasting: AI-powered predictions for inventory demand
Price Optimization: Intelligent pricing recommendations to maximize revenue
Product Performance Analysis: AI-generated insights on product trends
Cross-sell Recommendations: Suggestions for complementary products
Slow Moving Products: AI analysis of inventory that needs attention
Stockout Impact Analysis: Predictions on the impact of stockouts

1

Get Your OpenAI API Key

If you don't have an OpenAI API key yet, follow these steps:

Visit https://platform.openai.com
Sign up for an account or log in if you already have one
Navigate to API Keys section in your account settings
Click "Create new secret key"
Give your key a name (e.g., "InveTrack Production")
Copy the API key immediately (you won't be able to see it again)

Important

Keep your API key secure and never share it publicly. OpenAI charges based on usage, so monitor your API usage regularly.

2

Configure API Key in InveTrack

After completing the client setup and logging into the application:

Log in to InveTrack using the default admin credentials
Navigate to Settings from the main menu
Look for the "OpenAI API Key" or "AI Configuration" section
Paste your OpenAI API key into the designated field
Click "Save" to store the configuration

Note

The API key is stored securely in the database and is associated with your company. Each company can have its own API key configuration.

3

Verify AI Features

To verify that the API key is working correctly:

Navigate to the Reports or Analytics section
Try generating an AI-powered report (e.g., Demand Forecast or Price Optimization)
If configured correctly, the report should generate successfully
If you see an error, double-check that the API key is correct and has sufficient credits

Troubleshooting

If AI features are not working:

Verify the API key is correctly copied (no extra spaces)
Check your OpenAI account has available credits
Ensure your API key has not been revoked or expired
Check the application logs for detailed error messages

Step 5: Install InveTrack Client

1

Navigate to Client Directory

cd /path/to/inventory-manager/client

2

Install Dependencies

npm install

3

Configure API Endpoint

nano src/config/config.ts

Update the configuration:

export const baseUrl = "http://localhost:3000";
                
export const apiUrl = `${baseUrl}/api`;

4

Start the Client

npm run dev

Step 6: Access the Application

Open your web browser and navigate to:

http://localhost:5000

Default Login Credentials

Use these credentials to log in for the first time:

Email: admin@example.com
Password: admin123

Important

Change the default password immediately after your first login for security reasons.

Step 7: Production Setup with PM2

1

Install PM2 Globally

sudo npm install -g pm2

2

Create PM2 Configuration

Create

ecosystem.config.js

in the server directory:

module.exports = {
                apps: [{
                name: 'invetrack-server',
                script: './bin/www',
                instances: 1,
                autorestart: true,
                watch: false,
                max_memory_restart: '1G',
                env: {
                NODE_ENV: 'production',
                PORT: 3000
                }
                }]
                };

3

Start with PM2

pm2 start ecosystem.config.js
                pm2 save
                pm2 startup

Troubleshooting

Common Issues

Permission denied: Check file permissions and ownership
Port already in use: Use
```
netstat -tulpn | grep :3000
```
to find the process
MySQL connection failed: Verify MySQL is running with
```
sudo systemctl status mysql
```
Node modules not found: Ensure you're in the correct directory and run
```
npm install
```

Useful Commands

# Check Node.js version
            
node --version

            # Check MySQL status
            
sudo systemctl status mysql

            # Check running processes
            
ps aux | grep node

            # Check port usage
            
netstat -tulpn | grep :3000

            # View logs
            
tail -f /path/to/inventory-manager/server/logs/combined.log

Getting Help

If you encounter issues not covered in this guide, check the Troubleshooting page for more detailed solutions.

Linux Setup Guide

Prerequisites

Step 1: Install Node.js

Update Package Lists

Install Node.js 22

Verify Installation

Install EPEL Repository

Install Node.js

Note

Install Node.js

Step 2: Install MySQL

Install MySQL Server

Secure MySQL Installation

Install MySQL Server

Start and Enable MySQL

Install MySQL

Initialize MySQL

Create Database

Step 3: Install InveTrack Server

Navigate to Server Directory

Install Dependencies

Create Environment File

AI Features

Set Up Database

Start the Server

Step 4: Configure OpenAI API Key (Optional)

AI Features Available

Get Your OpenAI API Key

Important

Configure API Key in InveTrack

Note

Verify AI Features

Troubleshooting

Step 5: Install InveTrack Client

Navigate to Client Directory

Install Dependencies

Configure API Endpoint

Start the Client

Step 6: Access the Application

Default Login Credentials

Important

Step 7: Production Setup with PM2

Install PM2 Globally

Create PM2 Configuration

Start with PM2

Troubleshooting

Common Issues

Useful Commands

Getting Help