kigkonsult logo

contact Contact contact

Downloads Downloads Downloads

Share

iCal

iCalcreator iCalcreator
iCalcreator iCalcreator
iCalcreator iCalcreator iCalcreator
iCalcreator manual iCalcreator manual iCalcreator manual
iCalcreator tests and examples tests and examples iCalcreator tests and examples

rsscalCreator rsscalCreator
rsscalCreator rsscalCreator
rsscalCreator rsscalCreator rsscalCreator
rsscalCreator manual rsscalCreator manual rsscalCreator manual

Implement examples

tinycal tinycal tinycal
iCal file web calendar

eventCreator eventCreator eventCreator
iCal file event web editor

iCal utilities

dbiCal dbiCal dbiCal
iCal database interface

iCal csv xls
iCal csvl xls
iCalcnv iCalcnv iCalcnv
iCal converting package

tiCalFile tiCalFile tiCalFile
creating iCal test files

Communities

Get iCalcreator at SourceForge.net. Fast, secure and Free Open Source software downloads
Forum Reports

Freshmeat freshmeat.net

PHP Classes

sLog

sLog sLog sLog
event tracking database

Communities

SourceForge.net Logo
Forum Reports

Resources

resources Resources resources


Credits

PHPMailer 5.2 (LGPL)
jQuery 1.4.4 (MIT/GPL)
jQuery UI CSS1.8.15 (MIT/GPL)
jQuery Timepicker 0.9.7 (MIT/GPL)
prototype 1.7 (CC BY-SA)
reCAPTCHA

Support

Offer services for software support, design and development of customizations and adaptations of PHP/MySQL solutions with a special focus on software long term utility and reliability, supported through our agile acquire/design/transition process model.

contact Contact contact

Donate

You can show your appreciation for our free software, and can support future development by making a donation to the kigkonsult projects.

Make a donation of any size by clicking here. Thanks in advance!

Copyright ©2008-2012 kigkonsult

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.

Download sLog here.

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>','','','')