IRC Channels
For open discussions, an IRC Channel have been set up for Open ERP and Open Object: irc://irc.freenode.net/#openobject.
Wednesday, 2010-06-23
| *** yangoon1 has joined #openobject | 00:31 | |
| *** yangoon1 has quit IRC | 00:39 | |
| *** yangoon_rm has joined #openobject | 00:41 | |
| *** eLBati has quit IRC | 00:44 | |
| *** ludo21 has quit IRC | 00:53 | |
| *** ludo2 has joined #openobject | 00:54 | |
| *** ludo2 has quit IRC | 00:59 | |
| *** KangOl has quit IRC | 01:00 | |
| *** Virtualcolony has quit IRC | 01:06 | |
| *** Spiralmatrix has joined #openobject | 01:07 | |
| *** ovnicraft has quit IRC | 01:13 | |
| *** komsas has quit IRC | 01:25 | |
| *** atikasoft has quit IRC | 01:44 | |
| *** Gavin_Achado has joined #openobject | 01:48 | |
| *** yangoon_rm has quit IRC | 02:11 | |
| *** ovnicraft has joined #openobject | 03:30 | |
| *** zigzapgabe has quit IRC | 03:53 | |
| *** zigzapgabe has joined #openobject | 03:56 | |
| *** Gavin_Achado has left #openobject | 05:04 | |
| *** yangoon has quit IRC | 05:20 | |
| *** ovnicraft has quit IRC | 05:29 | |
| *** yangoon has joined #openobject | 05:35 | |
| *** zigzapgabe_ has joined #openobject | 05:38 | |
| *** julian1828 has quit IRC | 06:06 | |
| *** mr_amit has joined #openobject | 06:17 | |
| *** julian1828 has joined #openobject | 06:27 | |
| *** Nyx1 has joined #openobject | 07:55 | |
| *** enlightx has joined #openobject | 08:02 | |
| *** Nyx1 has quit IRC | 08:14 | |
| *** quodt has joined #openobject | 08:41 | |
| *** cedk has quit IRC | 08:57 | |
| *** Janneman1 has joined #openobject | 09:01 | |
| *** Spiralmatrix has quit IRC | 09:04 | |
| *** eLBati has joined #openobject | 09:19 | |
| *** rona1 has joined #openobject | 09:20 | |
| *** rona1 has left #openobject | 09:20 | |
| eLBati | if I inherit by prototyping (_name != _inherit), won't I inherit workflow too? | 09:37 |
|---|---|---|
| *** cedk has joined #openobject | 09:37 | |
| *** rationalperseus_ has joined #openobject | 09:43 | |
| *** rationalperseus has quit IRC | 09:43 | |
| *** KangOl has joined #openobject | 10:06 | |
| *** ChanServ sets mode: +o KangOl | 10:06 | |
| *** eLBati has quit IRC | 10:13 | |
| *** Red15 has joined #openobject | 10:13 | |
| *** rationalperseus_ has quit IRC | 10:35 | |
| *** enlightx has quit IRC | 10:38 | |
| *** Janneman1 has quit IRC | 10:38 | |
| *** rationalperseus has joined #openobject | 10:39 | |
| *** eLBati has joined #openobject | 10:40 | |
| *** ludo2 has joined #openobject | 10:41 | |
| *** kalymero has joined #openobject | 10:48 | |
| *** enlightx has joined #openobject | 10:53 | |
| *** jessejames has joined #openobject | 11:08 | |
| *** hounddog has joined #openobject | 11:16 | |
| eLBati | is it possible to use the same workflow for several objects? | 11:18 |
| cedk | eLBati: no | 11:21 |
| eLBati | thanks cedk | 11:22 |
| jessejames | Has anyone been able to run openerp on ubuntu lucid? | 11:23 |
| *** hounddog has quit IRC | 11:24 | |
| zanaga | jessejames: server or client? | 11:26 |
| eLBati | jessejames, yes but with this bug https://bugs.launchpad.net/openobject-server/+bug/594453 | 11:26 |
| jessejames | zanaga: server | 11:26 |
| zanaga | i've been running my test installation on lucid | 11:27 |
| jessejames | zanaga, my problem seems to be with connecting to the database as the openerp user | 11:28 |
| jessejames | I get this error: Unable to connect to template1: fe_sendauth: no password supplied | 11:29 |
| zanaga | is your database on the local server? | 11:30 |
| jessejames | yes | 11:30 |
| jessejames | I can run as the postgres user, but not openerp: sudo -u postgres python /usr/lib/openerp-server/openerp-server.py | 11:31 |
| zanaga | did you create the openerp database user? | 11:31 |
| jessejames | Yes and I've verified that it is there by looking at the pg_user table | 11:31 |
| zanaga | have you modified pg_hba.conf at any point? | 11:32 |
| jessejames | Yes, I've changed the setting from ident to md5 | 11:32 |
| zanaga | ok, and have you added the password for the openerp database user to openerp-server configuration? | 11:33 |
| jessejames | Yes | 11:33 |
| zanaga | hmm.. and you are sure that the configuration you specified is actually being used? | 11:34 |
| jessejames | How do i verify that? | 11:34 |
| zanaga | if you change the db_user field to something else, does it try to connect as a different user? | 11:34 |
| zanaga | for example | 11:34 |
| jessejames | checking... | 11:35 |
| zanaga | I used the ident authentication method here, so i haven't seen this problem myself.. but it would sound logical that the openerp-server is actually reading some other configuration file and using that instead of the one you are editing | 11:36 |
| jessejames | I've changed /etc/openerp-server.conf and will check the log | 11:40 |
| jessejames | I changed db-user tpo postgres and got this: Unable to connect to template1: FATAL: Ident authentication failed for user "postgres" | 11:41 |
| zanaga | ok.. so it is actually using that file | 11:42 |
| zanaga | then i'm out of ideas | 11:42 |
| jessejames | If I changed pg_hba.conf back to using ident, that should now work? | 11:42 |
| zanaga | yeah | 11:42 |
| jessejames | still getting the ident error for postgres | 11:45 |
| zanaga | and you are running the openerp-server as the openerp user? | 11:45 |
| jessejames | yes | 11:46 |
| zanaga | and i assume you changed the db_user back to openerp as well | 11:46 |
| jessejames | nope... will do | 11:46 |
| rationalperseus | when i try to connect to the database, i get: current transaction is aborted, commands ignored until end of transaction block\n\n'; anyone familiar with the issue please? :) | 11:47 |
| zanaga | rationalperseus: you are trying to send something to the server that it doesn't undestand and it aborts the transaction | 11:47 |
| rationalperseus | should be something related to a connection timeout between the client and the server | 11:47 |
| *** hounddog has joined #openobject | 11:47 | |
| rationalperseus | it happens only with one database | 11:48 |
| rationalperseus | the others on the same server accept the connection | 11:48 |
| zanaga | maybe there is a missing table or some other error like that? | 11:48 |
| zanaga | I'm not an expert there, just throwing ideas here =) | 11:49 |
| jessejames | zanaga: changing the db-user back to openerp didn't work either | 11:49 |
| rationalperseus | probably since the timeout happened when preparing the db for migrating | 11:49 |
| rationalperseus | Traceback (most recent call last):\n File "/usr/lib/openerp-server/netsvc.py", line 244, in dispatch\n result = LocalService(service_name)(method, *params)\n | 11:50 |
| zanaga | jessejames: odd.. does "sudo -u openerp psql template1" work? | 11:51 |
| jessejames | zanaga: psql: FATAL: Ident authentication failed for user "openerp" | 11:52 |
| zanaga | jessejames: then the problem is on the postgres side | 11:52 |
| *** hounddog has quit IRC | 11:52 | |
| zanaga | jessejames: for some reason the database fails to accept connections from openerp user | 11:52 |
| zanaga | jessejames: can you check that the database user doesn't have nologin attribute set | 11:53 |
| jessejames | zanaga, I can't do sudo su openerp ... could that be the problem? | 11:53 |
| jessejames | zanaga, how do I check nologin? | 11:53 |
| zanaga | jessejames: no, (and you should use sudo -s openerp instead) but most likely the user has an invalid shell set so that the su command fails | 11:54 |
| jessejames | zanaga, the openerp user was created by the package. I think I'll delete it and recreate it | 11:56 |
| zanaga | you can do "alter role openerp login;" | 11:56 |
| zanaga | that forces the login flag | 11:56 |
| zanaga | after that try again with the psql line | 11:56 |
| jessejames | I get role "openerp" does not exist | 11:58 |
| jessejames | ...on the alter role | 11:58 |
| zanaga | hmm.. | 11:58 |
| zanaga | that would be our problem | 11:58 |
| zanaga | hve you created the openerp database user? | 11:58 |
| jessejames | yes | 11:58 |
| zanaga | does \dg in psql show the user? | 11:59 |
| jessejames | Yes | 11:59 |
| zanaga | hmm.. what is going on here | 12:01 |
| zanaga | try recreating the database user, maybe that helps | 12:01 |
| zanaga | brb... stepping out for a sec | 12:03 |
| jessejames | dropuser openerp gave: removal of role "openerp" failed: ERROR: role "openerp" does not exist | 12:03 |
| zanaga | ok.. so there was something wrong with the database user | 12:14 |
| jessejames | I'm just trying to create a new user: openerpuser | 12:15 |
| zanaga | if you create it with any other name than openerp, you should use md5 login | 12:15 |
| jessejames | okay | 12:17 |
| *** Marcel|HSD has joined #openobject | 12:18 | |
| *** cjeske has joined #openobject | 12:23 | |
| jessejames | zanaga, I get the fe_sendauth: no password supplied error still | 12:28 |
| jessejames | zanaga, using the openerpuser and the ident option in postgres works | 12:30 |
| *** cjeske has quit IRC | 12:35 | |
| zanaga | well.. actually it's using the postgres user with ident.. | 12:42 |
| zanaga | ident matches the username to the database user and uses that | 12:42 |
| jessejames | the log seems to say that I'm connecting as my openerpuser. | 12:50 |
| *** cjeske has joined #openobject | 12:58 | |
| *** boran has joined #openobject | 12:59 | |
| *** boran has quit IRC | 13:03 | |
| jessejames | zanaga, thanks for your help. Looks as though there is a bug filed for this: https://bugs.edge.launchpad.net/ubuntu/+source/openerp-server/+bug/331065 | 13:10 |
| zanaga | hmm.. are you sure that it's the same issue.. doesn't look like it to me | 13:12 |
| jessejames | not exactly the same, but I couldn't create a database on another lucid server (a few days ago) | 13:14 |
| *** enlightx has quit IRC | 13:19 | |
| jessejames | zanaga, I've found the problem: "user error". I created the db user with the command from http://doc.openerp.com/install/linux/postgres/index.html#setup-a-postgresql-user but didn't realise that the user was openuser not openerp (which is what I put in the config files) | 13:45 |
| jessejames | zanaga, with the right user name in and changing pg_hba.conf to md5, everything works | 13:46 |
| zanaga | ah | 13:46 |
| zanaga | good thing you found the problem | 13:46 |
| zanaga | you should take a look at /usr/share/doc/openerp-server/README.Debian for other debian/ubuntu specific stuff as well | 13:46 |
| *** hounddog has joined #openobject | 13:47 | |
| jessejames | thanks | 13:47 |
| *** boran has joined #openobject | 13:51 | |
| *** boran has quit IRC | 13:59 | |
| *** tarik has joined #openobject | 14:05 | |
| *** boran has joined #openobject | 14:06 | |
| *** boran has quit IRC | 14:16 | |
| *** eLBati has quit IRC | 14:18 | |
| *** ardian has left #openobject | 14:23 | |
| *** mrcast has joined #openobject | 14:37 | |
| *** Marcel|HSD has left #openobject | 14:53 | |
| *** Red15 has quit IRC | 15:01 | |
| *** Red15 has joined #openobject | 15:01 | |
| *** eLBati has joined #openobject | 15:07 | |
| Red15 | when calling a function from inside your model (and the target function is also inside that same model) do you need to use super() ? | 15:10 |
| *** stijnbe has joined #openobject | 15:12 | |
| cedk | Red15: no | 15:13 |
| Red15 | but i tried to overwrite this target function from another inherited model but the original function does not call the re-written function | 15:15 |
| Red15 | so i have model a with function b, inside b it calls function a.c() (with self) | 15:15 |
| Red15 | but when i create model d which is _inherit and _name = a._inherit and a._name | 15:16 |
| Red15 | and inside d i tried to override c() | 15:16 |
| Red15 | while i expect a.b() -> d.b() -> a.b() | 15:17 |
| cedk | Red15: that is the expected behavior | 15:17 |
| Red15 | but doesnt seem to work ... | 15:18 |
| Red15 | and in fact d.b() calling a.b() would depend on me calling super(d, self).b() right ? | 15:18 |
| *** eLBati has quit IRC | 15:18 | |
| *** javivf has joined #openobject | 15:26 | |
| *** Marcel|HSD has joined #openobject | 15:44 | |
| *** Marcel|HSD has left #openobject | 15:49 | |
| *** Marcel|HSD has joined #openobject | 15:49 | |
| *** cjeske has quit IRC | 15:56 | |
| *** tarik_ has joined #openobject | 15:56 | |
| *** tarik has quit IRC | 15:59 | |
| *** tarik_ is now known as tarik | 16:00 | |
| *** Marcel|HSD has left #openobject | 16:01 | |
| *** hounddog has quit IRC | 16:06 | |
| *** tarik has quit IRC | 16:06 | |
| *** Marcel|HSD has joined #openobject | 16:07 | |
| *** zigzapgabe_ has quit IRC | 16:20 | |
| *** eLBati has joined #openobject | 16:31 | |
| *** pepeu has joined #openobject | 17:02 | |
| *** Spiralmatrix has joined #openobject | 17:04 | |
| *** pepeu has quit IRC | 17:32 | |
| *** pepeu has joined #openobject | 17:38 | |
| *** caneca has joined #openobject | 17:39 | |
| caneca | Hello, is there a way to select witch fields, between the ones that are being shown, that are editable in a tree view with editable="bottom" option? Or all of them become editable always? | 17:42 |
| caneca | field readonly="1" problem solved, thanks | 17:52 |
| *** quodt has quit IRC | 17:55 | |
| *** jehan_ has joined #openobject | 18:06 | |
| *** cedk has quit IRC | 18:16 | |
| *** Spiralmatrix has quit IRC | 18:19 | |
| *** javivf has quit IRC | 18:23 | |
| *** Red15 has quit IRC | 18:24 | |
| *** stijnbe has quit IRC | 18:27 | |
| *** RELAXPOR has joined #openobject | 18:50 | |
| RELAXPOR | HELLO | 18:50 |
| RELAXPOR | ANYBODY HERE | 18:50 |
| *** ovnicraft has joined #openobject | 18:53 | |
| *** julian1828 has left #openobject | 18:55 | |
| *** cedk has joined #openobject | 18:59 | |
| *** kalymero has quit IRC | 19:01 | |
| *** ludo2 has quit IRC | 19:04 | |
| *** RELAXPOR has quit IRC | 19:20 | |
| *** Marcel|HSD has left #openobject | 19:30 | |
| *** eLBati has quit IRC | 19:43 | |
| *** KangOl has quit IRC | 19:48 | |
| *** jehan_ has quit IRC | 19:51 | |
| *** austini has joined #openobject | 20:24 | |
| austini | hi, is there a function/module what i could use to search a order with the reference. basically id wanna find a deal with the reference. | 20:25 |
| austini | Im talking mostly about sales, purchase, manufacturing, stock and invoicing | 20:25 |
| *** LucaSub1 has joined #openobject | 20:28 | |
| *** LucaSub1 has left #openobject | 20:28 | |
| *** KangOl has joined #openobject | 20:30 | |
| *** ChanServ sets mode: +o KangOl | 20:31 | |
| *** jessejames has quit IRC | 20:31 | |
| *** julian1828 has joined #openobject | 20:31 | |
| *** ovnicraft has quit IRC | 20:54 | |
| *** mrcast has left #openobject | 21:05 | |
| austini | also is there a way to create a purchase order based on a open sales order? | 21:14 |
| *** SteelSide has joined #openobject | 21:24 | |
| SteelSide | Hello! Does OpenERP have anything that would help manage eg rents for an appartment building/subscriptions from customers? | 21:25 |
| austini | depends a lot from the process how you want to manage them | 21:27 |
| austini | you could consider one appartment as a running project that you manage with project management | 21:28 |
| austini | depends a lot on the level of detail you require from the system | 21:28 |
| SteelSide | hmm | 21:28 |
| SteelSide | austini, how much detail could I get using that way, and some other way, if you have another opention to compare it with? | 21:32 |
| *** bechamel has joined #openobject | 21:33 | |
| austini | first i need to know the size the operations your running? | 21:33 |
| austini | whether you actually need a erp to run it | 21:33 |
| SteelSide | Actually the closest thing I came up with was rent/subscriptions | 21:34 |
| SteelSide | We're a small ISP (at least we can call it that) and need a better way to keep track of our customers and send out invoices | 21:35 |
| SteelSide | about 50 customers at present and expecting to stay within a hundred or two | 21:35 |
| austini | then youll need a CRM and periodical invoicing | 21:37 |
| austini | basically you need to connect a customer with a product that is invoiced every so often | 21:39 |
| SteelSide | sounds sane | 21:41 |
| SteelSide | do you have any recomendations on CRM software? Preferably open source, but any pointers are welcome. | 21:41 |
| austini | i reckon that openerp can do it with slight modification | 21:42 |
| austini | other than that, building such SW would be simple, fast, quick and cheap | 21:42 |
| austini | using existing crm as a base for that | 21:44 |
| *** cedk has quit IRC | 21:49 | |
| *** ludo2 has joined #openobject | 21:52 | |
| *** cedk has joined #openobject | 21:52 | |
| *** ovnicraft has joined #openobject | 22:28 | |
| *** ludo2 has quit IRC | 22:29 | |
| *** ludo2 has joined #openobject | 22:50 | |
| *** bechamel has quit IRC | 22:52 | |
| *** pepeu has quit IRC | 22:55 | |
| *** julian1828 has quit IRC | 23:00 | |
| *** austini has quit IRC | 23:06 | |
| *** Marcel|HSD has joined #openobject | 23:08 | |
| *** quodt has joined #openobject | 23:11 | |
| *** mr_amit has quit IRC | 23:39 | |
| *** quodt has quit IRC | 23:51 | |
| *** cedk has quit IRC | 00:18 | |