Please remember that this is a work in progress. Your comments and suggestions are appreciated. Click here to send your comments to me, the developer.
If you find this module useful, I'd greatly appreciate a postcard (or cookies:) ) from you letting me know you're out there. My address is included in the LICENSE file in the distribution.
More documentation will be arriving as I get the time. Please be patient, as I'm kept rather busy by my schoolwork!
- Roxen 1.2 final or higher.
- mysql or other SQL database supported by pike.
- Download the latest version of logSQL with Documentation (v0.9)
Use this form to send me feedback or to request update notices.
Using logSQL is pretty easy. Just download the archive, then unpack it by using the following command:
tar -zxvf logsql-x.x.tar.gz (where x.x is the version of logSQL)You should get a directory called logsql-x.x. Inside that directory is a file called log_sql.pike. Copy that file to your Roxen modules directory, under roxen/server/modules. Then you can use the Configuration Interface to add the logSQL module.
You'll need to create a table for logSQL to insert the data into. You can use an existing database, or create a new one with the command:
mysqladmin create roxenwhere roxen is the name of the database. Then, use the access_log.mysql script to create the log table. Use the command:
mysql roxen < access_log.mysqlIf everything goes smoothly, you should have a new table, access_log. in the roxen database.
There are a few options you can change, but in most cases it won't be nessecary. If your database server is running on the same machine, specify 'localhost' as your server host for faster performance.
That's all there is to it! logSQL will automatically connect to your SQL server to insert access records.
Once you've set logSQL up, the module will maintain a connection to the specified database, and will attempt as best it can to reconnect if the link goes down. If the server goes down for an extended period of time, an entry will be made in the debug log every few minutes (specifiable in the config interface).
The most current information may be found in the README file in the distribution.
- mySQL
- This is a great little database engine. A home page is available at http://www.tcx.se.
- Pike
- The language that Roxen and this module are written in. Information on database support in pike is available at the Pike homepage, http://pike.idonex.se.
- Other Roxen Modules
- A page of other Roxen Modules that I've written. The page is http://www.riverweb.com/modules.
hww3@riverweb.com