Re: Timezone settings?

2006-07-27 Thread Alan DeKok
"Khoa Nguyen" <[EMAIL PROTECTED]> wrote:
> The radius message from a client has Event-Timestamp displayed as
> local EDT time, but when Radiusd proccesses the message, the
> Event-Timestamp was converted to UTC time (as shown in the radacct
> detail log files). How can I disable this? I checked the timezone
> setting on the freeradius server machine, and it was set to EDT. Is
> there a config parameter that tells freeradius not to alter the
> Event-Timestamp?

  Times *are* in UTC.  There isn't a configuration option to print
times in local time zone, unfortunately.

  And if you're runnign 0.9.3, you should really upgrade...

  Alan DeKok.
--
  http://deployingradius.com   - The web site of the book
  http://deployingradius.com/blog/ - The blog
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Timezone settings?

2006-07-27 Thread Khoa Nguyen

Hi,

I am using freeradius-0.9.3 with postgres 7.4.11. I have the following issue:

The radius message from a client has Event-Timestamp displayed as
local EDT time, but when Radiusd proccesses the message, the
Event-Timestamp was converted to UTC time (as shown in the radacct
detail log files). How can I disable this? I checked the timezone
setting on the freeradius server machine, and it was set to EDT. Is
there a config parameter that tells freeradius not to alter the
Event-Timestamp?

Thanks,
Khoa
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Timezone support

2005-10-30 Thread Gunther
I'm using FreeRadius 1.0.5 with MySQL 4.1.10. I am looking for a solution
for timezone support over several timezones.

There are probably several ways of doing this:
1. Set server with FreeRadius to the particular fixed timezone e.g. GMT 2.
Set MySQL to a fixed timezone (my.cnf timezone= ...) 3. others ...

Where are timezones used:
- System
- MySQL
- PHP Application
- FreeRadius

I do not like to change the server timezone as other applications are using
the same server.
Same thing for setting MySQL to a fixed timezone, which is not my normal
timezone, as other applications are using other DBs on the MySQL server.

I thought I can use the MySQL session specific timezone settings, but I do
not see anyhwere a place where I can set that in FreeRadius. I can set
everything in PHP, but when it comes to radacct updates from a NAS ... I
only have the MySQL specific timezone. It looks like that FreeRadius is
always using the System specific time and does not care about the MySQL
timezone settings.

My goal: I like to have all radacct date&time in e.g. GMT and then convert
in my application to the NAS specific timezone.

Right now I can only achieve this by setting the MySQL timezone to GMT and
ALL DB's are then in that timezone.
Or I run a separate instance of MySQL with different port to do this?

Any thoughts? 
Is there maybe a variable in FreeRadius telling to store time information in
another timezone? Do I have to switch from MySQL tp Postgresql

... there are probably many people using FreeRadius with NAS' spreaded over
several timezones.

Thx!


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


timezone

2004-07-08 Thread jesk
hi,

how does freeradius get the time of accounting packets?
i set localtime and mysqltime to utc/gmt, but freeradius is dateing the 
accounting packets with the time in my zone. is the time maybe taken
from the nas in the timestamp attribute?
i need utc/gmt for easier accounting to sommer and winter time.

thanks for any answer.
regards,
christian



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html