Database Setup

[open_mailbox]

Hey, I'm back again with a new video that hopefully helps folks get their database connection initialized. Enjoy.

[ZepTepProd]

Hey buddy, you don't show in your video where and how to get the mariadb dll! Can you send me it or show me how to create it please i'm lost

[open_mailbox]

Hey buddy, you don't show in your video where and how to get the mariadb dll! Can you send me it or show me how to create it please i'm lost

The mariadb client libs are in your server installation by default. Check the plugins directory. You don't need to do anything other than make sure "mariadb" is in your server_config.json under the plugins section. If you're talking about installing the actual MariaDB database itself, then yeah that's beyond the scope of this video beyond the brief look I gave at the website near the beginning. If that's what you're looking for: https://mariadb.org/

[KeyTur]

Hello I have error : bad argument #2 to 'mariadb_async_query' (expected string-like argument)

[LUA]function cmd_heure(player)
local query = mariadb_prepare(SQL, "SELECT CURRENT_TIMESTAMP()")
mariadb_async_query(SQL, query , cb_gettimestamp, player)
end
AddCommand("heure", cmd_heure)
function cb_gettimestamp()
local timestamp = mariadb_get_value_index(1, 1)
AddPlayerChat(player, "Il est : " .. timestamp)
end[/LUA]

[Talos]

Hello I have error : bad argument #2 to 'mariadb_async_query' (expected string-like argument)

[LUA]function cmd_heure(player)
local query = mariadb_prepare(SQL, "SELECT CURRENT_TIMESTAMP()")
mariadb_async_query(SQL, query , cb_gettimestamp, player)
end
AddCommand("heure", cmd_heure)
function cb_gettimestamp()
local timestamp = mariadb_get_value_index(1, 1)
AddPlayerChat(player, "Il est : " .. timestamp)
end[/LUA]

Looks like mariadb_prepare returned a false boolean. Check the mariadb_log, maybe your connection isn't setup properly.

[KeyTur]

CONSOLE : [2020-07-31 19:06:04] [script] Base de donné connecter a : localhost

SCRIPT :
if (SQL ~= nil) then
print("Base de donné connecter a : " .. sql_host)

Yet in the console it gives me no worries

[KeyTur]

Looks like mariadb_prepare returned a false boolean. Check the mariadb_log, maybe your connection isn't setup properly.

[2020-07-31 11:37:43.671] [mariadb] [error] Connection::Connection - establishing connection to MariaDB database failed: #1045
Yes Thanks