Unabable to login

sebastienserre

Oh!

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 dolibarr_user;'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1146 (42S02) at line 1: Table '628eb237668f648a.dolibarr_user' doesn't exist
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/code#

I think the first issue is the DB Prefix... default Dolibarr one is llx_ when I can see Cloudron one is 628eb237668f648a

I will first try to find steps to change it. Any resources are welcome

sebastienserre

Changed it simply in the conf.php

sebastienserre

oot@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@xxvinfo.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=57 *****
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#

The user sebastienserre is my old Dolibarr user, I do not see the default "admin" user created by Cloudron on Dolibarr install.

Note, the email used for my user is managed on Cloudron and is the email used as my Cloudron user (to install app etc)
Is there a conflict ?

scooke

Is it working now?? There was some impressive Help there for you, lots of code, etc., and here I was thinking maybe you were typing sebabastien!

james

Hello @sebastienserre

This output:

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

with

Error: LDAP setup for users not defined inside Dolibar

Indicated that the LDAP configuration fields did not get populated.

In the /app/pkg/start.sh this is normally done on the app start.
Since your sync failed here, and you just edited the conf.php to match your DB $dolibarr_main_db_prefix please run /app/pkg/start.sh once so the LDAP configuration fields get populated.
After you have run /app/pkg/start.sh once and can access the @dolibarr URL, cancel the script again with CTRL+C and run the above sync again.
Please share the output of that new sync attempt again.

@sebastienserre said in Unabable to login:

Note, the email used for my user is managed on Cloudron and is the email used as my Cloudron user (to install app etc)
Is there a conflict ?

This could be the case, but we will figure that out after you have attempted the above.

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

Edit the SQL file and replace llx_ with dolibarr_ for the database table names.
Instal a fresh @dolibarr app
Put the freshly installed @dolibarr app into recovery mode and do not disable the recovery mode unless instructed to do.
Follow the documentation to import the edited SQL file https://docs.cloudron.io/guides/import-mysql#import (do not disable the recovery mode)
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!

Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.

Cloudron Forum

Unabable to login