Brand New Installation issues....

[billk]

Server:
CentOS 4.2
Kernel 2.6.9-34.EL

I can't seem to get the web application to come up cleanly.  I verified that the alfresco user exists in the db, and the alfresco database exists as well.  What would be causing this?

UPDATE: I read back through the install guide.  I have mysql installed from the CentOS installation media and then upgraded to:
mysql-server-4.1.12-3.RHEL4.1

instead of installing from the mysql.com site using the Max DB.  I didn't see a MaxDB rpm choice, so I just took the server version from their site.  But when I try to install it tells me that there is a conflict with the package:
mysql-4.1.12-3.RHEL4.1

Not sure if that is related or not.


INFO: Deploying web application archive alfresco.war
09:28:05,217 ERROR [hibernate.util.JDBCExceptionReporter] Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost.localdomain' (using password: YES))
09:28:08,941 ERROR [hibernate.util.JDBCExceptionReporter] Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost.localdomain' (using password: YES))
09:28:08,945 ERROR [tool.hbm2ddl.SchemaUpdate] could not get database metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost.localdomain' (using password: YES))
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)

[gavinc]

From the errors you have it looks like you don't have the privileges setup correctly in the database for the alfresco user.

Try logging into MySQL from the command line and enter the following:

grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
‍‍

Hope this helps.

[billk]

That did the trick.  I used the script you provided to set the DB up on a fresh install of the OS and MySQL DB.  Any idea why this wouldn't have been setup by the install script?

[gavinc]

It's an omission, I have added an extra line to the db_setup.sql script to cover 'localhost.localdomain' as well.