Gallery

You SLA me!

Posted on 28 Apr 2009 at 11:02

Jon Honeyball wonders where in the world his data is stored, and David Moss continues his mission to get a course management system up and running.

IIS_USERS

IUSR

Network service

Click on OK once these permissions have been assigned. Again, if you haven't already done this, go to the PHP folder, open the php.ini file, locate the following entry and add the path to the Sessions folder (mine looks like this, but yours may well differ):

session.save_path="C:PHPSessions"

While you're in the php.ini file, make sure the following entries are uncommented:

extension=php_gd2.dll

extension=php_mbstring.dll

extension=php_mysql.dll

With that done return to IIS Manager, click on Default Web Site and double-click on Default Document in the centre pane. Click on Add... in the right-hand pane and type index.php into the edit box, then click on . The new default document type will appear at the top of the list, so you might want to move this down to change its priority. Next, head to your phpMyAdmin folder and look for a file named config.sample.inc.php. Look for the following entry:

$cfg['blowfish_secret'] = ' '; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

Add a value between the single quotes, which can be whatever you choose, for example:

$cfg['blowfish_secret'] = 'pcpro1234';

Next, look for this entry:

/* Select mysqli if your server has it */

$cfg['Servers'][$i]['extension'] = 'mysql';

Your server does have it, so change it as follows:

$cfg['Servers'][$i]['extension'] = 'mysqli';

Next you have to consider logon, so look for the following entry:

/* User for advanced features */

// $cfg['Servers'][$i]['controluser] = 'pma;

// $cfg['Servers'][$i]['controlpass] = 'pmapass;

Get rid of those two forward slashes // in front of each line and change "pmapass" to something else, and you should end up with something that looks like this:

$cfg['Servers'][$i]['controluser] = 'pma';

$cfg['Servers'][$i]['controlpass] = 'pcpro5678pass';

Now look for this entry:

/* Advanced phpMyAdmin features */

Below this heading you'll see a set of entries, each like the controluser and controlpass entries preceded by two forward slashes //, thus:

// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

// $cfg['Servers'][$i]['bookmarktable] = 'pma_bookmark';

// $cfg['Servers'][$i]['relation] = 'pma_relation';

...

There are nine of these entries in total, the last one being "pma_designer_coords". Once again, you'll need to remove the forward slashes from each line to uncomment them. Once you've done all this, save the file as config.inc.php. Fire up a browser, and enter the URL http://localhost/phpmyadmin/.

If all has gone well you should now see the phpMyAdmin welcome screen. Type in your MySQL username and password and click on Go. Now you should be in phpMyAdmin and can begin to work on building your new MySQL schema. See you next month in the July issue, and have fun experimenting in the meantime.

David Moss