topic Re: Database Configuration in Alfresco Archive

Database Configuration

gkhazal — Fri, 10 Jul 2009 16:22:57 GMT

I am installing Alfresco Community Edition and when the installation wizard ge to the Database Configuration I am recieving the following error messageNo database selected (#3D000)MySQL has been installed and tested with the Root password. What could be causing this error message and how could I fix

Re: Database Configuration

yahoon — Sat, 11 Jul 2009 00:03:09 GMT

I also get error ,here is my solution
uncheck the box,you will be requested to create database manually –so after the installation process I excute the sql file /opt/Alfresco/extras/databases/mysql/db_setup.sql
then start the program.

Re: Database Configuration

gkhazal — Tue, 14 Jul 2009 13:31:15 GMT

I have done the installation without the database, created the alfresco database and created the user alfresco. I am now getting an authentication problem when I try to go to http://localhost/share using admin as the username and password. I have also noticed that I am missing opt/alfresco/tomcat/shared/classes/alfresco/extension/custom-repository.properties and alf_data the only modification I can make is to the alfresco-global.properties. Has that been changed with the 3.2

Thanks

Re: Database Configuration

_sax — Tue, 14 Jul 2009 15:56:45 GMT

I did it the way you described and didn't run into problems.
alfresco-global.properties is meant as a central point for user configurations, overriding system defaults. Database config included.

Is it possible to login to the normal webclient http://localhost:8080/alfresco?

Re: Database Configuration

gkhazal — Tue, 14 Jul 2009 18:15:28 GMT

I am getting 404 error on /alfresco but a login when using /share
here is a copy of my alfresco-global.properties
###############################
## Common Alfresco Properties #
###############################

#
# Sample custom content and index data location
#————-
dir.root=/opt/Alfresco/alf_data

#
# Sample database connection properties
#————-
db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=3306

#
# External locations
#————-
ooo.exe=/usr/lib64/openoffice.org/program/soffice
img.root=/usr/local
swf.exe=/opt/Alfresco/bin/pdf2swf

#
# MySQL connection
#————-
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

Note… when I check my tables in alfresco database nothing has been created, also alf_data does not exist.

Any thoughts…

Re: Database Configuration

_sax — Thu, 16 Jul 2009 15:04:30 GMT

Your configuration file looks okay.
Your login can't work, because without a database, Alfresco can't check if your allowed to login.
When you stop Alfresco, recreate the database, like you did and start it, what does the log say?
Are there still problems connecting to it?
Are there other applications running, that may hinder a database access, like security tools or other software, that connects to databases?
Are there maybe stale Alfresco processes left, that block your newly started one?
Normally, Alfresco 3.2 works out of the box with MySQL.