I want to contribute something based on my experience this morning with installing ActiveCollab .7 RC1 in my local development environment using XAMPP (actually I use XAMPP Lite in Windows XP Pro). By default XAMPP Lite disables InnoDB storage, which is required by ActiveCollab. To get it to work, edit this file:

/xamppdir/mysql/bin/my (no file extension, though in some mysql installs it's my.conf)

Look for

skip-innodb 
# Uncomment the following if you are using InnoDB tables 
#innodb_data_home_dir = /xampplite/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend 
#innodb_log_group_home_dir = /xampplite/mysql/data/
#innodb_log_arch_dir = /xampplite/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 % 
# of RAM but beware of setting memory usage too high 
#set-variable = innodb_buffer_pool_size=16M 
#set-variable = innodb_additional_mem_pool_size=2M 
# Set .._log_file_size to 25 % of buffer pool size 
#set-variable = innodb_log_file_size=5M 
#set-variable = innodb_log_buffer_size=8M 
#innodb_flush_log_at_trx_commit=1 
#set-variable = innodb_lock_wait_timeout=50

Comment out the "skip-innodb" line and uncomment the variables. Careful, there are a few notes mingled in with the variables that must remain commented out or your mysql launch will fail. Uncommenting=remove the "#".

Here's what mine looked like when I was done:

#skip-innodb 
# Uncomment the following if you are using InnoDB tables 
innodb_data_home_dir = D:/DEVserver/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend 
innodb_log_group_home_dir = D:/DEVserver/mysql/data/
innodb_log_arch_dir = D:/DEVserver/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 % 
# of RAM but beware of setting memory usage too high 
set-variable = innodb_buffer_pool_size=16M 
set-variable = innodb_additional_mem_pool_size=2M 
#Set .._log_file_size to 25 % of buffer pool size 
set-variable = innodb_log_file_size=5M 
set-variable = innodb_log_buffer_size=8M 
innodb_flush_log_at_trx_commit=1 
set-variable = innodb_lock_wait_timeout=50

Save the file, restart mysql and proceed with installing ActiveCollab. Worked great for me.

XAMPP is a free (open source) easy to install Apache distribution containing MySQL, PHP and Perl. It's small (especially the Lite version) so you can just download, extract and start. You can even run it from a usb drive/memory card. Works in Windows, Mac, Linux and Solaris. Makes a great local development server environment.

XAMPP info: http://www.apachefriends.org/en/xampp.html

Regards,
Bill

Sorry. I have some questions?
- Why do you use xampp lite? instead of full xampp? Any specific reason? beside filesize?
- I've been running full xampp/aC without modifying anything (innodb setup)? Is it necessary the innodb setup?

Thanks for posting this, but I can't find "my" in that directory (there's a speed-dial shortcut called "my" but I can't edit it.

I'm probably using a different version - I just downloaded activeCollab the other day - could the file be in a different place in my version?

Cheers

The thing is, it's a shortcut, not a file so I can't open it. Ah - I can't open it with the right-click menu, but if I select File | Open | path/to/my from my editor, I can.

Worked beautifully - thanks!