*** Mud <Mud!d44edb12@gateway/web/freenode/ip.212.78.219.18> has joined #ingres | 12:12 | |
*** Mud is now known as Mud2 | 12:12 | |
Mud2 | Hi Majikthise | 12:12 |
---|---|---|
Majikthise | hello | 12:41 |
Mud2 | Majikthise: Any experience with php 5 and ingres_query issues? | 14:17 |
Mud2 | Ubuntu 14.04 | 14:17 |
Majikthise | er, maybe. We do use php5 with ingres here. | 14:21 |
Majikthise | what's up? | 14:21 |
Mud2 | when I run a simple php script with a ingres_query, I get a crash in apache2, but when I run the same php file in cli..its running fine | 14:22 |
Mud2 | the curious part is that it goes wrong on ingres_query.. ingres_link is working fine | 14:23 |
Mud2 | [core:notice] [pid 2180] AH00051: child pid 2198 exit signal Segmentation fault (11), possible coredump in /tmp/apache-coredumps | 14:23 |
Mud2 | but there is no dumpfile.. | 14:24 |
Mud2 | out of var_dump($result): string(17) "WAUZZZ4B23N112820" 'chs_num' => .... etc etc in the cli :) I compared the difference between php.ini in the cli folder and in the apache2, and corrected those in the apache2 php.ini file, but no difference.. | 14:26 |
Majikthise | which version of the driver? | 14:26 |
Mud2 | of php? of ingres client? | 14:27 |
Majikthise | well, which version of both :) | 14:27 |
Majikthise | it might be https://bugs.php.net/bug.php?id=65434 ? | 14:29 |
Mud2 | pecl/ingres is already installed and is the same as the released version 2.2.4 | 14:29 |
Mud2 | and ingres client installation file: ingres-10.2.0-100-eval-linux-ingbuild-x86_64 | 14:30 |
Majikthise | in fact it rings a bell, as we actually used a hacked version of the drivers here because we had weird segfaults when we moved to Linux. Unfortunately I can't remember the details of what we did :/ | 14:31 |
Majikthise | the PHP driver's a bit neglected these days I think. Actian don't seem to bother fixing any of the bugs that are still open on PECL. | 14:32 |
Mud2 | aha..so is in the pecl driver? | 14:32 |
Majikthise | the PECL driver is the same as the one you have | 14:33 |
Mud2 | on ubuntu 8.04 LTS with PECL ingres 2.2.1 stable I dont have any problems | 14:34 |
Mud2 | but I have to upgrade to ubuntu 14.04 because of newer version of php5 and Zend Framework 2 + OsTicket... | 14:35 |
Mud2 | is it somehow possible to get the 2.2.1 version somewhere to try that out ? | 14:36 |
Majikthise | it might be easiest for you to just use ODBC instead? We almost did that when we migrated to Linux, because we'd had so many problems with the native Ingres driver over the years | 14:36 |
Mud2 | also I cant make a dumptrace with gdb, ingres in a bit hard to get working with apache2 in single user mode.. | 14:36 |
Majikthise | yeah you can get the old one from https://pecl.php.net/package/ingres and compile it | 14:36 |
Mud2 | so cant tell you if it is that bug | 14:36 |
Majikthise | you'd probably have to update the PHP version string 2.2.1 code, mind. | 14:38 |
Majikthise | to make it work with PHP versions greater than 5.3 | 14:38 |
Mud2 | aha ok | 14:39 |
Mud2 | Majikthise, never worked with ODBC before? Which packages I need and do you have guide? | 14:39 |
Mud2 | before? = before. | 14:39 |
Mud2 | already installed php5-odbc but it does not reconize odbc_connect yet | 14:40 |
Majikthise | you basically have to install UnixODBC, which will be in the Ubuntu repos so that's easy, and then you get Ingres to generate a config file for you and you put the generated config into the UnixODBC config files. If you go to http://docs.actian.com and read the Connectivity manual for Ingres, you'll find some instructions in there somewhere | 14:41 |
Mud2 | I have tried to work before with actian-vector-client-4.2.0-202-free-linux-deb-amd64, but never figured out how that worked | 14:41 |
Mud2 | aha..I gonna read that :) | 14:41 |
Majikthise | unfortunately getting anything non-Java-based to connect to Ingres is like pulling teeth :/ I do actually quite like Ingres these days but blimey, they make it hard. | 14:42 |
Mud2 | Yes | 14:43 |
Majikthise | the PHP driver used to be maintained by a nice bloke called Grant, who was very responsive (he used to hang around in this channel) but then he went away somewhere and since then they seem to have largely ignored PHP | 14:43 |
Majikthise | and Python (I use the ODBC driver for that) | 14:44 |
Mud2 | Ever tried to install ingres-10.2.0-100-eval-linux-ingbuild-x86_64 ? on Ubuntu 14.04? You have to do dirty tricks to get it working.. | 14:44 |
Majikthise | no, I've not tried that. We use RHEL here, and we install Ingres from the tar-based distribution because we've never had much like with the OS-specific packages. | 14:45 |
Majikthise | *much luck | 14:45 |
Mud2 | ah ok :) | 14:46 |
Mud2 | Which project/product I have to select on the docs page? Just Ingres 10 ? | 14:46 |
Majikthise | 10.2 I suppose | 14:51 |
Majikthise | but I don't think the procedure's changed much lately | 14:51 |
Majikthise | so the instructions for any version of 10 will probably do | 14:51 |
Mud2 | Alright, thanks! | 14:53 |
Mud2 | hmm the odbc utility works a bit different then the netutil... grr :P | 14:59 |
Mud2 | Weekend, afk :) | 15:02 |
Majikthise | heh, enjoy :) | 15:02 |
Mud2 | thanks for all your help! | 15:02 |
Majikthise | no problem, good luck | 15:02 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!