[cups] accounting to mysql database?

[hw]

Pförtsch, Franz schrieb:
> Hello Allan,
>
> did you take a look at PyKota, at http://www.pykota.com/software/ ?
> I did not use it, but it is known to be very powerfull

Yes, and I decided it´s easier to write something myself to put the
information into the database so we can make use of it.

Basically, I only need to know how many pages have been printed for
most of the printers.  They are label printers, and by knowing how
many labels each of them has printed since the refill, we will be
able to get notifications and status information that tells us which
printer needs attention when, and in advance.  I doubt that a standard
accounting system does this, and it´s likely made for very different
purposes.

> I have done my "accounting" via printanalyzer.pl or phpprintanalyzer.php.
> Nowerday I have a python script which pushest the pagelog into a mysql-database

Having to poll the page_log is exactly what bothers me.  Now I
even found that the log is being rotated, and I don´t know what
does the rotation.  That makes it difficult, if not impossible,
to ensure that all log entries are transferred into the database.

Why can´t cups simply put the information it puts into the log file
directly into a database.