V_laptop (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) joined #gnuenterprise.
<wombat_> Ping?
<derek> V_laptop: i went spring training game (athletics vs angels)
<derek> then got home went to the store and buddy called me for emergency to play for them in a triple header
<derek> got home and watched movie with wife 
<V_laptop> yea yea.. 
<derek> im back now but pretty beat, it was a little over 80 today so got lots of sun
<V_laptop> =)
<derek> i see you sent email to gnue-sb i reckon that addresses most of what you wanted to discuss?
<V_laptop> think so.. 
<derek> cool
<derek> you be around tomorrow?
<V_laptop> should be
Action: derek needs to get some rest
<derek> after church i will try to stop in and we can address stuff ;)
<V_laptop> nadda problema
<derek> cool
Action: derek is away: sleep
<V_laptop> nite
fixe (~fixe@dsl093-081-253.chi2.dsl.speakeasy.net) joined #gnuenterprise.
Nick change: chillywilly -> cw-zzzZZZ
<cw-zzzZZZ> hmm?
Action: cw-zzzZZZ thought he saw a gost cw-zzzZZZ1
<cw-zzzZZZ> ghost*
<Vee2d2> boo!
<cw-zzzZZZ> 06:25 [ aaron___  ] [ derek ] [ InsanitY] [ pattieja] [ Stoke  ] [ wtg]
<cw-zzzZZZ> 06:25 [ bigbrother] [ dsmith] [ Isomer  ] [ ra3vat  ] [ Vee    ]
<cw-zzzZZZ> 06:25 [ cw-zzzZZ1 ] [ esands] [ johannes] [ reinhard] [ Vee2d2 ]
<cw-zzzZZZ> 06:25 [ cw-zzzZZZ ] [ havoc ] [ mdean   ] [ SachaS  ] [ wombat_]
<cw-zzzZZZ> see there's 2 sleeping chillywillys
<cw-zzzZZZ> er was
<cw-zzzZZZ> I had scrolled up and not noticed it
<cw-zzzZZZ> ok, sleep for real now
<Vee2d2> nite
<Vee2d2> me too I guess..
wombat_ (~mpalmer@server.baileyroberts.com.au) left irc: 
SachaS_ (~Sacha@dialup-196-9.wasp.net.au) joined #gnuenterprise.
ToyMan (~stuq@glvv-dsl4-118.citlink.net) joined #gnuenterprise.
Nick change: cw-zzzZZZ -> chillywilly
stuq_ (~stuq@glvv-dsl4-118.citlink.net) joined #gnuenterprise.
ToyMan (~stuq@glvv-dsl4-118.citlink.net) left irc: Read error: 110 (Connection timed out)
stuq_ (~stuq@glvv-dsl4-118.citlink.net) left irc: Read error: 60 (Operation timed out)
stuq_ (~stuq@170-215-206-10.glv.frontiernet.net) joined #gnuenterprise.
stuq_ (~stuq@170-215-206-10.glv.frontiernet.net) left irc: "Client Exiting"
Stoke_ (~stoker@ppp419.tc-1.roc-pt.ny.localnet.com) joined #gnuenterprise.
Stoke (~stoker@ppp23.tc-22.roc-pt.ny.localnet.com) left irc: Read error: 113 (No route to host)
reinhard (~reinhard@M690P031.adsl.highway.telekom.at) joined #gnuenterprise.
jamest (~jamest@adsl-64-216-111-42.dsl.tpkaks.swbell.net) joined #gnuenterprise.
<jamest> are there any numeric systems on our planet that do negative numbers differently than -100
<jamest> our numeric typecast isn't accepting minus signs and I want to fix
<jamest> being (l)american I want to limit the minus sign to the 1st char in the field
InsanitY (insanity@co58147-a.olden1.ov.home.nl) left irc: "changing servers"
V_laptop (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) left irc: Read error: 60 (Operation timed out)
fredrik__ (~fredrik@212-162-172-180.skbbip.com) joined #gnuenterprise.
<fredrik__> hi
<jamest> hi
fredrik__ (~fredrik@212-162-172-180.skbbip.com) left #gnuenterprise.
<reinhard> jamest: some accounting people tend to write it as 100-
<Vee2d2> jamest: (100) ?
<reinhard> Vee2d2: yes and that
<jamest> hmmmmm
<reinhard> but i haven't seen it in pracice
<jamest> how does a database handle that one
<reinhard> i only know that excel permits for that
<reinhard> the (100) one
<jamest> as I would think an int or number field would puke
<Vee2d2> I've only seen (100) in accounting reports 
<jamest> anyone have latest cvs up and running?
<jamest> i need someone to test a behaviour for me
<jamest> i really don't care to checkout a backup of head to test (as slow as cvs has been)
<jamest> well we seem to allow as many decimal points in a number as they want
<jamest> so i'll make it allows as many minus signs as they want
<jamest> this code is being replaced w/ input masks anyway so it's good enough for now i gues
<jamest> s
<Vee2d2> what do you need to test?
<jamest> i need someone to do a form like zipcode.gfd
<jamest> and tell me where the cursor appears
<Vee2d2> to just load it up? 
<jamest> what I'm seeing is the cursor is initially shown at the start of the field
<jamest> but typing a character puts it at the end of the field and the cursor jumps to the end
<Vee2d2> oof
<Vee2d2> DB000:   File "/home/vin/cvs/gnue/gnue/.cvsdevelbase/gnue/common/definitions/GParser.py", line 278, in startElementNS
<Vee2d2> DB000:     raise MarkupError, tmsg
<Vee2d2> DB000: gnue.common.definitions.GParser.MarkupError: Error processing <form> tag [I do not recognize the "height" attribute
<Vee2d2> geeg:~/cvs/gnue> gfcvs /home/vin/cvs/gnue/gnue/samples/tutorials/forms/zipcode/zipcode.gfd
<jamest> forms/samples/zipcode/zipcode.gfd
<jamest> i'm trying to get that mess cleaned up today too
<jamest> and get it all under gnue/samples
<Vee2d2> cursor sits in the first entry under City
<jamest> at start or end of the value?
<Vee2d2> I dont guess I understand what you mean?
<Vee2d2> it's on the beginning of that entry
<jamest> example: before the F in Fooville or after the e
<jamest> try pressing the right arrow
<jamest> does the cursor move to the right?
<Vee2d2> it behaves as I would expect.. 
<Vee2d2> do you mean as I type?
<jamest> yes
<jamest> If I querry up foo
<jamest> then press q
<jamest> i get fooq
<jamest> even though the cursor was before the f
<jamest> after that first bad cursor location it works perfectly
<jamest> i'll grab a fresh cvs
<Vee2d2> well I didnt have any data in the cities.. just added some, cleared, queried and put the cursor anywhere and start typing and that's where the chars get inserted
<jamest> i should probably keep a control checkout anyway
<jamest> the placement is perfect
<jamest> it's only initially after a query that I have an issue for only 1 keypress
Action: jamest has been in the display handlers trying to reduce screen refreshes
<Vee2d2> ahh! you're right
<Vee2d2> I closed and reloaded the form and I get the behavior you describe
<jamest> ok, so it's not something I introduced today then
<jamest> good as I didn't see how
<jamest> thanks
<jamest> it's depressing the number of little bugs I'm finding this weekend
<Vee2d2> that's not always a bad thing.. better than 'the number of giant bugs'
<jamest> i've got a list of those too
Action: ra3vat is finally installing debian
<Vee2d2> welcome to the land of smiles, ra3vat
<Vee2d2> s/land/bits/ ?
<jamest> where we're all very very happy
<jamest> and about 9 months behind the current software
<Vee2d2> hehe
<jamest> ;)
Action: Vee2d2 ponders food stuffs
<ra3vat> thanks :)
<ra3vat> what package for jabber server available in woody? my debian box is not on the net yet
<jamest> jabber
<jamest> apt-get install jabber
<Vee2d2> apt-cache is your friend, too. apt-cache search jabber
Action: Vee2d2 settles for potato chips
<ra3vat> ok
<ra3vat> Vee2d2: did not find jabber server on the disk i've used as the local source though few jabber clients appeared
<Vee2d2> you might also try http://www.debian.org/distrib/packages I guess.
<Vee2d2> there's some search forms on the bottom of the page
<Vee2d2> but ideally you'd wanna get things worked out so you can apt-get via the net
<ra3vat> Vee2d2: the link looks good it even opened in russian :)
<ra3vat> will try to connect that machine from the office tomorrow
InsanitY (insanity@co58147-a.olden1.ov.home.nl) joined #gnuenterprise.
<derek> Vee2d2: if ONLY apt-cache chips worked
<derek> apt-get consume doritos
<Vee2d2> heh
<Vee2d2> dpkg --purge driedsquidchips
Black_Engus (~jim@MTL-HSE-ppp200933.qc.sympatico.ca) joined #gnuenterprise.
Black_Engus (~jim@MTL-HSE-ppp200933.qc.sympatico.ca) left #gnuenterprise ("Client Exiting").
reinhard (~reinhard@M690P031.adsl.highway.telekom.at) left irc: "Fighting for peace is like fucking for virginity."
lupo (lupo@p5085F9B6.dip.t-dialin.net) joined #gnuenterprise.
lupo (lupo@p5085F9B6.dip.t-dialin.net) left irc: ""There are 10 different kinds of people on the world - those who understand binary and those who don't.""
SachaS_ (~Sacha@dialup-196-9.wasp.net.au) left irc: "Client Exiting"
<chillywilly> ello, anybody home?
<chillywilly> anyone know of a time tracking app for kde?
<Vee2d2> 'suop chilly
<chillywilly> or like a "project" app
<dsmith> chillywilly: mrproject?
<jcater> DCL + Konqueror
<jcater> :)
<dsmith> Oh. kde. Sorry.
Action: dsmith hides
<chillywilly> well doesn't matter what interface it has
<chillywilly> I think once upon a time I used gnome time tracker
<chillywilly> using DCL might be cool but that means work for havoc ;)
<chillywilly> well...maybe not
<chillywilly> I'm not sure I want to set it up though
<havoc> http://freshmeat.net/projects/ktimeclock/?topic_id=57
<chillywilly> thanks
<dsmith> chillywilly: I used to use "timesheet" on my palm, now we are using "AllTime" 
<chillywilly> well I should be a true gnuer and use dcl, but I probably won't ;P
Action: chillywilly downloads ktimeclock
ToyMan (~stuq@170-215-206-10.glv.frontiernet.net) joined #gnuenterprise.
ToyMan (~stuq@170-215-206-10.glv.frontiernet.net) left irc: Remote closed the connection
wtg (~merlinx@ppp384.qld.padsl.internode.on.net) left irc: "You ain't got debian you ain't got shit!"
wombat_ (~mpalmer@server.baileyroberts.com.au) joined #gnuenterprise.
<wombat_> Has anyone considered a groupware (PIM, Outlook, call it what you will) for GNUe?  It could integrate rather well with a lot of other areas (calendars and tasks, particularly) and would encourage a few people away from the Microsoft world view
V_laptop (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) joined #gnuenterprise.
chillywilly (danielb@mke-24-167-199-83.wi.rr.com) left irc: "restarting X"
chillywilly (danielb@mke-24-167-199-83.wi.rr.com) joined #gnuenterprise.
<chillywilly> derek around?
<chillywilly> here masta masta masta
<chillywilly> damn
<chillywilly> I need someone to kick around for a dcl install
<chillywilly> erm, while attempting one that is
wtg (~merlinx@ppp384.qld.padsl.internode.on.net) joined #gnuenterprise.
<jcater> wombat_: there was talk at one point of a GNUe Groupware
<jcater> hasn't gotten past talk though
<chillywilly> you ever install dcl jcater ;)?
<jcater> a year or so ago
<chillywilly> hmmm, can anyone reach postgresql.org?
<chillywilly> I get a blank page
<chillywilly> ?!?
<jcater> try www.us.postgresql.org
<jcater> it usually works when main site doesn;t
<chillywilly> k
<wombat_> jcater: Who was doing the discussion?
<jcater> mdean was leading the discussion
<jcater> (the author of DCL)
<jcater> he was main person interested
<wombat_> Well, I'm definitely keen.  I'll need something like that for work I want to do with GNUe anyway
<chillywilly> are we using dcl 0.9.2?
<chillywilly> for management of gnue that is
<wombat_> Are there any plans by anyone to restart or replace the PHP HTML forms client?  I see the status of phpforms is "CVS.  Dead." (paraphrased) on the website
ToyMan (~stuq@170-215-206-10.glv.frontiernet.net) joined #gnuenterprise.
<jcater> lol
<jcater> yeah
<jcater> we want to do a native html client
<jcater> the phpforms client was a complete reimplementation of our code in php
<jcater> chillywilly: we are on the latest DCL
<jcater> I think 0.9.2
<chillywilly> ok
<chillywilly> hey in pg_hba.con isn't it host (or the other 2) database use IP MASK AUTH AUTH_ARG ?
<chillywilly> s/use/user/
<chillywilly> .conf*
<wombat_> jcater: So the idea is to slap a Python CGI in front instead?
<jcater> in a nutshell, yes
<wombat_> cool
<chillywilly> jcater: is that pg_hba.conf format correct?
<chillywilly> HOST DATABASE IP MASK AUTH AUTH_ARG
<chillywilly> erm
<chillywilly> HOST DATABASE USER IP MASK AUTH AUTH_ARG
<jcater> local   all         all                                           trust
<jcater> host    all         all         127.0.0.1        255.0.0.0        trust
<jcater> host    all         all         0.0.0.0          0.0.0.0          reject
<jcater> is mine
<chillywilly> I like to use passwords ;)
<chillywilly> but that's bsides the point...
<chillywilly> you can't make any remote connections that way can ya?
<chillywilly> unix domain socket or local tcp/ip connection
<chillywilly> everything else is thrown out
<jamest> you pass the postmaster a -i to get tcp/ip
<jamest> them
<jamest> then
<chillywilly> already running with -i
<chillywilly> IIRC
<chillywilly> it is just complaining about my pg_hba.conf
<jamest> host    all         all         192.168.1.0   255.255.255.0   password|ident|crypt|or whatever the heck you want
<chillywilly> anything wrong with this line:
<chillywilly> host          all         all          192.168.0.0  255.255.0.0          md5
<chillywilly> this is the line it doesn't like
<jamest> did you restart the postmaster after adding it?
<chillywilly> yea
<jamest> or -HUP'n it
<chillywilly>  /etc/init.d/postgresql restart
<jamest> nothing I can see
wombat_ (~mpalmer@server.baileyroberts.com.au) left irc: "Gotta go, study to do"
Action: chillywilly thwaps postgres
<jcater> I've had bad lock with anything besides trust or reject :)
<jcater> so I'm a bad person to be asking
<jamest> chillywilly: I'm not sure /etc/init.d/postgresql supports restart
<chillywilly> I think I see the problem
<jamest> i used crypt and password
Action: chillywilly thwaps himself
Action: jamest thwaps chillywilly too
<jamest> hey jason, you need to get on this?
<jamest> s/?//
<chillywilly> :'(
<jcater> ?
<jamest> thwaping chillywilly
<jcater> oh
Action: jcater thwaps chillywilly
Action: chillywilly runs off to hide
<chillywilly> damnit
<chillywilly> still complains
jemfinch (~jfincher@ts5-9.homenet.ohio-state.edu) joined #gnuenterprise.
<jemfinch> if I have a UNIQUE column, will inserts with that column run faster if I put CREATE INDEX on that column?
<chillywilly> also, none of the examples in the file have a value for username
<jcater> jemfinch: what database? most databases I'm aware of, if you use UNIQUE, the database implicitly creates an index
<jemfinch> jcater: this is SQLite.
ToyMan (~stuq@170-215-206-10.glv.frontiernet.net) left irc: "Client Exiting"
<jamest> if it supports the explain statement it should tell you if it's using an index
Action: jemfinch wonders...he hasn't seen any mention of that in the documentation.
<jemfinch> it supports the explain statement.
<jamest> explain select * from dbname where uniqueField = 'bar';
Action: jemfinch will take a look once the db is finished building.
<jemfinch> this is actually taking a long time to build, though, so I'm expecting there not to be an index on the column.
<chillywilly> what the heck
<chillywilly> oh wait...this is testing here...
<chillywilly> postgres 7.2.1
<chillywilly> hmmm...
<jemfinch> hmm.
<jemfinch> I think I may have done my SQL wrong.
Action: chillywilly contemplates upgrading to sid
<chillywilly> does 7.2.1 use a format that omits usernames?
<jemfinch> the database is already at 20mb, and the data set it's coming from is only 2.5mb.
<jamest> chillywilly: yes
<chillywilly> (that would be kinda pointless though
<chillywilly> blah
<chillywilly> whose brilliant ide was that?
<chillywilly> idea*
<jamest> huh?
<jamest> user isn't in pg_hba.conf
<jamest> users are still in the db
<chillywilly> then what's the second 'all'
<jamest> 7.2.x has a different pg_hba format
<jamest> host         all         192.168.0.0   255.255.0.0   password
<chillywilly> yes and I asked whose brilliant idea was that and why they didn't add usernames sooner
<chillywilly> ;)
<chillywilly> is what I was implying
<chillywilly> you're just repeating yourself
<jcater> chillywilly: on the pg site, there is an elephant
Action: jamest thwaps chillywilly again
<jcater> blame him
<jcater> or blame derek
<jcater> that works most of the time
Action: chillywilly trout-foo kicks jamest through the monitor
<chillywilly> just you wait
<jcater> trout-foo?
<jcater> I guess that's not as bad as goat-bar
<chillywilly> I am still working on a device that will allow you to stab ppl in the face over the internet
<jcater> goatse comes close
<jcater> real close
<chillywilly> ROFL
<chillywilly> ROFLMAO
<chillywilly> man jcater you should go into comedy ;)
<jcater> I code on gnue
Action: chillywilly whipes away the tears from laughing
<jcater> isn't that close enough?
<chillywilly> hehe
<jcater> jamest gets a laugh from my code all the time
<chillywilly> I thought it SCARED him...
<jcater> oh
<jcater> I saw the tears
<jcater> I assumed it was from laughing to hard
<chillywilly> prolly not
<chillywilly> frell... postgres 7.3 is reason enough to upgrade...nah, I'll make do
jemfinch (~jfincher@ts5-9.homenet.ohio-state.edu) left irc: Read error: 54 (Connection reset by peer)
Action: jamest runs across the background being chased by a rabid GConditional
<chillywilly> wonder if there's a FNR stream going...
Action: chillywilly kicks postgres some more
<chillywilly> gawd I feel like such crap
<chillywilly> still noe dcl install just postgres configured...
<chillywilly> no
Action: chillywilly falls over
<chillywilly> crap I forgot to call caroline
Vee (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) joined #gnuenterprise.
V_laptop (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) left irc: Read error: 104 (Connection reset by peer)
<Vee2d2> that laptop setup can be pretty annoying.. if I so much as bump the table it's sitting on the pcmcia card locks the system up
<chillywilly> why?
<chillywilly> is it broke?
<Vee> old & w0rnout
jemfinch (~jfincher@ts33-3.homenet.ohio-state.edu) joined #gnuenterprise.
<jemfinch> ah, wow.
<Vee> you doing the dcl & timetracking in part for what will be your consulting buiz?
<jemfinch> SQLite apparently doesn't create indices on unique columns.
<Vee> ^chilly
<jemfinch> because making the indices made the select statement *much* faster.
<jemfinch> it's still pretty slow, though.
<jemfinch> do you think you guys can tell me if I can optimize this query at all?
<jemfinch> SELECT words.word from words, anagrams, sorted_words WHERE sorted_words.word='opt' AND anagrams.sorted_word_id=sorted_words.id AND words.id=anagrams.word_id
<chillywilly> Vee: well no I am using it to trakc my hours for a project I am working on for havoc
<chillywilly> er, I want to anyway
<chillywilly> right now I am wrestling with php
<chillywilly> it wants to serve me up the index.php file and not interpret it
<Vee> loading the module and whatnot in /etc/apache?
<chillywilly> yea
<chillywilly> I am pretty sure..lemme triple check it
<chillywilly> ;)
<Vee> another min or two & I'll bbe back in my office to check my configs.. 
<chillywilly> blah, it is commented out, wtf
<chillywilly> crap db errors
<chillywilly> I don't think I copied the right files over...
<chillywilly> $%^&**!@#
<chillywilly> this is annoying
<chillywilly> I hate php apps ;)
<chillywilly> what the heck
dsmith (dsmith@oh-strongsvillecadent1-1c-203.clvhoh.adelphia.net) left irc: "later.."
<chillywilly> of course no one is home in #dcl
<chillywilly> I don't think the INSTALL.txt in in sync
<chillywilly> cause I did what it said
<chillywilly> *grumble*
<chillywilly> hmmm
<chillywilly> well for anyone who cares
<chillywilly> this is what I got:
<chillywilly> Error executing query!
<chillywilly> SELECT dcl_config_name, dcl_config_field, dcl_config_int,dcl_config_double, dcl_config_date, dcl_config_datetime,dcl_config_varchar FROM dcl_config
<chillywilly> ERROR: Relation "dcl_config" does not exist Template Error: filename: file ./templates//login.tpl does not exist.
<chillywilly>  Halted.
<chillywilly> but I did run the sql script...
Action: chillywilly drops the db and tries again
<jamest> i though derek installed the last dcl from .debs on ash
<chillywilly> AFAIK 0.9.2 isn't packaged...
<Vee> I think I installed it.. but havent checked it out..
<Vee> chillywilly: it's in unstable
<chillywilly> doh
Action: chillywilly slaps himself
<jemfinch> does the order of my AND clauses in my query make a difference?
Action: chillywilly just did an apt-cache show dcl Vee ;)
<chillywilly> dangit
<chillywilly> hmmm...is there gonna be an issue of dpk -i the deb on a testing box?
<jamest> jemfinch: i believe that they can
<jamest> you want to match your index order
<Vee> jemfinch: I wouldnt think so... I wonder if there's a #sql-lite where developers hang or something...?
Action: chillywilly goes to the debian package web site to get it...
<jamest> i believe
<chillywilly> I may just frelling upgrade to sid...
<chillywilly> that might make life easier ;)
<chillywilly> doj
<chillywilly> DOH
<chillywilly> 0.9.2 is in testing
<jemfinch> jamest: what do you mean, "you want to match your index order"?
<jemfinch> Vee: it doesn't appear to be so.
<Vee2d2> there
<Vee2d2> actually, I need a drink now.. 
<Vee2d2> brb
<Vee2d2> there there.. =)
<jamest> i mean that if you have an index on column foo
<jamest> then you don't want to do
<jamest> where bar = '10' and foo = '1'
<jamest> but I haven't really studdied how indexes work since  Oracle 6
<jamest> which was like early/mid 90s
<jamest> so it may not be that way anymore
<jamest> explain should tell you
<jamest> explain is a wonderfull tool at least on postgresql
<jemfinch> I've got EXPLAIN on sqlite, but I don't quite know how to use it.
<jemfinch> did you see my query earlier?
<jcater> "You got some 'splainin to do, Lucy"
<jemfinch> should that query take a particularly long time to run?
<jemfinch> it took forever with no indexes; when I put indexes on sorted_words.word, words.word, and both anagrams.word_id and anagrams.sorted_word_id, it went a bit faster, but it still seemed slow.
<jamest> why even bring anagrams into the query?
<jemfinch> anagrams is the table that links sorted_words and words.
<chillywilly> tired...
<jamest> whoops, misread ti
<jemfinch> words is an id INTEGER PRIMARY KEY and a word TEXT.
<jemfinch> sorted_words is the same thing.
<jemfinch> (well, both those word TEXT are word TEXT UNIQUE ON CONFLICT IGNORE)
<jemfinch> anagrams is a word_id and a sorted_word_id to link the two.
<chillywilly> so wtf do I just make a symlink to /usr/share/dcl/www ?
<jamest> all you need to do is the same query with explain in front of it
<jamest> explain select .....................
<jemfinch> yeah, I did that -- but I don't know what to do about the output.
<jamest> what's it say
<jemfinch> hmm.
<jemfinch> I could keep a sorted_word_id in the words table.
<jemfinch> jamest: can I paste it into a /query to you?
<jemfinch> is "CREATE INDEX blah ON table (column1, column2)" the same as "CREATE INDEX blah1 ON table (column1); CREATE INDEX blah2 ON table (column2)"?
<jamest> i don't think so
<jamest> the first indexes by 1st column then the second
<jamest> so a select * from table where column2 = 'bar' ; 
<jamest> would not use the 1st index
<Vee2d2> chillywilly: I think they could take some pointers from packages like php(my|pg)admin where they put an apache.conf in /etc/php(my|pg)admin which has an apache alias and directory stuffs.. 
<chillywilly> you still hafta edit the main config right?
<Vee2d2> chillywilly: somehow it gets read.. I havent dug very deep to figure out the magic involved
<chillywilly> hrrrm, well I thought the post-install stuff edited http.conf for me
<jemfinch> jamest: do you want to see the EXPLAIN output?
<jamest> sure
<jamest> i'll try and read it
<jemfinch> it's 29 lines.
<chillywilly> but it didn't seem to do it I had to uncomment some lines myself
<jamest> hang on
<chillywilly> Vee2d2: it probably includes the config file in the main
<Vee2d2> ahh, I see it..
<Vee2d2> it appends /etc/apache/httpd.conf with
<Vee2d2> Include /etc/phpmyadmin/apache.conf
<Vee2d2> Include /etc/phppgadmin/apache.conf
<Vee2d2>                                                                                          
[23:15] Last message repeated 1 time(s).
<chillywilly> yep
<Vee2d2> it's a nice way of doin it
<chillywilly> yea
<chillywilly> that's debian?
<Vee2d2> yep
<Vee2d2> should report it as a bug for jeff.. =)
<chillywilly> hmmm, the grant.sh script is a PITA
<chillywilly> cause I created my own postgres user for DCL
<chillywilly> dcl owns the dcl database
Action: chillywilly adds a -U $grantTo to beginning of the psql command in grant.sh
Action: chillywilly wishes he didn't use password auth now
<chillywilly> frickin' have to type it for every grant in the for loop
<chillywilly> :-/
<chillywilly> should've added -p $password
Action: chillywilly hits C-c
<chillywilly> hmmm, -p is for port
<Vee2d2> get it worked out chilly?
<Vee2d2> reportbug is such a nifty tool.. 
<Vee2d2> hmm..
<Vee2d2>  Normal bugs - outstanding: 3 reports
<Vee2d2>   2) #155511: dcl: Wrong path in /etc/dcl/apache.conf
<Vee2d2> I didnt have an /etc/dcl/apache.conf at all.. 
<jemfinch> hmm.
<chillywilly> in postgres do you have to mark the end of an sql script in a special way?
<Vee2d2> wouldnt think so
<Vee2d2> you mean like in a dump?
<chillywilly> ah, that fixed it
<chillywilly> I hacked the grant.sh script to be better than what it was
<chillywilly> now I only type the password once
<chillywilly> ;P
<chillywilly> wonder where I can send the new shell script to
<chillywilly> ;P
<Vee2d2> reportbug
<chillywilly> it's part of dcl
<chillywilly> not debian
<chillywilly> package stuff
<chillywilly> it grants the db user ALL on the tables and sequences
jamest (~jamest@adsl-64-216-111-42.dsl.tpkaks.swbell.net) left #gnuenterprise.
<chillywilly> the thing was it would call psql like every time int he look
<chillywilly> and if you have passwd auth then it will prompt you for the password every frelling time
<Vee2d2> well, if it was anything else I would still have said reportbug and let the package maintainer forward it upstream..  but I guess mdean would be the guy to hit with it, eh?
<chillywilly> yea
<chillywilly> I made it so it wrote all the grant statements to a temp file then call psql once then rm'd the temp file
<derek> chillywilly: submit a patch ;)
Action: derek adds $U as well
<chillywilly> oh and it also uses the -U as the dcl may be only run by a postgres user
<derek> as it kicks me in the teeth on ash regularly ;)
<chillywilly> and not a system user
<chillywilly> right :)
<chillywilly> me too man!
<chillywilly> :)
<derek> email it to dcl-support@gnuenterprise.org ;)
<chillywilly> ah, ok
<derek> and mdean or i will take care of it
<chillywilly> yea, now I have to get back the original file to make a patch...
<derek> i.e. email your 'diff'
<chillywilly> apt-get --reinstall install dcl
<derek> :)
Action: derek has to be to work WAY too early
<derek> Vee i didnt forget about you, just busy weekend :(
Action: chillywilly will get up at 8am and start working
<chillywilly> or so..
<derek> will be swamped likely mon - wed too :(
<derek> will try to respond to your mail and get some stuff checked in
Action: derek HAS to get taxes done this week
<Vee2d2> cool
<Vee2d2> yea, me too.. or at least started
<derek> er get them prepared to take to accountant (i.e. clean my desk)
<chillywilly> you set a specific variable...cause I just used $grantTo after the -U
<chillywilly> cause AFICT grantTo is the user
<chillywilly> wonder if it will overwrite config.php
<chillywilly> oh well...
--- Mon Mar 10 2003