Mit Database Config meintest du die /etc/my.cnf ? Oder gibts noch Datenbankspezifische Konfigurationsdateien?
Code: Select all
[client]
port = 3306
socket = /var/run/mysql/mysql.sock
# Here follows entries for some specific programs
# The MariaDB server
[mysqld]
port = 3306
socket = /var/run/mysql/mysql.sock
# Change following line if you want to store your database elsewhere
datadir = /var/lib/mysql
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
# Replication Master Server (default)
# binary logging is required for replication
# log-bin=mysql-bin
# binary logging format - mixed recommended
# binlog_format=mixed
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
# The safe_mysqld script
[safe_mysqld]
log-error = /var/log/mysql/mysqld.log
socket = /var/run/mysql/mysql.sock
!includedir /etc/mysql
[mysqldump]
socket = /var/run/mysql/mysql.sock
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log = /var/log/mysqld_multi.log
# user = multi_admin
# password = secret
# The safe_mysqld script
[safe_mysqld]
log-error = /var/log/mysql/mysqld.log
socket = /var/run/mysql/mysql.sock
!includedir /etc/mysql
[mysqldump]
socket = /var/run/mysql/mysql.sock
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log = /var/log/mysqld_multi.log
# user = multi_admin
# password = secret
Die Datenbank ist ca 360MB groß.
Edit: Okay ich habe habe die Datenbank per Hand laden können indem ich max_allowed_package hoch gesetzt habe.
Das Hauptproblem besteht aber immer noch. Es sieht so aus, als ob otrs nicht auf die Datenbank zugreifen kann.
Beim Start von otrs kommt:
Code: Select all
Dec 14 14:15:17 h2106059 otrs[8094]: No database connect!)
Dec 14 14:15:17 otrs[8094]: -------------------------------------------------------------...----
Dec 14 14:15:17 otrs[8094]: Error: Maybe your database isn't configured yet?
Dec 14 14:15:17 otrs[8094]: -------------------------------------------------------------...----
Dec 14 14:15:17 otrs[8094]: Try the web installer to configure your database:
Dec 14 14:15:17 otrs[8094]: -->> http://h2106059.stratoserver.net/otrs/installer.pl <<--
Dec 14 14:15:17 otrs[8094]: -------------------------------------------------------------...----
Dec 14 14:15:17 otrs[8094]: or configure your database with README.database (DB - Setup Example)
Dec 14 14:15:17 otrs[8094]: -------------------------------------------------------------...----
Dec 14 14:15:17 otrs[8094]: ..failed
und beim Restoreprozess:
Message: Access denied for user 'otrs'@'localhost' (using password: YES)
In meiner Defaults.pm steht bei den DB Einstellungen:
Code: Select all
97 # --------------------------------------------------- #
98 # database settings #
99 # --------------------------------------------------- #
100 # DatabaseHost
101 # (The database host.)
102 $Self->{DatabaseHost} = 'localhost';
103
104 # Database
105 # (The database name.)
106 $Self->{Database} = 'otrs';
107
108 # DatabaseUser
109 # (The database user.)
110 $Self->{DatabaseUser} = 'otrs';
111
112 # DatabasePw
113 # (The password of database user.)
114 $Self->{DatabasePw} = 'XXX';
Anmelden mit "mysql -u otrs -p otrs" und dann c&p des pw aus der defaults geht.
Ich weiß nicht, ob das mit einspielt aber wenn ich in der Defaults.pm securemode auf 1 stelle kann ich trotzdem nicht in das Installationsmenü:
"Error Message: SecureMode active!"
Heißt das evtl, dass die Configdatei nicht richtig geladen wird?