This error appears to show up sometimes when using MySQL 5 with –with-mysql=/usr.
There have been reports that changing it to –with-mysqli=/usr/bin/mysql_config will fix this, but when I tried it, the mysql client api in php was set to mysql 3, so it wasn’t quite working. The solution I used was to have them both in the configure.php:

–with-mysql=/usr \
–with-mysqli=/usr/bin/mysql_config \

Then recompile php:

./build clean
./build php n

Then I edited the /etc/httpd/conf/httpd.conf and changed:

SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
#SSLRandomSeed startup file:/dev/random 512
#SSLRandomSeed startup file:/dev/urandom 512
#SSLRandomSeed connect file:/dev/random 512
#SSLRandomSeed connect file:/dev/urandom 512

To

#SSLRandomSeed startup builtin
#SSLRandomSeed connect builtin
#SSLRandomSeed startup file:/dev/random 512
SSLRandomSeed startup file:/dev/urandom 512
#SSLRandomSeed connect file:/dev/random 512
SSLRandomSeed connect file:/dev/urandom 512

Quite possibly, only the changes to the httpd.conf are actually required, but adding the extra functionality of mysqli probably won’t hurt any.
I also upgraded MySQL to 5.0.41 (this case, it was a 64-bit server):
http://files.directadmin.com/services/all/mysql/64-bit/

DirectAdmin essentially will work with any version of the software you want (within reason). You can use these newer versions of the software should you with to have them.
*** For Apache 2.2 and php 5.x, we have a new custombuild script available:
http://files.directadmin.com/services/custombuild/1.1. It will install both apache 2.2 and php 5 automatically for you. It also contains code for installing mysql 5. The custombuild script is consider the more recent way to install apache 2, php 5 and mysql 5. The rest of the guide will still work, but it’s more time consuming.

---

To convert apache 1.3 to apache 2.0, use this guide:
directadmin.com/features.php?id=441

---

For php 5, use this guide (after you are running the apache version you want to have):
help.directadmin.com/item.php?id=135

---

Regarding MySQL 5.0, you must first decide if you are eligible for the version change. If you are running MySQL 4.1.x or higher, then there won’t be any issues. If you are running MySQL 4.0.x or lower, then you have to take note of the following:
There passwords and table format changes between 4.0 and 4.1. Updating tables to the 4.1 format is not too difficult after the update is done:

mysql_fix_privilege_tables –user=da_admin –password=`cat /usr/local/directadmin/conf/mysql.conf | grep passwd |cut -d= -f2`

**However**, the password format cannot be converted to the new password format in 4.1. You have 2 choices:
1) After updating, go through all MySQL accounts and resave their passwords. You will need to know their plaintext password to do this. This is ideal so that you are using the latest formats and do not need to worry about compatibility issues with future releases.
2) Retain the old password formats and tell the new version of mysql to use those old formats by adding:

[mysqld]
old_passwords

into your /etc/my.cnf file, then restart mysqld. You will need to create this file.
This 2nd option is good to save time, but if you ever need to transfer the accounts to a new server already running MySQL 4.1 or higher, you will need to resave all mysqld password for that transferred account. The MySQL server should have all passwords in the same format.. either the new one, or the old one. If there are already account in the new format, you need to resave the passwords to it.
Related guide: directadmin.com/features.php?id=466
Once you’ve decided if the update is for you, use these guides to do it:
FreeBSD/Debian:
help.directadmin.com/item.php?id=106
You will need to get the binaries for your particular OS version. If you cannot file them on files.directadmin.com/services, then go to dev.mysql.com and download the binaries for your system. We do not have any special compile options, and we use all stock binaries from dev.mysql.com whenever possible. **Note** that the guide there contains freebsd binaries. Debian binaries would have to be downloaded if you use Debian. The same instructions apply.
Redhat/Fedora/CentOS (anything with rpms):
Conversion with rpms is quite easy (note the above notices about moving from 4.0 to 4.1 or higher still apply).
Download the 4 MySQL rpms that you want to use, either from files.directadmin.com or from dev.mysql.com. You’ll need the server, client, shared and devel rpms. You must not have any mismatched versions. We recommend generic i386 rpms. If you have 64-bit system, then you’ll need binaries specific to your system (dev.mysql.com has everything you’ll need)
Use wget to download all 4 rpms, then use "rpm -Uvh file.rpm" to update/install them, for example:

mkdir mysql
cd mysql
wget http://files.directadmin.com/services/all/mysql/MySQL-client-5.0.37-0.i386.rpm
wget http://files.directadmin.com/services/all/mysql/MySQL-devel-5.0.37-0.i386.rpm
wget http://files.directadmin.com/services/all/mysql/MySQL-server-5.0.37-0.i386.rpm
wget http://files.directadmin.com/services/all/mysql/MySQL-shared-5.0.37-0.i386.rpm
rpm -Uvh MySQL-*-5.0.37-0.i386.rpm
/sbin/service mysqld restart

Again, keep in mind any changes you may need to do to your database to make this version work.
If you have a clean DirectAdmin install without any databases on it yet and you wish to install the new version, it would likely be easier to use this guide to move cleanly to the version you want: help.directadmin.com/item.php?id=96. It will install all data and passwords after deleting the previous data (hence, youll need a new install first because any databases are going to be lost). For the guide, you’d replace the 4.0 rpms used in the example and simply download the 5.0.x version mentioned above.
It’s also recommended you do a full php recompile to load in MySQL’s current version of the client libraries. Hence, if you are going to be updating php anyway, do MySQL first.

This document provides information about MySQL databases.  Topics include creating databases, removing databases, adding users to a database, changing database passwords, and setting up your database with scripts.  The control panel makes database management easy for those people who don’t have in-depth knowledge of the topic.

Creating Databases 

From the main control panel menu click the "MySQL Databases" icon and then click the "Create new Database" link.

Choose a Database Name that helps you remember what the database is for.  For example, enter "chat" if the database is intended to be used with a chat script.  The database name is always preceded by your username and an underscore.  If you chose "chat" for a name, the actual database name would be username_chat.

The Database Username is the login name for the database.  It may be the same as the Database Name.  In the above example, we chose a different login name (gary).  As with the Database Name, the Database Username is also preceded by your username and an underscore (username_gary in this case).

After you have selected the database name and username, enter a database password and click the "Create" button.

Removing Databases

A list of all databases is present in the main MySQL databases menu.  To delete a database, check the box next to the database name you want to delete and then click the "Delete Selected" button.  In the above example, we are deleting the database named username_data1.

Adding Users to a Database

There may be times when you want to have more than one login name and password assigned to a database.  To add additional users to a database, follow these steps:

1.  From the main database menu, click on the name of the database you want to modify.

2.  Click on the "Create New Database User" link at the top of the screen.

3.  Enter a username and password and then click the "Create" button.

You can see how many users each database has from the main MySQL databases menu.

Removing Users from a Database

To remove database users, first click on the database name from the main MySQL databases menu.  In this example we have clicked on the "username_chat" database, which has two users (see above picture).

The username_chat database has two users: username_chat (the username is the same as the database name) and username_gary2.  To delete the database user, simply check the box next to its name and click the "Delete Selected" button.

Changing Database Passwords

To change a database password, first click on the name of the database in the main MySQL databases menu.  The list of database users will appear (see above picture).  To change the password for the database user, click the "modify" link and enter a new password, then click the "Create" button.  You do not need to know the old password to make this change.

Setting up your Database with Scripts

Most scripts need to know four things about your database: the database name, database username, password, and hostname. 

The database name always takes the form as ControlPanelUsername_DatabaseName, where ControlPanelUsername is the sign in name you use to access the control panel.  The DatabaseName is the name you give to the database from the MySQL databases menu.  For example, if you sign into the control panel as "gary" and create a database named "count," the true database name is gary_count — you will want to enter this database name into your script configuration.

The database username can be the same as the database name or you may choose a different username for the database.  The database username takes the form of ControlPanelUsername_DatabaseUserName.

The database password is set during database creation.  The password should be different than your control panel password.  The script will need to know the database password in order to modify the database.

The hostname tells the script where to access the database.  Usually this is designated as ‘localhost’ because the script and database are located on the same server.  If the script doesn’t allow a text entry in the hostname configuration, enter the IP address of your site.

Note: 

After you create a database, the control panel will take you to a screen that gives you all this information.  Simply take the values from this page and enter them into your script configuration.

Accessing phpMyAdmin

phpMyAdmin is a tool written in PHP that allows you to administrate your MySQL databases.  You can execute SQL statements, work with fields (add, edit, delete), work with tables (create, alter, drop), create additional databases, and much more.  phpMyAdmin is intended for advanced users.  Most PHP scripts will automatically setup the database for you, so you probably won’t need to use phpMyAdmin..

phpMyAdmin can be accessed at http://www.yourdomain.com/phpMyAdmin.  Please visit http://www.phpmyadmin.net for more information on using phpMyAdmin.

1. INTRODUCTION

1a. Introduction

LXadmin “Host in a box” is the only control panel that makes use of Lighttpd and DJBDNS which only uses 8 MB of RAM with a freshly installed system. The control panel itself uses 1 MB of RAM when idle. LXadmin “Host in a box” is part of LXadmin, the leading light-weight control panel in the industry. The only difference between the two is the use of different daemons.

This lightweight control panel has all of the features included in all leading control panels such as mail, spam filter, PHP, CGI, Perl, SUexec, FTP, MySQL and much much more. You will get to find out more in this document as you read.

---

2. THE BASICS

2a. Accessing the control panel

There are several ways to access LXadmin: http://yourdomain:7778 – You can access the control panel through any hosted domain by putting :7778 at the end of the domain. https://yourdomain:7777 - You can access the control panel securly using SSL through any hosted domain by putting :7777 at the end of the domain. http://192.168.0.1:7778 or https://192.168.0.1:7777 - You can access the control panel through any IP address allocated to the server.  This is useful when your domain transfer has not yet propagated. A window (top right image) will appear.  Enter your username and password and you should have successfully logged in.

2b. Changing your password

To change your password, click client home and then on the top right corner, you will see the password tab. Click on it and fill in your existing password and the new password twice and click Update.

2c. Adding a DNS Template

You have to add a DNS template initially. DNS template is the DNS configuration which will be copied to your domain’s DNS when a new domain is created. For adding a DNS template, you have to basically specify the primary and secondary nameservers for the domains you are planning to create on this server. For instance: ns1.lxlabs.com and ns2.lxlabs.com . The name is simply an identifier which will be used later when creating the domain.

For creating a new DNS template,

go to “Client Home” page and under “Domains“, click the “DNS Templates” icon

In the DNS Templates page, you can see the list of existing DNS templates. If you do not have any existing DNS template, create a new DNS template by clicking the “Add DNS Template” tab on the top.

In the next page, enter the DNS information for the template:

Click the “Add” button and the new DNS template is created. You can see the new DNS template in the list of DNS Templates

Click on the new DNS Template name to edit DNS records like NS, A, CNAME, MX and TXT

2d. Add a Reseller

Before you proceed to add a new Reseller, you have to add a new plan for the new client/reseller
To add a new plan,

To add a new plan, click “Client Plans” icon

In the next page, click the “Add Client Plan” tab.

Here you can enter the plan details like:

Client Plan name)
Description of the plan
Number Of Clients allowed
Number Of Domains allowed
Disk Usage (in MB)
Number Of Subdomains allowed
Mail Disk Usage (in MB) limit
Number Of Autoresponders allowed
Number of Mail Accounts allowed
Number Of Mailing Lists allowed
Traffic (in MB per Month) limit
Maximum number of MySQL Databases
Maximum Number Of Domain Users
Ability to add more domains
Ability to set Disabled URL
Ability to Enable Ssl
Ability to Enable Statistics
Ability to Enable Cgi
Ability to Enable Php
Ability to Enable Asp.net (ignored On Linux)
Allow Scheduler Management or not
Allow Backup Scheduling or not
Allow Backing Up or not
Can Manage DNS or not

Once you have created the plan, go back to the “Client Home” page and click the “Clients” button link

This page will list your existing customers and resellers. If you do not have any, click on either the “Add Reseller” tab that you see on the top.

In the “Add Reseller” page, enter a name for your Reseller, password and email address.
If you enable the “Send Welcome Message” check box, an email with the account details will be sent automatically to the Reseller’s email address.
Select the plan you have created earlier and click “Add” button.

Now in the “Clients” page, you should be able to see the new Reseller that you have created:

Joomla! adalah Sistem Manajemen Konten (SMK atau CMS) yang bebas dan terbuka (free opensource) ditulis menggunakan PHP dan basisdata MySQL untuk keperluan di internet maupun intranet. Joomla pertamakali dirilis dengan versi 1.0.0. Fitur-fitur Joomla! diantaranya adalah sistem caching untuk peningkatan performansi, RSS, blogs, poling, dll. Joomla! menggunakan lisensi GPL.

Asal kata Joomla sendiri berasal dari kata Swahili yang mengandung arti “kebersamaan”.

Prinsip Dasar Joomla

Secara garis besar dan gamblang, Joomla! terdiri dari 3 elemen dasar, yaitu server web (webserver), skrip PHP dan basisdata MySQL. Server web diasumsikan terhubung dengan Internet/Intranet yang berfungsi sebagai penyedia layanan situs. Skrip PHP terdiri dari kode program dalam bahasa PHP dan basisdata merupakan tempat penyimpanan konten. Joomla menggunakan Apache sebagai server web dan MySQL untuk basisdatanya.

Pertamakali, pengguna meminta akses terhadap halaman Joomla dengan mengeksekusi URL pada browser web yang kemudian terhubung dengan server web. Permintaan ini yang dalam istilah teknis lebih dikenal dengan query string selain terdapat URL juga mengandung parameter konten (section, category, ID article dan lain-lain). Berdasarkan parameter tersebut, sistem skrip Joomla melakukan kontak dengan basisdata dan mengambil konten yang dimaksud berdasarkan parameternya. Terakhir, konten dan templat (template) digabung bersama dan kembali sebagai halaman html, gambar, css dan javascript.

Paket Joomla! terdiri dari beberapa bagian yang terpisah dan termodul yang sangat fleksibel, dapat dengan mudah dikembangkan dan diintegrasikan. Sebagai contoh “plugins” WikiBot yang memperbolehkan penulis di Joomla menggunakan “Wikitags” pada bagian artikel yang fungsinya secara otomatis membuat pranala dinamis ke artikel Wikipedia pada saat ditampilkan. Ada lebih tersedia 1,700 “plugins” yang secara resmi didelegasikan oleh OpenSourceMatters tersedia di http://extensions.joomla.org/ dan saat ini secara resmi dipindahkan ke http://joomlacode.org dengan dukungan server yang lebih lengkap.

Riwayat Joomla

Pada tanggal 17 September 2005, diluncurkan Joomla versi awal yaitu 1.0.0 yang merupakan versi alias dari Mambo 4.5.2.3 yang dikembangkan oleh “Pengembang Inti Mambo hingga Agustus 2005″ yang hengkang dari Mambo.

Pemimpin Tim saat itu Andrew Eddie yang dikenal dengan sebutan “MasterChief” menulis surat terbuka di komunitas dan diumumkan di forum mamboserver.com. Tim pengembang kemudian membuat situs OpenSourceMatters untuk mendistrubusikan informasi ke pengguna, pengembang, desainer web dan komunitas lain pada umumnya.

Perkembangan Joomla berawal dari Joomla 1.0.0 sampai dengan tahap yang luar biasa yaitu Joomla 1.0.15. Namun seiring dengan perkembangan versi Joomla 1.0.x ini, sekitar tahun 2007 telah dimulai pengembangan Joomla 1.5.x yang memiliki beberapa persamaan dan perbedaan yang cukup signifikan. Saat ini Joomla 1.5.x telah mencapai pada tahap Joomla 1.5.8.

Masing-masing punya daya tarik tersendiri, Joomla 1.5.8 menawarkan nuansa baru dan lebih modern termasuk dalam systemya. Sedangkan Joomla 1.0.15 lebih stabil dan terdukung oleh banyak aplikasi dan developer.

No.	Versi	Tanggal Diluncurkan	Nama Kode
1.	1.0.0	17 September 2005	Sunrise
2.	1.0.1	21 September 2005	Sunburst
3.	1.0.2	2 Oktober 2005	Sunset
4.	1.0.3	14 Oktober 2005	Sunlight
5.	1.0.4	21 Nopember 2005	Sundial
6.	1.0.5	24 Desember 2005	Sunspot
7.	1.0.6	15 Januari 2006, 16:00	Sunscreen
8.	1.0.7	15 Januari 2006, 21:00	Sunburst
9.	1.0.8	26 Februari 2006	Sunshade
10.	1.0.9	5 Juni 2006	Sunshine
11.	1.0.10	26 Juni 2006	Sundown
12.	1.0.11	29 Agustus 2006	Sunbow
13.	1.0.12	25 Desember 2006	Sunfire
14.	1.0.13	2007	Sunglow
15.	1.0.14	2008
16.	1.0.15	2008
15.	1.5 Stable	22 Januari 2008	Stable

Seperti yang disampaikan oleh Pihak Pengembang Inti Joomla, Joomla 1.0.x akan berakhir pada Joomla 1.0.15. Tidak ada support dan pengembangan selanjutnya. Dan mereka akan berkonsentrasi pada Joomla 1.5.x. Pengguna Joomla dapat melakukan installasi pada server kami dengan manggunakan Fantastico auto installer