Downloads
sLog
sLog
A mysql (5.x) log database able to log events in a single or multi system/application environment. Written completely as mysql stored procedures with a secure simple log interface using direct access to database or via a web/SOAP service.
sLog logs application and system events, tracking user, client, application, application module, operation, date and time and event/log specifics.
Logging can be done with a simple direct mysql (function) call, no coding required apart from coding database connection and call. Logging can also be done by doing http or SOAP requests, PHP examples attached.
Database structure is completely hidden from user/calling application, using a mysql user only allowed to insert log events by executing a stored procedure.
Only sLog mysql administrator can access stored events and gather statistics of user activities (who did what?) and application use and payload.
SPM
sLog Payload Monitor is a HTML/Javascript/Ajax interface used for exploring sLog (req. v0.8) information.
LOG ITEMS
ORGANISATION (*) - organisation/unit alt. internet country name/code
ORGANISATION_SPEC - organisation/unit detail text
USER (*) - Some user id, member id alt. IP-number
USER_SPEC - ex. user name alt. Internet domain
CLIENT (*) - client name, alt. Web browser.
CLIENT_SPEC - client specification:version.. ., alt. Web browser spec.
APPLICATION (*) - application/system name
SERVICE - system module/(web-)service name ex. 'createCustomer'
OPERATION - Basic operation, ex. CRUD; one of 'create'/'read'/'update'/'delete'
APPLICATION2 / SERVICE2 / OPERATION2 - opt. parent/child relation; service/subservice
DATE - event date
TIME - event time
OBJECT NUMBER - if running more than one object instance (=application/service),
SUBJECT - Detailed header event information like query, read/update/delete id.. .
BODY - Respons, query answer, update specific..
(*) mandatory
using examples
// COMPLETE mysql call:
SELECT <database>.fslog('<date>','<time>','<application>','<service>',
'<operation>','<objno>','<application2>','<service2>','<operation2>',
'<client>','<clientSpec>','<organisation>','<org/unit>','<user>',
'<user_spec>','<subject>','<body>')
// SIMPLE mysql call:
"SELECT <database>.fslog('','','<application>','','','1','','','','<client>','',
'<organisation>','','<user1>','','','')
Release news
- sLog Payload Monitor, v0.8, released
- sLog Payload Monitor is a HTML/Javascript/Ajax interface used for exploring sLog information.
(Sat, 21 Jun 2008 17:02:27 GMT) - sLog 0.8 released
- A new release of sLog, a mysql
(Sat, 21 Jun 2008 16:56:31 GMT) - sLog 0.6 released
- First release of sLog, a mysql
(Sun, 16 Mar 2008 17:59:01 GMT)