Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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 #212

Open
chivarpilones opened this issue Apr 23, 2023 · 0 comments
Open

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 #212

chivarpilones opened this issue Apr 23, 2023 · 0 comments

Comments

@chivarpilones
Copy link

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@chivarpilones