Jump to content

Search the Community

Showing results for tags 'database'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • RAGE Multiplayer
    • Announcements
    • Discussion
    • Suggestions
  • Scripting
    • Scripting
    • Resources
  • Community
    • Support
    • Servers
    • Media Gallery
  • Non-English
    • Русский - Russian
    • Français - French
    • Deutsch - German
    • Espanol - Spanish
    • Română - Romanian
    • Portuguesa - Portuguese
    • Polski - Polish

Categories

  • Scripts
  • Gamemodes
  • Libraries
  • Plugins
  • Maps
  • Tools

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Facebook


Youtube


Skype


Web


VK

Found 8 results

  1. I tried to use the Owl Gaming gamemode for my future server and when I finally looks like I could setting it up, I had a lot of Database errors (I'm using PHPMyAdmin from XAMPP) so I tried to fix them but I wasn't able to. I also tried to ask for help in their github and the RAGE Discord but the people can't give me a solution for this (but they could help me with other issues) so I'm trying now here. After installing and setting up a proper SSL connection with Windows in PHPMyAdmin (MariaDB) I still having this error: Authentication to host '127.0.0.1' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'localhost' (using password: YES) [ERROR] MySQL Connection Failed. Cannot Connect to Server. This is my database info from XAMPP This is the connection string and parameters from the project: MySQL.cs public bool Initialize(bool bIsStartup = true) { // TODO_GITHUB: You need to set the below environment variables / variables to your GAME database connection info string[] gameSettings = new string[] { SettingHelpers.GetDevEnvironmentSetting("GAME_DATABASE_IP") ?? "127.0.0.1", SettingHelpers.GetDevEnvironmentSetting("GAME_DATABASE_NAME") ?? "_gtav", SettingHelpers.GetDevEnvironmentSetting("GAME_DATABASE_USERNAME") ?? "root", SettingHelpers.GetDevEnvironmentSetting("GAME_DATABASE_PASSWORD") ?? "admin", SettingHelpers.GetDevEnvironmentSetting("GAME_DATABASE_PORT") ?? "3306" }; // TODO_GITHUB: You need to set the below environment variables / variables to your AUTH database connection info string[] authSettings = new string[] { SettingHelpers.GetDevEnvironmentSetting("AUTH_DATABASE_IP") ?? "127.0.0.1", SettingHelpers.GetDevEnvironmentSetting("AUTH_DATABASE_NAME") ?? "core", SettingHelpers.GetDevEnvironmentSetting("AUTH_DATABASE_USERNAME") ?? "root", SettingHelpers.GetDevEnvironmentSetting("AUTH_DATABASE_PASSWORD") ?? "admin", SettingHelpers.GetDevEnvironmentSetting("AUTH_DATABASE_PORT") ?? "3306" }; try { Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); m_Connection_Game = new MySqlConnection(Helpers.FormatString( "Server={0}; database={1}; UID={2}; password={3}; port={4}; ConnectionTimeout=10;", gameSettings)); m_Connection_Game.Open(); m_Connection_Auth = new MySqlConnection(Helpers.FormatString( "Server={0}; database={1}; UID={2}; password={3}; port={4}; ConnectionTimeout=10;", authSettings)); m_Connection_Auth.Open(); PrintLogger.LogMessage(ELogSeverity.HIGH, "MySQL Initialized"); return true; } catch (MySqlException ex) { switch (ex.Number) { // These are partially useless since MySQL tends to not throw these properly half the time case 0: PrintLogger.LogMessage(ELogSeverity.ERROR, "MySQL Connection Failed. Cannot Connect to Server."); break; case 1: PrintLogger.LogMessage(ELogSeverity.ERROR, "MySQL Connection Failed. Invalid username/password."); break; case 1042: PrintLogger.LogMessage(ELogSeverity.ERROR, "MySQL Connection Failed. Connection Timed Out."); break; ThreadedMySQL.cs public ThreadedMySQLConnection(int ID, string strIP, string strDatabaseName, string strUsername, string strPassword, string strPort) { m_ID = ID; m_strDatabaseName = strDatabaseName; m_connection = new MySqlConnection(Helpers.FormatString( "Server={0}; database={1}; UID={2}; password={3}; port={4}; ConnectionTimeout=10; Pooling=False;", strIP, strDatabaseName, strUsername, strPassword, strPort)); Connect(); // spawn thread #if !USE_SINGLE_THREADED_MYSQL m_Thread = new Thread(ThreadedTick); m_Thread.Name = Helpers.FormatString("[{1}] Threaded SQL Thread {0}", m_ID, strDatabaseName); m_Thread.Start(); #endif m_connection.StateChange += OnConnectionStateChange; } private static ThreadedMySQLConnectionPool m_ConnectionPool_Game = new ThreadedMySQLConnectionPool( #if USE_SINGLE_THREADED_MYSQL 1, #elif DEBUG Math.Min(4, Environment.ProcessorCount - 1), #else Environment.ProcessorCount - 1, // spawn hyperthreaded cores - 1 so we dont swamp / run on main thread (well only on the virtual core) #endif // TODO_GITHUB: You need to set the below environment variables / variables to your GAME database connection info SettingHelpers.GetDevEnvironmentSetting("GAME_DATABASE_IP") ?? "127.0.0.1", SettingHelpers.GetDevEnvironmentSetting("GAME_DATABASE_NAME") ?? "_gtav", SettingHelpers.GetDevEnvironmentSetting("GAME_DATABASE_USERNAME") ?? "root", SettingHelpers.GetDevEnvironmentSetting("GAME_DATABASE_PASSWORD") ?? "admin", SettingHelpers.GetDevEnvironmentSetting("GAME_DATABASE_PORT") ?? "3306" ); // Auth DB private static ThreadedMySQLConnectionPool m_ConnectionPool_Auth = new ThreadedMySQLConnectionPool( #if USE_SINGLE_THREADED_MYSQL 1, #elif DEBUG Math.Min(4, Environment.ProcessorCount - 1), #else Environment.ProcessorCount - 1, // spawn hyperthreaded cores - 1 so we dont swamp / run on main thread (well only on the virtual core) #endif // TODO_GITHUB: You need to set the below environment variables / variables to your AUTH database connection info SettingHelpers.GetDevEnvironmentSetting("AUTH_DATABASE_IP") ?? "127.0.0.1", SettingHelpers.GetDevEnvironmentSetting("AUTH_DATABASE_NAME") ?? "core", SettingHelpers.GetDevEnvironmentSetting("AUTH_DATABASE_USERNAME") ?? "root", SettingHelpers.GetDevEnvironmentSetting("AUTH_DATABASE_PASSWORD") ?? "admin", SettingHelpers.GetDevEnvironmentSetting("AUTH_DATABASE_PORT") ?? "3306" ); SerialDefinitionsServers (for the GetDevEnvironmentSetting, there is no "dev_settings.json" in the project so the file never exists and they should took the ??-right-side values, I wanna think) public static class SettingHelpers { public static string GetDevEnvironmentSetting(string strKey) { if (System.IO.File.Exists("dev_settings.json")) { Dictionary<string, string> dictSettings = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<string, string>>(System.IO.File.ReadAllText("dev_settings.json")); if (dictSettings.TryGetValue(strKey, out string strValue)) { return strValue; } else { return "null"; } } else { return Environment.GetEnvironmentVariable(strKey); } } } Even I tried to hardcore the parameters and the connection string and I still having the same error. At this point, I don't know what else do, I double check credentials, hardcode the connection string and their parameters, change the credentials, using several databases (MySQL or MariaDB withouth PHPMyAdmin) and I still don't being able to make a proper connection to the server.
  2. Hello, i want connect my db with my server but that error shows in console. How i can solve it? https://i.imgur.com/g9OiaFF.png https://i.imgur.com/keAgOVK.png
  3. How to create a database and save a player's coordinates in it Hello. As a beginner I had lots of trouble finding a MySQL appropriate tutorial for beginners in development. I spent days learning how to create a basic table and save records in it. I decided to create this tutorial so that no one has to go throught what I went. This tutorial is divided in X parts. Feel free to jump ahead if you already to know how to do some. Index Downloading MySQL and MySQL Workbench Installing MySQL Driver Creating a database Connecting to the database and creating a table in it Manipulating the table 1- Installing MySQL and MySQL Workbench For you to be able to save databases and work with them you must first install MySQL and MySQL Workbench. Firstly, go to https://www.mysql.com/downloads/. Now, follow the steps on this video: https://www.youtube.com/watch?v=GIRcpjg-3Eg. I won't do a tutorial on how to install MySQL as it is to complex and very standart to everyone. 2- Installing MySQL Driver After installing MySQL we can access it by using Node.js. This tutorial will use the "mysql" module, downloaded from NPM. To download and install the "mysql" module, open the Command Terminal (go to your search bar and type 'cmd') and execute the following: C:\Users\Your Name>npm install mysql 3- Creating a database If you corretly followed the video above mentioned, you should have something like this once you open your MySQL Workbench: https://imgur.com/wSHrWr0 https://imgur.com/wSHrWr0 You want to press on Local instance MySQL80 or on any other connection you have. Once you do, the following page will open: https://imgur.com/vzSUhvS Right click on the left side box named Schemas and click 'Create Schema': https://imgur.com/rPg6RVi Name it 'rpg' (or whatever you want, just pay attention on the future steps) and click Apply twice and Finish. https://imgur.com/c1CrPwA Nice. Your database has been created. Now, we must connect to it. 4- Connecting to the database and creating a table in it To connect to a database, create a file on your server-files folder named connection.js. Once you create one go to your index.js and add in it the following: require('./connection.js') This will make your server know this file exists and run the code in it. Now, back to connection.js, type the following: var mysql = require('mysql'); With the first line, we are now importing the 'mysql' module to the file. Now, in the same file, type this: const con = mysql.createConnection({ host:'127.0.0.1', // host of server user:'user', // MySQL user password:'password', // MySQL password database: "rpg" }); With this code we are connecting to the database you host. Make sure to replace the user, the password and the database with whatever you had chosen in the previous steps. After connecting to the database, we can now manipulate it. Firstly, we'll create a table. The table can be created on MySQL Workbench or on the javascript file. If you create it on the file, it will try to create it everytime you open your ragemp-server, but it will return an innofensive error if it already exists. I'll create in on the file. Type the following: var sql = "CREATE TABLE players (id int NOT NULL AUTO_INCREMENT PRIMARY KEY, scID int NOT NULL UNIQUE, posX int NOT NULL, posY int NOT NULL, posZ int NOT NULL)"; con.query(sql, function (err, result) { if (err) { console.log('The following error happened while creating [players]: ' + err); throw err; } console.log("[players] has been created"); }); With the code above we've just created a table called 'players' which has 5 columns: 'id', 'scID', 'posX', 'posY', 'posZ'. As you can see, all of them are integers, which means they only accept numbers. If you try to add 'banana' to 'posX', you'll get an error. Also, all of them are NOT NULL, which means that there must be a value in them, they can't be empty, or you'll also get an error. 'scID' is unique, which means that the same data can't be repeated twice. Finally, 'ID' is a Primary Key, which is a mix between NOT NULL and UNIQUE. It uniquely identifies each record in a table. It is also AUTO_INCREMENT, which means a new number will be automatically generated when a new record is inserted into a table. After typing it, open your console. You received the following log: "[players] has been created". It obviously confirms that the table has been created. If you close your console and open it again, you'll instead receive this log: "The following error happened while creating [players]: Error: ER_TABLE_EXISTS_ERROR: Table 'players' already exists". That means that the table couldn't be created because it already exists. There's nothing wrong with the error. You can change it so the server doesn't try to create a table if it already exists, but I'll just leave it be. Now that our table is created, we want to manipulate it, but first make sure you add the module below to the bottom of connection.js: exports.con = con This will make it so that the const 'con' can be used in any file that imports it, which will be necessary for the next step. 5- Manipulating the table Now that we've created the table, we wan't to manipulate it according to our needs. You can do this on the same file, but we'll create another one. On the server-files folder, create a file named database.js (or whatever you want). Once again, make sure to add the require module to index.js: require('./database.js') Now, back to database.js, add the following: const con = require('./connection').con; This will import the 'con' const from connection.js, so that we can use it on this file. Now, we want to add a player's Rockstar Games Social Services ID to our table once he joins for the first time. To do it, write the code above: mp.events.add('playerJoin', (player) => { const socialID = player.rgscId; console.log(`[SERVER]: ${player.name} [SCID: ${player.rgscId}, ID: ${player.id}] entrou no servidor.`); con.query('INSERT INTO players (scID, posX, posY, posZ) VALUES ('+socialID+', 174, -919, 30.687)', function (err, result) { if (err) { console.log('The following error happened while inserting a new record to [players]: ' + err) throw err; } else { console.log(`New player: ${player.name}`); }; player.spawn(new mp.Vector3(174, -919, 30.687)); }); }); With this code, once a player join's we'll get is Social ID, send a log to the console informing us about his connection, insert his Social ID into our database (so that we can identify him later) and spawning him on X: 174, Y: -919, Z: 30.687. Now, as we made it so that the scID (Social ID) was UNIQUE, if a player is already in the database we can't add him again, and if we try to it will return an error. So, if you connect to your server for the first time, you'll get the log: "New player: [Your Name]". If you connect again, you'll get the log: 'The following error happened while inserting a new record to [players]: Error: ER_DUP_ENTRY: Duplicate entry '12345678' for key 'players.scID'. This means it detected that the scID you tried to insert already existed and, because the column is unique, we can't insert a similar one. Now, we can use this error to our advantage, as we don't need to check if a value already exists, because the error already tells us if it does or not. So, replace the code above with the one below: mp.events.add('playerJoin', (player) => { const socialID = player.rgscId; console.log(`[SERVER]: ${player.name} [SCID: ${player.rgscId}, ID: ${player.id}] entrou no servidor.`); con.query('INSERT INTO players (scID, posX, posY, posZ) VALUES ('+socialID+', 174, -919, 30.687)', function (err, result) { if (err) { switch(err.code) { case "ER_DUP_ENTRY": console.log("The following error happened while inserting a new record to [players]: " + err); con.query('SELECT posX, posY, posZ FROM players WHERE scID = '+socialID+'', function (err, result) { if (err) { console.log('The following error happened while selecting scID from [players]: ' + err); throw err; } else { player.spawn(new mp.Vector3(result[0].posX, result[0].posY, result[0].posZ)); } }); break; default: console.log('The following error happened while inserting a new record to [players]: ' + err) throw err; } } else { console.log(`Novo jogador: ${player.name}`); }; player.spawn(new mp.Vector3(174, -919, 30.687)); }); }); With this code, if there's an rror we'll check if the error is "ER_DUP_ENTRY" (if the value is duplicated). If it is, we will stop trying to insert it and actually use the coordinates assigned to a Social ID to spawn the player with that Social ID on those coordinates. We select 'posX', 'posY' and 'posZ' from the row where the 'scID' value is equal to the Social ID of the player that joined the server and spawn that player in those positions. If there's an error while selecting the values, we'll make sure that it is logged. Also, as we don't know for sure that the only error that we will face is "ER_DUP_ENTRY", we make sure to add a switch statement. If the error is the mention, we'll try to spawn the player and if it isn't we'll log it. Now, we made it so that a player spawns in the coordinates associated to him, but we need to actually made those coordinates change whenever he leaves. For this, add this code to the same file: mp.events.add('playerQuit', (player, exitType, reason) => { const socialID = player.rgscId; pos = player.position console.log(`[SERVER]: ${player.name} [SCID: ${player.rgscId}, ID: ${player.id}] left the server.`); con.query('UPDATE players SET posX = '+pos.x+', posY = '+pos.y+', posZ = '+pos.z+' WHERE scID = '+socialID+'', function (err, result) { if (err) { console.log(err); throw err; } else { console.log("Coordinates added") } }); }); This code means that once a player quits the server, we'll log the console of his disconnect and update the 'players' table with the coordinates where he left the server. We search for the row where his Social ID equals 'scID' and change his coordinates to the ones we obtained with the 'pos' var. If we do it successfuly, we'll log to the console: "Coordinates added". If there's an error, we'll log it. This is it. Thank you very much. If you know of anyway I can make my code better, let me know.
  4. Hello! I tried to connect to the DB, but the server threw an error. CS0012: The type 'DbConnection' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. -> MySQL/MySQL.cs:37 When i add a reference I get it: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Option not supported. Parameter name: db at MySql.Data.MySqlClient.MySqlBaseConnectionStringBuilder.GetOption(String key) at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.set_Item(String keyword, Object value) at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value) at MySql.Data.MySqlClient.MySqlBaseConnectionStringBuilder..ctor(String connStr, Boolean isXProtocol) at MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString(String value) at MySQL.MySQL.StartConnection() in MySQL/MySQL.cs:line 35 at VesRP.Setts() in VesRP.cs:line 11 --- 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) MySQL connection code: String SQLConnection = $"SERVER={sql.Host};PASSWORD={sql.Pass};UID={sql.User};DATABASE={sql.DB};"; conn = new MySqlConnection(SQLConnection); try { conn.Open(); NAPI.Util.ConsoleOutput("Connected!"); } catch(Exception ex) { NAPI.Util.ConsoleOutput("Error:"+ex.ToString()); }
  5. Hallo, ich will meine datenbank mit meinem localhost rage server verbinden bekomme aber immer ein fehlercode kann mir da jemand helfen ich habe auch die anleitung im wiki befolgt aber es funktioniert einfach nichts bin am verzweifeln bitte um hilfe wäre coll wen jeamnd mir den fertigen mysql connection code schiken könnte
  6. When creating the script, I tried to connect MySql or Postgres. I installed them through Nuget in Visual Studio, but after starting the server I got an error saying that there are no libraries, after which I registered the path to them in META, but not all the errors went away, and after several starts, server started to require net standart 2.0.0.0, how to use third-party libraries HELP.
  7. Is mongodb good for main server database?
  8. hey guys, i'm new to ragemp and javascript. i use node. how is it possible to use my mysql connection from other files? Like database.js my code where i want the connection of database: "use strict" const datab = require('../Database'); const List = []; connection.query("SELECT * FROM `table`", function(error, result) { if(error) { throw error; } else { console.log('Result is '+result[0].uName); } }); i want to load my whole table to the List
×
×
  • Create New...