Unabable to login

[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!