<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-626665080133695276</id><updated>2026-04-12T12:17:14.766-07:00</updated><category term="cpanel"/><category term="vps"/><category term="server"/><category term="hosting"/><category term="email"/><category term="Shell"/><category term="domain"/><category term="mysql"/><category term="ssl"/><category term="Plesk"/><category term="cms"/><category term="joomla"/><category term="kloxo"/><category term="facebook"/><category term="hacker"/><category term="hardisk"/><category term="load"/><category term="mendeteksi"/><category term="modsec"/><category term="munin"/><category term="raid"/><category term="serangan"/><category term="softcaulus"/><category term="web"/><category term="whm"/><category term="wordpress"/><title type='text'>Tutorial</title><subtitle type='html'>Your Hosting Tutorial &amp;amp; shell scripting admin</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>55</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-138048861417030827</id><published>2012-01-05T01:51:00.001-08:00</published><updated>2012-01-05T01:51:45.832-08:00</updated><title type='text'>enable Cron on chkserv</title><content type='html'>&lt;br /&gt;
&lt;div style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;span style=&quot;color: white;&quot;&gt;Create a crond file under the chkservd.d directory where all the services files are placed:&lt;/span&gt;&lt;/div&gt;
&lt;blockquote style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;strong&gt;&lt;span style=&quot;color: white;&quot;&gt;# pico /etc/chkserv.d/crond&lt;/span&gt;&lt;/strong&gt;&lt;/blockquote&gt;
&lt;div style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;span style=&quot;color: white;&quot;&gt;Add the following and save the file:&lt;/span&gt;&lt;/div&gt;
&lt;blockquote style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;strong&gt;&lt;span style=&quot;color: white;&quot;&gt;service[crond]=x,x,x,/etc/init.d/crond restart,crond,root&lt;/span&gt;&lt;/strong&gt;&lt;/blockquote&gt;
&lt;div style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;span style=&quot;color: white;&quot;&gt;Now you need to edit the chkservd configuration file and enable the crond service for monitoring&lt;/span&gt;&lt;/div&gt;
&lt;blockquote style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;strong&gt;&lt;span style=&quot;color: white;&quot;&gt;# pico /etc/chkserv.d/chkservd.conf&lt;/span&gt;&lt;/strong&gt;&lt;/blockquote&gt;
&lt;div style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;span style=&quot;color: white;&quot;&gt;add the following line at the end of the file&lt;/span&gt;&lt;/div&gt;
&lt;blockquote style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;strong&gt;&lt;span style=&quot;color: white;&quot;&gt;crond:1&lt;/span&gt;&lt;/strong&gt;&lt;/blockquote&gt;
&lt;div style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;span style=&quot;color: white;&quot;&gt;Now, save the file and restart the chkservd service for the new changes to take affect:&lt;/span&gt;&lt;/div&gt;
&lt;blockquote style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;strong&gt;&lt;span style=&quot;color: white;&quot;&gt;# /scripts/restartsrv chkservd&lt;/span&gt;&lt;/strong&gt;&lt;/blockquote&gt;
&lt;div style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;span style=&quot;color: white;&quot;&gt;In order to verify if chkservd auto-restarts the crond service if found offline, stop the service manually&lt;/span&gt;&lt;/div&gt;
&lt;blockquote style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;strong&gt;&lt;span style=&quot;color: white;&quot;&gt;# service crond stop&lt;/span&gt;&lt;/strong&gt;&lt;/blockquote&gt;
&lt;div style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;span style=&quot;color: white;&quot;&gt;and watch the logs&lt;/span&gt;&lt;/div&gt;
&lt;blockquote style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;strong&gt;&lt;span style=&quot;color: white;&quot;&gt;# tail -f /var/log/chkservd.log&lt;/span&gt;&lt;/strong&gt;&lt;/blockquote&gt;
&lt;div style=&quot;background-color: #230000; font-family: Georgia, Verdana; font-size: 11px; line-height: 18px;&quot;&gt;
&lt;span style=&quot;color: white;&quot;&gt;You will notice that the crond service is restarted automatically within 5 minutes.&lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/138048861417030827/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2012/01/enable-cron-on-chkserv.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/138048861417030827'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/138048861417030827'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2012/01/enable-cron-on-chkserv.html' title='enable Cron on chkserv'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-5928156919428245661</id><published>2011-12-13T22:16:00.001-08:00</published><updated>2011-12-13T22:16:39.007-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="raid"/><category scheme="http://www.blogger.com/atom/ns#" term="server"/><title type='text'>Dokumentasi untuk Stop Sync RAID</title><content type='html'>&lt;b&gt;Dokumentasi untuk Stop Sync RAID&lt;/b&gt;&lt;br /&gt;
ini dulu&lt;br /&gt;
mdadm --manage /dev/md1 --fail /dev/sdb2&lt;br /&gt;
baru ini&lt;br /&gt;
mdadm --manage /dev/md1 --remove /dev/sdb2&lt;br /&gt;
&lt;br /&gt;
mengaktifkan kembali&lt;br /&gt;
mdadm -a /dev/md1 /dev/sdb2</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/5928156919428245661/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/12/dokumentasi-untuk-stop-sync-raid.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/5928156919428245661'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/5928156919428245661'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/12/dokumentasi-untuk-stop-sync-raid.html' title='Dokumentasi untuk Stop Sync RAID'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-1428934778661877934</id><published>2011-12-13T19:43:00.000-08:00</published><updated>2011-12-14T00:01:19.279-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="server"/><title type='text'>chkserv configuration</title><content type='html'>chkservd is a service running on all cPanel®&lt;br /&gt;
servers which monitors the state of processes.&lt;br /&gt;
● chkserv.d can be controlled using the&lt;br /&gt;
command:&lt;br /&gt;
– /etc/init.d/chkservd (start|stop|restart)&lt;br /&gt;
– /usr/local/etc/rc.d/chkservd.sh (start|stop|restart)&lt;br /&gt;
● The chkservd perl script is located at /&lt;br /&gt;
usr/local/cpanel/libexec/chkservd&lt;br /&gt;
&lt;br /&gt;
You can add and remove services to be monitored&lt;br /&gt;
from chkservd by the files in /&lt;br /&gt;
etc/chkserv.d/&lt;br /&gt;
● You must also add the service to the chkservd.&lt;br /&gt;
conf with the following syntax:&lt;br /&gt;
service:1&lt;br /&gt;
● Each service has a indiviual file inside of /&lt;br /&gt;
etc/chkserv.d/ with the following syntax:&lt;br /&gt;
– #SERVICE = PORT, SEND, RESPONSE, RESTART&lt;br /&gt;
COMMANDYou can add and remove services to be monitored&lt;br /&gt;
from chkservd by the files in /&lt;br /&gt;
etc/chkserv.d/&lt;br /&gt;
● You must also add the service to the chkservd.&lt;br /&gt;
conf with the following syntax:&lt;br /&gt;
service:1&lt;br /&gt;
● Each service has a indiviual file inside of /&lt;br /&gt;
etc/chkserv.d/ with the following syntax:&lt;br /&gt;
– #SERVICE = PORT, SEND, RESPONSE, RESTART&lt;br /&gt;
COMMAND</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/1428934778661877934/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/12/chkserv-configuration.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/1428934778661877934'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/1428934778661877934'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/12/chkserv-configuration.html' title='chkserv configuration'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-2334068252742940573</id><published>2011-11-28T20:09:00.001-08:00</published><updated>2011-11-28T20:29:27.169-08:00</updated><title type='text'>Postgre Cpanel::AdminBin::adminrun(postgres) set error in context postgres</title><content type='html'>&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;Recently with a cPanel server, we had this issue of not being able to create postgresql database even after the postgresql package is installed and database server is running. Fixing of one issue lead to another there by needing to fix all the errors.&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Cpanel::AdminBin::adminrun(postgres) set error in context postgres&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; [2010-01-16 12:24:18 -0500] warn [postgres::listdbs] Encountered error in postgres::listdbs: Error from postgres wrapper: PostgreSQL has not been configured by the administrator. Unable to locate pgpass file.&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;This was fixed by doing these,&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;Login to WHM =&amp;gt; SQL Services =&amp;gt; Postgres Config =&amp;gt; Click on “Install Config”.&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;Login to WHM =&amp;gt; SQL Services =&amp;gt; Postgres Config =&amp;gt; “Set a Postgresql password also”&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;No error in cPanel after doing above. However that followed by an issue of created DBs not being appeared in the List DB page of Postgresql databases. Went to shell. Logged in as root . Switched to postgres. “su – postgres” . Ran the command “psql” and then&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;-bash-3.2$ psql&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;Welcome to psql 8.1.18, the PostgreSQL interactive terminal.&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;Type: \copyright for distribution terms&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;\h for help with SQL commands&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;\? for help with psql commands&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;\g or terminate with semicolon to execute query&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;\q to quit&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;postgres=# \l&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;List of databases&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;Name | Owner | Encoding&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;-----------+----------+----------&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;postgres | postgres | UTF8&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;template0 | postgres | UTF8&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;template1 | postgres | UTF8&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;(3 rows)&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;postgres=# \q&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;No DB was created. Checked the logs /usr/local/cpanel/logs/error_log and it had entries likeERROR: role “username” does not exist which meant, no roles to create the database.&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot;&gt;cd /var/cpanel/users &amp;amp;&amp;amp; for x in *; do su -c &quot;createuser -S -D -R $x&quot; postgres; done&lt;/span&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;&lt;br style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;,Arial,Helvetica,sans-serif;&quot; /&gt;</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/2334068252742940573/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/11/postgre-cpaneladminbinadminrunpostgres.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/2334068252742940573'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/2334068252742940573'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/11/postgre-cpaneladminbinadminrunpostgres.html' title='Postgre Cpanel::AdminBin::adminrun(postgres) set error in context postgres'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-4706018666868238930</id><published>2011-11-03T17:29:00.001-07:00</published><updated>2011-11-03T17:31:25.776-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="hardisk"/><category scheme="http://www.blogger.com/atom/ns#" term="hosting"/><category scheme="http://www.blogger.com/atom/ns#" term="server"/><category scheme="http://www.blogger.com/atom/ns#" term="Shell"/><title type='text'>Linux Disk utilities</title><content type='html'>&lt;span style=&quot;font-family: verdana,arial,helvetica,sans-serif; font-size: x-small;&quot;&gt;&lt;span style=&quot;font-size: small;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
                           &lt;br /&gt;fdisk /dev/hda &lt;br /&gt;(= &quot;fixed disk&quot;. As 
root.) Linux hard drive partitioning utility (DOS has a utility with the
 same name). In the example above, I specified that I would like to 
partition the first harddrive on the first IDE interface, hence &quot;hda&quot;. 
If I were you, i would backup any important data before using fdisk on 
any partition. I do not not know anybody who likes fdisk (either Linux 
or DOS edition)--I prefer easier to use cfdisk, see next command. &lt;br /&gt;
                           &lt;br /&gt;cfdisk /dev/hda &lt;br /&gt;(as root) Hard drive 
partitioning utility, menu-based. Easier to use then the plain-vanilla 
fdisk (see the previous command). Physical drives can contain primary 
partitions (max 4 per disk), and logical partitions (no restriction on 
number). A primary partition can be bootable. Logical partitions must be
 contained within &quot;extended partitions&quot;; extended partitions are not 
usable by themselves, they are just a container for logical partitions. 
When partitioning a disk, I typically: (1) create a primary partition 
(2) make the primary partition bootable (3) create an extended 
partition, (4) create logical partition(s) within the extended 
partition.&lt;a name=&#39;more&#39;&gt;&lt;/a&gt;&lt;br /&gt;
                           &lt;br /&gt;sfdisk -l -x |more &lt;br /&gt;(as root) List the partition tables (including extended partitions) for all drives on my system.&lt;br /&gt;
                           &lt;br /&gt;parted /dev/hda &lt;br /&gt;A partition 
manipulation utility for Linux (ext2), and DOS (FAT and FAT32) hard 
drive partition. It is for creation, destroying, moving, copying, 
shrinking, and extending partitions. You should really like to backup 
your data and carefully read info parted before using it.&lt;br /&gt;
                           &lt;br /&gt;fdformat /dev/fd0H1440 &lt;br /&gt;mkfs -c -t ext2 /dev/fd0 &lt;br /&gt;(=floppy
 disk format, two commands, as root) Perform a low-level formatting of a
 floppy in the first floppy drive (/dev/fd0), high density (1440 kB). 
Then make a Linux filesystem (-t ext2), checking/marking bad blocks (-c 
). Making the filesystem is an equivalent to the high-level formatting. I
 can also format floppies to different (also non-standard) densities; 
try ls /dev/fd0 .I am also able to format to the default density 
(normally 1440k) using fdformat /dev/fd0.&lt;br /&gt;
                           &lt;br /&gt;badblocks /dev/fd01440 1440 &lt;br /&gt;(as root)
 Check a high-density floppy for bad blocks and display the results on 
the screen. The parameter &quot;1440&quot; specifies that 1440 blocks are to be 
checked. This command does not modify the floppy. badblocks can be also 
used to check the surface of a hard drive but I have to unmount the 
filesystem first to do a full read-write check: &lt;br /&gt;mount [to find out which device contains the disk partition I wish to check for bad blocks] &lt;br /&gt;umount /dev/hda8 [unoumnt the selected partition] &lt;br /&gt;badblocks -n /dev/hda8 [check the selected partition in a non-destructive read-write mode, so that my data is not erased!] &lt;br /&gt;mount /dev/hda8 [mount the partition back since no info on bad blocks was printed] &lt;br /&gt;If bad blocks are found, they can be marked on the hard drive so that will not be used using: &lt;br /&gt;e2fsck -c /dev/hda8 &lt;br /&gt;
                           &lt;br /&gt;fsck -t ext2 /dev/hda2 &lt;br /&gt;(=file system 
check, as root) Check and repair a filesystem, e.g., after an &quot;unclean&quot; 
shutdown due to a power failure. The above example performs the check on
 the partition hda2, filesystem type ext2. You definitely want to 
unmount the partitions or boot Linux in the &quot;single mode&quot; to perform 
this (type &quot;linux single&quot; at the LILO prompt or use init 1 as root to 
enter the single user mode). If errors are found during the filesystem 
checkup, I accept the defaults for repair.&lt;br /&gt;
                           &lt;br /&gt;tune2fs -j /dev/hda2 &lt;br /&gt;(as root, only 
for kernel that support ext3--RH7.2) Adjust the tuneable parameter of an
 ext2 filesystem. The example above shows how to add a journal to a disk
 partition (hda2 in this example), effectively converting the file 
system to ext3 (journaling) filesystem. To complete the transition, you 
must also edit the file /etc/fstab and change the filesystem type from 
ext2 to ext3, else you may run into problems--ext2 will not mount an 
uncleanly shut down journaled filesystem! To check what is the type of 
the filesystem use mount (with no arguments) or cat /etc/mtab. If you 
need more information on ext3 setup, try: 
http://www.symonds.net/~rajesh/howto/ext3/ext3-5.html. &lt;br /&gt;Other options
 of tune2fs let you me add a volume label, adjust the number of mounts 
after which the filesystem check is performed (maximal mount count), or 
turn on time-based filesystem checks instead (less often used).&lt;br /&gt;
                           &lt;br /&gt;dd if=/dev/fd0H1440 of=floppy_image &lt;br /&gt;dd if=floppy_image of=/dev/fd0H1440 &lt;br /&gt;(two
 commands, dd=&quot;data duplicator&quot;) Create an image of a floppy to the file
 called &quot;floppy_image&quot; in the current directory. Then copy floppy_image 
(file) to another floppy disk. Works like DOS &quot;DISKCOPY&quot;.&lt;br /&gt;
                           &lt;br /&gt;mkbootdisk --device /dev/fd0 2.4.2-3 &lt;br /&gt;Make
 an emergency boot floppy. You are typically asked if you would like to 
make a boot disk during the system installation. The above command shows
 how to make it after install, on the first floppy drive (/dev/fd0). 
Your kernel name (needed in the command, here 2.4.2-3) can be determined
 either by running uname -a or ls /lib/modules .&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/4706018666868238930/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/11/linux-disk-utilities.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/4706018666868238930'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/4706018666868238930'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/11/linux-disk-utilities.html' title='Linux Disk utilities'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-8235600578482712714</id><published>2011-10-31T21:08:00.000-07:00</published><updated>2011-11-03T17:30:22.929-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="joomla"/><title type='text'>Mengganti Halaman administrator Joomla</title><content type='html'>&lt;ol&gt;
&lt;li&gt;Pertama kali, Jika menggunakan Joomla 1.0 silakan download file&amp;nbsp; &lt;a href=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/mod_jsecure_authentication.zip&quot;&gt;JSecure Authentication&lt;/a&gt; atau jika menggunakan Joomla 1.5.x silakan download file&amp;nbsp;&lt;a href=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/plgSystemJSecure-1.0.91.zip&quot;&gt;plgSystemJSecure-1.0.9&lt;/a&gt; .&lt;/li&gt;
&lt;li&gt;Masuklah ke halaman login administrator&lt;br /&gt;
&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-629&quot; height=&quot;329&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin1.jpg&quot; title=&quot;protect-admin1&quot; width=&quot;500&quot; /&gt;&lt;/div&gt;
&lt;li&gt;JIka menggunakan Joomla 1.0.x, pilih menu &lt;b&gt;Module &amp;gt; Installer&lt;/b&gt;.&lt;a name=&#39;more&#39;&gt;&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;Klik tombol Browse, tentukan file yang akan diupload. Klik tombol &lt;b&gt;Upload &amp;amp; Install&lt;/b&gt;.&lt;br /&gt;
&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-631&quot; height=&quot;79&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin3.jpg&quot; title=&quot;protect-admin3&quot; width=&quot;213&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Jika menggunakan Joomla 1.5.x, pilih menu &lt;b&gt;Extensions &amp;gt; Install/Uninstall&lt;/b&gt;. &lt;div style=&quot;text-align: center;&quot;&gt;
&lt;a href=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin2.jpg&quot;&gt;&lt;img alt=&quot;&quot; class=&quot;size-medium wp-image-630 aligncenter&quot; height=&quot;170&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin2.jpg&quot; title=&quot;protect-admin2&quot; width=&quot;160&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;Klik tombol &lt;b&gt;Browse&lt;/b&gt;, tentukan file yang akan diupload. Klik tombol&lt;b&gt; Upload &amp;amp; Install&lt;/b&gt;.&lt;br /&gt;
&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-631&quot; height=&quot;79&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin3.jpg&quot; title=&quot;protect-admin3&quot; width=&quot;213&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Tunggu beberapa saat hingga proses instalasi berhasil.&lt;br /&gt;
&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-632&quot; height=&quot;108&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin4.jpg&quot; title=&quot;protect-admin4&quot; width=&quot;263&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Setelah berhasil terinstal, ada beberapa baris script yang harus  dimasukkan ke dalam file Joomla. Untuk Joomla 1.0.x, temukan file l&lt;b&gt;ogin.php&lt;/b&gt; dalam folder &lt;b&gt;/administrator/templates/joomla_admin&lt;/b&gt;.&lt;br /&gt;
&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-636&quot; height=&quot;222&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin5.jpg&quot; title=&quot;protect-admin5&quot; width=&quot;377&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Masukkan script script di bawah ini. &lt;pre&gt;&lt;b&gt;&lt;span style=&quot;font-family: courier new,courier; font-size: x-small;&quot;&gt;require_once( $mosConfig_absolute_path . &#39;/administrator/includes/admin.php&#39; );&lt;/span&gt;&lt;/b&gt;&lt;b&gt;&lt;span style=&quot;font-family: courier new,courier; font-size: x-small;&quot;&gt;&lt;b&gt;mosLoadAdminModules( &#39;left&#39; );&lt;/b&gt;&lt;/span&gt;&lt;/b&gt;&lt;/pre&gt;
&lt;/li&gt;
&lt;li&gt;Masuk ke halaman Administrator kembali. Pilih menu &lt;b&gt;Module &amp;gt; Administrator Modules&lt;/b&gt;.&lt;br /&gt;
&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-637&quot; height=&quot;103&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin6.jpg&quot; title=&quot;protect-admin6&quot; width=&quot;170&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Klik link &lt;b&gt;jSecure Authentication&lt;/b&gt;.&lt;br /&gt;
&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-639&quot; height=&quot;137&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin7.jpg&quot; title=&quot;protect-admin7&quot; width=&quot;201&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Pilih Published pada radion button, kemudian simpan.&lt;br /&gt;
&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-640&quot; height=&quot;217&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin8.jpg&quot; title=&quot;protect-admin8&quot; width=&quot;241&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Pada Tab Parameter, masukkan teks sebagai kata kunci setelah  administrator. Sehingga, untuk masuk halaman administrator Joomla sudah  berubah menjadi &lt;b&gt;http://domainmu.com/administrator?goto4dm1n&lt;/b&gt;. Ingat!!, terdapat akhiran &lt;b&gt;?goto4dm1n&lt;/b&gt; setelah administrator. Jika sudah yakin, tekan tombol &lt;b&gt;Save &lt;/b&gt;untuk  menyimpan. Pastikan tidak lupa dengan kunci tersebut, jika lupa maka  tidak akan dapat login ke halaman administator Joomla.&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-642&quot; height=&quot;145&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin10.jpg&quot; title=&quot;protect-admin10&quot; width=&quot;500&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Untuk Joomla 1.5.x, setelah berhasil terinstal pilih menu &lt;b&gt;Extensions &amp;gt; Module Manager&lt;/b&gt;.&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-643&quot; height=&quot;177&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin11.jpg&quot; title=&quot;protect-admin11&quot; width=&quot;160&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Pilih &lt;b&gt;Administrator&lt;/b&gt;.&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-644&quot; height=&quot;123&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin12.jpg&quot; title=&quot;protect-admin12&quot; width=&quot;286&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Temukan module jSecure Authentication.&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-645&quot; height=&quot;109&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin13.jpg&quot; title=&quot;protect-admin13&quot; width=&quot;379&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Pilih &lt;b&gt;Enabled&lt;/b&gt;.&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-646&quot; height=&quot;176&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin14.jpg&quot; title=&quot;protect-admin14&quot; width=&quot;398&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Pada Parameter, masukkan kata untuk memproteksi halaman administrator. Selanjutnya, klik tombol &lt;b&gt;Save &lt;/b&gt;untuk menyimpan perubahan.&lt;/li&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;img alt=&quot;&quot; class=&quot;alignnone size-full wp-image-648&quot; height=&quot;163&quot; src=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/protect-admin15.jpg&quot; title=&quot;protect-admin15&quot; width=&quot;469&quot; /&gt;&lt;/div&gt;
&lt;li&gt;Ujilah website anda, login ke halaman Administrator dengan cara  menuliskan alamat URL http://domainmu.com/administrator. Apa yang  terjadi ? !!!&lt;/li&gt;
&lt;/ol&gt;
Untuk Joomla 1.5.x silakan dowload&amp;nbsp; –&amp;gt;&amp;nbsp; &lt;a href=&quot;http://slametriyanto.net/wp-content/uploads/2009/01/plgSystemJSecure-1.0.9.zip&quot;&gt;plgSystemJSecure-1.0.9&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/8235600578482712714/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/10/mengganti-halaman-administrator-joomla.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/8235600578482712714'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/8235600578482712714'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/10/mengganti-halaman-administrator-joomla.html' title='Mengganti Halaman administrator Joomla'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-2851949801762338576</id><published>2011-10-31T21:03:00.000-07:00</published><updated>2011-11-03T17:30:37.720-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="load"/><category scheme="http://www.blogger.com/atom/ns#" term="server"/><category scheme="http://www.blogger.com/atom/ns#" term="Shell"/><title type='text'>Script untuk melihat load pada server</title><content type='html'>#script gabungan hafidz&lt;br /&gt;
&lt;br /&gt;
echo &quot;Mw tampilan brp baris -script Hafidz ver 0.1-&quot;;&lt;br /&gt;
&lt;br /&gt;
#read input&lt;br /&gt;
#a=&quot;$input&quot;&lt;br /&gt;
&lt;br /&gt;
&lt;a name=&#39;more&#39;&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;ps -eo user,pcpu,pmem | tail -n +2 | awk &#39;{num[$1]++; cpu[$1] += $2; mem[$1] $&lt;br /&gt;
user, cpu[user], mem[user]) }&#39; | sort -k 1 -r | head -$a&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
echo &quot;===========================================&quot;&lt;br /&gt;
&lt;br /&gt;
ps -eo pcpu,pid,user,args | sort -k 1 -r | head -$a&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
#echo -n &quot;ingin export laporan??[y/g]&quot;;&lt;br /&gt;
&lt;br /&gt;
#coput=&lt;br /&gt;
#read coput&lt;br /&gt;
&lt;br /&gt;
#if [ $coput = &quot;y&quot; ];then&lt;br /&gt;
#ps -eo pcpu,pid,user,args | sort -k 1 -r | head -$a &amp;gt; load.txt&lt;br /&gt;
#else&lt;br /&gt;
#echo &quot; terima kasih :) hafidz ver o.1 -test-&quot;&lt;br /&gt;
#fi&lt;br /&gt;
echo &quot;penggunaan phpnya&quot;&lt;br /&gt;
ps auxf|grep php|awk &#39;{print $1}&#39;|sort|uniq -c&lt;br /&gt;
echo &quot;penggunaan mysqlnya &quot;&lt;br /&gt;
ps auxf|grep mysql|awk &#39;{print $1}&#39;|sort|uniq -c</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/2851949801762338576/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/10/script-untuk-melihat-load-pada-server.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/2851949801762338576'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/2851949801762338576'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/10/script-untuk-melihat-load-pada-server.html' title='Script untuk melihat load pada server'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-29562504261542153</id><published>2011-10-31T21:00:00.000-07:00</published><updated>2011-11-03T17:30:45.370-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="hacker"/><category scheme="http://www.blogger.com/atom/ns#" term="mendeteksi"/><category scheme="http://www.blogger.com/atom/ns#" term="serangan"/><category scheme="http://www.blogger.com/atom/ns#" term="web"/><title type='text'>Mendeteksi serangan hacker ke web anda</title><content type='html'>Mungkin bagi para administrator yang mempunyai web atau pun blog, jarang  yg memperhatikan masalah keamanan. Dimana kebanyakan para web admin  berpikir bahwa situs yang mereka kelola itu telah aman 100%, dan di rasa  tidak akan ada gangguan dari orang-orang iseng. Tapi jika suatu ketika  sang admin situs melihat di browsernya bahwa pada halaman depan situs  yang mereka telah berubah tampilan dengan adanya salam khas dari para  peretas (cracker / defacer), mereka selalu di hadapkan ke pada  penyesalan, marah, dan lain2.&lt;br /&gt;
&lt;br /&gt;
Memang penyesalan selalu datang di akhir brotha…..&lt;br /&gt;
Bagaimanakah kita mengantisipasi hal semacam itu…..?&lt;br /&gt;
Pada artikel kali ini saya akan coba membuat trik , bagaimana  mengidentifikasi serangan sedini mungkin agar tidak terjadi hal-hal yang  tidak di inginkan pada situs yang kita kelola.&lt;br /&gt;
&lt;br /&gt;
&lt;a name=&#39;more&#39;&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;
Disini kita akan mencoba Applikasi Craw Track&lt;br /&gt;
Anda bisa mengunjungi di&lt;a href=&quot;http://www.crawltrack.net/&quot; target=&quot;_blank&quot;&gt;&lt;u&gt; http://www.crawltrack.net/&lt;/u&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Peralatan yang dibutuhkan&lt;br /&gt;
1.    Crawl Track (&lt;a href=&quot;http://www.crawltrack.net/download/crawltrack3-2-1.zip&quot; target=&quot;_blank&quot;&gt;http://www.crawltrack.net/download/crawltrack3-2-1.zip&lt;/a&gt;)&lt;br /&gt;
2.    Hosting /Domain / Sub Domain&lt;br /&gt;
&lt;br /&gt;
mungkin buat yang sudah biasa berhubungan dengan aplikasi dan publishing  website cara menginstal dan konfigurasi script ini adalah hal yang  mudah.&lt;br /&gt;
Buat yang masih belajar atau mo mencoba untuk konfigurasi bisa membaca artikel saya di web pribadi saya.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://dark-note.com/articles.php?article_id=13&quot; target=&quot;_blank&quot;&gt;Analysis and Identification of an attack on your website (Session Dummies 1)&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Ok setelah selesai semua konfigurasi, kita akan mencoba membaca log dan  mengindentifikasi  jika terdapat serangan ke website kita.&lt;br /&gt;
&lt;br /&gt;
1. Masuk ke Crawl Track dan login .&lt;br /&gt;
2. pada halaman utama , silahkan mencari   &lt;span style=&quot;color: red;&quot;&gt;Hacking attempts&lt;/span&gt; dan Klik untuk melihat History nya&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;size_fullsize&quot;&gt;
&lt;img alt=&quot;&quot; border=&quot;0&quot; class=&quot;align_center&quot; src=&quot;http://www.jasakom.com/attachment.php?attachmentid=129&amp;amp;d=1272071734&quot; /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;size_fullsize&quot;&gt;
&lt;img alt=&quot;&quot; border=&quot;0&quot; class=&quot;align_center&quot; src=&quot;http://www.jasakom.com/attachment.php?attachmentid=130&amp;amp;d=1272071813&quot; /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
Pada History, terdapat keterangan seperti berikut&lt;br /&gt;
&lt;div class=&quot;bbcode_container&quot;&gt;
&lt;div class=&quot;bbcode_quote&quot;&gt;
&lt;div class=&quot;quote_container&quot;&gt;
- IP Used -------------&amp;gt; adalah IP Attacker yang di log&lt;br /&gt;
- Attack ---------------&amp;gt; Jumlah serangan yang dilakukan oleh Attacker&lt;br /&gt;
- Attack Details -------&amp;gt; Script yang coba Di Inject beserta Parameter code injection yang digunakan oleh Attacker       &lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;div class=&quot;size_fullsize&quot;&gt;
&lt;img alt=&quot;&quot; border=&quot;0&quot; class=&quot;align_center&quot; src=&quot;http://www.jasakom.com/attachment.php?attachmentid=130&amp;amp;d=1272071813&quot; /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
berdasarkan history yang di log oleh Crawl Track, Telah di indikasikan  adanya serangan terhadap situs yang gw kelola, serangan yang terdeteksi  dan yang digunakan oleh Attacker dari ip 208.38.187.136 (USA) , dengan  melakukan remote file melalui &lt;span style=&quot;color: red;&quot;&gt;PHPCentral Poll&lt;/span&gt; dimana file yg mau di inject an berasal dari alamat &lt;a href=&quot;http://www.kyosan.com.tw/appserv/id1??????&quot; target=&quot;_blank&quot;&gt;http://www.kyosan.com.tw/appserv/id1??????&lt;br /&gt;
&lt;/a&gt; &lt;br /&gt;
Berdasarkan log tersebut kita bisa mengantisipasi, dan mencoba mempatching celah yang ada di website yang kita kelola.&lt;br /&gt;
&lt;br /&gt;
Mudah-mudahan artikel ini berguna bagi yang ingin mengelola site sehingga bisa meminimalkan serangan dari pihak luar...</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/29562504261542153/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/10/mendeteksi-serangan-hacker-ke-web-anda.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/29562504261542153'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/29562504261542153'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/10/mendeteksi-serangan-hacker-ke-web-anda.html' title='Mendeteksi serangan hacker ke web anda'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-557781015790670618</id><published>2011-08-23T16:36:00.000-07:00</published><updated>2011-08-23T16:36:28.888-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="server"/><title type='text'>Cara Membuat Partisi Baru di Centos 5.x dengan menggunakan fdisk</title><content type='html'>maklum pemula dalam linux mo menuangkan sedikit informasi untuk partisi yang mungkin semua master sudah tau, tapi sebagai catatan karena memang sulit menemukan tulisan linux berbasis bahasa indonesia, yach tak bikinin aja untuk mempermudah.. walaupun udah banyak kali y :))&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;saat penginstalan linux anda sengaja tidak memakai seluruh space anda untuk membuat partisi baru&lt;/div&gt;&lt;div&gt;misalkan di /dev/sda anda, lalu cara untuk membuat partisi barunya adalah :&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;1. fdisk /dev/sda enter&lt;/div&gt;&lt;div&gt;2. n -&amp;gt; pilihan ini untuk menentukan jumlah kapasitas yang ingin di assign&lt;/div&gt;&lt;div&gt;3. +5000M -&amp;gt; saya assign 5000M atau 5GB&lt;/div&gt;&lt;div&gt;4. t -&amp;gt; pilihan ini untuk menentukan file system dari partisi&lt;/div&gt;&lt;div&gt;5. 1 -&amp;gt; tak pilih primary&lt;/div&gt;&lt;div&gt;6. 83 -&amp;gt; file system linux di tandai dengan angka 83&lt;/div&gt;&lt;div&gt;7. &amp;nbsp;w -&amp;gt; write disk , maka proses akan berjalan untuk mempartisi langkah2 yang tadi kita lakukan,&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;setelah itu restartlah linux anda dengan menggunakan shutdown -r now, lalu partisi akan tercreate bgitu anda login kembali ke linux anda...&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;jangan lupa koment yoo.... nulisnya lumayan cape&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/557781015790670618/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/cara-membuat-partisi-baru-di-centos-5x.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/557781015790670618'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/557781015790670618'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/cara-membuat-partisi-baru-di-centos-5x.html' title='Cara Membuat Partisi Baru di Centos 5.x dengan menggunakan fdisk'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-9149620479845046502</id><published>2011-08-23T07:47:00.000-07:00</published><updated>2011-08-23T07:47:55.535-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="server"/><category scheme="http://www.blogger.com/atom/ns#" term="vps"/><title type='text'>Pemindahan akun mail ke server lain via ssh</title><content type='html'>pemindahan biasa kalau menggunakan cpanel tinggal klik maka dengan mudah dapat tercreate, tapi bagaimana jika kita ingin memindahkan file apa aja sich yang harus kita pindahkan ini yang buat kita bingung bukan hehehe..&lt;div&gt;berikut adalah file2 penting yang akan kita pindahkan :&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;- /home/user/mail/namadomain.com -&amp;gt; file ini harus di copykan karena di dalam file ini terdapat data-data dari email klient&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;-&amp;nbsp;/home/user/etc/namadomain.com -&amp;gt; file ini berisikan password dari masing-masing email klient anda&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;-&amp;nbsp;/home/user/cpanel/email.yaml -&amp;gt; file ini berisi email-email user yang tercatat di cpanel&amp;nbsp;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;tiga direktori di atas sangat lah penting dalam pemindahan email secara manual , semoga bermanfaat, jangan baca doank komen, cape nulisnya&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/9149620479845046502/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/pemindahan-akun-mail-ke-server-lain-via.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/9149620479845046502'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/9149620479845046502'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/pemindahan-akun-mail-ke-server-lain-via.html' title='Pemindahan akun mail ke server lain via ssh'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-5813026908385983361</id><published>2011-08-23T07:40:00.000-07:00</published><updated>2011-08-23T07:40:55.337-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="hosting"/><category scheme="http://www.blogger.com/atom/ns#" term="server"/><category scheme="http://www.blogger.com/atom/ns#" term="vps"/><title type='text'>error pty cannot allocation pty</title><content type='html'>error di atas anda temui ketika anda login ke vps anda, apakah yang terjadi, biasa nya hal tersebut terjadi karena ssh tidak dapat menemukan pty , anda bisa men set nya di :&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;1. nano /etc/rc.sysint&lt;/div&gt;&lt;div&gt;2. masukan &quot; /sbin/udev &quot;&lt;/div&gt;&lt;div&gt;3. restart dech vps anda&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;lalu hasinya wah bisa masuk lagi ke ssh waow&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/5813026908385983361/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/error-pty-cannot-allocation-pty.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/5813026908385983361'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/5813026908385983361'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/error-pty-cannot-allocation-pty.html' title='error pty cannot allocation pty'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-5843079738727378140</id><published>2011-08-16T05:02:00.000-07:00</published><updated>2011-08-17T09:56:41.037-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="mysql"/><title type='text'>8 Tips Mengamankan MySQL di Server Unix Multiuser</title><content type='html'>&lt;h1&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-size: small; font-weight: normal;&quot;&gt;Sebagian besar dari kita, apalagi para programer dan sysadmin Web Unix, pasti sudah cukup familiar dengan software ini. MySQL—yang pernah dibahas di edisi 4 &lt;i&gt;mwmag—&lt;/i&gt;merupakan server RDBMS open source terpopuler, terutama untuk aplikasi Web. Artikel kali ini akan membahas isu-isu keamanan seputar menjalankan daemon MySQL di lingkungan multiuser, seperti di server shared hosting. Dalam lingkungan multiuser ada beberapa hal yang perlu diperhatikan, terutama yang berkaitan dengan isolasi user yang satu dengan user lain. Meskipun ada pula sebagian poin-poin yang diterangkan—seperti pengaturan permission MySQL—yang dapat diterapkan untuk Windows, namun jelas fokus artikel ini adalah pada lingkungan Unix/Linux.&lt;/span&gt;&lt;/h1&gt;&lt;a href=&quot;http://www.blogger.com/post-edit.g?blogID=626665080133695276&amp;amp;postID=5843079738727378140&amp;amp;from=pencil&quot; name=&quot;sub1&quot;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;h2&gt;Tip 1: Pasang mysqld Di Mesin Terpisah&lt;/h2&gt;&lt;div class=&quot;Normal-first&quot;&gt;Kita langsung mulai saja dengan tip yang pertama. Jika Anda punya budget cukup, pasanglah daemon MySQL (mysqld) di mesin terpisah. Cara ini adalah termasuk yang paling aman, karena mesin terpisah ini dapat kita taruh di belakang firewall sehingga tidak menerima koneksi dari Internet melainkan dari mesin-mesin tertentu saja di jaringan lokal. Juga, tiap user yang menggunakan database tidak perlu kita beri akses shell. Semua port dapat kita tutup kecuali port default mysqld saja (3306) yang kita buka. Tidak ada yang bisa menyentuh langsung file-file database maupun log kecuali user &lt;tt&gt;mysql&lt;/tt&gt; di mesin database tersebut, dan juga admin mesin tersebut.&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Tapi tentu tidak semua orang bisa membeli mesin dedicated. Jadi…&lt;/div&gt;&lt;a href=&quot;http://www.blogger.com/post-edit.g?blogID=626665080133695276&amp;amp;postID=5843079738727378140&amp;amp;from=pencil&quot; name=&quot;sub2&quot;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;h2&gt;Tip 2: Jalankan mysqld Terpisah Di Mesin Yang Sama&lt;/h2&gt;&lt;div class=&quot;Normal-first&quot;&gt;Meskipun MySQL merupakan database multiuser, tapi daemon &lt;tt&gt;mysqld&lt;/tt&gt; hanya berjalan sebagai satu user Unix saja (defaultnya adalah &lt;tt&gt;mysql&lt;/tt&gt;). Tidak ada wrapping seperti halnya pada Apache + suexec/cgiwrap. User Unix ini memiliki akses ke semua database di direktori data (defaultnya adalah &lt;tt&gt;/var/lib/mysql&lt;/tt&gt;). Tentu saja MySQL memiliki sistem access privilege yang cukup mendetil untuk mengatur klien mana yang dapat mengakses tabel atau database mana. Namun bug pada kode mysqld atau miskonfigurasi sistem privilegenya bisa saja mengakibatkan sebuah database berisi data rahasia terbuka bagi user MySQL lain. Misalnya lewat &lt;tt&gt;LOAD DATA INFILE&lt;/tt&gt; atau &lt;tt&gt;LOAD LOCAL DATA INFILE&lt;/tt&gt; maupun lewat &lt;tt&gt;SELECT INTO OUTFILE&lt;/tt&gt;, yang memungkinkan penyerang berpotensi menimpa file database milik user lain.&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Jika Anda mempunyai sebuah database yang datanya sensitif atau harus benar-benar private, Anda bisa dapat menjalankan mysqld terpisah. Tiap mysqld berjalan sebagai user Unix yang berbeda, sehingga satu mysqld tidak dapat mengganggu mysqld yang lainnya. Bug pada mysqld yang satu tidak dapat mengganggu mysqld lainnya, karena masing-masing tidak bisa menyentuh direktori data daemon lain.&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Contoh berikut adalah user &lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: monospace;&quot;&gt;hafidz&amp;nbsp;&lt;/span&gt;yang menjalankan sendiri daemon MySQL pribadi, berjalan sebagai user&amp;nbsp;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: monospace;&quot;&gt;hafidz&amp;nbsp;&lt;/span&gt;dan port 3366. Daemon MySQL utama, sebagai user &lt;tt&gt;mysql&lt;/tt&gt;, tidak dapat menyentuh database.&lt;/div&gt;&lt;pre&gt;$ mkdir /home/hafidz/mysql
$ mysql_install_db --datadir=/home/hafidz/mysql
$ /usr/sbin/mysqld --datadir=/home/hafidz/mysql --port=3366 \
    --socket=/home/hafidz/mysql/mysql.sock &amp;amp;&lt;/pre&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Anda dapat mengganti port 3366 dengan port kesukaan sendiri. Sebelum memakai, Anda perlu memberi password pada user MySQL root tentunya:&lt;/div&gt;&lt;pre&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;$ mysqladmin -u root -S /home/&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;white-space: normal;&quot;&gt;hafidz&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;/mysql/mysql.sock password &lt;i&gt;RAHASIA&lt;/i&gt;&lt;/span&gt;&lt;/pre&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Ganti &lt;i&gt;RAHASIA&lt;/i&gt; dengan password sebenarnya. Selanjutnya nanti sewaktu melakukan koneksi ke mysqld ini dengan command line client &lt;tt&gt;mysql&lt;/tt&gt; misalnya, Anda perlu menyebutkan opsi &lt;tt&gt;-h&lt;/tt&gt; (host) dan &lt;tt&gt;-P&lt;/tt&gt; (port) atau &lt;tt&gt;-S&lt;/tt&gt; (socket). Misalnya, koneksi via soket Unix:&lt;/div&gt;&lt;pre&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;$ mysql -u root -S /home/&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;white-space: normal;&quot;&gt;hafidz&lt;/span&gt;/mysql/mysql.sock&lt;/pre&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Atau koneksi via TCP:&lt;/div&gt;&lt;pre&gt;$ mysql -u root -h 127.0.0.1 -P 3366&lt;/pre&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Tapi, lagi-lagi, jika jumlah user banyak dan masing-masing ingin menjalankan mysqld-nya masing-masing, tentu saja overheadnya besar. Karena itu…&lt;/div&gt;&lt;a href=&quot;http://www.blogger.com/post-edit.g?blogID=626665080133695276&amp;amp;postID=5843079738727378140&amp;amp;from=pencil&quot; name=&quot;sub3&quot;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;h2&gt;Tip 3: Kenali Sistem Access Privilege MySQL&lt;/h2&gt;&lt;div class=&quot;Normal-first&quot;&gt;Sebagai seorang admin database, mau tidak mau hal yang satu ini harus dikuasai baik-baik. Sistem Access Privilege adalah cara utama MySQL dalam membatasi user dan host mana saja yang bisa melakukan koneksi, menyimpan password masing-masing user, dan membatasi kemampuan user dalam memanipulasi database (apakah hanya bisa melakukan &lt;tt&gt;SELECT&lt;/tt&gt; saja, atau &lt;tt&gt;SELECT&lt;/tt&gt; dan &lt;tt&gt;UPDATE&lt;/tt&gt;, dst). Apa artinya daemon MySQL yang terisolasi dari mesin maupun daemon lain apabila ia dengan cerobohnya menerima koneksi dari sembarang user dan host? &lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Sistem privilege MySQL cukup mendetil dan menurut saya lebih simpel tapi mendetil daripada sistem privilege PostgreSQL, meskipun dari segi otentikasi sistem PostgreSQL sebetulnya lebih fleksibel. Pada dasarnya seluruh informasi pengaturan privilege disimpan dalam sebuah database khusus bernama &lt;tt&gt;mysql&lt;/tt&gt;. Penjelasan mendetil mengenai di luar cakupan artikel ini, tapi sebagai tip beberapa hal berikut ini sebaiknya diikuti. Pertama, sebaiknya tiap user diberi password. Kedua, tabel &lt;tt&gt;user&lt;/tt&gt; di database &lt;tt&gt;mysql&lt;/tt&gt; ini sangat sensitif karena berisi password, jadi jangan biarkan user manapun memiliki privilege &lt;tt&gt;SELECT&lt;/tt&gt; terhadap. Ketiga, batasi privilege &lt;tt&gt;FILE&lt;/tt&gt; maupun &lt;tt&gt;PROCESS&lt;/tt&gt;, jangan berikan kecuali benar-benar perlu. Keempat, jangan biarkan satu user database melihat database lain kecuali benar-benar perlu.&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Dalam server shared hosting yang saya kelola, demi kesederhanaan, tiap user database hanya boleh mengakses satu database, dan daftar privilegenya seperti ini: Entri di tabel &lt;tt&gt;user&lt;/tt&gt;: &lt;tt&gt;(&#39;localhost&#39;, &#39;&lt;i&gt;USER&lt;/i&gt;&#39;, password(&lt;i&gt;&#39;PASSWORD&lt;/i&gt;&#39;), &#39;N&#39;, &#39;N&#39;, &#39;N&#39;, &#39;N&#39;, &#39;N&#39;, &#39;N&#39;, &#39;N&#39;, &#39;N&#39;, &#39;N&#39;). &lt;/tt&gt;Entri di tabel &lt;tt&gt;db&lt;/tt&gt;: &lt;tt&gt;(&#39;localhost&#39;, &#39;DATABASE&#39;, &#39;USER&#39;, &#39;Y&#39;, &#39;Y&#39;, &#39;Y&#39;, &#39;Y&#39;, &#39;Y&#39;, &#39;Y&#39;, &#39;N&#39;, &#39;Y&#39;, &#39;Y&#39;, &#39;Y&#39;)&lt;/tt&gt;. Artinya, si user &lt;tt&gt;&lt;i&gt;USER&lt;/i&gt;&lt;/tt&gt; hanya dapat melihat database &lt;tt&gt;&lt;i&gt;DATABASE&lt;/i&gt;&lt;/tt&gt;, hanya bisa melakukan koneksi dari mesin lokal melalui soket Unix, dan tidak memiliki privilege &lt;tt&gt;GRANT&lt;/tt&gt;. Privilege &lt;tt&gt;FILE&lt;/tt&gt; diberikan, tapi berhubung tiap skrip CGI diwrap, maka setidaknya akan lebih sulit bagi seorang penyerang untuk menciptakan file sebagai user Unix lain.&lt;/div&gt;&lt;a href=&quot;http://www.blogger.com/post-edit.g?blogID=626665080133695276&amp;amp;postID=5843079738727378140&amp;amp;from=pencil&quot; name=&quot;sub4&quot;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;h2&gt;Tip 4: Hanya Terima Koneksi Lokal&lt;/h2&gt;&lt;div class=&quot;Normal-first&quot;&gt;Dalam sebuah server shared hosting misalnya, umumnya database diakses dari skrip CGI/PHP/ASP di server yang sama. Jika kita ingin agar hanya user atau skrip dari mesin lokal saja yang dapat melakukan koneksi ke daemon MySQL maka kita dapat mematikan opsi listening di soket TCP. Seperti kita ketahui, MySQL mendengarkan koneksi di soket Unix (defaultnya di &lt;tt&gt;/var/lib/mysql/mysql.sock&lt;/tt&gt;) dan di port TCP (defaultnya di port 3306). Soket Unix hanya untuk klien lokal, sementara soket TCP dapat digunakan untuk koneksi jaringan.&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Untuk membuat mysqld tidak mendengarkan di soket TCP sama sekali, taruh baris berikut di &lt;tt&gt;/etc/my.cnf&lt;/tt&gt;:&lt;/div&gt;&lt;pre&gt;[mysqld]
skip-networking&lt;/pre&gt;&lt;div class=&quot;MsoNormal&quot;&gt;lalu restart mysqld. Atau tambahkan &lt;tt&gt;--skip-networking&lt;/tt&gt; saat menjalankan &lt;tt&gt;mysqld&lt;/tt&gt;.&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Setelah memakai opsi ini, bahkan koneksi ke &lt;tt&gt;127.0.0.1&lt;/tt&gt; pun akan ditolak dengan pesan &lt;i&gt;Connection Refused&lt;/i&gt;. Karena memang tidak ada soket TCP yang mendengarkan. Jadi untuk melakukan koneksi ke daemon MySQL kita harus menggunakan host &lt;tt&gt;localhost&lt;/tt&gt; agar soket Unixlah yang dipakai sebagai metode koneksi.&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Keuntungan menggunakan soket Unix, selain sedikit lebih cepat (karena tidak ada overhead protokol TCP/IP), isolasi filesystem pun berlaku sebagai lapisan pelindung. Database milik user&amp;nbsp;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: monospace;&quot;&gt;hafidz&amp;nbsp;&lt;/span&gt;di contoh Tip 2 tadi misalnya, tidak dapat dicapai sama sekali baik oleh klien di mesin lain maupun oleh user Unix lain di mesin yang sama, karena defaultnya lokasi soket Unix di &lt;tt&gt;/home/hafidz&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Times New Roman&#39;;&quot;&gt;&lt;tt&gt;/mysql/mysql.sock&lt;/tt&gt; ini tertutup dari user lain. Sehingga database ini bersifat pribadi dan hanya bisa diakses oleh user&amp;nbsp;&lt;/span&gt;&lt;/tt&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: monospace;&quot;&gt;hafidz&lt;/span&gt;&lt;br /&gt;
&lt;tt&gt;s&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Times New Roman&#39;;&quot;&gt;endiri maupun oleh skrip CGI/PHP yang berjalan sebagai user&amp;nbsp;&lt;/span&gt;&lt;/tt&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: monospace;&quot;&gt;hafidz&lt;/span&gt;&lt;tt&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Times New Roman&#39;;&quot;&gt;. Daemon MySQL utama, di lain pihak, merupakan daemon yang terbuka bagi semua user, karena &lt;tt&gt;/var/lib/mysql/mysql.sock&lt;/tt&gt; secara default dapat diakses oleh semua user.&lt;/span&gt;&lt;/tt&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Tentu saja, kadang-kadang database MySQL ingin diakses selain dari &lt;tt&gt;localhost&lt;/tt&gt; (misalnya, ingin diakses dari klien GUI di komputer Windows). Dalam kasus ini, mau tidak mau kita harus membuka lagi soket TCP dan kembali mengandalkan sistem privilege MySQL dalam membatasi host.&lt;/div&gt;&lt;a href=&quot;http://www.blogger.com/post-edit.g?blogID=626665080133695276&amp;amp;postID=5843079738727378140&amp;amp;from=pencil&quot; name=&quot;sub5&quot;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;h2&gt;Tip 5: Buang Database test&lt;/h2&gt;&lt;div class=&quot;Normal-first&quot;&gt;Dalam lingkungan multiuser, tiap user semestinya diberi database masing-masing dan database default yang diberikan oleh distribusi MySQL, yaitu &lt;tt&gt;test&lt;/tt&gt;, biasanya tidak ada gunanya. Ada baiknya database ini dihapus saja sehingga tidak sembarang user yang bisa mengakses database ini dan lalu memenuhi disk atau melakukan serangan DOS misalnya. Sebab defaultnya adalah semua user database bisa melihat database &lt;tt&gt;test&lt;/tt&gt;. Untuk menghapus database &lt;tt&gt;test&lt;/tt&gt;, berikan perintah ini dari klien command line &lt;tt&gt;mysql&lt;/tt&gt;:&lt;/div&gt;&lt;pre&gt;mysql&amp;gt; DELETE FROM db WHERE db=&#39;test&#39; OR db=&#39;test_%&#39;;
mysql&amp;gt; FLUSH PRIVILEGES;&lt;/pre&gt;&lt;a href=&quot;http://www.blogger.com/post-edit.g?blogID=626665080133695276&amp;amp;postID=5843079738727378140&amp;amp;from=pencil&quot; name=&quot;sub6&quot;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;h2&gt;Tip 6: chroot&lt;/h2&gt;&lt;div class=&quot;Normal-first&quot;&gt;Chroot adalah fasilitas yang disediakan di banyak sistem operasi Unix untuk membuat filesystem root “virtual” bagi program, misalnya di bawah &lt;tt&gt;/home/hafidz&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Times New Roman&#39;;&quot;&gt;&lt;tt&gt;/root&lt;/tt&gt;, sehingga program menganggap path tersebut adalah &lt;tt&gt;/&lt;/tt&gt; dan tidak bisa melihat path di atasnya (&lt;tt&gt;/home/hafidz&amp;nbsp;&lt;/tt&gt;&lt;/span&gt;&lt;/tt&gt;maupun &lt;tt&gt;/home&lt;/tt&gt; maupun &lt;tt&gt;/&lt;/tt&gt; asli). Chroot banyak bermanfaat untuk memenjarakan program sehingga tidak bisa menyentuh file-file di luar direktori yang sudah kita tetapkan sebagai penjaranya.&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Tip ini cukup berhubungan dengan tip 2 (tiap user memperoleh mysqld masing-masing). Di lingkungan virtual server pun &lt;tt&gt;chroot&lt;/tt&gt; sering dilakukan terhadap tiap-tiap daemon agar masing-masing tidak dapat melihat file milik daemon lain.&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Chroot saat ini harus dilakukan sebagai root karena merupakan operasi privileged. Menyambung contoh di tip 2, berikut ini cara menjalankan mysqld milik user&amp;nbsp;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: monospace;&quot;&gt;hafidz&amp;nbsp;&lt;/span&gt;dan memenjarakannya di &lt;tt&gt;/home/hafidz&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Times New Roman&#39;;&quot;&gt;&lt;tt&gt;/mysql&lt;/tt&gt;. &lt;tt&gt;mysqld&lt;/tt&gt; memiliki opsi &lt;tt&gt;--chroot&lt;/tt&gt; sehingga kita tidak perlu mengkopi &lt;tt&gt;/usr/sbin/mysqld&lt;/tt&gt;-nya itu sendiri, namun terakhir saya coba masih bermasalah, sehingga kita akan melakukan chroot menggunakan &lt;tt&gt;/usr/sbin/chroot&lt;/tt&gt;. Contoh ini untuk RedHat Linux (saya memakai versi 7.2) dan distribusi RPM binary dari MySQL AB (saya memakai 3.23.51).&lt;/span&gt;&lt;/tt&gt;&lt;/div&gt;&lt;pre&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;$ chdir /home/&lt;span class=&quot;Apple-style-span&quot; style=&quot;white-space: normal;&quot;&gt;hafidz&lt;/span&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot;&gt;
$ mkdir -p fakeroot/{var/lib,etc,tmp,lib,usr/sbin,usr/share}
$ mv mysql fakeroot/var/lib/   &lt;i&gt;# direktori data yg sudah dibuat di tip 2&lt;/i&gt;
$ echo -e &quot;root:*:0:0:::\nnobody:*:99:99:::\n&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;white-space: normal;&quot;&gt;hafidz&lt;/span&gt;:*:500:500:::&quot; \
&lt;span class=&quot;Apple-style-span&quot;&gt;    &amp;gt; fakeroot/etc/passwd
$ echo -e &quot;root::0:\n&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;white-space: normal;&quot;&gt;hafidz&lt;/span&gt;::500:&quot; &amp;gt; fakeroot/etc/group
&lt;span class=&quot;Apple-style-span&quot;&gt;$ cp -a /lib/{ld-*,libc.so*,libc-*.so,libnsl*,libnss_files*,libtermcap*} \
    fakeroot/lib/
$ cp -a /usr/sbin/mysqld fakeroot/usr/sbin/
$ cp -a /usr/share/mysql fakeroot/usr/share/
&amp;nbsp;
# /usr/sbin/chroot /home/&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;white-space: normal;&quot;&gt;hafidz&lt;/span&gt;/fakeroot /usr/sbin/mysqld \
&lt;span class=&quot;Apple-style-span&quot;&gt;    --user=&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;white-space: normal;&quot;&gt;hafidz&lt;/span&gt; \
&lt;span class=&quot;Apple-style-span&quot;&gt;    --datadir=/var/lib/mysql \
    --port=3366 \
    --socket=/var/lib/mysql/mysql.sock&lt;/span&gt;&lt;/pre&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Untuk instalasi seperti di atas, dibutuhkan overhead ruang disk sebesar sekitar 12MB untuk mengkopi library Linux dan file-file lain yang diperlukan ke bawah &lt;tt&gt;/home/hafidz&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Times New Roman&#39;;&quot;&gt;&lt;tt&gt;/fakeroot&lt;/tt&gt; (karena jika tidak, setelah dilakukan chroot maka mysqld tidak akan dapat mencari library yang dibutuhkan). Kita juga memerlukan &lt;tt&gt;/etc/passwd&lt;/tt&gt; dan &lt;tt&gt;/etc/group&lt;/tt&gt; “dummy”. Ganti UID dan GID 500 sesuai UID dan GID user yang akan menjalankan mysqld. Setelah semua file-file siap, kita memanggil mysqld. Perhatikan bahwa opsi-opsi path di &lt;tt&gt;--datadir&lt;/tt&gt; dan &lt;tt&gt;--socket&lt;/tt&gt; adalah relatif terhadap fakeroot. Program-program yang berada di bawah chroot yang sama akan melihat soket dan direktori data MySQL milik&amp;nbsp;&lt;/span&gt;&lt;/tt&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: monospace;&quot;&gt;hafidz&amp;nbsp;&lt;/span&gt;&lt;tt&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Times New Roman&#39;;&quot;&gt;ini di &lt;/span&gt;&lt;tt style=&quot;font-family: &#39;Times New Roman&#39;;&quot;&gt;/var/lib/mysql&lt;/tt&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Times New Roman&#39;;&quot;&gt;, tapi sebetulnya—seperti yang akan dilihat program-program lain yang berada di luar chroot—lokasi asli ada di &lt;/span&gt;&lt;tt&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Times New Roman&#39;;&quot;&gt;/home/hafidz&lt;/span&gt;&lt;/tt&gt;&lt;/tt&gt;&lt;tt&gt;/fakeroot/var/lib/mysql&lt;/tt&gt;.&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Chroot berguna terutama jika Anda tidak mempercayai MySQL versi development atau beta (mis: versi 4.0.2 saat ini). Chroot juga bermanfaat dalam menutup kemungkinan perintah SQL &lt;tt&gt;LOAD DATA INFILE&lt;/tt&gt; dan &lt;tt&gt;SELECT INTO OUTFILE&lt;/tt&gt; mengintip dan merusak file-file yang tidak diinginkan. Chroot juga perlu Anda pertimbangkan bila sebuah server memuat beberapa user yang benar-benar tidak saling mempercayai satu sama lain. Dalam kenyataan sehari-hari, saya jarang menggunakan chroot.&lt;/div&gt;&lt;a href=&quot;http://www.blogger.com/post-edit.g?blogID=626665080133695276&amp;amp;postID=5843079738727378140&amp;amp;from=pencil&quot; name=&quot;sub7&quot;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;h2&gt;Tip 7: Jangan Hidupkan LOAD DATA LOCAL INFILE&lt;/h2&gt;&lt;div class=&quot;Normal-first&quot;&gt;&lt;tt&gt;LOAD DATA LOCAL INFILE&lt;/tt&gt; adalah fasilitas agar klien bisa membaca sebuah file dari filesystem dan memasukkannya ke tabel database. Sejak 3.23.49, &lt;tt&gt;LOAD DATA LOCAL INFILE&lt;/tt&gt; sudah dimatikan secara default. Jika ada skrip CGI atau ASP di mesin shared hosting Anda yang tidak diwrap, maka ada potensi perintah SQL tersebut dipakai untuk membaca file-file sebagai user &lt;tt&gt;nobody&lt;/tt&gt; misalnya (dan mengambil source code skrip-skrip milik user lain lewat memuatnya ke tabel database lalu nanti ke file melalui &lt;tt&gt;SELECT INTO OUTFILE&lt;/tt&gt; atau lewat skrip yang melakukan &lt;tt&gt;SELECT&lt;/tt&gt; dan mencetaknya ke file). Jika Anda cukup yakin bahwa semua skrip terwrap, maka barulah Anda bisa mengaktifkan perintah SQL ini dengan memberikan opsi:&lt;/div&gt;&lt;pre&gt;[mysql]
local-infile&lt;/pre&gt;&lt;div class=&quot;MsoNormal&quot;&gt;di &lt;tt&gt;/etc/my.cnf&lt;/tt&gt;. Skrip pun harus memberikan perintah mysql_options() dulu—saat ini belum didukung oleh PHP—sebelum bisa memberikan perintah SQL &lt;tt&gt;LOAD DATA LOCAL INFILE&lt;/tt&gt;.&lt;/div&gt;&lt;a href=&quot;http://www.blogger.com/post-edit.g?blogID=626665080133695276&amp;amp;postID=5843079738727378140&amp;amp;from=pencil&quot; name=&quot;sub8&quot;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;h2&gt;Tip 8: Koneksi SSL&lt;/h2&gt;&lt;div class=&quot;Normal-first&quot;&gt;Tip ini berkaitan dengan tip nomor 4. Jika koneksi MySQL Anda hanya lokal via soket Unix, Anda cukup aman di poin ini. Tapi jika daemon MySQL Anda harus menerima klien (atau melakukan replikasi) via koneksi TCP dari Internet, maka ada potensi pencurian data melalui sniffing paket. Password dan data-data sensitif bisa melayang dari hop ke hop dan siap disadap. Ada baiknya Anda mempertimbangkan mensetup SSL untuk koneksi MySQL.&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;MySQL baru mendukung koneksi SSL natif mulai 4.0. Karena itu, kita bisa menggunakan &lt;b&gt;stunnel&lt;/b&gt; untuk mengenkripsi saluran komunikasi. Prinsip stunnel adalah, di sisi klien dan server kita memasang gerbang stunnel masuk agar terbentuk “terowongan”. Masing-masing klien dan server asli berkomunikasi secara lokal (via localhost) dengan stunnel. Sementara barulah stunnel di kedua sisi saling melakukan pembicaraan SSL. Berikut sebuah contoh. Di sisi klien (mis, beralamat di &lt;tt&gt;klien.com&lt;/tt&gt;):&lt;/div&gt;&lt;pre&gt;# /usr/sbin/stunnel -P/tmp/ -c -d 3306 -r &lt;i&gt;server.com&lt;/i&gt;:3307&lt;/pre&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Di sisi server (yang beralamat mis di &lt;tt&gt;server.com&lt;/tt&gt;):&lt;/div&gt;&lt;pre&gt;# cd /usr/share/ssl/certs
# openssl req -new -x509 -days 365 -nodes -out stunnel.pem \
    -keyout stunnel.pem
# /usr/sbin/stunnel -P/tmp/ -p stunnel.pem -d 3307 -r localhost:3306&lt;/pre&gt;&lt;div class=&quot;MsoNormal&quot;&gt;Lalu dari &lt;tt&gt;klien.com&lt;/tt&gt; lakukan koneksi MySQL ke server &lt;tt&gt;server.com&lt;/tt&gt; seperti biasa.&lt;/div&gt;&lt;a href=&quot;http://www.blogger.com/post-edit.g?blogID=626665080133695276&amp;amp;postID=5843079738727378140&amp;amp;from=pencil&quot; name=&quot;sub9&quot;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;h2&gt;Penutup&lt;/h2&gt;&lt;div class=&quot;Normal-first&quot;&gt;Pesan terakhir, jangan lupa membaca kembali manual MySQL bagian &lt;i&gt;General Security Issues and the MySQL Access Privilege System&lt;/i&gt; agar—mengutip kata-kata di manual tersebut—Anda “terhindar dari kesalahan-kesalahan security yang paling umum.” (sh)&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/5843079738727378140/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/8-tips-mengamankan-mysql-di-server-unix.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/5843079738727378140'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/5843079738727378140'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/8-tips-mengamankan-mysql-di-server-unix.html' title='8 Tips Mengamankan MySQL di Server Unix Multiuser'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-8472922206225441883</id><published>2011-08-16T03:25:00.001-07:00</published><updated>2011-08-16T03:25:58.606-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="munin"/><title type='text'>Installing Munin On CPanel</title><content type='html'>I had the same issue. Here is what I did to get it working:&lt;br /&gt;
&lt;br /&gt;
Before starting uninstall Munin via WHM.&lt;br /&gt;
&lt;br /&gt;
1) Forced cpanel update of perl to 5.8.7:&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;bbcode_container&quot;&gt; 	&lt;div class=&quot;bbcode_quote&quot;&gt; 		&lt;div class=&quot;quote_container&quot;&gt; 			&lt;div class=&quot;bbcode_quote_container&quot;&gt;&lt;/div&gt;To check what is the perl version on your system, use:&lt;br /&gt;
&lt;br /&gt;
perl -v&lt;br /&gt;
&lt;br /&gt;
This is perl, v5.8.7 built for i686-linux&lt;br /&gt;
&lt;br /&gt;
As you can see here, I am running the latest perl version available on CPanel so in this case an upgrade would not be necessary.&lt;br /&gt;
&lt;br /&gt;
If you need to upgrade your perl installation, here is the proper way to do it, in order to not break your CPanel:&lt;br /&gt;
&lt;br /&gt;
wget &lt;a href=&quot;http://layer1.cpanel.net/perl587installer.tar.gz&quot; rel=&quot;nofollow&quot; target=&quot;_blank&quot;&gt;http://layer1.cpanel.net/perl587installer.tar.gz&lt;/a&gt;&lt;br /&gt;
tar xfz perl587installer.tar.gz&lt;br /&gt;
cd perl587installer&lt;br /&gt;
./install&lt;br /&gt;
&lt;br /&gt;
After this is done, run:&lt;br /&gt;
&lt;br /&gt;
/scripts/upcp&lt;br /&gt;
&lt;br /&gt;
You can also run the following to ensure that all the necessary modules were reinstalled:&lt;br /&gt;
&lt;br /&gt;
/usr/local/cpanel/bin/checkperlmodules&lt;br /&gt;
&lt;br /&gt;
Once you have completed the upgrade, you can check again the perl version (perl -v) to ensure that this was properly installed. 			 		&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;from &lt;a href=&quot;http://www.ducea.com/2006/06/02/cpanel-perl-upgrade/&quot; rel=&quot;nofollow&quot; target=&quot;_blank&quot;&gt;http://www.ducea.com/2006/06/02/cpanel-perl-upgrade/&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
2) then forced RRD tool update:&lt;br /&gt;
&lt;div class=&quot;bbcode_container&quot;&gt; 	&lt;div class=&quot;bbcode_quote&quot;&gt; 		&lt;div class=&quot;quote_container&quot;&gt; 			&lt;div class=&quot;bbcode_quote_container&quot;&gt;&lt;/div&gt;mv /usr/local/cpanel/3rdparty/bin/rrdtool /usr/local/cpanel/3rdparty/bin/rrdtool.bak&lt;br /&gt;
/scripts/rrdtoolinstall 			 		&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;3) Install Munin via WHM.&lt;br /&gt;
&lt;br /&gt;
That got it installed and working. Only took about 5 hours to figure it out.&lt;br /&gt;
</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/8472922206225441883/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/installing-munin-on-cpanel.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/8472922206225441883'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/8472922206225441883'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/installing-munin-on-cpanel.html' title='Installing Munin On CPanel'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-457350042185991029</id><published>2011-08-16T03:07:00.000-07:00</published><updated>2011-08-16T03:07:46.082-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="hosting"/><title type='text'>Menginstall Perl yang rusak di CPanel</title><content type='html'>&lt;br /&gt;
&lt;pre class=&quot;bbcode_code&quot; style=&quot;height: 84px;&quot;&gt;masuk SSH anda lalu&amp;nbsp;

1. wget http://layer1.cpanel.net/perl588installer.tar.gz
2. tar zxvf perl588installer.tar.gz
3. cd perl588installer&lt;/pre&gt;&lt;pre class=&quot;bbcode_code&quot; style=&quot;height: 84px;&quot;&gt;4. ./install
5. /scripts/rrdtoolinstall ( untuk penginstalan rrdtools jika perlu)&lt;/pre&gt;</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/457350042185991029/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/menginstall-perl-yang-rusak-di-cpanel.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/457350042185991029'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/457350042185991029'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/menginstall-perl-yang-rusak-di-cpanel.html' title='Menginstall Perl yang rusak di CPanel'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-2090415300634255554</id><published>2011-08-11T23:03:00.000-07:00</published><updated>2011-08-11T23:03:55.245-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="facebook"/><category scheme="http://www.blogger.com/atom/ns#" term="modsec"/><title type='text'>Mendisable  Modsec Di cpanel perdomain</title><content type='html'>&lt;br /&gt;
&lt;div style=&quot;margin-bottom: .0001pt; margin: 0in; mso-line-height-alt: 9.75pt; text-align: justify; vertical-align: baseline;&quot;&gt;&lt;span style=&quot;background: white; color: #333333; font-family: Arial; font-size: 10.0pt;&quot;&gt;Wah situs saya tidak bisa dibuka ktika saya tambahkan link di facebook saya,&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;margin-bottom: .0001pt; margin: 0in; mso-line-height-alt: 9.75pt; text-align: justify; vertical-align: baseline;&quot;&gt;&lt;span style=&quot;background: white; color: #333333; font-family: Arial; font-size: 10.0pt;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;margin-bottom: .0001pt; margin: 0in; mso-line-height-alt: 9.75pt; text-align: justify; vertical-align: baseline;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #333333; font-family: Arial; font-size: x-small;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;margin-bottom: .0001pt; margin: 0in; mso-line-height-alt: 9.75pt; text-align: justify; vertical-align: baseline;&quot;&gt;&lt;span style=&quot;background: white; color: #333333; font-family: Arial; font-size: 10.0pt;&quot;&gt;1. nano /var/cpanel/templates/apache2/vhost.default ( saya disini pakai nano karena lebih mudah )&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 9.75pt; vertical-align: baseline;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial; font-size: xx-small;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 9.75pt; vertical-align: baseline;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial; font-size: xx-small;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;background-color: white; color: #333333; font-size: 13px; line-height: normal;&quot;&gt;tambahkan di baris paling akhir setelah&lt;span class=&quot;apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;[% END -%], langsung pada file&lt;span class=&quot;apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span class=&quot;ilad&quot;&gt;&lt;span style=&quot;border-bottom-color: windowtext; border-bottom-style: none; border-bottom-width: 1pt; border-left-color: windowtext; border-left-style: none; border-left-width: 1pt; border-right-color: windowtext; border-right-style: none; border-right-width: 1pt; border-top-color: windowtext; border-top-style: none; border-top-width: 1pt; padding-bottom: 0in; padding-left: 0in; padding-right: 0in; padding-top: 0in;&quot;&gt;template&lt;/span&gt;&lt;/span&gt;&lt;span class=&quot;apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;CPanel untuk vhost&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;MsoNormalTable&quot; style=&quot;border-collapse: collapse; width: 580px;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;   &lt;td style=&quot;padding: 0in 0in 0in 0in;&quot;&gt;   &lt;div class=&quot;MsoNormal&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;padding: 0in 0in 0in 0in; width: 413.25pt;&quot; width=&quot;551&quot;&gt;   &lt;div class=&quot;MsoNormal&quot;&gt;&lt;code&gt;&lt;span style=&quot;font-size: 10.0pt;&quot;&gt;[% IF   vhost.servername == &#39;namadomain.com&#39;&lt;/span&gt;&lt;/code&gt; &lt;code&gt;&lt;span style=&quot;font-size: 10.0pt;&quot;&gt;-%]&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;&lt;code&gt;&lt;span style=&quot;font-size: 10.0pt;&quot;&gt;SecRuleEngine Off&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;&lt;code&gt;&lt;span style=&quot;font-size: 10.0pt;&quot;&gt;[% END&lt;/span&gt;&lt;/code&gt; &lt;code&gt;&lt;span style=&quot;font-size: 10.0pt;&quot;&gt;-%]&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;&lt;/td&gt;  &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;div style=&quot;margin-bottom: .0001pt; margin: 0in; mso-line-height-alt: 9.75pt; text-align: justify; vertical-align: baseline;&quot;&gt;&lt;span style=&quot;background: white; color: #333333; font-family: Arial; font-size: 10.0pt;&quot;&gt;2. Lalu rebuild file httpd.conf pakai script-nya CPanel :&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 9.75pt; vertical-align: baseline;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial; font-size: xx-small;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/div&gt;&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;MsoNormalTable&quot; style=&quot;border-collapse: collapse; width: 580px;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;   &lt;td style=&quot;padding: 0in 0in 0in 0in;&quot;&gt;   &lt;div class=&quot;MsoNormal&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;padding: 0in 0in 0in 0in; width: 413.25pt;&quot; width=&quot;551&quot;&gt;   &lt;div class=&quot;MsoNormal&quot;&gt;&lt;code&gt;&lt;span style=&quot;font-size: 10.0pt;&quot;&gt;/scripts/rebuildhttpdconf&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;&lt;/td&gt;  &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;div style=&quot;margin-bottom: .0001pt; margin: 0in; mso-line-height-alt: 9.75pt; text-align: justify; vertical-align: baseline;&quot;&gt;&lt;span style=&quot;background: white; color: #333333; font-family: Arial; font-size: 10.0pt;&quot;&gt;3. Restart httpd :&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 9.75pt; vertical-align: baseline;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial; font-size: xx-small;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/div&gt;&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;MsoNormalTable&quot; style=&quot;border-collapse: collapse; width: 580px;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;   &lt;td style=&quot;padding: 0in 0in 0in 0in;&quot;&gt;   &lt;div class=&quot;MsoNormal&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;padding: 0in 0in 0in 0in; width: 413.25pt;&quot; width=&quot;551&quot;&gt;   &lt;div class=&quot;MsoNormal&quot;&gt;&lt;code&gt;&lt;span style=&quot;font-size: 10.0pt;&quot;&gt;/etc/init.d/httpd   restart&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;&lt;code&gt;&lt;span style=&quot;font-size: 10.0pt;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot;&gt;&lt;code&gt;&lt;span style=&quot;font-size: 10.0pt;&quot;&gt;Alhasil minta klient anda mengcheck kembali untuk domainnya yang di links dari facebook&lt;/span&gt;&lt;/code&gt;&lt;/div&gt;&lt;/td&gt;  &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;div class=&quot;MsoNormal&quot;&gt;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/2090415300634255554/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/mendisable-modsec-di-cpanel-perdomain.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/2090415300634255554'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/2090415300634255554'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/08/mendisable-modsec-di-cpanel-perdomain.html' title='Mendisable  Modsec Di cpanel perdomain'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-8393008384392433898</id><published>2011-06-25T19:44:00.000-07:00</published><updated>2011-06-25T19:44:51.083-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Shell"/><category scheme="http://www.blogger.com/atom/ns#" term="vps"/><title type='text'>How To replace my text easily</title><content type='html'>now we can replace our text easily like this&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;1. #nano test.txt&lt;/div&gt;&lt;div&gt;2. insert apa apa apa apa apa&amp;nbsp;&lt;/div&gt;&lt;div&gt;3. save it&lt;/div&gt;&lt;div&gt;4. replace apa brekele -- test.txt&lt;/div&gt;&lt;div&gt;5. and if we call it , #more test.txt&lt;/div&gt;&lt;div&gt;the view is brekele brekele brekele brekele brekele&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;please comment&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/8393008384392433898/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/06/how-to-replace-my-text-easily.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/8393008384392433898'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/8393008384392433898'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/06/how-to-replace-my-text-easily.html' title='How To replace my text easily'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total><georss:featurename>Indonesia</georss:featurename><georss:point>-7.4496240154078119 109.24804649999999</georss:point><georss:box>-16.112274015407813 86.094346499999986 1.2130259845921874 132.4017465</georss:box></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-2459428407661556050</id><published>2011-06-17T19:48:00.000-07:00</published><updated>2011-06-17T19:48:15.566-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="hosting"/><category scheme="http://www.blogger.com/atom/ns#" term="vps"/><title type='text'>Cpanel Log</title><content type='html'>install cpanel log&lt;br /&gt;
/var/log/cpanel*install*&lt;br /&gt;
Description : These log files contain cPanel installation logs &amp;amp; should be referenced first for any issues resulting from new cPanel installations..&lt;br /&gt;
&lt;br /&gt;
Cpanel/WHM Service Status Logs:&lt;br /&gt;
/var/log/chkservd.log&lt;br /&gt;
Description :The service monitoring demon (chkservd) logs all service checks here. Failed service are represented with a [-] and active services are represented by [+].&lt;br /&gt;
&lt;br /&gt;
Cpanel/WHM Accounting Logs:&lt;br /&gt;
Location : /var/cpanel/accounting.log&lt;br /&gt;
Description : Contains a list of accounting functions performed through WHM, including account removal and creation..&lt;br /&gt;
&lt;br /&gt;
cPanel/WHM Specific Requests and Errors:&lt;br /&gt;
cPanel error logs:&lt;br /&gt;
Location : /usr/local/cpanel/logs/error_log&lt;br /&gt;
Description : cPanel logs any error it incurs here. This should be checked when you encounter errors or&lt;br /&gt;
&lt;br /&gt;
strange behavior in cPanel/WHM...&lt;br /&gt;
cPanel License Error Logs:&lt;br /&gt;
Location : /usr/local/cpanel/logs/license_log&lt;br /&gt;
Description : All license update attempts are logged here. If you run into any errors related to license when logging in, check here.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Stats Daemon Logs:&lt;br /&gt;
Location : /usr/local/cpanel/logs/stats_log&lt;br /&gt;
Description : The stats daemon (cpanellogd) logs the output from all stats generators (Awstats, Webalizer, Analog) here.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Client Information, Requested URL Logs:&lt;br /&gt;
Location : /usr/local/cpanel/logs/access_log&lt;br /&gt;
Description : General information related to access cPanel requests is logged here.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
cPanel/WHM Update Logs:&lt;br /&gt;
Location : /var/cpanel/updatelogs/update-[TIMESTAMP].log&lt;br /&gt;
Description : Contains all output from each cPanel update [upcp]. It&#39;s named with the timestamp at which the upcp process was initiated..&lt;br /&gt;
&lt;br /&gt;
Bandwidth Logs:&lt;br /&gt;
Location : /var/cpanel/bandwidth&lt;br /&gt;
Description : Files contain a list of the bandwidth history for each account. Each named after their respective user.&lt;br /&gt;
&lt;br /&gt;
Tailwatchd [New]:&lt;br /&gt;
Location : /usr/local/cpanel/logs/tailwatchd_log&lt;br /&gt;
Description : Logs for daemon configuired under tailwatchd ie. cPBandwd, Eximstats, Antirelayd.&lt;br /&gt;
&lt;br /&gt;
Apache Logs:&lt;br /&gt;
General Error and Auditing Logs:&lt;br /&gt;
Location : /usr/local/apache/logs/error_log&lt;br /&gt;
Description : All exceptions caught by httpd along with standard error output from CGI applications are logged here..&lt;br /&gt;
The first place you should look when httpd crashes or you incur errors when accessing website.&lt;br /&gt;
&lt;br /&gt;
Apache SuExec Logs:&lt;br /&gt;
Location : /usr/local/apache/logs/suexec_log&lt;br /&gt;
Description : Auditing information reported by suexec each time a CGI application is executed. Useful for debugging internal server errors, with no relevant information being reported to the Apache error_log, check here for potential suexec policy violations...&lt;br /&gt;
&lt;br /&gt;
Domain Access Logs:&lt;br /&gt;
Location : /usr/local/apache/domlogs/domain.com&lt;br /&gt;
Description : General access log file for each domain configured with cPanel.&lt;br /&gt;
&lt;br /&gt;
Apache Access Logs:&lt;br /&gt;
Location : /usr/local/apache/logs/access_log&lt;br /&gt;
Description : Complete web server access log records all requests processed by the server.&lt;br /&gt;
&lt;br /&gt;
Exim :&lt;br /&gt;
Message Reception and Delivery:&lt;br /&gt;
Location : /var/log/exim_mainlog or /var/log/exim/mainlog&lt;br /&gt;
Description : Receives an entry every time a message is received or delivered.&lt;br /&gt;
&lt;br /&gt;
Exim ACLs/Policies based RejectLog :&lt;br /&gt;
Location : /var/log/exim_rejectlog&lt;br /&gt;
Description : An entry is written to this log every time a message is rejected based on either ACLs or other policies eg: aliases configured to :fail&lt;br /&gt;
&lt;br /&gt;
Unexpected or Fatal Errors:&lt;br /&gt;
Location : /var/log/exim_paniclog&lt;br /&gt;
Description : Logs any entries exim doesn’t know how to handle. It&#39;s generally a really bad thing when log entries are being written here, and they should be properly investigated..&lt;br /&gt;
&lt;br /&gt;
IMAP/POP/SpamAssassin General Logging and Errors:&lt;br /&gt;
Location : /var/log/maillog &amp;amp; /var/log/messages&lt;br /&gt;
Description : The IMAP, POP, and SpamAssassin services all log here. This includes all general logging information (login attempts, transactions, spam scoring), along with fatal errors.&lt;br /&gt;
&lt;br /&gt;
FTP:&lt;br /&gt;
FTP Logins and General Errors:&lt;br /&gt;
Location : /var/log/messages&lt;br /&gt;
Description : General information and login attempts are logged here..&lt;br /&gt;
&lt;br /&gt;
FTP Transactions logging:&lt;br /&gt;
Location : /var/log/xferlog or /var/log/messages&lt;br /&gt;
Description : Is a symbolic link in most cases to /usr/local/apache/domlogs/ftpxferlog, which contains a history of the transactions made by FTP users...&lt;br /&gt;
&lt;br /&gt;
MySQL:&lt;br /&gt;
MySQL General Information and Errors :&lt;br /&gt;
Location : /var/lib/mysql/$(hostname).err&lt;br /&gt;
Description : This path could vary, but is generally located in /var/lib/mysql. Could also be located at /var/log/mysqld.log&lt;br /&gt;
&lt;br /&gt;
Security:&lt;br /&gt;
Authentication attempts:&lt;br /&gt;
Location : /var/log/secure&lt;br /&gt;
Description : Logs all daemons which requires PAM Authentication.&lt;br /&gt;
&lt;br /&gt;
Tracking all Bad Logins and Logouts:&lt;br /&gt;
Location : /var/log/btmp&lt;br /&gt;
Description : Log of all attempted bad logins to the system. Accessed via the lastb command..&lt;br /&gt;
&lt;br /&gt;
Tracking all Logins and Logouts:&lt;br /&gt;
Location : /var/log/wtmp&lt;br /&gt;
Description : The wtmp file records all logins and logouts.&lt;br /&gt;
&lt;br /&gt;
Last Logins:&lt;br /&gt;
Location : /var/log/lastlog&lt;br /&gt;
Description : Database times of previous user logins. The lastlog file is a database which contains info on the last login of each user.&lt;br /&gt;
&lt;br /&gt;
WebDav or WebDisk Log :&lt;br /&gt;
Location : /usr/local/cpanel/logs/cpdavd_error_log&lt;br /&gt;
Description : The cpdavd daemon is &quot;WebDav&quot; (better known as &quot;WebDisk&quot;) which was introduced in cPanel 11 to allow users to mount their home directory on their personal computer, always having access to the files and content...&lt;br /&gt;
&lt;br /&gt;
Cphulkd Logs:&lt;br /&gt;
Location : /usr/local/cpanel/logs/cphulkd_errors.log&lt;br /&gt;
Description : cPHulk Brute Force Protection prevents malicious forces from trying to access your server&#39;s services by guessing the login password for that service....&lt;br /&gt;
It blacklists IPs that it thinks are trying to run a brute force attack.&lt;br /&gt;
&lt;br /&gt;
Failure Logging:&lt;br /&gt;
Location : /var/log/faillog&lt;br /&gt;
Description : Faillog formats the contents of the failure log from /var/log/faillog database. It also can be used for maintains failure counters and limits. Run faillog without arguments display only list of user faillog records who have ever had a login failure.&lt;br /&gt;
&lt;br /&gt;
Startup/Boot, Kernel &amp;amp; Hardware error messages :&lt;br /&gt;
Location : /var/log/dmesg&lt;br /&gt;
Description : dmesg is a &quot;window&quot; into the kernels ring-buffer. It&#39;s a message buffer of the kernel. The content of this file is referred to by the dmesg command. It shows bootlog and the hardware errors..&lt;br /&gt;
&lt;br /&gt;
Tomcat:&lt;br /&gt;
General Startup, Shutdown &amp;amp; Error Logs:&lt;br /&gt;
Location : /usr/local/jakarta/tomcat/logs/catalina.err and /usr/local/jakarta/tomcat/logs/catalina.out&lt;br /&gt;
Description : Logs for Tomcat and all tomcat based applications...</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/2459428407661556050/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/06/cpanel-log.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/2459428407661556050'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/2459428407661556050'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/06/cpanel-log.html' title='Cpanel Log'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-1220753811141199478</id><published>2011-06-16T05:25:00.000-07:00</published><updated>2011-06-16T05:25:52.698-07:00</updated><title type='text'>how to Change Backup time</title><content type='html'>My backup always start at 1 AM, can i change it?, yes u can :&lt;br /&gt;
&lt;br /&gt;
1 . open your cron at with&lt;br /&gt;
# vi /var/spool/cron/root&lt;br /&gt;
&lt;br /&gt;
2. Change this cron&lt;br /&gt;
0 1 * * * /scripts/cpbackup into&amp;nbsp;0 0 * * * /scripts/cpbackup , it mean will backup at 00.00&lt;br /&gt;
&lt;br /&gt;
thats how it is</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/1220753811141199478/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/06/how-to-change-backup-time.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/1220753811141199478'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/1220753811141199478'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/06/how-to-change-backup-time.html' title='how to Change Backup time'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-3938605241767892225</id><published>2011-06-15T23:05:00.000-07:00</published><updated>2011-06-15T23:05:28.955-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="vps"/><title type='text'>How To Check Backup On cpanel</title><content type='html'>how to check my cpanel backup status , u can check by type this command&lt;br /&gt;
&lt;br /&gt;
tail -f /usr/local/cpanel/logs/cpbackup/file.log&lt;br /&gt;
&lt;br /&gt;
please try and give us comment</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/3938605241767892225/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/06/how-to-check-backup-on-cpanel.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/3938605241767892225'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/3938605241767892225'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/06/how-to-check-backup-on-cpanel.html' title='How To Check Backup On cpanel'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-7144743337184797974</id><published>2011-05-03T13:57:00.001-07:00</published><updated>2011-05-03T13:58:35.703-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cms"/><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="joomla"/><title type='text'>Forgot Joomla admin password</title><content type='html'>Open the database using phpMyAdmin or database explorer and select the table, jos_users . (replace jos_ with your own table prefix if this is different than the default).&lt;br /&gt;
&lt;br /&gt;
Run the following SQL Code:&lt;br /&gt;
&lt;br /&gt;
INSERT INTO `jos_users`(`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`,`registerDate`, `lastvisitDate`,`activation`,`params`)&lt;br /&gt;
&lt;br /&gt;
VALUES (&#39;40&#39;, &#39;Administrator2&#39;, &#39;admin2&#39;, &#39; your-email@yourdomain.comThis e-mail address is being protected from spam bots, you need JavaScript enabled to view it &#39;,&#39;d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199&#39;,&#39;Super Administrator&#39;, 0, 1, &#39;0000-00-00 00:00:00&#39;, &#39;0000-00-00 00:00:00&#39;,&quot;&quot;,&quot;&quot;); &lt;br /&gt;
&lt;br /&gt;
INSERT INTO `jos_user_usergroup_map` (`user_id`,`group_id`) VALUES (40, 8); &lt;br /&gt;
&lt;br /&gt;
Logon to the back end http://yoursitedomain.com/administrator  using the username admin2 and the password secret in the login box.&lt;br /&gt;
&lt;br /&gt;
that how it works</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/7144743337184797974/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/05/forgot-joomla-admin-password.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/7144743337184797974'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/7144743337184797974'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/05/forgot-joomla-admin-password.html' title='Forgot Joomla admin password'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-467801565079769997</id><published>2011-04-30T23:47:00.000-07:00</published><updated>2011-05-01T00:23:33.331-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="email"/><category scheme="http://www.blogger.com/atom/ns#" term="vps"/><title type='text'>Install Mail Server On your VPS - centos base</title><content type='html'>It&#39;s so simple&lt;br /&gt;
&lt;br /&gt;
1. yum install -y exim&lt;br /&gt;
2. service exim start&lt;br /&gt;
3. chkconfig --level 235 exim on&lt;br /&gt;
&lt;a name=&#39;more&#39;&gt;&lt;/a&gt;&lt;br /&gt;
4. For the IMAP or POP3 you can install dovecot &amp;nbsp;: yum install -y dovecot&lt;br /&gt;
5. service dovecot start&lt;br /&gt;
6. chkconfig --level 235 dovecot on&lt;br /&gt;
7. to test it you can try :&lt;br /&gt;
&amp;nbsp;&amp;nbsp; &amp;nbsp;telnet localhost 25 &amp;lt;- for the smtp port&lt;br /&gt;
&amp;nbsp;&amp;nbsp; &amp;nbsp;telnet localhost 110 &amp;lt;- for the imap</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/467801565079769997/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/04/install-mail-server-on-your-vps-centos.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/467801565079769997'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/467801565079769997'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/04/install-mail-server-on-your-vps-centos.html' title='Install Mail Server On your VPS - centos base'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-1092854487016753103</id><published>2011-04-30T18:34:00.000-07:00</published><updated>2011-04-30T18:34:09.669-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="vps"/><category scheme="http://www.blogger.com/atom/ns#" term="whm"/><title type='text'>Reset Bandwith To Zero - CPanel</title><content type='html'>1. Login To your ssh server&lt;br /&gt;
2- cd /var/cpanel/bandwidth.cache/&lt;br /&gt;
3- vi domainname.com&lt;br /&gt;
4- delete the numbers in that file and retype 0 instead of the number&lt;br /&gt;
5- save and quit and show bandwidth usage in WHM you will find its 0&lt;br /&gt;
&lt;br /&gt;
wow that how it work</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/1092854487016753103/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/04/reset-bandwith-to-zero-cpanel.html#comment-form' title='4 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/1092854487016753103'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/1092854487016753103'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/04/reset-bandwith-to-zero-cpanel.html' title='Reset Bandwith To Zero - CPanel'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>4</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-5186929928260726409</id><published>2011-04-29T10:31:00.000-07:00</published><updated>2011-04-29T10:31:25.761-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="vps"/><title type='text'>Using Varnish</title><content type='html'>If your application works OK we can now switch the ports so Varnish will listen to port 80. Kill varnish.:&lt;br /&gt;
&lt;br /&gt;
# pkill varnishd&lt;br /&gt;
&lt;br /&gt;
and stop your web server. Edit the configuration for your web server and make it bind to port 8080 instead of 80. Now open the Varnish default.vcl and change the port of the default backend to 8080.&lt;br /&gt;
&lt;br /&gt;
Start up your web server and then start varnish.:&lt;br /&gt;
&lt;br /&gt;
# varnishd -f /usr/local/etc/varnish/default.vcl -s malloc,1G -T 127.0.0.1:2000&lt;br /&gt;
&lt;br /&gt;
&lt;a name=&#39;more&#39;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
We’re removed the -a option. Now Varnish will bind to the http port as it is its default. Now try your web application and see if it works OK.&lt;br /&gt;
&lt;br /&gt;
arnish has a great configuration system. Most other systems use configuration directives, where you basically turn on and off lots of switches. Varnish uses a domain specific language called Varnish Configuration Language, or VCL for short. Varnish translates this configuration into binary code which is then executed when requests arrive.&lt;br /&gt;
&lt;br /&gt;
The VCL files are divided into subroutines. The different subroutines are executed at different times. One is executed when we get the request, another when files are fetched from the backend server.&lt;br /&gt;
&lt;br /&gt;
Varnish will execute these subroutines of code at different stages of its work. Because it is code it is execute line by line precedence isn’t a problem. At some point you call an action in this subroutine and then the execution of the subroutine stops.&lt;br /&gt;
&lt;br /&gt;
If you don’t call an action in your subroutine and it reaches the end Varnish will execute some built in VCL code. You will see this VCL code commented out in default.vcl.&lt;br /&gt;
&lt;br /&gt;
99% of all the changes you’ll need to do will be done in two of these subroutines. vcl_recv and vcl_fetch.&lt;br /&gt;
vcl_recv¶&lt;br /&gt;
&lt;br /&gt;
vcl_recv (yes, we’re skimpy with characters, it’s Unix) is called at the beginning of a request, after the complete request has been received and parsed. Its purpose is to decide whether or not to serve the request, how to do it, and, if applicable, which backend to use.&lt;br /&gt;
&lt;br /&gt;
In vcl_recv you can also alter the request. Typically you can alter the cookies and add and remove request headers.&lt;br /&gt;
&lt;br /&gt;
Note that in vcl_recv only the request object, req is available.&lt;br /&gt;
vcl_fetch¶&lt;br /&gt;
&lt;br /&gt;
vcl_fetch is called after a document has been successfully retrieved from the backend. Normal tasks her are to alter the response headers, trigger ESI processing, try alternate backend servers in case the request failed.&lt;br /&gt;
&lt;br /&gt;
In vcl_fetch you still have the request object, req, available. There is also a backend response, beresp. beresp will contain the HTTP headers from the backend.&lt;br /&gt;
actions¶&lt;br /&gt;
&lt;br /&gt;
The most common actions to call are these:&lt;br /&gt;
&lt;br /&gt;
pass&lt;br /&gt;
When you call pass the request and subsequent response will be passed to and from the backend server. It won’t be cached. pass can be called in both vcl_recv and vcl_fetch.&lt;br /&gt;
lookup&lt;br /&gt;
When you call lookup from vcl_recv you tell Varnish to deliver content from cache even if the request othervise indicates that the request should be passed. You can’t call lookup from vcl_fetch.&lt;br /&gt;
pipe&lt;br /&gt;
Pipe can be called from vcl_recv as well. Pipe short circuits the client and the backend connections and Varnish will just sit there and shuffle bytes back and forth. Varnish will not look at the data being send back and forth - so your logs will be incomplete. Beware that with HTTP 1.1 a client can send several requests on the same connection and so you should instruct Varnish to add a “Connection: close” header before actually calling pipe.&lt;br /&gt;
deliver&lt;br /&gt;
Deliver the cached object to the client. Usually called in vcl_fetch.&lt;br /&gt;
esi&lt;br /&gt;
ESI-process the fetched document.&lt;br /&gt;
&lt;br /&gt;
Requests, responses and objects¶&lt;br /&gt;
&lt;br /&gt;
In VCL, there are three important data structures. The request, coming from the client, the response coming from the backend server and the object, stored in cache.&lt;br /&gt;
&lt;br /&gt;
In VCL you should know the following structures.&lt;br /&gt;
&lt;br /&gt;
req&lt;br /&gt;
The request object. When Varnish has received the request the req object is created and populated. Most of the work you do in vcl_recv you do on or with the req object.&lt;br /&gt;
beresp&lt;br /&gt;
The backend respons object. It contains the headers of the object comming from the backend. Most of the work you do in vcl_fetch you do on the beresp object.&lt;br /&gt;
obj&lt;br /&gt;
The cached object. Mostly a read only object that resides in memory. obj.ttl is writable, the rest is read only.&lt;br /&gt;
&lt;br /&gt;
Operators¶&lt;br /&gt;
&lt;br /&gt;
The following operators are available in VCL. See the examples further down for, uhm, examples.&lt;br /&gt;
&lt;br /&gt;
=&lt;br /&gt;
Assignment operator.&lt;br /&gt;
&lt;br /&gt;
==&lt;br /&gt;
Comparison.&lt;br /&gt;
&lt;br /&gt;
~&lt;br /&gt;
Match. Can either be used with regular expressions or ACLs.&lt;br /&gt;
&lt;br /&gt;
!&lt;br /&gt;
Negation.&lt;br /&gt;
&lt;br /&gt;
&amp;amp;&amp;amp;&lt;br /&gt;
Logical and&lt;br /&gt;
&lt;br /&gt;
||&lt;br /&gt;
Logical or&lt;br /&gt;
&lt;br /&gt;
Example 1 - manipulating headers¶&lt;br /&gt;
&lt;br /&gt;
Lets say we want to remove the cookie for all objects in the /static directory of our web server::&lt;br /&gt;
&lt;br /&gt;
sub vcl_recv {&lt;br /&gt;
if (req.url ~ &quot;^/images&quot;) {&lt;br /&gt;
unset req.http.cookie;&lt;br /&gt;
}&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
Now, when the request is handled to the backend server there will be no cookie header. The interesting line is the one with the if-statement. It matches the URL, taken from the request object, and matches it against the regular expression. Note the match operator. If it matches the Cookie: header of the request is unset (deleted).&lt;br /&gt;
Example 2 - manipulating beresp¶&lt;br /&gt;
&lt;br /&gt;
Here we override the TTL of a object comming from the backend if it matches certain criteria::&lt;br /&gt;
&lt;br /&gt;
sub vcl_fetch {&lt;br /&gt;
if (beresp.url ~ &quot;\.(png|gif|jpg)$&quot;) {&lt;br /&gt;
unset beresp.http.set-cookie;&lt;br /&gt;
set beresp.ttl = 3600;&lt;br /&gt;
}&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
Example 3 - ACLs¶&lt;br /&gt;
&lt;br /&gt;
You create a named access control list with the acl keyword. You can match the IP address of the client against an ACL with the match operator.:&lt;br /&gt;
&lt;br /&gt;
# Who is allowed to purge....&lt;br /&gt;
acl local {&lt;br /&gt;
&quot;localhost&quot;;&lt;br /&gt;
&quot;192.168.1.0&quot;/24; /* and everyone on the local network */&lt;br /&gt;
! &quot;192.168.1.23&quot;; /* except for the dialin router */&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
sub vcl_recv {&lt;br /&gt;
if (req.request == &quot;PURGE&quot;) {&lt;br /&gt;
if (client.ip ~ local) {&lt;br /&gt;
return(lookup);&lt;br /&gt;
}&lt;br /&gt;
}&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
sub vcl_hit {&lt;br /&gt;
if (req.request == &quot;PURGE&quot;) {&lt;br /&gt;
set obj.ttl = 0s;&lt;br /&gt;
error 200 &quot;Purged.&quot;;&lt;br /&gt;
}&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
sub vcl_miss {&lt;br /&gt;
if (req.request == &quot;PURGE&quot;) {&lt;br /&gt;
error 404 &quot;Not in cache.&quot;;&lt;br /&gt;
}&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
article from http://www.varnish-cache.org/docs/2.1/tutorial/vcl.html</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/5186929928260726409/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/04/using-varnish.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/5186929928260726409'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/5186929928260726409'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/04/using-varnish.html' title='Using Varnish'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-6379532002216016763</id><published>2011-04-23T19:09:00.000-07:00</published><updated>2011-04-23T19:09:53.432-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="vps"/><title type='text'>How to get file From FTP on my Shell</title><content type='html'>&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp ardsolution.co.cc&lt;/b&gt;&lt;/pre&gt;This command will attempt to connect to the ftp server at abc.xyz.edu.  If it succeeds, it will ask you to log in using a username and password. Public ftp servers often allow you to log in using the  username &quot;anonymous&quot; and your email address as password. Once you are logged in you can get a list of the available ftp commands  using the help function: &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; help&lt;/b&gt;&lt;/pre&gt;This lists the commands that you can use to show the directory contents, transfer files, and delete files. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; ls&lt;/b&gt;&lt;/pre&gt;This command prints the names of the files and subdirectories in the current directory on the remote computer. &lt;br /&gt;
&lt;a name=&#39;more&#39;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; cd customers&lt;/b&gt;&lt;/pre&gt;This command changes the current directory to the subdirecotry &quot;customers&quot;, if it exists. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; cd ..&lt;/b&gt;&lt;/pre&gt;Changes the current directory to the parent direcotry. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; lcd images&lt;/b&gt;&lt;/pre&gt;Changes the current directory &lt;i&gt;on the local computer&lt;/i&gt; to &quot;images&quot;, if it exists. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; ascii&lt;/b&gt;&lt;/pre&gt;Changes to &quot;ascii&quot; mode for transferring text files. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; binary&lt;/b&gt;&lt;/pre&gt;Changes to &quot;binary&quot; mode for transferring all files that are not text files. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; get image1.jpg&lt;/b&gt;&lt;/pre&gt;Downloads the file image1.jpg from the remote computer to the local  computer. Warning: If there already is file with the same name it will  be overwritten. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; put image2.jpg&lt;/b&gt;&lt;/pre&gt;Uploads the file image2.jpg from the local computer to the remote  computer. Warning: If there already is file with the same name it will  be overwritten. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; !ls&lt;/b&gt;&lt;/pre&gt;A &#39;!&#39; in front will execute the specified command on the local computer.  So &#39;!ls&#39; lists the file names and directory names of the current  directory on the local computer. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; mget *.jpg&lt;/b&gt;&lt;/pre&gt;With mget you can download multiple images. This command downloads all files that end with &quot;.jgp&quot;. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; mput *.jpg&lt;/b&gt;&lt;/pre&gt;Uploads all files that end with &quot;.jgp&quot;. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; mdelete *.jpg&lt;/b&gt;&lt;/pre&gt;Deletes all files that end with &quot;.jgp&quot;. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; prompt&lt;/b&gt;&lt;/pre&gt;Turns iteractive mode on or off so that commands on multiple files are executed without user confirmation. &lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background: none repeat scroll 0% 0% rgb(238, 238, 238); border: 2px solid rgb(204, 204, 204);&quot;&gt;&lt;b&gt; ftp&amp;gt; quit&lt;/b&gt;&lt;/pre&gt;Exits the ftp program.</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/6379532002216016763/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/04/how-to-get-file-from-ftp-on-my-shell.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/6379532002216016763'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/6379532002216016763'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/04/how-to-get-file-from-ftp-on-my-shell.html' title='How to get file From FTP on my Shell'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-626665080133695276.post-4154225158361873895</id><published>2011-04-23T18:56:00.000-07:00</published><updated>2011-04-24T00:05:42.765-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cpanel"/><category scheme="http://www.blogger.com/atom/ns#" term="vps"/><title type='text'>CPanel - Change All Folder Or File To 755 and 644 From shell</title><content type='html'>When i check my cpanel, my folder has change into 400 and file 600, how can i change all folder subfolder and all file on subfolder, u can try here baby :&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
1. Create file bash,&lt;br /&gt;
#vi change.sh&lt;br /&gt;
2. Paste this bash script&lt;br /&gt;
#Muhammad Hafidz Aghifary&lt;br /&gt;
#24-04-2011 - test test test&lt;br /&gt;
# Change Folder 755 and file 644 instant&lt;br /&gt;
# Status Weekend On Office&lt;br /&gt;
&lt;a name=&#39;more&#39;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
echo &quot;insert user -hafidz script-&quot;&lt;br /&gt;
&lt;br /&gt;
read input&lt;br /&gt;
a=&quot;$input&quot;&lt;br /&gt;
&lt;br /&gt;
find /home/$a/public_html -type d -exec chmod 755 {} \;&lt;br /&gt;
find /home/$a/public_html -type f -exec chmod 644 {} \;&lt;br /&gt;
&lt;br /&gt;
4. Save file , and give&lt;br /&gt;
# chmod +x change.sh&lt;br /&gt;
&lt;br /&gt;
5. run The Script&lt;br /&gt;
# ./change.sh&lt;br /&gt;
&lt;br /&gt;
Wow My files Change it All, THat How ItS Works</content><link rel='replies' type='application/atom+xml' href='http://hostingmantab.blogspot.com/feeds/4154225158361873895/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://hostingmantab.blogspot.com/2011/04/cpanel-change-all-folder-or-file-to-755.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/4154225158361873895'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/626665080133695276/posts/default/4154225158361873895'/><link rel='alternate' type='text/html' href='http://hostingmantab.blogspot.com/2011/04/cpanel-change-all-folder-or-file-to-755.html' title='CPanel - Change All Folder Or File To 755 and 644 From shell'/><author><name>Tutorial - example - cpanel - plesk - hosting</name><uri>http://www.blogger.com/profile/16795976379965732827</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry></feed>