mariadb connect - Revision history

BlueMountains at 09:29, 2 September 2020

2020-09-02T09:29:30Z

← Older revision		Revision as of 09:29, 2 September 2020
Line 12:		Line 12:
	{{FuncParam\|db_str \|MariaDB database to use.}}		{{FuncParam\|db_str \|MariaDB database to use.}}
	{{FuncParamOptional\|ssl_key_file\|Private key for SSL connections.}}		{{FuncParamOptional\|ssl_key_file\|Private key for SSL connections.}}
	{{FuncParamOptional\|ssl_cert_file\|~~__EDIT_ME__~~}}		{{FuncParamOptional\|ssl_cert_file\|Certificate file for SSL connections.}}
	{{FuncParamOptional\|ssl_ca_file\|~~__EDIT_ME__~~}}		{{FuncParamOptional\|ssl_ca_file\|Path to the certificate authority file}}
	{{FuncParamOptional\|ssl_ca_path\|~~__EDIT_ME__~~}}		{{FuncParamOptional\|ssl_ca_path\|Path to the directory containing the trusted TLS CA certificates in PEM format. }}
	{{FuncParamOptional\|ssl_cipher\|~~__EDIT_ME__~~}}		{{FuncParamOptional\|ssl_cipher\|List of permitted ciphers to use for TLS encryption.

			TLSv1.0
			TLSv1.1
			TLSv1.2
			TLSv1.3 }}

	{{FuncReturnValue\|Returns an identifier/handle to the new database connection. '''false''' on error.}}		{{FuncReturnValue\|Returns an identifier/handle to the new database connection. '''false''' on error.}}

Guewen at 23:33, 9 December 2019

2019-12-09T23:33:58Z

← Older revision		Revision as of 23:33, 9 December 2019
Line 22:		Line 22:
	<syntaxhighlight lang="Lua">		<syntaxhighlight lang="Lua">
	AddEvent("OnPackageStart", function()		AddEvent("OnPackageStart", function()

			local SQL_HOST = "localhost"
			local SQL_PORT = 3306
			local SQL_USER = "user"
			local SQL_PASS = "password"
			local SQL_DATA = "database"
			local SQL_CHAR = "utf8mb4"
			local SQL_LOGL = "debug"

	mariadb_log(SQL_LOGL)		mariadb_log(SQL_LOGL)

28days at 09:50, 19 November 2019

2019-11-19T09:50:16Z

← Older revision		Revision as of 09:50, 19 November 2019
Line 35:		Line 35:
	ServerExit()		ServerExit()
	end		end
	end		end)
	</syntaxhighlight>		</syntaxhighlight>

	{{RelatedFunctions}}		{{RelatedFunctions}}
	{{Template:MariaDBFunctions}}		{{Template:MariaDBFunctions}}

28days at 09:45, 19 November 2019

2019-11-19T09:45:01Z

← Older revision		Revision as of 09:45, 19 November 2019
Line 39:		Line 39:

	{{RelatedFunctions}}		{{RelatedFunctions}}
	* [[mariadb_disconnect]]		{{Template:MariaDBFunctions}}
	* [[mariadb_connect]]
	* [[mariadb_log]]

28days at 09:43, 19 November 2019

2019-11-19T09:43:59Z

← Older revision		Revision as of 09:43, 19 November 2019
Line 39:		Line 39:

	{{RelatedFunctions}}		{{RelatedFunctions}}
	~~__EDIT_ME__~~		* [[mariadb_disconnect]]
			* [[mariadb_connect]]
			* [[mariadb_log]]

28days at 09:41, 19 November 2019

2019-11-19T09:41:21Z

← Older revision		Revision as of 09:41, 19 November 2019
Line 2:		Line 2:
	{{Notice\|This function is provided by the official [[MariaDB]] plugin.}}		{{Notice\|This function is provided by the official [[MariaDB]] plugin.}}

	{{FuncDescription\|~~__EDIT_ME__~~}}		{{FuncDescription\|Connect to the mariadb database.}}

	{{FuncSyntax\|mariadb_connect(host_str, user_str, passwd_str, db_str [, ssl_key_file, ssl_cert_file, ssl_ca_file, ssl_ca_path, ssl_cipher])}}		{{FuncSyntax\|mariadb_connect(host_str, user_str, passwd_str, db_str [, ssl_key_file, ssl_cert_file, ssl_ca_file, ssl_ca_path, ssl_cipher])}}
Line 20:		Line 20:

	== Example ==		== Example ==
	~~__EDIT_ME__~~		<syntaxhighlight lang="Lua">
			AddEvent("OnPackageStart", function()
			mariadb_log(SQL_LOGL)

			sql = mariadb_connect(SQL_HOST .. ':' .. SQL_PORT, SQL_USER, SQL_PASS, SQL_DATA)

			if (sql ~= false) then
			print("MariaDB: Connected to " .. SQL_HOST)
			mariadb_set_charset(sql, SQL_CHAR)
			else
			print("MariaDB: Connection failed to " .. SQL_HOST .. ", see mariadb_log file")

			-- Immediately stop the server if we cannot connect
			ServerExit()
			end
			end
			</syntaxhighlight>

	{{RelatedFunctions}}		{{RelatedFunctions}}
	__EDIT_ME__		__EDIT_ME__

BlueMountains at 10:49, 19 May 2019

2019-05-19T10:49:33Z

← Older revision		Revision as of 10:49, 19 May 2019
Line 7:		Line 7:

	{{FuncParameters}}		{{FuncParameters}}
	{{FuncParam\|host_str\|~~__EDIT_ME__~~}}		{{FuncParam\|host_str\|The MariaDB server to connect to. This can be an IP address or hostname.}}
	{{FuncParam\|user_str\|~~__EDIT_ME__~~}}		{{FuncParam\|user_str\|The MariaDB user.}}
	{{FuncParam\|passwd_str\|~~__EDIT_ME__~~}}		{{FuncParam\|passwd_str\|The password for the user.}}
	{{FuncParam\|db_str \|~~__EDIT_ME__~~}}		{{FuncParam\|db_str \|MariaDB database to use.}}
	{{~~FuncParam~~\|ssl_key_file\|~~__EDIT_ME__~~}}		{{FuncParamOptional\|ssl_key_file\|Private key for SSL connections.}}
	{{~~FuncParam~~\|ssl_cert_file\|__EDIT_ME__}}		{{FuncParamOptional\|ssl_cert_file\|__EDIT_ME__}}
	{{~~FuncParam~~\|ssl_ca_file\|__EDIT_ME__}}		{{FuncParamOptional\|ssl_ca_file\|__EDIT_ME__}}
	{{~~FuncParam~~\|ssl_ca_path\|__EDIT_ME__}}		{{FuncParamOptional\|ssl_ca_path\|__EDIT_ME__}}
	{{FuncParamOptional\|ssl_cipher\|__EDIT_ME__}}		{{FuncParamOptional\|ssl_cipher\|__EDIT_ME__}}

	{{FuncReturnValue\|~~__EDIT_ME__~~}}		{{FuncReturnValue\|Returns an identifier/handle to the new database connection. '''false''' on error.}}

	== Example ==		== Example ==

BlueMountains: Created page with "{{Info|Function|Server|1.0}} {{Notice|This function is provided by the official MariaDB plugin.}} {{FuncDescription|__EDIT_ME__}} {{FuncSyntax|mariadb_connect(host_str,..."

2019-05-19T10:31:11Z

Created page with "{{Info|Function|Server|1.0}} {{Notice|This function is provided by the official MariaDB plugin.}} {{FuncDescription|__EDIT_ME__}} {{FuncSyntax|mariadb_connect(host_str,..."

New page

{{Info|Function|Server|1.0}}
{{Notice|This function is provided by the official [[MariaDB]] plugin.}}

{{FuncDescription|__EDIT_ME__}}

{{FuncSyntax|mariadb_connect(host_str, user_str, passwd_str, db_str [, ssl_key_file, ssl_cert_file, ssl_ca_file, ssl_ca_path, ssl_cipher])}}

{{FuncParameters}}
{{FuncParam|host_str|__EDIT_ME__}}
{{FuncParam|user_str|__EDIT_ME__}}
{{FuncParam|passwd_str|__EDIT_ME__}}
{{FuncParam|db_str |__EDIT_ME__}}
{{FuncParam|ssl_key_file|__EDIT_ME__}}
{{FuncParam|ssl_cert_file|__EDIT_ME__}}
{{FuncParam|ssl_ca_file|__EDIT_ME__}}
{{FuncParam|ssl_ca_path|__EDIT_ME__}}
{{FuncParamOptional|ssl_cipher|__EDIT_ME__}}

{{FuncReturnValue|__EDIT_ME__}}

== Example ==
__EDIT_ME__

{{RelatedFunctions}}
__EDIT_ME__

← Older revision		Revision as of 09:29, 2 September 2020
Line 12:		Line 12:
	{{FuncParam\|db_str \|MariaDB database to use.}}		{{FuncParam\|db_str \|MariaDB database to use.}}
	{{FuncParamOptional\|ssl_key_file\|Private key for SSL connections.}}		{{FuncParamOptional\|ssl_key_file\|Private key for SSL connections.}}
	{{FuncParamOptional\|ssl_cert_file\|~~__EDIT_ME__~~}}		{{FuncParamOptional\|ssl_cert_file\|Certificate file for SSL connections.}}
	{{FuncParamOptional\|ssl_ca_file\|~~__EDIT_ME__~~}}		{{FuncParamOptional\|ssl_ca_file\|Path to the certificate authority file}}
	{{FuncParamOptional\|ssl_ca_path\|~~__EDIT_ME__~~}}		{{FuncParamOptional\|ssl_ca_path\|Path to the directory containing the trusted TLS CA certificates in PEM format. }}
	{{FuncParamOptional\|ssl_cipher\|~~__EDIT_ME__~~}}		{{FuncParamOptional\|ssl_cipher\|List of permitted ciphers to use for TLS encryption.

			TLSv1.0
			TLSv1.1
			TLSv1.2
			TLSv1.3 }}

	{{FuncReturnValue\|Returns an identifier/handle to the new database connection. '''false''' on error.}}		{{FuncReturnValue\|Returns an identifier/handle to the new database connection. '''false''' on error.}}

← Older revision		Revision as of 10:49, 19 May 2019
Line 7:		Line 7:

	{{FuncParameters}}		{{FuncParameters}}
	{{FuncParam\|host_str\|~~__EDIT_ME__~~}}		{{FuncParam\|host_str\|The MariaDB server to connect to. This can be an IP address or hostname.}}
	{{FuncParam\|user_str\|~~__EDIT_ME__~~}}		{{FuncParam\|user_str\|The MariaDB user.}}
	{{FuncParam\|passwd_str\|~~__EDIT_ME__~~}}		{{FuncParam\|passwd_str\|The password for the user.}}
	{{FuncParam\|db_str \|~~__EDIT_ME__~~}}		{{FuncParam\|db_str \|MariaDB database to use.}}
	{{~~FuncParam~~\|ssl_key_file\|~~__EDIT_ME__~~}}		{{FuncParamOptional\|ssl_key_file\|Private key for SSL connections.}}
	{{~~FuncParam~~\|ssl_cert_file\|__EDIT_ME__}}		{{FuncParamOptional\|ssl_cert_file\|__EDIT_ME__}}
	{{~~FuncParam~~\|ssl_ca_file\|__EDIT_ME__}}		{{FuncParamOptional\|ssl_ca_file\|__EDIT_ME__}}
	{{~~FuncParam~~\|ssl_ca_path\|__EDIT_ME__}}		{{FuncParamOptional\|ssl_ca_path\|__EDIT_ME__}}
	{{FuncParamOptional\|ssl_cipher\|__EDIT_ME__}}		{{FuncParamOptional\|ssl_cipher\|__EDIT_ME__}}

	{{FuncReturnValue\|~~__EDIT_ME__~~}}		{{FuncReturnValue\|Returns an identifier/handle to the new database connection. '''false''' on error.}}

	== Example ==		== Example ==