Hi,

Neccesary software:
Hylafax v4.1.5

Without this version the format the script can not produce normal logging.

Explanation of the software:

What you find in this directory can be used to create a SQL log from the
logging which hylafax sends to syslog and it has a front end which can be
used to view it as well.

The status_faxen script can be inserted as a cron job for every 10 minutes 
or so to update the database with the most recent data and if the fax was 
sent or not. See the crontab file that goes with it in the scripts/ directory.

The fax_status.sql is a SQL template that you can insert into a database 
to create a table for the logging.
The fax_recipients.sql is a SQL template that you can insert into a database 
to create a table for the recipients administration. This is used by the 
front-end.

You can import it into mysql like this:
mysql -u user -p database < fax_status.sql
mysql -u user -p database < fax_recipients.sql

The config file contains all the relevant data and variables used 
throughout the script. That is including the database password and user.

Short description of the status codes and fields:

status=0, Fax is submitted into the queue, see sub_time and sub_date field.
status=1, Fax is sent, see tx_time and tx_date field.
status=2, Fax is not sent, error is in err_code field
status=3, Fax was removed from queue, see tx_time and tx_date field.

active, field is used for internal program.
recipient, field is used for internal program or if you have a 
phone/recipient matching database.
err_code, describes the error if there was one. It is cleared if it _is_ 
sent succesfully on a later attempt.
fax_id, contains the hylafax job_id.

Note that you need the month.sed script since the status_faxen script 
relies on this.

The FrontEnd:

It's a PHP script that logs into the database and check the sent status of 
the faxes. This is mostly succesful if you are in a send only environment 
and need to track what was sent when and at what time.

There also is a file output module burried deep within the 
includes/recipient_functions.php script. This function enables you to 
write the recipients from the database into a text file
for easy usage by external scripts.

Good luck using it!
Seth