[RADIATOR] Accounting by SQL and Authentication by ADSI
Hi: I want to authenticate my users using ADSI and Record all the acounting Data in an SQL server. The authentication work well but i can not record the accounting data. Below are a portion of my radius.cfg. BindStringLDAP://cn=%0,cn=Users,dc=mizona,dc=iasprueba,dc=com # Adjust DBSource, DBUsername, DBAuth to suit your DB DBSourcedbi:ODBC:Datalnet DBUsernameradiatorlog DBAuth radiatorlog AccountingTable ACCOUNTING 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 ACCTTERMINATECAUSE,Ascend-Disconnect- Cause,integer AcctColumnDef FRAMEDIPADDRESS,Framed-Address AcctColumnDef NASIDENTIFIER,NAS-Identifier AcctColumnDef NASPORT,NAS-Port,integer thanks Adrian ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
[RADIATOR] ADSI Authentication problem
* Hi: I'm configuring radiator to use ADSI Authentication as indicated below: * RewriteUsernames/^([...@]+).*/$1/ # Adjust DBSource, DBUsername, DBAuth to suit your DB DBSourcedbi:ODBC:MyDatasource DBUsernamemyusername DBAuth mypassword AccountingTable ACCOUNTING 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 ACCTTERMINATECAUSE,Ascend-Disconnect-Cause,integer AcctColumnDef FRAMEDIPADDRESS,Framed-Address AcctColumnDef NASIDENTIFIER,NAS-Identifier AcctColumnDef NASPORT,NAS-Port,integer BindString LDAP://cn=%0,ou=QA,dc=YouRoam,dc=com *The problem is that I obtain the following error messages when Radiator try to authenticate the user. Can any one tell me what's wrong. * Fri Aug 6 19:08:01 2010: DEBUG: Handling request with Handler '' Fri Aug 6 19:08:01 2010: DEBUG: Deleting session for qausernewserv3...@youroam .com, 192.168.124.254, 3772 Fri Aug 6 19:08:01 2010: DEBUG: Handling with ADSI Fri Aug 6 19:08:01 2010: DEBUG: BindString converted to LDAP://cn=qausernewserv 3810,ou=QA,dc=YouRoam,dc=com Fri Aug 6 19:08:01 2010: DEBUG: AuthUser converted to qausernewserv3810 Fri Aug 6 19:08:01 2010: DEBUG: Connecting to namespace: LDAP: Fri Aug 6 19:08:01 2010: DEBUG: Running OpenDSObject on LDAP://cn=qausernewserv 3810,ou=QA,dc=YouRoam,dc=com Fri Aug 6 19:08:01 2010: DEBUG: Could not get user object: Win32::OLE(0.1709) e rror 0x8007052e: "Logon failure: unknown user name or bad password" in METHOD/PROPERTYGET "OpenDSObject" Fri Aug 6 19:08:01 2010: DEBUG: AuthBy ADSI result: REJECT, Could not find user Fri Aug 6 19:08:01 2010: INFO: Access rejected for qausernewserv3810: Could not find user Fri Aug 6 19:08:01 2010: DEBUG: Packet dump: ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
[RADIATOR] Run radiator as a service in 64 platforms
Hi: How can I run Radiator as a service in Windows 2003 64 bits? Regards Adrian ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
[RADIATOR] Radiator and Active directory 2008
Hello: I have two Server with the same Radiator configuration. The server with AD 2003 work fine but the server with AD 2008 didn't authenticate the user using ADSI. There is some issue between Radiator and Active directory 2008?. regards. Adrian ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
[RADIATOR] AD 2008 schema and ADSI auth
Hi Hugh: Any update regarding the Radiator issue with AD 2008 schema and ADSI auth ? Regards, Adrian ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
[RADIATOR] SQL accounting problem
Hi : I have a problem with the SQL accounting. Radiator do not process the accounting- request. Below are my radius.cfg and the trace 4. I have checked the ports on my server and are ok. I'm using port 1812 for Radius and 1813 for accounting. # windows.cfg # # Example Radiator configuration file. # This very simple file will allow you to get started with # a simple system on Windows. You can then add and change features. # We suggest you start simple, prove to yourself that it # works and then develop a more complicated configuration. # # This example is expected to be installed in # c:\Program Files\Radiator\radius.cfg # It will authenticate from a standard users file in # c:\Program Files\Radiator\users # it will log debug and other messages to # c:\Program Files\Radiator\logfile # and log accounting to a file in # c:\Program Files\Radiator\detail # (of course you can change all these by editing this config file if you wish) # # It will accept requests from any client and try to handle requests # for any realm. # And it will print out what its doing in great detail to the log file. # # See radius.cfg for more complete examples of features and # syntax, and refer to the reference manual for a complete description # of all the features and syntax. # # You should consider this file to be a starting point only # $Id: windows.cfg,v 1.1 2003/03/27 09:41:28 mikem Exp $ Foreground LogStdout LogDirc:/Program Files/Radiator DbDirc:/Program Files/Radiator AuthPort1812 AcctPort1813 # This will log at DEBUG level: very verbose # User a lower trace level in production systems, typically use 3 Trace 4 # You will probably want to add other Clients to suit your site, # one for each NAS you want to work with. This will work # at least with radpwtst running on the local machine Secret ## Secret # # Authenticate all realms with this # LDAP, LDAP2 and LDAPSDK are all basically the same # but they use different LDAP modules: # LDAP uses Net::LDAPapi (which is now deprecated. Dont use #this for new installation102s) # LDAP2 uses the newer Net::LDAP in perl-ldap-0.09 or better # LDAPSDK uses the Netscape PerLDAP SDK(which is easily availble # for ActiveState Perl on NT) # # You must install the required perl module before you # can use this authentication method. # If you want to test AuthBy LDAP, uncomment and configure this Realm # RewriteUsernames/^([...@]+).*/$1/ # Adjust DBSource, DBUsername, DBAuth to suit your DB DBSourcedbi:ODBC:YouRoam DBUsername# DBAuth ### AccountingTable ACCOUNTING 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 ACCTTERMINATECAUSE,Ascend-Disconnect-Cause,integer AcctColumnDef FRAMEDIPADDRESS,Framed-Address AcctColumnDef NASIDENTIFIER,NAS-Identifier AcctColumnDef NASPORT,NAS-Port,integer AcctColumnDef GlobalRoamingWasZone,GlobalRoaming-Was-Zone AcctColumnDef GlobalRoamingUnitsUsed, GlobalRoaming-Units-Used, integer Host SourceIT.Youroam.com AuthDN YOUROAM\iasprueba AuthPassword # BaseDN cn=Users, dc=Youroam, dc=com UsernameAttr cn AuthAttrDef GlobalRoamingMaxUnitsA,GlobalRoaming-Max-Units,reply # *Trace 4:* C:\Users\administrator.YOUROAM>perl c:\perl64\bin\radiusd Thu Sep 16 18:48:11 2010: WARNING: No PasswordAttr or EncryptedPasswordAttr defi ned for AuthLDAP2 at 'C:\Program Files\Radiator\radius.cfg' line Thu Sep 16 18:48:11 2010: DEBUG: Finished reading configuration file 'C:\Program Files\Radiator\radius.cfg' This Radiator license will expire on 2011-02-01 This Radiator license will stop operating after 1000 requests To purchase an unlimited full source version of Radiator, see http://www.open.com.au/ordering.html To extend your license period, contact ad...@open.com.au Thu Sep 16 18:48:11 2010: DEBUG: Reading dictionary file 'c:/Program Files/Radia tor/dictionary' Thu Sep 16 18:48:12 2010: DEBUG: Creating authentication port 0.0.0.0:1812 Thu Sep 16 18:48:12 2010: DEBUG: Creating accounting port 0.0.0.0:1813 Thu Sep 16 18:48:12 2010: NOTICE: Server started: Radiator 4.6 on SOURCEIT (LOCK ED) Thu Sep 16 18:48:27 2010: DEBUG: Rewrote user name to iasprueba Thu Sep 16 18:48:27 2010: DEBUG: Packet dump: *** Received from 80.231.58.22 port 1814 Code: Access-Request Identifier: 92 Authentic: <234>V<168>5D<170><151><153>%<150><168>[<166><244>-<
(RADIATOR) Simultaneous Use with Accounting Stops set only?
Hi, I have a simple set up using Radiator 2.15 and with DefaultSimultaneousUse 1 AccountingStopsOnly set in the AuthBy SQL clause. However, when I set the Simultaneous-Use=2 in the CheckAttr Field of the subscribers table, it does not work as the session is still limited to 1. The documentation says that Simultaneous-Use keeps track of the number of sessions by counting the accounting start and Stop requests for that user which is probably why it does not work. Is there any other method of achieving simultaneous use for some subscribers while still having only Accounting Stops Only? Thanks Adrian === 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.
[RADIATOR] log to SQL
Hello: I trying to send the radiator log information to SQL database. I need information about the parameters that can I use in the SQL query. for example when we said insert into %3 (TIME_STAMP, PRIORITY, MESSAGE) values (%t, %0, &2) whats means %3, %0, %2. where I can find an equivalent of this parameters. Can some help me ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
[RADIATOR] Log SQL
Hi: I trying to configure the logSQL feature in Radiator. I put the code below inside the realm as indicated on the manual. The problem is that I not receiving any data in My SQL server. I test the SQL database with other application and work well. DBSource dbi:mSQL:Radiatorlogsql DBUSernameradiatorlog DBAuth radiatorlog Table RADLOG LogQuery insert into %3 (TIME_STAMP, PRIORITY, MESSAGE) values (%t, %0, %2) The Radiatorlogsql database is in the SQL server and the Server is using SQL authentication. My first question is: Is correct the code over this lines? I need an extra module to proper interface Radiator with SQL server than the default installed with perl? I can debug the SQLlog process?. thanks ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
