Editing FoolFuuka/Install/Debian

This guide was written by ATC of desuarchive, and is designed for Debian/Ubuntu Linux servers.

== Prepare things ==

<pre>apt-get update
apt-get upgrade</pre>
== Add the keys for HipHop Virtual Machine ==

<pre>sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0x5a16e7281be7a449
sudo add-apt-repository &quot;deb http://dl.hhvm.com/ubuntu $(lsb_release -sc) main&quot;</pre>
== Add repo for MariaDB 10.1 ==

<pre>sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
sudo add-apt-repository 'deb [arch=amd64,i386] http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu trusty main'</pre>
== Add repo for sphinxsearch ==

Note: Weird shit happens here

<pre>sudo add-apt-repository ppa:builds/sphinxsearch-stable</pre>
Then, Comment out repo in <code>/etc/apt/sources.list.d/*</code> and add to end:

<pre>  deb http://ppa.launchpad.net/builds/sphinxsearch-stable/ubuntu precise main 
  deb-src http://ppa.launchpad.net/builds/sphinxsearch-stable/ubuntu precise main </pre>
<pre>sudo apt-get update</pre>
== Install all the needed packages. ==

Nginx, HHVM, PHP5 Cli, PHP5 Curl, MariaDB, OpenJDK w/ compilier, Maven

<pre>sudo apt-get install git nginx hhvm php5-cli php5-curl php5-fpm php5-mysqlnd mariadb-server libmariadbclient-dev mariadb-client imagemagick openjdk-7-jre openjdk-7-jdk openjdk-7-jre-lib maven -y
sudo apt-get install phpmyadmin</pre>
== Install composer for downloading FoolFuuka dependencies. ==

<pre>curl -sS https://getcomposer.org/installer | php</pre>
== Move composer to bin ==

<pre>sudo mv composer.phar /usr/local/bin/composer</pre>
== Install hhvm as a service so it launches at boot. ==

<pre>sudo update-rc.d hhvm defaults</pre>
== Install hhvm with nginx ==

<pre>sudo /usr/share/hhvm/install_fastcgi.sh</pre>
== Edit HHVM config to use a unix socket. ==

<pre>sudo nano /etc/hhvm/server.ini</pre>
Then remove the line starting with hhvm.server.port, and in its place add the following one:

<pre>  hhvm.server.file_socket=/var/run/hhvm/hhvm.sock</pre>
== Set required php.ini vars. ==

<pre>sudo nano /etc/hhvm/php.ini</pre>
<pre>  date.timezone = UTC
  upload_max_filesize = 32M
  post_max_size = 32M</pre>
== Restart HHVM ==

<pre>sudo service hhvm restart</pre>
== Configure NGINX to use hhvm's new unix socket. ==

<pre>sudo nano /etc/nginx/hhvm.conf</pre>
In this file make sure that the fastcgi_pass directive points to the HHVM socket and looks like this:

<pre>  fastcgi_pass unix:/var/run/hhvm/hhvm.sock;</pre>
== Download FoolFuuka in home folder and install dependencies. ==

<pre>cd ~
composer create-project foolz/foolfuuka foolfuuka --prefer-source
cd foolfuuka
composer dump-autoload --optimize
composer install </pre>
== Install Foolfuuka Plugins ==

<pre>cd ~/foolfuuka/app/foolz/foolframe/plugins
mkdir foolz
cd foolz
git clone -c http.sslVerify=false https://dev.foolz.us/foolframe-plugins/foolframe-plugin-articles.git</pre>
<pre>cd ~/foolfuuka/app/foolz/foolfuuka/plugins
mkdir foolz
cd foolz
git clone -c http.sslVerify=false https://dev.foolz.us/foolfuuka-plugins/foolfuuka-plugin-board-statistics.git
git clone -c http.sslVerify=false https://dev.foolz.us/foolfuuka-plugins/foolfuuka-plugin-dice-roll.git
git clone -c http.sslVerify=false https://dev.foolz.us/foolfuuka-plugins/foolfuuka-plugin-quests.git</pre>
== Surely there is a better way to do this. ==

maybe you can try 755?

<pre>chmod -Rf 777 ~/foolfuuka

chown -Rf www-data:www-data ~/foolfuuka</pre>
== Configure Nginx to host foolfuuka ==

<pre>sudo nano /etc/nginx/sites-enabled/default</pre>
<pre>        root /home/ubuntu/foolfuuka/public;
        index index.php index.html index.htm;

        location / {
                try_files $uri $uri/ /index.php$is_args$args;
        }</pre>
== Restart Nginx ==

<pre>sudo service nginx restart</pre>
== Create the database and install Foolfuuka user accounts. ==

Note: Don't use this command: <code>sudo mysql_install_db</code>

<pre>sudo mysql_secure_installation</pre>
<pre>mysql -uroot -p
  CREATE USER 'asagi'@'localhost' IDENTIFIED BY 'pass';  
  CREATE USER 'foolfuuka'@'localhost' IDENTIFIED BY 'pass';
  CREATE DATABASE asagi DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_general_ci;
  CREATE DATABASE foolfuuka DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_general_ci;
  GRANT ALL PRIVILEGES ON `asagi`. * TO 'asagi'@'localhost';
  GRANT ALL PRIVILEGES ON `asagi`. * TO 'foolfuuka'@'localhost';
  GRANT ALL PRIVILEGES ON `foolfuuka`. * TO 'foolfuuka'@'localhost';
  FLUSH PRIVILEGES;
  exit</pre>
== #edit MariaDB to use utf8mb4 for correct unicode processing ==

<pre>sudo nano /etc/mysql/my.cnf</pre>
<pre>  [client]
  default-character-set = utf8mb4

  [mysql]
  default-character-set = utf8mb4

  [mysqld]
  character-set-client-handshake = FALSE
  character-set-server = utf8mb4
  collation-server = utf8mb4_general_ci</pre>
== Restart MariaDB ==

<pre>sudo service mysql restart</pre>
Disable transparent_hugepage

<pre>sudo echo never &gt; /sys/kernel/mm/transparent_hugepage/enabled
sudo echo never &gt; /sys/kernel/mm/transparent_hugepage/defrag
sudo nano /etc/default/grub
  # append transparent_hugepage=never to GRUB_CMDLINE_LINUX_DEFAULT 
sudo update-grub</pre>
Enable toku (Find and Uncomment the load module)

<pre>sudo nano /etc/mysql/conf.d/tokudb.cnf </pre>
Raise file limit

<pre>sudo nano /etc/security/limits.conf</pre>
<pre>  * soft nofile 63545
  * hard nofile 63545
  * soft nproc 63545
  * hard nproc 63545</pre>
Increase mysql file limit

<pre>sudo nano /etc/mysql/my.cnf</pre>
Put this after [mysqld]

<pre>  open-files-limit=40000</pre>
<pre>sudo service mysql stop
sudo reboot</pre>
<pre>mysql -u root -p
  set global default_storage_engine=TokuDB;
  SET GLOBAL log_bin_trust_function_creators = 1;</pre>
Now, Install FoolFuuka at the website using foolfuuka credentials

== Install and compile Asagi from source. ==

<pre>cd ~
git clone https://github.com/FoolCode/asagi.git
cd asagi
mvn package assembly:single
mv target/asagi-0.4.0-SNAPSHOT-full.jar ./asagi.jar</pre>
== Configure Asagi ==

<pre>cp asagi.json.example asagi.json
nano asagi.json</pre>
<pre>###
{&quot;settings&quot;: {
  &quot;dumperEngine&quot;: &quot;DumperJSON&quot;,
  &quot;sourceEngine&quot;: &quot;YotsubaJSON&quot;,

  &quot;boardSettings&quot;: {
    &quot;default&quot;: {
      &quot;engine&quot;: &quot;Mysql&quot;,
      &quot;database&quot;: &quot;asagi&quot;,
      &quot;host&quot;: &quot;localhost&quot;,
      &quot;username&quot;: &quot;asagi&quot;,
      &quot;password&quot;: &quot;afj8a428dauwj&quot;,
      &quot;charset&quot;: &quot;utf8mb4&quot;,
      &quot;path&quot;: &quot;/home/ubuntu/foolfuuka/public/foolfuuka/boards/&quot;,
      &quot;useOldDirectoryStructure&quot;: false,
      &quot;webserverGroup&quot;: &quot;www-data&quot;,
      &quot;thumbThreads&quot;: 3,
      &quot;mediaThreads&quot;: 0,
      &quot;newThreadsThreads&quot;: 3,
      &quot;deletedThreadsThresholdPage&quot;: 8,
      &quot;refreshDelay&quot;: 30,
      &quot;throttleAPI&quot;: true,
      &quot;throttleURL&quot;: &quot;api.4cdn.org&quot;,
      &quot;throttleMillisec&quot;: 11100,

      &quot;threadRefreshRate&quot;: 10,
      &quot;pageSettings&quot;: [
        {&quot;delay&quot;: 30, &quot;pages&quot;: [0, 1]},
        {&quot;delay&quot;: 500, &quot;pages&quot;: [2, 3, 4, 5, 6, 7, 8]},
        {&quot;delay&quot;: 30, &quot;pages&quot;: [9, 10]}
      ]
    },

    &quot;3&quot;: {},
    &quot;a&quot;: {},
    &quot;aco&quot;: {},
    &quot;adv&quot;: {},
    &quot;an&quot;: {},
    &quot;asp&quot;: {},
    &quot;b&quot;: {},
    &quot;biz&quot;: {},
    &quot;c&quot;: {},
    &quot;cgl&quot;: {},
    &quot;ck&quot;: {},
    &quot;cm&quot;: {},
    &quot;co&quot;: {},
    &quot;d&quot;: {},
    &quot;diy&quot;: {},
    &quot;e&quot;: {},
    &quot;f&quot;: {},
    &quot;fa&quot;: {},
    &quot;fit&quot;: {},
    &quot;g&quot;: {},
    &quot;gd&quot;: {},
    &quot;gif&quot;: {},
    &quot;h&quot;: {},
    &quot;hc&quot;: {},
    &quot;hm&quot;: {},
    &quot;his&quot;: {},
    &quot;hr&quot;: {},
    &quot;i&quot;: {},
    &quot;ic&quot;: {},
    &quot;int&quot;: {},
    &quot;jp&quot;: {},
    &quot;k&quot;: {},
    &quot;lgbt&quot;: {},
    &quot;lit&quot;: {},
    &quot;m&quot;: {},
    &quot;mlp&quot;: {},
    &quot;mu&quot;: {},
    &quot;n&quot;: {},
    &quot;news&quot;: {},
    &quot;o&quot;: {},
    &quot;out&quot;: {},
    &quot;p&quot;: {},
    &quot;po&quot;: {},
    &quot;pol&quot;: {},
    &quot;qa&quot;: {},
    &quot;qst&quot;: {},
    &quot;r&quot;: {},
    &quot;r9k&quot;: {},
    &quot;s&quot;: {},
    &quot;s4s&quot;: {},
    &quot;sci&quot;: {},
    &quot;soc&quot;: {},
    &quot;sp&quot;: {},
    &quot;t&quot;: {},
    &quot;tg&quot;: {},
    &quot;toy&quot;: {},
    &quot;trash&quot;: {},
    &quot;trv&quot;: {},
    &quot;tv&quot;: {},
    &quot;u&quot;: {},
    &quot;v&quot;: {},
    &quot;vg&quot;: {},
    &quot;vp&quot;: {},
    &quot;vr&quot;: {},
    &quot;w&quot;: {},
    &quot;wg&quot;: {},
    &quot;wsg&quot;: {},
    &quot;wsr&quot;: {},
    &quot;x&quot;: {},
    &quot;y&quot;: {}
  }
}}
###</pre>
== Start asagi (There is a better way to do this). ==

Maybe we should use systemd for it...

<pre>screen java -Xmx6144m -XX:+UseParNewGC -XX:MaxPermSize=512m -jar asagi.jar</pre>
Now, Configure asagi as the database and remove the table prefix from FoolFuuka

== Add boards, Configure Sphinx ==

http://IP/admin &gt; Search &gt; Generate Config.

Copy config out of FF and add your MySQL database information. Paste this to /etc/sphinxsearch/sphinx.conf

Build the indexes

<pre>sudo indexer 3_ancient a_ancient aco_ancient adv_ancient an_ancient asp_ancient b_ancient biz_ancient c_ancient cgl_ancient ck_ancient cm_ancient co_ancient d_ancient diy_ancient e_ancient f_ancient fa_ancient fit_ancient g_ancient gd_ancient gif_ancient h_ancient hc_ancient hm_ancient his_ancient hr_ancient i_ancient ic_ancient int_ancient jp_ancient k_ancient lgbt_ancient lit_ancient m_ancient mlp_ancient mu_ancient n_ancient news_ancient o_ancient out_ancient p_ancient po_ancient pol_ancient qa_ancient qst_ancient r_ancient r9k_ancient s_ancient s4s_ancient sci_ancient soc_ancient sp_ancient t_ancient tg_ancient toy_ancient trash_ancient trv_ancient tv_ancient u_ancient v_ancient vg_ancient vp_ancient vr_ancient w_ancient wg_ancient wsg_ancient wsr_ancient x_ancient y_ancient --rotate</pre>
<pre>sudo indexer 3_main a_main aco_main adv_main an_main asp_main b_main biz_main c_main cgl_main ck_main cm_main co_main d_main diy_main e_main f_main fa_main fit_main g_main gd_main gif_main h_main hc_main hm_main his_main hr_main i_main ic_main int_main jp_main k_main lgbt_main lit_main m_main mlp_main mu_main n_main news_main o_main out_main p_main po_main pol_main qa_main qst_main r_main r9k_main s_main s4s_main sci_main soc_main sp_main t_main tg_main toy_main trash_main trv_main tv_main u_main v_main vg_main vp_main vr_main w_main wg_main wsg_main wsr_main x_main y_main --rotate</pre>
Configure Crontab

<pre>  */3  * * * * indexer 3_delta a_delta aco_delta adv_delta an_delta asp_delta b_delta biz_delta c_delta cgl_delta ck_delta cm_delta co_delta d_delta diy_delta e_delta f_delta fa_delta fit_delta g_delta gd_delta gif_delta h_delta hc_delta hm_delta his_delta hr_delta i_delta ic_delta int_delta jp_delta k_delta lgbt_delta lit_delta m_delta mlp_delta mu_delta n_delta news_delta o_delta out_delta p_delta po_delta pol_delta qa_delta qst_delta r_delta r9k_delta s_delta s4s_delta sci_delta soc_delta sp_delta t_delta tg_delta toy_delta trash_delta trv_delta tv_delta u_delta v_delta vg_delta vp_delta vr_delta w_delta wg_delta wsg_delta wsr_delta x_delta y_delta --rotate --quiet
  0 */6 * * * indexer 3_main a_main aco_main adv_main an_main asp_main b_main biz_main c_main cgl_main ck_main cm_main co_main d_main diy_main e_main f_main fa_main fit_main g_main gd_main gif_main h_main hc_main hm_main his_main hr_main i_main ic_main int_main jp_main k_main lgbt_main lit_main m_main mlp_main mu_main n_main news_main o_main out_main p_main po_main pol_main qa_main qst_main r_main r9k_main s_main s4s_main sci_main soc_main sp_main t_main tg_main toy_main trash_main trv_main tv_main u_main v_main vg_main vp_main vr_main w_main wg_main wsg_main wsr_main x_main y_main --rotate --quiet</pre>