Jumat, 01 April 2011

Driver canon IP 2770 untuk Linux

Driver canon IP 2770 untuk Linux

http://support-sg.canon-asia.com/contents/SG/EN/0100272402.html

ada 3 versi; rpm, deb & source

http://support-sg.canon-asia.com/contents/SG/EN/0100271602.html (iP2700 series IJ Printer Driver Ver. 3.30 for Linux (rpm Packagearchive))

http://support-sg.canon-asia.com/contents/SG/EN/0100272402.html (iP2700 series IJ Printer Driver Ver. 3.30 for Linux (debian Packagearchive) File name : cnijfilter-ip2700series-3.30-1-i386-deb.tar.gz )

http://support-sg.canon-asia.com/contents/SG/EN/0100272402.html (IJ Printer Driver Ver. 3.30 for Linux (Source file))

Cara installnya, setelah download. Masuk ke root, jalankan install.sh

root@hapsono-desktop:/home/setup/bagi/linux/cnijfilter-ip2700series-3.30-1-i386-deb# ls
install.sh packages resources
root@hapsono-desktop:/home/setup/bagi/linux/cnijfilter-ip2700series-3.30-1-i386-deb# ./install.sh
==================================================

Canon Inkjet Printer Driver Ver.3.30-1 for Linux
Copyright CANON INC. 2001-2010
All Rights Reserved.

==================================================
Command executed = sudo dpkg -iG ./packages/cnijfilter-common_3.30-1_i386.deb
Selecting previously deselected package cnijfilter-common.
(Reading database ... 123414 files and directories currently installed.)
Unpacking cnijfilter-common (from .../cnijfilter-common_3.30-1_i386.deb) ...
Setting up cnijfilter-common (3.30-1) ...

Processing triggers for libc6 ...
ldconfig deferred processing now taking place
Command executed = sudo dpkg -iG ./packages/cnijfilter-ip2700series_3.30-1_i386.deb
Selecting previously deselected package cnijfilter-ip2700series.
(Reading database ... 123430 files and directories currently installed.)
Unpacking cnijfilter-ip2700series (from .../cnijfilter-ip2700series_3.30-1_i386.deb) ...
Setting up cnijfilter-ip2700series (3.30-1) ...

Processing triggers for libc6 ...
ldconfig deferred processing now taking place

#=========================================================#
# Register Printer
#=========================================================#
Next, register the printer to the computer.
Connect the printer, and then turn on the power.
To use the printer on the network, connect the printer to the network.
When the printer is ready, press the Enter key.
>

Searching for printers...


#=========================================================#
# Select Printer
#=========================================================#
Select the printer.
If the printer you want to use is not listed, select Update [0] to search again.
To cancel the process, enter [Q].
-----------------------------------------------------------
0) Update
-----------------------------------------------------------
Target printers detected
1) Canon iP2700 series (/dev/usb/lp0)
-----------------------------------------------------------
Currently selected:[1] Canon iP2700 series (/dev/usb/lp0)
Enter the value. [1]

#=========================================================#
# Register Printer
#=========================================================#
Enter the printer name.[IP2700]
Command executed = sudo /usr/sbin/lpadmin -p IP2700 -m canonip2700.ppd -v cnijusb:/dev/usb/lp0 -E

#=========================================================#
# Set as Default Printer
#=========================================================#
Do you want to set this printer as the default printer?
Enter [y] for Yes or [n] for No.[y]y

#=========================================================#
Installation has been completed.
Printer Name : IP2700
Select this printer name for printing.
#=========================================================#
root@hapsono-desktop:/home/setup/bagi/linux/cnijfilter-ip2700series-3.30-1-i386-deb#

Saya pakai ubuntu 9.04 / jaunty...... tidak ada masalah untuk menjalankan file ini...
Selamat mencoba

Selasa, 01 Maret 2011

Pengenalan Database Mysql

Mysql merupakan database yang paling handal dikalangan pemrograman web, dengan alasan bahwa program ini merupakan database yang sangat kuat dan cukup stabil untuk digunakan sebagai media penyimpanan data.

Sebagai database server yang mampu untuk me-manajemen database dengan baik, MySQL terhitung merupakan database yang paling banyak digunakan dalam pemrograman web, dibandingkan dengan database yang lainnya, seperti Ms ACCESS.

Penggunaan MySQL sudah terintegrasi dengan paket Pemrograman web yakni PHP, karena dengan menggunakan kedua program ini program tersebut telah terbukti akan kehebatannya dalam memproses atau menangani permintaan data di dalam dunia internet.

Kemampuan lain yang dimiliki oleh MySQL adalah mampu mendukung Relational Database Manajemen System (RDBMS), sehingga dengan kemampuan ini MySQL mampu menangani relasional / hubungan antar field tabel yang dijdaikan primary key, serta mampu menangani data-data yang berukuran sangat besar hingga berukuran Giga Byte.

Untuk mendownload program MySQL kamu bisa mendownload nya disini http://www.mysql.com/ , yang bersifat free (gratis) dan kamu tidak usah takut akan berbayar lisensi nya.

Atau jika tidak mau pusing download saja xampp (versi win & linux) apache-mysql-php di http://www.apachefriends.org/en/xampp

eksport dan import database mysql

untuk mengeksport file database dari command line sintaks nya seperti ini

mysqldump -u root -p nama_database > drive:\nama file.sql;

kalau kita membuat database dengan nama latihan maka nama database nya latihan,

posisi untuk mengeksport menjadi file adalah

c:\appserv\mysql\bin

setelah itu tulis sintaks nya

c:\appserv\mysql\bin\mysqldump -u root -p latihan > c:\latihan.sql

maka kita telah mengekspor database di drive c dengan nama file latihan.sql yang bisa dibuka dengan menggunakan notepad.

untuk mengimport atau mengambil database yang sudah tercipta. kebalikan nya

mysql -u root -p nama database < drive\file.sql

untuk nama database kita ciptakan dulu pada koneksi mysql nya :

mysql>create database latihan;

lalu keluar dari koneksi database nya

mysql>\q
bye

c:\appserv\mysql\bin

lalu import lah database yang sudah tersimpan dari drive dan folder penyimpanan.

c:\appserv\mysql\bin\mysqldump -u root -p latihan

Basic Linux Commands

Basic Linux Commands

mkdir - make directories

Usage

mkdir [OPTION] DIRECTORY

Options

Create the DIRECTORY(ies), if they do not already exist.

Mandatory arguments to long options are mandatory for short options too.

-m, mode=MODE set permission mode (as in chmod), not rwxrwxrwx - umask

-p, parents no error if existing, make parent directories as needed

-v, verbose print a message for each created directory

-help display this help and exit

-version output version information and exit

cd - change directories

Use cd to change directories. Type cd followed by the name of a directory to access that directory.Keep in mind that you are always in a directory and can navigate to directories hierarchically above or below.

mv- change the name of a directory

Type mv followed by the current name of a directory and the new name of the directory.

Ex: mv testdir newnamedir

pwd - print working directory

will show you the full path to the directory you are currently in. This is very handy to use, especially when performing some of the other commands on this page

rmdir - Remove an existing directory

rm -r

Removes directories and files within the directories recursively.

chown - change file owner and group

Usage

chown [OPTION] OWNER[:[GROUP]] FILE

chown [OPTION] :GROUP FILE

chown [OPTION] --reference=RFILE FILE

Options

Change the owner and/or group of each FILE to OWNER and/or GROUP. With --reference, change the owner and group of each FILE to those of RFILE.

-c, changes like verbose but report only when a change is made

-dereference affect the referent of each symbolic link, rather than the symbolic link itself

-h, no-dereference affect each symbolic link instead of any referenced file (useful only on systems that can change the ownership of a symlink)

-from=CURRENT_OWNER:CURRENT_GROUP

change the owner and/or group of each file only if its current owner and/or group match those specified here. Either may be omitted, in which case a match is not required for the omitted attribute.

-no-preserve-root do not treat `/' specially (the default)

-preserve-root fail to operate recursively on `/'

-f, -silent, -quiet suppress most error messages

-reference=RFILE use RFILE's owner and group rather than the specifying OWNER:GROUP values

-R, -recursive operate on files and directories recursively

-v, -verbose output a diagnostic for every file processed

The following options modify how a hierarchy is traversed when the -R option is also specified. If more than one is specified, only the final one takes effect.

-H if a command line argument is a symbolic link to a directory, traverse it

-L traverse every symbolic link to a directory encountered

-P do not traverse any symbolic links (default)

chmod - change file access permissions

Usage

chmod [-r] permissions filenames

r Change the permission on files that are in the subdirectories of the directory that you are currently in. permission Specifies the rights that are being granted. Below is the different rights that you can grant in an alpha numeric format.filenames File or directory that you are associating the rights with Permissions

u - User who owns the file.

g - Group that owns the file.

o - Other.

a - All.

r - Read the file.

w - Write or edit the file.

x - Execute or run the file as a program.

Numeric Permissions:

CHMOD can also to attributed by using Numeric Permissions:

400 read by owner

040 read by group

004 read by anybody (other)

200 write by owner

020 write by group

002 write by anybody

100 execute by owner

010 execute by group

001 execute by anybody

ls - Short listing of directory contents

-a list hidden files

-d list the name of the current directory

-F show directories with a trailing '/'

executable files with a trailing '*'

-g show group ownership of file in long listing

-i print the inode number of each file

-l long listing giving details about files and directories

-R list all subdirectories encountered

-t sort by time modified instead of name

cp - Copy files

cp myfile yourfile

Copy the files "myfile" to the file "yourfile" in the current working directory. This command will create the file "yourfile" if it doesn't exist. It will normally overwrite it without warning if it exists.

cp -i myfile yourfile

With the "-i" option, if the file "yourfile" exists, you will be prompted before it is overwritten.

cp -i /data/myfile

Copy the file "/data/myfile" to the current working directory and name it "myfile". Prompt before overwriting the file.

cp -dpr srcdir destdir

Copy all files from the directory "srcdir" to the directory "destdir" preserving links (-poption), file attributes (-p option), and copy recursively (-r option). With these options, a directory and all it contents can be copied to another dir

ln - Creates a symbolic link to a file.

ln -s test symlink

Creates a symbolic link named symlink that points to the file test Typing "ls -i test symlink" will show the two files are different with different inodes. Typing "ls -l test symlink" will show that symlink points to the file test.

locate - A fast database driven file locator.

slocate -u

This command builds the slocate database. It will take several minutes to complete this command.This command must be used before searching for files, however cron runs this command periodically on most systems.locate whereis Lists all files whose names contain the string "whereis". directory.

more - Allows file contents or piped output to be sent to the screen one page at a time

less - Opposite of the more command

cat - Sends file contents to standard output. This is a way to list the contents of short files to the screen. It works well with piping.

whereis - Report all known instances of a command
wc - Print byte, word, and line counts

bg

bg jobs Places the current job (or, by using the alternative form, the specified jobs) in the background, suspending its execution so that a new user prompt appears immediately. Use the jobs command to discover the identities of background jobs.

cal month year - Prints a calendar for the specified month of the specified year.

cat files - Prints the contents of the specified files.

clear - Clears the terminal screen.

cmp file1 file2 - Compares two files, reporting all discrepancies. Similar to the diff command, though the output format differs.

diff file1 file2 - Compares two files, reporting all discrepancies. Similar to the cmp command, though the output format differs.

dmesg - Prints the messages resulting from the most recent system boot.

fg

fg jobs - Brings the current job (or the specified jobs) to the foreground.

file files - Determines and prints a description of the type of each specified file.

find path -name pattern -print

Searches the specified path for files with names matching the specified pattern (usually enclosed in single quotes) and prints their names. The find command has many other arguments and functions; see the online documentation.

finger users - Prints descriptions of the specified users.

free - Displays the amount of used and free system memory.

ftp hostname

Opens an FTP connection to the specified host, allowing files to be transferred. The FTP program provides subcommands for accomplishing file transfers; see the online documentation.

head files - Prints the first several lines of each specified file.

ispell files - Checks the spelling of the contents of the specified files.

kill process_ids

kill - signal process_ids

kill -l

Kills the specified processes, sends the specified processes the specified signal (given as a number or name), or prints a list of available signals.

killall program

killall - signal program

Kills all processes that are instances of the specified program or sends the specified signal to all processes that are instances of the specified program.

mail - Launches a simple mail client that permits sending and receiving email messages.

man title

man section title - Prints the specified man page.

ping host - Sends an echo request via TCP/IP to the specified host. A response confirms that the host is operational.

reboot - Reboots the system (requires root privileges).

shutdown minutes

shutdown -r minutes

Shuts down the system after the specified number of minutes elapses (requires root privileges). The -r option causes the system to be rebooted once it has shut down.

sleep time - Causes the command interpreter to pause for the specified number of seconds.

sort files - Sorts the specified files. The command has many useful arguments; see the online documentation.

split file - Splits a file into several smaller files. The command has many arguments; see the online documentation

sync - Completes all pending input/output operations (requires root privileges).

telnet host - Opens a login session on the specified host.

top - Prints a display of system processes that's continually updated until the user presses the q key.

traceroute host - Uses echo requests to determine and print a network path to the host.

uptime - Prints the system uptime.

w - Prints the current system users.

wall - Prints a message to each user except those who've disabled message reception. Type Ctrl-D to end the message.

20 Antivirus Terbaik di Dunia Versi Tahun 2010

Ini Dia, 20 Antivirus Terbaik di Dunia Versi Tahun 2010 [update 2011]

Di Bawah ini adalah daftar 20 antivirus terbaik serta cara penilaiannya versi
Toptenreview :

Spoiler for Peringkat tahun 2010:


1. BitDefender Antivirus : Ini Dia 10 Antivirus Terbaik 2010 Antivirus ini
mendapat rating excellent, wajar saja jika Toptenreviews.com menobatkannya
menjadi jawara.

2. Kaspersky Anti-Virus : Antivirus dengan Bintang Iklan "jacky Chan" ini ada di
posisi 2.

3. Webroot AntiVirus with SpySweeper : Jujur saya belum pernah dengar antivirus
yang satu ini, tapi Toptenreviews.com menempatkannya di posisi 3.

4. Norton AntiVirus : "Mbah" Norton sendiri ada di posisi 4 menggeser ESET Nod32
Antivirus

5. ESET Nod32 Antivirus : Antivirus ini tergeser ke posisi 5 setelah pada 2009
sebelumnya ada di posisi 4.

6. AVG Anti-Virus : Pasti familiar dengan antivirus ini kan? Yah...tapi sayang,
AVG harus turun 1 peringkat pada 2010 ini ke posisi 6.

7. F-Secure Anti-Virus : Setelah pada 2009 menempati posisi paling buncit di Top
Ten. Kini F-Secure Anti-Virus mengamankan posisi di peringkat 7.

8. G DATA AntiVirus : Ini merupakan pendatang baru di jajaran 10 besar antivirus
terbaik 2010. Tentunya posisi 8 cukup baik bagi Antivirus ini.

9. Avira AntiVir : Pada 2009 Avira sama sekali tidak masuk 10 besar, namun
sekarang ia kembali dan nongkrong di posisi 9.

10. Trend Micro : Trend Micro mengalami penurunan 2 peringkat ke posisi 10.

11. AVAST! Antivirus with Anti-Spyware

12. eScan AntiVirus Edition

13. McAfee VirusScan

14. ZoneAlarm Antivirus

15. CA Antivirus

16. Panda Antivirus

17. Vipre Antivirus + Antispyware

18. CyberDefender Early Detection Center

19. ParetoLogic Anti-Virus PLUS

20. Norman Antivirus & Antispyware


UPDATE awal 2011
==============
1. BitDefender Antivirus : Masih si jawara bertahan BitDefender memimpin di
peringkat 1.

2. Kaspersky Anti-Virus : Belum mampu menggoyahkan singgasana, tapi tetap stabil
di peringkat 2.

3. Webroot AntiVirus with SpySweeper : Antivirus yg masih asing di telinga ane,
juga bertahan di peringkat 3.

4. Norton AntiVirus : Setelah berhasil menggeser ESET Nod32 pada 2010, Norton
belum mampu menembus posisi 3 besar 2011.

5. ESET Nod32 Antivirus : Bertahan di posisi buncit TOP FIVE.

Sampai di posisi 5 besar belum ada perubahan peringkat. Kita lanjut ke posisi
selanjutnya.

6. AVG Anti-Virus : Antivirus ini juga masih di posisi yg sama pada 2010.

7. G DATA AntiVirus : Setelah menggebrak pada 2010 dengan menempati posisi 8,
pendatang baru ini kembali naik peringkat.

8. Avira AntiVir : Antivirus ini juga mampu naik 1 peringkat!

9. Vipre Antivirus : Ini dia antivirus baru yg menembus 10 besar, yg pada 2010
menduduki hanya peringkat 17.

10. Trend Micro : Penutup posisi 10 besar, masih di pegang oleh antivirus ini.

11. AVAST! Antivirus with Anti-Spyware

12. F-Secure Anti-Virus

13. eScan AntiVirus Edition

14. McAfee VirusScan

15. ZoneAlarm Antivirus

16. CA Antivirus

17. Panda Antivirus

18. Lavasoft Ad-Aware

19. CyberDefender Early Detection Center

20. ParetoLogic Anti-Virus PLUS



Jadi mana yang paling bagus..?

kami saja masih pakai symantec anti virus (khusus yang license, yg free kawan2 msh banyak yg milih smadav)

Cara membuat password root di Mysql

#mysql -u root -p (enter)
mysql>grant all on *.* to root@localhost identified by 'password-anda'; (enter)
mysql>\q

coba masuk lagi ke mySQL

#mysql -u root -p (enter)
saat menanyakan password masukkan password-anda (enter)
Pembuatan password mySQL sudah selesai

MySQL command line with XAMPP

mysql -u root

mysql>

dan ini sintak kode untuk memanajemen database mysql :

1. show databases; = melihat seluruh database yang sudah dibuat.

2. create database nama database; = membuat database baru dengan nama bebas.

3. use nama database; = menggunakan database yang dibuat untuk di manajemen.akan tampil database changed.

sintak kode memanajemen tabel database :

1. create table nama tabel(nama field type data(size) not null, primary key(field));
= kode ini sekalian membuat tabel beserta dengan nama field dan type data nya.
contoh :
mysql> create tabel contoh(
-> id int(5) not null auto_increment,
-> nama varchar(25) not null,
-> pesan text,
-> primary key(id));

2. describe nama tabel; = menampilkan struktur field tabel.
contoh :
mysql> describe contoh;

setelah membuat tabel, tabel di isi dengan record, berikut adalah sintak kode memanajemen pengisian record tabel.

1. insert into nama tabel(field)values('isi record'); = mengisi baris / record tabel.
contoh :
mysql> insert into contoh(nama, pesan) values('rais','tes saja'); (enter)

2. select * from nama tabel; = menampilkan seluruh isi baris/record tabel.
contoh :
mysql> select * from contoh; (enter) = maka seluruh isi record tabel di tampilkan.

3. Update nama tabel set field='record baru' where field='record';
untuk mengupdate / memperbaiki record dalam tabel.
contoh :
mysql> update contoh set pesan = 'boleh dah' where id='1'; (enter)
maka pesan yang tadi "tes saja" di ubah menjadi "boleh dah".

4. Delete from nama tabel where field='isi record'; (enter)
untuk menghapus record dalam tabel yang tidak dibutuhkan lagi.
contoh:
mysql> delete from contoh where id='1';
record dengan field id = 1 telah terhapus

5. Drop table nama tabel; = menghapus tabel yang tidak dibutuhkan lagi.
contoh :
mysql> drop table contoh; maka nama tabel contoh dalam database telah di hapus.