<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>Mulyanto.Net</title>
	<atom:link href="http://mulyanto.net/?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://mulyanto.net</link>
	<description>Learning By Writting</description>
	<lastBuildDate>Wed, 04 Aug 2010 08:35:21 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0</generator>
		<item>
		<title>Program PASCAL : Boso Walikan Prokem Jogja</title>
		<link>http://mulyanto.net/?p=378</link>
		<comments>http://mulyanto.net/?p=378#comments</comments>
		<pubDate>Wed, 04 Aug 2010 08:29:11 +0000</pubDate>
		<dc:creator>mulyanto</dc:creator>
				<category><![CDATA[programming]]></category>
		<category><![CDATA[Pascal]]></category>

		<guid isPermaLink="false">http://mulyanto.net/?p=378</guid>
		<description><![CDATA[Mungkin banyak yang tau DAGADU tapi sedikit yang tau kalau artinya adalah MATAMU. Untuk kalangan anak jogja yang mengerti bahasa Slank atau bahasa gaulnya jogja. Untuk artikel tentang Boso Walikan bisa dilihat  disini dan buat yang seneng dan pengen gabung di FB bisa diliat disini program basawalikan; uses crt; const siji : array[1..10] of string[2] [...]]]></description>
			<content:encoded><![CDATA[<p>Mungkin banyak yang tau DAGADU tapi sedikit yang tau kalau artinya adalah MATAMU. Untuk kalangan anak jogja yang mengerti bahasa Slank atau bahasa gaulnya jogja.</p>
<p>Untuk artikel tentang Boso Walikan bisa dilihat  <a href="http://jengjeng.matriphe.com/bahasa-walikan-jogja.html">disini</a> dan buat yang seneng dan pengen gabung di FB bisa diliat <a href="http://www.facebook.com/group.php?gid=59326694320">disini</a></p>
<p style="padding-left: 60px;"><span style="color: #000080;">program basawalikan;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">uses crt;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">const</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">siji : array[1..10] of string[2] = (&#8216;h&#8217;,'n&#8217; ,&#8217;c',&#8217;r',&#8217;k&#8217; ,&#8217;d',&#8217;t',&#8217;s',&#8217;w&#8217; ,&#8217;l');</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">loro : array[1..10] of string[2] = (&#8216;p&#8217;,'dh&#8217;,'j&#8217;,'y&#8217;,'ny&#8217;,'m&#8217;,'g&#8217;,'b&#8217;,'th&#8217;,'ng&#8217;);</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">telu : array[1..9] of string[2] = (&#8216; &#8216;,&#8217;-',&#8217;!',&#8217;?',&#8217;a',&#8217;i',&#8217;u',&#8217;e',&#8217;o');</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">var i,j : integer;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp : string;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">kal,hasil : string;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">selesai : char;</span></p>
<p><span id="more-378"></span></p>
<p style="padding-left: 60px;"><span style="font-size: medium;"><span style="color: #000080;">begin</span></span><span style="font-size: medium;"><span style="color: #000080;"> </span></span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">clrscr;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">repeat</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">write(&#8216;Masukkan kata : &#8216;);</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">readln(kal);</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">i := 1;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">hasil :=&#8221;;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">while i &lt;= length(kal) do</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">begin</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp:=&#8221;;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">if kal[i] =&#8217;t&#8217; then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">begin</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">if kal[i+1] = &#8216;h&#8217; then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">begin</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp := kal[i] + kal[i+1];</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">i := i+1;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">end</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">else</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp:=kal[i];</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">end</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">else if kal[i] =&#8217;d&#8217; then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">begin</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">if kal[i+1] = &#8216;h&#8217; then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">begin</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp := kal[i] + kal[i+1];</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">i := i+1;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">end</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">else</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp:=kal[i];</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">end</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">else if kal[i] =&#8217;n&#8217; then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">begin</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">if kal[i+1] = &#8216;g&#8217; then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">begin</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp := kal[i] + kal[i+1];</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">i := i+1;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">end</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">else</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">if kal[i+1] = &#8216;y&#8217; then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">begin</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp := kal[i] + kal[i+1];</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">i := i+1;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">end</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">else</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp:=kal[i];</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">end</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">else if kal[i] = &#8216; &#8216; then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp :=&#8217; &#8216;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">else if kal[i] = &#8216;-&#8217; then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp :=&#8217;-&#8217;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">else</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">begin</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">tmp := kal[i];</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">end;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">for j:= 1 to 10 do</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">begin</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">{ writeln(j);</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">writeln(tmp);}</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">if tmp = telu[j] then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">hasil := hasil + telu[j]</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">else if tmp = siji[j] then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">hasil := hasil + loro[j]</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">else  if tmp = loro[j] then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">hasil := hasil + siji[j]</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">{ else if tmp = papat[j] then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">hasil := hasil + papat[j] }</span></p>
<p style="padding-left: 60px;"><span style="font-size: medium;"><span style="color: #000080;">end;</span></span><span style="font-size: medium;"><span style="color: #000080;"> </span></span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">{</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">* end;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">for j:= 1 to 3 do</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">begin</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">if tmp = loro[j] then</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">hasil := hasil + siji[j];</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">end;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">}</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">i:=1+i;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">end;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">writeln(hasil);</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">writeln;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">write(&#8216;Ulang lagi [Y/T] :&#8217;);</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">selesai:=Upcase(Readkey);</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">clrscr;</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">until (selesai=&#8217;T') or (selesai=&#8217;t');</span></p>
<p style="padding-left: 60px;"><span style="color: #000080;">end.</span></p>
<p><span style="color: #000080;"><br />
</span></p>
]]></content:encoded>
			<wfw:commentRss>http://mulyanto.net/?feed=rss2&amp;p=378</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>IDE Geany</title>
		<link>http://mulyanto.net/?p=365</link>
		<comments>http://mulyanto.net/?p=365#comments</comments>
		<pubDate>Wed, 28 Jul 2010 07:01:49 +0000</pubDate>
		<dc:creator>mulyanto</dc:creator>
				<category><![CDATA[mydays]]></category>

		<guid isPermaLink="false">http://mulyanto.net/?p=365</guid>
		<description><![CDATA[Ada rekomendasi buat Integrated Development Environment bagi teman-teman yang lagi cari2 IDE. Geany namanya, jalan bagus di Fedora core 12-ku, Tampilannya keren dus bisa nangani program apa aja. Fitur lainnya auto keywordnya yang keren. Buat yang suka pascal, install dulu free pascal for linux trus install Geanynya #yum install fpc #yum install geany Selamat mencoba]]></description>
			<content:encoded><![CDATA[<p>Ada rekomendasi buat Integrated Development Environment bagi teman-teman yang lagi cari2 IDE. Geany namanya, jalan bagus di Fedora core 12-ku, Tampilannya keren dus bisa nangani program apa aja. Fitur lainnya auto keywordnya yang keren.</p>
<p><img src="http://mulyanto.net/wp-content/uploads/2010/07/geany.jpeg" alt="Geany" width="454" height="227" /></p>
<p>Buat yang suka pascal, install dulu free pascal for linux trus install Geanynya</p>
<p style="padding-left: 30px;"><span style="color: #3366ff;">#yum install fpc</span></p>
<p><span style="color: #3366ff;"> #yum install geany</span></p>
<p>Selamat mencoba</p>
]]></content:encoded>
			<wfw:commentRss>http://mulyanto.net/?feed=rss2&amp;p=365</wfw:commentRss>
		<slash:comments>1</slash:comments>
		</item>
		<item>
		<title>PROCEDURE DAN TRIGGER MYSQL</title>
		<link>http://mulyanto.net/?p=343</link>
		<comments>http://mulyanto.net/?p=343#comments</comments>
		<pubDate>Tue, 13 Jul 2010 06:51:32 +0000</pubDate>
		<dc:creator>mulyanto</dc:creator>
				<category><![CDATA[MySQL]]></category>
		<category><![CDATA[database]]></category>

		<guid isPermaLink="false">http://mulyanto.net/?p=343</guid>
		<description><![CDATA[BERKENALAN DENGAN STORE PROCEDURE DAN TRIGGER Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data &#8211; MYSQL References Prosedur merupakan program yang ditulis dan dieksekusi langsung dari Engine database. Beberapa situasi [...]]]></description>
			<content:encoded><![CDATA[<p><strong>BERKENALAN DENGAN STORE PROCEDURE DAN TRIGGER</strong></p>
<p><em>Stored Procedures</em><em> which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data &#8211; </em>MYSQL References</p>
<p>Prosedur merupakan program yang ditulis dan dieksekusi langsung dari Engine database. Beberapa situasi dimana stored procedure sangat bermanfaat :</p>
<ol>
<li>Pada system yang didalamnya terdapat bermacam-macam platform bahasa pemrograman, akan tetapi proses yang terjadi pada database harus tetap memiliki standard yang sama.</li>
<li>Sistem dikerjakan pada lingkungan yang berbeda-beda dengan prioritas keamanan yang berbeda sehingga diperlukan pembatasan terhadap hak-hak penggunaan terhadap tabel-tabel tertentu.</li>
<li>Dengan adanya multi koneksi , maka dengan store procedure akan memberikan performa yang lebih baik karena proses interkoneksi dari luar server menjadi lebih sedikit.</li>
<li>Programmer gak perlu pusing melihat bertumpuk-tumpuk tabel karena hanya memakai prosedur yang sudah ada.</li>
</ol>
<p><span id="more-343"></span>Sedangkan trigger merupakan store procedure yang digunakan untuk memicu  perubahan pada suatu tabel sesuai dengan event yang  terjadi (insert, delete, update). Trigger dapat digunakan untuk memicu  proses terhadap tabel lain maupun tabel itu sendiri.</p>
<p>Manfaat dari trigger :</p>
<ol>
<li>Pada pemanfaatan program aplikasi multi platform, proses bisnis dari sistem dapat dibuat langsung dilakukan didatabase sehingga perbedaan interpretasi di  program aplikasi menjadi lebih diminimalisisr</li>
<li>Proses lebih cepat</li>
<li>Programmer  tinggal ongkang-ongkang kaki karena yang pusing DBAnya hehehehe..</li>
</ol>
<p>Contoh tabel dan sampel data untuk coba-coba trigger dan procedure</p>
<blockquote><p>CREATE TABLE jurusan (<br />
id CHAR(3),<br />
nama VARCHAR(50) NOT NULL,<br />
Constraint pk_jur primary key(id));</p>
<p>CREATE TABLE Mahasiswa (<br />
Nim CHAR(7),<br />
Nama VARCHAR(50) NOT NULL,<br />
Tgl_lahir DATE,<br />
Jn_Kelamin ENUM(&#8216;L&#8217;,'P&#8217;),<br />
jalan VARCHAR(50),<br />
Kota VARCHAR(20),<br />
jurusan varchar(3),<br />
constraint pk_mhs primary key(nim),<br />
constraint fk_mhs_jur foreign key(jurusan) references jurusan(id));</p>
<p>CREATE TABLE Dosen (<br />
Nip CHAR(5),<br />
Nama VARCHAR(50) NOT NULL,<br />
Tgl_lahir DATE,<br />
Jn_Kelamin ENUM(&#8216;L&#8217;,'P&#8217;),<br />
jalan VARCHAR(50),<br />
Kota VARCHAR(20),<br />
jurusan varchar(3),<br />
constraint pk_dsn primary key(nip),<br />
constraint fk_dsn_jur foreign key(jurusan) references jurusan(id));</p>
<p>CREATE TABLE MataKuliah (<br />
Kode_mka CHAR(10) NOT NULL,<br />
Nama VARCHAR(50) NOT NULL,<br />
Semester CHAR(5) NoT NULL,<br />
sks TINYINT NOT NULL,<br />
jenis ENUM(&#8216;P&#8217;,W&#8217;),<br />
dosen char(5),<br />
constraint pk_mka primary key(kode_mka),<br />
constraint fk_mka_dsn foreign key(dosen) references dosen(nip));</p>
<p>CREATE TABLE Prasyarat(<br />
ID_prasyarat int auto_increment,<br />
Kode_prasyarat char(10),<br />
Kode_mka char(10),<br />
Nilai varchar(1),<br />
constraint pk_pra primary key(id_prasyarat),<br />
constraint fk_pra_mka foreign key(kode_mka) references matakuliah(kode_mka),<br />
constraint fk_pra_pra foreign key(kode_prasyarat) references matakuliah(kode_mka));</p>
<p>CREATE TABLEkuliah (<br />
id int(11) NOT NULL auto_increment,<br />
nilai_angka tinyint(4)NULL,<br />
nilai_huruf char(1)NULL,<br />
bobot tinyint(4)NULL,<br />
Th_akademik char(5) NOT NULL,<br />
nim char(7)NULL,<br />
mka char(10)NULL,<br />
constraint pk_klh primary key(id),<br />
constraint fk_klh_mhs foreign key(nim) references mahasiswa(nim),<br />
constraint fk_klh_mka foreign key(nim) references matakuliah(kode_mka));</p>
<p>INSERT INTO jurusan (Id, Nama) VALUES<br />
(&#8216;J01&#8242;, &#8216;Ilmu Komputer&#8217;),<br />
(&#8216;J02&#8242;, &#8216;Teknologi Informasi&#8217;),<br />
(&#8216;J03&#8242;, &#8216;Manajemen Informatika&#8217;);</p>
<p>INSERT INTO Mahasiswa (Nim, Nama, Tgl_lahir, Jn_Kelamin, jalan, Kota, jurusan) VALUES<br />
(&#8217;0110001&#8242;, &#8216;Angga Ramadhan&#8217;, &#8217;1986-05-05&#8242;, &#8216;L&#8217;, &#8216;Jl. Brigjen Katamso 50&#8242;, &#8216;Yogyakarta&#8217;, &#8216;J01&#8242;),<br />
(&#8217;0110002&#8242;, &#8216;Amir syarifudin&#8217;, &#8217;1985-06-20&#8242;, &#8216;L&#8217;, &#8216;Jl. Ahmad Yani 47&#8242;, &#8216;Sleman&#8217;, &#8216;J01&#8242;),<br />
(&#8217;0110003&#8242;, &#8216;Dian Arum Ndalu&#8217;, &#8217;1979-03-14&#8242;, &#8216;P&#8217;, &#8216;Jl. Kapten Tendean 23&#8242;, &#8216;Bantul&#8217;, &#8216;J01&#8242;),<br />
(&#8217;0110004&#8242;, &#8216;Imam Bagus&#8217;, &#8217;1980-05-13&#8242;, &#8216;L&#8217;, &#8216;Jl. Karangwaru I/3&#8242;, &#8216;Magelang&#8217;, &#8216;J01&#8242;),<br />
(&#8217;0110005&#8242;, &#8216;Marlina Zein&#8217;, &#8217;1982-02-01&#8242;, &#8216;P&#8217;, &#8216;Jl. Batang 108&#8242;, &#8216;Yogyakarta&#8217;, &#8216;J01&#8242;),<br />
(&#8217;0110006&#8242;, &#8216;Rahendra Putra&#8217;, &#8217;1986-04-12&#8242;, &#8216;L&#8217;, &#8216;Jl. Kenari 2A&#8217;, &#8216;Sleman&#8217;, &#8216;J01&#8242;), (&#8217;0110007&#8242;, &#8216;Yasinta Priska Nadia&#8217;, &#8217;1978-04-29&#8242;, &#8216;P&#8217;, &#8216;Jl. Kertosono 87&#8242;, &#8216;Bandung&#8217;, &#8216;J01&#8242;),<br />
(&#8217;0210001&#8242;, &#8216;Vivi Pratami&#8217;, &#8217;1987-03-13&#8242;, &#8216;P&#8217;, &#8216;Jl. Gambiran 23&#8242;, &#8216;Yogyakarta&#8217;, &#8216;J02&#8242;),<br />
(&#8217;0210002&#8242;, &#8216;Yuanita Tiara Reni&#8217;, &#8217;1985-06-21&#8242;, &#8216;P&#8217;, &#8216;Jl. Mahameru 46&#8242;, &#8216;Jakarta&#8217;, &#8216;J02&#8242;),<br />
(&#8217;0210003&#8242;, &#8216;Yusuf Nizar&#8217;, &#8217;1978-09-23&#8242;, &#8216;L&#8217;, &#8216;Jl. Colombo&#8217;, &#8216;Yogyakarta&#8217;, &#8216;J02&#8242;),<br />
(&#8217;0210004&#8242;, &#8216;Imelda Nurinda&#8217;, &#8217;1984-08-12&#8242;, &#8216;P&#8217;, &#8216;Jl. Antasari 55&#8242;, &#8216;Medan&#8217;, &#8216;J02&#8242;),<br />
(&#8217;0210005&#8242;, &#8216;Khomaruzaman&#8217;, &#8217;1982-10-26&#8242;, &#8216;L&#8217;, &#8216;Jl. Wachid Hasyim 47&#8242;, &#8216;Makasar&#8217;, &#8216;J02&#8242;),<br />
(&#8217;0210006&#8242;, &#8216;Danis Mariaman&#8217;, &#8217;1979-12-18&#8242;, &#8216;L&#8217;, &#8216;Jl. Warungboto 05&#8242;, &#8216;Yogyakarta&#8217;, &#8216;J02&#8242;),<br />
(&#8217;0210007&#8242;, &#8216;Ardhi Nugroho&#8217;, &#8217;1986-09-16&#8242;, &#8216;L&#8217;, &#8216;Jl. Wonosari 63&#8242;, &#8216;Bantul&#8217;, &#8216;J02&#8242;),<br />
(&#8217;0310001&#8242;, &#8216;Rima Nurasmi&#8217;, &#8217;1987-03-03&#8242;, &#8216;P&#8217;, &#8216;Jl. Panggang Indah 108&#8242;, &#8216;Gunung Kidul&#8217;, &#8216;J03&#8242;),<br />
(&#8217;0310002&#8242;, &#8216;Reza Fitriawati&#8217;, &#8217;1985-07-10&#8242;, &#8216;P&#8217;, &#8216;Jl. Samas 2A&#8217;, &#8216;Bantul&#8217;, &#8216;J03&#8242;),<br />
(&#8217;0310003&#8242;, &#8216;Haris Prasetya&#8217;, &#8217;1980-06-28&#8242;, &#8216;L&#8217;, &#8216;Jl. Maga 23&#8242;, &#8216;Semarang&#8217;, &#8216;J03&#8242;),<br />
(&#8217;0310004&#8242;, &#8216;Binti Nur Fitriani&#8217;, &#8217;1986-09-14&#8242;, &#8216;P&#8217;, &#8216;Jl. Randu Belang 23&#8242;, &#8216;Yogyakarta&#8217;, &#8216;J03&#8242;),<br />
(&#8217;0310005&#8242;, &#8216;Evi Munandari&#8217;, &#8217;1988-01-21&#8242;, &#8216;P&#8217;, &#8216;Jl. Kebon Agung 40&#8242;, &#8216;Surakarta&#8217;, &#8216;J03&#8242;),<br />
(&#8217;0310006&#8242;, &#8216;Nur Yusman Aqim&#8217;, &#8217;1979-02-28&#8242;, &#8216;L&#8217;, &#8216;Jl. Kamboja 12&#8242;, &#8216;Magelang&#8217;, &#8216;J03&#8242;);</p>
<p>INSERT INTO dosen (Nip, Nama, Tgl_lahir, Jn_Kelamin, jalan, Kota, jurusan) VALUES<br />
(&#8217;03002&#8242;, &#8216;Diana Ginting,S.Pd.,M.Cs.&#8217;, &#8217;1959-06-21&#8242;, &#8221;, &#8216;Jl. Gatot Subroto 89&#8242;, &#8216;Jakarta&#8217;, &#8216;J03&#8242;),<br />
(&#8217;03001&#8242;, &#8216;Septian Dwiyanto,S.T.,M.Cs.&#8217;, &#8217;1964-03-13&#8242;, &#8216;P&#8217;, &#8216;Jl. Bulukan 03&#8242;, &#8216;Lampung&#8217;, &#8216;J03&#8242;),<br />
(&#8217;02003&#8242;, &#8216;Wahyu Nirba Habibah,S.T.&#8217;, &#8217;1963-04-29&#8242;, &#8221;, &#8216;Jl. Mayoret&#8217;, &#8216;Bandung&#8217;, &#8216;J02&#8242;),<br />
(&#8217;02002&#8242;, &#8216;Jamalludin,S.T.,M.Kom.&#8217;, &#8217;1965-04-12&#8242;, &#8216;P&#8217;, &#8216;Jl. Jend. Sudirman&#8217;, &#8216;Sleman&#8217;, &#8216;J02&#8242;),<br />
(&#8217;02001&#8242;, &#8216;Mahmudin,S.Ag.,M.Kom.&#8217;, &#8217;1956-02-01&#8242;, &#8216;P&#8217;, &#8216;Jl. Disvus 20&#8242;, &#8216;Yogyakarta&#8217;, &#8216;J02&#8242;),<br />
(&#8217;01003&#8242;, &#8216;Kitri Sri Rahayu,S.T.&#8217;, &#8217;1958-03-14&#8242;, &#8216;P&#8217;, &#8216;Jl. Mrican 23&#8242;, &#8216;Yogyakarta&#8217;, &#8216;J01&#8242;),<br />
(&#8217;01004&#8242;, &#8216;Eko Aribowo,S.T.,M.Kom.&#8217;, &#8217;1961-05-13&#8242;, &#8216;P&#8217;, &#8216;Jl. Mawar 56&#8242;, &#8216;Magelang&#8217;, &#8216;J01&#8242;),<br />
(&#8217;01002&#8242;, &#8216;Imana Kusuma,S.T.,M.Kom.&#8217;, &#8217;1960-06-20&#8242;, &#8216;L&#8217;, &#8216;Jl. KOl. Sugiono&#8217;, &#8216;Sleman&#8217;, &#8216;J01&#8242;),<br />
(&#8217;01001&#8242;, &#8216;Wahyu Pujiono,S.T.,M.Kom.&#8217;, &#8217;1957-09-03&#8242;, &#8216;L&#8217;, &#8216;Jl. Ambassador&#8217;, &#8216;Jakarta&#8217;, &#8216;J01&#8242;),<br />
(&#8217;03003&#8242;, &#8216;Yohanes Surya,S.T.&#8217;, &#8217;1960-09-23&#8242;, &#8216;P&#8217;, &#8216;Jl. Tamantirto&#8217;, &#8216;Bantul&#8217;, &#8216;J03&#8242;);</p>
<p>INSERT INTO matakuliah (Kode_mka, Nama, Semester, sks, jenis, dosen) VALUES<br />
(&#8216;MI01002&#8242;, &#8216;Operating System&#8217;, &#8217;1&#8242;, 2, &#8216;W&#8217;, &#8217;03004&#8242;),<br />
(&#8216;MI01001&#8242;, &#8216;Konsep Basis Data&#8217;, &#8217;1&#8242;, 2, &#8216;W&#8217;, &#8217;03004&#8242;),<br />
(&#8216;IK02004&#8242;, &#8216;Basis Data&#8217;, &#8217;2&#8242;, 3, &#8216;P&#8217;, &#8217;01001&#8242;),<br />
(&#8216;IK02003&#8242;, &#8216;Arsitektur Komputer&#8217;, &#8217;2&#8242;, 2, &#8216;P&#8217;, &#8217;01004&#8242;),<br />
(&#8216;IK02002&#8242;, &#8216;Dasar Pemrograman II&#8217;, &#8217;2&#8242;, 3, &#8216;W&#8217;, &#8217;01002&#8242;),<br />
(&#8216;IK02001&#8242;, &#8216;Algoritma Pemrograman&#8217;, &#8217;2&#8242;, 2, &#8216;W&#8217;, &#8217;01003&#8242;),<br />
(&#8216;IK01004&#8242;, &#8216;E-Commerce&#8217;, &#8217;1&#8242;, 2, &#8216;P&#8217;, &#8217;01001&#8242;),<br />
(&#8216;IK01003&#8242;, &#8216;Organisasi Komputer&#8217;, &#8217;1&#8242;, 2, &#8216;P&#8217;, &#8217;01004&#8242;),<br />
(&#8216;IK01002&#8242;, &#8216;Dasar Pemrograman&#8217;, &#8217;1&#8242;, 3, &#8216;W&#8217;, &#8217;01003&#8242;),<br />
(&#8216;IK01001&#8242;, &#8216;Statistika &amp; Probabilitas&#8217;, &#8217;1&#8242;, 2, &#8216;W&#8217;, &#8217;01002&#8242;),<br />
(&#8216;TI02004&#8242;, &#8216;Bahasa Rakitan&#8217;, &#8217;1&#8242;, 2, &#8216;P&#8217;, &#8217;02001&#8242;),<br />
(&#8216;TI02003&#8242;, &#8216;Kalkulus 2&#8242;, &#8217;2&#8242;, 3, &#8216;W&#8217;, &#8217;02003&#8242;),<br />
(&#8216;TI02002&#8242;, &#8216;Sistem Operasi&#8217;, &#8217;2&#8242;, 2, &#8216;W&#8217;, &#8217;02002&#8242;),<br />
(&#8216;TI02001&#8242;, &#8216;Algoritma Dan Pemrograman I&#8217;, &#8217;2&#8242;, 3, &#8216;W&#8217;, &#8217;02002&#8242;),<br />
(&#8216;TI01004&#8242;, &#8216;Matematika Diskrit&#8217;, &#8217;1&#8242;, 2, &#8216;W&#8217;, &#8217;02002&#8242;),<br />
(&#8216;TI01003&#8242;, &#8216;Kalkulus 1&#8242;, &#8217;1&#8242;, 3, &#8216;W&#8217;, &#8217;02003&#8242;),<br />
(&#8216;TI01002&#8242;, &#8216;Aljabar Linear&#8217;, &#8217;1&#8242;, 3, &#8216;W&#8217;, &#8217;02001&#8242;),<br />
(&#8216;TI01001&#8242;, &#8216;Statistik Dasar&#8217;, &#8217;1&#8242;, 2, &#8216;W&#8217;, &#8217;02001&#8242;),<br />
(&#8216;MI01003&#8242;, &#8216;Aljabar Elementer&#8217;, &#8217;1&#8242;, 2, &#8216;W&#8217;, &#8217;03003&#8242;),<br />
(&#8216;MI01004&#8242;, &#8216;Fuzzy Logic&#8217;, &#8217;1&#8242;, 2, &#8216;P&#8217;, &#8217;03001&#8242;),<br />
(&#8216;MI02001&#8242;, &#8216;Teknologi Basis Data&#8217;, &#8217;2&#8242;, 2, &#8216;W&#8217;, &#8217;03002&#8242;),<br />
(&#8216;MI02002&#8242;, &#8216;Sistem Operasi&#8217;, &#8217;2&#8242;, 2, &#8216;W&#8217;, &#8217;03001&#8242;),<br />
(&#8216;MI02003&#8242;, &#8216;Pemrograman Terstruktur&#8217;, &#8217;3&#8242;, 2, &#8216;W&#8217;, &#8217;03001&#8242;),<br />
(&#8216;MI02004&#8242;, &#8216;Web Programming&#8217;, &#8217;2&#8242;, 3, &#8216;P&#8217;, &#8217;03003&#8242;);</p>
<p>INSERT INTO prasyarat (ID_prasyarat, Kode_prasyarat, Kode_mka, Nilai) VALUES<br />
(1, &#8216;IK02002&#8242;, &#8216;IK01002&#8242;, &#8216;C&#8217;),<br />
(2, &#8216;IK02003&#8242;, &#8216;IK01003&#8242;, &#8216;C&#8217;),<br />
(3, &#8216;MI02004&#8242;, &#8216;MI01001&#8242;, &#8216;C&#8217;),<br />
(4, &#8216;MI02004&#8242;, &#8216;MI01002&#8242;, &#8216;C&#8217;);</p>
<p>INSERT INTO kuliah (nilai_angka, nilai_huruf, bobot, Th_akademik, nim, mka) VALUES<br />
(66, &#8216;B&#8217;, 3, &#8217;20101&#8242;, &#8217;0210003&#8242;, &#8216;TI01001&#8242;),<br />
(50, &#8216;C&#8217;, 2, &#8217;20101&#8242;, &#8217;0210002&#8242;, &#8216;TI01004&#8242;),<br />
(90, &#8216;A&#8217;, 4, &#8217;20101&#8242;, &#8217;0210003&#8242;, &#8216;TI01003&#8242;),<br />
(70, &#8216;B&#8217;, 3, &#8217;20101&#8242;, &#8217;0210001&#8242;, &#8216;TI01001&#8242;),<br />
(80, &#8216;B&#8217;, 3, &#8217;20101&#8242;, &#8217;0110002&#8242;, &#8216;IK01004&#8242;),<br />
(95, &#8216;A&#8217;, 4, &#8217;20101&#8242;, &#8217;0110001&#8242;, &#8216;IK01004&#8242;),<br />
(70, &#8216;B&#8217;, 3, &#8217;20101&#8242;, &#8217;0110001&#8242;, &#8216;IK01003&#8242;),<br />
(80, &#8216;B&#8217;, 3, &#8217;20101&#8242;, &#8217;0110001&#8242;, &#8216;IK01001&#8242;),<br />
(NULL, NULL, NULL, &#8217;20102&#8242;, &#8217;0110001&#8242;, &#8216;IK02001&#8242;),<br />
(NULL, NULL, NULL, &#8217;20102&#8242;, &#8217;0110001&#8242;, &#8216;IK02003&#8242;),<br />
(NULL, NULL, NULL, &#8217;20102&#8242;, &#8217;0110001&#8242;, &#8216;IK02004&#8242;),<br />
(95, &#8216;A&#8217;, 4, &#8217;20102&#8242;, &#8217;0110002&#8242;, &#8216;IK02004&#8242;),<br />
(NULL, NULL, NULL, &#8217;20102&#8242;, &#8217;0210001&#8242;, &#8216;TI02001&#8242;),<br />
(NULL, NULL, NULL, &#8217;20102&#8242;, &#8217;0210003&#8242;, &#8216;TI02003&#8242;),<br />
(NULL, NULL, NULL, &#8217;20102&#8242;, &#8217;0210002&#8242;, &#8216;TI02004&#8242;),<br />
(NULL, NULL, NULL, &#8217;20102&#8242;, &#8217;0210003&#8242;, &#8216;TI02001&#8242;),<br />
(NULL, NULL, NULL, &#8217;20102&#8242;, &#8217;0110002&#8242;, &#8216;IK02001&#8242;);</p></blockquote>
<p><strong>A. </strong><strong>TRIGGER</strong></p>
<p>Contoh Trigger yang digunakan untuk memicu perubahan pada tabel kuliah, pada tabel kuliah proses insert diasumsikan hanya dilakukan pada kolom nilai_angka saja sedangkan nilai huruf dan bobot akan terisi secara otomatis (dg mekanisme trigger) dilakukan jika nilai_angka terisi dengan kriteria tertentu.</p>
<p>Trigger disini dilakukan ketika terjadi 2 event yaitu insert (Before Insert) pada nilai_angka atau update (before update) pada nilai_angka.</p>
<p>Kalo di oracle bisa dibuat satu saja tapi kok di mysql aku coba gak bisa <img src='http://mulyanto.net/wp-includes/images/smilies/icon_biggrin.gif' alt=':D' class='wp-smiley' /> , terpaksa bikin 2 trigger.</p>
<blockquote><p>DELIMITER  &amp;&amp;<br />
CREATE TRIGGER updatebobot before update on kuliah<br />
for each row<br />
begin<br />
if new.nilai_angka &lt; 20 then<br />
set new.bobot = 0;<br />
set new.nilai_huruf=’E’;<br />
else if new.nilai_angka &gt;= 20 and new.nilai_angka &lt;=40 then<br />
set new.bobot = 1;<br />
set new.nilai_huruf=’D’;<br />
else if new.nilai_angka &gt;= 41 and new.nilai_angka &lt;=60 then<br />
set new.bobot = 2;<br />
set new.nilai_huruf=’C’;<br />
else if new.nilai_angka &gt;= 61 and new.nilai_angka &lt;=80 then<br />
set new.bobot = 3;<br />
set new.nilai_huruf=’B’;<br />
else if new.nilai_angka &gt;= 81 and new.nilai_angka &lt;=100 then<br />
set new.bobot = 4;<br />
set new.nilai_huruf=’A’;<br />
end if;<br />
end if;<br />
end if;<br />
end if;<br />
end if;<br />
end &amp;&amp;<br />
DELIMITER ;</p>
<p>DELIMITER  &amp;&amp;<br />
CREATE TRIGGER insertbobot before insert on kuliah<br />
for each row<br />
begin<br />
if new.nilai_angka &lt; 20 then<br />
set new.bobot = 0;<br />
set new.nilai_huruf=’E’;<br />
else if new.nilai_angka &gt;= 20 and new.nilai_angka &lt;=40 then<br />
set new.bobot = 1;<br />
set new.nilai_huruf=’D’;<br />
else if new.nilai_angka &gt;= 41 and new.nilai_angka &lt;=60 then<br />
set new.bobot = 2;<br />
set new.nilai_huruf=’C’;<br />
else if new.nilai_angka &gt;= 61 and new.nilai_angka &lt;=80 then<br />
set new.bobot = 3;<br />
set new.nilai_huruf=’B’;<br />
else if new.nilai_angka &gt;= 81 and new.nilai_angka &lt;=100 then<br />
set new.bobot = 4;<br />
set new.nilai_huruf=’A’;<br />
end if;<br />
end if;<br />
end if;<br />
end if;<br />
end if;<br />
end &amp;&amp;<br />
DELIMITER ;</p></blockquote>
<p>Untuk mencoba trigger  :</p>
<blockquote><p>UPDATE KULIAH set nilai_angka =60 where nim =&#8217;0110001&#8242; and mka =&#8217;IK02001&#8242; and th_akademik=&#8217;20102&#8242;;<br />
INSERT INTO kuliah (nilai_angka, Th_akademik, nim, mka) VALUES (66, &#8217;20102&#8242;, &#8217;010004&#8242;, &#8216;TI01004&#8242;);</p></blockquote>
<p><strong>B. </strong><strong>PROCEDURE</strong></p>
<p>Contoh procedure untuk melakukan cetak KRS, cetak KHS dan melakukan Proses KRS (input KRS) dan juga Input Nilai.</p>
<p><strong>a) </strong><strong>Procedure cetak KRS</strong></p>
<blockquote><p>DELIMITER &amp;&amp;<br />
CREATE PROCEDURE CetakKRS(nim char(7), ta char(7))<br />
BEGIN<br />
SELECT distinct concat(m.nim ,&#8221;, m.nama ,&#8217; | TA :  &#8216;, k.th_akademik) as  &#8220;Data Mahasiswa&#8221; from mahasiswa m<br />
inner join kuliah k on m.nim = k.nim<br />
where k.nim =nim and k.Th_akademik =ta;<br />
SELECT concat(k.mka ,&#8217;  | &#8216; , mk.nama, &#8216; &#8216;) as &#8220;Mata Kuliah&#8221;, d.nama as &#8220;Dosen&#8221;, mk.sks as &#8220;SKS&#8221; from kuliah k<br />
inner join matakuliah mk on k.mka = mk.kode_mka<br />
inner join mahasiswa mhs on k.nim = mhs.nim<br />
inner join dosen d on d.nip = mk.dosen<br />
where k.nim = nim and k.Th_akademik = ta;<br />
SELECT Concat(&#8216;Jumlah SKS = &#8216;, sum(mk.sks)) as &#8221; Keterangan&#8221; from kuliah k<br />
inner join mahasiswa m on k.nim = m.nim<br />
inner join matakuliah mk on k.mka = mk.kode_mka<br />
where k.nim = nim and k.Th_akademik = ta<br />
group by m.nim  ;<br />
END &amp;&amp;<br />
DELIMITER ;</p></blockquote>
<p><strong>b) </strong><strong>Procedure cetak KHS</strong></p>
<blockquote><p>DELIMITER &amp;&amp;<br />
CREATE PROCEDURE CetakKHS(nim char(7), ta char(7))<br />
BEGIN<br />
SELECT distinct concat(m.nim ,&#8217;   &#8216;, m.nama ,&#8217;  | TA :  &#8216;, k.th_akademik) as  &#8220;Data Mahasiswa&#8221; from mahasiswa m<br />
inner join kuliah k on m.nim = k.nim<br />
where k.nim =nim and k.Th_akademik =ta;</p>
<p>SELECT k.mka, mk.nama, mk.sks, k.nilai_huruf as Nilai, k.bobot, (k.bobot * mk.sks) as &#8220;bobot (bobot x sks)&#8221; from kuliah k<br />
inner join matakuliah mk on k.mka = mk.kode_mka<br />
inner join mahasiswa mhs on k.nim = mhs.nim<br />
where k.nim = nim and k.Th_akademik = ta;<br />
SELECT Concat(&#8216;Jumlah SKS = &#8216;, sum(mk.sks)) as &#8221; Keterangan  &#8220;, (sum(k.bobot * mk.sks)) as “Total Bobot”, (sum(k.bobot * mk.sks)/ sum(mk.sks)) as “IP<br />
Sementara” from kuliah k<br />
inner join mahasiswa m on k.nim = m.nim<br />
inner join matakuliah mk on k.mka = mk.kode_mka<br />
where k.nim = nim and k.Th_akademik = ta<br />
group by m.nim ;<br />
END &amp;&amp;<br />
DELIMITER ;</p></blockquote>
<p><strong>c)  Proses insert dan update tabel kuliah pada trigger diatas dapat juga  dijadikan procedure</strong></p>
<blockquote><p>DELIMITER &amp;&amp;<br />
CREATE PROCEDURE InputKRS(nr char(7), mk char(10), ta char(5))<br />
BEGIN<br />
Insert into kuliah(nim , mka, th_akademik)<br />
values (nr, mk, ta);<br />
END &amp;&amp;<br />
DELIMITER ;</p>
<p>DELIMITER &amp;&amp;<br />
CREATE PROCEDURE InputNilai(nr char(7), mk char(10), ta char(5), nl tinyint)<br />
BEGIN<br />
Update kuliah set nilai_angka = nl<br />
where kuliah.nim =nr and kuliah.mka = mk and kuliah.th_akademik = ta;<br />
END &amp;&amp;<br />
DELIMITER ;</p></blockquote>
<p>Melihat status dari procedure yang aktif</p>
<blockquote><p>SHOW PROCEDURE STATUS;</p></blockquote>
<p>Memanggil Procedure yang sudah dibuat</p>
<blockquote><p>CALL CETAKKRS(&#8217;0110001&#8242;,&#8217;20102&#8242;);<br />
CALL CETAKKHS(&#8217;0110001&#8242;,&#8217;20101&#8242;);</p></blockquote>
]]></content:encoded>
			<wfw:commentRss>http://mulyanto.net/?feed=rss2&amp;p=343</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Petir..</title>
		<link>http://mulyanto.net/?p=339</link>
		<comments>http://mulyanto.net/?p=339#comments</comments>
		<pubDate>Thu, 04 Feb 2010 10:27:09 +0000</pubDate>
		<dc:creator>mulyanto</dc:creator>
				<category><![CDATA[mydays]]></category>

		<guid isPermaLink="false">http://mulyanto.net/?p=339</guid>
		<description><![CDATA[Hari ini gak ada kerjaan, cuman ngitungin perangkat-perangkat yang Gosong disikat petir, nih dia korban-korbannya : 1 PC kantor 1 PC server 3 Switch 1 Central PABX 1 LAN Card Proxy Server Semoga semua diterima disisi-Nya Kalo dihitung2 selama 1 tahun ini, korban-korbanya 1 Printer Jaringan 1 PC server 3 PC Kantor 2 Central PABX [...]]]></description>
			<content:encoded><![CDATA[<p>Hari ini gak ada kerjaan, cuman ngitungin perangkat-perangkat yang Gosong disikat petir, nih dia korban-korbannya :</p>
<p>1 PC kantor</p>
<p>1 PC server</p>
<p>3 Switch</p>
<p>1 Central PABX</p>
<p>1 LAN Card Proxy Server</p>
<p>Semoga semua diterima disisi-Nya</p>
<p>Kalo dihitung2 selama 1 tahun ini, korban-korbanya</p>
<p>1 Printer Jaringan</p>
<p>1 PC server</p>
<p>3 PC Kantor</p>
<p>2 Central PABX</p>
<p>5 Switch</p>
<p>LanCard tewas tidak terhitung</p>
<p>fyuuuhh</p>
]]></content:encoded>
			<wfw:commentRss>http://mulyanto.net/?feed=rss2&amp;p=339</wfw:commentRss>
		<slash:comments>1</slash:comments>
		</item>
		<item>
		<title>Instalasi Google Cromium pada Fedora Core 11</title>
		<link>http://mulyanto.net/?p=335</link>
		<comments>http://mulyanto.net/?p=335#comments</comments>
		<pubDate>Sat, 30 Jan 2010 10:26:59 +0000</pubDate>
		<dc:creator>mulyanto</dc:creator>
				<category><![CDATA[Internet]]></category>
		<category><![CDATA[linux]]></category>

		<guid isPermaLink="false">http://mulyanto.net/?p=335</guid>
		<description><![CDATA[Dah dari dulu kebelet mo pake Google Chrome hanya sayang dulu adanya cuman di WIndows aja, katanya engine belum dikembangkan untuk mesin Linux. Ternyata sekarang sudah bisa make kakaknya Chrome di Fedora core 11ku. Instalasinya relatif mudah, cuman butuh koneksi internet.. Filenya lumayan besar 19 Mb.. Set dulu ke Fedora kita ke repo chromium. #vim [...]]]></description>
			<content:encoded><![CDATA[<p>Dah dari dulu kebelet mo pake Google Chrome hanya sayang dulu adanya cuman di WIndows aja, katanya engine belum dikembangkan untuk mesin Linux.</p>
<p>Ternyata sekarang sudah bisa make kakaknya Chrome di Fedora core 11ku.</p>
<p>Instalasinya relatif mudah, cuman butuh koneksi internet.. Filenya lumayan besar 19 Mb..</p>
<div id="attachment_336" class="wp-caption aligncenter" style="width: 310px"><a href="http://mulyanto.net/wp-content/uploads/2010/01/google-chromium.png" rel="shadowbox[post-335];player=img;"><img class="size-full wp-image-336" title="chromium" src="http://mulyanto.net/wp-content/uploads/2010/01/google-chromium.png" alt="chromium" width="300" height="300" /></a><p class="wp-caption-text">chromium</p></div>
<p>Set dulu ke Fedora kita ke repo chromium.</p>
<pre>#vim /etc/yum.repos.d/chromium.repo</pre>
<p><span id="more-335"></span></p>
<p>Isinya :</p>
<pre>[chromium]
name=Chromium Test Packages
baseurl=http://spot.fedorapeople.org/chromium/F$releasever/
enabled=1
gpgcheck=0</pre>
<p>Jalankan yum</p>
<p>#yum install chromium</p>
<pre>vim /etc/yum.repos.d/chromium.repo</pre>
<pre>
<div id="_mcePaste">Total download size: 19 M</div>
<div id="_mcePaste">Is this ok [y/N]: y</div>
<div id="_mcePaste">Downloading Packages:</div>
<div id="_mcePaste">(1/4): chromium-4.0.285.0-0.1.20091230svn35370.fc11.i586.rpm                                                         | 2.7 MB     14:23</div>
<div id="_mcePaste">(2/4): chromium-libs-4.0.285.0-0.1.20091230svn35370.fc11.i586.rpm                                                    |  16 MB     23:19</div>
<div id="_mcePaste">(3/4): minizip-1.2.3-22.fc11.i586.rpm                                                                                |  25 kB     00:00</div>
<div id="_mcePaste">(4/4): v8-2.0.5-1.20091229svn3528.fc11.i586.rpm                                                                      | 964 kB     00:10</div>
<div id="_mcePaste">--------------------------------------------------------------------------------------------------------------------------------------------</div>
<div id="_mcePaste">Total                                                                                                       8.6 kB/s |  19 MB     38:09</div>
<div id="_mcePaste">Running rpm_check_debug</div>
<div id="_mcePaste">Running Transaction Test</div>
<div id="_mcePaste">Finished Transaction Test</div>
<div id="_mcePaste">Transaction Test Succeeded</div>
<div id="_mcePaste">Running Transaction</div>
<div id="_mcePaste">Installing     : v8-2.0.5-1.20091229svn3528.fc11.i586                                                                                 1/4</div>
<div id="_mcePaste">Installing     : minizip-1.2.3-22.fc11.i586                                                                                           2/4</div>
<div id="_mcePaste">Installing     : chromium-libs-4.0.285.0-0.1.20091230svn35370.fc11.i586                                                               3/4</div>
<div id="_mcePaste">Installing     : chromium-4.0.285.0-0.1.20091230svn35370.fc11.i586                                                                    4/4</div>
<div id="_mcePaste">Installed:</div>
<div id="_mcePaste">chromium.i586 0:4.0.285.0-0.1.20091230svn35370.fc11</div>
<div id="_mcePaste">Dependency Installed:</div>
<div id="_mcePaste">chromium-libs.i586 0:4.0.285.0-0.1.20091230svn35370.fc11     minizip.i586 0:1.2.3-22.fc11     v8.i586 0:2.0.5-1.20091229svn3528.fc11</div>
<div id="_mcePaste">Complete!</div>

otal download size: 19 MIs this ok [y/N]: yDownloading Packages:(1/4): chromium-4.0.285.0-0.1.20091230svn35370.fc11.i586.rpm                                                         | 2.7 MB     14:23     (2/4): chromium-libs-4.0.285.0-0.1.20091230svn35370.fc11.i586.rpm                                                    |  16 MB     23:19     (3/4): minizip-1.2.3-22.fc11.i586.rpm                                                                                |  25 kB     00:00     (4/4): v8-2.0.5-1.20091229svn3528.fc11.i586.rpm                                                                      | 964 kB     00:10     --------------------------------------------------------------------------------------------------------------------------------------------Total                                                                                                       8.6 kB/s |  19 MB     38:09     Running rpm_check_debugRunning Transaction TestFinished Transaction TestTransaction Test SucceededRunning Transaction  Installing     : v8-2.0.5-1.20091229svn3528.fc11.i586                                                                                 1/4   Installing     : minizip-1.2.3-22.fc11.i586                                                                                           2/4   Installing     : chromium-libs-4.0.285.0-0.1.20091230svn35370.fc11.i586                                                               3/4   Installing     : chromium-4.0.285.0-0.1.20091230svn35370.fc11.i586                                                                    4/4 
Installed:  chromium.i586 0:4.0.285.0-0.1.20091230svn35370.fc11                                                                                       
Dependency Installed:  chromium-libs.i586 0:4.0.285.0-0.1.20091230svn35370.fc11     minizip.i586 0:1.2.3-22.fc11     v8.i586 0:2.0.5-1.20091229svn3528.fc11    
Complete!</pre>
<p>Selesai jalankan cromium dari Main Menu..</p>
]]></content:encoded>
			<wfw:commentRss>http://mulyanto.net/?feed=rss2&amp;p=335</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Konfigurasi Sudo pada Fedora Core 11</title>
		<link>http://mulyanto.net/?p=329</link>
		<comments>http://mulyanto.net/?p=329#comments</comments>
		<pubDate>Fri, 29 Jan 2010 19:42:00 +0000</pubDate>
		<dc:creator>mulyanto</dc:creator>
				<category><![CDATA[linux]]></category>

		<guid isPermaLink="false">http://mulyanto.net/?p=329</guid>
		<description><![CDATA[Pada linux, sangat tidak dianjurkan untuk login kedalam linuxbox dengan menggunakan user root secara langsung.  Hal ini dimaksudkan untuk mengantisipasi keamanan dari linuxbox kita. Oleh karena itu disarankan untuk login dengan menggunakan user biasa. Trus gimana kalo ngoprek ? Tinggal ngeroot aja.. Tapi kalo mo gak repot pake mekanisme SUDO. Sudo membolehkan user biasa untuk [...]]]></description>
			<content:encoded><![CDATA[<p>Pada linux, sangat tidak dianjurkan untuk login kedalam linuxbox dengan menggunakan user root secara langsung.  Hal ini dimaksudkan untuk mengantisipasi keamanan dari linuxbox kita. Oleh karena itu disarankan untuk login dengan menggunakan user biasa.</p>
<p>Trus gimana kalo ngoprek ?</p>
<p>Tinggal ngeroot aja.. Tapi kalo mo gak repot pake mekanisme SUDO.</p>
<p>Sudo membolehkan user biasa untuk menjalankan command-command selayaknya root atau administrator dengan tetap menggunakan user biasa.  Pada beberapa distro seperti Ubuntu, user defaultnya secara otomatis sudah dapat melakukan SUDO, berbeda dengan Fedora yang harus disetting secara manual.</p>
<p><a href="http://mulyanto.net/wp-content/uploads/2010/01/sudo1.jpg" rel="shadowbox[post-329];player=img;"><img class="aligncenter size-full wp-image-331" title="sudo" src="http://mulyanto.net/wp-content/uploads/2010/01/sudo1.jpg" alt="" width="240" height="240" /></a></p>
<p>Untuk fedora 11, karena saya menginstall komputer tanpa GUI maka perlu buat user sebagai SUDOnya</p>
<p><em>[root@localhost ~]# useradd mysys<br />
[root@localhost ~]# passwd mysys<br />
Changing password for user mysys.<br />
New UNIX password:<br />
BAD PASSWORD: it is based on a dictionary word<br />
Retype new UNIX password:<br />
passwd: all authentication tokens updated successfully.</em></p>
<p>Selanjutnya masukkan user mysys sebagai SUDO. File konfigurasinya di /etc/sudoers.</p>
<pre><em>[root@localhost ~]#</em>echo 'mysys ALL=(ALL) ALL' &gt;&gt; /etc/sudoers</pre>
<p>Kemudian tes dengan masuk ke Linuxbox dengan menggunaka user mysys dan coba jalankan command-command dengan privillage Root.</p>
<p><em>[mysys@localhost ~]$ sudo cat /etc/passwd</em></p>
<p><em>We trust you have received the usual lecture from the local System<br />
Administrator. It usually boils down to these three things:</em></p>
<p><em>#1) Respect the privacy of others.<br />
#2) Think before you type.<br />
#3) With great power comes great responsibility.</em></p>
<p><em>[sudo] password for mysys:</em></p>
<p>Maka user mysys dapat melakukan akses terhadap command-command root tanpa login root.</p>
]]></content:encoded>
			<wfw:commentRss>http://mulyanto.net/?feed=rss2&amp;p=329</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>KVMku ngadat di IBM X3250 M2</title>
		<link>http://mulyanto.net/?p=322</link>
		<comments>http://mulyanto.net/?p=322#comments</comments>
		<pubDate>Thu, 14 Jan 2010 11:55:34 +0000</pubDate>
		<dc:creator>mulyanto</dc:creator>
				<category><![CDATA[Server]]></category>

		<guid isPermaLink="false">http://mulyanto.net/?p=322</guid>
		<description><![CDATA[Tiada hari tanpa belajar dan tiada belajar tanpa masalah   (malu ngomong tiap hari kok masalah mulu wekekekek), nih dapat maenan baru IBM X3250 M2 buat ganti nambahin server-server kampus. Baru kali ini liat server blade wekekeke (katrok..). Masalahnya timbul pas mo instalasi fedora, ternyata KVM DLINK-ku yang colokan kibot ma mose-nya PS2 gak bisa [...]]]></description>
			<content:encoded><![CDATA[<p>Tiada hari tanpa belajar dan tiada belajar tanpa masalah <img src='http://mulyanto.net/wp-includes/images/smilies/icon_biggrin.gif' alt=':D' class='wp-smiley' />   (malu ngomong tiap hari kok masalah mulu wekekekek), nih dapat maenan baru IBM X3250 M2 buat ganti nambahin server-server kampus. Baru kali ini liat server blade wekekeke (katrok..).</p>
<p><a href="http://mulyanto.net/wp-content/uploads/2010/01/headache.jpg" rel="shadowbox[post-322];player=img;"><img class="alignleft size-thumbnail wp-image-323" title="pusing" src="http://mulyanto.net/wp-content/uploads/2010/01/headache-150x150.jpg" alt="" width="150" height="150" /></a></p>
<p>Masalahnya timbul pas mo instalasi fedora, ternyata KVM DLINK-ku yang colokan kibot ma mose-nya PS2 gak bisa kedetek ma tuh server karena pake USB, gak mempan PS2 to USB Converter.</p>
<p>Gak bisa ngistall Fedora tersayang jadinya <img src='http://mulyanto.net/wp-includes/images/smilies/icon_biggrin.gif' alt=':D' class='wp-smiley' /> ..</p>
<p>Plis ada yang bisa ngebantu ??</p>
]]></content:encoded>
			<wfw:commentRss>http://mulyanto.net/?feed=rss2&amp;p=322</wfw:commentRss>
		<slash:comments>1</slash:comments>
		</item>
		<item>
		<title>Setting Powerstation 2 Pad</title>
		<link>http://mulyanto.net/?p=317</link>
		<comments>http://mulyanto.net/?p=317#comments</comments>
		<pubDate>Thu, 14 Jan 2010 11:23:02 +0000</pubDate>
		<dc:creator>mulyanto</dc:creator>
				<category><![CDATA[Internet]]></category>
		<category><![CDATA[mydays]]></category>

		<guid isPermaLink="false">http://mulyanto.net/?p=317</guid>
		<description><![CDATA[Setelah 4 hari berjibaku, akhirnya selesai juga seting-seting Akses Poin baru, sebenernya dah lama belinya dari okt 2009, cuman baru sekarang bisa seting-seting. Lumayan bisa nambahin covering hotspot di kampus.. Ada problem dikit, laptop bermerk tohsiba (termasuk punyaku) dan beberapa jenis laptop gak bisa konek ke Wifi.. Tapi masalahnya simpel aja, tinggal upgrade firmware dari [...]]]></description>
			<content:encoded><![CDATA[<p>Setelah 4 hari berjibaku, akhirnya selesai juga seting-seting Akses Poin baru, sebenernya dah lama belinya dari okt 2009, cuman baru sekarang bisa seting-seting.</p>
<p>Lumayan bisa nambahin covering hotspot di kampus..</p>
<div id="attachment_318" class="wp-caption alignleft" style="width: 144px"><a href="http://mulyanto.net/wp-content/uploads/2010/01/ps2.jpg" rel="shadowbox[post-317];player=img;"><img class="size-thumbnail wp-image-318" title="Powerstation 2" src="http://mulyanto.net/wp-content/uploads/2010/01/ps2-150x150.jpg" alt="" width="134" height="134" /></a><p class="wp-caption-text">Powerstation 2</p></div>
<p>Ada problem dikit, laptop bermerk tohsiba (termasuk punyaku) dan beberapa jenis laptop gak bisa konek ke Wifi.. Tapi masalahnya simpel aja, tinggal upgrade firmware dari 2.1.1 ke 3.5 beres ternyata <img src='http://mulyanto.net/wp-includes/images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' /> </p>
<p>Selamat berinternet ria, semoga bermanfaat..</p>
]]></content:encoded>
			<wfw:commentRss>http://mulyanto.net/?feed=rss2&amp;p=317</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Menunggu persaingan Bing dan Google</title>
		<link>http://mulyanto.net/?p=305</link>
		<comments>http://mulyanto.net/?p=305#comments</comments>
		<pubDate>Sun, 28 Jun 2009 07:09:55 +0000</pubDate>
		<dc:creator>mulyanto</dc:creator>
				<category><![CDATA[Internet]]></category>
		<category><![CDATA[Browser]]></category>

		<guid isPermaLink="false">http://mulyanto.net/?p=305</guid>
		<description><![CDATA[Wah ternyata Bing sudah mengudara, mesin seaching dari microsoft yang katanya mampu menyaingi Google. Nyoba-nyoba Bing kalo liat tampilannya kok masih kerenan Google ya, kesannya kuno,  dan gak ruwet dan keliatan blog banget , dan kalo dibandingin ma yahoo masih lebih fresh yahoo, IMHO. Kalo untuk seraching, coba-coba secara kasar emang beda sih keliatannya lebih [...]]]></description>
			<content:encoded><![CDATA[<p>Wah ternyata Bing sudah mengudara, mesin seaching dari microsoft yang katanya mampu menyaingi Google. Nyoba-nyoba <a title="Bing" href="http://www.bing.com" target="_blank">Bing</a> kalo liat tampilannya kok masih kerenan Google ya, kesannya kuno,  dan gak ruwet dan keliatan blog banget <img src='http://mulyanto.net/wp-includes/images/smilies/icon_biggrin.gif' alt=':D' class='wp-smiley' /> , dan kalo dibandingin ma yahoo masih lebih fresh yahoo, IMHO.</p>
<p><a href="http://mulyanto.net/wp-content/uploads/2009/06/binglogo_reverse_lg.jpg" rel="shadowbox[post-305];player=img;"><img class="alignleft size-medium wp-image-306" title="Bing" src="http://mulyanto.net/wp-content/uploads/2009/06/binglogo_reverse_lg-300x231.jpg" alt="Bing" width="300" height="231" /></a></p>
<p>Kalo untuk seraching, coba-coba secara kasar emang beda sih keliatannya lebih cepet dari Google, tapi hasilnya keliatan beda dengan Google, untuk klausa yang lebih spesifik ternyata Bing kalah hebat denganGoogle, ternyata Google masih lebih pinteran dari Bing.</p>
<p>Trus relatifitas juga kayanya aku lebih sreg ma Google, karena aku coba beberapa prase yng berkaitan dengan referensi kayanya lebih sreg dengan hasil dari Google..</p>
<p>Ini cuman penilaian aku sendiri jadi silakan yang mo nyoba Bing, bisa akses di www.bing.com..</p>
]]></content:encoded>
			<wfw:commentRss>http://mulyanto.net/?feed=rss2&amp;p=305</wfw:commentRss>
		<slash:comments>1</slash:comments>
		</item>
		<item>
		<title>Pidgin dan Yahoo lagi gak akur</title>
		<link>http://mulyanto.net/?p=303</link>
		<comments>http://mulyanto.net/?p=303#comments</comments>
		<pubDate>Wed, 24 Jun 2009 05:10:44 +0000</pubDate>
		<dc:creator>mulyanto</dc:creator>
				<category><![CDATA[Internet]]></category>
		<category><![CDATA[Pidgin]]></category>

		<guid isPermaLink="false">http://mulyanto.net/?p=303</guid>
		<description><![CDATA[Wah beberapa hari neh gak bisa konek ke Y, tau neh pigdin ngadat ngoneksiin ke YM. Padahal dah gak ada komputer Windows dimeja kerja . Baca website pidgin ternyata emang lagi ada bugnya : Quite often I cannot connect to yahoo (several others at my work are having identical issues with multiple Pidgin/Gaim versions (1.5, [...]]]></description>
			<content:encoded><![CDATA[<p>Wah beberapa hari neh gak bisa konek ke Y, tau neh pigdin ngadat ngoneksiin ke YM. Padahal dah gak ada komputer Windows dimeja kerja <img src='http://mulyanto.net/wp-includes/images/smilies/icon_sad.gif' alt=':(' class='wp-smiley' /> .</p>
<p>Baca website pidgin ternyata emang lagi ada bugnya :</p>
<p>Quite often I <span class="searchword1">cannot</span> <span class="searchword2">connect</span> to <span class="searchword3">yahoo</span> (several others at my work are having identical issues with multiple <span class="searchword0">Pidgin</span>/Gaim versions (1.5, 2.0B6, B7, etc&#8230;), but we can all connect with Yahoo&#8217;s IM client.</p>
<p>It seems to <span class="searchword2">connect</span> but then says the server closes the <span class="searchword2">connect</span>ion with unknown error number 0 and inactivates the account (BTW: if we have a <span class="searchword3">Yahoo</span> client logged in it will disconnect saying someone else logged in with the same account, showing the <span class="searchword3">Yahoo</span> service is seeing <span class="searchword0">Pidgin</span>&#8216;s login).  A dialog box pops up and says:</p>
<p>Unknown error number 0. Logging into the <span class="searchword3">Yahoo</span>! website may fix this&#8230;</p>
<p>Wew.. kira-kira ganti apa ya&#8230;</p>
]]></content:encoded>
			<wfw:commentRss>http://mulyanto.net/?feed=rss2&amp;p=303</wfw:commentRss>
		<slash:comments>4</slash:comments>
		</item>
	</channel>
</rss>
