Error enabling MySQL for Wordpress

    • OMV 2.x
    • Resolved
    • Error enabling MySQL for Wordpress

      I have the wordpress plugin installed but when i try to enable the plugin and check the blog page i get a Error 404 page from Nginx. I have tried enabling the MySQL server to sort this i believe but anytime i do i get this error. A shared folder has been created and is not referenced by anything else.

      Error #2002:
      exception 'OMVException' with message 'Invalid method parameter: data.sharedfolderref does not exist, and it is not an optional property.' in /usr/share/php/openmediavault/rpcservice.inc:187
      Stack trace:
      #0 /usr/share/openmediavault/engined/rpc/mysql.inc(137): OMVRpcServiceAbstract->validateMethodParams(Array, '{\n ...')
      #1 [internal function]: OMVRpcServiceMySql->setSettings(Array, Array)
      #2 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
      #3 /usr/share/php/openmediavault/rpc.inc(79): OMVRpcServiceAbstract->callMethod('setSettings', Array, Array)
      #4 /usr/sbin/omv-engined(500): OMVRpc::exec('MySql', 'setSettings', Array, Array, 1)
      #5 {main}
    • Clear your browser cache. The new mysql plugin in the testing repo doesn't use shared folders anymore. If you upgraded, it will convert an existing install to a datadir option in extras option though.
      omv 5.0.14 usul | 64 bit | 5.0 proxmox kernel | omvextrasorg 5.1.4
      omv-extras.org plugins source code and issue tracker - github

      Please read this before posting a question and this and this for docker questions.
      Please don't PM for support... Too many PMs!
    • Is there a datadir line in extra options? If you upgraded, it will automatically add the line.
      omv 5.0.14 usul | 64 bit | 5.0 proxmox kernel | omvextrasorg 5.1.4
      omv-extras.org plugins source code and issue tracker - github

      Please read this before posting a question and this and this for docker questions.
      Please don't PM for support... Too many PMs!
    • I have problems with mysql too since 2.x.

      this one was because i switched omv extras test repo on

      mysql seems buggy when u have an existing installation

      versions are different mysql plugin 1.0.16 and in test its 2.x
      | HP N54L Tobi´ 00 BIOS@2013 | 8GB 1333 | 2x WD-Black 320GB md0 / in TopDock | AMCC 9650SE-4LPML hwraid 4 x 3TB WD Green RAID5 mit BBU |
      | SlimLine Bluray in the Top Dock | Powerwalker 650 USV | Edimax WLAN | IcyBox 2x2TB RAID1 via eSATA |
      | Storage at the moment : 12.58TB |
    • As long as the datadir line was added to extra options, it should work the same. Is that line there? What is buggy?
      omv 5.0.14 usul | 64 bit | 5.0 proxmox kernel | omvextrasorg 5.1.4
      omv-extras.org plugins source code and issue tracker - github

      Please read this before posting a question and this and this for docker questions.
      Please don't PM for support... Too many PMs!
    • With mysql 2.1 or newer plugin:

      Install mysql and wordpress plugins
      Enable mysql
      Save and Apply
      Set mysql root password

      Install database from wordpress plugin and then enable.
      Launch blog site to fill out setup information.

      If this doesn't work, I recommend purging mysql, the mysql user and group, remove /var/lib/mysql and /etc/mysql/. Then start with my instructions.
      omv 5.0.14 usul | 64 bit | 5.0 proxmox kernel | omvextrasorg 5.1.4
      omv-extras.org plugins source code and issue tracker - github

      Please read this before posting a question and this and this for docker questions.
      Please don't PM for support... Too many PMs!
    • Removed folder then followed your instructions I still get an error enabling mysql unfortunately.

      Error #3002:
      exception 'OMVException' with message 'Failed to set configuration' in /usr/share/openmediavault/engined/rpc/mysql.inc:155
      Stack trace:
      #0 [internal function]: OMVRpcServiceMySql->setSettings(Array, Array)
      #1 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
      #2 /usr/share/php/openmediavault/rpc.inc(79): OMVRpcServiceAbstract->callMethod('setSettings', Array, Array)
      #3 /usr/sbin/omv-engined(500): OMVRpc::exec('MySql', 'setSettings', Array, Array, 1)
      #4 {main}
    • Source Code

      1. ii openmediavault 2.1.6 all Open network attached storage solution
      2. ii openmediavault-backup 1.0.11 all backup plugin for OpenMediaVault.
      3. ii openmediavault-btsync 1.0.13 all BitTorrent Sync plugin for OpenMediaVault.
      4. ii openmediavault-extplorer 1.1 all OpenMediaVault eXtplorer plugin
      5. ii openmediavault-forkeddaapd 2.0 all OpenMediaVault forked-daapd (DAAP server) plugin
      6. ii openmediavault-keyring 0.3 all GnuPG archive keys of the OpenMediaVault archive
      7. ii openmediavault-links 1.5 all OpenMediaVault links plugin
      8. ii openmediavault-locate 1.0 all locate plugin for OpenMediaVault.
      9. ii openmediavault-lvm2 2.1 all OpenMediaVault Logical Volume Manager (LVM2) plugin
      10. ii openmediavault-minidlna 1.0.11 all OpenMediaVault miniDLNA (DLNA server) plugin
      11. ii openmediavault-mysql 2.1 all MySQL plugin for OpenMediaVault.
      12. ii openmediavault-nginx 2.0-2 all Nginx plugin for OpenMediaVault.
      13. ii openmediavault-nut 2.0 all OpenMediaVault Network UPS Tools (NUT) plugin
      14. ii openmediavault-omvextrasorg 1.32 all OMV-Extras.org Package Repositories for OpenMediaVault
      15. ii openmediavault-owncloud 2.0.3 all OpenMediaVault ownCloud plugin
      16. ii openmediavault-plexmediaserver 1.0.12 all OpenMediaVault Plex Media Server plugin
      17. ii openmediavault-remoteshare 1.1 all remote share plugin for OpenMediaVault.
      18. ii openmediavault-route 2.0 all OpenMediaVault IP routing table plugin
      19. ii openmediavault-rsnapshot 1.0.11 all OpenMediaVault rsnapshot backup plugin.
      20. ii openmediavault-syncthing 1.6 all Syncthing plugin for OpenMediaVault.
      21. ii openmediavault-usbbackup 2.1 all OpenMediaVault USB/eSATA backup plugin
      22. ii openmediavault-virtualbox 1.3 all VirtualBox plugin for OpenMediaVault.
      23. ii openmediavault-websites 1.2 all Web sites plugin for OpenMediaVault.
      24. ii openmediavault-wordpress 1.0.2 all OpenMediaVault Wordpress plugin
      Display All

      The post was edited 1 time, last by WastlJ ().

    • When removing the unusable Wordpress plugin i got.

      Source Code

      1. Failed to execute command 'export LANG=C; apt-get --yes --auto-remove --purge remove openmediavault-wordpress 2>&1': Reading package lists... Building dependency tree... Reading state information... The following packages will be REMOVED: dbconfig-common* mywebsql* openmediavault-mysql* openmediavault-wordpress* 0 upgraded, 0 newly installed, 4 to remove and 0 not upgraded. After this operation, 5651 kB disk space will be freed. (Reading database ... 52372 files and directories currently installed.) Removing openmediavault-wordpress ... Reloading nginx configuration: nginx. Purging configuration files for openmediavault-wordpress ... Removing openmediavault-mysql ... Reloading nginx configuration: nginx. Reloading PHP5 FastCGI Process Manager: php5-fpm . Purging configuration files for openmediavault-mysql ... Removing dbconfig-common ... Purging configuration files for dbconfig-common ... debconf: unable to initialize frontend: Dialog debconf: (TERM is not set, so the dialog frontend is not usable.) debconf: falling back to frontend: Readline debconf: unable to initialize frontend: Readline debconf: (This frontend requires a controlling tty.) debconf: falling back to frontend: Teletype Removing mywebsql ... Purging configuration files for mywebsql ... rm: cannot remove `/var/lib/mywebsql': No such file or directory dpkg: error processing mywebsql (--purge): subprocess installed post-removal script returned error exit status 1 Processing triggers for openmediavault ... Restarting engine daemon ... Processing triggers for man-db ... debconf: unable to initialize frontend: Dialog debconf: (TERM is not set, so the dialog frontend is not usable.) debconf: falling back to frontend: Readline debconf: unable to initialize frontend: Readline debconf: (This frontend requires a controlling tty.) debconf: falling back to frontend: Teletype Errors were encountered while processing: mywebsql Creating index of upgradeable packages ... Creating index of openmediavault plugins ... E: Sub-process /usr/bin/dpkg returned an error code (1
      2. Error #4000:
      3. exception 'OMVException' with message 'Failed to execute command 'export LANG=C; apt-get --yes --auto-remove --purge remove openmediavault-wordpress 2>&1': Reading package lists...
      4. Building dependency tree...
      5. Reading state information...
      6. The following packages will be REMOVED:
      7. dbconfig-common* mywebsql* openmediavault-mysql* openmediavault-wordpress*
      8. 0 upgraded, 0 newly installed, 4 to remove and 0 not upgraded.
      9. After this operation, 5651 kB disk space will be freed.
      10. (Reading database ...
      11. 52372 files and directories currently installed.)
      12. Removing openmediavault-wordpress ...
      13. Reloading nginx configuration:
      14. nginx.
      15. Purging configuration files for openmediavault-wordpress ...
      16. Removing openmediavault-mysql ...
      17. Reloading nginx configuration:
      18. nginx.
      19. Reloading PHP5 FastCGI Process Manager: php5-fpm
      20. .
      21. Purging configuration files for openmediavault-mysql ...
      22. Removing dbconfig-common ...
      23. Purging configuration files for dbconfig-common ...
      24. debconf: unable to initialize frontend: Dialog
      25. debconf: (TERM is not set, so the dialog frontend is not usable.)
      26. debconf: falling back to frontend: Readline
      27. debconf: unable to initialize frontend: Readline
      28. debconf: (This frontend requires a controlling tty.)
      29. debconf: falling back to frontend: Teletype
      30. Removing mywebsql ...
      31. Purging configuration files for mywebsql ...
      32. rm: cannot remove `/var/lib/mywebsql': No such file or directory
      33. dpkg: error processing mywebsql (--purge):
      34. subprocess installed post-removal script returned error exit status 1
      35. Processing triggers for openmediavault ...
      36. Restarting engine daemon ...
      37. Processing triggers for man-db ...
      38. debconf: unable to initialize frontend: Dialog
      39. debconf: (TERM is not set, so the dialog frontend is not usable.)
      40. debconf: falling back to frontend: Readline
      41. debconf: unable to initialize frontend: Readline
      42. debconf: (This frontend requires a controlling tty.)
      43. debconf: falling back to frontend: Teletype
      44. Errors were encountered while processing:
      45. mywebsql
      46. Creating index of upgradeable packages ...
      47. Creating index of openmediavault plugins ...
      48. E: Sub-process /usr/bin/dpkg returned an error code (1)' in /usr/share/openmediavault/engined/rpc/pluginmgmt.inc:170
      49. Stack trace:
      50. #0 [internal function]: OMVRpcServicePluginMgmt->remove(Array, Array)
      51. #1 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
      52. #2 /usr/share/php/openmediavault/rpc.inc(79): OMVRpcServiceAbstract->callMethod('remove', Array, Array)
      53. #3 /usr/sbin/omv-engined(500): OMVRpc::exec('Plugin', 'remove', Array, Array, 1)
      54. #4 {main}
      Display All

      The post was edited 1 time, last by WastlJ ().

    • Source Code

      1. mkdir /var/lib/mywebsql
      2. apt-get purge mywebsql


      then again
      dpkg -l | grep openmediavault


      AND: please use code boxes ;)
      OMV 4.x| HP Microserver | 256GB Samsung 830 SSD for system | 4x 2TB in a RAID5
      OMV 4.x| Odroid XU4 | 5TB Data drive | 500GB Backup drive
      OMV 5.x| Raspberry Pi 4 | 6TB Data drive | 500GB SSD drive