Install clients

A client needs a copy of the program and a configuration file with the SQL brokers. It does not need the cluster key.

The command line client

Copy the synsql program on the user's machine, then create etc/synsql.conf in the home directory:

SQL_BROKER  broker-1  11000  /var/tmp
SQL_BROKER  broker-2  11000  /var/tmp

Only the lines SQL_BROKER are read by clients; the name must be resolvable and the port reachable.

The libraries

• The C library (libsynsql.so, libsynsql.a, synsqllib.h) is built with make -f Makefile.lib in the client directory; make -f Makefile.lib install copies it to /usr/local.
• The Python library pysynsql is a directory of Python files with no dependency. Copy it or put it on the PYTHONPATH. On Windows the configuration file is looked for in %APPDATA%\synsql\synsql.conf; the variable SYNSQL_CONF can point to any file.

Accounts

Create one account per user (create user) and grant the privileges they need. Do not share the system account.