[Bug 1205162] New: PHP mysqli not load from web after upgrade
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162 Bug ID: 1205162 Summary: PHP mysqli not load from web after upgrade Classification: openSUSE Product: openSUSE Distribution Version: Leap 15.4 Hardware: Other OS: openSUSE Leap 15.4 Status: NEW Severity: Normal Priority: P5 - None Component: Other Assignee: screening-team-bugs@suse.de Reporter: novell@regproctor.com QA Contact: qa-bugs@suse.de Found By: --- Blocker: --- Everything is described here: https://forums.opensuse.org/showthread.php/576937-mysqli-doesnt-work?highlig... however in short: Once having done a distribution upgrade from leap 15.3 to 15.4 the PHP MySQLi module won't load when running from the web unless you add the line: extension=mysqlnd somewhere in a used php.ini. However, when running PHP from the command line (CLI mode) the module loads correctly which also means that when you add the line then from then on in CLI mode you will get the warning: PHP Warning: Module 'mysqlnd' already loaded in Unknown on line 0 I guess you could avoid the warning by adding the line in: /etc/php7/apache/php.ini which I should add the fact into the above referenced forum post. -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162#c1
Eric Schirra
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162
Eric Schirra
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162#c8
--- Comment #8 from Reg Proctor
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162#c9
--- Comment #9 from Reg Proctor
<body cz-shortcut-listen="true" style="margin-bottom: 36px !important;"><div class="center"> 185c185 < <tr><td class="e">REMOTE_PORT </td><td class="v">52578 </td></tr>
<tr><td class="e">REMOTE_PORT </td><td class="v">49518 </td></tr> 576,598d575 < <h2><a name="module_mysqli">mysqli</a></h2> < <table> < <tbody><tr class="h"><th>MysqlI Support</th><th>enabled</th></tr> < <tr><td class="e">Client API library version </td><td class="v">mysqlnd 8.1.13 </td></tr> < <tr><td class="e">Active Persistent Links </td><td class="v">0 </td></tr> < <tr><td class="e">Inactive Persistent Links </td><td class="v">0 </td></tr> < <tr><td class="e">Active Links </td><td class="v">0 </td></tr> < </tbody></table> < <table> < <tbody><tr class="h"><th>Directive</th><th>Local Value</th><th>Master Value</th></tr> < <tr><td class="e">mysqli.allow_local_infile</td><td class="v">Off</td><td class="v">Off</td></tr> < <tr><td class="e">mysqli.allow_persistent</td><td class="v">Off</td><td class="v">Off</td></tr> < <tr><td class="e">mysqli.default_host</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr> < <tr><td class="e">mysqli.default_port</td><td class="v">3306</td><td class="v">3306</td></tr> < <tr><td class="e">mysqli.default_pw</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr> < <tr><td class="e">mysqli.default_socket</td><td class="v">/run/mysql/mysql.sock</td><td class="v">/run/mysql/mysql.sock</td></tr> < <tr><td class="e">mysqli.default_user</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr> < <tr><td class="e">mysqli.local_infile_directory</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr> < <tr><td class="e">mysqli.max_links</td><td class="v">Unlimited</td><td class="v">Unlimited</td></tr> < <tr><td class="e">mysqli.max_persistent</td><td class="v">Unlimited</td><td class="v">Unlimited</td></tr> < <tr><td class="e">mysqli.reconnect</td><td class="v">Off</td><td class="v">Off</td></tr> < <tr><td class="e">mysqli.rollback_on_cached_plink</td><td class="v">Off</td><td class="v">Off</td></tr> < </tbody></table> 614c591 < <tr><td class="e">API Extensions </td><td class="v">mysqli,pdo_mysql </td></tr>
<tr><td class="e">API Extensions </td><td class="v">pdo_mysql </td></tr> 937,945c914,922 < <tr><td class="e">Cache hits </td><td class="v">1152 </td></tr> < <tr><td class="e">Cache misses </td><td class="v">422 </td></tr> < <tr><td class="e">Used memory </td><td class="v">16646440 </td></tr> < <tr><td class="e">Free memory </td><td class="v">117569128 </td></tr> < <tr><td class="e">Wasted memory </td><td class="v">2160 </td></tr> < <tr><td class="e">Interned Strings Used memory </td><td class="v">1713304 </td></tr> < <tr><td class="e">Interned Strings Free memory </td><td class="v">4577688 </td></tr> < <tr><td class="e">Cached scripts </td><td class="v">375 </td></tr> < <tr><td class="e">Cached keys </td><td class="v">727 </td></tr>
<tr><td class="e">Cache hits </td><td class="v">0 </td></tr> <tr><td class="e">Cache misses </td><td class="v">1 </td></tr> <tr><td class="e">Used memory </td><td class="v">9168488 </td></tr> <tr><td class="e">Free memory </td><td class="v">125049240 </td></tr> <tr><td class="e">Wasted memory </td><td class="v">0 </td></tr> <tr><td class="e">Interned Strings Used memory </td><td class="v">455784 </td></tr> <tr><td class="e">Interned Strings Free memory </td><td class="v">5835208 </td></tr> <tr><td class="e">Cached scripts </td><td class="v">1 </td></tr> <tr><td class="e">Cached keys </td><td class="v">1 </td></tr> 1055c1032 < <tr><td class="e">SYSTEMD_EXEC_PID </td><td class="v">19440 </td></tr>
<tr><td class="e">SYSTEMD_EXEC_PID </td><td class="v">19910 </td></tr> 1086c1063 < <tr><td class="e">INVOCATION_ID </td><td class="v">0cae0650cb694772b370aa9f42020562 </td></tr>
<tr><td class="e">INVOCATION_ID </td><td class="v">ae4ba0eac41d4d72b6b64a351bedc1f9 </td></tr> 1096c1073 < <tr><td class="e">JOURNAL_STREAM </td><td class="v">8:2141896 </td></tr>
<tr><td class="e">JOURNAL_STREAM </td><td class="v">8:2150621 </td></tr> 1141c1118 < <tr><td class="e">$_SERVER['REMOTE_PORT']</td><td class="v">52578</td></tr>
<tr><td class="e">$_SERVER['REMOTE_PORT']</td><td class="v">49518</td></tr> 1149,1150c1126,1127 < <tr><td class="e">$_SERVER['REQUEST_TIME_FLOAT']</td><td class="v">1673153599.6341</td></tr> < <tr><td class="e">$_SERVER['REQUEST_TIME']</td><td class="v">1673153599</td></tr>
<tr><td class="e">$_SERVER['REQUEST_TIME_FLOAT']</td><td class="v">1673153724.33</td></tr> <tr><td class="e">$_SERVER['REQUEST_TIME']</td><td class="v">1673153724</td></tr> 1307c1284,1335 < </div><link rel="stylesheet" type="text/css" href="Working%20-%20PHP%208.1.13%20-%20phpinfo()_files/s3downbar.css"><link rel="stylesheet" type="text/css" href="Working%20-%20PHP%208.1.13%20-%20phpinfo()_files/contextmenu.css"><link rel="stylesheet" type="text/css" href="Working%20-%20PHP%208.1.13%20-%20phpinfo()_files/tooltip.css"><div id="s3downbar-ibmbeeacmbeeaebmfjpmnlgkhoejinha" style="box-sizing: initial !important; position: fixed; white-space: nowrap; width: 120% !important; left: 0px; bottom: 0px; border-top: 1px solid rgb(153, 153, 153); transform-origin: left bottom 0px; z-index: 2147483647; margin: 0px; padding: 2px 0px; background-color: rgb(238, 238, 238); color: rgb(34, 34, 34); display: none !important; transform: scale(0.833333) !important;"><style type="text/css" media="print">#s3downbar-ibmbeeacmbeeaebmfjpmnlgkhoejinha { display: none !important; }</style><div style="box-sizing: initial !important; position: absolute !important;" id="s3downbar_resize_pane" is_top="false"><div style="box-sizing: initial !important;" class="tooltip_box" is_top="false"></div><div style="box-sizing: initial !important;" class="tooltip_arrow" is_top="false"></div></div><div style="box-sizing: initial !important; color: rgb(34, 34, 34) !important; position: relative !important; order: 4 !important;" class="s3dmBox" id="s3downbar_hide_button" is_hidden="false"><div id="s3downbar_hide_button_img" style="box-sizing: initial !important; background-image: url("moz-extension://e670dc73-a262-4f0d-8645-c1d2662ad130/skin/s3dm_icons.png") !important; display: inline-block !important;"></div><div style="box-sizing: initial !important;" class="tooltip_box" is_top="false"><div style="box-sizing: initial !important;" class="tooltipText">Hide Download Bar</div><div style="box-sizing: initial !important;" class="tooltipText">Ctrl + Shift + Z = Show/Hide Download Bar</div></div><div style="box-sizing: initial !important;" class="tooltip_arrow" is_top="false"></div></div><div style="box-sizing: initial !important; color: rgb(34, 34, 34) !important; position: relative !important;" class="s3dmBox" id="s3downbar_main_menu_button" is_hidden="false"><img style="box-sizing: initial !important;" src="Working%20-%20PHP%208.1.13%20-%20phpinfo()_files/logo16.png"><span style="box-sizing: initial !important;">Downloads</span><div style="box-sizing: initial !important;" class="tooltip_box" is_top="false"><div style="box-sizing: initial !important;" class="tooltipText">Download Manager (S3)</div></div><div style="box-sizing: initial !important;" class="tooltip_arrow" is_top="false"></div></div><div style="box-sizing: initial !important; color: rgb(34, 34, 34) !important; position: relative !important; order: 2 !important;" class="s3dmBox" id="s3downbar_clear_button" is_hidden="false">Clear<div style="box-sizing: initial !important;" class="tooltip_box" is_top="false"><div style="box-sizing: initial !important;" class="tooltipText">Left Click: Clear All Finished</div><div style="box-sizing: initial !important;" class="tooltipText">Right Click: Undo last clear</div></div><div style="box-sizing: initial !important;" class="tooltip_arrow" is_top="false"></div></div><div style="box-sizing: initial !important; color: rgb(34, 34, 34) !important; position: relative !important; order: 1 !important;" class="s3dmBox" id="s3downbar_holder_summary_progress" is_hidden="false"><div style="box-sizing: initial !important;">100%</div><div style="box-sizing: initial !important;" class="tooltip_box" is_top="false"><div style="box-sizing: initial !important;" class="tooltipText">Download History</div></div><div style="box-sizing: initial !important;" class="tooltip_arrow" is_top="false"></div></div><div style="box-sizing: initial !important;" id="s3downbar_download_data_listbox"><div style="box-sizing: initial !important; max-height: 60px !important;" id="s3downbar_download_data_listbox_scroll" list_count="0"><div style="box-sizing: initial !important;" id="s3downbar_download_data_list_empty">Download list is empty</div></div></div></div></body></html> \ No newline at end of file
</div><link rel="stylesheet" type="text/css" href="Faulty%20-%20PHP%208.1.13%20-%20phpinfo()_files/s3downbar.css"><link rel="stylesheet" type="text/css" href="Faulty%20-%20PHP%208.1.13%20-%20phpinfo()_files/contextmenu.css"><link rel="stylesheet" type="text/css" href="Faulty%20-%20PHP%208.1.13%20-%20phpinfo()_files/tooltip.css"><div id="s3downbar-ibmbeeacmbeeaebmfjpmnlgkhoejinha" style="box-sizing: initial !important; position: fixed; white-space: nowrap; width: 120% !important; left: 0px; bottom: 0px; border-top: 1px solid rgb(153, 153, 153); transform-origin: left bottom 0px; z-index: 2147483647; margin: 0px; padding: 2px 0px; background-color: rgb(238, 238, 238); color: rgb(34, 34, 34); display: flex !important; transform: scale(0.833333) !important;"><style type="text/css" media="print">#s3downbar-ibmbeeacmbeeaebmfjpmnlgkhoejinha { display: none !important; }</style><div style="box-sizing: initial !important; position: absolute !important;" id="s3downbar_resize_pane" is_top="fa lse"><div style="box-sizing: initial !important;" class="tooltip_box" is_top="false"></div><div style="box-sizing: initial !important;" class="tooltip_arrow" is_top="false"></div></div><div style="box-sizing: initial !important; color: rgb(34, 34, 34) !important; position: relative !important; order: 4 !important;" class="s3dmBox" id="s3downbar_hide_button" is_hidden="false"><div id="s3downbar_hide_button_img" style="box-sizing: initial !important; background-image: url("moz-extension://e670dc73-a262-4f0d-8645-c1d2662ad130/skin/s3dm_icons.png") !important; display: inline-block !important;"></div><div style="box-sizing: initial !important;" class="tooltip_box" is_top="false"><div style="box-sizing: initial !important;" class="tooltipText">Hide Download Bar</div><div style="box-sizing: initial !important;" class="tooltipText">Ctrl + Shift + Z = Show/Hide Download Bar</div></div><div style="box-sizing: initial !important;" class="tooltip_arrow" is_top="false"></div></div><di v style="box-sizing: initial !important; color: rgb(34, 34, 34) !important; position: relative !important;" class="s3dmBox" id="s3downbar_main_menu_button" is_hidden="false"><img style="box-sizing: initial !important;" src="Faulty%20-%20PHP%208.1.13%20-%20phpinfo()_files/logo16.png"><span style="box-sizing: initial !important;">Downloads</span><div style="box-sizing: initial !important;" class="tooltip_box" is_top="false"><div style="box-sizing: initial !important;" class="tooltipText">Download Manager (S3)</div></div><div style="box-sizing: initial !important;" class="tooltip_arrow" is_top="false"></div></div><div style="box-sizing: initial !important; color: rgb(34, 34, 34) !important; position: relative !important; order: 2 !important;" class="s3dmBox" id="s3downbar_clear_button" is_hidden="false">Clear<div style="box-sizing: initial !important;" class="tooltip_box" is_top="false"><div style="box-sizing: initial !important;" class="tooltipText">Left Click: Clear All Finished
-- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162#c12
--- Comment #12 from Reg Proctor
I will try to summarize for me: 1. 2. 5. reporter's workaround: add extension=mysqlnd into /etc/php7/apache2/php.ini; > this is however not acceptable in general (will issue warning about duplicite > > extension loading, fx. on the php+apache+phpinfo() setup)
Not quite. This works because it produces no error because you are adding it in only for Apache which is where it's getting left out. What should be the case is that it should not need to be added into the Apache specific php.ini file because it's already included from the files in the .../conf.d/ directory which covers all forms of use which just means CLI and Apache for the most part.
6.
-- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162#c13
--- Comment #13 from Reg Proctor
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162#c14
--- Comment #14 from Reg Proctor
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162#c15
--- Comment #15 from Reg Proctor
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162#c19
--- Comment #19 from OBSbugzilla Bot
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162#c20
--- Comment #20 from Eric Schirra
This is an autogenerated message for OBS integration: This bug (1205162) was mentioned in https://build.opensuse.org/request/show/1069569 Factory / php8
Will this only be fixed in php8? What is about php7 in Leap? -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162
http://bugzilla.opensuse.org/show_bug.cgi?id=1205162#c23
Eric Schirra
participants (1)
-
bugzilla_noreply@suse.com