To connect your Openfire server with external database management systems like MariaDB, you first need to know how to obtain data from these databases. In this case, we will be focusing specifically on retrieving information about the MariaDB data directory using a SQL prompt.

### Step 1: Accessing MySQL/MariaDB via SQL Prompt

To access your MariaDB instance through an SQL client like mysql or similar tools such as sqlplus (for Oracle's database management systems), you can use any text editor that supports command-line input/output operations.

For example, if your MariaDB server is running on the local machine and listening on port 3306 with a user name 'your_username' having privileges to execute SHOW statements:

1. Open a terminal or Command Prompt window.

2. Type in `mysql -u username -p password -D database_name`

3. Replace `'username'` and `'password'` with your actual MariaDB login credentials, as well as replace `'database_name'` with the name of the schema you want to connect to.

### Step 4: Executing SHOW Command

Once connected via an SQL prompt or client, use a simple `SHOW ENGINE INNODB PLUGIN;` (or equivalent for other storage engines) command followed by ENTER. This will display information about all available plugins and their versions installed on your MariaDB server.

Here is what you might see when running this query:

```sql

+-----------------------+

| Engine | Version |

+---------+------------+

| Innodb | 1.0.17-14 |

```

From the output above, note down the path to the data directory under `Data_home` or wherever your MariaDB instance has been installed.

### Step 5: Finding Your Data Directory

If you still cannot find it from step 4, try running:

```sql

SHOW TABLESPACE INNODB STATUS;

```

This will display additional details about each tablespace (or 'log group' in some terms) created by MariaDB during startup. Look for something like `Data_home` or similar under the 'Log' section of your output.

### Step 6: Changing Data Directory After Setup

If you want to change where MySQL/MariaDB stores its data after initial setup, use these commands:

1. Stop all running instances using system commands (like `service mysqld stop`, or equivalent for Windows).

2. Copy the entire contents of your current datadir location (`sudo cp -r /var/lib/mysql/* /new_datadir/`), then move this new directory to wherever you want MySQL/MariaDB to store its data instead.

3. Edit my.cnf (or my.ini on *nix systems) and change `datadir=absolute_path_to_new_location`.

4. Restart your MariaDB service with the following command:

```bash

sudo /usr/local/mysql/bin/mysqld_safe &

```

Make sure to adjust paths according to where MySQL was installed on your system.

Now you should be able to access and manage data stored in MariaDB using tools like SQL Prompt or other clients available for various platforms. Remember that changing the datadir location requires careful planning, especially if there are existing databases already set up within it!

Get mariadb data dir from sql prompt