RE: That was the weekend that was!

["Mark Harrison" <Mark.Harrison@xxxxxxx>]

When I get a website to put it on...

Also, at the moment, it's got the IP address of the server, the database
name, and the username/password used to get at the database hardcoded. I
guess some "config" code would be useful before release ;-)

And also, also, needs a bit of work done to the HV scedule to make it
useful... I'll post the lot in the next week or so if I get time ;-)

Mark Harrison
Head of Systems, eKingfisher

************************************************************************
****
Kingfisher plc
Registered Office: North West House, 119 Marylebone Road, London NW1 5PX
Registered in England, Number 1664812

This e-mail is only intended for the person(s) to whom it is addressed
and
may contain confidential information.  Unless stated to the contrary,
any
opinions or comments are personal to the writer and do not represent the
official view of the company.  If you have received this e-mail in
error,
please notify us immediately by reply e-mail and then delete this
message
>from
disclose its contents to any other person.  Thank you for your
co-operation.
************************************************************************
****



-----Original Message-----
From: Chris Bond [mailto:chris@xxxxxxx]
Sent: 4 March 2002 10:11
To: ukha_d@xxxxxxx
Subject: Re: [ukha_d] That was the weekend that was!


So when do we get the vb app then ... :)
----- Original Message -----
From: "Mark Harrison" <Mark.Harrison@xxxxxxx>
To: <ukha_d@xxxxxxx>
Sent: Monday, March 04, 2002 10:07 AM
Subject: [ukha_d] That was the weekend that was!


> Inspired by the "house of HA statistics", Mary and I had a
> programming/installing "overnighter" on friday night, with
the
following
> acheived:
>
> 1: On the server, creation of a mySql database to store HA logs.
> Software used: MySql (already installed)
>
> 2: Creation of a standalone VB app that listened to HomeVision on the
> serial port, and then wrote events into the MySql database.
> Software used: VB, the MySql OLEDB native driver (which worked first
> time on download), MSCOMM (Microsoft serial port driver)
>
> 3: Modification of the HV schedule to output in a predefined format,
the
> serial data that the VB app was expecting.
> Software used: The HV schedule editor
>
>
> Then, on Saturday, while Mary was asleep...
>
> 1: Installation of the latest Apache onto the server
>
> 2: Installation of the mySQL-recommended PERL with the database
> extensions
>
> 3: A Perl script that wandered off to the my-SQL database, came up
with
> the events, and did some basic processing on them, and returned the
> responses in an XHTML page!
>
> 4: A basic XHTML1.0 website to hang the Perl bits off :-)
>
>
> Next steps 1: Add a rather more sophisticated structure to the lookup
> table that converts CODES to events, putting in separate fields for
> room, device, action, and cause (directly triggered by Pronto, macro,
> etc.)
>
> Next steps 2: Put in an "amber" zone on the firewall, and
move the web
> server out to there, while keeping the database server in green.
> Two-tier web application in multiple zones.
>
> Funky, heh?
>
> Mark
>
>
> For more information: http://www.automatedhome.co.uk
> Post message: ukha_d@xxxxxxx
> Subscribe:  ukha_d-subscribe@xxxxxxx
> Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
> List owner:  ukha_d-owner@xxxxxxx
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
>




For more information: http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx
Subscribe:  ukha_d-subscribe@xxxxxxx
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
List owner:  ukha_d-owner@xxxxxxx

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/



________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________