*** lxf has joined #gnuenterprise *** SachaS has joined #gnuenterprise *** lxf has quit IRC *** SachaS has quit IRC weii.. anyone can help me with some routing problem? *** Amorphous has joined #gnuenterprise *** kilo has joined #gnuenterprise *** reinhard has joined #gnuenterprise *** johannesV has joined #gnuenterprise *** Morphous has quit IRC reinhard: good morning samples/gauntlet on the 3rd page some messagebox wont display DB000: File "/home/gabor/gnue-svn/gnue-common/.cvsdevelbase/gnue/forms/GFForm.py", line 928, in triggerActivateDialog DB000: self._instance.activateForm(dialogName,parameters, modal) DB000: File "/home/gabor/gnue-svn/gnue-common/.cvsdevelbase/gnue/forms/GFInstance.py", line 333, in activateForm DB000: form.processTrigger('On-Activation') DB000: File "/home/gabor/gnue-svn/gnue-common/.cvsdevelbase/gnue/common/logic/GTrigger.py", line 294, in processTrigger DB000: function(self) DB000: File "/home/gabor/gnue-svn/gnue-common/.cvsdevelbase/gnue/common/logic/adapters/Base.py", line 181, in __call__ DB000: return apply (self.execute, args, params) DB000: File "/home/gabor/gnue-svn/gnue-common/.cvsdevelbase/gnue/common/logic/adapters/python.py", line 202, in execute DB000: exec self._compiled in self._context._globalNS, localNS DB000: File "", line 11, in ? DB000: File "", line 8, in _jumpto DB000: NameError: name 'Block_1' is not defined *** SachaS has joined #gnuenterprise good morning reinhard: appserver is running again. did reboot. now is working again. strange. did restart db but that did not help before... now is fine. SachaS: good morning hi kilo how are you? 3m: monday morning mood :) *** btami has joined #gnuenterprise *** Amorphous has quit IRC *** chillywilly has quit IRC *** dimas has quit IRC *** ajmitch has quit IRC *** Stoke_ has quit IRC *** johannesV has quit IRC *** btami has quit IRC *** SachaS has quit IRC *** derek has quit IRC *** holycow has quit IRC *** Vee2d2 has quit IRC *** Vee has quit IRC *** icltlfatppl has quit IRC *** dcmwai has quit IRC *** kilo has quit IRC *** havoc has quit IRC *** kilo has joined #gnuenterprise *** havoc has joined #gnuenterprise *** Amorphous has joined #gnuenterprise *** chillywilly has joined #gnuenterprise *** dimas has joined #gnuenterprise *** ajmitch has joined #gnuenterprise *** Stoke_ has joined #gnuenterprise *** johannesV has joined #gnuenterprise *** btami has joined #gnuenterprise *** SachaS has joined #gnuenterprise *** holycow has joined #gnuenterprise *** dcmwai has joined #gnuenterprise *** derek has joined #gnuenterprise *** Vee2d2 has joined #gnuenterprise *** icltlfatppl has joined #gnuenterprise *** Vee has joined #gnuenterprise reinhard: I think the changes to your post() commit() causes a problem for me. in a procedure I do create object 1, later in the same procedure I create object 2. object 2 references object 1. when I commit(), I get an error, saying, that when it wants to insert object 2 into the db, that there is no gnue_id of object 1 in the db. i try with the previous release version to see if the problem is only with the latest version. try with revision 5626 same problem. here the message in the client: DB000: File "/home/sacha/gnuenterprise/gnue/gnue-common/.cvsdevelbase/gnue/common/datasources/drivers/DBSIG2/Connection.py", line 271, in makecursor DB000: cursor.execute (s) DB000: ProgrammingError: ERROR: insert or update on table "purchase_inventoryreordertransaction" violates foreign key constraint "purchase_inventoryreordertransaction_purchase_inventoryreorder_" DB000: DETAIL: Key (purchase_inventoryreorder)=(85502001492224511697851243741222) is not present in table "inventory_inventoryreorder". DB000: DB000: INSERT INTO purchase_inventoryReorderTransaction (purchase_inventoryReorder,purchase_processed,gnue_id) VALUES ('85502001492224511697851243741222',FALSE,'83659906884327364165675687188627') at one stage the code was working. hey sash hi holycow. appserver is running. seems like only i had a problem. oh neat :) so then i go to the samples dir in gnue-appserver and try to get the sample app started, correct? yes. you have to edit your connections.conf file you can add the two values of the INSTALL file in the gnue-appserver dir your connections.conf file should be in /home/holycow/gnue/etc/ its not where is it? ah wait yes it is ok. add the two entries, as shown in the INSTALL file [gnue] and [appserver] if they are not yet in the connections.conf file there is also one in /usr/local/gnue/etc but alrighty *nod* k [appserver] as well? i think its a leftover from my previous install... not sure i thought i cleaned everything out nevermind, make sure they look as shown in the INSTALL file. which python postgresql driver do you use? k. sorry for the really dumb question i use psycopg i'm not sure frankly... apt-get install python2.3-psycopg ;) i forget how i installed it in the first place, i may have looked it up in apt after reading the pdf hehe k. sec. lemme check the install file settings k i already have all those settings in the connections.config file DB000: Error: The PostgreSQL driver returned the following error: DB000: FATAL: IDENT authentication failed for user "gnue" any thoughts? i have user gnue in postgresql and account doesn't need password (set via webmin module for postgres if that matters) running the postgress script was successfull however, just an fyi what was successful? did you do a: make postgresql in the samples directory? and followed by a: ./setup-pgsql.sh ? ./setup-pgsql.sh <-- only that, as per instructions in installer oh yeah that does call make postgresql :) that was successful? yep, no error messages now it just can't login to gnue user in postgres appearently and if you connect with the psql tool can you call psql gnue ? ok. i get a gnue prompt gnue=# i presume that looks correct? dangit, i've never had any exposure to postgres either, i'm feel so fookin useless, my thanks for helping heh :) do a: \d you should get a list with tables the gnue_* tables are used for appserver and the address_* are used for the sample application. yep :) its all there 8 rows ok. \q will get you back to the shell prompt ehehe so thats it! and try in one window: gacvs --database gnue -Z i assume you get the permission error when you call that... bash: gacvs: command not found actually no i get what i had originally which was unrecognized bash commands for the strange gnue apps :/ gacvs not found. ok looks like the links to the tools is not set. i will owe you money after this, heh do a ls (you might have to adjust the path) lots of money ;) ls -al /home/holycow/bin you see the symbolic links to the python scripts in there. gotcha so you can do a: /home/holycow/bin/gacvs --database gnue -Z what do you get? ohhhhhh i get it k sec lots of errors, last one being --> FATAL: IDENT authentication failed for user "gnue" ok. so you dont have the permission :) open the file (as root) with your favourite editor: ah yeh :) to the db or the directory? emacs /etc/postgresql/pg_hba.conf i have to following (not very secure, not useable for production server but lets you going) lines set: local all postgres ident sameuser local all all trust local all all ident sameuser host all all 127.0.0.1 255.255.255.255 trust host all all 0.0.0.0 0.0.0.0 reject *nod* oh i see, permission to postgres it self fuck this shit is gonna take long to master heh postgres + python + gnue oivey! i think the hardest will be how to organise your application server business modules! heh :) thats okay its a start i picked up linux because i wanted one set of tools for the job i have a few modules, a few classes, a few procedures and cant find where I create new business objects :| (this calls for a new start) not the endless pile of shit one has on windoz :/ :) lol :) *nod* oh i will be hitting my head against many walls however with that being said gnue is really the only framework that i have found that really understands some of the things we've discussed did you do a: /etc/init.d/postgresql restart = ? ok. heh forgot *nod* i should know that done try again to start your appserver gacvs --database gnue -Z nope same thing ok. i think i know why whats your current user whoami rtaylor oh that one has to in in post conf yeah i think or you can do a: su to get root than a su postgres and then do a createuser --createdb --adduser gnue createuser --createdb --adduser rtaylor yeah both already exist :/ tried that what :) dah if you do the ./setup-pgsql.sh again do you get an error message at the top of the script=? before i do that, just to check: ident in /etc/posgresql/pg_hba.conf should be set to sameuser or rtaylor? i think you even can comment that line to only have local all all trust oh i see what your saying, we completely opened all the connections to pgsql *nod* no worries at one stage we have to get it right with the permissions etc. *nod* this is something silly i'm doing for sure i can smell it i know its bad when you dont know what your doing starts to smell bad in here ;) hehe :) i appreciate your work, the first time starting the engine is the hardest once it gets going one can keep it running :) yeah lets hope we get the engine started lots of errors as everything exists cool that makes sense ? example: ERROR: duplicate key violates unique constraint "gnue_id_pk_address_country" that makes sense as it was successfull originally yeah oh i see you might drop the database first do a oh right dropdb gnue and then again a ./setup-pgsql.sh and then start appserver with: gacvs --database gnue -Z and start the client with: gfcvs sample.gfd :) well dropping and setting up db is fine starting up server doesnt work again for same reasong gnue user authentication error gfcvs sample.gfd brings up a login screen and when i try to login as test test which i created my self out of curiosity doesnt work definately permissions issue yep. DB000: socket.error: (111, 'Connection refused') <-- generated for test/test which meanst its talking to the db successfully as far as i can tell ok. appserver is talking to the database the client is talking to the appserver in which window did you get that message? i opened another cli and made sure i was logged in as user account rtaylor, not postgres or root do you have a username setting in the connections.conf file? in the [gnue] part username = gnue that tells appserver which username to take to login to the database actually no, thats weird, that makes sense true, doesnt it i think when you set username to gnue you can close down the postgresql permission file again, so that only a user named gnue needs access and not everybody okay i dropped the db and gnue user again, recreated them, restarted b db piece of cake still no go that means its sommin in the config file what do you get? pg config file same permission error? gnue-appserver returnst a whole bunch of py errors, finally terminating in sql driver returning fata; ident failed for user gnue ok. it cant be anything other than pg config file imho yeah. have a look at the file. good luck ;) thx dude :) appreciate you taking me this far we are not very far :| well, lets just say you helped another user get a better understanding of how the cvs install is setup and why i get why bin and etc are in the /home/user dir now, and how the apps interact :D there a whole new world waiting for you ;) once you can enter it hehe hey you left earlier before you told me how you find form based development in gnue do you find it fast, revolutionary, etc? form based development. hmm. as a beginner, i like designer very much. lets you create simple forms easy and quickly. once you want a little bit more complicated forms, you have to dig a little bit deeper, but not that hard after all. i'm certain i will hit some kind of wall suppose i wanted to create a form with a timer, say a to do list where you check off an action item and time spent working on it would that be possible? or drag and drop between list tables? i think there is no drag and drop yet i think there is no drag and drop. but your todo list should be possible, even as a starter project. *nod* perhaps that is pushing it too far towards a platform or traditional dev environmet yeah? :) cool, i'll have fun trying first be able to log in :) hehehe you know the good thing? back to readme files, i may have missed something its not working because we dont have the permissions right whats that SachaS? wow, now hat is a discussion... GNUe: Abandon hope, all ye who enter here 8-)) ah yes :) hahaha :) kilo. we need to get postgress permissions right i see, Sacha, i see if it gets right, i will commit it to a wiki, if you dont mind kilo, my thoughts exactly kilo please do so are you logging this? i will wait until it succeeds... heh :) irc logs everything you may wait a day or two, i got sleep and work ahead of me :) hehe v v close i can smell it most important part to outline here are a few separate concepts did you check the pg_hba.conf file? once i get it i will help commit to wiki extra info SachaS, playing with it now ok. my /etc/postgresql/pg_ident.conf file is empty (only comments inside) obviously same here bbiab *** holycow has quit IRC *** holycow has joined #gnuenterprise okay reinstalled postgres :) heres an interesting factoid: after creating user and db gnue then running setup-pgsql.sh, psql says 'rtaylor' does not exist very interesting that would indicate it needs rtaylor account and gnue account? lets see what happens btami, are you here? i get a DB000: TypeError: dumpXML() got an unexpected keyword argument 'textEncoding' when saving a new form from designer I see you changed something in reports for revision 5213 5613 is the revision which includes a change from you. when I set LC_ALL="C" its fine yaaaay got it :) SachaS: yes it's me :( SachaS, you rock :) thanks holycow you were right, i misunderstood your instructions on the postgres conf file heh SachaS: will fix btami: i am not sure if it is a problem as now its working again :| the bug comes when you have a trigger in .gfd and want save indesigner btami. yep. it works without trigger but I get the error when I have a trigger (and button). woo hey :) form wizard rox holycow! is the sample working? is the appserver sample working? well the form wizard is, i just created a sample form from a table sorry i lost the sample form command can you post that again, i closed xchat b4 logging that line :/ did you connect to the appserver? with designer: yep yep yes great! ok. go into the samples file :) ok. go into the samples directory <-- v v happy and then call k. gfcvs sample.gfd nup lots of errors what? whats the last one? DB000: TypeError: __init__() takes exactly 2 arguments (1 given) do it again username: hacker password: secret oh he h works! :) good :) dude, thanks so much :) i knew you weren't far off, actually you were dead on i just misunderstood the permissions part sweetness :) btw nice touch on the human check box in that sample hahahaha :) oh i see gfcvs means gnue forms cvs version yeah. okay i see, this form wizard is really cool and fast way to create simple forms v nice kilo, okay solved it mmm, havent been following closely. what did you solve? the postgresql permission setup appserver connected to pg *nod* what SachaS said if you post to wiki, make sure you mention to change the /etc/postgresql/pg_hba.conf settings from someuser to trust probably extremely unsafe but for newbs kinda important the pdf on how to setup a sample app db is lacking in a few respects given what i've learned here ok, will parse through the log now time for some submission :) *** dcmwai has quit IRC SachaS: fixed it, can you try it for me, please? ok. nite all happy days :) *** holycow has quit IRC btami: it works when I connect to the db but i cannot connect to the appserver :| but that might be a problem of appserver ok. ok, thx lunch time SachaS: we recognized that in designer if you only change trigger code, it wont save that you need to change something on the form to save trigger code changes kilo: yeah i create the button in designer etc. but write the trigger code in emacs ;) ok then, lunch for me too finally here