mariadb connect file

From Onset Developer Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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

Retrieved from "https://dev.playonset.com/index.php?title=mariadb_connect_file&oldid=4298"