IRC logs of #tryton for Tuesday, 2017-01-03

chat.freenode.net #tryton log beginning Tue Jan 3 00:00:01 CET 2017
2017-01-03 01:02 -!- mamcode(~mamcode@190-204-34-148.dyn.dsl.cantv.net) has joined #tryton
2017-01-03 02:02 -!- leio(~leio@gentoo/developer/leio) has joined #tryton
2017-01-03 02:46 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2017-01-03 03:02 -!- kstenger1(~karla@r186-50-23-215.dialup.adsl.anteldata.net.uy) has joined #tryton
2017-01-03 03:17 -!- julio-o(~Thunderbi@corp-200-105-253-66.uio.puntonet.ec) has joined #tryton
2017-01-03 03:33 <LeBron> in my tryton client, i just get Database: Could not connect to the server. Host is localhost:8000
2017-01-03 03:40 -!- thaneor1(~ldlc6@r179-25-74-239.dialup.adsl.anteldata.net.uy) has joined #tryton
2017-01-03 03:46 <LeBron> ok, for localhost:5432, it throwss a long error "BadStatusLine"
2017-01-03 03:47 <kstenger> LeBron: the user is the one you choose, you can tell it to tryton through the configuration file. Which version are you installing?
2017-01-03 03:47 <LeBron> kstenger: tryton version 4.2.0
2017-01-03 03:48 <kstenger> LeBron: http://doc.tryton.org/4.2/trytond/doc/topics/configuration.html
2017-01-03 03:48 <LeBron> i have a postgres db called lebrondb owned by lebron. i then ran trytond-admin -c /etc/tryton/trytond.conf -d lebrondb --all
2017-01-03 03:49 <kstenger> LeBron: can you create a pastebin with the contents of your /etc/tryton/trytond.conf file ?
2017-01-03 03:49 <LeBron> inside my config file, i have uri=postgresql://lebron:password@localhost/. have also just tried "uri=postgresql://lebron:password@/"
2017-01-03 03:49 <LeBron> kstenger: sure
2017-01-03 03:52 <LeBron> kstenger: http://pastebin.com/zy8aWcNS
2017-01-03 03:55 <LeBron> kstenger: here is my psql -U postgres -c "\list" output: http://pastebin.com/nnGbnWKy
2017-01-03 03:55 <LeBron> then i run, "trytond-admin -c /etc/tryton/trytond.conf -d aldb --all". then i open the client, and i cannot connect to the database
2017-01-03 03:56 <LeBron> postgresql-9.5 is confirmed to be running
2017-01-03 03:57 <kstenger> LeBron: is "al" a system user or a postgresql role ?
2017-01-03 03:58 <LeBron> both
2017-01-03 03:58 <kstenger> LeBron: ok, did you ensure the role password is the same ?
2017-01-03 03:58 <LeBron> it is a role that shows up in psql \du
2017-01-03 03:58 <LeBron> i did not set a role password...
2017-01-03 04:00 <LeBron> sorry, this is a noob question. in the config file, is the password supposed to be the user or the role password?
2017-01-03 04:00 <kstenger> LeBron: IIRC it's the role's password
2017-01-03 04:00 <LeBron> so what is the password you set after you run trytond-admin -c?
2017-01-03 04:00 <kstenger> LeBron: but I would ensure both are equal
2017-01-03 04:01 <kstenger> LeBron: the one you set with trytind-admin is the one you will use inside tryton, for the 'admin' user
2017-01-03 04:01 <LeBron> kstenger: i set a role password. still can't get a connection in the client
2017-01-03 04:08 <LeBron> in the configuration.html, there are two alternative uri lines under pyscopg2. one without localhost, and one with a port.
2017-01-03 04:08 <kstenger> LeBron: what happens if you try using this instead? uri = postgresql://postgres:@localhost/
2017-01-03 04:11 <LeBron> what -d to put with my trytond-admin command?
2017-01-03 04:11 <kstenger> LeBron: aldb
2017-01-03 04:12 <LeBron> kstenger: tried -d aldb and -d postgres. same thing
2017-01-03 04:12 <LeBron> is there a verbose mode or another way to troubleshoot this?
2017-01-03 04:13 <kstenger> LeBron: yes, use -v and/or --debug
2017-01-03 04:13 <kstenger> LeBron: but -d value is the name you gave to your database
2017-01-03 04:13 <LeBron> kstenger: by default there is also a postgres database
2017-01-03 04:13 <LeBron> kstenger: yes, my database is present in postgres \list
2017-01-03 04:14 <kstenger> LeBron: the one you created
2017-01-03 04:14 <kstenger> for tryton
2017-01-03 04:14 <LeBron> kstenger: yes, i tried it with -d aldb
2017-01-03 04:15 <kstenger> LeBron: about the uri, I'm not sure this is the problem, you can try several setups, but usually the simpler works (sorry not too helpful on this point now)
2017-01-03 04:16 <LeBron> kstenger: i'm just trying to use the default setup with postgres
2017-01-03 04:19 <kstenger> LeBron: actually my current setup uses the uri given above despite the database I created for tryton is not called postgres...
2017-01-03 04:21 <LeBron> so in your client's profile, what do you put for host?
2017-01-03 04:21 <LeBron> and any mention to ports?
2017-01-03 04:25 <kstenger> LeBron: ah, it's because you have to add the [web] section, and a value of: listen = 127.0.0.1:8000 (so here you define host/port)
2017-01-03 04:26 <kstenger> LeBron: same host and port in client
2017-01-03 04:27 <kstenger> LeBron: the port you could define on the database section is just for the connection to the database (in case you don't use the postgres default)
2017-01-03 04:28 <LeBron> ok, i added [web] in with that line
2017-01-03 04:29 <LeBron> kstenger: no luck...
2017-01-03 04:31 <kstenger> LeBron: what's your uri now?
2017-01-03 04:34 <LeBron> i used the one you gave me. uri = postgresql://postgres:@localhost/
2017-01-03 04:34 <LeBron> also tried uri = postgresql://al:a@localhost:8000/
2017-01-03 04:34 <LeBron> and also with my hostname
2017-01-03 04:34 -!- leio(~leio@gentoo/developer/leio) has joined #tryton
2017-01-03 04:35 -!- kstenger(~karla@r186-50-23-215.dialup.adsl.anteldata.net.uy) has joined #tryton
2017-01-03 04:35 -!- thaneor1(~ldlc6@r179-25-74-239.dialup.adsl.anteldata.net.uy) has joined #tryton
2017-01-03 04:36 <kstenger> LeBron: try: uri = postgresql://al:a@localhost/
2017-01-03 04:37 <kstenger> actually
2017-01-03 04:37 <kstenger> ah, nm
2017-01-03 04:38 <kstenger> LeBron: or: uri = postgresql://al@localhost/
2017-01-03 04:38 <LeBron> so i did that. and then i ran the client againl. and i put in "localhost" or "localhost:8000" and no luck
2017-01-03 04:39 <LeBron> kstenger: just did that one now. no luck
2017-01-03 04:39 <kstenger> LeBron: 8000 is not for here, here you connect to postgres, so should be 5432 by default
2017-01-03 04:39 <LeBron> kstenger: same as earlier, if i put in port 5432, i get this error
2017-01-03 04:40 <LeBron> http://pastebin.com/JgYkDV5V
2017-01-03 04:47 <kstenger> LeBron: sorry I don't see what's wrong, hope you can find help with someone else later
2017-01-03 04:47 <LeBron> kstenger: thanks. i posted to the google group, but i can't see my post anymore. perhaps it needs admin approval
2017-01-03 04:48 <kstenger> LeBron: it may take a few minutes to appearfrom my experience
2017-01-03 04:50 <LeBron> it says "recently posted to". hm. thanks forf the help, i will leave my computer on to stay on this channel
2017-01-03 07:32 -!- dj_xatra(~dj_xatra@217.166.83.130) has joined #tryton
2017-01-03 08:08 -!- rpit(~rpit@aftr-37-24-151-184.unity-media.net) has joined #tryton
2017-01-03 08:38 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton
2017-01-03 08:46 -!- mrichez(~smuxi@mail.saluc.com) has joined #tryton
2017-01-03 08:50 -!- csotelo(~csotelo@2001:1388:49c5:892a:c074:b598:d35d:d34f) has joined #tryton
2017-01-03 08:50 -!- udono(~udono@tmo-098-189.customers.d1-online.com) has joined #tryton
2017-01-03 09:12 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton
2017-01-03 09:29 -!- LordVan(~lordvan@gentoo/developer/LordVan) has joined #tryton
2017-01-03 10:00 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2017-01-03 10:04 -!- Piyush__(0116a082@gateway/web/freenode/ip.1.22.160.130) has joined #tryton
2017-01-03 10:05 <Piyush__> how can make JSON request for party >configuration >companies >the company >currency to get standard currency?
2017-01-03 10:23 -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton
2017-01-03 11:26 <Piyush__> how can I make JSON request for party >configuration >companies >the company >currency to get standard currency?
2017-01-03 11:43 <cedk> Piyush__: like any read request
2017-01-03 11:44 <Piyush__> cedk: I want to know the modal/ api name for the request
2017-01-03 11:49 <Piyush__> model*
2017-01-03 12:03 <cedk> Piyush__: you should look in adminstration>models menu
2017-01-03 12:31 -!- mamcode(~mamcode@190.79.52.100) has joined #tryton
2017-01-03 12:34 -!- thaneor(~ldlc6@r179-25-74-239.dialup.adsl.anteldata.net.uy) has joined #tryton
2017-01-03 12:36 <Piyush__> how to get default currency & payment term while creating new sale?
2017-01-03 13:19 -!- notizblock(~notizbloc@nblock.org) has joined #tryton
2017-01-03 13:19 -!- giesen(~ggiesen@2001:19f0:0:1019:5400:ff:fe25:bda6) has joined #tryton
2017-01-03 13:29 <Piyush__> cedk: I am able to get all currency with currency.currency model, but could not get identified for party >configuration >companies >the company >currency
2017-01-03 13:32 <cedk> Piyush__: it is the company.company
2017-01-03 13:35 <Piyush__> I got that! thanks cedk
2017-01-03 13:53 -!- smarro(~sebastian@181.16.7.104) has joined #tryton
2017-01-03 14:10 -!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton
2017-01-03 15:08 -!- meigallodixital(~meigallod@249.135.116.91.static.reverse-mundo-r.com) has joined #tryton
2017-01-03 15:30 -!- giesen(quassel@ego.giesen.me) has joined #tryton
2017-01-03 15:45 -!- thaneor(~ldlc6@r179-25-79-46.dialup.adsl.anteldata.net.uy) has joined #tryton
2017-01-03 15:59 -!- julio-o(~Thunderbi@corp-200-105-253-66.uio.puntonet.ec) has joined #tryton
2017-01-03 17:18 -!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton
2017-01-03 17:21 -!- JanGB(~jan@193.174.248.1) has joined #tryton
2017-01-03 17:34 -!- JanGB(~jan@nat3.hmt-leipzig.de) has joined #tryton
2017-01-03 17:50 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton
2017-01-03 18:01 -!- smarro(~sebastian@181.16.7.104) has joined #tryton
2017-01-03 18:32 -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton
2017-01-03 18:38 -!- smarro(~sebastian@181.16.7.104) has joined #tryton
2017-01-03 18:44 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has left #tryton
2017-01-03 19:08 -!- LeBron(~a@CPEbc4dfba26313-CMbc4dfba26310.cpe.net.cable.rogers.com) has left #tryton
2017-01-03 20:36 -!- sebd(~seb@aditu.ldd.fr) has joined #tryton
2017-01-03 21:14 -!- thaneor(~ldlc6@r179-24-114-72.dialup.adsl.anteldata.net.uy) has joined #tryton

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