Difference between revisions of "OrangeScrum"
Jump to navigation
Jump to search
Michael.mast (talk | contribs) |
Michael.mast (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 9: | Line 9: | ||
<br> | <br> | ||
| − | ==DB Creation==<ref>https://www.euperia.com/development/mysql-create-database-with-utf8-character-set-syntax/1064</ref> | + | ==DB Creation== |
| + | <ref>https://www.euperia.com/development/mysql-create-database-with-utf8-character-set-syntax/1064</ref> | ||
*<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)]> | + | 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; | ||
Latest revision as of 14:51, 10 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
- [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.
MariaDB [(none)]> grant all privileges on orangescrum.* to 'orange'@'localhost'; MariaDB [(none)]> flush privileges; MariaDB [(none)]> exit;
- ↑ http://www.orangescrum.org/general-installation-guide
- ↑ http://dev.antoinesolutions.com/apache-server/mod_rewrite
- ↑ https://www.euperia.com/development/mysql-create-database-with-utf8-character-set-syntax/1064
- ↑ https://support.kayako.com/article/472-how-do-i-disable-mysql-strict-mode-on-the-server
- ↑ https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql
