Monday, 2009-10-26

*** Alex| has quit IRC00:03
*** Alex| has joined #ingres01:10
*** ChanServ sets mode: +o Alex|01:10
*** dyki has joined #ingres01:12
*** grantc has joined #ingres02:34
*** ChanServ sets mode: +o grantc02:34
*** atrofast has quit IRC04:49
*** toumi01 has joined #ingres06:15
*** mull has joined #ingres06:28
*** rossand has joined #ingres06:48
*** ChanServ sets mode: +o rossand06:48
*** atrofast has joined #ingres06:48
*** ccsidiot has joined #ingres06:55
*** DarylM has joined #ingres06:56
*** ccsidiot has left #ingres07:16
*** Dejan has quit IRC07:30
*** ccsidiot has joined #ingres07:47
*** rossand has quit IRC07:49
*** atrofast has quit IRC07:49
*** atrofast has joined #ingres07:51
*** Alex| has quit IRC08:20
atrofastgrantc: Can you add people to our hidden lists at lists.ingres.com?08:24
grantcwhat hidden lists?08:24
atrofastgrantc: codev08:24
ccsidiotHey08:33
ccsidiotI'm Eva08:33
ccsidiotI have one quick question08:33
grantchi eva08:34
DarylMGo ahead08:34
ccsidiotI was getting the php driver for Ingres here http://esd.ingres.com/product/drivers/PHP/Windows_32-Bit/PHP_Driver/08:35
ccsidiotAnd I have Ingres II version 10.008:35
ccsidiotWhen I unzip the package that I download, I didn't spot the folder for Ingres 10.008:36
ccsidiotWhich one shall I pick then?08:36
grantci'll need to build you one as I've not done a dll for that release08:36
ccsidiotOh, that will be great! Thanks so much08:37
ccsidiotOops08:37
ccsidiotToo sleepy08:37
ccsidiotRead that wrong08:37
ccsidiotSo I need to go back and get Ingres 9.3 instead?08:37
ccsidiot@@08:38
ii_logccsidiot: Error: "@" is not a valid command.08:38
ccsidiotSigh, looks like that I need to :(08:38
grantcccsidiot: which PHP release is this for?08:39
ccsidiotIngres08:39
grantcif you can wait 30 minutes i can do a new build of the driver for 10.0.0/10708:39
grantcwhich version of php08:40
ccsidiot5.308:40
atrofastHey grantc how hard is it to set up an environment in Windows to build the Ingres PHP driver?08:40
grantcit's not difficult once you've done it 10 times :)08:40
ccsidiotWow 10 times!08:41
grantcit's not as easy as building it on Linux/UNIX08:41
ccsidiotThanks! I can wait while figuring out other things08:41
grantcit requires a full PHP build environment08:41
DarylM10 times grantc?  I would think you have built and rebuilt that driver around 10,000 times  ..... :-)08:41
grantc:)08:42
grantc@google php windows source08:42
ii_loggrantc: PHP: Downloads: <http://php.net/downloads.php>; PHP: Building from source - Manual: <http://php.net/manual/en/install.windows.building.php>; ImageMagick: Install from Source: <http://www.imagemagick.org/script/install-source.php>; Text ยป Windows Source Code: <http://www.albinoblacksheep.com/text/source>; SpeedGuide.net :: Windows 2k/XP Registry Tweaks: (2 more messages)08:42
grantcthe 2nd link gives you the basic setup you need08:42
atrofastWhich Windows versions are supported?08:43
atrofastProbably not Win 7 64 bit eh? :P08:44
grantcwin x64 is not supported no :)08:45
atrofastI always get burned for running 64 bit :P08:45
atrofastThe only VPN client that works is NCP's and it costs $20008:46
atrofastCisco is not making a 64 bit client for Windows08:46
grantci guess you'll have to wait until we change VPN tech (supposedly planned)08:49
grantcthe ciscovpn tool is not being developed at all now - i believe its their SSL soln or nothing08:50
atrofastgrantc: Yeah that's what I heard too08:50
atrofastJust have to get my VPN business done in Linux, that's all08:51
grantcccsidiot/atrofast - http://wiki.php.net/internals/windows/stepbystepbuild seems to have an improved guide08:51
grantcor get a vpn router08:51
grantcon mac we have the choice of cisco or vpnc...08:51
grantcccsidiot: do you know which PHP type you are running? Thread safe or non-thread safe08:53
ccsidiotOh, how do I check that?08:54
ccsidiotphpinfo()?08:54
ccsidiotYupz08:54
ccsidiotIt says08:54
ccsidiotThread Safety = enabled08:54
grantcccsidiot: http://dl.getdropbox.com/u/2191213/php_ingres.dll MD5sum afc5c73cbb045341351a7fc2fefad61c08:57
ccsidiotWow, thanks so much!08:59
Vroomfondlegrantc: I'm trying to drag our Ingres PHP wrapper function into the 21st century. If I call ingres_fetch_array after sending, say, a CREATE query (or something else which doesn't actually return rows), will the driver get upset at me?09:51
Vroomfondleat the moment our wrapper function differentiates between SELECT and CREATE, UPDATE etc. and I can't quite figure out why09:51
grantcit will tell your mum :)09:52
Vroomfondleheh09:52
grantcthe driver executes SELECT's differently from other statements09:52
Vroomfondlehow so?09:53
grantcor rather the 2.0 driver does - if you want the 2.0 driver to execute the queries the same way as the older driver i.e. not use cursors for selects use ingres_unbuffered_query09:53
grantcwith 9.2 and cursors you can scroll backwards and forwards09:54
Vroomfondlethe wrapper function currently only does the fetch_array stuff if you've sent a SELECT. Otherwise it avoids doing that. I'm wondering if I still need to include this behaviour.09:54
Vroomfondleor can I just make it send the query and then try to do an ingres_fetch_array nomatter what09:55
* grantc is thinking09:55
grantcin theory there should not be any problem - but it's been a while since i've tested that scenario09:56
Vroomfondlewell, I'll assume that it'll work then; I'll be sure to let you know if it doesn't :)09:56
*** DerMeister has joined #ingres09:59
grantc:)09:59
grantcit appears to be harmless from some quick testing09:59
*** grantc has quit IRC10:24
*** Alex| has joined #ingres10:54
*** ChanServ sets mode: +o Alex|10:54
*** ccsidiot has left #ingres11:02
*** zxiiro has joined #ingres11:07
*** ChanServ sets mode: +v zxiiro11:07
*** ccsidiot has joined #ingres13:44
ccsidiotHey14:14
ccsidiotI was following this http://community.ingres.com/wiki/Drupal_on_Ingres_Documentation to get Drupal on Ingres14:15
ccsidiotWhen I have a test.php with this line echo "<?php echo ini_get('extension_dir'); ?>" | php14:15
ccsidiotwhere the test.php is located under htdocs of apache2.214:15
ccsidiotit gives me echo "./"14:15
ccsidiotand I put the php_ingres.dll under apache, it didn't work14:16
pboroyeah, that means that the extension_dir is set to "./" in your php.ini14:16
pboroyou should modify your php.ini to define some proper path to php_ingres.dll or something :)14:16
ccsidiotOkay cool :)14:17
ccsidiotLet me try if that works14:17
pboro; Directory in which the loadable extensions (modules) reside.14:18
pboroextension_dir = "./"14:18
pborothat's the default from php.ini14:18
ccsidiotYea, I can see that comments too14:18
ccsidiotBut I'm wondering if I go ahead and change that14:18
ccsidiotThere are other dlls that I got for getting php and apache communicating14:19
ccsidiotChanging that means I need to move those dlls to the new directory right?14:19
pborohmm... if those dlls do get correctly loaded, then php_ingres.dll should work too... have you added "extension=php_ingres.dll" in the bottom of php.ini?14:21
ccsidiotYes14:21
pborook, what are the other dlls? just name couple of them14:21
ccsidiotphp5apache2_2.dll14:22
ccsidiotphp5ts.dll14:22
ccsidiot:)14:22
pboroand you load those too using extension=php5ts.dll and so on?14:22
pborothose don't look like extensions imo...14:22
pboroso extension_dir should not affect loading them :) just guessing, I have no experience on running apache+php on Windows14:23
ccsidiot^^" Yea, I don't have them14:23
ccsidiotin the list of extensions in php.ini14:23
pboroyeah, so it should be safe to change extension_dir and leave those dlls in the place where they are now14:24
pboroanyway, you can always make extension_dir = "./" if it turns out to be a bad idea :)14:24
ccsidiotYup :) The point that bug me was, I put the php_ingres.dll under the same directory as where I put that line of code14:25
ccsidiotand when I restarted apache, and restart the installation of Drupal14:26
ccsidiotit still can't locate php_ingres.dll14:26
pborohmm under the same directory as the line of code... you mean php.ini?14:27
pboro"./" might not refer to the path containing php.ini but something completely different... try extension_dir = "c:\php\ext" and place dll in c:\php\ext and try again then?14:28
ccsidiotI put that line of code in a toy php file namly test.php under the root of localhost14:28
ccsidiotI have also tried that14:28
pboroyou mean the "<?php echo..." or "extension_dir = ..."?14:28
*** Alex| has quit IRC14:29
ccsidiotYea, I got it, thanks! That was silly, I typed / instead of \14:31
ccsidiotin the path of extension_dir14:31
ccsidiot:D14:31
pboroit works now?14:31
ccsidiotYupz14:31
pborogreat :)14:31
ccsidiotThanks!!!!!!!!!14:31
pborono prob14:31
*** rossand has joined #ingres14:33
*** ChanServ sets mode: +o rossand14:33
ccsidiotOops14:33
ccsidiotNo, it doesn't14:33
ccsidiotIt was recognizing mysql but not ingre14:34
ccsidiotingres14:34
ccsidiotand they are put in the same directory C:/php/ext14:34
ccsidiotI have just commented the line extension=php_mysql.dll and restarted apache14:35
ccsidiotand it still can't find php_ingres.dll14:36
ccsidiotHummmm, I was playing around with other extensions and see if they can be seen by Drupal14:46
ccsidiotI've asked the Drupal people14:48
ccsidiotand their question is14:48
ccsidiotdoes drupal 7 requires the PDO for the database engine? And some other answers that I need php_pdo_ingres.dll14:49
ccsidiotI'm off, thanks for the help14:54
*** ccsidiot has left #ingres14:54
*** DerMeister has quit IRC15:13
*** mull has quit IRC15:21
*** rossand has quit IRC15:25
*** DarylM has quit IRC15:32
*** ccsidiot has joined #ingres18:35
*** toumi01 has left #ingres18:39
*** toumi01 has joined #ingres18:49
*** mull has joined #ingres18:50
*** toumi01 has left #ingres18:56
*** toumi01 has joined #ingres19:03
*** mull has quit IRC19:31
*** toumi01 has quit IRC19:45
ccsidiotHey, I have come in earlier today. I was installing Drupal 7 on Ingres 10.0.0.107, with PHP 5, Apache 2.219:45
ccsidiotOn windows 32 bit xp home sp319:46
ccsidiotand Firefox19:46
ccsidiotI have got the php_ingres.dll from Grant earlier today19:46
ccsidiotfor Ingres version 1019:46
ccsidiotand have extension_dir=C:/php/ext and this line extension=php_ingres.dll in my php.ini under Apache19:47
ccsidiotand when I ran the install.php from drupal, it says Your web server does not appear to support any common database types.19:48
ccsidiotThanks in advance if anyone have gone with this procedure can help me out a little bit20:15
*** dyki has quit IRC20:15
*** dyki has joined #ingres20:19
*** cytrinox_ has joined #ingres20:20
*** cytrinox has quit IRC20:29
*** cytrinox_ is now known as cytrinox20:29
*** ccsidiot has left #ingres20:45
*** ccsidiot has joined #ingres20:45
*** ccsidiot has left #ingres21:16
*** cytrinox has quit IRC22:02
*** zxiiro has quit IRC22:02
*** atrofast has quit IRC22:02
*** cytrinox has joined #ingres22:02
*** zxiiro has joined #ingres22:02
*** atrofast has joined #ingres22:02
*** irc.freenode.net sets mode: +v zxiiro22:02
*** Alex| has joined #ingres22:06
*** ChanServ sets mode: +o Alex|22:06
*** Alex| has quit IRC22:41
*** FrankW has quit IRC23:15

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!