| *** troal011 has joined #ingres | 00:00 | |
| *** withdefault is now known as notdefault | 00:06 | |
| *** mull has quit IRC | 01:18 | |
| *** troal011 has quit IRC | 02:34 | |
| *** mull has joined #ingres | 03:51 | |
| *** mull has joined #ingres | 03:51 | |
| *** rossand has quit IRC | 04:17 | |
| *** rossand has joined #ingres | 04:20 | |
| *** ChanServ sets mode: +o rossand | 04:20 | |
| *** toumi01 has quit IRC | 04:24 | |
| *** mull has quit IRC | 05:16 | |
| *** NoeJeko has joined #ingres | 05:29 | |
| NoeJeko | =[ Alex is never around anymore | 05:29 |
|---|---|---|
| *** rossand has quit IRC | 05:45 | |
| *** Alex|off is now known as Alex| | 06:48 | |
| *** grantc_offline is now known as grantc | 07:18 | |
| pboro | NoeJeko, I would not say tha | 07:19 |
| pboro | that even | 07:20 |
| *** grantc is now known as grantc_offline | 07:24 | |
| *** grantc_offline is now known as grantc | 07:24 | |
| grantc | hi NoeJeko - are you still up? | 08:20 |
| *** thiagomz has joined #ingres | 10:41 | |
| *** thiagomz has quit IRC | 10:51 | |
| *** satanmalin has quit IRC | 11:05 | |
| *** satanmalin has joined #ingres | 11:06 | |
| *** thiagomz has joined #ingres | 12:13 | |
| thiagomz | Guys, Morning... How can I associate my table on iitables with my file on filesystem ? | 12:16 |
| pboro | iifile_info | 12:17 |
| grantc | see the view iifile_info | 12:17 |
| thiagomz | grantc: tkz | 12:17 |
| thiagomz | pboro: tkz too | 12:17 |
| grantc | np | 12:17 |
| thiagomz | when do I drop a table, it is removed from the filesystem ? | 12:18 |
| grantc | i guess so but if "stuff" is also happening on the file it might not disappear until "stuff" has finished | 12:20 |
| grantc | also temp tables (not session temp tables) remain until they are manually purged | 12:20 |
| thiagomz | grantc: i am asking it.. because i have files on data directory from 2007 without any change... | 12:20 |
| thiagomz | and it is using space on filesystem... | 12:20 |
| grantc | do they relate to actual tables in the db? | 12:21 |
| thiagomz | i will query iifile_info to verify that association... | 12:21 |
| grantc | if they are temp tables the verifydb command has a purge option | 12:21 |
| grantc | see http://docs.ingres.com | 12:21 |
| thiagomz | tkz... | 12:21 |
| *** mull has joined #ingres | 13:05 | |
| *** rossand has joined #ingres | 13:27 | |
| *** ChanServ sets mode: +o rossand | 13:27 | |
| *** troal012 has joined #ingres | 13:31 | |
| *** troal012 has quit IRC | 13:34 | |
| *** troal011 has joined #ingres | 13:38 | |
| *** troal011 is now known as troal01 | 13:49 | |
| Alex| | rossand, what is the current status of the geospatial project? | 14:03 |
| *** notdefault is now known as withdefault | 14:06 | |
| *** troal01 has quit IRC | 14:07 | |
| *** troal01 has joined #ingres | 14:07 | |
| *** toumi01 has joined #ingres | 14:12 | |
| *** Gerhard has joined #ingres | 14:15 | |
| thiagomz | what is the site to past a output ? | 14:29 |
| thiagomz | paste | 14:29 |
| Alex| | e.g. pastebin.com | 14:30 |
| Alex| | nopaste.org | 14:30 |
| thiagomz | ingres | 14:30 |
| Alex| | or many others | 14:30 |
| thiagomz | guys, where can i get the database name for that sql => http://nopaste.org/p/ag5ggecuh | 14:31 |
| thiagomz | Alex|: ;-) | 14:31 |
| Alex| | not sure I understand the question | 14:32 |
| thiagomz | i wannt put a => and database name = 'mydb'; | 14:33 |
| thiagomz | where can i get that info... | 14:33 |
| Alex| | why would you do that? iitables only contains the tables of one database and that is the one you're connected to | 14:34 |
| thiagomz | Alex|: tkz... i didn´t now that ;) | 14:35 |
| thiagomz | newbie ingres dba | 14:36 |
| thiagomz | :D | 14:36 |
| Alex| | each database has its own iitables, iiattributes, iisequences, etc... | 14:36 |
| thiagomz | Alex|: a i am a oracle dba learning ingres... | 14:37 |
| thiagomz | that information was very usefull... | 14:37 |
| Alex| | no problem :) | 14:37 |
| *** Gerhard has quit IRC | 14:45 | |
| troal01 | http://aur.archlinux.org/packages.php?ID=24432 :D | 14:55 |
| *** mull has quit IRC | 15:02 | |
| NoeJeko | hey Alex | 15:05 |
| Alex| | hi | 15:05 |
| NoeJeko | i got my questions taken care of lol. | 15:06 |
| Alex| | questions? | 15:06 |
| NoeJeko | did you have time to check that admin user exception thing? | 15:06 |
| Alex| | not yet... was on the road the last two days | 15:06 |
| NoeJeko | oh, i was having a trouble with the query I used to populate the popular downloads | 15:06 |
| Alex| | ah you mean the first 5 thing? | 15:07 |
| NoeJeko | ... seems a temporary spell of insanity as I tried to "SELECT COUNT(*) AS count" forgetting that 'count | 15:07 |
| NoeJeko | ''count' is reserved SQL grammar | 15:07 |
| NoeJeko | heh... heh... | 15:07 |
| NoeJeko | yeah, you can see the "popular downloads" on esd-itdev | 15:08 |
| Alex| | doesn't work? hm... I would have guessed it does because the it's a context sensitive parser, i.e. it should know from the context when you want to use it as a keyword and when not | 15:08 |
| NoeJeko | it takes a number of queries to generate it, but i cache them in APC | 15:08 |
| NoeJeko | so it only requeries every 4 hours | 15:08 |
| Alex| | ok | 15:08 |
| NoeJeko | all testing has shown that it only adds .1 seconds to the page generation anyway and i figure thats acceptable once every 4 hours | 15:09 |
| NoeJeko | when vtrenz adds 3-10 seconds to it =[ | 15:09 |
| Alex| | ouch | 15:09 |
| NoeJeko | ya, but i'm hoping | 15:09 |
| NoeJeko | that's just because i'm calling the WSDL from behind the firewall | 15:09 |
| NoeJeko | and it'll speed up once its at rackspace | 15:09 |
| NoeJeko | go go gadget masergy | 15:10 |
| NoeJeko | and the thing with the query that didn't work | 15:10 |
| NoeJeko | was "CREATE VIEW popular_dls AS SELECT COUNT(*) AS count, file_id FROM dl_tracking GROUP BY file_id"(this worked fine) and then a subsequent call to "SELECT count, file_id FROM popular_dls ORDER BY count DESC" (this failed, for not-so-obvious-then-but-blatant-now reasons) | 15:12 |
| *** troal01 has left #ingres | 15:12 | |
| Alex| | because of the count? | 15:13 |
| NoeJeko | yeah haha | 15:13 |
| grantc | NoeJeko, have you had a look at that ingres_escape_string() update? | 15:13 |
| NoeJeko | when i changed it to something like dl_total it worked fine | 15:13 |
| Alex| | ok | 15:13 |
| NoeJeko | um, no sorry Grant I've been pushed really hard to get this vtrenz->ESD integration done | 15:13 |
| grantc | no worries - Alex| mentioned that they had you working on other stuff | 15:14 |
| NoeJeko | i'll play with it today as i'm pretty much done on the ESD 1.4.2 release unless someone finds some crazy bug | 15:14 |
| *** troal01 has joined #ingres | 15:14 | |
| grantc | nice work with the wiki login - a lot better than the 3-4 page redirect | 15:14 |
| NoeJeko | thanks - it still breaks sometimes for reasons unknown to me | 15:15 |
| NoeJeko | but tricipher is in the process of adding a WSDL method to get the SAML | 15:15 |
| NoeJeko | so I don't have to cURL POST and then parse the returned HTML | 15:15 |
| NoeJeko | should end the last of that | 15:15 |
| grantc | nice | 15:15 |
| NoeJeko | also i dont think i cc'd you on this | 15:15 |
| NoeJeko | but we had a couple reports of it breaking | 15:16 |
| NoeJeko | so i added a "click here if this appears more than 10 seconds" | 15:16 |
| NoeJeko | that takes you to a non-AJAX login form | 15:16 |
| NoeJeko | it still bounce, bounce, bounces but at least you get in | 15:16 |
| grantc | is it the same problem as the multiple IP thing kschendel was having? | 15:16 |
| NoeJeko | um, no - at first i thought the user had javascript disabled | 15:17 |
| NoeJeko | but if they had that they wouldn't have gotten the spinning progress indicator at all | 15:17 |
| NoeJeko | basically they clicked login and the progress indicator just remained forever | 15:17 |
| grantc | always happen for them? or was it random? | 15:17 |
| NoeJeko | i think they only tried it once | 15:18 |
| NoeJeko | but they reported it to pam and pam reported it to me/the team as "a friend of rogers had issues" | 15:18 |
| NoeJeko | there's little i can do to account for isolated incidents that i cannot recreate but the "click here if 10 seconds" thing was a quick proactive step i could take to try and prevent them | 15:19 |
| grantc | yes those detailed bug reports are my favourites too | 15:19 |
| Alex| | what else do you need to know other than - it's broken! ? ;p | 15:19 |
| NoeJeko | lol.. i test this stuff on a win vista, win xp, and win 2k3 box, using FF2, FF3, IE6, IE7, opera, safari, and chrome, then on my iphone, PSP, and PS3 before I release it =[ | 15:20 |
| NoeJeko | and yeah, i asked pam if she'll capture some critical data - such as (at the least) browser, OS, and time .. so I can at leastr have a starting point =[ | 15:21 |
| grantc | she should know better being in support :) | 15:22 |
| grantc | as for the browser support - i feel your pain. | 15:22 |
| grantc | different php versions against different Ingres versions on windows/linux/solaris/toaster | 15:23 |
| NoeJeko | do you ever get kschendels with the php driver? by that i mean obscure setups that NO ONE ELSE on earth has? | 15:24 |
| grantc | no not really - the biggest problem is building for php releases | 15:24 |
| grantc | it takes a fair while to do the windows builds and every now and again i get someone on 5.2.3 or something old... | 15:25 |
| grantc | yesterday for example... | 15:25 |
| NoeJeko | those 5.2.3 cats are probably using RHEL | 15:25 |
| grantc | when 5.3 gets released that will be more interesting for me | 15:25 |
| NoeJeko | red hat's repositories are ungodly out of date on some things | 15:26 |
| grantc | yeah - unix peeps can do their own builds | 15:26 |
| grantc | its the windows ones I have issues with | 15:26 |
| grantc | no phpize for windows :[ | 15:26 |
| NoeJeko | ah - yeah most windows users don't build their own | 15:26 |
| NoeJeko | solution: run a real server OS | 15:26 |
| grantc | now there is a thing called easyingres which is making my life a bit more interesting | 15:27 |
| Alex| | ;) | 15:27 |
| NoeJeko | honestly i don't see how they compete in the server market with an OS that has to be rebooted for every change or weekly maintenance | 15:27 |
| Alex| | sometimes I have the feeling you sound a little negative :) | 15:27 |
| NoeJeko | [root@mmog httpd]# uptime | 15:27 |
| NoeJeko | 09:27:41 up 196 days, 11:46, 1 user, load average: 0.00, 0.00, 0.00 | 15:27 |
| grantc | Alex|, it's called being british, an unfortunate national trait | 15:28 |
| Alex| | hehe | 15:28 |
| grantc | the australians call us whinging poms | 15:28 |
| Alex| | your excuse to everything ;p | 15:28 |
| NoeJeko | haha | 15:28 |
| NoeJeko | i thought he meant my attitude towards windows as a server =P | 15:28 |
| grantc | http://www.urbandictionary.com/define.php?term=Whinging Pom | 15:28 |
| grantc | A person of British origin who will consistently complain about any situation that they may face. They are emotionally unable to deal with any sort of adverse condition without commenting negatively about it. - about sums it up :) | 15:29 |
| Alex| | hrhr... | 15:29 |
| NoeJeko | kudos on the progress with the php driver so far though, grant | 15:29 |
| Alex| | Chris Rogers was the first name that came to my mind, reading this :) | 15:29 |
| grantc | as you can tell i am not a "every problem is an opportunity" sort of person | 15:30 |
| NoeJeko | with the pre-100 rows one, there's no way in hell i would have been able to add that "popular download" section to ESD | 15:30 |
| grantc | NoeJeko, cheers - have you seen the docs? | 15:30 |
| grantc | :D | 15:30 |
| NoeJeko | as php/ingres would have taken an hour to query the db | 15:30 |
| grantc | lol | 15:30 |
| NoeJeko | not yet - it's another thing in queue lol | 15:30 |
| grantc | in 2.1.0 you can fiddle with the number of rows | 15:30 |
| NoeJeko | teresa sent me a note about them | 15:31 |
| grantc | understood - i hope to get the review mostly done this week then any additional changes can be done piece meal | 15:31 |
| *** mull has joined #ingres | 15:31 | |
| NoeJeko | yeah today i should have time - everything's done in ESD and i was able to clear a good bit from my queue yesterday | 15:31 |
| NoeJeko | so are we just replacing the documentation on php.net and archiving the 1.4.3 docs on ingres wiki? | 15:32 |
| grantc | cool - I am more interested in what you think is missing i.e. particular problems you have hit that are not addressed | 15:32 |
| grantc | i tagged the 1.4.3 docs so i can recall them and re-generate them | 15:32 |
| grantc | i never heard anything back from the php group regarding "copyright" | 15:33 |
| NoeJeko | well, IMHO | 15:33 |
| NoeJeko | since you don't work for the PHP group and you're the one that submitted them | 15:33 |
| NoeJeko | you should retain copyright | 15:33 |
| grantc | not sure about that | 15:33 |
| grantc | the PHP driver is (c) php group since it was that way when i took over | 15:34 |
| NoeJeko | and its not like they're going to lose traffic from removing dead driver docs to replace with ones that would actually bring new traffic | 15:34 |
| grantc | sure | 15:34 |
| grantc | they just need converting to media wiki | 15:34 |
| NoeJeko | what format are they in for php.net - XML? | 15:35 |
| grantc | the source material is docbook | 15:35 |
| NoeJeko | mm - never heard of that | 15:35 |
| NoeJeko | ill have to look it up | 15:35 |
| grantc | its an XML format for docs | 15:35 |
| grantc | on the one hand its a pain to edit but it allows you to generate web,pdf, .... | 15:36 |
| grantc | http://www.docbook.org/ | 15:38 |
| NoeJeko | so it should be pretty intuitive to write a php script to parse it then spit out wikiformat pages? | 15:38 |
| grantc | let me take a look - the current system, still under development, does have plugins | 15:39 |
| NoeJeko | ah - nothing pressing - was just trying to find a way to automate it since it seems all our plates get fuller by the week | 15:39 |
| grantc | sure - or since there are only 20 pages it can be done once by hand and that's it | 15:40 |
| grantc | i might need to back port some changes from the 2.0 docs but again its a once only effort | 15:40 |
| NoeJeko | haha nothing like trying to find an intuitive way to parse/format the authorit docs outselves =x | 15:41 |
| NoeJeko | (our | 15:41 |
| grantc | yeah - mull had a good go at that | 15:41 |
| grantc | never been the same since :) | 15:41 |
| NoeJeko | well, they have the option to store it in a MSSQL server | 15:41 |
| mull | heh, I did notice that my docs.ingres.com stuff got trashed... that made me sad | 15:42 |
| NoeJeko | so i tried to migrate a library to the MSSQL and then parse it with php | 15:42 |
| mull | my python code to do it was ugly, but it did work | 15:42 |
| NoeJeko | for the record, i don't condone the use of frames as i was forced to do on the new docs.ingres.com... | 15:42 |
| grantc | mull we lost on one hand and gained on another... now we need to sort those frames out | 15:43 |
| mull | NoeJeko: yeah, that was the primary reason that I wrote the python code to translate them to something frameless | 15:43 |
| grantc | NoeJeko, i might have something to convert the docs... | 15:43 |
| NoeJeko | i think the <iframe> tag should go die in a fire but management was pressing to get docs skinned like the rest of the community site and with authorit's limited capabilities i didn't see too many other options | 15:43 |
| NoeJeko | docs... ingres docs or php docs? | 15:44 |
| grantc | it needs some work but as a proof of concept | 15:44 |
| grantc | docs.ingres... | 15:44 |
| NoeJeko | does it involve keeping them out of authorit? | 15:44 |
| grantc | no | 15:44 |
| grantc | unfortunately | 15:44 |
| grantc | or fortunately | 15:44 |
| NoeJeko | haha i met strong resistance when i suggested that | 15:44 |
| grantc | it seems to work for them, all we need is a post process thing that can take the stuff it now generates and de-frame it | 15:45 |
| NoeJeko | well, reading the authorit database itself in MSSQL was a pain in the ass | 15:45 |
| grantc | from what i can tell, it does not take much to do... the javascript needs modifying (since it tests for the frame) and some php code needs injecting... | 15:46 |
| NoeJeko | that's on CA service desk level of complexity | 15:46 |
| grantc | :) | 15:46 |
| NoeJeko | mm - so read the toc into the documentation as a PHP include() or something you're thinking? | 15:47 |
| grantc | yup | 15:47 |
| NoeJeko | interesting - i'll play with that if i get some time | 15:47 |
| grantc | also you need to play with the JS but its not too difficult | 15:47 |
| NoeJeko | i have a copy of authorit | 15:47 |
| NoeJeko | what would be really hot is if the tool could spit out URLs without spaces | 15:48 |
| NoeJeko | and that weren't 256 characters long | 15:48 |
| grantc | i was working on the post generated html | 15:48 |
| grantc | indeed :) | 15:48 |
| NoeJeko | mm - another alternative | 15:48 |
| NoeJeko | the tool can spit out an XML representation of the documentation | 15:49 |
| NoeJeko | so could have PHP parse that and generate the individual pages | 15:49 |
| grantc | i used sed but sure | 15:49 |
| NoeJeko | what's sad | 15:50 |
| NoeJeko | is that we completely lost our pageranks for that documentation | 15:50 |
| NoeJeko | previously, if you googled for anything SQL-grammar related | 15:50 |
| NoeJeko | ingres was in the top 1-4 results | 15:50 |
| NoeJeko | now.. nowhere to be found =[ | 15:50 |
| grantc | yup | 15:51 |
| grantc | i had a blog post I was writting about why documentation is useful then it got updated | 15:52 |
| *** Alex| is now known as Alex|off | 15:52 | |
| NoeJeko | good documentationw is a godsend | 15:52 |
| NoeJeko | 90% oif the reason i haven't coded any projects to date on ingres (other than ESD) is lack of sufficient documentation for the 2.x driver and lack of functionality for the 1.x | 15:53 |
| grantc | err | 15:53 |
| NoeJeko | well, on the side | 15:57 |
| NoeJeko | i'm writing a browser-based strategy game | 15:57 |
| NoeJeko | and i want to write it on ingres | 15:57 |
| grantc | take a look at http://croker.net/~grant/openapi/CreatePasswordStatement.htm.php | 15:57 |
| grantc | ignore the file name... a minor detail | 15:57 |
| NoeJeko | i'm guessing the tables were from authorit? | 15:59 |
| NoeJeko | that's pretty nice - as long as we could wrap the output into our look & feel that would work | 16:00 |
| grantc | yup - i need to sort out the toc | 16:00 |
| grantc | or an alternative would be to set php as the handler | 16:00 |
| NoeJeko | lol i should get going so i get to the office at a reasonable time | 16:02 |
| *** Alex|off is now known as Alex| | 16:12 | |
| *** DerMeister has joined #ingres | 16:35 | |
| *** troal01 has quit IRC | 16:40 | |
| *** troal01 has joined #ingres | 16:42 | |
| *** troal01 has joined #ingres | 16:42 | |
| *** DarylM has joined #ingres | 16:50 | |
| *** troal01 has quit IRC | 16:55 | |
| *** troal01 has joined #ingres | 16:56 | |
| *** troal01 has quit IRC | 17:05 | |
| *** Alex| is now known as Alex|off | 17:05 | |
| *** troal01 has joined #ingres | 17:08 | |
| *** Alex|off is now known as Alex| | 18:59 | |
| *** Alex| is now known as Alex|off | 19:15 | |
| *** troal01 has left #ingres | 21:03 | |
| *** troal01 has joined #ingres | 21:05 | |
| *** troal01 has quit IRC | 21:11 | |
| *** troal01 has joined #ingres | 21:16 | |
| *** troal01 has quit IRC | 21:22 | |
| *** troal01 has joined #ingres | 21:24 | |
| *** troal01 has left #ingres | 21:25 | |
| *** troal01 has joined #ingres | 21:27 | |
| *** rossand has quit IRC | 21:39 | |
| *** thiagomz has quit IRC | 21:39 | |
| *** grantc is now known as grantc_offline | 21:56 | |
| *** DerMeister has quit IRC | 22:08 | |
| *** toumi01 has left #ingres | 22:18 | |
| *** toumi01 has joined #ingres | 22:18 | |
| *** withdefault is now known as notdefault | 22:37 | |
| *** DarylM has quit IRC | 23:38 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!