4.0.8

[pmn]

Hello,

I'm trying to install otrs 4.0.8 on Opensuse 11.4. At the time of creating the database from the web interface i'm getting
<Error: Please set the value for innodb_log_file_size on your database to at least 256 MB (current: 5 MB, recommended: 512 MB). For more information, please have a look at http://dev.mysql.com/doc/refman/5.6/en/ ... ation.html.?

I tried to run perl /opt/otrs/bin/otrs.MySQLInnoDBSwitch.pl but that also fails saying

Message: Access denied for user 'otrs'@'localhost' (using password: YES)


Any link / advice directing me how to install otrs 4.0.8 would be very much appreciated.

Thank you.

[reneeb]

Did you follow the link? On the mysql website it is described in detail how you reconfigure the logfile size... After that you should be able to install OTRS.

[pmn]

Thanks for the reply. Yes I did, But was not successful. This is what I did

mysql> SET GLOBAL innodb_fast_shutdown = 1;

backed up the log files /var/log/mysql to a different location and deleted the innodb logs at /var/log/mysql
Then edited the /etc/my.cnf – here I only changed
innodb_log_file_size = 256M under [mysqld]

but were some other variables which are commented. I left them as it is since im not sure about the values to be set. Is it required to uncomment these also ?

#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = nnodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 256M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

Leaving the above as it is I tried to start mysql service but it refused to start, so I switched back the backup of /var/log/mysql back to it's original place to get the sql service started,

Any one having faced the same issue ?

[wurzel]

Hi,

for me it always worked with

stopping mysqld

changing

Code: Select all

innodb_log_file_size = 256M 

under [mysqld]


removing the ib_logfile datafiles in /var/lib/mysql/

restarting mysqld.

Cheers
Flo