Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Nov 10, 2013

todo list install ubuntu 13.10 saucy salamander

Post install todo on ubuntu 13.10 saucy salamander.


my environment :

1. Ubuntu Desktop 13.10  64 bit

2. theme MAC

3. for development (python, ruby, perl)

apt source list local Indonesia

first : edit  on apt/sources.list
deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
deb ftp://ftp.itb.ac.id/pub/ubuntu saucy main restricted universe multiverse
deb ftp://ftp.itb.ac.id/pub/ubuntu saucy-updates main restricted universe multiverse
deb ftp://ftp.itb.ac.id/pub/ubuntu saucy-security main restricted universe multiverse
deb ftp://ftp.itb.ac.id/pub/ubuntu saucy-backports main restricted universe multiverse
deb ftp://ftp.itb.ac.id/pub/ubuntu saucy-proposed main restricted universe multiverse

install ffmpeg sound gstreamer flash ubuntu 13.10

second : basic installation

sudo apt-get update
sudo apt-get install unity-tweak-tool gnome-tweak-tool  libxine1-ffmpeg gxine mencoder mpeg2dec vorbis-tools id3v2 mpg321 mpg123 libflac++6 ffmpeg totem-mozilla icedax tagtool easytag id3tool lame nautilus-script-audio-convert libmad0 libjpeg-progs flac faac faad sox ffmpeg2theora libmpeg2-4 uudeview flac libmpeg3-1 mpeg3-utils mpegdemux liba52-0.7.4-dev libquicktime2  gstreamer0.10-ffmpeg gstreamer0.10-fluendo-mp3 gstreamer0.10-gnonlin gstreamer0.10-plugins-bad-multiverse gstreamer0.10-plugins-bad gstreamer0.10-plugins-ugly totem-plugins-extra gstreamer-dbus-media-service gstreamer-tools ubuntu-restricted-extras ttf-mscorefonts-installer libtiff4

install google chrome gedit-developer-plugin apache mysql ubuntu 13.10

sudo apt-get install chromium-browser chromium-browser-l10n gedit gedit-plugins gedit-developer-plugins compiz compizconfig-settings-manager compiz-plugins vim tomboy  tomboy apache2 mysql-server-5.5

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
  sudo apt-key add -
or you can install with ubuntu ppa
 sudo add-apt-repository ppa:pitti/postgresql  
sudo apt-get install postgresql-9.3 pgadmin3
sudo add-apt-repository ppa:sinzui/ppa
sudo apt-get update
sudo apt-get install gedit-developer-plugins

install mac theme ubuntu 13.10


third : Mac Theme

sudo add-apt-repository ppa:cairo-dock-team/ppa
sudo apt-get update
sudo apt-get install cairo-dock cairo-dock-plug-ins
gsettings set com.canonical.desktop.interface scrollbar-mode normal
wget -O launcher_bfb.png http://goo.gl/7AIQCA
sudo mv launcher_bfb.png /usr/share/unity/icons/
sudo add-apt-repository ppa:noobslab/themes
sudo apt-get update
sudo apt-get install mbuntu-bscreen-v2  mac-icons-v2-noobslab mac-ithemes-v2-noobslab
sudo sed -i "s/enabled=1/enabled=0/g" '/etc/default/apport'
sudo xhost +SI:localuser:lightdm
sudo su lightdm -s /bin/bash
gsettings set com.canonical.unity-greeter draw-grid false
sudo mv /usr/share/unity-greeter/logo.png /usr/share/unity-greeter/logo.png.backup
wget -O mac-fonts.zip http://goo.gl/b7CwYz
sudo unzip mac-fonts.zip -d /usr/share/fonts; rm mac-fonts.zip
sudo fc-cache -f -v

install desktop video recording ubuntu 13.10


forth : additional
sudo add-apt-repository ppa:kazam-team/unstable-series
sudo apt-get update
sudo apt-get install kazam gimp
Read more ...

Jun 4, 2011

Speed up your searching (in large data) by fulltext index and copy your youtube from tmp folder

Inspiring from my trouble in copying a video from youtube, then i get the solution. Linux only, the previous version (flash 9, with karmic or lusty) it can be copy the the video directly from /tmp, but in flash 10 with mavric its disappear. so use my trick or downgrade your flash.

Basic concept for this trick is searching for PID of process then grep-ing the stream in directed to a file, the result is un-extension files, but it can be played on totem or other audio player. Just run it on console, go to /tmp, then copy your video that has been watched. .. :D





1. Copy your video in /tmp
for i in $(pgrep -f libflashplayer.so); do ls -l /proc/$i/fd/* | grep '/tmp/Flash' | grep -o "/proc/$i/fd/\\S*" | xargs cp -t /tmp/  ; done

A lady asking me for some hadith which is difficult to get the original source, i just remember on my brain while my hadith source is to large to be traced with common searching such as "LIKE" or "%" or RLIKE, then i make a new indexing with new methods, FULLTEXT Index. It can be faster then.


2. Speed up your searching (in large data) by fulltext index
create FULLTEXT INDEX fullbukhori on had_bukhari(isi_arab, isi_indonesia, isi_arab_gundul);
set global key_buffer_size = 600*1024*1024;
load index into cache had_bukhari index(fullbukhori);

SELECT *, MATCH(isi_arab, isi_indonesia, isi_arab_gundul) AGAINST ('tenang') AS score
        FROM `had_bukhari`
        WHERE  MATCH(isi_arab, isi_indonesia, isi_arab_gundul) AGAINST ('+diri+tenang');

SELECT *, MATCH(isi_arab, isi_indonesia, isi_arab_gundul) AGAINST ('سكينة') AS score
        FROM `had_bukhari`
        WHERE  MATCH(isi_arab, isi_indonesia, isi_arab_gundul) AGAINST ('سكينة');
Read more ...

Oct 29, 2010

Integrated Server

Alhamdulillah thanks for Alloh who has given His mercy to us till now. And also for people who support this project, beginning from our study club students which are keep struggle to realize our goals.

Designing this project has been imagined for along time. The real implementation of ICT for our school, which is become very large community and number of services that must be served. We was studied about amount of network, Linux operating system, wireless technology and also the real cases of ours here. Implementing our knowledge has begin, since we got high speed internet access.

The concept of this project is giving good serving actually on internet access with no breaking the religion rules. Some special configurations are needed to prevent users access prohibited sites.

All software that used on this project are open source. The configurations of this AAA server are customized for SMA Budi Utomo  only. Due to some features of Radius Server cannot run properly, we made some special scripts to handle many cases which not handled by AAA.

We setting up this for project with high-end technology to make it still applicable  for next expansion of ICT. For next step, we can merged such as SIPS (Voip Server), freeNAS (open source NAS implementation) , Kannel (GSM messaging system) to our existing server.

Next urgently needed is develop private website and micro-blog to support some features and also empower human resource in using ICT for teaching. Facing global growth of technology, especially to make micro-blog and private websites, our student and also teacher must familiar to our new system. Some features has been enabled to improve them, such as private samba file server with net-bios login for each teacher 1 Giga Byte quota.

We know that its not too prefect, sometimes we found any vulnerabilities of our system, especially in filtering many words related to porn term and many others. We try to make it best, but we need support from all users to give many suggestions to improve our system together.

check my ppt on  : http://www.slideshare.net/febru/integrated-server
Read more ...