IRC logs of #tryton for Monday, 2014-03-10

chat.freenode.net #tryton log beginning Mon Mar 10 00:00:01 CET 2014
2014-03-10 00:22 -!- smarro(~sebastian@190.105.85.74) has joined #tryton
2014-03-10 00:53 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-03-10 02:57 -!- quisto(~quisto@190.55.80.169) has joined #tryton
2014-03-10 03:56 -!- _Dominik_(~cubie@178-27-83-239-dynip.superkabel.de) has joined #tryton
2014-03-10 06:02 -!- yangoon1(~mathiasb@p549F1806.dip0.t-ipconnect.de) has joined #tryton
2014-03-10 06:40 -!- frispete(~frispete@p54A93920.dip0.t-ipconnect.de) has joined #tryton
2014-03-10 07:19 -!- mfladischer(~fladische@sh144.medunigraz.at) has joined #tryton
2014-03-10 07:23 -!- udono(~udono@ip-88-152-168-173.unitymediagroup.de) has joined #tryton
2014-03-10 07:45 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton
2014-03-10 08:19 -!- strebitz(~sebastian@91.183.59.105) has joined #tryton
2014-03-10 08:38 -!- jeancavallo(~giovanni@LVelizy-156-46-68-52.w80-12.abo.wanadoo.fr) has joined #tryton
2014-03-10 08:42 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton
2014-03-10 09:16 -!- pokoli(~pokoli@unaffiliated/pokoli) has joined #tryton
2014-03-10 09:17 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has joined #tryton
2014-03-10 09:19 -!- azi(~azi@75.144.20.73) has joined #tryton
2014-03-10 09:57 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-03-10 10:12 -!- andygraybeal(~andy@h109.215.22.98.dynamic.ip.windstream.net) has joined #tryton
2014-03-10 10:24 -!- strebitz(~sebastian@91.183.59.105) has left #tryton
2014-03-10 11:11 -!- nicoe(~nicoe@2001:6f8:3aa:0:b699:baff:fe56:2328) has joined #tryton
2014-03-10 11:15 -!- corro(~corro@46.22.23.85) has joined #tryton
2014-03-10 11:22 -!- Telesight(~anthony@77-175-168-222.FTTH.ispfabriek.nl) has joined #tryton
2014-03-10 11:33 -!- grasbauer(~jan@dslb-094-222-149-079.pools.arcor-ip.net) has joined #tryton
2014-03-10 11:44 -!- smarro(~sebastian@190.105.85.74) has joined #tryton
2014-03-10 11:47 -!- Dinkar_(~Dinkar@c-68-36-206-189.hsd1.nj.comcast.net) has joined #tryton
2014-03-10 12:05 -!- jeancavallo(~giovanni@LVelizy-156-46-68-52.w80-12.abo.wanadoo.fr) has joined #tryton
2014-03-10 12:10 -!- hiaselhans(~hiaselhan@212.186.35.254) has joined #tryton
2014-03-10 12:21 -!- mariomop(~quassel@host249.186-109-105.telecom.net.ar) has joined #tryton
2014-03-10 12:46 <hiaselhans> hi there
2014-03-10 12:47 <hiaselhans> i have a question once again
2014-03-10 12:47 <hiaselhans> is it possible to disable form_print button per domain?
2014-03-10 12:47 <hiaselhans> for example in 'state' = 'draft'
2014-03-10 12:47 <hiaselhans> ?
2014-03-10 12:54 <cedk> hiaselhans: no
2014-03-10 12:55 <cedk> hiaselhans: but in trunk, you can use a button
2014-03-10 12:58 <hiaselhans> ok cool, like cls._update_buttons()?
2014-03-10 12:58 <hiaselhans> cls._buttons.update
2014-03-10 12:58 <hiaselhans> i meant
2014-03-10 14:18 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has joined #tryton
2014-03-10 15:07 -!- azi(~azi@75.144.20.73) has joined #tryton
2014-03-10 15:31 -!- freeq(~freeq@6.Red-83-47-127.dynamicIP.rima-tde.net) has joined #tryton
2014-03-10 15:31 <freeq> hi
2014-03-10 15:33 <freeq> i have a question.. i am installing GNU Health which includes Tryton on Ubuntu 12.04.. I have followed all instructions, started the tryton server . now I am connecting from Windows Tryton client and when it's trying to fetch the Databse list it results in "Could not connect to server"
2014-03-10 15:33 <freeq> however when I check on the server end I see this:
2014-03-10 15:34 <freeq> gnuhealth:~/gnuhealth/tryton/server/trytond-3.0.2/bin $ ./trytond
2014-03-10 15:34 <freeq> [Mon Mar 10 14:01:58 2014] INFO:server:using /home/gnuhealth/gnuhealth/tryton/server/trytond-3.0.2/etc/trytond.conf as configuration file
2014-03-10 15:34 <freeq> [Mon Mar 10 14:01:58 2014] INFO:server:initialising distributed objects services
2014-03-10 15:34 <freeq> [Mon Mar 10 14:01:58 2014] INFO:server:starting JSON-RPC protocol on *:8000
2014-03-10 15:34 <freeq> [Mon Mar 10 14:02:05 2014] INFO:database:connect to "template1"
2014-03-10 15:34 <freeq> [Mon Mar 10 14:02:07 2014] INFO:database:connect to "template1"
2014-03-10 15:34 <freeq> so it seems as though the connection is coming through
2014-03-10 15:34 <freeq> not sure what's going wrong
2014-03-10 15:34 <freeq> any ideas?
2014-03-10 15:35 <nicoe> freeq: it's the database connection that is up not the client to the server connection
2014-03-10 15:37 <freeq> makes sense.. is there any log file where I could see in more detail what's happening
2014-03-10 15:37 <freeq> ?
2014-03-10 15:39 <freeq> the thing is, in the Tryton version coming with GNU Health the config file has most lines commented out
2014-03-10 15:39 <freeq> I am not sure if that's correct
2014-03-10 15:40 <freeq> the instructions don't mention that I would have to change anything like db_type
2014-03-10 15:40 <freeq> but it's commented out
2014-03-10 15:49 <corro> freeq: there are default values for the settings. For example default db_type is 'postgresql'.
2014-03-10 15:49 -!- andygraybeal(~andy@h109.215.22.98.dynamic.ip.windstream.net) has joined #tryton
2014-03-10 15:51 <corro> freeq: and GNU health questions you should probably better ask in #gnu-health
2014-03-10 15:51 <freeq> corro: thanks.. tried there yesterday but it was a bit inactive.. i figured the issue may be somewhere on the Tryton server config or something
2014-03-10 15:51 <corro> freeq: I don't know the GNU health installation instructions, but it looks like there is a problem connecting to the database. Do you have a local or a remote database server?
2014-03-10 15:51 <freeq> it's local
2014-03-10 15:51 <freeq> postgres
2014-03-10 15:51 <corro> freeq: can you connect to the db using the psql command line tool?
2014-03-10 15:52 <freeq> but i have to say i didn't do any config except setting up the gnuhealth DB and user
2014-03-10 15:52 <freeq> i think GNU Health sets up the rest
2014-03-10 15:52 <freeq> to be honest i'm not really a Tryton/Postgres expert :|
2014-03-10 15:52 <freeq> since it's a vserver I also have the option of using another distro, Debian or CentOS, any of those work better with Tryton/GNU Health than Ubuntu?
2014-03-10 15:58 <freeq> corro: not sure.. how would I do that? the DB name is "gnuhealth"
2014-03-10 15:58 <corro> freeq: just try 'psql'
2014-03-10 15:59 <freeq> psql: FATAL: database "gnuhealth" does not exist
2014-03-10 15:59 <freeq> hmm
2014-03-10 15:59 <freeq> strange
2014-03-10 15:59 <freeq> i did create it according to instructions
2014-03-10 16:00 <corro> freeq: try this command again: su - postgres -c "createuser --createdb --no-createrole --no-superuser gnuhealth"
2014-03-10 16:00 <corro> freeq: but as root user
2014-03-10 16:00 <corro> freeq: not the gnuhealth user you seem to work with right now
2014-03-10 16:01 <freeq> ok will try
2014-03-10 16:01 <freeq> root:~# su - postgres -c "createuser --createdb --no-createrole --no-superuser gnuhealth"
2014-03-10 16:01 <freeq> createuser: creation of new role failed: ERROR: role "gnuhealth" already exists
2014-03-10 16:03 <corro> freeq: guessed so... well then let's create just the database: su - postgres -c "createdb --owner=gnuhealth gnuhealth"
2014-03-10 16:03 <freeq> as root right?
2014-03-10 16:03 <corro> freeq: yes
2014-03-10 16:03 <freeq> done
2014-03-10 16:04 <freeq> now it connects to the database if i type psql
2014-03-10 16:04 <corro> freeq: start the server once again and try to connect
2014-03-10 16:05 <freeq> ok
2014-03-10 16:06 <freeq> same issue still :(
2014-03-10 16:07 <freeq> [Mon Mar 10 15:05:24 2014] INFO:server:using /home/gnuhealth/gnuhealth/tryton/server/trytond-3.0.2/etc/trytond.conf as configuration file
2014-03-10 16:07 <freeq> [Mon Mar 10 15:05:24 2014] INFO:server:initialising distributed objects services
2014-03-10 16:07 <freeq> [Mon Mar 10 15:05:24 2014] INFO:server:starting JSON-RPC protocol on *:8000
2014-03-10 16:07 <freeq> [Mon Mar 10 15:05:29 2014] INFO:database:connect to "template1"
2014-03-10 16:07 <freeq> [Mon Mar 10 15:05:31 2014] INFO:database:connect to "template1"
2014-03-10 16:07 <freeq> [Mon Mar 10 15:05:33 2014] INFO:database:connect to "template1"
2014-03-10 16:07 <freeq> [Mon Mar 10 15:06:25 2014] INFO:database:connect to "template1"
2014-03-10 16:07 <freeq> [Mon Mar 10 15:06:33 2014] INFO:database:connect to "template1"
2014-03-10 16:07 <corro> freeq: did you start the server as the gnuhealth user?
2014-03-10 16:07 <freeq> yes
2014-03-10 16:08 <freeq> could there be an issue with packages or versions?
2014-03-10 16:09 <freeq> i did upgrade from 10.04 before, since it's a VPS I had to do the upgrade and couldn't install from scratch
2014-03-10 16:10 <freeq> the thing was on a previous image (unrelated to the current) I did get the connection to work on Ubuntu 10.04, but then could not install the modules.. i figured would be better to upgrade to 12.04 at that point
2014-03-10 16:10 <freeq> so i restored 10.04 image clean and then did the upgrade
2014-03-10 16:10 <freeq> followed by install of GNU Health
2014-03-10 16:11 <corro> freeq: looks like the gnuhealth package is pretty self contained, I don't think the problem is related to your system.
2014-03-10 16:12 <freeq> ok
2014-03-10 16:13 <freeq> would it be useful to check postgres logs?
2014-03-10 16:13 <corro> freeq: could you please post the trytond.conf on pastebin.org (or something similar)?
2014-03-10 16:13 <freeq> sure
2014-03-10 16:13 <freeq> btw, thanks for all the help so far, appreciated
2014-03-10 16:13 <corro> freeq: you're welcome
2014-03-10 16:15 <freeq> http://pastebin.com/qfC8KQSu
2014-03-10 16:16 <freeq> this is the standard one, I only changed "jsonrpc = local:8000" to "jsonrpc = *:8000"
2014-03-10 16:17 <corro> freeq: looks correct, default values should be fine if you're able to log in via psql
2014-03-10 16:17 <pokoli> freeq: you must set your db_user and db_password for the gnuhealth you created to access postgresql
2014-03-10 16:19 <freeq> ok I can try that
2014-03-10 16:19 <freeq> would the db user and password need to be equal to the username and password of gnuhealth user?
2014-03-10 16:20 <freeq> or is that independent?
2014-03-10 16:20 <corro> pokoli: not necessarily if he uses peer authentication?
2014-03-10 16:21 <pokoli> corro: AFAIK peer authentication is disabled by default
2014-03-10 16:22 <freeq> i am connection from a remote client btw
2014-03-10 16:22 <pokoli> freeq: corro frist thing I will try is to connect to Postgresql manually from comandline
2014-03-10 16:22 <corro> pokoli: did already work using peer auth
2014-03-10 16:23 <freeq> ~/gnuhealth/tryton/server/trytond-3.0.2/bin $ psql
2014-03-10 16:23 <freeq> psql (9.1.12)
2014-03-10 16:23 <freeq> Type "help" for help.
2014-03-10 16:23 <freeq> gnuhealth=> help
2014-03-10 16:23 <pokoli> freeq: in which user are you runing postgresql?
2014-03-10 16:24 <freeq> gnuhealth
2014-03-10 16:24 <freeq> ah you mean the server
2014-03-10 16:24 <freeq> i guess root, how can i check?
2014-03-10 16:24 <pokoli> freeq: yes, the server
2014-03-10 16:25 <pokoli> freeq: can you run trytond from the comandline, just type ./trytond in the bin folder
2014-03-10 16:26 <freeq> root:/bin# ./trytond
2014-03-10 16:26 <freeq> -bash: ./trytond: No such file or directory
2014-03-10 16:26 <freeq> tryton is installed within the GNU Health installation though
2014-03-10 16:26 <freeq> under gnuhealth user
2014-03-10 16:27 <pokoli> freeq: so run under the gnuhealth user, in the ~/gnuhealth/tryton/server/trytond-3.0.2/bin folder :P
2014-03-10 16:29 <freeq> ~/gnuhealth/tryton/server/trytond-3.0.2/bin $ ./trytond
2014-03-10 16:29 <freeq> [Mon Mar 10 15:29:47 2014] INFO:server:using /home/gnuhealth/gnuhealth/tryton/server/trytond-3.0.2/etc/trytond.conf as configuration file
2014-03-10 16:29 <freeq> [Mon Mar 10 15:29:47 2014] INFO:server:initialising distributed objects services
2014-03-10 16:29 <freeq> [Mon Mar 10 15:29:48 2014] INFO:server:starting JSON-RPC protocol on *:8000
2014-03-10 16:30 <pokoli> freeq: All seems ok. Can you connect from the client and create a database?
2014-03-10 16:31 <freeq> nope.. i get the "Could not connect to server" error
2014-03-10 16:32 <freeq> although i do see the connection on the server
2014-03-10 16:32 <freeq> [Mon Mar 10 15:30:23 2014] INFO:server:starting JSON-RPC protocol on *:8000
2014-03-10 16:32 <freeq> [Mon Mar 10 15:30:27 2014] INFO:database:connect to "template1"
2014-03-10 16:32 <freeq> [Mon Mar 10 15:30:30 2014] INFO:database:connect to "template1"
2014-03-10 16:32 <freeq> [Mon Mar 10 15:30:36 2014] INFO:database:connect to "template1"
2014-03-10 16:32 <freeq> [Mon Mar 10 15:30:39 2014] INFO:database:connect to "template1"
2014-03-10 16:32 <freeq> [Mon Mar 10 15:30:44 2014] INFO:database:connect to "template1"
2014-03-10 16:33 <corro> these are attempted connections to the server. Trytond retries failed attempts five times by default (hence the five connects to template1).
2014-03-10 16:33 <corro> there must be a db connection issue, but I don't really see why
2014-03-10 16:35 <freeq> are there any useful logs to check for more details?
2014-03-10 16:36 <pokoli> freeq: corro I imagine that peer is only enabled for local sockets, and tryton is ussing a tpc-socket for connecting postgresql
2014-03-10 16:36 <pokoli> freeq: could you try psql -U gnuhealth -h localhost gnuhealth
2014-03-10 16:37 <freeq> sure
2014-03-10 16:37 <corro> pokoli: that's not the default behavior of trytond, it uses peer auth by default
2014-03-10 16:38 -!- smarro(~sebastian@190.105.85.74) has joined #tryton
2014-03-10 16:39 <freeq> that command seems to be doing nothing
2014-03-10 16:40 <pokoli> freeq: have you changed any config in the postgresql configuration?
2014-03-10 16:41 <pokoli> freeq: could you paste the output of: netstat -putan | grep 5432
2014-03-10 16:43 <freeq> nothing comes back
2014-03-10 16:46 <freeq> didn't change anyting either in postgresql config
2014-03-10 16:46 <freeq> clean install
2014-03-10 16:46 <pokoli> freeq: so your postgresql is only listening to local socket, so you can't conect to it
2014-03-10 16:47 <freeq> ok, how do i change that?
2014-03-10 16:47 <pokoli> freeq: in postgresql pg_hba.conf
2014-03-10 16:49 <freeq> seems i have 2 postgres dirs
2014-03-10 16:49 <freeq> find / -name "pg_hba.conf"
2014-03-10 16:50 <freeq> 9.1 and 8.4
2014-03-10 16:53 <freeq> contents of pg_hba.conf of 9.1: http://pastebin.com/15LwNAgm
2014-03-10 16:54 <pokoli> freeq: it's enabled on line 39
2014-03-10 16:55 <pokoli> freeq: so I guess your running 8.4
2014-03-10 16:56 <freeq> how can i see which one i'm running?
2014-03-10 16:59 <freeq> pg_hba.conf for 8.4: http://pastebin.com/esQ4Tsc7
2014-03-10 17:42 -!- azi1(~azi@75.144.20.73) has joined #tryton
2014-03-10 17:47 -!- pablovannini(~pablo@181.47.176.42) has joined #tryton
2014-03-10 18:01 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-03-10 18:14 -!- littlebit(~Thunderbi@ulmg-5d84566c.pool.mediaWays.net) has joined #tryton
2014-03-10 19:12 -!- rafiu(~Adium@host81-139-178-190.in-addr.btopenworld.com) has joined #tryton
2014-03-10 19:46 -!- azi(~azi@c-69-181-105-205.hsd1.ca.comcast.net) has joined #tryton
2014-03-10 19:47 -!- azi1(~azi@173-164-176-58-SFBA.hfc.comcastbusiness.net) has joined #tryton
2014-03-10 19:57 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has left #tryton
2014-03-10 20:45 -!- freeq123(~freeq@6.Red-83-47-127.dynamicIP.rima-tde.net) has joined #tryton
2014-03-10 20:56 -!- zdvbox(~zdvbox@95.215.140.56) has joined #tryton
2014-03-10 21:35 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton
2014-03-10 22:34 -!- frispete(~frispete@p54A93920.dip0.t-ipconnect.de) has joined #tryton
2014-03-10 22:39 -!- azi(~azi@173-164-176-58-SFBA.hfc.comcastbusiness.net) has joined #tryton
2014-03-10 22:45 -!- freeq(~freeq@6.Red-83-47-127.dynamicIP.rima-tde.net) has joined #tryton

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