Running the MobiLink server

All MobiLink clients synchronize through the MobiLink server. None connect directly to a database server. You must start the MobiLink server before a MobiLink client synchronizes.

For a list of mlsrv12 command line options, see MobiLink server options.

The MobiLink server opens database connections, via ODBC, with your consolidated database server. It then accepts connections from remote applications and controls the synchronization process.

To start the MobiLink server

Run mlsrv12. Use the -c option to specify the ODBC connection parameters for your consolidated database.

For information about connection parameters, see -c mlsrv12 option.

You must specify connection parameters. Other options are available, but are optional. These options allow you to specify how the server works. For example, you can specify a cache size and logging options.

For more information about mlsrv12 options, see mlsrv12 syntax.

Note

The mlsrv12 options allow you to specify how the MobiLink server works. To control what the server does during synchronization, you define scripts that are invoked at synchronization events. See Synchronization events.

Example

The following command starts the MobiLink server using the ODBC data source SQL Anywhere 12 CustDB to identify the consolidated database. Enter the entire command on one line.

mlsrv12
  -c "dsn=SQL Anywhere 12 CustDB;uid=DBA;pwd=sql"
  -zs MyServer
  -o mlsrv.log
  -vcr
  -x tcpip(port=3303)

In this example, the -c option provides a connection string that contains an ODBC data source name (DSN) and authentication. The -zs option provides a server name. The -o option specifies that the log file should be named mlsrv.log. The contents of mlsrv.log are verbose because of the -vcr option. The -x option opens a port for version 10 and later clients.

For more information about the options described in the previous example, see:

You can also start the MobiLink server as a Windows service or Unix daemon. See Running the MobiLink server outside the current session.

Required permissions

You must specify a database user for the MobiLink server to connect to the database server. You specify the database user with the mlsrv12 -c option or in the ODBC data source. See -c mlsrv12 option.

This database user must have full select, insert, update, and delete permissions on the MobiLink system tables, and must also have execute permissions on the MobiLink system procedures. By default, the database user who runs the MobiLink setup script has these permissions. If you want to use another database user to run the MobiLink server, you must grant permissions for that user on the ml_* tables and the ml_add_*_script system procedures.

For example, in a SQL Anywhere consolidated database you can grant the required permissions as follows:

CREATE USER DBUser IDENTIFIED BY SQL;
GRANT ALL ON dbo.ml_user to DBUser;
...
GRANT EXECUTE ON dbo.ml_add_table_script TO DBUser;
...

For an example of code that grants the necessary permissions to all MobiLink system objects, see Upgrading your consolidated database.

For a list of all MobiLink system procedures, see MobiLink server system procedures.

The database user also needs the appropriate permission on all tables referenced in the MobiLink scripts, ands execute permissions on any procedures referenced in the MobiLink scripts.

Some types of consolidated databases require the database user used by MobiLink server to have specific permissions against a small number of system tables and/or views. See the following topics for information about specific consolidated databases:

For more information about setup scripts, see Setting up a consolidated database.

Discuss this page in DocCommentXchange.