Ubuntu

Solusi Ubuntu 16.04 LTS mariadb-server-10.0 is not configured yet

Last Updated on 17 April 2017 By tommy Leave a Comment

Log dari apt-get install mariadb-server atau apt-get install -f

Setting up mariadb-server-10.0 (10.0.29-0ubuntu0.16.04.1) …
dpkg: error processing package mariadb-server-10.0 (–configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mariadb-server:
mariadb-server depends on mariadb-server-10.0 (>= 10.0.29-0ubuntu0.16.04.1); however:
Package mariadb-server-10.0 is not configured yet.

dpkg: error processing package mariadb-server (–configure):
dependency problems – leaving unconfigured
No apport report written because the error message indicates it’s a follow-up error from a previous failure.
Errors were encountered while processing:
mariadb-server-10.0
mariadb-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Log error dari journalctl -u mysql

— Logs begin at Mon 2017-04-17 10:59:21 WIB, end at Mon 2017-04-17 11:12:03 WIB. —
Apr 17 10:59:28 librenms systemd[1]: Starting LSB: Start and stop the mysql database server daemon…
Apr 17 10:59:30 librenms mysql[1086]: * Starting MariaDB database server mysqld
Apr 17 10:59:33 librenms mysql[1086]: cat: /var/run/mysqld/mysqld.pid: No such file or directory
Apr 17 10:59:33 librenms mysql[1086]: …fail!
Apr 17 10:59:33 librenms systemd[1]: mysql.service: Control process exited, code=exited status=1
Apr 17 10:59:33 librenms systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Apr 17 10:59:33 librenms systemd[1]: mysql.service: Unit entered failed state.
Apr 17 10:59:33 librenms systemd[1]: mysql.service: Failed with result ‘exit-code’.
Apr 17 11:00:49 librenms systemd[1]: Stopped LSB: Start and stop the mysql database server daemon.
Apr 17 11:08:06 librenms systemd[1]: Stopped LSB: Start and stop the mysql database server daemon.
Apr 17 11:09:56 librenms systemd[1]: Stopped LSB: Start and stop the mysql database server daemon.

Solusi

1. Backup database

cp -r /var/lib/mysql /tmp/

2. Hapus Direktori Data MariaDB

rm -fr /var/lib/mysql

3. Install MariaDB Server

apt-get install mariadb-server mariadb-client

4. Restore Database

cp -r /tmp/mysql /var/lib/

5. Ubah Permission Folder Data MariaDB

chown mysql:mysql /var/lib/mysql -R

6. Jalankan MariaDB Server

service mysql start

Debian apt Resource temporarily unavailable

Last Updated on 29 September 2016 By tommy Leave a Comment

Berikut ini log waktu install/upgrade dengan apt-get

The following packages will be upgraded:
  automake base-files bind9-host dnsutils e2fslibs e2fsprogs gnupg gpgv
  libbind9-90 libc-bin libc-dev-bin libc6 libc6-dev libcomerr2
  libdns-export100 libdns100 libirs-export91 libisc-export95 libisc95
  libisccc90 libisccfg-export90 libisccfg90 liblwres90 libmysqlclient18
  libpam-systemd libpython2.7-minimal libpython2.7-stdlib libsqlite3-0 libss2
  libssl-dev libssl1.0.0 libsystemd0 libudev1 libxml2 locales
  multiarch-support mysql-common openssl python2.7 python2.7-minimal systemd
  systemd-sysv udev wget wpasupplicant
45 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
E: Could not get lock /var/cache/apt/archives/lock - open (11: Resource temporarily unavailable)
E: Unable to lock directory /var/cache/apt/archives/
root@orangepipcplus:~# apt-get clean all
E: Could not get lock /var/cache/apt/archives/lock - open (11: Resource temporarily unavailable)
E: Unable to lock the download directory</blockquote>

Solusi

Solusi adalah menghapus file dibawah ini

rm -f /var/lib/dpkg/lock
rm -fr /var/cache/apt/archives/lock

lalu update file cache apt-get

apt-get update; apt-get upgrade -y

Install Mega Sync Client Linux

Last Updated on 17 September 2014 By tommy Leave a Comment

Mega memberikan space gratis sebesar 50 GB, jauh lebih besar dibandingkan pesaingnya Google Drive, Dropbox, Box ataupun OneDrive. Salah satu kelebihannya adalah tersedianya sync client untuk Linux ;). Disini akan saya jelaskan cara instalasi Mega Sync di Debian, Fedora dan Ubuntu.
Debian

## 64 Bit
https://mega.co.nz/linux/MEGAsync/Debian_7.0/amd64/megasync-Debian_7.0_amd64.deb
## 32 Bit
https://mega.co.nz/linux/MEGAsync/Debian_7.0/i386/megasync-Debian_7.0_i386.deb

cara install-nya

sudo dpkg -i megasync-Debian_7.0_i386.deb 
atau 
sudo dpkg -i megasync-Debian_7.0_amd64.deb

Fedora 20

## 64 Bit
https://mega.co.nz/linux/MEGAsync/Fedora_20/x86_64/megasync-Fedora_20.x86_64.rpm
## 32 Bit
https://mega.co.nz/linux/MEGAsync/Fedora_20/i686/megasync-Fedora_20.i686.rpm

cara install Mega Sync di Fedora 20, baik untuk 64 atau 32 bit

yum localinstall megasync-Fedora_20*.rpm

Ubuntu 14.04

## 64 Bit
https://mega.co.nz/linux/MEGAsync/xUbuntu_14.04/amd64/megasync-xUbuntu_14.04_amd64.deb
## 32 Bit
https://mega.co.nz/linux/MEGAsync/xUbuntu_14.04/i386/megasync-xUbuntu_14.04_i386.deb

cara install Mega Sync di Ubuntu 14.04

sudo dpkg -i megasync-xUbuntu_14.04_amd64.deb
atau 
sudo dpkg -i megasync-xUbuntu_14.04_i386.deb

Install Ampache Ubuntu 14.04

Last Updated on 7 August 2014 By tommy 2 Comments

Berikut ini adalah tutorial cara instalasi Ampache di Ubuntu 14.04.
Install Apache, PHP dan MySQL

apt-get install apache2 php5 php5-mysql php5-curl mysql-server mysql-client

Install unzip untuk mengekstrak file .zip

apt-get install unzip

Download Ampache

wget https://github.com/ampache/ampache/archive/3.7.0.zip

ekstrak, lalu pindahkan ke /var/www/html (root apache di Ubuntu)

unzip 3.7.0.zip
mv ampache-3.7.0/ /var/www/html/ampache

ubah permission folder config di /var/www/html/ampache agar bisa diakses oleh Apache

chmod 777 /var/www/html/ampache/config -R
chown www-data:www-data -R /var/www/html/ampache

buka alamat IP/ampache atau localhost/ampache

klik Start Configuration
Di halaman Requirements pastikan semua Status OK. Bila masih ada berwarna merah, lihat tahapan instalasi diatas bisa saja ada yang tertinggal.

Klik Continue

Tahap selanjutnya Insert Ampache Database disini yang perlu di isi hanya password untuk root MySQL, password sama dengan password yang dimasukkan sewaktu instalasi MySQL server.

Dibagian Generate Config File isi MySQL Username dan MySQL Password sama seperti tahap sebelumnya.

Scroll kebawah sampai bagian Files, klik Write, nanti muncul warna hijau (OK)

klik Continue to Step 3.

Di bagian Create Admin Account isikan password yang akan digunakan untuk login admin ampache, username juga bisa dirubah. Disini saya biarkan usernamenya admin.

Halaman selanjutnya Ampache Update, scroll kebawah klik tombol Update Now!. Setelah selesai sekarang buka halaman login Ampache IP/ampache/login.php

Instalasi dan Konfigurasi Squid Proxy di Ubuntu LTS 12.04

Last Updated on 25 March 2013 By tommy 3 Comments

Untuk pengguna Debian bisa melihat tutorial yang sama disini.

Proxy yang akan kita install ber-type Anonymouse jadi browser/ip address checker tidak akan mendeteksi (public) ip address anda yang asli. Tujuan saya untuk menulis tutorial ini bukan cara untuk melakukan tindakan-tindakan negative tetapi agar anda lebih aman sewaktu browsing di Internet dan dalam beberapa kasus bahkan gratis :).

Siapkan VPS/Server/Dedicated Server yang akan digunakan sebagai proxy server, login sebagai root (untuk pengguna Windows bisa menggunakan Putty). Setelah anda login sekarang update dan upgrade semua paket software yang ada di server anda, untuk memastikan anda menggunakan software-software terbaru.

su -c "apt-get clean all; apt-get update; apt-get upgrade"

Setelah upgrade selesai, install squid proxy

su -c "apt-get install squid apache2 nano"

di vps yang saya gunakan, squid yang terinstall adalah squid 3.1.19. Buka file konfigurasi squid yang berada di

su -c "nano /etc/squid3/squid.conf"

Dibawah

##auth_param basic children 5
##auth_param basic realm Squid proxy-caching web server
##auth_param basic credentialsttl 2 hours

tambahakan

auth_param basic program /usr/lib/squid3/ncsa_auth /etc/squid3/squid_passwd
auth_param basic children 5
auth_param basic realm Squid proxy-caching web server
auth_param basic credentialsttl 2 hours

sehingga menjadi

##auth_param basic children 5
##auth_param basic realm Squid proxy-caching web server
##auth_param basic credentialsttl 2 hours
auth_param basic program /usr/lib/squid3/ncsa_auth /etc/squid3/squid_passwd
auth_param basic children 5
auth_param basic realm Squid proxy-caching web server
auth_param basic credentialsttl 2 hours

cari kembali bagian yang memuat tulisan seperti dibawah ini

# 
# INSERT YOUR OWN RULE(S) HERE TO ALLOW ACCESS FROM YOUR CLIENTS
#

tambahkan dibawahnya

acl ncsaauth proxy_auth REQUIRED
http_access allow ncsaauth

sehingga menjadi

#
# INSERT YOUR OWN RULE(S) HERE TO ALLOW ACCESS FROM YOUR CLIENTS
#
acl ncsaauth proxy_auth REQUIRED
http_access allow ncsaauth

Dibaris paling bawah squid.conf tambahkan

header_access Allow allow all
header_access Authorization allow all
header_access WWW-Authenticate allow all
header_access Proxy-Authorization allow all
header_access Proxy-Authenticate allow all
header_access Cache-Control allow all
header_access Content-Encoding allow all
header_access Content-Length allow all
header_access Content-Type allow all
header_access Date allow all
header_access Expires allow all
header_access Host allow all
header_access If-Modified-Since allow all
header_access Last-Modified allow all
header_access Location allow all
header_access Pragma allow all
header_access Accept allow all
header_access Accept-Charset allow all
header_access Accept-Encoding allow all
header_access Accept-Language allow all
header_access Content-Language allow all
header_access Mime-Version allow all
header_access Retry-After allow all
header_access Title allow all
header_access Connection allow all
header_access Proxy-Connection allow all
header_access User-Agent allow all
header_access Cookie allow all
header_access All deny all

Proses konfigurasi sudah selesai, sekarang waktunya untuk menambahkan user yang bisa login ke proxy server. Buat file tempat menyimpan username dan password squid

touch /etc/squid3/squid_passwd

misalkan user yang mau kita tambahkan adalah user1 ketik perintah

htpasswd /etc/squid/squid_passwd user1

setelah perintah diatas dijalankan muncul tampilan

New password: 
Re-type new password: 
Adding password for user user1

yang menandakan bahwa user1 telah berhasil dibuat dan sekarang waktunya mencoba proxy ini. Port standart squid adalah 3128
Sebelum mulai menggunakan squid restart terlebih dahulu squid

service squid3 restart