[GAMEMODE] WiredPlayers Roleplay Server

[chocopops]

Hey Xabi, I'm sorry to bother you. I installed your WiredPlayers roleplay mod but for some odd reason the database won't connect.

 

 

-> Error starting 'WiredPlayers' System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.AggregateException: One or more errors occurred.

 

I receive this error above. I did link my IP, database name and database password in the meta.xml as well as the database.cs in the WiredPlayers.csproj and pressed Build, I put all the files inside the server and yet when I launch the server I received this error. What could possibly be the issue? Do I need to add ports to the IP as well, or is it okay without? Again, sorry for interrupting you. I've just been really struggling and trying with this for quite a while now and would really appreciate some help.

[Xabi]

1 hour ago, chocopops said:

Hey Xabi, I'm sorry to bother you. I installed your WiredPlayers roleplay mod but for some odd reason the database won't connect.

 

 

-> Error starting 'WiredPlayers' System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.AggregateException: One or more errors occurred.

 

I receive this error above. I did link my IP, database name and database password in the meta.xml as well as the database.cs in the WiredPlayers.csproj and pressed Build, I put all the files inside the server and yet when I launch the server I received this error. What could possibly be the issue? Do I need to add ports to the IP as well, or is it okay without? Again, sorry for interrupting you. I've just been really struggling and trying with this for quite a while now and would really appreciate some help.

Database.cs? What did you change there? There's no need to change anything but SSLmode there, as that's the meta.xml for.

[I'm Pickle Rick]

20 hours ago, TiPi said:

 

Hello,

 

Thanks for your feedback.

I subscribe to your patreon how can I access the source now

 

https://github.com/TiPi57

Write him a message on patreon with your github nickname

[chocopops]

14 hours ago, Xabi said:

Database.cs? What did you change there? There's no need to change anything but SSLmode there, as that's the meta.xml for.

Got you. I changed Database.cs back, and put my server IP in meta.xml with the server port, is that good or should I remove the port?

 

I also received this error now, I believe it has to do with the database but I'm really unaware of what the issue is. I put in my database name, my database password, my server IP WITH the port in meta.xml and yet the server just launches for like 10 seconds, loads me in this starting room and then I'm stuck before the server crashes again.

 

Here's the error:

Quote

-> Error starting 'WiredPlayers' 
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.AggregateException: One or more errors occurred. (Der angegebene Host ist unbekannt) ---> System.Net.Sockets.SocketException: Der angegebene Host ist unbekannt 
at IPHostEntry System.Net.Dns.InternalGetHostByName(string hostName, bool includeIPv6) 
at void System.Net.Dns.ResolveCallback(object context) 
at IPHostEntry System.Net.Dns.HostResolutionEndHelper(IAsyncResult asyncResult) 
at IPAddress[] System.Net.Dns.EndGetHostAddresses(IAsyncResult asyncResult) 
at bool System.Net.Sockets.Socket.DoDnsCallback(IAsyncResult result, MultipleAddressConnectAsyncResult context) 
at void System.Net.Sockets.Socket.DnsCallback(IAsyncResult result) 
at void System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) 
at void System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult) 
at Task System.Net.Sockets.TcpClient.ConnectAsync(string host, int port)+(IAsyncResult asyncResult) => { } [1] 
at void System.Threading.Tasks.TaskFactory<TResult>.FromAsyncCoreLogic(IAsyncResult iar, Func<IAsyncResult, TResult> endFunction, Action<IAsyncResult> endAction, Task<TResult> promise, bool requiresSynchronization) 
--- End of inner exception stack trace --- 
at void System.Threading.Tasks.Task.ThrowIfExceptional(bool includeTaskCanceledExceptions) 
at bool System.Threading.Tasks.Task.Wait(int millisecondsTimeout, CancellationToken cancellationToken) 
at Stream MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings) 
at void MySql.Data.MySqlClient.NativeDriver.Open() 
--- End of inner exception stack trace --- 
at void MySql.Data.MySqlClient.NativeDriver.Open() 
at void MySql.Data.MySqlClient.Driver.Open() 
at Driver MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) 
at Driver MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() 
at Driver MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() 
at Driver MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() 
at Driver MySql.Data.MySqlClient.MySqlPool.GetConnection() 
at void MySql.Data.MySqlClient.MySqlConnection.Open() 
at List<BusinessModel> WiredPlayers.database.Database.LoadAllBusiness() in C:\RAGEMP\server-files\bridge\resources\WiredPlayers\database\Database.cs:line 1218 
at void WiredPlayers.business.Business.LoadDatabaseBusiness() in C:\RAGEMP\server-files\bridge\resources\WiredPlayers\business\Business.cs:line 19 
at void WiredPlayers.database.Database.OnResourceStart() in C:\RAGEMP\server-files\bridge\resources\WiredPlayers\database\Database.cs:line 40 
--- End of inner exception stack trace --- 
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) 
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) 
at GTANetworkInternals.ScriptingEngine.InvokeVoidMethod(String method, Object[] args) 
at System.Collections.Generic.List`1.ForEach(Action`1 action) 
at GTANetworkInternals.EventHandler.ParseEx(Event _event, ScriptingEngine engine, Object[] arguments) 
at System.Collections.Generic.List`1.ForEach(Action`1 action) 
at GTANetworkInternals.GameServer.StartResource(String resourceName, String parent) 

 

[TiPi]

Just a short message to thank Xabi and encourage you to join the patreon. 
The project has come a long way since the free version. 
The contribution is small in relation to work and support.

Edited July 19, 2019 by TiPi

[Xabi]

1 hour ago, chocopops said:

Got you. I changed Database.cs back, and put my server IP in meta.xml with the server port, is that good or should I remove the port?

 

I also received this error now, I believe it has to do with the database but I'm really unaware of what the issue is. I put in my database name, my database password, my server IP WITH the port in meta.xml and yet the server just launches for like 10 seconds, loads me in this starting room and then I'm stuck before the server crashes again.

 

Here's the error:

 

You don't need to put the port if it's the default one (which should be 3306)

[chocopops]

46 minutes ago, Xabi said:

You don't need to put the port if it's the default one (which should be 3306)

 

My port isn't the default one because I'm loading the database on a server from a host. 

 

So despite putting the IP of the server with the port in the "host" entry, I just get those errors listed above. I followed the tutorial step by step yet this happens, I'm not exactly sure what really is wrong.

[Xabi]

48 minutes ago, chocopops said:

 

My port isn't the default one because I'm loading the database on a server from a host. 

 

So despite putting the IP of the server with the port in the "host" entry, I just get those errors listed above. I followed the tutorial step by step yet this happens, I'm not exactly sure what really is wrong.

Then you'll have to change the MySQL connection string to add that port, but it can't be on the IP.

[chocopops]

1 hour ago, Xabi said:

Then you'll have to change the MySQL connection string to add that port, but it can't be on the IP.

How do I do that? Is this something for me to change within my own MySQL or is it within your own files? 

 

Sorry for asking a lot of questions, I'm not that great with databases.

[Reve]

Xabi
Здравствуйте.
Создал поставил ваш сервер, при входе на сервер нету окна авторизации.
Базу данных подключил, пакеты bridge установил, файл enable-clientside-cs.txt создал.
Ищу информацию уже много часов, так ответа и не нашёл.
https://imgur.com/a/HM4aAhU
https://imgur.com/a/zfuSrb2