IRC logs of #tryton for Friday, 2016-11-18

chat.freenode.net #tryton log beginning Fri Nov 18 00:00:01 CET 2016
2016-11-18 00:00 <stav> trudat
2016-11-18 00:01 <stav> been playing with demo3.4
2016-11-18 00:01 <stav> with username: demo
2016-11-18 00:01 <stav> could i cheat into it from there?
2016-11-18 00:01 <kstenger> cheat?
2016-11-18 00:01 <stav> get to postrgresql shell
2016-11-18 00:02 <stav> then change permissions / create databases
2016-11-18 00:02 <kstenger> stav: no, the demo is not installed in your computer, it's a demo server provided by tryton
2016-11-18 00:02 <stav> oh
2016-11-18 00:04 <kstenger> stav: given your surprise I have to ask, are you sure you installed both tryton and trytond (the tryton server) ?
2016-11-18 00:07 -!- xcodinas(~xcodinas@5.134.115.102) has joined #tryton
2016-11-18 00:07 <stav> ill check in synaptic
2016-11-18 00:08 <kstenger> check if the command trytond is available on command line
2016-11-18 00:09 <stav> tryton-neso and tryton-server-doc are not installed
2016-11-18 00:09 <stav> neso is server methinks
2016-11-18 00:09 <stav> im installing it
2016-11-18 00:09 <kstenger> stav: no
2016-11-18 00:10 <stav> ok
2016-11-18 00:10 <stav> ?? Tryton is a high-level general purpose application platform written in Python
2016-11-18 00:10 <stav> and using PostgreSQL as database engine. It is the core base of a complete
2016-11-18 00:10 <stav> business solution.
2016-11-18 00:10 <stav> This package provides a standalone client/server package for Tryton.
2016-11-18 00:10 <kstenger> neso is a mix of client and server, but it doesn't exist anymore in newer versions. I dont have experience with it, but you dont need it
2016-11-18 00:11 <stav> ok
2016-11-18 00:11 <kstenger> stav: please, don't paste too many lines in the chat. If necessary at any time, use a pastebin service and post the url
2016-11-18 00:12 <kstenger> stav: I have to go out a few minutes
2016-11-18 00:12 <stav> oh.. i got it
2016-11-18 00:13 <stav> root@vDebJessHw10:/home/stav# sudo -u postgres psql postgres
2016-11-18 00:13 <stav> psql (9.4.9)
2016-11-18 00:13 <stav> Type "help" for help.
2016-11-18 00:13 <stav> postgres=#
2016-11-18 00:13 <stav> ok.. to be continued... thanks for your help
2016-11-18 00:18 <stav> is anyone there?
2016-11-18 00:22 <stav> sorry about 'pastebin' ... i'll figure out what that is and not do it again
2016-11-18 00:29 <stav> if anyone's there and knows how to find the <config file> in the context of initializing a database,
2016-11-18 00:30 <stav> please let me know.. much appreciated
2016-11-18 00:49 <kstenger> stav: did you already figure out pastebin.com ? :-)
2016-11-18 00:50 <stav> no.. using xchat and i dont see pastebin in any of the menus
2016-11-18 00:51 <kstenger> also, at this time is past midnight in europe, so many are slept/out for a beer :p
2016-11-18 00:51 <stav> oh cool.. im in montreal canada
2016-11-18 00:51 <kstenger> just go to pastebin.com from your browser
2016-11-18 00:51 <stav> 7pm (1900) here
2016-11-18 00:51 <kstenger> 9pm for me ;-)
2016-11-18 00:52 <stav> im much obliged to you sir. ive made progress... editing pg_hba.conf file and such to allow local connection
2016-11-18 00:53 <stav> created a user
2016-11-18 00:53 <stav> ill continue another time
2016-11-18 00:53 <kstenger> great, it's a nice feeling to advance on your own, I know :-)
2016-11-18 00:54 <stav> be well friend
2016-11-18 01:28 -!- stav(~stav@mtrlpq4381w-lp130-02-76-66-182-77.dsl.bell.ca) has joined #tryton
2016-11-18 01:33 <stav> anyone with postgresql knowledge listening?
2016-11-18 01:34 <stav> trying to setup new company and create users..
2016-11-18 01:34 <stav> not the user friendliest
2016-11-18 01:34 <stav> ..
2016-11-18 01:36 <kstenger> stav: as a general rule, just ask your question, explain what you are doing and where you got stuck.
2016-11-18 01:36 <kstenger> stav: Where are you now?
2016-11-18 01:40 <stav> ill remember
2016-11-18 01:41 <stav> editing pg_hba.conf again
2016-11-18 01:42 <stav> local all all md5 (was peer)
2016-11-18 01:43 <stav> so i think it's ok
2016-11-18 01:43 <stav> restarted postgresql,
2016-11-18 01:44 <stav> now trying to create database
2016-11-18 01:46 <stav> so i did: trytond -c <pg_hba.conf> -d <testdb01> --all
2016-11-18 01:46 <stav> from postgresql shell but db wasn't created...
2016-11-18 01:47 <stav> \l did not show "testdb01"
2016-11-18 01:47 <kstenger> stav: 1) whenever you see a pair of <> in a tutorial, don't use them on your command, it's just for you to fill in the blanks
2016-11-18 01:47 <stav> oh
2016-11-18 01:48 <kstenger> stav: 2) the postgres shell is for SQL commands, not for that command. The "initialization" of the db with that command is done after you had created a DB in postgres
2016-11-18 01:48 <kstenger> 3
2016-11-18 01:48 <kstenger> (sorry)
2016-11-18 01:48 <stav> got it... i'll try it
2016-11-18 01:49 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2016-11-18 01:51 <kstenger> stav: 3) instead of using psql you can use the command line "createdb trytondb -E utf8 -O tryton -U postgres" This assumes you have a tryton user that will owe the database once created, and it's name will be trytondb
2016-11-18 01:54 <stav> from linux prompt?
2016-11-18 01:54 <kstenger> stav: 4) you cannot use the conf file of postgres as a configuration file for tryton. Check this url to understand the config file for tryton: http://doc.tryton.org/3.4/trytond/doc/topics/configuration.html
2016-11-18 01:54 <kstenger> stav: yes
2016-11-18 01:55 <kstenger> stav: also, if the file is not in your current directory use the full path
2016-11-18 01:58 <stav> can i paste 2 lines of terminal text?
2016-11-18 01:59 <stav> got error: peer authentication failed for user "postgres"
2016-11-18 01:59 <kstenger> yes, 2 lines is fine :)
2016-11-18 01:59 <stav> root@vDebJessHw10:/# createdb trytondb -E utf8 -O tryton -U postgres
2016-11-18 01:59 <stav> createdb: could not connect to database template1: FATAL: Peer authentication failed for user "postgres"
2016-11-18 02:01 <kstenger> you can also start to filter the lines, and show the most relevant, in this case just the last one. It looks weird to me that error because you should have a postgres user I think
2016-11-18 02:02 <kstenger> otherwise, you can use the postgres user directly and avoid the -U parameter
2016-11-18 02:02 <kstenger> so
2016-11-18 02:02 <kstenger> "su - postgres"
2016-11-18 02:02 <kstenger> then "createdb trytondb -E utf8 -O tryton"
2016-11-18 02:07 <stav> tried and got: ERROR: role "tryton" does not exist
2016-11-18 02:08 <stav> to create user i did: "CREATE USER stavadmin01"
2016-11-18 02:08 <kstenger> and the result?
2016-11-18 02:10 <stav> this was done before in the prompt: postgres=#
2016-11-18 02:10 <stav> postgres=# CREATE USER stavadmin01
2016-11-18 02:10 <stav> postgres-# /q
2016-11-18 02:11 <stav> = turned into -
2016-11-18 02:12 <kstenger> ok, you missed one semicolon at the end of the sql command BUT it's either one or the other. createdb is just simpler to use
2016-11-18 02:12 <kstenger> I see one problem that is you don't have yet a user for tryton, which would be convenient
2016-11-18 02:13 <kstenger> so create a linux user called tryton, and then try the createdb command again
2016-11-18 02:17 <stav> just "adduser tryton" ?
2016-11-18 02:18 <kstenger> yes
2016-11-18 02:18 <kstenger> I guess
2016-11-18 02:18 -!- morfeokmg(~smuxi@189.146.48.254) has joined #tryton
2016-11-18 02:19 <stav> my linux prompt now says: postgres@vDebJessHw10:/$
2016-11-18 02:19 <stav> should i adduser from this prompt or root prompt?
2016-11-18 02:19 <kstenger> adduser from root prompt
2016-11-18 02:20 <stav> The user `tryton' already exists.
2016-11-18 02:20 <kstenger> ah ok, then we shall just create the role
2016-11-18 02:20 <stav> seems appropriate
2016-11-18 02:21 <kstenger> this is postgres stuff, go back into the postgres prompt
2016-11-18 02:21 <kstenger> run psql
2016-11-18 02:23 <kstenger> run this command in there
2016-11-18 02:23 <kstenger> CREATE ROLE tryton WITH CREATEDB;
2016-11-18 02:23 <stav> login only works if i do : "sudo -u postgres psql postgres"
2016-11-18 02:24 <stav> psql command asks for password that doesn't work
2016-11-18 02:24 <kstenger> doesn't just "su - postgres" work when you are root?
2016-11-18 02:25 <stav> root@vDebJessHw10:/# su - postgres
2016-11-18 02:25 <stav> postgres@vDebJessHw10:~$
2016-11-18 02:25 <kstenger> then now "psql"
2016-11-18 02:26 <stav> ok now postgres=#
2016-11-18 02:26 <kstenger> CREATE ROLE tryton WITH CREATEDB;
2016-11-18 02:27 <stav> ? exactly as you wrote it?
2016-11-18 02:27 <kstenger> yes
2016-11-18 02:28 <stav> ok.. replied: CREATE ROLE
2016-11-18 02:29 <stav> and then postgres=#
2016-11-18 02:29 <stav> i'm really thankful that tryton people kept it simple
2016-11-18 02:29 <kstenger> quit the postgres shell
2016-11-18 02:29 <kstenger> this is postgres stuff so far
2016-11-18 02:30 <stav> ok now at prompt: "postgres@vDebJessHw10:~$ "
2016-11-18 02:30 <kstenger> repeat the createdb command now
2016-11-18 02:30 <stav> should i 'undo' edits to .conf file at some point?
2016-11-18 02:31 <kstenger> given you changed the configuration file of postgres (not the tryton one) I'd say yes, but I cannot tell for sure
2016-11-18 02:31 <stav> do you mean..
2016-11-18 02:32 <stav> CREATE ROLE tryton WITH CREATEDB;
2016-11-18 02:32 <kstenger> no
2016-11-18 02:32 <kstenger> createdb trytondb -E utf8 -O tryton
2016-11-18 02:33 <kstenger> you can name the database as you like
2016-11-18 02:34 <stav> kept trytondb.... worked!
2016-11-18 02:35 <kstenger> ok, so hopefully for now we are done with the postgres stuff
2016-11-18 02:35 <stav> fingers & toes crossed
2016-11-18 02:35 <kstenger> go back to root
2016-11-18 02:35 <stav> do i have to repeat this every time i create a new company database?
2016-11-18 02:36 <stav> ok.. back to root
2016-11-18 02:37 <kstenger> I'm unsure, but we gave the tryton user ermission to create dbs, so you should be able to create databases from the tryton client later
2016-11-18 02:37 <stav> i hope so
2016-11-18 02:37 <kstenger> anyway, if you need it, you will just need to use the createdb command, not all the rest
2016-11-18 02:38 <stav> good 2 know
2016-11-18 02:38 <stav> do i try client now or verify that trytondb was created?
2016-11-18 02:39 <kstenger> so now, we should check where your configuration file is. I recall that it still was created by default with 3.4 but I don't know where your distribution installs it by default
2016-11-18 02:40 <stav> do u mean pg...conf file?
2016-11-18 02:40 <kstenger> no, the tryton.conf (or was it trytond.conf?) file
2016-11-18 02:41 <kstenger> pg == postgres
2016-11-18 02:41 <kstenger> so no tryton
2016-11-18 02:42 <stav> trytond.conf is in /etc/tryton
2016-11-18 02:42 <kstenger> good, that is the file
2016-11-18 02:42 <stav> gedit into it?
2016-11-18 02:42 <kstenger> please
2016-11-18 02:44 <stav> ok
2016-11-18 02:45 <stav> ready to verify/edit
2016-11-18 02:47 <kstenger> make a pastebin with the contents please, I'm very tired and I cannot find a good source to guide you blindly
2016-11-18 02:49 <kstenger> you need to set a password for admin user, but I can't remember anything else
2016-11-18 02:49 <stav> i so appreciate you...i'll paste and let you sleep...but how in Xchat?... is there another name than 'pastebin'?
2016-11-18 02:50 <stav> i see 'file-transfers'?
2016-11-18 02:50 <kstenger> open your browser, firefox, chromium etc and get into pastebin.com
2016-11-18 02:50 <stav> or can u suggest a better client for debian?
2016-11-18 02:51 <kstenger> better client of irc? I can't tell, I just use pidgin... but this is not an issue, just open your browser! :p
2016-11-18 02:52 <stav> at pastebin..so i copy paste text of trytond.conf?
2016-11-18 02:52 <kstenger> yes, then paste here the url that points to your pastebin
2016-11-18 02:53 <kstenger> (there are many pastebin-like services you can google for yes)
2016-11-18 02:54 <stav> http://pastebin.com/r9DQ9PUY
2016-11-18 02:54 <stav> ...does that seem right?
2016-11-18 02:55 <kstenger> yes, perfect
2016-11-18 02:56 <kstenger> so you can uncomment line 19 (remove the # sign at the beginning of the line)
2016-11-18 02:58 <stav> done
2016-11-18 02:58 <kstenger> also uncomment line 62, I'm unsure if it should look like "listen = 0.0.0.0:8000" or "listen = *:8000" you can change it later to test if one fails
2016-11-18 03:00 <kstenger> go to line 99 and choose a password for your user 'admin' within tryton
2016-11-18 03:00 <stav> it's the first one
2016-11-18 03:00 <kstenger> (make sure you also uncomment the line)
2016-11-18 03:00 <kstenger> yes, it;s the user with all privileges in tryton
2016-11-18 03:01 <kstenger> ok, I think that will be enough
2016-11-18 03:03 <stav> awesome,
2016-11-18 03:03 <stav> thank you so much for your help
2016-11-18 03:03 <stav> sleep well :)
2016-11-18 03:04 <stav> if i have any problems I'll try again tmrw
2016-11-18 03:04 <kstenger> now you should launch the database initialization with this: trytond -c /etc/tryton/trytond.conf -d trytondb --all
2016-11-18 03:04 <kstenger> thank you! :)
2016-11-18 03:04 <stav> :)
2016-11-18 03:05 <stav> ooh..
2016-11-18 03:05 <stav> from root or postgres user prompt?
2016-11-18 03:06 <kstenger> better to use tryton prompt
2016-11-18 03:06 <stav> ?
2016-11-18 03:06 <kstenger> su - tryton
2016-11-18 03:06 <stav> doesn't switch name from root?
2016-11-18 03:07 <stav> still: root@vDebJessHw10:/#
2016-11-18 03:07 <kstenger> no, it logs you in with the tryton user
2016-11-18 03:07 <kstenger> the one we created earlier
2016-11-18 03:08 <kstenger> but, if you will run it locally, then you'll be fine with root, however at a higher level it could be a security issue
2016-11-18 03:10 <stav> don't work :( i'll stop bugging you friend. will try you again tomorrow.
2016-11-18 03:11 <stav> one last thing... does pidgin allow copy/paste from the dialogue?
2016-11-18 03:11 <stav> xchat does not
2016-11-18 03:11 <kstenger> do you mean if you can copy the text of the chat ?
2016-11-18 03:12 <stav> yes, for example from window above to ..say.. command line
2016-11-18 03:13 <kstenger> yes I can use the mouse to select text plus usual shortcuts
2016-11-18 03:13 <stav> cool.. i'll install pidgin
2016-11-18 03:13 <stav> good night
2016-11-18 03:16 -!- stav(~stav@mtrlpq4381w-lp130-02-76-66-182-77.dsl.bell.ca) has joined #tryton
2016-11-18 03:16 -!- stav(~stav@mtrlpq4381w-lp130-02-76-66-182-77.dsl.bell.ca) has left #tryton
2016-11-18 04:00 -!- morfeokmg(~smuxi@189.146.48.254) has joined #tryton
2016-11-18 05:17 -!- morfeokmg(~smuxi@189.146.48.254) has joined #tryton
2016-11-18 06:03 -!- thaneor1(~ldlc6@r179-24-154-77.dialup.adsl.anteldata.net.uy) has joined #tryton
2016-11-18 07:03 -!- flachtassekasse(~flachtass@p5DD1912C.dip0.t-ipconnect.de) has joined #tryton
2016-11-18 07:46 -!- JanGB(~jan@ipservice-092-216-122-042.092.216.pools.vodafone-ip.de) has joined #tryton
2016-11-18 08:05 -!- flachtassekasse(~flachtass@p5DD19175.dip0.t-ipconnect.de) has joined #tryton
2016-11-18 08:17 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton
2016-11-18 08:23 -!- JanGB(~jan@x59cc8221.dyn.telefonica.de) has joined #tryton
2016-11-18 08:41 -!- JanGB(~jan@x59cc8221.dyn.telefonica.de) has joined #tryton
2016-11-18 08:44 -!- mrichez(~smuxi@mail.saluc.com) has joined #tryton
2016-11-18 08:45 -!- nicoe(~nicoe@2a02:a03f:30b2:3c00:ee55:f9ff:fe7b:f7ac) has joined #tryton
2016-11-18 08:56 -!- rpit(~rpit@aftr-37-24-151-93.unity-media.net) has joined #tryton
2016-11-18 09:50 -!- nicoe(~nicoe@2a02:a03f:30b2:3c00:ee55:f9ff:fe7b:f7ac) has joined #tryton
2016-11-18 09:55 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2016-11-18 11:30 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton
2016-11-18 12:44 -!- smarro(~sebastian@181.16.7.104) has joined #tryton
2016-11-18 12:51 <xcodinas> cedk: Sao test are failing in drone :(
2016-11-18 12:59 <cedk> xcodinas: as usual local-npm is broken because JS community is a failure
2016-11-18 13:04 <pokoli> ACTION laughs
2016-11-18 13:05 -!- mariomop(~quassel@181.90.95.0) has joined #tryton
2016-11-18 13:11 <cedk> I found the problem in pouchdb
2016-11-18 13:12 <cedk> there is a new package name 'constructor' and pouchdb check for name on Object (as dict) but Object in JS has an attribute constructor
2016-11-18 13:12 <cedk> ACTION javascript is really a toy language programming
2016-11-18 13:19 -!- JosDzG(~Thunderbi@187.154.107.46) has joined #tryton
2016-11-18 13:32 <cedk> et voila: https://github.com/pouchdb/pouchdb/pull/5886
2016-11-18 13:39 -!- SamSagaZ(~SamSagaZ@101-241-231-201.fibertel.com.ar) has joined #tryton
2016-11-18 16:02 -!- kstenger(~karla@r186-54-23-28.dialup.adsl.anteldata.net.uy) has joined #tryton
2016-11-18 16:32 -!- mariomop(~quassel@181.110.157.234) has joined #tryton
2016-11-18 16:56 -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton
2016-11-18 17:08 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton
2016-11-18 17:22 -!- udono(~udono@p50938317.dip0.t-ipconnect.de) has joined #tryton
2016-11-18 17:32 -!- kobain(~kobain@unaffiliated/kobain) has joined #tryton
2016-11-18 18:05 -!- thaneor(~ldlc6@179.26.13.136) has joined #tryton
2016-11-18 19:21 -!- giesen(~ggiesen@2001:19f0:0:1019:5400:ff:fe25:bda6) has joined #tryton
2016-11-18 21:30 -!- lukio(~lukio@181.45.71.170) has joined #tryton
2016-11-18 22:27 -!- lukio(~lukio@181.45.71.170) has left #tryton
2016-11-18 22:36 -!- smarro(~sebastian@181.16.7.104) has joined #tryton
2016-11-18 23:13 -!- rpit(~rpit@aftr-37-24-151-93.unity-media.net) has joined #tryton

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