Koozali.org: home of the SME Server

Obsolete Releases => SME Server 8.x => Topic started by: bloodshoteye on March 25, 2011, 09:50:59 AM

Title: Solved - Moodle 2x and InnoDB
Post by: bloodshoteye on March 25, 2011, 09:50:59 AM

Hi All,

Using SME 8.0 beta 6, fully patched:
I put Moodle into an ibay and configured a subdomain (URL is http://moodle.domain.tld)
All seems fine, can access via LAN and WAN.
My question is a notification Moodle is making about InnoDB compared to MyISAM:

Quote

Database tables are using MyISAM database engine, it is recommended to use ACID compliant engine with full transaction support such as InnoDB.

If I enable the InnoDB engine (obviously also re-installing Moodle) as per [[http://wiki.contribs.org/MySQL#Enable_InnoDB_engine]], will other existing MyISAM databases on the same box be affected?

Cheers,

Title: Re: Moodle 2x and InnoDB
Post by: bloodshoteye on March 25, 2011, 04:01:00 PM

Replied to self:

Quote

To convert a non-InnoDB table to use InnoDB use ALTER TABLE:
ALTER TABLE t1 ENGINE=InnoDB;
Important
Do not convert MySQL system tables in the mysql database (such as user or host) to the InnoDB type. This is an unsupported operation. The system tables must always be of the MyISAM type.

This is from the following authoritative website: http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html (http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html)
Thus individual DBs can be converted leaving other existing tables as they are. If you want to.

Cheers,

Title: Re: Solved - Moodle 2x and InnoDB
Post by: kwak on April 26, 2011, 05:51:50 PM

Hi,

Have you manage to install INTL  (php-intl)?

Kwak

Title: Re: Solved - Moodle 2x and InnoDB
Post by: bloodshoteye on April 26, 2011, 06:49:02 PM

Quote from: kwak on April 26, 2011, 05:51:50 PM

Hi,
Have you manage to install INTL  (php-intl)?
Kwak

I don'y remember installing that, so I did

Quote

# yum list installed

- not installed.

Cheers.

Title: Re: Solved - Moodle 2x and InnoDB
Post by: newburns on December 12, 2011, 07:16:53 AM

How did you place moodle into an IBay. Did you install into an IBay? Please explain.

Title: Re: Solved - Moodle 2x and InnoDB
Post by: bloodshoteye on December 12, 2011, 07:46:09 AM

Quote from: newburns on December 12, 2011, 07:16:53 AM

How did you place moodle into an IBay. Did you install into an IBay? Please explain.

Far as I recall I simply expanded the tar.gz file in the IBay and followed Moodle's instructions. Also you must set:

Code: [Select]

db accounts setprop <IBay_name> PHPBaseDir /home/e-smith/files/ibays/<IBay_name>/html/:/tmp/
signal-event ibay-modify <IBay_name>
For secure Moodle data set:

Code: [Select]

db accounts setprop <IBay_name> PHPBaseDir /home/e-smith/files/ibays/<IBay_name>/html/:/opt/moodledata/
signal-event ibay-modify <IBay_name>
You will need to make sure the Moodle config file is also set for secure data.

I offer no assurances I am correct as I'm relying on my forgettery.
Cheers