How to upgrade mariadb 5.1.50 to mariadb 5.2.3

New mariadb 5.2.3 version already out. I just curious on how to upgrade mariadb since I just installed it 3 days ago :-)

From montyprogram :

MariaDB 5.2.3 is a Stable release. In general this means there are no known serious bugs and we believe the code is ready for general usage.

Here’s upgrade process of mariadb from 5.1.50 to 5.2.3 on freebsd 8.1 stable :

Backup first

#cd /usr/local

#tar cvzf var.tar.gz var

#mv var.tar.gz /home/alamsyah

Continue reading

How to install mariadb on FreeBSD

Recent discussion around mysql license and its future lead me to mariadb.

From Wikipedia

MariaDB is a community-developed branch of the MySQL database, the impetus being the community maintenance of its free status under GPL, as opposed to any uncertainty of MySQL license status under its current ownership by Oracle.

The intent also being to maintain high fidelity with MySQL, ensuring a “drop-in” replacement capability with library binary equivalency and exacting matching with MySQL APIs and commands. It includes the XtraDB storage engine as a replacement for InnoDB.

Its lead developer is Monty Widenius, the founder of MySQL and Monty Program AB.”

dba by night, ninja by nightBeing curious I decide to install mariadb on my Freebsd 8.1 stable . My first option for install is via ports but at time writing I don’t find the mariadb port :-(

After search and dig google I came up with solution on how to install mariadb from source.

Here the steps :

Continue reading

How to install postgresql 8.1.22 and php 5.2.14 on FreeBSD 8.1 stable

Recent change in mysql make my friend contact me. He want to learn and practice about postgresql before use it on real cpanel host that support postgresql . I agree to set new server for him to play around. The  server itself basically consists of apache, php, postgresql and phppgadmin on FreeBSD 8.1 stable.

Here the steps :

Which Version of Postgresql

I also have same hosting account that my friend use. I log in to cpanel then click phppgadmin to see postgresql version.

Ok. I can see that Postgresql 8.1.22 installed on that host.

Continue reading

Upgrade Zimbra Network Edition from 6.0.1 to 6.0.8

Stop Zimbra Service

su – zimbra

$ zmcontrol stop
Host mail.yourdomain.com
Stopping stats…Done.
Stopping mta…Done.
Stopping spell…Done.
Stopping snmp…Done.
Stopping archiving…Done.
Stopping antivirus…Done.
Stopping antispam…Done.
Stopping imapproxy…Done.
Stopping memcached…Done.
Stopping mailbox…Done.
Stopping convertd…Done.
Stopping logger…Done.
Stopping ldap…Done.
$
$ exit
logout
#

Backup Zimbra

# cd /opt
# tar cvzf zimbra.tar.gz zimbra

Check Zimbra Version

$ zmcontrol -v

Release 6.0.1_GA_1816.UBUNTU8 UBUNTU8 NETWORK edition.

Check License
$ zmlicense -c
license is in grace period

$ zmlicense -c
license is OK

Continue reading

How to update / renew Zimbra License

Your Zimbra Network License expired 24 days ago :-)

Yes, that message show up when I log in to one of my client and they ask me to renew the license.

Well, the process itself isn’t difficult as what you need to extend zimbra license just ask sales at zimbra.com.

they will email license key and with the key what you need to do is login to zimbra admin.

Click on Global Settings.

Click License will give this screen.

Click Update License.

Browse for license file and click Next.

Your license file is uploaded successfully.

Click Install.

You license file is installed successfully.

Done.

Client can continue their zimbra mailbox.