gmane.comp.printing.pykota.user

Trimming old jobhistory

Paul Ortman — 2008-09-05T17:54:12

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Similarly to Brian Chivers, I've had a Pykota install for several years now with fairly moderate usage and have definitely noticed an uptick in disk usage and query time on the PostgreSQL database. Unlike Brian, I don't want to drop everything but the printers. A little investigation shows that jobhistory is the biggest space hog for me. I'd like to just drop job history that is say older than x number of days or years and put that on a cron job. I'm fine writing the SQL to do that myself, but I was curious what I might break or loose if I do so. Here's our current usage for the curious: relname | tablesize | indexsize | toastsize | totalsize - ----------------------+-----------+-----------+-----------+------------ gc_error_messages | 2809856 | 286720 | 0 | 3032 kB gc_balance_snapshot | 56713216 | 43163648 | 0 | 95 MB billingcodes | 0 | 16384 | 0 | 24 kB coefficients |

clearing out the database

Brian Chivers — 2008-09-05T08:02:15

We've been running Pykota for a few years now & I've never cleared out the database so as you can imagine it's got a bit in there :-) How can I clear out all the users & print history but leave just the printers in there ? Also is the a "compact" routine to run on postgresql when it's done :-) Thanks Brian Chivers Portsmouth College ------------------------------------------------------------------------------------------------ The views expressed here are my own and not necessarily the views of Portsmouth College

Using PyKota with CUPS print queue

Creech, Brandin M — 2008-09-04T23:59:53

Hello I would like to use PyKota with CUPS's print queue ("Option job-hold-until indefinite" in /etc/cups/printers.conf). However, as stated in the documentation, PyKota only activates after the job is released from the print queue. Is there any way to have PyKota activate itself before going into the print queue? In my ideal setup, the user should request a print job from one of the computers and then authenticate to PyKota using pknotify, and then release the print job from a dedicated print station. I realize the CUPS filters are designed to occur after the print job is released, but I'm wondering if running two instances of CUPS (or two separate print queues) would work, the first queue would release its jobs immediately (which PyKota would then take care of), and then after it is accounted for, that print job would be released into another instance of CUPS (which is set up for "Option job-hold-until indefinite") which will sit in the queue until manually released. Local machine -> First CUPS queue (

Print delay when using PyKota

Creech, Brandin M — 2008-09-03T00:18:24

Hello. I'm currently testing PyKota in my lab and have encountered a small problem-- the print accounting is working as it should, but there is a 15-30 second delay when releasing a print job to a PyKota-managed device. Unfortunately I can't exactly tell from my CUPS log where the problem is occuring: I [02/Sep/2008:18:39:12 -0500] Started filter /usr/lib/cups/filter/pstops (PID 2 5390) for job 1670. I [02/Sep/2008:18:39:12 -0500] Started filter /usr/lib/cups/filter/pstoraster (P ID 25391) for job 1670. I [02/Sep/2008:18:39:12 -0500] Started filter /usr/lib/cups/filter/rastertoguten print.5.0 (PID 25392) for job 1670. I [02/Sep/2008:18:39:12 -0500] Started backend /usr/lib/cups/backend/cupspykota (PID 25393) for job 1670. I [02/Sep/2008:18:39:12 -0500] Job 1670 was released by "root". All print jobs released show similar output, and all of them have about a 15-30 second delay before printing actually begins. If I bypass PyKota and print to the device directly (by removing "cupspykota://" from the Device

Questions more

Ricardo dos Santos Paula — 2008-09-02T19:10:32

Ok J. Alet, I could solve the problem of users. printing are all very well, and far too much, rs The problem was a driver that I had installed on the server was PCL6 dai I swapped for a PS and resolved. Thank you! Then more questions ... 1) put in the browser of my browser the address ==> http://localhost/cgi-bin/printquota.cgi he logs right on the page. As phaco ask him to sign? 2) At the end of pykota.conf I saw the respect of quotas by coverage of ink. It could send me an example of such configuration? 3) The files. Cgi of the graphics interface for me to manage everything? For example: - add credits to users or groups - add or remove printers or users with quotas and rules. 4) How to set the e-mail I receive? For example, I received a mail set standard. ie and sent to the user with a copy to the administrator on the balance of the share low. I ask ==> What do I set the file contents of the message I got, because I would like to translate the message that will be sent. Thanks Ricardo

Can you run 1.26 with a 1.24 backend

Brian Chivers — 2008-09-01T11:14:13

Sorry if this arrives twice but I think I sent it to the old address :-) We have our existing print servers all running 1.24 with a postgressql backend without any problem. I have just installed 2 thinclient server based around CentOS5 (both 32 & 64 bit) and would like to install pykota on to these to manage the local HP printers connected via JetDirect. I have download the latest megapack but it is a newer version. Is it possible to mix the versions but keeping the same backend ?? If it isn;t possible I'll reconfigure the existing print servers used for the area's to run on the thinclient network but was trying to remove them and do my bit for the enviroment :-) Thanks Brian Chivers Portsmouth College ------------------------------------------------------------------------------------------------ The views expressed here are my own and not necessarily the views of Portsmouth College

Add users to automatically AD

Ricardo dos Santos Paula — 2008-08-31T15:01:37

Print normally and added a user unix: (rick) automatically. Shared the printer to users via samba windows installed the driver in the Unix server. At the time of printing a page with user test administrator of the AD in a machine he closes the windows explorer. It was because of pykota not recognise the users of the windows? How to automatically add the users of Windos?

Pykota's configuration

Ricardo dos Santos Paula — 2008-08-29T15:08:42

The following command will be launched to import the HPLaserJet4250 print queue into PyKota's database and reroute it through PyKota : pkprinters --add --cups --description "Printer created with pksetup" "HPLaserJet4250" Do you agree ? yes Error==> Creation... lpadmin: device-uri inválido "cupspykota://socket://192.168.0.222:9100"! Done. Average speed : 3.71 entries per second. I have to put in lpadmin printer admin at the beginning of the configuration of pksetup? Maybe this?

Erro no empacotamento do svn

Ricardo dos Santos Paula — 2008-08-28T13:11:47

Ola! Eu baixei o svn da versao 1.26 estavel a revision e 3408. No momento em q vou empacotar o codigo para um pacote .deb me deparei com o seguinte erro==> dpkg-buildpackage: source version 1.26_unofficial Undefined subroutine &Dpkg::Version::_g called at /usr/share/perl5/Dpkg/Version.pm line 204. Alguem pode me ajudar a resolver isso? Grato Ricardo

mailing lists problems

2008-08-20T22:07:56

Hi there, For some yet unknown reason, the mailing lists were down for at least the first 20 days of August. Nobody complained privately, so I think most of you were probably on holidays as well during this time. All should be back online now. Sorry for the inconvenience. Jerome Alet

[ANNOUNCE] Official tarball for PyKota v1.26 + HotFixes

2008-07-25T08:46:39

Hi there, Exactly one year before today, PyKota v1.26 was published. Today, I've (finally, some would say) put online a tarball containing v1.26 + all the important fixes that were made during this year. These fixes were backported from the 1.27 development tree, which shouldn't be considered useable yet. You can safely (well, I hope, but please do a backup first) install this tarball on top of, or instead of, PyKota v1.26. You should not install it on top of 1.27alpha_something since there are several changes to the pykota.conf configuration file and to the code. People with an entry pass can download it from : http://www.pykota.com/software/pykota/download/tarballs/pykota-1.26_fixes_official.tar.gz People without an entry pass can either purchase one, or grab the same code from the 1.26_fixes branch in subversion. Hoping today won't be a brown paper bag day... bye Jerome Alet

Holidays

2008-07-25T06:40:15

Hi there, I'll be on holidays from tomorrow until sometimes around August 15th. People who have a support contract can of course still use the http://otrs.librelogiciel.com/otrs/customer.pl website during this time period, since this is the only way I can be reached anywhere anytime, and (usually) almost immediately. For other people, please don't hesitate to ask questions to the mailing lists anyway, since there are a lot of people who know the software enough to be able to help you. bye Jerome Alet

Mailing lists follow-up

2008-07-21T13:50:48

Hi there, I've now put a gateway which will cause all messages sent to these three old mailing lists addresses : pykota-/5ZRO4h8pWPt3Uwzc2GATQC/G2K4zDHf< at >public.gmane.org pykota-devel-/5ZRO4h8pWPt3Uwzc2GATQC/G2K4zDHf< at >public.gmane.org tea4cups-/5ZRO4h8pWPt3Uwzc2GATQC/G2K4zDHf< at >public.gmane.org to be transparently forwarded to the new mailing lists addresses, respectively : pykota-CRN2QmnblHuoKLMKz95RRw< at >public.gmane.org pykota-devel-CRN2QmnblHuoKLMKz95RRw< at >public.gmane.org tea4cups-CRN2QmnblHuoKLMKz95RRw< at >public.gmane.org You are encouraged to exclusively use the new addresses above from now on, however this gateway will make the transition smoother. The two other mailing lists won't have such a gateway, because they are in readonly mode for you anyway. bye Jerome Alet

PING

2008-07-18T09:49:34

Just to be sure all works fine again, please could someone answer to this messages to the list ? Thanks in advance Jerome Alet

[ANNOUNCE] Mailing lists moved

2008-07-18T06:32:11

Hi there, As announced yesterday, the mailing lists were moved to the new server and to the pykota.com domain. The new adresses are : pykota-CRN2QmnblHuoKLMKz95RRw< at >public.gmane.org pykota-devel-CRN2QmnblHuoKLMKz95RRw< at >public.gmane.org tea4cups-CRN2QmnblHuoKLMKz95RRw< at >public.gmane.org pykota-support-CRN2QmnblHuoKLMKz95RRw< at >public.gmane.org pykota-techsupport-CRN2QmnblHuoKLMKz95RRw< at >public.gmane.org Of these five mailing list, only the three first ones can receive messages from you. The two other ones are readonly and reserved for announces to people with respectively an unlimited entry pass or a technical support contract. You can change your preferences or unsubscribe from : http://lists.pykota.com/mailman/listinfo/pykota http://lists.pykota.com/mailman/listinfo/pykota-devel http://lists.pykota.com/mailman/listinfo/tea4cups http://lists.pykota.com/mailman/listinfo/pykota-support http://lists.pykota.com/mailman/listinfo/pykota-techsupport Feel free to use these lists, it should work.

[ANNOUNCE] Mailing lists maintainance

Jerome Alet — 2008-07-17T15:12:56

Hi there, As previously announced a few weeks ago, all the < at >librelogiciel.com printing related mailing lists will be moved to the pykota.com domain. This move will happen later this evening, with full functionnality restored by tomorrow evening, if all goes as expected. If you actually filter incoming mail, ensure your filter accept mail coming from pykota.com. As far as your existing subscriptions are concerned, you've got nothing to do because your mailing list accounts will be moved at the same time as the mailing list themselves. The http links to subcribe or unsubscribe from these lists will also be moved, and will be inactivated during the move. Once the move is done, you'll have to send messages to, for example, pykota-coX37C6cWi/QT0dZR+AlfA< at >public.gmane.org, instead of, for example, pykota-/5ZRO4h8pWPt3Uwzc2GATQC/G2K4zDHf< at >public.gmane.org The old list addresses might still work but will be phased out eventually. I ask you to NOT answer to this message. If you want to answer to it, do so pr

duplex accounting

Élio Coutinho — 2008-07-16T10:18:58

Hi Jerome, Another feature that would be nice, would be the possibility of having different prices for duplex printings. I know that most likely it would always charge you for an even number of pages, because that's what the printer actually counts. To go around this, you could compare the software accounting with the hardware accounting, and charge by the lesser value. From the logs, you are already doing this comparison: Beware : computed job size (2) != precomputed job size (1) I know it remains the fact of detecting that a job is duplex... Anyway, it's just a suggestion, that I hope you consider introducing in the next release ;-) Best regards, Elio

user reports

Élio Coutinho — 2008-07-16T08:44:30

Hello, I'm in the process of migrating our windows based printing account system to pykota. On the present system, each user can access his printing reports, and check how his balance was debited for his printings, or how it was increased by his deposits. You can find an example on the image in attachment. Notice that for each printing the resulting balance is shown, which allows the user to easily understand why they deposited 100, and the balance was increased to 95 only. Looking at the pykota database, it seems that there is no information on the resulting balance, at the time the job was printed. Is this correct, or am I missing something? I suppose I could do the math and trace back the balance, but I would have more confidence that no one has fiddled with the database, if the balance were to be recorded on each transaction. Would it be possible to record this information? Best regards, Elio Coutinho

help.

Carlos Alberto Restrepo Márquez. — 2008-07-14T23:55:04

hello, I need help, I installed pykota-1.26 in debian 4.0, followed in the footsteps according to the manual, but when I send a print printer does not respond, I reviewed the logs searched for possible errors ain positive results, just as he set pykota. conf to send emails of potential errors that occur, but do not send any message. Addjunto sending files logs, for those who can give me a hand. Thanks in advance. PD. The evidence I'm doing on the printer Norte5-py Carlos.

Little problem in Pykota website

Adam Victor Nazareth Brandizzi — 2008-07-10T15:24:32

Hello, all! I think there is a litte problem in the http://www.pykota.com/wiki/PyKota/ page. The page says that "You can download [...] by typing the following command : svn co svn://svn.pykota.com/pykota/trunk pykota but I just could get PyKota replacing the svn:// part by http:// : svn co http://svn.pykota.com/pykota/trunk pykota Thanks in advance!