posted 4 years ago in CUBRID Apps&Tools category by Esen Sagynov
Wordpress is an open source blog publishing web application powered by PHP which can also be used for content management. It has many features including a plugin architecture and a templating system. Used by over 2% of the 10,000 biggest websites, WordPress is the most popular blog software in use today.
As CUBRID is getting more popular, our CUBRID Developers Community has ported Wordpress to use CUBRID DBMS as the back-end database server. Wordpress for CUBRID Project Site is hosted at NAVER Development Center.
All latest Wordpress releases are compatible with CUBRID. You can download them by clicking one of the links below. You are highly recommended to download the latest version.
- Wordpress 18.104.22.168
- Wordpress 2.9.2
- Wordpress 2.9.1
- Wordpress 2.9
- Wordpress 2.8.6
- Wordpress 2.8.5
- Wordpress 2.8.4
Wordpress Installation Guide
This guide assumes that you have CUBRID 2008 already installed on your operating system. If not, download the latest version from CUBRID Downloads page. For the information on how to install CUBRID, refer to CUBRID Installation Guide. In this tutorial we will be working with CUBRID for Windows. If you are using another version, there will not be any significant differences. So, you should not worry.
In order to run Wordpress you also have to have Apache Web Server and PHP Engine installed prior to proceeding to Wordpress installation.
- You can download Apache Web Server from http://httpd.apache.org/
- PHP Engine can be obtained from http://www.php.net/
Once everything is installed, you first have to prepare the database which will hold your blogging site information.
Preparing the database for Wordpress site
First, create a database which will now on hold the WordPress site data. Skip this step if you have already created a database for the site.
Once CUBRID is installed, the CUBRID Service Tray icon will appear on your system tray. Click on CUBRID Manager as shown below to open CUBRID Manager.
If you click the CUBRID Manager and log in the [Site Manager] dialog box, the following window will appear. With the CUBRID Manager, you can manage all databases, their classes, and users.
Now, select [Create Database] sub menu under [Action] main menu. You should see the image below.
Type a name for your new database which will hold your site data. Remember this name, because you are going to need it WordPress installation. Then, click [Next].
When the above dialog appears, click [Next].
If the database is successfully created, the dialog box shown above will popup, displaying the summary of the current database creation process. Click [Finish] to create the new database. It might take a while to create files required for the database. You should see that a database named "wordpress" (or the name that you entered) is created.
Now, add a database user. If a database is created, users called “dba” and “public” are automatically created. However, it is not recommended to use them in your application due to security reasons. It is always best to create separate users for each database. In order to created the user, right click on [Users] and select [Create User] as shown below.
Type a user name and password, then click [OK]. Remember the user name and the password you provided. You will need them when installing WordPress.
If you succeed, you should see a user called “wpuser” (or the name you entere) under [User] branch. This will finish the database configuration. We will now proceed to Wordpress installation.
When you download Wordpress you will have a zipped file. You have to unzip it to the location where your Web Server files are located. This may be somewhere like under "localhost" directory or "httpdocs", or something else, you should know. Once you unzipped the Wordpress file you downloaded, navigate your browser to that location like "http://yourdomain.com/wordpress" or "http://127.0.0.1/wordpress". You should see the following page. Click [Create a Configuration File] to start the installation process.
Then you will see the page below, which will list the items you need to know to create a configuration file. Click [Let's go!] to proceed.
In the new page type the database name you created before into the [Database Name] field. Then type the user name and password you created before into the [User Name] and [Password] fields. For the rest fields, generally, you can use the default values. After providing all the information, click [Submit].
If the message shown below appears, it means you typed the database information correctly. If a different message appears, check whether you correctly entered the database name, user name and password. If everything is fine, click [Run the install].
You will be prompted to type your new blog title in [Blog Title] and your e-mail address in [Your E-mail]. If you want your blog to be listed in the searching engine results such as Google, Yahoo, Naver or Daum, select the corresponding check box and click [Install WordPress] button.
When the the WordPress installation is complete, you should see the page displayed below. The characters beside [Password] is a password temporarily created by WordPress. Save it somewhere. You will need it to log in to the administrative panel in the next page. Click [Log In].
Type "admin" in [Username] and the characters displayed in the previous page in [Password]. And click [Log In].
Now, the WordPress installation is complete. You can change the temporary password by clicking [Yes, Take me to my profile page] in the red box as shown below.
If all the steps are completed successfully, you will be able to see your blogging site up and running as shown below.
For more information about WordPress features, visit http://wordpress.org.
FACT: Wordpress.org often releases new versions of their open source blogging system Wordpress. So, sometimes you might notice Wordpress 2.x.x update is available! You are highly recommended to update your system. message on the top of your Wordpress dashboard (administration panel) page right below the header cap. Since you are using Wordpress ported to CUBRID, those kind of update notifications refer to Updates for Wordpress running with CUBRID.
CHANGES: The open source community at NAVER Development Center which ported Wordpress for CUBRID, has altered the logic of updating the Wordpress. That is they changed the code so that your system does not check Wordpress.org servers whether a new version is available. Instead Wordpress for CUBRID refers to Wordpress Project Site at NAVER Development Center for new releases. That means that if you see an update notification, it does not necessarily mean that original Wordpress.org has been updated, albeit it might mean so, but might not. What it definitely means is that Wordpress for CUBRID has a new version released, so you are recommended to update. Likewise, you might not receive any update notifications even if Wordpress.org released new versions, because it might take some time to make changes in Wordpress for CUBRID. But be sure that soon you will get your updates.
WHY: Why has Wordpress for CUBRID community decided to change the update logic? Because if they did not, you would try to accept Wordpress.org updates which were dedicated to MySQL users. In this case your system might crash, literally, because CUBRID and MySQL are different database servers with different syntax and functions. The code for one cannot be adopted by another.