FreeBSD: Upgrade from 8.2 to 9.0

To check the freebsd version;

#uname -a

-if generic, you can use this step.. :)

You can use this command to upgrade to latest release FreeBSD 9.0:

# freebsd-update -r 9.0-RELEASE upgrade

You might see following error:
The update metadata is correctly signed, but failed an integrity check. Cowardly refusing to proceed any further.

This error indicate that it cannot accept % and @ characters which appear in FreeBSD 9. To overcome this, run following command:

# sed -i '' -e 's/=_/=%@_/' /usr/sbin/freebsd-update

Now start the upgrade process:

# freebsd-update -r 9.0-RELEASE upgrade

Accept all prompted values and follow the wizard. This process downloads all files and patches required for upgrade so it takes time. You might need to press ‘Enter’ once to check /etc/hosts file. Once complete, run following command to start installing the updates:

To quit from vi:  type :q

Then it will asked you to run /usr/sbin/freebsd_update install 

The system must now be rebooted with the newly installed kernel before the non-kernel components are updated.

# reboot

After the process completed, the system will ask you to build back all your application which installed using ports. Once done, you need to rerun again the above command to complete the upgrade process and you should something like below:

# freebsd-update install 

Installing updates... Done

Your update should be completed now. To check the new version, run following command:
# uname -r 

9.0-RELEASE

BUT.. then my apache cannot start... OHHH NOOO... 

here is the error:

Performing sanity check on apache22 configuration:

httpd: Syntax error on line 105 of /usr/local/etc/apache22/httpd.conf: Cannot load /usr/local/libexec/apache22/libphp5.so into server: Shared object "libz.so.5" not found, required by "libphp5.so"

Edit this file

# ee /etc/libmap.conf

libz.so.5  libz.so

then... you can restart the apache /usr/local/etc/rc.d/apache22 restart

"Kerberos" authentication failed while trying to access EMC or EMS

My colleague have this problem when she want to access EMC Microsoft Exchange: 

After I check the problem, I could see that she don't have this folder.

C:\Users\{user}\AppData\Roaming\Microsoft\Exchange\RemotePowerShell\server.domain.com

So, I copied mine but she still cannot access.

Then, I go to this folder and delete the Exchange Management Console file.
C:\users\\AppData\Roaming\Microsoft\MMC\Exchange Management Console
Close EMC and reopen it.

And its working... hahaha.. very good... :) 

Reset Password For Wordpress and VB in Mysql

WORDPRESS

1. Get an MD5 hash of your password.
2. Visit md5 Hash Generator, or...
3. Create a key with Python. or...
4. On Unix/Linux:
5. Create file wp.txt with the new password in it (and *nothing* else)
6. md5sum wp.txt
7. rm wp.txt
8. "mysql -u root -p" (log in to MySQL)
9. enter your mysql password
10. "use (name-of-database)" (select WordPress database)
11. "show tables;" (you're looking for a table name with "users" at the end)
12. "SELECT ID, user_login, user_pass FROM (name-of-table-you-found)" (this gives you an idea of what's going on inside)
13. "UPDATE (name-of-table-you-found) SET user_pass="(MD5-string-you-made)" WHERE ID = (id#-of-account-you-are-reseting-password-for)" (actually changes the password)
14. "SELECT ID, user_login, user_pass FROM (name-of-table-you-found)" (confirm that it was changed)
15. (type Control-D, to exit mysql client)

Referrence : http://codex.wordpress.org/Resetting_Your_Password

Eg: 

UPDATE `wparb_users` SET `user_pass` = MD5('passwordbaru' ) WHERE `wparb_users`.`user_login` = "admin" 

VBULLETIN

Eg:

UPDATE user set password = MD5(concat(MD5(''), user.salt)) WHERE userid =  

CVS is Deprecated at FreeBSD.org (and so is cvsup!)

Today I'm starting doing my server preventive maintenance. I usually using cvsup to update package in FreeBSD and today, I received error:
So, the solution is using portsnap.
Here is the step :
1. Download a compressed snapshot of the Ports Collection
# portsnap fetch
2.When running Portsnap for the first time, extract the snapshot
# portsnap extract
3. cd
-> since it will reset your node point.

Then you can still use the port upgrade command as usual :)