Sriram Natarajan's Weblog
Famous 5 minute installation of Wordpress with OpenSolaris 2008.05
So, if I had to setup a blogging web site, where would I go other than the favorite - WordPress. I followed their famous 5 minute installation steps within OpenSolaris 2008.05 and here we go.
* OpenSolaris 2008.05 is a LiveCD based distribution . So, if you need a AMP stack, you can get this on demand by running the following command
[sriramn@sriram-laptop]: pfexec pkg install amp
* Now, you can initialize and configure Apache and MySQL service by doing something like
[sriramn@sriram-laptop]: pfexec /usr/sbin/svccfg import /var/svc/manifest/application/database/mysql.xml
[sriramn@sriram-laptop]: pfexec /usr/sbin/svccfg import /var/svc/manifest/network/http-apache22.xml
[sriramn@sriram-laptop]: pfexec /usr/sbin/svcadm enable network/http:apache22
[sriramn@sriram-laptop]: pfexec /usr/sbin/svcadm enable database/mysql:version_50
* Now, let us configure a Wordpress database within MySQL database. So, let us do something like
[sriramn@sriram-laptop]: pfexec /usr/mysql/bin/mysql -u root
here is a sample output that you would expect to see...
[sriramn@sriram-laptop]: pfexec /usr/mysql/bin/mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.45 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Now , let us create a new database and assign a user to this.
mysql> create database wordpress;
mysql> select database wordpress;
mysql> grant all privileges on wordpress.* to wp@localhost identified by 'wp';
mysql> flush privileges;
mysql> quit;
* At this point, we have created a new database 'wordpress' with a user 'wp' and with password 'wp' assigned to manage this database. Well, not a whole lot secure but a good starting point though.
* Now, you can download WordPress 2.5.1 from here unpack it to /var/apache2/2.2/htdocs - default apache document root directory.
* Now, copy /var/apache2/2.2/htdocs/wordpress/wp-config-sample.php to /var/apache2/2.2/htdocs/wodpresswp-config.php and edit the first four lines of the file to reflect the just now configured database name , user name and password.
[sriramn@sriram-laptop]: cd /tmp
[sriramn@sriram-laptop]: wget http://wordpress.org/latest.zip
[sriramn@sriram-laptop]: cd /var/apache2/2.2/htdocs/w
[sriramn@sriram-laptop]: pfexec unzip /tmp/wordpress-2.5.1.zip
[sriramn@sriram-laptop]: pfexec cp wordpress/wp-config-sample.php wordpress/wp-config.php
pfexec vi wordpress/wp-config.php and edit this file - first four lines and provide your database name, user name and password . In my case, wordpress/wp-config.php file looks something like
<?php
// ** MySQL settings ** //
define('DB_NAME', 'wordpress'); // The name of the database
define('DB_USER', 'wp'); // Your MySQL username
define('DB_PASSWORD', 'wp'); // ...and password
define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
* That's it . you are now ready to host your blog site . You should be able to reach your blog site by accessing http://localhost/wordpress
Simple, huh . Ah , one last thing - If you would like to take this site into production, you might want to enable to APC cache - which is integrated within OpenSolaris Web(AMP) Stack but not enabled as default. You could do this by editing /etc/php5/5.2.4/conf.d/apc.ini and for more APC related settings , please refer here.
Note: Once you enable APC, please remember to restart Apache service for this change to take into effect
[sriramn@sriram-laptop]: pfexec /usr/sbin/svcadm restart network/http:apache22
Hope, you find this useful. Feel free to ping me back if you have any suggestions or issues. Alternatively, you could visit OpenSolaris forum
Posted at 02:01PM May 05, 2008 by natarajan in Web Stack | Comments[1]
Monday May 05, 2008

error in create mysql database :
select database wordpress;
should be :
use wordpress ;
willy (w2)
Posted by w2 on May 11, 2008 at 01:10 AM PDT #