Howdy all,
I've got a question to ask..and I hope someone can help shed some light on
the subject.
We have a filtering service called 'X-Stop', that filters users depending on
their class
string.. One can customize the class attribute depending on what the user
wants
filtered..
Here's the question, how can grab the custom string out of my database for
the
user, if they have the service enabled (column is xstop) ?? Here's a sample
code that I have now of my AuthBy SQL statement..
<AuthBy SQL>
DBSource dbi:mysql:authenticate:127.0.0.1
DBUsername xxxxx
DBAuth xxxxx
AuthSelect select password, '' as CHECKATTR,
if(xstop=1,'VPN-Neighbor = 216.190.28.36, Class = "xstop: Rule1"','Class=
"IW.SGU-SUNSET"') as REPLYATTR from users where username='%n' and
dialup_service!=-1 and dialup_service!=0
EncryptedPassword 1
</AuthBy>
As you can see there's a simple 'if' statement inside the select statement
that sets the
VPN-Neighbor to talk to the Filtering box directly.. and assigns the class
..
Question being, how do I select the class from the database, and return it
as the
Class attribute ???
I've tried doing a 'AuthSelect select password,xstop_class, '' .... ' but
that
didn't seem to work right..
Anybody want to offer some help??
Thanks,
Cassidy B. Larson
InfoWest Networking
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
