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

chat.freenode.net #tryton log beginning Wed Feb 3 00:00:02 CET 2010
2010-02-03 00:00 <cedk> vengfulsquirrel: you will lost the transaction that are running
2010-02-03 00:01 <vengfulsquirrel> like database transactions that have not been commited?
2010-02-03 00:02 <vengfulsquirrel> I 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.
2010-02-03 00:02 <vengfulsquirrel> Is that standard procedure?
2010-02-03 00:02 <cedk> vengfulsquirrel: yes commit happens at the end of client request
2010-02-03 00:03 <vengfulsquirrel> by regular kill I meant SIGINT I think
2010-02-03 00:03 <cedk> vengfulsquirrel: server don't stop only when client requests are running
2010-02-03 00:04 <vengfulsquirrel> Maybe they are waiting to login actually.
2010-02-03 00:04 <vengfulsquirrel> I've been having weird performance problem.
2010-02-03 00:04 <cedk> vengfulsquirrel: with SIGINT, the server will wait until all running request will end
2010-02-03 00:05 <vengfulsquirrel> Sometimes it takes 5 minutes from opening the client to when you can start typing your password.
2010-02-03 00:07 <cedk> vengfulsquirrel: do you have many databases?
2010-02-03 00:07 <vengfulsquirrel> 1 db
2010-02-03 00:09 <cedk> vengfulsquirrel: network issue maybe?
2010-02-03 00:09 <vengfulsquirrel> no, restart and uts fine
2010-02-03 00:09 <vengfulsquirrel> super fast
2010-02-03 00:10 -!- Kavli(~kavli@kavli-1-pt.tunnel.tserv24.sto1.ipv6.he.net) has joined #tryton
2010-02-03 00:11 <cedk> vengfulsquirrel: too much open connection?
2010-02-03 00:11 <cedk> vengfulsquirrel: there is a limit to 40 by default
2010-02-03 00:11 <vengfulsquirrel> 2-3?
2010-02-03 00:14 <cedk> vengfulsquirrel: it depends if you have a lot of dead connections
2010-02-03 00:14 <cedk> vengfulsquirrel: depending of the OS configuration, the timeout could be long
2010-02-03 00:18 <Kavli> Hello guys. This is probably a question that is asked often here, but how do I bootstrap the database once I've installed the daemon?
2010-02-03 00:18 <Kavli> I've tried running the daemon (trytond) as the database user, assuming it could do its own bootstrap, but nope.
2010-02-03 00:18 <vengfulsquirrel> cedk: I was just doing netstat -atp | grep 8070, is that adequate?
2010-02-03 00:19 <cedk> Kavli: http://code.google.com/p/tryton/wiki/SetupAndStart
2010-02-03 00:19 <cedk> vengfulsquirrel: I think
2010-02-03 00:20 <Kavli> cedk: Thanks! This is probably what I've been googling for and missed! I'll check it out!
2010-02-03 00:20 <vengfulsquirrel> cedk: Yeah there are less than 5 for sure.
2010-02-03 00:21 <vengfulsquirrel> cedk: A user was waiting to login to the server, that seems to be what was keeping SIGINT from succeeding.
2010-02-03 00:22 <vengfulsquirrel> cedk: Although there could have been 1 or more terminated clients, will the transaction continue on the server after a user terminates a window?
2010-02-03 00:22 -!- Kavli(~kavli@kavli-1-pt.tunnel.tserv24.sto1.ipv6.he.net) has left #tryton
2010-02-03 00:22 <cedk> vengfulsquirrel: transaction is per user request
2010-02-03 00:23 <cedk> vengfulsquirrel: you can see request by starting the client with -v option
2010-02-03 00:23 <vengfulsquirrel> Right, so the server is unresponsive and the user is waiting on something for 12 minutes and then they terminate the window.
2010-02-03 00:23 <vengfulsquirrel> I'm assuming it was still in a request.
2010-02-03 00:26 <cedk> vengfulsquirrel: yes, if you stop it the server will no longer accept new request
2010-02-03 00:49 <vengfulsquirrel> cedk: 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.
2010-02-03 01:32 -!- yangoon(~mathiasb@p549F5EC1.dip.t-dialin.net) has joined #tryton
2010-02-03 05:20 -!- yangoon(~mathiasb@p549F7259.dip.t-dialin.net) has joined #tryton
2010-02-03 07:15 -!- udono(~udono@dynamic-unidsl-85-197-16-119.westend.de) has joined #tryton
2010-02-03 07:31 -!- vengfulsquirrel(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton
2010-02-03 08:18 -!- Timitos(~timitos@88.217.184.172) has joined #tryton
2010-02-03 08:18 -!- sharkcz(~ndan@plz1-v-4-17.static.adsl.vol.cz) has joined #tryton
2010-02-03 08:45 -!- sharoon(~sharoonth@opg066b.halls.manchester.ac.uk) has joined #tryton
2010-02-03 09:03 -!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton
2010-02-03 09:04 -!- mfladischer(~fladische@2001:5c0:1505:7e00:68ba:17ff:fe2f:a344) has joined #tryton
2010-02-03 09:15 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2010-02-03 09:17 -!- bechamel(~user@host-85-201-159-186.brutele.be) has joined #tryton
2010-02-03 11:00 -!- sharoon(~sharoonth@opg066b.halls.manchester.ac.uk) has left #tryton
2010-02-03 12:21 -!- paepke(~paepke@p4FEB3744.dip0.t-ipconnect.de) has joined #tryton
2010-02-03 12:26 -!- udono(~udono@dynamic-unidsl-85-197-23-179.westend.de) has joined #tryton
2010-02-03 13:13 -!- udono(~udono@dynamic-unidsl-85-197-18-118.westend.de) has joined #tryton
2010-02-03 14:24 -!- woakas(~woakas@190.144.69.234) has joined #tryton
2010-02-03 14:37 -!- sharoon(~sharoonth@opg066b.halls.manchester.ac.uk) has joined #tryton
2010-02-03 15:34 <cedk> sharoon: have you news for issue 1404?
2010-02-03 15:34 <sharoon> the calendar one, the issue i figured out is caused by my calendar client
2010-02-03 15:35 <sharoon> its probably sending in the weong info, now i dont have the issue, but lets check and reopen the issue if it exists
2010-02-03 15:37 <cedk> sharoon: which client do you use?
2010-02-03 15:38 <sharoon> cedk: sunbird on windows
2010-02-03 15:40 <cedk> sharoon: it is strange, sunbird should work correctly
2010-02-03 15:41 <cedk> sharoon: could you update the issue with yout information and close it if you think it must
2010-02-03 15:42 <sharoon> cedk: 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 client
2010-02-03 15:42 <sharoon> client == subird
2010-02-03 15:44 <cedk> sharoon: is there a log in server side?
2010-02-03 15:44 <sharoon> cedk: no
2010-02-03 15:46 <cedk> sharoon: which version of sunbird?
2010-02-03 15:46 <cedk> sharoon: and do you use ssl?
2010-02-03 15:46 <sharoon> cedk: no ssl and 0.9
2010-02-03 15:47 <cedk> sharoon: I had bad experience with sunbird on windows without ssl
2010-02-03 15:47 <sharoon> cedk: then its known issue
2010-02-03 15:51 <cedk> sharoon: could you test with ssl to see if it is that
2010-02-03 15:56 <sharoon> cedk: sure and will let you know
2010-02-03 16:07 <cedk> sharoon: is your module sale_opportunity available somewhere?
2010-02-03 16:08 <sharoon> cedk: yes in two version 1_4 and trunk
2010-02-03 16:08 <sharoon> cedk: its here:
2010-02-03 16:08 <sharoon> http://mercurial.intuxication.org/hg/sale_opportunity_1_4
2010-02-03 16:08 <sharoon> http://mercurial.intuxication.org/hg/sale_opportunity
2010-02-03 16:08 <sharoon> http://mercurial.intuxication.org/hg/support_management_1_4
2010-02-03 16:10 <cedk> sharoon: thx
2010-02-03 16:27 <cedk> sharoon: could you close codereview issue when they are done thx
2010-02-03 16:28 <sharoon> cedk: sure
2010-02-03 16:28 <sharoon> cedk: i think most of them are done
2010-02-03 16:32 <cedk> Timitos, udono: do you know johbo?
2010-02-03 16:33 <Timitos> cedk: yes
2010-02-03 16:33 <cedk> Timitos: is he on irc?
2010-02-03 16:34 <Timitos> cedk: sometimes. but not today.
2010-02-03 16:34 <cedk> Timitos: he wrote the line for the issue1405
2010-02-03 16:35 <Timitos> cedk: i will send him a message about the issue
2010-02-03 16:36 <cedk> Timitos: I'm doing on the issue and add him on it
2010-02-03 16:37 <Timitos> cedk: ok
2010-02-03 16:48 -!- johbo(~joh@statdsl-085-016-072-173.ewe-ip-backbone.de) has joined #tryton
2010-02-03 18:08 -!- paepke(~paepke@p4FEB3744.dip0.t-ipconnect.de) has left #tryton
2010-02-03 18:22 -!- panthera(~daniel@static.88-198-196-34.clients.your-server.de) has joined #tryton
2010-02-03 18:51 -!- enlightx(~enlightx@host-84-223-75-247.cust-adsl.tiscali.it) has joined #tryton
2010-02-03 20:04 -!- vengfulsquirrel(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton
2010-02-03 20:06 -!- johbo(~joh@statdsl-085-016-072-173.ewe-ip-backbone.de) has joined #tryton
2010-02-03 20:31 -!- rednul_(~rednul@host-98-127-54-98.bln-mt.client.bresnan.net) has joined #tryton
2010-02-03 20:44 -!- LucaSub1(~LucaSub@host187-177-dynamic.9-87-r.retail.telecomitalia.it) has joined #tryton
2010-02-03 20:44 -!- LucaSub1(~LucaSub@host187-177-dynamic.9-87-r.retail.telecomitalia.it) has left #tryton
2010-02-03 21:37 -!- vengfulsquirrel(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton
2010-02-03 22:57 -!- juanfer(~juanfer@190.144.69.234) has joined #tryton
2010-02-03 23:31 <cedk> sharoon: you should ask to intuxication guys to put your modules into tryton folder
2010-02-03 23:31 <sharoon> cedk: how do i do that?
2010-02-03 23:31 <cedk> sharoon: ask her on irc
2010-02-03 23:32 <sharoon> cedk: ok
2010-02-03 23:34 <sharoon> cedk: we now have a requirement to do the magento connector which we might prefer to do on tryton
2010-02-03 23:35 <sharoon> cedk: anything to note, point out, any preferred ways you would recommend?
2010-02-03 23:35 <cedk> sharoon: there was some work done with satchmo http://code.google.com/hosting/search?q=label:tryton
2010-02-03 23:37 <sharoon> cedk: 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.
2010-02-03 23:37 <sharoon> cedk: and satchmo is not as powerful as magento yet
2010-02-03 23:37 <sharoon> cedk: magento is a lot of crap but functionally toooo rich and google seems to love it
2010-02-03 23:39 <cedk> sharoon: I don't know well those softwares but it depends of the needs
2010-02-03 23:39 <cedk> sharoon: I don't think it is good to choice one only because he has a lot of functionalities
2010-02-03 23:39 <sharoon> cedk: the need is specific about magento, not our choise :(
2010-02-03 23:40 <sharoon> cedk: personally i hate PHP and magento and its crappy EAV model on mysql
2010-02-03 23:40 <cedk> sharoon: the thing I find interesting with satchmo is that it is written in Python and seems to be simple, clean and modular
2010-02-03 23:41 <sharoon> cedk: i agree and no integration is 100% acheivable, even with open ERP we built up the most complex module and still buggy
2010-02-03 23:42 <sharoon> cedk: i asked this before, is there any plans for tax_include in taxes?
2010-02-03 23:42 <cedk> sharoon: be careful when customer talk about technical requirements instead of business requirements
2010-02-03 23:42 <cedk> sharoon: no tax_include will never work at least like OpenERP does
2010-02-03 23:43 <sharoon> cedk: ok, it never works there properly ;-)
2010-02-03 23:43 <sharoon> cedk: are u planning for it in anyway?
2010-02-03 23:44 <cedk> sharoon: we made a custom module for a customer to import sales from POS, the amount was tax include and we convert it into account move
2010-02-03 23:45 <cedk> sharoon: so it requires to dispatch rounding error around lines
2010-02-03 23:45 <cedk> sharoon: no we don't plan any buggy stuffs by design
2010-02-03 23:45 <sharoon> cedk: this requirement is outside integration, tax inclusive prices are a common requirement right?
2010-02-03 23:46 <cedk> sharoon: not that way
2010-02-03 23:46 <cedk> sharoon: like I says tax include comes from POS, so you need to define how you convert into tax exclude amount
2010-02-03 23:48 <cedk> sharoon: invoice with tax include has no sense
2010-02-03 23:49 <sharoon> cedk: can you explain because most companies in jurisdictions like ours with taxes quote net prices including VAT
2010-02-03 23:49 <cedk> sharoon: and again what is the requirements? Why do you want tax include?
2010-02-03 23:50 <sharoon> cedk: sell at a price inclusive of tax is the requirement and define pricelists inclusive of VAT
2010-02-03 23:50 <cedk> sharoon: sell like that is for large public (without invoice)
2010-02-03 23:51 <cedk> sharoon: it is not B2B but B2C
2010-02-03 23:51 <sharoon> cedk: agree
2010-02-03 23:51 <cedk> sharoon: so B2C doesn't go into the workflow of sale->shipment->invoice
2010-02-03 23:51 <cedk> sharoon: it is done by POS
2010-02-03 23:51 <sharoon> cedk: agree again, so we have a POS?
2010-02-03 23:52 <cedk> sharoon: so POS->import into Tryton->shipment->account moves
2010-02-03 23:52 <cedk> sharoon: there is a work: http://code.google.com/p/trytonpos/
2010-02-03 23:52 <cedk> sharoon: but I don't know where it is
2010-02-03 23:53 <sharoon> cedk: there's no code
2010-02-03 23:53 <cedk> sharoon: carlos has work on it but I don't know
2010-02-03 23:53 <cedk> sharoon: but there is some OpenSource POS
2010-02-03 23:54 <sharoon> cedk: ok, is carlos in the IRC?
2010-02-03 23:54 <cedk> sharoon: carlos is also his nickname on irc
2010-02-03 23:54 <sharoon> cedk: ok, so he' not here now
2010-02-03 23:54 <cedk> sharoon: and again, it depends of the needs of the POS
2010-02-03 23:55 <cedk> sharoon: does it need to work on a cash machine?
2010-02-03 23:55 <sharoon> cedk: Not at all
2010-02-03 23:55 <cedk> sharoon: how much transaction per day?
2010-02-03 23:55 <cedk> sharoon: how much POS?
2010-02-03 23:55 <sharoon> cedk: Its mostly e-commerce orders in existing 5 magento stores, sometimes in addition phone orders
2010-02-03 23:56 <cedk> sharoon: phone orders can be encoded into magento I guess
2010-02-03 23:56 <cedk> sharoon: so it is not a POS that you need but an import script that convert sale into shipment and account moves
2010-02-03 23:57 <sharoon> cedk: mostly yes, but it would be nice to maintain the workflow in tryton, meaning import sale orders as such and process the rest in tryto
2010-02-03 23:57 <cedk> sharoon: I don't think, if you don't need invoice
2010-02-03 23:58 <sharoon> cedk: but the problem is customer records will be in teo places, one will have to check both tryton and magento to give a proper answer
2010-02-03 23:58 <cedk> sharoon: no, create a Model that has the magento information sync
2010-02-03 23:58 <sharoon> cedk: ok
2010-02-03 23:59 <cedk> sharoon: and perhaps it can be done with a non SQL Model that will query magento

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