V9 Moving Servers - Mac Firebird SQL

V9 Moving Servers - Mac Firebird SQL

Here is a quick guide on how to move Accessit Library from one Firebird SQL server to another (presumably newer) Firebird SQL MacOS Server.
Prior to the server migration, first update the Access-It Management App to the latest build. You can download the updates through Library Setup -> Software Update Checker. Then create a Backup (Management -> Create a Backup)

Required installers

Firebird

Click here to download the latest Firebird 2.5 installer

Accessit Library

Click here to download the latest Accessit Library installers.

Required steps

Ensure that all users have closed down Accessit Management App and do not the Web App during the migration.

Old Server

  1. Create a backup in the Accessit Managment App and save it to a safe location on your servers local drive.
    Go to Management -> Create a backup
  2. Stop all Accessit Library Services. Click here for more info.
  3. Stop the Firebird service. Click here for more info.
  4. Remove services by removing Accessit and Firebird plist's from /Library/LaunchDaemons folder.
  5. Copy the backup across to the new server

New Server

  1. Install Firebird 2.5 as a service with the provided installer
  2. Install Accessit Library by using MacOS Server Installer
  3. Ensure the Firebird and Accessit services are stopped
    sudo launchctl unload /Library/LaunchDaemons/com.accessitsoftware.bts.plist
    sudo launchctl unload /Library/LaunchDaemons/com.accessitsoftware.tomee.plist
    sudo launchctl unload /Library/LaunchDaemons/org.firebird.gds.plist   

  4. Download the Empty database template (click the link to download) and save it to a safe location.
  5. Rename the file from Brooklyn25_Mac.fdb to Brooklyn.fdb
  6. Move the empty Brooklyn.fdb file and replace it in the data folder. /usr/local/accessit/data
  7. Download new Security2.fdb file
  8. Place into /Library/Frameworks/Firebird.framework/Versions/A/Resources/English.lproj/var over the top of existing one
  9. Confirm Aliiases.conf has following line: "Brooklyn = /usr/local/accessit/Data/Brooklyn.fdb"
  10. Start the Firebird service
    sudo launchctl load /Library/LaunchDaemons/org.firebird.gds.plist 
  11. Start Accessit Management App in Maintenance mode
    creating an empty notepad file in the Applications/Accessit folder and rename it to Config.Block
  12. Restore the backup into the previously downloaded and renamed Empty database template (from step 5) by;

    1. Tools
    2. Restore a backup
    3. Load Current
    4. Ok
    5. Locate the backup file you copied from the old server
  13. Once the update has completed, you can close the maintenance window.
  14. Delete the Config.block if you created one in step 10
  15. Start the Accessit Management App
  16. Start the Accessit BTS and Accessit Web Service services
    sudo launchctl load /Library/LaunchDaemons/com.accessitsoftware.bts.plist
    sudo launchctl load /Library/LaunchDaemons/com.accessitsoftware.tomee.plist
Note: If the IP address of the server has changed, you will have to replace the AIS_cfg.properties files on the clients computers, so it will point to the new IP address of the server.

Web App

From here you may need to change the Web App port and also move across any uploaded files from the old server.
Uploaded files are normally located in: /usr/local/accessit/tomee/files
To change the Web App port and add the new files location, edit the server.xml file as shown below and restart the Accessit Web Service - TomEE:
/usr/local/accessit/tomee/files/server.xml
Web App port

File location


After the server.xml has been updated, you will need to check the following configuration in the Accessit Management App
  1. Go to Library Setup -> Campus Setup -> Web App settings
  2. You need to ensure that the address is correctly defined for your new server. It will need to include the correct port #.
    E.g. http://ourwebserver/ or http://ourwebserver:2000/ if the Web App is listening on port 2000

  3. Next you will need to check the Set Web Upload Root Path.
    Go to Library Setup -> Organization Setup -> Organization info
  4. You may need to update this to be http://ourwebserver/files or http://ourwebserver:2000/files if the Web App is listening on port 2000

If you experience difficulties and require further assistance, please contact our Technical Support (or create a ticket) and we will be happy to assist you.



    • Related Articles

    • Mac OS - Generate Lets Encrypt SSL Certificate

        This is a guide on setting up free SSL certificate for Accessit Web App using Let’s Encrypt on Mac Servers. Generated certificates will also renew automatically.   Requirements:  Accessit Web App must be available from the internet on port 80. ...

    • Windows - Generate Lets Encrypt SSL Certificate

      This is a guide on setting up free SSL certificate for Accessit Web App using Let’s Encrypt on Windows Servers. Generated certificates will also renew automatically.   Requirements:  Accessit Web App must be available from the internet on port 80. ...