This is an old revision of the document!
Note: The information presented on this page does not apply to POPFile users on the Windows platform who installed POPFile using the installer package. The installer sees to it that the version of SQLite included with POPFile is compatible with POPFile and installs the needed libraries in such a manner that they will not impact any other software on your system.
DBD::SQLite 0.31 and before needs to be installed without modification (unless you tried a v1.X and have a Sqlite3 db which must be converted back).
DBD::SQLite 0.32 - 0.33 needs to be installed with modification: Change Bayes_dbconnect from: dbi:SQLite:dbname=$dbname… to: dbi:SQLite2:dbname=$dbname…in the config file). (also if you tried a v1.X and have a Sqlite3 db which must be converted).
DBD::SQLite 1.x Does not work without modification of popfile (yet). It can coexist with popfile (if needed for another application) by changing popfile to DBD::SQLite2 0.33 (see above)…and allowing the other application to run with a sqlite 1.x driver.
During July 2004 SQLite Version 3 was released. This version has significant changes from SQLite Version 2 including changes to the database file format, which breaks compatibility between the two versions.
A new version of the Perl interface module to SQLite, DBD::SQLite was also released during July. Unfortunately, the release has caused some confusion due to the naming and numbering schemes that were used.
To check on the version of DBD::SQLite installed on your machine, use the following Perl one-liner.
perl -MDBD::SQLite -e 'print $DBD::SQLite::VERSION'
With the break in database file compatibility and version confusion, we expect that users of SQLite will start seeing issues, particularly those who have installed Perl packages that use SQLite.
Until the POPFile developers resolve the incompatibility issues with SQLite3, we do not recommend any POPFile users use SQLite 3 for POPFile.
If you must upgrade your Perl SQLite to version 3 due to other applications on your machine, we recommend you install DBD::SQLite2 and make the following change to your database connection string on the advanced page of the UI (or in popfile.cfg).
Change bayes_dbconnect from:
dbi:SQLite:dbname=$dbname
to:
dbi:SQLite2:dbname=$dbname
Note that POPFile must be shutdown and restarted for the change to go into effect.
Once the dust settles and the POPFile developers have had the opportunity to fully test SQLite 3 with POPFile, we will make an orderly transition to the newer version and take care of converting your POPFile database at that time.
Should you find anything in the documentation that is incomplete, unclear, outdated or just plain wrong, please let us know and leave a note in the Documentation Forum.