| chat.freenode.net #tryton log beginning Sun Oct 11 00:00:02 CEST 2009 | ||
| 2009-10-11 00:29 -!- gremly(n=gremly@190.25.200.108) has joined #tryton | ||
| 2009-10-11 00:36 -!- gremly(n=gremly@190.25.200.108) has joined #tryton | ||
| 2009-10-11 00:36 -!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton | ||
| 2009-10-11 00:45 -!- gremly1(n=gremly@190.25.200.108) has joined #tryton | ||
| 2009-10-11 01:05 -!- gremly2(n=gremly@190.25.200.108) has joined #tryton | ||
| 2009-10-11 01:17 -!- vengfulsquirrel(n=ian@69.181.194.95) has joined #tryton | ||
| 2009-10-11 02:20 -!- FWiesing(n=FWiesing@194.208.185.12) has joined #tryton | ||
| 2009-10-11 02:21 -!- vengfulsquirrel(n=ian@69.181.194.95) has joined #tryton | ||
| 2009-10-11 04:23 -!- Orban(n=ruckc@207-118-215-244.dyn.centurytel.net) has joined #tryton | ||
| 2009-10-11 05:19 -!- yangoon(n=mathiasb@p549F7570.dip.t-dialin.net) has joined #tryton | ||
| 2009-10-11 08:04 -!- gour(n=Gour@93.159.88.138) has joined #tryton | ||
| 2009-10-11 08:53 -!- carlos(n=carlos@87.221.156.255) has joined #tryton | ||
| 2009-10-11 09:55 -!- carlos(n=carlos@87.221.156.255) has joined #tryton | ||
| 2009-10-11 09:56 -!- gour(n=Gour@188.125.19.6) has joined #tryton | ||
| 2009-10-11 10:26 -!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton | ||
| 2009-10-11 10:58 -!- paepke(n=paepke@R8a00.r.pppool.de) has joined #tryton | ||
| 2009-10-11 12:24 -!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton | ||
| 2009-10-11 12:29 -!- carlos(n=carlos@88.148.7.66) has joined #tryton | ||
| 2009-10-11 13:18 -!- carlos(n=carlos@88.148.7.66) has joined #tryton | ||
| 2009-10-11 14:02 -!- udono(n=udono@85.197.24.144) has joined #tryton | ||
| 2009-10-11 14:34 -!- carlos(n=carlos@88.148.7.66) has joined #tryton | ||
| 2009-10-11 15:44 <cedk> Orban: I have fixed the manifests in overlay | ||
| 2009-10-11 17:21 <Orban> cedk, also postgresql's createuser doesn't have a --quiet option in the emerge --configure trytond | ||
| 2009-10-11 17:25 <cedk> Orban: which version ? | ||
| 2009-10-11 17:28 <Orban> 1.2.2 | ||
| 2009-10-11 17:28 <Orban> oh postgres 8.4.1 | ||
| 2009-10-11 17:31 -!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton | ||
| 2009-10-11 17:41 -!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton | ||
| 2009-10-11 17:56 <cedk> Orban: seems to be removed | ||
| 2009-10-11 17:57 <cedk> Orban: it is present in 8.1.11 | ||
| 2009-10-11 17:57 <cedk> Orban: could you give me the output of "createuser --help" | ||
| 2009-10-11 17:59 <cedk> Orban: it was removed betwee 8.2 and 8.3 | ||
| 2009-10-11 18:01 -!- gour(n=Gour@87.252.135.22) has joined #tryton | ||
| 2009-10-11 18:05 <CIA-78> C?dric Krier <ced@b2ck.com> default * 296:a68c54703e1b gentoo-overlay/app-office/trytond/ (12 files): Remove quiet option of createuser for version >= 8.3 | ||
| 2009-10-11 18:05 <CIA-78> http://hg.tryton.org/tryton-overlay/rev/a68c54703e1b | ||
| 2009-10-11 18:05 <cedk> Orban: fixed | ||
| 2009-10-11 18:08 <Orban> sweet | ||
| 2009-10-11 18:08 <Orban> thanks cedk | ||
| 2009-10-11 18:40 -!- yangoon(n=mathiasb@p549F7570.dip.t-dialin.net) has joined #tryton | ||
| 2009-10-11 18:43 -!- preC(n=preCTWO@orkan.Informatik.Uni-Oldenburg.DE) has joined #tryton | ||
| 2009-10-11 18:49 -!- preC(n=preCTWO@134.106.11.155) has joined #tryton | ||
| 2009-10-11 18:50 -!- yangoon(n=mathiasb@p549F7570.dip.t-dialin.net) has joined #tryton | ||
| 2009-10-11 18:56 -!- gour(n=Gour@188.125.13.202) has joined #tryton | ||
| 2009-10-11 19:01 -!- carlos(n=carlos@88.148.7.66) has joined #tryton | ||
| 2009-10-11 19:04 -!- yangoon(n=mathiasb@p549F7570.dip.t-dialin.net) has joined #tryton | ||
| 2009-10-11 19:08 <CIA-78> carlos roundup * #1220/Missing menu entry to add a new Category for a Product: | ||
| 2009-10-11 19:08 <CIA-78> [new] The Product module lacks a menu entry to add a new Category for a product. | ||
| 2009-10-11 19:08 <CIA-78> You can workaround it opening the list of categories and then, ... | ||
| 2009-10-11 19:08 <CIA-78> http://bugs.tryton.org/roundup/issue1220 | ||
| 2009-10-11 19:23 -!- paepke(n=paepke@R8a00.r.pppool.de) has joined #tryton | ||
| 2009-10-11 20:38 -!- huzzel(n=huzzeln@p54A3D5D9.dip.t-dialin.net) has joined #tryton | ||
| 2009-10-11 20:57 <Orban> ok, so i have trytond installed in gentoo and the client just created a database, now the client doesn't show the database as available and there were no errors on creating it | ||
| 2009-10-11 21:01 <yangoon> Orban: and the client returned succes after having created the database? | ||
| 2009-10-11 21:03 <Orban> yes | ||
| 2009-10-11 21:03 <Orban> let me try again though | ||
| 2009-10-11 21:08 <Orban> it does the creating the database progress bar -- then it just goes back to the connect dialog | ||
| 2009-10-11 21:09 <yangoon> Orban: and you cannot login with user admin and the password, you entered for him? | ||
| 2009-10-11 21:10 <Orban> nope, it says No database found, you must create one | ||
| 2009-10-11 21:10 <yangoon> Orban: did you enter the correct connection details? | ||
| 2009-10-11 21:11 <Orban> yes, in trytond.conf i specified hostname (localhost) and port, user, password | ||
| 2009-10-11 21:11 <yangoon> Orban: I m speaking from the connect dialog in the client | ||
| 2009-10-11 21:11 <Orban> yes | ||
| 2009-10-11 21:12 <Orban> because it connects and shows entries in the trytond.log file | ||
| 2009-10-11 21:15 <yangoon> Orban: strange, could you please paste somewhere the log? | ||
| 2009-10-11 21:16 <Orban> yes just a moment, i am retrying it while tailing the postmaster.log | ||
| 2009-10-11 21:16 <yangoon> you should see the database anyway in postgres... | ||
| 2009-10-11 21:22 -!- carlos(n=carlos@88.148.7.66) has joined #tryton | ||
| 2009-10-11 21:23 <Orban> yes the database exists in postgres | ||
| 2009-10-11 21:23 <Orban> how does the server find existing databases? | ||
| 2009-10-11 21:26 <yangoon> the database owner of the postgres database has to be the user you specified in trytond.conf | ||
| 2009-10-11 21:27 <Orban> yes that is the case | ||
| 2009-10-11 21:27 <yangoon> Orban: you have the trytond admin, you have the postgres user, and you have the admin of|in each database | ||
| 2009-10-11 21:27 <Orban> i'm digging into pool.py to see how it queries for the database list | ||
| 2009-10-11 21:28 <Orban> the trytond user is the owner of the database, and it created it | ||
| 2009-10-11 21:29 <yangoon> don't confuse the user running the server with the user accessing poastgres | ||
| 2009-10-11 21:29 <yangoon> Orban: do you have the correct client version for the server? | ||
| 2009-10-11 21:29 <Orban> i'm not | ||
| 2009-10-11 21:30 <Orban> yes, i'm running 1.2.2 server | ||
| 2009-10-11 21:30 <Orban> and 1.2.2 client windows | ||
| 2009-10-11 21:30 <Orban> and the server is linux/gentoo | ||
| 2009-10-11 21:30 <yangoon> then it cannot be localhost in the client | ||
| 2009-10-11 21:30 <Orban> no on the client its <hostname>:8070 | ||
| 2009-10-11 21:30 <Orban> the connection settings i thought you were referring to was trytond.conf | ||
| 2009-10-11 21:32 <yangoon> Orban: could you please paste the log of trytond after a connection attempt? | ||
| 2009-10-11 21:34 <Orban> is there a way to increase log verbosity, its only showing one line per connection attempt ([Sun Oct 11 14:29:29 2009] INFO:database:connect to "") | ||
| 2009-10-11 21:34 <yangoon> Orban: run the server with -v | ||
| 2009-10-11 21:35 -!- carlos(n=carlos@88.148.7.66) has joined #tryton | ||
| 2009-10-11 21:40 <Orban> http://pastebin.com/m176d737f | ||
| 2009-10-11 21:42 <yangoon> Orban: ând log with database creation? | ||
| 2009-10-11 21:43 <Orban> ok, one moment | ||
| 2009-10-11 21:49 <Orban> http://pastebin.com/m46258a06 | ||
| 2009-10-11 21:49 <Orban> so its creating the pool, but its not putting it in the list of known databases | ||
| 2009-10-11 21:52 <yangoon> Orban: you are running postgres 8.4? | ||
| 2009-10-11 21:53 <Orban> yes | ||
| 2009-10-11 21:55 <yangoon> Orban: are you familiar with patches? | ||
| 2009-10-11 21:55 <Orban> its been a while but yes | ||
| 2009-10-11 21:56 <Orban> is there an issue with tryton and postgres 8.4 | ||
| 2009-10-11 21:57 <yangoon> Orban: we don't know so far, but could be perhaps | ||
| 2009-10-11 21:59 <cedk> Orban: the code that retrieve database is in trytond/backend/postgresql/database.py line 149 | ||
| 2009-10-11 22:01 <yangoon> Orban: http://paste.pocoo.org/show/144416/ | ||
| 2009-10-11 22:01 <yangoon> Orban: this patch omits database check, if you want to try it | ||
| 2009-10-11 22:02 <yangoon> make first a backup of trytond/backend/postgresql/database.py | ||
| 2009-10-11 22:08 <yangoon> Orban: but cedk is right, it is probably not the check failing, but the listing | ||
| 2009-10-11 22:08 <yangoon> Orban: so better to try the select statement from the commandline, if it is working | ||
| 2009-10-11 22:09 <Orban> ok i added some debugging statements into database.py, and its executing the query on line 164 after if db_name:, then if i run the query in psql it returns the database, but the cursor.fetchall() doesn't return anything... | ||
| 2009-10-11 22:09 <Orban> the select statement is working | ||
| 2009-10-11 22:09 <Orban> on commandline, but not in python | ||
| 2009-10-11 22:10 -!- vengfulsquirrel(n=ian@69.181.194.95) has joined #tryton | ||
| 2009-10-11 22:20 <Orban> yangoon, yea its definetly giving me different results on the sql in tryton vs. psql... | ||
| 2009-10-11 22:26 <cedk> Orban: are you sure you run the query with the same sql user? | ||
| 2009-10-11 22:26 <Orban> yes | ||
| 2009-10-11 22:26 <Orban> both running as trytond | ||
| 2009-10-11 22:28 <cedk> Orban: and you connect to template1? | ||
| 2009-10-11 22:34 <Orban> yep | ||
| 2009-10-11 22:35 <cedk> Orban: that is really strange | ||
| 2009-10-11 22:35 <Orban> echo "select datname from pg_database where datdba = (select usesysid from pg_user where usename='trytond') and datname not in ('template0','template1','postgres') order by datname;" | psql -U trytond template1 | ||
| 2009-10-11 22:35 <Orban> yep | ||
| 2009-10-11 22:36 <cedk> Orban: which version of psycopg? | ||
| 2009-10-11 22:37 <Orban> 2.0.12 | ||
| 2009-10-11 22:37 <Orban> let me try to replicate the query in python | ||
| 2009-10-11 22:42 <Orban> cedk, http://pastebin.com/m239096d3 | ||
| 2009-10-11 22:50 <Orban> in database.py i just manually added it to the res list and it works fine | ||
| 2009-10-11 22:53 <cedk> Orban: it is really strange | ||
| 2009-10-11 22:54 <Orban> i agree | ||
| 2009-10-11 23:42 <cedk> Orban: could you try with psycopg 2.0.7 ? | ||
| 2009-10-11 23:49 <Orban> cedk, not really i've got a few other apps that depend on psycopg | ||
| 2009-10-11 23:51 <cedk> Orban: it is a python module so it will not need any re-compile | ||
| 2009-10-11 23:58 <Orban> no, but i need 2.0.12 due to fixes, though i can't remember which ones |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!