windows/linux ARK: Survival Evolved (Supports Clusters)

[DevilzEye1]

I'll attempt again when I get home from work and check the variables again, then attempt to create the service 

[DevilzEye1]

welp, i figured out the problem, i didnt set the username and pass in the actual script, i was trying to use the variables for that instead, my mistake...

however now i get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'YtpiFNv51K'' at line 1

and i dont know anything about the SQL Language.

my server is: Server version: 8.0.19 - MySQL Community Server (Windows) on localhost

the error it shows im assuming is this line:

#mysql.ExecuteNonQuery(String.Format("CREATE USER '{0}'@'localhost' IDENTIFIED BY '{1}';", escapeduser, escapedpass));

but, im not sure what to modify on that to fix it...

 

[Dennis]

What's your current script? Please blank out your MySQL username and password.

[DevilzEye1]

current scripts are the ones from the tcadmin wiki:

generate user/pass (before created) from wiki:

import clr;
import System;

clr.AddReference("TCAdmin.SDK");
from TCAdmin.SDK.Misc import Random;
from System import String;

ThisService.Variables["MySQLUser"] = String.Format("db{0}", ThisService.ServiceId);
ThisService.Variables["MySQLPassword"] = Random.RandomString(10,True,True);
ThisService.Save();

create database (after created) from wiki:

import clr;
import System;

clr.AddReference("TCAdmin.DatabaseProviders.MySql");
clr.AddReference("TCAdmin.SDK");
from TCAdmin.DatabaseProviders.MySql import MySqlManager;
from System import String;

mysql_server="localhost";
mysql_root="xxxx";
mysql_password="xxxx";

with MySqlManager() as mysql:
 escapeduser=mysql.PrepareSqlValue(ThisService.Variables["MySQLUser"]);
 escapedpass=mysql.PrepareSqlValue(ThisService.Variables["MySQLPassword"]);
 mysql.DisableReplication=True;
 mysql.Connect(String.Format("Data Source={0};User Id={1};Password={2};Pooling=False;", mysql_server, mysql_root, mysql_password));

 mysql.ExecuteNonQuery(String.Format("DROP DATABASE IF EXISTS {0};", escapeduser));
 if mysql.Execute(String.Format("SELECT * FROM mysql.user WHERE user='{0}' AND host='localhost';", escapeduser)).Rows.Count == 1 :
  mysql.ExecuteNonQuery(String.Format("DROP USER {0}@localhost;", escapeduser));

 mysql.ExecuteNonQuery(String.Format("CREATE DATABASE {0};", escapeduser));
 ## MYSQL 5 SYNTAX
 mysql.ExecuteNonQuery(String.Format("GRANT ALL PRIVILEGES ON {0}.* TO '{0}'@'localhost' IDENTIFIED BY '{1}';", escapeduser, escapedpass));
 ## MYSQL 8 SYNTAX
 #mysql.ExecuteNonQuery(String.Format("CREATE USER '{0}'@'localhost' IDENTIFIED BY '{1}';", escapeduser, escapedpass));
 #mysql.ExecuteNonQuery(String.Format("GRANT ALL PRIVILEGES ON {0}.* TO '{0}'@'localhost';", escapeduser));

and the before deleted script from wiki:

import clr;
import System;

clr.AddReference("TCAdmin.DatabaseProviders.MySql");
clr.AddReference("TCAdmin.SDK");
from TCAdmin.DatabaseProviders.MySql import MySqlManager;
from System import String;

mysql_server="localhost";
mysql_root="xxxx";
mysql_password="xxxx";

if not ThisService.Variables.HasValue("MySQLUser") :
 Script.Exit();

if ThisService.Variables["MySQLUser"] == String.Empty:
 Script.Exit();

with MySqlManager() as mysql:
 escapeduser=mysql.PrepareSqlValue(ThisService.Variables["MySQLUser"]);
 mysql.DisableReplication=True;
 mysql.Connect(String.Format("Data Source={0};User Id={1};Password={2};Pooling=False;", mysql_server, mysql_root, mysql_password));

 mysql.ExecuteNonQuery(String.Format("DROP DATABASE IF EXISTS {0};", escapeduser));
 if mysql.Execute(String.Format("SELECT * FROM mysql.user WHERE user='{0}' AND host='localhost';", escapeduser)).Rows.Count == 1 :
  mysql.ExecuteNonQuery(String.Format("DROP USER {0}@localhost;", escapeduser));

 

[Dennis]

If you're using MySQL 8, you should uncomment the MySQL 8 lines and remove the MySQL 5 lines.

[DevilzEye1]

Oh wow, I'm sorry, I overlooked that lol, I'll swap that around and try again, thank you

[DevilzEye1]

well it successfully created the database for the server, but im still getting this error on start

Access denied for user 'omitted'@'xxxxx' (using password: YES)

which again, its displaying my webhost MySQL connection information, and not the info in the localhost database i set up specifically for the independent game server...

 <-- the server did create the database upon initial create for the game, so that part worked...

 

so what is the "Access denied" for when trying to "start" the server? (first start)

[Dennis]

The issue is not related to this game config, so you're best off creating a new thread or ticket about it. I can't help much more, unfortunately.

[DevilzEye1]

it only shows that error on that ARK server, none of the others, and creating other servers dont show an error either so it's definitely specific to this game... *shrug*

[DevilzEye1]

i have it working now, i opened a support ticket and they corrected a couple mistakes:

1) when i changed the MySQL password, i didnt restart the Service manager (didnt know i was suppose to)

2) they fixed a syntax error in the mysql scripts. % needs to be in quotes '%' and i pulled all the scripts from the wiki, and what came with the config

3) Before started script from config named "Set permissions on cluster folder" they had to fix as well to this

import clr
clr.AddReference("TCAdmin.SDK")
clr.AddReference("TCAdmin.GameHosting.SDK")
from TCAdmin.GameHosting.SDK.Objects import Server, Service, Game
from TCAdmin.SDK.Objects import User
from System.IO import Directory, Path
from System import Environment, PlatformID, Exception

#Load objects from database.
serviceid=ThisService_ServiceId
ThisService=Service(serviceid)
if ThisService.Variables['clusterid']:
  if ThisService.Variables['ClusterPath'] == None and ThisService.Variables['clusterid'] !='':
    raise Exception('Your service has no ClusterPath set. Go to \"More\" (next to Start) and click \"Set ClusterPath value\"')
  
  elif ThisService.Variables['ClusterPath'] != None and ThisService.Variables['clusterid']:
    ThisUser=User(ThisService.UserId)
    ThisServer=Server(ThisService.ServerId)
    ThisGame=Game(ThisService.GameId)
    
    services=Service.GetServices(ThisUser, ThisService.ServerId)
    if Environment.OSVersion.Platform == PlatformID.Win32NT:
      if not Directory.Exists(ThisService.Variables["ClusterPath"] + "/clusters"):
        Directory.CreateDirectory(ThisService.Variables["ClusterPath"] + "/clusters")
    else:
      from subprocess import Popen
      clusterfolder = ThisService.Variables["ClusterPath"] + "/clusters"
      if not Directory.Exists(clusterfolder):
        Directory.CreateDirectory(clusterfolder)
        Popen(["chown", "-R", ThisService.RunAsUserName+':'+ThisService.RunAsUserName, clusterfolder])

i dont know what they changed but, there is the working version (i didnt touch this script from the original config so, i pasted it for your reference Dennis)

[Dennis]

On 4/10/2021 at 5:21 PM, DevilzEye1 said:

3) Before started script from config named "Set permissions on cluster folder" they had to fix as well to this

That seems identical to what's already in the config. Are you using the latest version?

[DevilzEye1]

yes sir i am  thats just what the rep said, i dunno, unless somehow i screwed it up, but i never opened that script so

but now i cant get ARK to publish to the public ingame server list so, here's yet another problem ive been tackling... it's not related to TCadmin tho because it does it outside of TCA as well... yay

[Dennis]

If you've forwarded all of the ports, you shouldn't worry. That's just how the server list works in ARK (and most other games). It won't show all servers all the time.

[Smolf]

Hello.

Can you please tell me a hint, how to make cluster.

Need information about path.

 

Anyone can help me?

 

[Dennis]

@Smolfyou're not using the latest version of the config. Update it.

[Smolf]

6 minutes ago, Dennis said:

@Smolfyou're not using the latest version of the config. Update it.

Hi again.

Just  uploaded a new config, still the same. Im using linux.

ARK_SE - Linux.xml

[Dennis]

Update again. I see that the Linux config was using the old config as template.

[Smolf]

19 minutes ago, Dennis said:

Update again. I see that the Linux config was using the old config as template.

Thank you

[Smolf]

Work steam workshop, not working, cant download plugins.

Edited April 17, 2021 by Smolf

[Dennis]

@Smolf "Cancelled" seems to indicate that something interrupted the installation. This could possibly be a monitor restart.

[Smolf]

hi.

Can you do something about update?

[conceptr980]

I noticed that ARK had the same issue as your other Config RUST since once the server is full, the query keeps calculating more than the MAX number of users in server which is in queue and it reaches Max limit in tcadmin max players detection.

Solving this with same script of Rust or so would be great (Maybe)

Thx

[Dennis]

@conceptr980 is that not only with CrossPlay enabled? There's no fix for that, unfortunately. That's just how the number of active players are reported.

[conceptr980]

15 hours ago, Dennis said:

@conceptr980 is that not only with CrossPlay enabled? There's no fix for that, unfortunately. That's just how the number of active players are reported.

Thanks for your reply. No crossplay used, just normal server. Disabling players detection query would be the only solution available i presume

[Dennis]

If you add the server to your Steam favorites, does it also report more players than max allowed?