mariadb connect file: Difference between revisions

From Onset Developer Wiki
No edit summary
No edit summary
 
Line 18: Line 18:
password = 1234
password = 1234
database = mydb
database = mydb
ssl_enable = false
ssl_key_file =
ssl_cert_file =
ssl_ca_file =
ssl_ca_path =
ssl_cipher =
</pre>
</pre>
<syntaxhighlight lang="Lua">
<syntaxhighlight lang="Lua">

Latest revision as of 09:30, 2 September 2020

mariadb connect file

Type: Function
Context: Server
Introduced: v1.0

NOTICE

This function is provided by the official MariaDB plugin.

Description

Connect using configuration from a file.

Syntax

mariadb_connect_file(file_name)

Parameters

  • file_name
    The file name with the mariaDB credentials.

Return Value

  • Returns an identifier/ handle to the new database connection. false on error.

Example

sql_config.txt:

hostname = 127.0.0.1:3306
username = myuser
password = 1234
database = mydb
ssl_enable = false
ssl_key_file = 
ssl_cert_file = 
ssl_ca_file = 
ssl_ca_path = 
ssl_cipher = 
AddEvent("OnPackageStart", function()
	mariadb_log("debug")

	sql = mariadb_connect_file("horizon/sql_config.txt")

	if (sql ~= false) then
		print("MariaDB: Connected.")
	else
		print("MariaDB: Connection failed. See mariadb_log file")

		-- Immediately stop the server if we cannot connect
		ServerExit()
	end
end)

See also