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 ComputerFreak

WordPress Blogging

Posted By ariandita on April 18th, 2013

I’ve never been so frustrating when blogging, now it become that worst. You know why ? Because the administrator of the Multisite WordPress Blog is ME !

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 Set Outlook Anywhere On in binus.edu email Account

Posted By ariandita on November 7th, 2012

Binus Exchange Server have Outlook Anywhere On that means you can connect to Email Server from internet with Microsoft Outlook Client, here how to set your Microsoft Outlook 2007 to access binus.edu email account from the internet

Open Microsoft Outlook 2007


Select Tools – Options

On Account Settings windows click Change

On Change E-mail Account window click More Settings

On Microsoft Exchange windows please select Connection tab

On Connection tab please check the Connect to Microsoft Exchange using HTTP options, and click on Exchange Proxy Setting to change detail configuration

On Microsoft Exchange Proxy Setting fill in Use This URL to connect to my proxy server for Exchange with mail.binus.edu , check the Only connect to proxy servers that have this principal name in their certificate option and fill it with msstd:mail.binus.edu

Click OK

Click OK

Click OK

Click Next

Click Finish

Click Close

Please restart your Microsoft Outlook 2007 to have newly setting applied

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 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.