grantc | morning all | 00:12 |
---|---|---|
grantc | interesting query of the day - "select dba()" ... | 00:12 |
*** Alex| has quit IRC | 00:21 | |
pboro | err... | 00:27 |
pboro | grantc, it would be really nice if there was a nightly build system for Ingres | 00:28 |
grantc | based on code.ingres.com? | 00:28 |
pboro | yeah | 00:29 |
pboro | based on trunk | 00:29 |
pboro | I'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 bugs | 00:29 |
pboro | we'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 |
grantc | We do nightlies internally to see if anything got broke | 00:31 |
grantc | although i'm not sure if they are put anywhere. | 00:31 |
pboro | oh, okay | 00:32 |
pboro | I thought that there has to be nightly build but it's just not "released" outside :) | 00:32 |
*** Alex| has joined #ingres | 00:38 | |
*** ChanServ sets mode: +o Alex| | 00:38 | |
*** PaulM05 has joined #ingres | 01:03 | |
*** KermitTheFragger has joined #ingres | 01:05 | |
*** Mud has joined #ingres | 02:30 | |
*** cthibert has joined #ingres | 03:43 | |
*** atrofast has joined #ingres | 03:43 | |
*** Mud has quit IRC | 03:47 | |
*** Mud has joined #ingres | 03:53 | |
*** gerhard has joined #ingres | 04:31 | |
*** rossand has joined #ingres | 04:32 | |
*** ChanServ sets mode: +o rossand | 04:32 | |
gerhard | Hi all | 04:41 |
rossand | Hi gerhard, everyone | 04:41 |
gerhard | how can I get rid off the security_audit_key stuff for an existing table? | 04:42 |
PaulM05 | DROP SECURITY_ALARM ON mytable ALL | 04:46 |
PaulM05 | or you can specifiy a number instead of ALL - do a HELP SECURITY_ALARM ON mytable to see what they are | 04:47 |
*** Alex| has quit IRC | 04:48 | |
*** PaulM05 is now known as PaulM05_lunch | 04:56 | |
*** zxiiro has quit IRC | 05:01 | |
gerhard | drop security_alarm on mytable all -> ran through without errors | 05:07 |
gerhard | help security_alarm on mytable --> no sec. alarms | 05:08 |
gerhard | BUT: copydb dbname --> copy.in still contains security_audit_key line for mytable.... | 05:08 |
*** zxiiro has joined #ingres | 05:51 | |
*** ChanServ sets mode: +v zxiiro | 05:51 | |
*** PaulM05_lunch is now known as PaulM05 | 06:00 | |
PaulM05 | back from lunch! | 06:02 |
PaulM05 | looks like you hit bug 122778 gerhard | 06:02 |
PaulM05 | only just been fixed | 06:02 |
gerhard | I have Win32 / Ingres 9.2.0 / P13620 | 06:06 |
PaulM05 | yeah the fix isn't out in any patch yet | 06:07 |
gerhard | so only chance unloading / fixing copy.in / reloading ....? Or any way to do it just with SQL? | 06:08 |
PaulM05 | the bug is that copydb is putting the security_alarm_key line in when it shouldn't be there | 06:08 |
PaulM05 | if HELP tells you there are no sec. alarms then I don't think there's anything to fix | 06:09 |
gerhard | any copydb switch to tell copydb to ignore it....? | 06:09 |
PaulM05 | just edit the copy.in manually if you need to use it | 06:09 |
gerhard | OK | 06:09 |
pboro | anyone compiled Ingres on Debian Lenny 64-bit? | 06:18 |
DrEeevil | pboro: 64bit sounds optimistic | 06:20 |
pboro | it's compiling currently, just wondering if there's any pit falls | 06:20 |
DrEeevil | last time I tried it didn't work ...not sure if that got properly fixed | 06:21 |
pboro | yeah | 06:21 |
DrEeevil | what version are you trying? | 06:21 |
pboro | latest from svn, I'm working on a nightly build system for the main svn tree | 06:21 |
DrEeevil | oh :) | 06:21 |
pboro | if it turns out to be too difficult I prolly ditch it, but we'll see... | 06:22 |
gerhard | Paul: any knowledge base document about Bug 122778? | 06:22 |
PaulM05 | no - they usually write the KB doc once the issue is closed - which it isn't - when I said this was recent I'm talking yesterday | 06:30 |
PaulM05 | pboro: 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 |
PaulM05 | are you building int.lnx or a64.lnx? | 06:32 |
pboro | I just installed the required libs and gcc-multilib and it seems to be building just fine | 06:32 |
pboro | a64.lnx | 06:32 |
PaulM05 | like I say should be ok - watch out for lp32 stuff | 06:34 |
pboro | yeah | 06:34 |
pboro | building 9.1 was really painful :) | 06:34 |
PaulM05 | are you going to post these somewhere or is this for your own use? | 06:38 |
pboro | the builds will prolly go on my web server and will be freely downloadable | 06:38 |
pboro | I just have to find some time to write couple sh scripts to make it happen :) | 06:39 |
PaulM05 | that's cool - are you going to run the tests and post the results too? | 06:39 |
*** mull has joined #ingres | 06:39 | |
pboro | not sure about the tests... my first goal is to be able to easily test daily builds with our needs | 06:39 |
pboro | if the tests are not hard to set up, maybe | 06:39 |
PaulM05 | not if you use the supplied scripts | 06:40 |
PaulM05 | interpretting the results can be another matter... | 06:40 |
pboro | does running the tests require root privileges? | 06:40 |
pboro | hehe | 06:40 |
PaulM05 | I think the script requires it at the moment - whether it's strictly needed I'm not sure | 06:41 |
DrEeevil | that sounds like you're not actually building 64bit :) | 06:41 |
pboro | PaulM05, ok, I don't have spare virtual server to use right now so avoiding root privilege is a must atm... | 06:42 |
PaulM05 | ah | 06:42 |
pboro | DrEeevil, oh, should there currently be some breakage in main for a64? | 06:42 |
DrEeevil | pboro: no, but when I hear "multilib" I'm wondering if that is a clean 64bit build | 06:43 |
pboro | DrEeevil, I'm doing hybrid | 06:43 |
DrEeevil | ah yes, the scary one ;) | 06:44 |
pboro | I don't think it's possible to do clean 64-bit? | 06:44 |
pboro | or has it already been fixed | 06:44 |
PaulM05 | pboro: 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 else | 06:44 |
DrEeevil | I doubt it, but it'd be really nice | 06:44 |
PaulM05 | there's no non-hybrid linux 64bit atm afaik | 06:44 |
pboro | DrEeevil, yeah it would make developing and testing on 64-bit platform much easier | 06:44 |
DrEeevil | indeed | 06:44 |
pboro | PaulM05, that's my knowledge too | 06:44 |
PaulM05 | you can always just build int.lnx | 06:45 |
pboro | ahh... first problem, jam is still running but nothing happens... | 06:46 |
*** cthibert has left #ingres | 07:07 | |
*** cthibert has joined #ingres | 07:10 | |
pboro | finally, damn | 07:10 |
*** gerhard has quit IRC | 07:22 | |
*** Alex| has joined #ingres | 07:28 | |
*** ChanServ sets mode: +o Alex| | 07:28 | |
pboro | Does Ingres still depend on Xerces 2.7? Or is it possible to use newer version? | 07:28 |
PaulM05 | it's possible | 07:28 |
PaulM05 | not sure if 3.0 is a possibility though | 07:29 |
pboro | oh okay, we then I'll forget 2.7 and try compiling with 2.8, which is available in Lenny | 07:29 |
*** Mud has quit IRC | 07:48 | |
pboro | seems to work | 07:49 |
pboro | at least it compiled :) | 07:49 |
PaulM05 | cool | 07:50 |
DarylM | X3.0 should work now with the community svn source | 07:50 |
DarylM | In fact it is required for the Mac 64 bit port | 07:50 |
*** Mud has joined #ingres | 07:53 | |
*** Mud has quit IRC | 07:57 | |
*** Mud has joined #ingres | 08:30 | |
*** DerMeister has joined #ingres | 08:37 | |
*** Mud has quit IRC | 09:14 | |
*** Mud has joined #ingres | 09:20 | |
*** KermitTheFragger has quit IRC | 09:44 | |
*** PaulM05 has quit IRC | 09:46 | |
pboro | err | 09:59 |
pboro | anyone know how I'm supposed to tar package the build after running runbuild.sh? | 10:00 |
pboro | ahh, I prolly figured it... | 10:00 |
pboro | nnnice :) now some scripting and I'm able to publish nightly builds of svn version | 10:08 |
*** grantc has quit IRC | 10:31 | |
*** cthibert has quit IRC | 10:46 | |
*** cthibert has joined #ingres | 10:46 | |
*** cytrinox has quit IRC | 10:47 | |
*** cytrinox has joined #ingres | 10:48 | |
*** KermitTheFragger has joined #ingres | 10:59 | |
*** Mud has quit IRC | 11:48 | |
*** Mud has joined #ingres | 11:54 | |
*** DarylM has quit IRC | 12:05 | |
pboro | damn I wish it was possible to exclude something when doing svn checkout | 12:27 |
pboro | test datas take a lot of space and are unnecessary for nighlty builds | 12:27 |
FrankW | pboro++ | 12:29 |
pboro | hi FrankW | 12:29 |
FrankW | I 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 |
FrankW | I try to place testsuites parallel to the source tree rather than within it. (in GDAL and MapServer for instance). | 12:31 |
pboro | yup | 12:31 |
rossand | FrankW, pboro That is a good idea, and a few folks have suggested it before. I am supportive of doing so. | 12:41 |
rossand | Our 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 #ingres | 12:42 | |
rossand | A 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 |
rossand | I'll think of an appropriate way to propose this formally so it doesn't come as a shock to the world. | 12:43 |
pboro | thanks :) | 12:43 |
rossand | It would be reasonable to push the tests up a level so that we have ingres, and ingres_tests | 12:43 |
rossand | And the user can symlink the tst directory to where ever they checked out the test from. | 12:44 |
rossand | This 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 |
pboro | rossand, you can still bring tests with the main tree using svn:externals | 12:45 |
pboro | it's possible to exclude externals when doing export / checkout | 12:45 |
rossand | pboro: that's a great idea. | 12:45 |
pboro | altho' I don't think using svn:externals is really needed but you could keep the tree as is | 12:46 |
rossand | I 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 |
pboro | http://svnbook.red-bean.com/en/1.0/ch07s03.html :) | 12:46 |
FrankW | In my limited experience externals are a bit of a hassle. | 12:47 |
pboro | umm well they are separate, but checking out the main will also check the other repo inside the main | 12:47 |
pboro | it's like a link inside a repo | 12:47 |
pboro | check the web page and svn output, you'll figure it :) | 12:47 |
rossand | Yep, I'll do so. Thanks for the suggestion. | 12:48 |
*** cthibert has left #ingres | 12:55 | |
*** atrofast has quit IRC | 13:06 | |
*** zxiiro has quit IRC | 13:15 | |
*** atrofast has joined #ingres | 13:20 | |
*** Alex| has quit IRC | 13:21 | |
*** DerMeister has quit IRC | 13:21 | |
*** Mud has quit IRC | 13:44 | |
*** zxiiro has joined #ingres | 14:29 | |
*** ChanServ sets mode: +v zxiiro | 14:29 | |
*** hanje04 has joined #ingres | 14:46 | |
*** hanje04 has left #ingres | 14:46 | |
*** ukjay has joined #ingres | 14:47 | |
*** DarylM has quit IRC | 14:51 | |
*** DarylM has joined #ingres | 14:53 | |
*** KermitTheFragger has quit IRC | 15:19 | |
*** mull has quit IRC | 15:27 | |
*** mull has joined #ingres | 16:20 | |
*** rossand has quit IRC | 17:39 | |
*** zxiiro has quit IRC | 17:51 | |
*** zxiiro has joined #ingres | 17:51 | |
*** ChanServ sets mode: +v zxiiro | 17:51 | |
*** atrofast has quit IRC | 17:58 | |
*** nafox has joined #ingres | 18:49 | |
nafox | hi | 18:50 |
nafox | there is no ingres vectorwise release yet, or? would like to use it for my bachelor thesis | 19:06 |
*** zxiiro has quit IRC | 19:16 | |
*** cytrinox has quit IRC | 19:24 | |
*** cytrinox has joined #ingres | 19:25 | |
*** rossand has joined #ingres | 19:33 | |
*** ChanServ sets mode: +o rossand | 19:33 | |
*** mull has quit IRC | 20:04 | |
*** rossand has quit IRC | 21:20 | |
*** nafox has quit IRC | 21:48 | |
*** Alex| has joined #ingres | 22:23 | |
*** ChanServ sets mode: +o Alex| | 22:23 | |
*** Alex| has quit IRC | 23:28 | |
*** Mud has joined #ingres | 23:30 | |
*** gerhard has joined #ingres | 23:31 | |
*** Alex| has joined #ingres | 23:45 | |
*** ChanServ sets mode: +o Alex| | 23:45 | |
*** Mud has quit IRC | 23:49 | |
*** Mud has joined #ingres | 23:54 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!