Database Settings - Revision history

Manni: /* mySQL Linux Bash remote control */

2022-06-17T12:11:43Z

‎mySQL Linux Bash remote control

2022-06-17T11:56:26Z

‎mySQL Linux Bash remote control

2022-06-17T11:40:48Z

2022-06-17T10:27:10Z

‎MySQL

2022-06-17T10:18:49Z

‎MySQL

2022-06-17T10:12:27Z

‎Configuring OpenSimulator

2022-06-17T10:11:16Z

‎Using different database settings for different services

2022-06-17T10:09:28Z

‎MySQL

2022-06-17T10:08:36Z

‎MySQL

2014-11-28T00:46:27Z

‎MSSQL

@@ Line 350: / Line 350: @@
 mysqlrest "$username" "$password" "$databasename" "SHOW TABLES FROM $databasename"
 echo "$result_mysqlrest"
 </pre>

@@ Line 351: / Line 351: @@
 echo "$result_mysqlrest"
 </pre>
 [[Category:Database]]

← Older revision		Revision as of 11:40, 17 June 2022
Line 331:		Line 331:
	max_allowed_packet=2147483648		max_allowed_packet=2147483648

		+	= mySQL Linux Bash remote control =

		+	<pre>
		+	#!/bin/bash
		+
		+	### Function to query mySQL records: mysqlrest "username" "password" "databasename" "mysqlcommands"
		+	### Return values are in the $result_mysqlrest variable
		+	function mysqlrest()
		+	{
		+	username=$1; password=$2; databasename=$3; mysqlcommand=$4;
		+	result_mysqlrest=$(echo "$mysqlcommand;" \| MYSQL_PWD=$password mysql -u"$username" "$databasename" -N) 2> /dev/null
		+	}
		+
		+	# Example query:
		+	username="opensim"; password="123456"; databasename="Grid";
		+
		+	echo "PRINT ALL DATABASE TABLES: "
		+	mysqlrest "$username" "$password" "$databasename" "SHOW TABLES FROM $databasename"
		+	echo "$result_mysqlrest"
		+	</pre>

	[[Category:Database]]		[[Category:Database]]

@@ Line 321: / Line 321: @@
   max_allowed_packet  = 16M
 Packet Too Large: mysqldump in /etc/mysql/conf.d
@@ Line 328: / Line 331: @@
   max_allowed_packet=2147483648
-On Ubuntu 14.04.1 with MySQL latest, this setting was already found to be 16M.
 [[Category:Database]]

@@ Line 320: / Line 320: @@
   max_allowed_packet  = 16M
 On Ubuntu 14.04.1 with MySQL latest, this setting was already found to be 16M.
 [[Category:Database]]

@@ Line 258: / Line 258: @@
 ; MySql
 StorageProvider = "OpenSim.Data.MySQL.dll"
-ConnectionString = "Data Source=localhost;Database=opensim;User ID=opensimuser;Password=opensimpassword;Old Guids=true;"
+ConnectionString = "Data Source=localhost;Database=opensim;User ID=opensimuser;Password=opensimpassword;Old Guids=true;SslMode=None;"
 </pre>
 Note that "Data Source=localhost;" actually specifies a TCP socket. If your MySQL server is set up to refuse remote connections (i.e. with skip-networking enabled) you'll need to replace "localhost" with the path to MySQL's UNIX socket.

@@ Line 160: / Line 160: @@
 [DatabaseService]
 StorageProvider = "OpenSim.Data.MySQL.dll"
-ConnectionString = "Data Source=localhost;Database=opensim;User ID=opensim;Password=***;Old Guids=true;"
+ConnectionString = "Data Source=localhost;Database=opensim;User ID=opensim;Password=***;Old Guids=true;SslMode=None;"
 ...
 [InventoryService]
-ConnectionString = "Data Source=localhost;Database=opensim2;User ID=opensim;Password=***;Old Guids=true;"
+ConnectionString = "Data Source=localhost;Database=opensim2;User ID=opensim;Password=***;Old Guids=true;SslMode=None;"
 ...
 [AuthenticationService]

@@ Line 19: / Line 19: @@
 <pre>
 StorageProvider = "OpenSim.Data.MySQL.dll"
-ConnectionString = "Data Source=localhost;Database=opensimdb;User ID=opensim;Password=h0tgrits;Old Guids=true;"
+ConnectionString = "Data Source=localhost;Database=opensimdb;User ID=opensim;Password=h0tgrits;Old Guids=true;SslMode=None;"
 </pre>

← Older revision		Revision as of 00:46, 28 November 2014
Line 49:		Line 49:

	===MSSQL===		===MSSQL===
		+
		+	'''NOTE: MSSQL support will be removed in OpenSimulator 0.8.1 as it has been unmaintained for more than 2 years and so has bugs and lacks support for recent OpenSimulator features.'''

	'''NOTE: There had been another way to connect to MSSQL database, which was using "mssql_connection.ini" in bin/ directory. On OpenSimulator 0.7.1 or later, it will NOT be read even if you set it properly. Use ConnectionString in *Common.ini instead. For more specific details, see the section [[#MSSQL]].'''		'''NOTE: There had been another way to connect to MSSQL database, which was using "mssql_connection.ini" in bin/ directory. On OpenSimulator 0.7.1 or later, it will NOT be read even if you set it properly. Use ConnectionString in *Common.ini instead. For more specific details, see the section [[#MSSQL]].'''