Authenticating access via caller-id or username/password

[John Ward]

Good Day,
I've an interesting question.
I currently authenticate users via caller-id for a static ip delivery system.

I have had to change the "sql_user_name" to the "calling-station-id"
attribute so that i can match the entries to so called  usernames in
the MYSQL database

This is working and works well as the username for authentication ends
up being the caller id.

I now have to authenticate users based on username and password in one
instance and solely calling-station-id in another.

the config i use in the "files" to authenticate a user on caller id is
as follows:

DEFAULT Calling-Station-ID =="1234567890", Auth-Type := Accept
        Framed-IP-Address = 155.22.0.21

DEFAULT Calling-Station-ID =="2234567890", Auth-Type := Accept
        Framed-IP-Address = 155.22.0.22

DEFAULT Calling-Station-ID =="3234567890", Auth-Type := Accept
        Framed-IP-Address = 155.22.0.23

DEFAULT Calling-Station-ID =="4234567890", Auth-Type := Accept
        Framed-IP-Address = 155.22.0.24

the DEFAULT section has the framing types etc set.

How would i now do this in the MYSQL database as there is no way of
tying the "username" to anything ?


Regards
John