root / pykota / trunk / NEWS @ 1559

Revision 1558, 39.9 kB (checked in by jalet, 20 years ago)

Added first draft of MySQL initialization script

  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
Line 
1# $Id$
2
3PyKota - Print Quota for CUPS
4
5(c) 2003-2004 Jerome Alet <alet@librelogiciel.com>
6This program is free software; you can redistribute it and/or modify
7it under the terms of the GNU General Public License as published by
8the Free Software Foundation; either version 2 of the License, or
9(at your option) any later version.
10
11This program is distributed in the hope that it will be useful,
12but WITHOUT ANY WARRANTY; without even the implied warranty of
13MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
14GNU General Public License for more details.
15
16You should have received a copy of the GNU General Public License
17along with this program; if not, write to the Free Software
18Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
19
20============================================================
21
22PyKota NEWS :
23
24    - 1.19alpha25 :
25   
26        - Added new "description" field to printers in both
27          PostgreSQL and LDAP. No code to handle this yet.
28         
29        - Reversed the fix for power save mode in printers : 
30          no paper or tray open would have caused people to
31          be undercharged.
32         
33        - Preliminary version of MySQL initialization script.
34         
35    - 1.19alpha24 :
36   
37        - Native PDF parsing code now works perfectly with
38          Python 2.1 and above, and is way faster than before.
39          GhostScript is not used anymore to convert PDF to PS,
40          because PDF is parsed directly.
41         
42    - 1.19alpha23 :
43   
44        - Fixed waitprinter.sh wrt PowerSave mode and some
45          printers. Thanks to Ryan Suarez.
46       
47        - Smart PDL analyzer now recognizes PDF too : two
48          PDF parsing methods are used : a native one which
49          is very fast but requires Python 2.3 or above, and
50          a slower one which uses Ghostscript. PyKota detects
51          automatically which method to use depending on your
52          version of Python.
53       
54        - All tracebacks now include PyKota's version number.
55         
56    - 1.19alpha22 :
57   
58        - Ensures that the file pointer for job's data is
59          reset to the start of the job's datas after the
60          job's size pre-computation phase.
61         
62        - Improved PostScript detection code for bad drivers
63          which don't correctly switch languages between PJL
64          and PS.
65       
66        - Even better debugging code.
67       
68    - 1.19alpha21 :
69   
70        - Additionnal check.
71       
72    - 1.19alpha20 :
73   
74        - More complete logging messages wrt accounters.
75       
76        - Now catches early failures occuring when the configuration
77          files are parsed.
78       
79    - 1.19alpha19 :
80   
81        - Fixed over-verbose exits when displaying help
82          or version.
83         
84        - Extended some PATH in the shell scripts 
85       
86        - Deleting an user now also deletes his payments history.
87       
88        - Doesn't explicitely ignore SIGCHLD anymore. This seems to
89          cause problems.
90
91    - 1.19alpha18 :
92   
93        - History of payments is now stored in the database, and
94          updated each time an user's balance is modified with
95          edpykota --balance. This history represents each time
96          the user was given some positive or negative credit,
97          but doesn't reflect price paid for jobs, which appear
98          in the jobs history instead.
99         
100        - Jobs history web reports now include the job's size in
101          bytes. Also columns were reordered to render the report
102          more easily readable.
103         
104    - 1.19alpha17 :
105   
106        - Mysterious bug (program exited unexpectedly without leaving
107          any log message) which occured once in a while when
108          cancelling jobs should be fixed now.
109         
110        - New 'crashrecipient' directive. Disabled by 
111          default. See sample configuration file to see how
112          to activate it. It is suggested that you activate it.
113         
114        - New PYKOTAJOBSIZEBYTES environment variable exported, 
115          which contains the job's size in bytes. Empty jobs
116          are now denied. This value is now stored in the job
117          history (but not yet displayed from the web interface)
118         
119        - Preliminary work on payments storage : the PostgreSQL 
120          and LDAP schemas should be OK now, but no code is written
121          yet to support this functionnality.
122         
123    - 1.19alpha16 :
124   
125        - the newuser and newgroup LDAP specific directives now accept
126          a second parameter to attach(), "fail" or "warn". If no entry
127          is found to attach PyKota attributes to, and "fail" was used,
128          then action is aborted and program exits in error. If "warn"
129          is used, a new entry is created but a warning message is logged.
130         
131        - The job's originating hostname is now stored in the database,
132          and exported as PYKOTAJOBORIGINATINGHOSTNAME in the environment.
133       
134    - 1.19alpha15 :
135   
136        - The old pykota filter is now removed. This means that
137          currently PyKota doesn't support LPRng anymore, but
138          LPRng support will be re-added, improved, in the near future.
139         
140    - 1.19alpha14 :
141   
142        - PYKOTAPRECOMPUTEDJOBSIZE and PYKOTAPRECOMPUTEDJOBPRICE
143          are now exported as environment variables.
144         
145        - Heavy CPU usage is now completely fixed it seems, by
146          introducing some 0.01 second sleeping when nothing to do.
147         
148        - Pre-computation of the job's size is now only
149          done when enforcement is "STRICT", this saves
150          CPU for people who don't want to use this new
151          feature.
152         
153        - New 'enforcement' directive which accepts either
154          STRICT or LAXIST. See sample configuration file
155          for details.
156         
157    - 1.19alpha13 :
158   
159        - Get back to an old version of the polling loop which
160          worked fine, but non-optimally. Will be optimized
161          as time permits.
162         
163    - 1.19alpha12 :
164   
165        - Job's size is now precomputed unconditionnally using
166          the generic PDL analyzer.
167          NB : This value is not yet used to pre-allow/deny the
168          job.
169       
170    - 1.19alpha11 :
171   
172        - The pykota filter is now completely deprecated and
173          can't be used anymore. LPRng users MUST download
174          an older version of PyKota. CUPS users MUST use
175          cupspykota. Better support for LPRng will come
176          in the near future.
177         
178    - 1.19alpha10 :
179   
180        - pykotme now uses generic PDL Analyzer directly instead
181          of spawning a new process.
182         
183        - Improvements to generic PDL Analyzer.
184       
185        - 25% Speedup in PCL parser. Getting more of the Python version
186          will probably be difficult, since the completely table driven
187          parser I wrote is slower than the original algorithm. Then,
188          the original algorithm is still used for now.
189          Probable that more speed could be achieved using mmap, at the
190          expense of severe memory consumption.
191       
192        - configuration simplifications : the "accounter" directive's
193          'hardware' arguments now accepts what was in the "requester"
194          directive as it's content. The "requester" directive is not
195          supported anymore. See sample configuration file for details.
196       
197    - 1.19alpha9 :
198       
199        - pkpgcounter is now just a wrapper around the PDLAnalyzer class
200       
201        - pykotaOptions LDAP attribute now accepts non-ascii characters
202          too.
203         
204        - First try at cupspykota main loop rewrite
205       
206    - 1.19alpha8 :
207   
208        - 'querying' accounting method is now called 'hardware'
209       
210        - 'external' accounting method is now called 'software'
211       
212        - 'stupid' accounting method doesn't exist anymore
213       
214        - 'snmp' requester doesn't exist anymore
215       
216        - code simplifications in external requester
217       
218    - 1.19alpha7 :
219     
220        - Database schema change (both LDAP and PostgreSQL) to
221          allow storage of the job-originating-hostname attribute.
222          An SQL upgrade script is present. The code is not yet
223          capable of setting/retrieving this attribute. Support
224          for this functionnality will be added in the future.
225         
226    - 1.19alpha6 :
227   
228        - problems connecting to SMTP servers are now catched.
229       
230        - pykotme now uses pkpgcounter to compute the size of the
231          job. This modification adds PCL5 and soon PCLXL (PCL6)
232          support. You can now get quotes for PCL in addition to
233          PostScript.
234         
235        - pkpgcounter now includes first try at PCLXL parser. 
236          It is currently disabled until it's finished.
237         
238    - 1.19alpha5 :
239   
240        - cupspykota polling loop fix for MacOSX (at least)
241       
242        - logging subsystem now logs PID too, to ease diagnosing
243          problems under heavy load.
244         
245        - pkpgcounter enhancements.
246       
247        - pkprinters --skipexisting now tells pkprinters to not
248          modify existing printers when --add is used.
249          pkprinters logs a warning message whenever --add is
250          used and a printer already exists.
251         
252        - LDAP schema now allows accented chars in pykotaFileName
253          and pykotaTitle attributes.
254       
255    - 1.19alpha4 :
256   
257        - a bad copy&paste prevented pkpgcounter to work at all, this
258          is now fixed.
259         
260        - improved PCL support in pkpgcounter, with the use of
261          HP PCL/PJL Reference Set
262          PCL5 Printer Language Technical Quick Reference Guide
263       
264        - pkpgcounter now uses mmap to speed things up : duration
265          is halved with the sample 87 pages PCL document I use for
266          testing.
267         
268    - 1.19alpha3 :
269   
270        - pkprinters now accepts the --list command line argument
271          to list informations about printers.
272         
273    - 1.19alpha2 :
274   
275        - pkpgcounter is now included as a smart external
276          accounter which can handle both PostScript and PCL.
277         
278    - 1.19alpha1 :
279   
280        - PYKOTALIMITBY environment variable is now exported too.
281       
282        - Inclusion of Michele Baldessari's work on autotools.
283       
284    - 1.18 :
285   
286        - Improved documentation
287       
288    - 1.18beta2 :
289     
290        - Fix for raw jobs with cupspykota
291       
292    - 1.18beta :
293   
294        - Small fix for new waitprinter.sh script
295       
296        - Better tracebacks on error conditions
297       
298        - Improved translations
299       
300        - Improved documentation
301       
302    - 1.18alpha15 :
303
304        - waitprinter.sh replaced by a new and possibly faster
305          and more powerful one.
306   
307        - Names can now begin with a digit.
308       
309        - Stability improvement for quotas set on printers groups.
310       
311    - 1.18alpha14 :
312   
313        - Catches more (all ?) problems with SMTP servers instead
314          of breaking.
315         
316        - Italian translation added.
317       
318    - 1.18alpha13 :
319   
320        - Pre and Post hooks are now available in the pykota
321          filter as well.
322         
323        - The pykota filter doesn't check last user's quota
324          anymore when delayed hardware accounting is used :
325          this will be done anyway the next time the last
326          user will print again. This saves some database
327          queries which are unneeded.
328       
329    - 1.18alpha12 :
330   
331        - Pre and Post hooks to external commands with many
332          many environment variables available are useable
333          from the cupspykota backend.
334          See sample configuration file for details and help.
335         
336    - 1.18alpha11 :
337   
338        - Hopefully final fix wrt groups (users and printers)
339       
340    - 1.18alpha10 :
341   
342        - Fixed nested printer groups accounting.
343       
344        - Fixed user groups + printer groups problem.
345       
346    - 1.18alpha9 :
347   
348        - Fix for LDAP problem when job price was 0.
349       
350        - Fix for empty user groups with LDAP.
351       
352        - Preliminary version of the snmpprinterstatus command added.
353       
354    - 1.18alpha8 :
355   
356        - Don't retrieve data when not needed.
357          This avoids many database queries.
358       
359    - 1.18alpha7 :
360   
361        - New experimental ldapcache directive to improve
362          LDAP caching.
363         
364    - 1.18alpha6 :
365       
366        - New configuration directive added : maildomain
367          to specify the domain to send mail to when user
368          email address is not set in PyKota database.
369         
370        - More complete email message headers. 
371         
372    - 1.18alpha5 :
373   
374        - Debian packaging specific files, contributed by
375          Peter Hawkins are now included in the project's tree.
376         
377        - Preliminary work on future low-level LDAP caching to speed
378          up modifications (at least).
379         
380    - 1.18alpha4 :
381   
382        - Applied some of the modifications suggested by
383          Peter Hawkins, for better Debian integration.
384          Most notably cupspykota, pykota, and the shell
385          scripts are now installed into /usr/share/pykota
386          instead of into /usr/bin
387          BEWARE : double check that your symbolic link
388          to cupspykota is correct, and that your pykota.conf
389          file use correct path for the shell scripts like
390          waitprinter.sh and al.
391         
392        - pkhint command added, to help in configuring correct
393          accounting method for PyKota.
394         
395    - 1.18alpha3 :
396   
397        - Fixed a rare bug in cupspykota backend which gave
398          incorrect "CUPS backend died abnormally" messages.
399       
400    - 1.18alpha2 :
401   
402        - Added the pkprinters command line tool to manage printers
403          exclusively.
404       
405    - 1.18alpha1 :
406   
407        - Preliminary work on Relationnal Database Independance.
408       
409        - Sample report made from OpenOffice.org added as PDF and SXC.
410       
411    - 1.17 :
412   
413        - Finalized release.
414       
415    - 1.17alpha2 :
416   
417        - Fix stupid software accounting bug in the CUPS backend.
418       
419    - 1.17alpha1 :
420   
421        - User/Group deletion code in edpykota rewritten.
422       
423    - 1.16 :
424   
425        - Preliminary documentation on how to use OpenOffice.org
426          to create personnalized reports for PyKota + PostgreSQL.
427         
428        - Spanish installation guide for CUPS+PyKota+PostgreSQL
429          added to the documentation. Doesn't yet document v1.16
430          though.
431       
432        - Portuguese Portuguese translation replaces Brasilian
433          Portuguese Translation. Brasilian portuguese
434          translation is still available under the 'br' locale.
435       
436    - 1.16beta3 :
437   
438        - Swedish translation added.
439       
440        - Small fix in documentation.
441       
442    - 1.16beta2 :
443   
444        - Small fix for job cancelling code while job already
445          printing in CUPS backend.
446         
447        - Big fix wrt printing policies for unknown users. 
448       
449    - 1.16beta1 :
450   
451        - Manpages upgraded.
452       
453    - 1.16alpha26 :
454   
455        - Job price is now computed like this :
456       
457          SUM((NbPages * PricePerPage) + PricePerJob)
458         
459          For current printer and all the printers groups it is
460          a member of, if any.
461         
462          This may be difficult to grasp, but offers unprecedented
463          flexibility.
464         
465    - 1.16alpha25 :
466   
467        - Email address can be set at user creation time,
468          using the following syntax :
469         
470            $ edpykota --add username/email@yourdomain.com
471       
472    - 1.16alpha24 :
473   
474        - CGI script now can show the printing history.
475       
476        - Bug wrt number of copies should be fixed.
477       
478        - Major code refactoring => It is now possible to
479          automatically add printers on first print.
480       
481    - 1.16alpha23 :
482   
483        - Fixed potential accuracy problem if a user printed on
484          several printers at the very same time.
485       
486    - 1.16alpha22 :
487   
488        - edpykota now allows adding printers to printer groups
489       
490    - 1.16alpha21 :
491   
492        - Allows the dot in user and printer names.
493       
494        - Printer groups are now cached too.
495       
496    - 1.16alpha20 :
497   
498        - Fixed several small bugs with the help of PyChecker.
499       
500    - 1.16alpha19 :
501     
502        - Fixed a bug in PostgreSQL backend's code.
503       
504    - 1.16alpha18 :
505   
506        - Initial code for printer groups support. Printer groups have
507          to be added with external tools like psql or gq for example.
508          Printer groups seems to work fine with users. Untested with user
509          groups for now.
510
511        - Several minor visual problems fixed in reports.
512       
513        - Fixed a bug in LDAP date handling.
514       
515        - Fix for LDAP problem with some combination of OpenLDAP + Python-LDAP
516          + some particular settings.
517         
518        - mailandpopup.sh shell script added. See sample configuration file
519          for details.
520       
521        - Several environment variables are now exported when executing
522          external commands (accounters, requesters, mailers) :
523           
524            PYKOTAUSERNAME => user who is printing
525            PYKOTAPRINTERNAME => printer on which the job is being sent
526            PYKOTATITLE => Job's title
527            PYKOTAFILENAME => Job's filename
528            PYKOTACOPIES => number of copies asked
529            PYKOTAOPTIONS => print command options (-o with CUPS)
530         
531    - 1.16alpha17 :
532   
533        - Added portugues translation.
534       
535        - Major code refactoring in accounters.
536       
537    - 1.16alpha16 :
538   
539        - Code refactoring, and addition of a real HTML reporter, to
540          have nice looking and useful web based reports (in the future).
541       
542        - Added utolower configuration option to convert all usernames
543          to lowercase during printing.
544         
545    - 1.15alpha15 :
546   
547        - Now includes the papwaitprinter.sh shell script to wait for
548          AppleTalk enabled printers.
549         
550    - 1.16alpha14 :
551   
552        - Now printing on a printer not defined in the Quota Storage,
553          results in the job being cancelled or stopped, depending
554          on the printing system.
555         
556    - 1.16alpha13 :
557   
558        - Small bugfix wrt Python v2.1
559       
560        - If username is an empty string, user root is assumed.
561       
562        - 'postgresql' is not recognized anymore as a storage backend,
563          you have to use 'pgstorage' instead. 'postgresql' used to
564          be supported for compatibility with very old PyKota versions,
565          this is not the case anymore.
566         
567    - 1.16alpha12 :
568   
569        - Job price added to job history, to keep accounting correct
570          if a printer price per page or per job is modified and the
571          history is not reset : the history would have given a false
572          amount of money charged before the printer's prices were
573          modified, this addition solves the problem.
574         
575    - 1.16alpha11 :
576   
577        - Some preliminary modifications to the database structure for
578          PostgreSQL and OpenLDAP. A script to upgrade a PostgreSQL
579          database is now provided. LDAP attributes now support
580          eq, pres and sub indexes.
581         
582        - Job history now contains additional informations : 
583          number of copies, filename, title and print options.
584         
585    - 1.16alpha10 :
586       
587        - Some modifications done to external policy handling.
588          See sample configuration file for details.
589   
590        - Spanish translation added.
591       
592    - 1.16alpha9 :
593   
594        - mailto can be set to external(...) to warn users above
595          quota with any command of your choice (e.g. linpopup).
596          Several parameters are available, see sample configuration
597          file for details.
598         
599    - 1.16alpha8 :
600   
601        - Now cupspykota transmits SIGTERMS to the original 
602          backend when the user deletes a job being processed.
603         
604        - The documentation is now licensed under the terms of the
605          GNU GPL too.
606         
607    - 1.16alpha7 :
608   
609        - The CUPS backend is now fully functionnal (it seems).
610       
611        - From now on, the use of the pykota filter with CUPS
612          is deprecated. The pykota filter still has to be
613          used with LPRng though.
614       
615    - 1.16alpha6 :
616   
617        - Bug fixed : when edpykota was used to add a printer
618          with no user or group name, a bad user/group name "*" was
619          added to the database.
620         
621    - 1.16alpha5 :
622   
623        - New CUPS backend supports device enumeration !
624          This means that NO manual CUPS configuration has to
625          be done. All can now be done from CUPS web interface.
626       
627    - 1.16alpha4 :
628   
629        - New CUPS backend added.
630       
631    - 1.16alpha3 :
632       
633        - Minimal FAQ document added.
634       
635    - 1.16alpha2 :
636   
637        - CGI script now partially supports browser's language preference
638       
639    - 1.16alpha1 :
640   
641        - Ensures that the LDAP connection is really closed at end.
642       
643        - More complete error messages in case of LDAP operation failure.
644       
645    - 1.15 :
646     
647        - Documentation improved.
648       
649    - 1.15beta :
650   
651        - Command line tools now accept multiple printer
652          names or wildcards, separated with commas.
653         
654    - 1.15alpha9 :
655   
656        - External policy can be used to auto-add unknown users
657          and any other interesting things you may want to do.
658          WARNING : You can't auto-add printers for now.
659          They have to be created manually before.
660          Look at sample configuration file for examples.
661         
662    - 1.15alpha8 :
663   
664        - Job history can be disabled if needed.
665          This feature may be useful for people who use the LDAP
666          backend and don't want their LDAP tree to grow out of
667          control.
668       
669    - 1.15alpha7 :
670   
671        - More work done on caching wrt groups.
672       
673    - 1.15alpha6 :
674   
675        - Performance bottleneck with LDAP solved.
676       
677    - 1.15alpha5 :
678   
679        - Caching mechanism for all database queries.
680
681    - 1.15alpha4 :
682   
683        - Problem with Python 2.3 fixed. Needs some definitive
684          modification.
685         
686    - 1.15alpha3 :
687   
688        - CGI script now tries to restrict view when the
689          REMOTE_USER environment variable is set. This allows
690          people to protect its use with .htaccess files.
691          When unprotected, or if REMOTE_USER is 'root', then
692          unrestricted access is granted.
693          NB : REMOTE_USER is automatically set by the web server
694          (e.g. Apache) when a page with restricted access is viewed.
695         
696    - 1.15alpha2 :
697   
698        - Better detection of LPRng.
699       
700        - Outputs a warning if printing system is unknown.
701       
702    - 1.15alpha1 :
703   
704        - Bug fix in SQL code.
705       
706    - 1.14 :
707   
708        - The PostgreSQL database connection is now always closed before
709          exit. The LDAP database connection too, but it didn't suffer
710          from the problem anyway, AFAICT.
711       
712    - 1.14beta2 :
713   
714        - An LDAP-specific configuration field was introduced, usermail.
715          Use it to specify which LDAP attribute contains a valid email
716          address for the user. See sample configuration file for
717          details.
718       
719    - 1.14beta :
720   
721        - Two new LDAP-specific configuration fields were introduced,
722          newuser and newgroup. Use them to specify if you want to add
723          quota information to existing entries or elsewhere.
724          See sample configuration file for details.
725         
726    - 1.14alpha9 :
727   
728        - Documentation improved.
729       
730        - pykotme now also prints the user's account balance value
731          if the user is registered in the Quota Storage and his
732          limiting factor is "balance".
733         
734    - 1.14alpha8 :
735   
736        - bin/waitprinter.sh is now included to wait for
737          SNMP enabled printers to be idle again before
738          asking for their internal page counter.
739          See sample configuration file for details.
740         
741    - 1.14alpha7 :
742   
743        - edpykota now doesn't check if the user/group is above
744          quota. The check is only done at print time. This
745          prevents the sending of email messages when creating
746          user quotas if quota is already reached at creation
747          time.
748         
749    - 1.14alpha6 :
750   
751        - Configuration file split and moved to /etc/pykota/pykota.conf
752          and /etc/pykota/pykotadmin.conf to prevent simple users to
753          have Read/Write access to the Quota Database.
754          Don't forget to :
755         
756                $ chmod 640 /etc/pykota/pykotadmin.conf
757               
758        - storageuser and storageuserpw configuration fields reintroduced
759          for the same reason.
760         
761        - Code cleaning for future implementation of email addresses
762          support in the PostgreSQL and LDAP backends.
763         
764    - 1.14alpha5 :
765       
766        - Big bug fixed when changing the prices for a printer
767       
768    - 1.14alpha4 :
769   
770        - When adding an user, the user itself and its account balance
771          are now added in the same LDAP entry. Before they were added
772          as two different LDAP entries.
773         
774    - 1.14alpha3 :
775   
776        - Email field added to PostgreSQL database. An upgrade script
777          is included in initscripts/postgresql.
778       
779    - 1.14alpha2 :
780   
781        - Typo fixed when using the --prototype option to edpykota
782       
783    - 1.14alpha1 :
784   
785        - Poor man's treshold included : users with a low account
786          balance (below 1.0 by default, configurable) are sent
787          a warning message.
788         
789        - All warning messages to users are now configurable. 
790          NB : Warning messages to the administrator are not.
791       
792    - 1.13 :
793   
794        - Some small fixes wrt group handling.
795       
796        - The whole module code was passed through PyChecker and
797          several small code inconsistencies were fixed,
798          as well as a bug in the groups code.
799         
800    - 1.13alpha1 :
801   
802        - Bug fix wrt LDAP.
803       
804    - 1.12 :
805   
806        - More complete test added in edpykota.
807       
808    - 1.12alpha2 :
809   
810        - The previous bug fix was incomplete. This is corrected.
811       
812    - 1.12alpha1 :
813   
814        - Small bug fix.
815       
816    - 1.11 :
817   
818        - Now includes the pykotme command line tool, to produce
819          printing quotes for users.
820         
821    - 1.10 :
822   
823        - Bug fixed wrt quota reports when print limiting is by
824          account balance.
825         
826    - 1.09 :
827   
828        - Translations finalized.
829       
830        - Manpages updated.
831       
832        - Installation documentation improved wrt LDAP support.
833       
834    - 1.09beta2 :
835   
836        - The CGI script for quota reports works again, and
837          is much more powerful.
838       
839    - 1.09beta :
840   
841        - edpykota finalized
842       
843    - 1.09alpha2 :
844   
845        - LDAP schema modified a bit. Please upgrade.
846       
847        - LDAP backend works !
848       
849        - repykota and warnpykota allow the root user to pass
850          users or groups names on the command line. Users
851          and groups names may contain wildcards.
852         
853        - repykota and warnpykota only reports or warns the
854          current user when launched by non-root users.
855         
856        - Minor bug fixes. 
857   
858    - 1.09alpha1 :
859   
860        - More work on LDAP storage backend. Many options
861          were added to /etc/pykota.conf to give some
862          hints to the LDAP storage backend.
863         
864        - Severe database access optimizations were done by
865          rewriting most of the Quota Storage backends drivers.
866     
867    - 1.08 :
868   
869        - Major bug fix wrt LPRng support for remote jobs.
870       
871        - Major bug fix wrt increase/decrease account balances.
872       
873    - 1.08alpha8 :
874   
875        - Code refactoring.
876       
877        - A single user/password pair is used to connect
878          to the database backend. The storageuser configuration
879          field, and its associated passwords storageuserpw, are
880          not used anymore.
881         
882        - You can now set PyKota in debug mode, see sample configuration 
883          file for details.
884          WARNING : only Quota Storage backend queries are logged in
885          debug mode, for now.
886       
887    - 1.08alpha7 :
888   
889        - Very latest LDAP schema.
890       
891        - Code enhancement wrt easy pluggability of PyKota attributes
892          and object classes into an existing LDAP directory.
893       
894    - 1.08alpha6 :
895   
896        - Minor bug corrections
897       
898        - More work on LDAP : new schema
899       
900    - 1.08alpha5 :
901   
902        - More good work on LDAP storage.
903          repykota now works reasonably well with the sample LDAP directory.
904       
905    - 1.08alpha4 :
906   
907        - LDAP schema included.
908          THIS IS JUST FOR PEOPLE TO DISCUSS ABOUT THIS.
909          LDAP SUPPORT DOESN'T WORK YET, AND THE SCHEMA
910          MAY CHANGE IN THE FUTURE. PLEASE TELL US
911          WHAT YOU THINK ABOUT THIS SCHEMA ON THE
912          MAILING LIST.
913         
914    - 1.08alpha3 :
915   
916        - External accounting methods were partly rewritten :
917         
918          - No more "broken pipe" should happen.
919         
920          - They now take care of the number of copies
921            This may be unneeded though, if the postscript
922            file already does this, because this would
923            overcharge users (number of copies counted
924            two times). NEEDS MORE TESTING.
925           
926          - The sample configuration file now contains 
927            an external accounting method example which should
928            work with all DSC compliant Postscript files.
929           
930        - Some small bugs were fixed.   
931       
932    - 1.08alpha2 :
933   
934        - Now works with net-snmp v5.0 and above.
935          It already worked, but the sample configuration
936          file didn't contain appropriate values...
937       
938    - 1.07 : Release of the Shame !
939   
940        - The external accounting methods driver was left out of
941          the CVS tree. Nobody could use it since it wasn't included !
942         
943    - 1.06 :
944   
945        - Severe bug fixed : if you had a printer in
946          power saving state which couldn't answer immediately,
947          a bug was triggered.
948          It was caused by a bad copy/paste which
949          forgot to import a Python module at run time.
950         
951    - 1.05 :
952   
953        - External accounters are finally available !
954          This means that you can plug any page accounting
955          method you like by setting the appropriate
956          'accounter' field in /etc/pykota.conf
957          See the sample conf/pykota.conf.sample to
958          learn how to do.
959         
960          NB : Both 'external' and 'stupid' accounting methods
961               account a job size just before *this* job is
962               sent to the printer.
963               The original 'querying' method accounts a job
964               size just before *the next* job is sent to
965               the printer.
966       
967    - 1.05alpha3 :
968   
969        - A 'stupid' and unreliable accounting method was
970          implemented to serve as an example on how to
971          do this sort of things. This method only counts
972          the 'showpage' statements in the input data.
973          See sample configuration file for details.
974          Pluggable accounting methods work, but I advise
975          you TO NOT USE THIS ONE WHICH IS JUST AN EXAMPLE.
976          It is not reliable enough to be used.
977          Use the 'querying' accounting method instead.
978         
979    - 1.05alpha2 :
980   
981        - Pluggable accounting methods.
982       
983        - Better error handling.
984       
985    - 1.05alpha1 :
986   
987        - SECURITY file added to help improve PyKota's security.
988       
989        - Extracting the printer's internal page counter is now
990          tried several times, waiting several seconds between
991          two tries. This lets the time to warm up for some printers
992          which don't answer when they are sleeping (my Apple
993          LaserWriter 16/600 PS is in this case, maybe others too)
994         
995        - Small display bug fixed in repykota
996         
997    - 1.04 :
998   
999        - Default print policy for users/groups unknown from
1000          the print quota system is now DENY instead of ALLOW,
1001          since ALLOW can generate inaccurate results
1002          (incorrect job sizes charged to the wrong persons)
1003         
1004        - LPRng support works !
1005       
1006        - A bug was introduced some time ago wrt printers' default
1007          policy for unknown users. It is now corrected.
1008       
1009        - repykota now displays prices per job and per page for each
1010          printer, if they are defined.
1011         
1012        - Minor display bug fixed in repykota.
1013       
1014        - Problem when running repykota with an empty database was fixed.
1015       
1016    - 1.03 :
1017   
1018        - Upgrade script included for earlier versions.
1019          Please look inside the initscripts subdirectory.
1020          THE DATABASE SCHEMA HAS CHANGED, PLEASE UPGRADE.
1021         
1022        - repykota now reports account balances too.
1023       
1024        - PyKota now has a nice logo, see the logos
1025          subdirectory.
1026       
1027        - Manual pages were finally updated.
1028       
1029        - Group quotas seem to work now !
1030       
1031        - The new database schema allows to keep an history of all
1032          jobs as well as charge users per page and/or per job,
1033          and track users' account balance.
1034         
1035        - edpykota now accepts much more command line options to 
1036          use the new functionnalities. See edpykota --help for
1037          details.
1038         
1039        - The installation script now allows to install the sample
1040          configuration file during first installation.
1041         
1042        - More group quota code works, but still not finished. 
1043       
1044        - The CGI script displays a link to PyKota's website.
1045       
1046        - The job history is now kept, this will allow per-period
1047          reports in the future.
1048         
1049        - After having modified the quota for an user with edpykota,
1050          a quota check is done to eventually warn the user/admin about
1051          a quota which is too low to print.
1052         
1053        - A workaround is provided for HP Printers : their internal
1054          page counter is only saved to NVRAM in a 10 increment, so
1055          if you switch them off and then on, the reported page counter
1056          may be lower than the real number of pages printed.
1057          See http://web.mit.edu/source/third/lprng/doc/LPRng-HOWTO-15.html
1058          We unconditionnally set the last job's page count to
1059          abs(int((10 - abs(lastcounter(snmp) - lastcounter(storage)) / 2))
1060          in this case.
1061          For a more accurate accounting, never switch your HP printers
1062          off.
1063         
1064        - A fix is provided for printers which only have a volatile 
1065          page counter (reset to 0 every time you switch the printer on)
1066          This should allow PyKota to work reasonably fine with HP Laserjet
1067          4L/5L/6L, not perfect, but better than nothing.
1068          See http://web.mit.edu/source/third/lprng/doc/LPRng-HOWTO-15.html
1069          For a more accurate accounting, never switch your HP printers
1070          off. This is untested, please report any problem.
1071         
1072        - A bug was fixed when edpykota --add was used with users who already
1073          had a quota on the specified printer.
1074         
1075        - A small display bug in repykota was introduced in preliminary
1076          1.03 versions, and fixed later on.
1077         
1078        - Some minor bugs which happened in rare situations were fixed.
1079       
1080        - Support for AppleTalk printers was added, see sample configuration
1081          file for details.
1082         
1083        - Users and group printing can now be controlled (limited) either by 
1084          print quota or by account balance.
1085       
1086    - 1.02 :
1087   
1088        - The installation script now checks for software availability
1089          and in case a software is missing asks the user if he
1090          wants to continue with the installation or abort it.
1091         
1092        - The configuration file pykota.conf is now expected to be
1093          found in /etc instead of in /etc/cups
1094          The installation script prompts the user to see if he
1095          wants to move an old configuration file to the new location
1096          if needed.
1097         
1098        - Improved documentation.
1099       
1100        - You can now set the tcp/ip port on which the Quota Storage
1101          Server is listening, see sample configuration file for details.
1102       
1103        - Better general error handling.
1104       
1105        - Upgrade script for pre 1.01 PostgreSQL database schema is now
1106          included as well.
1107       
1108    - 1.01 :
1109   
1110        - The configuration file now accepts an option   
1111          to choose the recipient(s) of the email messages :
1112         
1113            - DevNull means no one will receive them.
1114            - User means only the user will receive them.
1115            - Admin means only the admin will receive them.
1116            - Both means the User and the Admin will receive them.
1117           
1118        - The configuration file now uses hard-coded default values
1119          when an option is not set. See sample configuration file
1120          for details.
1121         
1122        - Manual pages are included since 1.00, but I forgot to   
1123          add this information to this file.
1124         
1125        - Redistribution terms for the official package have 
1126          softened and are now fully GPL compatible :
1127          unrestricted modification is now allowed even for
1128          the version number.
1129         
1130    - 1.00 :
1131   
1132        - edpykota now accepts a --noquota option. This
1133          disable quota checking while still doing page
1134          accounting. This is really useful for people
1135          who don't want to limit their users but want
1136          to know how much pages they print.
1137         
1138        - Some untested scripts were added to retrieve
1139          the life time page counter of non-SNMP printers.
1140         
1141        - Every directory now has a specific README file. 
1142       
1143    - 0.99 :
1144   
1145        - Under some circumstances while the user wasn't allowed
1146          to print, he didn't receive any email message. It is
1147          now fixed.
1148         
1149        - When an user wasn't allowed to print, the quota for
1150          the previous user wasn't updated. This is now fixed.
1151         
1152    - 0.98 :
1153   
1154        - Correctly handle the case where the printer is switched off.
1155       
1156        - Small bug wrt syslog fixed.
1157       
1158    - 0.97 :
1159   
1160        - edpykota accepts wildcards on its command line for users/groups too
1161          if the --add option is not set, e.g. :
1162         
1163              $ edpykota --printer lp --softlimit 50 --hardlimit 100 "jer*"
1164             
1165        - If no user name is passed at all, then a default wildcard of "*"
1166          which means apply the command on ALL users for this printer is used.
1167         
1168        - Small bug fixes.
1169       
1170    - 0.96 :
1171
1172        - Options requester, policy, admin, adminmail and gracedelay can now
1173          be set either globally or per printer. The printer option has
1174          priority if both are defined.
1175
1176        - More powerful configuration parser.
1177       
1178        - If all options are defined globally, there's no need to
1179          define a section for each printer in the configuration
1180          file anymore. Just define a [global] section and it's ok.
1181
1182    - 0.95 :
1183
1184        - External requesters for printers finally added.
1185
1186        - Full internationalization (english and french are supported)
1187 
1188        - More complete quota usage report
1189
1190        - CGI script to access to the quota usage report
1191
1192        - Several bugs fixed.
1193
1194
1195    - 0.9 :
1196
1197        - First public version
Note: See TracBrowser for help on using the browser.