Difference between revisions of "OrangeScrum"

From Michael's Information Zone
Jump to navigation Jump to search
Line 12: Line 12:
 
*<ref>https://support.kayako.com/article/472-how-do-i-disable-mysql-strict-mode-on-the-server</ref>Disable Strict Mode
 
*<ref>https://support.kayako.com/article/472-how-do-i-disable-mysql-strict-mode-on-the-server</ref>Disable Strict Mode
 
<pre>
 
<pre>
MariaDB [(none)]> create database orangescrum collate utf8_unicode_ci;
+
MariaDB [(none)]> CREATE DATABASE `orangescrum` CHARACTER SET utf8 COLLATE utf8_unicode_ci;
 
MariaDB [(none)]> use orangescrum;
 
MariaDB [(none)]> use orangescrum;
 
MariaDB [orangescrum]> source /root/database.sql;
 
MariaDB [orangescrum]> source /root/database.sql;

Revision as of 13:01, 6 May 2016

WORK IN PROGRESS

A few of us at the office were in need of a project management solution, and so I started installing all kinds of servers. OrangeScrum is one of them and the instructions on their [1]site are not very friendly to people who may not be vary familiar with PHP, Apache, and MySQL (like me).
NOTE : I had an old desktop laying around with 1GB of RAM and a single core Pentium M processor that I used for testing these servers out on. Ended up installing Fedora Server, which had some of the requirements baked in.

Apache Config

[2] Enable mod_rewrite

==DB Creation==[3]

  • [4]Disable Strict Mode
MariaDB [(none)]> CREATE DATABASE `orangescrum` CHARACTER SET utf8 COLLATE utf8_unicode_ci;
MariaDB [(none)]> use orangescrum;
MariaDB [orangescrum]> source /root/database.sql;
MariaDB [(none)]> create user 'orange'@'localhost' identified by 'orange';

Please note that the above assumes orangescrum is running on the same server as the database, also orange as the password but this can be changed.

[5]

MariaDB [(none)]> grant all privileges on orangescrum.* to 'orange'@'localhost';
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> exit;