IRC logs of #tryton for Tuesday, 2010-12-21

chat.freenode.net #tryton log beginning Tue Dec 21 00:00:02 CET 2010
2010-12-21 01:59 -!- ikks(~ikks@190.158.100.177) has joined #tryton
2010-12-21 02:12 -!- woakas(~woakas@200.106.202.91) has joined #tryton
2010-12-21 03:23 -!- gremly(~gremly@200.106.202.91) has joined #tryton
2010-12-21 03:44 -!- nicoe(~nicoe@193.200.42.57) has left #tryton
2010-12-21 03:44 -!- nicoe(~nicoe@193.200.42.57) has joined #tryton
2010-12-21 04:09 -!- ikks(~ikks@190.158.100.177) has joined #tryton
2010-12-21 05:18 -!- yangoon(~mathiasb@p549F6574.dip.t-dialin.net) has joined #tryton
2010-12-21 05:22 -!- nicoe(~nicoe@193.200.42.57) has joined #tryton
2010-12-21 06:06 -!- plantian(~ian@206-211-209-202.utilitytelephone.net) has joined #tryton
2010-12-21 08:06 -!- vladimir_(~vladimir@213.151.246.136) has joined #tryton
2010-12-21 08:34 -!- plantian(~ian@206-211-209-202.utilitytelephone.net) has joined #tryton
2010-12-21 08:36 <plantian> Is there information stored in a tryton database that would prevent a client from connecting to it after moving the database between servers? I'm trying to use the database from an sql file on another computer and the server starts fine and is listening on 8070 but the client will not connect with "Could not connect to server!".
2010-12-21 08:41 -!- paepke(~paepke@p4FEB0568.dip0.t-ipconnect.de) has joined #tryton
2010-12-21 08:42 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2010-12-21 08:47 -!- okko(~okko@62.58.29.41) has joined #tryton
2010-12-21 08:57 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2010-12-21 09:07 -!- paepke(~paepke@p4FEB0568.dip0.t-ipconnect.de) has joined #tryton
2010-12-21 09:07 <udono> plantian: did you use secure connection?
2010-12-21 09:09 <plantian> udono: I did not before but I tried turning it on and making cert+private-key but it didn't seem to make a difference.
2010-12-21 09:10 <plantian> I am sure it is some very simple mistake. I noticed that my postgresql version is newer on this computer than on my prior development machine, I hope that isn't it.
2010-12-21 09:10 <udono> plantian: delete ~/.config/tryton/<BRANCH>/known_hosts on client-side
2010-12-21 09:11 <udono> plantian: it could be the fingerprint check, which block the connection.
2010-12-21 09:12 <plantian> The client and server are the same machine and it should be using localhost.
2010-12-21 09:12 <plantian> I deleted the known_hosts entry though. Do I need to tell the client to use a secure connection or will it autodetect.
2010-12-21 09:13 <plantian> I should add that I am using trunk too.
2010-12-21 09:13 <udono> plantian: it will autodetect
2010-12-21 09:13 <udono> plantian: ust try again
2010-12-21 09:13 <udono> *just
2010-12-21 09:15 <udono> plantian: did the server outputs something, when the client tries to connect?
2010-12-21 09:16 <plantian> udono: [Tue Dec 21 00:14:40 2010] INFO:database:connect to "template1"
2010-12-21 09:16 <udono> plantian: it seems a database role problem.
2010-12-21 09:18 <udono> plantian: the given user/password for database in trytond.conf or ~/.pgpass seems not right.
2010-12-21 09:19 <udono> plantian: or the system user which start the server has no database access for the database you want to connect. Problem is AFAIS server-site.
2010-12-21 09:23 -!- okko(~okko@62.58.29.41) has joined #tryton
2010-12-21 09:26 <udono> plantian: best is to check the owner of the new database.
2010-12-21 09:27 <plantian> udono: Yeah it seems that psql does not check my password, so all passwords work. I think maybe something is wrong with my postgresql configuration.
2010-12-21 09:29 <plantian> Nevermind I guess that is how my other server works too.
2010-12-21 09:31 <plantian> Does trytond use the configuration settings when running update=... ?
2010-12-21 09:32 -!- nicoe(~nicoe@193.200.42.57) has left #tryton
2010-12-21 09:32 <udono> plantian: I think yes, because it needs to connect to the database and add/delete/modify tables/columns/values
2010-12-21 09:32 -!- nicoe(~nicoe@193.200.42.57) has joined #tryton
2010-12-21 09:33 <udono> plantian: but at least it uses the trytond/etc/trytond.conf if no other configuration is found
2010-12-21 09:33 -!- ecarreras(~under@unaffiliated/ecarreras) has joined #tryton
2010-12-21 09:37 <plantian> udono: Would the admin_password come into play?
2010-12-21 09:38 <udono> plantian: unsure. But I think it does not come into play on trytond -u
2010-12-21 09:39 <plantian> udono: --update=all with trytond seems to work fine an connects and does regular updating
2010-12-21 09:39 <plantian> Maybe it is some other host/ip resolution problem?
2010-12-21 09:40 <udono> plantian: ... I think admin_password is solely used for database administration tasks from the client, found in File > Database, but unsure
2010-12-21 09:40 -!- paepke(~paepke@p4FEB0696.dip0.t-ipconnect.de) has joined #tryton
2010-12-21 09:41 <udono> plantian: host/ip I do not think, too, because the server stats: [Tue Dec 21 00:14:40 2010] INFO:database:connect to "template1"
2010-12-21 09:41 <udono> plantian: who is the owner of your database and the tables inside?
2010-12-21 09:42 <udono> plantian: usually you just need to check one table and the database self.
2010-12-21 09:46 <plantian> udono: The owner is correct for database and tables, it is 'tfs'. The database is tfs-trunk though. Why does it try to connect to template1?
2010-12-21 09:47 <udono> plantian: so table owner is 'tfs' and database owner is 'tfs-trunk'?
2010-12-21 09:48 <plantian> udono: http://paste.pocoo.org/show/307750/
2010-12-21 09:48 <plantian> Database is tfs-trunk and database owner is tfs.
2010-12-21 09:48 <plantian> Is that wrong ?
2010-12-21 09:49 <udono> plantian: ok. Did you try to connect to tfs-trunk with user tfs via psql?
2010-12-21 09:50 <udono> plantian: It does not look wrong...
2010-12-21 09:52 <udono> plantian: something like sudo su tfs -c "psql tfs-trunk" should work.
2010-12-21 09:52 <plantian> I run tryton under a different shell user, maybe that is the problem.
2010-12-21 09:54 <udono> plantian: then you need to set the database connection in trytond.conf
2010-12-21 09:55 <udono> plantian: or put a ~/.pgpass for the system user, which runs trytond
2010-12-21 09:56 -!- vincentvdl(~vincent@62.58.29.41) has joined #tryton
2010-12-21 09:56 -!- bechamel(~user@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton
2010-12-21 09:57 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2010-12-21 09:59 -!- okko(~okko@62.58.29.41) has joined #tryton
2010-12-21 10:01 <udono> plantian: take a look into pg_hba.conf and find out how your database connection is set up. Take care of ident_sameuser and md5.
2010-12-21 10:01 <plantian> udono: The database connection is set in the trytond.conf and running trytond --update=all -d tfs-trunk as the shell user "ian" seems to work(the same as trytond server itself).
2010-12-21 10:01 <plantian> Yeah okay I will compare those with other server.
2010-12-21 10:02 <udono> plantian: ... another thing I recognized in trytond.conf is that interface = localhost does not work always. Then I used interface = 0.0.0.0
2010-12-21 10:06 -!- pjstevns(~pjstevns@a83-163-46-103.adsl.xs4all.nl) has joined #tryton
2010-12-21 10:22 -!- paepke(~paepke@p4FEB0696.dip0.t-ipconnect.de) has joined #tryton
2010-12-21 11:26 -!- jcm(~jcm@symetrie.net) has joined #tryton
2010-12-21 11:27 -!- dba_(~daniel@178.63.150.30) has joined #tryton
2010-12-21 11:29 -!- nicoe(~nicoe@193.200.42.57) has left #tryton
2010-12-21 11:30 -!- nicoe(~nicoe@193.200.42.57) has joined #tryton
2010-12-21 12:14 -!- enlightx(~enlightx@cust.static.84-253-54-235.cybernet.ch) has joined #tryton
2010-12-21 12:50 -!- okko(~okko@62.58.29.41) has joined #tryton
2010-12-21 13:01 -!- enlightx(~enlightx@cust.static.84-253-54-235.cybernet.ch) has joined #tryton
2010-12-21 13:32 -!- nicoe(~nicoe@193.200.42.57) has left #tryton
2010-12-21 13:34 -!- vincentvdl(~vincent@62.58.29.41) has left #tryton
2010-12-21 13:39 -!- vincentvdl(~vincent@62.58.29.41) has joined #tryton
2010-12-21 13:40 <vincentvdl> Hi... Feels like a "Tryton for Dummies" question.. but I couldn't find an example of an Or in a domain?
2010-12-21 13:43 <vincentvdl> For a view I only wat to display records that have a bool1 or bool2 field with value True
2010-12-21 13:53 <bechamel> vincentvdl: hi, should be something like Or(bool1, bool2)
2010-12-21 13:54 <udono> vincentvdl: bechamel: seems not so easy, it is a domain, not states
2010-12-21 13:55 <vincentvdl> @bechamel: A domain needs to be a tuple if I'm not mistaken?
2010-12-21 13:55 <bechamel> udono, vincentvdl: oh yes didn't read correctly
2010-12-21 13:55 <vincentvdl> @uduno: Thanks for confirming that ;-)
2010-12-21 13:55 <bechamel> ['OR', tuple1, tuple2]
2010-12-21 13:55 <udono> vincentvdl: Does this work: ['OR', ('bool1', '=', True), ('bool2', '=', True)]
2010-12-21 13:55 <udono> :-)
2010-12-21 13:56 <vincentvdl> uduno: first thing I tried :) Going to try bechamel's suggestion now
2010-12-21 13:57 <bechamel> vincentvdl: udono awnser should work actualy
2010-12-21 13:57 <vincentvdl> uduno, bechamel: Will doublecheck
2010-12-21 13:58 -!- vladimir_(~vladimir@213.151.246.136) has joined #tryton
2010-12-21 13:58 <udono> vincentvdl: ['OR', [('bool1', '=', True)], [('bool2', '=', True)]] should work
2010-12-21 13:59 <udono> vincentvdl: see http://doc.tryton.org/1.8/trytond/doc/topics/domain.html
2010-12-21 13:59 <vincentvdl> uduno: OK I see my errror, thought Or was a pyson function, so I had something like Or(....). Sorry!
2010-12-21 14:08 <vincentvdl> udono, bechamel: Thanks for your help, I managed to get it working
2010-12-21 14:08 <udono> vincentvdl: never mind
2010-12-21 14:08 <vincentvdl> <field name="domain">['OR', ('bool1', '=', True), ('bool2', '=', True)]</field>
2010-12-21 14:09 <bechamel> vincentvdl: your are welcome :)
2010-12-21 14:38 <Kavli> Is there a Tryton 4 Dummies somewhere. Some basic use-cases for the different modules. It feels stupid to ask basic questions in this forum. Like now I'm stuck at marking open invoices paid. I'm expecting a button in an open invoice, where I can issue a payment, but nope... How do I handle payments?
2010-12-21 14:41 <udono> Kavli: did you install account_statement?
2010-12-21 14:42 <Kavli> udono: account_statement is indeed installed.
2010-12-21 14:42 <udono> Kavli: If you install account_statement, then the pay button on invoice is invisible. You need to do your payments with account statement.
2010-12-21 14:44 <Kavli> Aha! So I should uninstall account_statement, to make it simple?
2010-12-21 14:44 <udono> Kavli: You can not uninstall modules in Tryton
2010-12-21 14:46 <Kavli> udono: Ok, but I'll start over without installing account_statement. :-) Ok. I'll see if I can make it shine now. Thanx so far!
2010-12-21 14:47 <udono> Kavli: welcome
2010-12-21 14:59 -!- gremly(~gremly@200.106.202.91) has joined #tryton
2010-12-21 15:10 -!- ecarreras(~under@unaffiliated/ecarreras) has joined #tryton
2010-12-21 15:13 -!- pepeu(~manuel@201.155.193.192) has joined #tryton
2010-12-21 15:27 -!- enlightx(~enlightx@cust.static.84-253-54-235.cybernet.ch) has joined #tryton
2010-12-21 16:05 <Kavli> udono: Ok. Now it works as I expected it to do! Thanks again!
2010-12-21 16:59 -!- vincentvdl(~vincent@62.58.29.41) has left #tryton
2010-12-21 17:12 -!- vincentvdl(~vincent@62.58.29.41) has joined #tryton
2010-12-21 17:39 -!- vladimir_(~vladimir@213.151.246.136) has joined #tryton
2010-12-21 17:44 -!- vladimir_(~vladimir@213.151.246.136) has joined #tryton
2010-12-21 17:48 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2010-12-21 18:13 -!- zodman(~andres-va@foresight/developer/zodman) has joined #tryton
2010-12-21 18:36 -!- chrue(~chrue@host-091-097-026-022.ewe-ip-backbone.de) has joined #tryton
2010-12-21 18:46 -!- vincentvdl(~vincent@62.58.29.41) has left #tryton
2010-12-21 18:48 -!- vladimir_(~vladimir@213.151.246.136) has joined #tryton
2010-12-21 18:53 -!- vladimir__(~vladimir@213.151.246.136) has joined #tryton
2010-12-21 19:06 -!- jcm(~jcm@cxr69-10-88-172-230-130.fbx.proxad.net) has joined #tryton
2010-12-21 19:08 -!- paepke(~paepke@p4FEB0696.dip0.t-ipconnect.de) has left #tryton
2010-12-21 20:44 -!- zodman(~andres-va@204.93.174.54) has joined #tryton
2010-12-21 21:35 -!- plantian(~ian@206-211-209-202.utilitytelephone.net) has joined #tryton
2010-12-21 22:00 -!- plantian(~ian@206-211-209-202.utilitytelephone.net) has joined #tryton
2010-12-21 22:17 -!- zodman(~andres-va@foresight/developer/zodman) has joined #tryton
2010-12-21 22:32 -!- oGc-SeyZ(~SeyZ@85.26.24.56) has joined #tryton
2010-12-21 22:35 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton

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