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
Parameters.
Short Description. close an open oracle connection
see also 'connect' command
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.
Type. bool
Default value. false
autoconnect with the database at startup
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)
Type. text
Default value. none.
database password associated with schema specified by 'db_login' variable
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 ;)
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.
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.