Greslore
September 18th, 2008, 07:32 PM
Greetings all,
Basically, I have about 20 machines with central authentication (LDAP). I want to keep track of who is logging in and the date. And this all needs to be secure. I am leaning towards going with a MySQL solution. But I am a bit clueless on this and was hoping someone could point me in the right direction.
Here is what I am thinking...
1-Set up MySQL Server
2-Create MySQL User for the logging
3-Create table: USERS
4-Give MySQL User access to the table
5-Create BASH script to place the output of "whoami" and "date" into the USERS table authenticating with the created MySQL user. This BASH script will be run when the user logs in.
6-Access MySQL db somehow.
Give me your thoughts if I am on the right track or not. Likewise, assuming I am indeed on the right track, how exactly do I accomplish parts 5 and 6? How do I access the MySQL DB? A script that extracts the data into a text file? Any help/guidance is MUCHO appreciated!!
Basically, I have about 20 machines with central authentication (LDAP). I want to keep track of who is logging in and the date. And this all needs to be secure. I am leaning towards going with a MySQL solution. But I am a bit clueless on this and was hoping someone could point me in the right direction.
Here is what I am thinking...
1-Set up MySQL Server
2-Create MySQL User for the logging
3-Create table: USERS
4-Give MySQL User access to the table
5-Create BASH script to place the output of "whoami" and "date" into the USERS table authenticating with the created MySQL user. This BASH script will be run when the user logs in.
6-Access MySQL db somehow.
Give me your thoughts if I am on the right track or not. Likewise, assuming I am indeed on the right track, how exactly do I accomplish parts 5 and 6? How do I access the MySQL DB? A script that extracts the data into a text file? Any help/guidance is MUCHO appreciated!!