[RadiusNT] Time Banking problem

Gokhan Cetinkaya ( gokhan@prizma.net.tr )
Mon, 19 Apr 1999 19:03:50 +0300

This is a cryptographically signed message in MIME format.

--------------ms4A4D63AF56C6DC963251D94C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

hi,
i am testing RadiusNT 2.5.162 in ODBC mode. (with SQL Server 6.5)
i enabled Time Banking and checked Manual Service Update option in the
RadiusNT admin. i see the update statement in -x15 mode;

SQL Statement: UPDATE SubAccounts Set TimeLeft=TimeLeft-11 Where
TimeLeft<>Null
And TimeLeft<>-9999 And Login='test'

but the timeleft field in the subaccounts table does NOT change!!

any ideas??

(by the way, if i execute the query directly on the SQL Query tool, it
works just fine..)

Thank you
_____________________________________________________________________
Gokhan Cetinkaya gokhan@prizma.net.tr
http://www.prizma.net.tr Tel:+90-212-2279858
http://pusula.net Fax:+90-212-2596939
http://www.emlak.net http://bogaztv.prizma.net.tr

--------------ms4A4D63AF56C6DC963251D94C
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

MIIHpQYJKoZIhvcNAQcCoIIHljCCB5ICAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC
BcgwggKHMIIB8KADAgECAgJSFjANBgkqhkiG9w0BAQQFADCBuTELMAkGA1UEBhMCWkExFTAT
BgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxGjAYBgNVBAoTEVRo
YXd0ZSBDb25zdWx0aW5nMSkwJwYDVQQLEyBUaGF3dGUgUEYgUlNBIElLIDE5OTguOS4xNiAx
Nzo1NTE2MDQGA1UEAxMtVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIFJTQSBJc3N1ZXIgMTk5
OC45LjE2MB4XDTk4MTEyNzA5NDEzNVoXDTk5MTEyNzA5NDEzNVowRjEfMB0GA1UEAxMWVGhh
d3RlIEZyZWVtYWlsIE1lbWJlcjEjMCEGCSqGSIb3DQEJARYUZ29raGFuQHByaXptYS5uZXQu
dHIwXDANBgkqhkiG9w0BAQEFAANLADBIAkEA2/BLV6UckovCWZM8mf+cBpkyj1R8ojNwQBeJ
4ykcpJfXZiUKxzOKdWCLpRLlxWo5kU0W7+TtuP42Pe2sDZrFnwIDAQABo1QwUjARBglghkgB
hvhCAQEEBAMCBaAwDgYDVR0PAQH/BAQDAgWgMAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAU
/j5gnGuMD7DYM8bKxh5YsHE4teAwDQYJKoZIhvcNAQEEBQADgYEAnVRW/mnsoPOmPo+BAYKL
SknamSLaiUKcUPQ8C1v26+IoEelYSu8eLaUtCZLxpELNeSEtc1/8OpvmPM915Qp07uy84/d1
cYnGGhZLGdFJzcSe3E0p3WVguMRyyBM6dT0DhDzXqlViSzrrDx6PXutXjR1d7P2y5UzCEO07
je3bZ9kwggM5MIICoqADAgECAgEKMA0GCSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEV
MBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRo
YXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlz
aW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0B
CQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNOTgwOTE2MTc1NTM0WhcNMDAw
OTE1MTc1NTM0WjCBuTELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIG
A1UEBxMLRHVyYmFudmlsbGUxGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSkwJwYDVQQL
EyBUaGF3dGUgUEYgUlNBIElLIDE5OTguOS4xNiAxNzo1NTE2MDQGA1UEAxMtVGhhd3RlIFBl
cnNvbmFsIEZyZWVtYWlsIFJTQSBJc3N1ZXIgMTk5OC45LjE2MIGfMA0GCSqGSIb3DQEBAQUA
A4GNADCBiQKBgQDEpeXU1NBfCALuByF9JL+ra44e6yAHAhWEa4/QkyQfG53uaLK5LE/pk2cX
EBceoflDQSO5MKp2l7vz5/2BwLUxi/amUCZU8pUo6xmkHpcesOK4m8EEmjLQPAlsT+Q1T/B2
vwATA09FCGDz/LTQkAGKEsmcun9S6iqTNTY8POQ1LwIDAQABozcwNTASBgNVHRMBAf8ECDAG
AQH/AgEAMB8GA1UdIwQYMBaAFHJJwnM0xlX0C3ZygX539IfnxrIOMA0GCSqGSIb3DQEBBAUA
A4GBACzHgh8BQz4Hj+5pXKlkgvjAlq2TK8ubUNdAmoHCuqZ2nTyVQNxVweFVgnmrCimm1Qzh
Vyg+j/m71d8Nk1iqWy2LjzPk3VgVNXZyFSm9QvRakgt3X50n25otThuCBo7SjVa7ld7bDGUF
3pWeAt1TF76+/GvDGiJ6FCthvcKfXnpaMYIBpTCCAaECAQEwgcAwgbkxCzAJBgNVBAYTAlpB
MRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcTC0R1cmJhbnZpbGxlMRowGAYDVQQK
ExFUaGF3dGUgQ29uc3VsdGluZzEpMCcGA1UECxMgVGhhd3RlIFBGIFJTQSBJSyAxOTk4Ljku
MTYgMTc6NTUxNjA0BgNVBAMTLVRoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBSU0EgSXNzdWVy
IDE5OTguOS4xNgICUhYwCQYFKw4DAhoFAKB9MBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEw
HAYJKoZIhvcNAQkFMQ8XDTk5MDQxOTE2MDM1MlowHgYJKoZIhvcNAQkPMREwDzANBggqhkiG
9w0DAgIBKDAjBgkqhkiG9w0BCQQxFgQUH6Rgu9qB/xJHbJBGk2Cl/zf1lDkwDQYJKoZIhvcN
AQEBBQAEQD5gWT02OQIS5W194UB7uID2h2UtWqzF/XdT8+RYcuJ+jF63wPxiZ33JXN/OOx6N
fglC9/TLasa6ONyd3na/F4E=
--------------ms4A4D63AF56C6DC963251D94C--