| *** gerhard has joined #ingres | 00:03 | |
| gerhard | Morning all | 00:05 |
|---|---|---|
| pboro | 'ning | 00:06 |
| *** grantc has joined #ingres | 00:28 | |
| *** Mud has quit IRC | 01:01 | |
| *** KermitTheFragger has joined #ingres | 01:02 | |
| *** Mud has joined #ingres | 01:09 | |
| *** grantc has quit IRC | 01:28 | |
| *** grantc has joined #ingres | 01:31 | |
| *** Dejan has joined #ingres | 01:39 | |
| Dejan | good morning | 01:40 |
| grantc | morning Dejan | 01:40 |
| *** Mud has quit IRC | 01:43 | |
| *** Mud has joined #ingres | 01:45 | |
| *** Mud has quit IRC | 02:28 | |
| *** Mud has joined #ingres | 02:34 | |
| *** maida01 has joined #ingres | 02:44 | |
| *** gerhard has quit IRC | 02:45 | |
| *** maida01 has quit IRC | 02:55 | |
| *** maida01 has joined #ingres | 02:55 | |
| *** maida01 has quit IRC | 02:57 | |
| *** jundi has joined #ingres | 02:57 | |
| jundi | hello guys. | 02:58 |
| jundi | i am new to both linux and ingres. i have installed a linux openSuse 10.3 on my laptop using using VirtualBox and installed ingres 9.2.1 on that image. i have installed the client application on my windows machine (the virtualbox HOST machine) and now i am trying to connect to the ingres db on the linux machine (the virtualbox GUEST machine)... | 03:01 |
| jundi | i can ping from the linux vm to the windows box and vice versa.. but the vnode wouldn't connect | 03:02 |
| jundi | the errlog.log file shows the following message (on the client machine) | 03:03 |
| jundi | 2010 E_GC2809_NTWK_CONNECTION_FAILNetwork connection failed for protocol TCP_IP, to node 128.127.0.32, port II; status follows. JUNDI-PC ::[I2\COMSVR\17d4 , 6100 , 00000002]: Tue May 04 08:52:03 2010 E_CL2781_GC_CONNECT_FAILAn attempted network connection failed | 03:03 |
| jundi | connect() failed with operating system error 1225 (The remote computer refused the network connection.) | 03:04 |
| jundi | am i making any sense? :) | 03:04 |
| grantc | do you have the SuSE firewall running? | 03:05 |
| jundi | how do i know that? | 03:05 |
| grantc | sudo iptables -L | 03:06 |
| grantc | paste any output to http://ingres.pastebin.com | 03:06 |
| jundi | ingres.pastebin.com/Yybzaacx | 03:11 |
| jundi | sorry http://ingres.pastebin.com/Yybzaacx | 03:12 |
| grantc | the firewall is enabled - either you need to shutdown the firewall using "rcSuSEfirewall stop" or open up the relevant ports | 03:17 |
| jundi | rcSuSEfirewall: command not found.... :( | 03:23 |
| jundi | can i access the firewall settings from yast? | 03:23 |
| grantc | yup - yast firewall | 03:24 |
| grantc | i guess i misspelt the script name | 03:24 |
| grantc | it's been a while since i've used suse | 03:25 |
| jundi | its ok.. i have disabled the firewall now.. still not working but with a different error now: | 03:31 |
| jundi | connect() failed with operating system error 1225 (The remote computer refused the network connection.) | 03:32 |
| jundi | ooops | 03:32 |
| jundi | thats the same error... hold on | 03:32 |
| jundi | my bad.. its the same error | 03:32 |
| Dejan | or /sbin/service iptables stop | 03:33 |
| Dejan | i think that may work too | 03:33 |
| jundi | well.. the yast firewall worked.. i have stopped the fw | 03:33 |
| Dejan | but in general you should be able to disable firewall from yast | 03:33 |
| Dejan | i rarely use openSuSE too | 03:33 |
| jundi | i dont know if this could help... i have an installation pwd for the server machine.. and when using the in the netutil command i've put the following: | 03:37 |
| jundi | login = * | 03:37 |
| jundi | password = installation password | 03:37 |
| jundi | and in the client machine: | 03:37 |
| jundi | user name = ingres | 03:38 |
| jundi | password = ingres user passwrod | 03:38 |
| grantc | on the client you have to use the same as the server | 03:43 |
| jundi | ingres usr password is the same as installation password :) | 03:43 |
| grantc | that is login=* | 03:43 |
| grantc | i think... | 03:43 |
| jundi | now it is giving me two errors: | 03:48 |
| jundi | connect() failed with operating system error 1225 (The remote computer refused the network connection.) | 03:48 |
| jundi | Tue May 04 09:47:00 2010 E_GC0001_ASSOC_FAILAssociation failure: partner abruptly released association | 03:48 |
| grantc | do you still have the firewall enabled? | 03:48 |
| jundi | from yast firewall the status says Firewall is not running | 03:49 |
| jundi | but i disabled it from root... should i disable it from the ingres user .. or can i ? | 03:49 |
| grantc | no that's fine | 03:50 |
| jundi | i tried it any way.. cant be done :) | 03:50 |
| grantc | on the windows box can you "sql @server_ip,tcp_ip,ii[ingres,secret]::iidbdb" | 03:52 |
| grantc | change "server_ip" to the ip of your linux server, "ii" to the server installation code ( ingprenv II_INSTALLATION) and the "secret" password | 03:53 |
| *** cthibert has joined #ingres | 03:53 | |
| jundi | failed to connect to dbms server | 03:54 |
| jundi | :( | 03:54 |
| jundi | and in the errlog it says: | 03:55 |
| jundi | connect() failed with operating system error 1225 (The remote computer refused the network connection.) | 03:55 |
| jundi | i am able to ping between the two machines.. but i can NOT telnet | 03:57 |
| jundi | but thats because the telnet service is no installed on the linux machine.. | 03:57 |
| jundi | *is not installed | 03:58 |
| grantc | on the linux box what does "lsof -i | grep ingres" show? | 03:59 |
| jundi | http://ingres.pastebin.com/eFGywDYM | 04:02 |
| grantc | that looks ok... | 04:03 |
| grantc | and iptables -L has nothing in it? | 04:07 |
| jundi | nothing in there | 04:11 |
| grantc | on the server what does "ingprenv II_SHADOW_PWD" return? | 04:12 |
| jundi | it gives the path for the ingvalidpw file | 04:13 |
| grantc | what does ls -l of that file show? | 04:14 |
| jundi | the owner is root -- i cant copy and paste between the two machines :( so i am just trying to guess what you need to know | 04:17 |
| grantc | and the permissions on the file? | 04:19 |
| *** siman01 has joined #ingres | 04:19 | |
| grantc | can you ssh in from the windows box to the linux box? | 04:20 |
| jundi | http://ingres.pastebin.com/QmFKiVep | 04:22 |
| *** atrofast has joined #ingres | 04:22 | |
| grantc | and ssh? | 04:22 |
| jundi | the command is not found... i tried from linux to windows.. but it did not work | 04:25 |
| jundi | connection refused | 04:26 |
| grantc | windows to linux? try downloading putty | 04:26 |
| jundi | do you mean i should download putty on windows? | 04:28 |
| grantc | yup | 04:29 |
| jundi | damn it!! connection refused again.. | 04:30 |
| jundi | i have to say thank you grantc for your patience with me so far! | 04:30 |
| jundi | but i am learning a lot from this.. | 04:31 |
| grantc | i need to prepare lunch - i'll be back later | 04:32 |
| jundi | could it be because of me using virtualbox? i mean this mess could be caused by the way the two machines share the same network adapter (physically) | 04:32 |
| jundi | bon apetit :) | 04:32 |
| *** tripitaka has joined #ingres | 04:32 | |
| *** grantc is now known as grantc_away | 04:33 | |
| tripitaka | Hi, probable dumb question here, I'm trying to install 9.2 on a rhel5 x86_64 machine, I've selected a linux terminal and a package install, I have selected the components I want to install, but I cannot figure out how to proceed with the installation | 04:37 |
| tripitaka | I see 'Install (f5)', but when I press f5 it overwrites the yes/no option in the installation selection table | 04:37 |
| jundi | try the vt100f termcap.. when you're done choosing the components press f1 and type install | 04:43 |
| tripitaka | jundi: thanks, got it to work using vt100f and using the keypad as a selector | 05:06 |
| jundi | good luck mate :) | 05:09 |
| *** zxiiro has quit IRC | 05:17 | |
| Dejan | i use xterm in putty | 05:29 |
| *** rossand has joined #ingres | 05:42 | |
| *** ChanServ sets mode: +o rossand | 05:42 | |
| awatkins | hello, i'm trying to build the ruby driver for ingres, however, i'm using a mac running snow leopard, so wheni try to build against the normal 32-bit install, it fails. so i tried building hte 64 from source and am running into trouble | 05:56 |
| *** zxiiro has joined #ingres | 06:00 | |
| *** ChanServ sets mode: +v zxiiro | 06:00 | |
| awatkins | anyone? | 06:02 |
| Dejan | i can't help - wait for grantc to come back | 06:04 |
| Dejan | he is the developer :) | 06:04 |
| grantc_away | hi awatkins | 06:25 |
| *** grantc_away is now known as grantc | 06:25 | |
| awatkins | hi grantc | 06:25 |
| awatkins | i hear you're the guy to help with getting ingres to compile on a mac | 06:26 |
| grantc | can you paste the errors you are seeing into http://ingres.pastebin.com | 06:26 |
| grantc | i can try - i have a mac but it's 32 bit only | 06:26 |
| awatkins | cool, yeah, we'll give ti a whirl. one thing, is i had to compile xerces 3.1 or whatever because of the 32bit, 64 bit issues with 2.7 | 06:27 |
| siman01 | xerces :( | 06:27 |
| grantc | for ingres you mean - I used to have a build of ingres on my mac but it's not been updated in a while | 06:28 |
| grantc | i need to step away again for a bit, i should be back in 40 mins, if you have to disappear you can email me via grant . croker @ ingres . com | 06:29 |
| awatkins | ok | 06:29 |
| *** cthibert has left #ingres | 06:35 | |
| awatkins | ok, its up for when you get back | 06:36 |
| *** cthibert has joined #ingres | 06:37 | |
| *** mull has joined #ingres | 06:47 | |
| *** jundi has quit IRC | 06:54 | |
| awatkins | i guess for when you get back. a lot of my errors go away when changing ucontext.h to sys/ucontext.h as outlined here: | 07:09 |
| awatkins | http://duriansoftware.com/joe/PSA:-avoiding-the-%22ucontext-routines-are-deprecated%22-error-on-Mac-OS-X-Snow-Leopard.html | 07:09 |
| awatkins | not sure if this screws up anythign | 07:09 |
| grantc | DarylM, might know the answer as he's working on a port | 07:19 |
| DarylM | Hey, my chat icon just jumped on the dock..... :-D | 07:19 |
| awatkins | so my next issues seems to be with ranlib and libcompat.a | 07:19 |
| awatkins | loks like it can't compile ercompile | 07:20 |
| DarylM | Give me a sec, I remember doing something about ucontext but it has been a while. | 07:20 |
| awatkins | i just changed ucontext to sys/ucontext and it seemed to go ahead | 07:20 |
| grantc | DarylM do you have your code submitted or is it in a branch? | 07:20 |
| DarylM | No, I route all my changes through Jay | 07:21 |
| grantc | so they should be in main then? | 07:21 |
| DarylM | I think so. Let me check. "tm" is broken in the latest build. | 07:21 |
| awatkins | here's the latest pastie bin | 07:22 |
| awatkins | http://ingres.pastebin.com/fZ0V4Vb9 | 07:22 |
| Dejan | guys - do we have some "powered by" Ingres button, for webs | 07:23 |
| Dejan | like lighttpd: http://www.9nu.eu/ | 07:23 |
| Dejan | see that logo at the bottom of my 9nu.eu website | 07:23 |
| grantc | Dejan we used to but that was at the old firm | 07:23 |
| Dejan | i think it would be cool to have it for ingres | 07:24 |
| grantc | awatkins, i'm pulling headrevs and will try a build on 32-bit 10.6.3 | 07:25 |
| awatkins | grantc, ok, but the problem is that with the 32 built build, i can't get the ruby libraries to link properly | 07:26 |
| grantc | what errors do you see with that? | 07:27 |
| awatkins | let me see if i can pull them up again., though they stem mostly from my ruby be a 64bit build | 07:29 |
| DarylM | awatkins: In clsigs.h I wrapped the #include <ucontext.h> in a #ifndef OSX | 07:30 |
| DarylM | You don't need ucontext.h >at all< on SnowL. | 07:30 |
| DarylM | I apparently have not submitted that back (yet)...... | 07:30 |
| grantc | DarylM: tsk tsk | 07:31 |
| DarylM | :-) | 07:31 |
| grantc | perhaps it's worth you branching main so people can try out your changes? | 07:31 |
| awatkins | ah cool | 07:31 |
| awatkins | here's hte ruby error | 07:31 |
| awatkins | ld: warning: in /opt/Ingres/IngresII/ingres/lib/libq.1.dylib, file was built for i386 which is not the architecture being linked (x86_64) | 07:31 |
| grantc | ah the universal binary problem | 07:32 |
| DarylM | Oh my, that problem | 07:32 |
| awatkins | yeah, so i figured i'd bulid ingres from source to get around this | 07:32 |
| DarylM | Easy to fix on OS/X, ridiculously hard on AIX.... | 07:33 |
| grantc | awatkins: you can ignore it if you are only working with 32 bit | 07:33 |
| awatkins | really? cause i jsut nee dthe ruby driver to connect to our main db which is on a linux machine, which compiled fine | 07:34 |
| grantc | yup - i had this issue on 10.5 but then it was ppc vs i386 | 07:34 |
| DarylM | grantc: Branching for my stuff would be overkill since the changes do not represent a new feature set. I just need to be less sloppy and submit them (basically smaller fixes for now) into main | 07:34 |
| DarylM | All the 64 bit port stuff was already submitted. | 07:35 |
| awatkins | i'm not sure it'll work | 07:35 |
| awatkins | when i try to require Ingres i get LoadErrors | 07:35 |
| awatkins | http://ingres.pastebin.com/08xj2fCX | 07:36 |
| DarylM | I still have Mac Rudy/Ingres playtime on my to do list... | 07:36 |
| DarylM | Sadly, it is not really high on my list, but I am the local resource for all your Ingres/Mac porting needs :-D | 07:37 |
| grantc | awatkins, err that bug should have been fixed | 07:39 |
| grantc | _CM_Attrtab is an extern in one of the Ingres libs | 07:39 |
| DarylM | Interesting, I thought that was fixed. | 07:39 |
| awatkins | grantc thats linking against the 9.3 os x download, i couldn't find a 10.0 os x download anywhere | 07:39 |
| Dejan | what's OSX ? | 07:40 |
| Dejan | ^^ | 07:40 |
| DarylM | That is a good clarification grantc, I am using the SVN repository. | 07:40 |
| DarylM | Just the really cool BSD Unix system. | 07:40 |
| Vroomfondle | Dejan: Mac OS... | 07:40 |
| Dejan | never heard of it | 07:40 |
| Dejan | :P | 07:40 |
| DarylM | :P | 07:40 |
| awatkins | Dejan: a highly overrated... | 07:40 |
| * grantc dons his flame proof trousers | 07:41 | |
| DarylM | lol | 07:42 |
| DarylM | So, Dejan probably doesn't want to hear that I have a 3G iPad now....... | 07:42 |
| grantc | all i can say is it's a darn sight better than slowaris | 07:42 |
| * DarylM << Fanboy ........... | 07:42 | |
| Dejan | everything is better than slowaris | 07:43 |
| DarylM | Please, I am still in mourning over the recent history of Solaris...... It the old days it was such a nice system. | 07:43 |
| * DarylM Eeek, I just dated myself. | 07:44 | |
| DarylM | By the way, 9 times out of 10 when I have a new OS/X port issue, I just look at the Linux port code and add defined(DARWIN) to it. | 07:45 |
| awatkins | DarylIM: I'm not sure I follow | 07:46 |
| DarylM | From a porting point of view, OS/X an Linux are extremely close. | 07:47 |
| DarylM | So for example, some Xerces compatibility changes I made for Xerces 3.0 support matched the LInux version of the code. | 07:48 |
| awatkins | DarylIM: yeah, thats what I figured, so hence my kind of failed attempt to recompile under os x. but it sounds like hte port is another way to go? | 07:48 |
| awatkins | DarylIM: acutally I think its dawning on me. You're saying just download the linux port, and give that a whirl | 07:49 |
| rossand | DarylM: Cool. Did I miss the Xerces IP/code inspection? Is that in main at the moment? | 07:49 |
| DarylM | Mainline development is pretty swamped right now so there has not been a new Mac build for a while. | 07:49 |
| DarylM | No, you cannot run the LInux Ingres on OS/X | 07:50 |
| DarylM | I grabbed the SVN repository source and simply build it. | 07:50 |
| DarylM | I keep two versions, 32 bit and 64 bit. | 07:50 |
| DarylM | Personally, I think the 64 bit version works better, but I have no concrete testing evidence to prove that. | 07:51 |
| awatkins | DarylIM: are the instructions the same from building from svn, i.e. using jam, etc. or does it support the ./configure, make, make install | 07:51 |
| DarylM | I am of the opinion we should ditch the 32bit OS/X port entirely and just post the 64 bit. | 07:51 |
| DarylM | You have to follow the readme instructions in the source repository. | 07:51 |
| awatkins | ok | 07:52 |
| DarylM | It isn't the standard open source configure/make/make install cycle | 07:52 |
| DarylM | But it is close. Ingres uses the "jam" build tool. | 07:53 |
| *** Mud has quit IRC | 07:53 | |
| DarylM | But don't start me on that one...... | 07:53 |
| awatkins | um, yeah.... | 07:53 |
| grantc | awatkins: darwin port can provide most of the supporting libraries/tools | 07:56 |
| grantc | I'm using libxerces-c-2.8 from there | 07:56 |
| grantc | sorry macports - http://www.macports.org/ | 07:57 |
| awatkins | grantc: if at all possible i'd like to avoid mac ports and just hand build if i can help it. i have a lot of beef with what macports ends up doing to my system at the end of the day | 07:57 |
| Dejan | the only apple machine i ever had had macosx for less than 20min | 07:58 |
| Dejan | because it took me that much to install Linux over it | 07:58 |
| grantc | awatkins: fair enough | 07:59 |
| grantc | well svn head rev's just built with one failure - /Users/grant/src/ingres/main/build/sig/inglogs/inglogs: No such file or directory | 08:00 |
| awatkins | grantc: cool, i'm exporting it right now | 08:00 |
| DarylM | Dejan: ROFL, that is exactly what I do with any Windows machine I receive. Immediately install Linux over it :-D | 08:11 |
| Dejan | DarylM, that machine was noticably quicker with PPC Linux on it | 08:12 |
| Dejan | no joke | 08:12 |
| * DarylM is impatiently waiting for a new Netbook specific port of Ubuntu 10 | 08:12 | |
| DarylM | PPC? Yea, I'm probably not surprised by that. | 08:13 |
| DarylM | Grantc: I think "mkdir /Users/grant/src/ingres/main/build/sig/inglog" will solve that | 08:14 |
| grantc | DarylM: cheers, that sorted it | 08:16 |
| grantc | so why did it not get created? | 08:17 |
| DarylM | It is in the actual installation directory. | 08:18 |
| DarylM | The Jamfile apparently assumes the directory layout of the build directory has already been set up. I suspect that a "from scratch" build would not have that problem but I never bothered to check. | 08:18 |
| awatkins | is libcompat.a needed to build? | 08:50 |
| awatkins | seems like its not included in os x | 08:51 |
| grantc | that's our library and it should get built | 08:51 |
| awatkins | hmm, pretty much getting hte same error as this guy now | 09:01 |
| awatkins | http://osdir.com/ml/unix-porting/2009-09/msg00002.html | 09:01 |
| grantc | Jeremy might be along later on, he pops in from time to time, better known here as uk_jay | 09:04 |
| awatkins | ok | 09:05 |
| Dejan | see you tomorrow | 09:05 |
| Dejan | time to go home | 09:05 |
| *** Dejan has quit IRC | 09:05 | |
| *** siman01 has quit IRC | 09:12 | |
| *** KermitTheFragger has quit IRC | 09:39 | |
| *** grantc has quit IRC | 10:12 | |
| *** Mud has joined #ingres | 10:28 | |
| *** rossand has quit IRC | 10:28 | |
| *** tripitaka has quit IRC | 10:29 | |
| *** DerMeister has joined #ingres | 11:26 | |
| *** DerMeister has quit IRC | 11:52 | |
| *** DerMeister has joined #ingres | 12:06 | |
| *** atrofast has quit IRC | 12:13 | |
| *** Mud has quit IRC | 12:31 | |
| *** DerMeister has quit IRC | 12:42 | |
| *** Mud has joined #ingres | 12:45 | |
| awatkins | DarylM you still around? | 12:58 |
| DarylM | yes, but on a CC | 13:04 |
| *** Mud has quit IRC | 13:06 | |
| *** cthibert has left #ingres | 13:22 | |
| DarylM | awatkins: How may I help you? | 13:26 |
| awatkins | DarylM: just wondered if you had any advice or heard of an issue where libcompat.a wouldn't link correctly | 13:27 |
| awatkins | brb | 13:28 |
| DarylM | Doesn't seem familiar. | 13:28 |
| DarylM | More detail? | 13:28 |
| awatkins | its basically what this guy ran into | 13:32 |
| awatkins | http://osdir.com/ml/unix-porting/2009-09/msg00002.html | 13:32 |
| awatkins | except mine is on siprintf.o | 13:33 |
| *** zxiiro has quit IRC | 13:52 | |
| awatkins | DarylM: huh, using the -sIIOPTIM=-g with jam seems to have fixed hte problem | 13:55 |
| DarylM | I suspect then it is likely that the recompile fixed some problem with the object files used to build the library | 13:56 |
| DarylM | But I recognize the error in the link you posted | 13:58 |
| awatkins | Was there ever a fix? its more for my curiosity since i spent so long on it | 14:05 |
| awatkins | or somethign i'm doing wrong | 14:06 |
| DarylM | not sure. will do some checking... | 14:21 |
| *** zxiiro has joined #ingres | 14:48 | |
| *** ChanServ sets mode: +v zxiiro | 14:48 | |
| *** siman01 has joined #ingres | 15:06 | |
| *** siman01 has quit IRC | 16:11 | |
| *** awatkins has quit IRC | 16:29 | |
| *** mull has quit IRC | 16:37 | |
| *** cytrinox_ has joined #ingres | 19:20 | |
| *** cytrinox has quit IRC | 19:23 | |
| *** cytrinox_ is now known as cytrinox | 19:23 | |
| *** mull has joined #ingres | 19:29 | |
| *** mull has quit IRC | 19:41 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!