why can't login

[alfian]

[img]http://phiandkit.files.wordpress.com/2011/06/alfresco.jpg[/img]

login : admin
password : admin

[mrogers]

You have not posted enough information.  

Most likely alfresco is not running.   Look in alfresco.log to see if there are any clues.

[alfian]

08:18:58,093 WARN  [org.hibernate.cfg.SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
08:19:03,578 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageService' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'SearchService' while setting bean property 'searchService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'SearchService' defined in class path resource [alfresco/public-services-context.xml]: Cannot resolve reference to bean 'searchService' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'searchService' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'indexerAndSearcherFactory' while setting bean property 'indexerAndSearcherFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'indexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'admLuceneIndexerAndSearcherFactory' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'admLuceneIndexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'mlAwareNodeService' while setting bean property 'nodeService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mlAwareNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'mtAwareNodeService' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mtAwareNodeService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'qnameDAO' while setting bean property 'qnameDAO'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'qnameDAO' defined in class path resource [alfresco/dao/dao-context.xml]: Cannot resolve reference to bean 'repoSqlMapClientTemplate' while setting bean property 'sqlMapClientTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlMapClientTemplate' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'alfrescoSqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'alfrescoSqlMapClient' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'dialectResourceLoader' while setting bean property 'resourceLoader'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectResourceLoader' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot create inner bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#6798eb' of type [org.springframework.beans.factory.config.PropertyPathFactoryBean] while setting bean property 'dialectClass'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.beans.factory.config.PropertyPathFactoryBean#6798eb' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialect': FactoryBean threw exception on object creation; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection

09:56:38,312 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.

09:56:39,140 WARN  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.

09:56:40,000 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 05130000 The store 'avm://sitestore' has a duplicate root node entry.


09:57:46,734 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 275 Web Scripts (+0 failed), 286 URLs
09:57:46,734 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)
09:57:46,734 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)

this my log

sory i'm newbie on alfresco

[bengrah]

Hi afian

Your error looks like either Alfresco is unable to connect to your content store (check the permissions on the folder are right for the user you are running Alfresco as a service as) or that your database isn't running (judging by the SQLException you're getting).

Try navigating to wherever you've installed the SQL database (or if you're using the one bundled with Alfresco, it should be in <Alfresco Directory/mysql/bin and run the following command via command prompt "mysqld –standalone –console" (without the quotation marks)

Check Task Manager to see if "mysqld" is running, then try and restart Alfresco again.

[alfian]

thank you my friend

I've tried "mysqld - standalone - console" but the result appears an error and I still can not login. The database was created, mysqld is already in the task manager. following I show an image results

[img]http://phiandkit.files.wordpress.com/2011/06/mysqld.jpg[/img]

[img]http://phiandkit.files.wordpress.com/2011/06/error-alfresco.jpg[/img]

[bengrah]

Hi afian

You have to use two hyphens when running that mysqld command; "mysqld –standalone –console" which is what I've read on other sites anyway. Though if mysqld is running as it is, then your database should be fine to connect to. Are you using the correct database credentials in your alfresco-global.properties file?

Check the db.name, db.port etc. properties, maybe you're using the wrong credentials to log in. What you could do is again, navigate to your MySQL data base being used and check you can actually log in to your database instance. Navigate to <Alfresco Directory/mysql/bin then use "mysql -u <username, usually root> -p" then hit Return, then enter your password for this user, which is probably "root" again and see if you can log in. If you can, then make sure the properties in alfresco-global.properties match this.