Open Source Document Management System | OpenKM

Because information matters
https://forum.openkm.com/

Don't Know

https://forum.openkm.com/viewtopic.php?t=3817

Page 2 of 2

Re: Don't Know

PostPosted:Wed Jun 09, 2010 6:34 pm
by jllort
have you installed propertly jar libs in lib folder ?

Re: Don't Know

PostPosted:Thu Jun 10, 2010 1:20 am
by Vian
Of course

Re: Don't Know

PostPosted:Thu Jun 10, 2010 9:01 am
by jllort
have you modified openkm.cfg in order to enable mysql ?

Re: Don't Know

PostPosted:Thu Jun 10, 2010 9:16 am
by 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>

Re: Don't Know

PostPosted:Thu Jun 10, 2010 9:33 pm
by jllort
Use it in your OpenKM.cfg
Code: Select all
system.database=mysql

Re: Don't Know

PostPosted:Fri Jun 11, 2010 1:29 am
by 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

Re: Don't Know

PostPosted:Fri Jun 11, 2010 5:43 am
by jllort
delete folder repository and start again.

Re: Don't Know

PostPosted:Fri Jun 11, 2010 6:03 am
by 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

Re: Don't Know

PostPosted:Fri Jun 11, 2010 7:22 am
by 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>

Re: Don't Know

PostPosted:Fri Jun 11, 2010 7:32 am
by 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>
All times are UTC
Page 2 of 2
Powered by phpBB® Forum Software © phpBB Limited