IRC logs of #tryton for Wednesday, 2014-09-10

chat.freenode.net #tryton log beginning Wed Sep 10 00:00:01 CEST 2014
2014-09-10 00:05 -!- pokoli(~pokoli@unaffiliated/pokoli) has joined #tryton
2014-09-10 02:49 -!- gremly(~gremly@190.85.36.58) has joined #tryton
2014-09-10 03:13 -!- alisonken1lap3(~alisonken@pool-71-104-227-211.lsanca.dsl-w.verizon.net) has joined #tryton
2014-09-10 06:02 -!- digitalsatori(~Thunderbi@180.157.156.202) has joined #tryton
2014-09-10 06:08 -!- digitalsatori(~Thunderbi@180.157.156.202) has joined #tryton
2014-09-10 06:24 -!- digitalsatori(~Thunderbi@180.157.156.202) has joined #tryton
2014-09-10 06:41 -!- frispete_(~frispete@p54A920D7.dip0.t-ipconnect.de) has joined #tryton
2014-09-10 07:02 -!- yangoon1(~mathiasb@p549F125F.dip0.t-ipconnect.de) has joined #tryton
2014-09-10 07:21 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton
2014-09-10 07:42 -!- nicoe(~nicoe@222.126-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton
2014-09-10 07:52 -!- nicoe_(~nicoe@91.179.36.174) has joined #tryton
2014-09-10 08:00 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton
2014-09-10 08:12 -!- nicoe_(~nicoe@91.179.36.181) has joined #tryton
2014-09-10 08:15 -!- grasbauer(~Thunderbi@ip92340dc6.dynamic.kabel-deutschland.de) has joined #tryton
2014-09-10 08:31 -!- marius_(~marius@v100.nfq.lt) has joined #tryton
2014-09-10 08:50 -!- nicoe(~nicoe@91.179.55.1) has joined #tryton
2014-09-10 08:57 -!- jeancavallo1(~giovanni@bob75-9-88-181-2-176.fbx.proxad.net) has joined #tryton
2014-09-10 08:57 -!- jeancavallo(~giovanni@bob75-9-88-181-2-176.fbx.proxad.net) has joined #tryton
2014-09-10 09:08 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-09-10 09:19 -!- jeancavallo(~giovanni@bob75-9-88-181-2-176.fbx.proxad.net) has joined #tryton
2014-09-10 09:19 -!- jeancavallo1(~giovanni@bob75-9-88-181-2-176.fbx.proxad.net) has joined #tryton
2014-09-10 09:22 -!- rpit(~ralf@dslb-088-070-130-055.088.070.pools.vodafone-ip.de) has joined #tryton
2014-09-10 09:27 -!- vcardon(~vcardon@bureau-sdsl.tranquil.it) has joined #tryton
2014-09-10 09:31 -!- prksh(~prksh@198.61.199.179) has joined #tryton
2014-09-10 09:38 -!- rpit(~ralf@dslb-088-070-130-055.088.070.pools.vodafone-ip.de) has joined #tryton
2014-09-10 09:40 -!- nicoe_(~nicoe@91.179.61.232) has joined #tryton
2014-09-10 09:55 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has joined #tryton
2014-09-10 10:34 -!- ytz(~textual@opfw01.options-it.com) has joined #tryton
2014-09-10 10:39 -!- nicoe_(~nicoe@109.133.135.53) has joined #tryton
2014-09-10 10:40 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton
2014-09-10 10:48 -!- ytz(~textual@opfw01.options-it.com) has joined #tryton
2014-09-10 11:04 -!- grasbauer(~Thunderbi@ip92340dc6.dynamic.kabel-deutschland.de) has joined #tryton
2014-09-10 11:06 <grasbauer> ACTION Sublab confirmed as Location for Sprints and Breakfast at Unconference/Sunday
2014-09-10 11:07 <pokoli> grasbauer: there are beers for breakfast??? ;)
2014-09-10 11:08 <grasbauer> pokoli: of course!
2014-09-10 11:10 <grasbauer> pokoli: there is a 3d printer
2014-09-10 11:11 <pokoli> grasbauer: so I can print beers? amazing :P
2014-09-10 11:12 <nicoe_> :D
2014-09-10 11:12 -!- VaticanCameos(~pritishc@122.177.212.125) has joined #tryton
2014-09-10 11:19 <grasbauer> nicoe_: btw - did you benchmarks withtryton client and gtk3
2014-09-10 11:19 <grasbauer> ?
2014-09-10 11:20 <nicoe_> grasbauer: not yet
2014-09-10 11:20 <grasbauer> nicoe_: because on arm the performance of gtk2 is poor - mostly addText
2014-09-10 11:22 <grasbauer> nicoe_: did a gtkperf and combobox and addText are the bottlenecks
2014-09-10 11:26 <grasbauer> nicoe_: need to check what is the diffrence between chromebook and banana pi - gtkperf on chtomebook with default setings: 11s - on banana 32s
2014-09-10 11:27 <nicoe_> And with gtk3 the perfs were better?
2014-09-10 11:27 <grasbauer> nicoe_: didn't check yet
2014-09-10 11:31 -!- vcardon(~vcardon@bureau-sdsl.tranquil.it) has joined #tryton
2014-09-10 11:37 <grasbauer> nicoe_: possibly the difference between ARM Mali-T604 and Mali-400 MP is significant - but on the presentation yesterday I decided to start Tryton via X2Go because of the slow rendering ... yesterday our client had an audit as supplier for Airbus - one point without issues: software integration - a guy told me, that he would love to use a system like tryton - "We are using SAP and it sucks" ;)
2014-09-10 11:43 <nicoe_> grasbauer: That's great :D
2014-09-10 11:44 <cedk> grasbauer: what do you mean by addText?
2014-09-10 11:45 <grasbauer> cedk: GtkTextView - Add text - time: 0,58 here on my chromebook - on banana pi it takes 4,XX
2014-09-10 11:47 <cedk> grasbauer: there is no such method as "add text" on TextView
2014-09-10 11:51 <grasbauer> cedk: this check only renders text to a box and is slooooooooow - need to investigate - but the gtk rendering on banana pi is a pain
2014-09-10 11:52 <cedk> grasbauer: I don't understand
2014-09-10 11:53 <grasbauer> cedk: this is chromebook http://pastebin.com/vaCdPX1g
2014-09-10 11:55 <grasbauer> cedk: on banana it takes 37s - so tryton looks like responding slow, but it's a rendering issue
2014-09-10 11:56 <cedk> grasbauer: do you have 2d acceleration?
2014-09-10 11:59 <grasbauer> cedk: don't know - set up X, xfce with a lightweight theme and run in this issue - I was in hurry and haven't the time to investigate in deep - but out of the box tryton was near unusable
2014-09-10 12:01 <cedk> grasbauer: for me, it looks like you get a plain old vesa driver
2014-09-10 12:02 <grasbauer> cedk: i think its fbdev
2014-09-10 12:04 <cedk> grasbauer: I even think it is not GTK that is slow but pango
2014-09-10 12:04 <grasbauer> cedk: possibly - it's doing the font rendering, right?
2014-09-10 12:06 <cedk> grasbauer: yes
2014-09-10 12:07 <cedk> grasbauer: also you should check glx, with glxinfo
2014-09-10 12:08 -!- prksh(~prksh@198.61.199.179) has joined #tryton
2014-09-10 12:09 -!- nicoe_(~nicoe@109.133.143.137) has joined #tryton
2014-09-10 12:11 <grasbauer> cedk: I will do some tests and report the results - or better I send you a banana for free ;)
2014-09-10 12:31 <marius_> is it possible to reconcile payable and receivable accounts?
2014-09-10 12:31 <marius_> what's the proper way of doing that?
2014-09-10 12:32 <cedk> marius_: under "Financial>Entries>Reconcile lines"
2014-09-10 12:33 <marius_> cedk, I have to select an account there
2014-09-10 12:33 <marius_> so after I select it, I don't see payable lines when looking at receivable, etc
2014-09-10 12:34 <pokoli> marius_: so you want to reconcile a payable with a receivable?
2014-09-10 12:34 <marius_> yeah, something like that
2014-09-10 12:34 <marius_> I don't know what's the proper way of doing that
2014-09-10 12:35 <pokoli> marius_: so to do it correctly, you have to create a move, from payable to receivable (to move the balance)
2014-09-10 12:35 <pokoli> marius_: and the reconcile both (payable with payable, receivable with receivable)
2014-09-10 12:35 <pokoli> marius_: this gives the full traceability
2014-09-10 12:35 <cedk> marius_: you must create a move between the two accounts
2014-09-10 12:36 <cedk> such case should really be rare
2014-09-10 12:37 <cedk> maybe you can reconcile the line alone and put the write-off to the other account and than reconcile with the new line
2014-09-10 12:40 <marius_> I lose party on account_move when writing off
2014-09-10 12:40 <marius_> cedk, I have some parties which both buy from me and I sell to them ;)
2014-09-10 12:41 <cedk> marius_: for the exact same amount?
2014-09-10 12:42 <cedk> marius_: at the exact same date?
2014-09-10 12:43 <marius_> not for the same amount, not for the same date
2014-09-10 12:44 <cedk> marius_: so they can not be reconciled
2014-09-10 12:45 <marius_> so whats the right way of using receivables as payments and the other way around?
2014-09-10 12:45 <cedk> marius_: I don't understand what you want
2014-09-10 12:47 <pokoli> marius_: so you want to balance the payments, and only pay the diferens between what you sold and what you bought?
2014-09-10 12:47 <marius_> pokoli, yes
2014-09-10 12:48 <cedk> marius_: look at the party and make a payment of the difference between both amount
2014-09-10 12:49 <pokoli> marius_: I think we have a wizard for this, but I don't remember on which module
2014-09-10 12:50 <cedk> pokoli: probably it could land in std
2014-09-10 12:51 <pokoli> cedk: we have a lot of fields that don't exist on std, but I will try to find it and open an issue to add it to standard account
2014-09-10 12:51 <cedk> but the difficulty will be later when receiving the bank statement because you will have to split lines
2014-09-10 12:51 <cedk> pokoli: you have a lot of non std field in the accounting
2014-09-10 12:51 <cedk> pokoli: this sounds very bad
2014-09-10 12:51 <pokoli> cedk: for example, payment_type, bank_account, and so
2014-09-10 12:53 <pokoli> cedk: this is the wizard https://bitbucket.org/trytonspain/trytond-account_bank/src/f7dd8a50e3053671bcb92634e1b3543c126d2686/account.py?at=default#cl-435
2014-09-10 12:53 <cedk> pokoli: ha yes the out of mind fields
2014-09-10 12:54 <cedk> pokoli: all things that has nothing to do in accounting
2014-09-10 12:55 <pokoli> cedk: won't discuss about that ;)
2014-09-10 12:55 <pokoli> cedk: so if we remove all this "out of mind fields" we can introduce this in std?
2014-09-10 13:03 -!- prksh(~prksh@198.61.199.179) has joined #tryton
2014-09-10 13:03 <cedk> pokoli: no, I mean it must create a payment
2014-09-10 13:05 <pokoli> cedk: currently we only create move_line, so the payment can be manually created from there
2014-09-10 13:06 <pokoli> cedk: so when importing the bank statement you have the correct line with the amount
2014-09-10 13:06 <pokoli> cedk: and all the old lines get reconciled
2014-09-10 13:08 <cedk> pokoli: except that you reconcile before doing the payment
2014-09-10 13:09 <cedk> pokoli: and account_payment add a payment field on statement for reconciliation
2014-09-10 13:09 <pokoli> cedk: yes, but the result of the wizard is a new move line which is not reconciled + all the reconciled ones, so the amount is the same, but grouped in one line
2014-09-10 13:11 -!- mariomop(~quassel@host223.190-229-210.telecom.net.ar) has joined #tryton
2014-09-10 13:11 <cedk> pokoli: yes but the invoices linked are marked as paid
2014-09-10 13:12 <cedk> pokoli: I always found wrong to modify the accounting for operational facilities
2014-09-10 13:13 -!- smarro(~sebastian@190.105.93.196) has joined #tryton
2014-09-10 13:13 <pokoli> cedk: yes, invoiced are marked as paid
2014-09-10 13:14 <cedk> pokoli: so -> wrong
2014-09-10 13:16 <pokoli> cedk: yes and not
2014-09-10 13:16 <pokoli> cedk: as some invoices are paid, but others not
2014-09-10 13:16 <pokoli> cedk: so the only way to do it right is to do it manually
2014-09-10 13:16 -!- marius_(~marius@v100.nfq.lt) has joined #tryton
2014-09-10 13:20 <cedk> pokoli: no the right way is the make a payment (with clearing)
2014-09-10 13:20 <cedk> pokoli: and such payment clearing move should reconcile once succeed
2014-09-10 13:23 <pokoli> cedk: so basically the PayLine wizard, should be able to group payments by some criteria
2014-09-10 13:24 <pokoli> cedk: but the payment has a link with only one move (which is right), so how to keep the link between all the compensated moves and the payment?
2014-09-10 13:24 <cedk> pokoli: no it should not group payments
2014-09-10 13:26 <pokoli> cedk: so I don't understand you
2014-09-10 13:27 <pokoli> marius_: you requirement is to only send one line to the bank? The amount of this line will be the diference between payables and receivables, isn't it?
2014-09-10 13:32 <cedk> pokoli: grouping payments has no meaning
2014-09-10 13:32 <cedk> pokoli: you want to have only one payment not many grouped
2014-09-10 13:33 <pokoli> cedk: Yes, one payment with the diference amount, so I don't understand how you will manage to renconcile all the invoices when the payment has succeed
2014-09-10 13:34 <cedk> pokoli: I don't know but it is the goal
2014-09-10 13:34 <cedk> pokoli: otherwise your design is a failure if something goes wrong
2014-09-10 13:35 <pokoli> cedk: yes from the invoicing point of view, not for the accounting point of view
2014-09-10 13:35 <pokoli> cedk: as you will still have on move with the pending amount
2014-09-10 13:35 <cedk> pokoli: I want both point of view
2014-09-10 13:36 <cedk> pokoli: yes but it breaks all the other modules like dunning, account_invoice, sale, purchase etc.
2014-09-10 13:37 <pokoli> cedk: understood, so I see your point
2014-09-10 13:39 <marius_> pokoli, yes
2014-09-10 13:39 <pokoli> marius_: so with the solution I explained you will have all the invoices marked as paid
2014-09-10 13:40 <pokoli> marius_: which is not the reality, as there is some diference that must be paid
2014-09-10 13:41 <pokoli> marius_: if it's right for you, just create the intermediate move and go ahead
2014-09-10 13:43 <marius_> pokoli, you mean between receivable account and payable account?
2014-09-10 13:43 <pokoli> marius_: yes, so you move the payable amounts to the receivable ones for example
2014-09-10 13:44 <marius_> ok, thanks
2014-09-10 13:49 -!- kstenger(~karla@200.124.209.158) has joined #tryton
2014-09-10 13:53 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton
2014-09-10 13:58 -!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton
2014-09-10 14:05 <cedk> pokoli: maybe if we could have a way in case of payment failure to completly delete this grouped move
2014-09-10 14:09 -!- vcardon(~vcardon@bureau-sdsl.tranquil.it) has joined #tryton
2014-09-10 14:57 -!- moldy(~asdf@unaffiliated/moldy) has joined #tryton
2014-09-10 14:57 <moldy> hi
2014-09-10 15:14 <marius_> hey
2014-09-10 15:18 -!- alisonken1home(~alisonken@pool-71-104-227-211.lsanca.dsl-w.verizon.net) has joined #tryton
2014-09-10 15:19 -!- smarro(~sebastian@181.47.135.16) has joined #tryton
2014-09-10 15:20 -!- alisonken1home(~alisonken@pool-71-104-227-211.lsanca.dsl-w.verizon.net) has joined #tryton
2014-09-10 15:20 <pokoli> cedk: why we can not delete a failed payment?
2014-09-10 15:25 <pokoli> cedk: sorry, you talk about the move, so you can unreconcile it, and then create another move using the same origins (so invoices are marked as pending another time)
2014-09-10 15:27 <cedk> pokoli: doesn't work because you can not be sure the the account of the invoice will match the not reconciled account of your new move
2014-09-10 15:27 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton
2014-09-10 15:27 <cedk> pokoli: I mean indeed it is not a problem if invoice is marked as paid during the payment process
2014-09-10 15:28 <cedk> pokoli: but at the end, if the payment fails, the invoice must be back to validated
2014-09-10 15:29 <pokoli> cedk: i was thinking, that the move must be related to only one invoice, So if we fill the origin all will work as expected
2014-09-10 15:30 <pokoli> cedk: so the user must select an invoice to relate the resulting, if some of the moves are related to an invoice
2014-09-10 15:31 <pokoli> cedk: so in this case, all the compensated invoices will be marked as paid, and you will only have one invoice that have some part (or the total) pending to pay
2014-09-10 15:32 <cedk> pokoli: sounds like a dirty hack
2014-09-10 15:32 <cedk> pokoli: more over how do you cancel such things
2014-09-10 15:34 <pokoli> cedk: invoices has a many2one to moves and we may change this to a one2Many field, so you can modify the lines to pay by creating new moves related to the invoice
2014-09-10 15:35 <pokoli> cedk: so to cancel you can delete the new created moves (or create a compensation moves if not possible to delete)
2014-09-10 15:36 <cedk> pokoli: why not but doesn't fix the original issue
2014-09-10 15:37 -!- mfladischer(~fladische@eduroam-240-223.wlan.univie.ac.at) has joined #tryton
2014-09-10 15:37 <pokoli> cedk: why you don't fix the original issue?
2014-09-10 15:38 <pokoli> s/you/it/
2014-09-10 15:40 <cedk> pokoli: OK in some way, but you still need something to create the move and do all the linking
2014-09-10 15:40 <cedk> also I'm not sure you can have an invoice doing more than 1 move
2014-09-10 15:41 <moldy> i am considering giving tryton a try at my company sometime soon
2014-09-10 15:41 <moldy> i read that it does not really support serial numbers, is that still true?
2014-09-10 15:42 <cedk> pokoli: what about, creating the grouping move with reonciliation etc.
2014-09-10 15:42 <cedk> pokoli: using a special journal for that
2014-09-10 15:42 <pokoli> cedk: I'm not sure about the invoice doing more than one move too
2014-09-10 15:42 <cedk> pokoli: so on payment fail, if the move is on this *special* journal, payment cancel it
2014-09-10 15:43 <cedk> by cancel, I mean delete it if not posted
2014-09-10 15:44 <pokoli> cedk: and post when confirmed?
2014-09-10 15:44 <pokoli> cedk: makes sense
2014-09-10 15:45 <cedk> pokoli: post when set on statement like for clearing
2014-09-10 15:45 <pokoli> cedk: yes, post when you really now that this is what happened
2014-09-10 15:46 <cedk> pokoli: so now the wizard, should probably be design with care because you must have the ability to select which lines to group
2014-09-10 15:47 <pokoli> cedk: what we have now, it ensures that you don't mix lines from diferent parties, and this kind of things
2014-09-10 15:50 <cedk> pokoli: I think about opening a view with parties that have both kind of lines
2014-09-10 15:50 <pokoli> cedk: we have this on the lines to pay view
2014-09-10 15:50 <cedk> pokoli: from there, open a view per parties with the lines
2014-09-10 15:51 <cedk> pokoli: and using a wizard group the selected one
2014-09-10 15:52 <cedk> still one issue is that payment often requires id like end_to_end_id of SEPA
2014-09-10 15:52 <cedk> so for now, it uses the origin of the move and for example if it is an invoice take the number
2014-09-10 15:53 <cedk> now I guess it must check if it is an other move then take all the origin
2014-09-10 15:53 <pokoli> cedk: I guess we can get all the origins
2014-09-10 15:55 <pokoli> cedk: we have this https://bitbucket.org/trytonspain/trytond-account_bank/src/f7dd8a50e3053671bcb92634e1b3543c126d2686/account.py?at=default#cl-272
2014-09-10 15:56 <pokoli> cedk: so having a domain on this field and ordering with party you have your view
2014-09-10 15:58 <cedk> pokoli: don't understand
2014-09-10 16:00 <pokoli> cedk: don't worry, it's basically how to show all the moves that have another move that can be compensated
2014-09-10 16:00 <cedk> pokoli: don't need of that
2014-09-10 16:01 <cedk> pokoli: just party with at least unreconciled line in receivable and payable
2014-09-10 16:01 <cedk> but I will never do a function field for that
2014-09-10 16:01 <pokoli> cedk: so how you will know all the parties that have a unreconcile line for payable and receivable
2014-09-10 16:03 <cedk> pokoli: indeed it is just parties with amount_payble != 0 and amount_receivabel != 0
2014-09-10 16:03 <cedk> indeed no need of anything for that
2014-09-10 16:06 <pokoli> cedk: right, so you need a way to open receivable and payable lines (can be selected in the wizard) and select the ones you want to group
2014-09-10 16:08 <cedk> pokoli: we have already 2 relate
2014-09-10 16:08 <cedk> pokoli: better to convert into one relate with tab domains
2014-09-10 16:09 <pokoli> cedk: makes sense, but with a all tab in order to be able to select both
2014-09-10 16:09 <pokoli> cedk: I will open an issue for this as can be done easly
2014-09-10 16:14 <cedk> pokoli: can put a link to this chat
2014-09-10 16:15 <pokoli> cedk: I explained a llitle bit the issue, as the chat is large and can be confusing
2014-09-10 16:26 <pokoli> moldy: nobody answered your question, did they?
2014-09-10 16:27 <pokoli> moldy: I think you need the stock_lot module in order to manage serial numbers
2014-09-10 16:29 <moldy> pokoli: not yet.
2014-09-10 16:29 <moldy> pokoli: thanks. i will look into that.
2014-09-10 16:29 <cedk> yes, a serial number == a lot with 1 product
2014-09-10 16:30 <moldy> this sounds a little unclean, but i will take a look at it, maybe it's just me
2014-09-10 16:31 -!- alisonken1lap3(~alisonken@18.18.ultimate-int.uia.net) has joined #tryton
2014-09-10 16:34 <pokoli> moldy: why you say unclean?
2014-09-10 16:37 <moldy> pokoli: it's just my intuition
2014-09-10 16:38 <pokoli> moldy: so just give i try, and if you confirm your intiution we will be happy to hear your thoughts
2014-09-10 16:40 <moldy> pokoli: yes, i will give it a try. thanks.
2014-09-10 16:40 <moldy> pokoli: what is the right way to install tryton in a virtualenv, especially how to handle pygtk?
2014-09-10 16:41 <pokoli> moldy: install the server on a virtualenv
2014-09-10 16:41 <moldy> pokoli: ok, i did
2014-09-10 16:41 <cedk> moldy: what is your OS?
2014-09-10 16:41 <pokoli> moldy: and install pygtk outside of the virtualenv, and run the client from outside of the virtualenv
2014-09-10 16:42 <moldy> pokoli: so, installing the client in a virtualenv is not supported?
2014-09-10 16:43 <cedk> moldy: it is but pygtk is complicated
2014-09-10 16:43 <cedk> moldy: you can also use a virtualenv with system-packages
2014-09-10 16:43 <cedk> but indeed, what is your OS?
2014-09-10 16:43 <cedk> Tryton is packages on many OS
2014-09-10 16:43 <moldy> cedk: debian
2014-09-10 16:48 <pokoli> moldy: tryton.alioth.debian.org/mirror.html
2014-09-10 16:49 <moldy> thanks. i'd still like to use virtualenv, if it's easily possible.
2014-09-10 16:51 <moldy> W: Failed to fetch http://debian.tryton.org/debian/dists/jessie/main/binary-amd64/Packages 404 Not Found
2014-09-10 16:52 <pokoli> moldy: you should use jessie-X.X , where X.X corresponds to the series you want to use
2014-09-10 16:53 <pokoli> moldy: latests stable series are 3.2, so i will recommend you using jessie-3.2
2014-09-10 16:55 <moldy> i really hate insalling such things globally to my system
2014-09-10 16:55 <moldy> it creates all sorts of headaches :(
2014-09-10 16:56 <pokoli> moldy: you won't have problems if you only install the client
2014-09-10 16:56 -!- vernichon(~Thunderbi@gex01-1-78-234-55-95.fbx.proxad.net) has joined #tryton
2014-09-10 16:56 <moldy> i will give it a try
2014-09-10 16:57 <moldy> the server is running. where is the documentaton on how to connect to it?
2014-09-10 17:02 <moldy> the client says that it cannot connect. i guess i am missing some configuration, like db and credentials...
2014-09-10 17:04 <pokoli> moldy: http://tryton-documentation.readthedocs.org/en/latest/user_guide/tryton_client.html
2014-09-10 17:05 <moldy> pokoli: thanks, but i am looking for the server configuration
2014-09-10 17:05 <moldy> i just found /etc/trytond.conf
2014-09-10 17:07 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton
2014-09-10 17:08 <moldy> "can not connect to server"
2014-09-10 17:10 <moldy> trytond is 3.2.2, but tryton is 3.2.3 -- is that a problem?
2014-09-10 17:13 <pokoli> moldy: no, the series are the same
2014-09-10 17:13 <pokoli> moldy: are you connection from different machines?
2014-09-10 17:13 <moldy> pokoli: ok, thanks. i can now connect to the server. next problem seems to be that the db is empty, it is lacking the schema.
2014-09-10 17:13 <moldy> pokoli: no, all on localhost
2014-09-10 17:13 <pokoli> moldy: just create a new one from the client
2014-09-10 17:14 <moldy> "already exists". so i need to delete the existing db first?
2014-09-10 17:17 <moldy> unknown problem
2014-09-10 17:17 <moldy> geez, what a PITA
2014-09-10 17:17 <moldy> sorry.
2014-09-10 17:18 <moldy> http://dpaste.com/1BY353N
2014-09-10 17:19 <cedk> moldy: could be 2 issues:
2014-09-10 17:19 <moldy> "permission denied to create the database". which permissions are needed here? which db engine does it try to use by default? sqlite?
2014-09-10 17:19 <cedk> moldy: - ipv6 vs ipv4
2014-09-10 17:20 <cedk> moldy: or ssl fingerprint in known_hosts
2014-09-10 17:20 <moldy> ok, it seems to be trying to use postgres
2014-09-10 17:20 <cedk> moldy: on 3.2 postresql
2014-09-10 17:20 <moldy> ok. maybe this should be mentioned somewhere ;)
2014-09-10 17:21 <cedk> moldy: it changed in trunk
2014-09-10 17:21 <moldy> so i need to create a postgres role and give that role permission to create new databases?
2014-09-10 17:21 <moldy> there is no other way to initialize the db?
2014-09-10 17:22 <moldy> i am totally confused about where to enter which credentials.
2014-09-10 17:23 <moldy> there is "login name" and "password", and then under "manage profiles", there is again "login name" (but no password), and then when i hit "create db", there is "tryton server password", and "admin password".
2014-09-10 17:25 <moldy> is tryton really not able to just initialize its own database when it has an existing empty db and permissions on it?
2014-09-10 17:27 <cedk> moldy: no because it will be a security thread
2014-09-10 17:28 <moldy> that sounds weird, every other db app i know can do that
2014-09-10 17:28 <cedk> moldy: indeed, it the future database will no more be created with the client
2014-09-10 17:28 <moldy> cedk: how is it a security threat if tryton creates its db tables?
2014-09-10 17:28 <cedk> moldy: it will be if it creates a DB when someone access it is interface
2014-09-10 17:28 <moldy> i am not talking about creating the database. i am talking about creating the tables and filling them with initial data.
2014-09-10 17:29 <moldy> big difference.
2014-09-10 17:29 <moldy> creating the db is the sysadmin's job, creating the schema and data is the application's job.
2014-09-10 17:30 <moldy> i created the db, i started the server, i launched the client, then i get: rogrammingError: relation "ir_module_module" does not exist
2014-09-10 17:30 <cedk> moldy: It is what Tryton does
2014-09-10 17:30 <moldy> cedk: ok, what am i doing wrong then?
2014-09-10 17:31 <cedk> moldy: trytond can not check on every connection if the database is completly in sync with the code
2014-09-10 17:31 <cedk> moldy: I don't know what you do
2014-09-10 17:31 <moldy> cedk: at the moment, i just want to know how i get this thing running.
2014-09-10 17:32 <moldy> cedk: i created an empty postgres db called "tryton". i entered the db name, db user and db password in /etc/trytond.conf. then i started the server and the client.
2014-09-10 17:32 <cedk> moldy: why?
2014-09-10 17:32 <moldy> cedk: why what? why i created the db?
2014-09-10 17:32 <cedk> moldy: where do you put the db name in configuration ?
2014-09-10 17:32 <cedk> moldy: where do you get all those information?
2014-09-10 17:32 <moldy> cedk: sorry, i didn't. only the host, user and password
2014-09-10 17:33 <cedk> moldy: so you can use the wizard of the client and follow the instruction
2014-09-10 17:33 <moldy> ok, so tryton expects that he has privileges to create databases, it's not possible to use existing ones?
2014-09-10 17:33 <moldy> that's a bit crazy, but ok.
2014-09-10 17:34 <cedk> moldy: no, you can setup the database from command line
2014-09-10 17:34 <moldy> ahhh
2014-09-10 17:35 <moldy> cedk: ok, how do i do this?
2014-09-10 17:37 <moldy> well, i gave the postgres tryton user CREATE rights and used the client to create th db, that seems to have worked
2014-09-10 17:37 <cedk> moldy: trytond -d <db> -i all
2014-09-10 17:37 <moldy> cedk: ah, thanks
2014-09-10 17:38 <moldy> so that is meant by "init a module".
2014-09-10 17:41 <moldy> cedk, pokoli: thanks.
2014-09-10 17:42 <moldy> is there PDF documentation for the current release?
2014-09-10 17:43 <moldy> the one on readthedocs.org seems to be very outdated
2014-09-10 17:45 <cedk> moldy: it is not, it is just because it is incomplete
2014-09-10 17:46 <moldy> cedk: oh, ok. because it says "0.1"
2014-09-10 17:47 <cedk> moldy: where?
2014-09-10 17:47 <moldy> first page of the generated PF
2014-09-10 17:47 <cedk> http://trytond.readthedocs.org/en/latest/ -> 3.3 in the title
2014-09-10 17:47 <moldy> PDF
2014-09-10 17:48 <cedk> which PDF?
2014-09-10 17:48 <moldy> cedk: bottom left corner, "read the docs", "PDF"
2014-09-10 17:48 <moldy> https://readthedocs.org/projects/trytond/downloads/pdf/latest/
2014-09-10 17:49 <cedk> moldy: don't see by the title is: Release 3.3
2014-09-10 17:49 <moldy> ok, then it's just the PDF
2014-09-10 17:51 <moldy> thanks for your help, i will drive home now... talk to you later.
2014-09-10 18:15 -!- Telesight(~anthony@77-175-159-159.FTTH.ispfabriek.nl) has joined #tryton
2014-09-10 18:17 <cedk> moldy: is such doc would have helped: http://codereview.tryton.org/7571003/diff/20001/doc/topics/setup_database.rst
2014-09-10 18:20 <cedk> pokoli: scenario fails: http://hg.tryton.org/modules/purchase/rev/3544cd44c4d7
2014-09-10 18:20 <cedk> pokoli: Sale is not defined, I don't see why you do a sale
2014-09-10 18:20 <cedk> pokoli: please run scenario when you modify them
2014-09-10 18:21 <pokoli> cedk: ohh, this was not uploaded to the review, so I commited a wrong patch sorry
2014-09-10 18:29 <cedk> pokoli: please backout it and push the right one
2014-09-10 18:33 <pokoli> cedk: done
2014-09-10 19:09 -!- Telesight(~anthony@77-175-159-159.FTTH.ispfabriek.nl) has joined #tryton
2014-09-10 19:10 -!- Telesight(~anthony@77-175-159-159.FTTH.ispfabriek.nl) has joined #tryton
2014-09-10 20:18 -!- rpit(~ralf@dslb-092-073-175-134.092.073.pools.vodafone-ip.de) has joined #tryton
2014-09-10 20:36 -!- pablovannini(~pablo@host126.186-109-85.telecom.net.ar) has joined #tryton
2014-09-10 20:53 -!- gremly(~gremly@190.85.36.58) has joined #tryton
2014-09-10 21:25 -!- smarro(~sebastian@190.105.93.196) has joined #tryton
2014-09-10 22:07 -!- Telesight(~anthony@77-175-159-159.FTTH.ispfabriek.nl) has joined #tryton
2014-09-10 23:26 -!- uranus(~uranus@ool-182fa854.dyn.optonline.net) has joined #tryton
2014-09-10 23:30 -!- uranush(~uranus@ool-182fa854.dyn.optonline.net) has joined #tryton

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