IRC logs of #tryton for Wednesday, 2018-11-14 #tryton log beginning Wed Nov 14 00:00:01 CET 2018
cedkcsotelo: the sequence attribute00:11
csotelocedk, <tree sequence="sequence"> vs <tree>? but.. something else? sorry for the question if it looks weird, I just want to understand00:11
cedkcsotelo: yes that's the difference00:11
csotelocedk, and how it affect the view?00:11
cedkcsotelo: it allow DnD to order the records00:11
csotelocedk, great! thanks!!}00:11
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton00:11
-!- lucascastro( has joined #tryton01:11
-!- thaneor(~lenovo3@ has joined #tryton01:11
-!- JanGB( has joined #tryton02:11
-!- JanGB( has left #tryton02:11
-!- yangoon1( has joined #tryton04:11
-!- yangoon( has joined #tryton05:11
-!- tafelgeschirr(~tafelgesc@ has joined #tryton06:11
-!- Timitos( has joined #tryton07:11
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton08:11
-!- mrichez( has joined #tryton08:11
-!- nicoe( has joined #tryton09:11
-!- rpit( has joined #tryton10:11
-!- rpit1( has joined #tryton11:11
-!- mariomop(~quassel@ has joined #tryton12:11
cedkwhy I prefer discuss over ML:!topic/tryton/eGAfeCtBGvA12:11
pokolicedk: I thought exactly the same after seen too much replies12:11
cedkwe should start the process of closing ML12:11
mrichezhi, in tryton 5, wizard form size is rather small : Could it be improved ?12:11
cedkmrichez: you can define an height on the Many2Many12:11
cedkwizard takes the natural size of the content12:11
mrichezcedk: ok thanks :-)12:11
-!- lucascastro( has joined #tryton13:11
-!- thaneor1( has joined #tryton13:11
-!- tafelgeschirr(~tafelgesc@ has joined #tryton14:11
-!- dkellygb( has joined #tryton14:11
-!- tafelgeschirr_(~tafelgesc@ has joined #tryton15:11
-!- mono(~mono@ has joined #tryton15:11
-!- k_valdivia(~k_valdivi@2800:200:f400:1d68:444:bd1b:3741:c87) has joined #tryton16:11
-!- JanGB( has joined #tryton16:11
-!- csotelo(~csotelo@ has joined #tryton16:11
dkellygbHello Everybody, I like the concept of Tryton but I am having difficulty installing.  The documentation seems very sparce.  For example, we have our own Postgresql server.  How do I create the database and then get the clients to see it?16:11
pokolidkellygb: hello and welcome aboard! Once you have the server installed you can setup your database with the following steps:
dkellygbI assume that the config file in "trytond-admin -c <config file> -d <database name> --all" is /etc/tryton/trytond.conf16:11
-!- JanGB( has joined #tryton16:11
nicoedkellygb: it depends how you installed tryton but indeed there's good chances it's the right file16:11
dkellygbI updated the trytond.conf file with uri = postgresql://tryton:dave@ and commmented out the Sqlite stuff.16:11
dkellygbThen I ran the command "uri = postgresql://tryton:dave@"17:11
dkellygbI got this traceback:Traceback (most recent call last):17:11
dkellygb  File "/usr/bin/trytond-admin", line 21, in <module>17:11
dkellygb  File "/usr/lib/python3/dist-packages/trytond/", line 24, in run17:11
dkellygb    with Transaction().start(db_name, 0, _nocache=True):17:11
dkellygb  File "/usr/lib/python3/dist-packages/trytond/", line 88, in start17:11
dkellygb    database = Database(database_name).connect()17:11
dkellygb  File "/usr/lib/python3/dist-packages/trytond/backend/sqlite/", line 251, in connect17:11
dkellygb    raise IOError('Database "%s" doesn\'t exist!' % db_filename)17:11
dkellygbOSError: Database "tryton.sqlite" doesn't exist!17:11
dkellygbIt seems to still be looking for sqlite stuff.17:11
dkellygbSorry, the command I ran was:17:11
dkellygbtrytond-admin -c /etc/tryton/trytond.conf -d tryton --all17:11
nicoeCould you run the same command with -v and post a link to a pastebin-like with your log?17:11
-!- JanGB1( has joined #tryton17:11
dkellygbWhere is the log kept?17:11
cedkdkellygb: looks like configuration file is not readable by the user17:11
dkellygbDo I need elevated privileges?17:11
cedkdkellygb: no but read access to the configuration file17:11
dkellygbOk, I chmod the trytond.conf and it tells me psycopg2 is not installed.  Give me a minute to do that.17:11
-!- JanGB( has joined #tryton17:11
dkellygbWhen I run the command again, I get "psycopg2.OperationalError: FATAL:  database "tryton" does not exist"  Do I have to create the database first before I run the command?17:11
dkellygbOk, so you need to create the postgresql database first.17:11
nicoedkellygb: yes something along the lines "createdb -E UTF8 -T template0 name_of_your_db" (you will need to have the rights to do this)17:11
dkellygbYeah, I did that and it worked.17:11
dkellygbNow, however, I can access the database using pgadmin but when I try to log in with the client, it can't see the database.17:11
dkellygbI put in the host line and tryton in the database line and I get could not connect to server.  I will try to reboot.17:11
dkellygbRebooting doesn't seem to help.  Where do I find the logs?17:11
nicoeDo you run trytond ?17:11
pokolidkellygb: you have to connect to the ip of the server using the port 800017:11
pokolidkellygb: take care that the default configuration only listens to localhost so connecting from a diferent machine will not work17:11
dkellygbAh, the server is the trytond server not the postgresql server?17:11
pokolidkellygb: see
pokolidkellygb: yes, the server is trytond server17:11
pokolidkellygb: if you installed using distro packages it may be running as services otherwise you should start it manually17:11
-!- dkellygb( has joined #tryton18:11
dkellygbI am now back.  I am able to get in after a reboot.  I suppose the server needs a restart to read the updated conf files.18:11
pokolidkellygb: then the server is installed as system service so it's restarted after the reboot18:11
pokolidkellygb: may I ask you which SO are you using?18:11
csoteloHello domunity, is there some module to support more than one currency on accounting configuration18:11
csotelosorry for the type writing mistake18:11
csoteloI mean, on our chart account we have accounts for local currency (PEN) and and foreign currencies (EUR/USD) but account configuration just support one currency, my question is: is possible to manage more than one currency?18:11
dkellygbHi pokoli, what is SO?18:11
csotelodkellygb, he is talking about to your operative system18:11
dkellygbOk, Linux Mint 19 Cinnamon.  This is based on Ubuntu 18.04 Bionic.18:11
cedkcsotelo: you can not mix currencies in a chart of account, anywhere18:11
pokolidkellygb: then you should probably be able to restart the server with: systemctl restart trytond18:11
pokolidkellygb: which requires elevated privileges18:11
pokolicsotelo: the chart of account is only managed in the local currency. The invoice module automatically managed currency conversion when using foreign currencies18:11
-!- Timitos( has joined #tryton18:11
-!- JanGB( has joined #tryton19:11
csotelocedk, on our chart account we have the accounts 121201 for posted invoices in local currency and 121202 for posted invoiced on foreign currencies19:11
pokolicsotelo: you should convert the foreign currencies amount to the company currency amount19:11
-!- nicoe(~nicoe@2a02:578:858c:500:7e2a:31ff:fe5e:b25d) has joined #tryton19:11
-!- k_valdivia(~k_valdivi@2800:200:f400:1d68:444:bd1b:3741:c87) has joined #tryton19:11
-!- lucascastro( has joined #tryton20:11
-!- JanGB1( has joined #tryton21:11
-!- JanGB1( has left #tryton21:11
-!- semarie(~semarie@unaffiliated/semarie) has joined #tryton22:11
-!- k_valdivia(~k_valdivi@2800:200:f400:1d68:444:bd1b:3741:c87) has joined #tryton22:11

Generated by 2.16.0 by Marius Gedminas - find it at!