Re: [hylafax-users] MySQL

["Michael T. Babcock" <mbabcock@fibrespeed.net>]

Thomas Jalsovsky wrote:

>      I would like to know that is there any logging possibility into
>MySQL (maybe another SQL), maybe authorization module working with
>SQL.
>  
>

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.
http://www.fibrespeed.net/~mbabcock



____________________ HylaFAX(tm) Users Mailing List _______________________
  To subscribe/unsubscribe, click http://lists.hylafax.org/cgi-bin/lsg2.cgi
 On UNIX: mail -s unsubscribe hylafax-users-request@hylafax.org < /dev/null
  *To learn about commercial HylaFAX(tm) support, mail sales@hylafax.org.*