Solved: Connection problems...

[vladyslu]

I followed the instruction on how to set up a server on digital oceans. Everything connected. The game does not join. I tried many times with different builds, and nothing worked. I do not know what to do. I bought the kit on the Unity Asset Store.

[insthync]

Did you open ports? https://www.digitalocean.com/community/tutorials/how-to-set-up-a-firewall-with-ufw-on-ubuntu-18-04

sudo ufw allow 7000

[vladyslu]

Did you open ports? https://www.digitalocean.com/community/tutorials/how-to-set-up-a-firewall-with-ufw-on-ubuntu-18-04

sudo ufw allow 7000

Sure. I did everything that was stated in this instruction: https://suriyun-production.github.io/mmorpg-kit-docs/#/dedicates/digitalocean

[insthync]

No more info?, how can I help you, team viewer ?

[vladyslu]

No more info?, how can I help you, team viewer?

Will you be available in around 40 minutes? Also, I can send you screenshots.

[vladyslu]

This is my root/build command:

root@phpmyadmin-ubuntu-s-1vcpu-1gb-nyc3-01:~# /root/Build.x86_64 -startCentralSe rver -startChatServer -startMapSpawnServer -startDatabaseServer Mono path[0] = '/root/Build_Data/Managed' Mono config path = '/root/Build_Data/MonoBleedingEdge/etc' Initialize engine version: 2020.3.22f1 (e1a7f79fd887) [Subsystems] Discovering subsystems at path /root/Build_Data/UnitySubsystems Forcing GfxDevice: Null GfxDevice: creating device client; threaded=0 NullGfxDevice: Version: NULL 1.0 [1.0] Renderer: Null Device Vendor: Unity Technologies Begin MonoManager ReloadAssembly

• Completed reload, in 0.429 seconds ERROR: Shader Sprites/Default shader is not supported on this GPU (none of subsh aders/fallbacks are suitable) ERROR: Shader Sprites/Mask shader is not supported on this GPU (none of subshade rs/fallbacks are suitable) ERROR: Shader Projector/AdditiveTint shader is not supported on this GPU (none o f subshaders/fallbacks are suitable) ERROR: Shader Mobile/Particles/Additive shader is not supported on this GPU (non e of subshaders/fallbacks are suitable) ERROR: Shader Mobile/Unlit (Supports Lightmap) shader is not supported on this G PU (none of subshaders/fallbacks are suitable) ERROR: Shader Mobile/Particles/Alpha Blended shader is not supported on this GPU (none of subshaders/fallbacks are suitable) ERROR: Shader Legacy Shaders/Particles/Alpha Blended Premultiply shader is not s upported on this GPU (none of subshaders/fallbacks are suitable) ERROR: Shader Legacy Shaders/VertexLit shader is not supported on this GPU (none of subshaders/fallbacks are suitable) ERROR: Shader Mobile/Particles/VertexLit Blended shader is not supported on this GPU (none of subshaders/fallbacks are suitable) ERROR: Shader Mobile/VertexLit shader is not supported on this GPU (none of subs haders/fallbacks are suitable) WARNING: Shader Unsupported: 'Standard' - All subshaders removed WARNING: Shader Did you use #pragma only_renderers and omit this platform? WARNING: Shader If subshaders removal was intentional, you may have forgotten tu rning Fallback off? ERROR: Shader Standard shader is not supported on this GPU (none of subshaders/f allbacks are suitable) WARNING: Shader Unsupported: 'Standard' - All subshaders removed WARNING: Shader Did you use #pragma only_renderers and omit this platform? WARNING: Shader If subshaders removal was intentional, you may have forgotten tu rning Fallback off? WARNING: Shader Unsupported: 'Mobile/Diffuse' - All subshaders removed WARNING: Shader Did you use #pragma only_renderers and omit this platform? WARNING: Shader If subshaders removal was intentional, you may have forgotten tu rning Fallback off? ERROR: Shader Mobile/Diffuse shader is not supported on this GPU (none of subsha ders/fallbacks are suitable) WARNING: Shader Unsupported: 'Mobile/Diffuse' - All subshaders removed WARNING: Shader Did you use #pragma only_renderers and omit this platform? WARNING: Shader If subshaders removal was intentional, you may have forgotten tu rning Fallback off? ERROR: Shader GUI/Text Shader shader is not supported on this GPU (none of subsh aders/fallbacks are suitable) UnloadTime: 1.060113 ms Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.dll Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.dll.so Fallback handler could not load library /root/Build_Data/Mono/advapi32.dll Fallback handler could not load library /root/Build_Data/Mono/libadvapi32 Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.so Fallback handler could not load library /root/Build_Data/Mono/advapi32 Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.dll Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.dll.so Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.dll Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.dll Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.dll.so Fallback handler could not load library /root/Build_Data/Mono/advapi32.dll Fallback handler could not load library /root/Build_Data/Mono/libadvapi32 Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.so Fallback handler could not load library /root/Build_Data/Mono/advapi32 Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.dll Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.dll.so Fallback handler could not load library /root/Build_Data/Mono/libadvapi32.dll [DevExt] GameInstance - Awake Reading config file from ./config/serverConfig.json [DevExt] GameInstance - LoadedGameData Fallback handler could not load library /root/Build_Data/Mono/libKernel32 Fallback handler could not load library /root/Build_Data/Mono/libKernel32.so Fallback handler could not load library /root/Build_Data/Mono/Kernel32 Fallback handler could not load library /root/Build_Data/Mono/libKernel32 Fallback handler could not load library /root/Build_Data/Mono/libKernel32.so Fallback handler could not load library /root/Build_Data/Mono/libKernel32 Uploading Crash Report InvalidOperationException: Connection must be Open; current state is Closed at MySqlConnector.MySqlConnection.get_Session () [0x00035] in :0 at MySqlConnector.Core.ICancellableCommandExtensions.ResetCommandTimeout (MySqlConnector.Core.ICancellableCommand c ommand) [0x0000a] in :0 at MySqlConnector.MySqlCommand+d71.MoveNext () [0x0001e] in :0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <695d1cc93cca45069c528c15c9fdd749>: 0 at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in < 695d1cc93cca45069c528c15c9fdd749>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <695d1cc93cca45069c528c15c9fdd749>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <695d1cc 93cca45069c528c15c9fdd749>:0 at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <695d1cc93cca45069c528c15c9fdd7 49>:0 at MultiplayerARPG.MMO.MySQLDatabase+d22.MoveNext () [0x00180] in <ac57af28367340b189defdf81b9c110 2>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <695d1cc93cca45069c528c15c9fdd749>: 0 at Cysharp.Threading.Tasks.UniTask+ExceptionResultSource1[T].GetResult (System.Int16 token) [0x00000] in <1143cfe3 cee144cdaad992f97e49f25e>:0 at MultiplayerARPG.MMO.MySQLDatabase+<ExecuteScalar>d__21.MoveNext () [0x000ff] in <ac57af28367340b189defdf81b9c110 2>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <695d1cc93cca45069c528c15c9fdd749>: 0 at Cysharp.Threading.Tasks.CompilerServices.AsyncUniTask2[TStateMachine,T].GetResult (System.Int16 token) [0x00000 ] in <1143cfe3cee144cdaad992f97e49f25e>:0 at MultiplayerARPG.MMO.MySQLDatabase+d7.MoveNext () [0x00087] in <ac57af28367340b189defdf81b9c110 2>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <695d1cc93cca45069c528c15c9fdd749>: 0 at Cysharp.Threading.Tasks.CompilerServices.AsyncUniTask`2[TStateMachine,T].GetResult (System.Int16 token) [0x00000 ] in <1143cfe3cee144cdaad992f97e49f25e>:0 at MultiplayerARPG.MMO.MySQLDatabase+d6.MoveNext () [0x00238] in :0 UnityEngine.DebugLogHandler:Internal_LogException(Exception, Object) UnityEngine.DebugLogHandler:LogException(Exception, Object) UnityEngine.Logger:LogException(Exception, Object) UnityEngine.Debug:LogException(Exception) Cysharp.Threading.Tasks.UniTaskScheduler:PublishUnobservedTaskException(Exception) MultiplayerARPG.MMO.d6:MoveNext() Cysharp.Threading.Tasks.CompilerServices.AsyncUniTaskVoid1:Run() Cysharp.Threading.Tasks.AwaiterActions:Continuation(Object) Cysharp.Threading.Tasks.UniTaskCompletionSourceCore1:TrySetException(Exception) Cysharp.Threading.Tasks.CompilerServices.AsyncUniTask`2:SetException(Exception) MultiplayerARPG.MMO.d7:MoveNext() Cysharp.Threading.Tasks.CompilerServices.AsyncUniTask2:Run() Cysharp.Threading.Tasks.AwaiterActions:Continuation(Object) Cysharp.Threading.Tasks.UniTaskCompletionSourceCore1:TrySetException(Exception) Cysharp.Threading.Tasks.CompilerServices.AsyncUniTask2:SetException(Exception) MultiplayerARPG.MMO.<ExecuteScalar>d__21:MoveNext() Cysharp.Threading.Tasks.CompilerServices.AsyncUniTask2:Run() Cysharp.Threading.Tasks.AwaiterActions:Continuation(Object) Cysharp.Threading.Tasks.UniTaskCompletionSourceCore1:TrySetResult(AsyncUnit) Cysharp.Threading.Tasks.CompilerServices.AsyncUniTask1:SetResult() MultiplayerARPG.MMO.d11:MoveNext() Cysharp.Threading.Tasks.CompilerServices.AsyncUniTask`1:Run() System.Threading.Tasks.<>c:<.cctor>b7_0(Object) UnityEngine.WorkRequest:Invoke() UnityEngine.UnitySynchronizationContext:Exec() UnityEngine.UnitySynchronizationContext:ExecuteTasks()

[insthync]

Send your team viewer info to ittipon.bay@gmail.com

[insthync]

It seems like you did not set mysql connection properly

[insthync]

For quick connection test, you may try change database to SQLite, by change config in serverConfig.json to "databaseOptionIndex" : 0,

[vladyslu]

For quick connection test, you may try change database to SQLite, by change config in serverConfig.json to "databaseOptionIndex" : 0,

I tried it, and it did not help. I sent you a team viewer invite.

[insthync]

Send the info to my email.

[vladyslu]

I sent you the invite on ittipon.bay@gmail.com again. Do you need any other info?

[vladyslu]

sorry. I saw that you connected at the moment when you disconnected.

[insthync]

I actually want to control your PC to find problems, you may login into SSH server before send TeamViewer info to me.

On Fri, 19 Nov 2021 at 23:06, Vladyslav Luchenko @.***> wrote:

I sent you the invite on @.*** again. Do you need any other info?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/suriyun-production/mmorpg-kit-docs/issues/1282#issuecomment-974201396, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAUSSTU63UTDZPASDSJZNWLUMZYY3ANCNFSM5IMF5ILA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[vladyslu]

I think that I logged in to everything.

[insthync]

List of problems

• Wrong config files location, config files must be inside config folder
• Cannot connect to MySQL, caching_sha2_password' requires a secure connection (so I test connection with SQLite later)
• You use a low-spec server, when it launches more than 2 instances, the server machine is freezing.

[vladyslu]

oof. So the $5 droplet is too weak even for two connections?

[insthync]

It's not 2 conenctions, it's 2 instances, it's like running 2 Unity games

[vladyslu]

yes. I get it. I mean it will not be able to hold two players playing.

[insthync]

No you don't understand me

[vladyslu]

did I launch 2 server builds there?

[insthync]

At the server when you set spawnMaps it will run new instances for each map

From the example above it will run 3 more instances.

[insthync]

Players connection is not instances amount.

[vladyslu]

I understand it now. Sorry. :D Thank you. I think that it works well now. For people who may have the same problem:

List of problems

* Wrong config files location, config files must be inside `config` folder

* Cannot connect to MySQL, `caching_sha2_password' requires a secure connection` (so I test connection with SQLite later)

* You use a low-spec server, when it launches more than 2 instances, the server machine is freezing.