yunohost-apps / dolibarr_ynh Goto Github PK

Hi, I've tried to install many times Dolibarr, but I always have the same bug after the installation.

First : I need to remove install.lock
Then : I can launch the first installation
At the end, it asks a password for the first user (I can't choose the login btw).
Then I arrive at the login page, and I can't connect, with a wrong password or login advertisement ......

Context

• Hardware: Yunohost on a Synology VM
• YunoHost version: 11.0.10.2 (stable)
• Dollibarr version : 16.0.3

i have a problem with upgrading from 15.0.3 to 16.0.3

WARNING - 688 Source path '/etc/php/8.0/fpm/pool.d/dolibarr.conf' does not exist

I have no idea what it has there and how I can fix the error

2022-12-09 11:10:59,959: DEBUG - 639 ++ app=dolibarr
2022-12-09 11:10:59,959: DEBUG - 639 ++ [[ do_not_backup_data =~ (unprotected|protected|skipped)_ ]]
2022-12-09 11:10:59,959: DEBUG - 640 ++ ynh_app_setting get dolibarr do_not_backup_data
2022-12-09 11:10:59,999: DEBUG - 680 + do_not_backup_data=
2022-12-09 11:10:59,999: DEBUG - 680 + '[' '!' -e /etc/php/8.0/fpm/pool.d/dolibarr.conf ']'
2022-12-09 11:11:00,000: DEBUG - 680 + ynh_print_warn '--message=Source path '''/etc/php/8.0/fpm/pool.d/dolibarr.conf''' does not exist'
2022-12-09 11:11:00,006: DEBUG - 687 + ynh_print_log 'Source path '''/etc/php/8.0/fpm/pool.d/dolibarr.conf''' does not exist'
2022-12-09 11:11:00,006: DEBUG - 687 + echo -e 'Source path '''/etc/php/8.0/fpm/pool.d/dolibarr.conf''' does not exist'
2022-12-09 11:11:00,006: DEBUG - 687 + '[' 0 == 0 ']'
2022-12-09 11:11:00,007: WARNING - 688 Source path '/etc/php/8.0/fpm/pool.d/dolibarr.conf' does not exist
2022-12-09 11:11:00,007: DEBUG - 688 + echo /etc/php/8.0/fpm/pool.d/dolibarr.conf
2022-12-09 11:11:00,007: DEBUG - 688 + grep --quiet /etc/fail2ban
2022-12-09 11:11:00,008: DEBUG - 688 + return 1
2022-12-09 11:11:00,008: DEBUG - 688 + ynh_exit_properly
2022-12-09 11:11:00,510: DEBUG - 1191 + exit 1
2022-12-09 11:11:01,511: DEBUG - 2192 Could not run script: /var/cache/yunohost/app_tmp_work_dirs/app_1ug0ikxm/scripts/backup
2022-12-09 11:11:01,513: WARNING - 2194 Could not back up dolibarr
2022-12-09 11:11:01,516: DEBUG - 2197 The operation 'Create a backup archive' could not be completed. Please share the full log of this operation using the command 'yunohost log share 20221209-111059-backup_create' to get help
2022-12-09 11:11:01,521: DEBUG - 2202 action [1346618.1] executed in 2.097s
2022-12-09 11:11:01,521: WARNING - 2202 Nothing to save
2022-12-09 11:11:01,543: DEBUG - + ynh_die '--message=Backup failed, the upgrade process was aborted.'
2022-12-09 11:11:01,554: WARNING - Backup failed, the upgrade process was aborted.
2022-12-09 11:11:02,556: ERROR - dolibarr konnte nicht aktualisiert werden: Es ist ein Fehler im App-Upgrade-Skript aufgetreten

2022-12-09.txt

sorry for the lack of details, just starting out. The install looks like it works but when I try to go into the site I always get:

The application tried to self-upgrade, but the install/upgrade pages have been disabled for security (by the existence of a lock file install.lock in the dolibarr documents directory).
If an upgrade is in progress, please wait. If not, click on the following link. If you always see this same page, you must remove/rename the file install.lock in the documents directory.
Click here to go to your application

Now, I don't know how to delete this so it's a dead/failed app for me :(

There is a missing PHPZIPextensionNotLoaded error when trying to download a selection of invoices.

I could fix that by installing php7.0-zip by hand:

sudo apt-get install php7.0-zip

This extension should be installed during the dolibarr installation.

On my last upgrade I've seen this error:

./upgrade: line 207: [: -eq: unary operator expected

The problem is here:

Hi,

Trying to install a custom module on my Dolibarr instance (admin/modules.php?mode=deploy), I have an error message regarding access rights of htdocs folder :

L'installation de module externe est impossible depuis l'interface web pour la raison suivante :
Impossible d'écrire dans le répertoire /var/www/dolibarr/htdocs/custom

Indeed, root is the owner of htdocs folder. Changing owner to dolibarr solves the issue.

Yunohost redirects to homepage instead of Dolibarr. I don't totally understand it so I will post what the creator of Dolidroid found:

"When you click on the "search" button, the application call the page https://****.com/dolibarr/core/search_page.php. Because dolidroid is designed to increase performance, page is loaded into another process than the main web page. So already done authentication is not valid and yunohost asks for another authentication login and password.

If you enter it, yunohost should redirect to https://.com/dolibarr/core/search_page.php but here it redirects to https://.com/

I'm afraid there is no way to use dolidroid with yunohost until the redirect of yunohost is fixed or removed."

I will ask the creator of Dolidroid watch this issue to see if he can offer any further info.

Having the same problem as the past like 3 issues #26 and #19, get up to that same page, and can't get any further. When I delete the install.lock file from out of /var/www/dolibarr/documents, and then I get this page that says to upgrade, when I try that, it does nothing for me, and just puts the install.lock back, can't even select the 'Fresh Install', says I can't get to it or something.

After Upgrade from 16.0.4 to 16.0.5 is a Bug

DolibarrHasDetectedError.
InformationToHelpDiagnose:
Date: 20230402131101
Dolibarr: 16.0.5 - https://www.dolibarr.org
PHP: 7.4.33
Server: nginx/1.18.0
OS: Linux yunohost 5.15.85-1-pve #1 SMP PVE 5.15.85-1 (2023-02-01T00:00Z) x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/111.0

RequestedUrl: /dolibarr/
Referer: https://domain.com/yunohost/sso/?r=aHR0cHts6Ly9yZWJsZXIubmFDFSxvbGliYXJyLw==
MenuManager:

DatabaseTypeManager: mysqli
RequestLastAccessInError: ErrorNoRequestInError
ReturnCodeLastAccessInError: ErrorNoRequestInError
InformationLastAccessInError: ErrorNoRequestInError

Message: host=localhost, port=3306, user=dolibarr, databasename=dolibarr, Connection refused

I got a "out of sort memory" in Dolibarr 12, in the invoice module. The same instance worked without problem on Dolibarr 11. Maybe on a smaller database it wouldn't display this.

It doesn't prevent to create a new invoice though. It just prevented a display a "customer invoices drafts" block. The other blocs worked fine.

To fix it, I had to modify

/etc/mysql/my.cnf

at the line

sort_buffer_size = 64K

I put

sort_buffer_size = 256K

instead. It's a global file, I don't know if it's possible to adjust this setting only for dolibarr.

When install works (cf. #10 , maybe related ?), dictionary tables (ynh_c_currencies, ynh_c_country, ...) are empty.

I don't know how to investigate further

# yunohost --version
yunohost: 
  repo: stable
  version: 2.7.10
yunohost-admin: 
  repo: stable
  version: 2.7.7
moulinette: 
  repo: stable
  version: 2.7.7
ssowat: 
  repo: stable
  version: 2.7.7

c.f. https://github.com/YunoHost-Apps/dolibarr_ynh/blob/master/scripts/install#L126-L129 which in done in install, but not in upgrade ... but Yunohost will replace the hook during upgrade, then breaking the post_user_create hook

Hi,

Thank you for your work. Trying installation Dolibarr on Yunohost.

However, I've got this message :

L'application a tenté de se mettre à niveau automatiquement, mais les pages d'installation / de mise à niveau ont été désactivées pour des raisons de sécurité (grâce à l'existence d'un fichier de verrouillage install.lock dans le répertoire de documents dolibarr).
Cliquez sur le lien suivant et si vous atteignez toujours cette page, vous devez supprimer manuellement le fichier install.lock dans le répertoire documents
Cliquez ici pour aller sur votre application

Yunohost is on a dedicated server (Kimsufi KS-7) with a new installation, Debian Stretch. I've already tried to install with yunohost app install https://github.com/YunoHost-Apps/dolibarr_ynh/tree/testing --debug. The issue is the same.

Deleting install.lock doesn't work. Re-install this application made the same issue too.

How can I solve it ?

Thanks

Describe the bug

Installation works but is unusable as per this thread. Log indicates warnings on things that should have been errors TBH (patch failed to apply, then postinstall failed on importing LDAP users).

Context

• Hardware: VPS bought online
• YunoHost version: 11.2.9.1 (stable)
• I have access to my server: Through SSH
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no
• Using, or trying to install package version/branch: 18.0.3~ynh1

Steps to reproduce

• Install from catalog

Expected behavior

Works.

Logs

Logs: https://paste.yunohost.org/raw/uxaqohezad

Describe the bug

L'utilisation de l'accès en caldav via le module cdav (https://github.com/Befox/cdav/blob/e7ba4efe9e699fb729f68c569f791316b5d64d13/README.md) me redirige vers l'authentification yunohost

Context

• Hardware: VM dédiée à yunohost
• YunoHost version: 4.2.8.3

J'ai tenté d'ajouter les commandes indiquées dans le readme du module pour nginx, mais l'authentification n'est pas demandée lors de l'ajout du lien caldav dans thunderbird. cela redirige vers l'url sso de yunohost et du coup l'authentification est impossible (car thunderbird ne présente pas l'interface web de login)

ce type d'utilisation est-il possible/compatible avec dolibarr sur yunohost ? (je connais assez bien nginx/debian & cie, mais beaucoup moins yunohost, il n'est donc pas impossible que je passe à côté d'une option de configuration)

Hello,
Once I installed dolibarr I always have this message on the first screen:

L'application a tenté de se mettre à niveau automatiquement, mais les pages d'installation / de mise à niveau ont été désactivées pour des raisons de sécurité (grâce à l'existence d'un fichier de verrouillage install.lock dans le répertoire de documents dolibarr). Cliquez sur le lien suivant et si vous atteignez toujours cette page, vous devez supprimer manuellement le fichier install.lock dans le répertoire documents Cliquez ici pour aller sur votre application

If I remove the install.lock then I have to upgrade the app, and when finished the same message appears

1. add the module cdav to standard installation

cdav - Dolibarr module to synchronize calendars, project tasks and address book from CalDAV/CardDAV/ICS client tools such as Mozilla Thunderbird/TBSync or Android DAVx5. Dolibarr becomes a CalDAV/CardDAV server.

I think it belongs to standard installation.

2. Information 17.0.1 TEST
   No problem at all when upgrading.
   No problems with daily use.
   cdav runs much better with 17.0.1 and PHP 8.

3. the version has already jumped to 17.0.2

Hello,

I just installed Dolibarr on Yunohost (both on latest stable versions), but the user in Dolibar is always listed as SuperAdmin, and not the current Yunohost user.

Did I miss something ?

When I want to create a new group inside Dolibarr, I'm blocked by permission control. I was logged with SuperAdmin user configured in the YNH installation panel.

hello!

is it possible to add the new version 19.0.0 to the testing branch? i think this is a big version jump

https://github.com/Dolibarr/dolibarr

Hi, i don't know how to passe out this bug.
Sorry i don't have the habbit to repport bug and if you need some more information please tell me
Thanks a lot

Describe the bug

A clear and concise description of what the bug is.

Context

• Hardware: * Old laptop or computer*
• YunoHost version: 4.2.6.1
• I have access to my server: All the way
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no
• Using, or trying to install package version/branch: classical with the store apps.

Steps to reproduce

1. Going to the app store.
2. Installing the app.
3. Trying to do the fist step and select French land then bug.

Logs

Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic (Vous pouvez fixer l'option $dolibarr_main_prod sur '1' pour supprimer quelques notifications):
Date: 20210710151925
Dolibarr: 13.0.3 - https://www.dolibarr.org
Niveau de fonctionnalités: 0
PHP: 7.3.29-1+020210701.86+debian101.gbp7ad6eb
Serveur: nginx/1.14.2
OS: Linux ankh.gr 4.19.0-17-amd64 #1 SMP Debian 4.19.194-2 (2021-06-21) x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:89.0) Gecko/20100101 Firefox/89.0

Url sollicitée: /dolibarr/admin/company.php
Referer: https://ankh.gr/dolibarr/admin/company.php?mainmenu=home&action=edit
Gestionnaire de menu: eldy_menu.php

Modules/Applications: user, ldap
Type gestionnaire de base de données: mysqli
Requête dernier accès en base en erreur: SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid= AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
Code retour dernier accès en base en erreur: DB_ERROR_SYNTAX
Information sur le dernier accès en base en erreur: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_de...' at line 1

Salut,

Je viens d'essayer ton package pour YunoHost 2.7.9.
Tout semble fonctionner. Nous sommes un réseau d'associations très intéressé par ton package, y-a-t-il des tests que nous pourrions mener qui pourraient aider ?

bonne journée

I haven't investigated so far, given that LDAP login does not work yet: #3

check_process seems to crash when we invoke CURL in the install
Any idea?

Describe the bug

*When you logout, it gives you error saying "Applicative disconnection should be useless when connection was made in mode http" even tho the HTTP is now HTTPS...

Context

• Hardware: ARM64 board / OCI / ...
  YunoHost 11.0.9.8 (stable).
• I have access to my server: SSH/ ROOT | ...
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no

The script name is: Dolibarr

Steps to reproduce

-Ah, Noting was done, just install and that's all,, but when u logout noting happens

Since update to 18.0.3~ynh2, all uploaded files, as invoices, are lost !

Hello !

I want to know if there is a mobile interface for dolibarr ?
If not, can you make something ?
Actually I can't go to dolibarr on my phone with yunohost.

Thanks

Describe the bug

A clear and concise description of what the bug is.

Context

• Hardware: Raspberry Pi at home
• YunoHost version: 4.2.8.3 (stable)
• I have access to my server: Through SSH | through the webadmin
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no, it's a fresh install of Yunohost on a Raspberry Pi 2

Steps to reproduce

On the webadmin of a fresh install of Yunohost (which was not up to date at the first try) : try to install the official Dolibarr package and it failed. I got this error during the install process :

Dolibarr installation fail : ERROR 1146 (42S02) at line 1: Table 'dolibarr.llx_const' doesn't exist

Updated through CLI (SSH) and retried to install the package on the webadmin : same error.

Tried to install the package through CLI (SSH). Same error :

sudo yunohost app install dolibarr
Choose the domain where this app should be installed [this-is-my-domain.nohost.me] (default: this-is-my-domain.nohost.me): this-is-my-domain.nohost.me
Choose the path where this app should be installed (default: /dolibarr): 
Choose an administrator user for this app [anthony | quentin] (default: anthony): 
Info: Installing dolibarr...
Info: [....................] > Validating installation parameters...
Info: [....................] > Storing installation settings...
Info: [....................] > Creating a MySQL database...
Info: [....................] > Setting up source files...
Info: [++++++++............] > Download source files...
Info: [########+...........] > Configuring system user...
Info: [#########...........] > Configuring PHP-FPM and install dependencies...
Info: [#########...........] > Configuring NGINX web server...
Info: [#########...........] > Configuring permissions...
Info: [#########...........] > Finalizing installation...
Info: [#########...........] > Generate fileconf
Info: [#########+..........] > installation - step 1
Info: [##########++++++++..] > installation - step 2 (may take a while)...
Info: [##################..] > installation - step 4
Info: [##################+.] > installation - step 5
Info: [###################.] > configuring LDAP
Warning: ERROR 1146 (42S02) at line 1: Table 'dolibarr.llx_const' doesn't exist
Error: Unable to install dolibarr: An error occurred inside the app installation script
Info: The operation 'Install the 'dolibarr' app' could not be completed. Please share the full log of this operation using the command 'yunohost log share 20210926-213942-app_install-dolibarr' to get help
Warning: Here's an extract of the logs before the crash. It might help debugging the error:
Info: DEBUG - + for arg in "${@:2}"
Info: DEBUG - + POST_data='testpost=ok&action=set&'
Info: DEBUG - + for arg in "${@:2}"
Info: DEBUG - + POST_data='testpost=ok&action=set&pass=**********&'
Info: DEBUG - + for arg in "${@:2}"
Info: DEBUG - + POST_data='testpost=ok&action=set&pass=**********&pass_verif=**********&'
Info: DEBUG - + '[' -n 'testpost=ok&action=set&pass=**********&pass_verif=**********&' ']'
Info: DEBUG - + POST_data='--data testpost=ok&action=set&pass=**********&pass_verif=**********'
Info: DEBUG - + sleep 2
Info: DEBUG - + local cookiefile=/tmp/ynh-dolibarr-cookie.txt
Info: DEBUG - + touch /tmp/ynh-dolibarr-cookie.txt
Info: DEBUG - + chown root /tmp/ynh-dolibarr-cookie.txt
Info: DEBUG - + chmod 700 /tmp/ynh-dolibarr-cookie.txt
Info: DEBUG - + curl --silent --show-error --insecure --location --header 'Host: this-is-my-domain.nohost.me' --resolve this-is-my-domain.nohost.me:443:127.0.0.1 --data 'testpost=ok&action=set&pass=**********&pass_verif=**********' https://localhost/dolibarr/install/step5.php --cookie-jar /tmp/ynh-dolibarr-cookie.txt --cookie /tmp/ynh-dolibarr-cookie.txt
Info: DEBUG - + echo '[###################.] > configuring LDAP'
Info: INFO - [###################.] > configuring LDAP
Info: DEBUG - + ynh_mysql_connect_as --user=dolibarr --password=********** --database=dolibarr
Info: DEBUG - + database=dolibarr
Info: DEBUG - + mysql --user=dolibarr --password=********** --batch dolibarr
Info: WARNING - ERROR 1146 (42S02) at line 1: Table 'dolibarr.llx_const' doesn't exist
Info: DEBUG - + ynh_exit_properly
Warning: Removing the app following the installation failure...
Info: [+...................] > Loading installation settings...
Info: [#+++++++++++........] > Removing the MySQL database...
Info: [############+.......] > Removing app main directory...
Info: [#############++.....] > Removing NGINX web server configuration...
Info: [###############+....] > Removing PHP-FPM configuration...
Info: [################+...] > Removing logrotate configuration...
Info: '/etc/dolibarr' wasn't deleted because it doesn't exist.
Info: [#################+..] > Removing the dedicated system user...
Info: [####################] > Removal of dolibarr completed
Error: The operation 'Install the 'dolibarr' app' could not be completed. Please share the full log of this operation using the command 'yunohost log share 20210926-213942-app_install-dolibarr' to get help

Logs

https://paste.yunohost.org/raw/recadumoja

Thank you in advance,

Best regards.

Caribou22

hello,

when uploading a PDF (invoice) bigger than 1 Mb, I get a "413 Request Entity Too Large" error in nginx. If I upload a PDF under 1 Mb, it works fine.

I don't know which file is responsible for this. In /etc/php/7.0/fpm/pool.d/dolibarr.conf I have:

php_admin_value[upload_max_filesize] = 30M

which should allow for a 30 Mb limit if I understood well.

I've also increased those values:

php_admin_value[memory_limit] = 62M
php_admin_value[upload_max_filesize] = 60M
php_admin_value[post_max_size] = 60M

I've also modified the dolibarr setting to limit files to 16 Mb instead of 8 Mb. But it's still the same, I get the 413 error.

So it's not a problem with php, but rather with nginx.

I've found in this file:

/etc/nginx/conf.d/myhostname.tech.d/dolibarr.conf

   # Common parameter to increase upload size limit in conjunction with dedicated php-fpm file
  # client_max_body_size 50M;

client_max_body_size was commented. I don't know how much is the default (I suppose 1 Mb), but maybe it would be better to increase this value by default? Some pdf to import can definitely be more than 1 Mb.

After I've uncommented the entry, I could upload a 4 Mb PDF!

Describe the bug

We can't directly delete and then restore dolibarr in a simple way.

Context

• Hardware: VPS (scaleway)
• YunoHost version: 4.2.6.1
• I have access to my server: Through SSH and through the webadmin
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no

I already had this error on a previous instance of this server, and I've erased it because of this error, I though my installation was broken :(

Steps to reproduce

removing dolibarr will give this log:

SUCCESS - dolibarr removed
DEBUG - Permission 'dolibarr.main' deleted
Uhoh, unknown permission dolibarr.main ? (Maybe we're in the process or deleting the perm for this app...)

we'll no longer see the dolibarr app in the yunohost interface.

But when trying to restore a backup (or install a new instance) we'll get this error:

Les applications suivantes ne peuvent pas être restaurées car elles sont déjà installées : dolibarr

So from the command line I've run a second time the uninstaller:

yunohost app remove dolibarr

Success! dolibarr removed
Info: The operation 'Remove the 'dolibarr' app' could not be completed. Please share the full log of this operation using the command 'yunohost log share 20210629-181927-app_remove-dolibarr' to get help

so I got a second time this same error with the dolibarr.main permission.

Here is the log: https://paste.yunohost.org/raw/wemobizuvu

But this time if try to remove it again, I got:

Could not find dolibarr in the list of installed apps

Then only this time I could restore dolibarr from my backup!

Expected behavior

Dolibarr should delete without error and restore from backup without having to delete it two times from the command line.

Logs

https://paste.yunohost.org/raw/wemobizuvu

https://github.com/Dolibarr/dolibarr/releases/tag/18.0.3

https://www.dolibarr.fr/forum/t/suppression-impossible-de-factures-prov-et-brouillons/43914/7

I have an error during installation script

2021-02-25 19:11:04,162: WARNING - ldap user update ended with error
2021-02-25 19:11:04,162: DEBUG - + echo -e 'ldap user update ended with error'
2021-02-25 19:11:04,162: DEBUG - + '[' 1 -eq 1 ']'
2021-02-25 19:11:04,163: DEBUG - + ynh_mysql_connect_as --user=dolibarr --password=********** --database=dolibarr
2021-02-25 19:11:04,264: DEBUG - + database=dolibarr
2021-02-25 19:11:04,265: DEBUG - + mysql --user=dolibarr --password=********** --batch dolibarr
2021-02-25 19:11:04,467: DEBUG - + ynh_exit_properly
2021-02-25 19:11:04,467: WARNING - ERROR 1364 (HY000) at line 7: Field 'morphy' doesn't have a default value
2021-02-25 19:11:04,468: DEBUG - + local exit_code=1
2021-02-25 19:11:04,469: DEBUG - + '[' 1 -eq 0 ']'
2021-02-25 19:11:04,469: DEBUG - + trap '' EXIT
2021-02-25 19:11:04,470: DEBUG - + set +o errexit
2021-02-25 19:11:04,471: DEBUG - + set +o nounset
2021-02-25 19:11:04,471: DEBUG - + sleep 0.5
2021-02-25 19:11:04,973: DEBUG - + type -t ynh_clean_setup
2021-02-25 19:11:04,973: DEBUG - + exit 1
2021-02-25 19:11:05,032: ERROR - Impossible d’installer dolibarr : Une erreur est survenue dans le script d’installation de l’application

yunohost up to date and fresh install on VM

@mastereur The process have to to create install.lock file after the dolibarr install.

An actual exploit is massively use on Dolibarr that aren't protected by this good practice.

https://sechead.com/headlines/cve:302ae05a7b4108d8f82d997ca455cd7217368613dca49273e01e0b07cedef5ed

I have a bug "Permission not granted"
Any ideas?

Dolibarr install failed - ERROR 1146 (42S02) at line 1: Table 'dolibarr.llx_const' doesn't exist

When i try to install dolibarr on fresh yuno install it fail from cmdline or from webadmin.

Context

• Hardware: debian 11 VM on proxmox
• YunoHost version: 11.0.4
• I have access to my server: *Through SSH and through the webadmin
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no
  • If yes, please explain:
• Using, or trying to install package version/branch: 14.0.5~ynh1

Steps to reproduce

• sudo yunohost app install dolibarr

Expected behavior

dollibarr successful installation

Logs

https://paste.yunohost.org/raw/vitawadepi

Describe the bug

After configuring the timezone on the server side, it didn't update in Dolibarr.
When I use POS, the time of sales is the old one.

Context

• Hardware: *VPS bought online
• YunoHost version: 11.2.4 (stable)
• I have access to my server: Through SSH | through the webadmin
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: *no

Steps to reproduce

• sudo dpkg-reconfigure tzdata
• Select Europe/Paris
• Go to PoS, create a new sell.

Dolibarr needs to compare the user password to the LDAP password from what I understood.
I have tried setting up the field "userPassword" in Dolibarr but it does not work. Dolibarr tries to compare to a md5 encrypted password, but YNH is salted.

Any idea?

For some unknown reason, the installation randomly fails.
It seems the problem appears at "step5" of the install process, regarding the logs.

Log of a succeed intall

<div class="divlogoinstall" style="text-align:center"><img class="imglogoinstall" src="../theme/dolibarr_logo.png" alt="Dolibarr logo"><br>6.0.4</div><br><span class="titre">Installation ou mise &agrave; jour de Dolibarr - Fin de l&#039;installation</span>                                                                                                                                          
<form name="forminstall" style="width: 100%" action="step5.php" method="POST">                                                                                                                        
<input type="hidden" name="testpost" value="ok">                                                                                                      
<input type="hidden" name="action" value="set">                                                    
<table class="main" width="100%"><tr><td>                                                                                                                                                             
<table class="main-inside" width="100%"><tr><td>
<br>Cr&eacute;ation du compte administrateur Dolibarr &#039;<b>tera</b>&#039; r&eacute;ussie.<br>Activation du module modLdap<br>Votre syst&egrave;me est maintenant install&eacute;.<br><br>Vous devez maintenant configurer Dolibarr selon vos besoins (Choix de l&#039;apparence, des fonctionnalit&eacute;s, etc.). Pour cela, cliquez sur le lien ci-dessous&nbsp;:<br><br><div class="center"><a href="../admin/index.php?mainmenu=home&leftmenu=setup&username=tera">Acc&eacute;der &agrave; Dolibarr (espace de configuration)</a></div></td></tr></table></td></tr></table>
<input type="hidden" name="selectlang" value="fr_FR"></form>

<!-- Start of log output
[...]
End of log output -->                                                                                                                                                                                 
                                                                                                                                                                                                      
</body>                                                                                                                                                                                               
</html>                                                                                                                                                                                               
+ mysql -u dolibarr -p5D3tieBMiVQc dolibarr                                                                                                                                                           
+ mysql -u dolibarr -p5D3tieBMiVQc dolibarr                                                                                                                                                           
+ sudo sudo -u www-data php /var/www/dolibarr/scripts/user/sync_users_ldap2dolibarr.php commitiferror --server=localhost -y                                                                           
***** sync_users_ldap2dolibarr.php (6.0.4) pid=8009 *****                                                                                                                                             
Mails sending disabled (useless in batch mode)

----- Synchronize all records from LDAP database:
host=localhost
port=389
login=
pass=
DN to extract=ou=users,dc=yunohost,dc=org
Filter=(&(objectClass=posixAccount))
----- To Dolibarr database:
type=mysqli
host=localhost
port=3306
login=dolibarr
database=dolibarr
----- Options:
commitiferror=1
excludeuser=
Mapped LDAP fields=uid,cn,sn,givenName,telephonenumber,facsimiletelephonenumber,mobile,mail

UserCreate # allan: login=allan, fullname=Allan --> Created user id=2 login=allan
[...]
UserCreate # yves: login=yves, fullname=Yves --> Created user id=33 login=yves

Pas d'erreur, on valide

+ '[' 0 = 1 ']'
+ ynh_app_setting_delete dolibarr unprotected_uris
+ sudo yunohost app setting -d dolibarr unprotected_uris --quiet
+ sudo yunohost app ssowatconf
La configuration de SSOwat a été générée
+ sudo sed -i 's@$dolibarr_main_authentication='\''dolibarr'\'';@$dolibarr_main_authentication='\''http'\'';@g' /var/www/dolibarr/htdocs/conf/conf.php
+ sed -i s@YNH_APP@dolibarr@g ../hooks/post_user_create
+ sed -i s@YNH_MEMBER@0@g ../hooks/post_user_create
+ ynh_exit_properly
+ local exit_code=0
+ '[' 0 -eq 0 ']'
+ exit 0
Succès ! La configuration de SSOwat a été générée
Succès ! Installation terminée

Log of a failed install

<div class="divlogoinstall" style="text-align:center"><img class="imglogoinstall" src="../theme/dolibarr_logo.png" alt="Dolibarr logo"><br>6.0.4</div><br><span class="titre">Installation ou mise &agrave; jour de Dolibarr - Fin de l&#039;installation</span>
<form name="forminstall" style="width: 100%" action="step5.php" method="POST">
<input type="hidden" name="testpost" value="ok">
<input type="hidden" name="action" value="set">
<table class="main" width="100%"><tr><td>
<table class="main-inside" width="100%"><tr><td>
<br>
+ mysql -u dolibarr -pHr6pXJ5Vu6qG dolibarr
+ mysql -u dolibarr -pHr6pXJ5Vu6qG dolibarr
+ sudo sudo -u www-data php /var/www/dolibarr/scripts/user/sync_users_ldap2dolibarr.php commitiferror --server=localhost -y
***** sync_users_ldap2dolibarr.php (6.0.4) pid=5451 *****
Mails sending disabled (useless in batch mode)

----- Synchronize all records from LDAP database:
host=localhost
port=389
login=
pass=
DN to extract=ou=users,dc=yunohost,dc=org
Filter=(&(objectClass=posixAccount))
----- To Dolibarr database:
type=mysqli
host=localhost
port=3306
login=dolibarr
database=dolibarr
----- Options:
commitiferror=1
excludeuser=
Mapped LDAP fields=uid,cn,sn,givenName,mail

UserCreate # allan: login=allan, fullname=Allan --> -1 Table 'dolibarr.ynh_user' doesn't exist
[...]
UserCreate # yves: login=yves, fullname=Yves --> -1 Table 'dolibarr.ynh_user' doesn't exist

Errors found but we validate despite this

+ ynh_exit_properly
+ local exit_code=33
+ '[' 33 -eq 0 ']'
+ trap '' EXIT
+ set +eu
+ echo -e '!!\n  dolibarr'\''s script has encountered an error. Its execution was cancelled.\n!!'
+ type -t ynh_clean_setup
+ ynh_die
+ echo ''
+ exit 1

!!
dolibarr's script has encountered an error. Its execution was cancelled.
!!

Exécution du script « /var/cache/yunohost/from_file/dolibarr_ynh-master/scripts/remove »...
+ source _common.sh
+ source /usr/share/yunohost/helpers
+++ run-parts --list /usr/share/yunohost/helpers.d
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/backend ']'
++ . /usr/share/yunohost/helpers.d/backend
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/filesystem ']'
++ . /usr/share/yunohost/helpers.d/filesystem
+++ CAN_BIND=1
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/ip ']'
++ . /usr/share/yunohost/helpers.d/ip
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/mysql ']'
++ . /usr/share/yunohost/helpers.d/mysql
+++ MYSQL_ROOT_PWD_FILE=/etc/yunohost/mysql
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/network ']'
++ . /usr/share/yunohost/helpers.d/network
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/package ']'
++ . /usr/share/yunohost/helpers.d/package
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/print ']'
++ . /usr/share/yunohost/helpers.d/print
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/setting ']'
++ . /usr/share/yunohost/helpers.d/setting
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/string ']'
++ . /usr/share/yunohost/helpers.d/string
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/system ']'
++ . /usr/share/yunohost/helpers.d/system
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/user ']'
++ . /usr/share/yunohost/helpers.d/user
++ for helper in '$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)'
++ '[' -r /usr/share/yunohost/helpers.d/utils ']'
++ . /usr/share/yunohost/helpers.d/utils
+ app=dolibarr
++ ynh_app_setting_get dolibarr domain
++ sudo yunohost app setting dolibarr domain --output-as plain --quiet
yunohost.app.setting
+ domain=agora-dev.tera.coop
+ sudo rm -rf /var/www/dolibarr
+ sudo rm -f /etc/nginx/conf.d/agora-dev.tera.coop.d/dolibarr.conf
+ sudo rm -f /etc/php5/fpm/pool.d/dolibarr.conf
+ sudo service php5-fpm reload
+ dbname=dolibarr
+ dbuser=dolibarr
+ ynh_mysql_drop_db dolibarr
+ ynh_mysql_execute_as_root 'DROP DATABASE dolibarr;'
++ sudo cat /etc/yunohost/mysql
+ ynh_mysql_connect_as root 2OqvCGBZSW ''
+ mysql -u root --password=2OqvCGBZSW -B ''
+ ynh_mysql_drop_user dolibarr
+ ynh_mysql_execute_as_root 'DROP USER '\''dolibarr'\''@'\''localhost'\'';'
++ sudo cat /etc/yunohost/mysql
+ ynh_mysql_connect_as root 2OqvCGBZSW ''
+ mysql -u root --password=2OqvCGBZSW -B ''
+ sudo service nginx reload
La configuration de SSOwat a été générée
Échec de l'installation

# yunohost --version
yunohost: 
  repo: stable
  version: 2.7.10
yunohost-admin: 
  repo: stable
  version: 2.7.7
moulinette: 
  repo: stable
  version: 2.7.7
ssowat: 
  repo: stable
  version: 2.7.7

dolibarr public folder (/public/ url) must be public

Describe the bug

Après l'installation de l'app dolibarr, j'ai une première erreur due au fichier install.lock.
Après suppression en ligne de commande de ce fichier, à la première connexion on tombe sur une page qui demande si on est sur une mise à jour ou première installation. J'ai choisi première installation, et en suivant les étapes j'obtiens cette erreur :

Ensuite, à l'étape suivante, il demande un mot de passe pour le compte qu'on avait défini comme administrateur au moment de l'installation, puis j'ai l'erreur suivante :

Echec de la création du compte administrateur Dolibarr L'identifiant totom existe déjà.


Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic (Vous pouvez fixer l'option $dolibarr_main_prod sur '1' pour supprimer quelques notifications):
Date: 20211008164037
Dolibarr: 14.0.2 - https://www.dolibarr.org
Niveau de fonctionnalités: 0
PHP: 7.3.31-1+0~20210923.88+debian10~1.gbpac4058
Serveur: nginx/1.14.2
OS: Linux lamo 4.19.0-17-amd64 #1 SMP Debian 4.19.194-2 (2021-06-21) x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:92.0) Gecko/20100101 Firefox/92.0

Url sollicitée: /install/step5.php
Referer: https://jolibar.lapoursuite.fr/install/step4.php
Gestionnaire de menu:

Modules/Applications: user, ldap
Message: step5.php: unknown choice of action

Évidemment l'utilisateur existe déjà, vu qu'on l'a choisi parmis les utilisateurs yunohost. Est-ce que c'est normal de passer par ce setup à l'installation ? J'ai aussi essayé le choix suggéré, "mise à jour 13.0 ou 14.0.0-»14.0", ça a l'air de bien marcher, mais à la fin quand je veux accéder à l'application, je retombe sur la page "Installation ou mise à jour de dolibarr".

Context

• Hardware: Old laptop or computer
• YunoHost version: 4.2.8.3
• I have access to my server: Through SSH and through the webadmin and direct access via keyboard / screen
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: yes
  • If yes, please explain: I have installed and then removed dolibarr last year on this server, don't know if something can interfere.
• Using, or trying to install package version/branch: 14.0.2~ynh1

Describe the bug

WARNING - ./50-dolibarr: line 14: [: -eq: unary operator expected, après l'ajout d'un user Yuno

Context

• Hardware: VPS bought online
• YunoHost version: 11.0.10.2
• I have access to my server: Through SSH AND through the webadmin
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no
  • If yes, please explain:
• Using, or trying to install package version/branch: master
• current package version: version: 15.0.3~ynh1

Steps to reproduce

• *operation: user_create depuis la webmin
• If you used the webadmin, please perform the equivalent command from the CLI first.
• If the error occurs in your browser, explain what you did:
  1. user_create` depuis la webmin

Expected behavior

after adding a user in yuno, I get a warning.
WARNING - ./50-dolibarr: line 14: [: -eq: unary operator expected
Il semble qu'il manque la valeur 0 pour la variable member=

Logs

2022-12-05 15:32:05,240: DEBUG - Executing command '['sh', '-c', '/bin/bash -x "./50-dolibarr" [email protected] 7>&1']'
2022-12-05 15:32:05,256: DEBUG - + app=dolibarr
2022-12-05 15:32:05,261: DEBUG - + src_path=/var/www/dolibarr
2022-12-05 15:32:05,262: DEBUG - + member=
2022-12-05 15:32:05,262: DEBUG - + sudo php /var/www/dolibarr/scripts/user/sync_users_ldap2dolibarr.php commitiferror --server=localhost -y
2022-12-05 15:32:05,415: DEBUG - ***** sync_users_ldap2dolibarr.php (15.0.3) pid=250311 *****
2022-12-05 15:32:05,415: DEBUG - Mails sending disabled (useless in batch mode)
2022-12-05 15:32:05,415: DEBUG - 
2022-12-05 15:32:05,416: DEBUG - ----- Synchronize all records from LDAP database:
2022-12-05 15:32:05,416: DEBUG - host=localhost
2022-12-05 15:32:05,416: DEBUG - port=389
2022-12-05 15:32:05,416: DEBUG - login=
2022-12-05 15:32:05,416: DEBUG - pass=
2022-12-05 15:32:05,417: DEBUG - DN to extract=ou=users,dc=yunohost,dc=org
2022-12-05 15:32:05,417: DEBUG - Filter=(&(objectClass=posixAccount))
2022-12-05 15:32:05,417: DEBUG - ----- To Dolibarr database:
2022-12-05 15:32:05,417: DEBUG - type=mysqli
2022-12-05 15:32:05,417: DEBUG - host=localhost
2022-12-05 15:32:05,417: DEBUG - port=3306
2022-12-05 15:32:05,418: DEBUG - login=dolibarr
2022-12-05 15:32:05,418: DEBUG - database=dolibarr
2022-12-05 15:32:05,418: DEBUG - ----- Options:
2022-12-05 15:32:05,418: DEBUG - commitiferror=1
2022-12-05 15:32:05,418: DEBUG - excludeuser=
2022-12-05 15:32:05,418: DEBUG - Mapped LDAP fields=cn,sn,givenname,uid,telephonenumber,facsimiletelephonenumber,mobile,mail
2022-12-05 15:32:05,419: DEBUG - 
2022-12-05 15:32:05,433: DEBUG - UserCreate # AA CC: login=aa_cc, fullname=AA CC --> -6 Login aa_cc already exists.
2022-12-05 15:32:06,606: DEBUG - Errors found but we validate despite this
2022-12-05 15:32:07,024: DEBUG - 
2022-12-05 15:32:07,033: DEBUG - + echo ldap user update ended with error
2022-12-05 15:32:07,034: DEBUG - ldap user update ended with error
2022-12-05 15:32:07,034: DEBUG - + '[' -eq 1 ']'
2022-12-05 15:32:07,036: WARNING - ./50-dolibarr: line 14: [: -eq: unary operator expected

• Après ajout 0 ca fonctionne.
• cf commit cabfd3d3c0de7da9e706206af761d06223f96da5 du Mar 24, 2021 cabfd3d
  Je pense que ca impact les instance dolibarr faites avant cette date.

https://github.com/Dolibarr/dolibarr/releases/tag/18.0.4

Describe the bug

my /media/Data folder and sub-folder owneship changed to Dolibarr:Dolibarr

Context

My YunoHost server

Hardware: : MacbookAir
YunoHost version: 4.3.6.2
I have access to my server : Through SSH | through the webadmin | direct access via keyboard / screen
Are you in a special context or did you perform some particular tweaking on your YunoHost instance ? : no - Some docker container installed but should not interfere

Description of my issue

Hi,
I opened a topic in yunohost forum, but I guess here is a better place. I discovered the issue trying to sync joplin thanks to my nextcloud. I had the error :

Last error: Error: DELETE locks/1_1_0f5a643a6edb41548f543321abf6b864.json: (Exception Sabre\DAV\Exception\Forbidden) (403): <?xml version="1.0" encoding="utf-8"?> <d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns"> <s:exception>Sabre\DAV\Exception\Forbidden</s:exception> <s:message/> </d:error>

I thought it was a nextcloud issue base on the error and initial googling. In fact, the lock table was empty and it was just the file itself that could not be removed, (yes, you should have better read the error message). I tried to delete the /media/Data/AppData/Joplin_notes/locks/1_1_0f5a643a6edb41548f543321abf6b864.json using the nextcloud web interface, I could not. ▶️ it happened to be a permission issue again. And I have not fixed it yet as I am unsure how to handle it safely.

Right after I failed at upgrading nextcloud I have installed #dolibarr an ERP/CRM as I wanted to start some personal business.
On my nextcloud installation, I have an External hard drive connected for additional space which is mounted in /media/Data. This is where most of my files are located --including Joplin Notes

After Dolibarr's installation, all the /media/Data ownership changed to Dolibarr:Dolibarr. Not sure whether permissions changed. This is why, the lock file cannot be removed, nextcloud does not have the permission anymore !

So I assumed that just installing Dolibarr changed the owneship as I did not do anything myself.
In dolibarr itself, I added a third parti, changes some masks for numbering and that's it.

Does dolibarr expect a /media/Data folder for its own use ?

Steps to reproduce

not able to test on another instance.

Expected behavior

A clear and concise description of what you expected to happen. You can remove this section if the command above is enough to understand your intent.

Logs

not sure what to provide