Linux-Tip.net - Keep your knowledge with OWL!

Home

Workshops

Server

Keep your knowledge with OWL!

Sunday, 25 September 2005

Article Index
Keep your knowledge with OWL!
"Step 1: Suse 9.3 Installation"
"Step 2: Webmin installation and configuration" toc="1"
"Step 3: Apache2 configuration"
"InstallingOWL" toc="1"
"Step 5: MySQL configuration and OWL database installation" toc="1"
"Installing and configuring anti-virus software ClamAV" toc="1"
"Step 7: Get OWL ready to work" toc="1"
"Troubleshooting and additional help" toc="1"

Page 6 of 9

Step 5: MySQL configuration and OWL database installation

The MySQL database has become the world's most popular open source database because of its consistent fast performance, high reliability and ease of use.

You have already found the “MySQL Databas Server icon”. After clicking on it, you will probably get the following error message:

MySQL is not running on your system - database list could not be retrieved.

Please start the MySQLServer. Now you should see the two default databases installed (mysql and test) and the “Global Options”.

It is time to create the new owl database. Click on the MySQL databases area to “Create a new database” and add the database name owl. Next click on the “Create” button. You’ll find the new created empty database called owl in the overview like the picture bellow:

To create tables we will use the script mysql-tables.sql located in the directory /srv/www/htdocs/intranet/DOCS/sql .

Please click on the owl database icon to edit the database. Now use the “Execute SQL” button and add the file name in the “Select an SQL command … From local tile to execute” area. Please search for the following file on the local file system:

/srv/www/htdocs/intranet/DOCS/sql/mysql-tables.sql

After successfully executing the command, you should get the following message:

Output from SQL commands in file /srv/www/htdocs/intranet/DOCS/sql/mysql-tables.sql ..
No output generated

This means everything is correct. You should now be able to see the new 23 tables in the database area after clicking on the owl database icon.

Next we have to create a database user and to add the necessary permissions. Please click on “Global Options” -“User Permissions” - “Create a new user”…

… and the following information:

After saving the new user you should double check the information in the user table and note the password you have used. Please use this password in the in “Step 3” mentioned configuration file owl.php. (in our example “mypassword”).

To make sure that everything works fine restart the MySQL Server using the “Stop” and the “Start” buttons.

Please use your favorite browser and access the login page like this:

http://localhost/intranet or http://yourIP/intranet