trying to install server onto ubuntu

[feartheway]

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

 

[Martin (Dragonsan)]

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.

[feartheway]

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

 

[feartheway]

i put in 

nmap -p 5052 -sU -P0 192.168.1.157

 

[feartheway]

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?

 

 

[feartheway]

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)
 

[Martin (Dragonsan)]

13 hours ago, feartheway said:

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

 

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?

 

 

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.

[feartheway]

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.

 

 

 

 

 

 

[feartheway]

its not letting me stop the server any reason why?

Any good ways of forcing a restart and stop of atavism of the system?

 

[feartheway]

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 

[feartheway]

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.

 

 

 

[feartheway]

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?

 

 

 

 

 

 

 

 

 

[Zbawcasan]

I see that you run the server with administrator rights.
delete as root (with sudo) the run folder in atavism_server/bin directory and delete logs folder in the atavism server/ directory

then run atavism server from ubuntu user

[feartheway]

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?

 

[Zbawcasan]

you forgot the dots before /

[feartheway]

next problem is the world.properties does not seem to start up

      ./world.sh -vC start

 

[Zbawcasan]

send packed logs to support@atavismonline.com

[feartheway]

sent the logs please confirm you got them

[Zbawcasan]

I can see in the logs that you have set the wrong login / password to the database
and the domain server could not start because the port was already busy
check if the previously started processes of atavism were closed

[feartheway]

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

 

 

 

[feartheway]

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.

 

 

[feartheway]

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

 

 

 

 

[feartheway]

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

[Martin (Dragonsan)]

It's all about open ports, proper IPs, and access to the database. I'm glad you are up and running

[Darwinasm86]

Hi I am pretty much stuck with getting UBUNTU server setup.

I followed the guide and I feel confident I did everything, but I must have missed something because I can't connect to the Auth Server and I don't see the Auth.sh script telling me I can login, it's just stuck as you can see in the image

Any help?