NS8-Dolibarr App

stephdl · March 27, 2024, 1:43pm

I am a lazzy boy today, honestly, connect to a LDAP could be difficult, workable with one, failed with another schema

kemboielvis22 · March 27, 2024, 4:33pm

okay no problem

hucky · May 17, 2024, 2:37pm

Has anyone ever done a data migration from NS7 to NS8?

kemboielvis22 · May 19, 2024, 8:52pm

About the dolibar ldap issue i have never been able to fix
it has issues accessing the ldap server

can anyone help

oneitonitram · May 30, 2024, 8:12am

hello @mrmarkuz or @stephdl do you have anu idea as to how i could implement removal of install.lock in dolibarr just prior to upgrading, if update command is issued between versions…

TEsting upgrade cycle between Dolibarr 18.05 to 19.02 and in the process the following error is received

Equally, the message says, creating the file upgrade.unlock into Dolibarr documents directory would also resolve the problem.

so my thinking is.

WHat about creating the upgrade.unlock file prior to upgrade then removing it after the upgrade is complete.

in both instances i dont know if, the newly created file is automatically removed once upgrade is completed, or if a new install.lock file is created if removed before an upgrade.

Any ideas?

tried to ssh into the container, but i cant locate the folder, not sure if am looking wrongly

kemboielvis22 · May 30, 2024, 8:24am

I think i have an idea on this i will take a look at it later and give you the update

stephdl · May 30, 2024, 8:53am

it is a common lock I used with the NS7 version

github.com

stephdl/nethserver-dolibarr/blob/ns7/root/etc/e-smith/events/actions/nethserver-dolibarr-create-database

#!/usr/bin/perl


use strict;
use warnings;
use NethServer::Password;
use esmith::ConfigDB;

my $db = esmith::ConfigDB->open() || die("Can't open db");


my $old_version = $db->get_prop('dolibarr','rpmVersion') || '11.0.3';
$old_version =~ s/\.//g;

my $version = `/usr/bin/rpm -qi nethserver-dolibarr | awk -F': ' '/Version/ {print \$2}'`;
$version =~ s/\.//g;
chomp $version;

system('/usr/bin/mkdir -p /usr/share/dolibarr/rpm_logs');

This file has been truncated. show original

github.com

stephdl/nethserver-dolibarr/blob/ns7/root/etc/e-smith/events/actions/nethserver-dolibarr-do-database-upgrade

#!/bin/bash

#
# we use the internal php console to upgrade the mysql db
#
old_version=$1
version=$2

/usr/bin/mkdir -p /usr/share/dolibarr/rpm_logs

# test if we use a domain name and use it in URL
DomainName=$(/usr/sbin/e-smith/config getprop dolibarr DomainName)

if [[ $DomainName != '' ]];then
    URL="https://${DomainName}/htdocs/install/"
else
    URL="https://127.0.0.1/dolibarr/install/"
fi

# test with time out of 30 seconds

This file has been truncated. show original

oneitonitram · July 26, 2024, 2:27pm

Dolibarr Ldap Mapping

This example will help you to create user in dolibarr from your users in your lldap server from a specific group and to login with the password from the lldap server.

To connect ldap->dolibarr

In Dolibarr, install the LDAP module from Home → Modules/Applications
Go to the configuration of this module and fill it like this:

Users and groups synchronization: LDAP -> Dolibarr
Contacts’ synchronization: No
Type: OpenLdap
Version: Version 3
Primary server: ldap://example.com
Secondary server: Empty
Server port: port 3890
Server DN: dc=example,dc=com
Use TLS: No
Administrator DN: uid=admin,ou=people,dc=example,dc=com
Administrator password: secret

Click on modify then “TEST LDAP CONNECTION”.
You should get this result on the bottom:

 TCP connect to LDAP server successful (Server=ldap://example.com, Port=389)
Connect/Authenticate to LDAP server successful (Server=ldap://example.com, Port=389, Admin=uid=admin,ou=people,dc=example,dc=com, Password=**********)
LDAP server configured for version 3

And two new tabs will appear on the top: Users and Groups.

We will use only Users in this example to get the users we want to import.
The tab Groups would be to import groups.

Click on the Users tab and fill it like this:

Users’ DN: ou=people,dc=example,dc=com
List of objectClass: person
Search filter: memberOf=cn=yournamegroup,ou=groups,dc=example,dc=com

(or if you don’t have a group for your users, leave the search filter empty)

Full name: cn
Name: sn
First name: givenname
Login uid
Email address mail

Click on “MODIFY” and then on “TEST A LDAP SEARCH”.

You should get the number of users in the group or all users if you didn’t use a filter.

To import ldap users into the dolibarr database (needed to login with those users):

Navigate to Users & Groups → New Users.
Click on the blank form “Users in LDAP database”, you will get the list of the users in the group filled above. With the “GET” button, you will import the selected user.

To enable LDAP login:

Modify your conf.php in your dolibarr folder in htdocs/conf.
Replace

// Authentication settings
$dolibarr_main_authentication='dolibarr';

with:

// Authentication settings
// Only  add "ldap" to only login using the ldap server, or/and "dolibar" to compare with local users. In any case, you need to have the user existing in dolibarr.
$dolibarr_main_authentication='ldap,dolibarr'; 
$dolibarr_main_auth_ldap_host='ldap://127.0.0.1:3890';
$dolibarr_main_auth_ldap_port='3890';
$dolibarr_main_auth_ldap_version='3';
$dolibarr_main_auth_ldap_servertype='openldap';
$dolibarr_main_auth_ldap_login_attribute='uid';
$dolibarr_main_auth_ldap_dn='ou=people,dc=example,dc=com';
$dolibarr_main_auth_ldap_admin_login='uid=admin,ou=people,dc=example,dc=com';
$dolibarr_main_auth_ldap_admin_pass='secret';

You can add this line to enable debug in case anything is wrong:

$dolibarr_main_auth_ldap_debug='true';

Hoping to Automate the Process for NS8

ferdinando.arfe · August 6, 2024, 10:23pm

Yes, it’s a very important thing to do! I’ve tried to port the sql dump of Dolibarr from NS7 to a Dolibarr on Debian with no luck! Maybe the wrong versions (17.0.2 vs 19.0.2) but who know?

kemboielvis22 · August 6, 2024, 10:37pm

The database is not exporting or you are having issues migrating

oneitonitram · August 7, 2024, 12:05am

It would be best to first upgrade your Dolibarr App to latest version before attemtping 2 genrations Jump. that is bound to cause issues.

ferdinando.arfe · August 7, 2024, 7:03am

On the NS7 i’ve tried the @stephdl path to upgrade but with no other versions available beyond 17.0.2

ferdinando.arfe · August 7, 2024, 7:05am

Yes, when i start the import after few rows find error in the CREATE TABLE and, because its the first of many others, i think this kind of error could be the first of so many others

oneitonitram · August 7, 2024, 7:17am

In NS8, we have a version that included version 18 however, we had not properly impelemnted Backup and restore functions.

there are 2 was we could go about this.

We could have @stephdl Update his Module for NS8, to the latest possible version. then you import to NS8.
We could Build Versions 17 through 18 on a separate branch, then you could import to the version 17 on NS8, Manually run updates to the Version 18 on NS8 in the same branch.

and FInally Upgrade to Version 19 currently Published.

THis could potentially Offer Dolibarr NS7 users a Migration Path to NS8

@kemboielvis22 could you look into the possibility of implementing this

ferdinando.arfe · August 7, 2024, 7:28am

That’s a great idea! I’ll really appreciate your work on it

kemboielvis22 · August 7, 2024, 12:41pm

Okay sure i will check on it

oneitonitram · September 14, 2024, 5:43am

Dolibarr finally has an official docker image: Dolibarr/dolibarr-docker: Official Dolibarr docker images. Based on the work of Garcia MICHEL (tuxgasy) (github.com)

fausp · December 18, 2024, 9:35am

Dolibarr finally has an official docker image: Dolibarr/dolibarr-docker: Official Dolibarr docker images. Based on the work of Garcia MICHEL (tuxgasy) (github.com)
[/quote]

Could you please tell us what your plans are with the NS8-Doliabrr App, will it be available via the Software Center?

oneitonitram · December 18, 2024, 10:53am

hello @fausp it was Available via the software center before the new Update o NS8.

Our push was to make some further tests, Posibly change to the official docker image, and the the solution as release, so that ti can be available via software center, as at the moment, testing apps do not appear.

fausp · December 18, 2024, 11:10am

Hi, thank you for clarification, a Testchannel would be nice?

On march I have to build up a network for a custormer, do you think dolibarr will be available?