On 9/13/2011 12:09, Arran Cudbard-Bell wrote:
On 13 Sep 2011, at 20:29, [email protected] 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
[email protected]
RADIUS - Waging war on ignorance and apathy one Access-Challenge at a time.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
So what are the most proper ways to mark a user in an sql database as
either active or inactive, enabled or disabled?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
