You Are Viewing ComputerFreak

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 !

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
   [code language=”bash”]
   mysqldump -u username -p username_password MySQL_database_name > dumpfilename.sql
   [/code]

2. How to Restore
   to restore from dumpfile we can use this syntax
   [code language=”bash”]
   mysql -u username -p username_password MySQL_database_name < dumpfilename.sql
   [/code]

The backup progress sometime get failed with this notification

[code language=”bash”]
mysqldump: Got error: 1016: Can’t open file: ‘./databasename/tablename.frm’ (errno: 24) when using LOCK TABLES
[/code]

Use these additional parameter to the backup command
[code language=”bash”]
–skip-lock-tables
[/code]
or
[code language=”bash”]
–lock-tables=false
[/code]

That’s it, than I backed up the WordPress content with
[code language=”bash”]
tar -cvf
[/code]
OK than, I’ve upgraded the WordPress to the newest version, which is 3.5
Happy Administer System !

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

[code language=”html”]
mailq | grep MAILER-DAEMON
[/code]

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

[code language=”html”]
mailq | grep MAILER-DAEMON | awk ‘{print $1}’ | tr -d ‘*’ | postsuper -d –
[/code]
Happy Administering System

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

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.

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.