Plugin: logsoracle

Commands

connect

Parameters. 

Short Description.  connect to oracle database

in order to log anything you need to estabilish a connection first.
this requieres ekg variables 'logsoracle:db_login' and
'logsoracle:db_password' to be set.
if something goes wrong during connection check if:
- you have oracle installed ;)
- required enviroment variables are set ($ORACLE_HOME and friends)
  a script which does the work for you should come with the database.
- an instance of the database is running and you can connect to it
  from the command line using sqlplus.
- you have properly set logsoracle:db_login and logsoracle:db_password
variables (type 'set' to see all vars.)
- check if all permissions are ok

disconnect

Parameters. 

Short Description.  close an open oracle connection

see also 'connect' command

status

Parameters. 

Short Description.  print various information about plugin

this command is for informational purposes only. you should get
some basic info about plugin work in your status window.


Variables

auto_connect:

Type.  bool

Default value.  false

autoconnect with the database at startup

db_login

Type.  text

Default value.  none

database login (schema name). 
it's generally a good idea to create a new schema for
EKG2 purposes (don't forget to create all required database
objects - see logsoracle.sql file for more details)

db_password

Type.  text

Default value.  none.

database password associated with schema specified by
'db_login' variable

log_messages

Type.  bool

Default value.  true

if this is set to true then all passing messages (both sent and
recieved) will be logged into the database. it's rather smart 
to keep this on ;)

log_status

Type.  bool

Default value.  true

if true then all status changes (both your's and people from 
the roster) will be logged into the database.
this might generate a lot of data/queries if you have many 
contacts or connect/disconnect very often. in that case try
disabling this feature or create a database trigger which
will filter out unnecessary status changes before new inserts.  

logging_active

Type.  bool

Default value.  true

if for some reason you want to disable logging for a while and
keep the plugin loaded in memory then set this to false.