Voucher time based not working as expected

[Ferrarotti Luca]

Hi Dirk,

I would like to make my compliment about the project. It's a very awesome result.
I'm working with it about some months and it's very great.

Actually I'm experiencing some troubles about vouchers time based.
I had created a profile with one hour a day with the daily reset.
But if I consume more the time expected the login is still usable in the same day.

Using the log file viewer when I made a check with voucher data based no prblems, but when I made a check with the other one, I saw this error :

Error : rlm_sql (sql),database query error, SELECT IFNULL(SUM(acctsessiontime - GREATEST((1383350400 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='000001' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1383350400',You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM radacct WHERE username='000001' AND UNIX_TIMESTAMP(acctstarttime) + acctses' at line 1 .

Actually I'm using the latest svn revision r571, this a known bug or I made some mistakes during the setup?

Any kind of suggestion would be appreciated.

Best regards

Luca

[fridaystreet]

Hi Luca,

I think your issue is related to/the same as mine here https://sourceforge.net/p/radiusdesk/discussion/help/thread/17c519eb/

Basically the way it is calculating the time used from login needs to take in to account the Rd-Total-Time attribute of the profile, which currently it's not doing.

Cheers
Paul

[Ferrarotti Luca]

Hi Paul,

many thanks about this. I would like to test your modification about the other thread.

Regards

Luca