*** jcater has quit IRC
*** jcater has joined #gnuenterprise
*** SachaS has joined #gnuenterprise
*** Morphous has joined #gnuenterprise
*** Amorphous has quit IRC
*** holycow has quit IRC
*** sacha_ has joined #gnuenterprise
<sacha_> t
*** sjc has joined #gnuenterprise
*** SachaS has quit IRC
*** konijn has joined #gnuenterprise
<konijn> ah, many more people than on gnue :D
<konijn> who can I bother with newbie questions ?
<konijn> debian related, I think I screwed it up and want to unscrew ( if possible )
<ajmitch> how badly screwed up? :)
<konijn> well heh
<konijn> I get this error :
<ajmitch> btw, using tarballs or debian packages?
<konijn> DB000: gnue.common.definitions.GParser.MarkupError: Error processing <import-tabledata> tag [I do not know what a <import-tabledata> tag does]
<konijn> make: *** [postgresql] Error 1
<ajmitch> or code from svn?
<konijn> well, I first did apt-get install gnue-.*
<konijn> this installed python & all packages
<ajmitch> right, what versions?
<konijn> but then I couldnt get gnue-designer running with Postgres
<ajmitch> (of gnue packages)
<konijn> a sec
<konijn> gnue common version  0?5?2
<konijn> 0.5.2
<ajmitch> ok
<ajmitch> what are you trying to do that gives that error?
<ajmitch> there are 0.5.4 packages, but not uploaded to sid yet
<konijn> well, i tried to connect to the postgres database in the developer
<konijn> it said : login required for ....
<konijn> so I tried gnue without password
<konijn> and that didnt work so I'm stumped
<konijn> so then I tried to install gnue with the subversion stuff
<konijn> but that didnt work either :'(
<konijn> it breaks then at the install-postgres.sh
<ajmitch> you'd need to setup your postgresql db for the gnue stuff
<ajmitch> I'm not too familiar with it, unfortunately
<konijn> I've added the database gnue
<konijn> and the user gnue
<konijn> darned
<konijn> :(
<konijn> which db are you familiar with ?
<ajmitch> mainly mysql
<konijn> I dont care really at this moment which database
<ajmitch> I have to lookup stuff when doing it with postgresql
<konijn> uh, except mysql since I have snob friends that dont like mysql :D
<konijn> just kidding
<konijn> erm ok
<konijn> let's do apt-get install mysql then
<ajmitch> you need to add the db, add the user, and then grant permissions to the user for that db
<ajmitch> for postgresql
<konijn> can you look up how to do the third part for postgres, you'd use google or have a better link ?
<ajmitch> there are 3 different db drivers to choose from for postgres, also :)
<konijn> I have installed the proper driver
<konijn> psychog
<konijn> or something like that
<ajmitch> right
<ajmitch> were you trying to just play with the tools, or with a specific example?
<konijn> Just wanted to make a form
<ajmitch> ok
* ajmitch looks up what he has 
<ajmitch> I've got postgres & mysql installed here for gnue use :)
<konijn> do you remember how you set up the postgres user ?
*** SachaLunch has quit IRC
<ajmitch> something like GRANT ALL PRIVILEGES ON DATABASE gnue TO user;
<ajmitch> there's a page on the wiki, now that I recall
<konijn> w00t
<konijn> the wiki pages didnt help a lot :(
<konijn> it's where I got the xml parser error, when following the wiki
<ajmitch> probably because you'd need to use a newer gnue version to use the examples there
<konijn> ah
<ajmitch> especialy if you followed the one for gnue-appserver examples...
<ajmitch> appserver has seen a fair bit of development lately 
<konijn> it is indeed one of the gnue-appserver examples
* ajmitch pokes jcater - wakeup!
<konijn> so what would happen if I apt-get remove all the gnue stuff
<ajmitch> I would have to hunt you down ;)
<konijn> and then get from subversion the gnue package
<konijn> can I still run gnue-designer then ?
<ajmitch> one moment, I'll get you updated debian packages
<konijn> you have automated the process of creating the deb packages ?
<ajmitch> no
<ajmitch> I build them :)
<konijn> heh
<ajmitch> for now, use in /etc/apt/sources.list
<ajmitch> deb http://ajmitch.dyndns.win.co.nz/debuild/gnue ./
<ajmitch> that ought to work
<ajmitch> I'll try & get them into sid asap :)
<ajmitch> it probably won't help with the postgresql setup, but appserver examples would have a better chance of working :)
<ajmitch> anything working there?
<konijn> noops
<konijn> i do apt-get update
<konijn> and then it doesnt seem to get the packages from your http link
<konijn> weird
<konijn> :(
<ajmitch> hmm, I saw it in the apache logs
<ajmitch> apt-get install gnue-common
<ajmitch> see if it upgrades the packages
<ajmitch> it'll probably show a 404 on the Release file (not required for apt)
<konijn> gnue-common is already the most recent version
<konijn> and it stays 0.5.2
* ajmitch mutters :)
<konijn> could it be because other lines where it does check are more like
<konijn> deb htp://blablabla main contribe non-free
<konijn> ?
<konijn> do I have to upgrade my installation first ?
<ajmitch> nah, that's because there are subdirs for that
<ajmitch> shouldn't do
<konijn> I'd prefer not to
<konijn> but gnue is really very interesting
<konijn>  I was writing something similar to it in Java
<konijn> but gnue is way further ;D
<konijn> and a group effort which always beats the solo solution :)
<ajmitch> hehe
<konijn> so if I _have_ to upgrade, I will
* ajmitch got the packages list fine from a server he uses
<ajmitch> grab the packages individually if you want, there's not many :)
<ajmitch> only 5 if you want all the tools
<konijn> I use the apt-get install gnue-.*
<konijn> i love regular expression :D
<ajmitch> heh
<konijn> still , it doesnt work, I dont get a newer version :(
<konijn> also separater apt-get install gnue-designer doesnt work for example
<konijn> darn
*** konijn has left #gnuenterprise
<ajmitch> bother
*** konijn has joined #gnuenterprise
<konijn> back
<ajmitch> hmm
<ajmitch> I wonder why your apt-get doesn't like me
<ajmitch> paste the line you added?
<ajmitch> it works fine here for me
<konijn> yes
<konijn> I even tried
<konijn> deb http://ajmitch.dhis.org/debuild/gnue/ ./
<ajmitch> but I see an http 200 response there... :)
<konijn> I am on it with mozaille
<konijn> that will explain it :D
<konijn> sorry to burst the bubble :D
<ajmitch> no, with a user agent of apt-get
<konijn> wow
<konijn> basterd
<konijn> ok
<ajmitch> I didn't do it
<konijn> apt-get is a basterd :D
<ajmitch> yep :)
<ajmitch> just wget gnue-{common,forms-wxgtk,designer}-0.5.4-1_all.deb
<ajmitch> and dpkg -i the same :)
<ajmitch> (add the rest of the url to that wget command)
<konijn> on the road :D
*** lekma has joined #gnuenterprise
<konijn> that still doesnt work well :(
<konijn> DB000: Traceback (most recent call last):
<konijn> DB000:   File "/usr/lib/gnue/python/gnue/designer/base/TemplateParser.py", line 222, in OnNextStep
<konijn> DB000:     self.setStep(self.nextStep)
<konijn> DB000:   File "/usr/lib/gnue/python/gnue/designer/base/TemplateParser.py", line 178, in setStep
<konijn> DB000:     self.stepInfo = self.parser.template.GetStep(step)
<konijn> DB000:   File "/usr/lib/gnue/python/gnue/designer/templates/forms/Simple.py", line 103, in GetStep
<konijn> DB000:     set=self.GetAvailableSources(self.variables['connection'])), ),
<konijn> DB000:   File "/usr/lib/gnue/python/gnue/designer/base/TemplateBase.py", line 171, in GetAvailableSources
<konijn> DB000:     self.__cachedSources[connection_name] = \
<konijn> DB000: AttributeError: Connection instance has no attribute 'introspector'
<konijn> and then the wizard that I wanted to try falls over :(
<ajmitch> ooh, that looks worrying
<ajmitch> how'd you get that?
<konijn> click file , click new, click wizard, click simple wizard
* ajmitch looks
<konijn> choose database ( postgres ) , identify ( gnue, no password)
<konijn> and then this error
<konijn> before I had an identification error
<konijn> so it's better :D
<konijn> I think
<ajmitch> it shouldn't be :)
* ajmitch waits
<ajmitch> hmm, I logged into a postgres db & it worked ok
<konijn> darn
<ajmitch> using provider = postgresql in connections.conf, however
<ajmitch> which, iirc, autoselects a driver
<ajmitch> are you using debian unstable?
<konijn> no
<konijn> stable
<ajmitch> right..
<ajmitch> I'm surprised these packages installed, they've only been tested on unstable :)
<ajmitch> what version of python-psycopg ?
<konijn> works better
<ajmitch> sorry?
<konijn> have the authent error again
<ajmitch> alright
<ajmitch> so that shows more of a postgresql config problem than gnue
<ajmitch> can you login to the db via the command line?
<ajmitch> something like psql -u gnue gnue
<ajmitch> (if gnue is the db you created and gnue the user)
* ajmitch notes that he has to go to sleep soon
<konijn> ok
<konijn> sorry
<konijn> had visit
<konijn> the misses told me to be polite :D
<konijn> heh
<ajmitch> hehe
<konijn> that works
<konijn> I get in
<ajmitch> alright
<ajmitch> and psql -u gnue -h 127.0.0.1 gnue
<ajmitch> this just happened to be on the mailing list a couple of days ago :)
<konijn> ah 
<konijn> this failed
<konijn> I have change the all   all machin
<ajmitch> nah
<ajmitch> you don't need to
<konijn> what do I have to do then ?
<ajmitch> you could add a section in pg_hba.conf for host 127.0.0.1 
<ajmitch> or you could change connections.conf
<ajmitch> to say "host =" instead of "host = localhost"
<ajmitch> I suggest changing /etc/gnue/connections.conf for now
<konijn> ok
<ajmitch> any luck yet? :)
<konijn> well shoot
<konijn> I did the pg_hba thing first
<konijn> and now I seem to have corrupted it 
<ajmitch> ah it's easy enough to do...
<ajmitch> especially if you're using docs for >= 7.3 and you're using an old postgresql
<ajmitch> I think the wiki docs are for a modern postgres, where they changed the pg_hba.conf syntax
<konijn> ah
<ajmitch> the comments in the file ought to help enough
<konijn> you know where I can find the postgres server log ?
<ajmitch> it probably logs to /var/log/syslog
<ajmitch> or /var/log/postgres.log
<konijn> darn
<konijn> ok, i'll let you sleep :D
<ajmitch> ok :)
<ajmitch> there should be others around soon, if they decide to visit on a sunday :)
* ajmitch falls onto his bed 
<konijn> sleep well
<konijn> sweet dreams
*** konijn has quit IRC
*** sjc has quit IRC
*** Vee has quit IRC
*** lekma has quit IRC
*** dimas has quit IRC
*** Vee2d2 has quit IRC
*** jcater has quit IRC
*** ajmitch has quit IRC
*** Stoke_ has quit IRC
*** derek_home has quit IRC
*** mdean has quit IRC
*** Morphous has quit IRC
*** nickr has quit IRC
*** wayneg has quit IRC
*** ubriz has quit IRC
*** chillywilly has quit IRC
*** havoc has quit IRC
*** Morphous has joined #gnuenterprise
*** nickr has joined #gnuenterprise
*** wayneg has joined #gnuenterprise
*** ubriz has joined #gnuenterprise
*** chillywilly has joined #gnuenterprise
*** havoc has joined #gnuenterprise
*** jcater has joined #gnuenterprise
*** derek_home has joined #gnuenterprise
*** mdean has joined #gnuenterprise
*** ajmitch has joined #gnuenterprise
*** Stoke_ has joined #gnuenterprise
*** lekma has joined #gnuenterprise
*** konijn has joined #gnuenterprise
*** sjc has joined #gnuenterprise
*** Vee has joined #gnuenterprise
*** dimas has joined #gnuenterprise
*** Vee2d2 has joined #gnuenterprise
*** SachaS has joined #gnuenterprise
*** sjc has quit IRC
*** sjc has joined #gnuenterprise
*** SachaS has quit IRC
*** SachaS has joined #gnuenterprise
*** SachaS has quit IRC
<konijn> any one awake ?
*** Stoke_ has quit IRC
*** ajmitch has quit IRC
*** Vee has quit IRC
*** konijn has quit IRC
*** lekma has quit IRC
*** Vee2d2 has quit IRC
*** dimas has quit IRC
*** jcater has quit IRC
*** derek_home has quit IRC
*** mdean has quit IRC
*** havoc has quit IRC
*** ubriz has quit IRC
*** wayneg has quit IRC
*** Morphous has quit IRC
*** chillywilly has quit IRC
*** nickr has quit IRC
*** mdean has joined #gnuenterprise
*** derek_home has joined #gnuenterprise
*** Morphous has joined #gnuenterprise
*** nickr has joined #gnuenterprise
*** wayneg has joined #gnuenterprise
*** ubriz has joined #gnuenterprise
*** chillywilly has joined #gnuenterprise
*** havoc has joined #gnuenterprise
*** ajmitch has joined #gnuenterprise
*** Stoke_ has joined #gnuenterprise
*** jcater has joined #gnuenterprise
*** lekma has joined #gnuenterprise
*** konijn has joined #gnuenterprise
*** Vee has joined #gnuenterprise
*** dimas has joined #gnuenterprise
*** Vee2d2 has joined #gnuenterprise
*** havoc has quit IRC
*** ubriz has quit IRC
*** wayneg has quit IRC
*** Morphous has quit IRC
*** chillywilly has quit IRC
*** nickr has quit IRC
*** Morphous has joined #gnuenterprise
*** nickr has joined #gnuenterprise
*** wayneg has joined #gnuenterprise
*** ubriz has joined #gnuenterprise
*** chillywilly has joined #gnuenterprise
*** havoc has joined #gnuenterprise
*** mdean has quit IRC
*** derek_home has quit IRC
*** derek_home has joined #gnuenterprise
*** mdean has joined #gnuenterprise
*** mdean has quit IRC
*** derek_home has quit IRC
*** havoc has quit IRC
*** ubriz has quit IRC
*** wayneg has quit IRC
*** Morphous has quit IRC
*** chillywilly has quit IRC
*** nickr has quit IRC
*** jcater has quit IRC
*** Vee has quit IRC
*** konijn has quit IRC
*** lekma has quit IRC
*** Vee2d2 has quit IRC
*** dimas has quit IRC
*** Stoke_ has quit IRC
*** ajmitch has quit IRC
*** mdean has joined #gnuenterprise
*** derek_home has joined #gnuenterprise
*** havoc has joined #gnuenterprise
*** chillywilly has joined #gnuenterprise
*** ubriz has joined #gnuenterprise
*** wayneg has joined #gnuenterprise
*** nickr has joined #gnuenterprise
*** Morphous has joined #gnuenterprise
*** Vee2d2 has joined #gnuenterprise
*** dimas has joined #gnuenterprise
*** Vee has joined #gnuenterprise
*** konijn has joined #gnuenterprise
*** lekma has joined #gnuenterprise
*** jcater has joined #gnuenterprise
*** Stoke_ has joined #gnuenterprise
*** ajmitch has joined #gnuenterprise
*** ubriz has left #gnuenterprise
*** ubriz_ has joined #gnuenterprise
<konijn> any one that can help with an error I'm getting ?
*** reinhard has joined #gnuenterprise
*** konijn has quit IRC
<lekma> hi reinhard
<lekma> reinhard: did you achieve to make joins with datasources and conditions??
*** SachaS has joined #gnuenterprise
<reinhard> hi lekma
<reinhard> yes i did
<reinhard> if all goes well i will commit today
<reinhard> hi SachaS
<lekma> reinhard: can you get to display the field on which the join is done?
<reinhard> lekma: bbl in 10 minutes
*** reinhard has quit IRC
*** reinhard has joined #gnuenterprise
<reinhard> back
<reinhard> lekma: i think ididn't understand your question
<lekma> the way it is now you can make: 
<lekma>   <datasource name="dts_test" connection="test_dev" table="a_test,b_test">
<lekma>     <condition><eq><cfield name="a_test.key_id"/><cfield name="b_test.key_id"/></eq></condition>
<lekma>   </datasource>
<lekma> but you can't have neither a_test.key_id nor b_test.key_id in the block
<reinhard> you can't?
<lekma> error was: key_id was ambiguous
<reinhard> ah
<reinhard> gotcha
<reinhard> well, can't you have the field "a_test.key_id" in the block?
<reinhard> btw i'm doing the joins in appserver
<reinhard> so this is not exactly the problem i was trying to solve
<reinhard> but just a quite similar one
<lekma> ah ok
<reinhard> can you have a dot in
<reinhard> <field name="foo" field="a_test.key_id">
<reinhard> ?
<lekma> nope, same error
<reinhard> eek
<lekma> gnue.common.datasources.drivers.DBSIG2.DataObject kept adding 'key_id' in _fieldReferences dict
<reinhard> you didn't order_by key_id, did you?
<lekma> nope no order_by
<reinhard> weird
<reinhard> i didn't have that problem
<lekma> you can have dots in the field name, and it works for the first empty resulset which is created before querying the db
<reinhard> even though i did something very similar within appserver
<reinhard> i think the dataObject gets field references passed from GDataSource.py
<lekma> yes, i did follow it up to the point the first empty resulset is created, GFField initiate GDatasource referenceField() and _fieldReferences is used by DataObject
<lekma> but when you query the db _fieldReferences get updated by ?? and DataObject gets a new referenced field
<reinhard> hmmm
<reinhard> i guess a grep on _fieldReferences doesn't help much, right?
<lekma> i'm lost in gnue code (that would make a movie title)
<reinhard> would be a scary movie
<reinhard> ;-)
<lekma> and as i'm a newbie in python as well as gnue...
<lekma> nope
<reinhard> lekma: it might well be that i'll stumble across the same problem while finishing my change today
<reinhard> if i do, i'll keep you updated
<lekma> ok thanks
<reinhard> otherwise you might want to inform jamest or jcater
<jcater> lekma: fieldReferences gets updated by the dataobjects after the first query
<jcater> just in case we did a "select * from ..."
<jcater> in gnue forms, this doesn't happen
<jcater> but in other tools/custom scripts it might
<jcater> so the updating of fieldReferences by the dataobjects when using forms is redundent
<jcater> well, that's not 100% true either
<jcater> for most databases it's redundent
<jcater> but our good old friend mysql bastardizes its field names
<jcater> so when using joins, it is helpful w/mysql too
* jcater runs off... I opened the pool today :)
<chillywilly> dropping the kids off at the pool...
<SachaS> night
<SachaS> happy swimming
<SachaS> hallo reinhard. bin noch nicht dazu gekommen, um das gespraech zu ...
<SachaS> niderzuschreiben
<reinhard> SachaS: ok
<reinhard> SachaS: np
<SachaS> dah. that was german ...
<SachaS> ok.
<SachaS> will be busy next week, as I got feedback from my supervisors ...
<SachaS> and then I will go to New Orleans HURRAY!
<SachaS> well
<SachaS> and now i go to bed :)
<reinhard> good night
*** SachaS has left #gnuenterprise
*** dneighbo has joined #gnuenterprise
*** derek_home has quit IRC
<reinhard> night all
*** reinhard has quit IRC
<lekma> jcater: how can i bypass the updating of  fieldReferences
<lekma> ?
*** sjc has quit IRC
*** lekma has quit IRC
*** ajmitch has quit IRC
*** ajmitch has joined #gnuenterprise
*** frayed has joined #gnuenterprise
<frayed> hello?
*** frayed has quit IRC
<jcater> bypass?!?
<jcater> why bypass?
*** jcater has quit IRC