*** grantc has joined #ingres | 00:30 | |
*** ChanServ sets mode: +o grantc | 00:30 | |
*** Alex| has joined #ingres | 00:35 | |
*** ChanServ sets mode: +o Alex| | 00:35 | |
*** cthibert has joined #ingres | 02:16 | |
*** tanjir has quit IRC | 02:17 | |
*** cthibert has left #ingres | 02:30 | |
*** cthibert has joined #ingres | 02:41 | |
*** Gerhard has joined #ingres | 02:52 | |
Gerhard | Hi all | 02:59 |
---|---|---|
Vroomfondle | grantc: you about? | 02:59 |
grantc | hi Vroomfondle | 03:00 |
Vroomfondle | :) | 03:00 |
grantc | hi Gerhard | 03:00 |
Vroomfondle | I'm seeing: PHP Warning: ingres_query() [<a href='function.ingres-query'>function.ingres-query</a>]: ii_success : Server or API error - no error message available, status 8 | 03:00 |
grantc | that's not good | 03:00 |
Vroomfondle | I suspected not | 03:00 |
grantc | is it something you can reproduce simply¿ | 03:01 |
Vroomfondle | I think I've just found the problem. | 03:02 |
Vroomfondle | well, the cause | 03:02 |
Vroomfondle | if I send a parameterised query, I get that message | 03:03 |
Vroomfondle | if I just interpolate the params into the SQL string myself and don't send them to ingres_query, the problem goes away | 03:03 |
Vroomfondle | do parameterised queries work at all with Ingres 2.6? | 03:03 |
Vroomfondle | (we're moving to 9.2 ASAP, so if it's just an incompatibility then I can wait) | 03:04 |
grantc | if you can email the help table/create table def and the select to grantc@php.net i'll take a look | 03:05 |
Vroomfondle | ok, I'll see what I can do | 03:06 |
grantc | the param queries should work with 2.6, although i've not tested that release | 03:06 |
grantc | it could be a problem with the DESCRIBE code | 03:06 |
grantc | another quick test would be to do "ingres_unbuffered_query" | 03:06 |
Vroomfondle | we don't seem to have ingres_unbuffered_query | 03:08 |
Vroomfondle | I think we've got a slightly old ver of the driver | 03:08 |
grantc | which release do you have? | 03:09 |
grantc | see http://svn.php.net/repository/pecl/ingres/trunk/CHANGELOG for the list of changes you are missing, lots... | 03:10 |
Vroomfondle | Ingres Extension Version => 2.0.0 | 03:10 |
Vroomfondle | yeah, I know | 03:10 |
Vroomfondle | I've asked our admin to install the latest version | 03:10 |
Vroomfondle | but it'll probably take him ages to get around to it :/ | 03:10 |
grantc | i would *strongly* recommend you upgrade 2.1 has performance fixes | 03:11 |
Vroomfondle | grantc: sent | 03:20 |
grantc | ok, i'll try an look at it later on today. | 03:22 |
Vroomfondle | k. I just tried a simpler SQL and it still failed; have sent that to you to make things easier for you | 03:23 |
grantc | it could be the null values causing problems | 03:23 |
Vroomfondle | well, they should be blank strings rather than actual nulls (though I forget if PHP actually differentiates between the two) | 03:24 |
Vroomfondle | as they originally come from POST | 03:24 |
grantc | it will be a PHP string not a NULL - i have a feeling there is a fix in SVN for this | 03:25 |
grantc | http://pecl.php.net/bugs/bug.php?id=16752 | 03:25 |
Vroomfondle | Aha. | 03:27 |
Vroomfondle | yes - changing them to single spaces works | 03:29 |
grantc | http://dl.getdropbox.com/u/2191213/ingres-2.2.2.tgz contains the fix | 03:30 |
Vroomfondle | any idea when that's likely to hit PECL? | 03:31 |
Vroomfondle | I'll have a hard time convincing my boss & our admins to recompile the module from a TGZ | 03:32 |
grantc | i need to run the code through the test suite and do a build for all platforms | 03:32 |
grantc | unless there is a problem it will be the same TGZ file that will be uploaded to pecl | 03:32 |
grantc | also wget http://pecl.php.net/get/ingres - would also download the same file | 03:35 |
grantc | when it gets uploaded... so I am not sure what the problem is. If you'd rather I send you the file via email from my ingres.com address so it's "more official" rather than it being downloaded from some anon url :) | 03:36 |
grantc | or you can download it through SVN | 03:37 |
Vroomfondle | well, is running it through the test suite just a formality? | 03:38 |
Vroomfondle | basically there's no way my boss is going to let me run a driver on our server unless it's been confirmed as working | 03:39 |
Vroomfondle | actually, perhaps I can just ask to have it installed on our test server for now | 03:41 |
Vroomfondle | my code won't be ready for a month or so anyway... | 03:41 |
* Vroomfondle speaks to his boss, and gains agreement to put the new version on the test server | 03:46 | |
Vroomfondle | thanks, grantc | 03:46 |
grantc | no problem - i'm looking at the test suite now and the 3 tests for that bug fail in the test suite but run ok in isolation... | 03:47 |
grantc | something is screwed up | 03:47 |
* grantc goes back to ruby | 03:47 | |
*** toumi01 has joined #ingres | 04:07 | |
*** atrofast has joined #ingres | 04:09 | |
grantc | hi atrofast | 04:14 |
atrofast | Hi grantc | 04:16 |
grantc | i see your students are having fun with drupal on windows | 04:17 |
atrofast | Yeah, which is one area I haven't tinkered with much | 04:18 |
atrofast | Thanks for helping out on the mailing list | 04:19 |
grantc | perhaps you or eva could add a section for Windows steps? | 04:19 |
grantc | I need to do a write up for Ingres on Windows with IIS and Apache but it's not on my priority list right now | 04:19 |
atrofast | Good idea, I'm a bit Linux centric, didn't think anyone would want to set up Drupal on Windows :P | 04:21 |
*** Gerhard has quit IRC | 04:39 | |
*** cthibert has quit IRC | 05:08 | |
*** cthibert has joined #ingres | 05:34 | |
*** Gerhard has joined #ingres | 05:52 | |
*** mull has joined #ingres | 06:04 | |
*** atrofast has quit IRC | 06:36 | |
*** atrofast has joined #ingres | 06:42 | |
*** Alex| has quit IRC | 07:17 | |
*** Gerhard has quit IRC | 07:32 | |
*** FrankW has joined #ingres | 07:39 | |
*** ccsidiot has joined #ingres | 07:50 | |
*** atrofast has quit IRC | 08:29 | |
*** atrofast has joined #ingres | 08:31 | |
*** ccsidiot2 has joined #ingres | 08:56 | |
* ccsidiot2 slaps ccsidiot with a big red brick | 08:57 | |
*** ccsidiot has quit IRC | 09:02 | |
*** ccsidiot2 has left #ingres | 09:21 | |
*** ccsidiot2 has joined #ingres | 09:21 | |
*** ccsidiot2 has left #ingres | 09:21 | |
*** ccsidiot has joined #ingres | 09:22 | |
ccsidiot | Hey, I have just noticed after changing the variables listed under Configuring Apache and Ingres of the Drupal on Ingres documentation | 09:25 |
ccsidiot | My IngresIJ instance is not started up properly | 09:26 |
ccsidiot | The primary Transaction Log | 09:26 |
ccsidiot | has a dark green circle and the Dual Transaction Log does not even have a circle | 09:27 |
ccsidiot | And the tooltip near the bottom right says that "Ingres[IJ] Started > default count" | 09:28 |
ccsidiot | Is that normal? | 09:28 |
DarylM | Is that different than before? (Green normally is good. I am not sure if there are "shades" of green.....) | 09:28 |
ccsidiot | Yes, it is different than before | 09:29 |
ccsidiot | It used to have a shocking green colour | 09:29 |
ccsidiot | before I configure those values | 09:29 |
ccsidiot | Now it started up as a dark green colour | 09:30 |
grantc | dark green means there is something running which is not configured to run | 09:30 |
grantc | not a problem in itself | 09:30 |
DarylM | I am not sure the primary transaction log would ever NOT be configured to run.... ;-) | 09:31 |
grantc | DarylM: I have an Ingres gem to play with if you are feeling brave | 09:31 |
grantc | indeed - i have never liked IVM | 09:32 |
DarylM | I am very brave | 09:32 |
DarylM | lol | 09:32 |
DarylM | Sadly, since I have not really had an opportunity to read the Drupal documentation, I can't predict what types of problems might occur making the recommended changes. | 09:33 |
grantc | http://dl.getdropbox.com/u/2191213/Ingres-1.4.0.gem | 09:33 |
grantc | i guess the gem won't build on OS X :) | 09:33 |
DarylM | I have a Linux server | 09:34 |
ccsidiot | I'm blogging my progress and stuffs to watch out for when install all these on windows on my blog | 09:34 |
ccsidiot | http://i-wa.blogspot.com/ | 09:34 |
ccsidiot | And I'll definitely compile a complete list when we've gone through all these configurations | 09:35 |
ccsidiot | :D | 09:35 |
grantc | ccsidiot: feel free to update the wiki page, i am sure atrofast won't mind | 09:35 |
ccsidiot | I have also emailed him personally, we've been talking about this too :) | 09:36 |
grantc | :) | 09:37 |
ccsidiot | So back to my question, sounds like it should give me a shocking green light | 09:38 |
ccsidiot | Are changing those values significant in configuring Apache with Ingres? I think the path variables and all those matters more right? | 09:39 |
ccsidiot | Are those variables only for performance? | 09:39 |
atrofast | Some config values have to be updated in Ingres for Drupal to work properly | 09:39 |
atrofast | Specifically the cursor limit, and system max locks | 09:40 |
grantc | can you paste your ingres\files\errlog.log to http://ingres.pastebin.com | 09:40 |
ccsidiot | Oh, I see :), okay, let me check the errlog | 09:40 |
ccsidiot | My log for yesterday is really long though | 09:49 |
ccsidiot | http://ingres.pastebin.com/m1c2718d0.txt | 09:52 |
ccsidiot | Oops, I mean today | 09:52 |
grantc | that looks ok - i guess it's IVM which has got confused | 09:54 |
ccsidiot | What's IVM? :( | 09:54 |
ccsidiot | The ingres vertual Machine? | 09:54 |
ccsidiot | :P | 09:54 |
grantc | Ingres Visual Manager - the green icon in your task bar | 09:55 |
ccsidiot | Oh, I see | 09:55 |
grantc | DarylM: can you see http://inspect.ingres.com/r/43/ | 09:55 |
ccsidiot | Okay :) | 09:55 |
DarylM | yes | 09:56 |
grantc | can you download the diff and apply it to your OS X box | 09:56 |
grantc | i want to make sure it works ok since I don't have access any more to Ingres on OS X | 09:57 |
DarylM | yea, I'll have to resync to svn. | 09:57 |
DarylM | I keep both a 32 bit svn build and a 64 bit svn build up to date as well as the driver respository | 09:57 |
grantc | how do you build ingres in 32 bit mode on SL? | 09:58 |
DarylM | nothing special, it just builds. I worked with J to get the porting stuff right. | 09:59 |
DarylM | There is a new tag in the VERS file which switches the build to 64bit mode | 10:00 |
DarylM | ingres.gem worked fine on Linux but as expected it didn't build on OS/X. Unfortunately the "gem install" command gives little information for diagnosis. | 10:01 |
grantc | it's missing the extern and the librt change.. | 10:02 |
DarylM | ah | 10:03 |
grantc | how did you get around http://inspect.ingres.com/r/43/ | 10:05 |
grantc | oops i meant http://ingres.pastebin.com/d5db8d6e2 | 10:05 |
DarylM | don't recall seeing that. Let me check on it. | 10:06 |
DarylM | No error here. Not sure. | 10:08 |
DarylM | I am relatively sure I have not modified my 32 bit build tree but as I am a bit (lot) of a hack I can't be sure without checking :-) | 10:09 |
grantc | hmm ok :) | 10:09 |
grantc | i'm doing an update now so we'll see | 10:09 |
DarylM | 10.6.1 (Darwin Kernel Version 10.0.0: Fri Jul 31 22:47:34 PDT 2009) | 10:10 |
grantc | ditto | 10:10 |
DarylM | To quote one of my favorite characters: "Fascinating" | 10:11 |
DarylM | yuck. All that _SIZE_ stuff is in compat.h I hate that file. Humans can't be expected to read all those nested ifdefs | 10:13 |
* DarylM is getting hungry. That Irish pub down the street is looking very nice | 10:14 | |
ccsidiot | Grant: I forgot which option that I've picked (as a web service/locally), | 10:22 |
ccsidiot | for apache | 10:22 |
ccsidiot | so I have tried also to run from command line to start apache from there | 10:22 |
grantc | in the task manager you can see what user apache is running as - if it's system then its as a service | 10:24 |
ccsidiot | Oh | 10:28 |
ccsidiot | I see | 10:28 |
ccsidiot | It's running locally | 10:28 |
ccsidiot | How do I start apache from this command prompt? - cmd /k C:\Program Files\Ingres\IngresIJ\bin\setingenvs.bat | 10:34 |
grantc | i guess you can run the apache binary, httpd.exe | 10:41 |
grantc | from wherever it's installed | 10:41 |
bonsaikitten | barbaric! :) | 10:42 |
ccsidiot | Thanks! I'll continue 1 hour later :) | 10:51 |
ccsidiot | Class | 10:51 |
ccsidiot | ttul | 10:51 |
* grantc is away: slopes off | 11:05 | |
*** Alex| has joined #ingres | 11:06 | |
*** ChanServ sets mode: +o Alex| | 11:06 | |
*** ccsidiot has quit IRC | 11:24 | |
*** cthibert has left #ingres | 11:28 | |
*** ccsidiot has joined #ingres | 12:12 | |
ccsidiot | Hi guys, for configuring apache with Ingres, my phpinfo is bringing up the correct values for II_SYSTEM and path under environment section of additional modules, and I start off the apache instance httpd.exe from this command window "cmd /k C:\Program Files\Ingres\IngresIJ\bin\setingenvs.bat" | 12:34 |
ccsidiot | At this step, I tried the drupal installation from http://localhost:8080/drupal-6.14/install.php, at the database part, it's stucked | 12:35 |
ccsidiot | It's stucked at database configuration | 12:38 |
*** Alex| has quit IRC | 12:56 | |
ccsidiot | :( | 13:40 |
*** monda07 has joined #ingres | 13:57 | |
monda07 | I had to try out the SeaMonkey IRC chat tool (ChatZilla) :-) | 13:57 |
*** monda07 has quit IRC | 14:18 | |
*** ccsidiot has quit IRC | 14:36 | |
*** ccsidiot has joined #ingres | 14:37 | |
*** atrofast has quit IRC | 15:06 | |
*** atrofast has joined #ingres | 15:06 | |
*** DarylM has quit IRC | 15:26 | |
*** mull has quit IRC | 15:28 | |
*** toumi01 has left #ingres | 15:32 | |
*** cytrinox_ has joined #ingres | 20:20 | |
*** cytrinox has quit IRC | 20:21 | |
*** cytrinox_ is now known as cytrinox | 20:21 | |
*** ccsidiot has left #ingres | 22:11 | |
*** grantc_ has joined #ingres | 23:23 | |
*** ChanServ sets mode: +o grantc_ | 23:23 | |
*** Alex| has joined #ingres | 23:36 | |
*** ChanServ sets mode: +o Alex| | 23:36 | |
*** grantc has quit IRC | 23:37 | |
*** grantc_ has quit IRC | 23:40 | |
*** grantc has joined #ingres | 23:43 | |
*** ChanServ sets mode: +o grantc | 23:43 | |
*** grantc_ has joined #ingres | 23:43 | |
*** ChanServ sets mode: +o grantc_ | 23:43 | |
*** grantc_ was kicked by grantc (grantc) | 23:51 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!