IRC logs of #tryton for Sunday, 2010-08-29

chat.freenode.net #tryton log beginning Sun Aug 29 00:00:02 CEST 2010
2010-08-29 01:45 -!- pepeu(~manuel@201.155.193.192) has joined #tryton
2010-08-29 02:10 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton
2010-08-29 02:24 -!- digitalsatori(~tony@116.233.244.108) has joined #tryton
2010-08-29 05:19 -!- yangoon(~mathiasb@p549F5D25.dip.t-dialin.net) has joined #tryton
2010-08-29 08:51 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2010-08-29 09:16 -!- hihat(~hihat@dyn.83-228-164-243.dsl.vtx.ch) has joined #tryton
2010-08-29 09:20 <hihat> good morning, somebody willing to help me check why I do get "could not connect to server" on a imho properly done (remote) installation of tryton-server 1.6.1?
2010-08-29 09:23 <cedk> hihat: why not
2010-08-29 09:23 <cedk> hihat: is the server running?
2010-08-29 09:25 -!- udono(~udono@dynamic-unidsl-85-197-17-55.westend.de) has joined #tryton
2010-08-29 09:27 <hihat> thanks, yes it is.
2010-08-29 09:27 <hihat> root@***:~# netstat -antp | grep python
2010-08-29 09:27 <hihat> tcp 0 0 127.0.0.1:8070 0.0.0.0:* LISTEN 25154/python
2010-08-29 09:27 <hihat> tcp 0 0 127.0.0.1:8080 0.0.0.0:* LISTEN 25154/python
2010-08-29 09:27 <cedk> hihat: is firewalls open for these ports?
2010-08-29 09:29 <hihat> I made a portscan last night where :8070 was found open, and on client side, I could connect to your demo server, I quickly check again
2010-08-29 09:30 <hihat> btw, I was using debian sid packages
2010-08-29 09:31 <cedk> hihat: have you activate the webdav ?
2010-08-29 09:31 <hihat> yes
2010-08-29 09:31 <hihat> i need it
2010-08-29 09:32 <hihat> one reason for tryton over openerp (which was running on the same system before)
2010-08-29 09:34 <cedk> hihat: ok, it was to be sure that the python processes are Tryton and not OE :-)
2010-08-29 09:34 <cedk> hihat: have you any output from trytond ?
2010-08-29 09:35 <hihat> :-) there is no more openerp on that box...
2010-08-29 09:36 <hihat> root@***:/etc/init.d# ps axu | grep tryton
2010-08-29 09:36 <hihat> tryton 29507 5.5 1.9 44696 19416 ? Sl 09:31 0:01 /usr/bin/python /usr/bin/trytond --config=/etc/trytond.conf --logfile=/var/log/trytond.log
2010-08-29 09:36 <hihat> root 29527 0.0 0.0 3272 724 pts/0 S+ 09:31 0:00 grep tryton
2010-08-29 09:37 -!- enlightx(~enlightx@dynamic-adsl-94-34-211-122.clienti.tiscali.it) has joined #tryton
2010-08-29 09:37 <hihat> root@***:/etc/init.d# tail -f /var/log/trytond.log
2010-08-29 09:37 <hihat> [Sun Aug 29 09:35:14 2010] INFO:modules:account_invoice_history:registering classes
2010-08-29 09:37 <hihat> [Sun Aug 29 09:35:14 2010] INFO:modules:stock_supply:registering classes
2010-08-29 09:37 <hihat> [Sun Aug 29 09:35:14 2010] INFO:modules:analytic_sale:registering classes
2010-08-29 09:37 <hihat> [Sun Aug 29 09:35:14 2010] INFO:modules:analytic_purchase:registering classes
2010-08-29 09:37 <hihat> [Sun Aug 29 09:35:14 2010] INFO:modules:stock_supply_day:registering classes
2010-08-29 09:37 <hihat> [Sun Aug 29 09:35:14 2010] INFO:modules:purchase_invoice_line_standalone:registering classes
2010-08-29 09:37 <hihat> [Sun Aug 29 09:35:14 2010] INFO:modules:sale_price_list:registering classes
2010-08-29 09:37 <hihat> [Sun Aug 29 09:35:14 2010] INFO:server:starting NetRPC protocol, port 8070
2010-08-29 09:37 <hihat> [Sun Aug 29 09:35:14 2010] INFO:server:starting WebDAV protocol, port 8080
2010-08-29 09:37 <hihat> [Sun Aug 29 09:35:14 2010] INFO:server:waiting for connections...
2010-08-29 09:40 <cedk> hihat: ok (next time use pastbin or others)
2010-08-29 09:41 <hihat> ok, sorry, I will
2010-08-29 09:41 <cedk> hihat: so it seems that there is an issue to reach the server
2010-08-29 09:42 <cedk> hihat: could you do a tcpdump to see if packets commes
2010-08-29 09:43 <hihat> I just did another adjustment in the trytond.conf
2010-08-29 09:43 <hihat> I replaced interface = localhost with interface = 0.0.0.0
2010-08-29 09:44 <cedk> hihat: but your netstat output show that it already listen on all interfaces
2010-08-29 09:48 <hihat> yes it should not make a difference but when I made that adjustment I could connect, then I changed the secure_-settings, which led to a failure in starting tryton-server, changed it back (leaving interface = ) and now I am where I was, could not connect
2010-08-29 09:48 <hihat> the ports 8070 and 8080 are open (port scanner diagnosis), I will do a tcpdump
2010-08-29 09:49 <cedk> hihat: you enabled ssl?
2010-08-29 09:49 <hihat> I tried to
2010-08-29 09:49 <hihat> (using pkey and certificate I use for apache2)
2010-08-29 09:50 <cedk> hihat: http://code.google.com/p/tryton/wiki/SSLHowto
2010-08-29 09:53 <hihat> ok, thank you, for now I am trying without ssl, not to complicate the problem and not to steal you too much time
2010-08-29 09:56 <cedk> hihat: as soon as you don't have sensitive data, it is ok
2010-08-29 09:56 <hihat> tcpdump was empty, then restarting the client and I can connect (now in a secure config without webdav without ssl)!
2010-08-29 09:56 -!- daniel(~daniel@c-24-7-203-207.hsd1.il.comcast.net) has joined #tryton
2010-08-29 09:57 <hihat> thanks a lot for assistance, now I am gonna figuring out what was wrong with my ssl configuration, erp data always are sensitive I think (accounting stuff surely is, isn't it). Another reason to switch to tryton from openerp.
2010-08-29 09:58 <hihat> btw, in the comparison chart, it was stated that tryton encrypts the password. Looking at trytond.conf, the trytonAdminPassword (admin_passwd) and the db_password are there in plaintext. How to store it encrypted?
2010-08-29 10:00 <cedk> hihat: this one is not encrypted but in production server it should be set to empty
2010-08-29 10:00 <cedk> hihat: others are stored in res_user table and encrypted with sha1
2010-08-29 10:01 <cedk> hihat: the password is also "salted" to prevent rainbow table
2010-08-29 10:07 <daniel> Can't seem to get a connection available for the server up and running on Ubuntu 9.10
2010-08-29 10:08 <daniel> using 1.6.1
2010-08-29 10:08 <daniel> installed via synaptic
2010-08-29 10:08 <daniel> I've read the debian docs and can't seem to make it work for me
2010-08-29 10:08 <hihat> ok, thank you for information. As I observe, when I comment (#) the db_password line in trytond.conf I need to comment all db_-fields so that default configuration is assumed - otherwise I cannot connect to server.
2010-08-29 10:09 <hihat> Hi daniel, have you done a portscan to ensure 8070 is open?
2010-08-29 10:09 <daniel> I have not!
2010-08-29 10:09 <cedk> hihat: db_password is for database connection
2010-08-29 10:09 <hihat> and just as a sidenote, I have heard that the debian packages of tryton would work with ubuntu too
2010-08-29 10:09 <daniel> thank you for responding!
2010-08-29 10:10 <cedk> hihat: have outputs of trytond ?
2010-08-29 10:11 <cedk> daniel: oops, have outputs of trytond ?
2010-08-29 10:11 <hihat> cedk: yes, I know, but if I leave empty the db_password as you suggested, but let the other db_-configfields active, I cannot connect, if I comment al db_-fields, I can.
2010-08-29 10:12 <hihat> db_host = localhost
2010-08-29 10:12 <hihat> db_port = 5432
2010-08-29 10:12 <hihat> db_user = tryton
2010-08-29 10:12 <hihat> #db_password = False
2010-08-29 10:12 <hihat> --> I cannot connect
2010-08-29 10:12 <hihat> ok, let's help daniel for now...
2010-08-29 10:12 <daniel> I don't. I've tried launching from the commandline and from the client gui
2010-08-29 10:13 <daniel> It waits indefinitely for open connections on the commandline, so your suggestion makes sense
2010-08-29 10:13 <hihat> daniel: try "tail -f /var/log/trytond.log"
2010-08-29 10:13 <daniel> I simply type "trytond"
2010-08-29 10:13 <hihat> daniel: do you try to connect from remote or client and server on same machine?
2010-08-29 10:13 <daniel> yes
2010-08-29 10:14 <hihat> daniel: from remote? from a windows or a linux client?
2010-08-29 10:14 <daniel> Linux Ubuntu 9.10
2010-08-29 10:16 <hihat> daniel: what is your output on "netstat -antp | grep python"?
2010-08-29 10:17 <daniel> nothing, should I be redirecting it to a file?
2010-08-29 10:17 <hihat> daniel: I don't know about the Ubuntu package, but even with the debian sid package it's necessary to do some manual postgresql-configuration in the pg_hba.conf
2010-08-29 10:18 <daniel> I can't seem to get to the file!!!
2010-08-29 10:18 <daniel> At least I know that i'm trying the right things
2010-08-29 10:18 <hihat> daniel: if the server was running and listening an the network interface, some related entry should appear when asking with "netstat -antp"
2010-08-29 10:18 <daniel> pg_hba.conf is shown as a binary that I can't edit
2010-08-29 10:18 <daniel> I see
2010-08-29 10:19 <daniel> interesting, I've only just started learning how to use netstat
2010-08-29 10:19 <hihat> daniel: I did understand you right did I? you try to connect from a remote machine / client to the server on a different ubuntu-machine...
2010-08-29 10:20 <daniel> No, I'm trying to setup the server as a process on my laptop and then connect from the same laptop
2010-08-29 10:20 <daniel> I haven't even gotten the software up and running yet at all
2010-08-29 10:20 <daniel> in any way
2010-08-29 10:21 <daniel> Spent several hours struggling with setting up Postgres
2010-08-29 10:21 <daniel> Learning experience though, good stuff.
2010-08-29 10:22 <hihat> daniel: I can understand you well, I didn't acquaint myself with postgresql until 2 months ago...
2010-08-29 10:23 <daniel> The documentation is excellent but I'm still quite awkward at the commandline
2010-08-29 10:23 <daniel> so even doing basic tasks like setting up a db, or changing a port# is epic
2010-08-29 10:24 <hihat> daniel: did you install a package or did you do the manual install?
2010-08-29 10:24 <daniel> package
2010-08-29 10:25 <daniel> first though I tried through setup tools
2010-08-29 10:26 <daniel> i think, it was even later than this when I intsalled the first time. i think I may try to uninstall and reinstall tomorrow, maybe the pghba.conf will be editable then. And I can check my ports properly
2010-08-29 10:26 <daniel> Would you suggest building from source? Or a package? Or as a pypi module?
2010-08-29 10:28 <hihat> daniel: first of all, I am not a developer, just a wanna-be-enduser with some linux experience that happens to be on that IRC right now because cedk assited me with another problem
2010-08-29 10:28 <daniel> ha!
2010-08-29 10:28 <hihat> daniel: pg_hba.conf is a text-file, it should be editable, maybe your ftp client doesn't display it correctly, you might try to edit it with vim on the commandline
2010-08-29 10:28 <daniel> well thanks for the help that you've given thus far
2010-08-29 10:29 <daniel> indeed
2010-08-29 10:29 <cedk> daniel: if you plane to make dev, follow http://code.google.com/p/tryton/wiki/InstallationMercurial
2010-08-29 10:29 <hihat> daniel: although maybe ubuntu already did adjust it during the package installation, I don't know about that package, I installed debian sid package
2010-08-29 10:29 <daniel> yeah, its not on a separate machine, so I should be able to get it open
2010-08-29 10:30 <daniel> don't know why its not working
2010-08-29 10:30 <cedk> hihat: I think the ubuntu package if just a copy of the debian one
2010-08-29 10:30 <cedk> daniel: the server is running?
2010-08-29 10:30 <daniel> I'm afraid not
2010-08-29 10:31 <cedk> daniel: did you run it from command line?
2010-08-29 10:31 <daniel> no luck calling it with no arguements frm the commandline
2010-08-29 10:31 <cedk> daniel: what was the output?
2010-08-29 10:31 <daniel> [Sun Aug 29 03:31:21 2010] INFO:server:using default configuration
2010-08-29 10:31 <daniel> [Sun Aug 29 03:31:21 2010] INFO:server:initialising distributed objects services
2010-08-29 10:31 <daniel> [Sun Aug 29 03:31:21 2010] DEBUG:psycopg2:installed. Logging using Python logging module
2010-08-29 10:31 <daniel> [Sun Aug 29 03:31:22 2010] INFO:modules:ir:registering classes
2010-08-29 10:31 <daniel> [Sun Aug 29 03:31:22 2010] INFO:modules:res:registering classes
2010-08-29 10:31 <daniel> [Sun Aug 29 03:31:22 2010] INFO:modules:webdav:registering classes
2010-08-29 10:31 <daniel> [Sun Aug 29 03:31:22 2010] INFO:modules:test:registering classes
2010-08-29 10:31 <daniel> [Sun Aug 29 03:31:22 2010] INFO:modules:workflow:registering classes
2010-08-29 10:31 <daniel> [Sun Aug 29 03:31:22 2010] INFO:server:starting NetRPC protocol, port 8070
2010-08-29 10:31 <daniel> [Sun Aug 29 03:31:22 2010] INFO:server:waiting for connections...
2010-08-29 10:32 <hihat> daniel: so it seems to be running
2010-08-29 10:32 <daniel> and then it never finds a connection or timesout, it just hangs
2010-08-29 10:32 <daniel> it does
2010-08-29 10:33 <cedk> daniel: it is a server so it is listening
2010-08-29 10:33 <cedk> daniel: it works
2010-08-29 10:33 <hihat> daniel: if you want to connect from remote, check once with a port scan, you can do by www without commandline here: http://ping.eu/port-chk/
2010-08-29 10:33 <cedk> daniel: now run the client
2010-08-29 10:35 <daniel> ahha!
2010-08-29 10:36 <daniel> the port IS closed.
2010-08-29 10:38 <hihat> daniel: I had to adjust trytond.conf in order to get the port open. This is good because of security when you don't want to run it over the network. I suggest you to try to adjust the interface - line (on top of the file /etc/trytond.conf) like this "interface = 0.0.0.0" - stop server and start it again and check again whether the port is open (it probably would be open when netstat -antp reports it's listening on 8070)
2010-08-29 10:39 <daniel> trying now
2010-08-29 10:44 <daniel> searched my filesystem and conuldn't find the trytond.conf file
2010-08-29 10:44 <daniel> not in /etc/
2010-08-29 10:45 <daniel> there's a config.py in the highest level directory of trytond, and it looks somewhat similar to Django's settings.py
2010-08-29 10:46 -!- hihat(~hihat@dyn.83-228-164-243.dsl.vtx.ch) has joined #tryton
2010-08-29 10:46 <hihat> daniel, in that case it's not the same as the debian package .-)
2010-08-29 10:47 <hihat> when you start trytond from the commandline it should inform you in the first line which configurationfile it's using
2010-08-29 10:47 <daniel> i think what happened is that I installed it via setup tools and just didn't pay attention to what was necessary, tomorrow morning after a solid nights sleep I'll uninstall/reinstall via debians package
2010-08-29 10:48 <daniel> indeed
2010-08-29 10:48 <daniel> well I'll try that right now
2010-08-29 10:48 <daniel> just says default configuration
2010-08-29 10:49 <daniel> so probably the config.py file
2010-08-29 10:49 <daniel> just guessing
2010-08-29 10:49 <daniel> Do you know how I would open port 8070?
2010-08-29 10:49 <hihat> cedk: when I start tryton from the commandline as user trytond I get the following error-line:
2010-08-29 10:50 <hihat> cedk: tryton@***:/root$ trytond
2010-08-29 10:50 <hihat> ERROR: couldn't create the logfile directory:[Errno 13] Permission denied: '/var/log/tryond.log'[Sun Aug 29 10:48:19 2010] INFO:server:using /etc/trytond.conf a
2010-08-29 10:50 <hihat> s configuration file
2010-08-29 10:50 <hihat> cedk: and I see a tryond.log file generated, but shouldn't that be tryton.log (with a t instead, which file already exists of course)?
2010-08-29 10:51 <hihat> daniel: imho the default configuration file is /etc/trytond.conf. the port would probably be opened automatically if you had everything configured so that the server nows that it has to listen to calls from over the network
2010-08-29 10:52 <daniel> thats what i thought
2010-08-29 10:54 <hihat> cedk: can you help me out with a few ideas why my tryton-server fails to start when I enable ssl, I followed the instructions (http://code.google.com/p/tryton/wiki/SSLHowto) and have everything installed what's needed, further I used this key and certificate not only with apache2 successfully but also with openerp
2010-08-29 10:54 <daniel> interesting, it gives me a socket.error when i try to run as root
2010-08-29 10:54 <daniel> thank you very much for the help
2010-08-29 10:54 <daniel> bed time for me, try again tomorrow
2010-08-29 10:55 <hihat> daniel: I am glad if I could help as I am sometimes in need of help too, good night and good luck
2010-08-29 10:57 <hihat> cedk: that's what I get when starting ssl-enabled trytond (as user tryton) from the command line: http://pastebin.com/7ThcWStX
2010-08-29 10:57 <udono> hihat: make sure, that user 'tryton' can write to /var/log/tryond.log
2010-08-29 10:58 <hihat> udono: thanks for participation, yes I saw that problem, but why is there a log-file called tryond.log beside the one I have specified in /etc/trytond.conf called trytond.log?
2010-08-29 10:58 <udono> hihat: don't know, just remove it
2010-08-29 10:58 <hihat> udono: isn't that I typo somewhere in the code (tryond.log instead of trytond.log)?
2010-08-29 10:59 <udono> hihat: no, I don't think. Maybe it's a typo you did while testing?
2010-08-29 11:00 <hihat> udono: shame on me, it is!
2010-08-29 11:01 <hihat> udono/cedk: that was really stupid from me. however, the ssl connection problem is not affected by that (now corrected).
2010-08-29 11:01 <udono> hihat: what is the problem with ssl
2010-08-29 11:02 <udono> ?
2010-08-29 11:02 <udono> hihat: sorry, just reading your paste
2010-08-29 11:03 <udono> hihat: your user tryton needed to have read access for the keyfiles
2010-08-29 11:04 <hihat> udono: yes, I checked that, there is read access for all users
2010-08-29 11:04 <udono> hihat: maybe to much read access...
2010-08-29 11:05 <udono> ACTION is unsure about this
2010-08-29 11:06 <hihat> hihat: for security reason, maybe, but it's not in an exposed path and it needs to be because of virtual hosts, apache and other apps working with it
2010-08-29 11:07 <hihat> udono: sorry, confused your name :-) so stupid like me config-typo before.
2010-08-29 11:07 <hihat> udono: anyway, this is my configuration file: http://pastebin.com/CGVBvRup - as soon as I disable the ssl options, tryton-server starts properly
2010-08-29 11:09 <hihat> udono: don't worry, I will try copying key and certificate to another location once
2010-08-29 11:10 <udono> hihat: or just try to create temporary keys like described in the wiki.
2010-08-29 11:11 <udono> hihat: maybe the admin.basiskompetenz.ch.key /*.crt won't work?
2010-08-29 11:11 <udono> ... with tryton
2010-08-29 11:13 <hihat> udono: with openerp they did...
2010-08-29 11:16 <cedk> hihat: I think there is some permission check in OpenSSL before using a key
2010-08-29 11:16 <udono> hihat: then they should work with tryton, too
2010-08-29 11:18 <hihat> cedk: permission not bound to the file system?
2010-08-29 11:18 <cedk> hihat: no fs permission
2010-08-29 11:19 <hihat> cedk: because I tried and copy the key and crt directly to /etc/ with no success
2010-08-29 11:19 <hihat> cedk: what kind of permission do I have to check?
2010-08-29 11:24 <udono> hihat: maybe something like this: sudo usermod -a -G ssl-cert tryton
2010-08-29 11:25 <udono> * on debian
2010-08-29 11:26 <hihat> ok I try integrating this cert and key by openssl only for tryton again
2010-08-29 11:32 <hihat> however if I managed to use them with l
2010-08-29 11:32 <hihat> with openerp I should with tryton too...
2010-08-29 12:06 <cedk> hihat: the error message from OpenSSL is clear that it can not open the certificate file
2010-08-29 12:26 <hihat> cedk: yes, I see - I installed key / certificate again with user tryton and it's working now! thanks for your assistance, the helpfulness of tryton-developers is a great plus!
2010-08-29 13:35 -!- digitalsatori(~tony@116.233.244.108) has joined #tryton
2010-08-29 14:01 -!- sharoon(~sharoon@vpn32.its.manchester.ac.uk) has joined #tryton
2010-08-29 14:08 -!- tony_(~tony@116.233.249.49) has joined #tryton
2010-08-29 14:46 -!- tony__(~tony@116.233.241.167) has joined #tryton
2010-08-29 14:49 -!- pheller(~pheller@pool-173-48-216-195.bstnma.fios.verizon.net) has joined #tryton
2010-08-29 16:38 -!- FWiesing(~FWiesing@85-126-100-130.work.xdsl-line.inode.at) has joined #tryton
2010-08-29 17:12 -!- David(~hihat@dyn.83-228-164-243.dsl.vtx.ch) has joined #tryton
2010-08-29 17:33 -!- gremly(~gremly@190.26.158.98) has joined #tryton
2010-08-29 17:34 -!- hihat(~hihat@dyn.83-228-164-243.dsl.vtx.ch) has joined #tryton
2010-08-29 18:03 -!- David(~hihat@dyn.83-228-164-243.dsl.vtx.ch) has joined #tryton
2010-08-29 18:23 -!- sharoon(~sharoon@vpn85.its.manchester.ac.uk) has joined #tryton
2010-08-29 18:26 -!- enlightx(~enlightx@dynamic-adsl-94-34-211-122.clienti.tiscali.it) has joined #tryton
2010-08-29 18:57 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton
2010-08-29 18:57 -!- Guest62327(~hihat@dyn.83-228-164-243.dsl.vtx.ch) has joined #tryton
2010-08-29 19:17 -!- hihat(~hihat@dyn.83-228-164-243.dsl.vtx.ch) has joined #tryton
2010-08-29 19:27 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton
2010-08-29 19:31 -!- David(~hihat@dyn.83-228-164-243.dsl.vtx.ch) has joined #tryton
2010-08-29 19:47 -!- plantian(~ian@c-69-181-194-95.hsd1.ca.comcast.net) has joined #tryton
2010-08-29 20:07 -!- eLBati(~elbati@94.163.43.149) has joined #tryton
2010-08-29 20:58 -!- gremly(~gremly@190.26.158.160) has joined #tryton
2010-08-29 22:09 -!- gremly(~gremly@190.26.158.160) has joined #tryton
2010-08-29 22:57 -!- pheller(~pheller@pool-173-48-216-195.bstnma.fios.verizon.net) has joined #tryton
2010-08-29 23:27 -!- pepeu(~manuel@187.137.75.117) has joined #tryton

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