[RESOLVED] php.ini not loading

[jmoore2141]

I have windows dev environment and a unix test environment both using odbc as the connection method. On windows I modify a line in php.ini for the purpose of expanding odbc variable limits. When apache is bounced I can see that longtext results are no longer truncated. When I apply the same change to the unix instance and bounce apache, no effect occurs. The line I modify is:

original

; Handling of LONG fields. Returns number of bytes to variables. 0 means
; passthru.
odbc.defaultlrl = 4026

to

; Handling of LONG fields. Returns number of bytes to variables. 0 means
; passthru.
odbc.defaultlrl = 99999

Is there a simple way that I can validate that php.ini is loading when apache starts or alternatively force this same objective through some other manner.

Thank you ,

Josh

--the following are results from phpinfo()

--System SunOS toadfish 5.10 Generic_125100-09 sun4u

Build Date May 7 2007 06:45:52

Configure Command './configure' '--with-apxs2=/rsstest/apache2/bin/apxs' '--with-mysql=/rsstest/mysqlt' '--with-mysqli=/rsstest/mysqlt/bin/mysql_config' '--with-unixODBC=/usr/lib' '--enable-sockets' '--with-config-file-path=/rsstest/etc/php.ini'

Server API Apache 2.0 Handler

Virtual Directory Support disabled

Configuration File (php.ini) Path /rsstest/etc/php.ini

PHP API 20041225

PHP Extension 20060613

Zend Extension 220060519

Debug Build no

Thread Safety disabled

Zend Memory Manager enabled

IPv6 Support enabled

Registered PHP Streams php, file, data, http, ftp

Registered Stream Socket Transports tcp, udp, unix, udg

Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert., consumed, convert.iconv.

[bpat1434]

Yes. Create a script and in it just call this one function: [man]phpinfo/man.

Echo that out, and you'll have a slew of information available to you. Towards the top you should see a "Configuration File (php.ini) Path". Just make sure that's where your php.ini file is, and it will be loaded.

If that's not where your php.ini file is located, just add the directive "PHPIniDir" to the apache conf, and point it to your php.ini 😉

Now, dealing with the ODBC issue, I can't even find Apache documentation on it....

[jmoore2141]

Thank you for the response. I included a dump of phpinfo in the original thread and validated that I am updating the correct file. I believe that what is occurring is that the odbc options are being skipped over on the unix machine because for whatever reason unix odbc is being recognized differently from that on the windows configuration. In any event I have added an alternate connection and am retrieving that data using mysqli which I've discovered does not truncate the data. Thanks again.

Josh