Unabable to login

[james]

Hello @sebastienserre
On every app start of @dolibarr the LDAP and OIDC configuration is written to the database before the fully starts.
Are you able to login with your Cloudron user?

[sebastienserre]

Hello @james
Not after having imported my SQL DB following https://docs.cloudron.io/guides/import-mysql
Is there some setting to add directly in the DB ?

[james]

Hello @sebastienserre
Can you try the following?

• Create an app backup
• Put the app into recovery mode
• open the Web Terminal of the app
• run:

  /app/pkg/sync-users.sh
  

• run:

  /app/pkg/start.sh
  

• Wait for the app to come reachable
• Try to login with your Cloudron user

[sebastienserre]

First command is returning an error

root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/code# /app/pkg/sync-users.sh
==> Syncing LDAP users into dolibarr
Created directory: /var/lib/snmp/cert_indexes
Error: Dolibarr config file content seems to be not correctly defined (file /core/lib/functions.lib.php not found).<br>
Please run dolibarr setup by calling page <b>/install</b>.<br>
root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/code# 

then the second is producing PHP Warning and then never go out from recovery mode

root@069c78d3-05f5-4e4b-a0be-da6396c1f304:/app/code# /app/pkg/start.sh
==> Ensure permissions
==> Starting Dolibarr
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 07:48:32.022598 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 07:48:32.022648 2026] [core:notice] [pid 22] AH00094: Command line: '/usr/sbin/apache2 -D FOREGROUND'
- - - [14/Jan/2026:07:48:40 +0000] "GET / HTTP/1.1" 200 7214 "-" "Mozilla (CloudronHealth)"
- 

The line - - - [14/Jan/2026:07:48:40 +0000] "GET / HTTP/1.1" 200 7214 "-" "Mozilla (CloudronHealth)"is repeating

[james]

Hello @sebastienserre

@sebastienserre said in Unabable to login:

The line - - - [14/Jan/2026:07:48:40 +0000] "GET / HTTP/1.1" 200 7214 "-" "Mozilla (CloudronHealth)"is repeating

This is the Cloudron Health check which checks if the app is responding. Seeing this would indicate that the app is up and running.

I am looking into the reported error when running /app/pkg/sync-users.sh.

[james]

Hello @sebastienserre

While the app is still in recovery mode, if your /app/pkg/start.sh script is still running, press CTRL+C to cancel the script or press the Restart App button in the top right corner of the Web Terminal.
Now you should be able to write commands again.

Please run the following command:

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;'

This will output all login, email, firstname and lastname entries from the database table dolibarr_user.
Example output from my test @dolibarr installation:

+----------------+--------------------+-----------+------------+
| login          | email              | firstname | lastname   |
+----------------+--------------------+-----------+------------+
| admin          |                    |           | SuperAdmin |
| james.smith    | james@cloudron.dev | James     | Smith      |
| test           | tina@cloudron.dev  | Tina      | Testing    |
+----------------+--------------------+-----------+------------+

If you see your Cloudron users there, please report back.

If you do not see your Cloudron Users there, please follow these steps:

Explanation of what we are running here.
The following commands are part of the /app/pkg/start.sh which normally start the @dolibarr app.
By default, /app/pkg/sync-users.sh is only run when /app/data/conf/conf.php does not exist.
So with the following commands we ignore the check and run it manually.

• run:

  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
  

The output should look something like this:

==> Syncing LDAP users into dolibarr
***** sync_users_ldap2dolibarr.php (22.0.4) pid=24 *****
Mails sending disabled (useless in batch mode)

----- Synchronize all records from LDAP database:
host=ldap://172.18.0.1
port=3002
login=cn=ce0b42af-a03c-4c21-b7a1-59b7b7026b9b,ou=apps,dc=cloudron
pass=********************************************************************************************************************************
DN to extract=ou=users,dc=cloudron
Filter=(&(objectclass=user))
----- To Dolibarr database:
type=mysqli
host=mysql
port=3306
login=c453b77d85cb3891
database=c453b77d85cb3891
----- Options:
commitiferror=0
excludeuser=
Mapped LDAP fields=cn,sn,givenName,username,mail

UserCreate # James Smith: login=james.smith, fullname=James Smith --> -6 Login james.smith already exists.
UserCreate # Tina Testing: login=test, fullname=Tina Testing --> -6 Login test already exists.
Some errors were found. Changes have been rolled back.

In this output example the sync recognized that the two users from Cloudron james.smith and test do already exist.

After this, you can now run:

/app/pkg/start.sh

When you see the Cloudron Health Check, try to access your @dolibarr URL and login with a Cloudron User.

---

Also, what we might need to consider.
In your previous @dolibarr installation, please check the conf.php for $dolibarr_main_instance_unique_id.
I am not 100% sure if this is important but since it is named unique_id we might need to migrate that value to /app/data/conf/conf.php to get a fully working @dolibarr again.
Also check your old @dolibarr conf.php for other special configuration that might need to be migrated.

[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

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!