| *** grantc has joined #ingres | 00:26 | |
| *** ChanServ sets mode: +o grantc | 00:26 | |
| *** thiagomz_ has quit IRC | 00:40 | |
| *** thiagomz has joined #ingres | 00:40 | |
| *** Alex| has joined #ingres | 00:48 | |
| *** Alex| is now known as Alex|off | 00:48 | |
| *** Nornagest has joined #ingres | 00:49 | |
| *** Alex|off is now known as Alex| | 00:53 | |
| *** ChanServ sets mode: +o Alex| | 00:53 | |
| *** Deyan has joined #ingres | 03:01 | |
| Deyan | hi fellows | 03:01 |
|---|---|---|
| Deyan | anyone around? | 03:01 |
| pboro | sure | 03:01 |
| Deyan | i have a problem - we have just installed 9.4 | 03:01 |
| Deyan | over 9.3 | 03:01 |
| Deyan | installer detected the old instance | 03:01 |
| Deyan | and did everything | 03:02 |
| Deyan | i can connect to old databases via "ingres" user locally | 03:02 |
| * grantc de-cloaks | 03:02 | |
| Deyan | but JDBC connections do not work | 03:02 |
| pboro | does it show any error message? did you check errlog.log? | 03:02 |
| grantc | Deyan, check to see if you have an iigcd process running | 03:02 |
| Deyan | so somehow remote connections to the new 9.4 do not work | 03:02 |
| Deyan | grantc: ok mate, i will check that | 03:02 |
| pboro | I guess 9.4 is pretty much WIP | 03:03 |
| Deyan | grantc: bingo | 03:03 |
| Deyan | grantc: it failed | 03:03 |
| grantc | can you paste the errors from errlog.log to http://ingres.pastebin.com | 03:03 |
| Deyan | http://ingres.pastebin.com/d6b235fa2 | 03:07 |
| Deyan | looks like passwords have been *censored* | 03:07 |
| Deyan | :) | 03:07 |
| grantc | what OS is this? | 03:08 |
| *** Deyan has quit IRC | 03:11 | |
| *** Vroomfondle has quit IRC | 03:11 | |
| *** mull has quit IRC | 03:11 | |
| *** thiagomz has quit IRC | 03:11 | |
| *** clach04 has quit IRC | 03:11 | |
| *** bonro01 has quit IRC | 03:11 | |
| *** thiagomz has joined #ingres | 03:12 | |
| *** mull has joined #ingres | 03:12 | |
| *** clach04 has joined #ingres | 03:12 | |
| *** Vroomfondle has joined #ingres | 03:12 | |
| *** Deyan has joined #ingres | 03:13 | |
| *** bonro01 has joined #ingres | 03:13 | |
| Deyan | grantc: there? | 03:14 |
| grantc | yup | 03:14 |
| Deyan | looks like the password i used in 9.3 is changed after i switched to 9.4 | 03:14 |
| grantc | seemed you got bounced | 03:14 |
| grantc | which OS is this? | 03:14 |
| Deyan | openSUSE | 03:14 |
| *** zxiiro has quit IRC | 03:14 | |
| Deyan | 11.0 | 03:14 |
| Deyan | 64bit | 03:14 |
| grantc | did you install using the RPMs? | 03:14 |
| Deyan | yes | 03:15 |
| grantc | is there a value for "ingprenv II_SHADOW_PWD" ? | 03:15 |
| Deyan | hold on | 03:15 |
| Deyan | i will check that | 03:15 |
| Deyan | yep | 03:15 |
| Deyan | that variable has proper value | 03:16 |
| grantc | if you run "echo ingres ingrespasswd | `ingprenv II_SHADOW_PWD`; echo $?" | 03:16 |
| grantc | what do you get? | 03:16 |
| Deyan | i get "4" | 03:17 |
| grantc | ok if you look at $II_SYSTEM/ingres/files/iipwd/ingvalidpw.c and search for a bunch of "#define" statements, 4 means E_NOTROOT | 03:18 |
| Deyan | erm, i was running this as "ingres" user | 03:18 |
| grantc | which in english, or whatever, means the owner of ingprenv II_SHADOW_PWD is not root | 03:19 |
| Deyan | so root should be owner of that file? | 03:19 |
| grantc | > ls -l `ingprenv II_SHADOW_PWD` | 03:19 |
| grantc | -rwsr-xr-x 1 root grant 16032 2009-02-04 10:47 /opt/Ingres/R3/ingres/bin/ingvalidpw | 03:19 |
| grantc | yup | 03:19 |
| Deyan | i think THAT is the problem | 03:19 |
| grantc | also with the setuid bit set | 03:19 |
| Deyan | i am going to check that | 03:20 |
| Deyan | yeps | 03:20 |
| grantc | so chown root that file also chmod 4755 the file and you should be good to go | 03:20 |
| Deyan | thanks mate | 03:21 |
| Deyan | i think this was the problem | 03:21 |
| Deyan | i am going to try again | 03:21 |
| Deyan | wooohoooo! | 03:21 |
| Deyan | now it works | 03:21 |
| Deyan | erm... | 03:21 |
| Deyan | i think we have a bug in the installer | 03:21 |
| Deyan | or RPM | 03:21 |
| Deyan | because it did not setup these privileges | 03:22 |
| Deyan | well, at least it did not in our case here | 03:23 |
| Deyan | we ran installer as root | 03:23 |
| *** zxiiro has joined #ingres | 03:23 | |
| Deyan | and ingres-9.4.0-101-NPTL-gpl-linux-x86_64.tgz | 03:23 |
| Deyan | was the file that we used | 03:24 |
| grantc | Unfortunately i moved to ubuntu so I have to do all this stuff by hand :( | 03:25 |
| Deyan | :( poor you | 03:25 |
| Deyan | ;) | 03:25 |
| grantc | :) | 03:25 |
| Deyan | J/K - obviously there are some benefits | 03:25 |
| Deyan | you now know that the system can be borked without proper privileges of that password tool... | 03:26 |
| grantc | not sure there is to be honest | 03:26 |
| grantc | it's and age old Ingres problem | 03:26 |
| grantc | s/and/an/ | 03:26 |
| Deyan | strange it does not use pam or something... | 03:26 |
| grantc | google pam ingres | 03:27 |
| ii_log | http://community.ingres.com/forum/dba-forum/1780-ingres-pam-integration.html | 03:27 |
| Deyan | yeppers | 03:27 |
| Deyan | i saw that | 03:27 |
| grantc | pam is an option but ingres has been around for longer than PAM has existed | 03:27 |
| Deyan | sure | 03:27 |
| grantc | if you look at the code in ingvalidpw.c you will see all the different password systems we have to support | 03:28 |
| Deyan | i can understand that :) | 03:28 |
| *** bonro01 has quit IRC | 03:28 | |
| Deyan | our production server is on OpenVMS... | 03:29 |
| * grantc feels for you | 03:29 | |
| Deyan | rofl | 03:29 |
| Deyan | but not for long | 03:29 |
| *** bonro01 has joined #ingres | 03:29 | |
| Deyan | ;) | 03:29 |
| grantc | although i should not say too many bad things against openvms since it help me travel the world. | 03:30 |
| Deyan | we are moving the old system to Linux in few months | 03:30 |
| Deyan | 1 year at most | 03:30 |
| grantc | cool | 03:30 |
| Deyan | ROFL | 03:31 |
| Deyan | i just started working for this company... | 03:34 |
| Deyan | I never touched Ingres in my life before | 03:34 |
| Deyan | and i used VAX/VMS some 15 years ago | 03:34 |
| grantc | new blood :) | 03:35 |
| Deyan | that was the only time i worked with VMS | 03:35 |
| Deyan | so far i like Ingres | 03:35 |
| Deyan | and i like the direction | 03:35 |
| Deyan | (towards open-source) | 03:35 |
| Deyan | I come from MySQL world | 03:35 |
| Deyan | allthough i worked with Oracle quite a lot | 03:35 |
| grantc | yeah it's pretty easy to get to grips with and most things work the same across the platforms | 03:35 |
| Deyan | i have come across the shift2ingres project | 03:37 |
| grantc | hmmm yes... | 03:37 |
| grantc | we got into a bit of hot water there... or rather some of the entries did | 03:38 |
| grantc | that was submitted as part of a $1m prize for conversion tools for Ingres. unfortunately some of them were submitted by oracle employees... | 03:38 |
| grantc | needless to say we/they ran into IP issues | 03:39 |
| Deyan | $1m... | 03:46 |
| Deyan | why did i not know about it... | 03:46 |
| Deyan | :> | 03:46 |
| Deyan | so who won the prize? | 03:46 |
| grantc | not sure - no one in the end.. since the supposed top 3 all came from oracle employees | 03:47 |
| grantc | http://linux.sys-con.com/node/86163 - has the supposed winners ... | 03:47 |
| Alex| | shift2ingres never really worked... we were writing a new tool last year that does the job now :) | 03:49 |
| grantc | are you going to publish it? | 03:49 |
| Alex| | not sure... of course mgmt wants to make money with it.... | 03:50 |
| grantc | :) | 03:50 |
| Alex| | off now... company bicycle tour today... | 03:50 |
| *** Alex| is now known as Alex|off | 03:51 | |
| Deyan | Alex|off: have fun | 03:55 |
| Deyan | it is a nice company you are working for:D | 03:55 |
| grantc | :) | 03:59 |
| grantc | the last time i went out on my bike i hit a kid .... and i came off worse | 03:59 |
| pboro | :D | 04:00 |
| grantc | i lied - the bike came off worse then me then the kid.. i still need to take it to the shop to get repaired | 04:00 |
| Deyan | make | 04:26 |
| Deyan | ups | 04:26 |
| Deyan | :D | 04:26 |
| atrofast | Ah I tried the OME lib that shift2ingres made | 06:05 |
| atrofast | It's made a SQL function for "greatest" although it only takes two arguments | 06:06 |
| *** mull has quit IRC | 06:45 | |
| *** mull has joined #ingres | 07:46 | |
| *** DarylM has joined #ingres | 08:08 | |
| *** DerMeister has joined #ingres | 09:42 | |
| *** Deyan has quit IRC | 10:13 | |
| *** NoeJeko has joined #ingres | 11:07 | |
| *** Dejan has joined #ingres | 11:51 | |
| Dejan | hello people | 11:51 |
| atrofast | Hello Dejan | 13:03 |
| *** Alex|off is now known as Alex| | 13:14 | |
| *** DarylM has quit IRC | 13:18 | |
| *** zxiiro has quit IRC | 13:27 | |
| *** DarylM has joined #ingres | 13:31 | |
| *** Alex| is now known as Alex|off | 13:35 | |
| *** zxiiro has joined #ingres | 13:37 | |
| *** DerMeister has quit IRC | 14:20 | |
| *** grantc has quit IRC | 14:34 | |
| *** Dejan has quit IRC | 14:52 | |
| *** mull has quit IRC | 15:22 | |
| *** DarylM has quit IRC | 15:47 | |
| *** rossand has joined #ingres | 17:37 | |
| *** ChanServ sets mode: +o rossand | 17:37 | |
| *** mull has joined #ingres | 18:28 | |
| *** rossand has quit IRC | 19:30 | |
| *** mull has quit IRC | 21:05 | |
| *** Alex|off is now known as Alex| | 22:04 | |
| *** NoeJeko has quit IRC | 22:46 | |
| *** Alex| is now known as Alex|off | 22:54 | |
| *** grantc has joined #ingres | 22:55 | |
| *** ChanServ sets mode: +o grantc | 22:55 | |
| *** Alex|off is now known as Alex| | 23:11 | |
| *** Alex| is now known as Alex|off | 23:48 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!