Install Discourse on Vultr and import from Kunena3

This guide shows how I was able to setup discourse and import 10.000+ users and 38.000+ posts from kunena.

I was running an outdated Joomla! 2.5.28 version with kunena 3.0.8 on top and it was hacked. Therefore I was looking for a new solution for my site. I knew discourse from another forum I use as a visitor, not as an owner. For me, without other skills than basic SSH and unix skills, I found it very hard to install and import. I’m a medical doctor, a GP, not a programmer… I have spent a week of my spare time of trial and error as I knew nothing about docker at all. I still don’t, but it seems like my board is running now :slight_smile: !

First I did setup a new server at vultr.com I chose the 5dollars 1 cpu, 1gb memory, 25gb ssd solution. I did choose Ubuntu 17.10 x64 (64 bit OS) as the OS

I made a local SSH key and added it to the server during the setup.

Then I connected to my new server

ssh root@serverip

First I did get the latest Ubuntu updates for the version

sudo apt-get update 
sudo apt-get upgrade

Then I installed docker
I did use this guide to install docker: discourse/docs/INSTALL-cloud.md at main · discourse/discourse · GitHub

wget -qO- https://get.docker.com/ | sh

Then the install of discourse

sudo -s
mkdir /var/discourse
git clone https://github.com/discourse/discourse_docker.git /var/discourse
cd /var/discourse

And then run the setup. I use elasticemail as a smtp host.

./discourse-setup

Discourse settings

In Admin >> Settings change the following

  • download remote images to local → enable
  • download remote images max days old → 10000
  • slug_generation_method → ascii
  • disable edit notifications → enable

After I have finished my setup via the email activation I got my vanilla board up running. :slight_smile: It was time for a reboot

reboot

Now the database fun

Entering the docker container called app. And that was a step I missed in the beginning. You have to enter the container to see the import scripts, oooh. Newbie I am.

cd /var/discourse
./launcher enter app

First it have to be up to date

sudo apt-get update
sudo apt-get upgrade

Let us install the software needed in the container

sudo apt-get install mariadb-server libmysqlclient-dev nano

Test if mysql is available

mysql

If you get this error

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2 “No such file or directory”)

Run this tutorial. After this is done try the mysql command again. If it works you are ready for the next step.

sudo gem install mysql2
echo "gem 'mysql2', require: false" >> /var/www/discourse/Gemfile
cd /var/www/discourse
su discourse -c 'bundle install --no-deployment --without test --without development'

And you get a error like this:_ sudo: no tty present and no askpass program specified_
Now run:

bundle install

Connect to the database

mysql -u root -p

CREATE USER 'kunena'@'localhost' IDENTIFIED BY 'kunena';
CREATE DATABASE kunena;
GRANT ALL PRIVILEGES ON kunena . * TO 'kunena'@'localhost';
FLUSH PRIVILEGES;
Exit

To ensure that the database is created login to the database with the new user: kunena and password kunena:

mysql -u kunena -pkunena

If you want to show the table status

show table status from kunena;

If you want to see the databases the user kunena got access to

show databases;

Import the old Joomla/kunena database

First I did clean up my old forum. I did ensure I only had a 1 level structure (so NO subforms).

Forum 1 Forum 2 ….
I had to rename the tabels prefix to “jos_” even then the script let you edit the prefix - but I was getting some error.
I did export using phpmyadmin and did exported kunena and standart Joomla tables only.

Upload file to server

Upload your file to root in your server using the password you find in the vult server manager and port 22

Restart your shell to connect to your servers root and not being inside your docker app.
To be able to to see the file in the app directory you have to copy the file inside the app dir.

docker cp databasefilename.sql app:/var/www/discourse/databasename.sql

Start the app container

cd /var/discourse
./launcher enter app
ls -ls  

Do you see the file on the list of files? I hope so!

Import the sql file into the new database

First you have to set the right owner of the file

chown discourse:discourse databasename.sql

Now import the sql file to the kunena database using the kunena user and password

mysql -ukunena -pkunena kunena < databasename.sql

Let us ensure the database isn’t empty. If you see rows it worked :slight_smile:

mysql -u kunena -pkunena
show table status from kunena;
exit

Edit the import script

We need nano to be able to edit files. If you didn’t install nano earlier, do it now

sudo apt-get install nano

Now we can edit the import script file

sudo nano script/import_scripts/kunena3.rb 

like so

export DB_HOST="localhost"
export DB_NAME="kunena"
export DB_USER="kunena"
export DB_PW="kunena"
export KUNENA_PREFIX=“jos_” # "iff_" sometimes
export IMAGE_PREFIX="http://URL/media/kunena/attachments"
export PARENT_FIELD="parent_id" 

Go to your old server and chmod 777 the “media/kunena/attachments” folder.

Back in your vultr server. And inside the app container we need the screen script to be installed before we run the import script. In my case it took 5 hours to run.

sudo apt-get install screen

Open Screen

screen

Brew some coffee and then In the screen window

su discourse -c 'RAILS_ENV=production ruby script/import_scripts/kunena3.rb'

Then the show begins…

loading existing groups...
loading existing users...
loading existing categories...
loading existing posts...
loading existing topics...
fetching Joomla users data from mysql
fetching Kunena user data from mysql
creating users
        8 / 8 (100.0%)  %)
creating topics and posts
    38888 / 38888 (100.0%)  [196 items/min]
updating bumped_at on topics
updating last posted at on users
updating last seen at on users
Updating topic reply counts...
    10625 / 10623 (100.0%)  [8242 items/min]  .Updating first_post_created_at...
Updating user post_count...
Updating user topic_count...
updating featured topic users
    15723 / 15723 (100.0%)
updating featured topics in categories
       12 / 12 (100.0%)
updating user topic reply counts
    10623 / 10623 (100.0%)
resetting topic counters
    15723 / 15723 (100.0%)
Done (04h 27min 25sec)

When it is done you can remove the packages we don’t want to use… I hope this little guide will save you time!

9 Likes