Archive for the 'Systems' Category

Zen Cart, MySQL, phpMyAdmin, Apache

I’m currently working on some E-commerce stuff. I’ve been learning quite a bit about Zen Cart, MySQL, phpMyAdmin, Apache.

Spent a couple of hours today upgrading from MySQL 5.0 to MySQL 5.1

It went ok.

While trying to find some quick and easy ways to import data into Zen Cart I’ve ended up looking into phpMyAdmin.

Also MySQL 5.1 seems to support CSV as a storage engine. See this post: http://dev.mysql.com/tech-resources/articles/csv-storage-engine.html

All good stuff – I’m probably going to need to refer back to that sometime hence the post – time to sleep now.



Open BSD

I don’t often seem to find the time to play around with some of the various UNIX variants out there. Anyway when a customers VPN network appliance died on me today I went to investigate.

It was supplied by a company who are no longer in business so I was pretty much on my own.

After attaching a monitor and keyboard and watching it boot I discovered it was booting OpenBSD 3.8

I didn’t know the root password and this appliance had lost all tcp/ip connectivity. So I googled and found http://www.cyberciti.biz/tips/reset-forgotten-openbsd-root-password.html

This post worked like a charm for me and I had reset the root password within a few minutes.

No time to find out why this appliance cannot communicate over tcp/ip currently.



WDS

Been configuring Netgear wireless routers with WDS settings to extend the range of the wireless signal in a home network environment. All worked great though I was using two DG834G routers and they need to be v3 or higher.



DOCTYPE craziness with IE8

I use xhtml docs to store content for my site – it’s a custom built cms written in php.

So, my content files all use a template that looks like this:

<?xml version=”1.0″ encoding=”UTF-8″ ?>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.manick.co.uk/TR/xhtml1/DTD/xhtml1-transitional.dtd“>

<html xmlns=”http://www.w3.org/1999/xhtml” xml:lang=”en” lang=”en”>

<head>
</head>

<body>
</body>

</html>

Anyway, I’ve noticed that IE8 fails to show these files, though FF has no issue. Very annoying. It would show an error like this:

The XML page cannot be displayed

Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.


System error: -2146697204. Error processing resource ‘http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd’.

 

 

Anyway I finally decided to research the problem and find out what is wrong…

I found a very relevant blog post about DTDs here:

http://www.w3.org/blog/systeam/2008/02/08/w3c_s_excessive_dtd_traffic

It seems that w3 suffer from excessive traffic when these DTD documents are repetitively called for over the Internet resulting in a kind of DOS attack.

There seems to be a great deal of ongoing debate regarding this issue – as I was looking for a quick fix I decided to host the relevant DTDs on my own server.

I was happy to do this as these XHTML files are not served directly to web browsers but are processed by PHP on my webserver.

The resulting document that is returned to the webrowser can continue to list the www.w3.org DTD document.

I’m guessing that IE8 shouldn’t be attempting to load these documents from w3.org when I try to view my xml files that contain the xhtml.

Also it appears that the w3.org have now gone so far as to block browsers requesting the DTD based on the User-Agent string of the HTTP request.

I gleaned this info from: http://www.outofcontrol.ca/2009/02/20/w3org-dtdxhtml1-strictdtd-blocks-windows-ie-users/

It seems odd to me that we are still struggling with this and it’s now nearly 2010.



PHPExcel

Decided to find out if there were any free libraries that would allow you to create Excel files from scratch. Idea being that you can call this from PHP and create a spreadsheet from a website. Not a new idea but anyway. Found PHPExcel v1.7.0 and got it installed and running very quickly. Great piece of work. I will likely use it at some point in some project or other. Oh, it writes Excel 2007 format too.



Process Affinity

I just experienced something new – multi threading on a 2 cpu system causing an issue with an application using a serial modem on COM1.

The application threw an error along the lines of ‘noise on line’ which I didn’t quite believe and when I spoke to the software support for this app the solution was to set the process affinity to just one of the two processors in Task Manager.

A more permanent solution is to use affinity.exe which will set the process affinity as it’s launched I think – I never bothered to find out as I just moved the app to a single processor machine.

Interesting though.




You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.