In your table, what you have under the "min" column, is the actual number of seconds the users are connected. -----Original Message----- From: Md. Sifat Ullah Patwary [mailto:sifat@spnetctg.com] Sent: Wednesday, April 23, 2003 3:04 AM To: usr-tc@mailman.xmission.com Subject: [USR-TC] Wrong AcctSessionTime Dear List, Yesterday I configured a NETServer/16 V.34. Its working fine. But I found a problem with it. Its not giving acctsessiontime RADIUS correctly to its radius server. Everyting is correct except this. I tried to find the exact time elapsed by users second and found that no one is accurate. NETServer/16 is giving every entry wrong. Here is a result of query wich gives exact time (AcctStopTime-AcctStartTime) Vs. AcctSessionTime. I have more 2 Terminal Server one from PortMaster II and another is Cyclades PR3000. These two are giving the reading correctly but NETServer/16 is not. mysql> select acctstarttime,acctstoptime,unix_timestamp(acctstoptime)-unix_timestamp(accts tarttime) min,acctsessiontime sec from radacct where nasipaddress='2x.18x.2x.1x' and acctsessiontime>5000 limit 10; +---------------------+---------------------+-------+------------+ | acctstarttime | acctstoptime | min | sec | +---------------------+---------------------+-------+------------+ | 2003-04-22 21:54:47 | 2003-04-22 23:20:15 | 5128 | 6200 | | 2003-04-22 21:56:30 | 2003-04-22 23:16:15 | 4785 | 5502 | | 2003-04-22 22:31:22 | 2003-04-22 23:49:15 | 4673 | 5405 | | 2003-04-22 22:52:26 | 2003-04-23 02:37:23 | 13497 | 34748 | | 2003-04-22 23:50:52 | 2003-04-23 01:25:19 | 5667 | 6732 | | 2003-04-23 00:36:33 | 2003-04-23 03:05:21 | 8928 | 31606 | | 2003-04-23 01:26:35 | 2003-04-23 01:32:50 | 375 | 20208 | | 2003-04-23 13:26:16 | 2003-04-23 13:30:27 | 251 | 2147483647 | +---------------------+---------------------+-------+------------+ 8 rows in set (0.01 sec) NAS '2x.18x.2x.1x' is NETServer/16 V.34 I like to know what I did wrong/ whats the way to fix the problem. Sifat _______________________________________________ USR-TC mailing list USR-TC@mailman.xmission.com http://mailman.xmission.com/cgi-bin/mailman/listinfo/usr-tc