It is logging into the service. I don't all users have to be correct for service to run.
So it is working????
It is logging into the service. I don't all users have to be correct for service to run.
So it is working????
NO, for all changes made in web interface I will received:
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
and also I can't access SQL management site
Sub, what about deleting this user and recreating??? If it is deleted should not mysql start?
sorry, which user?
Sub is watching he knows. Or is it required in init script???
in Services TAB, I CAN SEE MySQL running!!!!
Yeah exactly, debian-sys-maint is used for the init scripts.
Did you try GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '***********'; again by the way?
If I recall correctly I had an issue with MySQL not being able to stop either, and that was because of debian-sys-maint. So you first have to run that command and then kill the process(?) or restart the server. Don't really remember sadly.
I never had this problem.
@HK
huray, now it works!
root@HPNAS:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 230
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 'xxxxxxxxxxxxxxxxxxx';
Query OK, 0 rows affected (0.00 sec)
mysql> \q
Bye
root@HPNAS:~# service mysql status
/usr/bin/mysqladmin Ver 8.42 Distrib 5.5.38, for debian-linux-gnu on x86_64
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.
Server version 5.5.38-0+wheezy1
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 14 hours 16 min 47 sec
Threads: 1 Questions: 558 Slow queries: 0 Opens: 287 Flush tables: 1 Open tables: 74 Queries per second avg: 0.010
Alles anzeigen
guys, thank you very much
also, the SQL Management site works now!!!!
again, many thanks
Good...
Hi hunt3rus,
i did your 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
here the Output:
login as: root
root@192.168.178.22's password:
Linux omv-homeserver 3.2.0-4-amd64 #1 SMP Debian 3.2.60-1+deb7u3 x86_64
The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.
Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Thu Sep 18 21:14:07 2014 from eddy-desktop.fritz.box
root@omv-homeserver:~# apt-get --purge remove libmysqlclient18:amd64
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen.... Fertig
Die folgenden Pakete werden ENTFERNT:
libdbd-mysql-perl* libmysqlclient18* mysql-client-5.5* mysql-server*
mysql-server-5.5* mywebsql* openmediavault-mysql*
0 aktualisiert, 0 neu installiert, 7 zu entfernen und 1 nicht aktualisiert.
4 nicht vollständig installiert oder entfernt.
Nach dieser Operation werden 78,9 MB Plattenplatz freigegeben.
Möchten Sie fortfahren [J/n]? J
(Lese Datenbank ... 79826 Dateien und Verzeichnisse sind derzeit installiert.)
Entfernen von openmediavault-mysql ...
Reloading nginx configuration: nginx.
Reloading PHP5 FastCGI Process Manager: php5-fpm.
Löschen der Konfigurationsdateien von openmediavault-mysql ...
Entfernen von mywebsql ...
Löschen der Konfigurationsdateien von mywebsql ...
Entfernen von mysql-server ...
Entfernen von mysql-server-5.5 ...
Stopping MySQL database server: mysqld.
Löschen der Konfigurationsdateien von mysql-server-5.5 ...
Entfernen von mysql-client-5.5 ...
Entfernen von libdbd-mysql-perl ...
Entfernen von libmysqlclient18:amd64 ...
Löschen der Konfigurationsdateien von libmysqlclient18:amd64 ...
Trigger für openmediavault werden verarbeitet ...
Restarting engine daemon ...
Creating index of upgradeable packages ...
Creating index of OpenMediaVault plugins ...
root@omv-homeserver:~# apt-get --purge remove mysql-client-5.5
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen.... Fertig
Paket »mysql-client-5.5« ist nicht installiert, wird also auch nicht entfernt.
0 aktualisiert, 0 neu installiert, 0 zu entfernen und 1 nicht aktualisiert.
root@omv-homeserver:~# apt-get --purge remove mysql-common
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen.... Fertig
Die folgenden Pakete werden ENTFERNT:
mysql-common*
0 aktualisiert, 0 neu installiert, 1 zu entfernen und 1 nicht aktualisiert.
Nach dieser Operation werden 139 kB Plattenplatz freigegeben.
Möchten Sie fortfahren [J/n]? J
(Lese Datenbank ... 78988 Dateien und Verzeichnisse sind derzeit installiert.)
Entfernen von mysql-common ...
Löschen der Konfigurationsdateien von mysql-common ...
dpkg: Warnung: Während Entfernens von mysql-common ist Verzeichnis »/etc/mysql/conf.d« nicht leer, wird daher nicht gelöscht
Creating index of upgradeable packages ...
Creating index of OpenMediaVault plugins ...
root@omv-homeserver:~# apt-get --purge remove mysql-server
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen.... Fertig
Paket »mysql-server« ist nicht installiert, wird also auch nicht entfernt.
0 aktualisiert, 0 neu installiert, 0 zu entfernen und 1 nicht aktualisiert.
root@omv-homeserver:~# apt-get --purge remove mysql-server-5.5
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen.... Fertig
Paket »mysql-server-5.5« ist nicht installiert, wird also auch nicht entfernt.
0 aktualisiert, 0 neu installiert, 0 zu entfernen und 1 nicht aktualisiert.
root@omv-homeserver:~# apt-get --purge remove mysql-server-core-5.5
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen.... Fertig
Die folgenden Pakete werden ENTFERNT:
mysql-server-core-5.5*
0 aktualisiert, 0 neu installiert, 1 zu entfernen und 1 nicht aktualisiert.
Nach dieser Operation werden 20,2 MB Plattenplatz freigegeben.
Möchten Sie fortfahren [J/n]? J
(Lese Datenbank ... 78979 Dateien und Verzeichnisse sind derzeit installiert.)
Entfernen von mysql-server-core-5.5 ...
Creating index of upgradeable packages ...
Creating index of OpenMediaVault plugins ...
root@omv-homeserver:~# apt-get --purge remove php5-mysqlnd
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen.... Fertig
Die folgenden Pakete werden ENTFERNT:
php5-mysqlnd*
0 aktualisiert, 0 neu installiert, 1 zu entfernen und 1 nicht aktualisiert.
Nach dieser Operation werden 495 kB Plattenplatz freigegeben.
Möchten Sie fortfahren [J/n]? J
(Lese Datenbank ... 78889 Dateien und Verzeichnisse sind derzeit installiert.)
Entfernen von php5-mysqlnd ...
Löschen der Konfigurationsdateien von php5-mysqlnd ...
Trigger für php5-fpm werden verarbeitet ...
insserv: warning: script 'K02var_log' missing LSB tags and overrides
insserv: warning: script 'var_log' missing LSB tags and overrides
Restarting PHP5 FastCGI Process Manager: php5-fpm.
Creating index of upgradeable packages ...
Creating index of OpenMediaVault plugins ...
root@omv-homeserver:~# dpkg -l | grep mysql
root@omv-homeserver:~#
and what i am doing now?
Thanks!
Eddy
still have the same problem...
output of the webinterface
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 mysql-server-core-5.5 mywebsql php5-mysqlnd
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 mysql-server-core-5.5 mywebsql
openmediavault-mysql php5-mysqlnd
0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded.
Need to get 10.4 MB of archives.
After this operation, 99.8 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-core-5.5 mysql-server-5.5 php5-mysqlnd mysql-server
openmediavault-mysql mywebsql
Authentication warning overridden.
Get:1 http://security.debian.org/ wheezy/updates/main mysql-common all 5.5.38-0+wheezy1 [78.6 kB]
Get:2 http://ftp.de.debian.org/debian/ wheezy/main libdbd-mysql-perl amd64 4.021-1+b1 [126 kB]
Get:3 http://security.debian.org/ wheezy/updates/main libmysqlclient18 amd64 5.5.38-0+wheezy1 [680 kB]
Get:4 http://packages.omv-extras.org/debian/ kralizec/main openmediavault-mysql all 1.0.10 [19.6 kB]
Get:5 http://packages.omv-extras.org/debian/ kralizec/main mywebsql all 3.4-omv1 [1447 kB]
Get:6 http://security.debian.org/ wheezy/updates/main mysql-client-5.5 amd64 5.5.38-0+wheezy1 [1886 kB]
Get:7 http://security.debian.org/ wheezy/updates/main mysql-server-core-5.5 amd64 5.5.38-0+wheezy1 [3777 kB]
Get:8 http://security.debian.org/ wheezy/updates/main mysql-server-5.5 amd64 5.5.38-0+wheezy1 [2098 kB]
Get:9 http://security.debian.org/ wheezy/updates/main php5-mysqlnd amd64 5.4.4-14+deb7u14 [163 kB]
Get:10 http://security.debian.org/ wheezy/updates/main mysql-server all 5.5.38-0+wheezy1 [76.9 kB]
Preconfiguring packages ...
Fetched 10.4 MB in 12s (802 kB/s)
Selecting previously unselected package mysql-common.
(Reading database ... 78888 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) ...
Selecting previously unselected package mysql-server-core-5.5.
Unpacking mysql-server-core-5.5 (from .../mysql-server-core-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 ... 79078 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 php5-mysqlnd.
Unpacking php5-mysqlnd (from .../php5-mysqlnd_5.4.4-14+deb7u14_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 php5-fpm ...
insserv: warning: script 'K02var_log' missing LSB tags and overrides
insserv: warning: script 'var_log' missing LSB tags and overrides
Restarting PHP5 FastCGI Process Manager: php5-fpm.
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-core-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
Setting up php5-mysqlnd (5.4.4-14+deb7u14) ...
Creating config file /etc/php5/mods-available/mysqlnd.ini with new version
Creating config file /etc/php5/mods-available/mysql.ini with new version
Creating config file /etc/php5/mods-available/mysqli.ini with new version
Creating config file /etc/php5/mods-available/pdo_mysql.ini with new version
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
Processing triggers for php5-fpm ...
insserv: warning: script 'K02var_log' missing LSB tags and overrides
insserv: warning: script 'var_log' missing LSB tags and overrides
Restarting PHP5 FastCGI Process Manager: php5-fpm.
Errors were encountered while processing:
mysql-server-5.5
mysql-server
openmediavault-mysql
mywebsql
please help me ...
Eddy
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-client-5.5 5.5.38-0+wheezy1 amd64 MySQL database client binaries
ii mysql-common 5.5.38-0+wheezy1 all MySQL database common files, e.g. /etc/mysql/my.cnf
iU mysql-server 5.5.38-0+wheezy1 all MySQL database server (metapackage depending on the latest version)
iF 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
iU openmediavault-mysql 1.0.10 all MySQL plugin for OpenMediaVault
ii php5-mysqlnd 5.4.4-14+deb7u14 amd64 MySQL module for php5 (Native Driver)
service mysql status
if I get to Services, i got this Message in a window
Failed to get configuration (xpath=//services/mysql)
Fehler #3003:
exception 'OMVException' with message 'Failed to get configuration (xpath=//services/mysql)' in /usr/share/openmediavault/engined/module/mysql.inc:64
Stack trace:
#0 /usr/share/openmediavault/engined/rpc/services.inc(63): OMVModuleMySQL->getStatus()
#1 [internal function]: OMVRpcServiceServices->getStatus(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('getStatus', Array, Array)
#4 /usr/sbin/omv-engined(501): OMVRpc::exec('Services', 'getStatus', Array, Array, 1)
#5 {main}
Thanks!
Eddy
Yes the Problem ist it cant start... i dont know why...
service mysql start
root@omv-homeserver:~# service mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
root@omv-homeserver:~# service mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
root@omv-homeserver:~# service mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
root@omv-homeserver:~#
try:
Zitatmysql_upgrade -u root -p
(but I suppose that command will work only if the mysql server is up)
Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!