Text version of the portfolio of Rémi Moreau, a BTS SIO SISR student (French two-year degree in IT infrastructure and networks). Open in RémiOS, the interactive version → · Version française

Open-Prod v10 environment: architecture and maintenance

Type
Work project
Date
September 2026 – October 2026
Status
in progress
Technologies
Ubuntu 24.04, Open-Prod 10, Odoo, PostgreSQL, Python, PHP, Git, Git LFS, systemd, JasperReports, SSH
Skills
B1.1 Manage IT assets; B1.5 Make an IT service available to users; B1.6 Organise one’s professional development

Context

Since September 2026, I have been a work-study ERP consultant at 1Life, an integrator of the Open-Prod ERP within the Visiativ group. The first weeks are dedicated to training: learning Open-Prod on demo databases before working with customers. During this period I presented a purchase-to-sale flow, was trained in project-based management and prepared a production flow.

For this training, I have an Ubuntu virtual machine running a complete Open-Prod v10 installation. I administer it over SSH from my workstation, and use the ERP in the browser.

Objectives

Implementation

The machine's architecture. The virtual machine runs Ubuntu 24.04 and brings together several building blocks:

Architecture diagram of the Open-Prod v10 environment: from my Windows workstation, I administer the virtual machine over SSH and use Open-Prod in the browser. The Ubuntu 24.04 virtual machine runs the Open-Prod 10.2 server (Python, built on Odoo, systemd service), which stores its data in PostgreSQL (demo and training databases) and produces PDF documents with JasperReports. The MyFab tooling (1Life's PHP scripts, including app-manager and sql-update) drives the server and fetches updates from four Git repositories. Databases are duplicated, restored and imported from the browser.
Architecture of my Open-Prod v10 environment (diagram in French)

Four components tracked with Git. The installation relies on four Git repositories, each with its own version, which the openprod-info command displays:

Updating the environment. I use the app-manager command, which manages seven components: Open-Prod, the MyFab modules and the customer-specific modules, Jasper and its reports, and the tooling itself. For each one, it detects whether it is installed, then offers to install, update or uninstall it, and runs the matching script. The update fetches the new version of the code from Git, with Git LFS for large files. When an update succeeds and the component requires it, app-manager then moves straight on to synchronising the databases.

Synchronising the databases with the code (sql-update). The new code sometimes expects tables or columns that do not exist yet in the databases. The sql-update command brings them back in line:

  1. stopping the Open-Prod service, so that nobody changes the data during the operation;
  2. choosing the databases to process: one, several or all;
  3. recording the version of each repository in a log, to know afterwards which code each database was updated with;
  4. for each database, updating all the modules: Odoo compares the code with the database, creates or alters the tables and columns, reloads the menus and screens, and replaces the translations;
  5. restarting the service, then displaying any errors.

Despite its name, sql-update does not run hand-written SQL queries: Odoo translates the changes in the code into changes to the database. A database must be synchronised before it is used with a new version. Another script in the tooling can also record the branch and the latest commit of each repository in the database's system parameters: the version of the code can then be found from the database itself.

Duplicating, restoring and importing databases. From the web interface for managing databases, I duplicate the demo databases to work on a copy without damaging the original, restore a database to return to a known state, and import other demo and training databases.

Results and testing

Difficulties encountered

Understanding what the commands really did. At first, I used the tooling's commands without knowing what was behind them. To understand, I first found where they were defined (they are terminal aliases), then read the scripts' code. That is how I discovered that Open-Prod is built on Odoo, and that sql-update does not run SQL but a module update.

Possible improvements

Skills applied