[GUIDE] Get Dolibarr ERP with MariaDB running on UnRaid with Docker Compose


p0p

Recommended Posts

Hi,

 

I'm very new to Docker and this is my first time to add Containers with Docker Compose. If there are improvements, please let me know ūüôā

Currently running on: UnRaid 6.11.1

Used Docker Container: https://hub.docker.com/r/tuxgasy/dolibarr

 

Requirements:

  • UnRaid
  • Access to the Internet
  • Community Apps
  • Community App: Docker Compose

 

Steps:

  1. Have the Community Apps Extension installed.
  2. Search inside the Community Apps for "Docker Compose" and install the App.
  3. Switch to the Docker Tab, you'll see a new Section for Compose,
  4. At the Compose Section, on the most bottom left, click the Button "Add New Stack" - a Popup will appear.
  5. Give your Stack a name, in this Case "Dolibarr" and hit OK - Inside the Compose Section, you're going see your new created stack.
  6. Left of the Name of the stack "Dolibarr" hit the gear (option) icon - a popup will appear right above the name.
  7. Hit "Edit Stack" - a popup will appear in the center of the screen.
  8. Hit "Compose File" - the popup will close itself and a text editor will appear (you might have to scroll down a bit).
  9. Delete the content inside the text editor.
  10. Add these lines
    version: "3"
    
    services:
        mariadb:
            image: mariadb:latest
            environment:
                MYSQL_ROOT_PASSWORD: root
                MYSQL_DATABASE: dolibarr
            ports:
                - "3306:3306"
    
        web:
            image: tuxgasy/dolibarr
            environment:
                DOLI_DB_HOST: mariadb
                DOLI_DB_USER: root
                DOLI_DB_PASSWORD: root
                DOLI_DB_NAME: dolibarr
                DOLI_URL_ROOT: 'http://0.0.0.0'
                PHP_INI_DATE_TIMEZONE: 'Europe/Paris'
            ports:
                - "3002:80"
            links:
                - mariadb


    and hit Save at the top center of the text editor - A popup for "Edit Stack UI Labels" will appear

  11. Enter the following for the services
    Service: mariadb

    Icon - https://mariadb.com/wp-content/uploads/2019/11/mariadb-logo-vert_blue-transparent.png
    Web UI - http://[IP][PORT:3306]/
    Shell - leave as it is


    Service: web

    Icon - https://www.dolibarr.org/medias/image/www.dolibarr.org/images/stories/dolibarr.png
    Web UI - http://[IP][PORT:3002]/
    Shell - leave as it is

     

  12. In the column "Commands" hit "Compose Up" to start the deployment - It will create a Dolibarr and a MariaDB Container.

  13. The Docker Containers are going to start themselves.
    Grab a Coffee, the initial process can take a while until Dolibarr is up (depends on your machine).

  14. Navigate to http://YOURSERVERIP:3002 (replace YOURSERVERIP with the IP address of UnRaid server) // if this isn't working, try http://YOURSERVERIP:3002/install - The login mask should appear.

  15. To login to the Dolibar Dashboard, use the following login information:
    Default User:
    admin
    Defaul Password:
    admin

  16. Done -Setup Dolibarr as you wish 

 

Notes:

  • Port¬†3306 is the Dolibarr default port for the DB.
  • Port 3002 is a port set by me - you can set it to whatever port number you want.

 

Happy ERPing!

Edited by p0p
pretty things up
Link to comment
  • 1 month later...

You are a life saver. I have been trying and trying to get an ERP system in place and apparently I have come to the right spot. Is it possible to take this particular setup and use Adempiere  (ERP) instead of the Dolibarr. Adempiere is another open source ERP like Dolibarr, but far more in depth with lot numbers and just everything in general. It's a very vast interface. I have been banging my head into walls for weeks trying to compose Adempiere with something like PostreSQL and a possible barcode scanner but my skillset with docker compose has much to be desired. 
The only documentation I can find in the wild regarding installing Adempiere through docker compose is here:
https://adempiere.gitbook.io/docs/system-administration/installation/install-adempiere-easily-with-docker

Again, with little experience with docker compose I am at a loss. 

Edited by S3v3nD34dly51ns
Link to comment
12 hours ago, S3v3nD34dly51ns said:

You are a life saver. I have been trying and trying to get an ERP system in place and apparently I have come to the right spot. Is it possible to take this particular setup and use Adempiere  (ERP) instead of the Dolibarr. Adempiere is another open source ERP like Dolibarr, but far more in depth with lot numbers and just everything in general. It's a very vast interface. I have been banging my head into walls for weeks trying to compose Adempiere with something like PostreSQL and a possible barcode scanner but my skillset with docker compose has much to be desired. 
The only documentation I can find in the wild regarding installing Adempiere through docker compose is here:
https://adempiere.gitbook.io/docs/system-administration/installation/install-adempiere-easily-with-docker

Again, with little experience with docker compose I am at a loss. 

Hi, someone created a Community App for Dolibarr - for easier config use this app.
You can also take a look at my ERPNext Thread.
It's a great start and much more flexible, extendable and cheaper (in terms of plugin costs) than Dolibarr.

 

Regarding Adempiere...

I don't know about it but seems to be self-explaining. Be aware, I'm also a Docker beginner and following my instructions may break things - Creating Backups are advised!

Also.. you can find informations on the GitHub page https://github.com/adempiere/adempiere-docker

  1. Use Unraid Docker Compose Plugin to create a project and a folder
  2. paste in the env part to the Docker (attention! You need SSL activated to on your machine! Watch some tutorials to do so! You could also use a reverse proxy!)
    #  Copyright (C) 2003-2017, e-Evolution Consultants S.A. , http://www.e-evolution.com
    #  This program is free software: you can redistribute it and/or modify
    #  it under the terms of the GNU General Public License as published by
    #  the Free Software Foundation, either version 3 of the License, or
    #  (at your option) any later version.
    #  This program is distributed in the hope that it will be useful,
    #  but WITHOUT ANY WARRANTY; without even the implied warranty of
    #  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    #  GNU General Public License for more details.
    #  You should have received a copy of the GNU General Public License
    #  along with this program.  If not, see <http://www.gnu.org/licenses/>.ce
    #  Email: [email protected], http://www.e-evolution.com , http://github.com/e-Evolution
    ADEMPIERE_WEB_PORT=8274
    ADEMPIERE_SSL_PORT=4444
    ADEMPIERE_VERSION=3.9.3
    # ATENTION If is "Y" it will be replace de actual defined database with a empty ADempiere seed
    ADEMPIERE_DB_INIT=Y
  3. Have git installed on your unraid server
  4. cd to your project folder
  5. git Clone the repository to your project folder
    git clone https://github.com/adempiere/adempiere-docker.git
  6. Deploy ("install") the application to your project folder
    cd ..
    pwd 
    # From the adempiere-docker directory execute
    ./application.sh adempiere up -d --build
    # Wait a few minutes while the ADempiere Server installation is done 
    docker ps |grep postgres
    # The output should show something like 
    e70086fe9f89   dd4fa36a9c2f             "docker-entrypoint.s…"   11 months ago       Up 4 minutes       0.0.0.0:55432->5432/tcp                          postgres122_db_1
    docker ps |grep adempiere
    # The output should show something like 
    fe8cc0a49e77   adempiere                "/bin/sh -c '/root/s…"   11 months ago       Up 8 minutes       0.0.0.0:4444->4444/tcp, 0.0.0.0:8274->8888/tcp   adempiere
    docker logs adempiere

HINT: You may need to map the ports in the env and deploy step and change the IP-Address to get things working. Play around until you get it right. 

Edited by p0p
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.