*** grantc has joined #ingres | 00:01 | |
*** ChanServ sets mode: +o grantc | 00:01 | |
Vroomfondle | o/ | 00:19 |
---|---|---|
*** Mud is now known as Mud|afk | 00:43 | |
*** grantc_ has joined #ingres | 01:38 | |
*** grantc_ is now known as crogr01 | 01:38 | |
*** ChanServ sets mode: +o crogr01 | 01:38 | |
*** crogr01 has quit IRC | 01:42 | |
*** grantc_ has joined #ingres | 01:44 | |
*** grantc_ is now known as Guest58714 | 01:44 | |
*** Guest58714 is now known as crogr01 | 01:44 | |
*** ChanServ sets mode: +o crogr01 | 01:44 | |
*** crogr01 has quit IRC | 02:22 | |
*** Alex| has joined #ingres | 02:46 | |
*** ChanServ sets mode: +o Alex| | 02:46 | |
*** Gerhard has quit IRC | 02:52 | |
*** thiagomz has joined #ingres | 04:08 | |
thiagomz | morning all | 04:09 |
thiagomz | guys, i have the index name ... i wanna know what is his table... | 04:09 |
thiagomz | in what table the index is based. | 04:10 |
thiagomz | iiindexes | 04:11 |
thiagomz | ! | 04:11 |
thiagomz | :D | 04:11 |
*** zxiiro has quit IRC | 04:34 | |
*** zxiiro has joined #ingres | 04:35 | |
*** ChanServ sets mode: +v zxiiro | 04:35 | |
*** zxiiro has quit IRC | 04:56 | |
*** toumi01 has joined #ingres | 05:06 | |
*** Guest2564 has joined #ingres | 05:10 | |
*** Guest2564 is now known as Deyan | 05:11 | |
Deyan | meep | 05:11 |
Deyan | dyki: :) | 05:11 |
Deyan | how's everybody? | 05:11 |
grantc | morning | 05:12 |
*** zxiiro has joined #ingres | 05:44 | |
*** ChanServ sets mode: +v zxiiro | 05:44 | |
*** rossand has joined #ingres | 05:49 | |
*** ChanServ sets mode: +o rossand | 05:49 | |
*** mull has joined #ingres | 05:59 | |
*** atrofast has joined #ingres | 06:48 | |
*** ccsidiot has joined #ingres | 06:54 | |
ccsidiot | Hey, are the ucosp students having a meeting now? | 06:57 |
*** Alex| has quit IRC | 07:00 | |
*** SaraDanaher has joined #ingres | 07:26 | |
rossand | Hi Sara | 07:27 |
*** Mud has joined #ingres | 07:42 | |
*** Mud|afk has quit IRC | 07:49 | |
*** hanje04 has joined #ingres | 08:32 | |
*** Alex| has joined #ingres | 08:39 | |
*** ChanServ sets mode: +o Alex| | 08:39 | |
*** hanje04 has quit IRC | 08:39 | |
Deyan | grantc: i suppose you have a code that can be used as replacement for identities | 08:46 |
Deyan | or someone else? | 08:46 |
grantc | how do you mean? | 08:47 |
Deyan | i need to for an old version of ingres | 08:47 |
grantc | how old? | 08:47 |
Deyan | which does not have sequences | 08:47 |
Deyan | :/ | 08:47 |
grantc | i don't have code only ideas .... | 08:48 |
Deyan | well, i know how i can solve it, but thought maybe someone already wrote something like that... | 08:48 |
Deyan | i can do exactly what ingres does with sequences... | 08:48 |
grantc | it's messy however you do it and you will run into concurrency issues | 08:49 |
Deyan | the first thing that came to my mind was to write a procedure NEXTVAL() which would use "sequences" table in the current schema | 08:56 |
grantc | one way i came up with years ago was to have a rule that would update the row of the table with the next number if the column concerned was a known value, say -1 | 09:06 |
*** FrankW has quit IRC | 09:10 | |
*** Alex| has quit IRC | 09:20 | |
*** grantc has quit IRC | 09:59 | |
*** SaraDanaher has quit IRC | 10:02 | |
ccsidiot | Hey, guys, while I'm building the code on school's server | 10:52 |
ccsidiot | the code checked out from geospatial repo | 10:53 |
ccsidiot | I got the following messages from Jam | 10:53 |
ccsidiot | http://ingres.pastebin.com/md5c365f | 10:53 |
ccsidiot | and on line 263, it says don't know how to make /usr/lib/libxerces-c.so.27.0 | 10:53 |
ccsidiot | I'm confused how to tackle that | 10:54 |
*** thiagomz has quit IRC | 10:56 | |
ccsidiot | and on line 1240, there's another error buildrel: command not found | 10:57 |
ccsidiot | is buildrel another component that I need to install? | 10:57 |
toumi01 | ccsidiot: seeing no other replies to you ... and knowing zip about the geospatial wrinkles to the build ... see http://ingres.pastebin.com/m5a20ca3d for the sort of script I run from the root of the svn pull ... then I run these commands: cd jam; jam; cd $ING_SRC; mkjams; jam | 11:39 |
ccsidiot | toumi01: Thanks for your reply! So I run this script instead of runbuild? | 11:40 |
toumi01 | runbuild is a does-it-all wrapper I think and I prefer to do it "by hand" ... just old fashioned? ;) | 11:41 |
ccsidiot | Hum, I ran the script in the pastebin | 11:48 |
ccsidiot | cd jam, then jam, it says warning: unknown rule IISUBSYS | 11:48 |
toumi01 | the posted script is pretty generic, but you environment may vary | 11:49 |
toumi01 | the basic idea is: pull the code, set up some environment variables and then source buildrel to bootstrap other settings, go to the jam directory and run "jam" to bootstrap the jam tool, then go back to $ING_SRC and run mkjams to automatically set up jam build files, and finally run "jam" from $ING_SRC to build Ingres | 11:51 |
toumi01 | of course the details of where headers are in your environment, what gcc version you distro has, etc. is what keeps life interesting! | 11:52 |
toumi01 | when things go wrong ... always pipe jam output to a file ... "jam >& jam.out &" ... and then look for the FIRST problem, and fix things one by one | 11:53 |
toumi01 | if there are lots of build errors it is likely that there is a single root cause, or a few root causes at most, and a re-jam after setting things right will be the build to go cleanly | 11:54 |
toumi01 | after a clean (or mostly clean) build the command "buildrel -a" (an Ingres tool) will adjust file permissions and audit the build for missing files | 11:54 |
ccsidiot | Yea, the problem is now they code does not know the path to buildrel -a | 11:55 |
toumi01 | buildrel is created during the Ingres build, so if there were failures there's a good chance that it was not built | 11:56 |
*** Mud has quit IRC | 11:59 | |
atrofast | ccsidiot: You can also do jam -q to stop at first error | 12:00 |
ccsidiot | Yea, I can see from my error log: http://ingres.pastebin.com/md5c365f. It has problems in line 255 in //ING_ROOT/src/tools | 12:01 |
atrofast | ccsidiot: You need to have GEOS libs installed and available.. If they are installed in /usr/local/lib you need to add that to /etc/ld.so.conf and run ldconfig as root | 12:08 |
atrofast | Also I see that you can't find the libxerces files properly... How are you building? runbuild.sh or jam? | 12:09 |
ccsidiot | I'm doing runbuild | 12:10 |
ccsidiot | I'm building via ssh to a server at school | 12:10 |
ccsidiot | which has debian on it | 12:10 |
atrofast | Okay cool, so are you able to install additional libraries? | 12:11 |
ccsidiot | I will need to talk to the sysadmin about installing more things for me if installing at a non standard location will be really troublesome, since I only have limited rights to install, I can only install as a non-root user | 12:12 |
atrofast | Well you can make that work too but it would take longer because you'd have to download the source of Xerces-C and GEOS and compile them and the libs somewhere like ~/lib and export LD_LIBRARY_PATH=~/lib:$LD_LIBRARY_PATH | 12:19 |
atrofast | But you could run into "dependency hell" going that route, I have never myself tried to compile Xerces on Linux but GEOS is not too bad | 12:20 |
ccsidiot | The sysadmin already got me libxerces-c2-dev libxerces-c28 pax jam libpam0g-dev | 12:20 |
atrofast | Okay great | 12:20 |
ccsidiot | and I got the error log after he's installed those dependencies for me | 12:21 |
ccsidiot | I mean the error log above | 12:21 |
atrofast | Okay so the libxerces error can be fixed, but you will need GEOS to compile the geospatial branch | 12:21 |
ccsidiot | Just now toumi01 also suggested that too :) | 12:22 |
ccsidiot | So the GEOS lib is in the repo? or I need to get that from ESD? | 12:23 |
atrofast | No you need to get it from: http://trac.osgeo.org/geos/ | 12:25 |
atrofast | You'll have to compile the source, there are some instructions here: http://community.ingres.com/wiki/GeoDemoLinuxSetup | 12:26 |
ccsidiot | Sweet :) | 12:27 |
ccsidiot | Let me follow that | 12:27 |
ccsidiot | Thanks toumi01 astrofast :) | 12:27 |
toumi01 | good luck! | 12:27 |
ccsidiot | Thanks, I think I really need that :) | 12:27 |
atrofast | That guide kinda assumes you have root access though so you're going to have to adjust it somewhat | 12:28 |
toumi01 | especially on Friday the 13th! | 12:28 |
atrofast | Only if you're superstitious :) | 12:28 |
ccsidiot | XD, I think I am | 12:28 |
*** Alex| has joined #ingres | 12:32 | |
*** ChanServ sets mode: +o Alex| | 12:32 | |
*** clach04 has joined #ingres | 13:30 | |
*** zxiiro has quit IRC | 13:39 | |
*** toumi01 has left #ingres | 13:42 | |
*** mull has quit IRC | 13:49 | |
*** mull has joined #ingres | 13:52 | |
ccsidiot | Hum, the make for the GEO library did not go well: http://ingres.pastebin.com/m39145323 | 13:56 |
ccsidiot | It says nothing to be done for `all` | 13:56 |
ccsidiot | Oh nvm, | 13:57 |
ccsidiot | the make was done | 13:57 |
ccsidiot | It was the make install that gave me problem | 13:57 |
ccsidiot | http://ingres.pastebin.com/m2ceec26d | 13:58 |
atrofast | ccsidiot: Yes since you don't have root access make install is not going to work | 14:15 |
atrofast | What you could do is when you run configure: ./configure --prefix=~/ | 14:15 |
atrofast | Then make/make install it should work | 14:15 |
*** hanje04 has joined #ingres | 14:15 | |
ccsidiot | Hummm, I make clean, configured ./configure --prefix=/abs_path//geospatial/geos-3.2.Orc1, then make, then make install | 14:20 |
ccsidiot | It gives me the same error | 14:21 |
ccsidiot | Nothing to be done | 14:21 |
ccsidiot | http://ingres.pastebin.com/m1aa1da1 | 14:22 |
ccsidiot | Oh, right, I think I spot the problem | 14:25 |
ccsidiot | Let me double check the paths | 14:25 |
atrofast | The --prefix option needs to point to a directory where you have write access (usually your home directory) | 14:26 |
atrofast | Which ~/ is code for :) | 14:26 |
ccsidiot | It prompts me for absolute path though | 14:27 |
ccsidiot | that's why I put the absolute path there :( | 14:27 |
ccsidiot | After I've fixed the paths, it's doesn't have any error | 14:29 |
ccsidiot | Hum, how can I tell I install that correctly? | 14:29 |
ccsidiot | :) | 14:30 |
*** mull has quit IRC | 14:34 | |
atrofast | Check the directory you specified in --prefix, it should have a lib dir in it with libgeos.so something and libgeos_c.so something | 14:35 |
ccsidiot | Sweet, I've got them :) | 14:39 |
ccsidiot | :D:D:D:D | 14:39 |
ccsidiot | Thanks atrofast! | 14:39 |
atrofast | Most welcome, just remember if you want to compile against them you should set the environment variable LD_LIBRARY_PATH to point to the lib dir | 14:43 |
ccsidiot | Oh, I don't get the meaning of "compile against them" | 14:45 |
ccsidiot | What does that mean? | 14:46 |
atrofast | Ingres requires those libraries to compile so when you try to compile Ingres, it has to compile against them | 14:47 |
atrofast | so you would do a export LD_LIBRARY_PATH=/path/to/libs so that the compiler picks them up when running | 14:48 |
ccsidiot | Oh, I see :) atrofast: Thanks for your reminder | 14:48 |
*** Alex| has quit IRC | 14:50 | |
*** DarylM has quit IRC | 15:13 | |
*** clach04 has quit IRC | 17:13 | |
*** hanje04 has quit IRC | 18:45 | |
*** cytrinox_ has joined #ingres | 19:25 | |
*** cytrinox has quit IRC | 19:37 | |
*** cytrinox_ is now known as cytrinox | 19:37 | |
*** rossand has quit IRC | 21:49 | |
*** Alex| has joined #ingres | 23:08 | |
*** ChanServ sets mode: +o Alex| | 23:08 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!