feartheway

It all seems to be working now! Phew that was a deep / steep learning experience for me regarding ubuntu, pi4, atavism, mysql.

UPDATE FIXED IT SOMEHOW everything is green going to test the client now https://duckduckgo.com/?q=ER_HOST_NOT_PRIVILEGED%3A+Host+is+not+allowed+to+connect+to+this+MySQL+server&atb=v228-1&ia=web mysql -u root -p use mysql; select host from user where user='root'; update user set host = '%' where user ='root'; // If Host = '%', it means that all IPs have connection privileges, which should be set according to the IPs of the production environment flush privileges; new error = connection error Connection error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client i did this before hope it works to solve the problem cd /etc/mysql sudo mcedit /etc/mysql/my.cnf #add this line at the end [mysqld] default-authentication-plugin=mysql_native_password sudo systemctl status mysql.service sudo shutdown -r now (reboot) sudo systemctl status mysql.service https://www.tutorialspoint.com/how-to-restart-mysql-server sudo systmectl restart mysql mysql> restart; mysql> show databases; mysql> select version(); ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; ALTER USER 'atavism'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; ALTER USER 'atavism'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; ALTER USER 'ubuntu'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; ALTER USER 'ubuntu'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; CREATE USER 'jeffrey'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; https://www.javaniceday.com/post/error-er_not_supported_auth_mode-client-does-not-support-authentication-protocol-requested-by-server -- to deal with ER_NOT_SUPPORTED_AUTH_MODE error. Only run this line for local dev ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; -- create our main user for local dev CREATE USER IF NOT EXISTS 'my_user'@'%' IDENTIFIED BY 'root'; CREATE DATABASE IF NOT EXISTS `test_container` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; GRANT ALL PRIVILEGES ON test_container.* TO 'my_user'@'%' WITH GRANT OPTION; flush privileges; update db set Host=’133.155.44.103' where Db='yourDB'; update user set Host=’133.155.44.103' where user='user1'; GRANT ALL ON database_name.* to 'database_username'@'10.24.96.5' IDENTIFIED BY 'database_password'; > FLUSH PRIVILEGES; > SELECT host FROM mysql.user WHERE user = "database_username"; https://phoenixnap.com/kb/mysql-remote-connection https://www.tecmint.com/fix-error-1130-hy000-host-not-allowed-to-connect-mysql/ sudo systemctl restart mysql sudo ufw allow from remote_ip_address to any port 3306 Open Port 3306 with iptables The iptables utility is available on most Linux distributions by default. Type the following command to open MySQL port 3306 to unrestricted traffic: sudo iptables -A INPUT -p tcp --dport 3306 -j ACCEPT To limit access to a specific IP address, use the following command instead: sudo iptables -A INPUT -p tcp -s 133.155.44.103 --dport 3306 -j ACCEPT

I think its something to do with this... Posted October 7 Ensure that the server port 3306 is accessible from your PC. You can do this with telnet or nmap (Linux). First do this locally to ensure that the database is running like telnet 127.0.0.1 3306 or nmap 127.0.0.1 -p 3306 If it will work then use server IP on the server, like telnet YourServerIP 3306 or nmap YourServerIP -p 3306 If it won't work (port will be closed), then there are two options: 1. MySQL is bound on the localhost address only, and you need to change it in the MySQL configuration file (usually in the /etc/mysql/mysql.conf.d/mysqld.cnf) you need to modify entry bind-address from 127.0.0.1 to 0.0.0.0 and then restart MySQL service sudo systmectl restart mysql tried the atavism editor test Connection error: ER_HOST_NOT_PRIVILEGED: Host 'user1-PC.home' is not allowed to connect to this MySQL server 3306 still seems to be disabled.

everything seems to be working on pi now but the remote pc cannot connect?

sent the logs please confirm you got them

next problem is the world.properties does not seem to start up ./world.sh -vC start

Ok I have resintalled the pi but now i have another problem i try sudo ./auth.sh -vC start solved needed to do this ls -ls chmod +x * command no found?! what have i forgotten to do?

i tried to start ./world.sh -vC start and this happened and a lot of red screens should have been sudo ./world.sh -vC start how do i get rid of all the old logs? this looks bad?

i used this to update mysql to demo data, login as root. sudo mysql -u root -p < "admin.sql" pw test sudo mysql -u root -p < "atavism.sql" pw test sudo mysql -u root -p < "master.sql" pw test sudo mysql -u root -p < "world_content.sql" pw test obviously if / when i go live I will have to change passwords.

ok i switched it off and on again and now it wont let me update the sql My problem seems to be how to update the server sql files. access denied for user -p

its not letting me stop the server any reason why? Any good ways of forcing a restart and stop of atavism of the system?

I think i may not have installed the demo data into the server? maybe i did will have to check my logbook. https://unity.wiki.atavismonline.com/project/installation/ Import DB structure files to your DB engine (MySQL) there are 4 files located in “Server_location_files/sql/” or “Server_location_files/sql/New Install with Demo Data” depending on your choice. By default databases will be imported using the utf8 character set and utf8_general_ci collation. admin.sql atavism.sql master.sql world_content.sql In command line type: mysql -u -p <”filename.sql” – if local DB mysql -u -h -p <”filename.sql” – if remote DB this video is helpful but i do not see any distinction between data structure and data in 10.5 sql folder on server. There are not 2 different folders data structure / data in 10.5.

warning message in console is this. Got Disconnect() from at Atavism.AtavismNetworkHelper.Disconnect () [0x00000] in <616cf1dbffea491ead6414b44286991b>:0 at Atavism.AtavismWorldManager.Disconnected () [0x00000] in <616cf1dbffea491ead6414b44286991b>:0 at Atavism.AtavismClient.Update () [0x00083] in <616cf1dbffea491ead6414b44286991b>:0 UnityEngine.Debug:LogWarning (object) Atavism.AtavismNetworkHelper:Disconnect () (at Assets/Standard Assets/Atavism Core/Networking/AtavismNetworkHelper.cs:1499) Atavism.AtavismWorldManager:Disconnected () (at Assets/Standard Assets/Atavism Core/Base/AtavismWorldManager.cs:1826) Atavism.AtavismClient:Update () (at Assets/Standard Assets/Atavism Core/Base/AtavismClient.cs:320)

i did ufw disable on the pi for now. will have to figure out how to configure ufw later. now it does not crash but it does just cycle back to login screen?

i put in nmap -p 5052 -sU -P0 192.168.1.157