Question about freeradius+mssql's empty radacct table

[fzhuxl]

Dear all,			
    I have setup my AAA(freeradius+mssql).Fortunately,everything goes ok（I can dialup now）,except the table named "radacct" in my radius datatabse(sqlserver 2k) is empty.
What I have done：
    1.installed:
        freeradius<->unixODBC+freeTDS<->SQL SERVER 2K
    2.configure the radiusd.conf
      　$INCLUDE ${confdir}/mssql.conf 

        authorize { 
           　　… 
             　　sql
           　　… 
              　　} 
    　　accouting { 
           　　… 
             　　sql 
             　　… 
              　　} 
    3. configure the mssql.conf 

         driver = "rlm_sql_unixodbc" 

         # Connect info 
            server = "blackboardDSN" 
            login = "tester" 
            password = "letmein" 

         # Database table configuration 
            radius_db = "radius" 

         # Print all SQL statements when in debug mode (-x) 
            sqltrace = no 
            sqltracefile = ${logdir}/sqltrace.sql 
    
    4. sql server2k database "radius" tables created: 
          usergroup,radcheck,redreply,radgroupcheck,radgroupreply,radacct,radreply,usergroup
       create user: "radius" 
       grant  "db_datareader","db_datawriter","public" to the new user--"radius".

  finally test:
    the dialing authentication is ok,but the dial-up log is not recorded in radacct table.It is totally empty!

  How can I get the dial-up log in radacct? I am appreciating help from you. 


Thanks and Regards


 
　　　　　　　　a55567 at 21cn.com
　　　　　　　　　　2007-08-18
-------------- next part --------------
A non-text attachment was scrubbed...
Name: radius_DB_script.sql
Type: application/octet-stream
Size: 7915 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-devel/attachments/20070818/3eae4f90/attachment.obj>