Can this tool help me with this?


(klabacita) #1

Hi.

We have a app that is not logging what the users do, is a ERP but we
cannot know who change, delete or insert data to the db.

The good thing is that we can access the database, we start moving the
system screen to web, because with php we can access the db.

Now, we want to log what the users are doing, we have a idea, let me
explain and see if u understand and let me know if elasticsearch can
help me.

suppose that user1 access the screen number 2(screen2) this is for
adding a new Purchase Order, he change some data and save to the db,
the screen have for example 15 input fields.

Our app, will save the data to the db and after this will log all the
input fields, we concatenated the whole 15 inputs fields we don't care
about validation is what the user want and send it to a log file like
syslog for example that send all in text.

The log will have this format:

UserIP, Username, date+time,
screenX,input1,input2,input3,input4,input5,input6,input7,input8...input15

I don't care for indexes, data types validation, all I want to know is
what data the screen have went the user decide to save it.

Now if u see the log after couple of inputs we will have:

UserIP, User1, date+time,
screenX,input1,input2,input3,input4,input5,input6,input7,input8...input15
UserIP, User2, date+time,
screenX,input1,input2,input3,input4,input5,input6,input7,input8...input15
UserIP, User1, date+time,
screenX,input1,input2,input3,input4,input5,input6,input7,input8...input15

We continue using our ERP with the RDBMS but now we have logs of what
the users are doing, if something happen we go to our log system and
generate a query and search for all the changes in screenX->Input8

Because we know the meaning of that input8.

This is a idea we have, now I can use MySQL for this, create a db,
table with some fields and one that could hold the whole string for my
log, but I think is a waste of resources if we use MySQL.

I was reading articles about no-sql systems and my head ask: do a no-
sql system could help with this?
Do MySQL can do it?

Which one will be better?

Latter I read about elasticsearch and here I am searching for what
system could help us with this logging thing and not affect the
performance of a our current ERP system.

Thanks for your time!!!


(Karussell) #2

do a no-sql system could help with this?

ElasticSearch is a fulltext search server not a no-sql storage,
although there are people (like me) using it as nosql storage.
If you need search (e.g. for searching the logs) it can help you.
(have a look into logstash)

Which one will be better?

Sorry, but you'll need to try it and answer it yourself as only you
know all the requirements.

Peter.

BTW: would you mind to shorten your question a bit next time :slight_smile: no
problem if you have a problem but you should concentrate to the point
so that we can have time for all users :wink:


(klabacita) #3

On Dec 9, 1:40 am, Karussell tableyourt...@googlemail.com wrote:

do a no-sql system could help with this?

ElasticSearch is a fulltext search server not a no-sql storage,
although there are people (like me) using it as nosql storage.
If you need search (e.g. for searching the logs) it can help you.
(have a look into logstash)

Which one will be better?

Sorry, but you'll need to try it and answer it yourself as only you
know all the requirements.

Peter.

BTW: would you mind to shorten your question a bit next time :slight_smile: no
problem if you have a problem but you should concentrate to the point
so that we can have time for all users :wink:

Thanks for your info.

Sorry about the long message, I just wanted to show my problem in
detail.

U have give me more details about elasticsearch.

Thanks!!!


(Karussell) #4

U have give me more details about elasticsearch.

feel free to ask further specific questions after getting started ...

Peter


(klabacita) #5

On Dec 9, 11:46 am, Karussell tableyourt...@googlemail.com wrote:

U have give me more details about elasticsearch.

feel free to ask further specific questions after getting started ...

Peter

Thanks!!!


(system) #6