(RADIATOR) Radusage table not updated.
Michael Bellears
mbellears at staff.datafx.com.au
Mon Jul 21 19:59:28 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).
Certainly Hugh:
Radiator-3.5(No patches)
RAdmin 1.7(No Patches)
Regards,
MB
>
> 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,NAS
> >> I
> >>> 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,NAS
> >> I
> >>> 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,NAS
> >> I
> >>> 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