--------------ms92503B8FAF75861AEC853925
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hello:
I just finishing evalutaing the RadiusNT 2.5.124. I have some
doubts:
My configuration:
WinNt 4 with SP3;
MS SQL Server 6.5 version 6.50.201
SQL-DMO version 6.05.02 (yes, 6.05.02)
SQL DB-Library version 6.50.252
ODBC SQL Server version 3.50.0305 (SQLSRV32.DLL - 11/07/97)
The Radius Nt configuration:
0) Mode: 1
1) IgnoreCase: 0
2) TrimName: 1
3) ReqAcctAuth: 0
4) AllowMalformed: 0
5) Proxy: 0
6) Options: 335
7) Debug: 0
8) LogFile:
9) AcctLogFile:
10) ODBCDatasource: radius
11) Username: Radius
12) Password: internet
13) AcctODBCDatasource:
14) AcctUsername:
15) AcctPassword:
16) DataDirectory: d:\radius
17) AcctDirectory: d:\radius\acct
18) UsersFile: Users
19) CompanyName:
20) License:
21) IPAddress: All
22) DBM: 1
Timebanking enabled.
When i used ODBC Access all works fine. I migrated to SQL and then the
timebanking stoped to update the TimeLeft filed on the SubAccount's
table.
I tried several configurations and no results. On the debug mode (15),
it shows the SQL statements (Update TimeLeft=TimeLeft-xx Where ......).
As I said, I tried all could i do. I tried to run this statement on the
SQL and it worked! My last option was to hex edit the RADIUS.EXE. I
found the code on the .EXE and changed this statement as test. For my
surprise, IT WORKED! I changed the statement to:
UPDATE SubAccounts Set TimeLeft=Timeleft-Round((%ld/60)+0.5,0) Where
TimeLeft>0 And Login='%s'
I noticed that my version of SQL doesn't recognize the word "NULL" or
something like that. That's because it wasn't working!
Another problem was that on the field Timeleft, the value are in
MINUTES, and when the update statement runs, subtracts in SECONDS.
That's so I put the Round((%ld/60)+0.5,0) on it.
I would like to know if this bug exists or it's only on my system.
Another question is:
I saw on the RadiusNT admin that has a option to "USE DIFFERENT
ACCOUNTING DSN". I would like to know which tables are necessary to put
on each database.
Regards,
Lee Wen
--------------ms92503B8FAF75861AEC853925
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature
MIIJrQYJKoZIhvcNAQcCoIIJnjCCCZoCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC
B68wggR5MIID4qADAgECAhBh7KzZNIh/tQpSGYvghKxKMA0GCSqGSIb3DQEBBAUAMIHMMRcw
FQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29y
azFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5
IFJlZi4sTElBQi5MVEQoYyk5ODFIMEYGA1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRp
dmlkdWFsIFN1YnNjcmliZXItUGVyc29uYSBOb3QgVmFsaWRhdGVkMB4XDTk4MDYzMDAwMDAw
MFoXDTk5MDYzMDIzNTk1OVowggEKMRcwFQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UE
CxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9y
ZXBvc2l0b3J5L1JQQSBJbmNvcnAuIGJ5IFJlZi4sTElBQi5MVEQoYyk5ODEeMBwGA1UECxMV
UGVyc29uYSBOb3QgVmFsaWRhdGVkMTMwMQYDVQQLEypEaWdpdGFsIElEIENsYXNzIDEgLSBO
ZXRzY2FwZSBGdWxsIFNlcnZpY2UxEDAOBgNVBAMTB0xlZSBXZW4xHzAdBgkqhkiG9w0BCQEW
EGxlZUBub2RlMS5jb20uYnIwXDANBgkqhkiG9w0BAQEFAANLADBIAkEAphB65VpzjNE5Njq3
PEvmZWtCK1g4ElR0oSLkuk2U75siiDtpSiPAKm3HPtFxmshNSRnUMdUdvvyh0wsnDcisIwID
AQABo4IBXTCCAVkwCQYDVR0TBAIwADCBrwYDVR0gBIGnMIAwgAYLYIZIAYb4RQEHAQEwgDAo
BggrBgEFBQcCARYcaHR0cHM6Ly93d3cudmVyaXNpZ24uY29tL0NQUzBiBggrBgEFBQcCAjBW
MBUWDlZlcmlTaWduLCBJbmMuMAMCAQEaPVZlcmlTaWduJ3MgQ1BTIGluY29ycC4gYnkgcmVm
ZXJlbmNlIGxpYWIuIGx0ZC4gKGMpOTcgVmVyaVNpZ24AAAAAAAAwEQYJYIZIAYb4QgEBBAQD
AgeAMIGGBgpghkgBhvhFAQYDBHgWdmQ0NjUyYmQ2M2YyMDQ3MDI5Mjk4NzYzYzlkMmYyNzUw
NjljNzM1OWJlZDFiMDU5ZGE3NWJjNGJjOTcwMTc0N2RhNWM0ZjMxNDFiZWFkYjNiYzZmODhh
MTBiMDZiZjFkNDExNDg5Y2EwYmE0M2Y0ZTU5MDY1NDEwDQYJKoZIhvcNAQEEBQADgYEAA/g3
pnPtoNmgWtc8DFH/EHVeXUw/YB2tsXPwN9roli19ThGYmE0dL5UjLIuswtrs8eqiKWm4C7pQ
X3OBjTlmGXcsoLmEV6UF2r2PftLiwekQ/HkVIBTBqdeAKnvsBiToqNabQtEsoqCfjmge/z8A
+TAKjLPt7VmnnGMXPX+Rk3swggMuMIICl6ADAgECAhEA0nYujRQMPX2yqCVdr+4NdTANBgkq
hkiG9w0BAQIFADBfMQswCQYDVQQGEwJVUzEXMBUGA1UEChMOVmVyaVNpZ24sIEluYy4xNzA1
BgNVBAsTLkNsYXNzIDEgUHVibGljIFByaW1hcnkgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkw
HhcNOTgwNTEyMDAwMDAwWhcNMDgwNTEyMjM1OTU5WjCBzDEXMBUGA1UEChMOVmVyaVNpZ24s
IEluYy4xHzAdBgNVBAsTFlZlcmlTaWduIFRydXN0IE5ldHdvcmsxRjBEBgNVBAsTPXd3dy52
ZXJpc2lnbi5jb20vcmVwb3NpdG9yeS9SUEEgSW5jb3JwLiBCeSBSZWYuLExJQUIuTFREKGMp
OTgxSDBGBgNVBAMTP1ZlcmlTaWduIENsYXNzIDEgQ0EgSW5kaXZpZHVhbCBTdWJzY3JpYmVy
LVBlcnNvbmEgTm90IFZhbGlkYXRlZDCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAu1pE
igQWu1X9A3qKLZRPFXg2uA1Ksm+cVL+86HcqnbnwaLuV2TFBcHqBS7lIE1YtxwjhhEKrwKKS
q0RcqkLwgg4C6S/7wju7vsknCl22sDZCM7VuVIhPh0q/Gdr5FegPh7Yc48zGmo5/aiSS4/zg
ZbqnsX7vyds3ashKyAkG5JkCAwEAAaN8MHowEQYJYIZIAYb4QgEBBAQDAgEGMEcGA1UdIARA
MD4wPAYLYIZIAYb4RQEHAQEwLTArBggrBgEFBQcCARYfd3d3LnZlcmlzaWduLmNvbS9yZXBv
c2l0b3J5L1JQQTAPBgNVHRMECDAGAQH/AgEAMAsGA1UdDwQEAwIBBjANBgkqhkiG9w0BAQIF
AAOBgQCIuDc73dqUNwCtqp/hgQFxHpJqbS/28Z3TymQ43BuYDAeGW4UVag+5SYWklfEXfWe0
fy0s3ZpCnsM+tI6q5QsG3vJWKvozx74Z11NMw73I4xe1pElCY+zCphcPXVgaSTyQXFWjZSAA
/Rgg5V+CprGoksVYasGNAzzrw80FopCubjGCAcYwggHCAgEBMIHhMIHMMRcwFQYDVQQKEw5W
ZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazFGMEQGA1UE
CxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5IFJlZi4sTElB
Qi5MVEQoYyk5ODFIMEYGA1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRpdmlkdWFsIFN1
YnNjcmliZXItUGVyc29uYSBOb3QgVmFsaWRhdGVkAhBh7KzZNIh/tQpSGYvghKxKMAkGBSsO
AwIaBQCgfTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw05ODEy
MTExOTI0MjFaMB4GCSqGSIb3DQEJDzERMA8wDQYIKoZIhvcNAwICASgwIwYJKoZIhvcNAQkE
MRYEFMMsABmTvs6/L7xlrtkNRnEPDLn8MA0GCSqGSIb3DQEBAQUABEBlGKA7g20CcG1EoU3e
YbHQlx6QqHPuVoVWM3sGuXSd5ehnwVLTUxy3E3ugnKyWnLaTw8wm6MqZFPWSsQm0uXoi
--------------ms92503B8FAF75861AEC853925--