*** bonro01 has joined #ingres | 00:08 | |
*** bonro011 has quit IRC | 00:23 | |
*** Alex| has joined #ingres | 00:41 | |
*** ChanServ sets mode: +o Alex| | 00:41 | |
dyki | 44 | 01:14 |
---|---|---|
*** dyki has quit IRC | 01:14 | |
*** paulmason has joined #ingres | 01:28 | |
*** paulmason has left #ingres | 01:29 | |
*** Deyan has quit IRC | 01:46 | |
*** paulm05 has joined #ingres | 02:00 | |
*** paulm05 is now known as maspa05 | 02:53 | |
*** maspa05 is now known as paulm05 | 02:54 | |
*** cthibert has joined #ingres | 03:41 | |
*** grantc has quit IRC | 04:35 | |
*** grantc has joined #ingres | 04:35 | |
*** ChanServ sets mode: +o grantc | 04:35 | |
*** zxiiro has quit IRC | 04:56 | |
*** atrofast has joined #ingres | 05:13 | |
atrofast | Is anyone familiar with the format of the transaction logs in Ingres? I know that each page starts with a log page header but I'm not quite sure what it looks like | 05:16 |
atrofast | The log header (absolute first page) is a struct that I've found, the actual log records have structs that you can look at but I cannot find a struct or anything similar for log page headers | 05:23 |
atrofast | It's supposed to have address of last writte npage, a checksum, page number stuff like that but I can't find in which order and what format | 05:23 |
grantc | Alison might know | 05:23 |
grantc | or Karl | 05:24 |
atrofast | Thanks grantc I guess I'll send off an emial | 05:24 |
grantc | toumi01 would probably know but he's not online yet | 05:25 |
Mud | grantc: got my application running \o/ | 05:25 |
grantc | Nice | 05:25 |
Mud | its importing data from all the ingres DB's (7 dif :X) and puts it in 1 Mysql table with a status and some calculations :D | 05:26 |
Mud | its running smooth for 18k+ rows | 05:26 |
grantc | eh MySQL? | 05:26 |
Mud | yes | 05:26 |
Mud | Our intranet runs on Mysql | 05:26 |
* grantc pretends he did not hear that | 05:26 | |
pboro | haha | 05:27 |
Mud | grantc: we dont control the ingres DB's eh :) they are ownt by our car importer | 05:27 |
Mud | + every application on our intranet has a db on a mysql server :o | 05:28 |
grantc | fair enough - i had assumed you were importing them into a local Ingres instance | 05:28 |
Mud | grantc: no no :) | 05:28 |
Mud | ^^ | 05:28 |
grantc | :/ | 05:28 |
Mud | mysql <3 :P | 05:28 |
Mud | but thats personal :D | 05:28 |
atrofast | Hehe, wars have been started by less than that Mud :) | 05:29 |
grantc | atrofast, i've got svnsync going | 05:30 |
Mud | grantc: its funny btw, we have also some applications that use Mssql as database, but also Progress DB and for our intranet we have Mysql :') | 05:30 |
Mud | and our main app use a Ingres DB :X | 05:30 |
grantc | i guess it keeps your DBA busy ;) | 05:30 |
Mud | ye :P | 05:30 |
Mud | I hate progress DB btw | 05:31 |
Mud | a few weeks a go the head finance dir, called me to copy to the database to a test DB | 05:32 |
Mud | and i couldnt | 05:32 |
Mud | guess what: I had to create extra files on the local hdd, and I had to add line a config :X | 05:32 |
Mud | how stupid is that! | 05:33 |
Mud | :X | 05:33 |
Mud | each DB use a own config that contains what files the db's should use (db files) :X | 05:33 |
Mud | :X | 05:33 |
Mud | so when you do a import from a 1 GB db to a 100 MB db, thats goes wrong :') | 05:34 |
Mud | :') | 05:34 |
Mud | also : when you say in your config that you use 7x 100MB files and the DB goes over the 700MB, it stops working :X | 05:37 |
Mud | :') | 05:37 |
atrofast | Wow that sounds clunky | 05:40 |
* atrofast never used Progress DB | 05:41 | |
paulm05 | is it like a tablespace - fixed size? | 05:41 |
*** cthibert has left #ingres | 05:45 | |
grantc | i have a n00b DBA question - how do you control the size of the journal files | 05:48 |
grantc | IIRC there is/was a param that can be tweeked in cbf but i cannot see it | 05:48 |
paulm05 | archiver_refresh IIRC | 05:48 |
grantc | does it take decimal values? | 05:49 |
paulm05 | yes it should do | 05:49 |
*** cthibert has joined #ingres | 05:49 | |
*** rossand has joined #ingres | 05:50 | |
*** ChanServ sets mode: +o rossand | 05:50 | |
grantc | CBF disagres | 05:50 |
* paulm05 checks - nope that didn't work | 05:50 | |
grantc | i know the archiver interval params allow for it... oh well | 05:50 |
paulm05 | if you edit config.dat directly I think it will use the decimal value | 05:50 |
* grantc breaks out vim | 05:51 | |
grantc | well ingres started... | 05:52 |
paulm05 | you testing incremental rollforward or something? | 05:52 |
grantc | paulm05, i might need to pick your brains later on regarding moving ckps about | 05:52 |
grantc | perhaps :) | 05:52 |
paulm05 | never actually tried it myself - but there's always time to learn :) | 05:53 |
grantc | i'm investigating methods to improve the backup of {bugs,lxr,inspect}.ingres.com | 05:53 |
grantc | ditto til this morning | 05:53 |
grantc | i think i have it working | 05:54 |
paulm05 | btw - thanks for installing the IRC bouncer | 05:54 |
grantc | right now the problem is the large jnl files | 05:54 |
grantc | no problem | 05:54 |
* grantc wanders off to sort out lunch | 05:54 | |
* grantc is away: wanders off | 05:55 | |
Mud | [14:41:52] <paulm05> is it like a tablespace - fixed size? << I guess so | 05:56 |
Mud | [14:40:47] <atrofast> Wow that sounds clunky << clunky? | 05:56 |
atrofast | Awkward, hard to use etc? | 05:58 |
Mud | well | 06:00 |
Mud | I know how to start and a stop a Postgress DB | 06:00 |
Mud | thats al xD | 06:00 |
*** zxiiro has joined #ingres | 06:27 | |
*** ChanServ sets mode: +v zxiiro | 06:27 | |
*** siman01 has joined #ingres | 06:46 | |
*** toumi01 has joined #ingres | 06:46 | |
*** DarylM has joined #ingres | 06:47 | |
*** mull has joined #ingres | 06:51 | |
siman01 | one of my friends has an embarrising problem with the windows alfresco bundle - the bundles copy of ingres can't be removed, when ever he tries it is silently reinstalled - I've never seen anything like it - anyone got any ideas | 06:51 |
paulm05 | any particular error or message? | 06:52 |
siman01 | no errors - about 20 seconds after deleting the ingres directory an msi starts up and reinstalls it, it is not interactive but does flash a window on the screen very briefly | 06:54 |
siman01 | hes uninstalled the alfresco bundle from control pannel - that stays uninstalled - but ingres keeps coming back | 06:56 |
siman01 | its pretty funny | 06:56 |
paulm05 | that's bizarre | 06:57 |
paulm05 | never heard of magically re-installing software before | 06:57 |
siman01 | i've suggested he searches his drives for an msi over 40megs - but I've no idea what it kicking the install off - there must be some kind of watchdog on the directory | 07:02 |
paulm05 | is it the whole of Ingres or just a component? I know Windows has a method of replacing missing system DLLs - if it's re-installing the .Net component or ODBC driver it could be that I suppose | 07:03 |
siman01 | its a full reinstall of ingres, which was bundled with alfresco - alfresco has been uninstalled | 07:06 |
paulm05 | don't know the alfresco bundle well enough - check the event log for clues perhaps? | 07:10 |
grantc | siman01, i've had this problem with 9.1.1 | 07:34 |
siman01 | he found the msi and a cad file in the temp directory of the user ("alfresco") he used to install the bundle | 07:34 |
grantc | i caused it to occur by moving II_SYSTEM and something happened to see me do it and i had the cycle of Windows Installer Dialog boxes you see | 07:35 |
siman01 | deleted those - now the phantom installer is stuck in an infinite loop of complaining it can't find the file then retrying | 07:35 |
siman01 | how did you get rid? | 07:35 |
grantc | i think i re-installed Ingres | 07:35 |
siman01 | I'd like to know what the "somethings" is | 07:36 |
paulm05 | is there still an Ingres Service trying to start? | 07:38 |
siman01 | nope | 07:38 |
*** Traveler4 has joined #ingres | 07:47 | |
Traveler4 | hi, I was wondering what common practice is for designing a web database with administrators if you're not using a framework | 07:48 |
*** atrofast has quit IRC | 07:50 | |
paulm05 | siman01: how is he uninstalling? is he using Windows Add/Remove or is he running the Ingres Uninstall menu item? or some other method? | 07:58 |
*** Alex| has quit IRC | 08:03 | |
*** atrofast has joined #ingres | 08:03 | |
*** ccsidiot has joined #ingres | 08:05 | |
siman01 | paulm05: there is no add/remove item and there was no uninstall option in the start menu, the hundled installer seems to be different from the normal windows installer | 08:07 |
paulm05 | OK | 08:09 |
paulm05 | I had asked my colleague if he'd ever seen anything like it and that was what he asked. Also since Grant has seen similar behaviour with 9.1.1 that suggests it's not a bundle problem per se | 08:10 |
grantc | paulm05, what's the best way to re-use a checkpoint on another machine (assume offline and the secondary machine is setup with the same locations) | 08:14 |
grantc | ? | 08:14 |
paulm05 | copy it over and rollforward? | 08:17 |
*** FrankW has quit IRC | 08:18 | |
paulm05 | main thing is to have the same locations, in the same order, as the source | 08:19 |
grantc | and the cnf files? | 08:22 |
grantc | file copied to data + dmp? | 08:23 |
paulm05 | ok - you need the cnf file from root data | 08:23 |
*** FrankW has joined #ingres | 08:23 | |
paulm05 | you need the aaaaaaaa.cnf from dmp, and the cXXXXXXX.dmp if you're not copying the most recent ckp | 08:24 |
paulm05 | rollforwarddb '#cN' mydb looks for the c00000N.dmp file rather than aaaaaaaa.cnf | 08:25 |
*** Traveler4 has quit IRC | 08:27 | |
grantc | hmm ok | 08:28 |
*** ccsidiot_ has joined #ingres | 08:38 | |
ccsidiot_ | Hi guys, I'm currently working my way to compile Geospatial, at the stage of getting the libraries for mapserver | 08:45 |
ccsidiot_ | there's a flag described http://community.ingres.com/wiki/GeoDemoLinuxSetup namely regex | 08:45 |
ccsidiot_ | is that also something that I need to get? | 08:46 |
ccsidiot_ | I'm following this document about mapserver and it's not on the list of libraries http://mapserver.org/installation/unix.html#libgd | 08:46 |
atrofast | ccsidiot_ You don't need to compile mapserver to make Ingres compile, you only need GEOS | 08:50 |
ccsidiot_ | Oh, not even gdal? | 08:50 |
atrofast | That wiki is about setting up a mapserver demo running on Ingres but parts of it apply to just compiling Ingres | 08:51 |
atrofast | Not really no | 08:51 |
ccsidiot_ | Oh :( | 08:51 |
ccsidiot_ | Thanks for letting me know before I go further | 08:51 |
ccsidiot_ | :) | 08:52 |
ccsidiot_ | So I have GEOS, and then I can go runbuild.sh? | 08:52 |
*** ccsidiot has quit IRC | 08:52 | |
*** ccsidiot_ has left #ingres | 08:53 | |
*** ccsidiot_ has joined #ingres | 08:54 | |
*** Mud|afk has joined #ingres | 09:00 | |
*** Mud has quit IRC | 09:00 | |
*** Mud|afk is now known as Mud | 09:00 | |
grantc | paulm05, it would appear you need the dmp files and lst file in dmp to recover an offline ckp | 09:03 |
paulm05 | d*dmp? | 09:04 |
grantc | c0000005.dmp | 09:05 |
*** siman01 has quit IRC | 09:05 | |
paulm05 | ok | 09:05 |
ccsidiot_ | I'm lost in how to build code | 09:06 |
paulm05 | 5 is the latest ckp yes? | 09:06 |
grantc | yip | 09:08 |
paulm05 | that makes sense | 09:09 |
grantc | i assumed that dmp was not needed for an offline rollfwd | 09:10 |
paulm05 | me too - but thinking about it, things could have changed. aaaaaaaa.cnf will be the 'up-to-date' cnf file, c000000N.dmp is the copy as of the time of ckp #N, in theory you could have added or removed locations to the database in the meantime | 09:13 |
paulm05 | my guess is it will check cnf, find the most recent ckpy # and get that dmp file | 09:13 |
paulm05 | In the past I've copied the cnf file to the relevant dmp to make it work I think. So long as there's no journals or dump files involved it shouldn't matter | 09:14 |
grantc | with 9.2 it appears to be needed | 09:18 |
paulm05 | yes | 09:20 |
paulm05 | I don't think that's changed | 09:20 |
paulm05 | I just forgot ;) | 09:20 |
grantc | in that case it's been a long time since i've hacked cnf files and moved ckp files about | 09:23 |
grantc | Ingres 2.0 perhaps? | 09:23 |
paulm05 | maybe | 09:25 |
paulm05 | if I'm right about it being to do with adding/removing locations it might be when extenddb was added (2.5?) | 09:26 |
ccsidiot_ | I have my environment variables set like this: http://ingres.pastebin.com/m3d2190a2 and I have my GEOS make and installed, but I'm getting this error log for my runbuild.sh, which is the same of what I get before the installing of GEOS, is that because the runbuild.sh does not recognise the path to GEOS? | 09:27 |
ccsidiot_ | http://ingres.pastebin.com/m53e37423 | 09:27 |
paulm05 | looks like you're missing Xerces and geos_c - not sure about the later but you ought be able to get the former from your distro's package repository | 09:30 |
paulm05 | I've never built the Geospatial version but looking at http://community.ingres.com/wiki/BuildingIngresGeospatial it seems you need to install the Geos library first | 09:33 |
atrofast | ccsidiot_: You need to export LD_LIBRARY_PATH=/path/to/geos/libs:$LD_LIBRARY_PATH | 09:33 |
atrofast | Also the runbuild.sh script doesn't seem to pick up that you have libxerces 2.7 | 09:34 |
ccsidiot_ | I already installed the GEOS libraries | 09:34 |
atrofast | Since you don't have root access you have ot set the LD_LIBRARY_PATH | 09:35 |
ccsidiot_ | Okay, let me try | 09:35 |
atrofast | ccsidiot_: Also you might have to edit buildtools/set_env.sh at the very end of the file add export XERCVERS=27 (this might work) | 09:41 |
ccsidiot_ | Looks like that the path for me set up by my sys admin is dynamic for every session that I log onto | 09:50 |
ccsidiot_ | :( | 09:50 |
ccsidiot_ | Hummmmm, let me talk to him about this, thanks :) | 09:50 |
ccsidiot_ | He installed xerces/jam and those things for me | 09:51 |
*** clach04 has joined #ingres | 09:57 | |
ccsidiot_ | I'm trying to see if I configured GEOS correctly, at this line "Add this folder to your ldconfig if it's not already there:", where do I add that folder to? | 09:59 |
ccsidiot_ | http://community.ingres.com/wiki/BuildingIngresGeospatial | 09:59 |
paulm05 | that was the part you'd need to be root to do, so I think you need to add it to LD_LIBRARY_PATH instead (see above) | 10:05 |
ccsidiot_ | so does what does non-root user do? | 10:08 |
ccsidiot_ | I'm not sure that (Must be root) means stuffs done below or above | 10:10 |
ccsidiot_ | must be root user | 10:10 |
paulm05 | "<atrofast> ccsidiot_: You need to export LD_LIBRARY_PATH=/path/to/geos/libs:$LD_LIBRARY_PATH" | 10:13 |
ccsidiot_ | Oh, that's all? | 10:15 |
ccsidiot_ | If that is, then I've already done | 10:15 |
ccsidiot_ | And ran the runbuild.sh, | 10:16 |
paulm05 | do you still get errors? | 10:16 |
ccsidiot_ | Yes | 10:16 |
paulm05 | the same errors? | 10:17 |
atrofast | ccsidiot_: Try adding it to the end of buildtools/set_env.sh instead I can't remember if all environment variables are passed/kept properly | 10:18 |
atrofast | Along with the export XERCVERS=27 | 10:18 |
ccsidiot_ | The xerces are still there, http://ingres.pastebin.com/d2bfa63c0 | 10:20 |
ccsidiot_ | The geos seems gone | 10:20 |
ccsidiot_ | :) | 10:20 |
paulm05 | what version of Xerces do you have installed? do you know? I think it's more likely that you *don't* have 2.7 and that's why you're getting that error. | 10:22 |
atrofast | paulm05: Good point sorry about that | 10:22 |
ccsidiot_ | Yea, right! My sysadmin set up 2.8 instead of 2.7 for me | 10:24 |
paulm05 | try setting XERCVERS=28 | 10:24 |
atrofast | Yes but you might have to do it in set_env.sh I ran into the set_env.sh script overwriting my XERCVERS set in the enviornment | 10:25 |
ccsidiot_ | Sweet, let me try | 10:25 |
paulm05 | although - I think it can get reset - I recall changing $ING_SRC/tools/port/jam/bldenv - the line "xvers=27" when I wanted to use a later version | 10:26 |
paulm05 | although if you update your source tree that will get overwritten so be careful :) | 10:26 |
ccsidiot_ | Yay! Progress! Only 1 failed target | 10:31 |
paulm05 | what was that? | 10:32 |
ccsidiot_ | http://ingres.pastebin.com/m9b62249 | 10:32 |
ccsidiot_ | and besides, what's buildrel? | 10:33 |
paulm05 | buildrel packages the release, and checks it | 10:34 |
paulm05 | it's still failing to find geos_c - see line 272 | 10:35 |
ccsidiot_ | Oh yea, I missed that :( | 10:36 |
paulm05 | did you set LD_LIBRARY_PATH on the command line or did you put it in set_env.sh? I think if you tried the first you might need to try the second | 10:37 |
ccsidiot_ | I put that in set_env.sh | 10:37 |
paulm05 | do you have a libgeos_c file somewhere? in /usr/local/lib perhaps? | 10:39 |
paulm05 | something like libgeos_c.1.so I mean | 10:40 |
ccsidiot_ | Nope | 10:41 |
ccsidiot_ | I'm compiling this on school's server | 10:41 |
ccsidiot_ | doesn't have usr/local/lib | 10:41 |
paulm05 | so where did Geos get installed to? | 10:41 |
ccsidiot_ | but I ran a find for every accessible directories, no | 10:41 |
ccsidiot_ | It installed /data/g7iwwong/geos-3.2.0rc1/ | 10:42 |
paulm05 | so there should be a libgeos_c file somewhere under there? or not? | 10:44 |
atrofast | ccsidiot_: Is that were the libgeos_c.so something libs are? | 10:44 |
atrofast | Heh | 10:44 |
ccsidiot_ | Oh, there's no underscore | 10:45 |
ccsidiot_ | Oh right, | 10:45 |
ccsidiot_ | there is | 10:45 |
ccsidiot_ | @@ Typo | 10:45 |
ii_log` | ccsidiot_: Error: "@" is not a valid command. | 10:45 |
ccsidiot_ | It's under lib of geos | 10:45 |
atrofast | Okay and you made LD_LIBRARY_PATH point to that directory? | 10:46 |
ccsidiot_ | I have this line in the end of set_env export $LD_LIBRARY_PATH=/data/g7iwwong/geos-3.2.0rc1/libs:$LD_LIBRARY_PATH | 10:47 |
paulm05 | should that be just "lib" not "libs"? | 10:47 |
ccsidiot_ | I changed that and ran runbuild.sh again | 10:49 |
ccsidiot_ | error :( | 10:49 |
paulm05 | :( | 10:49 |
paulm05 | oh - the first $ shouldn't be on the LD_LIBRARY_PATH | 10:50 |
paulm05 | you want: export LD_LIBRARY_PATH=/data/g7iwwong/geos-3.2.0rc1/lib:$LD_LIBRARY_PATH | 10:51 |
ccsidiot_ | I have that | 10:51 |
ccsidiot_ | ran runbuild | 10:51 |
ccsidiot_ | error :( | 10:51 |
paulm05 | same error? | 10:51 |
ccsidiot_ | Yes | 10:52 |
ccsidiot_ | cannot find -lgeos_c | 10:52 |
ccsidiot_ | in usr/Xllr6/bin/ld | 10:52 |
ccsidiot_ | Why is it still looking into usr/local/bin | 10:53 |
paulm05 | you definitely have "export LD_LIBRARY_PATH..." and not "export $LD_LIBRARY_PATH..."? | 10:53 |
ccsidiot_ | Yes | 10:53 |
paulm05 | ok - sorry - just double-checking | 10:53 |
ccsidiot_ | :) It's okay, this is weird | 10:53 |
ccsidiot_ | Is there a $ for the second LD_LIBRARY_PATH? | 10:55 |
ccsidiot_ | for the export? | 10:55 |
paulm05 | must be getting unset somewhere | 10:55 |
ccsidiot_ | :( I'll be back 4pm, class from 2-4 :( | 10:56 |
ccsidiot_ | I'll be going in 5 minutes :( | 10:56 |
paulm05 | yes - basically you're setting the variable LD_LIBRARY_PATH to a value with the current value of LD_LIBRARY_PATH (i.e. $LD_LIBRARY_PATH) on the end | 10:56 |
ccsidiot_ | Yea, it will be weird if the 2nd LD_LIBRARY_PATH does not have $ | 10:56 |
ccsidiot_ | Hum.... | 10:56 |
paulm05 | you could just hack bldenv again and stick it in there - that would at least get you going | 10:57 |
ccsidiot_ | Okay, I'll try, thanks paulm05, atrofast :), I'll let you guys know if that works later | 10:58 |
paulm05 | ok - I'll be going home soon - might check in later | 10:59 |
ccsidiot_ | :) | 11:00 |
*** ccsidiot_ has left #ingres | 11:00 | |
*** Mud is now known as Mud|afk | 11:00 | |
*** paulm05 has quit IRC | 11:01 | |
*** grantc has quit IRC | 11:14 | |
*** atrofast has left #ingres | 11:40 | |
*** Mud|afk has quit IRC | 11:46 | |
*** cthibert has left #ingres | 12:10 | |
*** DerMeister has joined #ingres | 12:12 | |
*** Mud has joined #ingres | 12:12 | |
*** Alex| has joined #ingres | 12:27 | |
*** ChanServ sets mode: +o Alex| | 12:27 | |
*** ccsidiot has joined #ingres | 13:02 | |
*** atrofast has joined #ingres | 13:07 | |
ccsidiot | Hey | 13:15 |
ccsidiot | I have included this exact line "export LD_LIBRARY_PATH=/data/g7iwwong/geos-3.2.0rc1/lib:$LD_LIBRARY_PATH" in both set_env and bldenv, and gives me the same error "/usr/X11R6/bin/ld: cannot find -lgeos_c" | 13:17 |
ccsidiot | Does the variable LD_LIBRARY_PATH also reset somewhere else? | 13:18 |
*** Alex| has quit IRC | 13:35 | |
*** Mud has quit IRC | 13:38 | |
*** DerMeister has quit IRC | 14:01 | |
*** PaulM05 has joined #ingres | 14:02 | |
*** PaulM05 has left #ingres | 14:04 | |
*** zxiiro has quit IRC | 14:06 | |
*** ccsidiot has quit IRC | 14:28 | |
*** ccsidiot_ has joined #ingres | 14:29 | |
*** ccsidiot_ has left #ingres | 14:45 | |
*** toumi01 has left #ingres | 14:47 | |
*** zxiiro has joined #ingres | 14:56 | |
*** ChanServ sets mode: +v zxiiro | 14:56 | |
*** mull has quit IRC | 15:43 | |
*** atrofast has quit IRC | 16:17 | |
*** atrofast has joined #ingres | 16:18 | |
*** rossand has quit IRC | 16:40 | |
*** atrofast has quit IRC | 17:23 | |
*** atrofast1 has joined #ingres | 17:24 | |
*** atrofast1 has quit IRC | 17:28 | |
*** atrofast has joined #ingres | 17:29 | |
*** atrofast has quit IRC | 17:37 | |
*** mull has joined #ingres | 17:40 | |
*** SaraDanaher has joined #ingres | 17:43 | |
SaraDanaher | hi every one, | 17:43 |
*** ccsidiot has joined #ingres | 19:13 | |
ccsidiot | Hey everyone, I'm running the runbuild.sh checked out from geospatial repo with the following line added at the end of the runbuild.sh : echo $LD_LIBRARY_PATH | 19:19 |
ccsidiot | It gives me /data/g7iwwong/geos-3.2.0rc1/lib:/data/g7iwwong/geos-3.2.0rc1/lib:/lib:/usr/lib:/usr/local/lib:/data/g7iwwong/geospatial/build/lib:/data/g7iwwong/geospatial/build/lib/lp32 | 19:20 |
ccsidiot | which means that the path is not reset as the runbuild.sh is ran | 19:21 |
FrankW | ccsidiot: are you on a 64bit system? Or 32bit? | 19:21 |
ccsidiot | 32 bit | 19:21 |
ccsidiot | FrankW: Oh it does matter? | 19:21 |
ccsidiot | Wait | 19:22 |
FrankW | I had some particular problems linking against geos on 64bit linux in my ingres build. | 19:22 |
FrankW | I was wondering if you might be encountering similar problems. | 19:22 |
ccsidiot | I'm sshing from a 32 bit machine to a server at school | 19:22 |
ccsidiot | How can I check in this case? | 19:22 |
FrankW | cat /proc/cpuinfo | 19:22 |
FrankW | should give a clue. | 19:23 |
ccsidiot | It says clflush size:64 | 19:23 |
FrankW | What is the "model name"? | 19:23 |
ccsidiot | It's Intel(R) Pentium(R) 4 CPU 2.80GHz | 19:24 |
FrankW | I have one 32bit linux system handy and it report clflush size of 32, so I suspect your server is 64bit. | 19:24 |
ccsidiot | Oh :( | 19:25 |
FrankW | the problem I encountered in my build was that *parts* of the ingres build still required 32bit libraries, so I had to have 32bit and 64bit versions available. | 19:25 |
*** cytrinox_ has joined #ingres | 19:25 | |
FrankW | It was a significant hassle. :-( | 19:25 |
FrankW | I assume you don't have much latitude with regard to what system to operate on? | 19:26 |
ccsidiot | rossand and a couple of others suggest me to runbuild.sh on Linux since there's only 1 month left for me to go and the only machine that I have is on Windows | 19:27 |
ccsidiot | and figuring out stuffs on Windows apparently took Alex a week | 19:27 |
FrankW | it has been my understanding that building on windows is a black art. | 19:28 |
FrankW | 64bit linux is unfortunately also somewhat harder than 32bit, at least for the geospatial builds. | 19:28 |
FrankW | If you would like, I could try and do a clean build on my 64bit system and we could try to work through the problems together. | 19:28 |
ccsidiot | FrankW: That'd be really helpful :) | 19:30 |
FrankW | Hmm, my ingres skills are already rather rusty a couple months after my last (and first) build. | 19:31 |
ccsidiot | I'm new to Ingres, I'm sure you know more than I do | 19:31 |
ccsidiot | :) | 19:32 |
FrankW | I have an old snapshot of http://code.ingres.com/ingres/branches/geospatial but I recall Chuck mentioning I ought to do a clean checkout before building again. | 19:32 |
FrankW | I'll start that extract - it will take me a while over my satellite link. | 19:32 |
FrankW | I assume you are the Ms. Wong I was emailing with on the weekend? Or perhaps a fellow student? | 19:33 |
ccsidiot | Yes, I'm :) | 19:33 |
FrankW | I've been impressed with your organizational ambition on the mailing list. | 19:33 |
ccsidiot | Thanks for your replies, double thanks to do that on a weekend | 19:33 |
ccsidiot | Thanks, since I really want to get started! | 19:34 |
ccsidiot | Like really really to see how stuffs works | 19:34 |
FrankW | What is your role on the project? I've only a relatively vague idea of what you folks are up to despite a briefing by Andrew. | 19:34 |
ccsidiot | My role is just a normal team member among all, what we are supposed to archieve by the end of the term 2009-Dec-11 is described here: http://ucosp.wordpress.com/2009/10/31/ingres-geospatial-students-grading-scheme/ | 19:36 |
*** cytrinox has quit IRC | 19:37 | |
*** cytrinox_ is now known as cytrinox | 19:37 | |
ccsidiot | but I've requested from my uni(UofT) that I want to come back to Ingres for my project course next term | 19:37 |
FrankW | "Goal(s): Improve robustness and error path checking." | 19:38 |
FrankW | Is that within the new geospatial code? | 19:38 |
ccsidiot | Yes, within geospatial | 19:38 |
FrankW | Cool | 19:38 |
FrankW | svn checkout plugging away... | 19:40 |
ccsidiot | let me do a clean checkout too then :) | 19:42 |
FrankW | Have you considered working in a linux VM on your laptop? Perhaps it has only a modest amount of memory? | 19:42 |
ccsidiot | That was op-ed out since my laptop is > 5 years old with very little RAM(1GB), running a VM on this is not good. I also thought of dual boot, but I'm living on this machine for my other courses too, so don't want to mess around it at this time of the term | 19:45 |
FrankW | gotcha, I think your evaluation is correct. | 19:45 |
ccsidiot | Andrew and a couple of others also suggested 1 week ago that if I happened couldn't get the quota from school, then they'll see what can they get for me, I got the 4GB quota from school and I thought that I'm fine, but now :( | 19:47 |
FrankW | In a pinch I can provide you an account on 32bit server I lease in Montreal, assuming the latency would not make it unpleasant for your use. | 19:48 |
ccsidiot | Oh that's going to save my life :) Thanks so much FrankW!! | 19:50 |
FrankW | I see my old build tree disk usage is: | 19:51 |
FrankW | 3299740 server_old/ | 19:51 |
FrankW | 3.3GB just to checkout and build does not bode terribly well on a 4GB quota. | 19:52 |
ccsidiot | I'll just use that for Gepspatial. I only have 4GB quota at school I think it's gonna be the same if ever 64 bit might work | 19:53 |
ccsidiot | :) | 19:53 |
FrankW | Did you change anything before running "runbuild.sh"? | 19:59 |
ccsidiot | Nope, other than that echo statement in the end | 19:59 |
FrankW | How did you install GEOS? | 20:00 |
ccsidiot | I downloaded it, ./configure --prefix='data/blah/geos-3.2.0rc1', then make, then make install | 20:00 |
FrankW | How were you hoping ingres would find that geos? | 20:01 |
FrankW | I'm seeing: | 20:01 |
FrankW | Link /wrk/home/warmerda/ingres/server/tools/bin/lp32/salign | 20:01 |
FrankW | /usr/bin/ld: skipping incompatible /usr/local/lib/libgeos_c.so when searching for -lgeos_c | 20:01 |
FrankW | /usr/bin/ld: skipping incompatible /usr/local/lib/libgeos_c.a when searching for -lgeos_c | 20:01 |
FrankW | /usr/bin/ld: cannot find -lgeos_c | 20:01 |
FrankW | in my log file after a first failed build. | 20:01 |
FrankW | Is this similar to what you see? | 20:01 |
ccsidiot | Yes, my build can't find GEOS like this | 20:03 |
ccsidiot | Link /data/g7iwwong/geospatial/build/bin/ercompile | 20:03 |
ccsidiot | =>/usr/X11R6/bin/ld: cannot find -lgeos_c | 20:03 |
ccsidiot | and the libgeos_c.so are lying in the directory | 20:04 |
FrankW | Lying in what directory? | 20:04 |
FrankW | I assume you installed geos into a directory on your local account. How was ingres supposed to find it there? | 20:05 |
ccsidiot | Oh right! The geos-3.2.0rc1 :) | 20:05 |
ccsidiot | Argh, how can I overlook this | 20:05 |
ccsidiot | Let me try changing the path | 20:06 |
FrankW | My system ld.so.conf setup looks in /usr/local/lib so I'm finding the 64bit version but at a point where 32bit tools are being built. | 20:06 |
FrankW | Hence the messages. | 20:07 |
ccsidiot | wait... I have this in the path export LD_LIBRARY_PATH=/data/g7iwwong/geos-3.2.0rc1/lib:$LD_LIBRARY_PATH | 20:07 |
FrankW | I haven't quite worked out how we are expected to tell the ingres build where stuff is if it is not in a system directory. | 20:07 |
ccsidiot | :( | 20:07 |
ccsidiot | which is where the libgeos_c.so stuffs are | 20:07 |
FrankW | I do not believe that LD_LIBRARY_PATH affects linking with ld, it only affects finding the .so files at runtime. | 20:07 |
ccsidiot | Sigh | 20:07 |
FrankW | I kind of hoped that buildtools/setenv.sh would be a good place to configure special needs but it doesn't seem to be. | 20:08 |
ccsidiot | I also add that same line to bldevn | 20:09 |
ccsidiot | *bldenv | 20:09 |
FrankW | gotcha, src/tools/port/jam/bldenv | 20:10 |
ccsidiot | which apparently also modify the same variable, just in case that it got reset | 20:10 |
FrankW | Hmm, no mention of geos in that file. | 20:10 |
FrankW | I vaguely recall having to change something else last time. | 20:11 |
FrankW | I should have taken notes. | 20:11 |
FrankW | we really need somewhere we can set -L linker directives. | 20:12 |
FrankW | But I don't think bldenv is that place. | 20:12 |
ccsidiot | No problem :), does it help if I try to do grep -iR LD_LIBRARY_PATH in all files where I checked out the geospatial code? That's what I ran before I headed off to class from 6-9pm | 20:13 |
FrankW | I was grepping on geos to find where the link directive is. | 20:13 |
ccsidiot | Cool :) | 20:13 |
FrankW | I do not believe LD_LIBRARY_PATH is directly related to link time. | 20:13 |
FrankW | unfortunately I soon hit: | 20:14 |
FrankW | warmerda@gdal64[63]% grep geos */*/*/* | 20:14 |
ccsidiot | Hummmm.. | 20:16 |
FrankW | ccsidiot: http://lists.ingres.com/pipermail/gis-users/2009-August/000162.html | 20:18 |
*** SaraDanaher has quit IRC | 20:19 | |
FrankW | It does not appear all the files are in the same places. Grr. | 20:19 |
FrankW | src/tools/port/shell_unix/mkdefault.sh seems to be the new location. | 20:22 |
FrankW | Hmm, my change in mkdefault.sh does not seem to be helping. I suspect I need to do some sort of clean process before rerunning runbuild.sh | 20:28 |
FrankW | But I'm not sure what. | 20:28 |
FrankW | Ah, runbuild.sh clean | 20:30 |
FrankW | Not so tricky after all. | 20:30 |
ccsidiot | Oh :) | 20:31 |
FrankW | It is still issuing the command: | 20:32 |
FrankW | cc -m32 -rdynamic -Wl,-rpath,'$ORIGIN/../../lib/lp32' -lpthread -lrt -lm -lc -lcrypt -ldl -lgcc_s -lgeos_c -o /wrk/home/warmerda/ingres/server/tools/bin/lp32/salign /wrk/home/warmerda/ingres/server/src/tools/port/eval_unix_vms/lp32/salign.o | 20:32 |
FrankW | While I have manually modified mkdefault.sh to insert a -L ahead of the -lgeos_c | 20:32 |
FrankW | So I'm missing something here. | 20:32 |
FrankW | src/tools/port/jam/Jamdefs.hyb86_lnx seems to be the file on my system. | 20:35 |
FrankW | Do you have that on your 64bit server? Does it have geos_c in it? | 20:36 |
FrankW | I changed the LDLIBMACH32 line to: | 20:36 |
ccsidiot | I'm trying to follow | 20:36 |
FrankW | LDLIBMACH32 = -lpthread -lrt -lm -lc -lcrypt -ldl -lgcc_s -L/usr/local/32bit/lib -lgeos_c ; | 20:36 |
ccsidiot | If I have not misunderstood, so the cc -m32 blah is the configurations for 32 bit | 20:37 |
FrankW | That was the command actually used to try and link one of the 32bit executables as it appeared in the build log after failure. | 20:38 |
FrankW | Looking at it I could see no -L directive appeared before the -lgeos_c, though I had hoped it would. | 20:38 |
FrankW | I seem to be getting further now... | 20:39 |
ccsidiot | Oh I see, so let me change the line on LDLIBMACH32 | 20:39 |
FrankW | You will presumably need to modify both LDLIBMACH32 and LDLIBMACH64 since both your versions will be in non-standard places. | 20:40 |
FrankW | I'll bundle up my 32bit geos since it will not be that easy for you to build on 64bit system. | 20:40 |
ccsidiot | Oh I see | 20:41 |
FrankW | http://home.gdal.org/tmp/32bit-geos.tar.gz should have it. | 20:43 |
ccsidiot | Oh I thought building geospatial is only picking up GEOS only, but not GDAL and mapserver | 20:44 |
ccsidiot | or am I wrong? | 20:44 |
FrankW | building geospatial does not depend on gdal or mapserver. | 20:44 |
FrankW | But home.gdal.org is my personal web server. | 20:44 |
ccsidiot | Oh, I see :) | 20:44 |
FrankW | I have had to do: | 20:55 |
ccsidiot | Hum, the package that I got from home.gdal.org/blah does not have makefile :( | 20:55 |
ccsidiot | or configure | 20:55 |
FrankW | mkdir src/front/embed/csq/lp32 src/front/embed/c/lp32 | 20:55 |
FrankW | ccsidiot: it is prebuilt 32bit binaries. | 20:55 |
FrankW | Just unpack it and put it somewhere you can reference with a -L directive before the geos_c link. | 20:55 |
FrankW | I suppose there will be some issue for you with finding include files as well as the libraries. | 20:56 |
FrankW | So the LDLIBMACH32 changes may not be enough. | 20:56 |
ccsidiot | So does that meant to work with only 32 or 64? | 20:56 |
FrankW | The .tar.gz file I provided is just the 32bit, but you can use your own build for the 64bit. | 20:57 |
FrankW | I provided it because it can be tricky to build geos in 32bit mode on a 64bit system. | 20:57 |
ccsidiot | Yea, true | 20:57 |
*** mull has quit IRC | 21:04 | |
*** Alex| has joined #ingres | 22:26 | |
*** ChanServ sets mode: +o Alex| | 22:26 | |
*** ccsidiot has left #ingres | 22:52 | |
*** Alex| has quit IRC | 23:01 | |
*** Gerhard has joined #ingres | 23:19 | |
Gerhard | Hi all | 23:24 |
pboro | Hi Gerhard | 23:24 |
*** grantc has joined #ingres | 23:35 | |
*** ChanServ sets mode: +o grantc | 23:35 | |
*** sbishop411_ has joined #ingres | 23:59 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!