Unabable to login

[sebastienserre]

Unfortunately, restarting app and then redoing the command, doesn't change:

                                                                                                            Reconnecting...
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/code# mysql --user=${CLOUDRON_MYSQL_USERNAME} --password=${CLOUDRON_MYSQL_PASSWORD} --host=${CLOUDRON_MYSQL_HOST} ${CLOUDRON_MYSQL_DATABASE} -e 'SELECT login,email,firstname,lastname FROM llx_user;'
mysql: [Warning] Using a password on the command line interface can be insecure.
+----------------+------------------------+------------+------------+
| login          | email                  | firstname  | lastname   |
+----------------+------------------------+------------+------------+
| sebastienserre | sebastien@xxxnfo.com | Sébastien  | SERRE      |
| administrateur |                        |            | admin      |
| webservice     |                        |            | webservice |
| client         |                        |            | Client     |
+----------------+------------------------+------------+------------+
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/code# mkdir -p /run/dolibarr/{sessions,upgrade-logs,conf} /app/data/{dolibarr,conf,custom} /run/php/sessions
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/code# cp /app/pkg/conf.php /run/dolibarr/conf/conf.php
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/code# chown -R root:root /run/dolibarr/conf
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/code# /app/pkg/sync-users.sh
==> Syncing LDAP users into dolibarr
***** sync_users_ldap2dolibarr.php (22.0.4) pid=39 *****
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_NAME in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 81
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_FIRSTNAME in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 82
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_LOGIN in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 83
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_LOGIN_SAMBA in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 84
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_PASSWORD in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 85
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_PASSWORD_CRYPTED in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 86
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_PHONE in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 87
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_FAX in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 88
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_MOBILE in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 89
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_MAIL in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 94
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_TITLE in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 95
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_DESCRIPTION in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 96
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_SID in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 97
Mails sending disabled (useless in batch mode)

----- Synchronize all records from LDAP database:
host=
port=
login=
pass=
DN to extract=
Filter=(=*)
----- To Dolibarr database:
type=mysqli
host=mysql
port=3306
login=628eb237668f648a
database=628eb237668f648a
----- Options:
commitiferror=0
excludeuser=
Mapped LDAP fields=

Error: LDAP setup for users not defined inside Dolibarrroot@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/code# 
``

[james]

Hello @sebastienserre

I think I see the issue here.
In /app/pkg/start.sh the population of the LDAP configuration is hard coded to dolibarr_const and does not use the prefix set in /app/data/conf/conf.php.
Give me a moment to analyse this and find a solution.

[james]

Hello @sebastienserre

I have attempted to dynamically get the prefix on startup in the /app/pkg/start.sh.
Please execute the following commands:

cd /app/pkg/
wget https://file.cloudron.dev/api/v1/shares/sid-f89149647ff19f3ed38d09176fe55ecb872bd238a6cac86b2500be2ce71422f5?type=download -O dolibar_14886_1.patch
git apply dolibar_14886_1.patch

Now run:

/app/pkg/start.sh

Wait for the app to be reachable, and cancel the script again with CTRL+C.
Now attempt a user sync again:

mkdir -p /run/dolibarr/{sessions,upgrade-logs,conf} /app/data/{dolibarr,conf,custom} /run/php/sessions
cp /app/pkg/conf.php /run/dolibarr/conf/conf.php
chown -R root:root /run/dolibarr/conf
/app/pkg/sync-users.sh

Please share the full output of the whole process.

[sebastienserre]

unfortunately, wget doesn't work

root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/pkg# wget https://file.cloudron.dev/api/v1/shares/sid-f89149647ff19f3ed38d09176fe55ecb872bd238a6cac86b2500be2ce71422f5?type=download -O dolibar_14886_1.patch
dolibar_14886_1.patch: Read-only file system
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/pkg#
``

[james]

Hello @sebastienserre

Read-only file system

Your app is not in recovery mode.
Please put the app in recovery mode and try again.

[sebastienserre]

root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/code# cd /app/pkg/
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/pkg# wget https://file.cloudron.dev/api/v1/shares/sid-f89149647ff19f3ed38d09176fe55ecb872bd238a6cac86b2500be2ce71422f5?type=download -O dolibar_14886_1.patch
--2026-01-14 10:14:14--  https://file.cloudron.dev/api/v1/shares/sid-f89149647ff19f3ed38d09176fe55ecb872bd238a6cac86b2500be2ce71422f5?type=download
Resolving file.cloudron.dev (file.cloudron.dev)... 139.162.188.66, 2a01:7e01::2000:3cff:fe7c:9d41
Connecting to file.cloudron.dev (file.cloudron.dev)|139.162.188.66|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2957 (2.9K) [application/octet-stream]
Saving to: ‘dolibar_14886_1.patch’

dolibar_14886_1.patch                                100%[=====================================================================================================================>]   2.89K  --.-KB/s    in 0s      

2026-01-14 10:14:14 (509 MB/s) - ‘dolibar_14886_1.patch’ saved [2957/2957]
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/pkg# git apply dolibar_14886_1.patch
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/pkg# /app/pkg/start.sh
==> Ensure permissions
==> Starting Dolibarr
Created directory: /var/lib/snmp/cert_indexes
PHP Warning:  Undefined property: stdClass::$MAIN_VERSION_LAST_INSTALL in /app/code/htdocs/install/get-version.php on line 33
==> Running upgrade hooks .  -> 22.0.4
==> Upgrading from version  to version 22.0.4
[Wed Jan 14 10:15:22.480395 2026] [mpm_prefork:notice] [pid 22] AH00163: Apache/2.4.58 (Ubuntu) mod_perl/2.0.13 Perl/v5.38.2 configured -- resuming normal operations
[Wed Jan 14 10:15:22.480433 2026] [core:notice] [pid 22] AH00094: Command line: '/usr/sbin/apache2 -D FOREGROUND'
- - - [14/Jan/2026:10:15:30 +0000] "GET / HTTP/1.1" 200 7214 "-" "Mozilla (CloudronHealth)"
- - - [14/Jan/2026:10:15:40 +0000] "GET / HTTP/1.1" 200 7214 "-" "Mozilla (CloudronHealth)"
^Croot@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/pkgmkdir -p /run/dolibarr/{sessions,upgrade-logs,conf} /app/data/{dolibarr,conf,custom} /run/php/sessionsns
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/pkg# cp /app/pkg/conf.php /run/dolibarr/conf/conf.php
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/pkg# chown -R root:root /run/dolibarr/conf
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/pkg# /app/pkg/sync-users.sh
==> Syncing LDAP users into dolibarr
***** sync_users_ldap2dolibarr.php (22.0.4) pid=43 *****
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_NAME in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 81
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_FIRSTNAME in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 82
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_LOGIN in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 83
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_LOGIN_SAMBA in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 84
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_PASSWORD in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 85
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_PASSWORD_CRYPTED in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 86
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_PHONE in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 87
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_FAX in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 88
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_MOBILE in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 89
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_MAIL in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 94
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_TITLE in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 95
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_DESCRIPTION in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 96
PHP Warning:  Undefined property: stdClass::$LDAP_FIELD_SID in /app/code/scripts/user/sync_users_ldap2dolibarr.php on line 97
Mails sending disabled (useless in batch mode)

----- Synchronize all records from LDAP database:
host=
port=
login=
pass=
DN to extract=
Filter=(=*)
----- To Dolibarr database:
type=mysqli
host=mysql
port=3306
login=628eb237668f648a
database=628eb237668f648a
----- Options:
commitiferror=0
excludeuser=
Mapped LDAP fields=

Error: LDAP setup for users not defined inside Dolibarrroot@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/pkg# 

Note that /app/pkg/start.shdoesn't make Dolibarr out of recovery mode. I have to go out of recovery mode from CLoudron panel to get Doliabrr available.

[james]

Hello @sebastienserre

@sebastienserre said in Unabable to login:

I have to go out of recovery mode from CLoudron panel to get Doliabrr available.

Yes and no.
/app/pkg/start.sh is the script executed when the app is not in recovery mode.
So when the recovery mode is enabled, it is expected that the app is not reachable, unless you run /app/pkg/start.sh in the Web Terminal and let it running.

---

At this point I highly suspect there is a deeper issue with the imported DB.
We should attempt the following.
The SQL file you are importing should be edited to use dolibarr_ instead of llx_.
After that has been edited the SQL file should be imported according to the documentation https://docs.cloudron.io/guides/import-mysql#import

1. Edit the SQL file and replace llx_ with dolibarr_ for the database table names.
2. Instal a fresh @dolibarr app
3. Put the freshly installed @dolibarr app into recovery mode and do not disable the recovery mode unless instructed to do.
4. Follow the documentation to import the edited SQL file https://docs.cloudron.io/guides/import-mysql#import (do not disable the recovery mode)
5. start @dolibarr with /app/pkg/start.sh in the Web Terminal

---

If possible, you could provide the original SQL file that should be imported to me in a private forum message so I can better replicate the issue.

[james]

Analysis log of importing the DB and upgrading

Issues found:

• database version 22.0.2 is lower than programs version 22.0.4. Redirect to install/upgrade page.
  Solved by installed the Cloudron app version 1.12.3 which packages Dolibarr version 22.0.2
• Update issue: Illegal mix of collations was DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci fixed by replacing with DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci in the SQL file
• Custom plugins was missing named totp2fa was provided by @sebastienserre to fix the issue
• Old configured GeoLite2-Country file caused issues, disabled with UPDATE dolibarr_const SET value=0 WHERE rowid=1217;
  or in the SQL file:

  (1217,'MAIN_MODULE_GEOIPMAXMIND',1,'0',NULL,0,NULL,'2017-03-05 16:24:23'),
  

• After upgrade from 22.0.2 to 22.0.3 an SQL issue:

  Error DB_ERROR_1267 (Req 90): UPDATE dolibarr_accounting_account as acc SET acc.centralized = 1 WHERE acc.account_number in (SELECT value FROM dolibarr_const WHERE name IN ('ACCOUNTING_ACCOUNT_CUSTOMER','ACCOUNTING_ACCOUNT_SUPPLIER','SALARIES_ACCOUNTING_ACCOUNT_PAYMENT','ACCOUNTING_ACCOUNT_EXPENSEREPORT'));
  
  Illegal mix of collations (utf8mb3_unicode_ci,IMPLICIT) and (utf8mb3_general_ci,IMPLICIT) for operation '='
  

  Fixed by visiting $APP_FQDN/install/repair.php?force_utf8_on_tables=confirmed waiting for that to finish and restarting the app
• Updated to 22.0.3 and 22.0.4 with no more issues
• Database had an error which blocked the re-import of the db if dumped, thus also blocking cloudron backup restore, fixed by following https://www.dolibarr.org/forum/t/issue-restoring-data/24462 - so this was/is an DB migration issue between Dolibarr versions

[sebastienserre]

Many many thanks to @james who has providing me a very great support.
Without him I wouldn't have corretcly migrated my Dolibarr.

Thank you again!

[scooke]

Seriously, that is some amazing support. You will not find this elsewhere, anywhere. Cloudron rules!