Linksys Activity Logger / News: Recent posts

Does anybody have any feedback? I see that people are downloading LAL, but I've not heard from anybody.......Feedback would be appreciated so that I know if this project is of use to anyone.

Version 0.5 of the lal_web module now works correctly for graphing if you are using MySQL. Differences between the syntax of the two databases have been worked out.

I've just discovered that the graphing queries only work under Oracle. I need to do some research on MySQL's built-ins to see if it has corresponding functions. For the time being, they graphing capability is ONLY supported if you are using an Oracle database. Sorry for the temporary inconvenience.

LAL Web now includes a graphing capability. Simply select from a pop-up list the desired graph and it will be genereated and displayed automatically in your web browser. This was previously only available by getting the CVS version, now it is publically available. Requires JpGraph in order to generate the graphs.

I have added the graphing capability to the CVS version. It supports three pre-defined graphs. This will be expanded as time permits. It will not be released as a publicly downloadable module until more is added to it and I'm sure it's working properly. NOTE: jpgraph is required now (on top of the original ADODB). See the lalinclude.php file for where to obtain it (or do a search on yahoo for jpgraph).

This release removes the need for the 'register_globals' to be set in the php.ini file. It also fixes a few minor bugs and has been tested under both Linux and Solaris using both MySQL and Oracle. Everything appears to be working. Next step is to possibly extend the query capability to make it more flexible and/or add some type of graphing capability.

PHP front end has now been extended to include a custom query capability. It allows you to select which fields to include in the output, custom search criteria, and how you want the records ordered.

Two items of interest:

1. I've tested the web interface against a MySQL database. I had it up and running in less than 2 minutes (I already had Apache, PHP and ADODB installed before). It worked perfectly - no problems!

2. Thanks to a single line of code submitted by a user, the logger now works with MacOS X! Cool!

A partially implemented version of the PHP front end has been released. It has been tested using Oracle, and in _theory_ should work with MySQL (will be tested later). Not all features are implemented yet, and not all features have been fleshed out yet. Just wanted to show some forward movement.

Sorry everyone - with @Home going under I forgot to change my email address. It is now corrected and I will receive your messages, sorry for the problem.

PR

The initial version of the PHP front-end to the database has been started and checked into CVS. It's curretly working under Solaris/Apache/Oracle (at least what's implemented). In theory it should work with mySQL as well - if the appropriate settings are made in the config file.

Additional functionality needs to be added as well as documentation (installation/usage). User feedback for features will be needed in order to improve the interface. I'm currently designing building it to suit my own purposes and adding what I think will be usefull.

There's been a new release today. This release supports Oracle 9i and removes a debugging message that was left in by mistake in the last release. Everything appears to be running stable and bug free so far. Now that all originally described features have been added this may soon become version 1.0.

Work on the PHP front end for use in Apache will be started soon.