mnwclient + SQL --------------- Requirements: ------------- mnwclient 1.10.0.4+ postgresql 7.0.3+ (mysql, msql, and oracle have hooks added in, but are untested at the moment) Perl 5.00503 or later DBI 1.09+ DBD::Pg 1.01+ (You will need the DBD specific to your SQL implementation) SQL database named 'fw' SQL table named 'events' Tables: ------- Refer to the database creation scripts included in the contrib directory, which is called 'create_database.sql', the schema has changed slightly since 1.10, but if you are not using the latest fwevents package then there is no need to change the schema. Perl + DBI + DBD: ----------------- You are likely already using Perl 5.00503, I am only saying that revision or later is a requirement because those are the only revisions I personally have encountered. I am also currently using DBI 1.19 and DBD::Pg 1.01 on my machine with Perl 5.00503. Note that the only tested platform is currently pgSQL 7.0.3 and 7.1.2, both under Perl 5.00503 and Perl 5.6.0. I believe that the other SQL engines should work fine since they are for the most part all implemented the same via DBI. Activiating SQL in mnwclient: ----------------------------- You may activate the SQL insertion code once the tables and users have been setup. For expert users you may wish to specify your own database name, database login, and database password. You need to add the following to your 'mnwclient.rc' configuration file, usesql pgsql Now for more advanced users, who want to specify their own database name, login, and passwords you can do the following, usesql pgsql dbname dblogin dbpass Here is the command structure for usesql, usesql [ ]