Unabable to login
Dolibarr
23
Posts
3
Posters
96
Views
3
Watching
-
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.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.shis 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.shin 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 usedolibarr_instead ofllx_.
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_withdolibarr_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.shin 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.
- Edit the SQL file and replace
-
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 version1.12.3which packages Dolibarr version22.0.2- Update issue: Illegal mix of collations was
DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_cifixed by replacing withDEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ciin the SQL file - Custom plugins was missing named
totp2fawas 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:
Fixed by visitingError 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 '='$APP_FQDN/install/repair.php?force_utf8_on_tables=confirmedwaiting 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
-
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!
