HylaFAX The world's
most advanced open source fax server
Re: [hylafax-users] MySQL
Thomas Jalsovsky wrote:
> I would like to know that is there any logging possibility into
>MySQL (maybe another SQL), maybe authorization module working with
A perl script that works as `tail --follow=name --retry
$hylafaxpath/etc/xferfaxlog | hylasql.pl` is pretty easy to write if
that's what you want.
xferfaxlog has most of the details about incoming and outgoing faxes and
splitting it with PERL is quite simple. Using the DBI to insert it all
into a well-schema'd database shouldn't be too difficult.
I'd offer you a pre-made solution, but its a lot more complicated than
the above and unfortunately a work-for-hire. The basic description
though is that it works off the faxrecvd script to punch data into a
series of SQL tables. It uses the 'c*' numbered log (from faxrecvd) to
read out additional statistics and/or errors into the tables and then
logs E-mailing or printing attempts against the original table entries
by modifying the accounting processes for LPRng.
Its only about 200 lines of code in PERL and I'm rewriting it in Python
slowly under the GPL from scratch. Don't hold your breath though ...
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
____________________ HylaFAX(tm) Users Mailing List _______________________
To subscribe/unsubscribe, click http://lists.hylafax.org/cgi-bin/lsg2.cgi
On UNIX: mail -s unsubscribe email@example.com < /dev/null
*To learn about commercial HylaFAX(tm) support, mail firstname.lastname@example.org.*