(RADIATOR) Radusage table not updated.
Hugh Irvine
hugh at open.com.au
Mon Jul 21 19:49:56 CDT 2003
Hello Michael -
Can you please tell me what versions of Radiator and Radmin you are
running?
Latest versions are Radiator 3.6 (plus patches) and Radmin 1.7 (plus
patches).
regards
Hugh
On Tuesday, Jul 22, 2003, at 10:38 Australia/Melbourne, Michael
Bellears wrote:
> Hi Hugh,
>
>>
>> The problem is due to the incorrect quoting of the string containing
>> the "@" sign.
>
> Ok.
>
>> In most clauses based on SQL, %0 can be used for the username string
>> and it will always be correctly quoted.
>
> As Radmin is being used for Acct., how would I modify the insert
> clause?(In the radmin.cfg, or would it require source-file mod?)
>
> Thanks for your assistance.
>
> Regards,
> MB
>
>> regards
>>
>> Hugh
>>
>>
>> On Monday, Jul 21, 2003, at 20:24 Australia/Melbourne,
>> Michael Bellears
>> wrote:
>>
>>>
>>> Hi Hugh,
>>>
>>>>
>>>> You should try the queries by hand to see what is happening.
>>>>
>>>
>>> Upon further investigation, it appears as though the '@' in the
>>> username is causing the problem:
>>>
>>> Success without '@'
>>>
>>> mysql> insert into RADUSAGE
>>>
>> (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,C
>>> l
>>>
>> ient_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUT
>> OCTETS,AC
>>> CTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER)
>>> values (1,'31200
>>> LAPM/
>>>
>> V42BIS',344121,1058742326,'connect_test','755798217','203.149.
>> 64.50',0,
>>> '55849500',28682053,2,'800006D0',89390039,3,'203.149.64.3');
>>> Query OK, 1 row affected (0.01 sec)
>>>
>>> mysql> select
>>>
>> USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASI
>>> D
>>> ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME =
>>> 'connect_test' order by TIME_STAMP;
>>> +--------------+------------+---------------+-----------------
>>> +-----------------+---------------+---------+----------------+
>>> | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME |
>>> FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE |
>>> +--------------+------------+---------------+-----------------
>>> +-----------------+---------------+---------+----------------+
>>> | connect_test | 1058742326 | 800006D0 | 344121 |
>>> 203.149.64.50 | 203.149.64.3 | 3 | 2 |
>>> +--------------+------------+---------------+-----------------
>>> +-----------------+---------------+---------+----------------+
>>> 1 row in set (0.00 sec)
>>>
>>> Failure with '@'
>>>
>>> mysql> insert into RADUSAGE
>>>
>> (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,C
>>> l
>>>
>> ient_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUT
>> OCTETS,AC
>>> CTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER)
>>> values (1,'31200
>>> LAPM/
>>>
>> V42BIS',344121,1058742326,'connect_test at dsl.datafx.com.au','75
>> 5798217',
>>>
>> '203.149.64.50',0,'55849500',28682053,2,'800006D0',89390039,3,
>> '203.149.
>>> 64.3');
>>> Query OK, 1 row affected (0.00 sec)
>>>
>>> mysql> select
>>>
>> USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASI
>>> D
>>> ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME =
>>> 'connect_test at datafx.com.au' order by TIME_STAMP;
>>> Empty set (0.00 sec)
>>>
>>> Insert with correct data, but removing the '@' from username:
>>>
>>> mysql> insert into RADUSAGE
>>>
>> (ACCTTERMINATECAUSE,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone_N
>>> u
>>>
>> mber,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTST
>> ATUSTYPE,
>>> ACCTOUTPUTOCTETS,ACCTSESSIONID,NASPORT,NASIDENTIFIER) values
>>> (18,21210,1058781354,'connect_test','atm
>>> 11','203.149.70.10',0,'3:2.261#184571819##speed:UBR:256#/
>>> ',74104,2,77696,'00009813',1,'203.63.121.145');
>>> Query OK, 1 row affected (0.00 sec)
>>>
>>> mysql> select
>>>
>> USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASI
>>> D
>>> ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME =
>>> 'connect_test' order by TIME_STAMP;
>>> +--------------+------------+---------------+-----------------
>>> +-----------------+----------------+---------+----------------+
>>> | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME |
>>> FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE |
>>> +--------------+------------+---------------+-----------------
>>> +-----------------+----------------+---------+----------------+
>>> | connect_test | 1058742326 | 800006D0 | 344121 |
>>> 203.149.64.50 | 203.149.64.3 | 3 | 2 |
>>> | connect_test | 1058781354 | 00009813 | 21210 |
>>> 203.149.70.10 | 203.63.121.145 | 1 | 2 |
>>> +--------------+------------+---------------+-----------------
>>> +-----------------+----------------+---------+----------------+
>>> 2 rows in set (0.00 sec)
>>>
>>> Any suggestions on how to get around this? (I would like
>> the username
>>> to be inserted with the '@dsl.datafx.com.au' if possible)
>>>
>>> Thanks in advance,
>>> MB
>>>
>>>>
>>>>
>>>> On Saturday, Jul 19, 2003, at 08:43 Australia/Melbourne, Michael
>>>> Bellears wrote:
>>>>
>>>>> Radiator/Radmin is auth/acct for dialup users
>> (MAX6000/PM3's), and
>>>>> also DSL users(Cisco7200).
>>>>>
>>>>> Dialup users acct data is successfully updated in the
>>>> RADUSAGE table,
>>>>> but DSL clients are not(RADONLINE is working for both).
>>>>>
>>>>> I see the insert in trace4:
>>>>>
>>>>> Sat Jul 19 08:05:51 2003: DEBUG: do query is: insert into RADUSAGE
>>>>>
>>>> (TIME_STAMP,USERNAME,ACCTDELAYTIME,DNIS,ACCTSTATUSTYPE,ACCTSES
>>>> SIONID,NA
>>>>> SPORT,NASIDENTIFIER) values
>>>>>
>>>> (1058565951,'connect_test at dsl.datafx.com.au',0,'3:2.261#184571
>>>> 819##spee
>>>>> d:UBR:256#/',1,'0000980F',1,'203.63.121.145')
>>>>>
>>>>> And also the insert in the mysql logs:
>>>>>
>>>>> 88528 Query insert into RADUSAGE
>>>>>
>>>> (TIME_STAMP,USERNAME,ACCTDELAYTIME,DNIS,ACCTSTATUSTYPE,ACCTSES
>>>> SIONID,NA
>>>>> SPORT,NASIDENTIFIER) values
>>>>>
>>>> (1058565951,'connect_test at dsl.datafx.com.au',0,'3:2.261#184571
>>>> 819##spee
>>>>> d:UBR:256#/',1,'0000980F',1,'203.63.121.145')
>>>>>
>>>>> But no results via Radmin Web Interface, or via CLI:
>>>>>
>>>>> mysql> select
>>>>>
>>>> USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDR
>>>> ESS,NASID
>>>>> ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME =
>>>>> 'connect_test at dsl.datafx.com.au' order by TIME_STAMP;
>> ERROR 1032:
>>>>> Can't find record in 'RADUSAGE'
>>>>>
>>>>> I see no errors in mysql.err log.
>>>>>
>>>>> A dialup users succesful insert FYR:
>>>>>
>>>>> Trcae4:
>>>>> Sat Jul 19 08:06:17 2003: DEBUG: do query is: insert into RADUSAGE
>>>>>
>>>> (Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone
>>>> _Number,F
>>>>>
>>>> RAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTSTATUSTY
>>>> PE,ACCTSE
>>>>> SSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) values
>>>>>
>>>> ('49333',863,1058565977,'eplan','755103035','203.149.64.51',0,
>>>> '55848000
>>>>> ',10315,2,'425834844',45523,20206,'203.149.64.4')
>>>>>
>>>>> MySQL Log:
>>>>> 88528 Query insert into RADUSAGE
>>>>>
>>>> (Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone
>>>> _Number,F
>>>>>
>>>> RAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTSTATUSTY
>>>> PE,ACCTSE
>>>>> SSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) values
>>>>>
>>>> ('49333',863,1058565977,'eplan','755103035','203.149.64.51',0,
>>>> '55848000
>>>>> ',10315,2,'425834844',45523,20206,'203.149.64.4')
>>>>>
>>>>> Thanks in advance.
>>>>>
>>>>> Regards,
>>>>> MB
>>>>> ===
>>>>> 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.
>>>>
>>>>
>>>
>>>
>>
>> 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.
>>
>>
>
>
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.
More information about the radiator
mailing list