How to Setup UnoPim Using Nginx Server

Anuj Mishra

16 December 2024

UnoPim is a user-friendly, Open-source product information management (PIM) solution designed to streamline both, the management and distribution of product data.

Built on the Laravel framework, it helps businesses organize, update, and share product information across various platforms, enhancing operational efficiency and also customer satisfaction.

In the previous blog, we discussed UnoPim Installation on Ubuntu 24.04 using the Apache server.

Prerequisites:

Before proceeding with the installation, ensure your system meets the following requirements:

Ubuntu(Linux) Version ≥ 20.04
Minimum System Requirements:
- RAM: 8 GB or higher
- CPU: 4 Cores
- Disk Space: 10 GB

Required Software:

Web-server: NGINX
Database: MySQL 5.7 or higher, MariaDB 10.10 or higher,
PHP: 8.2 or higher
Composer: 2.2.0 or higher

UnoPim Installation Steps –

Step 1: Install the Nginx Web Server

Start by updating your local package repository and also installing Nginx:

sudo apt update

sudo apt-get install nginx -y

sudo systemctl start nginx

Verify that Nginx is running:

1	sudo systemctl status nginx

Step 2: Install MySQL and Create Database

For Local Database Server:

Install MySQL:

1	sudo apt-get install mysql-server -y

2. Configure the MySQL root user and create the database:

sudo mysql

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

CREATE DATABASE unopim_db;

CREATE USER unopim_user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'unopim_password';

GRANT ALL PRIVILEGES ON unopim_db.* TO 'unopim_user'@'localhost';

FLUSH PRIVILEGES;

exit

For AWS RDS (if using a remote database):

Connect to your RDS instance:

1	mysql -u admin -p -h [RDS_endpoint]

Create the database and user for UnoPim:

CREATE USER 'unopim_user'@'%' IDENTIFIED BY 'unopim_password';

CREATE DATABASE unopim_db;

GRANT ALL PRIVILEGES ON unopim_db.* TO 'unopim_user'@'%';

FLUSH PRIVILEGES;

exit

Step 3: Install PHP and Required Extensions

1. Install PHP 8.2 and the necessary extensions

php8.2-cli php8.2-apcu php8.2-bcmath php8.2-curl php8.2-opcache php8.2-fpm php8.2-gd php8.2-intl php8.2-mysql php8.2-xml php8.2-zip php8.2-mbstring php8.2-imagick

Also, Install Software Properties Common Package:

1	sudo apt install software-properties-common -y

2. Add PHP Repository (PPA: Ondrej PHP)

sudo add-apt-repository ppa:ondrej/php

sudo apt-get update

3. Install PHP 8.2 and Essential Extensions

1	sudo apt-get install php8.2-cli php8.2-apcu php8.2-bcmath php8.2-curl php8.2-opcache php8.2-fpm php8.2-gd php8.2-intl php8.2-mysql php8.2-xml php8.2-zip php8.2-mbstring php8.2-imagick

4. Adjust PHP settings in php.ini for PHP CLI and FPM:

The memory_limit is set to 1024M (1GB) to allow more memory usage for PHP scripts run via the terminal, useful for resource-intensive tasks.

The date.timezone is set to UTC to standardize the time zone globally, as a result, in avoiding local time zone issues.

#Update CLI PHP configuration.

sudo sed -i 's/^memory_limit = .*/memory_limit = 1024M/' /etc/php/8.2/cli/php.ini

sudo sed -i 's/^date.timezone = .*/date.timezone = UTC/' /etc/php/8.2/cli/php.ini

The memory_limit is set to 512M to limit memory usage for PHP scripts executed by the web server, as a result, balancing performance and resource usage.

The date.timezone is also set to UTC to ensure consistency across applications and servers.

#Update FPM PHP configuration

sudo sed -i 's/^memory_limit = .*/memory_limit = 512M/' /etc/php/8.2/fpm/php.ini

sudo sed -i 's/^date.timezone = .*/date.timezone = UTC/' /etc/php/8.2/fpm/php.ini

Step 4: Install Composer

1. Install curl, wget, and other required utilities:

1	sudo apt-get install curl wget zip unzip net-tools -y

2. Install Composer:

php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"

php -r "if (hash_file('sha384', 'composer-setup.php') === 'dac665fdc30fdd8ec78b38b9800061b4150413ff2e3b6f88543c636f7cd84f6db9189d43a81e5503cda447da73c7e5b6') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"

php composer-setup.php --version=2.5.8

php -r "unlink('composer-setup.php');"

sudo mv composer.phar /usr/local/bin/composer

Step 5: Creating User

Create a new user:

1	sudo adduser unopim

Step 6: Download and Configure UnoPim

1. Download the UnoPim code:

su unopim

cd /home/unopim/

Then, Create a New Project Using Composer (unopim/unopim)

composer create-project unopim/unopim

cd unopim

2. Copy the .env file:

1	cp .env.example .env

3. Edit .env and update the necessary values based on your database setup

APP_NAME=UnopimAPP_

DEBUG=false

APP_URL=http://localhost/

DB_CONNECTION=mysql

DB_HOST=localhost

DB_PORT=3306

DB_DATABASE=unopim_db

DB_USERNAME=unopim_user

DB_PASSWORD=unopim_password

Then, Save and exit the file.

exit

Step 7: Set Up Nginx Virtual Hosts and PHP conf

Create a virtual host configuration:

cd /etc/nginx/sites-available/

sudo nano unopim.local.conf

2. Add the following configuration (adjust paths and domain/IP as needed):

server {

listen 80;

server_name unopim.local; # Replace with your domain or IP address

root /home/unopim/unopim/public; # Document root for the website

index index.php;

# Log files (optional but useful for debugging)

access_log /var/log/nginx/log.access.log;

error_log /var/log/nginx/log.error.log;

# Handle PHP requests

location ~ \.php$ {

include snippets/fastcgi-php.conf;

fastcgi_pass unix:/run/php/php8.2-fpm.sock; # PHP 8.2 FPM socket

fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

include fastcgi_params;

}

# Handle static files (images, CSS, JavaScript)

location / {

try_files $uri $uri/ /index.php?$query_string;

}

3. Now run these two commands to create a link in sites-enabled and remove the default nginx host file:

To Create a Symbolic Link for Nginx Site Configuration

1	sudo ln -s /etc/nginx/sites-available/unopim.local.conf /etc/nginx/sites-enabled/

Remove the default nginx host file

1	sudo rm -f /etc/nginx/sites-enabled/default

4. Make changes in the Nginx conf file as per your user

cd /etc/nginx/

sudo nano nginx.conf

5. Now user needs to define in php fpm as user, group, listen.owner, and listen.group

1	sudo nano /etc/php/8.2/fpm/pool.d/www.conf

6. Now restart the server and php-fpm:

1	sudo systemctl restart php8.2-fpm

7. Test Nginx Configuration for Syntax Errors and Reload Nginx to Apply Configuration Changes

sudo nginx -t

sudo systemctl restart nginx

Step 8: Complete UnoPim Installation

1. Run the UnoPim installation:

su unopim

cd /home/unopim/unopim/

chown -R unopim:unopim /home/unopim/

mysql -uroot -p

SET GLOBAL log_bin_trust_function_creators = 1;

exit

Note: log_bin_trust_function_creators should only be enabled in development environments.

However, For production systems, avoid using this setting unless necessary. You can set the log_bin_trust_function_creators value to be 0 after installation.

SET GLOBAL log_bin_trust_function_creators = 0;

1	php artisan unopim:install

Follow the prompts for configuration, including setting up the application name, URL, currency, and admin credentials.

Set your admin Name, email, and password, and finish the installation.

For Example:
Admin credentials are:

ADMINISTRATOR_NAME=admin
ADMINISTRATOR_EMAIL=admin@example.com
ADMINISTRATOR_PASSWORD=admin@123

Now exit the user

exit

Step 9: Access UnoPim

Open a browser and navigate to the following URL:

http://unopim.local/ #Your domain if mapped with the server or IP comes here

Step 10: Install Supervisor

1. Update your package manager and install supervisor:

sudo apt update

sudo apt install supervisor

2. Check the status of supervisor:

1	sudo systemctl status supervisor

3. Navigate to the Supervisor configuration directory:

1	cd /etc/supervisor/conf.d

4. Create a configuration file named unopim_queue_daemon.conf:

1	sudo nano /etc/supervisor/conf.d/unopim_queue_daemon.conf

5. Add the following content:

[program:unopim-worker]

command=/path/to/php /path/to/your/unopim/artisan queue:work

autostart=true

autorestart=true

user=my_user

numprocs=8

process_name=%(program_name)s_%(process_num)02d

stderr_logfile=/var/log/unopim_worker.err.log

stdout_logfile=/var/log/unopim_worker.out.log

stopasgroup=true

Notes:

Replace /path/to/php with the path to your PHP binary.
Replace /path/to/your/unopim with the installation directory of UnoPIM.
Replace my_user with the user that runs PHP-FPM (e.g., www-data).

6. Apply Changes

Run the following commands to apply the new Supervisor configuration:

sudo supervisorctl reread

sudo supervisorctl update

7. Start the UnoPIM queue daemon workers:

1	sudo supervisorctl start all

8. Check whether it’s running or not using the command

1	tail -f /var/log/supervisor/supervisord.log

Need Support?

Thank You for reading this Blog!

For further more interesting blogs, keep in touch with us. If you need any kind of support, simply raise a ticket at https://webkul.uvdesk.com/en/.

For further help or queries, please contact us or raise a ticket.