cancel
Showing results for 
Search instead for 
Did you mean: 

Database Configuration

gkhazal
Champ in-the-making
Champ in-the-making
I am installing Alfresco Community Edition and when the installation wizard ge to the Database Configuration I am recieving the following error message
No 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 the problem.

Thanks in advance
5 REPLIES 5

yahoon
Champ in-the-making
Champ in-the-making
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.

gkhazal
Champ in-the-making
Champ in-the-making
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

_sax
Champ in-the-making
Champ in-the-making
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?

gkhazal
Champ in-the-making
Champ in-the-making
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…

_sax
Champ in-the-making
Champ in-the-making
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.