Also MySQL Problem with OMV 1.x

    • OMV 1.0
    • Resolved

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Also MySQL Problem with OMV 1.x

      Hello everybody i hope you can help me. :)

      I had updated OMV to the newest Version 1.x a few days ago. Since that i having problems with MySQL. First i tried reboot, first aid ala Windows ;D Next I tried to uninstall mysql and install it again. I found under OMV 1.x MySQL will not work some comands like apt-get remove --purge /*paketname*/. Removing was sucsessful, but I tried to install it over the webinterface again and get this error:


      Source Code

      1. Reading package lists...
      2. Building dependency tree...
      3. Reading state information...
      4. The following extra packages will be installed:
      5. libdbd-mysql-perl libmysqlclient18 mysql-client-5.5 mysql-common
      6. mysql-server mysql-server-5.5 mywebsql
      7. Suggested packages:
      8. libterm-readkey-perl tinyca
      9. Recommended packages:
      10. libhtml-template-perl
      11. The following NEW packages will be installed:
      12. libdbd-mysql-perl libmysqlclient18 mysql-client-5.5 mysql-common
      13. mysql-server mysql-server-5.5 mywebsql openmediavault-mysql
      14. 0 upgraded, 8 newly installed, 0 to remove and 0 not upgraded.
      15. Need to get 0 B/6412 kB of archives.
      16. After this operation, 79.1 MB of additional disk space will be used.
      17. WARNING: The following packages cannot be authenticated!
      18. mysql-common libmysqlclient18 libdbd-mysql-perl mysql-client-5.5
      19. mysql-server-5.5 mysql-server openmediavault-mysql mywebsql
      20. Preconfiguring packages ...
      21. Authentication warning overridden.
      22. Selecting previously unselected package mysql-common.
      23. (Reading database ... 78980 files and directories currently installed.)
      24. Unpacking mysql-common (from .../mysql-common_5.5.38-0+wheezy1_all.deb) ...
      25. Selecting previously unselected package libmysqlclient18:amd64.
      26. Unpacking libmysqlclient18:amd64 (from .../libmysqlclient18_5.5.38-0+wheezy1_amd64.deb) ...
      27. Selecting previously unselected package libdbd-mysql-perl.
      28. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1+b1_amd64.deb) ...
      29. Selecting previously unselected package mysql-client-5.5.
      30. Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.38-0+wheezy1_amd64.deb) ...
      31. Setting up mysql-common (5.5.38-0+wheezy1) ...
      32. Selecting previously unselected package mysql-server-5.5.
      33. (Reading database ... 79080 files and directories currently installed.)
      34. Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.38-0+wheezy1_amd64.deb) ...
      35. Selecting previously unselected package mysql-server.
      36. Unpacking mysql-server (from .../mysql-server_5.5.38-0+wheezy1_all.deb) ...
      37. Selecting previously unselected package openmediavault-mysql.
      38. Unpacking openmediavault-mysql (from .../openmediavault-mysql_1.0.10_all.deb) ...
      39. Selecting previously unselected package mywebsql.
      40. Unpacking mywebsql (from .../mywebsql_3.4-omv1_all.deb) ...
      41. Processing triggers for openmediavault ...
      42. Restarting engine daemon ...
      43. Setting up libmysqlclient18:amd64 (5.5.38-0+wheezy1) ...
      44. Setting up libdbd-mysql-perl (4.021-1+b1) ...
      45. Setting up mysql-client-5.5 (5.5.38-0+wheezy1) ...
      46. Setting up mysql-server-5.5 (5.5.38-0+wheezy1) ...
      47. Stopping MySQL database server: mysqld.
      48. insserv: warning: script 'K02var_log' missing LSB tags and overrides
      49. insserv: warning: script 'var_log' missing LSB tags and overrides
      50. Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
      51. invoke-rc.d: initscript mysql, action "start" failed.
      52. dpkg: error processing mysql-server-5.5 (--configure):
      53. subprocess installed post-installation script returned error exit status 1
      54. dpkg: dependency problems prevent configuration of mysql-server:
      55. mysql-server depends on mysql-server-5.5; however:
      56. Package mysql-server-5.5 is not configured yet.
      57. dpkg: error processing mysql-server (--configure):
      58. dependency problems - leaving unconfigured
      59. dpkg: dependency problems prevent configuration of openmediavault-mysql:
      60. openmediavault-mysql depends on mysql-server; however:
      61. Package mysql-server is not configured yet.
      62. dpkg: error processing openmediavault-mysql (--configure):
      63. dependency problems - leaving unconfigured
      64. dpkg: dependency problems prevent configuration of mywebsql:
      65. mywebsql depends on openmediavault-mysql (>= 1.0.5); however:
      66. Package openmediavault-mysql is not configured yet.
      67. dpkg: error processing mywebsql (--configure):
      68. dependency problems - leaving unconfigured
      69. Errors were encountered while processing:
      70. mysql-server-5.5
      71. mysql-server
      72. openmediavault-mysql
      73. mywebsql
      Display All


      everything is up-to-date (apt-get update etc.)

      Hopefully you can help me. I cant find any Logfiles... :/

      Best Regards
      Eddy

      P.S. Sorry about my bad English...

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

    • Since it is already fragged...

      dpkg -l | grep mysql

      write down all the packages that are installed from the list.
      purge the plugin if it is install: apt-get --purge remove openmediavault-mysql
      remove all the packages from the list
      reinstall all the packages from the list
      then reinstall the plugin and enable.

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

    • hello,

      i'm on OMV 10.0.21 (fresh install), I made everything what you say above, and now I'm not able to install MySQL 10.0.10 plugin.
      i'm stuck on:

      Source Code

      1. Reading package lists...
      2. Building dependency tree...


      thanks for you support.
      The Power of the Power Button!
      OMV 2.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for system
    • also, after removing all the packages from the list, these packages are still on the server.


      Source Code

      1. root@HPNAS:~# apt-get --purge remove openmediavault-mysql
      2. Reading package lists... Done
      3. Building dependency tree
      4. Reading state information... Done
      5. Package 'openmediavault-mysql' is not installed, so not removed
      6. You might want to run 'apt-get -f install' to correct these:
      7. The following packages have unmet dependencies:
      8. mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
      9. E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
      10. root@HPNAS:~# apt-get --purge remove libmysqlclient18:amd64
      11. Reading package lists... Done
      12. Building dependency tree
      13. Reading state information... Done
      14. You might want to run 'apt-get -f install' to correct these:
      15. The following packages have unmet dependencies:
      16. mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
      17. E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
      18. root@HPNAS:~# apt-get --purge remove mysql-common
      19. Reading package lists... Done
      20. Building dependency tree
      21. Reading state information... Done
      22. You might want to run 'apt-get -f install' to correct these:
      23. The following packages have unmet dependencies:
      24. libmysqlclient18 : Depends: mysql-common (>= 5.5.38-0+wheezy1) but it is not going to be installed
      25. mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
      26. PreDepends: mysql-common (>= 5.5.38-0+wheezy1) but it is not going to be installed
      27. E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
      28. root@HPNAS:~# apt-get --purge remove mysql-server-5.5
      29. Reading package lists... Done
      30. Building dependency tree
      31. Reading state information... Done
      32. The following packages were automatically installed and are no longer required:
      33. dbconfig-common libaio1 libdbi-perl mysql-server-core-5.5 php5-mysqlnd
      34. Use 'apt-get autoremove' to remove them.
      35. The following packages will be REMOVED:
      36. mysql-server-5.5*
      37. 0 upgraded, 0 newly installed, 1 to remove and 1 not upgraded.
      38. 1 not fully installed or removed.
      39. After this operation, 32.7 MB disk space will be freed.
      40. Do you want to continue [Y/n]? y
      41. (Reading database ... 27723 files and directories currently installed.)
      42. Removing mysql-server-5.5 ...
      43. Stopping MySQL database server: mysqld failed!
      44. invoke-rc.d: initscript mysql, action "stop" failed.
      45. dpkg: error processing mysql-server-5.5 (--purge):
      46. subprocess installed pre-removal script returned error exit status 1
      47. Stopping MySQL database server: mysqld failed!
      48. invoke-rc.d: initscript mysql, action "stop" failed.
      49. Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
      50. invoke-rc.d: initscript mysql, action "start" failed.
      51. dpkg: error while cleaning up:
      52. subprocess installed post-installation script returned error exit status 1
      53. Errors were encountered while processing:
      54. mysql-server-5.5
      55. Creating index of upgradeable packages ...
      56. Creating index of OpenMediaVault plugins ...
      57. E: Sub-process /usr/bin/dpkg returned an error code (1)
      58. root@HPNAS:~# apt-get --purge remove mysql-server-core-5.5
      59. Reading package lists... Done
      60. Building dependency tree
      61. Reading state information... Done
      62. You might want to run 'apt-get -f install' to correct these:
      63. The following packages have unmet dependencies:
      64. mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
      65. Depends: mysql-server-core-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
      66. E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
      67. root@HPNAS:~# apt-get --purge remove php5-mysqlnd
      68. Reading package lists... Done
      69. Building dependency tree
      70. Reading state information... Done
      71. You might want to run 'apt-get -f install' to correct these:
      72. The following packages have unmet dependencies:
      73. mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
      74. E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
      75. root@HPNAS:~# dpkg -l | grep mysql
      76. ii libmysqlclient18:amd64 5.5.38-0+wheezy1 amd64 MySQL database client library
      77. ii mysql-common 5.5.38-0+wheezy1 all MySQL database common files, e.g. /etc/mysql/my.cnf
      78. pF mysql-server-5.5 5.5.38-0+wheezy1 amd64 MySQL database server binaries and system database setup
      79. ii mysql-server-core-5.5 5.5.38-0+wheezy1 amd64 MySQL database server binaries
      80. ii php5-mysqlnd 5.4.4-14+deb7u14 amd64 MySQL module for php5 (Native Driver)
      81. root@HPNAS:~#
      Display All


      thanks.
      The Power of the Power Button!
      OMV 2.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for system
    • also, if I change the Bind Address I received:

      Source Code

      1. Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' stop 2>&1': Stopping MySQL database server: mysqld failed!
      2. invoke-rc.d: initscript mysql, action "stop" failed.
      3. Error
      4. #4000:
      5. exception 'OMVException' with message 'Failed to execute command 'export
      6. LANG=C; invoke-rc.d 'mysql' stop 2>&1': Stopping MySQL database
      7. server: mysqld failed!
      8. invoke-rc.d: initscript mysql, action "stop" failed.' in
      9. /usr/share/php/openmediavault/initscript.inc:176
      10. Stack trace:
      11. #0 /usr/share/php/openmediavault/initscript.inc(148):
      12. OMVSysVInitScript->invoke('stop')
      13. #1 /usr/share/php/openmediavault/initscript.inc(53):
      14. OMVSysVInitScript->stop()
      15. #2 /usr/share/openmediavault/engined/module/mysql.inc(126):
      16. OMVSysVInitScript->exec()
      17. #3 /usr/share/openmediavault/engined/rpc/config.inc(164):
      18. OMVModuleMySQL->stopService()
      19. #4 [internal function]: OMVRpcServiceConfig->applyChanges(Array,
      20. Array)
      21. #5 /usr/share/php/openmediavault/rpcservice.inc(125):
      22. call_user_func_array(Array, Array)
      23. #6 /usr/share/php/openmediavault/rpcservice.inc(158):
      24. OMVRpcServiceAbstract->callMethod('applyChanges', Array, Array)
      25. #7 /usr/share/openmediavault/engined/rpc/config.inc(224):
      26. OMVRpcServiceAbstract->callMethodBg('applyChanges', Array, Array)
      27. #8 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array,
      28. Array)
      29. #9 /usr/share/php/openmediavault/rpcservice.inc(125):
      30. call_user_func_array(Array, Array)
      31. #10 /usr/share/php/openmediavault/rpc.inc(79):
      32. OMVRpcServiceAbstract->callMethod('applyChangesBg', Array, Array)
      33. #11 /usr/sbin/omv-engined(501): OMVRpc::exec('Config', 'applyChangesBg',
      34. Array, Array, 1)
      35. #12 {main}
      Display All

      Source Code

      1. root@HPNAS:~# service mysql status
      2. /usr/bin/mysqladmin: connect to server at 'localhost' failed
      3. error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
      4. .
      5. root@HPN

      and I don't know what to do.
      The Power of the Power Button!
      OMV 2.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for system

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

    • still not working :/

      Hi tekkb thanks for answering

      i have tried your workaround but it dont works...

      after unistall all packages, I have reinstalled everything again

      Display Spoiler


      root@omv-homeserver:~# dpkg -l | grep mysql
      ii libdbd-mysql-perl 4.021-1+b1 amd64 Perl5 database interface to the MySQL database
      ii libmysqlclient18:amd64 5.5.38-0+wheezy1 amd64 MySQL database client library
      ii mysql-common 5.5.38-0+wheezy1 all MySQL database common files, e.g. /etc/mysql/my.cnf
      ii mysql-server-core-5.5 5.5.38-0+wheezy1 amd64 MySQL database server binaries
      ii php5-mysqlnd 5.4.4-14+deb7u14 amd64 MySQL module for php5 (Native Driver)
      root@omv-homeserver:~# apt-get insall mysql-server-5.5
      E: Ungültige Operation insall
      root@omv-homeserver:~# apt-get install mysql-server-5.5
      Paketlisten werden gelesen... Fertig
      Abhängigkeitsbaum wird aufgebaut.
      Statusinformationen werden eingelesen.... Fertig
      Die folgenden zusätzlichen Pakete werden installiert:
      mysql-client-5.5
      Vorgeschlagene Pakete:
      libterm-readkey-perl tinyca
      Empfohlene Pakete:
      libhtml-template-perl
      Die folgenden NEUEN Pakete werden installiert:
      mysql-client-5.5 mysql-server-5.5
      0 aktualisiert, 2 neu installiert, 0 zu entfernen und 1 nicht aktualisiert.
      Es müssen noch 0 B von 3.984 kB an Archiven heruntergeladen werden.
      Nach dieser Operation werden 70,2 MB Plattenplatz zusätzlich benutzt.
      Möchten Sie fortfahren [J/n]? J
      Vorkonfiguration der Pakete ...
      #Vormals nicht ausgewähltes Paket mysql-client-5.5 wird gewählt.
      (Lese Datenbank ... 79025 Dateien und Verzeichnisse sind derzeit installiert.)
      Entpacken von mysql-client-5.5 (aus .../mysql-client-5.5_5.5.38-0+wheezy1_amd64.deb) ...
      Vormals nicht ausgewähltes Paket mysql-server-5.5 wird gewählt.
      Entpacken von mysql-server-5.5 (aus .../mysql-server-5.5_5.5.38-0+wheezy1_amd64.deb) ...
      mysql-client-5.5 (5.5.38-0+wheezy1) wird eingerichtet ...
      mysql-server-5.5 (5.5.38-0+wheezy1) wird eingerichtet ...
      Stopping MySQL database server: mysqld.
      140918 21:20:24 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
      140918 21:20:24 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
      140918 21:20:24 [Note] Plugin 'FEDERATED' is disabled.
      140918 21:20:24 InnoDB: The InnoDB memory heap is disabled
      140918 21:20:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
      140918 21:20:24 InnoDB: Compressed tables use zlib 1.2.7
      140918 21:20:24 InnoDB: Using Linux native AIO
      140918 21:20:24 InnoDB: Initializing buffer pool, size = 128.0M
      140918 21:20:24 InnoDB: Completed initialization of buffer pool
      140918 21:20:24 InnoDB: highest supported file format is Barracuda.
      140918 21:20:24 InnoDB: Waiting for the background threads to start
      140918 21:20:25 InnoDB: 5.5.38 started; log sequence number 1595675
      140918 21:20:25 InnoDB: Starting shutdown...
      140918 21:20:26 InnoDB: Shutdown completed; log sequence number 1595675
      insserv: warning: script 'K02var_log' missing LSB tags and overrides
      insserv: warning: script 'var_log' missing LSB tags and overrides
      Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
      invoke-rc.d: initscript mysql, action "start" failed.
      dpkg: Fehler beim Bearbeiten von mysql-server-5.5 (--configure):
      Unterprozess installiertes post-installation-Skript gab den Fehlerwert 1 zurück
      Fehler traten auf beim Bearbeiten von:
      mysql-server-5.5
      Creating index of upgradeable packages ...
      Creating index of OpenMediaVault plugins ...
      E: Sub-process /usr/bin/dpkg returned an error code (1)



      then I go to the Webinterface and tried to install the Plugin...

      Display Spoiler


      Reading package lists...
      Building dependency tree...
      Reading state information...
      The following extra packages will be installed:
      mysql-server mywebsql
      The following NEW packages will be installed:
      mysql-server mywebsql openmediavault-mysql
      0 upgraded, 3 newly installed, 0 to remove and 1 not upgraded.
      1 not fully installed or removed.
      Need to get 0 B/1543 kB of archives.
      After this operation, 4838 kB of additional disk space will be used.
      WARNING: The following packages cannot be authenticated!
      mysql-server openmediavault-mysql mywebsql
      Authentication warning overridden.
      Selecting previously unselected package mysql-server.
      (Reading database ... 79164 files and directories currently installed.)
      Unpacking mysql-server (from .../mysql-server_5.5.38-0+wheezy1_all.deb) ...
      Selecting previously unselected package openmediavault-mysql.
      Unpacking openmediavault-mysql (from .../openmediavault-mysql_1.0.10_all.deb) ...
      Selecting previously unselected package mywebsql.
      Unpacking mywebsql (from .../mywebsql_3.4-omv1_all.deb) ...
      Processing triggers for openmediavault ...
      Restarting engine daemon ...
      Setting up mysql-server-5.5 (5.5.38-0+wheezy1) ...
      Stopping MySQL database server: mysqld.
      insserv: warning: script 'K02var_log' missing LSB tags and overrides
      insserv: warning: script 'var_log' missing LSB tags and overrides
      Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
      invoke-rc.d: initscript mysql, action "start" failed.
      dpkg: error processing mysql-server-5.5 (--configure):
      subprocess installed post-installation script returned error exit status 1
      dpkg: dependency problems prevent configuration of mysql-server:
      mysql-server depends on mysql-server-5.5; however:
      Package mysql-server-5.5 is not configured yet.

      dpkg: error processing mysql-server (--configure):
      dependency problems - leaving unconfigured
      dpkg: dependency problems prevent configuration of openmediavault-mysql:
      openmediavault-mysql depends on mysql-server; however:
      Package mysql-server is not configured yet.

      dpkg: error processing openmediavault-mysql (--configure):
      dependency problems - leaving unconfigured
      dpkg: dependency problems prevent configuration of mywebsql:
      mywebsql depends on openmediavault-mysql (>= 1.0.5); however:
      Package openmediavault-mysql is not configured yet.

      dpkg: error processing mywebsql (--configure):
      dependency problems - leaving unconfigured
      Errors were encountered while processing:
      mysql-server-5.5
      mysql-server
      openmediavault-mysql
      mywebsql
      Creating index of upgradeable packages ...
      Creating index of OpenMediaVault plugins ...




      and now if you go to "Services" and MySQL you got this Error:

      Source Code

      1. Error #3003:
      2. exception 'OMVException' with message 'Failed to get configuration (xpath=//services/mysql)' in /usr/share/openmediavault/engined/rpc/mysql.inc:68
      3. Stack trace:
      4. #0 [internal function]: OMVRpcServiceMySQL->getSettings(NULL, Array)
      5. #1 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
      6. #2 /usr/share/php/openmediavault/rpc.inc(79): OMVRpcServiceAbstract->callMethod('getSettings', NULL, Array)
      7. #3 /usr/sbin/omv-engined(501): OMVRpc::exec('MySql', 'getSettings', NULL, Array, 1)
      8. #4 {main}



      I need a MySQL-Server... pls help me! ;)


      Big Thanks and best regards!
      Eddy
    • No, the same access denied....

      Source Code

      1. root@HPNAS:~# mysql -u root -p
      2. Enter password:
      3. Welcome to the MySQL monitor. Commands end with ; or \g.
      4. Your MySQL connection id is 32
      5. Server version: 5.5.38-0+wheezy1 (Debian)
      6. Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
      7. Oracle is a registered trademark of Oracle Corporation and/or its
      8. affiliates. Other names may be trademarks of their respective
      9. owners.
      10. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
      11. mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '****************'
      12. -> ^CCtrl-C -- exit!
      13. Aborted
      14. root@HPNAS:~# service mysql status
      15. /usr/bin/mysqladmin: connect to server at 'localhost' failed
      16. error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
      17. .
      Display All


      and the same error

      Source Code

      1. Error
      2. #4000:
      3. exception 'OMVException' with message 'Failed to execute command 'export
      4. LANG=C; invoke-rc.d 'mysql' stop 2>&1': Stopping MySQL database
      5. server: mysqld failed!
      6. invoke-rc.d: initscript mysql, action "stop" failed.' in
      7. /usr/share/php/openmediavault/initscript.inc:176
      8. Stack trace:
      9. #0 /usr/share/php/openmediavault/initscript.inc(148):
      10. OMVSysVInitScript->invoke('stop')
      11. #1 /usr/share/php/openmediavault/initscript.inc(53):
      12. OMVSysVInitScript->stop()
      13. #2 /usr/share/openmediavault/engined/module/mysql.inc(126):
      14. OMVSysVInitScript->exec()
      15. #3 /usr/share/openmediavault/engined/rpc/config.inc(164):
      16. OMVModuleMySQL->stopService()
      17. #4 [internal function]: OMVRpcServiceConfig->applyChanges(Array,
      18. Array)
      19. #5 /usr/share/php/openmediavault/rpcservice.inc(125):
      20. call_user_func_array(Array, Array)
      21. #6 /usr/share/php/openmediavault/rpcservice.inc(158):
      22. OMVRpcServiceAbstract->callMethod('applyChanges', Array, Array)
      23. #7 /usr/share/openmediavault/engined/rpc/config.inc(224):
      24. OMVRpcServiceAbstract->callMethodBg('applyChanges', Array, Array)
      25. #8 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array,
      26. Array)
      27. #9 /usr/share/php/openmediavault/rpcservice.inc(125):
      28. call_user_func_array(Array, Array)
      29. #10 /usr/share/php/openmediavault/rpc.inc(79):
      30. OMVRpcServiceAbstract->callMethod('applyChangesBg', Array, Array)
      31. #11 /usr/sbin/omv-engined(501): OMVRpc::exec('Config', 'applyChangesBg',
      32. Array, Array, 1)
      33. #12 {main}
      Display All


      other idea?
      The Power of the Power Button!
      OMV 2.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for system

      The post was edited 2 times, last by HK-47: Remove password. ().

    • hunt3rus wrote:

      No, the same access denied....

      Source Code

      1. * snip *


      and the same error

      Source Code

      1. * snip *


      other idea?

      Hm.. That usually works for the "Access denied for user 'debian-sys-maint'@'localhost'" issue. Maybe there's not even any debian-sys-maint user? You could try checking by logging in to MySQL and running SELECT User FROM mysql.user;. Otherwise I would suggest searching for "Access denied for user 'debian-sys-maint'@'localhost'" on the search engine of your choice. :) Hope this helps!

      Also, I removed the password from your post. Try to avoid posting them in the future for your own good.
    • I did:

      Source Code

      1. root@HPNAS:~# cat /etc/mysql/debian.cnf
      2. # Automatically generated for Debian scripts. DO NOT TOUCH!
      3. [client]
      4. host = localhost
      5. user = debian-sys-maint
      6. password = *************************
      7. socket = /var/run/mysqld/mysqld.sock
      8. [mysql_upgrade]
      9. host = localhost
      10. user = debian-sys-maint
      11. password = ******************************
      12. socket = /var/run/mysqld/mysqld.sock
      13. basedir = /usr
      14. root@HPNAS:~# [b]mysql -u root -p[/b]
      15. Enter password:
      16. Welcome to the MySQL monitor. Commands end with ; or \g.
      17. Your MySQL connection id is 199
      18. Server version: 5.5.38-0+wheezy1 (Debian)
      19. Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
      20. Oracle is a registered trademark of Oracle Corporation and/or its
      21. affiliates. Other names may be trademarks of their respective
      22. owners.
      23. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
      24. mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '<********************>'
      25. -> \q
      26. Bye
      27. root@HPNAS:~# service mysql status
      28. /usr/bin/mysqladmin: connect to server at 'localhost' failed
      29. error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
      30. .
      Display All


      is something wrong in my typo?

      thanks.
      The Power of the Power Button!
      OMV 2.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for system
    • what I don't understand is that I can uninstall/install the MySQL plugin, but if I change something on web interface everything goes wrong with this plugin.
      The Power of the Power Button!
      OMV 2.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for system
    • I used:

      Source Code

      1. apt-get --purge remove libmysqlclient18:amd64
      2. apt-get --purge remove mysql-client-5.5
      3. apt-get --purge remove mysql-common
      4. apt-get --purge remove mysql-server
      5. apt-get --purge remove mysql-server-5.5
      6. apt-get --purge remove mysql-server-core-5.5
      7. apt-get --purge remove php5-mysqlnd


      --------------------------------------
      guys, you are so dedicated.... it is incredible...
      The Power of the Power Button!
      OMV 2.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for system

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