687
edits
Changes
From SME Server
Jump to navigationJump to searcheliminate level 6 headlines...
==Install mariadb 'alongside' mysql==
===Draft notes on mariadb installation===
<nowiki>
<nowiki>
#####################################################################################
#####################################################################################
</nowiki>
</nowiki>
===Backup & Restore===
* (RequestedDeletion) Nice notes. Would it be worth it to look at the pre-backup and pre-restore events (And config db settings) so MariaDB databases are being backup up ?
* (RequestedDeletion) Nice notes. Would it be worth it to look at the pre-backup and pre-restore events (And config db settings) so MariaDB databases are being backup up ?
====/etc/e-smith/events/actions/mariadb-dump-tables====
* Based on /etc/e-smith/events/actions/mysql-dump-tables
* Based on /etc/e-smith/events/actions/mysql-dump-tables
* "CONNECT" options separated out for easy modification and potential movement into db variables
* "CONNECT" options separated out for easy modification and potential movement into db variables
mysqldump $CONNECT -x --add-drop-table -QB "$db" -r /home/e-smith/db/mariadb/"$db".dump || exit 1
mysqldump $CONNECT -x --add-drop-table -QB "$db" -r /home/e-smith/db/mariadb/"$db".dump || exit 1
done</nowiki>
done</nowiki>
====/etc/e-smith/events/actions/mariadb-load-tables====
* based on /etc/e-smith/events/actions/mysql-load-tables
* based on /etc/e-smith/events/actions/mysql-load-tables
* doesn't actually load the dbs
* doesn't actually load the dbs
done
done
fi</nowiki>
fi</nowiki>
====Automation====
=====Backup=====
* Link mariadb-dump-tables into the pre-backup event
* Link mariadb-dump-tables into the pre-backup event
* Dumped tables should be included in backups as they are stored under /home/e-smith
* Dumped tables should be included in backups as they are stored under /home/e-smith
<nowiki>cd /etc/e-smith/events/pre-backup
<nowiki>cd /etc/e-smith/events/pre-backup
ln -s ../actions/mariadb-dump-tables S20mariadb-dump-tables</nowiki>
ln -s ../actions/mariadb-dump-tables S20mariadb-dump-tables</nowiki>
=====Restore - NEEDS WORK=====
The SME Server mysql restore is complicated by various factors that may not apply to a mariadb "alongside" installation.
The SME Server mysql restore is complicated by various factors that may not apply to a mariadb "alongside" installation.
Here's what would need to be done to restore all mariadb databases:
Here's what would need to be done to restore all mariadb databases:
mysql $CONNECT < <dbname>.dump</nowiki>
mysql $CONNECT < <dbname>.dump</nowiki>
==Install Moodle 2.6 using git==
===Requirements===
* Recommended minimum browser: recent Google Chrome, recent Mozilla Firefox, Safari 6, Internet Explorer 9 (IE 10 required for drag and drop of files from outside the browser into Moodle)
* Recommended minimum browser: recent Google Chrome, recent Mozilla Firefox, Safari 6, Internet Explorer 9 (IE 10 required for drag and drop of files from outside the browser into Moodle)
* Moodle upgrade: Moodle 2.2 or later (if upgrading from earlier versions, you must upgrade to 2.2.11 as a first step)
* Moodle upgrade: Moodle 2.2 or later (if upgrading from earlier versions, you must upgrade to 2.2.11 as a first step)
* New recommended PHP extensions: <span style="color:green">zlib</span>, <span style="color:red;">OPcache</span>
* New recommended PHP extensions: <span style="color:green">zlib</span>, <span style="color:red;">OPcache</span>
====DB Version====
SME Server 8.x comes with MySQL v5.0.95. In order to install Moodle without risking destabilizing a SME server by changing the MySQL version, you can install MariaDB 5.3.54 ''alongside'' MySql.
SME Server 8.x comes with MySQL v5.0.95. In order to install Moodle without risking destabilizing a SME server by changing the MySQL version, you can install MariaDB 5.3.54 ''alongside'' MySql.
====OPcache====
Zend OPcache is built-in to PHP 5.5, and can be compiled to work with PHP 5.3.3.
Zend OPcache is built-in to PHP 5.5, and can be compiled to work with PHP 5.3.3.
I believe this will make Moodle run more slowly than it would *with* OPcache.
I believe this will make Moodle run more slowly than it would *with* OPcache.
===Installation===
====Prepare your server====
======Install useful php modules======
======Install useful php modules======
* During installation, Moodle will request php-soap, php-xmlrpc and php-intl. These are all available from the 'smeaddons' repository, and can be installed using:
* During installation, Moodle will request php-soap, php-xmlrpc and php-intl. These are all available from the 'smeaddons' repository, and can be installed using:
yum install php-soap php-xmlrpc php-intl
yum install php-soap php-xmlrpc php-intl
=====Create an ibay=====
* Create an ibay named 'moodle' in server-manager
* Create an ibay named 'moodle' in server-manager
* Customize some of the settings on the new moodle ibay
* Customize some of the settings on the new moodle ibay
#</nowiki>
#</nowiki>
=====Create a database=====
* Install Mariadb ''alongside'' mysql
* Install Mariadb ''alongside'' mysql
* create a mariadb database for moodle
* create a mariadb database for moodle
quit"</nowiki>
quit"</nowiki>
====Install Moodle====
=====Download & Checkout using git=====
<nowiki>
<nowiki>
#
#
signal-event ibay-modify $IBAY
signal-event ibay-modify $IBAY
</nowiki>
</nowiki>
=====Run the installer=====
<nowiki>#
<nowiki>#
# run the command line installer
# run the command line installer
sudo -u www /usr/bin/php install.php
sudo -u www /usr/bin/php install.php
</nowiki>
</nowiki>
=====Correct database settings if necessary=====
If you were not prompted for database socket, port, or other connection settings during the command line setup, you will need to correct the settings manually.
If you were not prompted for database socket, port, or other connection settings during the command line setup, you will need to correct the settings manually.
sed -i s/dbpass.*/dbpass\ \ \ \ \=\ \'$DBPASS\'\;/ /home/e-smith/files/ibays/moodle/html/config.php</nowiki>
sed -i s/dbpass.*/dbpass\ \ \ \ \=\ \'$DBPASS\'\;/ /home/e-smith/files/ibays/moodle/html/config.php</nowiki>
==Notes on check_earlytalker==
Why did you remove the Request_for_deletion template on the check_earlytalker page? AFAIK it is obsolete and should be deleted according to http://forums.contribs.org/index.php/topic,46234.msg226418.html#msg226418 - <small>— [[User:Cactus|Cactus]] ([[User talk:Cactus|talk]] | [[Special:Contributions/Cactus|contribs]]) </small> 07:05, 16 February 2012 (MST)
Why did you remove the Request_for_deletion template on the check_earlytalker page? AFAIK it is obsolete and should be deleted according to http://forums.contribs.org/index.php/topic,46234.msg226418.html#msg226418 - <small>— [[User:Cactus|Cactus]] ([[User talk:Cactus|talk]] | [[Special:Contributions/Cactus|contribs]]) </small> 07:05, 16 February 2012 (MST)
