Ich kriege von Plesk immer als Fehlermeldung
beim starten und bei dem Versuch ein update zu machen eigentlich von Plesk 8.4 auf Plesk 8.6/usr/bin/mysql: unknown variable 'character-set-server=utf8'
da es aber immerwieder Fehlermeldungen gab kann ich nun nur mein backup einspielen und erneut ein backup versuchen oder wie ich schon mit den fehlerhaften updates versucht hatte durch deinstallation der Packete gleich plesk 8.6 zu installieren. Leider kann ich aber keine Version von plesk so installieren außer die Version 8.2 und dann geht das versenden von Mails nicht mehr.
Dort bekomme ich dann immer als Fehlermeldung
554 mail server permanently rejected message
Meine Hoffnung wäre nun wenn Ihr mir helfen könntet die Mysql Meldung zu beheben oder das mit den Mails zu beheben
Meine my.cnf ist
Code: Select all
[client]
character-sets-dir = /usr/share/mysql/charsets
default-character-set = utf8
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
set-variable=local-infile=0
port = 3306
socket = /var/lib/mysql/mysql.sock
net_buffer_length = 8K
read_rnd_buffer_size = 512K
[safe_mysqld]
err-log=/var/lib/mysql/mysqld.log
open-files-limit = 4096
[mysqldump]
character-sets-dir = /usr/share/mysql/charsets
default-character-set = utf8
max_allowed_packet = 16M
quick
[mysqlimport]
character-sets-dir = /usr/share/mysql/charsets
default-character-set = utf8
[mysqlshow]
character-sets-dir = /usr/share/mysql/charsets
default-character-set = utf8
[mysql]
no-auto-rehash
character-sets-dir = /usr/share/mysql/charsets
character-set-server = utf8
default-character-set = utf8
user = mysql
port = 3306
# bind-address = 127.0.0.1
socket = /var/lib/mysqld/mysqld.sock
pid-file = /var/lib/mysqld/mysqld.pid
log-error = /var/log/mysql/mysqld.err
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
log-bin = mysql-bin
server-id = 1
sync_binlog = 1
binlog_cache_size = 1M
max_binlog_size = 10M
slave_compressed_protocol = 1
delay-key-write = ALL
skip-locking
skip-networking
skip-name-resolve
skip-external-locking
skip-show-database
safe-user-create = 1
default_table_type = MYISAM
transaction_isolation = REPEATABLE-READ
max_allowed_packet = 16M
max_heap_table_size = 64M
tmp_table_size = 64M
key_buffer_size = 384M
sort_buffer_size = 8M
join_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 32M
myisam_sort_buffer_size = 64M
myisam_max_sort_file_size = 1G
myisam_max_extra_sort_file_size = 1G
myisam_repair_threads = 1
thread_cache_size = 8
table_cache = 512
query_cache_type = 1
query_cache_size = 32M
query_cache_limit = 2M
thread_concurrency = 8
local-infile = 0
long_query_time = 3
log_slow_queries
log_long_format
myisam_recover
#skip-innodb
innodb_thread_concurrency = 8
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_data_home_dir = /var/lib/mysql
innodb_log_arch_dir = /var/lib/mysql
innodb_log_group_home_dir = /var/lib/mysql
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_log_files_in_group = 2
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 60
[isamchk]
character-sets-dir = /usr/share/mysql/charsets
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer_size = 4M
write_buffer_size = 4M
[myisamchk]
character-sets-dir = /usr/share/mysql/charsets
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer_size = 4M
write_buffer_size = 4M
[mysqlhotcopy]
interactive-timeout
und die genaue Fehlermeldung bei einem Update ist immer
===> Installing psa database
Checking for service MySQL: ..running
Trying to define valid mysql credentials... Trying to establish test connection... connected
done
Checking for service MySQL: ..running
Trying to establish test connection... /usr/bin/mysql: unknown variable 'character-set-server=utf8'
/usr/bin/mysql: unknown variable 'character-set-server=utf8'
/usr/bin/mysql: unknown variable 'character-set-server=utf8'
/usr/bin/mysql: unknown variable 'character-set-server=utf8'
ERROR while trying to establish test connection
Aborting...
Bitte helft mir ich bin solangsam echt am verzweifeln
