# Plugin configuration

To connect to the database to be monitored, the following fields must be completed in the `pandora_sybase.conf` file:

- isql = Path to the interactive `isql` terminal
- mode=Tentacle by default
- tentacle\_ip = IP address of the Pandora server
- tentacle\_port = Tentacle port of the Pandora server, `41121` by default.

- numberdatabases = Number of databases to be monitored. For each database, the corresponding `user`, `password`, `server`, and `name_agent` must be configured. For example, if two databases need to be monitored, the configuration parameters would be `user1`, `password1`, `server1` for the first database, and `user2`, `password2`, and `server2` for the second.

**Example:**

user1=sa  
password1=p4assword  
server1=desktop12  
name\_agent1=sybase\_desktop12

user2=sa  
password2=Fr4gile  
server2=desktop7  
name\_agent2=sybase\_desktop7

\* If the database can only be accessed via `isql` by specifying the port, it must be included in the configuration file, for example: `desktop12:2083`

- numberqueries = Number of custom queries to be executed (each one will create a module). For each query, in addition to the query itself, a module name and a module type must be defined. The parameters for configuring each query are: `query`, `namemodule`, and `typemodule`. For example, if two modules are to be created, `query1`, `namemodule1`, and `typemodule1` will define the first, while `query2`, `namemodule2`, and `typemodule2` will define the second.

**Example:**

query1=select sum^(case when u.segmap != 4 then size - curunreservedpgs^(u.dbid, u.lstart, u.unreservedpgs^^^) end^^^)/1048576.\*4096 as data\_used from master..sysdatabases d, master..sysusages u where u.dbid = d.dbid and d.status != 256 and db\_name^(u.dbid^^^) = 'test'  
namemodule1=data used database test  
typemodule1=generic\_data

query2=select sum^(case when u.segmap != 4 then size - curunreservedpgs^(u.dbid, u.lstart, u.unreservedpgs^^^) end^^^)/1048576.\*4096 as data\_used from master..sysdatabases d, master..sysusages u where u.dbid = d.dbid and d.status != 256 and db\_name^(u.dbid^^^) = 'master'  
namemodule2=data used database master  
typemodule2=generic\_data

Example of `.conf` file

```
isql=C:\SAP\OCS-16_0\bin\isql

# number of databases
numberdatabases=1

# database user
user1=sa
password1=pandorapass
server1=DESKTOPDQN7L842
name_agent1=sybase_DESKTOPDQN7L842

mode=tentacle
tentacle_ip=192.168.0.29
tentacle_port=41121

# number of queries
numberqueries=2

# queries and modules

query1=select sum^(case when u.segmap != 4 then size - curunreservedpgs^(u.dbid, u.lstart, u.unreservedpgs^^^) end^^^)/1048576.*4096 as data_used from master..sysdatabases d, master..sysusages u where u.dbid = d.dbid and d.status != 256 and db_name^(u.dbid^^^) = 'test'
namemodule1=data used database test
typemodule1=generic_data

query2=select sum^(case when u.segmap != 4 then size - curunreservedpgs^(u.dbid, u.lstart, u.unreservedpgs^^^) end^^^)/1048576.*4096 as data_used from master..sysdatabases d, master..sysusages u where u.dbid = d.dbid and d.status != 256 and db_name^(u.dbid^^^) = 'master'
namemodule2=data used database master
typemodule2=generic_data

```