Hello Jay -
Sorry you are having a bit of a struggle - hopefully we can get this sorted
out for you quickly.
The only possibilities I can think of are that you perhaps forgot the ","
between MAXLOGINS and FRAMED_NETMASK, or that the field FRAMED_NETMASK is
not defined in your database.
Have a look at the trace 4 debug output to see exactly what Radiator is
doing with the database, and you can also set the DBI debugging environment
variable to get lots of debug information out of DBI/DBD.
hth
Hugh
ps - I have copied this to Mike as I will be offline for the next week
NB - I'm travelling for a couple of weeks ...
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
----- Original Message -----
From: "Jay West" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 31, 2000 6:28 AM
Subject: (RADIATOR) Help! Argh! problems with radmin.cfg
> Again...
>
> We're trying to convert from the sample radiator sql database to the
sample
> radmin sql database. I'm having problems specifying the AuthColumnDef
stuff
> properly (I think). To start with, I know I need to specify my own
> AuthSelect and AuthColumnDef's when using AuthbyRADMIN if you want
> additional attributes. To start out simple, I created a radmin.cfg that
just
> specifies the exact same AuthSelect and AuthColumnDef stuff that the
> AuthRADMIN.pm does already by default. Here is the radmin.cfg that
works....
> (note the rest of the problem is described below the radmin.cfg text)...
>
> =========================================
> AuthPort 1812
> AcctPort 1813
> DictionaryFile /usr/local/etc/raddb/dictionary
> PidFile /var/run/radiusd.pid
>
> <Log SQL>
> DBSource dbi:mysql:radmin:pearl.tseinc.com
> DBUsername xxxxxxxx
> DBAuth xxxxxxxx
> Table RADMESSAGES
> Trace 4
> </Log>
>
> <ClientListSQL>
> DBSource dbi:mysql:radmin:pearl.tseinc.com
> DBUsername xxxxxxxx
> DBAuth xxxxxxxx
> </ClientListSQL>
>
> <SessionDatabase SQL>
> DBSource dbi:mysql:radmin:pearl.tseinc.com
> DBUsername xxxxxxxx
> DBAuth xxxxxxxx
> </SessionDatabase>
>
> <Realm DEFAULT>
> <AuthBy RADMIN>
> DBSource dbi:mysql:radmin:pearl.tseinc.com
> DBUsername xxxxxxxx
> DBAuth xxxxxxxx
>
> AuthSelect select PASS_WORD,STATICADDRESS,TIMELEFT,\
> MAXLOGINS \
> from RADUSERS where \
> USERNAME='%n' and BADLOGINS < 5 and \
> VALIDFROM < %t and VALIDTO > %t
> AuthColumnDef 0,User-Password,check
> AuthColumnDef 1,Framed-IP-Address,reply
> AuthColumnDef 2,Session-Timeout,reply
> AuthColumnDef 3,Simultaneous-Use,reply
>
> AccountingTable RADUSAGE
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,integer
> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type,integer
> AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
> AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
> AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
> AcctColumnDef ACCTSESSIONID,Acct-Session-Id
> AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
> AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
> AcctColumnDef NASIDENTIFIER,NAS-Identifier
> AcctColumnDef NASIDENTIFIER,NAS-IP-Address
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef DNIS,Called-Station-Id
>
> AcctSQLStatement update RADUSERS set
> TIMELEFT=TIMELEFT-0%{Acct-Session-Time},
> OCTETSINLEFT=OCTETSINLEFT-0%{Acct-Input-Octets},
> OCTETSOUTLEFT=OCTETSOUTLEFT-0%{Acct-Output-Octets} where USERNAME='%n'
>
> AddToReply Service-Type = Framed-User, \
> Framed-Protocol = PPP,\
> Framed-Routing = None,\
> Framed-MTU = 1500,\
> Framed-Compression = Van-Jacobson-TCP-IP
> </AuthBy>
> </Realm>
> =========================================
>
>
> The above works fine, and radpwtst works fine too. Here's the change - I
> want to also pass to the NAS the Framed-IP-Netmask, as well as the above
> default fields. The *ONLY* change I make to the above config file is to
add
> the field "FRAMED_NETMASK" to the above AuthSelect right after MAXLOGINS
> (but before the \). Then I add a AuthColumnDef after the last one (ex.
> AuthColumnDef 4,Framed-IP-Netmask,reply). Those two things are all I
change.
> Now when I run radpwtst, it tells me the user was rejected with a bad
> password. I know the password is correct, because radpwtst worked with the
> same userid/password combination before those two changes to radmin.cfg
were
> made.
>
> HELP! I've spent days messing with this already and am getting flustered.
> What am I doing wrong????
>
> OS: FreeBSD 3.3, Radiator 2.15, Radmin 1.3. My code is freshly installed
and
> unmodified except one source code change. I changed the update to the log
> file in LogSQL.pm to use TYPE instead of the (problematic) PRIORITY.
>
> Thanks *VERY* much in advance!
>
> Jay West
>
>
> ===
> 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.
>
===
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.
