IRC logs of #tryton for Monday, 2017-06-19

chat.freenode.net #tryton log beginning Mon Jun 19 00:00:01 CEST 2017
2017-06-19 00:59 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2017-06-19 01:05 -!- thaneor1(~ldlc6@r167-60-162-28.dialup.adsl.anteldata.net.uy) has joined #tryton
2017-06-19 01:26 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2017-06-19 04:24 -!- thaneor(~ldlc6@r167-56-55-149.dialup.adsl.anteldata.net.uy) has joined #tryton
2017-06-19 04:26 -!- vbastos(~vbastos@120.22.59.166) has joined #tryton
2017-06-19 08:56 -!- rpit(~rpit@aftr-37-24-144-89.unity-media.net) has joined #tryton
2017-06-19 09:01 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2017-06-19 09:06 -!- mrichez(~smuxi@mail.saluc.com) has joined #tryton
2017-06-19 09:07 -!- nicoe(~nicoe@2a02:a03f:30b2:3c00:ee55:f9ff:fe7b:f7ac) has joined #tryton
2017-06-19 09:26 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton
2017-06-19 09:30 -!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton
2017-06-19 09:34 <LordVan> hi
2017-06-19 09:35 <LordVan> i was wondering
2017-06-19 09:35 <LordVan> what exactly do i need unoconv for?
2017-06-19 09:35 <LordVan> do i need it for odt/ods/pdf generation, or is relatorio enough for that?
2017-06-19 09:41 <cedk> LordVan: it is needed to convert OpenDocument into other formats
2017-06-19 09:42 <cedk> LordVan: there is an issue to replace it with simple call to office: https://bugs.tryton.org/issue5907
2017-06-19 09:43 <LordVan> cedk, hi ^^
2017-06-19 09:43 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton
2017-06-19 09:44 -!- fabix(~chatmovil@qena.raceme.org) has joined #tryton
2017-06-19 09:47 <LordVan> cedk, so if i want pdf i need unoconv
2017-06-19 09:47 <LordVan> i don't really care if unoconv of call to libre/open-office
2017-06-19 09:47 <LordVan> but basically i need to install libre or open office in my LXC container for tryton
2017-06-19 09:48 <cedk> LordVan: yes, if you really want to have PDF
2017-06-19 09:48 <LordVan> well *really* is the question now ^^
2017-06-19 09:48 <LordVan> odt/ods have the advantage to be easier to edit (which could also be a disadvantage with our users lol)
2017-06-19 09:49 <LordVan> but basically if i don't need system generated pdf I can make do without installing libre/openoffice and all it's deps i don't otherwise need in the container
2017-06-19 09:51 <cedk> LordVan: normally, documents are open in read-only mode by default
2017-06-19 09:52 <LordVan> yes
2017-06-19 09:52 <LordVan> that is good
2017-06-19 09:56 <LordVan> then i leave it for now
2017-06-19 09:56 <LordVan> since that would be one hell of a lot of deps
2017-06-19 09:56 <LordVan> btw
2017-06-19 09:57 <LordVan> would you recommend running it with it's own postgresql within the container or (as i'd probably do now) with postgresql in a different lxc container?
2017-06-19 09:58 <LordVan> that aside ... how have you been cedk - been a while since we talked ;)
2017-06-19 09:58 <cedk> LordVan: it depends on your goals, how much instances you are running, what can of usage etc.
2017-06-19 09:58 <LordVan> cedk, well i have dbmail & some other dbs as well
2017-06-19 09:58 <LordVan> but i think i will put it in a seperate container
2017-06-19 09:59 <LordVan> should at least have less upgrade headaches that way i think - and i don't think i want to run like 3 instances of postgresql on that box
2017-06-19 09:59 <cedk> LordVan: I do not understand, why are you using containers?
2017-06-19 10:00 <LordVan> i just want to seperate the different things because upgrading one base package of the system can become a major headache sometimes when you have php stuff, .. depend on it
2017-06-19 10:00 <LordVan> (security is somewhat a concern too, but mainly i want less stuff installed on the "base" system
2017-06-19 10:01 <cedk> LordVan: I do not think container provides any security
2017-06-19 10:02 <LordVan> cedk, well it runs unpriviledged, so if there was a security problem in one it would have no permissions to do anything on the base system or in other containers
2017-06-19 10:02 <LordVan> but as i said
2017-06-19 10:02 <cedk> LordVan: the postgresql dependencies are quite small and should not have any complication
2017-06-19 10:02 <LordVan> postgresql is fine
2017-06-19 10:02 <LordVan> but all the php stuff
2017-06-19 10:02 <LordVan> ^^
2017-06-19 10:02 <cedk> LordVan: and normally upgrade of PG should not break things
2017-06-19 10:02 <LordVan> yeah pg is fine
2017-06-19 10:03 <cedk> LordVan: as far as I know PG and Tryton can run unpriviledged
2017-06-19 10:03 <LordVan> there'S a lot of stuff running on that machine
2017-06-19 10:03 <LordVan> cedk, that is true of course
2017-06-19 10:03 <LordVan> as i said security is not my main reason
2017-06-19 10:04 <LordVan> it is just i have to be real careful when i upgrade some base system stuff to not break DNS, Samba, ...
2017-06-19 10:04 <LordVan> i don't have the luxury of lots of servers
2017-06-19 10:04 <LordVan> so they all have many roles
2017-06-19 10:04 <LordVan> i also will put samba in a container for example
2017-06-19 10:05 <LordVan> (samba is a lot more of a pain than tryton or pg haha)
2017-06-19 10:06 <cedk> LordVan: so I have no recommandations
2017-06-19 10:06 <LordVan> ^^ fair enough
2017-06-19 10:07 <LordVan> well i go with one postgres instance i think because 3+ postgres instances on that machine is very likely just overkill
2017-06-19 10:07 <LordVan> the only really big db is dbmail
2017-06-19 10:08 <LordVan> anyway my main question about unoconv was answered so all is good :D
2017-06-19 10:08 <LordVan> btw
2017-06-19 10:08 <LordVan> i want to import data from dolibarr .. do you know if someone has done this before?
2017-06-19 10:09 -!- csotelo(~csotelo@2001:1388:49c6:5c38:1513:89ca:be23:6b46) has joined #tryton
2017-06-19 10:16 <cedk> LordVan: we have done some from Odoo/OpenERP to Tryton and wrote a basic script: http://hg.b2ck.com/openerp2tryton/
2017-06-19 10:16 <cedk> this can be inspiration
2017-06-19 10:16 -!- thaneor1(~ldlc6@179.26.151.24) has joined #tryton
2017-06-19 10:16 <LordVan> cool thanks
2017-06-19 10:17 <LordVan> though i know the dolibarr db quite well as i had to fix/add some stuff ^^
2017-06-19 10:17 <LordVan> unfortunately for me a lot of the dolibarr code & db tables & column names are in french
2017-06-19 10:17 <LordVan> lol
2017-06-19 10:17 <LordVan> gave me some headaches there
2017-06-19 10:19 <cedk> LordVan: they still use french naming?
2017-06-19 10:19 <LordVan> yes
2017-06-19 10:19 <LordVan> which is a major pita if you don't speak french
2017-06-19 10:19 <LordVan> i had to look at my tables contents to figure it out
2017-06-19 10:19 <cedk> LordVan: ha French guys…
2017-06-19 10:19 <LordVan> and the code has lots of french too
2017-06-19 10:20 <LordVan> (worst of all the example code and wiki too)
2017-06-19 10:20 <LordVan> ^^
2017-06-19 10:20 <fabix> cedk: yes, bad guys ;)
2017-06-19 10:20 <LordVan> i even had to fix some bugs
2017-06-19 10:20 <LordVan> fabix, haha
2017-06-19 10:37 <LordVan> but it seems tryton should fit my purposes more than dolibarr anyway -- and it is python and not php ^^
2017-06-19 10:39 <LordVan> so aftera ll those years i might still start using tryton at work now :D
2017-06-19 10:53 -!- jmpoure_(~jmpoure@soy95-2-82-236-103-229.fbx.proxad.net) has joined #tryton
2017-06-19 10:59 <LordVan> I shall let you know how the data import from dolibarr goes
2017-06-19 11:08 -!- _2cadz(~ccr@ax313-1-82-66-159-99.fbx.proxad.net) has joined #tryton
2017-06-19 11:14 -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton
2017-06-19 11:16 <cedk> LordVan: good, if you write a similar script than openerp2tryton, it will be great to publish it
2017-06-19 11:18 <LordVan> i will see if i can make a generic one or if i have to accomodate some .. extras ^^ but i will put it up somewhere
2017-06-19 12:22 -!- smarro(~sebastian@181.16.7.104) has joined #tryton
2017-06-19 12:30 -!- udono(~udono@153-058-210-188.ip-addr.inexio.net) has joined #tryton
2017-06-19 12:40 -!- udono(~udono@153-058-210-188.ip-addr.inexio.net) has joined #tryton
2017-06-19 12:58 -!- mariomop(~quassel@181.90.156.211) has joined #tryton
2017-06-19 13:33 -!- meigallodixital(~meigallod@249.135.116.91.static.reverse-mundo-r.com) has joined #tryton
2017-06-19 13:50 -!- jmpoure_(~jmpoure@soy95-2-82-236-103-229.fbx.proxad.net) has left #tryton
2017-06-19 13:53 -!- vbastos(~vbastos@san1823193.lnk.telstra.net) has joined #tryton
2017-06-19 14:07 -!- smarro(~sebastian@181.16.7.104) has joined #tryton
2017-06-19 14:17 -!- mariomop(~quassel@host121.190-229-64.telecom.net.ar) has joined #tryton
2017-06-19 14:18 -!- jmpoure_(~jmpoure@soy95-2-82-236-103-229.fbx.proxad.net) has joined #tryton
2017-06-19 14:31 -!- jmpoure_(~jmpoure@soy95-2-82-236-103-229.fbx.proxad.net) has joined #tryton
2017-06-19 14:46 -!- udono(~udono@153-058-210-188.ip-addr.inexio.net) has joined #tryton
2017-06-19 15:29 -!- jmpoure_(~jmpoure@soy95-2-82-236-103-229.fbx.proxad.net) has left #tryton
2017-06-19 15:34 -!- csotelo_at_work(~csotelo@179.43.99.44) has joined #tryton
2017-06-19 16:34 <mrichez> hi need some advices and may be examples... to filter product on specific category defined in a configuration (tryton 4.2)
2017-06-19 16:36 <mrichez> so i define in configuration my default_category as a property on a Many2One on product.category
2017-06-19 16:37 <mrichez> in another class i need to get products from this specific category (and children too)
2017-06-19 16:38 <mrichez> is defining a function field on a property allowed ?
2017-06-19 16:42 -!- lukio(~lukio@iplan.gcoop.com.ar) has joined #tryton
2017-06-19 16:46 <cedk> mrichez: yes it is but this means the result will also depend on the context
2017-06-19 16:47 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton
2017-06-19 16:48 <mrichez> cedk: what would be the alternative? i try to avoid a check box for each kind of product i need to filter
2017-06-19 16:57 <mrichez> cedk: sorry, i'm leaving
2017-06-19 17:20 -!- notizblock(~notizbloc@nblock.org) has joined #tryton
2017-06-19 17:36 -!- lukio(~lukio@iplan.gcoop.com.ar) has joined #tryton
2017-06-19 17:46 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton
2017-06-19 18:47 -!- lukio(~lukio@host126.186-109-85.telecom.net.ar) has joined #tryton
2017-06-19 18:55 -!- JosDzG(~Thunderbi@189.250.45.130) has joined #tryton
2017-06-19 19:01 -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton
2017-06-19 19:12 -!- JosDzG(~Thunderbi@189.250.45.130) has joined #tryton
2017-06-19 19:22 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has left #tryton
2017-06-19 19:37 -!- _2cadz(~ccr@ax313-1-82-66-159-99.fbx.proxad.net) has joined #tryton
2017-06-19 19:54 -!- pokoli(~pokoli@unaffiliated/pokoli) has joined #tryton
2017-06-19 20:14 -!- giesen_(~ggiesen@2001:19f0:0:1019:5400:ff:fe25:bda6) has joined #tryton
2017-06-19 20:29 -!- g5pw(~g5pw@mittelab/sudo/g5pw) has joined #tryton
2017-06-19 20:44 -!- LordVan(~lordvan@gentoo/developer/LordVan) has joined #tryton
2017-06-19 20:45 <LordVan> cedk, quick question: can i not use emerge --config app-office/trytond-4.4.1 if i have the postgresql server on a different machine?
2017-06-19 20:46 <LordVan> ah nm.
2017-06-19 20:46 <LordVan> that just creates the db user
2017-06-19 20:50 <LordVan> ACTION wonders what graphviz is used for
2017-06-19 21:01 <LordVan> btw cedk is it just me, or is a sample config file for trytond "missing" from the gentoo ebuilds?
2017-06-19 21:17 <LordVan> ACTION looks @ opensuse's config example
2017-06-19 21:44 <LordVan> this is odd ..
2017-06-19 21:44 <LordVan> i specified uri = postgresql://tryton:secretPwd@serverIP:5432/ in trytond.conf
2017-06-19 21:45 <LordVan> but when i run trytond-admin -v -c /etc/tryton/trytond.conf -d tryton --all
2017-06-19 21:45 <LordVan> 4046 139655752156928 [2017-06-19 19:45:03,832] INFO trytond.backend.postgresql.database connect to "tryton"
2017-06-19 21:45 <LordVan> ....
2017-06-19 21:45 <LordVan> psycopg2.OperationalError: could not connect to server: No such file or directory
2017-06-19 21:45 <LordVan> Is the server running locally and accepting
2017-06-19 21:45 <LordVan> connections on Unix domain socket "/run/postgresql/.s.PGSQL.5432"?
2017-06-19 21:45 <LordVan> any idea what i did wrong here?
2017-06-19 21:57 <LordVan> ah
2017-06-19 21:57 <LordVan> i left a 3rd '/' ..
2017-06-19 21:58 <LordVan> cedk, btw tryton-admin gives an error message about not finding genshi when run with python3 .. maybe "force" it to run with python2.7 ?
2017-06-19 21:59 <lukio> hi everyone, one of my custom modules where using the method dictfetchone from backend/database.py It seems that this method has been removed from core. Do I have any other way to fetch the row as a dictionary?
2017-06-19 22:00 <lukio> here is the commit which remove the method: https://bitbucket.org/tryton/trytond/diff/trytond/backend/database.py?diff2=9b2e0aac2d9c&at=4.0#Ltrytond/backend/database.pyF231
2017-06-19 22:00 -!- semarie_(~semarie@unaffiliated/semarie) has joined #tryton
2017-06-19 22:13 <LordVan> I get this error on trytond start: ConfigParser.NoSectionError: No section: 'formatters'
2017-06-19 22:13 <LordVan> i think it was something missing from my confing or so .. anyone happen to know what it is?
2017-06-19 22:18 -!- thaneor(~ldlc6@r179-24-153-0.dialup.adsl.anteldata.net.uy) has joined #tryton
2017-06-19 22:24 <LordVan> found the error ^^
2017-06-19 22:27 -!- JosDzG(~Thunderbi@189.250.45.130) has joined #tryton
2017-06-19 22:29 <lukio> Hi, I found that has been replaced by cursor_dict method. -> http://hg.tryton.org/trytond/rev/9b2e0aac2d9c/#l24.90
2017-06-19 22:56 -!- JosDzG(~Thunderbi@189.250.45.130) has joined #tryton
2017-06-19 23:01 -!- JosDzG(~Thunderbi@189.250.45.130) has joined #tryton
2017-06-19 23:33 -!- lukio(~lukio@host126.186-109-85.telecom.net.ar) has left #tryton

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