Hi Julian, sincerely thanks for appreciating the software! Unluckly the answer is negative, pmacct doesn't support SQLite 2 as support for SQLite is fairly recent and at the time version 3 was already out, working fine and stable.
The idea of building SQL INSERTs gathering data from the memory table (ie. the pmacct client) is valid but i'm not aware of any publicly available scripts around. Don't know whether other readers of the list might help. PNRG software uses Perl and does pretty much the same but exporting data from the memory table into some RRD files. Mantaining the same underlying logics and replacing the RRD-related functions with the Perl SQlite bindings, DBD::SQLite, should make the job. Roughly it should be Matter of building the SQL queries, filling them with the variables and generating the timestamps. Cheers, Paolo On Thu, Oct 04, 2007 at 03:53:31PM +0100, Julian Somers wrote: > Hi, > > I've been using pmacct with rrd for some time with great success. > Thanks for a fantastic app. > > I now want to store historical data in an sqlite db. The sqlite3 > plugin would work perfectly for me; unfortunately I am stuck with > sqlite2 for the time being on this device. > > My question is: has anyone used pmacct with sqlite2? Is there an old > plugin? Perhaps someone could point me to a script that pulls data > from pmacct client and stores it in the database? > > many thanks, > > Julian _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
