/usr/bin/mysql: unknown variable 'character-set-server=utf8'

mcfly
Posts: 92
Joined: 2005-09-20 17:10

/usr/bin/mysql: unknown variable 'character-set-server=utf8'

Post by mcfly »

Hi an alle ich bin so langsam echt am verzweifeln.

Ich kriege von Plesk immer als Fehlermeldung
/usr/bin/mysql: unknown variable 'character-set-server=utf8'
beim starten und bei dem Versuch ein update zu machen eigentlich von Plesk 8.4 auf Plesk 8.6

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
Top

Roger Wilco
Administrator
Administrator
Posts: 6001
Joined: 2004-05-23 12:53

Re: /usr/bin/mysql: unknown variable 'character-set-server=utf8'

Post by Roger Wilco »

character-set-server ist eine Option für den MySQL-Server (mysqld) und nicht für den MySQL-Client (mysql). Schau dir doch mal an, in welcher Sektion deiner my.cnf die Direktive steht. Der Name der Sektion ist auch für die übrigen Einstellungen darin falsch.
Top