InnoDB Support necessary?

[Wunschmeister]

Hi there,

I'd like to install OpenGoo (which I find great, BTW) on a Webspace which does not provide InnoDB.
For what exactly is InnoDB required in OpenGoo and can these features safely be disabled?

My problem is that the cheapest webspace which InnoDB at HostEurope is 35€/month which is definitely too much for a poor student ...

Thanks for your answers.

[cabeza]

Hi Wunschmeister,
   currently we only support MySql with InnoDB (myISAM is untested and I  suspect it won't work).
The reason for which we use InnoDb is that it supports transactions. This means the ability to rollback on errors and to commit several queries "as one" (among other advantages).
I am sorry to say that, for now, disabling InnoDb will not be easy.

Marcos

[Wunschmeister]

That's quite a shame 

I think this will keep many from using OpenGoo which is pretty sad.

[Wunschmeister]

Don't you think it'd be possible to change OpenGoo so that it could be used with normal MySQL databases in the future?

[cabeza]

Hi Wunschmeister,
adapting OpenGoo for non-InnoDB databses is not  a small change and not within our priorities right now.
However, it is possible to do it and we are willing to help if anyone volunteers.
Marcos
PS: I am sure you can find cheaper hosting solutions with InnoDB support.

[Wunschmeister]

I still don't really understand why a «normal» MySQL database wouldn't work ...

What would I have to do in order to make OpenGoo work without InnoDB?
I only do know little about MySQL and my PHP skills are not the best, too ...

[cabeza]

For further understanding of InnoDb and MyISAM take a look at http://en.wikipedia.org/wiki/MyISAM . I recoomend InnoDb for most purposes.

Having said that, to make it work with MyISAM, you should:
* remove the installation check
* remove all the InnoDB specific statements (I would remove the ones related to transactions, located in the MysqlDBAdapter class)

After doing this, test the system and see if it works.

Good luck !
And please let us know if it works...
Marcos

[cabeza]

Hacking for non InnoDB MySql databases:

1- Open, in your favorite text ed, the mysql_schema.php file located in /public/install/installation/templates/sql/
2- Search & Replace all the 'innodb' occurences by 'myisam' & save
3- Open the acInstallation.class.php file located in /public/install/installation/
4- Search & Replace all the 'innodb' occurences by 'myisam'
5- On line 213, delete 'myisam' in the 'have_myisam' variable statement,
6- On line 218, change 'return false' to 'return true' and save
7- Upload both files to their respective locations on your server if you have already uploaded all the
ActiveCollab files, or the whole package otherwise.
8- Go through the install process.

(from: http://www.activecollab.com/forums/topic/1302/)
Do it at your own risk. This hack is not officially supported, and it was not tested (by me at least).
I still recommend InnoDb.
Marcos

[cabeza]

Мы не тестировали систему с https еще.
Мы, безусловно, будет делать это в ближайшее время.
Marcos
PS: Существует нового состава совета в форум для не-Английский должностей

We have not tested the system with https yet.
We will definitely do this shortly.
Marcos
PS: There is a new board in the forum for non-English posts

[DarkStar]

Hacking for non InnoDB MySql databases:

1- Open, in your favorite text ed, the mysql_schema.php file located in /public/install/installation/templates/sql/
2- Search & Replace all the 'innodb' occurences by 'myisam' & save
3- Open the acInstallation.class.php file located in /public/install/installation/
4- Search & Replace all the 'innodb' occurences by 'myisam'
5- On line 213, delete 'myisam' in the 'have_myisam' variable statement,
6- On line 218, change 'return false' to 'return true' and save
7- Upload both files to their respective locations on your server if you have already uploaded all the
ActiveCollab files, or the whole package otherwise.
8- Go through the install process.

(from: http://www.activecollab.com/forums/topic/1302/)
Do it at your own risk. This hack is not officially supported, and it was not tested (by me at least).
I still recommend InnoDb.
Marcos

I can confirm this works. I just installed OpenGoo on my webspace which has a MySQL server without InnoDB support. Made the changes in the files mentioned above and everything works great!

[cabeza]

Good to know.
Thanks,
Marcos

[videosession]

Wunschmeister,

Go to ->  http://forums.opengoo.org/index.php?topic=210.0   for at least a few alternatives...