Redmine Installation Problems in Ubuntu 18.04.03

Problems encountered while installing Redmine 3.4.4 in Ubuntu 18.04.03

PROBLEM #1 Cannot Build SQLite3

# gem update
Updating installed gems
Updating sqlite3
Building native extensions. This could take a while...
ERROR: Error installing sqlite3:
ERROR: Failed to build gem native extension.

current directory: /var/lib/gems/2.5.0/gems/sqlite3-1.4.1/ext/sqlite3
/usr/bin/ruby2.5 -r ./siteconf20190813-10918-113tafq.rb extconf.rb
checking for sqlite3.h... no
sqlite3.h is missing. Try 'brew install sqlite3',
'yum install sqlite-devel' or 'apt-get install libsqlite3-dev'
and check your shared library search path (the
location where your sqlite3 shared library is located).
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers. Check the mkmf.log file for more details. You may
need configuration options.

Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=${opt-dir}/include
--with-opt-lib
--without-opt-lib=${opt-dir}/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=/usr/bin/$(RUBY_BASE_NAME)2.5
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-config
--without-sqlite3-config
--with-pkg-config
--without-pkg-config
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-dir
--without-sqlite3-dir
--with-sqlite3-include
--without-sqlite3-include=${sqlite3-dir}/include
--with-sqlite3-lib
--without-sqlite3-lib=${sqlite3-dir}/lib

To see why this extension failed to compile, please check the mkmf.log which can be found here:

/var/lib/gems/2.5.0/extensions/x86_64-linux/2.5.0/sqlite3-1.4.1/mkmf.log

extconf failed, exit code 1

Gem files will remain installed in /var/lib/gems/2.5.0/gems/sqlite3-1.4.1 for inspection.
Results logged to /var/lib/gems/2.5.0/extensions/x86_64-linux/2.5.0/sqlite3-1.4.1/gem_make.out
Updating web-console
ERROR: Error installing web-console:
Unresolved dependency found during sorting - activesupport (>= 4.2.0) (requested by rails-dom-testing-2.0.3)
Gems updated: sqlite3

SOLUTION: as suggested in the error message, just install libsqlite3-dev:

apt-get install libsqlite3-dev

PROBLEM #2: cannot update webconsole

# gem update
Updating installed gems
Updating web-console
ERROR: Error installing web-console:
Unresolved dependency found during sorting - activesupport (>= 4.2.0) (requested by rails-dom-testing-2.0.3)
Nothing to update

SOLUTION:
as in https://stackoverflow.com/questions/56084457/getting-error-when-installing-web-console

‘gem install -f web-console’

PROBLEM #3: Cannot bundle install

bundle install is needed to upgrade all gems to latest versions.

Problem:
> bundle install --without development test
Traceback (most recent call last):
1: from /usr/local/bin/bundle:23:in `<main>'
/usr/local/bin/bundle:23:in `load': cannot load such file -- /usr/share/rubygems-integration/all/gems/bundler-1.16.1/exe/bundle (LoadError)

Solution:

SOLUTION #1:

Ref: https://github.com/bundler/bundler/issues/6227
Just run:

gem update --system
gem uninstall bundler
gem install bundler
bundle install

this solution doesn’t not always work

SOLUTION #2: Use old bundler

https://www.redmine.org/issues/30353

gem install bundler -v 1.17.3 # Currently the latest bundler version < 2.0
bundle _1.17.3_ install

Instalasi Redmine 3.4.4-stable di Ubuntu 18.04.03

At the moment of writing this article, default installation in Ubuntu 18.04.03 will give you Redmine version 3.4.4.-stable

Installing Redmine 3.4.4-stable in 18.04.03
Use live server ISO (ubuntu-18.04.3-live-server-amd64.iso)

# reference: How to Install Redmine on Ubuntu step by stepapt-get update
apt-get upgrade

# install dependencies
apt install apache2 software-properties-common ruby-rmagick mysql-server mysql-client mysql-common ruby-dev build-essential libmysqlclient-dev libssl-dev gcc libmysqlclient-dev libapache2-mod-passenger libmagickcore-dev
apt install imagemagick-6.q16
apt-get install redmine redmine-mysql

# there may be questions from installer. Refer to Howto Install Redmine on Ubuntu www.redmine.org/projects/redmine/wiki/howto_install_redmine_on_ubuntu_step_by_step for explanation

# Next step is to upgrade all gems. It will take sometime to update all gems.

gem update

# possible error: connection problem.
# example erro message: Updating roadie
ERROR: Error installing roadie:
Unable to resolve dependency: user requested ‘roadie (= 3.5.0)’

gem install bundler

vi /etc/apache2/mods-available/passenger.conf

existing file:

<IfModule mod_passenger.c>
PassengerRoot /usr/lib/ruby/vendor_ruby/phusion_passenger/locations.ini
PassengerDefaultRuby /usr/bin/ruby
</IfModule>

Create symlink:

ln -s /usr/share/redmine/public /var/www/html/redmine

edit as follows:

<IfModule mod_passenger.c>
PassengerDefaultUser www-data
PassengerRoot /usr/lib/ruby/vendor_ruby/phusion_passenger/locations.ini
PassengerDefaultRuby /usr/bin/ruby
</IfModule>

edit file:

vi /etc/apache2/sites-available/000-default.conf

add the following lines:

<Directory /var/www/html/redmine>
RailsBaseURI /redmine
PassengerResolveSymlinksInDocumentRoot on
</Directory>

Create Gemlock file:

touch /usr/share/redmine/Gemfile.lock
chown www-data:www-data /usr/share/redmine/Gemfile.lock

service apache2 restart

browse to your website:

http://192.168.0.205/redmine/

with username: admin,
password: admin

You can check Redmine information in by following the menu : [Administration] -> [Information]

It will show something like this:

Default administrator account changed
Attachments directory writable
Plugin assets directory writable (./public/plugin_assets)
RMagick available (optional)
ImageMagick convert available (optional)

Environment:
Redmine version 3.4.4.stable
Ruby version 2.5.1-p57 (2018-03-29) [x86_64-linux-gnu]
Rails version 4.2.10
Environment production
Database adapter Mysql2
SCM:
Git 2.17.1
Filesystem
Redmine plugins:
no plugin installed

 

Redmine 3.4.4-stable

Instalasi Redmine 4.01 di Ubuntu 19.04

Prosedur instalasi Redmine di Ubuntu secara umum dapat dibaca di http://www.redmine.org/projects/redmine/wiki/howto_install_redmine_on_ubuntu_step_by_step , namun untuk setiap versi Ubuntu ada kemungkina perbedaan-perbedaan kecil.

Instalasi Aplikasi Pendukung

Berikut ini proses instalasi aplikasi pendukung Redmine:

apt-get update
apt-get remove cryptsetup-initramfs #optional, karena kadang-kadang kalau apt-get upgrade jadi macet di sini
apt-get upgrade
apt-get install apache2 software-properties-common ruby-rmagick mysql-server mysql-client mysql-common
apt-get install ruby-dev build-essential libmysqlclient-dev libssl-dev gcc libmysqlclient-dev
apt-get install libapache2-mod-passenger # untuk integrasi apache-passenger
apt-get install libmagickcore-dev # untuk rmagick , menghindari pesan “ERROR: Can’t install RMagick 4.0.0.” https://stackoverflow.com/questions/28324439/cant-install-rmagick-0-0-0-cant-find-magick-config
apt-get install redmine redmine-mysql
gem update
gem install bundler

Konfigurasi Apache

edit file /etc/apache2/mods-available/passenger.conf 

existing:

PassengerRoot /usr/lib/ruby/vendor_ruby/phusion_passenger/locations.ini PassengerDefaultRuby /usr/bin/ruby

ditambah “PassengerDefaultUser www-data” menjadi:

PassengerDefaultUser www-data
PassengerRoot /usr/lib/ruby/vendor_ruby/phusion_passenger/locations.ini PassengerDefaultRuby /usr/bin/ruby

tambahkan symlink:

ln -s /usr/share/redmine/public /var/www/html/redmine

edit file /etc/apache2/sites-available/000-default.conf , tambahkan sebagai berikut:

<Directory /var/www/html/redmine>
    RailsBaseURI /redmine
    PassengerResolveSymlinksInDocumentRoot on
</Directory>

Tambahkan file lock untuk Gemfile

touch /usr/share/redmine/Gemfile.lock
chown www-data:www-data /usr/share/redmine/Gemfile.lock

Restart Apache supaya konfigurasi dibaca ulang:

service apache2 restart

cek di browser:

ke alamat http://192.168.0.203/redmine

default username: admin, default password: admin
setelah login akan diminta untuk mengganti password

Pengecekan

Tampilan Administrator -> Information

Redmine 4.01 Information

 

Making Indonesia 4.0

Kumpulan artikel-artikel tentang “Making Indonesia 4.0”.

Making Indonesia 4.0

Dokumen Resmi Making Indonesia 4.0

Artikel Berita tentang Making Indonesia 4.0

Siaran Pers Bersama Terkait Bencana Selat Sunda

Berikut ini siaran pers bersama, yang nampaknya pengumuman resmi paling lengkap sejauh ini tentang bencana tsunami di Selat Sunda.

Siaran Pers Bersama dari lembaga-lembaga berikut:

  • Badan Informasi Geospasial (BIG) (https://twitter.com/InfoGeospasial)
  • Kementrian Koordinator Bidang Kemaritiman (https://twitter.com/kemaritiman)
  • Badan Pengkajian & Penerapan Teknologi (BPPT) (https://twitter.com/BPPT_RI)
  • BMKG (https://twitter.com/infoBMKG)
  • Lembaga Ilmu Pengetahuan Indonesia (LIPI) (https://twitter.com/lipiindonesia)
  • Badan Geologi
Halaman 1
Halaman 2
Lampiran 1
Lampiran

Sumber data ini adalah twitter dari BIG (Badan Informasi Geospasial) dalam format gambar JPG. Sejauh ini belum didapatkan versi PDF ataupun versi website.

Sumber:

Instalasi Eval AI di Ubuntu 17.10

Artikel ini adalah adaptasi dari prosedur instalasi di https://github.com/Cloud-CV/EvalAI

 

apt-get install openssh-server
apt-get install net-tools

Instalasi software dependencies:

apt-get install python2.7
apt-get install git
apt-get install postgresql

# Success. You can now start the database server using:
# /usr/lib/postgresql/9.6/bin/pg_ctl -D /var/lib/postgresql/9.6/main -l logfile start

apt-get install rabbitmq-server
apt-get install virtualenv
apt-get install python-psycopg2 (thanks to https://stackoverflow.com/questions/28253681/you-need-to-install-postgresql-server-dev-x-y-for-building-a-server-side-extensi)
apt-get install libpq-dev
apt-get install python-dev
apt-get install build-essential

# clone the EvalAI code

git clone https://github.com/Cloud-CV/EvalAI.git evalai

# Create a python virtual environment and install python dependencies.

cd evalai
virtualenv venv
source venv/bin/activate # run this command everytime before working on project
pip install -r requirements/dev.txt

Proses sampai tahap ini berhasil, selanjutnya masih perlu diujicoba:

cp settings/dev.sample.py settings/dev.py

Use your postgres username and password for fields USER and PASSWORD in dev.py file.

Create an empty postgres database and run database migration.

sudo -i -u (username)
createdb evalai
python manage.py migrate –settings=settings.dev

Seed the database with some fake data to work with.

python manage.py seed –settings=settings.dev

This command also creates a superuser(admin), a host user and a participant user with following credentials.

SUPERUSER- username: admin password: password
HOST USER- username: host password: password
PARTICIPANT USER- username: participant password: password

That’s it. Now you can run development server at http://127.0.0.1:8000 (for serving backend)

python manage.py runserver –settings=settings.dev

Open a new terminal window with node(6.9.2) and ruby(gem) installed on your machine and type

npm install

Install bower(1.8.0) globally by running:

npm install -g bower

Now install the bower dependencies by running:

bower install

If you running npm install behind a proxy server, use

npm config set proxy http://proxy:port

Now to connect to dev server at http://127.0.0.1:8888 (for serving frontend)

gulp dev:runserver

That’s it, Open web browser and hit the url http://127.0.0.1:8888.

(Optional) If you want to see the whole game into play, then start the RabbitMQ worker in a new terminal window using the following command that consumes the submissions done for every challenge:

python scripts/workers/submission_worker.py

 

Percobaan iNaturalist

Menghitung Bandwidth Fair Use Policy Indihome 2016

Pada tulisan ini akan dihitung berapa bandwidth yang dapat dipakai untuk paket 10 Mbps Indihome jika diaktifkan terus menerus pada kondisi ideal.

PT Telkom Indonesia menerapkan kebijakan Fair Use Policy (FUP) pada Indihome berikut ini mulai Februari 2016.

Fair Use Policy Indihome 2016
Tabel Fair Use Policy Indihome 2016

Asumsi:

  • Paket 10 Mbps
  • 1 bulan adalah 30 hari
  • Koneksi aktif download setiap saat hanya dibatasi kecepatan Indihome
  • B = byte, b = bit, 1 byte = 8 bit

Perhitungan:

Paket ini akan mengalami 3 macam kecepatan:

  • 10 Mbps ketika pemakaian <300 GB
  • 75% x 10 Mbps = 7.5 Mbps ketika pemakaian < 400 GB
  • 40% x 10 Mbps = 4. Mbps ketika pemakaian > 400 GB

Durasi kecepatan 10 Mbps adalah:

300 GB / 10 Mbps = 300 GB / 10 Mbps x 8 b/B = 240000 detik

Durasi kecepatan 7.5 Mbps adalah:

100 GB / 7.5 MBps = 100 GB / 7.5 Mbps x 8 b/B = 106666 detik

Durasi kecepatan  4 Mbps adalah:

30 hari – 240000 detik – 106666 detik = 30x24x60x60 – 240000 – 106666  = 2245333 detik

Berikut ini ringkasannya:

Kecepatan Durasi Total byte
segmen 1 10 Mbps 240000 detik 300 GB
segmen 2 7.5 Mbps 106666 detik 100 GB
segmen 3 4 Mbps 2245333 detik 1122,7 GB
Total 2592000 detik 1522.7 GB

Jadi total download selama 30 hari adalah 1522.7 GB , dengan kecepatan rata-rata adalah 433127 byte /s atau sekitar 3.46 Mbps

Referensi