Possible issue with firmware 4.3.3.0188 and MySQL

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
kofoster
Starting out
Posts: 22
Joined: Sun Nov 18, 2012 12:15 pm

Possible issue with firmware 4.3.3.0188 and MySQL

Postby kofoster » Fri May 26, 2017 4:45 am

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.
Karl
QNAP TS-219PII - Firmware Version 4.3.3.0188

User avatar
schumaku
Guru
Posts: 42623
Joined: Mon Jan 21, 2008 4:41 pm
Location: Kloten (Zurich), Switzerland -- Skype: schumaku
Contact:

Re: Possible issue with firmware 4.3.3.0188 and MySQL

Postby schumaku » Fri May 26, 2017 6:31 am

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
Starting out
Posts: 22
Joined: Sun Nov 18, 2012 12:15 pm

Re: Possible issue with firmware 4.3.3.0188 and MySQL

Postby kofoster » Fri May 26, 2017 7:07 am

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.
Karl
QNAP TS-219PII - Firmware Version 4.3.3.0188

User avatar
schumaku
Guru
Posts: 42623
Joined: Mon Jan 21, 2008 4:41 pm
Location: Kloten (Zurich), Switzerland -- Skype: schumaku
Contact:

Re: Possible issue with firmware 4.3.3.0188 and MySQL

Postby schumaku » Fri May 26, 2017 5:06 pm

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
Starting out
Posts: 22
Joined: Sun Nov 18, 2012 12:15 pm

Re: Possible issue with firmware 4.3.3.0188 and MySQL

Postby kofoster » Fri May 26, 2017 11:09 pm

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
You do not have the required permissions to view the files attached to this post.
Karl
QNAP TS-219PII - Firmware Version 4.3.3.0188

User avatar
schumaku
Guru
Posts: 42623
Joined: Mon Jan 21, 2008 4:41 pm
Location: Kloten (Zurich), Switzerland -- Skype: schumaku
Contact:

Re: Possible issue with firmware 4.3.3.0188 and MySQL

Postby schumaku » Sat May 27, 2017 6:12 am

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

kofoster
Starting out
Posts: 22
Joined: Sun Nov 18, 2012 12:15 pm

Re: Possible issue with firmware 4.3.3.0188 and MySQL

Postby kofoster » Thu Jun 08, 2017 9:40 am

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.
Karl
QNAP TS-219PII - Firmware Version 4.3.3.0188

kofoster
Starting out
Posts: 22
Joined: Sun Nov 18, 2012 12:15 pm

Re: Possible issue with firmware 4.3.3.0188 and MySQL

Postby kofoster » Fri Jul 28, 2017 10:15 pm

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.
Karl
QNAP TS-219PII - Firmware Version 4.3.3.0188

asdlinux
New here
Posts: 9
Joined: Mon Apr 27, 2015 2:27 am

Re: Possible issue with firmware 4.3.3.0188 and MySQL

Postby asdlinux » Tue Aug 29, 2017 4:48 am

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
First post
Posts: 1
Joined: Wed Jun 25, 2014 6:58 am

Re: Possible issue with firmware 4.3.3.0188 and MySQL

Postby smoothgravy » Wed Aug 30, 2017 1:38 pm

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
New here
Posts: 9
Joined: Mon Apr 27, 2015 2:27 am

Re: Possible issue with firmware 4.3.3.0188 and MySQL

Postby asdlinux » Tue Sep 05, 2017 2:58 pm

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
New here
Posts: 9
Joined: Mon Apr 27, 2015 2:27 am

Re: Possible issue with firmware 4.3.3.0188 and MySQL

Postby asdlinux » Tue Sep 19, 2017 11:21 pm

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


Return to “Web Server & Applications (Apache + PHP + MySQL / SQLite)”

Who is online

Users browsing this forum: No registered users and 4 guests