search

e-alfred / ocdownloader

ocDownloader - AGPL-licensed multi-protocol download manager for Nextcloud using ARIA2, youtube-dl and Curl (supports Youtube, BitTorrent, HTTP, FTP)
https://github.com/e-alfred/ocdownloader
GNU Affero General Public License v3.0
376 stars 85 forks source link

Postgresql : Ocdownload don't load #206

Open thrynir opened 3 years ago

thrynir commented 3 years ago
### Steps to reproduce 1. Install ocdownloader 2. got to apps/ocdownloader/add ### Expected behaviour Should load all elements ### Actual behaviour Show loading behind filename but don't load ### Server configuration **Operating system**: Debian 10 **Web server:** : nginx **Database:** : postgresql **PHP version:** 7.3 **Nextcloud version:** 21.0.1 **Updated from an older Nextcloud/ownCloud or fresh install:** fresh install **Where did you install Nextcloud from:** https://download.nextcloud.com/server/releases/nextcloud-21.0.1.zip **Signing status:**
Signing status No errors have been found.
**List of activated apps:**
App list - accessibility: 1.7.0 - bruteforcesettings: 2.1.0 - cloud_federation_api: 1.4.0 - dashboard: 7.1.0 - dav: 1.17.1 - federatedfilesharing: 1.11.0 - federation: 1.11.0 - files: 1.16.0 - files_pdfviewer: 2.1.0 - files_rightclick: 1.0.0 - files_sharing: 1.13.1 - files_trashbin: 1.11.0 - files_versions: 1.14.0 - files_videoplayer: 1.10.0 - firstrunwizard: 2.10.0 - logreader: 2.6.0 - lookup_server_connector: 1.9.0 - notifications: 2.9.0 - oauth2: 1.9.0 - occweb: 0.0.7 - ocdownloader: 1.7.11 - password_policy: 1.11.0 - photos: 1.3.0 - privacy: 1.5.0 - provisioning_api: 1.11.0 - recommendations: 1.0.0 - serverinfo: 1.11.0 - settings: 1.3.0 - sharebymail: 1.11.0 - survey_client: 1.9.0 - text: 3.2.0 - theming: 1.12.0 - twofactor_backupcodes: 1.10.0 - updatenotification: 1.11.0 - user_ldap: 1.11.0 - viewer: 1.5.0 - workflowengine: 2.3.0 Disabled: - activity - admin_audit - comments - contactsinteraction - encryption - files_external - nextcloud_announcements - support - systemtags - user_status - weather_status
**Nextcloud configuration:**
Config report "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "***REMOVED SENSITIVE VALUE*** ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "pgsql", "version": "21.0.1.1", "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "mail_sendmailmode": "smtp", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "25", "default_phone_region": "FR", "app_install_overwrite": [ "occweb", `"ldaporg", ], "memcache.local": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0 }, "maintenance": false } }
**Are you using external storage, if yes which one (currently not supported by ocDownloader):** local **Are you using encryption (currently not supported by ocDownloader):** no **Are you using an external user-backend, if yes which one:** LDAP #### LDAP configuration (delete this part if not used)
LDAP config +-------------------------------+---------------------------------------------------------------------------------------+ | Configuration | s01 | +-------------------------------+---------------------------------------------------------------------------------------+ | hasMemberOfFilterSupport | 0 | | homeFolderNamingRule | | | lastJpegPhotoLookup | 0 | | ldapAgentName | ***REMOVED SENSITIVE VALUE*** | | ldapAgentPassword | *** | | ldapAttributesForGroupSearch | | | ldapAttributesForUserSearch | | | ldapBackupHost | | | ldapBackupPort | | | ldapBase | ***REMOVED SENSITIVE VALUE*** | | ldapBaseGroups | ***REMOVED SENSITIVE VALUE*** | | ldapBaseUsers | ***REMOVED SENSITIVE VALUE*** | | ldapCacheTTL | 600 | | ldapConfigurationActive | 1 | | ldapDefaultPPolicyDN | | | ldapDynamicGroupMemberURL | | | ldapEmailAttribute | mail | | ldapExperiencedAdmin | 0 | | ldapExpertUUIDGroupAttr | | | ldapExpertUUIDUserAttr | | | ldapExpertUsernameAttr | | | ldapExtStorageHomeAttribute | | | ldapGidNumber | gidNumber | | ldapGroupDisplayName | cn | | ldapGroupFilter | | | ldapGroupFilterGroups | | | ldapGroupFilterMode | 0 | | ldapGroupFilterObjectclass | | | ldapGroupMemberAssocAttr | | | ldapHost | 10.0.0.12 | | ldapIgnoreNamingRules | | | ldapLoginFilter | (&(|(objectclass=inetOrgPerson))(|(uid=%uid)(|(mailPrimaryAddress=%uid)(mail=%uid)))) | | ldapLoginFilterAttributes | | | ldapLoginFilterEmail | 1 | | ldapLoginFilterMode | 0 | | ldapLoginFilterUsername | 1 | | ldapMatchingRuleInChainState | unknown | | ldapNestedGroups | 0 | | ldapOverrideMainServer | | | ldapPagingSize | 500 | | ldapPort | 389 | | ldapQuotaAttribute | | | ldapQuotaDefault | | | ldapTLS | 0 | | ldapUserAvatarRule | default | | ldapUserDisplayName | cn | | ldapUserDisplayName2 | | | ldapUserFilter | (|(objectclass=inetOrgPerson)) | | ldapUserFilterGroups | | | ldapUserFilterMode | 0 | | ldapUserFilterObjectclass | inetOrgPerson | | ldapUuidGroupAttribute | auto | | ldapUuidUserAttribute | auto | | turnOffCertCheck | 0 | | turnOnPasswordChange | 0 | | useMemberOfToDetectMembership | 1 | +--------
#### ocDownloader configuration: **Which downloader are you using:** Curl/Aria2 **Do you use a proxy:** No **Which protocols do you allow**: FTP/HTTP/Bittorrent/Youtube ### Client configuration **Browser:** Firefox 88.0.1 **Operating system:** Windows 10 ### Logs #### Web server error log
Web server error log ``` Insert your webserver log here ```
#### Nextcloud log (data/nextcloud.log)
Nextcloud log __":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"ocdownloader.Queue.Get"}]},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/ocdownloader/queue/get"]},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/nextcloud/apps/ocdownloader/controller/queue.php","Line":142},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0","version":"21.0.1.1"} {"reqId":"EC7NgrH5tdzNatcyukwG","level":3,"time":"2021-05-12T13:49:13+00:00","remoteAddr":"fe80::1442:7a9b:a6e3:43f","user":"384f52f8-69b6-103a-9bc5-a138b31cfe3f","app":"index","method":"POST","url":"/apps/ocdownloader/queue/get","message":{"Exception":"Exception","Message":"Call to a member function fetchRow() on bool","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"L10N":{"__class__":"OC\\L10N\\LazyL10N"},"__class__":"OCA\\ocDownloader\\Controller\\Queue"},"Get"]},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["QueueController","Get",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"ocdownloader.Queue.Get"}]},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/ocdownloader/queue/get"]},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","Line":159,"Previous":{"Exception":"Error","Message":"Call to a member function fetchRow() on bool","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"get","class":"OCA\\ocDownloader\\Controller\\Queue","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"L10N":{"__class__":"OC\\L10N\\LazyL10N"},"__class__":"OCA\\ocDownloader\\Controller\\Queue"},"Get"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"L10N":{"__class__":"OC\\L10N\\LazyL10N"},"__class__":"OCA\\ocDownloader\\Controller\\Queue"},"Get"]},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["QueueController","Get",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"ocdownloader.Queue.Get"}]},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/ocdownloader/queue/get"]},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/nextcloud/apps/ocdownloader/controller/queue.php","Line":142},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0","version":"21.0.1.1"} {"reqId":"1pWn7KLFw4hukpMePcC9","level":3,"time":"2021-05-12T14:01:08+00:00","remoteAddr":"fe80::1442:7a9b:a6e3:43f","user":"384f52f8-69b6-103a-9bc5-a138b31cfe3f","app":"PHP","method":"GET","url":"/settings/admin/additional","message":{"Exception":"Error","Message":"Undefined index: KEY at /var/www/nextcloud/apps/ocdownloader/settings/admin.php#28","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/ocdownloader/settings/admin.php","line":28,"function":"onError","class":"OC\\Log\\ErrorHandler","type":"::","args":[8,"Undefined index: KEY","/var/www/nextcloud/apps/ocdownloader/settings/admin.php",28,{"type":"admin","forms":[],"source":["ocdownloader/settings/admin.php"],"form":"ocdownloader/settings/admin.php","Tmpl":{"__class__":"OCP\\Template"},"0":"And 3 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_App.php","line":660,"args":["/var/www/nextcloud/apps/ocdownloader/settings/admin.php"],"function":"include"},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AdminSettingsController.php","line":95,"function":"getForms","class":"OC_App","type":"::","args":["admin"]},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AdminSettingsController.php","line":86,"function":"getLegacyForms","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":[]},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php","line":149,"function":"getSettings","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":["additional"]},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AdminSettingsController.php","line":68,"function":"getIndexResponse","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":["admin","additional"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"index","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":["additional"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AdminSettingsController"},"index"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AdminSettingsController"},"index"]},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AdminSettingsController","index",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"section":"additional","_route":"settings.AdminSettings.index"}]},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/admin/additional"]},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/nextcloud/lib/private/Log/ErrorHandler.php","Line":92,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0","version":"21.0.1.1"} {"reqId":"1pWn7KLFw4hukpMePcC9","level":3,"time":"2021-05-12T14:01:08+00:00","remoteAddr":"fe80::1442:7a9b:a6e3:43f","user":"384f52f8-69b6-103a-9bc5-a138b31cfe3f","app":"PHP","method":"GET","url":"/settings/admin/additional","message":{"Exception":"Error","Message":"Undefined index: VAL at /var/www/nextcloud/apps/ocdownloader/settings/admin.php#28","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/ocdownloader/settings/admin.php","line":28,"function":"onError","class":"OC\\Log\\ErrorHandler","type":"::","args":[8,"Undefined index: VAL","/var/www/nextcloud/apps/ocdownloader/settings/admin.php",28,{"type":"admin","forms":[],"source":["ocdownloader/settings/admin.php"],"form":"ocdownloader/settings/admin.php","Tmpl":{"__class__":"OCP\\Template"},"0":"And 3 more entries, set log level to debug to see all entries"}]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_App.php","line":660,"args":["/var/www/nextcloud/apps/ocdownloader/settings/admin.php"],"function":"include"},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AdminSettingsController.php","line":95,"function":"getForms","class":"OC_App","type":"::","args":["admin"]},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AdminSettingsController.php","line":86,"function":"getLegacyForms","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":[]},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php","line":149,"function":"getSettings","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":["additional"]},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AdminSettingsController.php","line":68,"function":"getIndexResponse","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":["admin","additional"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"index","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":["additional"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AdminSettingsController"},"index"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AdminSettingsController"},"index"]},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AdminSettingsController","index",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"section":"additional","_route":"settings.AdminSettings.index"}]},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/admin/additional"]},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/nextcloud/lib/private/Log/ErrorHandler.php","Line":92,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0","version":"21.0.1.1"}
#### Browser log
Browser log ``` Insert your browser log here, this could for example include: a) The javascript console log b) The network log c) ... ```
thrynir commented 3 years ago

Hi,

This is in fact related to issue #192

You forgot to apply the same change on /lib/Settings/Admin.php et /lib/Settings/Personal.php

Also probably somewhere else as I get this on the app page

image

neozerosv commented 2 years ago

Steps to reproduce

1. Install ocdownloader

2. got to apps/ocdownloader/add

Expected behaviour

Should load all elements

Actual behaviour

Show loading behind filename but don't load

Server configuration

Operating system: Debian 10

Web server: : nginx

Database: : postgresql

PHP version: 7.3

Nextcloud version: 21.0.1

Updated from an older Nextcloud/ownCloud or fresh install: fresh install

Where did you install Nextcloud from: https://download.nextcloud.com/server/releases/nextcloud-21.0.1.zip

Signing status: Signing status No errors have been found.

List of activated apps: App list

Nextcloud configuration: Config report

Are you using external storage, if yes which one (currently not supported by ocDownloader): local

Are you using encryption (currently not supported by ocDownloader): no

Are you using an external user-backend, if yes which one: LDAP

LDAP configuration (delete this part if not used)

LDAP config

ocDownloader configuration:

Which downloader are you using: Curl/Aria2

Do you use a proxy: No

Which protocols do you allow: FTP/HTTP/Bittorrent/Youtube

Client configuration

Browser: Firefox 88.0.1

Operating system: Windows 10

Logs

Web server error log

Web server error log

Nextcloud log (data/nextcloud.log)

Nextcloud log

Browser log

Browser log

Check this FIX that I found related to postgresql installs -->> https://github.com/e-alfred/ocdownloader/issues/162#issuecomment-1079599846