Conversion Fails

[blitzdesigner]

Steps to reproduce

Tag a file with the configured Tag to trigger conversion.

Expected behaviour

File is converted to PDF

Actual behaviour

Error "sh: 1: /usr/bin/libreoffice/tmp: not found"

Server configuration detail

Operating system: Linux 4.4.0-166-generic #195-Ubuntu SMP Tue Oct 1 09:35:25 UTC 2019 x86_64

Webserver: Apache (apache2handler)

Database: mysql 5.7.28

PHP version:

7.3.11-1+ubuntu16.04.1+deb.sury.org+1
Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, sodium, session, standard, apache2handler, mysqlnd, PDO, xml, apcu, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, gmp, iconv, igbinary, imagick, intl, json, exif, mysqli, pdo_mysql, apc, posix, readline, redis, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xmlreader, xmlwriter, xsl, zip, Phar, Zend OPcache

Nextcloud version: 16.0.6 - 16.0.6.1

Updated from an older Nextcloud/ownCloud or fresh install:

Where did you install Nextcloud from: unknown

Signing status

Array
(
)

List of activated apps

Enabled:
 - accessibility: 1.2.0
 - activity: 2.9.1
 - admin_audit: 1.6.0
 - apporder: 0.8.0
 - audioplayer: 2.8.4
 - bookmarks: 2.3.1
 - calendar: 1.7.1
 - camerarawpreviews: 0.7.2
 - checksum: 0.4.3
 - cloud_federation_api: 0.2.0
 - comments: 1.6.0
 - contacts: 3.1.6
 - data_request: 1.3.0
 - dav: 1.9.2
 - deck: 0.6.6
 - drop_account: 0.1.0
 - event_update_notification: 0.3.4
 - external: 3.3.1
 - extract: 1.2.2
 - federatedfilesharing: 1.6.0
 - federation: 1.6.0
 - files: 1.11.0
 - files_accesscontrol: 1.6.0
 - files_automatedtagging: 1.6.0
 - files_downloadactivity: 1.5.0
 - files_external: 1.7.0
 - files_frommail: 0.3.0
 - files_pdfviewer: 1.5.0
 - files_retention: 1.5.1
 - files_rightclick: 0.15.1
 - files_sharing: 1.8.0
 - files_texteditor: 2.8.0
 - files_trackdownloads: 1.5.0
 - files_trashbin: 1.6.0
 - files_versions: 1.9.0
 - files_videoplayer: 1.5.0
 - firstrunwizard: 2.5.0
 - gallery: 18.3.0
 - groupfolders: 4.1.4
 - impersonate: 1.3.0
 - issuetemplate: 0.5.0
 - logreader: 2.1.0
 - lookup_server_connector: 1.4.0
 - mail: 0.17.0
 - metadata: 0.10.0
 - music: 0.11.1
 - news: 14.0.1
 - nextcloud_announcements: 1.5.0
 - notes: 3.0.3
 - notifications: 2.4.1
 - oauth2: 1.4.2
 - passman: 2.3.4
 - password_policy: 1.6.0
 - phonetrack: 0.5.2
 - polls: 0.10.4
 - previewgenerator: 2.1.0
 - privacy: 1.0.0
 - provisioning_api: 1.6.0
 - quota_warning: 1.5.0
 - ransomware_detection: 0.5.2
 - ransomware_protection: 1.4.1
 - recommendations: 0.4.0
 - richdocuments: 3.4.4
 - serverinfo: 1.6.0
 - sharebymail: 1.6.0
 - sharerenamer: 2.7.2
 - socialsharing_diaspora: 1.0.5
 - socialsharing_email: 1.0.6
 - spreed: 6.0.4
 - support: 1.0.0
 - survey_client: 1.4.0
 - systemtags: 1.6.0
 - tasks: 0.11.3
 - theming: 1.7.0
 - twofactor_backupcodes: 1.5.0
 - twofactor_nextcloud_notification: 1.1.2
 - twofactor_totp: 3.0.1
 - twofactor_u2f: 3.0.1
 - updatenotification: 1.6.0
 - user_usage_report: 1.1.2
 - viewer: 1.2.0
 - workflow_pdf_converter: 1.1.0
 - workflowengine: 1.6.0
Disabled:
 - dashboard
 - encryption
 - twofactor_yubikey
 - user_ldap

Configuration (config/config.php)

{
    "installed": true,
    "dbtype": "mysql",
    "dbname": "***REMOVED SENSITIVE VALUE***",
    "dbuser": "***REMOVED SENSITIVE VALUE***",
    "dbpassword": "***REMOVED SENSITIVE VALUE***",
    "dbhost": "***REMOVED SENSITIVE VALUE***",
    "dbtableprefix": "oc_",
    "passwordsalt": "***REMOVED SENSITIVE VALUE***",
    "forcessl": true,
    "blacklisted_files": [
        ".htaccess"
    ],
    "trusted_domains": [
        "cloud.herkt.eu"
    ],
    "theme": "",
    "default_language": "de",
    "3rdpartyroot": "",
    "3rdpartyurl": "",
    "defaultapp": "files",
    "knowledgebaseenabled": true,
    "appstoreenabled": true,
    "mail_domain": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpdebug": false,
    "mail_smtpmode": "smtp",
    "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpport": "25",
    "mail_smtptimeout": 10,
    "mail_smtpsecure": "tls",
    "mail_smtpauth": true,
    "mail_smtpauthtype": "LOGIN",
    "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
    "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
    "trashbin_retention_obligation": "30, auto",
    "allow_user_to_change_display_name": true,
    "appcodechecker": false,
    "updatechecker": true,
    "has_internet_connection": true,
    "check_for_working_webdav": true,
    "check_for_working_htaccess": true,
    "log_type": "nextcloud",
    "logfile": "\/media\/cloud\/herkt\/nextcloud.log",
    "loglevel": 2,
    "logdateformat": "F d, Y H:i:s",
    "logtimezone": "Europe\/Berlin",
    "log_query": false,
    "log_authfailip": true,
    "log_rotate_size": 104857600,
    "remember_login_cookie_lifetime": 1296000,
    "session_lifetime": 86400,
    "session_keepalive": true,
    "custom_csp_policy": "default-src 'self'; script-src 'self' 'unsafe-eval'; style-src 'self' 'unsafe-inline'; frame-src *; img-src *; font-src 'self' data:; media-src *",
    "xframe_restriction": true,
    "datadirectory": "***REMOVED SENSITIVE VALUE***",
    "maintenance": false,
    "apps_paths": [
        {
            "path": "\/var\/www\/cloud.herkt.eu\/apps",
            "url": "\/apps",
            "writable": true
        }
    ],
    "customclient_desktop": "https:\/\/nextcloud.com\/install\/#install-clients",
    "customclient_android": "https:\/\/play.google.com\/store\/apps\/details?id=com.nextcloud.client",
    "customclient_ios": "https:\/\/itunes.apple.com\/us\/app\/nextcloud\/id1125420102?mt=8",
    "enable_previews": true,
    "preview_max_x": 4096,
    "preview_max_y": 4096,
    "preview_max_scale_factor": 10,
    "preview_office_cl_parameters": "",
    "preview_libreoffice_path": "\/usr\/bin\/soffice",
    "enable_avatars": true,
    "openssl": {
        "config": "\/usr\/lib\/ssl\/openssl.cnf"
    },
    "singleuser": false,
    "instanceid": "***REMOVED SENSITIVE VALUE***",
    "version": "16.0.6.1",
    "ldapIgnoreNamingRules": false,
    "mail_from_address": "***REMOVED SENSITIVE VALUE***",
    "secret": "***REMOVED SENSITIVE VALUE***",
    "appstore.experimental.enabled": true,
    "debug": true,
    "overwrite.cli.url": "https:\/\/cloud.herkt.eu",
    "updater.release.channel": "production",
    "mysql.utf8mb4": true,
    "filelocking.enabled": true,
    "memcache.distributed": "\\OC\\Memcache\\Redis",
    "memcache.locking": "\\OC\\Memcache\\Redis",
    "memcache.local": "\\OC\\Memcache\\APCu",
    "redis": {
        "host": "***REMOVED SENSITIVE VALUE***",
        "port": 0,
        "timeout": 0
    },
    "app_install_overwrite": [
        "calendar"
    ]
}

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption:

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

Client configuration

Browser: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.99 Safari/537.36 Vivaldi/2.9.1705.41

Operating system:

Logs

Web server error log

Insert your web server log here 

Nextcloud log

[workflow_pdf_converter] Fatal: could not convert /vale/files/cloud/Traumauto/Ioniq/Finanzierungsrechner.xlsx, reason: []

at 2019-11-28T14:18:16+01:00

Browser log

[blizzz]

do you have libreoffice installed at all on the server?

[blitzdesigner]

yes I do,

sudo apt install libreoffice
Reading package lists... Done
Building dependency tree
Reading state information... Done
libreoffice is already the newest version (1:5.1.6~rc2-0ubuntu1xenial10).
0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded.

[blitzdesigner]

what I forgot, after a not working conversion, I get a mail from Cron containing:

sh: 1: /usr/bin/soffice/tmp: not found

of course I was not able to create that dir, bcause /soffice is no directory.

Any ideas?