CABA Filemaker Server Settings

Filemaker Server

caba.mmm.com

10.126.78.10

(old CABA Server ) 10.105.79.44

Admin Console

http://127.0.0.1:16001/admin-console/

username:administrator

password: ouch53#Aruba

mySQL Settings

mySQL ODBC Source

(Production) -Rackspace

Data Source Name FPG2014

23.253.234.103.

Port 3306

User: fms

Password: padawan5482

Database: fallprogroup_com_20140715

Ad Auth/Azure Settings

Application ID

3c3a2f2d-7c0b-484f-8a84-5c16498d5939

Azure Key:

0HHMKdWiflgktY+DPOm+@TFHUPCo_243

Directory id

facac3c4-e2a5-4257-af76-205c8a821ddb

Object ID

0944d51f-da59-40b0-b143-c63624c257b6

Updating the "secret"

Every Two years the CABA service principle secret needs to be renewed for CABA.

This is done via the Azure control panel

Note: this was last performed on Sept 23 2021

Here's the directions form Claris on setting everything up:

https://support.claris.com/s/article/Accessing-solutions-using-Open-Authentication-OAuth-credentials-1503693096853?language=en_US

-Snippit

Configure OAuth in FileMaker Server

After registering the app, enable OAuth in FileMaker Server and enter the required information from your OAuth app. FileMaker Server 16 (or higher) is required.

  1. Go to Admin Console > Administration > External Administration
  2. Click Change for your OAuth service: Amazon, Google or Microsoft
  3. Enter the required the information from your OAuth app:
  1. Amazon : Client ID , Client Secret
  2. Google : Client ID , Client Secret
  3. Microsoft : Application ID (Client ID) ,  Key Value  (Client Secret), and Directory ID  (Tenant ID)
  1. Restart FileMaker Server

Stopping the Filemaker Server

Close the Database Files

IMPORTANT: There should be no clients connected when doing this

Stop the Database Server

Starting the Filemaker Server

Start the Database Server

Open/Connect to the  the admin interface then click Start Database Server ( you should only see this if you have Stopped the Database server. )The Database Server will auto start after a Server reboot.

 

Open the Databases

Dev/Staging Servers

CAAIAPPR01 (Dev)

169.6.88.134

255.255.255.192 (subnet)

169.6.88.129 (gateway)

169.6.40.85 (DNS)

169.6.33.134 (DNS)

 

CAAIAPPR03 (Staging)

169.6.88.144

255.255.255.192 (subnet)

169.6.88.129 (gateway)

169.6.40.85 (DNS)

169.6.33.134 (DNS)

 

DEV MySQL server at Rackspace 67.23.25.112