6.3.0: Mail export fails whith "illegal address" error

[MKochS]

Mail export fails as soon as the export process hits a mail with unexpected characters in the address line. I have the following in catalina.log:

Code: Select all

2017-04-05 11:50:36,064 [http-bio-127.0.0.1-8080-exec-85] ERROR com.openkm.util.impexp.RepositoryExporter- Illegal address
javax.mail.internet.AddressException: Illegal address in string ``Doe, John <john.doe@invalid>''

As a result, the whole export process stops and nothing is exported at all.

I'm getting this several times. What all mails in question seem to have in common is the comma between last and first name. Is there a workaround?

TIA
Mattias

[pavila]

You need to fix it in database before exporting.

[yiannis22]

I have the same problem now.
I'd like to move the system to a new machine and within this step changing from HSQLDB to MySQL.
On the old machine I did all the migrations till version 6.3.6
If I do the repository export now, I am getting lots of "illegal address" errors.
Is there any way to correct them automatically ?
Or..in case...how do I correct them manually in the old system ?

rgds

Thomas

[jllort]

The next script should help in detecting problematic emails:

Code: Select all

import com.openkm.core.DatabaseException;
import com.openkm.dao.bean.NodeMail;
import com.openkm.dao.HibernateUtil;
import javax.mail.internet.*;
import org.hibernate.*;
import java.util.*;

String qs = "from NodeMail nm";
Session session = null;

try {
    session = HibernateUtil.getSessionFactory().openSession();
    session.beginTransaction();
 
    Query q = session.createQuery(qs);
 
    for (NodeMail nm : q.list()) {
        try {
            new InternetAddress(nm.getFrom());
            for (String address : nm.getTo()) {
                new InternetAddress(address);
            }
            for (String address : nm.getReply()) {
                new InternetAddress(address);
            }
            for (String address : nm.getCc()) {
                new InternetAddress(address);
            }
            for (String address : nm.getBcc()) {
                new InternetAddress(address);
            }
        } catch (AddressException e) {
            print("Error con : " + nm.getUuid() + "<br>");
        }
    }
 
    HibernateUtil.commit(session.getTransaction());
} catch (HibernateException e) {
    HibernateUtil.rollback(session.getTransaction());
    throw new DatabaseException(e.getMessage(), e);
} finally {
    HibernateUtil.close(session);
}

you can try to solve with this script ( what removes a comma beween the name and the email "Name, <email>" , this is the most common issue, if not should investigate in deep a single email data to indentify the problema and then build a script to apply the correction )

Code: Select all

import com.openkm.core.DatabaseException;
import com.openkm.dao.bean.NodeMail;
import com.openkm.dao.HibernateUtil;
import javax.mail.internet.*;
import org.hibernate.*;
import java.util.*;

String qs = "from NodeMail nm";
Session session = null;

try {
    session = HibernateUtil.getSessionFactory().openSession();
    session.beginTransaction();
 
    Query q = session.createQuery(qs);
    
    for (NodeMail nm : q.list()) {
        try {
            new InternetAddress(nm.getFrom());
            for (String address : nm.getTo()) {
                new InternetAddress(address);
            }
            for (String address : nm.getReply()) {
                new InternetAddress(address);
            }
            for (String address : nm.getCc()) {
                new InternetAddress(address);
            }
            for (String address : nm.getBcc()) {
                new InternetAddress(address);
            }
        } catch (AddressException e) {
            print("Error con : " + nm.getUuid() + "<br>");
            nm.from = nm.from.replaceAll(",", "").trim();

            // to
            Set to = new HashSet();
            for (String address : nm.getTo()) {
                to.add(address.replaceAll(",", "").trim());
            }
            nm.to = to;

            // reply
            Set reply = new HashSet();
            for (String address : nm.getReply()) {
                reply.add(address.replaceAll(",", "").trim());
            }
            nm.reply = reply;

            // Cc
            Set cc = new HashSet();
            for (String address : nm.getCc()) {
                cc.add(address.replaceAll(",", "").trim());
            }
            nm.cc = cc;

            // Bcc
            Set bcc = new HashSet();
            for (String address : nm.getBcc()) {
                bcc.add(address.replaceAll(",", "").trim());
            }
            nm.bcc = bcc;
            session.update(nm);
        }
    }
 
    HibernateUtil.commit(session.getTransaction());
} catch (HibernateException e) {
    HibernateUtil.rollback(session.getTransaction());
    throw new DatabaseException(e.getMessage(), e);
} finally {
    HibernateUtil.close(session);
}