| *** Gerhard has joined #ingres | 00:28 | |
| Gerhard | Morning all | 00:43 |
|---|---|---|
| *** PaulM05 has joined #ingres | 00:43 | |
| Gerhard | Stumbled upon this today: http://esd.ingres.com/product/docs/R3/docs/Ingres_R3_Foreign_Language_Guides | 00:47 |
| grantc | morning - i don't think they've been updated since we left CA | 00:50 |
| PaulM05 | there is - or is about to be - a community project to get them up to date I believe | 00:50 |
| PaulM05 | or maybe that's just the message files | 00:51 |
| Gerhard | That's the point, everything CA-branded | 00:51 |
| Gerhard | I have never considered it a problem that Ingres manuals are English only, but some customers have asked for German documentation | 00:52 |
| Gerhard | Any plans for 9.2 manuals in German language? | 00:53 |
| grantc | Gerhard, this is an "interesting" problem - I've heard the same that some people are ok with the English docs since we would end up screwing up the translation and others want the localized docs | 00:53 |
| grantc | translation is not an exact science as you probably appreciate :) | 00:54 |
| PaulM05 | http://community.ingres.com/wiki/Ingres_Internationalization | 00:54 |
| PaulM05 | looks like that is just message text | 00:55 |
| Mud | morning | 01:21 |
| Mud | :W | 01:21 |
| *** grantc has quit IRC | 01:45 | |
| *** PaulM05 has quit IRC | 01:53 | |
| *** PaulM05 has joined #ingres | 02:22 | |
| *** cthibert has joined #ingres | 03:48 | |
| *** Alex_ has joined #ingres | 04:07 | |
| *** Alex| has quit IRC | 04:07 | |
| *** Alex_ is now known as Alex| | 04:07 | |
| *** ChanServ sets mode: +o Alex| | 04:07 | |
| *** Alex| has quit IRC | 04:26 | |
| *** grantc has joined #ingres | 04:36 | |
| *** ChanServ sets mode: +o grantc | 04:36 | |
| *** PaulM05 is now known as PaulM05_afk | 05:12 | |
| *** atrofast has quit IRC | 05:23 | |
| *** Alex| has joined #ingres | 05:31 | |
| *** ChanServ sets mode: +o Alex| | 05:31 | |
| *** atrofast has joined #ingres | 05:35 | |
| *** zxiiro has joined #ingres | 05:49 | |
| *** ChanServ sets mode: +v zxiiro | 05:49 | |
| *** Alex| has quit IRC | 05:59 | |
| *** rossand has joined #ingres | 06:04 | |
| *** ChanServ sets mode: +o rossand | 06:04 | |
| *** toumi01 has joined #ingres | 06:06 | |
| *** PaulM05_afk is now known as PaulM05 | 06:19 | |
| *** atrofast has quit IRC | 06:24 | |
| *** atrofast has joined #ingres | 06:29 | |
| *** DarylM has joined #ingres | 07:19 | |
| *** Mud has quit IRC | 07:40 | |
| *** Mud has joined #ingres | 07:41 | |
| Gerhard | Hi all, in the past I have encountered the problem that float field data may loose precision upon reload when the unload was done with -c flag. | 07:42 |
| Gerhard | Any way to avoid this? | 07:42 |
| PaulM05 | are you already using -f4 and -f8 flags? | 07:45 |
| *** cthibert has left #ingres | 07:47 | |
| Gerhard | unload.bat: | 07:47 |
| Gerhard | sql -s -f4F79.38 -f8F79.38 -u$ingres fepa404 < "C:\Users\ingres\copy.out" | 07:47 |
| Gerhard | reload.bat: | 07:47 |
| Gerhard | sql -s -f4F79.38 -f8F79.38 -u$ingres +U fepa404 < "C:\Users\ingres\copy.in" | 07:48 |
| PaulM05 | that's the maximum precision that you'll get with a character unload | 07:48 |
| Gerhard | That is what Ingres 9.2 produces on my Win32 machine. | 07:49 |
| PaulM05 | yes | 07:49 |
| Gerhard | What do the flags exactly mean? 38 digits behind the decimal point? | 07:50 |
| PaulM05 | yes - 79 digits with 38 behind the decimal point | 07:50 |
| *** cthibert has joined #ingres | 07:50 | |
| *** Mud has quit IRC | 08:08 | |
| *** Alex| has joined #ingres | 08:22 | |
| *** ChanServ sets mode: +o Alex| | 08:22 | |
| *** Mud has joined #ingres | 08:28 | |
| *** rossand has quit IRC | 08:34 | |
| *** rossand has joined #ingres | 08:36 | |
| *** ChanServ sets mode: +o rossand | 08:36 | |
| *** rossand has quit IRC | 08:38 | |
| *** rossand has joined #ingres | 08:40 | |
| *** ChanServ sets mode: +o rossand | 08:40 | |
| *** Gerhard has quit IRC | 08:45 | |
| *** ccsidiot has joined #ingres | 08:51 | |
| *** rossand has quit IRC | 09:03 | |
| *** rossand has joined #ingres | 09:05 | |
| *** ChanServ sets mode: +o rossand | 09:05 | |
| ccsidiot | Hey, I'm following this: http://community.ingres.com/wiki/Ingres_on_Debian_and_Ubuntu on my way to "createdbms" | 09:21 |
| ccsidiot | Am I looking at the right document or not? | 09:23 |
| PaulM05 | are you running on Ubuntu? | 09:24 |
| atrofast | ccsidiot: If your build completed successfully, all you should hvae to do is buildtools/createdbms II | 09:24 |
| ccsidiot | I'm running debian | 09:24 |
| atrofast | Then after it installs properly source buildtools/test_env.sh II | 09:24 |
| ccsidiot | I mean the school's server's running debian | 09:24 |
| ccsidiot | Oh, is it okay if I ask some conceptual questions? So after the Geospatial code is build successfully, what things are created after the build? | 09:25 |
| ccsidiot | Like an Ingres instance with Geospatial embeded? | 09:26 |
| FrankW | After the build you have ingres server software with geospatial support built-right-in as I understand it. | 09:42 |
| FrankW | So any db instance created with createdbms is geospatial ready, if you will. | 09:42 |
| atrofast | Yeah FrankW is right, the geospatial branch has geospatial right out of the box so to speak | 09:42 |
| ccsidiot | I see :) Thanks FrankW, atrofast | 09:44 |
| *** PaulM05 has quit IRC | 10:14 | |
| ccsidiot | Hum, when I'm in //geospatial/build/utility/ and then do ingstart, it doesn't print the line "Ingres is already running..." | 10:15 |
| atrofast | ccsidiot: From ING_ROOT you have to do source buildtools/test_env.sh II then ingstart to start ingres | 10:15 |
| ccsidiot | Great, thanks atrofast :) | 10:17 |
| *** SaraDanaher has joined #ingres | 10:19 | |
| grantc | pboro, are you still about? | 10:22 |
| *** hanje04 has joined #ingres | 10:34 | |
| SaraDanaher | hi grant are you there? | 10:50 |
| *** ccsidiot has quit IRC | 11:37 | |
| *** toumi01 has left #ingres | 11:58 | |
| *** Alex| has quit IRC | 12:14 | |
| *** bonro01 has joined #ingres | 12:31 | |
| *** toumi01 has joined #ingres | 12:35 | |
| *** bonro011 has quit IRC | 12:45 | |
| *** rossand has quit IRC | 13:02 | |
| *** grantc has quit IRC | 13:08 | |
| *** SaraDanaher has quit IRC | 13:10 | |
| *** zxiiro has quit IRC | 13:39 | |
| *** Mud has quit IRC | 13:51 | |
| *** ccsidiot has joined #ingres | 14:14 | |
| *** cthibert has left #ingres | 14:19 | |
| *** SaraDanaher has joined #ingres | 14:27 | |
| SaraDanaher | hi can some help me | 14:27 |
| SaraDanaher | i am trying to create a data base using the command createdb -udrupal drupal | 14:28 |
| SaraDanaher | but i get in error saying that the -u flag specified a nonexistent user | 14:29 |
| SaraDanaher | creation of database 'drupal' abnormally terminated | 14:29 |
| ccsidiot | do you have the user "drupal" in the database? | 14:30 |
| SaraDanaher | mmm | 14:31 |
| SaraDanaher | no | 14:31 |
| SaraDanaher | how do you do that? | 14:31 |
| SaraDanaher | i created a user call drupal in the OS | 14:31 |
| ccsidiot | I assumed you did ingstart right? | 14:32 |
| SaraDanaher | yes | 14:32 |
| SaraDanaher | i did | 14:33 |
| ccsidiot | do you mind logging out any database that you are in | 14:33 |
| ccsidiot | by doing \q | 14:33 |
| ccsidiot | then | 14:33 |
| ccsidiot | sql iidbdb | 14:33 |
| ccsidiot | then select name from iiuser \g | 14:33 |
| ccsidiot | what does it give you? | 14:34 |
| SaraDanaher | when i did the \q | 14:34 |
| SaraDanaher | command not found | 14:34 |
| ccsidiot | oh, if you are not logged in any database, then ignore that | 14:34 |
| ccsidiot | and move on to the sql iidbdb | 14:35 |
| SaraDanaher | ok it says ingres terminal monitor ..... | 14:36 |
| SaraDanaher | ingres linux version II | 14:36 |
| SaraDanaher | continue | 14:36 |
| SaraDanaher | * | 14:36 |
| SaraDanaher | * | 14:36 |
| SaraDanaher | * | 14:36 |
| ccsidiot | Hey, Sara, paste it here | 14:37 |
| ccsidiot | http://ingres.pastebin.com/ | 14:37 |
| ccsidiot | :) | 14:37 |
| ccsidiot | what does select name from iiuser \g give you? | 14:39 |
| SaraDanaher | one momento because i have ingres in a virtual machine | 14:39 |
| ccsidiot | :) | 14:39 |
| SaraDanaher | ok i sent | 14:43 |
| SaraDanaher | what i see that i got from the command sql iidbdb | 14:43 |
| ccsidiot | :) Got it, | 14:44 |
| *** SaraDanaher_ has joined #ingres | 14:47 | |
| SaraDanaher_ | now i am log in my virtual machine | 14:48 |
| SaraDanaher | http://ingres.pastebin.com/m67ef6fb8 | 14:51 |
| *** zxiiro has joined #ingres | 14:54 | |
| *** ChanServ sets mode: +v zxiiro | 14:54 | |
| ccsidiot | What about the select name from iiuser \g? | 14:55 |
| SaraDanaher_ | ok let me try that | 14:56 |
| SaraDanaher_ | but that command will be after i entered the sql iidbdb | 14:58 |
| SaraDanaher_ | ? | 14:58 |
| ccsidiot | Yupz | 14:58 |
| ccsidiot | sql iidbdb is like login to the database with the name "iidbdb" | 14:58 |
| ccsidiot | iidbdb is the database with the information about users, tables, other databases and etc | 14:59 |
| Vroomfondle | for a (slightly) friendlier interface you can use "isql iidbdb" if your keymap is set correctly | 15:00 |
| SaraDanaher_ | after u entered iiusert \g | 15:00 |
| SaraDanaher_ | syntax error | 15:00 |
| SaraDanaher_ | well i entered iiuser \g | 15:01 |
| ccsidiot | Thanks for the tip Vroomfondle | 15:01 |
| Vroomfondle | isql requires the use of "; commit;" rather than "\g", mind (as far as I know) | 15:01 |
| Vroomfondle | this reminds me - must get a local install of Ingres up and running | 15:02 |
| ccsidiot | :) | 15:03 |
| SaraDanaher_ | so what i should do next? | 15:03 |
| ccsidiot | what does select name from iiuser tell u? | 15:03 |
| ccsidiot | it should print something right? | 15:03 |
| SaraDanaher_ | executing.. | 15:03 |
| SaraDanaher_ | E_US09C4 Syntax error on line 1. Last symbol read was: 'EOF'. | 15:04 |
| ccsidiot | Hummmmm... | 15:05 |
| ccsidiot | are you using isql or sql? | 15:05 |
| SaraDanaher_ | sql | 15:05 |
| ccsidiot | :( I have never encounter this problem before, anyone knows why this is happening? | 15:06 |
| SaraDanaher_ | thanks for the trying cscidiot | 15:07 |
| ccsidiot | Did you type exactly "select name from iiuser \g"? | 15:07 |
| SaraDanaher_ | mmm | 15:07 |
| SaraDanaher_ | i typed iisuer \g | 15:08 |
| SaraDanaher_ | ahhh | 15:08 |
| SaraDanaher_ | i see | 15:08 |
| ccsidiot | what does it print you? | 15:09 |
| SaraDanaher_ | box with name | 15:09 |
| SaraDanaher_ | $ingres | 15:09 |
| ccsidiot | what are the names | 15:09 |
| SaraDanaher_ | www-data | 15:09 |
| SaraDanaher_ | ingres | 15:09 |
| SaraDanaher_ | root | 15:09 |
| ccsidiot | so you don't have the username drupal then | 15:09 |
| ccsidiot | you need to create the user with username "drupal" | 15:10 |
| SaraDanaher_ | i am sorry i am real new in this how i can do that | 15:10 |
| SaraDanaher_ | ? | 15:10 |
| ccsidiot | :) Sara, if you don't recognise, I'm Eva lol. I learned the basics from here: http://pentestmonkey.net/blog/ingres-sql-injection-cheat-sheet/ | 15:11 |
| ccsidiot | Hum....let me dig up the create user thing | 15:11 |
| SaraDanaher_ | eva | 15:12 |
| SaraDanaher_ | man you are real good | 15:12 |
| SaraDanaher_ | in this | 15:12 |
| SaraDanaher_ | lol | 15:12 |
| SaraDanaher_ | you should be working in ingres as an IT | 15:12 |
| ccsidiot | :) I'm not good, the list of people here are all gurus in different areas other than me | 15:13 |
| ccsidiot | Hum, type create user drupal \g | 15:13 |
| ccsidiot | then, do select name from iiuser \g again, this time you'll see the name drupal showing up | 15:14 |
| ccsidiot | :) | 15:14 |
| SaraDanaher_ | mm | 15:17 |
| SaraDanaher_ | dose not like the command create user drupal \g | 15:17 |
| SaraDanaher_ | bash: create: command not found | 15:17 |
| ccsidiot | you need to be in the database iidbdb to do this | 15:17 |
| ccsidiot | I think | 15:18 |
| ccsidiot | XD | 15:18 |
| ccsidiot | Not sure if in other database this works too | 15:18 |
| ccsidiot | Humm, I should try | 15:18 |
| ccsidiot | Great | 15:19 |
| ccsidiot | I'll take that back, log in to any database, then type create user drupal will work | 15:19 |
| ccsidiot | :_ | 15:19 |
| ccsidiot | :) | 15:19 |
| Vroomfondle | erm | 15:21 |
| Vroomfondle | yes, don't do it at bash prompt | 15:21 |
| Vroomfondle | you have to be in isql/sql first | 15:21 |
| ccsidiot | I did create user eva in some other database called sth, logged out sth, log in iidbdb, do select name from iiuser, the name eva doens't show up | 15:22 |
| ccsidiot | but the command create user eva executed successfully, why is that? | 15:23 |
| SaraDanaher_ | yes i did the samething | 15:23 |
| SaraDanaher_ | and it dosen'st show up as well | 15:23 |
| Vroomfondle | did you commit? | 15:23 |
| ccsidiot | but when I do create user eva in iidbdb, then it's there | 15:23 |
| Vroomfondle | anyway, use accessdb | 15:23 |
| ccsidiot | I didn't commit | 15:24 |
| Vroomfondle | I should think that committing is required | 15:24 |
| Vroomfondle | it's an SQL statement like any other - needs to be committed before it'll take effect | 15:25 |
| ccsidiot | But why the sql statement in iidbdb shows up its effect right away? | 15:25 |
| ccsidiot | without committing? | 15:26 |
| Vroomfondle | Good question. Um, I dunno :) | 15:26 |
| ccsidiot | Then there must be something special about iidbdb then :) | 15:27 |
| ccsidiot | I see that as some all in one place dictionary about databases/users/tables.. | 15:27 |
| ccsidiot | Thanks Vroomfondle :) | 15:28 |
| ccsidiot | So Sara, type the following: sql iidbdb, create user drupal, select name from iiuser | 15:31 |
| ccsidiot | then you should see the user with name drupal coming up | 15:31 |
| SaraDanaher_ | what i am using eva | 15:34 |
| SaraDanaher_ | is this | 15:34 |
| SaraDanaher_ | http://community.ingres.com/wiki/Ingres_with_Apache_on_Debian_Etch | 15:34 |
| ccsidiot | do you see the name drupal coming up though? | 15:34 |
| Vroomfondle | ccsidiot: ah, if that's what you did then that explains why the user appeared without the commit. | 15:35 |
| Vroomfondle | because you were still in the transaction | 15:35 |
| ccsidiot | Vroomfondle: What do you mean by still in the transaction? Like logging in iidbdb = during the transaction? | 15:35 |
| ccsidiot | Or Ingres commits transactions automatically from time to time? | 15:36 |
| Vroomfondle | well, if you do two SQL statements one after another without quitting from 'sql', you are still in the same transaction. Thus, you are looking at a temporary copy of the data. The changes won't be put into the real database until you commit or \g | 15:37 |
| ccsidiot | Sarah: I want to make sure that you really have the user name namely drupal before checking someting else | 15:37 |
| SaraDanaher_ | well right now | 15:37 |
| SaraDanaher_ | still executing | 15:37 |
| SaraDanaher_ | ... | 15:37 |
| ccsidiot | *Ccsidiot hates VM* | 15:37 |
| *** PaulM05 has joined #ingres | 15:38 | |
| ccsidiot | Vroomfondle: Hum, but I logged out from iidbdb, then logged back in, select name from iiuser, still has the name that I created | 15:39 |
| Vroomfondle | Hmm. Maybe it autocommits when you log out, then. | 15:39 |
| PaulM05 | it does | 15:39 |
| Vroomfondle | worth knowing :) | 15:40 |
| PaulM05 | was it isql or sql? | 15:40 |
| * Vroomfondle doesn't actually get access to iidbdb on any real server at his workplace | 15:40 | |
| Vroomfondle | it was sql, apparently | 15:40 |
| ccsidiot | PaulM05: Vroomfondle, Sara and I were discussing about the following: I logged in some db called sth, create user eva, logged out sth, logged in iidbdb, do select name from iiuser, the name eva is not showing up | 15:40 |
| PaulM05 | sql should actually end with a message like "your queries have been committed" (not sure if that's the exact phrase) | 15:41 |
| ccsidiot | but when I am in iidbdb, create user eva, select name from iiuser, eva's showing up | 15:41 |
| PaulM05 | yeah - you need to connect to iidbdb to create users | 15:42 |
| ccsidiot | Yupz, the statement executes successfully | 15:42 |
| ccsidiot | not sure if that's committed though | 15:42 |
| PaulM05 | create user doesn't fail on a user database? | 15:42 |
| ccsidiot | Yea, it doesn't fail | 15:42 |
| ccsidiot | :( | 15:42 |
| PaulM05 | that's a bug | 15:42 |
| ccsidiot | I was wondering where did it get execute to | 15:43 |
| ccsidiot | :) Yay, I found a bug | 15:43 |
| PaulM05 | next step fix it ;) | 15:43 |
| ccsidiot | Hum, I was trying to reproduce it, but failed to reproduce it | 15:44 |
| PaulM05 | spurious - worst kind | 15:44 |
| ccsidiot | Hum, let me stop Ingres and restart that | 15:44 |
| SaraDanaher_ | http://ingres.pastebin.com/m4821399d | 15:44 |
| SaraDanaher_ | i am using that command to create the drupal | 15:45 |
| PaulM05 | that should work | 15:45 |
| ccsidiot | PaulM05: I failed to reproduce that | 15:46 |
| ccsidiot | :( | 15:46 |
| PaulM05 | you get an error now? | 15:47 |
| ccsidiot | Yea | 15:47 |
| PaulM05 | well that's good then | 15:47 |
| PaulM05 | working properly | 15:47 |
| ccsidiot | Funny: Error = working properly | 15:48 |
| *** toumi01 has quit IRC | 15:48 | |
| PaulM05 | well yes because you're not supposed to be able to do what you're trying to do | 15:48 |
| ccsidiot | PaulM05:Yes :) You are very right | 15:48 |
| SaraDanaher_ | thanks | 15:49 |
| SaraDanaher_ | people | 15:49 |
| ccsidiot | Sara: Is that what you type exactly? | 15:49 |
| SaraDanaher_ | i got created finally the -udrupal drupal | 15:49 |
| SaraDanaher_ | data base | 15:49 |
| ccsidiot | Great! | 15:49 |
| ccsidiot | Good | 15:50 |
| ccsidiot | :) | 15:50 |
| SaraDanaher_ | thanks eva | 15:50 |
| ccsidiot | No problem | 15:50 |
| ccsidiot | We are getting there | 15:50 |
| SaraDanaher_ | yes | 15:50 |
| SaraDanaher_ | we are | 15:50 |
| SaraDanaher_ | .. | 15:50 |
| ccsidiot | Hey guys, Andrew and Alex provided me a patch to guide me through committing | 15:52 |
| ccsidiot | I have worked with svn before but I'm not sure if there's any rules to watch out for | 15:52 |
| ccsidiot | The patch has already been tested and code inspected, | 15:53 |
| ccsidiot | anything else? | 15:54 |
| ccsidiot | Do I need to commit the changes in 1 commit or can I separate that into different commits? | 15:55 |
| PaulM05 | I've never committed anything to the geospatial branch - do you have any guidelines for the project? | 16:00 |
| ccsidiot | I know the code need to be tested and code inspected before commiting, of which it already is | 16:02 |
| ccsidiot | but I know svn gets annoying when you commit 2 files first then 2 others later, and when people checkout the version only have those 2 first files will have trouble | 16:03 |
| ccsidiot | Other than that, I don't think there are any more specific guildlines | 16:04 |
| PaulM05 | yes - it would make sense to commit everything for one logical change - e.g. a bug fix - together | 16:04 |
| ccsidiot | :) | 16:08 |
| *** PaulM05 has left #ingres | 17:10 | |
| *** SaraDanaher_ has quit IRC | 17:15 | |
| *** ccsidiot_ has joined #ingres | 17:19 | |
| *** ccsidiot has quit IRC | 17:34 | |
| *** rossand has joined #ingres | 17:48 | |
| *** ChanServ sets mode: +o rossand | 17:48 | |
| *** SaraDanaher has quit IRC | 19:10 | |
| *** rossand has quit IRC | 19:18 | |
| *** cytrinox_ has joined #ingres | 19:22 | |
| *** cytrinox has quit IRC | 19:37 | |
| *** cytrinox_ is now known as cytrinox | 19:37 | |
| *** zxiiro has quit IRC | 19:55 | |
| *** zxiiro has joined #ingres | 19:57 | |
| *** ChanServ sets mode: +v zxiiro | 19:57 | |
| *** rossand has joined #ingres | 20:12 | |
| *** ChanServ sets mode: +o rossand | 20:12 | |
| *** rossand has quit IRC | 20:37 | |
| *** ccsidiot_ has left #ingres | 21:36 | |
| *** monda07 has joined #ingres | 21:51 | |
| *** DarylM has quit IRC | 22:01 | |
| *** monda07 is now known as DarylM | 22:01 | |
| *** Alex| has joined #ingres | 22:45 | |
| *** ChanServ sets mode: +o Alex| | 22:45 | |
| *** grantc has joined #ingres | 22:59 | |
| *** ChanServ sets mode: +o grantc | 22:59 | |
| *** Alex| has quit IRC | 23:23 | |
| *** Alex| has joined #ingres | 23:39 | |
| *** ChanServ sets mode: +o Alex| | 23:39 | |
| *** hanje04 has quit IRC | 23:55 | |
| *** Gerhard has joined #ingres | 23:59 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!