splash
Ardiansyah
A Father of three children, and wants to lead all of the family to reach the highest location in Jannah
Dari Ibnu Abbas ia berkata, "Dahulu aku pernah berada di belakang Rasulullah, lalu beliau bersabda: "Wahai anak kecil sesungguhnya aku ingin mengajarimu beberapa kata, jagalah Allah, maka pasti Allah menjagamu, jagalah Allah pasti kau akan menjumpai-Nya dihadapanmu. Apabila engkau meminta maka mintalah kepada Allah dan jika engkau meminta pertolongan maka mintalah pertolongan kepada Allah. Ketahuilah, seandainya suatu umat berkumpul untuk memberikan manfaat kepadamu maka mereka tidak bisa memberi manfaat tersebut kecuali yang telah ditakdirkan Allah untukmu dan apabila mereka berkumpul untuk memadharatkanmu maka mereka tidak bisa memadharatkanmu kecuali dengan apa-apa yang ditakdirkan oleh Allah atasmu, telah diangkat pena dan telah kering tinta" (HR. Tirmidzi, hasan shohih)
 

You Are Viewing Online Note for System Administrator

Backup and Restore MySQL Database

Posted By ariandita on December 20th, 2012

Hi there . . . .
As System Administrator we need to maintain Database Server, whether it’s open source or proprietary. I am using MySQL Server as database backend of WordPress, and one day a notification showed up, tell me that the newest WordPress had been released.
Wow it’s time to upgrade, but the notification also tell me to backup database and content first before upgrading, so I have to google to find out how to backup and restore a MySQL databse, I remembered that the last time I google I’ve found it in the most incredible blog about Linux, The CyberCiti, but I couldn’t find it now, I found the solution from thegeekstuff.com instead.

  1. How to backup
    Backup MySQL database can be done with two ways that I could find in thegeekstuff.com,

    • first with the mysqldump syntax
    • and the mysqlhotcopy syntax

    I choose to backup with mysqldump syntax, which is
    mysqldump -u username -p username_password MySQL_database_name > dumpfilename.sql

  2. How to Restore
    to restore from dumpfile we can use this syntax
    mysql -u username -p username_password MySQL_database_name < dumpfilename.sql

The backup progress sometime get failed with this notification

mysqldump: Got error: 1016: Can’t open file: ‘./databasename/tablename.frm’ (errno: 24) when using LOCK TABLES

Use these additional parameter to the backup command –skip-lock-tables or –lock-tables=false

That’s it, than I backed up the WordPress content with tar -cvf
OK than, I’ve upgraded the WordPress to the newest version, which is 3.5
Happy Administer System !

How to Remove Certain Email from Postfix Queue

Posted By ariandita on December 12th, 2012

As System Administrator sometimes we need to remove certain email from queue, first we have to know what items we want to remove, please use the mailq syntax, let’s try with MAILER-DAEMON items that we actually not need

mailq | grep MAILER-DAEMON

when the items is selected and confirmed, use this command to remove all selected items

mailq | grep accounts.serpong@binus.edu | awk ‘{print $1}’ | tr -d ‘*’ | postsuper -d -

Happy Administering System

How to Connect to AdminServer when CS Admin Kit.msc is broken (Kaspersky Administration-Kit)

Posted By ariandita on October 15th, 2010

Bina Nusantara uses Kaspersky Total Space Security for workstation’s and file server’s security. The Kaspersky Administration Server named Admin-Kit Server have its build in administration console on top of Microsoft Management Console. The Administration Console have a saved .msc file named “CS Admin Kit.msc”. The Main Server of Binus have Windows 2003 Standard x64 Edition. A few days after upgrading from old Admin-Kit Server, the shortcut won’t work. Look at this :

the Technical Engineer from Optima told me to use mmc.exe that is present in ordinary Windows Installation can be used to open the msc file that came from the Kaspersky Admin-Kit.

How to open FTP Passive Mode and Restrict the port used by FTP Passive Mode on Windows 2003 Server

Posted By ariandita on October 12th, 2010

Default FTP mode in Windows Server 2003 is active mode, it is more simple than FTP passive mode, but when load of the FTP is high we need FTP Passive mode to increase speed of the file transfer. Any mode of FTP will make no problem when we do not activate the built in firewall of Windows Server 2003. If we have to activate the firewall in FTP Active mode we just have to open single port, it is port 21, but if we decide to use FTP passive mode we have to open 10 – 50 dedicated port to server the FTP connection. Opening so many port in Windows Server 2003′s firewall will make us tired and bored, because to open a single port in Windows we need two clicks and several types.

Test Image :

[IMG]http://i259.photobucket.com/albums/hh287/ariandita/File-Location.jpg[/IMG]

How to add binus.edu account to your Blackberry Internet Service

Posted By ariandita on June 28th, 2010

The last Friday is like a nightmare for Binus Datacenter. Our Microsoft Exchange 2007 Client Access Server is dead. The Volume that contains Windows 2003 Operating System is corrupt. Fortunately we have another server that can be promoted to become a Client Access Server. Almost two days we tried to recovered the dying server. And we’ve done it on Saturday. Now we have all system ready but another problem occurred. Everyone that have a Blackberry and connect to our mail system via Blackberry Internet Service report that they don’t receive email for the past three days.

Although Data Center Staff do not have any Blackberry Device we try to get one to try the BIS setting. The problem solved when we erased the old account and created new one.

Please provide these data on the Provider’s Web Email Setting, open your Blackberry Web Browser and open this site

for Telkomsel : http://telkomsel.blackberry.com/
for Indosat : http://indosat.blackberry.com
for XL : http://www.xl.blackberry.com
for 3 : http://tri.blackberry.com/
for Axis : http://axis.blackberry.com/

Please provide this data in the next page

1. Email address : blablabla@binus.edu

2. Your password : “Binus1234″  ( Binus default password )

and click Next

your Blackberry Device will say

The email address or password is incorrect, or we need more detail

Retype the information or provide additonal settings.

Please select the Provide Additional Setting

1. Select Microsoft Outlook WebAccess

2. Provide the Outlook Web Access address for Binus : https://mail.binus.edu/owa

3. Login Name : binus/blablabla

4. Mailbox Name : blablabla

Klik Next

Your Blackberry should accept your configuration.