Hello Ganbold -
OK - having looked at the code in AuthSQL.pm, it appears that the problem is due to your AcctColumnDef:
You have specified "integer" which is causing the problem - you might try "literal" instead.AcctColumnDef
class_id,Class,integer,substring('%{Class}',1,locate('- ','%{Class}')-> 1)
AcctColumnDef
CONTRACTID,Class,integer,substring('%{Class}',locate('-> ','%{Class}')+1)
...
Have a look at section 6.28.14 in the Radiator 3.3.1 reference manual.
regards
Hugh
On Monday, Nov 25, 2002, at 12:39 Australia/Melbourne, Ganbold wrote:
Hi Hugh,
I changed as you suggested '-' into ':', but it seems like still error.
Mon Nov 25 10:11:01 2002: ERR: There is no value named 16:3049 for attribute Class. Using 0.
Mon Nov 25 10:11:01 2002: ERR: There is no value named 16:3049 for attribute Class. Using 0.
Mon Nov 25 10:11:01 2002: DEBUG: do query is: insert into ACCOUNTING (USERNAME,ACCTSTATUSTYPE,class_id,TIME_STAMP,NASPORT,CALLINGSTATIONID,A CCTDELAYTIME,CONTRACTID,ACCTSESSIONID,ACCTINPUTOCTETS,FRAMEDIPADDRESS,A CCTSESSIONTIME,ACCTOUTPUTOCTETS) values ('ynbstone','Stop',substring('16:3049',1,locate(':','16:3049')- 1),1038190261,'434','11305106',0,substring('16:3049',locate(':','16:304 9')+1),'00001D6F',1631,'202.179.xx.xx',18,836)
Ganbold
At 09:47 AM 11/25/2002 +1100, you wrote:
Hello Ganbold - I think a better approach would be to use a different delimiter than "-", which I suspect is confusing things.What about using ":" (colon) instead? Please try it and let me know what happens. regards Hugh On Sunday, Nov 24, 2002, at 17:45 Australia/Melbourne, Ganbold wrote:Hi Hugh,
Following is the part of the radius config file where I'm
concatenating 2 integer values into one string and putting into 2
integer field from
concatenated string:
.....
AuthSelect select
ENCRYPTEDPASSWORD,CHECKATTR,REPLYATTR,concat(CLASS_ID,'-',CONTRACTID)
from SUBSCRIBERS where USERNAME='%n' and STATUS='Active'
EncryptedPassword
AuthColumnDef 0, Encrypted-Password, check
AuthColumnDef 1, GENERIC, check
AuthColumnDef 2, GENERIC, reply
AuthColumnDef 3, Class, reply
...
AcctColumnDef
class_id,Class,integer,substring('%{Class}',1,locate('- ','%{Class}')-> 1)
AcctColumnDef
CONTRACTID,Class,integer,substring('%{Class}',locate('-> ','%{Class}')+1)
...
In dictionary file Class is defined as string.
Ganbold
At 03:24 PM 11/23/2002 +1100, you wrote:
Hello Ganbold -
What definition do you have for "Class" in your dictionary (looks like
"integer")?
It should be defined as "string".
Here is the entry from the standard dictionary:
ATTRIBUTE Class 25 string
regards
Hugh
On Friday, Nov 22, 2002, at 17:20 Australia/Melbourne, Ganbold wrote:
Hi,--
I'm having trouble with Radiator 3.3.1. I'm putting concatenated
value
to Class attribute.
But in radius logfile it says ERR: There is no value named 19-400 for
attribute Class. Using 0.
In insert statement it gets Class value and gets part of string and
puts into 2 different int field.
Following is the part of logfile and insert statement.
Ganbold
------Logfile --------------------------
Thu Nov 21 19:53:08 2002: ERR: There is no value named 19-400 for
attribute Class. Using 0.
Thu Nov 21 19:53:08 2002: ERR: There is no value named 19-400 for
attribute Class. Using 0.
Thu Nov 21 19:53:08 2002: DEBUG: do query is: insert into ACCOUNTING
(USERNAME,ACCTSTATUSTYPE,class_id,TIME_STAMP,ACCTTERMINAT
ECAUSE,NASPORT,CALLINGSTATIONID,ACCTDELAYTIME,CONTRACTID,ACCTSESSIO NI D, ACCTINPUTOCTETS,FRAMEDIPADDRESS,ACCTSESSIONTIME,ACCTOUT
PUTOCTETS) values
('skytel','Stop',substring('19-400',1,locate('-','19-400')-
1),1037879588,'User-Request','56','11366801',0,su
bstring('19-400',locate('-','19-
400')+1),'000F6CE3',511690,'202.179.x.xx',3131,7864103)
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
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.
-- 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
-- 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
