Hello Lasse,
On Jul 5, 9:55am, Lasse L. Johnsen wrote:
> Subject: (RADIATOR) SQL - LDAP
> Hello All,
>
> This is what I wan't to do:
>
> I wan't to put all mu accounting information into an SQL database, and the
> authentication should come from My LDAP server. Now my problem is the
> following. When I use configuration 1 only stop requests are put in my SQL
> db ( MySQL db ) and no users are allowed to connect, meaning that no one is
> authenticated succesfully. When I use configuration 2 everthing is working
> out as i should. Configuration 3 works - but does of course only put acct
> information in the detail fil. Now what is wrong with the SQL - LDAP
> configuration....?
Hmmm, the configuration file 1 looks OK.
Can you send a Radiator log file at trace level 4, showing what happens when
you try to authenticate and do accounting with configuration "1" from below?
What version of Radiator are you running?
Cheers.
> Best Regards
> Lasse L. Johnsen /TELE Greenland Internet
>
> ____________________________________________________________________________
> _____________________________
>
> 1:
>
> <Realm DEFAULT>
> MaxSessions 1
> AcctLogFileName %L/detail.log
> WtmpFileName %L/wtmp.log
> <AuthBy SQL>
> DBSource dbi:mysql:radius;host.greennet.gl
> DBUsername root
> DBAuth <PASSWD>
> AuthSelect
> AccountingTable radacct
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,integer
> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
> AcctColumnDef ACCTINPUTOCT,Acct-Input-Octets,integer
> AcctColumnDef ACCTOUTPUTOCT,Acct-Output-Octets,integer
> AcctColumnDef ACCTINPUTPAK,Acct-Input-Packets,integer
> AcctColumnDef ACCTOUTPUTPAK,Acct-Output-Packets,integer
> AcctColumnDef FRAMEDIP,Framed-IP-Address
> AcctColumnDef ACCTSESSIONID,Acct-Session-Id
> AcctColumnDef ACCTSESSTIME,Acct-Session-Time,integer
> AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef NASIP,NAS-IP-Address
> AcctColumnDef NASPORTTYPE,NAS-Port-Type
> AcctColumnDef CALLEDSID,Called-Station-Id, integer
> AcctColumnDef CALLINGSID,Calling-Station-Id, integer
> </AuthBy>
> <AuthBy LDAP>
> Identifier Radius
> Host host.tele.gl
> Port 389
> AuthDN cn=Directory Manager
> AuthPassword <PASSWD>
> BaseDN o=greennet.gl
> UsernameAttr uid
> PasswordAttr userpassword
> </AuthBy>
> </Realm>
>
> ____________________________________________________________________________
> ______________________________________
>
> 2:
>
>
> <Realm DEFAULT>
> MaxSessions 1
> AcctLogFileName %L/detail.log
> WtmpFileName %L/wtmp.log
> <AuthBy SQL>
> DBSource dbi:mysql:radius;host.greennet.gl
> DBUsername root
> DBAuth <PASSWD>
> AuthSelect
> AccountingTable radacct
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,integer
> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
> AcctColumnDef ACCTINPUTOCT,Acct-Input-Octets,integer
> AcctColumnDef ACCTOUTPUTOCT,Acct-Output-Octets,integer
> AcctColumnDef ACCTINPUTPAK,Acct-Input-Packets,integer
> AcctColumnDef ACCTOUTPUTPAK,Acct-Output-Packets,integer
> AcctColumnDef FRAMEDIP,Framed-IP-Address
> AcctColumnDef ACCTSESSIONID,Acct-Session-Id
> AcctColumnDef ACCTSESSTIME,Acct-Session-Time,integer
> AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef NASIP,NAS-IP-Address
> AcctColumnDef NASPORTTYPE,NAS-Port-Type
> AcctColumnDef CALLEDSID,Called-Station-Id, integer
> AcctColumnDef CALLINGSID,Calling-Station-Id, integer
> </AuthBy>
> <AuthBy RADIUS>
> Identifier Radius
> Host host.greennet.gl
> Secret <PASSWD>
> AuthPort 1645
> AcctPort 1646
> </AuthBy>
> </Realm>
>
> ____________________________________________________________________________
> ________________________________________
>
> 3:
>
> <Realm DEFAULT>
> MaxSessions 1
> AcctLogFileName %L/detail.log
> WtmpFileName %L/wtmp.log
> <AuthBy LDAP>
> Identifier Radius
> Host host.tele.gl
> Port 389
> AuthDN cn=Directory Manager
> AuthPassword <PASSWD>
> BaseDN o=greennet.gl
> UsernameAttr uid
> PasswordAttr userpassword
> </AuthBy>
> </Realm>
>
>
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from Lasse L. Johnsen
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
