Startup Scripts

Iotellect Server can execute two types of scripts during its startup: Command scripts and SQL scripts.

A Command script may contain the same commands that are accepted by the Net Admin, one per line. These commands are described in the Net Admin and Startup Script Command Reference. Commands that are not applicable during the startup of the server (i.e. "stop server", "restart server") are not executed. Any output provided by the executed commands is discarded.

Commands Scripts may be used to repair damaged Iotellect Server installations or pre-create system objects (Event Filters, Alerts etc.) in custom installations. Command scripts may include comments: Lines beginning with # will not be processed.

To execute a command script, run Iotellect Server with the with a -e <filename> command line option. (Where filename is the name of the script file).

# Create new event filter called "Keytroller Events" for every user in the system

C/users.*.filters/create/keytroller/Keytroller Events

# Show some additional fields in Event Log

S/users.*.filters.keytroller/additionalFields/description/Description/Keytroller Events/1/timestamp/Description/Keytroller Events/1/userid/Description/Keytroller Events/1/username/Description/Keytroller Events/1/machine/Description/Keytroller Events/1/data/Description/Keytroller Events/1

# Do not show event names in Event Log

F/users.*.filters.keytroller/shownFields/event/0

# Do not show event data in Event Log

F/users.*.filters.keytroller/shownFields/data/0

# Do not show event acknowledgements in Event Log

F/users.*.filters.keytroller/shownFields/ack/0

# Set default Device Driver to Keytroller

F/config/general/defaultDevicePlugin/com.tibbo.linkserver.plugin.device.keytroller

SQL Script contains SQL commands that are executed directly on the Iotellect Server database during server startup, one per line. To execute a command script, run Iotellect Server with the -s <filename> command line option (where filename is the name of the script file). SQL scripts may include comments: Lines beginning with # will not be processed.

Executing SQL commands may corrupt your Iotellect Server database. Backup your database before executing any SQL scripts.

# Emergency removal of user account 'john' and all associated data:

# (may be useful if account was corrupted)

# Removing user account

delete from ag_users where ag_username = 'john'

# Removing Device Server accounts

delete from ag_deviceservers where ag_owner = 'john'

# Deleting all persistent properties in all contexts

delete from ag_properties where ag_context like 'users.john.%'

# Deleting persistent events in contexts owner by John

delete from ag_events where ag_context like 'users.john.%'

Was this page helpful?

Tell us more

Send

Thank you!