Wednesday, 2010-02-24

grantcmorning all00:12
grantcinteresting query of the day - "select dba()" ...00:12
*** Alex| has quit IRC00:21
pboroerr...00:27
pborograntc, it would be really nice if there was a nightly build system for Ingres00:28
grantcbased on code.ingres.com?00:28
pboroyeah00:29
pborobased on trunk00:29
pboroI'm currently "beta" testing 10.0 and I hate to a) set up a own build system b) build it, which takes a lot of time :) I would really just want to concentrate on testing and reporting bugs00:29
pborowe'll, I guess it would be a good community effort to start providing nightly builds by community (i.e. by me or some other individual)00:30
grantcWe do nightlies internally to see if anything got broke00:31
grantcalthough i'm not sure if they are put anywhere.00:31
pborooh, okay00:32
pboroI thought that there has to be nightly build but it's just not "released" outside :)00:32
*** Alex| has joined #ingres00:38
*** ChanServ sets mode: +o Alex|00:38
*** PaulM05 has joined #ingres01:03
*** KermitTheFragger has joined #ingres01:05
*** Mud has joined #ingres02:30
*** cthibert has joined #ingres03:43
*** atrofast has joined #ingres03:43
*** Mud has quit IRC03:47
*** Mud has joined #ingres03:53
*** gerhard has joined #ingres04:31
*** rossand has joined #ingres04:32
*** ChanServ sets mode: +o rossand04:32
gerhardHi all04:41
rossandHi gerhard, everyone04:41
gerhardhow can I get rid off the security_audit_key stuff for an existing table?04:42
PaulM05DROP SECURITY_ALARM ON mytable ALL04:46
PaulM05or you can specifiy a number instead of ALL - do a HELP SECURITY_ALARM ON mytable to see what they are04:47
*** Alex| has quit IRC04:48
*** PaulM05 is now known as PaulM05_lunch04:56
*** zxiiro has quit IRC05:01
gerharddrop security_alarm on mytable all    -> ran through without errors05:07
gerhardhelp security_alarm on mytable    --> no sec. alarms05:08
gerhardBUT: copydb dbname --> copy.in still contains security_audit_key line for mytable....05:08
*** zxiiro has joined #ingres05:51
*** ChanServ sets mode: +v zxiiro05:51
*** PaulM05_lunch is now known as PaulM0506:00
PaulM05back from lunch!06:02
PaulM05looks like you hit bug 122778 gerhard06:02
PaulM05only just been fixed06:02
gerhardI have Win32 / Ingres 9.2.0 / P1362006:06
PaulM05yeah the fix isn't out in any patch yet06:07
gerhardso only chance unloading / fixing copy.in / reloading   ....? Or any way to do it just with SQL?06:08
PaulM05the bug is that copydb is putting the security_alarm_key line in when it shouldn't be there06:08
PaulM05if HELP tells you there are no sec. alarms then I don't think there's anything to fix06:09
gerhardany copydb switch to tell copydb to ignore it....?06:09
PaulM05just edit the copy.in manually if you need to use it06:09
gerhardOK06:09
pboroanyone compiled Ingres on Debian Lenny 64-bit?06:18
DrEeevilpboro: 64bit sounds optimistic06:20
pboroit's compiling currently, just wondering if there's any pit falls06:20
DrEeevillast time I tried it didn't work ...not sure if that got properly fixed06:21
pboroyeah06:21
DrEeevilwhat version are you trying?06:21
pborolatest from svn, I'm working on a nightly build system for the main svn tree06:21
DrEeeviloh :)06:21
pboroif it turns out to be too difficult I prolly ditch it, but we'll see...06:22
gerhardPaul: any knowledge base document about Bug 122778?06:22
PaulM05no - they usually write the KB doc once the issue is closed - which it isn't - when I said this was recent I'm talking yesterday06:30
PaulM05pboro: I used to compile on 64-bit Ubuntu a while back - worked fine once you've got the 3rd party stuff installed (Xerces, Kerberos)06:32
PaulM05are you building int.lnx or a64.lnx?06:32
pboroI just installed the required libs and gcc-multilib and it seems to be building just fine06:32
pboroa64.lnx06:32
PaulM05like I say should be ok - watch out for lp32 stuff06:34
pboroyeah06:34
pborobuilding 9.1 was really painful :)06:34
PaulM05are you going to post these somewhere or is this for your own use?06:38
pborothe builds will prolly go on my web server and will be freely downloadable06:38
pboroI just have to find some time to write couple sh scripts to make it happen :)06:39
PaulM05that's cool - are you going to run the tests and post the results too?06:39
*** mull has joined #ingres06:39
pboronot sure about the tests... my first goal is to be able to easily test daily builds with our needs06:39
pboroif the tests are not hard to set up, maybe06:39
PaulM05not if you use the supplied scripts06:40
PaulM05interpretting the results can be another matter...06:40
pborodoes running the tests require root privileges?06:40
pborohehe06:40
PaulM05I think the script requires it at the moment - whether it's strictly needed I'm not sure06:41
DrEeevilthat sounds like you're not actually building 64bit :)06:41
pboroPaulM05, ok, I don't have spare virtual server to use right now so avoiding root privilege is a must atm...06:42
PaulM05ah06:42
pboroDrEeevil, oh, should there currently be some breakage in main for a64?06:42
DrEeevilpboro: no, but when I hear "multilib" I'm wondering if that is a clean 64bit build06:43
pboroDrEeevil, I'm doing hybrid06:43
DrEeevilah yes, the scary one ;)06:44
pboroI don't think it's possible to do clean 64-bit?06:44
pboroor has it already been fixed06:44
PaulM05pboro: I posted this script back when I was using svn a lot more : http://bugs.ingres.com/ticket/461 - it might be helpful/basis for something else06:44
DrEeevilI doubt it, but it'd be really nice06:44
PaulM05there's no non-hybrid linux 64bit atm afaik06:44
pboroDrEeevil, yeah it would make developing and testing on 64-bit platform much easier06:44
DrEeevilindeed06:44
pboroPaulM05, that's my knowledge too06:44
PaulM05you can always just build int.lnx06:45
pboroahh... first problem, jam is still running but nothing happens...06:46
*** cthibert has left #ingres07:07
*** cthibert has joined #ingres07:10
pborofinally, damn07:10
*** gerhard has quit IRC07:22
*** Alex| has joined #ingres07:28
*** ChanServ sets mode: +o Alex|07:28
pboroDoes Ingres still depend on Xerces 2.7? Or is it possible to use newer version?07:28
PaulM05it's possible07:28
PaulM05not sure if 3.0 is a possibility though07:29
pborooh okay, we then I'll forget 2.7 and try compiling with 2.8, which is available in Lenny07:29
*** Mud has quit IRC07:48
pboroseems to work07:49
pboroat least it compiled :)07:49
PaulM05cool07:50
DarylMX3.0 should work now with the community svn source07:50
DarylMIn fact it is required for the Mac 64 bit port07:50
*** Mud has joined #ingres07:53
*** Mud has quit IRC07:57
*** Mud has joined #ingres08:30
*** DerMeister has joined #ingres08:37
*** Mud has quit IRC09:14
*** Mud has joined #ingres09:20
*** KermitTheFragger has quit IRC09:44
*** PaulM05 has quit IRC09:46
pboroerr09:59
pboroanyone know how I'm supposed to tar package the build after running runbuild.sh?10:00
pboroahh, I prolly figured it...10:00
pboronnnice :) now some scripting and I'm able to publish nightly builds of svn version10:08
*** grantc has quit IRC10:31
*** cthibert has quit IRC10:46
*** cthibert has joined #ingres10:46
*** cytrinox has quit IRC10:47
*** cytrinox has joined #ingres10:48
*** KermitTheFragger has joined #ingres10:59
*** Mud has quit IRC11:48
*** Mud has joined #ingres11:54
*** DarylM has quit IRC12:05
pborodamn I wish it was possible to exclude something when doing svn checkout12:27
pborotest datas take a lot of space and are unnecessary for nighlty builds12:27
FrankWpboro++12:29
pborohi FrankW12:29
FrankWI wanted to show my support for your statement.  In several different projects I've run into the same problem and it drives me nuts over a moderately bandwidth constrained link.12:30
FrankWI try to place testsuites parallel to the source tree rather than within it. (in GDAL and MapServer for instance).12:31
pboroyup12:31
rossandFrankW, pboro That is a good idea, and a few folks have suggested it before. I am supportive of doing so.12:41
rossandOur thinking was to have a structure so that a less experienced user could check out a URL and get everything they need.12:41
*** DarylM has joined #ingres12:42
rossandA couple of years later, a bit more pragmatism has set in. The type of user who has trouble with a second checkout to get the test is likely going to have other problems along the way.12:42
rossandI'll think of an appropriate way to propose this formally so it doesn't come as a shock to the world.12:43
pborothanks :)12:43
rossandIt would be reasonable to push the tests up a level so that we have ingres, and ingres_tests12:43
rossandAnd the user can symlink the tst directory to where ever they checked out the test from.12:44
rossandThis is pretty much what we do internally.12:44
rossand A nice side-effect of this is that you can share tests across build areas.12:44
pbororossand, you can still bring tests with the main tree using svn:externals12:45
pboroit's possible to exclude externals when doing export / checkout12:45
rossandpboro: that's a great idea.12:45
pboroaltho' I don't think using svn:externals is really needed but you could keep the tree as is12:46
rossandI haven't done work with externals before. Assuming the tests are still in the same repository, can you commit changes to both tests and code on the same commit?12:46
pborohttp://svnbook.red-bean.com/en/1.0/ch07s03.html :)12:46
FrankWIn my limited experience externals are a bit of a hassle.12:47
pboroumm well they are separate, but checking out the main will also check the other repo inside the main12:47
pboroit's like a link inside a repo12:47
pborocheck the web page and svn output, you'll figure it :)12:47
rossandYep, I'll do so. Thanks for the suggestion.12:48
*** cthibert has left #ingres12:55
*** atrofast has quit IRC13:06
*** zxiiro has quit IRC13:15
*** atrofast has joined #ingres13:20
*** Alex| has quit IRC13:21
*** DerMeister has quit IRC13:21
*** Mud has quit IRC13:44
*** zxiiro has joined #ingres14:29
*** ChanServ sets mode: +v zxiiro14:29
*** hanje04 has joined #ingres14:46
*** hanje04 has left #ingres14:46
*** ukjay has joined #ingres14:47
*** DarylM has quit IRC14:51
*** DarylM has joined #ingres14:53
*** KermitTheFragger has quit IRC15:19
*** mull has quit IRC15:27
*** mull has joined #ingres16:20
*** rossand has quit IRC17:39
*** zxiiro has quit IRC17:51
*** zxiiro has joined #ingres17:51
*** ChanServ sets mode: +v zxiiro17:51
*** atrofast has quit IRC17:58
*** nafox has joined #ingres18:49
nafoxhi18:50
nafoxthere is no ingres vectorwise release yet, or? would like to use it for my bachelor thesis19:06
*** zxiiro has quit IRC19:16
*** cytrinox has quit IRC19:24
*** cytrinox has joined #ingres19:25
*** rossand has joined #ingres19:33
*** ChanServ sets mode: +o rossand19:33
*** mull has quit IRC20:04
*** rossand has quit IRC21:20
*** nafox has quit IRC21:48
*** Alex| has joined #ingres22:23
*** ChanServ sets mode: +o Alex|22:23
*** Alex| has quit IRC23:28
*** Mud has joined #ingres23:30
*** gerhard has joined #ingres23:31
*** Alex| has joined #ingres23:45
*** ChanServ sets mode: +o Alex|23:45
*** Mud has quit IRC23:49
*** Mud has joined #ingres23:54

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!