Problem Accounting with PostGreSQL

mehtap at comu.edu.tr mehtap at comu.edu.tr
Tue Oct 14 15:57:07 CEST 2008


Hi,

We are using PostGreSQL for accounting. But when we made a query, we saw
all tables are empty except "radpostauth" and we need informations about
"radacct" table. So, when we were using FreeRADIUS 1.1.7, we changed
"postgresql.conf"'s  last comment like that:

      We changed this comment:

 postauth_query = "INSERT INTO ${postauth_table} (username, pass, reply,
authdate) VALUES ('%{User-Name}', '%{User-Password:-Chap-Password}',
'%{reply:Packet-Type}', NOW())"

        like that:

postauth_query = "INSERT into ${acct_table1} \
               (AcctSessionId, AcctUniqueId, UserName, Realm,
NASIPAddress, NASPortId, NASPortType, AcctStartTime,
AcctAuthentic, \
               ConnectInfo_start, CalledStationId, CallingStationId,
ServiceType, FramedProtocol, FramedIPAddress,
AcctStartDelay, XAscendSessionSvrKey) \
               values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', \
               '%{NAS-Port}', '%{NAS-Port-Type}', ('%S'::timestamp -
'%{Acct-Delay-Time:-0}'::interval), '%{Acct-Authentic}',
'%{Connect-Info}', \
               '%{Called-Station-Id}', '%{Calling-Station-Id}',
'%{Service-Type}', '%{Framed-Protocol}', \
               NULLIF('%{Framed-IP-Address}', '')::inet, 0,
'%{X-Ascend-Session-Svr-Key}')"

And it worked:)
But now, we are using FreeRADIUS 2.0.4 and when we have changed
"postgresql.conf" like over, it doesn't work. When someone tries to
connect with FreeRADIUS, it gives "Login Incorrect" message.

Is there any link including a solution about my problem?





More information about the Freeradius-Users mailing list