*** Gerhard has joined #ingres | 00:04 | |
*** Gerhard has quit IRC | 01:37 | |
*** Deyan has joined #ingres | 01:45 | |
Deyan | morning | 01:48 |
---|---|---|
pboro | hi Deyan | 02:29 |
Deyan | i always forget to write down my (Dejan) freenode password | 02:56 |
Deyan | so i can use my username here | 02:56 |
Deyan | (nickname) | 02:56 |
Deyan | :)) | 02:56 |
pboro | yup | 02:56 |
grantc | hi Deyan | 03:41 |
grantc | Can you try http://ingres.pastebin.com/f6fd0d64f against SVN headrevs (http://svn.php.net/repository/pecl/ingres/trunk) | 03:42 |
grantc | i think it fixes your problem | 03:43 |
Deyan | hi grant | 03:51 |
Deyan | i will try it asap | 03:52 |
Deyan | i am working on something atm | 03:52 |
Deyan | looks like we may have a similar problem with timestamps | 03:52 |
Deyan | we are currently examining the problem | 03:52 |
Deyan | (it could be our fault though) | 03:52 |
Deyan | :D | 03:53 |
grantc | you might find that the update fixes those too :) | 03:53 |
dyki | :) | 04:03 |
Deyan | khm... | 04:07 |
Deyan | does not seem like working here | 04:08 |
Deyan | Revision: 284640 | 04:08 |
Deyan | that is what i got | 04:08 |
Deyan | maybe linux caches the library... | 04:08 |
grantc | the patch needs to be applied to headrevs | 04:09 |
Deyan | ahaaaaa | 04:10 |
grantc | i.e. what's in SVN | 04:10 |
Deyan | can i get the diff from you? | 04:10 |
Deyan | do the diff against current svn | 04:10 |
grantc | that is the diff | 04:10 |
Deyan | and send it to me to dejan.lekic@areen.com | 04:10 |
Deyan | please | 04:10 |
Deyan | lol | 04:10 |
grantc | that diff is what is currently from the latest SVN | 04:10 |
Deyan | i did not realise it is a diff :) | 04:11 |
grantc | keep up :) | 04:12 |
Deyan | either i have forgotten how to apply the patch, or something is wrong with the diff file | 04:15 |
Deyan | i do patch -p 1 < grantc.patch | 04:15 |
Deyan | and get "patch: **** Only garbage was found in the patch input." | 04:15 |
grantc | -p0 i think | 04:15 |
Deyan | did that | 04:16 |
Deyan | nada | 04:16 |
Deyan | dejan@srv021:~/src/php-ingres> patch -p0 < grantc.patch | 04:16 |
Deyan | patch: **** Only garbage was found in the patch input. | 04:16 |
pboro | Deyan, download the patch instead of copypasting | 04:16 |
pboro | there's a link in pastebin for downloading the contents | 04:16 |
Deyan | pboro: i looked to download | 04:16 |
Deyan | at the end | 04:16 |
Deyan | not at the top | 04:16 |
Deyan | :))))))))))) | 04:16 |
Deyan | DONE | 04:17 |
Deyan | with downloaded file it worked | 04:18 |
Deyan | WORKS | 04:18 |
Deyan | grantc: <3 <3 <3 | 04:18 |
Deyan | ty guys | 04:18 |
Deyan | you are awesome | 04:18 |
grantc | cool - i will write up an integration plan and it will get submitted today/tomorrow | 04:18 |
Deyan | i think i have found something that should be treated as a bug | 04:25 |
Deyan | in ingres | 04:25 |
Deyan | i have this: | 04:25 |
Deyan | create table timestamp_test(id INT NOT NULL AUTO_INCREMENT, one CHAR(1), two TIMESTAMP NOT NULL, three TIMESTAMP, PRIMARY KEY(id)); | 04:26 |
Deyan | note that column "two" is NOT NULL | 04:26 |
Deyan | however, it allows me to insert '' there | 04:26 |
Deyan | even from sql | 04:26 |
Deyan | terminal monitor | 04:27 |
pboro | it is because you're using INGRESDATE, INGRESDATE allows empty strings | 04:27 |
Deyan | it is a timestamp... | 04:27 |
Deyan | or it is some configuration setting? | 04:27 |
pboro | lemme check what does that map to | 04:27 |
Deyan | upon installation we have choosen ANSI dates | 04:27 |
Deyan | not ingres dates | 04:27 |
pboro | ok, then it might really be a bug | 04:28 |
grantc | TIMESTAMP !=INGRESDate | 04:28 |
Deyan | i know that | 04:28 |
pboro | grantc, there's no aliasing for TIMESTAMP to INGRESDATE when using INGRESDATE, only for DATE? | 04:28 |
grantc | yup since timestamp has different properties | 04:28 |
grantc | at least from what i have seen | 04:29 |
pboro | I get: | 04:29 |
pboro | E_US10E8 '' is invalid format or value for timestamp without time zone or timestamp with local time zone. Please enter a valid timestamp value in yyyy-mm-dd hh:mm:ss[.fff...] format. | 04:29 |
pboro | when trying to insert '' in that column | 04:29 |
Deyan | pboro, how? o.O | 04:29 |
pboro | this is 9.2/143 with patch 13457 | 04:29 |
Deyan | i want that error too | 04:29 |
Deyan | :) | 04:30 |
Deyan | i have 9.3 here | 04:30 |
dyki | we use 9.3/151 | 04:30 |
pboro | Deyan, which version are you using? It prolly has a bug, which may or may not be fixed already in later releases. | 04:30 |
pboro | Ok, there's a bug in 9.3 then :) | 04:30 |
Deyan | pboro: that is what i am trying to say | 04:30 |
pboro | I tried it this way: CREATE TABLE test (id INTEGER NOT NULL, value TIMESTAMP NOT NULL, PRIMARY KEY(id)); INSERT INTO test VALUES (1, ''); | 04:31 |
dyki | it works perfectly ok in 9.3 :) | 04:32 |
dyki | no errors | 04:32 |
pboro | hehe | 04:32 |
grantc | it works in PHP as well against 9.2, "" gets converted to 0000-00-00 00:00:00.000000 | 04:32 |
Deyan | grantc: i am fine with that too | 04:33 |
Deyan | but here i get NOTHING | 04:33 |
dyki | when we use it from PHP with 9.3 same thing happens | 04:33 |
dyki | as in normal sql | 04:33 |
dyki | or isql | 04:33 |
grantc | http://ingres.pastebin.com/f4ffca57c | 04:33 |
grantc | it could be that OpenAPI is doing something before sending it across the wire... | 04:34 |
grantc | If you think it is a bug then log it | 04:35 |
Deyan | http://codepad.org/z6XAhDIF | 04:35 |
Deyan | i pasted it into ingres.pastebin.com | 04:36 |
Deyan | but it ***ed up the special chars | 04:36 |
Deyan | codepad works | 04:36 |
grantc | i get "0000-00-00 00:00:00.000000" | 04:36 |
pboro | grantc, by the way where should I report bugs about 9.3? we have support contract so is service desk correct place? | 04:36 |
grantc | pboro, yup | 04:37 |
pboro | grantc, ok, thanks... I'm building a JDBC test suite based on our apps and there seems to be some problems, better to report them early than after the ga release... | 04:37 |
grantc | :) | 04:38 |
Deyan | do not forget to report this bug too ;) | 04:39 |
Deyan | pboro: include it in the test suite, plx | 04:39 |
Deyan | :) | 04:39 |
pboro | Deyan, it is not a critical bug for us, but after everything more important have been resolved... why not :) | 04:40 |
pboro | (I don't work for Ingres, simply a user from Ingres client) | 04:41 |
*** atrofast has joined #ingres | 04:53 | |
Deyan | :)))) | 05:04 |
Deyan | well, i would submit a bug if i knew where | 05:05 |
Deyan | i will check that after the lunch ;) | 05:05 |
pboro | http://bugs.ingres.com/ | 05:05 |
*** rossand has joined #ingres | 05:15 | |
*** ChanServ sets mode: +o rossand | 05:15 | |
*** Alex| is now known as Alex|off | 05:27 | |
Vroomfondle | is there any publicly-accessible documentation for the file that's produced by copyapp? | 06:03 |
atrofast | Did you try the COmmand Reference document at docs.ingres.com? | 06:05 |
atrofast | http://docs.ingres.com/Ingres/9.2/Command%20Reference%20Guide/copyappcmd.htm Vroomfondle | 06:05 |
Vroomfondle | that doesn't tell me how to parse the file, thoguh | 06:06 |
Vroomfondle | *tough | 06:06 |
Vroomfondle | cheers for looking, though :) | 06:06 |
atrofast | No problem, sorry it wasn't more help | 06:07 |
*** Alex|off is now known as Alex| | 07:07 | |
*** adrianwarwickuni has joined #ingres | 08:05 | |
*** grantc has quit IRC | 08:08 | |
Deyan | oops | 08:18 |
*** grantc has joined #ingres | 08:21 | |
*** ChanServ sets mode: +o grantc | 08:21 | |
*** bonro01 has left #ingres | 08:31 | |
dyki | grantc: one question. Is there any quick and easy way to have a look at prepared statement just before the execuition? | 08:44 |
grantc | eh? | 08:44 |
grantc | what do you mean by "look" | 08:44 |
Deyan | he wants sql that is about to be executed in prepared statement queries... | 08:45 |
Deyan | in other words, we want to check if the generated sql is valid or not | 08:45 |
pboro | what language are you using? some drivers support tracing | 08:46 |
grantc | generated by who? | 08:46 |
dyki | php | 08:46 |
grantc | i don't touch the query (much) | 08:46 |
dyki | basically, is there any way to dump the SQL after it has all the parameters supplied? | 08:47 |
Deyan | ok, lets say i have "insert into tablename values(?,?,?)" | 08:47 |
grantc | All I do is replace the ? markers with ~V and depending on the query add a keyword | 08:47 |
Deyan | we call insert_query with arguments | 08:47 |
Deyan | now we want to see the sql | 08:47 |
*** bonro01 has joined #ingres | 08:47 | |
Deyan | that willa ctually be executed | 08:47 |
Deyan | will* | 08:47 |
grantc | the php driver does not embed the values in your supplied query | 08:48 |
grantc | it sends the query using iiapi_query telling the server to expect some parameters | 08:48 |
grantc | and they are sent along separately | 08:48 |
grantc | http://ingres.pastebin.com/f665fc16a | 08:49 |
grantc | The C functions in the trace are IIapi_query(), IIapi_setDescriptor() and IIapi_putParm() | 08:51 |
Deyan | thanks for info, grantc | 08:51 |
grantc | there is nothing in the driver that dumps that info.. I have thought about adding it but that is as far as i get | 08:52 |
dyki | cheers | 08:54 |
*** rossand has quit IRC | 09:04 | |
*** rossand has joined #ingres | 09:07 | |
*** ChanServ sets mode: +o rossand | 09:07 | |
grantc | hi atrofast | 09:30 |
atrofast | Hey grantc | 09:52 |
*** mull has joined #ingres | 09:55 | |
grantc | i've been looking at / -> /svn and unfortunately rewrite does not work | 09:56 |
grantc | you get the message "svn: Repository moved temporarily to ...." ; please relocate | 09:56 |
atrofast | Ah that's too bad ;9 | 09:57 |
atrofast | :( | 09:57 |
Alex| | hum, so it intercepts the message instead of just follow the redirect.... | 09:57 |
atrofast | There's no way to hide that it is a redirect/rewrite? | 09:59 |
Alex| | does it tell you where to relocate? That would be a way to inform people of a move..... | 09:59 |
*** Deyan has quit IRC | 10:01 | |
atrofast | So what I don't get is... there is a robots.txt in the root, why is it ignored? | 10:01 |
atrofast | Also the robots.txt only disallows HTTrack currently, is there a reason fo rhtat? | 10:01 |
grantc | Alex|, yes it does | 10:07 |
Alex| | I still think relocating is an option we can go..... I'm off | 10:08 |
*** Alex| is now known as Alex|off | 10:08 | |
grantc | atrofast, i cannot tell you but i have been playing with the robots.txt file and as you can see from the stats i mailed out google consumed 1GB of traffic last month | 10:09 |
atrofast | Google is not disallowed though, or was there an older version of robots.txt that did? | 10:09 |
ii_log | http://www.webmasterworld.com/google/3044757.htm | 10:09 |
grantc | yup earlier on this week it was disabled | 10:11 |
grantc | i have also read that running an SVN repo at / is not a good idea but i would need to dig up those references | 10:11 |
grantc | or perhaps we can do a transparent move... | 10:15 |
grantc | http://www.webmasterworld.com/apache/3832878.htm seems to work | 10:15 |
atrofast | How much of a hassle would that be? | 10:19 |
grantc | In theory no hassle.. | 10:20 |
grantc | All i would need to do is to write the re-write rules for each of the current repos and away we go | 10:21 |
atrofast | So if another repos is added, we would have to add another rewrite rule? | 10:22 |
grantc | perhaps | 10:23 |
grantc | although I would be inclined to say no - all new repos go via /svn/.... | 10:23 |
grantc | since we only have 7 repos at the moment the impact will be minimal | 10:23 |
grantc | / would redirect to /svn and /<repo> would be a passthrough (transparent to /svn/<repo> | 10:25 |
atrofast | Ah I see, that sounds pretty good | 10:30 |
grantc | people can still do a "svn switch --relocate" but there is no real need to | 10:33 |
rossand | processing :-) | 10:37 |
rossand | This would ensure the robots.txt is respected since the actual path served by apache is /svn/blah? | 10:38 |
rossand | Said another way, if it is transparent to svn clients, wouldn't it be transparent to search engines? | 10:39 |
grantc | correct | 10:39 |
grantc | yup | 10:39 |
rossand | If so, then wouldn't the issue persist? | 10:39 |
grantc | no because we would only pass on the svn repositories | 10:39 |
rossand | If I'm not mistaken, this would imply they could still crawl the svn repositories, no? | 10:40 |
grantc | yes they could but the robots.txt should work | 10:41 |
grantc | as you can see from the URL i /msg'd you the robots.txt we had was not working last month | 10:43 |
rossand | It's worth trying if we could somehow experiment under reasonably controlled conditions. For example, declare an outage. And test on one of our work areas. | 10:44 |
grantc | robot changes take 24-48 hours to take effect | 10:45 |
grantc | perhaps less but still | 10:45 |
rossand | The rewrite is the crucial bit to test. | 10:45 |
rossand | If it doesn't blow up people's work areas, then it's safe to proceed. | 10:45 |
grantc | try http://code.croker.net/ingres | 10:45 |
grantc | i moved it to /svn/ingres | 10:46 |
rossand | same rewrite rules? | 10:46 |
grantc | yup | 10:46 |
grantc | http://ingres.pastebin.com/f278eee99 | 10:47 |
rossand | OK. Seems like it should work. Work was add the rewrite & restart? | 10:47 |
grantc | restart or reload but yes | 10:47 |
rossand | yup | 10:47 |
grantc | and change the <Location /> to /svn... | 10:48 |
rossand | And of course (the duh question) it still updates fine? :-) | 10:48 |
grantc | :) | 10:48 |
grantc | i have not done a commit but what i did not is perform an svn update and it did not complain | 10:48 |
rossand | OK. Great solution then. I can't think of anything that's going to bite us - can you guys? | 10:48 |
grantc | which it did with a redirect rule | 10:49 |
rossand | brb, gotta switch back to my other machine. I'm satisfied this is a good way to solve this. It'll be great if indeed the search engines respect it. | 10:51 |
*** dyki has quit IRC | 10:51 | |
*** rossand has quit IRC | 10:52 | |
*** rossand has joined #ingres | 10:53 | |
*** ChanServ sets mode: +o rossand | 10:53 | |
*** DerMeister has joined #ingres | 10:57 | |
grantc | right the changes are in place, commented out at the moment | 10:58 |
grantc | I'll send out a mail announcing the outage for tomorrow morning, 6am GMT | 10:59 |
atrofast | Alright then, sounds good... Thanks grantc | 11:01 |
*** zxiiro has quit IRC | 11:17 | |
*** adrianwarwickuni has quit IRC | 11:28 | |
*** adrianwarwickuni has joined #ingres | 11:34 | |
*** grantc has quit IRC | 12:46 | |
*** DerMeister has quit IRC | 14:23 | |
*** mull has quit IRC | 15:16 | |
*** toumi01 has quit IRC | 16:27 | |
*** rossand has quit IRC | 16:48 | |
*** adrianwarwickuni has quit IRC | 17:38 | |
*** zxiiro has joined #ingres | 18:17 | |
*** ChanServ sets mode: +v zxiiro | 18:17 | |
*** zxiiro has quit IRC | 18:23 | |
*** mull has joined #ingres | 18:56 | |
*** mull has quit IRC | 19:02 | |
*** Alex|off is now known as Alex| | 22:40 | |
*** grantc has joined #ingres | 23:15 | |
*** ChanServ sets mode: +o grantc | 23:15 | |
grantc | morning Alex| | 23:15 |
Alex| | morning grantc - just on my way to the office... back in a few minutes | 23:16 |
grantc | ok | 23:16 |
*** Alex| is now known as Alex|off | 23:16 | |
*** graydot has joined #ingres | 23:21 | |
graydot | hi | 23:21 |
graydot | is there anyone here? i need a bit of help with conversion issues | 23:21 |
grantc | hi graydot | 23:22 |
grantc | what sort of issues? | 23:22 |
graydot | grantc, is this the channel for gis related help? | 23:22 |
grantc | with ingres yes but the people who know that stuff will be along later on | 23:24 |
graydot | grantc, oh...i have some files here from the chicago gis database and i don't know how to use it. i am a coder and am a newbie at gis. can you help? | 23:27 |
grantc | unfortunately not | 23:28 |
grantc | the people you need are rossand or atrofast | 23:28 |
grantc | both of them are based in canada and won't be around for 5-6 hours | 23:28 |
graydot | ok. know any other channels? | 23:29 |
graydot | grantc, | 23:30 |
grantc | perhaps there is an opengis channel | 23:30 |
grantc | google opengis irc | 23:30 |
ii_log | http://lists.freedesktop.org/archives/roadster/2005-April/000049.html | 23:30 |
grantc | @google opengis irc | 23:31 |
ii_log | grantc: [Roadster] OpenGIS, wms, wcs and PDAs: <http://lists.freedesktop.org/archives/roadster/2005-April/000049.html>; Semantic Web Interest Group IRC Scratchpad: <http://swig.xmlhack.com/2003/05/28/2003-05-28.html>; InLineFeature Usage - GeoServer: <http://geoserver.org/display/GEOSDOC/InLineFeature+Usage>; Chapter 4: <http://eea.eionet.europa.eu/Public/irc/eionet-circle/eionet- (2 more messages) | 23:31 |
grantc | @google opengeo irc | 23:31 |
ii_log | grantc: RulePanel redesign f ... / Andreas Hocevar — OpenGeo: <http://lists.opengeo.org/styler/archive/2009/02/1234954228727/forum_view>; geometry attribute n ... / Tim Schaub — OpenGeo: <http://lists.opengeo.org/styler/archive/2008/12/1229618615833/forum_view>; OpenGeo Code Sprint 2009 - GeoServer: <http://geoserver.org/display/GEOS/OpenGeo+Code+Sprint+2009>; Stichting OpenGeo (opengeo_nl) on Twitter: (2 more messages) | 23:31 |
*** Alex|off is now known as Alex| | 23:32 | |
Alex| | re | 23:32 |
Alex| | did you find a solution for the redirect problem? | 23:32 |
grantc | Alex|, no - looks like i have to revert | 23:33 |
Alex| | ? wrote your mail to quickly? | 23:33 |
Alex| | too | 23:33 |
grantc | i did some testing externally, but obviously i did not do enough | 23:34 |
grantc | a simple checkout, reconfig server, update worked ok | 23:34 |
grantc | but the same on our server does not work | 23:34 |
Alex| | hu? because of different svn versions? | 23:35 |
grantc | perhaps | 23:35 |
grantc | my box has 1.6.3 we have 1.5.2 | 23:35 |
Alex| | hm... | 23:35 |
Alex| | and we still cannot update without using our own packages I guess? | 23:36 |
grantc | i need to do more testing ... | 23:36 |
grantc | correct | 23:36 |
grantc | there are rpms in rpmforge for this OS release but we wander into unsupported territory | 23:36 |
Alex| | so either something that doesn't work but is supported or something that works but isn't supported... :) | 23:37 |
grantc | the only other option is to do "svn switch --relocate http://code.ingres.com/ingres http://code.ingres.com/svn/ingres" | 23:37 |
grantc | for each repo you have checked out | 23:37 |
grantc | since we are in the middle of summer i am not too keen on making people do that now | 23:38 |
Alex| | some kind of statistics how many working copies are out there would be nice :) | 23:38 |
grantc | graydot, there is a mailing list you can use gis-users@lists.ingres.com | 23:40 |
grantc | goto http://lists.ingres.com/mailman/listinfo/gis-users for more info | 23:40 |
graydot | grantc, thanks | 23:40 |
grantc | if there is an IRC channel, and i think there is, they will know where it is. | 23:41 |
grantc | Alex|, yeah... :) | 23:41 |
grantc | the advantage piccolo has over svn... | 23:42 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!