ID: 27553 Updated by: [EMAIL PROTECTED] Reported By: bradleyb at trans-soft dot net -Status: Open +Status: Bogus Bug Type: ODBC related Operating System: redhat 9 PHP Version: 4CVS-2004-03-11 New Comment:
PHP does not open odbc.ini file, it's the duty of unixODBC. And if unixODBC leaves the file open there is nothing PHP can do about it. Report to the unixODBC authors. Previous Comments: ------------------------------------------------------------------------ [2004-03-15 10:05:37] bradleyb at trans-soft dot net configure line: './configure' '--prefix=/opt/php4-STABLE-200403111430' '--with-apxs=/opt/httpd/bin/apxs' '--with-unixODBC' ------------------------------------------------------------------------ [2004-03-13 04:59:10] [EMAIL PROTECTED] I was asking for the configure line you used to configure PHP sources befor 'make'. (you can find that in the phpinfo() output..) ------------------------------------------------------------------------ [2004-03-11 11:01:39] bradleyb at trans-soft dot net Upated server to the latest stable version, but we are still encountering the problem with the odbc.ini file being left open by the apache process even with explicit call to odbc_close(). As requested, here is our configuration file (php.ini) path: /opt/php4-STABLE-200403111430/lib/php.ini ------------------------------------------------------------------------ [2004-03-10 19:45:48] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Also give us your full configure line used to configure PHP. ------------------------------------------------------------------------ [2004-03-10 18:00:49] bradleyb at trans-soft dot net Description: ------------ When i make a connection to my sybase db using odbc_connect, apache leaves the odbc.ini file open even thought i call odbc_close(). I am unable to figure out how to get these files closed. I have done quite a bit of research but am unable to locate any one who has experienced this issue. Apache is the User assigned to the file which is located -> etc/odbc.ini At the top of each page that i load is an include statement that creates a connection to the db. When i have finished running my query (odbc_do()), i call odbc_close(). For each page that is loaded, a new instance of odbc.ini is opened for each call to odbc_connect(). I verify this by using -> lsof odbc.ini in the etc/ directory. Reproduce code: --------------- $db = odbc_connect($DSN, $dbUserName, $dbPassWord); if(!$db) { die("Failure to connect to DB"); } if(@ $dbResource = odbc_do($db, $query)) { if(@ odbc_fetch_row($dbResource)) { $myData = odbc_result $dbResource, "ColumnName"); } odbc_close($db); } Expected result: ---------------- The odbc.ini file descriptor located in the etc/ directory to be closed. Actual result: -------------- file is left open? lsof odbc.ini COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME httpd 20268 apache 8r REG 3,6 1105 244685 odbc.ini ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27553&edit=1
