Unable to install Phpmyadmin

Support apps
1

I deployed the latest version of yunohost on a dedicated ARM server yesterday and then today i tried to deploy phpmyadmin. but it fails giving the following error.
!!

phpmyadmin’s script has encountered an error. Its execution was cancelled.

!!

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '_getopts_fix.sh TO ‘phpmyadmin_root’@‘localhost’ IDENTIFIED BY ‘pTVkmKXr7ruxx123’ at line 1

I couldnt understand getopts_fix.sh file to make any try. Can anyone has similar issue?

I tried the same in another server with again fresh yunohost installation and then phpmyadmin and still got the same issue. i believe its something linked with latest mariadb server that comes with yunohost and the phpmyadmin_ynh code…

Kindly help.

Thanks,
Kumar.

1 Like
2

That’s an internal error into phpmyadmin package.
This need to be fixed as soon as possible.

1 Like
3 
2019-04-21 13:28:02,508: DEBUG - + set +x

2019-04-21 13:28:02,610: DEBUG - + database=
2019-04-21 13:28:02,610: DEBUG - + mysql -u root --password=Vrr8oLAGHR -B ‘’
2019-04-21 13:28:02,711: DEBUG - + ynh_mysql_execute_as_root ‘GRANT ALL PRIVILEGES ON . TO ‘’‘phpmyadmin_root’’’@’’‘localhost’’’ IDENTIFIED BY ‘’‘uFUgeyHIjKX0SUp75neOsGBB’’’ WITH GRANT OPTION;
2019-04-21 13:28:02,712: DEBUG - FLUSH PRIVILEGES;’ mysql
2019-04-21 13:28:02,713: DEBUG - + local legacy_args=sd
2019-04-21 13:28:02,713: DEBUG - + args_array=([s]=sql= [d]=database=)
2019-04-21 13:28:02,714: DEBUG - + declare -Ar args_array
2019-04-21 13:28:02,715: DEBUG - + local sql
2019-04-21 13:28:02,715: DEBUG - + local database
2019-04-21 13:28:02,716: DEBUG - + ynh_handle_getopts_args ‘GRANT ALL PRIVILEGES ON . TO ‘’‘phpmyadmin_root’’’@’’‘localhost’’’ IDENTIFIED BY ‘’‘uFUgeyHIjKX0SUp75neOsGBB’’’ WITH GRANT OPTION;
2019-04-21 13:28:02,716: DEBUG - FLUSH PRIVILEGES;’ mysql
2019-04-21 13:28:02,717: DEBUG - + set +x
2019-04-21 13:28:02,718: DEBUG - + echo ‘! Helper used in legacy mode !’
2019-04-21 13:28:02,719: DEBUG - + set +x
2019-04-21 13:28:02,722: WARNING - ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘_getopts_fix.sh TO ‘phpmyadmin_root’@‘localhost’ IDENTIFIED BY ‘uFUgeyHIjKX0SUp7’ at line 1
2019-04-21 13:28:02,723: DEBUG - + database=mysql
2019-04-21 13:28:02,724: WARNING - !!
2019-04-21 13:28:02,725: DEBUG - ++ sudo cat /etc/yunohost/mysql
2019-04-21 13:28:02,726: WARNING - phpmyadmin’s script has encountered an error. Its execution was cancelled.
2019-04-21 13:28:02,727: DEBUG - + ynh_mysql_connect_as --user=root --password=Vrr8oLAGHR --database=mysql
2019-04-21 13:28:02,727: WARNING - !!
2019-04-21 13:28:02,729: DEBUG - + local legacy_args=upd
2019-04-21 13:28:02,729: WARNING -
2019-04-21 13:28:02,730: DEBUG - + args_array=([u]=user= [p]=password= [d]=database=)
2019-04-21 13:28:02,731: DEBUG - + declare -Ar args_array
2019-04-21 13:28:02,731: DEBUG - + local user
2019-04-21 13:28:02,732: DEBUG - + local password
2019-04-21 13:28:02,732: DEBUG - + local database
2019-04-21 13:28:02,733: DEBUG - + ynh_handle_getopts_args --user=root --password=Vrr8oLAGHR --database=mysql
2019-04-21 13:28:02,733: DEBUG - + set +x
2019-04-21 13:28:02,734: DEBUG - + database=mysql
2019-04-21 13:28:02,734: DEBUG - + mysql -u root --password=Vrr8oLAGHR -B mysql
2019-04-21 13:28:02,734: DEBUG - + ynh_exit_properly
2019-04-21 13:28:02,735: DEBUG - + local exit_code=1
2019-04-21 13:28:02,735: DEBUG - + ‘[’ 1 -eq 0 ‘]’
2019-04-21 13:28:02,736: DEBUG - + trap ‘’ EXIT
2019-04-21 13:28:02,736: DEBUG - + set +eu
2019-04-21 13:28:02,736: DEBUG - + echo -e ‘!!\n phpmyadmin’’‘s script has encountered an error. Its execution was cancelled.\n!!’
2019-04-21 13:28:02,737: DEBUG - + type -t ynh_clean_setup
2019-04-21 13:28:02,737: DEBUG - + ynh_die
2019-04-21 13:28:02,738: DEBUG - + local legacy_args=mc
2019-04-21 13:28:02,739: DEBUG - + args_array=([m]=message= [c]=ret_code=)
2019-04-21 13:28:02,739: DEBUG - + declare -Ar args_array
2019-04-21 13:28:02,740: DEBUG - + local message
2019-04-21 13:28:02,740: DEBUG - + local ret_code
2019-04-21 13:28:02,740: DEBUG - + ynh_handle_getopts_args
2019-04-21 13:28:02,741: DEBUG - + set +x
2019-04-21 13:28:02,741: DEBUG - + echo ‘’
2019-04-21 13:28:02,742: DEBUG - + exit 1

4

Any chance that you could actually describe your issue, @jookk ?

5

That’s the same issue.
The fix is pending here https://github.com/YunoHost-Apps/phpmyadmin_ynh/pull/86