(RADIATOR) RADONLINE problems. No queries.
Charles Alexander McCain
mccain at unixatlas.com
Tue Jul 29 08:09:58 CDT 2003
Hugh,
That seems to have fixed it. However,
i see this now.
Tue Jul 29 08:08:37 2003: ERR: Error in PreHandlerHook(): Can't use string
("") as a subroutine ref while "strict refs" in use at
/usr/local/lib/perl5/site_perl/5.6.1/Radius/Client.pm line 338.
What does that mean ?
Thanks,
AL
On Tue, 29 Jul 2003, Hugh Irvine wrote:
>
> Hello Charles -
>
> Your configuration file is incorrect - it should look like what is
> shown below (note the Realm clause at the end).
>
> regards
>
> Hugh
>
>
>
> #Foreground
> #LogStdout
> LogDir /var/adm/radacct
> DbDir /etc/raddb
>
> SnmpgetProg /usr/local/bin/snmpget
> Trace 4
> RewriteUsername s/^([^@]+)\@somewhere.net/$1/
> RewriteUsername s/^([^@]+)\@elsewhere.net/$1/
> RewriteUsername s/\s+//g
> RewriteUsername tr/A-Z/a-z/
>
> <Client DEFAULT>
> Secret letMEin
> DupInterval 0
> </Client>
>
> <SessionDatabase SQL>
> DBSource dbi:mysql:radius
> DBUsername xxxxxxxx
> DBAuth xxxxxxxxxxx
> Identifier SQLS
>
> AddQuery insert into RADONLINE (USERNAME,\
> NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,\
> FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE,DNIS) \
> values ('%n', '%N',\
> '%{NAS-Port}', '%{Acct-Session-Id}', '%o',\
> '%{Framed-IP-Address}', '%{NAS-Port-Type}',\
> '%{Service-Type}','%{Called-Station-Id}')
>
>
> DeleteQuery delete from RADONLINE where \
> USERNAME = '%n' and NASIDENTIFIER='%N' \
> and NASPORT='%{NAS-Port}'
>
> ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
>
> CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE
> \
> where ACCTSESSIONID = '%{Acct-Session-Id}'
> </SessionDatabase>
>
> <ClientListSQL>
> DBSource dbi:mysql:radius
> DBUsername xxxxxxxx
> DBAuth xxxxxxxxxx
> </ClientListSQL>
>
> <AuthBy UNIX>
> DefaultSimultaneousUse 1
> Identifier System
> Filename /etc/shadow
> </AuthBy>
>
> <AuthBy LDAP2>
> DefaultSimultaneousUse 1
> Identifier LDAP
> Host 127.0.0.1
> Port 389
> AuthDN uid=searchuser,dc=centurytel,dc=net
> AuthPassword xxxxxxxxxx
> BaseDN %0=%1,ou=people,dc=centurytel,dc=net
> Scope base
> UsernameAttr uid
> PasswordAttr userPassword
> HoldServerConnection
> SearchFilter (&(gecos=active)(uid=%1))
> AuthAttrDef gidNumber, gid-attr, request
> DefaultReply Service-Type=Framed-User,Framed-Protocol=PPP
> </AuthBy>
>
> <AuthBy SQL>
> #NoDefault
> DefaultSimultaneousUse 1
> Identifier CheckSQL
>
> DBSource dbi:mysql:radius
> DBUsername xxxxxxxxx
> DBAuth xxxxxxxx
>
> AccountingTable ACCOUNTING
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,integer
> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> 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
> AcctColumnDef NASIDENTIFIER,NAS-Identifier
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
>
> AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
> from SUBSCRIBERS \
> where USERNAME=%0
>
> AuthColumnDef 0, User-Password, check
> AuthColumnDef 1, GENERIC, check
> AuthColumnDef 2, GENERIC, reply
> DefaultReply Service-Type=Framed-User,Framed-Protocol=PPP
> </AuthBy>
>
> <Realm DEFAULT>
>
> SessionDatabase SQLS
>
> RewriteUsername s/^([^@]+).*/$1/
>
> PostAuthHook file:"%D/postHook"
> AcctLogFileName %L/%N/detail
>
> #AuthByPolicy ContinueWhileReject
> AuthByPolicy ContinueUntilAccept
> AuthBy LDAP
> AuthBy CheckSQL
> AuthBy System
>
> </Realm>
>
>
>
> On Tuesday, Jul 29, 2003, at 00:59 Australia/Melbourne, Charles
> Alexander McCain wrote:
>
> >
> > Hello,
> >
> > I'm having an issue with my config. It is not throwing anything into
> > RADONLINE, in my trace4, i'm not even seeing queries being sent.
> > Perhaps
> > my configs are wrong?
> >
> > Here is a copy of the config.
> >
> >
> >
> > #Foreground
> > #LogStdout
> > LogDir /var/adm/radacct
> > DbDir /etc/raddb
> >
> > SnmpgetProg /usr/local/bin/snmpget
> > Trace 4
> > RewriteUsername s/^([^@]+)\@somewhere.net/$1/
> > RewriteUsername s/^([^@]+)\@elsewhere.net/$1/
> > RewriteUsername s/\s+//g
> > RewriteUsername tr/A-Z/a-z/
> > <Client DEFAULT>
> >
> > Secret letMEin
> > DupInterval 0
> >
> > </Client>
> >
> > <Realm DEFAULT>
> > RewriteUsername s/^([^@]+).*/$1/
> >
> > PostAuthHook file:"%D/postHook"
> > AcctLogFileName %L/%N/detail
> >
> >
> > <SessionDatabase SQL>
> >
> > DBSource dbi:mysql:radius
> > DBUsername xxxxxxxx
> > DBAuth xxxxxxxxxxx
> > Identifier SQLS
> >
> > AddQuery insert into RADONLINE (USERNAME,\
> > NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,\
> > FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE,DNIS) \
> > values ('%n', '%N',\
> > '%{NAS-Port}', '%{Acct-Session-Id}', '%o',\
> > '%{Framed-IP-Address}', '%{NAS-Port-Type}',\
> > '%{Service-Type}','%{Called-Station-Id}')
> >
> >
> > DeleteQuery delete from RADONLINE where \
> > USERNAME = '%n' and NASIDENTIFIER='%N' \
> > and NASPORT='%{NAS-Port}'
> >
> > ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
> >
> > CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from
> > RADONLINE \
> > where ACCTSESSIONID = '%{Acct-Session-Id}'
> >
> >
> > </SessionDatabase>
> >
> >
> > <ClientListSQL>
> >
> > DBSource dbi:mysql:radius
> > DBUsername xxxxxxxx
> > DBAuth xxxxxxxxxx
> >
> > </ClientListSQL>
> > <AuthBy UNIX>
> >
> > DefaultSimultaneousUse 1
> > Identifier System
> > Filename /etc/shadow
> >
> > </AuthBy>
> >
> > <AuthBy LDAP2>
> > DefaultSimultaneousUse 1
> > Identifier LDAP
> > Host 127.0.0.1
> > Port 389
> > AuthDN uid=searchuser,dc=centurytel,dc=net
> > AuthPassword xxxxxxxxxx
> > BaseDN %0=%1,ou=people,dc=centurytel,dc=net
> > Scope base
> > UsernameAttr uid
> > PasswordAttr userPassword
> > HoldServerConnection
> > SearchFilter (&(gecos=active)(uid=%1))
> > AuthAttrDef gidNumber, gid-attr, request
> > DefaultReply Service-Type=Framed-User,Framed-Protocol=PPP
> > </AuthBy>
> > <AuthBy SQL>
> > #NoDefault
> > DefaultSimultaneousUse 1
> > Identifier CheckSQL
> >
> > DBSource dbi:mysql:radius
> > DBUsername xxxxxxxxx
> > DBAuth xxxxxxxx
> >
> >
> > AccountingTable ACCOUNTING
> > AcctColumnDef USERNAME,User-Name
> > AcctColumnDef TIME_STAMP,Timestamp,integer
> > AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> > 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
> > AcctColumnDef NASIDENTIFIER,NAS-Identifier
> > AcctColumnDef NASPORT,NAS-Port,integer
> > AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
> >
> > AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
> > from SUBSCRIBERS \
> > where USERNAME=%0
> >
> > AuthColumnDef 0, User-Password, check
> > AuthColumnDef 1, GENERIC, check
> > AuthColumnDef 2, GENERIC, reply
> > DefaultReply Service-Type=Framed-User,Framed-Protocol=PPP
> >
> >
> > </AuthBy>
> >
> >
> > #AuthByPolicy ContinueWhileReject
> > AuthByPolicy ContinueUntilAccept
> > AuthBy LDAP
> > AuthBy CheckSQL
> > AuthBy System
> >
> >
> > </Realm>
> > ===
> > Archive at http://www.open.com.au/archives/radiator/
> > Announcements on radiator-announce at open.com.au
> > To unsubscribe, email 'majordomo at open.com.au' with
> > 'unsubscribe radiator' in the body of the message.
> >
> >
>
> NB: have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator
mailing list