Archived - Final Cut Server: Connecting the database to the correct local user account
Final Cut Server uses configuration data which refers to the administrative user that installed the software. This configuration data contains the User ID (UID) which is different than the username of the administrative user. There may be situations where the Final Cut Server configuration data does not match any existing UIDs of local administrative users, such as:
- You delete the administrative user that installed Final Cut Server.
- You restore the Final Cut Server database onto a system with different administrative users that do not have the appropriate UID.
For proper functionality, make sure that the UID in the Final Cut Server configuration data matches the appropriate administrative user's UID.
Determining which User ID is in the current Final Cut Server configuration data
Type the following command in Terminal on the Final Cut Server system:
defaults read /Library/Preferences/com.apple.finalcutserver.settings "USER_ID"
The UID will appear on the next line in Terminal.
IMPORTANT: This user should have Read & Write access to your devices.
Updating Final Cut Server configuration data with the appropriate User ID
- To determine the UID of a local user account, choose System Preferences from the Apple () menu. From the View menu choose Accounts. Control-click the entry for the user account and choose Advanced Options.
- Open System Preferences on the Final Cut Server system. From the View menu choose Final Cut Server. In Final Cut Server preferences, click the General pane then click Stop to stop Final Cut Server.
- Type the following command in Terminal on the Final Cut Server system:
- Open System Preferences on the Final Cut Server system. From the View menu choose Final Cut Server. In Final Cut Server preferences, click the General pane then click Start to start Final Cut Server.
defaults write /Library/Preferences/com.apple.FinalCutServer.settings "USER_ID" -int 501
Note: The UID "501" in this example is the account the Final Cut Server database needs to be associated with.
Additional Steps for Final Cut Server 1.5.1
Use the template below to create a configuration file to map the correct local admin user to PostgreSQL users, ensuring that the syntax and case are preserved. Replace the "<user>" listings with the short name of the local admin user to which you wish to connect your database.
-----COPY BELOW THIS LINE-----
# PostgreSQL Ident Authentication Maps
# Refer to the PostgreSQL Administrator's Guide, chapter "Client
# Authentication" for a complete description. A short synopsis
# This file controls PostgreSQL ident-based authentication. It maps
# ident user names (typically Unix user names) to their corresponding
# PostgreSQL user names. Records are of the form:
# MAPNAME IDENT-USERNAME PG-USERNAME
# (The uppercase quantities must be replaced by actual values.)
# MAPNAME is the (otherwise freely chosen) map name that was used in
# pg_hba.conf. IDENT-USERNAME is the detected user name of the
# client. PG-USERNAME is the requested PostgreSQL user name. The
# existence of a record specifies that IDENT-USERNAME may connect as
# PG-USERNAME. Multiple maps may be specified in this file and used
# by pg_hba.conf.
# This file is read on server startup and when the postmaster receives
# a SIGHUP signal. If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect. You can use
# "pg_ctl reload" to do that.
# Put your actual configuration here
# No map names are defined in the default configuration. If all ident
# user names and PostgreSQL user names are the same, you don't need
# this file. Instead, use the special map name "sameuser" in
# MAPNAME IDENT-USERNAME PG-USERNAME
fcsvr root postgres
fcsvr <user> postgres
fcsvr root pxdb
fcsvr <user> pxdb
-----COPY ABOVE THIS LINE-----
Paste the template above into a Plain Text document and name the file "pg_ident.conf".
Save the file to the Desktop of your Server and follow these steps to properly place the file:
IMPORTANT: It is recommended that you make a backup of your database using Final Cut Server System Preferences before following these steps:
1. Open Final Cut Server System Preferences click Stop to stop Final Cut Server.
2. In the Applications folder open the Utilities folder and launch Terminal.
3. Run the following command at the prompt:
sudo cp ~/Desktop/pg_ident.conf /var/db/FinalCutServer/data/pg_ident.conf
4. Open Final Cut Server System Preferences and click Start to start Final Cut Server.
Important: Final Cut Server can only access custom Final Cut Server transcode settings in the Home directory it is connected to currently. Since these settings are initially created in Compressor, they are stored in ~/Library/Application Support/Compressor.