IRC logs of #tryton for Tuesday, 2011-03-08

chat.freenode.net #tryton log beginning Tue Mar 8 00:00:01 CET 2011
2011-03-08 01:03 -!- plantian(~ian@c-67-169-72-36.hsd1.ca.comcast.net) has joined #tryton
2011-03-08 01:49 -!- ikks_(~ikks@190.158.101.218) has joined #tryton
2011-03-08 02:36 -!- FWiesing(~franz@mail.tryton.at) has left #tryton
2011-03-08 03:56 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton
2011-03-08 05:06 -!- svaksha(~svaksha@unaffiliated/svaksha) has joined #tryton
2011-03-08 05:20 -!- yangoon(~mathiasb@p549F32CC.dip.t-dialin.net) has joined #tryton
2011-03-08 06:20 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton
2011-03-08 07:18 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-03-08 07:33 -!- svaksha(~svaksha@unaffiliated/svaksha) has joined #tryton
2011-03-08 07:42 -!- Vladimirek(~vladimir@bband-dyn213.178-41-22.t-com.sk) has joined #tryton
2011-03-08 07:52 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-03-08 08:16 -!- gasbakid(~gasbakid@41.96.2.101) has joined #tryton
2011-03-08 08:35 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-03-08 09:01 -!- enlightx(~enlightx@host73-9-dynamic.40-79-r.retail.telecomitalia.it) has joined #tryton
2011-03-08 09:03 -!- bechamel(~user@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton
2011-03-08 09:17 -!- elbenfreund(~elbenfreu@p54B92644.dip.t-dialin.net) has joined #tryton
2011-03-08 09:52 -!- paepke(~paepke@pD9545A77.dip0.t-ipconnect.de) has joined #tryton
2011-03-08 09:53 -!- nicoe(~nicoe@2001:6f8:3aa:0:217:f2ff:fef3:4e9) has joined #tryton
2011-03-08 10:13 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2011-03-08 10:32 -!- ikks_(~ikks@190.158.101.218) has joined #tryton
2011-03-08 11:23 -!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has joined #tryton
2011-03-08 12:07 -!- paepke(~paepke@pD9544DE5.dip0.t-ipconnect.de) has joined #tryton
2011-03-08 12:14 -!- Vladimirek(~vladimir@bband-dyn213.178-41-22.t-com.sk) has joined #tryton
2011-03-08 13:07 -!- sharoon(~sharoon@c-75-74-203-208.hsd1.fl.comcast.net) has joined #tryton
2011-03-08 13:11 -!- enlightx(~enlightx@host73-9-dynamic.40-79-r.retail.telecomitalia.it) has joined #tryton
2011-03-08 13:16 -!- hoRn(~chatzilla@pd95be09e.dip0.t-ipconnect.de) has joined #tryton
2011-03-08 13:29 <hoRn> hi
2011-03-08 13:31 <hoRn> is there a way to debug a <field name="domain"> statement? or can anybody give me a hint where to put some prints?
2011-03-08 13:32 <cedk> hoRn: what is the issue?
2011-03-08 13:34 <hoRn> cedk: I have a view opened by a wizard with start_date and end_date. now i wanna open an other model with ir.action.keyword with the start and end given in a domain
2011-03-08 13:35 <hoRn> cedk: first try was ("date", ">=", Get(Eval("context", {}), "start_date", False))
2011-03-08 13:35 -!- cheche(cheche@46.25.80.67) has joined #tryton
2011-03-08 13:36 <cedk> hoRn: inside []
2011-03-08 13:37 <hoRn> cedk: yes - <field name="domain">[("employee", "=", Eval('active_id')), ("date", ">=", Get(Eval("context", {}), "start_date", False))]</field>
2011-03-08 13:38 <hoRn> cedk: but finally i don't know nothing about the context of the opened view
2011-03-08 13:39 -!- blast_hardcheese(~blast_har@dsl092-043-124.lax1.dsl.speakeasy.net) has joined #tryton
2011-03-08 13:39 <hoRn> cedk: will try to print something in the pyson.py of the server
2011-03-08 13:40 <cedk> hoRn: just run the client with "-v" option, you will see the domain used
2011-03-08 13:41 <hoRn> so i need to install the default - yesterday i patched my client with a lot of stuff ;)
2011-03-08 13:45 <cedk> hoRn: I guess it should still work
2011-03-08 13:45 <hoRn> cedk: btw. - i tried to take a look to the dnd-patch - but the patch doesn't match my local version.
2011-03-08 13:45 <cedk> hoRn: it is for the changeset e35ba426dceb
2011-03-08 13:46 <hoRn> cedk: ok
2011-03-08 13:57 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-03-08 14:14 <serpent213> [Mon Mar 07 22:17:35 2011] ERROR:sql:Wrong SQL: UPDATE ir_cron SET nextcall = '2011-03-07T22:22:29'::timestamp, running = false, numbercall = -1 WHERE id = 1
2011-03-08 14:14 <serpent213> Exception in thread Thread-96:
2011-03-08 14:14 <serpent213> Traceback (most recent call last):
2011-03-08 14:15 <serpent213> File "/usr/local/lib/python2.6/threading.py", line 532, in __bootstrap_inner
2011-03-08 14:15 <serpent213> self.run()
2011-03-08 14:15 <serpent213> File "/usr/local/lib/python2.6/threading.py", line 484, in run
2011-03-08 14:15 <serpent213> self.__target(*self.__args, **self.__kwargs)
2011-03-08 14:15 <serpent213> File "/usr/local/lib/python2.6/site-packages/trytond-1.8.2-py2.6.egg/trytond/ir/cron.py", line 190, in pool_jobs
2011-03-08 14:15 <serpent213> [cron['id']])
2011-03-08 14:15 <serpent213> File "/usr/local/lib/python2.6/site-packages/trytond-1.8.2-py2.6.egg/trytond/backend/postgresql/database.py", line 295, in execute
2011-03-08 14:15 <serpent213> res = self.cursor.execute(sql, params)
2011-03-08 14:15 <serpent213> TransactionRollbackError: could not serialize access due to concurrent update
2011-03-08 14:15 <serpent213> CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."res_user" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"
2011-03-08 14:15 <serpent213> how come?
2011-03-08 14:15 <serpent213> running pgsql 9...
2011-03-08 15:03 -!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has joined #tryton
2011-03-08 15:27 <cedk> serpent213: please don't copy/paste traceback on irc, use tools like pastbin.ca
2011-03-08 15:31 <cedk> serpent213: it is just the cron that runs and failed because of concurrency access
2011-03-08 15:40 <serpent213> kk
2011-03-08 15:53 -!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has left #tryton
2011-03-08 15:53 <hoRn> if i opened a view with a wizzard i can access the values with Transaction().context[key] - when i wan't to open a new view from this view with ir.action.keyword - how can I post this context again?
2011-03-08 15:55 <cedk> hoRn: not sure you can
2011-03-08 15:55 <hoRn> cedk: ok - seems like this
2011-03-08 15:55 <hoRn> cedk: so i need to set up a new wizzard again
2011-03-08 15:56 <cedk> hoRn: from experiences, when you start to need too much context stuff, better to rethink about the design
2011-03-08 15:57 <hoRn> cedk: the design is broken ;)
2011-03-08 16:02 <hoRn> cedk: we use timesheet.line for tracking jobs - but we need a second model with a custom table_query to filter overlappping times. this model is accessed via a wizzard with startdate and enddate. Now I want to provide an oneclick-solution to get all the timesheet.lines for a employee in the daterange selected in the last step
2011-03-08 16:04 <cedk> hoRn: how can you have overlapping on timesheet.line ?
2011-03-08 16:08 <hoRn> we added two fields: start_time and end_time - the employees are checking in to a project using a little wxapp. In the Businessmodel there is the possibility to sign more than one project at one time.
2011-03-08 16:10 <cedk> hoRn: ok but why do you need to check if it is allow
2011-03-08 16:12 <hoRn> cedk: finally we want the worktime of each employee per day - so we simply filter the table with min(start_time) - max(end_time). everything works fine but sometimes the timesheet.lines are not correct. Now I want a fast way to open the treeview with a daterange and a single employee
2011-03-08 16:13 <hoRn> cedk: isn't than important - the active_id is given and the user can select a daterange in the tryton client again - i was thinking about how to simplify that
2011-03-08 16:17 <cedk> hoRn: you should be able to prefill the dates I think
2011-03-08 16:19 <hoRn> cedk: don't know how. Which object holds the active_id?
2011-03-08 16:24 <cedk> hoRn: the one selected
2011-03-08 16:33 <hoRn> cedk: how you think i can prefill the dates? the context changes because a change the model with the ir.action.keyword ...
2011-03-08 16:35 <cedk> hoRn: I don't understand
2011-03-08 16:37 <hoRn> cedk: I only think out loud ;)
2011-03-08 16:40 -!- zodman(~andres-va@gponr9-fija-203-7-69.iusacell.net) has joined #tryton
2011-03-08 16:40 <hoRn> cedk: <field name="domain">[("employee", "=", Eval('active_id'))]</field> works fine. active_id is a property of the view just open - so i was wondring, why i can not access the context or the domain or anything else of the current view
2011-03-08 16:43 -!- okko1(~okko@87.224.23.163) has joined #tryton
2011-03-08 16:45 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-03-08 16:48 -!- okko1(~okko@87.224.23.163) has joined #tryton
2011-03-08 16:52 -!- okko2(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-03-08 16:57 -!- okko(~okko@87.224.23.163) has joined #tryton
2011-03-08 17:03 -!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has joined #tryton
2011-03-08 17:04 -!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has left #tryton
2011-03-08 17:04 -!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has joined #tryton
2011-03-08 17:10 -!- gremly(~gremly@200.106.202.91) has joined #tryton
2011-03-08 17:26 -!- nicoe(~nicoe@2001:6f8:3aa:0:217:f2ff:fef3:4e9) has joined #tryton
2011-03-08 17:39 -!- Vladimirek(~vladimir@bband-dyn213.178-41-22.t-com.sk) has joined #tryton
2011-03-08 17:45 -!- bechamel(~user@host-85-201-144-79.brutele.be) has joined #tryton
2011-03-08 17:53 -!- elbenfreund(~elbenfreu@p54B92644.dip.t-dialin.net) has joined #tryton
2011-03-08 19:18 -!- enlightx(~enlightx@dynamic-adsl-94-34-234-144.clienti.tiscali.it) has joined #tryton
2011-03-08 19:26 -!- FWiesing(~franz@mail.tryton.at) has joined #tryton
2011-03-08 19:50 <serpent213> any issues known wrt secure webdav?
2011-03-08 19:50 <serpent213> http://pastie.org/1648346
2011-03-08 19:50 <serpent213> server closes the connection just after accepting it
2011-03-08 19:50 <serpent213> works w/o ssl
2011-03-08 19:53 -!- paepke(~paepke@pD9544DE5.dip0.t-ipconnect.de) has left #tryton
2011-03-08 20:11 <udono> serpent213: you have set secure_webdav = True in trytond.conf?
2011-03-08 20:13 <serpent213> sure
2011-03-08 20:13 <serpent213> if i set it to false and try to access by http, i get back an auth request -- as expected
2011-03-08 20:14 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton
2011-03-08 20:15 <serpent213> this is probably rather pyWebDav or pyOpenSSL related than trytond...
2011-03-08 20:16 <udono> serpent213: which tryton vrsion?
2011-03-08 20:17 <udono> serpent213: see also issue 1883...
2011-03-08 20:17 <udono> serpent213: how you generate the key?
2011-03-08 20:18 <udono> s/key/certificate/
2011-03-08 20:19 <serpent213> 1.8.2
2011-03-08 20:19 <serpent213> CACert
2011-03-08 20:21 <serpent213> problem seems to be with the ssl handshake, does not seem to proceed to webdav
2011-03-08 20:22 <serpent213> when connecting with telnet the connection is closed immediately, instead of waiting for data
2011-03-08 20:30 <serpent213> i guess i could put it behind a reverse proxy doing ssl...
2011-03-08 20:31 -!- bechamel(~user@host-85-201-144-79.brutele.be) has joined #tryton
2011-03-08 20:31 <udono> serpent213: as far as I can tell you, for me it works with self-signed cert and cadaver as a client.
2011-03-08 20:33 <udono> serpent213: maybe try to introspect the communication with wireshark/tcpdump
2011-03-08 20:35 <cedk> serpent213: which version of PyWebDAV ?
2011-03-08 20:39 <serpent213> cedk: 0.9.4.1
2011-03-08 20:41 <serpent213> now, without ssl, i sometimes get http://pastie.org/1648547
2011-03-08 20:42 <serpent213> and sometimes an auth request...
2011-03-08 20:45 <serpent213> btw, ssl works fine for netrpc using the same cert
2011-03-08 20:53 <cedk> serpent213: are you under OSX ?
2011-03-08 20:58 <serpent213> cedk: client is os x, server is a freebsd jail
2011-03-08 20:59 <cedk> serpent213: perhaps linked to http://bugs.python.org/issue8493
2011-03-08 21:20 -!- zodman(~andres-va@gponr9-fija-203-7-69.iusacell.net) has joined #tryton
2011-03-08 21:35 -!- trifon(~trifon@83.228.98.255) has joined #tryton
2011-03-08 21:37 -!- paepke(~paepke@pD9545ECE.dip.t-dialin.net) has joined #tryton
2011-03-08 21:40 -!- elbenfreund(~elbenfreu@p54B92644.dip.t-dialin.net) has joined #tryton
2011-03-08 22:22 -!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has left #tryton
2011-03-08 22:28 -!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has joined #tryton
2011-03-08 23:15 <serpent213> this is really strange
2011-03-08 23:15 <serpent213> ssl still disabled
2011-03-08 23:15 <serpent213> depending on client os and http client (curl vs wget) the results vary
2011-03-08 23:15 <serpent213> curl@freebsd does work most of the time
2011-03-08 23:16 <serpent213> curl@osx does not
2011-03-08 23:16 <serpent213> wget@osx works a litte better
2011-03-08 23:16 <serpent213> tunneling through ssh makes it always fail
2011-03-08 23:16 <serpent213> failing means "error: [Errno 35] Resource temporarily unavailable", see above
2011-03-08 23:16 <serpent213> ACTION is really puzzled
2011-03-08 23:17 <serpent213> i'll try a linux server setup...
2011-03-08 23:29 <serpent213> p.s.: the davserver command line tool always delivers the expected result -- so it's not PyWebDAV's fault, i guess...
2011-03-08 23:42 -!- elbenfreund1(~elbenfreu@p54B9566C.dip.t-dialin.net) has joined #tryton
2011-03-08 23:55 -!- zodman(~andres-va@gponr9-fija-203-7-69.iusacell.net) has joined #tryton

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!