| 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/!