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

chat.freenode.net #tryton log beginning Tue Mar 8 00:00:01 CET 2011
-!- plantian(~ian@c-67-169-72-36.hsd1.ca.comcast.net) has joined #tryton01:03
-!- ikks_(~ikks@190.158.101.218) has joined #tryton01:49
-!- FWiesing(~franz@mail.tryton.at) has left #tryton02:36
-!- zodman(~zodman@foresight/developer/zodman) has joined #tryton03:56
-!- svaksha(~svaksha@unaffiliated/svaksha) has joined #tryton05:06
-!- yangoon(~mathiasb@p549F32CC.dip.t-dialin.net) has joined #tryton05:20
-!- zodman(~zodman@foresight/developer/zodman) has joined #tryton06:20
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton07:18
-!- svaksha(~svaksha@unaffiliated/svaksha) has joined #tryton07:33
-!- Vladimirek(~vladimir@bband-dyn213.178-41-22.t-com.sk) has joined #tryton07:42
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton07:52
-!- gasbakid(~gasbakid@41.96.2.101) has joined #tryton08:16
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton08:35
-!- enlightx(~enlightx@host73-9-dynamic.40-79-r.retail.telecomitalia.it) has joined #tryton09:01
-!- bechamel(~user@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton09:03
-!- elbenfreund(~elbenfreu@p54B92644.dip.t-dialin.net) has joined #tryton09:17
-!- paepke(~paepke@pD9545A77.dip0.t-ipconnect.de) has joined #tryton09:52
-!- nicoe(~nicoe@2001:6f8:3aa:0:217:f2ff:fef3:4e9) has joined #tryton09:53
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton10:13
-!- ikks_(~ikks@190.158.101.218) has joined #tryton10:32
-!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has joined #tryton11:23
-!- paepke(~paepke@pD9544DE5.dip0.t-ipconnect.de) has joined #tryton12:07
-!- Vladimirek(~vladimir@bband-dyn213.178-41-22.t-com.sk) has joined #tryton12:14
-!- sharoon(~sharoon@c-75-74-203-208.hsd1.fl.comcast.net) has joined #tryton13:07
-!- enlightx(~enlightx@host73-9-dynamic.40-79-r.retail.telecomitalia.it) has joined #tryton13:11
-!- hoRn(~chatzilla@pd95be09e.dip0.t-ipconnect.de) has joined #tryton13:16
hoRnhi13:29
hoRnis there a way to debug a  <field name="domain"> statement? or can anybody give me a hint where to put some prints?13:31
cedkhoRn: what is the issue?13:32
hoRncedk: 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 domain13:34
hoRncedk: first try was ("date", ">=", Get(Eval("context", {}), "start_date", False))13:35
-!- cheche(cheche@46.25.80.67) has joined #tryton13:35
cedkhoRn: inside []13:36
hoRncedk: yes - <field name="domain">[("employee", "=", Eval('active_id')), ("date", ">=", Get(Eval("context", {}), "start_date", False))]</field>13:37
hoRncedk: but finally i don't know nothing about the context of the opened view13:38
-!- blast_hardcheese(~blast_har@dsl092-043-124.lax1.dsl.speakeasy.net) has joined #tryton13:39
hoRncedk: will try to print something in the pyson.py of the server13:39
cedkhoRn: just run the client with "-v" option, you will see the domain used13:40
hoRnso i need to install the default - yesterday i patched my client with a lot of stuff ;)13:41
cedkhoRn: I guess it should still work13:45
hoRncedk: btw. - i tried to take a look to the dnd-patch - but the patch doesn't match my local version.13:45
cedkhoRn: it is for the changeset e35ba426dceb13:45
hoRncedk: ok13:46
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton13:57
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 = 114:14
serpent213Exception in thread Thread-96:14:14
serpent213Traceback (most recent call last):14:14
serpent213  File "/usr/local/lib/python2.6/threading.py", line 532, in __bootstrap_inner14:15
serpent213    self.run()14:15
serpent213  File "/usr/local/lib/python2.6/threading.py", line 484, in run14:15
serpent213    self.__target(*self.__args, **self.__kwargs)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_jobs14:15
serpent213    [cron['id']])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 execute14:15
serpent213    res = self.cursor.execute(sql, params)14:15
serpent213TransactionRollbackError: could not serialize access due to concurrent update14:15
serpent213CONTEXT:  SQL statement "SELECT 1 FROM ONLY "public"."res_user" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"14:15
serpent213how come?14:15
serpent213running pgsql 9...14:15
-!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has joined #tryton15:03
cedkserpent213: please don't copy/paste traceback on irc, use tools like pastbin.ca15:27
cedkserpent213: it is just the cron that runs and failed because of concurrency access15:31
serpent213kk15:40
-!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has left #tryton15:53
hoRnif 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?15:53
cedkhoRn: not sure you can15:55
hoRncedk: ok - seems like this15:55
hoRncedk: so i need to set up a new wizzard again15:55
cedkhoRn: from experiences, when you start to need too much context stuff, better to rethink about the design15:56
hoRncedk: the design is broken ;)15:57
hoRncedk: 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 step16:02
cedkhoRn: how can you have overlapping on timesheet.line ?16:04
hoRnwe 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.16:08
cedkhoRn: ok but why do you need to check if it is allow16:10
hoRncedk: 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 employee16:12
hoRncedk: 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 that16:13
cedkhoRn: you should be able to prefill the dates I think16:17
hoRncedk: don't know how. Which object holds the active_id?16:19
cedkhoRn: the one selected16:24
hoRncedk: how you think i can prefill the dates? the context changes because a change the model with the ir.action.keyword ...16:33
cedkhoRn: I don't understand16:35
hoRncedk: I only think out loud ;)16:37
-!- zodman(~andres-va@gponr9-fija-203-7-69.iusacell.net) has joined #tryton16:40
hoRncedk: <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 view16:40
-!- okko1(~okko@87.224.23.163) has joined #tryton16:43
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton16:45
-!- okko1(~okko@87.224.23.163) has joined #tryton16:48
-!- okko2(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton16:52
-!- okko(~okko@87.224.23.163) has joined #tryton16:57
-!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has joined #tryton17:03
-!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has left #tryton17:04
-!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has joined #tryton17:04
-!- gremly(~gremly@200.106.202.91) has joined #tryton17:10
-!- nicoe(~nicoe@2001:6f8:3aa:0:217:f2ff:fef3:4e9) has joined #tryton17:26
-!- Vladimirek(~vladimir@bband-dyn213.178-41-22.t-com.sk) has joined #tryton17:39
-!- bechamel(~user@host-85-201-144-79.brutele.be) has joined #tryton17:45
-!- elbenfreund(~elbenfreu@p54B92644.dip.t-dialin.net) has joined #tryton17:53
-!- enlightx(~enlightx@dynamic-adsl-94-34-234-144.clienti.tiscali.it) has joined #tryton19:18
-!- FWiesing(~franz@mail.tryton.at) has joined #tryton19:26
serpent213any issues known wrt secure webdav?19:50
serpent213http://pastie.org/164834619:50
serpent213server closes the connection just after accepting it19:50
serpent213works w/o ssl19:50
-!- paepke(~paepke@pD9544DE5.dip0.t-ipconnect.de) has left #tryton19:53
udonoserpent213: you have set secure_webdav = True in trytond.conf?20:11
serpent213sure20:13
serpent213if i set it to false and try to access by http, i get back an auth request -- as expected20:13
-!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton20:14
serpent213this is probably rather pyWebDav or pyOpenSSL related than trytond...20:15
udonoserpent213: which tryton vrsion?20:16
udonoserpent213: see also issue 1883...20:17
udonoserpent213: how you generate the key?20:17
udonos/key/certificate/20:18
serpent2131.8.220:19
serpent213CACert20:19
serpent213problem seems to be with the ssl handshake, does not seem to proceed to webdav20:21
serpent213when connecting with telnet the connection is closed immediately, instead of waiting for data20:22
serpent213i guess i could put it behind a reverse proxy doing ssl...20:30
-!- bechamel(~user@host-85-201-144-79.brutele.be) has joined #tryton20:31
udonoserpent213: as far as I can tell you, for me it works with self-signed cert and cadaver as a client.20:31
udonoserpent213: maybe try to introspect the communication with wireshark/tcpdump20:33
cedkserpent213: which version of PyWebDAV ?20:35
serpent213cedk: 0.9.4.120:39
serpent213now, without ssl, i sometimes get http://pastie.org/164854720:41
serpent213and sometimes an auth request...20:42
serpent213btw, ssl works fine for netrpc using the same cert20:45
cedkserpent213: are you under OSX ?20:53
serpent213cedk: client is os x, server is a freebsd jail20:58
cedkserpent213: perhaps linked to http://bugs.python.org/issue849320:59
-!- zodman(~andres-va@gponr9-fija-203-7-69.iusacell.net) has joined #tryton21:20
-!- trifon(~trifon@83.228.98.255) has joined #tryton21:35
-!- paepke(~paepke@pD9545ECE.dip.t-dialin.net) has joined #tryton21:37
-!- elbenfreund(~elbenfreu@p54B92644.dip.t-dialin.net) has joined #tryton21:40
-!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has left #tryton22:22
-!- sharoon(~sharoon@173-162-112-230-miami.hfc.comcastbusiness.net) has joined #tryton22:28
serpent213this is really strange23:15
serpent213ssl still disabled23:15
serpent213depending on client os and http client (curl vs wget) the results vary23:15
serpent213curl@freebsd does work most of the time23:15
serpent213curl@osx does not23:16
serpent213wget@osx works a litte better23:16
serpent213tunneling through ssh makes it always fail23:16
serpent213failing means "error: [Errno 35] Resource temporarily unavailable", see above23:16
serpent213ACTION is really puzzled23:16
serpent213i'll try a linux server setup...23:17
serpent213p.s.: the davserver command line tool always delivers the expected result -- so it's not PyWebDAV's fault, i guess...23:29
-!- elbenfreund1(~elbenfreu@p54B9566C.dip.t-dialin.net) has joined #tryton23:42
-!- zodman(~andres-va@gponr9-fija-203-7-69.iusacell.net) has joined #tryton23:55

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!