On 13 Sep 2011, at 20:29, rauch.holger@googlemail.com wrote:
Hi to everybody,
On Tue, 13 Sep 2011, Alan DeKok wrote:
2394263740 wrote:
Sometime, I need disable a user account in mysql database. And then enable it later on after some check complete.
Can you please advise how to toggle such status?
See the MySQL documentation for how to write to rows in MySQL.
It's not just a matter of knowing how write rows in MySQL (that by itself doesn't change the enable/disable status) but also knowing which *column in particular* needs to be set to *what value*. Seems to me like the original poster was referring to that rather than some general MySQL syntax issue.
No. It's SQL, you can alter the query so that it only returns 'enabled' users. It has nothing to do with FreeRADIUS, other than possibly the location of the configuration file (raddb/sql/mysql/dialup.conf).
There're may be multiple solutions, please advise them all, so I can choose a one most fit the needs.
Try harder.
Are you *really* sure that advices like these are helpful at all??? (Alan, I've been subscribed to this mailing list for quite a while now and I'm well aware of the fact that you're very involved concerning code maintenance which leaves less time for answering mails. Of course I can only speak on my behalf, but I'm sure your work is appreciated by all list members. But, to be honest, a suggestion like the one given above is purely ridiculous and is (almost) the same as not replying at all.
The point of the list is to help users who are stuck with a particular question or concept. Not for those who are too lazy to try and figure things out themselves. Give a man a fish etc.. -Arran Arran Cudbard-Bell a.cudbardb@freeradius.org RADIUS - Waging war on ignorance and apathy one Access-Challenge at a time.