IRC logs of #tryton for Wednesday, 2010-02-03

chat.freenode.net #tryton log beginning Wed Feb 3 00:00:02 CET 2010
cedkvengfulsquirrel: you will lost the transaction that are running00:00
vengfulsquirrellike database transactions that have not been commited?00:01
vengfulsquirrelI think if the client is just logged in and the user is doing nothing though it prevent a regular kill from killing the server.  So I have to call users and tell them to close the client so I can stop the server.00:02
vengfulsquirrelIs that standard procedure?00:02
cedkvengfulsquirrel: yes commit happens at the end of client request00:02
vengfulsquirrelby regular kill I meant SIGINT I think00:03
cedkvengfulsquirrel: server don't stop only when client requests are running00:03
vengfulsquirrelMaybe they are waiting to login actually.00:04
vengfulsquirrelI've been having weird performance problem.00:04
cedkvengfulsquirrel: with SIGINT, the server will wait until all running request will end00:04
vengfulsquirrelSometimes it takes 5 minutes from opening the client to when you can start typing your password.00:05
cedkvengfulsquirrel: do you have many databases?00:07
vengfulsquirrel1 db00:07
cedkvengfulsquirrel: network issue maybe?00:09
vengfulsquirrelno, restart and uts fine00:09
vengfulsquirrelsuper fast00:09
-!- Kavli(~kavli@kavli-1-pt.tunnel.tserv24.sto1.ipv6.he.net) has joined #tryton00:10
cedkvengfulsquirrel: too much open connection?00:11
cedkvengfulsquirrel: there is a limit to 40 by default00:11
vengfulsquirrel2-3?00:11
cedkvengfulsquirrel: it depends if you have a lot of dead connections00:14
cedkvengfulsquirrel: depending of the OS configuration, the timeout could be long00:14
KavliHello guys. This is probably a question that is asked often here, but how do I bootstrap the database once I've installed the daemon?00:18
KavliI've tried running the daemon (trytond) as the database user, assuming it could do its own bootstrap, but nope.00:18
vengfulsquirrelcedk: I was just doing netstat -atp | grep 8070, is that adequate?00:18
cedkKavli: http://code.google.com/p/tryton/wiki/SetupAndStart00:19
cedkvengfulsquirrel: I think00:19
Kavlicedk: Thanks! This is probably what I've been googling for and missed! I'll check it out!00:20
vengfulsquirrelcedk: Yeah there are less than 5 for sure.00:20
vengfulsquirrelcedk: A user was waiting to login to the server, that seems to be what was keeping SIGINT from succeeding.00:21
vengfulsquirrelcedk: Although there could have been 1 or more terminated clients, will the transaction continue on the server after a user terminates a window?00:22
-!- Kavli(~kavli@kavli-1-pt.tunnel.tserv24.sto1.ipv6.he.net) has left #tryton00:22
cedkvengfulsquirrel: transaction is per user request00:22
cedkvengfulsquirrel: you can see request by starting the client with -v option00:23
vengfulsquirrelRight, so the server is unresponsive and the user is waiting on something for 12 minutes and then they terminate the window.00:23
vengfulsquirrelI'm assuming it was still in a request.00:23
cedkvengfulsquirrel: yes, if you stop it the server will no longer accept new request00:26
vengfulsquirrelcedk: I guess I will have to try and corner the problem.  I just don't understand why I need to restart trytond to make it responsive again.00:49
-!- yangoon(~mathiasb@p549F5EC1.dip.t-dialin.net) has joined #tryton01:32
-!- yangoon(~mathiasb@p549F7259.dip.t-dialin.net) has joined #tryton05:20
-!- udono(~udono@dynamic-unidsl-85-197-16-119.westend.de) has joined #tryton07:15
-!- vengfulsquirrel(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton07:31
-!- Timitos(~timitos@88.217.184.172) has joined #tryton08:18
-!- sharkcz(~ndan@plz1-v-4-17.static.adsl.vol.cz) has joined #tryton08:18
-!- sharoon(~sharoonth@opg066b.halls.manchester.ac.uk) has joined #tryton08:45
-!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton09:03
-!- mfladischer(~fladische@2001:5c0:1505:7e00:68ba:17ff:fe2f:a344) has joined #tryton09:04
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:15
-!- bechamel(~user@host-85-201-159-186.brutele.be) has joined #tryton09:17
-!- sharoon(~sharoonth@opg066b.halls.manchester.ac.uk) has left #tryton11:00
-!- paepke(~paepke@p4FEB3744.dip0.t-ipconnect.de) has joined #tryton12:21
-!- udono(~udono@dynamic-unidsl-85-197-23-179.westend.de) has joined #tryton12:26
-!- udono(~udono@dynamic-unidsl-85-197-18-118.westend.de) has joined #tryton13:13
-!- woakas(~woakas@190.144.69.234) has joined #tryton14:24
-!- sharoon(~sharoonth@opg066b.halls.manchester.ac.uk) has joined #tryton14:37
cedksharoon: have you news for issue 1404?15:34
sharoonthe calendar one, the issue i figured out is caused by my calendar client15:34
sharoonits probably sending in the weong info, now i dont have the issue, but lets check and reopen the issue if it exists15:35
cedksharoon: which client do you use?15:37
sharooncedk: sunbird on windows15:38
cedksharoon: it is strange, sunbird should work correctly15:40
cedksharoon: could you update the issue with yout information and close it if you think it must15:41
sharooncedk: also still i face an issue, when an event/todo is created on client side(sunbird/lightning in thunderbrd), it gets created on tryton but does not get displayed on the client15:42
sharoonclient == subird15:42
cedksharoon: is there a log in server side?15:44
sharooncedk: no15:44
cedksharoon: which version of sunbird?15:46
cedksharoon: and do you use ssl?15:46
sharooncedk: no ssl and 0.915:46
cedksharoon: I had bad experience with sunbird on windows without ssl15:47
sharooncedk: then its known issue15:47
cedksharoon: could you test with ssl to see if it is that15:51
sharooncedk: sure and will let you know15:56
cedksharoon: is your module sale_opportunity available somewhere?16:07
sharooncedk: yes in two version 1_4 and trunk16:08
sharooncedk: its here:16:08
sharoonhttp://mercurial.intuxication.org/hg/sale_opportunity_1_416:08
sharoonhttp://mercurial.intuxication.org/hg/sale_opportunity16:08
sharoonhttp://mercurial.intuxication.org/hg/support_management_1_416:08
cedksharoon: thx16:10
cedksharoon: could you close codereview issue when they are done thx16:27
sharooncedk: sure16:28
sharooncedk: i think most of them are done16:28
cedkTimitos, udono: do you know johbo?16:32
Timitoscedk: yes16:33
cedkTimitos: is he on irc?16:33
Timitoscedk: sometimes. but not today.16:34
cedkTimitos: he wrote the line for the issue140516:34
Timitoscedk: i will send him a message about the issue16:35
cedkTimitos: I'm doing on the issue and add him on it16:36
Timitoscedk: ok16:37
-!- johbo(~joh@statdsl-085-016-072-173.ewe-ip-backbone.de) has joined #tryton16:48
-!- paepke(~paepke@p4FEB3744.dip0.t-ipconnect.de) has left #tryton18:08
-!- panthera(~daniel@static.88-198-196-34.clients.your-server.de) has joined #tryton18:22
-!- enlightx(~enlightx@host-84-223-75-247.cust-adsl.tiscali.it) has joined #tryton18:51
-!- vengfulsquirrel(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton20:04
-!- johbo(~joh@statdsl-085-016-072-173.ewe-ip-backbone.de) has joined #tryton20:06
-!- rednul_(~rednul@host-98-127-54-98.bln-mt.client.bresnan.net) has joined #tryton20:31
-!- LucaSub1(~LucaSub@host187-177-dynamic.9-87-r.retail.telecomitalia.it) has joined #tryton20:44
-!- LucaSub1(~LucaSub@host187-177-dynamic.9-87-r.retail.telecomitalia.it) has left #tryton20:44
-!- vengfulsquirrel(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton21:37
-!- juanfer(~juanfer@190.144.69.234) has joined #tryton22:57
cedksharoon: you should ask to intuxication guys to put your modules into tryton folder23:31
sharooncedk: how do i do that?23:31
cedksharoon: ask her on irc23:31
sharooncedk: ok23:32
sharooncedk: we now have a requirement to do the magento connector which we might prefer to do on tryton23:34
sharooncedk: anything to note, point out, any preferred ways you would recommend?23:35
cedksharoon: there was some work done with satchmo http://code.google.com/hosting/search?q=label:tryton23:35
sharooncedk: we built the new connector API and magento bridge for Open ERP, but a pain to maintain them because of issues in Open ERP..... now that the focus is completely on their 5.2 release it doesnt make sense to give our customers Open ERP.23:37
sharooncedk: and satchmo is not as powerful as magento yet23:37
sharooncedk: magento is a lot of crap but functionally toooo rich and google seems to love it23:37
cedksharoon: I don't know well those softwares but it depends of the needs23:39
cedksharoon: I don't think it is good to choice one only because he has a lot of functionalities23:39
sharooncedk: the need is specific about magento, not our choise :(23:39
sharooncedk: personally i hate PHP and magento and its crappy EAV model on mysql23:40
cedksharoon: the thing I find interesting with satchmo is that it is written in Python and seems to be simple, clean and modular23:40
sharooncedk: i agree and no integration is 100% acheivable, even with open ERP we built up the most complex module and still buggy23:41
sharooncedk: i asked this before, is there any plans for tax_include in taxes?23:42
cedksharoon: be careful when customer talk about technical requirements instead of business requirements23:42
cedksharoon: no tax_include will never work at least like OpenERP does23:42
sharooncedk: ok, it never works there properly ;-)23:43
sharooncedk: are u planning for it in anyway?23:43
cedksharoon: we made a custom module for a customer to import sales from POS, the amount was tax include and we convert it into account move23:44
cedksharoon: so it requires to dispatch rounding error around lines23:45
cedksharoon: no we don't plan any buggy stuffs by design23:45
sharooncedk: this requirement is outside integration, tax inclusive prices are a common requirement right?23:45
cedksharoon: not that way23:46
cedksharoon: like I says tax include comes from POS, so you need to define how you convert into tax exclude amount23:46
cedksharoon: invoice with tax include has no sense23:48
sharooncedk: can you explain because most companies in jurisdictions like ours with taxes quote net prices including VAT23:49
cedksharoon: and again what is the requirements? Why do you want tax include?23:49
sharooncedk: sell at a price inclusive of tax is the requirement and define pricelists inclusive of VAT23:50
cedksharoon: sell like that is for large public (without invoice)23:50
cedksharoon: it is not B2B but B2C23:51
sharooncedk: agree23:51
cedksharoon: so B2C doesn't go into the workflow of sale->shipment->invoice23:51
cedksharoon: it is done by POS23:51
sharooncedk: agree again, so we have a POS?23:51
cedksharoon: so POS->import into Tryton->shipment->account moves23:52
cedksharoon: there is a work: http://code.google.com/p/trytonpos/23:52
cedksharoon: but I don't know where it is23:52
sharooncedk: there's no code23:53
cedksharoon: carlos has work on it but I don't know23:53
cedksharoon: but there is some OpenSource POS23:53
sharooncedk: ok, is carlos in the IRC?23:54
cedksharoon: carlos is also his nickname on irc23:54
sharooncedk: ok, so he' not here now23:54
cedksharoon: and again, it depends of the needs of the POS23:54
cedksharoon: does it need to work on a cash machine?23:55
sharooncedk: Not at all23:55
cedksharoon: how much transaction per day?23:55
cedksharoon: how much POS?23:55
sharooncedk: Its mostly e-commerce orders in existing 5 magento stores, sometimes in addition phone orders23:55
cedksharoon: phone orders can be encoded into magento I guess23:56
cedksharoon: so it is not a POS that you need but an import script that convert sale into shipment and account moves23:56
sharooncedk: mostly yes, but it would be nice to maintain the workflow in tryton, meaning import sale orders as such and process the rest in tryto23:57
cedksharoon: I don't think, if you don't need invoice23:57
sharooncedk: but the problem is customer records will be in teo places, one will have to check both tryton and magento to give a proper answer23:58
cedksharoon: no, create a Model that has the magento information sync23:58
sharooncedk: ok23:58
cedksharoon: and perhaps it can be done with a non SQL Model that will query magento23:59

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