topic Access denied for user 'alfresco'@'localhost' (using passwor in Alfresco Archive

Access denied for user 'alfresco'@'localhost' (using passwor

laurent1050 — Fri, 02 Jul 2010 08:49:47 GMT

Hi,I'm trying to install Alfresco 3.3 on RedHat.I've copied alfresco.war in tomcat.I've a PostgreSQL 8.1.11 database on the same server.I've created a database and a userCREATE DATABASE alfresco WITH ENCODING 'UTF8';CREATE USER alfresco WITH PASSWORD 'alfresco';GRANT ALL privileges on database alfr

Re: Access denied for user 'alfresco'@'localhost' (using passwor

janv — Fri, 02 Jul 2010 09:25:47 GMT

You mention using PostgreSQL but your log output shows MySQL ("… com.mysql.jdbc. …") ? Have you overridden the DB properties (including JDBC driver / url) in "afresco-global.properties" to comment-in PostgreSQL properties (and comment-out MySQL properties) ?

For an example, see also: http://wiki.alfresco.com/wiki/Database_Configuration#PostgreSQL_example

Regards,
Jan

Re: Access denied for user 'alfresco'@'localhost' (using passwor

laurent1050 — Fri, 02 Jul 2010 09:54:45 GMT

You're right !

Alfresco seems not to read my alfresco-global.properties in shared/classes.
Here is an extract of the alfresco-global.properties.

#
# Sample database connection properties
#
db.username=alfresco
db.password=alfresco

#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed.  After
# upgrading to a new version, this can be disabled.
#
db.schema.update=true

#
# MySQL connection
#
#db.driver=org.gjt.mm.mysql.Driver
#db.url=jdbc:mysql://localhost/alfresco

#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
db.driver=org.postgresql.Driver
db.url=jdbc:postgresql://127.0.0.1:5432/alfresco‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I think it's due to a strange config of my corporate server….

Thks
Laurent

Re: Access denied for user 'alfresco'@'localhost' (using passwor

zaizi — Fri, 02 Jul 2010 10:08:53 GMT

If you are using a default installation of Tomcat, it doesn't by default include "shared/classes" folder in it's class loader. You'll need to edit tomcat/conf/catalina.properties and add the path to shared.loader.

shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar‍

Ainga