Troubleshooting
Note: This page is an extension of the CodeIgniter User Guide page of the same name. Please read the CodeIgniter Troubleshooting page in addition to this page for complete information.
Setting Up Your Web Server for PHP
To use this system, your web server needs to be set up to interpret PHP code for all the pages using the system. Assuming that the PHP interpreter is installed in your server, it is probably configured to interpret files with a .php expension. If you are starting with a static site where the filenames end in .html, your web server will probably not interpret them correctly.
For the Apache server, you have to modify the following directive in the httpd.conf file, perhaps within your site's virtual server directive. If you don't have access to the httpd.conf file on your server, you can adding this same line to your .htaccess file:
AddType application/x-httpd-php .php .html
Adding '.html' to this directive tells the server to treat files with an .html extension as PHP files.
For servers other than Apache, there are similar directives. Please see the server documentation for details.
Configuring MySQL Users
Version 4.x of MySQL saves passwords using a different hashing algorithm than earlier versions. Unfortunately, the MySQL module in PHP 4.x cannot read the new passwords, so they must be converted to the old algorithm when you create new users in MySQL.
To create a user that has access to the coolbrew database you can use the following commands. You will want to change 'cb_password' to your real password:
% mysql -u root -p
mysql> grant all on coolbrew.* to brewuser@'localhost' identified by 'cb_password';
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('cb_password') WHERE host = 'localhost' AND User = 'brewuser';
mysql> FLUSH PRIVILEGES;