If my app output logs report the correct time, which they do:
Aug 16 12:21:17 WOMan[2002] DEBUG NSLog - === Commit Internal
Transaction
then, WO / Java have a correct timezone too.
therefore, this must be mysql?
On Aug 16, 2012, at 12:04 PM, Jesse Tayler <[email protected]> wrote:
> oh, that might be the trouble -- I didn't think about the database encoding.
>
> I'm using mysql, but I checked the db properties and found UTC?
>
> My server is EDT, or easter with daylight savings, for NYC. Unix reports Thu
> Aug 16 12:03:04 EDT 2012
>
> Should this be set to EDT? UTC is GMT right? That would be more like 8 hours
> off, no?
>
> Anyone know how Mysql should get setup or if this is ok?
>
> thanks!
>
> <Screen Shot 2012-08-16 at 11.59.39 AM.png>
>
> On Aug 16, 2012, at 12:55 AM, WebObjects TORAcom <[email protected]> wrote:
>
>> Hi Jesse,
>>
>> The date with the problem is stored in a database?
>>
>> We got some problems with Postgresql. Date and timezone on server was ok but
>> not in postgres.
>>
>> We found this instruction:
>>
>> ALTER DATABASE postgres SET timezone to 'Mexico/General';
>>
>> That made the trick.
>>
>> Hope this helps.
>>
>> Miguel Torres.
>>
>> On 14/08/2012, at 11:29, Jesse Tayler <[email protected]> wrote:
>>
>>> My server time is off a suspicious negative one hour, which I presume to be
>>> a daylight savings problem.
>>>
>>> UNIX returns the date I expect.
>>>
>>> So, I'd guess this is a Java or WO settings issue?
>>>
>>> A long time ago, on a server far away,
>>>
>>> there were some issues with missing timezone files used by Java and
>>> installed by WO or vice versa?
>>>
>>> Does anyone know where best to find out what's responsible for the date
>>> being returned an hour off to my client?
>>>
>>>
>>>
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list ([email protected])
>>> Help/Unsubscribe/Update your Subscription:
>>> https://lists.apple.com/mailman/options/webobjects-dev/wo%40toracom.net
>>>
>>> This email sent to [email protected]
>>>
>>
>>
>>
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/jtayler%40oeinc.com
>
> This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
