>It doesn't work on postgresql v7.4.6 that I tried it on.. howver, I
used
>
>"SELECT now() - AcctStartTime FROM radacct WHERE UserName = '%{%k}'
>LIMIT 1;"
>
Be carefull with this!!!!!
"SELECT now() - AcctStartTime Secs
FROM radacct
WHERE UserName = '%{k}' LIMIT 1;"
Gives for example with username 'test':
+-----------+
| Secs |
+-----------+
| 684042112 |
+-----------+
Recalculated in days: 7917,1540740740740740740740740741 days....
Is NOT the same as:
"SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(AcctStartTime) Secs
FROM radacct
WHERE UserName = '%{%k}' LIMIT 1"
Gives for example with username 'test':
+----------+
| Secs |
+----------+
| 17119330 |
+----------+
Recalculated in days: 198,14039351851851851851851851852
198days is the correct calculation...
So as you can see, it isn't the same, at least in MySQL, don't know with
other databases.
So before you you begin: think, try and check your things.
J.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
