Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have connected an openSUSE LAMP and an Ubuntu LAMP server to DB2 using ODBC. The openSUSE system we're using for a development environment, and the final deployment is to be on the Ubuntu system. On Ubuntu we get segfaults when SQL statements return nulls (see links to related bug reports), but this does not happen on openSUSE. Both machines are running 64-bit, here are the versions of both boxes and their software:

OS         Version    Kernel                Apache    PHP
openSUSE   12.2       3.4.11-2.16-default   2.2.22    5.3.15
Ubuntu     11.04      2.6.38-11-server      2.2.17    5.3.22-1~dotdeb.0
                                       (upgraded from 5.3.5-1ubuntu7)


Reading the changelog on php.net it looked like the bug was fixed in 5.3.11 but upgrading still has not solved our issue. I have finally compared phpinfo() output from both servers line-by-line and found one portion that seems like a red flag, but no idea how to fix this. In the ODBC section the ODBC_LFLAGS option shows:

openSUSE     -L/usr/lib64
Ubuntu       -L/usr/lib

Both systems are 64-bit, and are configured to use the 64-bit version of iSeriesAccess and unixODBC. iSeriesAccess had to be converted from RPM using alien as IBM doesn't support Ubuntu. Unfortunately upgrading Ubuntu or switching distros are not options for us. How can I switch Ubuntu to use /usr/lib64 for ODBC_LFLAGS? Also is there any other problem I may have overlooked?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.