tutorials:mairlistdb:sql-client-setup
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
tutorials:mairlistdb:sql-client-setup [2017/09/19 06:37] – created tw | tutorials:mairlistdb:sql-client-setup [2019/07/09 16:18] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== mAirListDB SQL Connection Setup ====== | + | ====== mAirListDB |
- | This article explains | + | This tutorial shows how to set up the connection |
- | We assume that the server part has already been done, so a user account and and empty database | + | This article only covers |
- | * [[tutorials: | + | ===== Server |
- | * [[tutorials: | + | |
- | * [[tutorials: | + | |
- | In this tutorial we use PostgreSQL | + | You must prepare your SQL server for use with mAirListDB first. In particular we will need: |
+ | |||
+ | * An empty database (no tables created yet!) | ||
+ | * A user + password to access that database, with sufficient credentials (often the owner of the database) | ||
+ | |||
+ | Setup instructions are very similar for each SQL server type, but we have separate tutorials available for that: | ||
+ | |||
+ | * [[tutorials: | ||
+ | * [[tutorials: | ||
+ | * [[tutorials: | ||
+ | |||
+ | Please set up the server first according to your particular SQL flavor, then return to this article to see instructions for the client setup. | ||
+ | ===== First Client Computer (Initial Setup) ===== | ||
+ | |||
+ | In this step, we will set up the connection from the first mAirList computer in your network, and also initialize the database, that is, create the necessary tables etc. | ||
+ | |||
+ | We assume that you have installed and activated mAirList on your computer. Please open the configuration app from the Windows Start Menu. | ||
+ | |||
+ | ==== Connection Setup ==== | ||
+ | |||
+ | In the config app, go to // | ||
+ | |||
+ | On the //General// tab, enter the host name or IP of the SQL server, the database name (// | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Click //Test login// to check if the SQL connection works before you continue. You will most likely see an error saying that the SQL connection was successful | ||
+ | |||
+ | ==== Initial Table Setup ==== | ||
+ | |||
+ | Now switch to the //Setup// tab to create the tables (" | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | The initial | ||
+ | |||
+ | Now click the //Perform Initial Setup// button and wait. mAirList will now create the SQL tables necessary to hold the mAirListDB library and scheduling data. This might take a few seconds and will eventually be confirmed with the messsage //Setup completed successfully//: | ||
+ | |||
+ | {{ : | ||
- | ===== Initial Setup (First Client Computer) ===== | ||
===== Additional Client Computers ===== | ===== Additional Client Computers ===== | ||
+ | |||
+ | If you want to connect additional mAirList computers to the database, go to the mAirList configuration app on each computer, and add the connection as described above. Now that we have created the tables, the //Test login// button should give the message: //Login OK// | ||
+ | |||
+ | When you click OK to save the connection, you will see the following message: | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Each mAirListDB has a unique identifier (made up of several random hexadecimal characters), | ||
+ | |||
+ | ===== Schema Upgrade ===== | ||
+ | |||
+ | When you install a new version of mAirList, it can happen that the mAirListDB connection stops working, and you see a message similar to the following: | ||
+ | |||
+ | Invalid schema version (found xx, need yy). Please upgrade your database. | ||
+ | | ||
+ | This happens when the new software version to add or modify SQL tables to support new functionality. We must perform a **Schema Upgrade** then. | ||
+ | |||
+ | <WRAP warning round> | ||
+ | **BIG FAT WARNING**: | ||
+ | |||
+ | Once the database schema was upgraded to a new version, it will stop working with older clients (mAirList versions) that require the older schema version. So you must also install the same new software version on **all** mAirList computers. | ||
+ | |||
+ | **It is not possible to downgrade the schema to an older version once it was upgraded.** We strongly recommend that you make a backup of your database before performing the upgrade, in case you must roll back to the old software version for any reason. | ||
+ | </ | ||
+ | |||
+ | To perform the schema upgrade, go to the //Upgrade// tab in the mAirListDB connection properties dialog. **You must do this only once for each database.** | ||
+ | |||
+ | First, click the //Check now// button to find out what your current schema version is, and if it matches the required version. | ||
+ | |||
+ | If an upgrade needs to be performed, click //Upgrade// and wait for the upgrade to complete. | ||
+ | |||
+ | |||
+ | ===== Optional Configuration Tasks ===== | ||
+ | |||
+ | ==== Connection Options ==== | ||
+ | |||
+ | ==== Multi-User Setup and Security Roles ==== | ||
+ | |||
+ | ==== Storage Redirection ==== | ||
+ | |||
+ | ==== Maintenance ==== | ||
tutorials/mairlistdb/sql-client-setup.1505803029.txt.gz · Last modified: 2019/07/09 16:19 (external edit)