Jump to content

trying to install server onto ubuntu


feartheway

Recommended Posts

have to refresh my memory on setting up windows firewall and router.

To allow remote connections to the server the following ports need to be opened: * 5040-5060 * 5090 * 9005-9010 They should be opened for both UDP and TCP connections.

i did the windows firewall i guess i need to check my router

still getting this ...

Failed to connect to rdp world server at 192.168.1.157:5052

 

https://unity.wiki.atavismonline.com/project/atavism-client-unity-installation/

 

 

my previous forums

 

 

 

some reference material

 

Link to comment
Share on other sites

Keep in mind that 5052 is UDP port. can you check if the port is accessible 

Can you verify that the port is accessible on the sever machine on the interface where you have your IP 192.168.1.157?

nmap -p 5052 -sU -P0 192.168.1.157

and if it will work, try to do it from a different machine. Basically if the server is starting properly, then the only way that can cause this is firewall on the server or on the client.

Link to comment
Share on other sites

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)
 

Link to comment
Share on other sites

13 hours ago, feartheway said:

wildo I left the server running and at the end it said "license verifcation failed"

 

image.png

This can occur in a case where the server doesn't have access to the Internet, outgoing port 443 (HTTPS) is closed, or cannot resolve DNS names.

8 hours ago, feartheway said:

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?

image.thumb.png.e9221bbd65d3925348f94f2bd8ea916b.png

 

 

is it possible that you have an incorrect client version like it's not 10.5.0 for some reason?

8 hours ago, feartheway said:

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)

This is simply due to disconnection from the server, so it's more like a result rather than the actual reason.

Link to comment
Share on other sites

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.

 

 

 

 

 

 

Link to comment
Share on other sites

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.

 

 

 

mysqlproblem2root.png

Link to comment
Share on other sites

I think its something to do with this... 

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.

image.thumb.png.19dfc595c256d4316e35dcf4721aea7b.png

 

 

image.png

Link to comment
Share on other sites

UPDATE FIXED IT SOMEHOW everything is green going to test the client now :D

 

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

 

image.thumb.png.541e23f1940e6571fb70125b337b0bea.png

 

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

 

 

 

 

Link to comment
Share on other sites

  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
  • Recommended Cloud Solution


    ksweb.net

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.