Re: user last activity and log in

2012-10-05 Thread Johan De Meersman
- Original Message - > From: "Singer Wang" > > 2) use a init-connect to log logins but that doesn't work for users > with super privileges as Keith mentioned below (thanks Keith for actually > trying to help!) That is indeed quite the nifty trick. Thanks, Keith :-) > 3) Write your own p

Re: user last activity and log in

2012-10-05 Thread Singer Wang
My bad actually, the MySQL Enterprise Audit is available in MySQL 5.5 S On Fri, Oct 5, 2012 at 2:14 AM, Singer Wang wrote: > Mellow greetings, > > Enhance your calm. Lets get our facts straight and not go off our > rockers. MySQL 5.6 Enterprise edition will be able to do this natively ( > https

Re: user last activity and log in

2012-10-04 Thread Singer Wang
Mellow greetings, Enhance your calm. Lets get our facts straight and not go off our rockers. MySQL 5.6 Enterprise edition will be able to do this natively ( https://blogs.oracle.com/MySQL/entry/new_in_mysql_enterprise_edition), but otherwise you cannot do it natively. This does not mean its imposs

Re: user last activity and log in

2012-10-04 Thread Keith Murphy
One small correction. Init-connect doesn't require a restart of MySQL. I was thinking of init-file. So that's even better. On Thursday, October 4, 2012, Keith Murphy wrote: > My friend Dave Holoboff wrote this up some time ago: > > > http://mysqlhints.blogspot.com/2011/01/how-to-log-user-conne

Re: user last activity and log in

2012-10-04 Thread Keith Murphy
My friend Dave Holoboff wrote this up some time ago: http://mysqlhints.blogspot.com/2011/01/how-to-log-user-connections-in-mysql.html You know you people sound like children. Really unprofessional. Go ahead --- call me names. i left middle school almost 30 years ago. It won't bother me. Can w

Re: user last activity and log in

2012-10-04 Thread Reindl Harald
From: Claudio Nanni [mailto:claudio.na...@gmail.com] >> Sent: Thursday, October 04, 2012 3:51 PM >> To: Reindl Harald >> Cc: mysql@lists.mysql.com >> Subject: Re: user last activity and log in >> >> Hi, >> >> 2012/10/4 Reindl Harald >> >>

RE: user last activity and log in

2012-10-04 Thread Rick James
Nanni [mailto:claudio.na...@gmail.com] > Sent: Thursday, October 04, 2012 3:51 PM > To: Reindl Harald > Cc: mysql@lists.mysql.com > Subject: Re: user last activity and log in > > Hi, > > 2012/10/4 Reindl Harald > > > > > > > Am 04.10.2012 17:28, schrieb Aastha: &

Re: user last activity and log in

2012-10-04 Thread Claudio Nanni
Hi, 2012/10/4 Reindl Harald > > > Am 04.10.2012 17:28, schrieb Aastha: > > I want to find the last time the given list of users logged in. > > Is there any mysql table from where i can retrieve the data or any > > specific sql > > no - because this would mean a WRITE QUERY in the mysql-database

Re: user last activity and log in

2012-10-04 Thread Reindl Harald
Am 04.10.2012 23:12, schrieb Johan De Meersman: > - Original Message - >> From: "Reindl Harald" rei...@thelounge.net> >> >> it does not matter what kind of users > > I'm happy for you that you still have all the answers anyone could ever want, > Harald. not all but the one to the topic

Re: user last activity and log in

2012-10-04 Thread Johan De Meersman
- Original Message - > From: "Reindl Harald" rei...@thelounge.net> > > it does not matter what kind of users I'm happy for you that you still have all the answers anyone could ever want, Harald. Regardless of having any background knowledge on the circumstance of the question, even. You

Re: user last activity and log in

2012-10-04 Thread Reindl Harald
it does not matter what kind of users usually each application has it's own datanase and it's own user, the application makes the connection and can at this point log whatever you want using the "general query log" can only be a bad joke you will log EVERY query and not only logins again: it is

Re: user last activity and log in

2012-10-04 Thread Aastha
Yes, i meant DB users. On Thu, Oct 4, 2012 at 10:57 AM, Johan De Meersman wrote: > > - Original Message - > > From: "Reindl Harald" > > > > this makes pretty no sense and is NOT the job of a RDBMS > > implement it in your application / db-abstraction-layer > > I notice no specification o

Re: user last activity and log in

2012-10-04 Thread Johan De Meersman
- Original Message - > From: "Reindl Harald" > > this makes pretty no sense and is NOT the job of a RDBMS > implement it in your application / db-abstraction-layer I notice no specification of what kind of users, so I'm assuming DB users. There *is* such a thing: you can find it in the

Re: user last activity and log in

2012-10-04 Thread Singer Wang
It is possible in MySQL 5.6 S On Thu, Oct 4, 2012 at 11:30 AM, List Man wrote: > There is no such thing. Your application has to deal with such info. > > LS > > > On Oct 4, 2012, at 11:28 AM, Aastha wrote: > > > Hello, > > > > I want to find the last time the given list of users logged in. >

Re: user last activity and log in

2012-10-04 Thread Reindl Harald
Am 04.10.2012 17:28, schrieb Aastha: > I want to find the last time the given list of users logged in. > Is there any mysql table from where i can retrieve the data or any > specific sql no - because this would mean a WRITE QUERY in the mysql-database for every connection - having a web-applicat

Re: user last activity and log in

2012-10-04 Thread List Man
There is no such thing. Your application has to deal with such info. LS On Oct 4, 2012, at 11:28 AM, Aastha wrote: > Hello, > > I want to find the last time the given list of users logged in. > Is there any mysql table from where i can retrieve the data or anyt > specific sql > > > Aastha G