Page 1 of 1

Mail import error (6.3.9. Community Edition)

PostPosted:Mon Apr 13, 2020 7:21 pm
by MKochS
Mail import fail s on a fresh 6.3.9 install ( on Debian Buster). Here's a section of catalina.out:
Code: Select all
2020-04-13 19:00:08,118 [Thread-80] INFO  com.openkm.util.MailUtils - ======= ======= 26 ======= =======
2020-04-13 19:00:08,119 [Thread-80] INFO  com.openkm.util.MailUtils - Folder: INBOX
2020-04-13 19:00:08,126 [Thread-80] INFO  com.openkm.util.MailUtils - Subject: Topic reply notification - "Database error OKM-013024 ndex OKM_DASHBOA
RD_ACTIVITY is corrupted"
2020-04-13 19:00:08,127 [Thread-80] INFO  com.openkm.util.MailUtils - From: forum@openkm.com
2020-04-13 19:00:08,127 [Thread-80] INFO  com.openkm.util.MailUtils - Received: Thu Apr 09 12:23:35 CEST 2020
2020-04-13 19:00:08,127 [Thread-80] INFO  com.openkm.util.MailUtils - Sent: Thu Apr 09 12:23:33 CEST 2020
2020-04-13 19:00:08,182 [Thread-80] INFO  c.o.m.db.stuff.DbSimpleAccessManager - ***************************
2020-04-13 19:00:08,182 [Thread-80] INFO  c.o.m.db.stuff.DbSimpleAccessManager - ***************************
2020-04-13 19:00:08,183 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.module.db.stuff.DbSimpleAccessManager -> isGranted (DbSimpleAccessManager.java:67)
2020-04-13 19:00:08,183 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.module.db.stuff.SecurityHelper -> checkRead (SecurityHelper.java:98)
2020-04-13 19:00:08,183 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.dao.NodeFolderDAO -> findByPk (NodeFolderDAO.java:202)
2020-04-13 19:00:08,183 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.module.db.DbFolderModule -> create (DbFolderModule.java:84)
2020-04-13 19:00:08,184 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.api.OKMFolder -> createSimple (OKMFolder.java:68)
2020-04-13 19:00:08,184 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.api.OKMFolder -> createMissingFolders (OKMFolder.java:200)
2020-04-13 19:00:08,184 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.util.MailUtils -> importMessages (MailUtils.java:665)
2020-04-13 19:00:08,185 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.util.MailUtils -> importMessages (MailUtils.java:583)
2020-04-13 19:00:08,185 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.core.UserMailImporter -> runAs (UserMailImporter.java:89)
2020-04-13 19:00:08,185 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.core.UserMailImporter -> run (UserMailImporter.java:60)
2020-04-13 19:00:08,186 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.util.ExecutionUtils -> runScript (ExecutionUtils.java:106)
2020-04-13 19:00:08,186 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.core.Cron$RunnerBsh -> run (Cron.java:99)
2020-04-13 19:00:08,186 [Thread-80] INFO  c.o.m.db.stuff.DbSimpleAccessManager - ***************************
2020-04-13 19:00:08,187 [Thread-80] INFO  c.o.m.db.stuff.DbSimpleAccessManager - ***************************
2020-04-13 19:00:08,192 [Thread-80] WARN  com.openkm.util.MailUtils - null
java.lang.NullPointerException: null
        at com.openkm.module.db.DbFolderModule.create(DbFolderModule.java:101) ~[classes/:6.3.9]
        at com.openkm.api.OKMFolder.createSimple(OKMFolder.java:68) ~[classes/:6.3.9]
        at com.openkm.api.OKMFolder.createMissingFolders(OKMFolder.java:200) ~[classes/:6.3.9]
        at com.openkm.util.MailUtils.importMessages(MailUtils.java:665) [classes/:6.3.9]
        at com.openkm.util.MailUtils.importMessages(MailUtils.java:583) [classes/:6.3.9]
        at com.openkm.core.UserMailImporter.runAs(UserMailImporter.java:89) [classes/:6.3.9]
        at com.openkm.core.UserMailImporter.run(UserMailImporter.java:60) [classes/:6.3.9]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_252-ea]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_252-ea]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_252-ea]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_252-ea]
        at bsh.Reflect.invokeMethod(Reflect.java:166) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.Reflect.invokeObjectMethod(Reflect.java:99) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.Interpreter.eval(Interpreter.java:664) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.Interpreter.eval(Interpreter.java:758) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.Interpreter.eval(Interpreter.java:747) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:106) [classes/:6.3.9]
        at com.openkm.core.Cron$RunnerBsh.run(Cron.java:99) [classes/:6.3.9]
        at java.lang.Thread.run(Thread.java:748) [na:1.8.0_252-ea]
The mail is available on request.

So far, not a single mail has been imported.


TIA
Matthias

Re: Mail import error (6.3.9. Community Edition)

PostPosted:Thu Apr 16, 2020 7:38 am
by Richard LU
You can configure mail filters. Take a look at http://wiki.openkm.com/index.php/Administring_users

Re: Mail import error (6.3.9. Community Edition)

PostPosted:Sat Apr 18, 2020 10:18 am
by jllort
First, you should not use wiki.openkm.com the documentation from there is deprecated you should use docs.openkm.com

How are you importing the email? with outlook addin, the msg or eml file ?