Depts

Went in to debug some things on the VPN site and noticed that the home page was taking forever to load (and in fact I think I ended up getting some cached version of the page).

Web server serving static pages no problem
phpmyadmin communicating with db no problem
Therefore problem has to be something to do with the wordpress code trying to establish a connection with the db.
Created a test.php file which does nothing other than try to connect to the DB. If it tries to connect to any DB running on the hcmc's mysql server, it times out and generates an error. If it tries to connect to a DB running on uvic's mysql server, it's fine. So, there's definitely a problem with any page on web.uvic.ca trying to connect to a db on the hcmc server. Put in request to sysadmins to check the Access Control List on the hcmc db server.

Noticed yesterday that when you're returned from the beanstream shopping cart to the page on the uvic server, you of course get the default version of the page (i.e. no form has been selected), and the only way to get back to the shopping cart page again is to buy another item (and then delete that item on the beanstream page). So, decided to implement a php page. The URL back from the beanstream shopping cart includes a bunch of key value pairs in the GET array, so I can test for those and figure out which form to display (I pass in a value using the ref1 variable which is intended for this kind of thing) and also to display a "return to shopping cart button" with appropriate URL. Also tidied up and commented the php code and the static html page.