What is the best way to parse messages?

Question

linux

The task is to display
information about user authorization from /var/log/messages. Further it is necessary to write down all this business in a database for example Mysql. Then bring it up to the software.
That is, you need an analogue of Windows logs.
Experienced advice needed. What is the best way to do this?
Make a parser for example in BASH? Or are there any ready-made solutions?

SUSE Linux Enterprise Server 11

Answer 1

awk is responsible for parsing text files in linux .
There is a good book .

Answer 2

The task is not completely clear.
To display information from /var/log/messages, just do the following: Specify the task.

Answer 3

Perhaps this approach will work for you. In /etc/syslog.conf add the line:
Then you will get the required information in the secure log file

Answer 4

tail -f /var/log/messages | grep "че вам нужно" - and you get a live log only for this line
if you need to write it down
If you need to write all this to the database, then who is stopping you from writing to it.

mysql -uroot -pтут_парол << EOF
Тут что нужно записать 
EOF

In Linux there is no "analogue of the log" you forgive me, such wretchedness has not yet been invented in it. Linux is much easier.
Describe more precisely the task, what kind of thing you need to do.
With an example of a file from which to take.
Where to put the database structure, or how you should display this information.
+

Answer 5

> Next, you need to write the whole thing to a database, for example Mysql
google://syslog-ng mysql