NAS326 V5.21(AAZF.11)

ctggladiator

Hello, since the new Firmware the mysql Service is not starting anymore:
Enable package "PHP-MySQL-phpMyAdmin" failed.

Does anyone has an idea?

Mijzelf

Are you a bit comfortable with the command line? Login over ssh and try to start it manually. It might spawn a usable error message.

You can find the package in /i-data/sysvol/.PKG/PHP-MySQL-phpMyAdmin/

The startscript is somewhere in subdirectory etc, I think etc/init.d/PHP-MySQL-phpMyAdmin.

Starting:

/i-data/sysvol/.PKG/PHP-MySQL-phpMyAdmin/etc/init.d/PHP-MySQL-phpMyAdmin startup

If it doesn't show a usable error. you can try 'debug mode':

sh -x /i-data/sysvol/.PKG/PHP-MySQL-phpMyAdmin/etc/init.d/PHP-MySQL-phpMyAdmin startup

ctggladiator

Hello Mijzelf,

i tried the debug mode. it shows following result:

/i-data/2824f7ff$ sh -x /i-data/sysvol/.PKG/PHP-MySQL-phpMyAdmin/etc/init.d/PHP-MySQL-phpMyAdmin startup

+ PKGSTATUSFILE=/etc/zyxel/pkg_conf/status

+ + sed s/ //g

sed s/\/$//g

+ awk -F: {print $2}

+ grep Installed-Rule

+ grep PHP-MySQL-phpMyAdmin /etc/zyxel/pkg_conf/status

+ PKGVOLPATH=/i-data/2824f7ff/.PKG/PHP-MySQL-phpMyAdmin

+ PKGLIBPATH=/i-data/2824f7ff/.PKG/PHP-MySQL-phpMyAdmin/lib

+ PHPCONTROLFILE=/i-data/2824f7ff/.PKG/PHP-MySQL-phpMyAdmin/zypkg_conf/info/PHP-MySQL-phpMyAdmin.control

+ IFCONFIG=/sbin/ifconfig

+ BONDINTERFACE=bond0

+ INTERFACEA=egiga0

+ INTERFACEB=egiga1

+ STATUSFILE=/i-data/2824f7ff/.PKG/PHP-MySQL-phpMyAdmin/config/PHP-MySQL-phpMyAdmin/PHP-MySQL-phpMyAdmin

+ HTTPCONFPATH=/etc/pkg_service_conf/PHP-MySQL-phpMyAdmin.conf

+ TMPCONFPATH=/etc/pkg_service_conf/PHP-MySQL-phpMyAdmin.conf.bak

+ KEYWORD=phpmyadmin

+ SQLPATH=/i-data/2824f7ff/.PKG/PHP-MySQL-phpMyAdmin/mysql

+ NICE_VALUE=20

+ HTTPD_TMP=/tmp/httpd_conf.bak

+ PLAYZONE=yes

+ PKGCONFIG=/etc/pkg_service_conf/httpd2.conf

+ CHKMD5SUMLIST=/i-data/2824f7ff/.PKG/PHP-MySQL-phpMyAdmin/config/checklist

+ PHPSOPATH=PHPIniDir /i-data/2824f7ff/.PKG/PHP-MySQL-phpMyAdmin/php

+ PHPINI=LoadModule php5_module /i-data/2824f7ff/.PKG/PHP-MySQL-phpMyAdmin/lib/libphp5.so

+ [ startup == getlink ]

+ [ startup == enable ]

+ [ startup == disable ]

+ [ startup == shutdown ]

+ [ startup == status ]

+ [ startup == startup ]

+ sqlite3 /etc/zyxel/upnp.db SELECT COUNT(*) FROM upnpInfo WHERE service='PHP-MYSQL-PHPMYADMIN_HTTP'

+ UPNPCOUNT=1

+ [ 0 == 1 ]

+ NICE_VALUE=17

+ mount --bind /i-data/2824f7ff/.PKG/PHP-MySQL-phpMyAdmin/mysql /usr/local/mysql

+ cat /i-data/2824f7ff/.PKG/PHP-MySQL-phpMyAdmin/config/PHP-MySQL-phpMyAdmin/PHP-MySQL-phpMyAdmin

+ STATUS=Disabled

+ [ Disabled == Enabled ]

+ disable

+ [ xyes == xyes ]

+ echo phpmyadmin

+ echo RewriteRule "(?i)/pkg/phpmyadmin" "/zyxel/disable.html" [R=301]

+ mv /etc/pkg_service_conf/PHP-MySQL-phpMyAdmin.conf.bak /etc/pkg_service_conf/PHP-MySQL-phpMyAdmin.conf

+ + sed s/^DirectoryIndex index.html index.htm index.php$/DirectoryIndex index.html index.htm/

sed s/^PHPIniDir /#PHPIniDir /

+ sed s/^AddType application\/x-httpd-php /#AddType application\/x-httpd-php /

+ sed s/^LoadModule[ ]php5_module/#LoadModule php5_module/ /etc/pkg_service_conf/httpd2.conf

+ mv /etc/pkg_service_conf/httpd2.conf.bak /etc/pkg_service_conf/httpd2.conf

+ grep phpmyadmin

+ cat /etc/pkg_service_conf/httpd2.conf

+ RESULT=AuthZyxelSkipPattern /phpmyadmin /webdav /favicon.ico /desktop,/cgi-bin/weblogin.cgi /desktop,/cgi-bin/file_download.cgi /desktop,/cgi-bin/dlnotify /desktop,/disable.html /desktop,/login.html /desktop,/ext/ /desktop,/css/ /desktop,/images/ /desktop,/loginwrap.html /desktop,/css/ /desktop,/dojo/ /desktop,/res/ /desktop,/js/ /desktop,/login.html /MyWeb/ /register_main/setCookie /playzone,/mobile_login.html /playzone,/mobile/sencha/ /playzone,/mobile/images/ /playzone,/images/

+ [ AuthZyxelSkipPattern /phpmyadmin /webdav /favicon.ico /desktop,/cgi-bin/weblogin.cgi /desktop,/cgi-bin/file_download.cgi /desktop,/cgi-bin/dlnotify /desktop,/disable.html /desktop,/login.html /desktop,/ext/ /desktop,/css/ /desktop,/images/ /desktop,/loginwrap.html /desktop,/css/ /desktop,/dojo/ /desktop,/res/ /desktop,/js/ /desktop,/login.html /MyWeb/ /register_main/setCookie /playzone,/mobile_login.html /playzone,/mobile/sencha/ /playzone,/mobile/images/ /playzone,/images/ ==  ]

+ touch /tmp/restart_httpd

+ exit 0

Can you find the problem?

Mijzelf

+ cat /i-data/2824f7ff/.PKG/PHP-MySQL-phpMyAdmin/config/PHP-MySQL-phpMyAdmin/PHP-MySQL-phpMyAdmin

+ STATUS=Disabled

+ [ Disabled == Enabled ]

+ disable

looks like the package isn't enabled. You can edit that file, or try to let the script do it:

/i-data/sysvol/.PKG/PHP-MySQL-phpMyAdmin/etc/init.d/PHP-MySQL-phpMyAdmin enable

ctggladiator

i tried the script. but the error is the same. Also in webgui i still cannot enable the service

Zyxel_Jerry

Hi @ctggladiator

Sorry for the inconvenience. 
Currently, we're working on this issue and will update you here.

dHeinz

What a mess! Please repair phpmyadmin and sql database abilty ASAP. At the moment, my NAS326 is nearly useless without this.

zacki27101

dHeinz said:

What a mess! Please repair phpmyadmin and sql database abilty ASAP. At the moment, my NAS326 is nearly useless without this.

Same situation, please fix it ASAP. As a workaround, is it possible to downgrade the firmware manually? 

Mijzelf

zacki27101 said:

  As a workaround, is it possible to downgrade the firmware manually? 

Yes. Download an older firmware here: ftp://ftp2.zyxel.com (as all major browser makers dropped support for ftp, you'll probably need an ftp client like filezilla), then login over ssh and execute

echo 1 > /firmware/mnt/info/revision

Then you can downgrade by uploading a firmware file in the webinterface. (A .bin file).

zacki27101

Mijzelf said:

zacki27101 said:

  As a workaround, is it possible to downgrade the firmware manually? 

Yes. Download an older firmware here: ftp://ftp2.zyxel.com (as all major browser makers dropped support for ftp, you'll probably need an ftp client like filezilla), then login over ssh and execute

echo 1 > /firmware/mnt/info/revision

Then you can downgrade by uploading a firmware file in the webinterface. (A .bin file).

Thanks for responding. But it is unfortunately not working for me. I downloaded '521AAZF10C0.bin' which is the version prior to the latest one (which worked just fine) and the webinterface responds with "The NAS firmware cannot be downgraded, please select a newer version of binary (BIN) upgrade file from your computer." Do I need a seperate/different file? 

ikubuf

You have to enter the command, "echo 1 > /firmware/mnt/info/revision" using SSH
then you can upgrade the firmware.