Tag Archives: linux

Linux Bash Console Sql Command

Published by:

Nah maksud saya sih, bagaimana menulis perintah dalam command line linux untuk menyisipkan sebuah atau banyak data ke dalam database sql.

Begini penampakan skrip yang saya tulis sambil membaca beberapa tutorial :

mysql -uusername -ppassword -e “USE mydatabase; INSERT INTO firsttable(id,value) VALUES(‘1′,’datasatu’);”

Dan tentunya perintah-perintah mysql lain bisa diterapkan disana, seperti UPDATE, DELETE, searching query dan sebagainya.

Mount Samba Server Bersama Backbox 5

Published by:

Kali ini yang dibahas kembali adalah Backbox versi 5. Yang merupakan operating system berplatform Ubuntu. Nah ceritanya Laptop HP yang saya pakai akan saya gunakan sebagai client. Karena data-data semua ada di server, maka saya perlu me-mount server seolah-olah menjadi drive lokal di laptop saya. Saya ketik perintah berikut di terminal.

sudo mount -t cifs -o username=user,pass=pass //192.168.x.x/mydata mydata

Tapi keluarlah error.

Setelah browsing sejenak, ternyata paket untuk me-mount tipe cifs belum ada di Backbox. Jadi install terlebih dulu library paket ini.

sudo apt-get install cifs-utils

Lalu ulangi perintah mount di atas. Dan selesai.

Zoneminder Filter Crash

Published by:

My filter won’t run. I wonder why, until today, I found out about the crash of the zmfilter.pl the command to execute the filter. After blogwalking a while I found out about the crash in Arc system. The solution is to create a file called /etc/timezone. The file must contain the location of the timezone. Mine is Asia/Jakarta.
I also do the forum said, I re-link the /etc/localtime to /usr/share/zoneinfo/Etc/GMT+7

Embed rtsp IP Camera to html Code

Published by:

source :

Code :

<!DOCTYPE html>
<title>Net Surveilance</title>
<embed type="application/x-vlc-plugin" pluginspage="http://www.videolan.org"
       id="vlc" />

<script type="text/javascript">
var vlc = document.getElementById("vlc");
var options = new Array(":aspect-ratio=4:3", ":rtsp-tcp");
var id = vlc.playlist.add("rtsp://", "fancy name", options);

<embed type="application/x-vlc-plugin" pluginspage="http://www.videolan.org"
       id="vlc2" />

<script type="text/javascript">
var vlc2 = document.getElementById("vlc2");
var options = new Array(":aspect-ratio=4:3", ":rtsp-tcp");
var id = vlc2.playlist.add("rtsp://", "fancy name", options);

<embed type="application/x-vlc-plugin" pluginspage="http://www.videolan.org"
       id="vlc3" />

<script type="text/javascript">
var vlc3 = document.getElementById("vlc3");
var options = new Array(":aspect-ratio=4:3", ":rtsp-tcp");
var id = vlc3.playlist.add("rtsp://", "fancy name", options);

<embed type="application/x-vlc-plugin" pluginspage="http://www.videolan.org"
       id="vlc4" />

<script type="text/javascript">
var vlc4 = document.getElementById("vlc4");
var options = new Array(":aspect-ratio=4:3", ":rtsp-tcp");
var id = vlc4.playlist.add("rtsp://", "fancy name", options);


The cctv in my example is located  in port 554 which is a standard port for rtsp protocol.

BackBox Linux Ubuntu 16.04 with sis671 VGA Chipset

Published by:

I had a broken hdd in my laptop 2 days ago. It made me to decide to find another hdd and install my Linux Backbox into it. Something made me worry, I forgot how to set the monitor to the appropriate setting. Then I had to browse the google once more. Here is what I looked for : sis671 driver for my 64bit Backbox.

I manage to find them. Cause I still keep those two in my own repo driver. I copy them to

#sudo cp sis671.la  /usr/lib/xorg/modules/driver
#sudo cp sis671.so  /usr/lib/xorg/modules/driver

Then Everything not goin right. I still have the 480×600 resolution. Then I went to grub setting at boot. I put vga=791 to force the display resolution up. It worked. But I didn’t satisfied, it should not be stop at 1024×768. Before this I manage to have 1280×768. Just I forgot how.

Then Googling again and find out about edid.bin. Actually just a blind guess, cause the source said it was used for nvida driver not my sis671. But what the hell. And sorry source, I forgot to write down your address. I tried to search you again in my history chrome but hell, that’s a lot of them so naaaaaaaa I’ll find you later.

According to the source I copied the edid.bin file to /root. Cause it goes to a reference in xorg.conf. And I also copied the xorg.conf but I modified myself cause it is not nvidia but sis. I will use sis671 driver that I copied earlier.


Here is my xorg.conf

Section “ServerLayout”
Identifier “Layout0”
Screen 0 “Screen0” 0 0
InputDevice “Keyboard0” “CoreKeyboard”
InputDevice “Mouse0” “CorePointer”

Section “Files”
RgbPath “/usr/X11R6/lib/X11/rgb”
FontPath “/usr/share/fonts/default/Type1”

Section “Module”
Load “dbe”
Load “extmod”
Load “type1”
Load “freetype”
Load “glx”

Section “ServerFlags”
Option “Xinerama” “0”

Section “InputDevice”
# generated from default
Identifier “Mouse0”
Driver “mouse”
Option “Protocol” “auto”
Option “Device” “/dev/psaux”
Option “Emulate3Buttons” “no”
Option “ZAxisMapping” “4 5”

Section “InputDevice”
# generated from default
Identifier “Keyboard0”
Driver “kbd”
option “AutoRepeat” “250 50”
option “CoreKeyboard”
option “XkbRules” “xorg”
option “XkbModel” “microsoftnek4k”
option “XkbOptions” “caps:internal_nocancel+lv3(switch)+compose(me nu)”

Section “Monitor”
# HorizSync source: xconfig, VertRefresh source: xconfig
Identifier “Monitor0”
VendorName “Unknown”
ModelName “DFP-0”
HorizSync 28.0 – 80
VertRefresh 43.0 – 120
#ModeLine “1440x900_60.00” 106.5 1440 1520 1672 1904 900 901 904 932 -hsync +vsync
Modeline “1280x768_60.00” 79.50 1280 1344 1472 1664 768 771 781 798 -hsync +vsync
Option “DPMS”

Section “Device”
Identifier “Videocard0”
Driver “sis671”
VendorName “”
BoardName “”

Section “Screen”
Identifier “Screen0”
Device “Videocard0”
Monitor “Monitor0”
DefaultDepth 24
Option “TwinView” “1”
Option “TwinViewXineramaInfoOrder” “DFP-0”
Option “metamodes” “DFP-0: 1440x900_60.00 +0+0, DFP-1: 1440x900_60.00 +1440+0”
Option “MonitorLayout” “TDMS”
Option “CustomEDID” “DFP-0:/root/edid.bin; DFP-1:/root/edid.bin”
SubSection “Display”
Depth 24

Then Reboot.

Oh pay attention to the modeline line in the xorg. I change the original one to my setting. The how to get the modeline is through this command.

#cvt 1280 768

The result will be like this :

# 1280×768 59.87 Hz (CVT) hsync: 47.78 kHz; pclk: 79.50 MHz
Modeline “1280x768_60.00” 79.50 1280 1344 1472 1664 768 771 781 798 -hsync +vsync

Copy and put the result into the xorg.conf. Then reboot again. And my laptop is fine now.

Oh just for the record, not for publishing reason, I didn’t get paid anyway from the manufacturer, I use Axioo Neon MNC 215p.

Backbox – Easy For Newbie As Me

Published by:

Backbox is one of the rar operating system people use. Especially regular people like me. This os is like Kali-Linux. An expert use it as a penetrating tools. Let’s say ethical hacker.. or something. The interfaces and everything is using ubuntu xenial based with lightdm desktop that very convenience to my notebook’s hardware.

Just like Kali, I have not use the penetrating tool yet. I have to learn it carefully though. Anyway this is a good experience, I set up a new goal for my computer expertise.

Kali – rolling Linux sound setting

Published by:

source : https://forums.kali.org/showthread.php?30815-No-sound-how-to-start-pulseaudio-on-startup

1. Turn on Kali Linux, open terminal and type in sudo killall pulseaudio and hit enter. Now type next.

sudo apt-get purge pulseaudio pulseaudio-utils gstreamer0.10-pulseaudio paman pavumeter pavucontrol

and again hit enter.
2. Continue typing and now type rm ~/ .pulse-cookie , after that type rm -r ~/ .pulse and after this type next.

sudo apt-get install alsa-base alsa-tools alsa-tools-gui alsa-utils alsa-oss alsamixergui libalsaplayer0

and at last type apt-get install kmix and hit enter.
3. And now restart machine.
4. OK now again open terminal and start typing on terminal and type next apt-get install pulseaudio and hit enter and and last type apt-get install gnome-core and again hit enter.
5. Restart machine.
Now you can see the result, all works great, problem solved

by deanMKD1

but in my case, I had to skip some step, like installed alsa-base, which was giving me the non exist message to me. The removing of the folder pulsa-cookie which was not exist.

The other is fine. They make my notebook sound alive.

configuring nfs server and mounting it

Published by:


NFS is one of the secure sharing system in linux. NFS is Network File System. It quite easy to setup, and more simple than samba.

portmap: ALL
lockd: ALL
rquotad: ALL
mountd: ALL
statd: ALL

chmod a+x /etc/rc.d/rc.nfsd
/etc/rc.d/rc.nfsd start

nano /etc/exports

$exportfs -r
that’s in server

this is in client
mount /home/me/computer1 -o nolock

Removing Zeitgeist Daemon from Ubuntu 12.04

Published by:

Zeitgeist is a service that control the user log.

From Wikipedia:

Zeitgeist is a service which logs the users’s activities and events, anywhere from files opened to websites visited and conversations. It makes this information readily available for other applications to use in form of timelines and statistics. It is able to establish relationships between items based on similarity and usage patterns by applying data association algorithms such as “Winepi” and “A Priori”

Zeitgeist is the main engine and logic behind GNOME Activity Journal which is currently seen to become one of the main means of viewing and managing activities in GNOME version 3.0

I think I want to try to ‘silent’ my laptop so I have no track. So I will uninstall it.

#root:/apt-get purge libzeitgeist-1.0-1 python-zeitgeist zeitgeist-core

Let’s see.