[Eisfair] [e1] Problem bei MariaDB Erstinstallation
Hans-Georg Kiefer
hansgeorg at edv-einsteiger.de
Do Jan 12 07:53:29 CET 2017
Hallo zusammen.
Zum Abschluss des Tages wollte ich auf einem Eisfair-Server, der seit
einem Jahr als Samba-Tänzer läuft, Apache und mysql/mariadb
installieren, um den Funktionsumfang zu erweitern.
Der Server ist mit seinem Paketen auf dem neuesten Stand.
Base 2.7.8
Kernel 2.26.1 SMP
Samba 2.40.0
openVPN 1.0.3
backup-zip 1.0.48
Installation von Apache, php5, php5_ccpp und MariaDB samt aller
Abhängigkeiten ohne Auffälligkewiten.
Nach der Konfiguration von MariaDB:
#----------------
START_MARIADB='no' # start MariaDB Server 'yes' or
MARIADB_NETWORK='no' # enable the TCP/IP external c
MARIADB_DATADIR='' # empty: default /var/lib/mysql
MARIADB_SEND_MAIL_FROM='' # Mail address from Admin,
required for outgoing mal
MARIADB_BACKUP_CRON_SCHEDULE='15 3 * * 5'
# start time for cron backup
MARIADB_BACKUP_TARGET='/data/backup/mysql'
# backup target directory
MARIADB_BACKUP_GROUP='users' # special group to use the backup
files
# default: empty -> mysql
MARIADB_BACKUP_N='1' # number of backup files
MARIADB_BACKUP_1_NAME='' # Use a name, ist only for you
MARIADB_BACKUP_1_ACTIVE='no' # Use yes or no
MARIADB_BACKUP_1_FILE='mysql' # backup file
MARIADB_BACKUP_1_MAX='7' # maximum number of stored Ba
MARIADB_BACKUP_1_FORCE='yes' # Ignore last file update date
MARIADB_BACKUP_MOUNT='' # command before run backup
# sample: 'mount /mo'
MARIADB_BACKUP_UMOUNT='' # command after run backup
# sample: 'umount /mo'
MARIADB_DEFAULT_COLLATION='utf8_unicode_ci'
# Default collation
MARIADB_CONNECT_PORT='3306' # MariaDB remote port default=3306
MARIADB_BIND_IP_ADDRESS='' # Network IP Address default=''
# connect a specific network card
MARIADB_MEMORY_OPT='medium' # Use RAM
# small: < 64 MB RAM
# medium: 64 - 128 MB RAM
# large: ~ 512 MB RAM
# huge: ~ 1024 MB RAM
MARIADB_THREAD_STACK_SIZE='256k' # stack size in k
MARIADB_MAX_ALLOWED_PACKET='1' # Default 1 (MB)
MARIADB_MAX_CONNECTIONS='200' # Count of maximal connections
MARIADB_ACTIVATE_BINLOG='no' # Activate binary logfile for r
MARIADB_MAX_BINLOG_SIZE='1024000' # Maximum size of logfile in By
#----------------
Startet der Datenbank server nicht [ FAIL ].
Messages hat nichts spannendes zu berichten:
...7135]: new group: name=mysql, GID=202
Jan 12 05:23:25 SERVER useradd[27171]: new user: name=mysql, UID=499,
GID=202, home=/var/lib/mysql, shell=/bin/false
Jan 12 05:26:34 SERVER usermod[27996]: add 'mysql' to group 'users'
Und das mysql-Log kann ich nicht wirklich wechseln:
170112 05:26:35 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
170112 5:26:35 [Note] /usr/bin/mysqld (mysqld 5.5.54-MariaDB) starting
as process 28516 ...
170112 5:26:35 InnoDB: The InnoDB memory heap is disabled
170112 5:26:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170112 5:26:35 InnoDB: Compressed tables use zlib 1.2.8
170112 5:26:35 InnoDB: Using Linux native AIO
170112 5:26:35 InnoDB: Initializing buffer pool, size = 128.0M
170112 5:26:35 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
170112 5:26:35 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
170112 5:26:35 InnoDB: Log file ./ib_logfile0 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
170112 5:26:35 InnoDB: Log file ./ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
170112 5:26:35 InnoDB: Waiting for the background threads to start
170112 5:26:36 Percona XtraDB (http://www.percona.com)
5.5.52-MariaDB-38.3 started; log sequence number 0
170112 5:26:36 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
170112 5:26:36 [ERROR] Fatal error: Can't open and lock privilege
tables: Tabelle 'mysql.host' existiert nicht
170112 05:26:36 mysqld_safe mysqld from pid file /run/mysql/mysql.pid ended
170112 05:28:25 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
170112 5:28:25 [Note] /usr/bin/mysqld (mysqld 5.5.54-MariaDB) starting
as process 29209 ...
170112 5:28:25 InnoDB: The InnoDB memory heap is disabled
170112 5:28:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170112 5:28:25 InnoDB: Compressed tables use zlib 1.2.8
170112 5:28:25 InnoDB: Using Linux native AIO
170112 5:28:25 InnoDB: Initializing buffer pool, size = 128.0M
170112 5:28:25 InnoDB: Completed initialization of buffer pool
170112 5:28:25 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 50037
170112 5:28:25 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1597945
170112 5:28:25 InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 45 46 47 48 49 50 51 52 53 54 55 56 57 58
59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
170112 5:28:26 InnoDB: Waiting for the background threads to start
170112 5:28:27 Percona XtraDB (http://www.percona.com)
5.5.52-MariaDB-38.3 started; log sequence number 1597945
170112 5:28:27 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
170112 5:28:27 [ERROR] Fatal error: Can't open and lock privilege
tables: Tabelle 'mysql.host' existiert nicht
170112 05:28:27 mysqld_safe mysqld from pid file /run/mysql/mysql.pid ended
Ich weiß, dass es nicht am Paket liegt, aber ich hab keine Idee, wie ich
dem beikomme.
Ach ja, beim Aufruf einer Menüfunktion von MariaDB erscheint unterm Menü
folgendes:
/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command
not found
Tanne
--
--------------------------
Es grüsst hochachtungsvoll
******* T A N N E ********
---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus
Mehr Informationen über die Mailingliste Eisfair