Mail import error (6.3.9. Community Edition)

[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

[Richard LU]

You can configure mail filters. Take a look at http://wiki.openkm.com/index.php/Administring_users

[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 ?