IRC logs of #tryton for Wednesday, 2018-11-14 #tryton log beginning Wed Nov 14 00:00:01 CET 2018
cedkcsotelo: the sequence attribute23:14
csotelocedk, <tree sequence="sequence"> vs <tree>? but.. something else? sorry for the question if it looks weird, I just want to understand23:17
cedkcsotelo: yes that's the difference23:17
csotelocedk, and how it affect the view?23:17
cedkcsotelo: it allow DnD to order the records23:36
csotelocedk, great! thanks!!}23:36
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton23:49
-!- lucascastro( has joined #tryton00:32
-!- thaneor(~lenovo3@ has joined #tryton00:35
-!- JanGB( has joined #tryton01:17
-!- JanGB( has left #tryton01:44
-!- yangoon1( has joined #tryton03:03
-!- yangoon( has joined #tryton04:01
-!- tafelgeschirr(~tafelgesc@ has joined #tryton05:57
-!- Timitos( has joined #tryton06:11
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton07:39
-!- mrichez( has joined #tryton07:53
-!- nicoe( has joined #tryton08:58
-!- rpit( has joined #tryton09:01
-!- rpit1( has joined #tryton10:40
-!- mariomop(~quassel@ has joined #tryton11:22
cedkwhy I prefer discuss over ML:!topic/tryton/eGAfeCtBGvA11:27
pokolicedk: I thought exactly the same after seen too much replies11:33
cedkwe should start the process of closing ML11:36
mrichezhi, in tryton 5, wizard form size is rather small : Could it be improved ?11:48
cedkmrichez: you can define an height on the Many2Many11:53
cedkwizard takes the natural size of the content11:54
mrichezcedk: ok thanks :-)11:54
-!- lucascastro( has joined #tryton12:26
-!- thaneor1( has joined #tryton12:37
-!- tafelgeschirr(~tafelgesc@ has joined #tryton13:07
-!- dkellygb( has joined #tryton13:25
-!- tafelgeschirr_(~tafelgesc@ has joined #tryton14:14
-!- mono(~mono@ has joined #tryton14:54
-!- k_valdivia(~k_valdivi@2800:200:f400:1d68:444:bd1b:3741:c87) has joined #tryton15:12
-!- JanGB( has joined #tryton15:31
-!- csotelo(~csotelo@ has joined #tryton15:42
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?15:43
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.conf15:48
-!- JanGB( has joined #tryton15:52
nicoedkellygb: it depends how you installed tryton but indeed there's good chances it's the right file15:53
dkellygbI updated the trytond.conf file with uri = postgresql://tryton:dave@ and commmented out the Sqlite stuff.15:59
dkellygbThen I ran the command "uri = postgresql://tryton:dave@"16:00
dkellygbI got this traceback:Traceback (most recent call last):16:00
dkellygb  File "/usr/bin/trytond-admin", line 21, in <module>16:00
dkellygb  File "/usr/lib/python3/dist-packages/trytond/", line 24, in run16:00
dkellygb    with Transaction().start(db_name, 0, _nocache=True):16:00
dkellygb  File "/usr/lib/python3/dist-packages/trytond/", line 88, in start16:00
dkellygb    database = Database(database_name).connect()16:00
dkellygb  File "/usr/lib/python3/dist-packages/trytond/backend/sqlite/", line 251, in connect16:00
dkellygb    raise IOError('Database "%s" doesn\'t exist!' % db_filename)16:00
dkellygbOSError: Database "tryton.sqlite" doesn't exist!16:00
dkellygbIt seems to still be looking for sqlite stuff.16:01
dkellygbSorry, the command I ran was:16:01
dkellygbtrytond-admin -c /etc/tryton/trytond.conf -d tryton --all16:01
nicoeCould you run the same command with -v and post a link to a pastebin-like with your log?16:03
-!- JanGB1( has joined #tryton16:04
dkellygbWhere is the log kept?16:05
cedkdkellygb: looks like configuration file is not readable by the user16:08
dkellygbDo I need elevated privileges?16:10
cedkdkellygb: no but read access to the configuration file16:13
dkellygbOk, I chmod the trytond.conf and it tells me psycopg2 is not installed.  Give me a minute to do that.16:15
-!- JanGB( has joined #tryton16:23
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?16:25
dkellygbOk, so you need to create the postgresql database first.16:28
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)16:28
dkellygbYeah, I did that and it worked.16:41
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.16:41
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.16:42
dkellygbRebooting doesn't seem to help.  Where do I find the logs?16:43
nicoeDo you run trytond ?16:45
pokolidkellygb: you have to connect to the ip of the server using the port 800016:47
pokolidkellygb: take care that the default configuration only listens to localhost so connecting from a diferent machine will not work16:48
dkellygbAh, the server is the trytond server not the postgresql server?16:48
pokolidkellygb: see
pokolidkellygb: yes, the server is trytond server16:48
pokolidkellygb: if you installed using distro packages it may be running as services otherwise you should start it manually16:49
-!- dkellygb( has joined #tryton17:00
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.17:00
pokolidkellygb: then the server is installed as system service so it's restarted after the reboot17:01
pokolidkellygb: may I ask you which SO are you using?17:01
csoteloHello domunity, is there some module to support more than one currency on accounting configuration17:29
csotelosorry for the type writing mistake17:29
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?17:32
dkellygbHi pokoli, what is SO?17:34
csotelodkellygb, he is talking about to your operative system17:34
dkellygbOk, Linux Mint 19 Cinnamon.  This is based on Ubuntu 18.04 Bionic.17:35
cedkcsotelo: you can not mix currencies in a chart of account, anywhere17:45
pokolidkellygb: then you should probably be able to restart the server with: systemctl restart trytond17:48
pokolidkellygb: which requires elevated privileges17:48
pokolicsotelo: the chart of account is only managed in the local currency. The invoice module automatically managed currency conversion when using foreign currencies17:49
-!- Timitos( has joined #tryton17:53
-!- JanGB( has joined #tryton18:02
csotelocedk, on our chart account we have the accounts 121201 for posted invoices in local currency and 121202 for posted invoiced on foreign currencies18:20
pokolicsotelo: you should convert the foreign currencies amount to the company currency amount18:23
-!- nicoe(~nicoe@2a02:578:858c:500:7e2a:31ff:fe5e:b25d) has joined #tryton18:38
-!- k_valdivia(~k_valdivi@2800:200:f400:1d68:444:bd1b:3741:c87) has joined #tryton18:46
-!- lucascastro( has joined #tryton19:45
-!- JanGB1( has joined #tryton20:02
-!- JanGB1( has left #tryton20:02
-!- semarie(~semarie@unaffiliated/semarie) has joined #tryton21:01
-!- k_valdivia(~k_valdivi@2800:200:f400:1d68:444:bd1b:3741:c87) has joined #tryton21:42

Generated by 2.17.3 by Marius Gedminas - find it at!