tag:blogger.com,1999:blog-54103353104919132872024-03-06T00:20:51.386-08:00sedikit tentang catatankuas romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comBlogger66125tag:blogger.com,1999:blog-5410335310491913287.post-80569495957176841692012-06-13T23:44:00.001-07:002012-06-13T23:44:23.175-07:00PDOStatement::rowCount<pre><!--?php
$database = "Test";
$server = "(local)";
$conn = new PDO( "sqlsrv:server=$server ; Database = $database", "", "");
$col1 = 'a';
$col2 = 'b';
$query = "insert into Table2(col1, col2) values(?, ?)";
$stmt = $conn--->prepare( $query );
$stmt->execute( array( $col1, $col2 ) );
print $stmt->rowCount();
echo "\n\n";
$con = null;
$database = "AdventureWorks";
$conn = new PDO( "sqlsrv:server=$server ; Database = $database", "", "");
$query = "select * from Person.ContactType";
$stmt = $conn->prepare( $query, array(<b style="color: blue;">PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL</b>));
$stmt->execute();
print $stmt->rowCount();
?></pre>
<pre> </pre>
<pre>http://msdn.microsoft.com/en-us/library/ff628154%28v=sql.105%29 </pre>
<div class="fullpost">
</div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-60180118817098360622012-02-14T05:14:00.000-08:002012-02-14T05:32:23.075-08:00migrate access to sql server 2005<div class="MsoNormal"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Tahoma","sans-serif"; font-size: 14pt;">Preface</span></b></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><span style="font-family: "Tahoma","sans-serif";">Prerequisites</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l1 level1 lfo1; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">.Net Framework Version 2.0</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l1 level1 lfo1; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">SQL Server 2005 (Express, Standard, Enterprise) installed</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l1 level1 lfo1; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">MS Access (2000,2002,2003) file to be migrated</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l1 level1 lfo1; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">MS Visual J# Version 2.0</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l1 level1 lfo1; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">SQL Server Migration Assistant (SMAS)</span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><span style="font-family: "Tahoma","sans-serif";">Download Links</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l3 level1 lfo2; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">.Net Framework Version 2.0 </span></div><div class="MsoNormal" style="margin-left: .75in; mso-list: l3 level2 lfo2; tab-stops: list .75in; text-indent: -.25in;"><span style="font-family: "Courier New"; font-size: 10pt;">o<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;"><a href="http://msdn.microsoft.com/netframework/downloads/updates/#.NET%20Framework%202.0%20Beta%20SDK%20and%20Redistributable">http://msdn.microsoft.com/netframework/downloads/updates/#.NET%20Framework%202.0%20Beta%20SDK%20and%20Redistributable</a></span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l3 level1 lfo2; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">SQL Server 2005</span></div><div class="MsoNormal" style="margin-left: .75in; mso-list: l3 level2 lfo2; tab-stops: list .75in; text-indent: -.25in;"><span style="font-family: "Courier New"; font-size: 10pt;">o<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;"><a href="http://www.microsoft.com/sql/downloads/default.mspx">http://www.microsoft.com/sql/downloads/default.mspx</a></span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l3 level1 lfo2; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">MS Visual J# Version 2.0</span></div><div class="MsoNormal" style="margin-left: .75in; mso-list: l3 level2 lfo2; tab-stops: list .75in; text-indent: -.25in;"><span style="font-family: "Courier New"; font-size: 10pt;">o<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;"><a href="http://www.microsoft.com/downloads/details.aspx?familyid=F72C74B3-ED0E-4AF8-AE63-2F0E42501BE1&displaylang=en">http://www.microsoft.com/downloads/details.aspx?familyid=F72C74B3-ED0E-4AF8-AE63-2F0E42501BE1&displaylang=en</a></span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l3 level1 lfo2; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">SSMA for Access</span></div><div class="MsoNormal" style="margin-left: .75in; mso-list: l3 level2 lfo2; tab-stops: list .75in; text-indent: -.25in;"><span style="font-family: "Courier New"; font-size: 10pt;">o<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;"><a href="http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en">http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en</a></span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><span style="font-family: "Tahoma","sans-serif";">Assumptions</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l2 level1 lfo4; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">.Net Framework Version 2.0 is installed</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l3 level1 lfo2; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">SQL Server 2005 is installed and remote connections are enabled </span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Tahoma","sans-serif"; font-size: 14pt;">How-To</span></b></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><span style="font-family: "Tahoma","sans-serif";">Instructions</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">1.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Log into your SQL Server 2005 data source</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">2.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Right click Databases and click “New Database…”</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">3.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">In the “Database Name” field, enter the name of the database that you would like to create and press “OK” when done</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">4.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Download MS Visual J# Version 2.0 from the download link above</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">5.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Install MS Visual J# Version 2.0</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">6.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Download SQL Server Management Services (SMAS) from the download link above</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">7.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Install SSMA</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">8.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Start the SSMA application</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">9.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Create a new project by clicking File > New Project … or click the New Project icon <img border="0" height="16" src="file:///C:/DOCUME%7E1/ardy/LOCALS%7E1/Temp/msohtmlclip1/01/clip_image001.gif" width="13" /></span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">10.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Give the project a name and location of where to save the project file like <b style="mso-bidi-font-weight: normal;">Figure 1</b></span></div><div class="MsoNormal"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGLrJptGkQZKpO-15GWV5tpXu9baylGG2ErpetsNmulL5NSkC8-YnYkGWUd0y4PxEz20SqEPIzDeyZdZrUhVgYRbRsWoN2sUpQwdvuR0nT6oJPW7cM4Z_zvY_iOOmU_uEdQK7sYZva_l4/s1600/Untitled-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="150" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGLrJptGkQZKpO-15GWV5tpXu9baylGG2ErpetsNmulL5NSkC8-YnYkGWUd0y4PxEz20SqEPIzDeyZdZrUhVgYRbRsWoN2sUpQwdvuR0nT6oJPW7cM4Z_zvY_iOOmU_uEdQK7sYZva_l4/s400/Untitled-1.jpg" width="400" /></a></div><br />
</div><div class="MsoNormal" style="page-break-after: avoid;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;"></span></div><div class="MsoCaption"><span style="font-family: "Tahoma","sans-serif";">Figure </span><span style="font-family: "Tahoma","sans-serif";">1</span><span style="font-family: "Tahoma","sans-serif";"></span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><br />
</div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">11.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">To preserve primary key numbering</span></div><div class="MsoNormal" style="margin-left: .75in; mso-list: l0 level2 lfo3; tab-stops: list .75in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">a.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Click Tools > Project Settings </span></div><div class="MsoNormal" style="margin-left: .75in; mso-list: l0 level2 lfo3; tab-stops: list .75in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">b.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Click the “Migration” link</span></div><div class="MsoNormal" style="margin-left: .75in; mso-list: l0 level2 lfo3; tab-stops: list .75in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">c.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Change “Keep Identity” to true see <b style="mso-bidi-font-weight: normal;">Figure 2</b></span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal" style="page-break-after: avoid;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;"><br />
</span></div><div class="MsoCaption"><span style="font-family: "Tahoma","sans-serif";">Figure </span><span style="font-family: "Tahoma","sans-serif";">2</span><span style="font-family: "Tahoma","sans-serif";"> -</span><span style="font-family: "Tahoma","sans-serif"; font-size: 9pt; font-weight: normal;"> You can change other settings here to match your desired database environment</span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">12.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Press “Apply” and “OK”</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">13.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Add your MS Access file to the SSMA project by clicking the “Add Files” graphic <img border="0" height="26" src="file:///C:/DOCUME%7E1/ardy/LOCALS%7E1/Temp/msohtmlclip1/01/clip_image005.gif" width="69" /> in the upper left of your SMAS screen</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">14.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Under the Access Metadata Explorer, you can now expand the tree to see all of the objects related to this Access file and then click the name of database to make sure all of your objects are highlighted</span></div><div class="MsoNormal"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhj2VUzjjm_MDjEMGnQ5zDlx7hHgIS190J2QG-nqD5229vx5bp0EBtidRcacL9IW4PTgtTMdCh8jGOC15O6YEQccd-gCtwyQ4AXftStTUOv1H1PyMmh3nmbiHxs-KgTl1GIDdbpKQII9do/s1600/Untitled-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhj2VUzjjm_MDjEMGnQ5zDlx7hHgIS190J2QG-nqD5229vx5bp0EBtidRcacL9IW4PTgtTMdCh8jGOC15O6YEQccd-gCtwyQ4AXftStTUOv1H1PyMmh3nmbiHxs-KgTl1GIDdbpKQII9do/s1600/Untitled-1.jpg" /></a></div><br />
</div><div class="MsoNormal" style="page-break-after: avoid;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;"></span></div><div class="MsoCaption"><span style="font-family: "Tahoma","sans-serif";">Figure </span><span style="font-family: "Tahoma","sans-serif";">3</span><span style="font-family: "Tahoma","sans-serif";"></span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><br />
</div><div class="MsoNormal"><br />
</div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">15.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Add your SQL Server 2005 connection to the SSMA project by click the “Connect to SQL Server” graphic in the upper left </span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">16.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Enter your database server, database name, authentication, user name and password to connect to your SQL Server 2005 instance in <b style="mso-bidi-font-weight: normal;">Figure 4</b></span></div><div class="MsoNormal"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVTbKRHUAgkLpZBToUEng4A7eq275ooSgKH40ga6Qz5xn9Fio6SaoI4NYkncYy2nS-5Qoem_1_-Az8aVbloYJ2N_ow4k_A6KOtX7_OL-V9rH9Qh0u8shpv9AthSQ3mJ6I7vEMRJ-Qz-wQ/s1600/Untitled-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="236" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVTbKRHUAgkLpZBToUEng4A7eq275ooSgKH40ga6Qz5xn9Fio6SaoI4NYkncYy2nS-5Qoem_1_-Az8aVbloYJ2N_ow4k_A6KOtX7_OL-V9rH9Qh0u8shpv9AthSQ3mJ6I7vEMRJ-Qz-wQ/s320/Untitled-1.jpg" width="320" /></a></div><br />
</div><div class="MsoNormal" style="page-break-after: avoid;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;"></span></div><div class="MsoCaption"><span style="font-family: "Tahoma","sans-serif";">Figure </span><span style="font-family: "Tahoma","sans-serif";">4</span><span style="font-family: "Tahoma","sans-serif";"></span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">17.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">You will see in the SQL Server Metadata Explorer, the list of databases available to your SQL Server. Click the name of the database you will be importing the MS Access data into</span></div><div class="MsoNormal"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8ZfI0tgl7jnh4Y0b-_a_hyphenhyphenz0GhieMgJXjpmRB3nlFmzh-aCZuezhbOBb_H_p88lK8596SwBbtplf6cgOtxZWmj-9SLu0xyJ2HfLQw29KrPfAh7xDZJKasL0OoEbWrZHFfh6mFhD09J0Y/s1600/Untitled-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8ZfI0tgl7jnh4Y0b-_a_hyphenhyphenz0GhieMgJXjpmRB3nlFmzh-aCZuezhbOBb_H_p88lK8596SwBbtplf6cgOtxZWmj-9SLu0xyJ2HfLQw29KrPfAh7xDZJKasL0OoEbWrZHFfh6mFhD09J0Y/s320/Untitled-1.jpg" width="307" /></a></div><br />
</div><div class="MsoNormal" style="page-break-after: avoid;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;"></span></div><div class="MsoCaption"><span style="font-family: "Tahoma","sans-serif";">Figure </span><span style="font-family: "Tahoma","sans-serif";">5</span><span style="font-family: "Tahoma","sans-serif";"></span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">18.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">From your Access Metadata Explorer, click the name of your Access database and then click the “Convert Schema” graphic </span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">19.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Along the bottom, you will see the output panel start outputting the conversions of the schema in <b style="mso-bidi-font-weight: normal;">Figure 6</b></span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr5Z2XaQpHA_aEfGeCeXKbBTJykBXbSqPLSpgnh4yrrKf9UtvY2Y1ERhDXbzfWlYlCXlZZoTCedX-7V89hX0hxr76Ov47DTa1T49IkZJtFQidkMWMIf7U8vCx51MpP2kgqm9EBUhe-4o4/s1600/Untitled-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="93" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr5Z2XaQpHA_aEfGeCeXKbBTJykBXbSqPLSpgnh4yrrKf9UtvY2Y1ERhDXbzfWlYlCXlZZoTCedX-7V89hX0hxr76Ov47DTa1T49IkZJtFQidkMWMIf7U8vCx51MpP2kgqm9EBUhe-4o4/s320/Untitled-1.jpg" width="320" /></a></div><div class="MsoNormal"><br />
</div><div class="MsoNormal" style="page-break-after: avoid;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;"></span></div><div class="MsoCaption"><span style="font-family: "Tahoma","sans-serif";">Figure </span><span style="font-family: "Tahoma","sans-serif";">6</span><span style="font-family: "Tahoma","sans-serif";"></span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">20.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">From your SQL Server Metadata explorer, expand “dbo” tree and then expand the “Tables” tree and you will see that the converted schema was loaded into the database in <b style="mso-bidi-font-weight: normal;">Figure 7</b></span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal" style="page-break-after: avoid;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIjXzR0OwrrrSiO3m2ajorSCeVV_54w_lei756edFb8kwQKHzntFjhG8sMH7xYoCkgDmVgj6YrN5P_GotKs7Qde7JyrQFrcBl7T8MNfXPbBm8FCBMXlsLJ2hHLwJbebXti1bx2Qskq66s/s1600/Untitled-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIjXzR0OwrrrSiO3m2ajorSCeVV_54w_lei756edFb8kwQKHzntFjhG8sMH7xYoCkgDmVgj6YrN5P_GotKs7Qde7JyrQFrcBl7T8MNfXPbBm8FCBMXlsLJ2hHLwJbebXti1bx2Qskq66s/s320/Untitled-1.jpg" width="223" /></a></div><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;"><br />
</span></div><div class="MsoCaption"><span style="font-family: "Tahoma","sans-serif";">Figure </span><span style="font-family: "Tahoma","sans-serif";">7</span><span style="font-family: "Tahoma","sans-serif";"></span></div><div class="MsoNormal"><br />
</div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">21.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Now right-click the “Tables” folder that is above the <b style="mso-bidi-font-weight: normal;">tblTest</b> table icon and from the options window you will see an option that says “Load to Database” or click the graphic. This will create and modify all of the tables that you have loaded into the schema and place them into the database as table objects.</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">22.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">From your Access Metadata explorer, left click the “Tables” folder under your Access file tree see <b style="mso-bidi-font-weight: normal;">Figure 3</b></span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">23.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">You will see the “Migrate Data” graphic become enabled</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">24.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">Click “Migrate Data” and the data from your Access database will be exported into SQL Server 2005</span></div><div class="MsoNormal" style="margin-left: .25in; mso-list: l0 level1 lfo3; tab-stops: list .25in; text-indent: -.25in;"><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">25.<span style="font: 7pt "Times New Roman";"> </span></span><span style="font-family: "Tahoma","sans-serif"; font-size: 10pt;">A report of the completed tasks will pop up, press close and your migration is complete</span></div><div class="fullpost"></div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-35198303406605651622012-02-06T17:06:00.000-08:002012-02-06T17:15:36.983-08:00Kutipan Membangun -Albert Einstein-<div class="fullpost">- Jika A adalah 'sukses', maka rumusnya adalah 'A=X+Y+Z', dimana X adalah 'kerja',<br />
Y adalah 'bermain', dan Z adalah jaga mulut anda agar tetap tertutup.</div><div class="fullpost">- Cobalah tidak untuk menjadi seseorang yang sukses, tetapi menjadi seseorang<br />
yang bernilai.<br />
- Saya tidak memiliki bakat tertentu. Saya hanya ingin tahu.<br />
- Satu-satunya sumber pengetahuan adalah pengalaman.<br />
- Pelepasan tenaga atom telah merubah segalanya kecuali cara kita berpikir.<br />
pemecahan untuk masalah ini tergantung kepada hati nurani umat manusia.<br />
Jika saya mengetahuinya, lebih baik saya menjadi pembuat jam tangan.</div><div class="fullpost">- supaya kamu berhasil langgarlah peraturan peraturan yang ada, lakukan<br />
yang menurut kamu benar<br />
- hidup seperti naik sepeda agar tidak terjatuh kamu harus tetap bergerak<br />
yang terpenting adalah tidak berhenti bertanya.<br />
- jika anda ingin mendapatkan hasil yang berbeda tetapi masih melakukan<br />
hal yg sama itu namanya terori yg gila.jika anda ingin sesuatu hal yg berbeda<br />
maka lakukan lah hal yg berbeda pula.</div><div class="fullpost"><ol></ol> -Albert Einstein- <br />
<ul></ul></div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-27668264775464862492011-08-28T08:53:00.001-07:002011-08-28T08:53:57.015-07:00Set Static IP Fedora 15<div class="fullpost"><b><br />
</b><br />
Had some trouble setting a static IP address using Network Manager in Fedora 15 on Virtual Box. after searching around this is what worked for me. <br />
Turn off NetworkManager from startup (we’ll be using network instead):<br />
<br />
<pre># chkconfig NetworkManager off</pre>Turn on network manager on start up:<br />
<br />
<pre>#chkconfig --level 35 network on</pre>Create the start up scripts for your devices. Ensure you know the device name “ethX” and the MAC address:<br />
<br />
<pre><code>#cd /etc/sysconfig/network-scripts/
#vi ifcfg-ethX (Your device number where "X" is)
add the following lines with your network information
BOOTPROTO=none
HWADDR=Your_hardware_address
DNS1=192.168.1.1
GATEWAY=192.168.1.1
IPADDR=192.168.1.2
NETMASK=255.255.255.0
ONBOOT=yes
TYPE=Ethernet
IPV6INIT=no
USERCTL=no
NM_CONTROLLED=no
DNS2=8.8.8.8
PREFIX=24
</code></pre>Stop NetworkManager and start network<br />
<br />
<pre><code>#service NetworkMananger stop
#service network start
#ifconfig</code></pre>**If you might have to install network if you haven’t previously done so.<br />
<br />
<pre>#yum install system-config-network</pre>And that’s it… pretty simple but it took some searching to find a solution for me… <br />
Thanks! </div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-41010131546472887102011-08-28T06:43:00.000-07:002011-08-28T06:43:33.892-07:00Broadcom 43xx Chipset and Ubuntu 11.04 (Natty Narwahl)<div class="fullpost">Just upgraded my 3-year old laptop (HP Pavilion dv9760ed) to Ubuntu 11.04. Apparently things went just fine and in a small hour the update completed. Bad thing: my wifi was not working anymore :( . The wifi card on my laptop is based in the Broadcom 4311 Chipset.<br />
<br />
First thing i did was checking my PCI devices available. This can be done with te command below. The filter “14e4″ will display only devices manufactured by Broadcom (including wifi cards)<br />
<br />
~$ lspci -vvnn | grep 14e4<br />
<br />
The result should be something like this:<br />
<br />
02:00.0 Network controller [0280]: Broadcom Corporation BCM4311 802.11b/g<br />
LP-PHY [14e4:4315] (rev 01)<br />
<br />
lshw is a small tool to provide detailed information on the hardware configuration of your machine.<br />
<br />
~$ lshw -C network<br />
<br />
Below you see the output of this command. As you can see the Broadcom device is DISABLED<br />
<br />
*-network DISABLED<br />
description: Wireless interface<br />
product: BCM43224 802.11a/b/g/n<br />
vendor: Broadcom Corporation<br />
<br />
First thing you can try is to activate the proprietary driver under: System > Administration > Hardware/Additional Drivers. Pay attention that this action requiers a working Internet connection (e.g. wired) This did’t do the tric for me. Still no working wifi :(<br />
<br />
You can manualy install some packages to get a working wifi connection. I’ve downloaded the following packages:<br />
<br />
B43-fwcutter; Utility for extracting Broadcom 43xx firmware<br />
Firmware-b43-installer; Installer package for firmware for de b43 driver<br />
<br />
I use 64-bits Ubuntu. If you use a different architecture, the linked webpages provide the right packages voor you with al little search. Attention: the firmware installer also needs an working Internet connection. When installing it will download some source files (somewhere from openwrt.org)<br />
<br />
Installing is very simple. As i use Gnome desktop i can dubble click the packages to install the. The ‘Ubuntu Software Center’ window will open en then just hit the install button. Thats al. B43-fwcutter package must be installed first.<br />
<br />
After installation everything works fine! However this is not a very user friendly way of upgrade/installation of Ubuntu. The majority of ‘standard’ users will be scared of when this problem occurs.<br />
<br />
Some screens of the installation of the above packages<br />
<br />
B43-fwcutter installation Firmware-B43-installer installation</div><div class="separator" style="clear: both; text-align: center;"><a href="http://tech.martijnedens.nl/wp-content/uploads/2011/05/Screenshot-Ubuntu-Software-Center-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="253" src="http://tech.martijnedens.nl/wp-content/uploads/2011/05/Screenshot-Ubuntu-Software-Center-2.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="http://tech.martijnedens.nl/wp-content/uploads/2011/05/Screenshot-Ubuntu-Software-Center.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="256" src="http://tech.martijnedens.nl/wp-content/uploads/2011/05/Screenshot-Ubuntu-Software-Center.png" width="320" /></a></div><div class="fullpost"><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
To get a temporarily Internet connection i plugged in my laptop in a free port of my router.</div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-23481253889855245052011-08-27T00:51:00.000-07:002011-08-27T00:51:13.900-07:00install libre Office di fedora<div class="fullpost">kemaren udah ngebahas openoffice sekarang ngebahas libreoffice..apa itu libreoffice..LibreOffice adalah sebuah paket aplikasi perkantoran yang kompatibel dengan aplikasi perkantoran besar seperti Microsoft Office atau OpenOffice.org dan tersedia dalam berbagai platform. Tujuannya adalah menghasilkan aplikasi perkantoran yang mendukung format ODF tanpa bergantung pada sebuah pemasok dan keharusan mencantumkan hak cipta. Nama LibreOffice merupakan gabungan dari kata Libre (bahasa Spanyol dan Perancis yang berarti bebas) dan Office (bahasa Inggris yang berarti kantor). Sebagai sebuah perangkat lunak bebas dan gratis, LibreOffice bebas untuk diunduh, digunakan, dan didistribusikan. LibreOffice merupakan proyek pengembangan dari OpenOffice.org yang sejak tahun 2010 sudah diakuisisi oleh Oracle. Semua fitur yang ada di OpenOffice ada pula di LibreOffice tetapi ke depannya akan dikembangkan secara lebih terbuka dan mandiri karena dibawah naungan pengembang....<a href="http://www.detikinet.com/read/2010/12/15/154911/1525546/398/libreoffice-lebih-baik-dari-openofficeorg">perpisahan</a></div><div class="fullpost"><br />
</div><div class="fullpost">INSTALASI</div><div class="fullpost"><br />
</div><div class="fullpost">Secara default baik libreoffice maupun openoffice belum terinstall di fedora 15, anda bisa dowload paket sourcenya, download libreoffice <a href="http://www.libreoffice.org/download/">disini</a><br />
<br />
extract paket libreoffice dengan menggunakan perintah berikut:<br />
<br />
terminal:<br />
<br />
tar xvzf LO_x.x.x-_Linux_x86_install-rpm_en-US.tar.gz<br />
<br />
masuk ke dalam folder extract<br />
<br />
cd /Downloads/en-US<br />
<br />
install paket RPM dengan menggunakan perintah berikut<br />
<br />
rpm -ivh *rpm<br />
<br />
menampilkan menu libreoffice, ketikkan perintah berikut<br />
<br />
cd /Downloads/en-US/RPMS/desktop-integration<br />
<br />
sekarang install libreofficenya<br />
<br />
rpm -ivh *rpm<br />
<br />
LibreOffice sudah terinstall, untuk cara yang lebih mudah, anda bisa menginstall libreoffice dengan mengetikkan perintah di bawah ini<br />
<br />
yum groupinstall "Office/Productivity"<br />
<br />
namun libreoffice-base belum terinstall di dalamnya, ketikkan perintah berikut untuk menginstall libreoffice-base<br />
<br />
yum -y install libreoffice-base<br />
<br />
Semoga bermanfaa</div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-85437458267135019282011-08-27T00:21:00.000-07:002011-08-27T00:23:14.201-07:00Install OpenOffice.org 3.3.0/3.4.0 on Fedora 15/14, CentOS/Red Hat (RHEL) 5.6/6<div class="fullpost">OpenOffice.org adalah aplikasi perkantoran yang kini banyak digunakan oleh perusahaan baik di Indonesia maupun negara lainnya, hal ini dikarenakan aplikasi perkantoran ini mempunyai kemampuan multiplatform dan dapat digunakan dibanyak Sistem Operasi baik itu Microsoft Windows, Linux maupun Macintosh. Selain itu OpenOffice.org menggunakan basis Open Source sebagai basis pengembangannya membuat aplikasi ini cepat berkembang dan gratis.<br />
Pada saat ini OpenOffice.org telah mencapai versi 2.0 dimana kemampuan yang dimilikinya sudah sangat jauh berbeda dengan versi-versi sebelumnya termasuk kemampuannya untuk memanfaatkan teknologi OpenDocument (odt) yaitu teknologi yang membuat dokumen dapat digunakan secara bersama-sama tidak saja berbeda sistem operasi, melainkan berbeda gadget/alat seperti Personal Computer, Personal Digital Assistant, Smartphone dan lain-lain.<br />
Dengan banyaknya kemampuan yang dimilikinya OpenOffice.org ini, maka OpenOffice.org sangat tepat dipelajari dan dijadikan aplikasi perkantoran andalan anda dimasa depan.<br />
Untuk mempelajari lebih jauh aplikasi OpenOffice.org bisa donlot modul pelatihannya di website saya, gratis buat personal atau modul kursus.<br />
<br />
<br />
1. Download OpenOffice.org 3.3.0/3.4.0 Beta Linux Package<br />
OpenOffice.org 3.3.0 32-bit version<br />
<br />
<div style="color: black;"><b>wget http://download.services.openoffice.org/files/stable/3.3.0/OOo_3.3.0_Linux_x86_install-rpm-wJRE_en-US.tar.gz </b></div><br />
OpenOffice.org 3.3.0 64-bit version<br />
<br />
<div style="color: black;"><b>wget http://download.services.openoffice.org/files/stable/3.3.0/OOo_3.3.0_Linux_x86-64_install-rpm-wJRE_en-US.tar.gz</b><br />
</div></div><div class="fullpost">2. Extract Package and Access Directory</div><div class="fullpost"><br />
<div style="color: black;"><b>tar -xvf OOo_3.3.0_*<br />
<br />
cd OOO330* <br />
## OR ##<br />
cd OOO330_m20_native_packed-1_en-US.9567/</b><br />
</div></div><div class="fullpost"></div><div class="fullpost"><span style="color: lime;"><span style="color: black;">3. Install / Update OpenOffice.org RPM packages</span></span><b><span style="color: lime;"><span style="color: black;"> </span></span></b></div><div class="fullpost"><b><span style="color: lime;"></span></b></div><div class="fullpost"><b><span style="color: lime;"></span></b></div><div class="fullpost"><b><span style="color: lime;"><br />
</span></b> <b style="color: black;">rpm -Uvh RPMS/*.rpm RPMS/desktop-integration/openoffice.org3.3-redhat-menus-3.3-*.rpm</b><br />
<br />
4. setup melalui GUi<br />
<br />
<b style="color: yellow;"><span style="color: lime;">./setup</span> </b><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://media.if-not-true-then-false.com/2010/02/openoffice-3.4-running-on-fedora-15-560x422.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="241" src="http://media.if-not-true-then-false.com/2010/02/openoffice-3.4-running-on-fedora-15-560x422.png" width="320" /></a></div>5.remove</div><div class="fullpost"><br />
<div style="color: black;"><b>yum remove openoffice.org*</b></div><br />
<br />
<br />
<br />
semoga bermanfaat..</div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-87081249208708858642011-08-26T02:08:00.000-07:002011-08-26T02:12:28.258-07:00Perintah Sudo<div class="fullpost">Secara default, fedora menggunakan perintah “su” untuk mengakses hak <i>root. </i>Jadi bila ingin melakukan suatu operasi yang memerlukan hak <i>root, </i>cukup gunakan<br />
<b><br />
</b><br />
<div><div class="syntaxhighlighter bash" id="highlighter_128024"><table border="0" cellpadding="0" cellspacing="0"><tbody>
<tr><td class="gutter"><div class="line number1 index0 alt2"><br />
</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><b><code class="bash plain">$ </code><code class="bash functions">su</code> <code class="bash plain">-c </code><code class="bash string">"perintah"</code></b><br />
</div></div></td></tr>
</tbody></table></div></div>sebagai perintah.<br />
Terbiasa dengan ubuntu style? Mudah saja, ada beberapa langkah yang perlu dilakukan untuk mengaktifkan fitur itu.<br />
<br />
1. Edit file /etc/sudoers<br />
<div><div class="syntaxhighlighter bash" id="highlighter_502171"><div class="toolbar"><br />
</div><table border="0" cellpadding="0" cellspacing="0"><tbody>
<tr><td class="gutter"><div class="line number1 index0 alt2"><br />
</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><b><code class="bash plain">$ </code><code class="bash functions">su</code> <code class="bash plain">-c </code><code class="bash string">"visudo"</code></b><br />
</div></div></td></tr>
</tbody></table></div></div>2. Edit pada baris yang berisi<br />
<div><div class="syntaxhighlighter bash" id="highlighter_140949"><div class="toolbar"><br />
</div><table border="0" cellpadding="0" cellspacing="0"><tbody>
<tr><td class="gutter"><div class="line number1 index0 alt2"><br />
</div><div class="line number2 index1 alt1"><br />
</div><div class="line number3 index2 alt2"><br />
</div><div class="line number4 index3 alt1"><br />
</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><b><code class="bash comments">## Allows people in group wheel to run all commands</code></b></div><div class="line number2 index1 alt1"><b><code class="bash comments"># %wheel ALL=(ALL) ALL</code></b></div><div class="line number3 index2 alt2"><b><code class="bash comments">## Same thing without a password</code></b></div><div class="line number4 index3 alt1"><b><code class="bash comments"># %wheel ALL=(ALL) NOPASSWD: ALL </code></b></div></div></td></tr>
</tbody></table></div></div><br />
Bila ingin sudo tetap meminta password, maka aktifkan baris yang<br />
<div><div class="syntaxhighlighter bash" id="highlighter_798680"><div class="toolbar"><br />
</div><table border="0" cellpadding="0" cellspacing="0"><tbody>
<tr><td class="gutter"><div class="line number1 index0 alt2"><b><br />
</b></div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><b><code class="bash plain">%wheel ALL=(ALL) ALL</code></b></div></div></td></tr>
</tbody></table></div></div><br />
dengan menghilangkan tanda pagar. Namun bila ingin tanpa password (berbahaya) aktifkan baris<br />
<div><div class="syntaxhighlighter bash" id="highlighter_64416"><div class="toolbar"><b><br />
</b></div><table border="0" cellpadding="0" cellspacing="0"><tbody>
<tr><td class="gutter"><div class="line number1 index0 alt2"><br />
</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><b><code class="bash plain">%wheel ALL=(ALL) NOPASSWD: ALL</code></b><br />
</div></div></td></tr>
</tbody></table></div></div>Save dengan cara tekan esc, :, w, q<br />
Lalu tambahkan user yang ingin bisa menggunakan sudo kedalam grup wheel<br />
<div><div class="syntaxhighlighter bash" id="highlighter_282763"><div class="toolbar"><b><br />
</b></div><table border="0" cellpadding="0" cellspacing="0"><tbody>
<tr><td class="gutter"><div class="line number1 index0 alt2"><b><br />
</b></div><b><br />
</b></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><b><code class="bash plain">$ </code><code class="bash functions">su</code> <code class="bash plain">-c </code><code class="bash string">"useradd -G wheel nama_user"</code> </b><br />
</div></div></td></tr>
</tbody></table></div></div>Done. Sekarang user yang sudah masuk group wheel bisa melakukan perintah sudo.</div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-19308235719149589942011-08-26T01:36:00.000-07:002011-08-26T01:36:37.519-07:00install mp3 plugins fedora 15<div class="fullpost"><a class="external free" href="http://www.fluendo.com/shop/product/fluendo-mp3-decoder/">http://www.fluendo.com/shop/product/fluendo-mp3-decoder/</a></div><div class="fullpost"> </div><div class="fullpost">Procedure<br />
<br />
Here is a basic procedure for installing the Fluendo MP3 plugin for GStreamer:</div><div class="fullpost"><br />
1. Visit Fluendo Webshop and click on "Fluendo MP3 Decoder."</div><div class="fullpost">2. Click on "Add to Cart" button and follow by "Checkout" button.</div><div class="fullpost"> 3. Sign in either as a new customer or returning customer. Continue Checkout Procedure to confirm this order. After confirming your order, you can download the codec in various formats. The most comfortable option is RPM.<br />
4. If you've downloaded the file as an RPM, just double-click and install it. Otherwise, extract the tarball and read the documenation/INSTALL.mp3.txt.<br />
<br />
<b> $ ls<br />
fluendo-mp3-1.i386.tar.bz2<br />
$ tar -jxvf fluendo-mp3-1.i386.tar.bz2<br />
fluendo-mp3-i386/<br />
fluendo-mp3-i386/libgstflump3dec.so<br />
documentation/INSTALL.mp3.txt<br />
documentation/LICENSE.mp3.txt<br />
$ ls<br />
documentation fluendo-mp3-1.i386.tar.bz2 fluendo-mp3-i386<br />
$ cd fluendo-mp3-i386/<br />
$ ls<br />
libgstflump3dec.so</b></div><div class="fullpost"><br />
Basically, you need to create a plugins directory under $HOME/.gstreamer-0.10 then copy the binary over.<br />
<br />
<b> $ mkdir -p $HOME/.gstreamer-0.10/plugins<br />
$ cp libgstflump3dec.so $HOME/.gstreamer-0.10/plugins<br />
$ chcon --type=textrel_shlib_t $HOME/.gstreamer-0.10/plugins/*.so</b></div><div class="fullpost"><br />
The last step may not be necessary if selinux is disabled.If selinux is enabled, make sure that executable stacks are enabled (see System > Administration > SELinux Management > Boolean > Memory Protection > Allow unconfined executables to mark their stack executable).<br />
Now, you should be able to play MP3 files using GStreamer applications such as Totem Movie Player, Rhythmbox Music Player, Banshee Music player or the Elisa Media center. </div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-79626927322060328292011-08-25T23:58:00.000-07:002011-08-26T00:00:19.359-07:00repository fedora 15 lokal singo<div class="fullpost"><div style="text-align: justify;">Jika anda pengguna fedora, di <a href="http://singo.ub.ac.id/">SINGO </a>sudah menyediakan repository untuk fedora. Repo untuk fedora 15 pun sudah tersedia di <a href="http://singo.ub.ac.id/">SINGO </a>. Silahkan arahkan repo fedora anda ke <a href="http://singo.ub.ac.id/">SINGO </a> </div><div style="text-align: justify;">Berikut saya tampilkan langkah-langkah mengganti source repo ke <a href="http://singo.ub.ac.id/">SINGO </a></div><div style="text-align: justify;">backup dulu file settingan repo</div><div style="text-align: justify;"><br />
#cp /etc/yum.repos.d/fedora.repo /etc/yum.repos.d/fedora.repo.old<br />
#cp/etc/yum.repos.d/fedora-updates.repo /etc/yum.repos.d/fedora-updates.repo.old</div><div style="text-align: justify;"><span id="more-680"></span><br />
kosongkan isi dari file settingan repo<br />
#echo “” > /etc/yum.repos.d/fedora.repo<br />
#echo “” > /etc/yum.repos.d/fedora-updates.repo</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Edit file settingan repo tersebut<br />
#vi /etc/yum.repos.d/fedora.repo</div><div style="text-align: justify;"><br />
</div>Masukkan list dibawah ini ke dalam file /etc/yum.repos.d/fedora.repo tersebut<br />
<blockquote><div style="text-align: justify;">[fedora-singo]<br />
name=Fedora<br />
baseurl=http://singo.ub.ac.id/fedora/releases/$releasever/Everything/$basearch/os/<br />
enabled=1<br />
gpgcheck=1<br />
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-fedora-$basearch</div></blockquote>Dan masukkan list dibawah ini ke dalam file /etc/yum.repos.d/fedora-updates.repo<br />
<blockquote>[fedora-singo]<br />
name=Fedora<br />
baseurl=http://singo.ub.ac.id/fedora/releases/$releasever/Everything/$basearch/os/<br />
enabled=1<br />
gpgcheck=1<br />
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-fedora-$basearch</blockquote></div><div class="fullpost"><div style="text-align: justify;">Setelah file repo di setting, jalankan perintah dibawah ini untuk menerapkan perubahan</div><div style="text-align: justify;"><br />
#yum clean all<br />
#yum update<br />
<a href="http://singo.ub.ac.id/penggunaan/">#yum list </a></div></div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-3979464839986555002011-08-22T15:47:00.000-07:002011-08-22T15:50:13.568-07:00Mengembalikan Panel Gnome Ubuntu Yang Hilang<div class="fullpost">Bukalah terminal dengan shortcut alt+f2 pada posisi kursor anda di desktop. Setelah terbuka terminal ketik perintah berikut:<br />
<br />
sudo debconf gnome-panel<br />
<br />
</div><div class="fullpost"></div><div class="fullpost">Perintah di atas akan mengembalikan panel gnome anda langsung, namun dalam hak acces root, setiap file yang anda download atau buat hanya bisa diakses oleh root. Namun setidaknya dengan panel ini anda bisa menggunakan aplikasi kembali terutama aplikasi browsing supaya dunia kembali terang.<br />
<br />
Kemudian downloadlah <a href="http://www.ziddu.com/download/14281243/PanelRestore.tar.gz.html">script berikut</a> untuk merestore kembali panel anda dengan hak akses akun anda. Download dan extrak filenya (PanelRestore.sh), taruh didestop biar mudah mencarinya. Untuk memastikan bahwa file tersebut tidak hanya root aja yang memiliki akses ada baiknya gunakan perintah chmod dulu pada filenya. sudo chmod 777 /home/useranda/Desktop/PanelRestore.sh. sebelum anda mengklik atau mengeksekusi file hasi download tersebut. Tutuplah terminal yang membuka gnome panel root.<br />
<br />
Selamat mencoba dan semoga artikel ini bisa membantu mengatasi sedikit masalah anda dengan ubuntu.<br />
<br />
<a href="http://ahmadzainul.wordpress.com/2011/03/21/mengembalikan-panel-gnome-ubuntu-yang-hilang/">sumber</a> </div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-56534925415151228742011-08-22T12:20:00.000-07:002011-08-25T12:23:43.366-07:00Extra Packages for Enterprise Linux (EPEL)<div class="fullpost">Welcome to the home of the EPEL Special Interest Group. <br />
<h2><span class="mw-headline" id="What_is_Extra_Packages_for_Enterprise_Linux_.28or_EPEL.29.3F"> What is Extra Packages for Enterprise Linux </span></h2>Extra Packages for Enterprise Linux (or EPEL) is a Fedora Special Interest Group that creates, maintains, and manages a high quality set of additional packages for Enterprise Linux, including, but not limited to, Red Hat Enterprise Linux (RHEL), CentOS and Scientific Linux (SL). <br />
EPEL packages are usually based on their Fedora counterparts and will never conflict with or replace packages in the base Enterprise Linux distributions. EPEL uses much of the same infrastructure as Fedora, including buildsystem, bugzilla instance, updates manager, mirror manager and more. <br />
Learn more about EPEL in the <a href="http://fedoraproject.org/wiki/EPEL/FAQ" title="EPEL/FAQ"> EPEL FAQ</a><br />
<br />
<h2><span class="mw-headline" id="What_packages_and_versions_are_available_in_EPEL.3F"> <span style="font-size: small;">What packages and versions are available in EPEL? </span></span></h2><h2><span class="mw-headline" id="What_packages_and_versions_are_available_in_EPEL.3F"><span style="font-size: small;"> </span></span></h2>You can take a look on any of the available EPEL mirrors from our <a class="external text" href="http://mirrors.fedoraproject.org/publiclist/EPEL/">mirror list</a> <br />
Alternately, you can browse the package set using repoview: <br />
<ul><li> EPEL 6: <a class="external text" href="http://download.fedora.redhat.com/pub/epel/6/i386/repoview/">i386</a>, <a class="external text" href="http://download.fedora.redhat.com/pub/epel/6/x86_64/repoview/">x86_64</a>, <a class="external text" href="http://download.fedora.redhat.com/pub/epel/6/ppc64/repoview/">ppc64</a>, <a class="external text" href="http://download.fedora.redhat.com/pub/epel/6/SRPMS/repoview/">sources</a> </li>
<li> EPEL 5: <a class="external text" href="http://download.fedora.redhat.com/pub/epel/5/i386/repoview/">i386</a>, <a class="external text" href="http://download.fedora.redhat.com/pub/epel/5/x86_64/repoview/">x86_64</a>, <a class="external text" href="http://download.fedora.redhat.com/pub/epel/5/ppc/repoview/">ppc</a>, <a class="external text" href="http://download.fedora.redhat.com/pub/epel/5/SRPMS/repoview/">sources</a> </li>
<li> EPEL 4: <a class="external text" href="http://download.fedora.redhat.com/pub/epel/4/i386/repoview/">i386</a>, <a class="external text" href="http://download.fedora.redhat.com/pub/epel/4/x86_64/repoview/">x86_64</a>, <a class="external text" href="http://download.fedora.redhat.com/pub/epel/4/ppc/repoview/">ppc</a>, <a class="external text" href="http://download.fedora.redhat.com/pub/epel/4/SRPMS/repoview/">sources</a></li>
<li> </li>
</ul><h2><span class="mw-headline" id="How_can_I_use_these_extra_packages.3F"> <span style="font-size: small;">How can I use these extra packages? </span></span></h2><h2><span class="mw-headline" id="How_can_I_use_these_extra_packages.3F"><span style="font-size: small;"> </span></span></h2>EPEL has an 'epel-release' package that includes gpg keys for package signing and repository information. Installing this package for your Enterprise Linux version should allow you to use normal tools such as yum to install packages and their dependencies. By default the stable EPEL repo is enabled, there is also a 'epel-testing' repository that contains packages that are not yet deemed stable. <br />
If you are running an EL6 version: <a class="external text" href="http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-5.noarch.rpm">epel-release-6-5.noarch.rpm</a> <br />
NOTE: You need to also enable the 'optional' repository to use EPEL packages as they depend on packages in that repository. <br />
If you are running an EL5 version: <a class="external text" href="http://download.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm">epel-release-5-4.noarch.rpm</a> <br />
If you are running an EL4 version: <a class="external text" href="http://download.fedoraproject.org/pub/epel/4/i386/epel-release-4-10.noarch.rpm">epel-release-4-10.noarch.rpm</a> <br />
You can verify these packages and their keys from the Fedora project's keys page: <a class="external free" href="https://fedoraproject.org/keys">https://fedoraproject.org/keys</a><br />
<br />
<h2 style="font-weight: normal;"><span style="font-size: small;"><b><span class="mw-headline" id="History_and_background_of_the_project"> History and background of the project </span></b></span></h2><h2 style="font-weight: normal;"><span style="font-size: small;"><b><span class="mw-headline" id="History_and_background_of_the_project"> </span></b></span></h2>The EPEL project was born when Fedora maintainers realized that the same infrastructure that builds and maintains packages would be great to also maintain add on packages for Enterprise Linux. Much of the early need was driven by what Fedora infrastructure needed on the RHEL machines that built and maintained Fedora. From there things have grown to a large collection of varied packages. See <a href="http://fedoraproject.org/wiki/History_and_Philosophy_of_EPEL" title="History and Philosophy of EPEL">our history and Philosophy page</a> for more information.<br />
<br />
<h2><span class="mw-headline" id="How_can_I_contribute.3F"> <span style="font-size: small;">How can I contribute? </span></span></h2><h2><span class="mw-headline" id="How_can_I_contribute.3F"><span style="font-size: small;"> </span></span></h2>The EPEL SIG is always looking for interested folks to help out. We always need package maintainers, qa/testers, bug triagers, marketing and documentation writers. Please see our <a href="http://fedoraproject.org/wiki/Joining_EPEL" title="Joining EPEL"> Joining EPEL</a> page for more information on how to join the SIG.<br />
<br />
<h2><span class="mw-headline" id="Communicating_with_the_EPEL_SIG" style="font-size: small;"> Communicating with the EPEL SIG </span></h2><h2><span class="mw-headline" id="Communicating_with_the_EPEL_SIG" style="font-size: small;"> </span></h2>There are many ways to communicate with the EPEL SIG and it's members: <br />
<ul><li> The #epel irc channel on irc.freenode.net offers real-time support for EPEL users and developers. </li>
</ul><ul><li> The <a class="external text" href="https://www.redhat.com/mailman/listinfo/epel-devel-list">epel-devel-list</a> is for general developer and SIG discussion. </li>
</ul><ul><li> The <a class="external text" href="http://lists.fedoraproject.org/mailman/listinfo/epel-announce">epel-announce</a> mailing list is a low volume mailing list for only important announcements. </li>
</ul><ul><li> The <a class="external text" href="http://lists.fedoraproject.org/mailman/listinfo/epel-package-announce">epel-package-announce</a> list is a list that gets information about package updates as they happen in the stable repository. </li>
</ul><ul><li> If you find a bug in a EPEL maintained package, please report it to <a class="external text" href="https://bugzilla.redhat.com/enter_bug.cgi?product=Fedora+EPEL">https://bugzilla.redhat.com/</a> under the "Fedora EPEL" component. </li>
</ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0BTrn7VgXIWGFG-Wf8Iz15ZRjFHvKSfipgUhigIYbvRJx5g5HnrtPGvRi_-3F1eczIhvPNn9McVew9cvOSE45_mN28pVQ6DnDpj7RwYvpRp-1ZG3uuLyQNO_0i1rm-x8qn0Nxvo0n8T8/s1600/542341.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0BTrn7VgXIWGFG-Wf8Iz15ZRjFHvKSfipgUhigIYbvRJx5g5HnrtPGvRi_-3F1eczIhvPNn9McVew9cvOSE45_mN28pVQ6DnDpj7RwYvpRp-1ZG3uuLyQNO_0i1rm-x8qn0Nxvo0n8T8/s1600/542341.png" /></a></div><ul><li> The EPEL SIG meets every week in the #fedora-meeting irc channel at 20:30UTC. Feel free to join us! Logs of past meetings can be found at: <a class="external free" href="http://meetbot.fedoraproject.org/teams/epel/">http://meetbot.fedoraproject.org/teams/epel/</a></li>
<li> </li>
</ul></div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-37551861711231240942011-08-22T11:53:00.000-07:002011-08-27T03:22:21.642-07:00Install virtualbox 4.x on ubuntu fedora<div class="fullpost"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgInPknb33fK_2EKTIWCiwr9FpY0CNY3vKq1uF12jrFMgH7-BtiVlduktp2VR63rlyemSqRo0vpmSefJEFY26nhuxKDWztRft7vVDKbubpuhqOKjkm7ovx8gzkrrDQrIMk2Kk6Wn9XdNdE/s1600/virtualbox-logo-small.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgInPknb33fK_2EKTIWCiwr9FpY0CNY3vKq1uF12jrFMgH7-BtiVlduktp2VR63rlyemSqRo0vpmSefJEFY26nhuxKDWztRft7vVDKbubpuhqOKjkm7ovx8gzkrrDQrIMk2Kk6Wn9XdNdE/s1600/virtualbox-logo-small.png" /></a></div><b>VirtualBox supports a large number of guest operating systems:</b><br />
<ul><li>Windows 3.x</li>
<li>Windows NT 4.0</li>
<li>Windows 2000</li>
<li>Windows XP</li>
<li>Windows Server 2003</li>
<li>Windows Vista</li>
<li>Windows 7</li>
<li>DOS</li>
<li>Linux (2.4 and 2.6)</li>
<li>Solaris</li>
<li>OpenSolaris</li>
<li>OpenBSD</li>
</ul><b>UBUNTU </b><br />
<br />
edit file repo nya.. </div><div class="fullpost">gksudo vi /etc/apt/sources.list</div><div class="fullpost"></div><div class="fullpost">tambahkan baris ini </div><div class="fullpost">deb http://download.virtualbox.org/virtualbox/debian natty contrib</div><div class="fullpost"></div><div class="fullpost">Save dan exit </div><div class="fullpost">wget -q http://download.virtualbox.org/virtualbox/debian/oracle_vbox.asc -O- | sudo apt-key add -</div><div class="fullpost"></div><div class="fullpost">Update Source </div><div class="fullpost">sudo apt-get update </div><div class="fullpost"><br />
</div><div class="fullpost">Install</div><div class="fullpost">sudo apt-get install virtualbox-4.0<br />
<br />
<br />
<b>FEDORA </b><br />
<br />
<h2 style="font-weight: normal;"><b><span style="font-size: small;">2. Install Fedora or RHEL Repo Files</span></b></h2><div class="wp_syntax"><div class="code"><pre class="bash" style="font-family: monospace;"><span style="font-size: small;"><span style="color: #7a0874; font-weight: bold;">cd</span> <span style="color: black; font-weight: bold;">/</span>etc<span style="color: black; font-weight: bold;">/</span>yum.repos.d<span style="color: black; font-weight: bold;">/</span>
<span style="color: #666666; font-style: italic;">## Fedora 15/14/13/12 and RHEL 6 users</span>
<span style="color: #c20cb9; font-weight: bold;">wget</span> http:<span style="color: black; font-weight: bold;">//</span>download.virtualbox.org<span style="color: black; font-weight: bold;">/</span>virtualbox<span style="color: black; font-weight: bold;">/</span>rpm<span style="color: black; font-weight: bold;">/</span>fedora<span style="color: black; font-weight: bold;">/</span>virtualbox.repo
<span style="color: #666666; font-style: italic;">## CentOS 5.6 and RHEL 5.6 users</span>
<span style="color: #c20cb9; font-weight: bold;">wget</span> http:<span style="color: black; font-weight: bold;">//</span>download.virtualbox.org<span style="color: black; font-weight: bold;">/</span>virtualbox<span style="color: black; font-weight: bold;">/</span>rpm<span style="color: black; font-weight: bold;">/</span>rhel<span style="color: black; font-weight: bold;">/</span>virtualbox.repo</span></pre><pre class="bash" style="font-family: monospace;"><span style="font-size: small;"> </span></pre><pre class="bash" style="font-family: monospace;"><span style="font-size: small;">atau </span></pre><pre class="bash" style="font-family: monospace;"><span style="font-size: small;">su -c 'curl http://download.virtualbox.org/virtualbox/rpm/fedora/virtualbox.repo > /etc/yum.repos.d</span></pre><pre class="bash" style="font-family: monospace;"><span style="font-size: small;">/virtualbox.repo; sed -i "s,enabled=0,enabled=1,g" /etc/yum.repos.d/virtualbox.repo' </span></pre><pre class="bash" style="font-family: monospace;"> </pre><h2><span style="font-size: small;">3. Update latest packages</span></h2><div class="wp_syntax"><div class="code"><pre class="bash" style="font-family: monospace;">yum update</pre><pre class="bash" style="font-family: monospace;"> </pre><pre class="bash" style="font-family: monospace;">atau</pre><pre class="bash" style="font-family: monospace;"></pre><pre class="bash" style="font-family: monospace;">su -c 'yum update; yum install -y VirtualBox-4.0 dkms gcc' </pre><pre class="bash" style="font-family: monospace;"> </pre></div></div><b>Note:</b> restart jika anda update kernel.<br />
<br />
<b>4. Install following dependency packages</b><br />
<br />
<span style="font-size: small;">yum install gcc kernel-devel kernel-headers<br />
<br />
## PAE kernel users install ##</span><br />
<span style="font-size: small;"><br />
yum install gcc kernel-PAE-devel kernel-headers</span> <br />
<br />
<b>5. Install VirtualBox Latest Version (current 4.1.0)</b><br />
<br />
yum install VirtualBox-4.1<br />
<br />
<h2><span style="font-size: small;">6. Add VirtualBox User to vboxusers Group</span></h2><div class="wp_syntax"><div class="code"><pre class="bash" style="font-family: monospace;"><span style="font-size: small;">usermod <span style="color: #660033;">-a</span> <span style="color: #660033;">-G</span> vboxusers user_name </span></pre><pre class="bash" style="font-family: monospace;"><span style="font-size: small;">
</span></pre></div></div><pre class="bash" style="font-family: monospace;"> </pre></div></div><b>7. Start VirtualBox</b><br />
<br />
VirtualBox<br />
<br />
</div><div class="fullpost"></div><div class="fullpost"></div><div class="fullpost"></div><div class="fullpost"></div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-87255467033830653252011-08-21T11:21:00.000-07:002011-08-21T11:21:52.062-07:00login root di GUI<div class="fullpost"><span class="" id="result_box" lang="id"><span class="hps">Di fedora 15 login sebagai root di GUI tidak bisa.dan bisa di akalin dengan sedikit konfigurasi..</span></span></div><div class="fullpost"><span class="" id="result_box" lang="id"><span class="hps"> </span></span></div><div class="fullpost"><span class="" id="result_box" lang="id"><span class="hps">PERINGATAN</span><span class="">:</span> <span class="hps">-</span> <span class="hps">Sebenarnya tidak</span> <span class="hps">baik</span> <span class="hps">untuk login</span> <span class="hps">sebagai root</span> <span class="hps">dari GUI</span><span class="">.</span> <span class="hps">Ini</span> <span class="hps">BERBAHAYA</span><span class="">.</span> <span class="hps">TAPI jika</span> <span class="hps">ada orang</span> <span class="hps">ingin tahu</span> <span class="hps">bahwa cara untuk</span> <span class="hps">login sebagai</span> <span class="hps">root dari</span> <span class="hps">GUI</span> <span class="hps">kemudian ikuti petunjuk</span><span class=""> ini.</span></span></div><div class="fullpost"><span class="" id="result_box" lang="id"><span class=""><br />
</span></span></div><div class="fullpost"><span class="" id="result_box" lang="id"><span class="hps">Di Fedora</span> <span class="hps">15</span> <span class="hps">Anda tidak dapat</span> <span class="hps">login sebagai</span> <span class="hps">root dari</span> <span class="hps">gui</span><span class="">.</span> <span class="hps">Dengan</span> <span class="hps">default</span><span class="">, hanya user</span> <span class="hps">normal</span> <span class="hps">yang diizinkan untuk</span> <span class="hps">login dari</span> <span class="hps">modus</span> <span class="hps">gui</span><span class="">.</span><br />
<br />
<span class="hps">Saya</span> <span class="hps">Berhasil</span> <span class="hps">Login</span> <span class="hps">sebagai</span> <span class="hps">root dari</span> <span class="hps">GUI pada</span> <span class="hps">Fedora</span> <span class="hps">15</span><span class="">.</span> <span class="hps">Ikuti langkah-langkah</span> <span class="hps">dan Anda akan</span> <span class="hps">mampu</span> <span class="hps">Login</span> <span class="hps">sebagai</span> <span class="hps">root dari</span> <span class="hps">GUI pada</span> <span class="hps">Fedora</span> <span class="hps">15</span><br />
<br />
<span class="hps">Jika</span> <span class="hps">Anda</span> <span class="hps">ingin</span> <span class="hps">login sebagai</span> <span class="hps">root dari</span> <span class="hps">GUI</span> <span class="hps">di Fedora</span> <span class="hps">15</span> <span class="hps">maka Anda</span> <span class="hps">harus mengedit</span> <span class="hps"></span><span class="hps">file / etc</span> <span class="hps">/</span> <span class="hps">pam.d</span> <span class="hps">/</span></span></div><div class="fullpost"></div><div class="fullpost">Step 1 :- [ardy@bundanarty]$ su – root<br />
Password:-<br />
<br />
Step 2:- masuk ke /etc/pam.d/ directory.<br />
<b>[root@ask4itsolutions]# cd /etc/pam.d/</b><br />
<b> # cp gdm gdm.bkp</b><br />
<div style="background-color: transparent; border: medium none; color: black; overflow: hidden; text-align: left; text-decoration: none;"><br />
Step 3 : edit file gdm dengan editor kesukaan kalian<br />
[root@ask4itsolutions pam.d]# vi gdm<br />
<br />
<b>cari baris ini..hapus atau beri komentar saja<br />
auth required pam_succeed_if.so user != root quiet</b><br />
<br />
Step 4 :- Save & Exit<br />
<br />
Step 5 :-cp gdm-password gdm-password.bkp<br />
<br />
<b>[root@ask4itsolutions.com pam.d]#vi gdm-password</b><br />
<br />
<b>cari baris ini..hapus atau beri komentar saja</b><b> </b><br />
<b>auth required pam_succeed_if.so user != root quiet</b><br />
<b><br />
Step 6 :- Save & Exit .</b><br />
<b>reboot dan coba</b><br />
<b> </b><br />
Thanks.semoga bermanfaat<br />
<div style="background-color: transparent; border: medium none; color: black; overflow: hidden; text-align: left; text-decoration: none;"><br />
</div><br />
<div style="background-color: transparent; border: medium none; color: black; overflow: hidden; text-align: left; text-decoration: none;"><br />
</div></div></div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-29000065724655182302011-08-21T09:44:00.000-07:002011-08-21T09:47:46.648-07:00install flash player di fedora dan centos<div class="fullpost"><pre class="bash" style="color: red; font-family: monospace;"><span style="font-size: small; font-weight: bold;"># sudo</span><span style="font-size: small;"> -i
</span><span style="font-size: small; font-style: italic;">## OR ##</span><span style="font-size: small;">
</span><span style="font-size: small; font-weight: bold;"># su</span><span style="font-size: small;"> </span></pre><pre class="bash" style="color: red; font-family: monospace;"><span style="font-size: small;"> </span></pre><pre class="bash" style="color: red; font-family: monospace;"><b><span style="font-size: small;"> </span><span style="color: black; font-size: small;">Install Adobe YUM Repository RPM package </span></b></pre><pre class="bash" style="color: red; font-family: monospace;"><span style="color: black; font-size: small;"> </span></pre><pre class="bash" style="color: red; font-family: monospace;"><span style="font-size: small;"># rpm -ivh http:</span><span style="font-size: small; font-weight: bold;">//</span><span style="font-size: small;">linuxdownload.adobe.com</span><span style="font-size: small; font-weight: bold;">/</span><span style="font-size: small;">adobe-release</span><span style="font-size: small; font-weight: bold;">/</span><span style="font-size: small;">adobe-release-i386-1.0-1.noarch.rpm
# rpm --import </span><span style="font-size: small; font-weight: bold;">/</span><span style="font-size: small;">etc</span><span style="font-size: small; font-weight: bold;">/</span><span style="font-size: small;">pki</span><span style="font-size: small; font-weight: bold;">/</span><span style="font-size: small;">rpm-gpg</span><span style="font-size: small; font-weight: bold;">/</span><span style="font-size: small;">RPM-GPG-KEY-adobe-linux </span></pre><pre class="bash" style="color: red; font-family: monospace;"><span style="font-size: small;"> </span></pre><pre class="bash" style="color: red; font-family: monospace;"><span style="color: black; font-size: small;">Update Repositories</span></pre><pre class="bash" style="color: red; font-family: monospace;"><span style="color: black; font-size: small;"> </span></pre><pre class="bash" style="color: red; font-family: monospace;"><span style="font-size: small;"># yum check-update</span></pre><pre class="bash" style="color: red; font-family: monospace;"><span style="font-size: small;"> </span></pre><pre class="bash" style="color: red; font-family: monospace;"><b><span style="color: black; font-size: small;">Untuk Fedora 15, Fedora 14, Fedora 13, Fedora 12 and Red Hat (RHEL) 6 </span></b></pre><pre class="bash" style="color: red; font-family: monospace;"><b><span style="color: black; font-size: small;"> Fedora 15/14/13/12 and Red Hat (RHEL) 6 32-bit version (i686)</span></b></pre><pre class="bash" style="color: red; font-family: monospace;"><span style="color: black; font-size: small;"> </span></pre><pre class="bash" style="font-family: monospace;"><span style="color: red; font-size: small;"># yum install flash-plugin nspluginwrapper alsa-plugins-pulseaudio libcurl </span></pre><pre class="bash" style="font-family: monospace;"><span style="font-size: small;">-------------------------------------------------------------------------------
</span></pre><h3 style="font-weight: normal;"><b><span style="font-size: small;">Fedora 15/14/13/12 and Red Hat (RHEL) 6 64-bit version_ (x86_64) (32 bit wrapped version) </span></b></h3><h3 style="font-weight: normal;"><span style="font-size: small;"><span style="color: red; font-size: x-small;"> #yum install flash-plugin nspluginwrapper.x86_64 \ </span><span style="font-size: x-small;"><br style="color: red;" /></span><span style="color: red;"><span style="font-size: x-small;">nspluginwrapper.i686 alsa-plugins-pulseaudio.i686 libcurl.i68</span>6</span></span></h3><h3 style="color: black; font-weight: normal;"><span style="font-size: small;"> <b>DICENTOS 5.5 dan 5.6 / CentOS and Red Hat 32-bit version (i386)</b></span></h3><pre class="bash" style="color: red; font-family: monospace;"><span style="font-size: small;"># yum groupinstall "Sound and Video"
# yum </span><span style="font-size: small; font-weight: bold;">install</span><span style="font-size: small;"> flash-plugin nspluginwrapper curl</span></pre><pre class="bash" style="font-family: monospace;"><b><span style="font-size: small;"> </span></b></pre><pre class="bash" style="font-family: monospace;"><span style="font-size: small;"><b>edit /etc/yum.repos.d/CentOS-Base-i386.repo </b></span></pre><pre class="bash" style="font-family: monospace;"><span style="font-size: small;"> </span></pre><pre class="bash" style="font-family: monospace;"><span style="color: lime; font-size: small;">[base-i386]</span><span style="font-size: small;">
</span><span style="color: lime; font-size: small;">name=CentOS-5.6 - Base i386</span><span style="font-size: small;">
</span><span style="color: lime; font-size: small;">baseurl=http://mirror.centos.org/centos/5/os/i386/</span><span style="font-size: small;">
</span><span style="color: lime; font-size: small;">gpgcheck=1</span><span style="font-size: small;">
</span><span style="color: lime; font-size: small;">gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5</span></pre><pre class="bash" style="font-family: monospace;"><span style="color: lime; font-size: small;"> </span></pre><pre class="bash" style="font-family: monospace;"><b><span style="font-size: small;">install</span></b></pre><pre class="bash" style="font-family: monospace;"><span style="font-size: small;"> </span></pre><pre class="bash" style="font-family: monospace;"><span style="color: red; font-size: small;"># yum install flash-plugin nspluginwrapper alsa-utils.i386 \ </span><span style="font-size: small;">
</span><span style="color: red; font-size: small;"># sox.i386 vorbis-tools.i386 curl.i386 alsa-utils.x86_64 \ </span><span style="font-size: small;">
</span><span style="color: red; font-size: small;"># sox.x86_64 vorbis-tools.x86_64 curl.x86_64</span></pre><h3 style="font-weight: normal;"><span style="font-size: x-small;"><b><span style="color: red;"> </span></b> </span></h3><pre class="bash" style="font-family: monospace;"></pre></div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-6525475776468409582011-08-21T02:30:00.000-07:002011-08-21T02:30:15.710-07:00Apa itu Load Balancing ??<div class="fullpost" style="color: black;"><span style="font-family: Verdana;"><h5>Secara harafiah, load balancing adalah pembagian beban menjadi <br />
seimbang (balance). Begitu juga artinya dalam dunia internet, server <br />
farm, dan jaringan komputer, load balancing adalah proses distribusi <br />
beban terhadap sebuah servis yang ada pada sekumpulan server atau <br />
perangkat jaringan ketika ada permintaan dari pengguna. Maksudnya <br />
adalah ketika sebuah sever sedang diakses oleh para pengguna, maka <br />
server tersebut sebenarnya sedang dibebani kerena harus melakukan <br />
proses terhadap permintaan para penggunanya. Jika penggunanya <br />
banyak, maka proses yang dilakukan juga menjadi banyak. <br />
<br />
Session-session komunikasi dibuka oleh serber tersebut untuk <br />
memungkinkan para penggunanya menikmati servis dari server <br />
tersebut. Jika satu server saja yang dibebani, tentu server tersebut <br />
tidak akan dapat melayani banyak pengguna karena kemampuannya <br />
dalam melakukan processing ada batasnya. Batasan ini bisa berasal <br />
dari banyak hal, misalnya kemampuan processing-nya, bandwidth <br />
internetnya, dan banyak lagi. <br />
<br />
Untuk itu, solusi yang paling ideal adalah dengan membagi-bagi beban <br />
yang datang tersebut ke beberapa server. Jadi, yang berugas <br />
melayani pengguna tidak hanya terpusat pada satu perangkat saja. <br />
Inilah yang disebut sistem load balancing. <br />
<br />
Misalnya ketika Anda mengakses ke situs www.detik.com, maka web <br />
server yang berisi dokumen-dokumen berita, akan langsung melayani <br />
Anda. Server tersebut memberikan apa yang Anda minta dengan <br />
membuka komunikasi menggunakn servis HTTP port 80. Informasi <br />
halaman utama akan langsung dikirimkan ke PC melalui port 80 <br />
tersebut, sehingga Anda dapat melihatnya di halaman browser. <br />
<br />
Ketika Anda meng-klik suatu link pada halaman web tersebut, <br />
permintaan Anda kemudian diproses kembali oleh server. Web server <br />
akan melayani permintaan Anda lagi dengan berbagai cara yang telah <br />
ditentukan oleh pengelolanya, apakah mengarahkan Anda kedalam <br />
folder tertentu, menjalankan script-script tertentu, mengirimkan <br />
gambar, memutar klip suara, dan banyak lagi. Pada saat ini, server <br />
detik.com sedang terbebani oleh permintaan Anda. Hingga halaman <br />
atau layanan yang Anda minta terbuka, maka selesailah proses <br />
tersebut dan server kembali bebas dari beban. <br />
<br />
Jika yang mengakses halaman web www.detik.com hanya Anda <br />
seorang, tentu sistem load balancing tidak diperlukan, karena sebuah <br />
server tentu masih sangat cukup untuk melayani permintaan Anda. <br />
Namun apa jadinya jika www.detik.com dibuka oleh hampir sebagian <br />
besar pengguna internet di Indonesia, setiap detik, dan setiap hari <br />
seperti keadaan saat ini. Mungkin sebuah server saja tidak akan <br />
sanggup melayani permintaan seberat itu. Permintaan akan terus <br />
datang dan proses juga akan terus-menerus dilaku</h5></span></div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-30094244226308636132011-08-19T06:05:00.000-07:002011-08-19T06:37:18.282-07:00Cerita tentang 32-bit dan 64-bit<div class="fullpost">Bingung mau pilih Windows yang mana untuk dipakai di rumah? Atau mau mulai mengikuti trend 64-bit? Coba baca dulu ini sebelum mengambil keputusan. Mudah2an bermanfaat.:D</div><div class="fullpost"></div><div class="fullpost"><span style="font-size: medium;"><u>Ilustrasi</u></span><br />
Si Bolang dan Si Aming sedang berada di Mangga Dua, Jakarta. Setelah pegal mencari-cari spare part computer dan menawar2 harga selama berjam2, akhirnya PC impian mereka selesai dirakit juga.<br />
<br />
Berikut spek computer mereka secara umum :<br />
<br />
<b>Komputer Bolang<br />
---------------- <br />
Prosesor dual core<br />
2 GB RAM<br />
VGA OnBoard<br />
<br />
Komputer Aming<br />
---------------<br />
Prosesor quad core terbaru<br />
8 GB RAM<br />
VGA Gaming terbaru</b><br />
<br />
Setelah itu mereka terlibat percakapan tentang sistem operasi windows apa yang akan mereka install ke dalam PC mereka masing-masing.<br />
<br />
<span style="font-family: Comic Sans MS;"><span style="font-size: small;">Bolang : Ming, lu udah tau mau install windows apa? Windows XP atau Vista?<br />
Aming : Gua sih ga suka yang ribet2 Lang, gw mau yang standar lah…XP aja.<br />
Bolang : Lu mau install yang XP 32 bit apa 64 bit?<br />
Aming : Hah apaan tuh? Gw kagak ngarti…yang gw tau windows tu XP, Vista<br />
Bolang : Ahh ga gaul lu Ming…makanya belajar dong biar cepet pinter!</span> </span></div><div class="fullpost"><br />
</div><div class="fullpost"><b><span style="color: royalblue;"><span style="font-size: medium;">Fakta-fakta # 1</span><br />
<span style="font-size: small;">Kebanyakan orang awam tidak mengerti tentang Windows 32 bit atau 64 bit.</span></span></b></div><div class="fullpost"></div><div class="fullpost"><span style="font-family: Comic Sans MS;"><span style="font-size: small;">Aming : wah gak ngarti gw yang begituan Lang…gw mah yang pasti2 aja deh…<br />
Bolang : ah..payah lu Ming.. spek computer lu doank yang keren! Tapi lu sendiri ga bisa mengoptimalkan computer lu sampe maksimal. Makanya jgn maen game online mulu!<br />
Aming : ya lu ajarin gw dong Lang. Gw cocoknya pake yang mana nih?<br />
Bolang : siip gw ajarin ya skrg</span></span><span style="color: royalblue;"><span style="font-size: small;"> </span></span></div><div class="fullpost"><span style="color: royalblue;"><span style="font-size: small;"><br />
</span></span></div><div class="fullpost">OK. Sekarang anggaplah komputer itu adalah sebuah mobil.. mobil Si Bolang bisa kita ibaratkan adalah sebuah Honda Jazz. </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiadm8828JxYD8iBh2FaYn6OeeFStx9lNg-c6ZpL4rgPNEPIo9uTl6SDcmnKztOx7I6k-JPHQpFPKYlwqh8PAYOzDPgqgW-f_gIaGtuyhQXTeXcmjPs3BNc_-6yPDsiv-ZjsJ1MdxC_sbA/s1600/Honda-Jazz-Concept-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="197" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiadm8828JxYD8iBh2FaYn6OeeFStx9lNg-c6ZpL4rgPNEPIo9uTl6SDcmnKztOx7I6k-JPHQpFPKYlwqh8PAYOzDPgqgW-f_gIaGtuyhQXTeXcmjPs3BNc_-6yPDsiv-ZjsJ1MdxC_sbA/s320/Honda-Jazz-Concept-1.jpg" width="320" /></a></div>Sedangkan mobil Si Aming bisa kita ibaratkan dengan sebuah Pagani Zonda.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEGTIr3puH6D8gkIyOpZlbevVuxcNZVWiooS0uD8M1i-BxNMarlZI6mEUW0n20JfgG_1ClZOEpH5Jz6iDawrwUdLGolk5ekMwuMLD2tQT6vbnZIyZNDJZYG8Mv1a6mFdHobsURWrlh1Kk/s1600/2005-Pagani-Zonda-F-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="183" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEGTIr3puH6D8gkIyOpZlbevVuxcNZVWiooS0uD8M1i-BxNMarlZI6mEUW0n20JfgG_1ClZOEpH5Jz6iDawrwUdLGolk5ekMwuMLD2tQT6vbnZIyZNDJZYG8Mv1a6mFdHobsURWrlh1Kk/s320/2005-Pagani-Zonda-F-1.jpg" width="320" /></a></div>Lalu sekarang kita anggap Windows 32 bit adalah jalan biasa, dan Windows 64 bit adalah jalan tol bebas hambatan.<br />
Sekarang mari kita terjemahkan keinginan mereka menginstall versi Windows yang mereka inginkan dengan spek komputer yang mereka punya.<br />
<br />
<b><span style="color: royalblue;"><span style="font-size: medium;">Fakta-fakta # 2</span><br />
<span style="font-size: small;">Windows 32-bit hanya support memory max. 4 GB.<br />
Windows 64-bit support memory max 192 GB. WOW!</span></span></b><br />
<br />
Apabila Bolang menginstall Windows 32 bit ke dalam komputernya, semuanya akan berjalan dengan baik-baik saja. Honda Jazz yang dibawa ke dalam jalanan kota. Pilihan yang tepat mengingat Bolang hanya punya memory 2 GB. Tapi karena VGA Bolang adalah onboard alias makan memory fisik, ada baiknya Bolang menambah memory lagi supaya lebih lancar.<br />
<br />
Akan tetapi apabila Si Aming menginstall Windows 32 bit ke dalam komputernya, semuanya juga akan berjalan dengan baik2 saja, tapi pilihan ini mempunyai beberapa kelemahan. Ibarat mobil sport super Pagani Zonda yang sangat cepat dibawa ke dalam jalanan kota, potensi penuhnya tidak akan terlihat. Oleh karena itu untuk memaksimalkan hardware yang dia punya, sebaiknya Aming memakai Windows 64-bit. Apabila Aming memakai Windows 32 bit, maka memorynya yang 8 GB tidak akan terdeteksi sepenuhnya (4 GB RAM sia-sia! numpang mejeng aje di dalam casing <img alt="" border="0" class="inlineimg" src="http://static.kaskus.us/images/smilies/sumbangan/14.gif" title="Big Grin" /><br />
<br />
<br />
<br />
<b><span style="color: royalblue;"><span style="font-size: medium;">Fakta-fakta # 3</span><br />
<span style="font-size: small;">Windows Vista/Seven x64 lebih baik daripada Windows XP x64. Ini karena Windows XP x64 sebenarnya adalah jelmaan Windows Server 2003!</span></span></b><br />
<span style="color: royalblue;"><span style="font-size: small;"> </span></span><span style="color: royalblue;"><span style="font-size: small;"> </span></span><br />
Sekarang Si Aming memilih untuk menginstall Windows 64 bit. Tapi Windows 64 bit yang mana? XP? Vista? Seven? Menurut pengalaman penulis, <b>dukungan program dan driver Windows Vista/Seven x64 lebih baik daripada Windows XP x64</b>. Penulis suatu waktu pernah ingin menginstall software bawaan digital camera di Windows XP x64, tapi tidak berhasil, ada pesan error: Not supported for this OS. Tetapi saat penulis menginstall di Windows Vista x64, tidak ada masalah sama sekali!<br />
Usut punya usut ternyata Windows XP x64 adalah jelmaan Windows Server 2003, dan memang di CD digital camera itu tertulis : For Windows XP and Vista. (Tidak ada Windows Server 2003 kan?!)<br />
<br />
<span style="color: royalblue;"><span style="font-size: small;"><br />
</span></span><br />
Sekarang harga memory sudah sangat murah. Bandingkan dengan jaman dulu waktu 1 keping DDR1 128 MB saja harganya bisa 250 ribu! <br />
Makin banyak memory yang terinstall di komputer kita, makin lancar kegiatan komputasi kita, karena kebutuhan Windows untuk virtual memory semakin berkurang. Memory fisik dan memory virtual bagaikan langit dan bumi.<br />
<br />
Mungkin memory ideal untuk jaman sekarang adalah 4 GB. Ini karena sekarang program2 makin rakus memory, terutama game dan software design/multimedia.<br />
<br />
<i>Fun Facts! Di software motion graphic, Adobe After Effect, di sistem yang sama2 punya memory 4 GB, apabila memakai windows 32-bit, memory yang bisa dipakai hanya 2 GB. Sedangkan di windows 64-bit, memory yang bisa dipakai seluruhnya 4 GB. Ini bisa dilihat di 'splash screen' pada saat membuka program tsb.</i><br />
Contoh : Bila kita membeli sebuah VGA card baru, tentunya kita diberi sebuah CD berisi driver untuk VGA tersebut. Namun seringkali driver tersebut adalah driver 32 bit. <br />
<br />
Bila anda memutuskan untuk memakai Windows 64 bit, downloadlah driver 64 bit terbaru dari vendor hardware anda. <br />
----------------------<br />
Ok, sekarang kita kembali lagi ke Bolang dan Aming.<br />
<br />
<span style="font-family: Comic Sans MS;"><span style="font-size: small;">Bolang : Gimana Ming, lu udah ngarti belum?<br />
Aming : Udah Lang..tapi gw masih ada pertanyaan nih. Bisa nggak gw pake dua2nya 32 bit ama 64 bit?<br />
Bolang : Ya bisa dong. Pake dual boot.<br />
Aming : Gimana caranya tu Lang?<br />
Bolang : Lu googling aja deh!</span></span><br />
<br />
Akhirnya sampai di rumah, si Aming menginstall Windows Vista 64 bit.<br />
Sesudah itu, Aming :<br />
<br />
<ul><li>membuka Firefox untuk ngaskus</li>
<li>buka Photoshop buat ngedit gambar pertamax</li>
<li>download film pake IDM</li>
<li>dengerin lagu pake iTunes</li>
<li>Jalanin bot RO</li>
<li>Chating pake YM</li>
<li>main game Call of Duty Modern Warfare 2,<b><span style="font-size: small;"><u> </u></span></b></li>
</ul>Jangan ada yang protes ya! Aming kan punya memory 8 GB & Quad core terbaru! Dilarang ngiri!:D<br />
<br />
<br />
<a href="http://www.belajarpc.info/bagaimana-memeriksa-processor-x86-32-bit-atau-x64-64-bit-pada-windows.htm">Bagaimana Memeriksa Processor x86 (32-bit) atau x64 (64-bit) pada Windows? </a>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-80562717690432612442011-08-18T05:31:00.000-07:002011-08-18T23:35:01.260-07:00install pidgin di ubuntu<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="http://imherry.blogdetik.com/files/2011/05/pidgin_logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="147" src="http://imherry.blogdetik.com/files/2011/05/pidgin_logo.png" width="320" /><span class="data-post"><b> </b></span></a></div><div style="text-align: left;"><span class="data-post"><b>Pidgin</b> adalah multi account Messenger Instant. Pidgin ini mendukung ICQ, IRC, MSN, Gtalk, SILC, Jabber, AOL dan banyak lainnya.</span><br />
<span class="data-post"> </span><br />
<span class="data-post"> Anda dapat men-download Pidgin untuk Windows, Mac, CentOS dan Fedora dari halaman download.</span><br />
<span class="data-post"> </span><br />
<span class="data-post"> Untuk menginstal <b>Pidgin 2.8.0</b> di Ubuntu 11.04 Natty Narwhal, ketik perintah berikut di terminal anda:</span></div><div class="separator" style="clear: both; text-align: center;"><span class="data-post"> <br style="color: lime;" /><span style="color: lime;"> </span></span></div><div class="alert" style="color: lime; font-family: "Courier New",Courier,monospace;">sudo add-apt-repository ppa:ferramroberto/pidgin</div><div class="alert" style="color: lime; font-family: "Courier New",Courier,monospace;">sudo apt-get update</div><div class="alert" style="color: lime; font-family: "Courier New",Courier,monospace;">apt-get install pidgin<br />
<br />
<br />
<div style="color: black;"><br />
</div><b style="color: black;">CARA MUDAH MENGGANTI GRUB UBUNTU </b><br />
<br />
sudo add-apt-repository ppa:danielrichter2007/grub-customizersudo apt-get update<br />
sudo apt-get install grub-customizer</div><br />
<div class="fullpost"></div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-31557258880108600412011-08-15T08:53:00.000-07:002011-08-22T05:24:51.752-07:00Masih Ketergantungan sama Windows<div class="fullpost">mahasiswa itu emang ga pernah lepas dengan yang namanya Windows..ckck</div><div class="fullpost">padahal lagi coba-coba mainin linux....<br />
<br />
</div><div class="fullpost"></div><div class="fullpost"></div><div class="fullpost" style="color: lime;">sudo add-apt-repository ppa:ubuntu-wine/ppa<br />
sudo apt-get update<br />
sudo apt-get install wine1.3<br />
<br />
</div><div class="fullpost"></div><div class="fullpost"></div><div class="fullpost">Terpaksa de....<br />
<br />
<b>HAPUS MENU SHORCUT APPLIKASI</b><br />
<br />
<span style="color: black;">Saya pernah mencoba menginstall program-program under Windows di Ubuntu. Namun saya merasa tidak nyaman, mengapa?</span><br />
<span style="color: black;">Yach...nanti jadi nggak opensource lagi, nggak freeware lagi dong. Trus akhirnya saya uninstall deh program-program under Wine tersebut. </span><br />
<span style="color: black;">Tapi saya merasa risi karena Wine beserta program-programnya masih nampak di menu.</span><br />
<span style="color: black;">Setelah bingung dan </span><span style="color: black; font-style: italic;">googling</span><span style="color: black;"> akhirnya saya menemukan caranya. Berikut caranya:</span><br />
<span style="color: black;">Menu program tersebut biasanya untuk per-user disimpan dibawah</span><br />
<br />
<span style="color: #009900;">$HOME/.config/menus/applications-merged/</span><br />
<br />
<span style="color: #009900;"><span style="color: black;">dan</span> </span><br />
<br />
<span style="color: #009900;">$HOME/.local/share/applications/wine/Programs/</span><br />
<br />
<span style="color: black;">Tinggal hapus </span><span style="color: black; font-style: italic;">(delete)</span><span style="color: black;"> aja program Wine beserta program-program di bawahnya.</span><br />
<span style="color: black;">Jadi bersih deh dari Wine dan nggak jadi mabuk lagi. </span><br />
<br />
<span style="color: black;">Cek directory berikut:<br />
<br />
<span style="color: lime;">~/.local/share/desktop-directories</span><br style="color: lime;" /><span style="color: lime;">~/.local/share/applications/wine</span><br style="color: lime;" /><span style="color: lime;">~/.config/menus/applications-merged</span><br />
<br />
hapus yang berhubungan dengan aplikasi wine yang diremove. Kalau perlu<br />
buang iconnya juga sekalian cek directory:<br />
<br />
<span style="color: lime;">~/.local/share/icons </span></span><br />
<br />
<br />
<span style="color: black;"><span style="color: lime;"><span style="color: black;">UNINSTALL WINE </span></span></span><br />
<br />
sudo apt-get remove wine<br />
rm -rf $HOME/.wine<br />
rm -f $HOME/.config/menus/applications-merged/wine*<br />
rm -rf $HOME/.local/share/applications/wine<br />
rm -f $HOME/.local/share/desktop-directories/wine*<br />
rm -f $HOME/.local/share/icons/????_*.xpm<span style="color: black;"><span style="color: lime;"><span style="color: black;"> </span></span></span></div><div class="fullpost"></div><div class="fullpost"></div><div class="fullpost"></div><div class="fullpost"></div><div class="fullpost"><br />
</div><div class="fullpost"><br />
</div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-4737871801425264682011-07-20T11:29:00.000-07:002011-07-20T11:32:59.657-07:00simpan gambar di vb.net dengan type bloob di mysql<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCktry77AVu7aAlXsbI848tLsTKaZK2eGKc1orDzn1eY1_eGdESGzkc8bZ6DrF-M03O8dFaICEnZB-fascvcVAGdePA_XQNB2CeS8Ff-moQCBshHNWxco7aP-MOzQXAqwopwpECcP47QU/s1600/Untitleccd-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="229" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCktry77AVu7aAlXsbI848tLsTKaZK2eGKc1orDzn1eY1_eGdESGzkc8bZ6DrF-M03O8dFaICEnZB-fascvcVAGdePA_XQNB2CeS8Ff-moQCBshHNWxco7aP-MOzQXAqwopwpECcP47QU/s320/Untitleccd-1.jpg" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCktry77AVu7aAlXsbI848tLsTKaZK2eGKc1orDzn1eY1_eGdESGzkc8bZ6DrF-M03O8dFaICEnZB-fascvcVAGdePA_XQNB2CeS8Ff-moQCBshHNWxco7aP-MOzQXAqwopwpECcP47QU/s1600/Untitleccd-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br />
</a></div><br />
Dim connstr As String<br />
connstr = "server=localhost;user id=root;password=;database=aldie;"<br />
<br />
Try<br />
'membaca isi steram<br />
fs = New FileStream(currfile, FileMode.Open, FileAccess.Read)<br />
<br />
'mendapatkan ukuran file<br />
ukuran = fs.Length<br />
Dim rawdata() As Byte = New Byte(ukuran) {}<br />
fs.Read(rawdata, 0, ukuran)<br />
fs.Close()<br />
<br />
Dim sql As String = "select * from jenisbarang"<br />
conn = New MySqlConnection(connstr)<br />
conn.Open()<br />
<br />
adapter = New MySqlDataAdapter(sql, conn)<br />
Dim cmdbuilder As MySqlCommandBuilder = New MySqlCommandBuilder(adapter)<br />
Dim ds As DataSet = New DataSet("jenisbarang")<br />
<br />
'mengsi data adapter<br />
adapter.Fill(ds, "jenisbarang")<br />
<br />
Dim row As DataRow = ds.Tables("jenisbarang").NewRow()<br />
row("kdjenis") = txtkdjenis.Text<br />
row("nmjenis") = txtnmjenis.Text<br />
row("nama_file") = Path.GetFileName(txtphoto.Text)<br />
row("ukuran") = ukuran<br />
row("file") = rawdata<br />
<br />
'meemasukan row<br />
ds.Tables("jenisbarang").Rows.Add(row)<br />
'menyimpan perubahan ke database<br />
adapter.Update(ds, "jenisbarang")<br />
MsgBox("data berhasil di masukan", MsgBoxStyle.Information, "insertok")<br />
mycn.tutupkoneksi()<br />
bersihkantext()<br />
<br />
'clear textbox dan piccturebox<br />
txtkdjenis.Text = "" : txtnmjenis.Text = ""<br />
txtphoto.Text = "" : txtkdjenis.Focus()<br />
Catch ex As Exception<br />
MsgBox("failed to insert : " + ex.Message)<br />
End Try<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzhMiG2Q2wSyCBDgcCmZMB6A-Eo7NRTjEllfhFZ5qMz7-NMnATRtvh8wuOvJNS5OD3tswrBrp5BSCSXZNukrlmlbnoiP0ytys_IfK2uv5Jno3pgd4Z9rCD2LjQoFObJie3i0Sag_Ibm2s/s1600/Untitled-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="308" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzhMiG2Q2wSyCBDgcCmZMB6A-Eo7NRTjEllfhFZ5qMz7-NMnATRtvh8wuOvJNS5OD3tswrBrp5BSCSXZNukrlmlbnoiP0ytys_IfK2uv5Jno3pgd4Z9rCD2LjQoFObJie3i0Sag_Ibm2s/s320/Untitled-1.jpg" width="320" /></a></div><br />
narsis dikit ga papa kan..heheas romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-49813348060744380292011-07-20T09:28:00.000-07:002011-07-20T09:28:13.253-07:00suara di vb.net<div class="fullpost" style="color: red;"><pre>Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim SAPI
SAPI = CreateObject("SAPI.spvoice")
SAPI.Speak("<b>Welcome to the 13th visual basic .net tutorial</b>")
End Sub
End Class</pre></div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-75136325007976061392011-07-14T00:59:00.000-07:002011-07-14T00:59:59.719-07:00Membatasi Karakter Input TextBoxMungkin Anda pernah menginginkan agar sebuah TextBox hanya boleh atau bisa diisi dengan karakter input tertentu, seperti hanya karakter "R" dan "A" saja, atau mungkin hanya karakter "I" dan karakter angka saja, atau yang lain.<br />
Berikut ini satu baris kode yang bisa Anda gunakanuntuk melakukannya. Sebagai contoh, buatlah sebuah kontrol TextBox di dalam Form. Lalu ketikkan kode berikut di bagian 'TextBox1_KeyPress' -nya :<br />
<b>[ VB 6.0 ]</b><br />
<div style="-moz-background-inline-policy: continuous; background: none repeat scroll 0% 0% rgb(255, 255, 204); border: 1px dotted rgb(245, 0, 61); padding: 2px;">If (InStr("<b>ARDY</b>", Chr(KeyAscii)) = 0) And (KeyAscii <> 8) Then KeyAscii = 0</div><a href="http://www.blogger.com/post-edit.g?blogID=5410335310491913287&postID=7513632500797606139" name="more"></a><br />
<b>[ VB .NET ]</b><br />
<div style="-moz-background-inline-policy: continuous; background: none repeat scroll 0% 0% rgb(255, 255, 204); border: 1px dotted rgb(245, 0, 61); padding: 2px;">If (InStr("<b>ARDY</b>", e.KeyChar) = 0) And (e.KeyChar <> Chr(8)) Then e.KeyChar = Chr(0)</div>Contoh diatas menunjukkan bagaimana TextBox hanya bisa diisi karakter "A", "R", "D", dan "Y" saja. Jika Anda menginginkan karakter yang lain, tinggal menggati teks yang berwarna merah dengan karakter-karakter yang hanya boleh diinputkan. Misalnya Anda ingin hanya krakter "T" dan karakter angka saja, tinggal menggantikannya dengan "T0123456789"as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-65786577794900874012011-07-11T02:31:00.000-07:002011-07-11T02:36:12.283-07:00uas yang super keren!!<div class="fullpost">curhat dikit..haha</div><div class="fullpost"></div><div class="fullpost">hari senin yang indah..ngopi pagi-pagi bersiap untuk berangkat ujian implementasi jarkom..saya merasa sudah siap karena semua sudah saya siapkan..saya mulai duduk di bangku komputer..dan melihat soal..weihh mantab..dah di luar kepala..haha sedikit sombong...eeeeeehhhhh.dosennya dateng..ngasih tambahan ini itu ini itu,,haha..okelah bisa di atur...gampang...pas udah selesai setting DNS..dan jalan..tinggal setting webserver dan phpnya....WHAT THE FUCK..ternyata flashdisk nya ga bisa masuk ke virtual servernya..sepertinya di disable..waaaaaaaasssuuuurrrrrrrrrrrrrr...semua file yang udah saya bikin..ga bisa di masukin donk?? waduhh gmana ini..putar otak..akhirnya ada ide dengan masukin file-file konfigurasinya di web..dan tinggal di download di virtual servernya..dan bisa...tapi sayang karena saya kehabisan waktu..<br />
<br />
</div><div class="fullpost"></div><div class="fullpost">dan yang saya sesalkan..kenapa flashdisk harus di disable..karena semua configuration itu tidak mungkin di ketik karena bisa makan waktu banyak..sedangkan saya hanya di beri waktu cuma 2 jam..itu pun belum ngiitung subneting install dns..apalagi buat konfigurasi webserver dan phpnya..oh mengapa oh mengapa !!</div><div class="fullpost"><br />
</div><div class="fullpost">tapi kenapa pak dosen yang saya hormati..tolong lah siswamu ini..kami bukan dewa yang bisa cepat mengerjakan soal dengan begitu cepat.dan kami hanya pelajar yang menuntut ilmu dari dosen.tolong hargai kerja keras kami..</div><div class="fullpost"><br />
</div><div class="fullpost">wHYYYYYYYYYYYYYYYYY flashdisknya di disableee.????grrrrrrrrrrrr</div><div class="fullpost"><br />
</div><div class="fullpost"><br />
</div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-36976518160137166982011-07-10T09:42:00.000-07:002011-07-10T09:57:56.067-07:00cara menghitung subnetting !!artikel ini saya ambil dari <a href="http://romisatriawahono.net/">romisatriawahono.net</a>.. sengaja saya publish di blog saya karena saya sendiri kadang2 lupa..hehe..kalo yang belum tau subnetting itu apa..cari aja ya di google..hehe<br />
<br />
<br />
<table border="0" style="width: 410px;"><tbody>
<tr> <th><table border="1"><tbody>
<tr> <td><b>Subnet Mask</b></td> <td><b>Nilai CIDR</b></td> </tr>
<tr> <td>255.128.0.0</td> <td>/9</td> </tr>
<tr> <td>255.192.0.0</td> <td>/10</td> </tr>
<tr> <td>255.224.0.0</td> <td>/11</td> </tr>
<tr> <td>255.240.0.0</td> <td>/12</td> </tr>
<tr> <td>255.248.0.0</td> <td>/13</td> </tr>
<tr> <td>255.252.0.0</td> <td>/14</td> </tr>
<tr> <td>255.254.0.0</td> <td>/15</td> </tr>
<tr> <td>255.255.0.0</td> <td>/16</td> </tr>
<tr> <td>255.255.128.0</td> <td>/17</td> </tr>
<tr> <td>255.255.192.0</td> <td>/18</td> </tr>
<tr> <td>255.255.224.0</td> <td>/19</td> </tr>
</tbody></table></th> <th><table border="1"><tbody>
<tr> <td><b>Subnet Mask</b></td> <td><b>Nilai CIDR</b></td> </tr>
<tr> <td>255.255.240.0</td> <td>/20</td> </tr>
<tr> <td>255.255.248.0</td> <td>/21</td> </tr>
<tr> <td>255.255.252.0</td> <td>/22</td> </tr>
<tr> <td>255.255.254.0</td> <td>/23</td> </tr>
<tr> <td>255.255.255.0</td> <td>/24</td> </tr>
<tr> <td>255.255.255.128</td> <td>/25</td> </tr>
<tr> <td>255.255.255.192</td> <td>/26</td> </tr>
<tr> <td>255.255.255.224</td> <td>/27</td> </tr>
<tr> <td>255.255.255.240</td> <td>/28</td> </tr>
<tr> <td>255.255.255.248</td> <td>/29</td> </tr>
<tr> <td>255.255.255.252</td> <td>/30</td> </tr>
</tbody></table></th> </tr>
</tbody></table><br />
<div align="justify"><b>SUBNETTING PADA IP ADDRESS CLASS C</b></div><div align="justify">Ok, sekarang mari langsung latihan saja. Subnetting seperti apa yang terjadi dengan sebuah NETWORK ADDRESS <b>192.168.1.0/26</b> ?</div><div align="justify"><b>Analisa</b>: 192.168.1.0 berarti kelas C dengan Subnet Mask /26 berarti 11111111.11111111.11111111.11000000 (255.255.255.192).</div><div align="justify"> </div><b>Penghitungan</b>: Seperti sudah saya sebutkan sebelumnya semua pertanyaan tentang subnetting akan berpusat di 4 hal, jumlah subnet, jumlah host per subnet, blok subnet, alamat host dan broadcast yang valid. Jadi kita selesaikan dengan urutan seperti itu:<b> </b><br />
<br />
<b>1. Jumlah Subnet</b> = 2<sup>x</sup>, dimana x adalah banyaknya binari 1 pada oktet terakhir subnet mask (2 oktet terakhir untuk kelas B, dan 3 oktet terakhir untuk kelas A). Jadi Jumlah Subnet adalah 2<sup>2</sup> = 4 subnet<b> </b><br />
<b>2.Jumlah Host per Subnet</b> = 2<sup>y</sup> – 2, dimana y adalah adalah kebalikan dari x yaitu banyaknya binari 0 pada oktet terakhir subnet. Jadi jumlah host per subnet adalah 2<sup>6</sup> – 2 = 62 host<b> </b><br />
<b>3.Blok Subnet</b> = 256 – 192 (nilai oktet terakhir subnet mask) = 64. Subnet berikutnya adalah 64 + 64 = 128, dan 128+64=192. Jadi subnet lengkapnya adalah <b>0, 64, 128, 192</b>.<br />
<b>4.</b>Bagaimana dengan alamat <b>host dan broadcast yang valid</b>? Kita langsung buat tabelnya. Sebagai catatan, host pertama adalah 1 angka setelah subnet, dan broadcast adalah 1 angka sebelum subnet berikutnya.<br />
<br />
<ol><table border="1" style="width: 420px;"><tbody>
<tr> <td><div align="left"><b>Subnet</b></div></td> <td><div align="left">192.168.1.<b>0</b></div></td> <td><div align="left">192.168.1.<b>64</b></div></td> <td><div align="left">192.168.1.<b>128</b></div></td> <td><div align="left">192.168.1.<b>192</b></div></td> </tr>
<tr> <td><div align="left"><b>Host Pertama</b></div></td> <td><div align="left">192.168.1.<b>1</b></div></td> <td><div align="left">192.168.1.<b>65</b></div></td> <td><div align="left">192.168.1.<b>129</b></div></td> <td><div align="left">192.168.1.<b>193</b></div></td> </tr>
<tr> <td><div align="left"><b>Host Terakhir</b></div></td> <td><div align="left">192.168.1.<b>62</b></div></td> <td><div align="left">192.168.1.<b>126</b></div></td> <td><div align="left">192.168.1.<b>190</b></div></td> <td><div align="left">192.168.1.<b>254</b></div></td> </tr>
<tr> <td><div align="left"><b>Broadcast</b></div></td> <td><div align="left">192.168.1.<b>63</b></div></td> <td><div align="left">192.168.1.<b>127</b></div></td> <td><div align="left">192.168.1.<b>191</b></div></td> <td><div align="left">192.168.1.<b>255</b></div></td> </tr>
</tbody></table></ol><div align="justify"> </div><div align="justify">Kita sudah selesaikan subnetting untuk IP address Class C. Dan kita bisa melanjutkan lagi untuk subnet mask yang lain, dengan konsep dan teknik yang sama. Subnet mask yang bisa digunakan untuk subnetting class C adalah seperti di bawah. Silakan anda coba menghitung seperti cara diatas untuk subnetmask lainnya.</div><div align="justify"><br />
</div><div align="justify"><br />
</div><table border="1"><tbody>
<tr> <td><b>Subnet Mask</b></td> <td><b>Nilai CIDR</b></td> </tr>
<tr> <td>255.255.255.128</td> <td>/25</td> </tr>
<tr> <td>255.255.255.192</td> <td>/26</td> </tr>
<tr> <td>255.255.255.224</td> <td>/27</td> </tr>
<tr> <td>255.255.255.240</td> <td>/28</td> </tr>
<tr> <td>255.255.255.248</td> <td>/29</td> </tr>
<tr> <td>255.255.255.252</td> <td>/30</td> </tr>
</tbody></table><br />
<b> </b><br />
<br />
<b>SUBNETTING PADA IP ADDRESS CLASS B</b><br />
Berikutnya kita akan mencoba melakukan subnetting untuk IP address class B. Pertama, subnet mask yang bisa digunakan untuk subnetting class B adalah seperti dibawah. Sengaja saya pisahkan jadi dua, blok sebelah kiri dan kanan karena masing-masing berbeda teknik terutama untuk oktet yang “dimainkan” berdasarkan blok subnetnya. CIDR /17 sampai /24 caranya sama persis dengan subnetting Class C, hanya blok subnetnya kita masukkan langsung ke oktet ketiga, bukan seperti Class C yang “dimainkan” di oktet keempat. Sedangkan CIDR /25 sampai /30 (kelipatan) blok subnet kita “mainkan” di oktet keempat, tapi setelah selesai oktet ketiga berjalan maju (coeunter) dari 0, 1, 2, 3, dst.<br />
<br />
<br />
<table border="0" style="width: 410px;"><tbody>
<tr> <th><table border="1"><tbody>
<tr> <td><b>Subnet Mask</b></td> <td><b>Nilai CIDR</b></td> </tr>
<tr> <td>255.255.128.0</td> <td>/17</td> </tr>
<tr> <td>255.255.192.0</td> <td>/18</td> </tr>
<tr> <td>255.255.224.0</td> <td>/19</td> </tr>
<tr> <td>255.255.240.0</td> <td>/20</td> </tr>
<tr> <td>255.255.248.0</td> <td>/21</td> </tr>
<tr> <td>255.255.252.0</td> <td>/22</td> </tr>
<tr> <td>255.255.254.0</td> <td>/23</td> </tr>
<tr> <td>255.255.255.0</td> <td>/24</td> </tr>
</tbody></table></th> <th><table border="1"><tbody>
<tr> <td><b>Subnet Mask</b></td> <td><b>Nilai CIDR</b></td> </tr>
<tr> <td>255.255.255.128</td> <td>/25</td> </tr>
<tr> <td>255.255.255.192</td> <td>/26</td> </tr>
<tr> <td>255.255.255.224</td> <td>/27</td> </tr>
<tr> <td>255.255.255.240</td> <td>/28</td> </tr>
<tr> <td>255.255.255.248</td> <td>/29</td> </tr>
<tr> <td>255.255.255.252</td> <td>/30</td> </tr>
</tbody></table></th> </tr>
</tbody></table><br />
<br />
Ok, kita coba dua soal untuk kedua teknik subnetting untuk Class B. Kita mulai dari yang menggunakan subnetmask dengan CIDR /17 sampai /24. Contoh network address <b>172.16.0.0/18</b>.<br />
<b>Analisa</b>: 172.16.0.0 berarti kelas B, dengan Subnet Mask /18 berarti 11111111.11111111.11000000.00000000 (255.255.192.0).<br />
<b>Penghitungan</b>:<b> </b><br />
<b>1.Jumlah Subnet</b> = 2<sup>x</sup>, dimana x adalah banyaknya binari 1 pada 2 oktet terakhir. Jadi Jumlah Subnet adalah 2<sup>2</sup> = 4 subnet<b> </b><br />
<b>2.Jumlah Host per Subnet</b> = 2<sup>y</sup> – 2, dimana y adalah adalah kebalikan dari x yaitu banyaknya binari 0 pada 2 oktet terakhir. Jadi jumlah host per subnet adalah 2<sup>14</sup> – 2 = 16.382 hos<b>t</b><br />
<b>3.Blok Subnet</b> = 256 – 192 = 64. Subnet berikutnya adalah 64 + 64 = 128, dan 128+64=192. Jadi subnet lengkapnya adalah <b>0, 64, 128, 192</b>.<b> </b><br />
<b>4.Alamat host dan broadcast yang valid?</b><br />
<br />
<ol><table border="1" style="width: 420px;"><tbody>
<tr> <td><div align="left"><b>Subnet</b> </div></td> <td><div align="left">172.16.<b>0.0</b></div></td> <td><div align="left">172.16.<b>64.0</b></div></td> <td><div align="left"><div align="left">172.16.<b>128.0</b></div></div></td> <td><div align="left"><div align="left">172.16.<b>192.0</b></div></div></td> </tr>
<tr> <td><div align="left"><b>Host Pertama</b></div></td> <td><div align="left"><div align="left">172.16.<b>0.1</b></div></div></td> <td><div align="left"><div align="left">172.16.<b>64.1</b></div></div></td> <td><div align="left"><div align="left">172.16.<b>128.1</b></div></div></td> <td><div align="left"><div align="left">172.16.<b>192.1</b></div></div></td> </tr>
<tr> <td><div align="left"><b>Host Terakhir</b></div></td> <td><div align="left"><div align="left">172.16.<b>63.254</b></div></div></td> <td><div align="left"><div align="left">172.16.<b>127.254</b></div></div></td> <td><div align="left"><div align="left">172.16.<b>191.254</b></div></div></td> <td><div align="left"><div align="left">172.16.<b>255.254</b></div></div></td> </tr>
<tr> <td><div align="left"><b>Broadcast</b></div></td> <td><div align="left"><div align="left">172.16.<b>63.255</b></div></div></td> <td><div align="left"><div align="left">172.16.<b>127.255</b></div></div></td> <td><div align="left"><div align="left">172.16.<b>191.255</b></div></div></td> <td><div align="left"><div align="left">172.16.<b>.255.255</b></div></div></td> </tr>
</tbody></table></ol><br />
Berikutnya kita coba satu lagi untuk Class B khususnya untuk yang menggunakan subnetmask CIDR /25 sampai /30. Contoh network address <b>172.16.0.0/25</b>.<br />
<b>Analisa</b>: 172.16.0.0 berarti kelas B, dengan Subnet Mask /25 berarti 11111111.11111111.11111111.10000000 (255.255.255.128).<br />
<b>Penghitungan</b>:<b> </b><br />
<br />
<b>1.Jumlah Subnet</b> = 2<sup>9</sup> = 512 subnet<b> </b><br />
<b>2.Jumlah Host per Subnet</b> = 2<sup>7</sup> – 2 = 126 host<b> </b><br />
<b>3.Blok Subnet</b> = 256 – 128 = 128. Jadi lengkapnya adalah (<b>0, 128</b>)<b> </b><br />
<b>4.Alamat host dan broadcast yang valid</b>?<br />
<br />
<br />
<table border="1" style="width: 420px;"><tbody>
<tr> <td><div align="left"><b> Subnet</b> </div></td> <td>172.16.<b>0.0</b></td> <td>172.16.<b>0.128</b></td> <td>172.16.<b>1.0</b></td> <td>… </td> <td>172.16.<b>255.128</b></td> </tr>
<tr> <td><b>Host Pertama</b></td> <td>172.16.<b>0.1</b></td> <td>172.16.<b>0.129</b></td> <td>172.16.<b>1.1</b></td> <td>… </td> <td>172.16.<b>255.129</b></td> </tr>
<tr> <td><b>Host Terakhir</b></td> <td>172.16.<b>0.126</b></td> <td>172.16.<b>0.254</b></td> <td>172.16.<b>1.126</b></td> <td>…</td> <td>172.16.<b>255.254</b></td> </tr>
<tr> <td><b>Broadcast</b></td> <td>172.16.<b>0.127</b></td> <td>172.16.<b>0.255</b></td> <td>172.16.<b>1.127</b></td> <td>…</td> <td>172.16.<b>255.255</b></td> </tr>
</tbody></table><br />
<br />
<br />
Masih bingung juga? Ok sebelum masuk ke Class A, coba ulangi lagi dari Class C, dan baca pelan-pelan ..<br />
<br />
<b>SUBNETTING PADA IP ADDRESS CLASS A</b><br />
Kalau sudah mantab dan paham, kita lanjut ke Class A. Konsepnya semua sama saja. Perbedaannya adalah di <b>OKTET</b> mana kita mainkan blok subnet. Kalau Class C di oktet ke 4 (terakhir), kelas B di Oktet 3 dan 4 (2 oktet terakhir), kalau Class A di oktet 2, 3 dan 4 (3 oktet terakhir). Kemudian subnet mask yang bisa digunakan untuk subnetting class A adalah semua subnet mask dari CIDR /8 sampai /30.<br />
Kita coba latihan untuk network address <b>10.0.0.0/16</b>.<br />
<b>Analisa</b>: 10.0.0.0 berarti kelas A, dengan Subnet Mask /16 berarti 11111111.11111111.00000000.00000000 (255.255.0.0).<br />
<b>Penghitungan</b><b>:</b><br />
<br />
<b>1.Jumlah Subnet</b> = 2<sup>8</sup> = 256 subnet<b> </b><br />
<b>2.Jumlah Host per Subnet</b> = 2<sup>16</sup> – 2 = 65534 host<b> </b><br />
<b>3.Blok Subnet</b> = 256 – 255 = 1. Jadi subnet lengkapnya: 0,1,2,3,4, etc.<b> </b><br />
<b>4.Alamat host dan broadcast yang valid</b>?<br />
<br />
<br />
<table border="1" style="width: 420px;"><tbody>
<tr> <td><div align="left"><b>Subnet</b> </div></td> <td>10.<b>0.0.0</b></td> <td>10.<b>1.0.0</b></td> <td>… </td> <td>10.<b>254.0.0</b></td> <td>10.<b>255.0.0</b></td> </tr>
<tr> <td><b>Host Pertama</b></td> <td>10.<b>0.0.1</b></td> <td>10.<b>1.0.1</b></td> <td>… </td> <td>10.<b>254.0.1</b></td> <td>10.<b>255.0.1</b></td> </tr>
<tr> <td><b>Host Terakhir</b></td> <td>10.<b>0.255.254</b></td> <td>10.<b>1.255.254</b></td> <td>…</td> <td>10.<b>254.255.254</b></td> <td>10.<b>255.255.254</b></td> </tr>
<tr> <td><b>Broadcast</b></td> <td>10.<b>0.255.255</b></td> <td>10.<b>1.255.255</b></td> <td>…</td> <td>10.<b>254.255.255</b></td> <td>10.<b>255.255.255</b></td> </tr>
</tbody></table><br />
<br />
Mudah-mudahan sudah setelah anda membaca paragraf terakhir ini, anda sudah memahami penghitungan subnetting dengan baik. Kalaupun belum paham juga, anda ulangi terus artikel ini pelan-pelan dari atas. Untuk teknik hapalan subnetting yang lebih cepat,as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.comtag:blogger.com,1999:blog-5410335310491913287.post-80230071555607557842011-07-10T08:14:00.000-07:002011-07-10T08:14:09.181-07:00mySQL di Slackware<div class="fullpost">Bagi pengguna linux, apalagi yang sering berususan dengan database kemungkinan besar pernah berususan dengan mySQL, di slackware sendiri database server yang diikutkan dalam distribusi adalah mySQL. Namun tidak sama dengan distro yang lain yang begitu selesai di install maka mySQL siap untuk digunakan asal servicenya sudah jalan tentunya tapi di slackware ada beberapa yang mesti dilakukan sebelum mySQL tersebut bisa digunakan.<br />
Kita akan mendapatkan pesan error seperti ini jika kita mencoba menjalankan mysql untuk kali pertama :<br />
<code><br />
<b>root@pegasus:~# /etc/rc.d/rc.mysqld start<br />
root@pegasus:~# Starting mysqld daemon with databases from /var/lib/mysql<br />
STOPPING server from pid file /var/run/mysql/mysql.pid<br />
070628 13:15:40 mysqld ended</b><br />
</code><br />
Berikut adalah cara untuk membuat mysql kita berjalan normal dan dapat digunakan.<br />
<b>Install Database Mysql</b><br />
mySQL menggunakan sebuah database bernama mysql yang berisikan data - data tentang database server tersebut misalnya pengguna/user, komputer pengakses, sampai dengan hak akses dari user.<br />
Untuk membuat database mysql kita tinggal ketikkan peintah : mysql_install_db<br />
<code><br />
<b>root@pegasus:~# mysql_install_db</b><br />
</code><br />
<b>Ganti kepemilikan /var/lib/mysql ke user mysql</b><br />
Akan ada beberapa baris pesan hasil dari perintah mysql_install_db diatas, sampai disini kita masih belum bisa menggunakan mysql server kita kalau nekat akan dapat error seperti diatas, ini disebabkan karena script rc.mysqld menggunakan user mysql sedangkan hasil pembuatan database dari peintah mysql_install_db masih milik dari root. Untuk itu kita perlu merubah kepemilikan / ownership dari file-file database mysql. Di slackware file - file tersebut ada di /var/lib/mysql sehingga perintah berikut biasanya berfungsi :<br />
<code><br />
<b>chown mysql.mysql /var/lib/mysql/ -R</b><br />
</code><br />
Jika silahkan menjalankan lagi server mysql kita :<br />
<code><br />
<b>root@pegasus:~# /etc/rc.d/rc.mysqld start</b><br />
</code><br />
Akan keluar pesan :<code><br />
<b>root@pegasus:~# Starting mysqld daemon with databases from /var/lib/mysql</b><br />
</code>Tanpa pesan seperti diatas (mysql ended)<br />
silahkan ketikkan perintah mysql untuk masuk ke mysql server.<br />
<code><br />
<b>root@pegasus:~# mysql<br />
Welcome to the MySQL monitor. Commands end with ; or \g.<br />
Your MySQL connection id is 1 to server version: 5.0.27-log</b></code><br />
<b>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.</b><br />
<b>mysql></b><br />
<br />
Jika tampilan yang kita dapat sama seperti diatas maka mysql kita sudah bisa digunakan dan tidak ada lagi kata "mySQL ndak bisa jalan di slackware =))".<br />
<br />
sumber:<a href="http://makassar-slackers.org/mySQL%20di%20Slackware"> makassar-slackers.org</a> </div>as romahttp://www.blogger.com/profile/16127186518673936097noreply@blogger.com