IRC logs of #tryton for Thursday, 2013-05-23

chat.freenode.net #tryton log beginning Thu May 23 00:00:03 CEST 2013
2013-05-23 08:41 <iamnoob> hi, i made a report to display all records in a module.. now what i cant figure out is.. if i have a 'quantity' field (where value will be a number) how can i sum all the quantity value? will i do it on the open-office(libre office)? how can i achieved this please
2013-05-23 08:43 <iamnoob> im using <rows.quantity> to show the 'quantity' value inside the .odt file is there a way to sum it?
2013-05-23 10:53 <kavish-lmde> Hi, tryton says wrong password
2013-05-23 10:54 <kavish-lmde> How do I recover tryton password?
2013-05-23 10:55 <kavish-lmde> Hello!
2013-05-23 10:56 <_droid> kavish-lmde: is it a clean new tryton installation?
2013-05-23 10:56 <kavish-lmde> Yes, I just installed it; during installation it asked for password; I use the same password, it says bad password
2013-05-23 10:57 <_droid> ok, what is the username that you use for the login?
2013-05-23 10:58 <kavish-lmde> admin
2013-05-23 10:58 <kavish-lmde> Actually was not able to proceed further; could not create new database etc.
2013-05-23 11:00 <_droid> kavish-lmde: what I had was to repeat the steps when creating the first tryton user in the installation instructions, and revise the username and password in your tryton.conf file
2013-05-23 11:02 <_droid> try those
2013-05-23 11:02 <kavish-lmde> will just try this out
2013-05-23 11:02 <_droid> points
2013-05-23 11:08 <kavish-lmde> every line is commented out with #
2013-05-23 11:08 <kavish-lmde> This probably means the installation script did not do its work?
2013-05-23 11:11 <_droid> kavish-lmde: you need to uncomment db_host, db_port,db_user, and db_password.
2013-05-23 11:11 <_droid> kavish-lmde: what is the database that you installed?
2013-05-23 11:11 <_droid> mysql or postgres?
2013-05-23 11:11 <kavish-lmde> postgresql
2013-05-23 11:11 <_droid> ok
2013-05-23 11:11 <kavish-lmde> will do these things first.
2013-05-23 11:13 <_droid> kavish-lmde: there is also a line what says db_type, uncomment that and put postgresql
2013-05-23 11:13 <kavish-lmde> #db_type is also commented; what to do?
2013-05-23 11:14 <_droid> kavish-lmde: also don't forget to restart your server in oder to make changes take affect
2013-05-23 11:14 <kavish-lmde> done
2013-05-23 11:14 <_droid> once you have restarted the server you will need to make sure that you have created a postgresql account with the username and password that you set in the conf-file
2013-05-23 11:15 <kavish-lmde> is there a service restart command for pgsql?
2013-05-23 11:15 <_droid> what OS?
2013-05-23 11:15 <kavish-lmde> lmde
2013-05-23 11:16 <kavish-lmde> LMDE
2013-05-23 11:16 <_droid> kavish-lmde: since it is a debian derivative, i would guess "sudo service psql stop" and then replace stop with start
2013-05-23 11:17 <kavish-lmde> psql or pgsql
2013-05-23 11:18 <_droid> try it, lmde won't bite you ;)
2013-05-23 11:18 <kavish-lmde> postgresql it is and restarted
2013-05-23 11:19 <kavish-lmde> db_host = false it says
2013-05-23 11:19 <_droid> kavish-lmde: a tip, if you are not sure if it is this or that use the tab key it will try to complete it for you
2013-05-23 11:19 <kavish-lmde> ok
2013-05-23 11:20 <_droid> check the ip of the host? if it is a localhost replace it with 127.0.0.1
2013-05-23 11:20 <kavish-lmde> db_port db_user everything is set to false
2013-05-23 11:22 <_droid> kavish-lmde: give me a pastebin link
2013-05-23 11:23 <kavish-lmde> just a min
2013-05-23 11:24 <_droid> kavish-lmde: no worries
2013-05-23 11:26 <kavish-lmde> http://pastebin.com/download.php?i=LVKbXi1Z
2013-05-23 11:30 <_droid> kavish-lmde: ok, all these db_ lines, uncomment them and replace the false with the actual username and password that u use for the postgresql db
2013-05-23 11:31 <kavish-lmde> one min
2013-05-23 11:31 <_droid> kavish-lmde: as for the port set it to 5432
2013-05-23 11:33 <kavish-lmde> db_host = 127.0.0.1 db_port = 8000 db_user = luxpro db_password = luxpro123 this ok?
2013-05-23 11:34 <kavish-lmde> ok
2013-05-23 11:34 <_droid> kavish-lmde: db_port: is supposed to be 5432
2013-05-23 11:34 <kavish-lmde> ok done
2013-05-23 11:36 <_droid> kavish-lmde: what you need to understand is that the db_ part tells the tryton server to what database to log onto like ip of the server, port etc
2013-05-23 11:37 <kavish-lmde> ok done
2013-05-23 11:42 <kavish-lmde> It looks like there are two port issues to deal with - one is for pgsql:5432 and one for tryton server itself: 8000 ??
2013-05-23 11:43 <_droid> yes
2013-05-23 11:43 <kavish-lmde> where to set the port for tryton server - or does the tryton client know it?
2013-05-23 11:43 <_droid> kavish-lmde: you have to see it like this: client<==port 8000===>tryton-server<===port5432==>database-server
2013-05-23 11:44 <kavish-lmde> yes i got that
2013-05-23 11:45 <_droid> kavish-lmde: that aspect is configured at the tryton.conf in the line that says "jsonrpc"
2013-05-23 11:45 <_droid> kavish-lmde: apparently your database server (postgresql) is on the same machine with tryton
2013-05-23 11:45 <kavish-lmde> Going through the documentation on doc.tryton.org all these details are not there ??
2013-05-23 11:46 <_droid> kavish-lmde: !? 1 sec
2013-05-23 11:47 <_droid> kavish-lmde: here you go
2013-05-23 11:47 <_droid> https://www.google.com/search?client=ubuntu&channel=fs&q=tryton+installation+guide&ie=utf-8&oe=utf-8
2013-05-23 11:47 <kavish-lmde> yes for now tryton client, server and pgsql will be on the same machine; later on I''ll separate them.
2013-05-23 11:48 <_droid> kavish-lmde: when you seperate them you will have to replace db_host=127.0.0.1 with the ip of the server and make sure that the port 5432 is open
2013-05-23 11:50 <kavish-lmde> ok
2013-05-23 11:51 <kavish-lmde> _droid: that was a handful of reading material; thanks for now; thanks again;
2013-05-23 11:54 <kavish-lmde> bye _droid; was nice learning from you; nice being on #tryton
2013-05-23 12:11 <_droid> kavish-lmde: was glad to help
2013-05-23 12:52 -!- _droid(~Thunderbi@178.135.65.143) has left #tryton
2013-05-23 15:55 <cedk> Pilou: your last commit breaks account_asset
2013-05-23 16:23 <Pilou> cedk: isn'it a bug in account_asset ?
2013-05-23 16:24 <cedk> Pilou: no
2013-05-23 16:28 <Pilou> the exception was here before, but exception was hidden
2013-05-23 16:28 <cedk> Pilou: no
2013-05-23 16:35 <Pilou> i revert my modifications with "hg log -p -r 1b1562ec4a63 |patch -p1 -R", apply this dumb patch http://pastebin.com/chgGbQgG and run the following command: "./bin/trytond -d db -i all"
2013-05-23 16:36 <Pilou> "coin2" * 10 never appears
2013-05-23 16:37 <cedk> Pilou: updating database is not a test
2013-05-23 16:38 <Pilou> same occurs with "./bin/trytond -d db"
2013-05-23 16:39 <Pilou> "cls._error_messages" is never updated because previous statement raises the exception
2013-05-23 17:28 <Pilou> cedk: so ?
2013-05-23 17:41 <cedk> Pilou: I made a patch
2013-05-23 18:01 <Pilou> cedk: why don't add a default __setup__ classmethod ?
2013-05-23 18:05 <jeancavallo> Pilou: I might be wrong but I think there is more than just the __setup__ being called
2013-05-23 18:25 <Pilou> cedk: using Model as a BaseClass for PurchaseLine could be a solution (http://pastebin.com/d64fcqsH)
2013-05-23 18:44 <cedk> Pilou: because we don't want to register a extra depends Model if the base is not there
2013-05-23 20:02 <gour_> /nick gour
2013-05-23 20:04 <gour> there are several php 'invoicing' apps, mostly web-based for handling quotes/invoices suitable for small businesses/freelancers which produce nice pdf based on some template. i'd like to use something which is python-based and not finding some django-based one wonder if tryton would be an overkill for such purpose?
2013-05-23 20:04 <gour> found out about Nereid in some list's discussions, but it seems it's not really web client?
2013-05-23 20:05 <gour> what is the status for tryton's web client although that's not exclusive requirement for me
2013-05-23 20:30 <pokoli> gour: http://hg.tryton.org/sandbox/sao is the repo
2013-05-23 20:30 <pokoli> gour: demo.tryton.org:8000 you can see a live demo of current status of web client (i don't know how updated is as I don't manage it)
2013-05-23 20:31 <cedk> gour, pokoli: it is up to date
2013-05-23 20:36 <gour> ACTION is trying demo...a bit slow, but ok
2013-05-23 20:37 <gour> is it possible to strip tryton to our bare needs easily? e.g we don't need stock 'cause our 'products' are services etc.?
2013-05-23 20:41 <pokoli> gour: stock is a requirement of sale but if you have all products that are services it won't use it. You can hide it's menu options by users permisions if you want
2013-05-23 20:55 <gour> pokoli: ok. thanks
2013-05-23 20:56 <pokoli> gour: I will sugest you to download gtk client and test directly from there
2013-05-23 20:57 <gour> there is no plan to move client away from gtk+?
2013-05-23 21:32 <gour> what is the purpose of https://bitbucket.org/zikzakmedia/trytond-django/overview ?
2013-05-23 22:32 <cedk> gour: don't know but if you search to plug a website with Tryton better to look at nereid
2013-05-23 22:33 <gour> cedk: no, if i'd use some php apps, it would run just on my localhost machine, no webshop involved
2013-05-23 22:34 <cedk> gour: what php apps?
2013-05-23 22:35 <gour> cedk: e.g. simpleinvoices, fusioninvoice etc.
2013-05-23 22:36 <gour> http://www.fusioninvoice.com/
2013-05-23 22:37 <gour> for personal stuff i use gnucash, but it missing quotes/proforma_invoices and its customizing abilities (via guile) are not so pretty
2013-05-23 22:37 <cedk> gour: but why using an other invoicing software, as Tryton already manage invoices
2013-05-23 22:38 <gour> cedk: no need, of course, just wondering if tryton might be overkill 'cause we don't have need for other modules like accounting etc. just invoicing
2013-05-23 22:40 <cedk> gour: just install account_invoice
2013-05-23 22:44 <gour> tryton generates libre(open)office documents for invoices?
2013-05-23 22:45 <cedk> gour: yes
2013-05-23 22:47 <gour> is there demo for 2.2 available? that's current debian version
2013-05-23 22:47 <gour> i had to try win client under winxp :-/
2013-05-23 22:48 <cedk> gour: no it is too old
2013-05-23 22:48 <gour> ahh...
2013-05-23 22:49 <gour> let me try to pull latest from experimental...
2013-05-23 22:52 <gour> you'll stay with (py)gtk toolkit?
2013-05-23 22:55 <gour> ACTION is demo-ing with 2.9 now...
2013-05-23 22:57 <cedk> gour: yes I don't see any reason to change
2013-05-23 22:57 <cedk> gour: there is no demo for 2.9 as it is the dev branch
2013-05-23 23:00 <gour> cedk: ok. for another desktop project i'm considering to write, i've decided in favour of (py)qt over gtk...
2013-05-23 23:03 <gour> i've created new demo account, added few items and when wanting to pay (as cash) i get: the debit account on jouurnal 'cash' is missing...but, afaict, no ability to change/add it?
2013-05-23 23:06 <cedk> gour: you have to setup a default debit/credit account on the journal
2013-05-23 23:09 <gour> cedk: does demo allows it?
2013-05-23 23:14 <gour> afacit, it does not
2013-05-23 23:15 <cedk> gour: I'm pretty sure yes
2013-05-23 23:16 <cedk> gour: but probably with admin user
2013-05-23 23:16 <gour> ahh ok. let me try to log as admin
2013-05-23 23:26 <gour> now it's ok, after changing things admin. :-)
2013-05-23 23:26 <cedk> gour: demo is not in account admin group
2013-05-23 23:26 <gour> ok
2013-05-23 23:27 <gour> i'll resume tomorrow after trying to install everything on my box and strip to the core needs we have at the moment

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