Search found 120 matches

by dferguson
Mon Feb 11, 2019 5:10 pm
Forum: Configuration
Topic: SOLVED: How to change field-type of existing metadata fields?
Replies: 5
Views: 160

Re: How to change field-type of existing metadata fields?

You want to change documents with "text field data" to the equivalent which are now listed in a select list? How about finding all the documents by group name of the text filed with a SQL query? You could then update the group name with the new group name and value. Write a script or other external ...
by dferguson
Mon Feb 11, 2019 3:50 pm
Forum: Installation
Topic: [SOLVED] tomcat service doesn't work
Replies: 10
Views: 1265

Re: [SOLVED] tomcat service doesn't work

I re-installed (after removing and purging) following the OpenKM installation documents and it is starting correctly. This was from the last restart... 2019-02-07 16:04:36,790 [localhost-startStop-1] INFO c.o.servlet.RepositoryStartupServlet - *** Start OpenOffice manager *** 2019-02-07 16:04:36,797...
by dferguson
Fri Feb 08, 2019 1:14 pm
Forum: Installation
Topic: [SOLVED] tomcat service doesn't work
Replies: 10
Views: 1265

Re: tomcat service doesn't work

I ended up finding that with the pre-installed OfficeLibre in Ubuntu 18.04.1 the soffice service wasn't starting/closing as expected. I uninstalled/removed OfficeLibre and reinstalled per OpenKM knowledge base and now start up and exit are as expected.
by dferguson
Thu Feb 07, 2019 8:32 pm
Forum: Configuration
Topic: [SOLVED] JavaMail not working with Office 365
Replies: 5
Views: 202

Re: JavaMail not working with Office 365

Great!

You might clarify that as indicated by the Office 365 Javadocs link provided in the OpenKM documentation, the username would be:

Code: Select all

mail.smtp.user="example@yourdomain.com"
mail.smtp.from="example@yourdomain.com"
by dferguson
Thu Feb 07, 2019 3:11 pm
Forum: Configuration
Topic: SOLVED: How to move a imported file in aspecific folder based on metadata
Replies: 2
Views: 89

Re: How to move a imported file in aspecific folder based on metadata

You write a SQL query to select all items in the "import" folder based on metadata; select NBS_UUID from OKM_NODE_BASE inner join OKM_NODE_PROPERTY on OKM_NODE_BASE.NBS_UUID = OKM_NODE_PROPERTY.NPG_NODE where OKM_NODE_BASE.NBS_PARENT = 'parent folder UUID' and OKM_NODE_PROPERTY.NPG_GROUP = 'okp:your...
by dferguson
Tue Feb 05, 2019 4:38 pm
Forum: Configuration
Topic: Can preview pdf but not word or excel documents.
Replies: 4
Views: 1237

Re: Can preview pdf but not word or excel documents.

On two installations, I have found that I needed to remove the OfficeLibre that came preinstalled with Ubuntu and then reinstall per the OpenKM setup instructions. Having OpenOffice of OfficeLibre installed ins't enough. I still ran into issues when just updating/upgrading the preinstalled installat...
by dferguson
Mon Feb 04, 2019 12:50 pm
Forum: Configuration
Topic: [SOLVED] JavaMail not working with Office 365
Replies: 5
Views: 202

Re: JavaMail not working with Office 365

Code: Select all

DEBUG SMTP: AUTH LOGIN failed
credentials are correct but I still get this...
by dferguson
Fri Feb 01, 2019 8:50 pm
Forum: Configuration
Topic: [SOLVED] JavaMail not working with Office 365
Replies: 5
Views: 202

Re: JavaMail not working with Office 365

I cleaned up my config settings to: <Resource name="mail/OpenKM" type="javax.mail.Session" mail.transport.protocol="smtp" mail.smtp.auth="true" mail.smtp.host="smtp.office365.com" mail.smtp.user="Docs" password="password" mail.smtp.port="587" mail.smtp.starttls.enable="true" mail.debug="true" /> and...
by dferguson
Fri Feb 01, 2019 7:52 pm
Forum: Configuration
Topic: [SOLVED] JavaMail not working with Office 365
Replies: 5
Views: 202

[SOLVED] JavaMail not working with Office 365

I have successfully used the tomcat mail with gmail before, but this installation requires me to use our Office 365 account. Here is my server.xml file section for mail configuration. <Resource name="mail/OpenKM" auth="Container" type="javax.mail.Session" mail.transport.protocol="smtp" mail.smtp.hos...
by dferguson
Mon Jan 28, 2019 8:32 pm
Forum: Installation
Topic: [SOLVED] tomcat service doesn't work
Replies: 10
Views: 1265

Re: tomcat service doesn't work

I gathered that the port was already in use. My question is, why does tomcat shutdown not close those ports and thus ensure a clean restart?
by dferguson
Tue Jan 22, 2019 1:22 pm
Forum: Installation
Topic: [SOLVED] tomcat service doesn't work
Replies: 10
Views: 1265

Re: tomcat service doesn't work

I've deployed Ubuntu 18.04.1 LTS in a virtual machine (VMWare Workstation Pro12, Windows 10 Pro). The office manager has quit again this morning and I tried to restart and it hung with these results. ● tomcat.service - LSB: Start and stop Apache Tomcat Loaded: loaded (/etc/init.d/tomcat; generated) ...
by dferguson
Thu Jan 17, 2019 1:52 pm
Forum: Installation
Topic: [SOLVED] tomcat service doesn't work
Replies: 10
Views: 1265

Re: tomcat service doesn't work

I ran a status request and got this back.. tomcat.service - LSB: Start and stop Apache Tomcat Loaded: loaded (/etc/init.d/tomcat; generated) Active: active (exited) since Wed 2019-01-16 14:04:33 EST; 18h ago Docs: man:systemd-sysv-generator(8) Tasks: 0 (limit: 4982) CGroup: /system.slice/tomcat.serv...
by dferguson
Wed Jan 16, 2019 7:12 pm
Forum: Installation
Topic: [SOLVED] tomcat service doesn't work
Replies: 10
Views: 1265

[SOLVED] tomcat service doesn't work

I have installed OpenKM multiple times and never had this issue, but starting tomcat with sudo service tomcat start doesn't work. To get tomcat to start I have to execute /home/openkm/$tomcat_home/bin/startup.sh Likewise stopping the service doesn't work I have to execute the shutdown.sh. I have con...
by dferguson
Thu Oct 18, 2018 1:23 pm
Forum: Usage
Topic: Activity log doesn't show any RENAME_DOCUMENT entries
Replies: 2
Views: 842

Re: Activity log doesn't show any RENAME_DOCUMENT entries

Thanks! That entry was not in the list. I have looked through the knowledge center and couldn't find the reference for editing that parameter. Apologize for not making that connection.
by dferguson
Tue Oct 16, 2018 5:59 pm
Forum: New features discussion
Topic: Electronic signature
Replies: 12
Views: 7389

Re: Electronic signature

Sorry to not have followed up on this. We have decided to use the document Notes feature to track document approvals and will abandon the use of document signatures.