Hyland Connect

lemmy · ‎12-27-2010

Hi,

I've just installed Community Version 3.4.c on Windows 7 with integrated MySQL database. I'm unable to login with admin / admin. I'm getting the German error message "Der Romote Server is eventuell nicht erreichbar oder Ihre Anmeldedaten wurden nicht erkannt" which translates to "The remote server may be down or your login data is wrong."

In the log I'm seeing some hints:

20:49:02,819 User:System ERROR [node.integrity.IntegrityChecker] Found 3 integrity violations:
Invalid property value: 
   Node: workspace://SpacesStore/10cabaff-73b8-4fc4-8771-ee0b0723de5e
   Type: {http://www.alfresco.org/model/content/1.0}folder
   Property: {http://www.alfresco.org/model/content/1.0}name
   Constraint: 11260000 Value 'E-Mail Einladungs-Mustervorlagen ' is not valid as a file name. This property must be a valid file name.
Invalid property value: 
   Node: workspace://SpacesStore/d4cdbe55-d852-4c1d-a146-90c411628c1c
   Type: {http://www.alfresco.org/model/content/1.0}folder
   Property: {http://www.alfresco.org/model/content/1.0}name
   Constraint: 11260001 Value 'E-Mail Benachrichtigungs-Mustervorlagen ' is not valid as a file name. This property must be a valid file name.
Invalid property value: 
   Node: workspace://SpacesStore/bef86a46-519a-4e17-8cea-5dd57f4308b2
   Type: {http://www.alfresco.org/model/content/1.0}folder
   Property: {http://www.alfresco.org/model/content/1.0}name
   Constraint: 11260002 Value 'Präsentations-Mustervorlagen ' is not valid as a file name. This property must be a valid file name.
20:49:03,015  ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 11260004 Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:361)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:718)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:905)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:740)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:500)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.alfresco.repo.node.integrity.IntegrityException: 11260003 Found 3 integrity violations:
Invalid property value: 
   Node: workspace://SpacesStore/10cabaff-73b8-4fc4-8771-ee0b0723de5e
   Type: {http://www.alfresco.org/model/content/1.0}folder
   Property: {http://www.alfresco.org/model/content/1.0}name
   Constraint: 11260000 Value 'E-Mail Einladungs-Mustervorlagen ' is not valid as a file name. This property must be a valid file name.
Invalid property value: 
   Node: workspace://SpacesStore/d4cdbe55-d852-4c1d-a146-90c411628c1c
   Type: {http://www.alfresco.org/model/content/1.0}folder
   Property: {http://www.alfresco.org/model/content/1.0}name
   Constraint: 11260001 Value 'E-Mail Benachrichtigungs-Mustervorlagen ' is not valid as a file name. This property must be a valid file name.
Invalid property value: 
   Node: workspace://SpacesStore/bef86a46-519a-4e17-8cea-5dd57f4308b2
   Type: {http://www.alfresco.org/model/content/1.0}folder
   Property: {http://www.alfresco.org/model/content/1.0}name
   Constraint: 11260002 Value 'Präsentations-Mustervorlagen ' is not valid as a file name. This property must be a valid file name.
   at org.alfresco.repo.node.integrity.IntegrityChecker.checkIntegrity(IntegrityChecker.java:661)
   at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.beforeCommit(AlfrescoTransactionSupport.java:677)
   at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:95)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:927)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:737)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:394)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:472)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:403)
   at org.alfresco.repo.importer.ImporterBootstrap$1.doWork(ImporterBootstrap.java:354)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:508)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:357)
   … 35 more
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
20:50:33,320  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 309 Web Scripts (+0 failed), 319 URLs
20:50:33,324  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 
20:50:33,324  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 
20:50:33,586  INFO  [extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 7842.49ms)
20:50:33,672  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
20:50:33,785  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
20:50:34,472  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
20:50:34,478  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
20:50:35,164  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
20:50:35,170  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
WARN : org.apache.myfaces.shared_impl.util.LocaleUtils - Locale name in faces-config.xml null or empty, setting locale to default locale : de_DE
WARN : org.springframework.beans.GenericTypeAwarePropertyDescriptor - Invalid JavaBean property 'baseUrl' being accessed! Ambiguous write methods found next to actually used [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.net.URI)]: [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.lang.String) throws java.net.URISyntaxException]
WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Not Found‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Any idea?

Thanks,
Lemmy

heiko_robert · ‎12-27-2010

Hi Lemmy,
this looks like that Alfresco 3.4 isn't tested in german environments yet. I allways kick out the the localization for system objects like "dictionary folder" (and console output) since this is source of lots of trouble in updates and other functions.

@Alfresco: Wouldn't it a better idea to kick out localization for spaces and console output at all? At least this should be a config option before first start since in multilang environments localized spaces don't work and admins should be able to work with english names and output - I assume it's also much easier for you to support if error message on the server are allways in english 😉

I try to bootstrap with DE locale and give you feedback.

Regards
Heiko

bremmington · ‎12-28-2010

Thanks, Heiko

@Lemmy: the reason why the WQS login isn't working is because the repository hasn't started, and the reason for that is because there appears to be a few errors in the German bootstrap data (as Heiko said). Please would you raise this in Jira, identifying as clearly as possible what steps you took when installing it and information about your environment (including OS and locale settings)?

Thanks

heiko_robert · ‎12-28-2010

Hi Lemmy,
I was able to reproduce the error on a german Win System. The initial bootstrap fails since the space names in the property files conflict with space name rules defined in the alfresco model. If you want to use the system in production you should wait for working language property files verified by alfresco but as a quick work around you can do the following:

stop Alfresco tomcat and leave the mysql up and running

delete the repository data since it is not working:

drop database alfresco34c;
create database alfresco34c default character set utf8 collate utf8_bin;
grant all on alfresco34c.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco34c.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
‍‍‍‍‍

move bootstrap-spaces_de_DE.properties

create new alfresco.war

jar cvf \Alfresco\tomcat\webapps\alfresco.war -C \Alfresco\tomcat\webapps\alfresco .‍

start alfresco tomcat service

heiko_robert · ‎12-28-2010

There is allready an issue created in jira: http://issues.alfresco.com/jira/browse/ALF-6317

lemmy · ‎12-28-2010

Heiko,

Thanks for your hints. Unfortunately it didn't work for me

I've dooble checked bootstrap-spaces_de_DE.properties, it contains us texts now. War file is newly created. Logfile looks better:


log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
20:24:26,102  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 309 Web Scripts (+0 failed), 319 URLs
20:24:26,105  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 
20:24:26,105  INFO  [extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 
20:24:26,415  INFO  [extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 8221.604ms)
20:24:26,481  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
20:24:26,609  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
20:24:27,998  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
20:24:28,004  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
20:24:29,481  INFO  [extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
20:24:29,487  INFO  [extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
WARN : org.apache.myfaces.shared_impl.util.LocaleUtils - Locale name in faces-config.xml null or empty, setting locale to default locale : de_DE
WARN : org.springframework.beans.GenericTypeAwarePropertyDescriptor - Invalid JavaBean property 'baseUrl' being accessed! Ambiguous write methods found next to actually used [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.net.URI)]: [public void org.alfresco.wcm.client.impl.WebScriptCallerImpl.setBaseUrl(java.lang.String) throws java.net.URISyntaxException]
WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Not Found
WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Not Found
WARN : org.alfresco.wcm.client.util.impl.GuestSessionFactoryImpl - WQS unable to connect to repository: Not Found‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Login still impossible. Will try to reinstall with us-location…

Regards,
Lemmy

lemmy · ‎12-28-2010

I've set my Windows 7 to US-EN (Location United States, Formats English (United States), Current language for non-Unicode programs: English (United States) and Firefox preferred language to english. After reinstallation of Alfresco I still get exceptions in the log and the login in German

ops: If German doesn't work currently english version should be fine for the moment.

How can I get a running 3.4.c server in english?

heiko_robert · ‎12-29-2010

Hi Lemmy,
the server locale (language) has nothing to do with your browser settings (at least for most cases).
When you changed the property files and created the new war file: did you delete the repository before the next start (emty alf_data dir and recreate database)?
If so, you need to take a look to the catalina.out during initial start for errors. If you cant log into <servername>:<port>/alfresco, there is no sense to try to login to share.

There is no easy way to uninstall and install everything from scratch since the installer starts tomcat and you need to modify things before the first start.

If you think something went wrong with your property modification you can force tomcat to start in english environment, but you still need to delete the repository first. Be aware if you change the server to english locale, full text search will treat everything from protocoll adapters as english content and search will not behave as you expect! We provide a commercial Module to fine grain tune search in Alfresco to meet these restrictions but for testing it may be fine for you just to switch the language.
To go that way create a new file named 'setenv.bat' in \tomcat\bin containing the following startup parameters (please change paths to meet your installation):

set JAVA_HOME=C:\Program Files\Java\jdk1.6.0_22
set JAVA_OPTS=-Xms1g -Xmx2g -XX:MaxPermSize=256m -server -Djava.library.path=c:/Alfresco/bin -Duser.language=en -Duser.region=US

‍‍‍‍

I

lemmy · ‎01-02-2011

Hi,

I've done the procedure exactly as described again including deletion and recreation of database. Stdout says org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost' (using password: YES)). Manually logging into mysql with user alfresco works fine, creation od databases is possible manually. Database alfresco doesn't contain any tables, folder Alfresco\alf_data is empty.

14:40:12,661  WARN  [hibernate.cfg.SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost' (using password: YES))
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
   at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
   at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855)
   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774)
   at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1460)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1398)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:512)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1305)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1305)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1305)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:557)
   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:842)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:416)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.sql.SQLException: Access denied for user 'alfresco'@'localhost' (using password: YES)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
   at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4004)
   at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2312)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
   at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
   at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
   at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
   … 77 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Please help!

Thanks,
Lemmy

heiko_robert · ‎01-02-2011

It looks like your MySQL config is not correct. The log says, that the alfresco user is not allowed to connect. Please check tomcat\shared\classes\alfresco-global.properties for mysql conect properties like
### database connection properties ###
db.driver=org.gjt.mm.mysql.Driver
db.username=alfresco
db.password=alfresco
db.name=alfresco34b
db.url=jdbc:mysql://localhost/alfresco34b

In my example you should be able to conect using:
mysql -ualfresco -palfresco alfresco34b -h localhost

Please use the host parameter (localhost) to simulate the exact network route which is used by alfresco.

Hyland Connect

Problems getting Community 3.4.c running