*** jamest has left #gnuenterprise
*** holycow has quit IRC
*** Morphous has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
*** johannesV has joined #gnuenterprise
*** Amorphous has quit IRC
*** sjc has joined #gnuenterprise
*** dneighbo has quit IRC
*** dneighbo has joined #gnuenterprise
*** dcmwai has quit IRC
*** lekma has joined #gnuenterprise
<lekma> is there any way to set a field max_length from a trigger??
<reinhard> lekma: not that i am aware of
<lekma> reinhard: i made a setMaxLength in GFField... that will be ok for now
<lekma> bbl
*** lekma has left #gnuenterprise
*** dimas has quit IRC
*** dimas has joined #gnuenterprise
*** jamest has joined #gnuenterprise
*** wayneg1 has quit IRC
<jamest> reinhard: you guys using dates or timestamps in any databases?
<reinhard> yes
<jamest> seems like svn head pukes on those now
<ajmitch> hi jamest, reinhard
<jamest> both forms and common itself return 0 results from any query that has a date field or timestamp
<jamest> hi ajmitch
<jamest> with or without 
<jamest> [common]
<jamest> useParameters = 1
<jamest> in my gnue.conf file
<jamest> nothing shows up in the debug-level=100
<reinhard> you talking about date in the condition
<reinhard> or a date in the resultset?
<jamest> no, just registered as a field in the datasource
<jamest> it doesn't have to be part of the condition
<reinhard> we do that daily
<jamest> odd
<jamest> as none of my programs work anymore
<jamest> forms dead
<jamest> anything w/ GDataSourceWrapper dead
<reinhard> can you say since when?
<jamest> last night is when I first added date field to what I'm working on
<jamest> by adding this line 
<jamest> and only this line to a form
<jamest>       <field name="fldBatch_date" field="batch_date" typecast="date"/>
<jamest> i kill the form (0 records returned always)
<reinhard> odd
<reinhard> odd
<reinhard> odd
<ajmitch> rather peculiar
<jamest> i will be looking into in about 12 hours
<jamest> but jcater mentioned that "they" were working on datasources lately
<jamest> so I assumed "they" were those crazy austrians that have been going like mad on appserver
<ajmitch> I worry about them
<jamest> and figured I'd ask what was up before I took a stab at really screwing things up :)
<reinhard> i have no idea
<reinhard> i will try to reproduce
<jamest> reinhard: if you have the time that's fine
<jamest> if not I'll look tonight
<johannesV> reinhard: just did it (using sample.gfd without appserver, but directly with db)
<johannesV> it work's well 
<jamest> johannesV: postgresql?
<johannesV> jamest: yes
<johannesV> using psycopg
<jamest> sigh
<jamest> i just looked in my connections.conf
<reinhard> i have also tested
<jamest> i have all connections except this one set to psycopg
<jamest> this one is set to postgresql
<reinhard> we have date, time, and datetime (timestamp) fields there
<reinhard> jamest: doh
<reinhard> jamest: so i think you found a bug in one of the drivers
<jamest> yes
<johannesV> works with postgresql too
<jamest> as psycopg does work
<jamest> postgresql IIRC walks thru all the drivers
<reinhard> johannesV: if you use postgresql, the plugin loader selects a random driver
<johannesV> ah, i see ...
<jamest> so it's all about what it hits first
<reinhard> can be that it selects another driver for you than for jamest
<johannesV> ok, so this might be not a valid result :(
<reinhard> yes exactly
<jamest> i'll try and figure out wazzup tonight
<johannesV> ok
<reinhard> johannesV: but if you have time, you could try all 4 drivers
<reinhard> and see if any of them fails
<jamest> as switching to psycopg fixed it for me
<jamest> and I need to go hose myself off and get ready for another fun filled day at work
<jamest> thanks
*** jamest has quit IRC
<johannesV> reinhard: ok, i would do some tests later
<reinhard> ok
*** dsmith has joined #gnuenterprise
*** jamest has joined #gnuenterprise
*** johannesV_ has joined #gnuenterprise
*** dneighbo_ has joined #gnuenterprise
*** johannesV has quit IRC
*** dneighbo has quit IRC
*** reinhard_ has joined #gnuenterprise
<johannesV_> back
*** reinhard has quit IRC
*** dcmwai has joined #gnuenterprise
<jamest> sigh
<jamest> we're talking scanning files into computer to reduce amount of paper stored 
<jamest> i suggest pdf as the storage format
<jamest> "but what if pdf goes away?"
<reinhard> jamest: that's a correct question
<reinhard> you should choose dvi
<reinhard> it has proven stable for a much longer period
<reinhard> j/k
<chillywilly> latex ;)?
<chillywilly> sorry
<chillywilly> LaTeX
<chillywilly> johannesV_: forth
<jamest> well
<jamest> i decided to switch to doc
<jamest> as it's what the State of KS uses 
<johannesV_> :)
<jamest> and everyone has the latest MS Office installed right?
<jamest> heck , i bet a few people even paid for it!
<chillywilly> WOW
<reinhard> jamest: i guess you are kidding now, right?
<reinhard> who will convert all those documents to office 2005 format when that is out
<reinhard> and to office 2006 a year later?
<reinhard> and then to office 2007??
<jamest> yeah, i kidding about it in math
<reinhard> *phew*
<jamest> but the state of ks purchasing department puts all our contracts online 
<jamest> in word
<chillywilly> evil ;)
<jamest> well
<jamest> i love that department
<chillywilly> no you don't
<jamest> you know me well chilly
<chillywilly> :)
* chillywilly gives jamest some luvin' .....uuunnnnfff
*** jcater has joined #gnuenterprise
*** jbailey has joined #gnuenterprise
<reinhard> jbailey: hello
<jbailey> Heya reinhard
<reinhard> jbailey: ajmitch told me he needs your help for uploading the new gnue packages
<jbailey> Yes.
<jbailey> I'm having trouble finding time.
<reinhard> oh
<reinhard> you're busy removing all that non-free documentation?
<reinhard> ;-P
<reinhard> j/k
<jbailey> Oy.
<jamest> you can't upload gnue!
<jamest> as aren't our docs FDL?
<reinhard> we have no invariant sections
<reinhard> IIRC
<jamest> so then that's ok to upload?
<reinhard> my understanding is yes
<reinhard> fwiw
<reinhard> i really believe that the intention to remove non-free stuff from debian is excellent
<reinhard> *after* the release of sarge
<jcater> no kidding
<jcater> I'm reasonably sure if sarge is delayed until 2005
<jcater> I'll be looking at alternatives :(
<jcater> which sucks, as I like debian, the community, etc
<jcater> but I've had to move production servers to sid
<jcater> which I said I'd never do
<jcater> but keeping woody updated w/backports wasn't any better
<nickr> I don't think its okay because derivatives could have invariant sections, iirc.
<reinhard> nickr: that's not an argument
<reinhard> then the BSD license wouldn't be ok either
<reinhard> because derivates can be completely non-free
<nickr> Perhaps so.
<nickr> That was the impression I got, though.
<nickr> oh and the DRM thing.
<reinhard> how can i get the date of a file in a shell script?
<nickr> ls -la file | awk '{print $6}'
<nickr> but that is not portable.
<dsmith> Testing works very well.
<reinhard> nickr: unfortunately that's not even portable across different locales
<reinhard> bbl
<dsmith> Sarge doesn't need to be released to use it.
<jcater> dsmith: that was the opposite of my experience :(
<nickr> testing doesn't have security infrastructure.
<jcater> I upgraded to testing, which brought my servers to their knees
<dsmith> That's true
<jcater> so I had to grab from sid to get working again
<jcater> this was a couple of months ago, though
<jcater> could be better now
<dsmith> I'm running my desk and our svn server on testing.
<jcater> of course, they can do what they like
<jcater> they don't owe me anything =)
<dsmith> I'm careful when I upgrade.
<dsmith> But no problems at all, so far.
<dsmith> Installing was a real trick, because the scsi controller didn't have a module, but there was a way to get to it.
<nickr> some locales have spaces in that date stamp?
<nickr> rm-away: use stat -c "%X" (for atime) (or %Y for mtime or %Z for ctime) in seconds
<nickr> then you can store than and convert freely into localtime using date
<jamest> testing burned me as well
<jamest> i find unstable works better
<jamest> which sometimes doesn't say much :)
<nickr> Testing is generally in a more messed up state as things try to get pulled into alignment
<nickr> until a freeze, then things mostly always work
<jamest> as I'm debating dumping debian if the release is retargeted at 05
<jamest> s/as/and
*** wayneg has joined #gnuenterprise
<derek> i agree that testing is fairly useless unless you are doing prep work to make testing stable :)
<derek> jamest/jcater im curious as to what you are considering moving too
* derek will probably be forced to choosing SuSE here at work
<derek> as some prop software (like backup software etc) only runs on Red Hat or SuSE
<derek> and Red Hat is almost more expensive than Windows now
<jcater> I'm definitely moving to SuSE for my oracle install
<derek> however at LDC they have switched to Gentoo and love it
<jcater> but don't plan to use it beyond that
<jcater> I don't like redhat
<derek> coming from Debian they said the switch was great (also they are huge python fans)
<jcater> as you say, too damn expensive
<jcater> I'm leaning towards either gentoo or freebsd
* jcater came from freebsd to debian
<jcater> and do miss the ports
<derek> my problem is that Gentoo isnt supported enough in the "enterprise" world
<jcater> yeah, that's my concern too
<jcater> gentoo scares me
<derek> i.e. i cant get commvault software for it, or oracle support for it etc
<jcater> though I've heard lots of ppl rave
<derek> so im in a bind at work
<derek> at home i am happy running unstable
<derek> its stable enough for me and up to date enough
<derek> though i might try gentoo out just to see how it goes
<jcater> the first time I tried gentoo I hated it
<jcater> but have since been told I went about it wrong
<derek> well i use it on server at LDC
<derek> and it is just :different: so i avoid doing a lot of things
<jcater> I pulled the plug after 3 days of it compiling the base system
<derek> but i suspect if i learned emerge i would be happy
<dsmith> jcater: Ahhh. Freebsd
<dsmith> jcater: I really like the *bsds. But I find Debian so much easier to manage.
<nickr> debian will absorb all.
<jcater> well, one thing I hate to lose
<jcater> is my cfengine setup
<jcater> which I can fine-tune for another distro
<dsmith> jcater: You like cfengine?  I looked at it years ago and it didn't impress me.
<jcater> I love it
<jcater> makes maintenance so easy
<jcater> I install base debian
<jcater> then apt-get install cfengine2
<jcater> scp a couple of files
<jcater> then that machine is fully set up for my needs
<dsmith> Cool.
<jcater> mail server, shared nfs drives, all gateways, etc
<jamest> cfengine is the bomb
*** lekma has joined #gnuenterprise
<chillywilly> anyone ever use mod_bandwidth in apache?
<chillywilly> under debian
<jamest> not me
*** lekma has quit IRC
<derek> unicode is hell
<derek> im tempted to try/except anything unicode and if it fails rather than encoding it sub the string for "you evil bastard"
<derek> http://www.gnuenterprise.org/~dneighbo/hold/labels.html is a list of supported labels for gnue-reports
<derek> there is a program out in utils that will read a label definition file to create a docbook file to be converted to format of choice
<derek> currently there has been no "sorting" of any kind added 
<derek> technically i would like elements in different order (say starting with vendor)
<derek> and contents sorted by column
<derek> just dont have time right now to play with it
<derek> and yes we really support over 1500 labels.. cause jcater kicks ass
*** dcmwai has quit IRC
*** Konijn has joined #gnuenterprise
*** johannesV_ has quit IRC
<reinhard> just for the logs
<reinhard> all: *please don't change from debian to SuSE!*
<reinhard> I changed from SuSE to debian (you remember?)
<Konijn> hereby I must support reinhard
<reinhard> and I *know* what I*
<Konijn> no SuSe for crying out loud
<reinhard> I'm talking about
<Konijn> I took tooo much time to configure my Knoppix partition, and have come to love it
<reinhard> ah yes
<reinhard> i think you all should move to knoppix
<jcater> jamest got burned a few times on knoppix installs
<jcater> come update time
<jcater> iirc
<jcater> reinhard: I'm moving to SuSE for my oracle install from Solaris
<reinhard> he never did an update w/ SuSE :)
<jcater> my two options are basically RedHat Enterprise or SuSE Enterprise
<jcater> RedHat Enterprise made me puke
<jamest> i run two knoppix boxes
<jamest> updated one to latest sid yday
<jamest> it's been fine so far
<jamest> but it seems to ignore things like dpkg-reconfigure xserver-xfree86
<jamest> never took the time to figure out why
<jamest> just read the logs
<jamest> reinhard: no suse at work
<jamest> it's a pita enough at home on the multiboot
<Konijn> idem
<jamest> ?
<Konijn> If I'm  not quick enough I always boot up in the wrong mode
<Konijn> I dont want 3 os's on my laptop at home !
<Konijn> g 'night
*** Konijn has quit IRC
<chillywilly> why are you guys looking to get away from debian? release cycles take too long?
<chillywilly> nevermind
<chillywilly> read back scroll
<chillywilly> this is not very cool
<chillywilly> hmmm, there's always Progeny Debian 2.0? ;)
<chillywilly> http://platform.progeny.com/componentized/
<dsmith> kde 3.2.2 just came down in my apt-get upgrade today.
<dsmith> Seems a bit more unstable than it was.
*** dsmith has quit IRC
*** dsmith has joined #gnuenterprise
*** [newbie] has joined #gnuenterprise
*** jamest has quit IRC
<derek> chillywilly i have less problems with release dates and more issues with support
<derek> ISV support that is
<derek> there is plenty of software we have that runs on GNU/Linux that is appealing to integrate into our existing infrastructure but it is not supported on Debian
<derek> CommVault backup software is one
<derek> Ximian Exchange Connector is another
<derek> and i am having no luck getting HP to honor support for servers running debian :(
<derek> currently SuSE and RH are only two that fit all the bills
<derek> i like red hat okay but its very pricey
<derek> SuSE i am not very interested in but its slowly becoming the only option :(
*** jcater has quit IRC
*** burtj has joined #gnuenterprise
<burtj> anybody alive?
*** burtj has quit IRC
* derek checks his pulse
<derek> yip still alive
*** reinhard_ has joined #gnuenterprise
*** reinhard has quit IRC
*** ogger has quit IRC
<reinhard_> night all
*** reinhard_ has quit IRC
<derek> night
*** jbailey has quit IRC
*** dsmith has joined #gnuenterprise
*** jcater has joined #gnuenterprise
*** SachaS has joined #gnuenterprise
<SachaS> hi everyone
<SachaS> greetings from New Orleans
<SachaS> this city is great for party!
<ajmitch> hi SachaS
<SachaS> hi ajmitch
* jcater dccs SachaS some beads
*** jamest has joined #gnuenterprise
* ajmitch mutters 
<SachaS> thanks jcater but I dont know what beads are :)
<jcater> :)
<jcater> quite useful in New Orleans
<jcater> esp. during Mardi Gras
<SachaS> beads hmmmm
<jcater> (or maybe only during Mardi Gras)
<SachaS> i heard thats big party time
<jamest> jcater is a perv
<jamest> wow, so he does have 1 redeming quality!
<jcater> SachaS: basically during Mardi Gras, women will show you their breasts in exchange for beads
<jcater> of course, not *all* women participate, but a huge chunk do
<jcater> all of them in my office who go down there participate :)
<jamest> jcater would know
<jamest> he drives them down there
<jamest> a car full of women
<SachaS> beads ==? perls
<SachaS> pearls?
<jamest> a trunk full of beads
<jcater> SachaS: well, plastic pearls
<SachaS> yeah
<jcater> or other colorful stone-like things
<SachaS> some are wearing them now .... but do not show anything ;)
<jamest> jcater: wouldn't it be quicker to just have them walk around the office topless for a day in exchange for maybe a timex or something?
<jcater> well, find you some beads and walk up to one
<jcater> and offer them to her
<jcater> you might get slapped since it's not mardi gras
<SachaS> jcater OK haha
<jcater> but, hey, you might get lucky too :)
<SachaS> no risk, no fun
<jcater> if they're carrying a cup w/"Budweiser" or "Heineken" written across it
<jcater> your odds go up a lot
<jamest> lol
<jamest> especially if it's almost empty!
<SachaS> ok will watch out for the hats
<SachaS> cups not hats
<SachaS> dah
<jcater> it's a shame I have to work
<jcater> or I'd join you in New Orleans :)
<jamest> you'd load up the wife and kid and make a vacation of it right?
* jcater is only a 5-6 hour drive away
<jcater> jamest: no
<jcater> wife might enjoy it too much
<jamest> lol
<jamest> we had a receptionist that when down w/ her husband
<SachaS> jcater, well we should meet in New Orleans for Mardi Grass then
<SachaS> have a gnue beads mardi grass come together
<jamest> or soon to be husband
<jamest> she didn't have a clue
<jamest> i guess she wound up in tears 
<jcater> wow
<jamest> seeing all the evil
<SachaS> haha
<jamest> or something
<jcater> if you don't plan to get drunk out of your mind
<jcater> stay away
<jcater> it's a friggin mad place
<jamest> so she ended up back at hotel while he stayed out
<SachaS> haha
<SachaS> we had good fun the first evening
<jcater> you eaten at commander's palace yet?
<SachaS> hmmm i think not
<SachaS> is that specially good? is that in the french quater?
*** dsmith has quit IRC
<jcater> http://www.commanderspalace.com/new_orleans/index.php
<jcater> supposed to be the best
<jcater> not sure of the pricing, though
<jcater> probably have to have reservations well in advance
<jcater> but I bet there's plenty of good eating down there
<SachaS> first night
<SachaS> everything was great
<SachaS> we went for seafood
<SachaS> awesome!
<SachaS> and wine :)
<SachaS> then life music
<jcater> cool
<jcater> SachaS: if you're in New Orleans
<jcater> dare I ask why you're in IRC?
<jcater> go out and have some fun!
<SachaS> yeah i have to catch up with email
<SachaS> but we will go for dinner in about 30 minutes
<SachaS> ;)
<SachaS> ok. i am off
<SachaS> see yas
*** SachaS has quit IRC
*** sjc has left #gnuenterprise
*** dimas has quit IRC
*** holycow has joined #gnuenterprise
*** holy_cow has joined #gnuenterprise
*** jcater has quit IRC
*** jamest has quit IRC