IRC logs of #tryton for Thursday, 2012-02-16

chat.freenode.net #tryton log beginning Thu Feb 16 00:00:01 CET 2012
2012-02-16 00:14 <caravel> Hi again (if anyone's still around ?), readng this https://code.google.com/p/tryton/wiki/InstallationOnDebian and following link heretryton.debian-maintainers.org returns a 404
2012-02-16 00:14 <caravel> sorry http://tryton.debian-maintainers.org
2012-02-16 00:15 <caravel> ACTION will report to #debian of course, any tip welcome
2012-02-16 10:56 <yangoon> caravel: links on https://code.google.com/p/tryton/wiki/InstallationOnDebian updated, website is currently in process of rebuilding
2012-02-16 11:22 <caravel> yangoon: thank you! I knew there would be what I wanted, in that page
2012-02-16 13:53 <sisalp> caravel: you may also be interested in testing this alternate way to get a tryton server ready : https://docs.google.com/document/d/1lKIHZcc3TFOUrjQebQ-sVyQ000mIv9gkxJSbCt0JQjE/edit
2012-02-16 15:19 <caravel> thanks sisalp, if I plan to understand it I'd better stick to the roots thou. Yet the packaged method are kinda cheat :)
2012-02-16 15:20 <caravel> I had a question thou, I think I had read a document about limitations if using the sqlite backend (which I consider for one of the hosts i.e. laptop), can't seem to find it now ?
2012-02-16 15:22 <caravel> and is that for exclusive use of trytond by neso i.e. stricly mono-user ?
2012-02-16 15:28 <bechamel> caravel: you can choose sqlite with a non-neso install
2012-02-16 15:28 <bechamel> caravel: and the biggest limitation is the performances, so it fits well for single-user usage
2012-02-16 15:43 <caravel> bechamel: ok thanks, and perf is none of a concern on that host (that'd be dev/test and eventually an "on-the-go server" for 2 clients, too ^^). I was pretty sure there were functional limitations thou, I guess I am confusing (had read quite a while ago)
2012-02-16 15:45 <bechamel> caravel: there are some limitation with sqlite but the tryton orm overcome them
2012-02-16 15:48 <bechamel> caravel: btw there are less tricks with sqlite than with mysql
2012-02-16 15:49 <caravel> bechamel: so getting trytond to use postgres (or even make use of an existing mysql) on that host, would be a pure waste of resources I assume
2012-02-16 15:50 <caravel> ACTION won't forsee to even start getting into db tuning for a good while, to be perfectly clear :D
2012-02-16 15:51 <sisalp> caravel: you need to understand roots indeed, but then you realize you need a lot more for real life.
2012-02-16 15:52 <bechamel> caravel: as long as you don't plan to put more users on it in the future, sqlite is perfect
2012-02-16 15:52 <sisalp> caravel: and I don't remember which ones, but recently was told "this is not available with sqlite"
2012-02-16 15:53 <caravel> how sarcastic is that sisalp ? :) yes bechamel, I got that right looong time ago!
2012-02-16 15:54 <sisalp> caravel: ? what is sarcastic ?
2012-02-16 15:55 <caravel> sisalp: I wondered (not native English as anyone could tell). I said I wanted to remain close the install roots earlier, so it was some echo :)
2012-02-16 15:55 <cedk> caravel: http://hg.tryton.org/trytond/file/4e2e64d932f7/README#l55
2012-02-16 15:57 <sisalp> SQLite can not alter column definitions nor create foreign keys. What are implications ?
2012-02-16 15:58 <sisalp> caravel: yes it was. You must understand how the product works, but then long term admin is not documented by install procedure
2012-02-16 15:59 <caravel> ACTION had guessed that too ;D
2012-02-16 16:00 <sisalp> caravel: you need to save databases, handle upgrades, watch for troubles etc..., all this is proposed by the alternative way.
2012-02-16 16:00 <caravel> between, I'm typically a db publisher, which means long working with db guys on interface to print millions of their data, without ever maintaining any proper db
2012-02-16 16:01 <caravel> sisalp: oh, I had misunderstood that, I'll look again (but wonder how could that be "handled", still). Let me read, enough pointers thanks a lot all
2012-02-16 16:29 <caravel> okay, went quickly through install_xoe and xoe scripts (well, some of, it's pretty large ^^)
2012-02-16 16:31 <caravel> Far from being a db wizzz, is that pretty sure I'd hit the wall soon or later (and much faster), unless using such script for setup & daily run ?
2012-02-16 16:38 <bechamel> caravel: what do you mean by hit the wall ?
2012-02-16 16:46 <caravel> bechamel: crash, burn data, disk, server and the whole building with it :)
2012-02-16 16:46 <sisalp> caravel: I think you can manage tryton without any script
2012-02-16 16:46 <sisalp> postgresql is a database you never hear about
2012-02-16 16:50 <sisalp> if you are a well organized sys admin, you can handle the task manually. I'not of this kind, so xoe is a tool to organize and standardize my work.
2012-02-16 16:50 <sisalp> With openerp, I had to, tryton is much easier to work with
2012-02-16 16:51 <caravel> ACTION needs to look much more into this, hadn't even realized latest tryton version differ between distro
2012-02-16 16:51 <caravel> btw, fedora dev machine here, debian server(s)
2012-02-16 16:54 <sisalp> caravel: using packages is convenient, but not if you need to adapt tryton. and you may want to prevent auto-update of the packages.
2012-02-16 16:54 <caravel> sisalp: I never auto-update, yum and aliases are my best friends
2012-02-16 16:55 <sisalp> caravel: never user apt-get upgrade on debian ?
2012-02-16 16:56 <caravel> sisalp: hey, you're teasing me now
2012-02-16 16:57 <sisalp> caravel: not teasing. if flag is per default, apt-get upgrade performs auto-update of tryton software, which may not be what you want.
2012-02-16 16:57 <caravel> ok ok - two or 3 years ago (I think ?) I had started to look into OpenERP then Tryton, don't remember reading about the big xoe of yours, I guess I failed to search
2012-02-16 16:58 <caravel> thanks, it surely will help me one way or another (running it or not cf platform and/or install mode I choose)
2012-02-16 16:59 <caravel> ACTION will stoping taking space, thanks again for all guidance
2012-02-16 16:59 <sisalp> caravel: I don't advertise xoe, and don't aim to spread it widely
2012-02-16 17:00 <sisalp> it is only one way to get things sorted
2012-02-16 17:01 <caravel> and it looks like it's been quite some effort to write it
2012-02-16 17:05 <sisalp> caravel: yes but since 5 years I host hundreds of servers ;-)
2012-02-16 17:06 <caravel> Now it makes sense, all of a sudden ^^
2012-02-16 17:19 <ciupicri> sharkcz, have you received my email about the missing dependency in trytond 2.2?
2012-02-16 17:20 <ciupicri> I was also thinking of upgrading the SysV service script to systemd
2012-02-16 17:21 <sharkcz> ciupicri: not sure, I'm not at my workstation, so it may lay in the unproceessed mail queue
2012-02-16 17:22 <sharkcz> the switch to systemd unit is planned for f17
2012-02-16 17:24 <ciupicri> I see, although I haven't noticed a .service file in the git repository for F17
2012-02-16 17:25 <ciupicri> http://pkgs.fedoraproject.org/gitweb/?p=trytond.git;a=tree;h=refs/heads/f17;hb=f17
2012-02-16 17:25 <sharkcz> it's not commited yet
2012-02-16 17:25 <ciupicri> I see
2012-02-16 17:26 <sharkcz> the problem is that there must be per dbserver units to use the advatage of service dependencies (trytond-pgsql will start after pgsql is started, etc)
2012-02-16 17:27 <sharkcz> and one also wants a generic "trytond" service, but I've solved similar problem in zabbix, so it's doable
2012-02-16 17:27 <ciupicri> right
2012-02-16 19:14 <caravel> night all, thanks again
2012-02-16 22:29 <ciupicri> is there a way to change the category of a product?
2012-02-16 22:29 <ciupicri> it seems that after adding a product and specifying its category I can not change it
2012-02-16 22:50 <ciupicri> how does the search work? Can I search only for a fragment of a field?
2012-02-16 23:30 <jerojasro> ciupicri: you *can* change a product category...
2012-02-16 23:31 <jerojasro> the thing is, you must clear the field first
2012-02-16 23:32 <jerojasro> ciupicri: or is the "category" field disabled?
2012-02-16 23:33 <ciupicri> jerojasro, let me try
2012-02-16 23:36 <ciupicri> jerojasro, yes, you're right, thanks
2012-02-16 23:36 <jerojasro> np
2012-02-16 23:39 <ciupicri> by the way, is there a way to configure the same accounts (revenue, expense) for all products? Use something like inheritance.
2012-02-16 23:40 <ciupicri> I noticed that the products can inherit from a category, but a category doesn't seem to be able to do the same from its parent (category).

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