Zdravím,
nějaký ten den se snažím rozběhnout dvě instance databáze mysql, ale pořád se to cosi nedaří...našel by se někdo, kdo to již rozběhnul?
Postupoval jsem dle tohoto návodu:
http://ubuntuforums.org/archive/index.php/t-1154296.htmlPři startu mysql to píše tuto chybu:
120520 10:07:50 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
120520 10:07:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120520 10:07:50 InnoDB: The InnoDB memory heap is disabled
120520 10:07:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120520 10:07:50 InnoDB: Compressed tables use zlib 1.2.3.4
120520 10:07:50 InnoDB: Initializing buffer pool, size = 128.0M
120520 10:07:50 InnoDB: Completed initialization of buffer pool
120520 10:07:50 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
..mám to víceméně stejně, jen v my.cnf jsem použil uživatele "mysql", on tam má "root". Ikdyž, zkoušel jsem i roota, ale ta samá chyba. Po chvilce googlení to vypadalo i na problém v apparmor, ale v tom samém návodu níže je napsáno, co tam vložit...celý soubor /etc/apparmor.d/usr.sbin.mysqld vypadá takto:
# vim:syntax=apparmor
# Last Modified: Tue Jun 19 17:37:30 2007
#include <tunables/global>
/usr/sbin/mysqld {
#include <abstractions/base>
#include <abstractions/nameservice>
#include <abstractions/user-tmp>
#include <abstractions/mysql>
#include <abstractions/winbind>
capability dac_override,
capability sys_resource,
capability setgid,
capability setuid,
network tcp,
/etc/hosts.allow r,
/etc/hosts.deny r,
/etc/mysql/*.pem r,
/etc/mysql/conf.d/ r,
/etc/mysql/conf.d/* r,
/etc/mysql/*.cnf r,
/usr/lib/mysql/plugin/ r,
/usr/lib/mysql/plugin/*.so* mr,
/usr/sbin/mysqld mr,
/usr/share/mysql/** r,
/var/log/mysql.log rw,
/var/log/mysql.err rw,
/var/lib/mysql/ r,
/var/lib/mysql/** rwk,
/var/log/mysql/ r,
/var/log/mysql/* rw,
/var/run/mysqld/mysqld.pid w,
/var/run/mysqld/mysqld.sock w,
/run/mysqld/mysqld.pid w,
/run/mysqld/mysqld.sock w,
/var/lib/mysql2/ r,
/var/lib/mysql2/** rwk,
/var/run/mysqld/mysqld2.pid w,
/var/run/mysqld/mysqld2.sock w,
# Site-specific additions and overrides. See local/README for details.
#include <local/usr.sbin.mysqld>
Jedna instance se nachází ve /var/lib/mysql, druhá instance /var/lib/mysql2 (on tam má /var/lib/mysql1 a mysql2, ale to je fuk)
Start mysql nevypíše vůbec nic:
root@domatest:/var/log/mysql# /etc/init.d/mysql start
root@domatest:/var/log/mysql#
Ale dle init skriptu ani nic nevypíše:
basedir=/usr
bindir=/usr/bin
if test -x $bindir/mysqld_multi
then
mysqld_multi="$bindir/mysqld_multi";
else
echo "Can't execute $bindir/mysqld_multi from dir $basedir";
exit;
fi
case "$1" in
'start' )
"$mysqld_multi" start $2
;;
'stop' )
"$mysqld_multi" stop $2
;;
'report' )
"$mysqld_multi" report $2
;;
'restart' )
"$mysqld_multi" stop $2
"$mysqld_multi" start $2
;;
*)
echo "Usage: $0 {start|stop|report|restart}" >&2
;;
esac
Jinak mám Ubuntu 12.04 server, 32bit
díky