Alfresco : 在此服务器上找不到 Alfresco 存储库

2021-11-26 00:00:00 mysql alfresco

我是 Alfresco 社区的新手,在尝试配置数据库时遇到了问题.我按照 here 中的步骤操作,但它不起作用我仍然遇到错误: "在此服务器上找不到 Alfresco 存储库"

I am new with Alfresco Comunity, i have trouble when i tried to configure database. i follow the step from here but it's not working i still got an error : "Cannot find Alfresco Repository on this server"

这是我的C:alfresco-community omcatsharedclassesalfresco-global.properties

###############################
## Common Alfresco Properties #
###############################

dir.root=C:/alfresco-community/alf_data

alfresco.context=alfresco
alfresco.host=127.0.0.1
alfresco.port=8080
alfresco.protocol=http

share.context=share
share.host=127.0.0.1
share.port=8080
share.protocol=http

### database connection properties ###
#db.driver=org.postgresql.Driver
#db.username=alfresco
#db.password=admin
#db.name=alfresco
#db.url=jdbc:postgresql://localhost:5432/${db.name}
# Note: your database must also be able to accept at least this many connections.  Please see your database documentation for instructions on how to configure this.
#db.pool.max=275
#db.pool.validate.query=SELECT 1

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost:3306/alfrescoaio?useUnicode=yes&characterEncoding=UTF-8 

db.username=root
db.password=123abc

db.name=alfrescoaio
db.host=localhost
db.port=3306
db.pool.max=275

user.name.caseSensitive=true




# The server mode. Set value here
# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=UNKNOWN

### FTP Server Configuration ###
ftp.port=21

### RMI registry port for JMX ###
alfresco.rmi.services.port=50500

### External executable locations ###
ooo.exe=C:/alfresco-community/libreoffice/App/libreoffice/program/soffice.exe
ooo.enabled=true
ooo.port=8100
img.root=C:\alfresco-community\imagemagick
img.coders=${img.root}\modules\coders
img.config=${img.root}
img.gslib=${img.root}\lib
img.exe=${img.root}\convert.exe

jodconverter.enabled=false
jodconverter.officeHome=C:/alfresco-community/libreoffice/App/libreoffice
jodconverter.portNumbers=8100

### Initial admin password ###
alfresco_user_store.adminpassword=209c6174da490caeb422f3fa5a7ae634

### E-mail site invitation setting ###
notification.email.siteinvite=false

### License location ###
dir.license.external=C:/alfresco-community

### Solr indexing ###
index.subsystem.name=solr4
dir.keystore=${dir.root}/keystore
solr.host=localhost
solr.port.ssl=8443

### Allow extended ResultSet processing
security.anyDenyDenies=false

### Smart Folders Config Properties ###
smart.folders.enabled=false

### Remote JMX (Default: disabled) ###
alfresco.jmx.connector.enabled=false

日志错误:

rnate-context.xml]: Cannot resolve reference to bean '&sessionFactory' while setting bean property 'localSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceCheck' defined in class path resource [alfresco/core-services-context.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.alfresco.repo.domain.schema.DataSourceCheck]: Constructor threw exception; nested exception is java.lang.RuntimeException: Database connection failed: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

谁能帮我解决这个问题?

Any one can help me how to fix this ?

推荐答案

Alfresco 安装程序随 PostgreSQL 一起提供.安装后,它会将 PostgreSQL 驱动程序 (postgresql-9.4-1201-jdbc41.jar) 放在 $TOMCAT_HOME/lib 中.

The Alfresco installer ships with PostgreSQL. When it is installed it will place the PostgreSQL driver (postgresql-9.4-1201-jdbc41.jar) in $TOMCAT_HOME/lib.

如果您要切换到不同的数据库,则需要确保新的数据库驱动程序可用.您的错误消息似乎表明它不是.

If you are switching to a different database you need to make sure the new database driver is available. Your error message seems to indicate it isn't.

查看 $TOMCAT_HOME/lib 并查看是否有名为 mysql-connector-java-*.jar 的文件.如果没有,请从此处下载,然后将 JAR 放在此目录中并重新启动.

Go look in $TOMCAT_HOME/lib and see if you have a file named mysql-connector-java-*.jar. If you don't, download it from here, then place the JAR in this directory and restart.

相关文章