| pboro | grantc, that's possible with svn too, with pre/post-hooks | 00:43 |
|---|---|---|
| Alex| | that's a little too late now I guess | 00:43 |
| pboro | hehe | 00:43 |
| grantc | yup - i was hoping to make the move transparent but it was not to be | 00:43 |
| pboro | apache logs could also be doable | 00:44 |
| grantc | yup we can get a list of all the people who have checked in code or who have rights to check in code | 00:49 |
| grantc | it does not cover the sites that have just done a checkout and are mirroring | 00:50 |
| pboro | ah, yeah, mirrors... | 00:52 |
| Alex| | we have mirrors? ;) | 01:01 |
| pboro | apparently :D | 01:01 |
| grantc | there are websites like ohloh.net that scan our code | 01:03 |
| grantc | most of which can be updated by hand... | 01:03 |
| *** magnusg| has joined #ingres | 01:07 | |
| *** dyki has joined #ingres | 01:08 | |
| dyki | morning all | 01:08 |
| grantc | morning | 01:11 |
| *** graydot has left #ingres | 01:17 | |
| *** Gerhard has joined #ingres | 01:28 | |
| Gerhard | Hi all | 01:34 |
| grantc | hullo | 01:34 |
| Gerhard | Anybody having experiences with the longrun script (see http://downloads.ingres.com/online/collaterals/wp/FindAndFixIngresQueries-WP-CN.pdf) on *Windows* machines? | 01:44 |
| grantc | nope | 01:46 |
| Gerhard | I tried with Microsofts's Services-for-Unix package which provides a korn shell but I'm unsure how to pass the "-i II_SYSTEM" switch to the script. | 01:48 |
| grantc | looking at the readme they it mentions using Cygwin | 01:51 |
| grantc | perhaps there is a difference between pdksh and ksh in SfU | 01:52 |
| Gerhard | I'll give pdksh a try. | 02:08 |
| *** Deyan has joined #ingres | 02:14 | |
| Deyan | morning | 02:14 |
| dyki | morning :) | 02:14 |
| Deyan | guys, how many times your ingres server crash perh day? | 05:11 |
| Deyan | ^^ | 05:11 |
| Deyan | servers* | 05:11 |
| Alex| | it's a sin to ask that question here ;p | 05:12 |
| *** Alex| is now known as Alex|off | 05:12 | |
| dyki | we are coming down to 6 today and its just lunch time :) | 05:12 |
| Deyan | we may hit the record today | 05:13 |
| Deyan | and beat yesterday by 2 | 05:13 |
| Deyan | 9.3 seems very unstable... | 05:13 |
| *** rossand has joined #ingres | 05:36 | |
| *** ChanServ sets mode: +o rossand | 05:36 | |
| pboro | Deyan, if 9.2 suits you, I suggest trying that | 05:54 |
| Deyan | pboro: i could not find 64bit version of it for Linux | 05:55 |
| Deyan | and building INGRES on Linux does not work as easy as i expected | 05:55 |
| Deyan | i think Ingres developers, no matter how they like/dislike MySQL should learn how mysql does the building system | 05:56 |
| Deyan | (yes, i know, ingres is much older) | 05:56 |
| pboro | Deyan, there is 64-bit version | 05:56 |
| Deyan | (but still...) | 05:56 |
| Deyan | pboro: we looked for it today | 05:57 |
| Deyan | so we decided to continue with 9.3 for now... | 05:57 |
| pboro | Hmm... apparently they released it only for customers with support contract | 05:58 |
| Deyan | i told you - we could not find it... | 05:58 |
| Deyan | anyway, i must work | 05:58 |
| pboro | yeah, there's no community version of ingres 9.2 for linux 64-bit | 05:58 |
| Deyan | sorry, thanks for help | 05:58 |
| Deyan | if crashing continues i am probably going to switch everything to MySQL | 05:59 |
| pboro | if that works better for you | 05:59 |
| Deyan | but we will see | 05:59 |
| pboro | for what kind of application are you using the database? | 06:02 |
| Deyan | enterprise | 06:03 |
| Deyan | ok, there is 9.0 | 06:04 |
| pboro | I don't see any reason why there is no community Ingres 9.2 64-bit for Linux, maybe you could ask guys at Ingres if they could put up the missing 64-bit version? | 06:05 |
| pboro | Community forums could be a good place to ask | 06:06 |
| dyki | there is no 9.1 either | 06:07 |
| Vroomfondle | get them to put up a .deb, while yer at it ;D | 06:08 |
| dyki | nah.. if compiling ingres would work there would be no problem | 06:08 |
| Deyan | we are not debian (and derivatives) users... | 06:08 |
| Deyan | ;) | 06:08 |
| Deyan | we are happy with RPMs | 06:09 |
| pboro | which RPM based distro are you using? | 06:10 |
| dyki | suse | 06:10 |
| Deyan | i use Fedora at home | 06:11 |
| Deyan | but i do not use it for anything serious | 06:11 |
| Deyan | just for playing around | 06:11 |
| Vroomfondle | I proposed Ingres for inclusion in the Ubuntu repos, but I don't think any package maintainers have been willing to take it on as yet | 06:12 |
| Vroomfondle | and I'm sure as hell not gonna do it myself. Sounds like pain ;) | 06:12 |
| pboro | Vroomfondle, no wonder there's no one else either ;) | 06:12 |
| dyki | well, i dont think that ubuntu is used for enterprise :) | 06:12 |
| pboro | it is | 06:13 |
| Vroomfondle | you'd be suprised | 06:13 |
| Deyan | Vroomfondle: yep, i am sure nobody is willing to do it :) | 06:13 |
| dyki | maybe in niche ;-) | 06:13 |
| Deyan | funny thing is - Ingres talks a lot about community, open-source etc | 06:13 |
| Vroomfondle | It's used a lot in enterprise, but mostly on the workstation end | 06:13 |
| Deyan | and they did not even bother to provide that community with proper HowTo document | 06:14 |
| Deyan | how to build it | 06:14 |
| Deyan | :) | 06:14 |
| Vroomfondle | remember that Canonical make their money from enterprise rollouts, and they're making money, so someone must be using it ;) | 06:14 |
| dyki | sure - workstation yes | 06:14 |
| pboro | Ubuntu Server is even certified for IBM DB2 and several other products | 06:15 |
| Vroomfondle | thing is, it's common for developers to be using Ubuntu workstations these days if they're developing for a 'nix-based system, so it would be worth Ingres' while to make it easy to install a local copy on a workstation | 06:15 |
| atrofast | The binary installer for Ingres works fine on Ubuntu as far as I've seen | 06:16 |
| atrofast | Or what we call the non-rpm installer | 06:16 |
| Vroomfondle | O.o | 06:17 |
| atrofast | It works fine for all Linux distro's I've tried (Ubuntu, Fedora, Arch) | 06:17 |
| pboro | Ingres also builds fine on Ubuntu and Debian | 06:17 |
| Vroomfondle | unless you're referring to something I haven't seen yet, it's never worked for me | 06:17 |
| Vroomfondle | I did manage to get it half-built using the instructions on the ubuntu wiki, but then I realised I was likely to die of old age before I got to the end and gave up ;) | 06:18 |
| Vroomfondle | I guess someone with a more pressing need would persevere, though | 06:18 |
| atrofast | No I'm talking about the pre-built packages :) | 06:18 |
| atrofast | from esd.ingres.com | 06:18 |
| pboro | Vroomfondle, latest trunk took 30 minutes to build on 2x P3 1,4 GHz system with 1 GB of RAM | 06:19 |
| Deyan | yeah, i understand why they charge for binaries | 06:19 |
| Deyan | - it is difficult to make them :) | 06:19 |
| Deyan | :)))))) | 06:19 |
| atrofast | No the community binaries are not charged for | 06:19 |
| pboro | Deyan, they don't charge for binaries, community binaries are free of charge | 06:19 |
| atrofast | They're GPL and you're free to use them as you see fit | 06:19 |
| Vroomfondle | pboro: it was more the sheer number of hoops I needed to jump through in the instructions that put me off, I think | 06:19 |
| pboro | Vroomfondle, oh, ok :) | 06:19 |
| Vroomfondle | atrofast: hrm. I did try those first but to no avail. Maybe I should have another go. | 06:20 |
| pboro | If I had access to a number of linux distros I would happily write build instructions for each of them | 06:20 |
| atrofast | You're on Ubuntu? | 06:20 |
| Deyan | sorry, let me rephrase, now i understand why they do not give any howto's for how to build Ingres | 06:20 |
| Vroomfondle | ... but I can't remember my Ingres password | 06:20 |
| pboro | since it's a pretty nobrainer, just have to figure out what packages are needed etc. | 06:20 |
| Vroomfondle | atrofast: yes | 06:20 |
| Deyan | - they are making money from the simple fact it is nearly impossible to build it by yourself | 06:20 |
| Deyan | :D | 06:20 |
| pboro | Deyan, that's not true :) | 06:20 |
| Deyan | yeah, yeah, not true... | 06:21 |
| Deyan | :D | 06:21 |
| pboro | I don't have any suse's at hand so can't help you on that, if I had, I would be happy to help | 06:21 |
| pboro | Suses even | 06:21 |
| atrofast | Okay Vroomfondle I'm gonna boot into my ubuntu 9.04 and see if I get any issues | 06:22 |
| Deyan | pboro: write INGRES Building HOWTO then ;) | 06:22 |
| pboro | Deyan, I'm not going to teach people to do their job, but a simple howto for a single distribution is fine | 06:23 |
| Deyan | my job is not to build RDBMS | 06:23 |
| Deyan | that is why i may just switch to MySQL | 06:23 |
| pboro | neither is mine :) | 06:23 |
| Deyan | and save myself lots of time | 06:23 |
| *** atrofast has quit IRC | 06:23 | |
| Deyan | anyways, enough talk - lets's work :) | 06:24 |
| pboro | Deyan, if you arrange me a virtual box or similar running suse, I'm happy to try compiling ingres 9.2 as 64-bit on it and write a howto about it | 06:24 |
| pboro | or is there a free version of suse available somewhere? | 06:24 |
| Deyan | it is called openSuSE | 06:24 |
| pboro | it's not the same | 06:24 |
| Deyan | and is available, naturally | 06:25 |
| Deyan | erm... ok, if you say so | 06:25 |
| pboro | or is it? is it 1:1 with commercial version? | 06:25 |
| *** atrofast has joined #ingres | 06:25 | |
| Deyan | commercial version just does not have the same package versions | 06:25 |
| Deyan | same with RedHat and Fedora | 06:25 |
| pboro | ok, so the howto for opensuse may not for suse at all | 06:25 |
| Deyan | EE versions are just little bit late | 06:25 |
| pboro | since it's not the same :( | 06:26 |
| Deyan | lagging behind open ones | 06:26 |
| rossand | Hey guys. Let me state - we know the build is not perfect. It has improved tremendously over the past year with a number of steps automated. It is feasible on some distributions to build in 3 commands. However, you're right, there's still a lot of work to do. | 06:26 |
| Deyan | we use opensuse | 06:26 |
| rossand | If you'd like to help us by naming specific things you don't like, that would be very helpful. | 06:26 |
| pboro | Deyan, oh, I thought you used suse | 06:26 |
| rossand | We know some of the short comings but your perspective is very valuable. | 06:26 |
| pboro | Deyan, I'll check opensuse later this evening if I can get it installed on vmware and try building Ingres, I'll write a howto then | 06:27 |
| Deyan | pboro: i do not make difference from those two | 06:27 |
| Deyan | so when i said suse, i meant opensuse | 06:27 |
| Deyan | my mistake | 06:27 |
| pboro | ok | 06:27 |
| pboro | anyway, I'll check opensuse later this evening and write a howto to make you happy :) | 06:28 |
| Deyan | rossand: i am trying hard here to stay with ingres, believe me | 06:28 |
| Deyan | i come from mysql world | 06:28 |
| Deyan | :) | 06:28 |
| Deyan | but we managed to crash ingres | 06:28 |
| Deyan | with amazingly simple stuff | 06:28 |
| rossand | Deyan: cool, thanks. We're glad to help. | 06:28 |
| rossand | Deyan: probably best to raise a bug for the crash. | 06:29 |
| Deyan | i would, but i am not payed here for fixing ingres problems | 06:29 |
| Deyan | and spending time trying to narrow down everything to find out what causes ingres to crash | 06:29 |
| Deyan | :/ | 06:29 |
| * Vroomfondle may be about to retract some of his earlier statements as it would appear that Ingres is installing fine (so far) from binaries on Intrepid | 06:29 | |
| Deyan | i am here to deliver | 06:29 |
| Deyan | :) | 06:29 |
| rossand | Deyan: Is this the first bug you've come across in open source software? | 06:30 |
| atrofast | Glad you got it to work Vroomfondle, I'm trying it out on 9.04 | 06:30 |
| rossand | Deyan: if you let us know about them as best you can afford, we stand a much better chance of fixing them. :-) | 06:30 |
| pboro | Deyan, which opensuse version are you using? 11? | 06:30 |
| Deyan | rossand: i would gladly help once i have a project i am payed for up and running | 06:30 |
| Deyan | :) | 06:31 |
| rossand | Deyan: let me paraphrase - you found an issue that prevents you from being paid using Ingres. because you're not being paid, you're not interested in telling us about it? It this about right? | 06:31 |
| Deyan | sounds sarcastic put that way | 06:33 |
| rossand | Sorry, I was not trying to be sarcastic. I appreciate the fact you're talking to us at all. | 06:33 |
| Deyan | i could easily say "ok, i am going to install stable version of mysql which is not going to crash every hour" | 06:33 |
| Deyan | be payed | 06:33 |
| Deyan | and be happy | 06:33 |
| rossand | Just trying to state facts to try and avoid any sarcasm. | 06:33 |
| Deyan | :D | 06:33 |
| Deyan | instead, i am still trying to use ingres | 06:33 |
| Deyan | do not ask me why... | 06:34 |
| Deyan | because i do not know the answer | 06:34 |
| Deyan | :)))) | 06:34 |
| rossand | Help us to help you - a little informaiton goes a long way. | 06:34 |
| rossand | It's quite possible we'll find such a bug ourselves in our testing. It does speed the process up if you let us know which distro, which version, the scenario you were doing. | 06:35 |
| rossand | In the end though, that's your choice. | 06:35 |
| Deyan | i have already helped ingres php extension project :) | 06:35 |
| rossand | Cool, thank you for that. | 06:35 |
| Deyan | 2 days ago we have found a serious bug | 06:35 |
| Deyan | which is fixed | 06:35 |
| Deyan | thanks to grant | 06:35 |
| Deyan | but i cannot spend hours here testing ingres stuff | 06:35 |
| Deyan | i hope you understand this | 06:35 |
| rossand | Yeah, grantc is awesome. He helped atrofast and I many times with the work to have drupal run on Ingres. | 06:36 |
| Deyan | on top of that, i cannot cover it | 06:36 |
| Deyan | i cannot provide rationale for using a product that crashes, and WASTE VALUABLE TIME | 06:36 |
| Deyan | instead of using product that does not crash | 06:37 |
| rossand | Deyan: definitely understood. As much time as you are willing to describe the problem helps us narrow it down. If you can't afford to do so or don't want to, then there's not much we can do but hope to run into it in our testing or that someone else will report it. Makes sense? | 06:37 |
| Deyan | :) | 06:37 |
| Deyan | here, on our test server we have a very funny problem | 06:38 |
| Deyan | which is IMHO pure Ingres problem | 06:38 |
| Deyan | (9.3 version) | 06:38 |
| Deyan | if i do destroydb <name> && createdb <name> && sql <name> <sqlscript.sql | 06:38 |
| Deyan | ingres will just get crazy | 06:39 |
| Deyan | (sql script only generates schema, nothing else) | 06:39 |
| rossand | Are you able to provide the script to me? | 06:39 |
| Vroomfondle | hmmm... well it's got as far as trying to start Star. 's taking a long time about it but then I guess that's not unusual. Seems to take a while on our sparc/solaris systems too. | 06:39 |
| atrofast | Vroomfondle: Yeah the binary installer works fine on Ubuntu 9.04 as well :) | 06:39 |
| Deyan | rossand: BUT | 06:39 |
| Deyan | if i put sleep 2 | 06:39 |
| Deyan | between those 3 commands | 06:40 |
| Deyan | everything works fine! | 06:40 |
| Deyan | :)))))))))))))))))))))))) | 06:40 |
| rossand | Deyan: that is very helpful right there. Are you able to provide the script? Once I can reproduce it, we're well on our way to fixing it. | 06:40 |
| Deyan | if i have time to do that, and narrow down the problem, i would do it | 06:41 |
| Deyan | i cannot provide the script | 06:41 |
| Deyan | i am simply not allowed to do it | 06:41 |
| rossand | Hmm, ok. Well I'll try with a schema of my own. Hopefully that'll break so I can reproduce without your script. | 06:42 |
| rossand | Just in case that doesn't work. If it's just the schema, what are the concerns about sharing it? | 06:43 |
| Vroomfondle | hrm. *still* starting Star, even after 10 mins. | 06:44 |
| Deyan | what? | 06:44 |
| Deyan | o.O | 06:45 |
| Deyan | rossand: erm... everything i do for the company is company's property | 06:45 |
| rossand | Deyan: sure. have you asked the company if you can share the schema creation script with us so we can investigate the bug? | 06:46 |
| atrofast | Vroomfondle: Which version of Ingres idd you use? | 06:46 |
| Vroomfondle | atrofast: Linux x64 | 06:46 |
| Vroomfondle | 9.2 | 06:46 |
| atrofast | I tried Linux x86_64 9.3 b151 and it didn't get stuck on starting STar, I'll try 9.2 now... Which build? | 06:46 |
| Vroomfondle | ingres-9.2.0-143-NPTL-com-linux-ingbuild-x86_64 | 06:47 |
| atrofast | Thanks, I'll try it | 06:48 |
| Gerhard | Deyan: maybe you could reproduce the error right now and then copy the last few lines of your $II_SYSTEM/ingres/files/errlog.log to the pastebin? | 06:50 |
| *** atrofast has quit IRC | 06:50 | |
| *** atrofast has joined #ingres | 06:50 | |
| atrofast | Vroomfondle: My install finished fine without hanging on Star | 06:53 |
| atrofast | I'm afraid I'm not very knowledgable of Star so I'm not sure what would be causing that problem :( | 06:54 |
| Vroomfondle | did you use ingres_express_install? | 06:57 |
| atrofast | Yes, I did | 06:58 |
| Vroomfondle | hrm, me too | 06:58 |
| atrofast | If you're not planning on using STar, you can always shut it off in cbf | 06:58 |
| atrofast | In fact that will make startup/shutdown faster too | 06:58 |
| Vroomfondle | it's been a while since I last attempted this. Where does it put all its binary files, by default? | 06:59 |
| Vroomfondle | there's nothing in ~ingres and I can't find the usual tools in /usr/bin or /usr/local/bin | 06:59 |
| atrofast | /opt/Ingres/IngresII | 07:00 |
| atrofast | Is the default | 07:00 |
| Vroomfondle | ah, cheers | 07:00 |
| atrofast | Log in as a privileged Ingres user (ingres by default) and source /home/ingres/.ingIIsh | 07:00 |
| Vroomfondle | no such file. | 07:02 |
| atrofast | Then run cbf, highlight Star Server, editcount and set it to 0, restart Ingres | 07:02 |
| atrofast | Hmmm that is interest | 07:02 |
| atrofast | Is there a .ingIIsh in /opt/Ingres/IngresII? | 07:02 |
| atrofast | Or /opt/Ingres/IngresII/ingres perhaps | 07:03 |
| Vroomfondle | there is indeed | 07:03 |
| Vroomfondle | aha, now I have access to cbf | 07:03 |
| atrofast | Do you know how to wor kCBF? | 07:04 |
| Vroomfondle | vaguely | 07:04 |
| Vroomfondle | I think I've done the right thing. Stopping the server now. | 07:05 |
| atrofast | I prefer to set the env var TERM_INGRES to "konsole" | 07:05 |
| Vroomfondle | aha, it started | 07:05 |
| Vroomfondle | cheers | 07:05 |
| atrofast | That way you can use the f-keys instead of the ESC-SHIFT-OP for commands | 07:05 |
| atrofast | Yay! | 07:05 |
| Vroomfondle | :) | 07:07 |
| *** toumi01 has joined #ingres | 07:07 | |
| pboro | err, how am I supposed to install packages in OpenSuse... *googles* | 07:28 |
| atrofast | commandline: zypper | 07:30 |
| atrofast | I think anyway, been a while since i used suse | 07:30 |
| Gerhard | pboro : yast | 07:30 |
| atrofast | Isn't yast the GUI and zypper the command line tool? | 07:31 |
| Gerhard | Yast can be used either in KDE/Gnome, but also in an SSH client | 07:32 |
| Gerhard | but you're right, it is not CLI | 07:32 |
| pboro | zypper looks more friendly | 07:32 |
| *** magnusg| has left #ingres | 07:32 | |
| *** magnusg| has joined #ingres | 07:34 | |
| *** magnusg| has left #ingres | 07:35 | |
| grantc | pboro it depends :) | 07:35 |
| pboro | ah... damn, my server doesn't support em64t, so I can run 64-bit opensuse on it, have to find some other hw | 07:35 |
| grantc | from repos you can do "zypper install package" or "yast -i package name" | 07:35 |
| pboro | grantc, ah, didn't figure that -i out | 07:35 |
| pboro | "apt-get|yum|whatever install package" is the most familiar way :> | 07:36 |
| grantc | zypper is ok | 07:37 |
| Deyan | aptitude too | 07:37 |
| Deyan | i used apt-get on Fedora long ago | 07:37 |
| pboro | Deyan, yeah aptitude is a bit more up to date than apt-get | 07:37 |
| pboro | handles conficts etc. better, tho' apt-get improved too | 07:38 |
| Deyan | they are awesome tools | 07:38 |
| Deyan | they only reason why i switched to yum later was that apt-get could not handle multiarch packages | 07:38 |
| Deyan | and mixed arch packages too | 07:39 |
| *** adrianwarwickuni has joined #ingres | 07:47 | |
| pboro | damn, I really need to install some captcha plugin to my blog to limit the amount of spam | 07:48 |
| grantc | pboro, akismet works well as well as re-captcha | 07:55 |
| pboro | grantc, re-catpcha is outdated (not been update for latest WP), but I installed SI CAPTCHA, it worked out of the box :) | 07:56 |
| grantc | i have re-captcha for my 2.81 install | 07:56 |
| pboro | oh, the web page says it's compatible only up to 2.7.x, so I skipped it | 07:56 |
| pboro | also iirc it required extra modification to the theme | 07:57 |
| *** atrofast has quit IRC | 07:57 | |
| * Vroomfondle pokes esd.ingres.com with the go-faster stick | 07:57 | |
| pboro | si captcha just relies on comment_form action (hook into it) so no need to modify your theme | 07:57 |
| pboro | hooks even | 07:58 |
| *** atrofast has joined #ingres | 08:00 | |
| pboro | hmm is http://svn.ingres.com/ingres/main/ latest 9.2 or simply the latest trunk for Ingres? | 08:03 |
| atrofast | It's the latest trunk for Ingres | 08:04 |
| rossand | I use drupal myself and the captcha plugin made spammers go away dramatically. None for about 2 months. Now, about 5-6 per day. Of course it's gleefully fun to nuke their crap each morning. Takes about 20 seconds vs. must be 2-3 minutes each for them. :-) | 08:04 |
| pboro | rossand :D | 08:05 |
| *** atrofast has quit IRC | 08:05 | |
| pboro | so only source for 9.2 is the ga release source available at ESD? the latest source for 9.2 is not publicly available? | 08:05 |
| pboro | "so the only source code..." even | 08:05 |
| grantc | pboro, you mean the sauce for the latest patches for 9.2 | 08:06 |
| grantc | ? | 08:06 |
| pboro | yup | 08:07 |
| *** atrofast has joined #ingres | 08:07 | |
| pboro | sauce :D | 08:07 |
| rossand | Deyan: I did a fresh build of the latest code from main for reproducing the issue you saw - should be ready any minute now. I'll get back to you. | 08:07 |
| Vroomfondle | flushed with success /me starts upgrading 9.2 -> 9.4 | 08:07 |
| pboro | Vroomfondle, you are not going to use 9.4 in production use, are you? :) | 08:08 |
| atrofast | Yeah that's not recommended :) | 08:08 |
| Vroomfondle | nah | 08:09 |
| pboro | just making sure :) | 08:09 |
| Vroomfondle | tbh it's only going to be used to access remote nodes anyway | 08:09 |
| Vroomfondle | this is just a local installation for my convenience, so that I can drag data out of our servers into local files without having to scp | 08:10 |
| Vroomfondle | and so that I can hook Python up to it :) | 08:10 |
| *** mull has joined #ingres | 08:10 | |
| Vroomfondle | I note that there's no 64bit build of visualdba etc. available from the website. Is there one available at all? | 08:12 |
| *** Gerhard has quit IRC | 08:17 | |
| pboro | grantc, so... no source for the latest 9.2 tree? :) | 08:17 |
| *** Alex|off is now known as Alex| | 08:17 | |
| grantc | pboro, I believe as a paying customer you get access to it | 08:18 |
| pboro | grantc, ah... I don't need it (at least not now), but I was thinking about community users | 08:18 |
| pboro | but apparently the process is that the community only gets the source of ga releases | 08:18 |
| grantc | :) | 08:18 |
| grantc | ga and bleading edge | 08:18 |
| pboro | (plus the latest and greatest trunk) | 08:18 |
| pboro | yup | 08:18 |
| grantc | the Vroomfondle running with knives edition | 08:18 |
| pboro | oh well, that makes sense :) | 08:19 |
| Vroomfondle | live fast & die in a blaze of segmentation faults | 08:19 |
| Vroomfondle | that's how I roll, dawg. | 08:19 |
| pboro | :D | 08:19 |
| atrofast | Haha | 08:22 |
| pboro | damn, I wish there was at least 32 hours in a day | 08:29 |
| Alex| | 18 hours of sleep? | 08:29 |
| pboro | naah, seven hours is enough :) | 08:30 |
| adrianwarwickuni | If I remember correctly then there are 32 hours in an MS-DOS day if that's any help ;)... In the days before I had internet I once reverse engineered the FAT file system for fun :) | 08:47 |
| pboro | :D | 08:47 |
| pboro | fortunately they only used values 0-23... it could have been MS extension to have hours 24-31 in use too! | 08:48 |
| adrianwarwickuni | Yep. But I managed better than that. I managed to add hard links (amongst other things) using a hex editor. | 08:50 |
| pboro | hehe | 08:50 |
| pboro | fs hacking, that's fun until it gets borked and you try running chkdsk or similar :D | 08:50 |
| *** grantc has quit IRC | 09:46 | |
| *** Deyan has quit IRC | 09:56 | |
| *** adrianwarwickuni has quit IRC | 10:06 | |
| *** DerMeister has joined #ingres | 10:07 | |
| *** atrofast has left #ingres | 10:22 | |
| *** atrofast has joined #ingres | 10:27 | |
| *** atrofast has left #ingres | 10:27 | |
| *** atrofast has joined #ingres | 10:27 | |
| *** dyki has quit IRC | 11:01 | |
| *** atrofast has quit IRC | 11:11 | |
| *** adrianwarwickuni has joined #ingres | 11:33 | |
| pboro | Has anyone tried boost-jam with Ingres? Does it work? | 13:06 |
| pboro | INSTALL file only mentions Jam, but doesn't state anything about variants... | 13:07 |
| pboro | I guess I gotta try it, since it's the only variant that openSUSE offers | 13:09 |
| Alex| | no ftjam available? | 13:09 |
| pboro | nope | 13:09 |
| Alex| | well, I'm sure jam is jam is jam :) | 13:10 |
| pboro | boost-jam is based on ftjam which is based on the original jam | 13:10 |
| pboro | I hope so :) | 13:10 |
| pboro | I wonder why Ingres would have to be compiled as user "ingres", but I guess it's better to follow the instructions... | 13:10 |
| Alex| | you _can_ compile it as another user but you need to fix some setuids | 13:11 |
| pboro | ah, ok... better not to dig blood out of my nose then | 13:11 |
| Alex| | makes life easier... | 13:12 |
| pboro | ingdev:/usr/src/ingres2006-9.2.0-134-gpl-src/pax # jam | 13:14 |
| pboro | LINUXX86_64 LINUX not supported | 13:14 |
| pboro | this prolly gonna be harder than I expected... | 13:14 |
| Alex| | you can fix that... try to remember where... it's a problem with what jam thinks the supported platforms are | 13:15 |
| pboro | Jamfile needs some modifications | 13:15 |
| pboro | I somehow expected that the source package would be ready for 64-bit Linux, but apparently not | 13:15 |
| Alex| | I had that problem on a 32-bit system but a distribution that set this variable differently | 13:16 |
| DerMeister | I redhat still the only official supported linux? | 13:17 |
| Alex| | and SLES and even Ubuntu... but that's for the binaries... no platform is 'supported' when it comes to compiling :) | 13:18 |
| pboro | hehe :) | 13:19 |
| pboro | I also need GCC <4.0... this really gonna be painful :D | 13:24 |
| Alex| | hm, really can't find it... it's a simple variable for jam that is set to something like OS+ARCH and the Ingres jam rules always expect LINUXX86 or so | 13:24 |
| Alex| | and no... the latest version I compiled was fine with 4.2.. only 4.3 had some gotchas | 13:24 |
| Alex| | because with 4.3 many warnings became errors.... not sure how far the support is today | 13:25 |
| pboro | the INSTALL file for 9.2 explicitly tells not to use GCC 4.x | 13:25 |
| Alex| | it worked for me everytime :) | 13:25 |
| Alex| | < 4.3 should be ok | 13:26 |
| pboro | hm hm, maybe I'll cheat here and try installing 4.2 | 13:26 |
| pboro | the default for openSUSE seems to be 4.3, but there's also 4.1 available | 13:27 |
| Alex| | yeah, 4.3 is becoming default in most distributions... maybe the code already compiles with 4.3.. haven't tried for a while | 13:27 |
| pboro | ehh... I need to install gcc43 to get alternatives entry so that I can use update-alternatives to make cc point to gcc4.1 | 13:31 |
| DerMeister | Even gentoo stable uses 4.3 for quite a while now :D | 13:34 |
| pboro | yup | 13:34 |
| DerMeister | Hm... looks like I still have 4.1 and 3.4 installed o_O | 13:35 |
| Alex| | it took quite some effort to make all packages compatible... | 13:36 |
| Alex| | unfortunately updating the Ingres code to compile with bleeding edge gcc is not the highest priority.... | 13:37 |
| pboro | eoowww I also need to compile Xerces 2.5 by hand | 13:37 |
| Alex| | nope... | 13:38 |
| pboro | openSUSE has 2.8, it most probably won't work with the build | 13:38 |
| Alex| | depending on how much effort you want to put in, it will :) | 13:38 |
| Alex| | take a look at http://bugs.gentoo.org/show_bug.cgi?id=247895 | 13:38 |
| pboro | I'll check that, thanks | 13:39 |
| pboro | oh my... | 13:39 |
| Alex| | there are some patches, workarounds, etc.. with this gentoo ebuild Ingres will compile with any xercesc version | 13:39 |
| Alex| | I think the current main code has the xercesc version hard coded only in bldenv | 13:40 |
| pboro | at least http://bugs.gentoo.org/attachment.cgi?id=172643 seems necessary | 13:40 |
| pboro | (but modified) | 13:40 |
| pboro | I'm pretty sure this is doable, but it's a different story if I'm that kind for Deyan | 13:41 |
| Alex| | I did a bit more than usually necessary because xercesc 3.x changed the naming convetion of the lib | 13:41 |
| Alex| | for 2.8 it may be enough to set xvers=28 in bldenv | 13:42 |
| pboro | yeah, I'm going to try that | 13:42 |
| Alex| | however, you need the xercesc headers and for 64-bit I think you need to have the 32-bit and 64-bit libxercexs-c | 13:43 |
| Alex| | I personally didn't compile Ingres on 64-bit yet but atrofast did | 13:44 |
| pboro | yeah, trying to figure how to get zypper install 32-bit version of libxerces-c too | 13:44 |
| *** adrianwarwickuni has quit IRC | 13:47 | |
| pboro | it looks promising! | 13:59 |
| Alex| | when you run jam with -q it will stop at errors... otherwise you will see them only in the statistics at the end | 14:02 |
| pboro | ah, thanks for the tip | 14:02 |
| Alex| | but when it doesn't say "don't know how to..." during that "patience" phase, chances are good it's working | 14:03 |
| pboro | hehe :) | 14:04 |
| *** DerMeister has quit IRC | 14:25 | |
| *** Alex| is now known as Alex|off | 14:29 | |
| *** mull has quit IRC | 14:40 | |
| *** adrianwarwickuni has joined #ingres | 17:03 | |
| rossand | If anyone sees Deyan before I do, please let them know I was not able to reproduce what they reported on Linux. destroying a database, recreating it, and creating tables from a script file ran fine multiple times with no delay between each command. I need more information to reproduce. The script, logs, or similar would help a lot. | 17:09 |
| *** adrianwarwickuni has quit IRC | 17:15 | |
| *** toumi01 has left #ingres | 19:58 | |
| *** rossand has quit IRC | 20:26 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!