Don't Know

[jllort]

have you installed propertly jar libs in lib folder ?

[Vian]

Of course

[jllort]

have you modified openkm.cfg in order to enable mysql ?

[Vian]

openkm.cfg.xml

# Default configuration values
#
repository.config=repository.xml
repository.home=repository
system.user=system
default.user.role=UserRol
default.admin.role=AdminRol
principal.adapter=es.git.openkm.principal.DatabasePrincipalAdapter
# principal.adapter=com.openkm.core.UsersRolesPrincipalAdapter
# max.file.size=5
# max.search.results=25
# system.demo=off
# update.info=off
restrict.file.mime=on
restrict.file.extension=*~,*.bak,._*
max.file.size=25
default.lang=cn

repository.xml

<?xml version="1.0"?>
<Repository>
<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://127.0.0.1:3306/openkm"/>
<param name="schemaObjectPrefix" value="rep_"/>
<param name="schema" value="mysql"/>
<param name="user" value="root"/>
<param name="password" value="xmbcit"/>
</FileSystem>
<Security appName="OpenKM">
<AccessManager class="es.git.openkm.core.OKMAccessManager"/>
<!-- <AccessManager class="org.apache.jackrabbit.core.security.SimpleAccessManager"/> -->
</Security>
<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default" />
<Workspace name="${wsp.name}">
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}"/>
</FileSystem>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://127.0.0.1:3306/openkm"/>
<param name="schemaObjectPrefix" value="${wsp.name}_"/>
<param name="schema" value="mysql"/>
<param name="externalBLOBs" value="false"/>
<param name="user" value="root"/>
<param name="password" value="xmbcit"/>
</PersistenceManager>
<SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${wsp.home}/index"/>
<param name="useCompoundFile" value="true"/>
<param name="minMergeDocs" value="100"/>
<param name="volatileIdleTime" value="3"/>
<param name="maxMergeDocs" value="100000"/>
<param name="mergeFactor" value="10"/>
<param name="bufferSize" value="10"/>
<param name="cacheSize" value="1000"/>
<param name="forceConsistencyCheck" value="false"/>
<param name="autoRepair" value="true"/>
<param name="analyzer" value="org.apache.lucene.analysis.standard.StandardAnalyzer"/>
<param name="respectDocumentOrder" value="false"/>
<param name="textFilterClasses" value="
org.apache.jackrabbit.core.query.lucene.TextPlainTextFilter,
org.apache.jackrabbit.extractor.MsExcelTextExtractor,
org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,
org.apache.jackrabbit.extractor.MsWordTextExtractor,
org.apache.jackrabbit.extractor.PdfTextExtractor,
org.apache.jackrabbit.extractor.HTMLTextExtractor,
org.apache.jackrabbit.extractor.XMLTextExtractor,
org.apache.jackrabbit.extractor.RTFTextExtractor,
org.apache.jackrabbit.extractor.OpenOfficeTextExtractor" />
</SearchIndex>
</Workspace>
<Versioning rootPath="${rep.home}/version">
<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://127.0.0.1:3306/openkm"/>
<param name="schemaObjectPrefix" value="ver_rep_"/>
<param name="schema" value="mysql"/>
<param name="user" value="root"/>
<param name="password" value="xmbcit"/>
</FileSystem>
<PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://127.0.0.1:3306/openkm"/>
<param name="schemaObjectPrefix" value="ver_"/>
<param name="schema" value="mysql"/>
<param name="externalBLOBs" value="false"/>
<param name="user" value="root"/>
<param name="password" value="xmbcit"/>
</PersistenceManager>
</Versioning>
</Repository>

[jllort]

Use it in your OpenKM.cfg

Code: Select all

system.database=mysql

[Vian]

Thank you very much!
but now when I log in openkm with okmAdmin...

My openkm.cfg.xml
# Default configuration values
#
system.database=mysql
repository.config=repository.xml
repository.home=repository
system.user=system
default.user.role=UserRol
default.admin.role=AdminRol
principal.adapter=es.git.openkm.principal.DatabasePrincipalAdapter
# principal.adapter=com.openkm.core.UsersRolesPrincipalAdapter
# max.file.size=5
# max.search.results=25
# system.demo=off
# update.info=off
restrict.file.mime=off
restrict.file.extension=*~,*.bak,._*
max.file.size=25

[jllort]

delete folder repository and start again.

[Vian]

I tried.No effect
"okm:home"
"Go to login page" ---> link
When I click "Go to login page" link, it displayed login page again.


and

<local-tx-datasource>
<jndi-name>OKMDashboardStatsDS</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/OKMDashboardStats?createDatabaseIfNotExist=true</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>xmbcit</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<!--<security-domain>HsqlDbRealm</security-domain>-->
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
<!--<depends>jboss:service=mysql,database=OKMDashboardStats</depends>-->
</local-tx-datasource>

Database OKMDashboardStats No created

[jllort]

Database it'll not be created automatically to you in version 4.1, you can forget it, you must recreate tables in same way are in Hypersonic. And you've missed autoreconnect param what's really important

Code: Select all

<connection-url>jdbc:mysql://127.0.0.1:3306/OKMDashboardStats?createDatabaseIfNotExist=true</connection-url>

[Vian]

Sorry, But I say you edited by openk-ds.xml

openkm.cfg.xml

system.database=mysql
repository.config=repository.xml
repository.home=repository
system.login.lowercase=on
system.user=system
default.user.role=UserRol
default.admin.role=AdminRol
principal.adapter=es.git.openkm.principal.DatabasePrincipalAdapter
# principal.adapter=com.openkm.core.UsersRolesPrincipalAdapter
# max.file.size=5
# max.search.results=25
system.demo=on
# update.info=off
restrict.file.mime=off
restrict.file.extension=*~,*.bak,._*
max.file.size=25

openkm-ds.xml

<?xml version="1.0" encoding="UTF-8"?>

<datasources>
<!-- OpenKM User Activity -->
<local-tx-datasource>
<jndi-name>OKMActivityDS</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/OKMActivity?autoreconnect =true</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>xmbcit</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<!--<security-domain>HsqlDbRealm</security-domain>-->
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
<!--<depends>jboss:service=mysql,database=OKMActivity</depends>-->
</local-tx-datasource>

<!-- For hsqldb accessed from jboss only, in-process (standalone) mode
<mbean code="com.mysql.jdbc.Driver"
name="jboss:service=mysql,database=OKMActivity">
<attribute name="Database">OKMActivity</attribute>
<attribute name="InProcessMode">true</attribute>
</mbean>
-->
<!-- OpenKM User Auth -->
<local-tx-datasource>
<jndi-name>OKMAuthDS</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/OKMAuth?autoreconnect =true</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>xmbcit</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<!--<security-domain>HsqlDbRealm</security-domain>-->
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
<!--<depends>jboss:service=mysql,database=OKMAuth</depends>-->
</local-tx-datasource>

<!-- For hsqldb accessed from jboss only, in-process (standalone) mode
<mbean code="com.mysql.jdbc.Driver"
name="jboss:service=mysql,database=OKMAuth">
<attribute name="Database">OKMAuth</attribute>
<attribute name="InProcessMode">true</attribute>
</mbean>
-->
<!-- OpenKM Dashboard Stats -->
<local-tx-datasource>
<jndi-name>OKMDashboardStatsDS</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/OKMDashboardStats?autoreconnect =true</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>xmbcit</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<!--<security-domain>HsqlDbRealm</security-domain>-->
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
<!--<depends>jboss:service=mysql,database=OKMDashboardStats</depends>-->
</local-tx-datasource>

<!-- For hsqldb accessed from jboss only, in-process (standalone) mode
<mbean code="com.mysql.jdbc.Driver"
name="jboss:service=mysql,database=OKMDashboardStats">
<attribute name="Database">OKMDashboardStats</attribute>
<attribute name="InProcessMode">true</attribute>
</mbean>
-->
<!-- OpenKM Workflow -->
<local-tx-datasource>
<jndi-name>OKMWorkflowDS</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/OKMWorkflow?autoreconnect =true</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>xmbcit</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<!--<security-domain>HsqlDbRealm</security-domain>-->
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
<!-- <depends>jboss:service=mysql,database=OKMWorkflow</depends>-->
</local-tx-datasource>

<!-- For hsqldb accessed from jboss only, in-process (standalone) mode
<mbean code="com.mysql.jdbc.Driver"
name="jboss:service=mysql,database=OKMWorkflow">
<attribute name="Database">OKMWorkflow</attribute>
<attribute name="InProcessMode">true</attribute>
</mbean>-->
</datasources>