Also MySQL Problem with OMV 1.x

Eddy · Sep 17th 2014

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:

Code

Reading package lists...
Building dependency tree...
Reading state information...
The following extra packages will be installed:
  libdbd-mysql-perl libmysqlclient18 mysql-client-5.5 mysql-common
  mysql-server mysql-server-5.5 mywebsql
Suggested packages:
  libterm-readkey-perl tinyca
Recommended packages:
  libhtml-template-perl
The following NEW packages will be installed:
  libdbd-mysql-perl libmysqlclient18 mysql-client-5.5 mysql-common
  mysql-server mysql-server-5.5 mywebsql openmediavault-mysql
0 upgraded, 8 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/6412 kB of archives.
After this operation, 79.1 MB of additional disk space will be used.
WARNING: The following packages cannot be authenticated!
  mysql-common libmysqlclient18 libdbd-mysql-perl mysql-client-5.5
  mysql-server-5.5 mysql-server openmediavault-mysql mywebsql
Preconfiguring packages ...
Authentication warning overridden.
Selecting previously unselected package mysql-common.
(Reading database ... 78980 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.5.38-0+wheezy1_all.deb) ...
Selecting previously unselected package libmysqlclient18:amd64.
Unpacking libmysqlclient18:amd64 (from .../libmysqlclient18_5.5.38-0+wheezy1_amd64.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1+b1_amd64.deb) ...
Selecting previously unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.38-0+wheezy1_amd64.deb) ...
Setting up mysql-common (5.5.38-0+wheezy1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 79080 files and directories currently installed.)
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.38-0+wheezy1_amd64.deb) ...
Selecting previously unselected package mysql-server.
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 libmysqlclient18:amd64 (5.5.38-0+wheezy1) ...
Setting up libdbd-mysql-perl (4.021-1+b1) ...
Setting up mysql-client-5.5 (5.5.38-0+wheezy1) ...
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

Display More

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...

tekkb · Sep 18th 2014

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.

hunt3rus · Sep 18th 2014

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:

Code

Reading package lists...
Building dependency tree...

thanks for you support.

tekkb · Sep 18th 2014

Give me output of this:

dpkg -l | grep mysql

hunt3rus · Sep 18th 2014

also, after removing all the packages from the list, these packages are still on the server.

Code

root@HPNAS:~# apt-get --purge remove openmediavault-mysql
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package 'openmediavault-mysql' is not installed, so not removed
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@HPNAS:~# apt-get --purge remove libmysqlclient18:amd64
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@HPNAS:~# apt-get --purge remove mysql-common
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 libmysqlclient18 : Depends: mysql-common (>= 5.5.38-0+wheezy1) but it is not going to be installed
 mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
                    PreDepends: mysql-common (>= 5.5.38-0+wheezy1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@HPNAS:~# apt-get --purge remove mysql-server-5.5
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
  dbconfig-common libaio1 libdbi-perl mysql-server-core-5.5 php5-mysqlnd
Use 'apt-get autoremove' to remove them.
The following packages will be REMOVED:
  mysql-server-5.5*
0 upgraded, 0 newly installed, 1 to remove and 1 not upgraded.
1 not fully installed or removed.
After this operation, 32.7 MB disk space will be freed.
Do you want to continue [Y/n]? y
(Reading database ... 27723 files and directories currently installed.)
Removing mysql-server-5.5 ...
Stopping MySQL database server: mysqld failed!
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg: error processing mysql-server-5.5 (--purge):
 subprocess installed pre-removal script returned error exit status 1
Stopping MySQL database server: mysqld failed!
invoke-rc.d: initscript mysql, action "stop" failed.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error while cleaning up:
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 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)
root@HPNAS:~# apt-get --purge remove mysql-server-core-5.5
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
                    Depends: mysql-server-core-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@HPNAS:~# apt-get --purge remove php5-mysqlnd
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.38-0+wheezy1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@HPNAS:~# dpkg -l | grep mysql
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
pF  mysql-server-5.5                   5.5.38-0+wheezy1              amd64        MySQL database server binaries and system database setup
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@HPNAS:~#

Display More

thanks.

tekkb · Sep 18th 2014

Give me a bit....

Do this:

apt-get -f install

Then try to install plugin.

hunt3rus · Sep 18th 2014

It's OK, I was able to install the MySQL plugin.

thanks again, your support is awesome.

can I reuse the old database location?

hunt3rus · Sep 18th 2014

also, if I change the Bind Address I received:

Code

Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' stop 2>&1': Stopping MySQL database server: mysqld failed!
invoke-rc.d: initscript mysql, action "stop" failed.


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

Display More

Code

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

and I don't know what to do.

tekkb · Sep 18th 2014

I have work to do. I may not be able to look at this til the evening. Aaron might help you in the mean time.

hunt3rus · Sep 18th 2014

no problem. I can wait.
even so, your support is great for OMV community.

HK-47 · Sep 18th 2014

I've had this problem in the past so try something like this.

hunt3rus · Sep 18th 2014

thanks HK, I will try tonight when I will be home

i will send you feedback....

Eddy · Sep 18th 2014

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:

Code

Error #3003:
exception 'OMVException' with message 'Failed to get configuration (xpath=//services/mysql)' in /usr/share/openmediavault/engined/rpc/mysql.inc:68
Stack trace:
#0 [internal function]: OMVRpcServiceMySQL->getSettings(NULL, 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('getSettings', NULL, Array)
#3 /usr/sbin/omv-engined(501): OMVRpc::exec('MySql', 'getSettings', NULL, Array, 1)
#4 {main}

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

Big Thanks and best regards!
Eddy

hunt3rus · Sep 18th 2014

No, the same access denied....

Code

root@HPNAS:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 32
Server version: 5.5.38-0+wheezy1 (Debian)


Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '****************'
    -> ^CCtrl-C -- exit!
Aborted
root@HPNAS:~# service mysql status
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
.

Display More

and the same error

Code

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

Display More

other idea?

HK-47 · Sep 18th 2014

Quote from hunt3rus
No, the same access denied....
Code
* snip *
and the same error
Code
* 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.

tekkb · Sep 19th 2014

I think hunt3rus must have had a typo. I would do the cat command again to get the password and retry those instructions again.

hunt3rus · Sep 19th 2014

I did:

Code

root@HPNAS:~# cat /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = *************************
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = ******************************
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr
root@HPNAS:~# [b]mysql -u root -p[/b]
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 199
Server version: 5.5.38-0+wheezy1 (Debian)


Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '<********************>'
    -> \q
Bye
root@HPNAS:~# service mysql status
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
.

Display More

is something wrong in my typo?

thanks.

hunt3rus · Sep 19th 2014

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.

tekkb · Sep 19th 2014

I'm still in bed. I will look at later today. When you removed all the packages did you just remove or purge???

hunt3rus · Sep 19th 2014

I used:

Code

apt-get --purge remove libmysqlclient18:amd64
apt-get --purge remove mysql-client-5.5
apt-get --purge remove mysql-common
apt-get --purge remove mysql-server
apt-get --purge remove mysql-server-5.5
apt-get --purge remove mysql-server-core-5.5
apt-get --purge remove php5-mysqlnd

--------------------------------------
guys, you are so dedicated.... it is incredible...

Also MySQL Problem with OMV 1.x

Participate now!

Tags