• Every Action generate e Mail

  • We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #41767  by muellere
 
Hi all,
i have the situation that all activation in the DMS (p.a. create or delete a file) generate e E-Mail to me. Also from any user!
I have OpenKM Version: 6.3.0 (build: 8156) Community.
BR
Ernst
 #41783  by jllort
 
You want to implementing it, or you have it now and you want to disable it ?
 #41976  by e.mueller
 
Hi jllort,
Many thanks for the response. The Problem ist by many users.

i have it now and i want to disable it.

Here the log-File:
Code: Select all
DEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Oracle]
DEBUG SMTP: useEhlo true, useAuth true
DEBUG SMTP: trying to connect to host "smtp.gmail.com", port 465, isSSL false
220 smtp.gmail.com ESMTP t188sm3665767wma.8 - gsmtp
DEBUG SMTP: connected to host "smtp.gmail.com", port: 465

EHLO t09c01srv02
250-smtp.gmail.com at your service, [213.221.202.39]
250-SIZE 35882577
250-8BITMIME
250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH
250-ENHANCEDSTATUSCODES
250-PIPELINING
250-CHUNKING
250 SMTPUTF8
DEBUG SMTP: Found extension "SIZE", arg "35882577"
DEBUG SMTP: Found extension "8BITMIME", arg ""
DEBUG SMTP: Found extension "AUTH", arg "LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH"
DEBUG SMTP: Found extension "ENHANCEDSTATUSCODES", arg ""
DEBUG SMTP: Found extension "PIPELINING", arg ""
DEBUG SMTP: Found extension "CHUNKING", arg ""
DEBUG SMTP: Found extension "SMTPUTF8", arg ""
DEBUG SMTP: STARTTLS requested but already using SSL
DEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM 
DEBUG SMTP: AUTH LOGIN command trace suppressed
DEBUG SMTP: AUTH LOGIN succeeded
DEBUG SMTP: use8bit false
MAIL FROM:<dms.ejv@gmail.com>
250 2.1.0 OK t188sm3665767wma.8 - gsmtp
RCPT TO:<urs.kneubuehler@jodlerfest-schoetz.ch>
250 2.1.5 OK t188sm3665767wma.8 - gsmtp
RCPT TO:<ernst.mueller@regio-it4you.ch>
250 2.1.5 OK t188sm3665767wma.8 - gsmtp
DEBUG SMTP: Verified Addresses
DEBUG SMTP:   urs.kneubuehler@jodlerfest-schoetz.ch
DEBUG SMTP:   ernst.mueller@regio-it4you.ch
DATA
354  Go ahead t188sm3665767wma.8 - gsmtp
Date: Tue, 28 Jun 2016 14:54:29 +0200 (CEST)
From: root@t09c01srv02
To: urs.kneubuehler@jodlerfest-schoetz.ch, ernst.mueller@regio-it4you.ch
Message-ID: <1443500685.1772.1467118469711.JavaMail.root@t09c01srv02>
Subject: OpenKM - CREATE_DOCUMENT - /okm:root/OK ZSJV JF Schoetz
 2018/Intern/99 Bilder/99 Verschiedenes/DSC_1680.jpg
MIME-Version: 1.0
Content-Type: multipart/mixed; 
	boundary="----=_Part_1770_1106734975.1467118469711"
Charset: UTF-8

------=_Part_1770_1106734975.1467118469711
Content-Type: text/html;charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type"/>
</head>
<body>
<b>Document: </b><a href="https://www.dms-ejv.ch/OpenKM/index.jsp?uuid=f4235ecf-5833-4002-8159-ef65c064434b">/okm:root/OK ZSJV JF Schoetz 2018/Intern/99 Bilder/99 Verschiedenes/DSC_1680.jpg</a><br/><b>User: </b>OK-ZSJV-2018-EMU<br/><b>Event: </b>CREATE_DOCUMENT<br/><b>Comment: </b><br/>
</body>
</html>
------=_Part_1770_1106734975.1467118469711--
.
250 2.0.0 OK 1467118471 t188sm3665767wma.8 - gsmtp
QUIT
2016-06-28 14:55:00,031 [Thread-46207] INFO  com.openkm.extractor.TextExtractorWorker- processSerial.Working on {docUuid=f4235ecf-5833-4002-8159-ef65c064434b, docPath=/okm:root/OK ZSJV JF Schoetz 2018/Intern/99 Bilder/99 Verschiedenes/DSC_1680.jpg, docVerUuid=b8c18a68-3a03-4798-9a05-e9c2544bab2a, date=Tue Jun 28 14:54:29 CEST 2016}
2016-06-28 14:55:00,032 [Thread-46207] WARN  com.openkm.extractor.CuneiformTextExtractor- Undefined OCR application
2016-06-28 14:55:00,032 [Thread-46207] WARN  com.openkm.dao.NodeDocumentDAO- There was a problem extracting text from '/okm:root/OK ZSJV JF Schoetz 2018/Intern/99 Bilder/99 Verschiedenes/DSC_1680.jpg': Too few text extracted
2016-06-28 15:00:00,030 [Thread-46211] INFO  com.openkm.core.UserMailImporter- *** User mail importer activated ***
this mail comes by any Upload Action.
Each upload process , the DMS system sends Mails to the two receivers " urs.kneubuehler@jodlerfest-schoetz.ch and to ernst.mueller@regio-it4you.ch "
I do not know why
have you e solution?
Thanks and BR
Ernst
 #41987  by jllort
 
Take a look if your users are subscribed to some folders. I think this is the reason why are getting these notifications.

Go to at Administration > Database query and execute:
Code: Select all
SELECT * FROM OKM_NODE_SUBSCRIPTOR;
 #41990  by e.mueller
 
Yes , here the result of the query ...
How can I delete subscribing by the user OK-ZSJV-2018-OKP ?
in the gui or with commands?
Attachments
here the Print Screen
here the Print Screen
Bildschirmfoto 2016-06-30 um 14.17.17.png (216.27 KiB) Viewed 3948 times
 #41998  by jllort
 
Only the user can unsubscribe itself, another option is remove the database record from administration ( SQL delete etc... from the same view )
 #42037  by e.mueller
 
Hi,

can you documented the action step by step for "remove the database record from administration ( SQL delete etc... from the same view )" with a example.
Thank you very much for your support.
BR
Ernst
 #42042  by jllort
 
First of all select all the records of the user:
Code: Select all
SELECT * FROM OKM_NODE_SUBSCRIPTOR where NSB_SUBSCRIPTOR='OK-ZSJV-2018-OKP';
Then check each node ( to verify is you really want to unsubscribe from there ).
Code: Select all
http://localhost:8080/OpenKM/frontend/index.jsp?uuid=HERE THE VALUE OF COLUMN NSB_NODE
Finally delete the nodes:
Code: Select all
DELETE FROM OKM_NODE_SUBSCRIPTOR where NSB_SUBSCRIPTOR='OK-ZSJV-2018-OKP' AND NSB_CODE='HERE THE VALUE OF COLUMN NSB_NODE';
 #42048  by e.mueller
 
Hello,
The proposed solution worked.
Code: Select all
DELETE FROM OKM_NODE_SUBSCRIPTOR where NSB_SUBSCRIPTOR='OK-ZSJV-2018-OKP' AND NSB_[b]N[/b]ODE='HERE THE VALUE OF COLUMN NSB_NODE';
Thank you very much.
BR
Ernst

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.