FileMaker Server 11

FileMaker Server Help

2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker is a trademark of FileMaker, Inc. registered in the U.S. and other countries. The file folder logo is a trademark of FileMaker, Inc. All other trademarks are the property of their respective owners. FileMaker documentation is copyrighted. You are not authorized to make additional copies or distribute this documentation without written permission from FileMaker. You may use this documentation solely with a valid licensed copy of FileMaker software. All persons, companies, email addresses, and URLs listed in the examples are purely fictitious and any resemblance to existing persons, companies, email addresses, or URLs is purely coincidental. Credits are listed in the Acknowledgements documents provided with this software. Mention of third-party products and URLs is for informational purposes only and constitutes neither an endorsement nor a recommendation. FileMaker, Inc. assumes no responsibility with regard to the performance of these products. For more information, visit our website at www.filemaker.com. Edition: 01

Contents

About FileMaker Server. 8 New features in FileMaker Server 11. 9 Deploying FileMaker Server. 11
Which deployment type is right for me?. 12 Testing FileMaker Server. 13 Checking the status of your deployment. 15 Changing a FileMaker Server deployment. 17
Starting Admin Console. 18 Hosting databases. 20
Editing accounts and privilege sets. 21 Uploading database files. 22 Uploading database files manually. 24 Verifying databases are available to FileMaker Pro clients. 25

Hosting websites. 27

Hosting PHP websites. 28 Starting PHP Site Assistant from Admin Console. 30 Hosting XSLT websites. 31 Hosting databases for XML queries. 33 Using Instant Web Publishing. 34
Starting and stopping FileMaker Server. 36 Configuring general settings. 37
Server information settings. 38 Email notification settings. 40 Admin Console settings. 42 Auto Start settings. 44
Configuring administrator groups. 45
Adding administrator groups. 47 External authentication for Admin Console and administrator groups. 50 FileMaker Server group folders. 52 FileMaker Server administrator group privileges. 53
Configuring Database Server settings. 55
FileMaker Pro client settings. 56 Using SSL with an LDAP directory service. 59 Database settings. 61 Cache flushing operation. 63

FILEMAKER SERVER 11 HELP

Database Server security settings. 64 External authentication for database access. 66 Default folder settings. 67 Logging and statistics settings. 69 Server plug-in settings. 71
Configuring web publishing settings. 72
General web publishing settings. 73 PHP web publishing settings. 74 XSLT web publishing settings. 76 Text encoding for XSLT requests. 78 Configuring the interaction between web sessions and database sessions. 79 XML web publishing settings. 80 Instant Web Publishing settings. 81
Administering clients. 82
Sending messages to FileMaker Pro clients. 83 Disconnecting clients. 84
Administering databases. 85
Sending messages to FileMaker Pro clients of selected databases. 87 Opening hosted files. 88 Closing hosted files. 89 Verifying hosted files. 90 Pausing hosted files. 91 Resuming hosted files. 92 Removing hosted files. 93
Using ODBC and JDBC with FileMaker Server. 95
Sharing FileMaker databases via ODBC and JDBC. 97 Enabling sharing via ODBC and JDBC. 98 Accessing external ODBC data sources. 99
Monitoring FileMaker Server. 101
Viewing server statistics. 103 Viewing client statistics. 105 Viewing log file entries. 107 Event log. 110 Access log. 111 Server statistics log. 112 Client statistics log. 113 Web publishing logs. 114 Web Server Module log. 115

Managing plug-ins. 116

Enabling server-side plug-ins. 117 Folders for server-side plug-in files. 118 Changing plug-in file permissions (Mac OS). 119 Enabling auto-update for plug-ins. 120
Preparing Mac OS plug-in files for conversion to.tar format. 121
Securing your data. 122 Scheduling administrative tasks. 123
Scheduling database backups. 125 Tips for database backups. 126 About keeping multiple backups of a scheduled backup. 128 Restoring a database file from a backup. 129 Verifying the integrity of databases. 130 Running server-side scripts. 131 Running FileMaker scripts. 132 Running system-level script files. 134 Creating Script Sequence tasks. 135 Sending scheduled messages to clients of hosted databases. 136 Creating schedules. 137 Examples of repeating schedules. 138 Editing schedules. 140 Duplicating a schedule. 141 Deleting a schedule. 142 Running a schedule manually. 143 Enabling and disabling schedules. 144

Saving and loading schedules and groups. 145
Saving schedules and groups settings. 147 Loading schedules and groups settings. 148

Troubleshooting. 150

Deployment problems. 151 Admin Console problems. 152 General problems. 153 Network problems. 154 Problems on client computers. 155 FileMaker Server event log messages. 157 Command line error messages. 162 Improving performance. 163
Checking for updates. 164 About the license key. 165 Command line reference. 166
fmsadmin commands. 169 AUTORESTART command. 170 BACKUP command. 171 CLOSE command. 172 DISABLE command. 173 DISCONNECT command. 174 ENABLE command. 175
HELP command. 176 LIST command. 177 OPEN command. 178 PAUSE command. 179 REMOVE command. 180 RESTART command. 181 RESUME command. 182 RUN command. 183 SEND command. 184 START command. 185 STATUS command. 186 STOP command. 187 VERIFY command. 188
Glossary. 189 Registration. 197 Customer support and Knowledge Base. 198 Copyright information. 199 Help topics that do not appear in the table of contents (such as contextsensitive topics). 200
Setting up an administrator account. 201 Naming FileMaker Server. 202 Enabling sharing via ODBC and JDBC. 203 Enabling web publishing. 204 Enabling technologies for web publishing. 205 Selecting a deployment type. 207 Assigning worker machine roles. 208 Specifying a web server. 209 Web Server Test Failed. 210 Deployment summary. 211 Users, groups, and permissions (Mac OS). 212 Selecting databases to upload. 214 Specifying an upload option. 216 Viewing the database upload status. 217 Reviewing the upload summary. 218 Starting or stopping the FileMaker Server service (Windows). 219 Starting or stopping FileMaker Server background processes (Mac OS). 220 Specifying directory service settings. 221 Publishing directory server settings. 222 About user details. 223 About databases open details. 224 Viewing activities in the Event Viewer (Windows). 225 Changing the language of the Event log. 226 Selecting a task. 228 Database backup schedule. 229 Selecting databases. 230
Selecting the backup folder and options. 231 Adding database close options. 232 Selecting the schedule frequency. 233 Naming the schedule. 234 Enabling email notifications in schedules. 235 Receiving email notifications only when a schedule fails. 236 Reviewing schedule details. 237 Selecting the script type. 238 Selecting a database to run the FileMaker script. 239 Selecting a FileMaker script to run. 240 Selecting a system-level script to run. 241 Adding script sequence options. 243 Adding script options. 245 Selecting users to send a message to. 246 Creating a message. 247 Ports used by FileMaker Server. 248 Tips for valid folders. 249

About FileMaker Server

FileMaker Server is a dedicated database server that opens FileMaker Pro files, makes them available to clients on your network, and publishes FileMaker data in web pages or to other applications. Note If you are a group administrator, your server administrator must configure your administrator group to allow you to do database administration tasks. Group administrators are not allowed to configure FileMaker Server or perform other server administration tasks described in many of the topics in this online Help system. A note at the beginning of each major topic indicates which tasks group administrators are allowed to do if the server administrator selects the appropriate privilege for the group. For more information, contact your server administrator.

FileMaker Server 11 supports FileMaker Pro 9, 10, and 11 clients. You must convert files created in FileMaker Pro 6 and earlier to the.fp7 file format. See FileMaker Pro Help for information on converting files. If a hosted database is designed to access data from an external SQL data source, you must set up the same ODBC data source name (DSN) on the FileMaker Server master machine as was set up on the machine running FileMaker Pro when the database was created. See Accessing external ODBC data sources. If a hosted database uses server-side plug-ins or if you want to automatically update clientside plug-ins, then you must place the plug-ins on FileMaker Server also. See Managing plug-ins. You cannot use peer-to-peer database hosting in FileMaker Pro on the same computer that FileMaker Server is running on. As FileMaker Server opens files that were not closed properly or have not been opened in a FileMaker Pro 8 or later product, FileMaker Server performs a consistency check on each file and logs the result of the check in the event log. Up to 125 FileMaker Pro database files can be hosted on FileMaker Server and automatically opened when FileMaker Server starts. If you are a group administrator, your server administrator must configure your administrator group to allow you to upload databases to your group folder. For more information, contact your server administrator.
Administering databases Closing hosted files Administering clients Viewing server statistics Sending messages to FileMaker Pro clients Enabling auto-update for plug-ins
Editing accounts and privilege sets
Note The following information is for server administrators and group administrators. In FileMaker Pro, edit the accounts and privilege sets that clients will use for access to each database. Choose File menu > Manage > Security. Enable the appropriate extended privileges for particular privilege sets. Every account assigned to a privilege set with extended privileges will be able to access the database through the protocol associated with an extended privilege (for example, Access via FileMaker Network). For more information on accounts, privilege sets, and extended privileges, see the FILEMAKER PRO USER S GUIDE. Enable the privilege to Disconnect user from FileMaker Server when idle to disconnect idle users from FileMaker Server for each account (or keep them connected), as necessary. For more information on setting the length of time a user must be idle before being disconnected, see FileMaker Pro client settings. If you plan to use external authentication, then you must edit each FileMaker Pro account that clients will use for shared access. In the Edit Account dialog box, for Account is authenticated via, choose External Server. For more information on enabling external authentication for FileMaker Pro accounts, see FileMaker Pro Help. For more information on setting up FileMaker Server to support external authentication, see Database Server security settings.

where: <scheme> is the HTTP or HTTPS protocol. <host> is the IP address or domain name of the host computer where the web server is installed. <port> is optional and specifies the port that the web server is listening on. If no port is specified, then the default port for the protocol is assumed (port 80 for HTTP, or port 443 for HTTPS). <path> is optional and specifies the folder inside the xslt-template-files folder where the XSLT stylesheet is located. <stylesheet> is the name of the stylesheet with an.xsl extension. <query string> can be a combination of one query command and one or more query parameters for Custom Web Publishing with XSLT.
XSLT web publishing settings Hosting websites
Note The following information is for server administrators. FileMaker Custom Web Publishing with XML enables you to send query requests to FileMaker Server, and display, modify, or manipulate the resulting data as needed. Using an HTTP request along with the appropriate query commands and parameters, you can retrieve FileMaker data as an XML document. For more information on preparing a database and accessing XML data, see CUSTOM WEB PUBLISHING WITH XML AND XSLT on the Start Page.
To host a database that uses Custom Web Publishing with XML:
1. In FileMaker Pro, open the database and edit the privilege set for the account that will access the database. Enable the extended privilege Access via XML Web Publishing FMS only. Note If your FileMaker database solution uses more than one FileMaker database file, all of the database files must use this privilege set with the extended privilege Access via XML Web Publishing - FMS only enabled. 2. In FileMaker Server Admin Console, select Enable XML publishing on the Web Publishing > XML tab. 3. Prepare databases for Custom Web Publishing. For more information, see FILEMAKER SERVER CUSTOM WEB PUBLISHING WITH XML AND XSLT. 4. Upload the database file to FileMaker Server with the Upload Database assistant. See Hosting databases. Note If your FileMaker database solution uses more than one FileMaker database file, all of the database files must be on the same computer. 5. Send an HTTP or HTTPS request in the form of a URL that specifies the FileMaker XML grammar, one query command, and one or more FileMaker query parameters to the Web Publishing Engine through an HTML form, an HREF link, or a script in your program or webpage. You can also type the URL in a web browser. For more information on specifying a URL for XML data, see FILEMAKER SERVER CUSTOM WEB PUBLISHING WITH XML AND XSLT.
XML web publishing settings Hosting websites
Note The following information is for server administrators. You can use Instant Web Publishing to quickly and easily publish your database on the web. You dont need to modify your database files or install additional software anyone with compatible web browser software and access to the internet or an intranet can connect to your database to view, edit, sort, or search records, if you give them access privileges. Note Instant Web Publishing is available only if you have a FileMaker Server Advanced license. For more information on developing a FileMaker Pro database that works well with Instant Web Publishing, see FILEMAKER INSTANT WEB PUBLISHING GUIDE on the Start Page.

Administrator groups are available only if you have a FileMaker Server Advanced license. Administrator groups are an optional feature. If multiple users log in to the same group administrator account at the same time, only one user can do the following tasks at a time: Edit a particular schedule Use the Upload Database assistant to upload a database Whenever the server administrator adds, changes, renames, or removes an administrator group, an event is logged in the Event.log file. See Event log.
Adding administrator groups
External authentication for Admin Console and administrator groups Saving and loading schedules and groups
Note The following information is for server administrators. As the server administrator, you can use administrator groups to delegate database administration tasks to other users. You retain exclusive and complete control of FileMaker Server. Group administrators are not allowed to configure FileMaker Server, and you specify which database administration tasks you want to allow group administrators to do. For more information, see Configuring administrator groups.
To add an administrator group:
1. Choose Administrator Groups. 2. Click Add. 3. Enter the configuration information for the administrator group: To Enter the user name and password of the administrator group Do this For Identity: Group Name: Enter a name for the administrator group. The group administrator enters this name when logging in to Admin Console. Group Password and Confirm Password: Enter a password for the administrator group. Use an optional external group for authentication Select Use external group and enter an optional domain or local machine name followed by the external authentication group name. For example: groupname, domain\groupname, or groupname@localmachine. The external group cannot be associated with the Admin Console account. See Admin Console settings. You can limit the number of external groups FileMaker Server Advanced searches when authenticating users by specifying the domain or local machine name in either of the following formats: domain\group or localmachine\group group@domain or group@localmachine If you do not specify a domain or local machine name, here is how FileMaker Server Advanced searches for the external group on these platforms: Mac OS: searches the local machine only Windows: searches the domain, if the computer is a member of a domain, then searches the local machine To test your external group authentication setting, click Test External Group. If the test fails, verify the external group name information.

To Select the FileMaker Server group folder that contains the databases you want to associate with the administrator group
Do this Click Select Folder, select the FileMaker Server group folder, then click OK. For information about the rules that affect group folders, see FileMaker Server group folders. Folders that are not associated with an administrator group and therefore available are indicated by the following folder icon in the Select Folder dialog box:
Folders that are already associated with an administrator group and therefore unavailable for other groups are indicated by the following group folder icon:
You can position your cursor over this group folder icon to display the name of the administrator group that is already associated with the group folder. This icon is also displayed for the parent folder of an existing group folder to indicate the parent folder is also unavailable. Select the FileMaker Server administrator group privileges 4. Click Save. Important To prevent users from mistakenly logging in to Admin Console or the wrong administrator group, make sure the group names and passwords defined in the Manage Groups tab do not match any user name and password in any of the external authentication groups associated with Admin Console or another administrator group. Use a unique group name and a strong password that is at least 8 characters and a combination of letters and numbers. Note that the Admin Console user name and administrator group names are not case sensitive, but passwords are. For additional important guidelines for using external authentication groups, see External authentication for Admin Console and administrator groups. Click Edit Privileges, select the group privileges, then click OK. For more information, see FileMaker Server administrator group privileges.
Make sure you click Test External Group to verify the external group name information is correct. Also make sure the group administrators account information exists in the external group. If the external group name is incorrect or the group administrators user name or password does not exist in the external group, FileMaker Server displays a message to group administrators when they log in stating that the user name and password are incorrect. If a group administrator is a member of multiple external groups each of which is associated with an administrator group, Admin Console displays the Select Administrator Group dialog box to allow the group administrator to select an administrator group when logging in. After logging in, the group administrator can switch groups by choosing Server menu > Groups and then the group name.
Users in an associated external authentication group can log in using the group name and password in addition to their external user name and password. If you do not want to allow users to use the group name and password to log in, then do not distribute the group name and password to users. The administrator group privileges determine the level of access for group administrators that are members of external authentication groups. If you change the properties or privileges for an administrator group while a group administrator is logged in to that group, FileMaker Server displays a message to warn you the properties and privileges will change immediately. The change can possibly confuse the group administrator. For example, if you disable the privilege that allows the group administrator to create schedules, the change takes effect immediately. To avoid confusion, you may want to ask the group administrator to log out of Admin Console before you save any changes to the group properties or privileges. Schedules are associated with databases, not with administrator groups. If you change the group folder for an administrator group, the schedules displayed in the Schedules pane will change to the schedules that are associated with the databases in the new group folder. To avoid confusion, you may want to inform the group administrator before you change the group folder or group name. If a schedule performs a task on a database that is in an administrator group, the groups name is listed next to the schedule in the Schedules pane for server administrators only. If you change a group name, the new name appears in the Schedules pane next to any schedules associated with the databases in that group. To remove a saved administrator group, select the group name in the Manage Groups tab and then click Remove. The databases in the group folder and all associated schedules are not deleted when you remove a group. To change a group folder for a saved administrator group from a subfolder to the default or additional database folder, you must first remove the saved administrator group. Then you can create a new group and select the default or additional database folder in the Select Folder dialog box. If a group folder is deleted, renamed, or moved by using file system tools, a group administrator can log in to Admin Console. But the group administrator cannot perform any database administration tasks because the association with the original group folder name has become invalid and consequently there are no databases in the group. You must specify a new valid group folder for the group in the Manage Groups tab. The server administrator can create all types of schedules for a particular group except system-level script schedules. Group administrators must create their own system-level script schedules for their groups. After the groups system-level script schedules are created, the server administrator can perform all actions on themincluding running, editing, and deleting them.

To specify event logging settings:
1. Choose Database Server > Logging tab. To Set the time between collecting statistics Do this For Collection Interval, enter the time in minutes and seconds. The collection interval determines how frequently FileMaker Server collects the server statistical information that is displayed in the Statistics > Server tab and optionally logged in the Stats.log file. The collection interval also determines how frequently FileMaker Server collects the client statistical information that is displayed in the Statistics > Clients tab and optionally logged in the ClientStats.log file. Specify the log size For Log Size, specify the maximum size in MB for the Access.log, Event.log, Stats.log, and ClientStats.log files.

To Enable logging

Do this Events are always logged in the Event.log file. Event logging cannot be disabled. Select Access to log connections to FileMaker Server in the Access.log file. Select Usage statistics to log server performance measurements displayed in the Statistics > Server tab in the Stats.log file. Note Selecting Usage statistics does not log the client statistics displayed in the Statistics > Clients tab in the ClientStats.log file. For more information, see Viewing client statistics.
General web publishing settings Viewing server statistics Viewing log file entries Configuring Database Server settings

Server plug-in settings

Note The following information is for server administrators. The Database Server > Server Plug-Ins tab allows you to enable FileMaker Server to use external function plug-ins with hosted FileMaker Pro databases that are designed to use server-side plugins. For more information on plug-ins, see Managing plug-ins.
To allow FileMaker Server to use plug-ins:
1. Select Enable FileMaker Server to use plug-ins. The list shows the plug-ins that are in the plug-in folder. 2. Select Enabled for each plug-in that you want to execute on FileMaker Server. 3. Click Save.
Enabling server-side plug-ins Uploading database files Configuring Database Server settings
Configuring web publishing settings
Note The following information is for server administrators. Choose Web Publishing and select one of the following tabs to specify FileMaker Server settings: Choose General Settings To Specify the web publishing error logging level and the maximum number of web publishing sessions. See General web publishing settings. Enable and configure Custom Web Publishing with PHP. See PHP web publishing settings Enable and configure Custom Web Publishing with XSLT. See XSLT web publishing settings Enable and configure Custom Web Publishing with XML. See XML web publishing settings Enable and configure Instant Web Publishing. See Instant Web Publishing settings

To enable XSLT Publishing:
1. Choose Web Publishing > XSLT tab. To Enable XSLT Publishing Do this Select Enable XSLT publishing. This setting must be enabled to configure the other settings in this tab. Choose how errors are generated Select one of these modes: Development mode: Generate a specific error page when an error occurs in the Web Publishing Engine. Use this mode when you are developing and testing XSLT stylesheets. You cannot enable server-side stylesheet caching in Development mode. Production mode: Generate a default general text message in the error page when an error occurs in the Web Publishing Engine. Use this mode to use the Web Publishing Engine to host XSLT stylesheets. Enable server-side stylesheet caching If Production mode is selected, select Enable stylesheet caching and choose a value for Cache Size. Server-side caching stores frequently-used XSLT stylesheets in memory, which increases Web Publishing Engine performance. The Web Publishing Engine uses caching only when it is in Production mode. Enable XSLT database sessions Select Enable database sessions. Sessions are optional in Custom Web Publishing with XSLT. For more information, see Configuring the interaction between web sessions and database sessions.
To Set the default session timeout value
Do this For Session Timeout, set the default session time-out for Custom Web Publishing with XSLT. Sessions are optional in Custom Web Publishing with XSLT and you create them by using the fmxslt:create_session() extension function. You can override the default setting by using the fmxslt:invalidate_session() and fmxslt:set_session_timeout() extension functions. See FILEMAKER SERVER CUSTOM WEB PUBLISHING WITH XML AND XSLT.
Specify SMTP information for email messages sent in an XSLT stylesheet
Specify the following: SMTP Server Address: Enter an IP address (example: 127.1.1.1) or a host name (example: postoffice.emailserver.com). Port: The port number required to connect to the SMTP server. The default port number is 25. Select SMTP Authentication if required and choose the authentication type: Plain Text: Plain text authentication using LOGIN mechanism CRAM-MD5: Challenge-Response Authentication Mechanism-Message Digest 5 authentication to encrypt the password for the SMTP mail server Note Contact your email administrator to find out whether authentication is required and what type is used. User: Enter the user name required to log in to the SMTP server. Password: Enter the users password.
Select the default character encoding 2. Click Save.
For Default Character Encoding, select the Page Encoding and the Email Encoding. See Text encoding for XSLT requests
Administering databases Administering clients General web publishing settings Email notification settings Configuring web publishing settings
Text encoding for XSLT requests
Note The following information is for server administrators. When the Web Publishing Engine is installed, the initial default text encoding for XSLT requests is UTF-8. For email messages, the default is ISO-8859-1. You can change these default text encoding settings. For more information about overriding default settings for individual requests, see the FILEMAKER SERVER CUSTOM WEB PUBLISHING WITH XML AND XSLT on the Start Page. Encoding US-ASCII ISO-8859-1 ISO-8859-15 ISO-2022-JP Shift_JIS UTF-8 Description Basic ASCII character set typically used for plain text English email Latin-1 character set typically used for Roman character-based webpages and email messages Latin-9 character set, which is almost the same as the Latin-1 character set. Includes the Euro symbol. ISO Japanese encoding typically used for Japanese email messages Japanese encoding typically used for Japanese web pages Eight-bit encoding of Unicode. Because UTF-8 supports the full range of Unicode characters, it can handle pages for any language.

Cache Unsaved %

Disk KB/sec Read Disk KB/sec Written Elapsed Time/Call

I/O Time/Call

Statistic Network KB/sec In Network KB/sec Out Open Databases Remote Calls/sec
Description Amount of data being transferred across the network into FileMaker Server, measured in KB. Amount of data being transferred across the network out of FileMaker Server, measured in KB. Number of open databases. Use this information to configure the Maximum number of files to host option. Number of separate remote calls received from all clients, divided by the statistics sampling interval. Note that there can be multiple remote calls to perform a single operation from the client's perspective. Number of separate remote calls received from all clients that were pending completion at the moment in time when statistics were last sampled. Time (in microseconds) a remote call waits for other processes. For example, a value of 1 million means an average of 1 second per call.

Remote Calls In Progress

Wait Time/Call
If you are a group administrator, your server administrator must configure your administrator group to allow you to view server statistics. For more information, contact your server administrator. FileMaker Server updates the server statistics list at the time interval you specify. To reduce the overhead required to calculate statistics, you can increase the interval between each time FileMaker Server collects statistics. However, the server statistics then become approximations of how FileMaker Server is actually using system resources. For information on configuring the statistics collection interval, see Logging and statistics settings. FileMaker Server can also store server statistics in a log file. See Server statistics log. To sort items in the list in ascending or descending order, click a column heading. To resize the width of a column, select the column heading border and drag it horizontally. To put the columns in a different order, click a column heading, drag it, and drop it at the desired location.
Administering clients Administering databases Logging and statistics settings Monitoring FileMaker Server
Viewing client statistics
Note The following information is for server administrators. Use the Statistics > Clients tab to monitor server performance and diagnose the causes of FileMaker Server performance problems. Admin Console displays client statistics collected during remote calls made by each FileMaker Pro client, all Web Publishing Engine (WPC) clients, and all ODBC and JDBC clients to FileMaker Server. The client statistics are collected and logged only while the Statistics > Clients tab is displayed. If you choose a different tab or pane or stop Admin Console, FileMaker Server automatically stops collecting and logging client statistics. Note If you use the Statistics > Clients tab in larger deployments, FileMaker Server performance may be adversely affected. Use the Statistics > Clients tab only when needed to troubleshoot FileMaker Server performance problems.

To view client statistics:
1. Choose Statistics > Clients tab. 2. To pause the update of client statistics in the Statistics > Clients tab, click Pause. See Pausing and resuming update of client statistics. 3. To log the client statistics, select Log client statistics while the Clients tab is selected. See Logging client statistics. Statistic Client Description For a FileMaker Pro client, the user login name is displayed. For all Web Publishing clients, WPC is displayed. For all ODBC and JDBC clients, XDBC is displayed. Position your cursor over the name in the Client column to display the machine name and IP address of the client. Remote Calls Number of remote calls completed. Note that there can be multiple remote calls to perform a single operation from the client's perspective. Number of remote calls which are pending completion. The start of the remote call can be during the current collection interval or the previous interval. Elapsed time (in microseconds) of a completed remote call or an inprogress remote call. Time (in microseconds) spent by the clients thread waiting for input and output to complete. Time (in microseconds) spent by the clients thread waiting for other threads or resources. Number of bytes received from the client to FileMaker Server (data requests). Number of bytes sent to the client from FileMaker Server (notifications).

In Progress

Elapsed Time I/O Time Wait Time Net Bytes In Net Bytes Out
Pausing and resuming update of client statistics
FileMaker Server continuously updates the client statistics in the Statistics > Clients tab at the time interval specified for the statistics collection interval. The default setting is 15 seconds. You can click Pause to pause the update of the statistics in the Statistics > Clients tab so that you can inspect the data. Click Resume to display the latest client statistics and continue updating. To reduce the overhead required to calculate statistics, you can increase the interval between each time FileMaker Server collects statistics. However, the client statistics then become approximations of how FileMaker Server is actually using system resources. For information on configuring the statistics collection interval, see Logging and statistics settings.
Logging client statistics
If you select Log client statistics while the Clients tab is selected, a log file named ClientStats.log is created in the FileMaker Server/Logs/ folder for as long as the Statistics > Clients tab is displayed. If you choose a different tab or pane or stop Admin Console, FileMaker Server automatically deselects Log client statistics while the Clients tab is selected. ClientStats.log is a tab-delimited text file. You can view the ClientStats.log file in FileMaker Pro, a spreadsheet, or a text editor. See Client statistics log.

General problems

FileMaker Server is sending too many email messages
You have many, frequently-run scheduled tasks with email notifications enabled. Try disabling email notifications or remove email addresses for some scheduled tasks. Also, see Receiving email notifications only when a schedule fails.
None of the scheduled tasks are running
FileMaker Server has been configured not to allow any schedules to run. To allow FileMaker Server to run enabled schedules, click Schedules and select Allow schedules to run.
The path for my additional database folder or backup database folder is not valid
Check the ownership and permissions of the folder. When you click Validate in the Database Server > Default Folders tab or the Schedule assistant, Admin Console may fail to validate a folder path because the folder does not have the correct permissions. Check that the folder is owned by the user fmserver (or in the group fmsadmin) and has read and write permissions. The backup folder cannot be a parent or a subfolder of the default database folder, the additional database folder, or the Scripts folder. The additional database folder cannot be a parent or a subfolder of the default database folder, the backup folder, or the Scripts folder. See Default folder settings and Tips for valid folders.

Network problems

A FileMaker Pro client using TCP/IP can't find FileMaker Server databases on the network
Verify that TCP/IP networking software is properly configured on the host and client computers. Verify that the simultaneous client limit you specified has not been reached. FileMaker Pro databases shared via TCP/IP can be opened remotely using the list of local hosts, the IP address of the host machine, or the DNS name of the host machine if one has been defined. For example, a database hosted from a computer with an IP address of 192.168.10.0, and a DNS name of host.domain.com can be opened by entering either the IP address or the DNS name in the File menu > Open Remote > Network File Path field, using the format fmnet:/192.168.10.0/ <filename>. (Note that fmnet:/ uses a single slash.) Note FileMaker Pro also supports IPv6 addresses in the form of eight four-digit number groups, separated by colons and surrounded by square brackets. For example, fmnet:/ [2001:0DB8:85A3:08D3:1319:8A2E:0370:7334]/<filename> If no client computers can see FileMaker Server in the Open Remote File dialog box, check the server network connection, and make sure the FileMaker Server ports are open on any firewall.
If the master machine has a firewall enabled, then you must open the ports required by FileMaker Server to communicate with users and administrators. See Ports used by FileMaker Server. Each shortcut starts Admin Console for a specific FileMaker Server deployment. If the IP address of the master machine has changed, you must remove the shortcut and start Admin Console from the FileMaker Server Admin Console page again. See Starting Admin Console.

To enable web publishing:
1. Click Yes, enable Web Publishing to enable web publishing or click No, do not enable Web Publishing to disable. 2. Click Next to go to the next step. Click Back to return to the previous step or Cancel to exit the Deployment assistant.
To use web publishing, a supported web server must be installed and activated. For more information, see FILEMAKER SERVER GETTING STARTED GUIDE on the Start Page. You can change the web publishing technology settings in Admin Console. However, you must use the Deployment assistant to enable or disable web publishing as a whole (click Edit Server Deployment on the FileMaker Server Overview pane).
Deploying FileMaker Server Enabling technologies for web publishing
Enabling technologies for web publishing
In this Deployment assistant step, choose the technologies you want to use to publish your FileMaker databases on the web.
To enable the technologies for web publishing:
1. Select the web publishing technologies that you want to use. If you want to Send HTTP requests along with XML query commands and parameters and retrieve FileMaker data as an XML document. Transform, filter, or format XML data in a FileMaker database using XSLT stylesheets for use in a web browser or in other applications. Quickly and easily publish FileMaker databases on the web that look and work much like they do in FileMaker Pro. Access FileMaker data using the FileMaker API for PHP in PHP web applications. Enable XML XSLT
Instant Web Publishing Requires a FileMaker Server Advanced license. PHP
2. If you enable PHP publishing, choose whether to install the FileMaker supplied version of PHP. If you want to Install FileMaker supplied PHP and the FileMaker API for PHP Use your own installation of PHP Choose Yes, install the FileMaker supported version of PHP (PHP 5.2) If you already have PHP installed, it will be disabled. No, use my existing installation of the PHP engine FileMaker Server supports PHP versions 4.3.11, PHP 4.4.1, and PHP 5.x. You must manually install the FileMaker API for PHP. For instructions, see FILEMAKER SERVER CUSTOM WEB PUBLISHING WITH PHP on the Start Page. 3. Click Next to go to the next step. Click Back to return to the previous step or Cancel to exit the Deployment assistant.
Enabling Instant Web Publishing requires a FileMaker Server Advanced license. You can change the web publishing technology settings in Admin Console. However, you must use the Deployment assistant to change the option to use the FileMaker supported PHP engine. See Hosting PHP websites. If you use your own version of PHP, you must manually install the FileMaker API for PHP in order to use PHP publishing. See FILEMAKER SERVER CUSTOM WEB PUBLISHING WITH PHP for more information.

Adding script options

Note The following information is for server administrators and group administrators. In this Schedule assistant step, you can select time limit options for the script schedule.

To add script options:

1. For Time limit, select the maximum amount of time you expect the sequence to complete. 2. Select Abort schedule if time limit reached or server stopped if you want to abort the scheduled task if the script or script sequence takes longer to run than the specified Time limit, or if the Database Server stops. 3. Click Next. Click Back to return to the previous step or Cancel to exit the Schedule assistant.
If you select Abort schedule if time limit reached or server stopped and the specified Time limit is exceeded, or if the Database Server stops, the script or script sequence is aborted and FileMaker Server logs an Error message in the Event log. If you do not select Abort schedule if time limit reached or server stopped, FileMaker Server logs a Warning message and the script scheduled task continues to run if the specified Time limit is exceeded, or if the Database Server stops. Use the following methods to stop a script that hangs in an incomplete state such as an infinite loop: To stop a FileMaker script, select the FileMaker script in the Clients pane and choose Disconnect from Actions. To stop a system-level script, locate the scripts process ID in the Event log and terminate the process in the Activity Monitor on Mac OS or Task Manager on Windows.
Selecting users to send a message to
Note The following information is for server administrators and group administrators. In this Schedule assistant step, select the users that you want to receive a message. You select users by choosing one or more databases. Any FileMaker Pro user who is connected to one of these databases will receive the message.
To select users to send a message to:
1. Select one of the following options for sending a scheduled message: Choose All FileMaker Pro users (all databases) To (Server administrators) Send a scheduled message to all FileMaker Pro users connected to hosted databases. (Group administrators) Send a scheduled message to all FileMaker Pro users connected to hosted databases in your administration group. See the following note. FileMaker Pro users of Send a scheduled message to FileMaker Pro users connected to databases in folder hosted databases in a specified folder. See the following note. FileMaker Pro users of Send a scheduled message to FileMaker Pro users connected to a a selected database selected hosted database. 2. Click Next. Click Back to return to the previous step or Cancel to exit the Schedule assistant. Note If you are a group administrator and your server administrator did not select the default database folder or the additional database folder for your administrator group, the FileMaker Pro users of databases in folder option is not available. For more information, contact your server administrator.

DATASHEET

FileMaker SERVER 11
Get reliable, high-performance access to your critical data!
FileMaker Server 11 is fast, reliable, easy-to-use server software for groups of FileMaker Pro users that lets you securely share databases over a network, or on the web. With FileMaker Server 11, you can run your databases at peak performance with helpful diagnostic tools, maintain and back up your databases with ease, and get time-saving automation capabilities.
New in FileMaker Server 11
Get more time saving tools and maintenance enhancements:
New! Enhanced Statistics View Get detailed visibility into every FileMaker Pro client on the server to help diagnose potential issues. New! Backup File Clone Save an empty version of your database to help preserve the schema and architecture of your file while troubleshooting your database. New! Save or Load Schedules Automatically save and load your server schedules when migrating to new hardware. New! Specify User Accounts Get the access privileges you need by selecting a specific user account to run system-level scripts. New! Script Time Limits Set optional time limits for script schedules to keep your databases running more efficiently.
Easy installation and administration Basic installations take just 20 minutes or less. Manage your databases remotely and automate administrative tasks. Run FileMaker Server in a mixed Windows and Mac OS X environment. Monitor every FileMaker Pro client on the server to diagnose potential issues. 24/7 reliability and availability Get anytime access to your data with 24/7 availability. Protect your data with scheduled live back-ups. Host multiple FileMaker database solutions simultaneously on the network to allow your users to share and update critical information Robust scalability Connect up to 250 simultaneous FileMaker Pro users. Get greater security and network performance for your shared databases.
Industry-standard security Manage user accounts and passwords efficiently through external authentication via industry standard Active Directory and Open Directory. Use SSL encryption for secure data transfer. Protect sensitive information by filtering the display of hosted database names based on user privileges. Custom Web Publishing Create custom, data-driven websites using PHP. Use the PHP Site Assistant for step-by-step help in creating PHP websites.
Use built-in PHP Site Assistant themes to create visually stunning websites in minutes.

Minimum Requirements

10 Reasons why you should use FileMaker Server 11!
Manage databases remotely from any computer on the network. Schedule automatic backups for data protection. Automate administrative tasks with the Admin Console. Receive email notifications of errors or completed maintenance activities. Share with larger groups of users compared to peer-to-peer sharing. Centralize your live external SQL connections. Publish data to the web using PHP or XSLT. Secure data transfers with SSL encryption. Use the PHP Site Assistant for step-by-step help in creating PHP websites. Manage user access through external authentication via Active Directory/Open Directory.
Windows Windows Server 2008 R2 Windows 7 Professional Edition Windows Server 2008 Standard Edition SP2 Windows Server 2003 Standard Edition SP2 Mac Mac OS X 10.6 or 10.5.8 (Intel-based Mac) Mac OS X Server 10.6 or 10.5.8 (Intel-based Mac) For detailed technical specifications, visit: www.filemaker.com/servertechspecs
Version stated is the minimum requirement. The software may also work with later versions certified by FileMaker.
Volume License Purchase Options FileMaker provides extensive and progressive volume licensing programs that makes it easy for businesses to outfit their workgroups at a reasonable price. To learn more about FileMaker Volume Licensing Programs, contact the FileMaker Volume Licensing Team at: (800) 725-2747. About FileMaker, Inc. FileMaker, Inc. offers a complete product line including FileMaker Pro, FileMaker Pro Advanced, FileMaker Server, FileMaker Server Advanced, and Bento. These products provide companies with targeted business solutions that are as comprehensive as they are powerful. The FileMaker Business Alliance includes thousands of solution providers available to assist companies with development needs, customized business solutions, and advanced training. For more information, visit www.filemaker.com. To order FileMaker, Inc. products within the U.S. and Canada, call (800) 325-2747. Feature Easy Installation & Administration 24/7 Reliability & Availability Security Custom Web Publishing Sharing FileMaker Server 11

Fast, reliable, easy-to-use server software for managing your FileMaker Pro databases.
FileMaker Server 11 Advanced
FileMaker Server 11 Advanced includes all the features in FileMaker Server 11 plus more sharing and connectivity options. Add FileMaker Server 11 Advanced to FileMaker Pro and maximize your database sharing capabilities, easily and securely.
FileMaker Server 11 Advanced Description Basic installation takes just 20 minutes or less. Manage your databases remotely and automate administrative tasks. Get anytime access to your data with 24/7 availability. Protect your data with scheduled live back-ups. Manage user access through external authentication via Active Directory/Open Directory. Use SSL encryption for secure data transfer. Create custom, data-driven websites using PHP. Use the PHP Site Assistant for creating PHP websites. NEW! FileMaker Server 11 Advanced technology does not limit the number of FileMaker Pro clients. Technical limits are imposed only by your hardware and operating system. NEW! Create Administrator Groups and assign specific administrative tasks while retaining exclusive control of your server. Easily publish and share databases over the web with up to 100 concurrent web users. Share data with other applications via server-based ODBC/ JDBC support. ODBC/JDBC clients can submit SQL queries to FileMaker databases.

Connect up to 250 users

No limits
Administrator Groups Instant Web Publishing ODCB/JDBC Support
19842010 FileMaker, Inc. FileMaker and the file folder logo are trademarks of FileMaker, Inc., in the U.S. and other countries. Mac and the Mac logo are trademarks of Apple Inc. registered in the U.S. and other countries. Windows Server and the Windows logo are trademarks of the Microsoft group of companies. All other trademarks are the property of their respective owners.