ERROR 1356 (HY000) at line 2: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

[chivarpilones]

Actual behavior

Successfully tagged kupiki-portal-backend_portal-backend:latest ::: Adding portal backend in systemd startup ::: Disabling Portal backend service ::: Adding Freeradius in systemd startup ::: Activating Freeradius service Synchronizing state of freeradius.service with SysV service script with /lib/systemd/systemd-sysv-install. Executing: /lib/systemd/systemd-sysv-install enable freeradius ::: Creating fail2ban local configuration ::: Configuring fail2ban jail rules ::: Reloading fail2ban local configuration OK ::: Create banner on login ::: Append script version to the banner ::: Changing banner rights ::: Activating the banner for SSH ::: ::: Reload configuration for SSH service ::: Creating Kupiki Admin folder for the database ::: Changing rights of the folder ::: Updating authentication plugin ERROR 1356 (HY000) at line 2: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them ::: ::: Something went wrong with the last command. Please check the log file :::

Expected behavior

{Please write here}

Configuration parameters (if changed in the script)

cp pihotspot.sh Chivar.sh

Logs

::: ::: Log file created : /var/log/Chivar_hotspot.log ::: Use command 'tail -f /var/log/Chivar_hotspot.log' in a new console to get installation details ::: Updating APT config to force IPv4 Acquire::ForceIPv4 "true"; ::: Configuring localepurge ::: Disable integrated Bluetooth support (After next reboot) ::: Checking for tun module tun 61440 2 ::: Checking if LAN interface already exists wlan0: flags=323<UP,BROADCAST,RUNNING,PROMISC> mtu 1500 ::: Adding MariaDb password ::: Adding MariaDb password (confirmation) ::: Getting WAN IP of the Raspberry Pi (for daloradius access) ::: Updating the system hostname to Chivar ::: Adding Avahi dependencies ::: Updating /etc/hosts ::: Correct configuration for Collectd daemon ::: Install pika module ::: Removing any previous sources of CoovaChilli project ::: Cloning CoovaChilli project Cloning into 'coova-chilli'... ::: Removing any previous sources of Kupiki Admin ::: Cloning Kupiki Admin web UI project Cloning into 'webui'... ::: Download Kupiki SQL Counters --2023-04-23 22:23:41-- https://raw.githubusercontent.com/pihomeserver/Kupiki-Hotspot-Script/master/updates/sqlcounter Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 185.199.110.133, 185.199.111.133, 185.199.108.133, ... Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|185.199.110.133|:443... connected. HTTP request sent, awaiting response... 200 OK Length: 9037 (8.8K) [text/plain] Saving to: 'sqlcounter'

 0K ........                                              100% 23.6K=0.4s

2023-04-23 22:23:42 (23.6 KB/s) - 'sqlcounter' saved [9037/9037]

::: Download Haserl --2023-04-23 22:23:42-- http://downloads.sourceforge.net/project/haserl/haserl-devel/haserl-0.9.35.tar.gz Resolving downloads.sourceforge.net (downloads.sourceforge.net)... 204.68.111.105 Connecting to downloads.sourceforge.net (downloads.sourceforge.net)|204.68.111.105|:80... connected. HTTP request sent, awaiting response... 302 Found Location: http://udomain.dl.sourceforge.net/project/haserl/haserl-devel/haserl-0.9.35.tar.gz [following] --2023-04-23 22:23:43-- http://udomain.dl.sourceforge.net/project/haserl/haserl-devel/haserl-0.9.35.tar.gz Resolving udomain.dl.sourceforge.net (udomain.dl.sourceforge.net)... 203.135.147.10 Connecting to udomain.dl.sourceforge.net (udomain.dl.sourceforge.net)|203.135.147.10|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 152239 (149K) [application/x-gzip] Saving to: 'haserl-0.9.35.tar.gz'

 0K .......... .......... .......... .......... .......... 33%  110K 1s
50K .......... .......... .......... .......... .......... 67%  225K 0s

100K .......... .......... .......... .......... ........ 100% 843K=0.7s

2023-04-23 22:23:45 (202 KB/s) - 'haserl-0.9.35.tar.gz' saved [152239/152239]

::: Cloning daloradius project Cloning into 'daloradius'... Updating files: 100% (1654/1654), done. ::: Cloning Pi Hotspot portal project Cloning into 'portal'... ::: Cloning Pi Hotspot portal backend project Cloning into 'kupiki-portal-backend'... ::: Starting MySql service ::: Update interface configuration (eth0) auto eth0 allow-hotplug eth0 iface eth0 inet dhcp ::: Update interface configuration (wlan0) auto wlan0 allow-hotplug wlan0 iface wlan0 inet static ::: Update wifi configuration to add country code country=PH ::: Activating the WAN interface ifup: interface eth0 already configured ::: Activating the LAN interface ifup: interface wlan0 already configured ::: Stopping fprobe service ::: Stopping nfdump service ::: Updating fprobe configuration ::: Updating nfdump configuration ::: Updating nfdump service configuration (init.d) ::: Updating nfdump service configuration (systemd) ::: Set cleaning options for Netflow data ::: Adding logs cleaning every day at 1am (system time) ::: Adding Netflow stats update in the crontab 00 01 * * * root /usr/bin/nfexpire -r /var/cache/nfdump ::: Stopping freeradius service to update the configuration ::: Creating freeradius database ::: Installing freeradius schema ::: Adding setup data ::: Updating freeradius configuration - Activate SQL support ::: Configuration of the Freeradius SQL driver ::: Change dialect of the Freeradius SQL driver to mysql ::: Configuration of the Freeradius SQL connection ::: Updating freeradius configuration - Activate SQL counters ::: Bug fix for SQL dialect once SQL Counters are activated ::: Update of Freeradius secret key ::: Updating inner-tunnel configuration (1) ::: Updating inner-tunnel configuration (2) ::: Updating freeradius default configuration (1) ::: Updating freeradius default configuration (2) ::: Activating COA support in Freeradius ::: Adding CoovaChilli counters (limit bandwidth) ::: Updating file access rights ::: Activating counters ::: Checking freeradius configuration ::: Activating IP forwarding ::: Restarting network service to take IP forwarding into account Restarting networking (via systemctl): networking.service. ::: Configuring CoovaChilli up action ::: Block access from LAN to WAN except portal ::: Activating CoovaChilli ::: Creating CoovaChilli at /etc/chilli/config ::: Configure MAC address authentication (1/2) ::: Configure MAC address authentication (2/2) ::: Activating CoovaChilli on boot update-rc.d: warning: start and stop actions are no longer supported; falling back to defaults ::: Uncompressing Haserl archive haserl-0.9.35/ haserl-0.9.35/ChangeLog . . . haserl-0.9.35/install-sh ::: Compiling and installing Haserl Making install in src make[1]: Entering directory '/usr/src/haserl-0.9.35/src' . . make[1]: Leaving directory '/usr/src/haserl-0.9.35' ::: Updating chilli configuration ::: Creating configuration file for hostapd ::: Configuring hostapd ::: Installing Daloradius in Nginx folder ::: Loading daloradius configuration into MySql ::: Drop freeradius tables created by Daloradius to reload the Freeradius 3.0 version ::: Reload original Freeradius schema ::: Creating users privileges for localhost ::: Granting users privileges ::: Configuring daloradius DB user name ::: Configuring daloradius DB user password ::: Configuring daloradius DB proxy configuration file ::: Configuring daloradius DB proxy path ::: Building NGINX configuration (default listen port : 80) ::: Building NGINX configuration for the portal (default listen port : 80) ::: Activating portal website ::: Installing the portal in Nginx folder ::: Updating Captive Portal configuration file - Register host ::: Updating Captive Portal configuration file - Chilli Controller host ::: Checking Nginx configuration file nginx: the configuration file /etc/nginx/nginx.conf syntax is ok nginx: configuration file /etc/nginx/nginx.conf test is successful ::: Installing the portal backend in the user kupiki home folder ::: Updating Captive Portal backend configuration file ::: Update rights for NGINX sites ::: ::: Build the Docker image of Portal backend ::: Adding portal backend in systemd startup ::: Disabling Portal backend service ::: Adding Freeradius in systemd startup ::: Activating Freeradius service ::: Creating fail2ban local configuration ::: Configuring fail2ban jail rules ::: Reloading fail2ban local configuration ::: Create banner on login ::: Append script version to the banner ::: Changing banner rights ::: Activating the banner for SSH ::: ::: Reload configuration for SSH service ::: Creating Kupiki Admin folder for the database ::: Changing rights of the folder ::: Updating authentication plugin ::: ::: Something went wrong with the last command. Please check the log file :::

Your environment

OS: Debian GNU/Linux 11 (bullseye) aarch64 Host: Raspberry Pi 3 Model B Plus Rev 1.3

Additional comments

this part of script near bottom

display_message "Updating authentication plugin" mariadb -u root -p$MYSQL_PASSWORD << EOT use mysql; update user set authentication_string=password('$MYSQL_PASSWORD'), plugin='mysql_native_password' where user='root'; flush privileges; EOT check_returned_code $?

ERROR 1356 (HY000) at line 2: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

im stuck in this part please help