Possible issue with firmware 4.3.3.0188 and MySQL

[kofoster]

I am running on a TS 219P II. There are a number of web applications (Joomla, Wordpress, MantisBT, etc.) installed in the /Web directory. Everything was working fine until I upgraded firmware to 4.3.3.0188. Now none of the web applications work, giving various messages when initiated, mostly - "This page isn’t working qnapname is currently unable to handle this request. HTTP ERROR 500." Two applications give somewhat more meaningful messages:

Wordpress: Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

MantisBT: APPLICATION ERROR #400 Database connection failed. Error received from database was #0: PHP Support for database is not enabled.

Did the firmware upgrade disable PHP support for MySQL?

How can I fix this?

Thanks in advance for the help.

[schumaku]

Hallo Karl,

Are the Web apps configured to use mysql or mysqli ? Change to mysqli in case ...

Does phpMyAdmin work on the NAS?

Check phpinfo, something like

/share/Web/phpinfo.php ...:

Code: Select all

<?php

// Show all information, defaults to INFO_ALL
phpinfo();
?>

....and call it from a Web browser ... have an eye if the MySQL extensions are in place.

-Kurt

[kofoster]

Kurt,

Thanks for responding.

The Web apps are configured to use mysqli.

phpMyAdmin does not work. It gives: phpMyAdmin - Error. The session extension is missing. Please check your PHP configuration.

phpinfo() isn't showing any section showing MySQL extensions.

[schumaku]

This is the first table from phpinfo() on a 4.3.3.0188 Marvell Kirkwood NAS similar to yours:

PHP Version 5.6.30

System Linux TS-419PII 3.4.6 #1 Tue May 16 11:39:46 CST 2017 armv5tel
Build Date May 16 2017 03:49:52
Configure Command './configure' '--disable-debug' '--prefix=/root/daily_build/arm_05/4.3.3/Model/TS-220/../../NasMgmt/HTTP/php5' '--with-config-file-path=/etc/config/php.ini' '--with-config-file-scan-dir=/etc/config/php.d' '--enable-ftp=shared' '--enable-sockets=shared' '--with-gettext=shared' '--with-zlib=shared' '--with-jpeg-dir=' '--with-png-dir=/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--with-gd=shared' '--with-freetype-dir=/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--enable-gd-native-ttf=shared' '--enable-mbstring=shared' '--with-openssl=shared,/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--with-libxml-dir=/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--enable-libxml=shared,/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--enable-sqlite-utf8=shared' '--with-mysql=shared,mysqlnd' '--with-mcrypt=shared,/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--enable-zend-multibyte=shared' '--with-iconv=shared,/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--enable-exif=shared' '--with-pdo-mysql=shared,mysqlnd' '--enable-pdo=shared' '--with-pdo-sqlite=shared,/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--with-sqlite=shared' '--with-curl=shared,/root/daily_build/arm_05/4.3.3/Model/TS-220/../../SysUtil/curl-7.43.0' '--with-curlwrappers=shared,/root/daily_build/arm_05/4.3.3/Model/TS-220/../../SysUtil/curl-7.43.0' '--with-xsl=shared,/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--with-mysqli=shared,mysqlnd' '--enable-calendar=shared' '--enable-bcmath=shared' '--with-ldap=shared,/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--with-imap=shared,/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--with-imap-ssl=/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr' '--enable-dba=shared' '--enable-dbase=shared' '--enable-shmop=shared' '--enable-wddx=shared' '--enable-zip=shared' '--with-xmlrpc=shared' '--enable-soap=shared' '--with-mssql=shared,/root/daily_build/arm_05/4.3.3/Model/TS-220/../../NasMgmt/HTTP/php_modules/php_mod_install/arm' '--enable-pcntl=shared' '--host=arm-none-linux-gnueabi' '--build=arm' '--enable-mysqlnd=shared' '--enable-session=shared' '--with-sqlite3=shared' '--with-apxs2=../apache_install_tmp/bin/apxs' 'build_alias=arm' 'host_alias=arm-none-linux-gnueabi' 'CC=arm-none-linux-gnueabi-gcc' 'CFLAGS=-DHAVE_SIG_T '-D_FILE_OFFSET_BITS=64' '-O2'' 'LDFLAGS=-Wl,-rpath=/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr/lib '-L/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/lib' '-L/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr/lib'' 'CPPFLAGS=-I/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/include '-I/opt/cross-project/arm/marvell/arm-none-linux-gnueabi/libc/marvell-f/usr/include' '-I/root/daily_build/arm_05/4.3.3/Model/TS-220/../../Kernel/linux-3.4.6/include''
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/config/php.ini
Loaded Configuration File /php.ini
Scan this dir for additional .ini files /etc/config/php.d
Additional .ini files parsed /etc/config/php.d/ext.ini
PHP API 20131106
PHP Extension 20131226
Zend Extension 220131226
Zend Extension Build API220131226,NTS
PHP Extension Build API20131226,NTS
Debug Build no
Thread Safety disabled
Zend Signal Handling disabled
Zend Memory Manager enabled
Zend Multibyte Support provided by mbstring
IPv6 Support enabled
DTrace Support disabled
Registered PHP Streams https, ftps, compress.zlib, php, file, glob, data, http, ftp, phar, zip
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls, tlsv1.0, tlsv1.1, tlsv1.2
Registered Stream Filters zlib.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, mcrypt.*, mdecrypt.*

Does yours look similar ... well, much more the same, except of the system line showing your NAS name?

[~] # cat /etc/config/php.d/ext.ini
extension = zlib.so
extension = curl.so
extension = calendar.so
extension = iconv.so
extension = gd.so
extension = session.so
extension = pdo.so
extension = sqlite3.so
extension = mysqlnd.so
extension = pdo_mysql.so
extension = pdo_sqlite.so
extension = mysql.so
extension = mysqli.so
extension = openssl.so
extension = zip.so
extension = bcmath.so
extension = dba.so
extension = exif.so
extension = ftp.so
extension = gettext.so
extension = imap.so
extension = ldap.so
extension = mbstring.so
extension = mcrypt.so
extension = pcntl.so
extension = shmop.so
extension = soap.so
extension = sockets.so
extension = wddx.so
extension = xmlrpc.so
extension = xsl.so

The related modules are in place?

[~] # ls /mnt/ext/opt/apache/modules/
bcmath.so* mod_authz_dbm.so* mod_lbmethod_heartbeat.so* mod_socache_memcache.so*
calendar.so* mod_authz_groupfile.so* mod_ldap.so* mod_socache_shmcb.so*
curl.so* mod_authz_host.so* mod_log_config.so* mod_speling.so*
dba.so* mod_authz_owner.so* mod_log_debug.so* mod_ssl.so*
exif.so* mod_authz_unixgroup.so* mod_logio.so* mod_status.so*
ftp.so* mod_authz_user.so* mod_macro.so* mod_substitute.so*
gd.so* mod_autoindex.so* mod_mime.so* mod_unique_id.so*
geoip.so* mod_buffer.so* mod_negotiation.so* mod_unixd.so*
gettext.so* mod_cache.so* mod_proxy.so* mod_userdir.so*
iconv.so* mod_cache_disk.so* mod_proxy_ajp.so* mod_version.so*
imagick.so* mod_cache_socache.so* mod_proxy_balancer.so* mod_vhost_alias.so*
imap.so* mod_cgi.so* mod_proxy_connect.so* mod_watchdog.so*
ldap.so* mod_charset_lite.so* mod_proxy_express.so* mssql.so*
libphp5.so* mod_dav.so* mod_proxy_fcgi.so* mysql.so*
mbstring.so* mod_dav_fs.so* mod_proxy_fdpass.so* mysqli.so*
mcrypt.so* mod_dav_lock.so* mod_proxy_ftp.so* mysqlnd.so*
memcached.so* mod_dbd.so* mod_proxy_hcheck.so* opcache.so*
mod_access_compat.so* mod_deflate.so* mod_proxy_http.so* openssl.so*
mod_actions.so* mod_dir.so* mod_proxy_scgi.so* pcntl.so*
mod_alias.so* mod_dumpio.so* mod_proxy_wstunnel.so* pdo.so*
mod_allowmethods.so* mod_env.so* mod_qos.so* pdo_mysql.so*
mod_auth_basic.so* mod_evasive24.so* mod_ratelimit.so* pdo_sqlite.so*
mod_auth_digest.so* mod_expires.so* mod_remoteip.so* session.so*
mod_auth_form.so* mod_ext_filter.so* mod_reqtimeout.so* shmop.so*
mod_authn_anon.so* mod_fastcgi.so* mod_request.so* soap.so*
mod_authn_core.so* mod_file_cache.so* mod_rewrite.so* sockets.so*
mod_authn_dbd.so* mod_filter.so* mod_security2.so* sqlite3.so*
mod_authn_dbm.so* mod_headers.so* mod_sed.so* wddx.so*
mod_authn_file.so* mod_http2.so* mod_session.so* xmlrpc.so*
mod_authn_socache.so* mod_include.so* mod_session_cookie.so* xsl.so*
mod_authnz_external.so* mod_info.so* mod_session_dbd.so* zip.so*
mod_authnz_ldap.so* mod_lbmethod_bybusyness.so* mod_setenvif.so* zlib.so*
mod_authz_core.so* mod_lbmethod_byrequests.so* mod_slotmem_shm.so*
mod_authz_dbd.so* mod_lbmethod_bytraffic.so* mod_socache_dbm.so*


Worth a try is re-applying the same firmware again using the https://wiki.qnap.com/wiki/Manually_Updating_Firmware process.

[kofoster]

Here are what mine looks like. Pretty much the same. I will try the re-install over the weekend:

phpinfo_1.PNG

phpinfo_2.PNG

cat /etc/config/php.d/ext.ini

extension = zlib.so
extension = curl.so
extension = calendar.so
extension = iconv.so
extension = gd.so
extension = session.so
extension = pdo.so
extension = sqlite3.so
extension = mysqlnd.so
extension = pdo_mysql.so
extension = pdo_sqlite.so
extension = mysql.so
extension = mysqli.so
extension = openssl.so
extension = zip.so
extension = bcmath.so
extension = dba.so
extension = exif.so
extension = ftp.so
extension = gettext.so
extension = imap.so
extension = ldap.so
extension = mbstring.so
extension = mcrypt.so
extension = pcntl.so
extension = shmop.so
extension = soap.so
extension = sockets.so
extension = wddx.so
extension = xmlrpc.so
extension = xsl.so

ls /mnt/ext/opt/apache/modules/

bcmath.so
calendar.so
curl.so
dba.so
exif.so
ftp.so
gd.so
geoip.so
gettext.so
iconv.so
imagick.so
imap.so
ldap.so
libphp5.so
mbstring.so
mcrypt.so
memcached.so
mod_access_compat.so
mod_actions.so
mod_alias.so
mod_allowmethods.so
mod_auth_basic.so
mod_auth_digest.so
mod_auth_form.so
mod_authn_anon.so
mod_authn_core.so
mod_authn_dbd.so
mod_authn_dbm.so
mod_authn_file.so
mod_authn_socache.so
mod_authnz_external.so
mod_authnz_ldap.so
mod_authz_core.so
mod_authz_dbd.so
mod_authz_dbm.so
mod_authz_groupfile.so
mod_authz_host.so
mod_authz_owner.so
mod_authz_unixgroup.so
mod_authz_user.so
mod_autoindex.so
mod_buffer.so
mod_cache.so
mod_cache_disk.so
mod_cache_socache.so
mod_cgi.so
mod_charset_lite.so
mod_dav.so
mod_dav_fs.so
mod_dav_lock.so
mod_dbd.so
mod_deflate.so
mod_dir.so
mod_dumpio.so
mod_env.so
mod_evasive24.so
mod_expires.so
mod_ext_filter.so
mod_fastcgi.so
mod_file_cache.so
mod_filter.so
mod_headers.so
mod_http2.so
mod_include.so
mod_info.so
mod_lbmethod_bybusyness.so
mod_lbmethod_byrequests.so
mod_lbmethod_bytraffic.so
mod_lbmethod_heartbeat.so
mod_ldap.so
mod_log_config.so
mod_log_debug.so
mod_logio.so
mod_macro.so
mod_mime.so
mod_negotiation.so
mod_proxy.so
mod_proxy_ajp.so
mod_proxy_balancer.so
mod_proxy_connect.so
mod_proxy_express.so
mod_proxy_fcgi.so
mod_proxy_fdpass.so
mod_proxy_ftp.so
mod_proxy_hcheck.so
mod_proxy_http.so
mod_proxy_scgi.so
mod_proxy_wstunnel.so
mod_qos.so
mod_ratelimit.so
mod_remoteip.so
mod_reqtimeout.so
mod_request.so
mod_rewrite.so
mod_security2.so
mod_sed.so
mod_session.so
mod_session_cookie.so
mod_session_dbd.so
mod_setenvif.so
mod_slotmem_shm.so
mod_socache_dbm.so
mod_socache_memcache.so
mod_socache_shmcb.so
mod_speling.so
mod_ssl.so
mod_status.so
mod_substitute.so
mod_unique_id.so
mod_unixd.so
mod_userdir.so
mod_version.so
mod_vhost_alias.so
mod_watchdog.so
mssql.so
mysql.so
mysqli.so
mysqlnd.so
opcache.so
openssl.so
pcntl.so
pdo.so
pdo_mysql.so
pdo_sqlite.so
php5.5
session.so
shmop.so
soap.so
sockets.so
sqlite3.so
wddx.so
xmlrpc.so
xsl.so
zip.so
zlib.so

[schumaku]

Looks to me like the objects are not lodaed in PHP/Apache.

[kofoster]

Kurt,

Sorry for the delay but I had to turn my attention to something else the last few days. How do I reload the required objects into PHP/Apache? I am a novice when it comes to the inner parts of this box.

I did open an incident with QNAP and someone logged in and poked around but couldn't fix the problem. I am still waiting on them to get back to me with some explanation of why this happened and how to fix it.

[kofoster]

So just in case anyone comes across this issue, my solution turned out to be disabling the PHP 5.5.27 Qpkg. After several sessions with QNAP support, someone who had apparently seen the issue before, logged in and stopped the Qpkg. Once he did that everything started working again. He said the firmware update installed PHP 5.6.30 and this seems to conflict with the Qpkg. I also disabled the Qpkg on another QNAP exhibiting the same issue and it was resolved there also.

[asdlinux]

I have the same issue, But i cant find how to disable the PHP 5.5.27 Qpkg. Can anyone guide me how ? Thanks

[smoothgravy]

To disable it, open the App Center. If the PHP package is installed, it should be listed there. Click on the arrow below it and then choose Stop.

[asdlinux]

Thank you for your answer, But the PHP package is not listed. I have phpMyAdmin istalled so i should have a version of php installed. I can not access MariaSQL at the moment and nothing that depends on it works ... what to do ?

[asdlinux]

I opened a ticket at QNAP and this was my solution for this problem.
-------- QNAP Response --------
Hi Magnus,

Please remove QMariaDB app as it is not supported on 4.3.x. If you have data on the DB, you need to downgrade firmware to 4.2.x, export the DB, upgrade firmware to 4.3.x, then import the DB.


Best Regards

Vincent Tseng
QNAP Systems, Inc.
------------------------------------

I did this ... and restarted my NAS ... Still not working so I tried to Re-Initialize Database. and after that I can login phpMyAdmin. It seems to work normally again. Now i am reinstalling all apps that was depending on QMariaDB.
Hope this helps
Regards,
Magnus

[edavila]

To disable it, open the App Center. If the PHP package is installed, it should be listed there. Click on the arrow below it and then choose Stop.

It solved my problem

[edavila]

So just in case anyone comes across this issue, my solution turned out to be disabling the PHP 5.5.27 Qpkg. After several sessions with QNAP support, someone who had apparently seen the issue before, logged in and stopped the Qpkg. Once he did that everything started working again. He said the firmware update installed PHP 5.6.30 and this seems to conflict with the Qpkg. I also disabled the Qpkg on another QNAP exhibiting the same issue and it was resolved there also.

Thanks. It solves the problem...