topic Re: Hour in the created information is not the same the system in Alfresco Archive

Hour in the created information is not the same the system

hsp — Fri, 20 Jan 2006 18:28:19 GMT

When I upload some content, it appears with two more hours than the hour in the system tray.What configuration would be wrong?

Re: Hour in the created information is not the same the system

steve — Mon, 23 Jan 2006 11:04:16 GMT

Hello,

The date and time will be coming off your server machine.
Could you check the settings on that machine?

If this is the machine you are talking about, or the machine's time is set correctly and the time is still appearing 2 hours ahead then please let us know and we'll investigate further.

Thank you,

Steve

Re: Hour in the created information is not the same the system

hsp — Mon, 23 Jan 2006 11:58:10 GMT

The server and client are running in the same machine.
The machines time is ok, but the contents are set by 2 hours more than the machines time, whatever the time is.

Re: Hour in the created information is not the same the system

steve — Mon, 23 Jan 2006 12:59:05 GMT

Hello,

Ok, thanks for the confirmation.

What operating system is your machine running?

Steve

Re: Hour in the created information is not the same the system

hsp — Mon, 23 Jan 2006 13:22:25 GMT

Linux debian-br-cdd 2.6.8-2-k7 #1 Tue Aug 16 14:00:15 UTC 2005 i686 GNU/Linux

Re: Hour in the created information is not the same the system

steve — Mon, 23 Jan 2006 14:50:19 GMT

Hello,

After searching the Debian bug list, and various other places, there are several bugs to do with time zone errors where the system shows the correct time but other applications do not - when you are offset from UTC.
I don't suppose that your time zone is 2 hours offset from UTC, is it?

There also appear to be time zone issues in the MySQL bug lists.

We will look to see if there is anything that we can do about this, or if we are causing this, but as far as I am aware we just use the built in Java time statements.

Steve

Re: Hour in the created information is not the same the system

hsp — Mon, 23 Jan 2006 15:32:24 GMT

Well, after set to use UTC, I did realize that the difference between my time zone from UTC is 2 hours. So now, there in London is 15:38 pm, and here is 13:38 pm.
But why the time doesn't appear with my configuration set? Is that a bug?

Re: Hour in the created information is not the same the system

hsp — Tue, 31 Jan 2006 16:50:06 GMT

Answers????
I want to see the same time between the content/folder right uploaded and the time on the system bar.

Re: Hour in the created information is not the same the system

gavinc — Wed, 01 Feb 2006 11:01:30 GMT

A bug has been raised in JIRA for this issue: http://www.alfresco.org/jira/browse/AR-394

Re: Hour in the created information is not the same the system

matafagafo — Wed, 01 Feb 2006 11:28:33 GMT

Hello
The same happens to me, the same -2 hours.
My server in running in a W2K server, the TimeZone is BRST.

Re: Hour in the created information is not the same the system

steve — Thu, 02 Feb 2006 16:47:43 GMT

Hello,

One thing you could try is to modify your MySQL connection string in the file 'repository.properties' to be as follows:

Old String: db.url=jdbc:mysql:///${db.name}

New String: db.url=jdbc:mysql:///${db.name}?useTimezone=true

(If you are using Tomcat, this file is found in tomcat\webapps\alfresco\WEB-INF\classes\alfresco)

If this does, or does not solve your problem could you please let us know.
Thanks,

Steve

Re: Hour in the created information is not the same the system

hsp — Thu, 02 Feb 2006 17:01:33 GMT

I am using postgresql. How could it be in repository.properties for that..

Old string: db.url=jdbcostgresql://localhost/alfresco

New: db.url=jdbcostgresql://localhost/alfresco?useTimezone=true

works?

Re: Hour in the created information is not the same the system

hsp — Thu, 02 Feb 2006 17:12:10 GMT

I did the string mencioned above (for postgre), but the time still 2 hours more.

Re: Hour in the created information is not the same the system

hsp — Thu, 02 Feb 2006 17:27:43 GMT

The time in file in the alf_data/contentstore/ folder is correct, but the time showed in the UI for the file content is 2 hours more.

Re: Hour in the created information is not the same the system

steve — Thu, 02 Feb 2006 19:30:46 GMT

Hello,

That flag was for MySQL only…

What is your timezone setting for your PostgreSQL database?
You could try re-setting your time zone settings to LOCAL.

Also, according to the PostgreSQL docs the following is true:

PostgreSQL contains internal tabular information for time zone decoding, since there is no *nix standard system interface to provide access to general, cross-timezone information. The underlying OS is used to provide time zone information for output, however.

See here: http://www.postgresql.org/docs/7.4/interactive/datetime-keywords.html#DATETIME-MOD-TABLE

Steve

Re: Hour in the created information is not the same the system

hsp — Tue, 07 Feb 2006 17:31:50 GMT

Thank you,
I saw the link. But how can I set the time zone in postgre to LOCAL?

Re: Hour in the created information is not the same the system

hsp — Tue, 07 Feb 2006 18:42:37 GMT

I think it is a bug….related with time creation.
I created a folder named Temp, so it was with its time (2 hours ahead, but ok…), then I entered in the folder Temp and created another folder named Temp. In this case the parent folder Temp gets the same time, the two folder are with the same time creation (the last time).
I am using the version 1.2 RC1

Re: Hour in the created information is not the same the system

steve — Wed, 08 Feb 2006 12:50:19 GMT

Hi,

I have been able to get this to happen in our test environments.
I have raised this as AR-410.

Steve

Re: Hour in the created information is not the same the system

davidc — Wed, 08 Feb 2006 19:10:05 GMT

This has been fixed and will be available in next v1.2 release candidate (any day now) or SVN (r2327).

Re: Hour in the created information is not the same the system

hsp — Thu, 09 Feb 2006 13:40:56 GMT

Ok, I'm glad.
I installed another version of postgresql (8.1) because of timezone is not working on my old installation (postgre 7.4).
After postgresql installed, I run the alfresco but it doesn't work.
The alf_data and database was created, but the caches.xml files was not.
It is happen some errors (I deleted the two files cache, alf_data and data_base):
2006-02-09 11:05:37,024 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: function information_schema._pg_keypositions() does not exist

2006-02-09 11:05:37,114 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] could not complete schema update
org.hibernate.exception.SQLGrammarException: could not get table metadata: applied_patch
…
Initialization of bean failed; nested exception is java.io.FileNotFoundException: class path resource [ehcache.xml] cannot be resolved to URL because it does not exist
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ehCacheManager' defined in class path resource [alfresco/cache-context.xml]: Initialization of bean failed; nested exception is java.io.FileNotFoundException: class path resource [ehcache.xml] cannot be resolved to URL because it does not exist
java.io.FileNotFoundException: class path resource [ehcache.xml] cannot be resolved to URL because it does not exist
…
Can't resolve reference to bean 'ehCacheManager' while setting property 'cacheManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ehCacheManager' defined in class path resource [alfresco/cache-context.xml]: Initialization of bean failed; nested exception is java.io.FileNotFoundException: class path resource [ehcache.xml] cannot be resolved to URL because it does not exist
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ehCacheManager' defined in class path resource [alfresco/cache-context.xml]: Initialization of bean failed; nested exception is java.io.FileNotFoundException: class path resource [ehcache.xml] cannot be resolved to URL because it does not exist
java.io.FileNotFoundException: class path resource [ehcache.xml] cannot be resolved to URL because it does not exist.

Is there some imcompatibility between postgresql version 7xx and 8xx, related with functions?? what next? what about the caches files?