PC or Server with many application in front or back end process effect to be slowly performance. Linux have type of memory such as pagecache, inode and dentries. pagecache sometimes ambiguously called “disk cache”, is a “transparent” buffer of disk-backed… Read more ›
Pada dasarnya instalasi dan konfigurasi Squid Windows dan Linux. Kita hanya perlu download sumber Squid di site squid, dan mengekstraknya di drive dan folder yang kita inginkan (default c:\squid). Setelah kita ekstrak, gandakan dan ubah file squid.conf.default ==>squid.conf, mime.conf.default ==>… Read more ›
Kadang untuk minimalisasi bandwidth international yang kita gunakan linux memberikan kemudahan dari sisi repository linux, yaitu dengan menggunakan repository local dengan menggunakan createrepo, rsync, httpd dan crond. Createrepo adalah program untuk membuat sebuah repomd (xml-based rpm metadata) repository. Rsync adalah… Read more ›
Swap Partition Condition : My man has made mistake on CentOS Installation Check partition with human readable
|
1 2 3 4 5 6 7 8 |
root@WS01 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 29G 3.5G 24G 13% / /dev/sda5 28G 841M 26G 4% /var /dev/sda3 4.8G 138M 4.4G 4% /home /dev/sda1 99M 18M 76M 20% /boot /dev/sda6 4.0G 101M 3.9G 1% /swap tmpfs 2.9G 0 2.9G 0% /dev/shm |
“/swap” is not swap partition but swap folder partition Check partition mount
|
1 2 3 4 5 6 7 8 9 10 |
[root@WS01 ~]# cat /etc/fstab LABEL=/ / ext3 defaults 1 1 LABEL=/var /var ext3 defaults 1 2 LABEL=/home /home ext3 defaults 1 2 LABEL=/boot /boot ext3 defaults 1 2 LABEL=/swap /swap ext3 defaults 1 2 tmpfs /dev/shm tmpfs defaults 0 0 devpts /dev/pts devpts gid=5,mode=620 0 0 sysfs /sys sysfs defaults 0 0 proc /proc proc defaults 0 0 |
No swap partition/system Action : Delete /swap partition
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
[root@WS01 ~]# fdisk /dev/sda Command (m for help): p Disk /dev/sda: 71.9 GB, 71999422464 bytes 255 heads, 63 sectors/track, 8753 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 13 104391 83 Linux /dev/sda2 14 3837 30716280 83 Linux /dev/sda3 3838 4474 5116702+ 83 Linux /dev/sda4 4475 8753 34371067+ 5 Extended /dev/sda5 4985 8753 30274461 83 Linux /dev/sda6 4475 4984 4096543+ 83 Linux Command (m for help): d Partition number (1-6): 6 Command (m for help): w |
Time naming for Indonesia Zone time have 3 zone, here: WIT – West Indonesia (Standart) Time CIT – Central Indonesia (Standart) Time EIT – East Indonesia (Standart) Time Date in server:
|
1 2 |
[root@localhost ~]# date Tue May 18 00:10:05 UTC 2010 |
To be:
|
1 2 |
[root@localhost ~]# date Tue May 18 00:10:05 WIT 2010 |
Use file /etc/localtime to set… Read more ›
My Environment : OS : CentOS 5.7 Final Web Server : httpd-2.2.3-53 PHP : php53-5.3.3-1.el5_6.1 Programming Language : gcc Download package from php.net Download package dbase-5 from php.net
|
1 |
[root@compare] # wget http://pecl.php.net/get/dbase-5.0.1.tgz |
Extract package
|
1 |
[root@compare] # tar -zxvf dbase-5.0.1.tgz |
Prepare the build environment for a PHP extension… Read more ›
Make function for import dbase file to mysql database with perl
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
#!/usr/bin/perl # Program to load .DBF files into MySQL use DBI; use XBase; # Load .DBF files into MySQL $database = "database"; $user = "user"; $password = "password"; #$dbfpath = the directory of the .DBF files $dbfpath = "/web/globaldominion.net/data"; # Connect To MySQL $driver = "mysql"; $dsn = "DBI:$driver:database=$database"; $mysqldbh = DBI->connect($dsn, $user, $password); # Connect to DBF "database" $dbfdbh = DBI->connect("DBI:XBase:$dbfpath") or die $DBI::errstr; # Gather information from DBF files # table is the name of the .DBF file without the .DBF extention $file1 = $dbfdbh->prepare(q{SELECT * FROM table}) or die $dbfdbh->errstr(); $file1->execute() or die $file1->errstr(); # Load DBF data for file1 my $query = "DELETE FROM mysql_table"; #just clearing out the table if needed $mysqldbh->do($query) or die $mysqldbh->errstr(); #quick fix for " while (@dbf_table_rows = $file1->fetchrow()) { for ($i = 0; $i <= 15; $i++) { $dbf_table_rows[$i] =~ s/"/'/g; } #use a sprintf to format the SQL query for inserting into the MySQL table my $query = sprintf(q{INSERT INTO mysql_table VALUES ( "%s", "%s", "%s", %d, "%s", %d, "%s", "%s", %d, "%s", "%s", "%s", "%s", %d, "%s")}, @dbf_table_rows); $mysqldbh->do($query) or die print "$query\n"; } |
Make function for conversion in php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
function Terbilang($n) { $hasil = ""; $satuan = array("", "Satu", "Dua", "Tiga", "Empat", "Lima", "Enam", "Tujuh", "Delapan", "Sembilan", "Sepuluh", "Sebelas"); if ($n >= 0 && $n <= 11) { $hasil .= " " . $satuan[$n]; } elseif ($n >= 12 && $n <= 19) { $hasil .= Terbilang($n % 10) . " Belas"; } elseif ($n >= 20 && $n <= 99) { $hasil .= Terbilang(floor($n / 10)) . " Puluh" . Terbilang($n % 10); } elseif ($n >= 100 && $n <= 199) { $hasil .= " Seratus" . Terbilang($n - 100); } elseif ($n >= 200 && $n <= 999) { $hasil .= Terbilang(floor($n / 100)) . " Ratus" . Terbilang($n % 100); } elseif ($n > 1000 && $n <= 1999) { $hasil .= " Seribu" . Terbilang($n - 1000); } elseif ($n >= 2000 && $n <= 999999) { $hasil .= Terbilang(floor($n / 1000)) . " Ribu" . Terbilang($n % 1000); } elseif ($n >= 1000000 && $n <= 999999999) { $hasil .= Terbilang(floor($n / 1000000)) . " Juta" . Terbilang($n % 1000000); } else { $hasil .= Terbilang(floor($n / 1000000000)) . " Milyar" . Terbilang($n % 1000000000); } return $hasil; } |
Check partition with human readable
|
1 2 3 4 5 6 |
[root@proxy ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 93G 12G 77G 14% / /dev/sda1 99M 25M 70M 27% /boot tmpfs 1.5G 0 1.5G 0% /dev/shm |
Check partition with Partition table manipulator
|
1 2 3 4 5 6 7 8 9 |
[root@proxy ~]# fdisk -l Disk /dev/sda: 161.0 GB, 161061273600 bytes 255 heads, 63 sectors/track, 19581 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 13 104391 83 Linux /dev/sda2 14 13054 104751832+ 8e Linux LVM |
Create or add new partition
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
[root@proxy ~]# fdisk /dev/sda Command (m for help): p Disk /dev/sda: 161.0 GB, 161061273600 bytes 255 heads, 63 sectors/track, 19581 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 13 104391 83 Linux /dev/sda2 14 13054 104751832+ 8e Linux LVM Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 3 First cylinder (13055-19581, default 13055): Using default value 13055 Last cylinder or +size or +sizeM or +sizeK (13055-19581, default 19581): Using default value 19581 Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. WARNING: Re-reading the partition table failed with error 16: Device or resource busy. The kernel still uses the old table. The new table will be used at the next reboot. Syncing disks. |
Create system in new partition
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
[root@proxy ~]# /sbin/mkfs.ext3 -L /cache /dev/sda3 mke2fs 1.39 (29-May-2006) Filesystem label=/cache OS type: Linux Block size=4096 (log=2) Fragment size=4096 (log=2) 6553600 inodes, 13107031 blocks 655351 blocks (5.00%) reserved for the super user First data block=0 Maximum filesystem blocks=0 400 block groups 32768 blocks per group, 32768 fragments per group 16384 inodes per group Superblock backups stored on blocks: 32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208, 4096000, 7962624, 11239424 Writing inode tables: done Creating journal (32768 blocks): done Writing superblocks and filesystem accounting information: done This filesystem will be automatically checked every 24 mounts or 180 days, whichever comes first. Use tune2fs -c or -i to override. |
View result of partition
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
[root@proxy ~]# fdisk /dev/sda The number of cylinders for this disk is set to 19581. There is nothing wrong with that, but this is larger than 1024, and could in certain setups cause problems with: 1) software that runs at boot time (e.g., old versions of LILO) 2) booting and partitioning software from other OSs (e.g., DOS FDISK, OS/2 FDISK) Command (m for help): p Disk /dev/sda: 161.0 GB, 161061273600 bytes 255 heads, 63 sectors/track, 19581 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 13 104391 83 Linux /dev/sda2 14 13054 104751832+ 8e Linux LVM /dev/sda3 13055 19581 52428127+ 83 Linux |
Mounting partition to directory
|
1 2 3 |
[root@proxy ~]# mkdir /cache [root@proxy ~]# mount /dev/sda3 /cache [root@proxy ~]# mount -a |
Mounting partition as permanent from… Read more ›
How do I make /etc/fstab writable when in emergency mode
|
1 |
mount / -o remount,rw |
How to change your age on google account If you have entered your age wrongly while registering for ur account in Google and now want to change your age,… Read more ›