Chapter 10. SQL Remote Administration
Theparameters for each message link go in a key under the SQL Remote
key,with the name of the message link (4,

smtp

,and so on).
♦NetWare Youshould create a file named
dbremote.ini
inthe
sys:\system
directoryto hold the FILE system directory setting. Thisfile
isnot a Windows-format INI file: it must consist of a single line, holding
onlythe directory name.
Forexample, if the directory is

user:\dbr43

,then the
dbremote.ini
file
wouldcontain the following:
user:\dbr43
♦UNIX TheFILE system directory setting is held in the SQLREMOTE
environmentvariable.
The

sqlremote

environmentvariable holds a path that can be used as an
alternativeto one of the control parameters for the file sharing system.
Theparameters available for each message system are discussed in the
followingsections. Eachsection describes a single message system.
Whenthe Message Agent loads a message link, the link uses the settings of
thecurrent publisher or, if a setting is not specified, of groups to which the
publisherbelongs. OnWindows, the first time a version of the Message
Agentis run that supports storing the message link parameters in the
database,it copies the link options from the registry to the database.
The file message system
SQLRemote can be used even if you do not have a message system in place,
byusing the filemessage system.
Addressesin the file
messagesystem Thefile message system is a simple file-sharing system. Afile address for a
remoteuser is a subdirectory into which all their messages are written. To
retrievemessages from their “inbox”, an application reads the messages
fromthe directory containing the user’s files. Returnmessages are sent to
theaddress (written to the directory) of the consolidated database.
Whenrunning as an NT service make sure that the account under which the
MessageAgent is running has permissions to read and write all necessary
directories. This is often a problem when accessing network drives.
Rootdirector y for
addresses Thefile system addresses are typically subdirectories of a shared directory
thatis available to all SQL Remote users, whether by modem or on a local
areanetwork. Eachuser should have a registry entry, initialization file entry,
orSQLREMOTE environment variable pointing to the shared directory.
215