topic Alfresco startup issue when it points to MySQL DB in Alfresco Archive

Alfresco startup issue when it points to MySQL DB

hani — Mon, 30 Jul 2007 08:31:39 GMT

I have successfully installed Alfresco 2.1 Community edition in my Windows-XP machine and it works fine HSQL-DB. When I changed the files "custom-repository.properties" and "custom-hibernate-dialect.properties" inorder to use my local MySQL DB the alfresco DB and users are created in my local DB .

Re: Alfresco startup issue when it points to MySQL DB

davidc — Tue, 31 Jul 2007 09:33:50 GMT

You also need to clean your dir.root directory, or point it to a new directory.

Re: Alfresco startup issue when it points to MySQL DB

sobotka — Tue, 31 Jul 2007 10:31:58 GMT

I have the same problem. Within custom-repository.properties I set:

dir.root=D:\Alfresco\data
dir.indexes=D:\Alfresco\data

Didn't help.

What's the reason of the error (Context initialization failed org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed). Has it to do with MySQL or repository location ?

Petr

Re: Alfresco startup issue when it points to MySQL DB

sobotka — Tue, 31 Jul 2007 10:41:36 GMT

As I see now my problem is rather different from the one above, the cause of my exception is:

Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to import package at line 41; column 35 due to error:
Content URL classpath:alfresco/templates/prehled-systemu.html does not exist.
        at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:190)
        at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:360)
        at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:224)
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:426)

It has nothing to do with MySQL or repository location because it appears also when not changing the original configuration.

"alfresco/templates/prehled-systemu.html" is probably some localized file (it has czech name which corresponds to my regional settings). Where can I configure that this file will not be searched for ?

Petr

Re: Alfresco startup issue when it points to MySQL DB

davidc — Tue, 31 Jul 2007 11:31:54 GMT

"alfresco/templates/prehled-systemu.html" is probably some localized file (it has czech name which corresponds to my regional settings). Where can I configure that this file will not be searched for ?

That's not an out-of-the-box file, afaik. So, I guess you added the configuration to refer to it?

Re: Alfresco startup issue when it points to MySQL DB

sobotka — Tue, 31 Jul 2007 11:39:10 GMT

That's not an out-of-the-box file, afaik. So, I guess you added the configuration to refer to it?

No, Alfresco tries to refer to that file after simple installation and startup (without any reconfiguration).
I guess there is a problem in the localization into czech language. I have czech regional setting on my comp. The name "prehled-systemu" is the translation of "system-overview" - file "system-overview.html" resides int the template directory. It seems that in my environment Alfresco translates the english file name into czech one - which doesn't exist obviously.

Can you understand what I mean ?

Petr

Re: Alfresco startup issue when it points to MySQL DB

davidc — Wed, 01 Aug 2007 09:53:51 GMT

Oh I see.

You can modify either:

config/alfresco/messages/bootstrap-templates.properties - line 10

or:

config/alfresco/templates/software_engineering_project.xml - line 40

Re: Alfresco startup issue when it points to MySQL DB

sobotka — Wed, 01 Aug 2007 10:20:39 GMT

You can modify either:
config/alfresco/messages/bootstrap-templates.properties - line 10
or:
config/alfresco/templates/software_engineering_project.xml - line 40

I didn't find any file containing the text "prehled-systemu" under Alfresco\tomcat\webapps. In bootstrap-templates.properties there is "system-overview.html". In the other file there is some indirect value (${templates.document.system_overview.name}).

Petr

Re: Alfresco startup issue when it points to MySQL DB

davidc — Wed, 01 Aug 2007 10:52:54 GMT

Did you search under /tomcat/shared?

Re: Alfresco startup issue when it points to MySQL DB

sobotka — Wed, 01 Aug 2007 11:00:57 GMT

Did you search under /tomcat/shared?

Bingo ! It is written in Alfresco\tomcat\shared\classes\alfresco\messages\bootstrap-templates_cs_CZ.properties

So, in the distribution of Alfresco there should be:
- either the original english filename "system-overview.html" in the prop file above
- or czech version of this html file must be created and put in the appropriate directory
(the first option is generally used in other localization files)

Right ?
Thanks for your cooperation.
Petr

Re: Alfresco startup issue when it points to MySQL DB

davidc — Wed, 01 Aug 2007 11:45:05 GMT

Correct.

Personally, I think the filename should remain system-overview.html and the reference in software_engineering_project.xml should be hard-coded to that name and not use the locale indirection.