| chat.freenode.net #tryton log beginning Wed Jun 19 00:00:06 CEST 2013 | ||
| 2013-06-19 22:01 <hydrosiii> hi | ||
| 2013-06-19 22:01 <hydrosiii> i need some help to install a tryton server in debian | ||
| 2013-06-19 22:02 <hydrosiii> i downloaded the packages from debian.tryton.org | ||
| 2013-06-19 22:02 <hydrosiii> and installled sucesfully in the system | ||
| 2013-06-19 22:02 <hydrosiii> but i cannot make the tryton-server connecto to postgresql | ||
| 2013-06-19 22:03 <hydrosiii> i followed the instructions provided in the package | ||
| 2013-06-19 22:03 <hydrosiii> named README.debian | ||
| 2013-06-19 22:05 <hydrosiii> got an error creating the database with the command # su - postgres -c "createuser --createdb --no-createrole --no-superuser \ --pwprompt tryton" | ||
| 2013-06-19 22:06 <hydrosiii> error , too many arguments for the createuser command, it doesnt accept the last part --pwrprompt tryton | ||
| 2013-06-19 22:06 <hydrosiii> without it, the user is created, but i cannot connect tryton anyway | ||
| 2013-06-19 22:07 <hydrosiii> how do i sucessfully setup the database? | ||
| 2013-06-19 22:16 <cedk> hydrosiii: try without --pwprompt but keep tryton | ||
| 2013-06-19 22:17 <yangoon1> hydrosiii: # su - postgres -c "createuser --createdb --no-createrole --no-superuser --pwprompt tryton" should work | ||
| 2013-06-19 22:24 <hydrosiii> yeah it worked | ||
| 2013-06-19 22:24 <hydrosiii> let me see if tryton connects | ||
| 2013-06-19 22:27 <hydrosiii> no | ||
| 2013-06-19 22:27 <hydrosiii> it doesnt | ||
| 2013-06-19 22:27 <hydrosiii> i create the database with the command | ||
| 2013-06-19 22:27 <hydrosiii> su - postgres -c "createdb --encoding=UNICODE --owner=tryton tryton" | ||
| 2013-06-19 22:28 <hydrosiii> i changed trytond.conf lines dbtype=postgresql | ||
| 2013-06-19 22:28 <hydrosiii> db_user= tryton | ||
| 2013-06-19 22:28 <hydrosiii> db_password = tryton | ||
| 2013-06-19 22:29 <hydrosiii> so it should work | ||
| 2013-06-19 22:29 <hydrosiii> but when i do | ||
| 2013-06-19 22:29 <hydrosiii> /usr/bin/trytond -i all -d tryton | ||
| 2013-06-19 22:29 <hydrosiii> i get a fatal error saying the Database doesnt exist | ||
| 2013-06-19 22:31 <yangoon1> hydrosiii: it probably depends on the authentication mechanism you are using for postgresql | ||
| 2013-06-19 22:31 <cedk> hydrosiii: but did you create the database tryton ? | ||
| 2013-06-19 22:33 <hydrosiii> su - postgres -c "createdb --encoding=UNICODE --owner=tryton tryton", odesnt this command create the db? | ||
| 2013-06-19 22:34 <cedk> hydrosiii: yes | ||
| 2013-06-19 22:34 <hydrosiii> i have changed also the authentication machanism in pg_hba.conf | ||
| 2013-06-19 22:34 <hydrosiii> to | ||
| 2013-06-19 22:34 <yangoon1> hydrosiii: if you are using ident, you must connect as the same user or map him like in http://www.viste.com/Java/Language/PostgreSQL/pgsql3.html | ||
| 2013-06-19 22:35 <yangoon1> hydrosiii: probably most portable is to use md5 | ||
| 2013-06-19 22:35 <hydrosiii> in the debian manual says to use password authentication | ||
| 2013-06-19 22:35 <hydrosiii> so i changed pg_hba.conf line | ||
| 2013-06-19 22:36 <hydrosiii> local all all password | ||
| 2013-06-19 22:36 <hydrosiii> im not sure password is a valid option, maybe that is the problem | ||
| 2013-06-19 22:36 <yangoon1> indeed | ||
| 2013-06-19 22:36 <yangoon1> host all all 127.0.0.1/32 md5 | ||
| 2013-06-19 22:36 <yangoon1> for localhost IPv4 | ||
| 2013-06-19 22:37 <hydrosiii> yeah i have that setting to | ||
| 2013-06-19 22:37 <hydrosiii> one line below | ||
| 2013-06-19 22:37 <hydrosiii> host all all 127.0.0.1/32 md5 | ||
| 2013-06-19 22:37 <hydrosiii> i had another line saying local all all indet | ||
| 2013-06-19 22:38 <hydrosiii> *ident | ||
| 2013-06-19 22:38 <yangoon1> hydrosiii: tryton server and postgres are running on the same machine? | ||
| 2013-06-19 22:38 <hydrosiii> but after reading that i needed password authentication i changed it | ||
| 2013-06-19 22:38 <hydrosiii> yes | ||
| 2013-06-19 22:38 <hydrosiii> same machine | ||
| 2013-06-19 22:38 <hydrosiii> is a VM, if ti changes something | ||
| 2013-06-19 22:38 <yangoon1> host all all ::1/128 md5 | ||
| 2013-06-19 22:38 <yangoon1> for IPv6 also included? | ||
| 2013-06-19 22:39 <hydrosiii> yes | ||
| 2013-06-19 22:40 <yangoon1> comment the lines with password option and restart the postgres server | ||
| 2013-06-19 22:41 <yangoon1> then be sure, if tryton was really the password the tryton role in postgres | ||
| 2013-06-19 22:42 <yangoon1> if yes, restart the tryton server and try to connect with the client | ||
| 2013-06-19 22:42 <yangoon1> you can also create a database from the client | ||
| 2013-06-19 22:44 <hydrosiii> how can i be sure of the password in the tryton role? | ||
| 2013-06-19 22:44 <hydrosiii> n | ||
| 2013-06-19 22:45 <yangoon1> hydrosiii: it is the one you provided when doing # su - postgres -c "createuser --createdb --no-createrole --no-superuser --pwprompt tryton" | ||
| 2013-06-19 22:46 <hydrosiii> yes | ||
| 2013-06-19 22:46 <hydrosiii> i m pretty sure is tryton | ||
| 2013-06-19 22:46 <hydrosiii> but how can i check it | ||
| 2013-06-19 22:46 <hydrosiii> ?? | ||
| 2013-06-19 22:52 <yangoon1> hydrosiii: can you connect with tryton client to tryton server? | ||
| 2013-06-19 22:55 <hydrosiii> im trying | ||
| 2013-06-19 22:56 <hydrosiii> ok | ||
| 2013-06-19 22:56 <hydrosiii> im trying wiht createnew database | ||
| 2013-06-19 22:56 <hydrosiii> in the client | ||
| 2013-06-19 22:57 <hydrosiii> server conecction 127.0.0.1:8000 | ||
| 2013-06-19 22:58 <hydrosiii> no i cannot | ||
| 2013-06-19 22:58 <hydrosiii> connect to the server | ||
| 2013-06-19 22:59 <yangoon1> hydrosiii: I suppose the client is not running in the same VM as the server? | ||
| 2013-06-19 23:00 <hydrosiii> it is running inside the VM, yes | ||
| 2013-06-19 23:01 <hydrosiii> im trying to set everithing up into the VM and then install other clients | ||
| 2013-06-19 23:01 <hydrosiii> cut that shouldnt be aproblem | ||
| 2013-06-19 23:01 <hydrosiii> let me try | ||
| 2013-06-19 23:01 <hydrosiii> with a client outsi te VM | ||
| 2013-06-19 23:03 <hydrosiii> maybe that is the problem | ||
| 2013-06-19 23:07 <hydrosiii> no i cannot conect | ||
| 2013-06-19 23:07 <hydrosiii> from neither form outside the VM or form the inside | ||
| 2013-06-19 23:07 <hydrosiii> the network is working since i have used it the same configuration with different vm's | ||
| 2013-06-19 23:07 <hydrosiii> so the network is not the problem | ||
| 2013-06-19 23:10 <yangoon1> hydrosiii: 127.0.0.1:8000 is wrong when connecting from outside | ||
| 2013-06-19 23:11 <yangoon1> hydrosiii: also take care to have the tryton server listen on an external interface | ||
| 2013-06-19 23:12 <hydrosiii> ye ah i know form outsie | ||
| 2013-06-19 23:13 <hydrosiii> im using the vm ip adress | ||
| 2013-06-19 23:14 <yangoon1> hydrosiii: so you need something like jsonrpc = <vm_ip>:8000 in trytond.conf | ||
| 2013-06-19 23:14 <hydrosiii> the default is localhost:8000 | ||
| 2013-06-19 23:14 <hydrosiii> i think is right | ||
| 2013-06-19 23:17 <yangoon1> hydrosiii: you won't be lucky when you are trying to connect from outside to a server listening on localhost | ||
| 2013-06-19 23:17 <hydrosiii> i know | ||
| 2013-06-19 23:18 <hydrosiii> i point the client from outside to 192.168.0.15 | ||
| 2013-06-19 23:18 <hydrosiii> port 8000 | ||
| 2013-06-19 23:18 <hydrosiii> the VM ip adrees | ||
| 2013-06-19 23:18 <hydrosiii> so i should change trytond to reflect thi? | ||
| 2013-06-19 23:18 <hydrosiii> shouldn't it be automatic? | ||
| 2013-06-19 23:19 <yangoon1> hydrosiii: how should it be automatic, if you set it to localhost in trytond.conf? | ||
| 2013-06-19 23:20 <hydrosiii> aa ok | ||
| 2013-06-19 23:20 <yangoon1> hydrosiii: the least restrictive configuration is "jsonrpc = *:8000" | ||
| 2013-06-19 23:20 <hydrosiii> yeah | ||
| 2013-06-19 23:21 <hydrosiii> i know see my service using nmap | ||
| 2013-06-19 23:21 <hydrosiii> to the corresponding ip | ||
| 2013-06-19 23:21 <hydrosiii> let me see if the client connect | ||
| 2013-06-19 23:21 <yangoon1> hydrosiii: so good luck, have to leave | ||
| 2013-06-19 23:23 <hydrosiii> thank you | ||
| 2013-06-19 23:23 <hydrosiii> weel i cant see the server | ||
| 2013-06-19 23:24 <hydrosiii> but ti cannot create the db | ||
| 2013-06-19 23:24 <hydrosiii> let me see what im doing wring | ||
| 2013-06-19 23:37 <hydrosiii> hi | ||
| 2013-06-19 23:37 <hydrosiii> again | ||
| 2013-06-19 23:37 <hydrosiii> i get an error in the client when i want to cerate a db | ||
| 2013-06-19 23:37 <hydrosiii> saying | ||
| 2013-06-19 23:38 <hydrosiii> there's no line in pg_hba,conf for <<[local]>> user <<tryton>> | ||
| 2013-06-19 23:38 <hydrosiii> database <<template1>> , SSL inactive | ||
| 2013-06-19 23:40 <cjbarnes18> Hi all, I am trying to apply review 92001 without much luck, what is the method for resolving conflicts and resuming the patch/import/review? | ||
| 2013-06-19 23:41 <hydrosiii> thank you solved it | ||
| 2013-06-19 23:41 <hydrosiii> added a line in pg_hba.conf with local all all password | ||
| 2013-06-19 23:42 <cjbarnes18> hi hydrosiii, is this for a live deployment? | ||
| 2013-06-19 23:42 <hydrosiii> yes | ||
| 2013-06-19 23:42 <hydrosiii> trying to set it up ina a store | ||
| 2013-06-19 23:43 <cjbarnes18> is tryton going to be on the same server as postgres? | ||
| 2013-06-19 23:43 <hydrosiii> yes | ||
| 2013-06-19 23:44 <cjbarnes18> ok, only thinking that if you have it on a seporate box plain text password isnt good... | ||
| 2013-06-19 23:44 <hydrosiii> yes, but is the same box | ||
| 2013-06-19 23:44 <cjbarnes18> looks like you have it cracked :D | ||
| 2013-06-19 23:44 <hydrosiii> and for now , im just going to use LAN | ||
| 2013-06-19 23:45 <hydrosiii> if i go on the internet ill see, then , | ||
| 2013-06-19 23:45 <hydrosiii> i ll go with the easy setup for now :) | ||
| 2013-06-19 23:45 <cjbarnes18> you probably wouldnt expose postgresql directly to the net anyway. | ||
| 2013-06-19 23:45 <hydrosiii> yes, of course | ||
| 2013-06-19 23:46 <hydrosiii> but well, maybe ill disable every internet connection to the server | ||
| 2013-06-19 23:46 <hydrosiii> or i can use iptables, to block all ports | ||
| 2013-06-19 23:46 <hydrosiii> that i know, i just dont know how to use the conf files in postgresql | ||
| 2013-06-19 23:46 <hydrosiii> they're difficult | ||
| 2013-06-19 23:47 <cjbarnes18> assuming you have a firewall between the internet and your LAN youre probably OK | ||
| 2013-06-19 23:47 <cjbarnes18> by default postgresql will only listen on localhost anyway | ||
| 2013-06-19 23:48 <cjbarnes18> the config files are well documented but there is a lot in there. | ||
| 2013-06-19 23:48 <cjbarnes18> the documentstion at postgresql is very good though. | ||
| 2013-06-19 23:48 <cjbarnes18> postgresql.org that is. | ||
| 2013-06-19 23:50 <cjbarnes18> cedk ping | ||
| 2013-06-19 23:50 <hydrosiii> ok tahan you | ||
| 2013-06-19 23:50 <cjbarnes18> yw | ||
| 2013-06-19 23:51 <hydrosiii> also im trying to install point of sale moduel | ||
| 2013-06-19 23:52 <cjbarnes18> wich version of Tryton are you installing? | ||
| 2013-06-19 23:53 <hydrosiii> 2.6 | ||
| 2013-06-19 23:53 <cjbarnes18> last time I checked it POS hadnt been updated, you may need to go earlier. | ||
| 2013-06-19 23:55 <hydrosiii> it has been updataed | ||
| 2013-06-19 23:55 <hydrosiii> by | ||
| 2013-06-19 23:55 <hydrosiii> https://bitbucket.org/camus77 | ||
| 2013-06-19 23:55 <hydrosiii> well, i mailed the dev, and told me that the pos is ready | ||
| 2013-06-19 23:56 <cjbarnes18> cool | ||
| 2013-06-19 23:56 <cjbarnes18> I hadnt seen that fork | ||
| 2013-06-19 23:57 <hydrosiii> yes, is good | ||
| 2013-06-19 23:57 <hydrosiii> since all i need tryton is to sell stuff | ||
| 2013-06-19 23:57 <hydrosiii> searched for days for it |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!