17.01.2012 15:13:22
Kun Li
Posts: 6
|
Hi Admin
I'm from TsingTao China.
I have a Radius(DigitalChina Radius) running now,but the User-data-table is following:
table name:UserParam(SQL2000)
userid|username|realname|password|usergroupid|exprdate......
1|01010111|likun|test|2|2012-5-31
Can I use the current datatable for TekRadius?
If use tekradius-database,I must split the row for 4 rows,example
username,attribute,attrtype,val
1,ietf|1,0,01010111
1,ietf|0,0,groupname
1,ietf|2,0,test
1,tekradius|2,0,2012-5-31
May i change the query sql and use the old database
for example
select * from UserParam where Username='??' and password='??' and exprdate>current_timestamp
but the key just one-param
I need your suggestion
thanks
|
|
|
0
• permalink
|
17.01.2012 16:05:30
Admin
Administrator
Posts: 1833
|
You can consider creating a view named "Authentication" which splits single row record to multiple row records. Please see;
http://www.dbforums.com/microsoft-sql-server/1608664-spliting-single-row-into-multiple-rows.html
|
|
|
0
• permalink
|
18.01.2012 06:18:22
Kun Li
Posts: 6
|
If that use more CPU and more hard-disk read and write?
It is about 3000 requests at 07:00am to 07:15am everyday.
If TekRadius can be supported?
Thank you.
|
|
|
0
• permalink
|
18.01.2012 11:09:07
Admin
Administrator
Posts: 1833
|
Yes, TekRADIUS can handle this load.
|
|
|
0
• permalink
|
18.01.2012 11:33:45
Kun Li
Posts: 6
|
Oh~~ Good
It will be Chinese New Year in 5 days
Best wishes!
Little English
Thank you very much.
|
|
|
0
• permalink
|
18.01.2012 13:14:26
Admin
Administrator
Posts: 1833
|
Happy Dragon Year
|
|
|
0
• permalink
|