php-groups.com | Post Question | Search | About | Groups | Contact | Register | Login


New in This Group

#50223 [NEW]: foreach() affects array pointer unexpectedly (different between PHP versions)
11/18/2009 11:44:27 PM

#50222 [NEW]: can't disable magic_quotes_gpc support
11/18/2009 11:21:53 PM

#50220 [NEW]: file_exists fails for files on network share
11/18/2009 2:55:48 PM

#50219 [NEW]: soap call Segmentation fault on a redirected url
11/18/2009 2:41:59 PM

#50215 [NEW]: Parent: child process exited with status 3221225477 -- Restarting.
11/18/2009 10:22:50 AM

#50214 [NEW]: IPv6 with fsockopen broken
11/18/2009 10:08:29 AM

#50213 [NEW]: impossible to delete header
11/18/2009 5:56:05 AM

#50212 [NEW]: SEGV by ldap_get_option() with LDAP_OPT_NETWORK_TIMEOUT
11/18/2009 1:29:30 AM

#50210 [NEW]: PHP won't parse multipart/form-data if it was originally chunk encoded.
11/17/2009 10:46:23 PM

#50209 [NEW]: Compiling with libedit cannot find readline.h
11/17/2009 9:49:34 PM

#50595 [NEW]: Mysqlnd extension needs to read my.ini file for sanity Reply

Group: php.bugs Subscribe Posted:12/28/2009 7:53:21 PM Replies:2 Views:29 Items(2)
From: tallyce at gmail dot com
Operating system: Windows7
PHP version: 5.3.1
PHP Bug Type: MySQL related
Bug description: Mysqlnd extension needs to read my.ini file for sanity

Description:
------------
http://au2.php.net/manual/en/migration53.incompatible.php
states that the Mysqlnd driver doesn't read the my.ini file but
instead that mysqli_options() should be used to tell PHP about
settings.

Can I plead the developers to have a mysqlnd.inifile option or
similar?

This latest change is very regressive: it means that, for instance, if
your database files are stored in a non-standard location, e.g. a data
rather than OS C: disk (as specified in my.ini), or any other
performance-related setting, these all have to be manually added to
script files, making them completely non-portable, or editing through
third-party apps (making it time-consuming to upgrade).

If such an ini option were added, might it just be a case of just
parsing the specified file and passing the found values into whatever
interface mysqli_options is using?

Reproduce code:
---------------
n/a

Expected result:
----------------
n/a

Actual result:
--------------
n/a

--
Edit bug report at http://bugs.php.net/?id=50595&edit=1
--
Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=50595&r=trysnapshot52
Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=50595&r=trysnapshot53
Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=50595&r=trysnapshot60
Fixed in SVN: http://bugs.php.net/fix.php?id=50595&r=fixed
Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=50595&r=needdocs
Fixed in release: http://bugs.php.net/fix.php?id=50595&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=50595&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=50595&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=50595&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=50595&r=support
Expected behavior: http://bugs.php.net/fix.php?id=50595&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=50595&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=50595&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=50595&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=50595&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=50595&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=50595&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=50595&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=50595&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=50595&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=50595&r=mysqlcfg

php-b...@lists.php.net ("tallyce at gmail dot com")
12/28/2009 7:53:21 PM




ID: 50595
Updated by: johannes@php.net
Reported By: tallyce at gmail dot com
-Status: Open
+Status: Feedback
Bug Type: Feature/Change Request
Operating System: Windows7
PHP Version: 5.3.1
New Comment:

Which settings would you actually need to set for the client in my.cnf?
- The server will read it's settings anyways.


Previous Comments:
------------------------------------------------------------------------

[2009-12-28 19:53:21] tallyce at gmail dot com

Description:
------------
http://au2.php.net/manual/en/migration53.incompatible.php
states that the Mysqlnd driver doesn't read the my.ini file but
instead that mysqli_options() should be used to tell PHP about
settings.

Can I plead the developers to have a mysqlnd.inifile option or
similar?

This latest change is very regressive: it means that, for instance, if

your database files are stored in a non-standard location, e.g. a data

rather than OS C: disk (as specified in my.ini), or any other
performance-related setting, these all have to be manually added to
script files, making them completely non-portable, or editing through
third-party apps (making it time-consuming to upgrade).

If such an ini option were added, might it just be a case of just
parsing the specified file and passing the found values into whatever
interface mysqli_options is using?

Reproduce code:
---------------
n/a

Expected result:
----------------
n/a

Actual result:
--------------
n/a


------------------------------------------------------------------------


--
Edit this bug report at http://bugs.php.net/?id=50595&edit=1

johan...@php.net
12/29/2009 12:12:45 PM

ID: 50595
User updated by: tallyce at gmail dot com
Reported By: tallyce at gmail dot com
-Status: Feedback
+Status: Open
Bug Type: Feature/Change Request
Operating System: Windows7
PHP Version: 5.3.1
New Comment:

In my case, the data files are too big to fit on the C: driver, so
placing them in the MySQL subdirectory (under program files) is not an

option. So, the "datadir" setting in my.ini is set to be elsewhere. (In

the end I used a Windows7 symlink as a workaround, but this feels like
a
rather unsatisfactory hack.)

I don't know which settings are still read by the MySQL server process,

but this one at least is ignored by PHP.

Either way, it seems odd that one should go through the process of
setting up and tuning a MySQL server and then have the key program that

reads the data simply ignore the settings, following the release of PHP

5.3.x.


Previous Comments:
------------------------------------------------------------------------

[2009-12-29 12:12:45] johannes@php.net

Which settings would you actually need to set for the client in my.cnf?
- The server will read it's settings anyways.

------------------------------------------------------------------------

[2009-12-28 19:53:21] tallyce at gmail dot com

Description:
------------
http://au2.php.net/manual/en/migration53.incompatible.php
states that the Mysqlnd driver doesn't read the my.ini file but
instead that mysqli_options() should be used to tell PHP about
settings.

Can I plead the developers to have a mysqlnd.inifile option or
similar?

This latest change is very regressive: it means that, for instance, if

your database files are stored in a non-standard location, e.g. a data

rather than OS C: disk (as specified in my.ini), or any other
performance-related setting, these all have to be manually added to
script files, making them completely non-portable, or editing through
third-party apps (making it time-consuming to upgrade).

If such an ini option were added, might it just be a case of just
parsing the specified file and passing the found values into whatever
interface mysqli_options is using?

Reproduce code:
---------------
n/a

Expected result:
----------------
n/a

Actual result:
--------------
n/a


------------------------------------------------------------------------


--
Edit this bug report at http://bugs.php.net/?id=50595&edit=1

php-b...@lists.php.net ("tallyce at gmail dot com")
1/2/2010 1:51:02 PM


Reply:
| or Email(not shown): Name: | Register | Login

Alert me when someone responds to this posting.











Newest Articles

note 97095 added to soapclient.soapclient
4/1/2010 5:58:19 AM

note 97094 added to function.sqlite-changes
4/1/2010 5:06:46 AM

note 97093 added to function.sqlite-changes
4/1/2010 5:06:21 AM

note 97092 added to ref.xmlrpc
4/1/2010 4:52:18 AM

note 97091 added to function.var-export
4/1/2010 3:32:03 AM