Good day Guys

Im working on migrating data from a PostgreSQL Roundcube database into MariaDB, and I've run into an issue with the collected_addresses table that I'd like some clarification on.

In PostgreSQL, the email column is defined as varchar(255) with default collation, which performs strict byte-wise comparisons. Because of this, PostgreSQL correctly treats accented characters as distinct. For example:

kardiológia@removed.

kardiologia@removed.

These coexist without conflict.

However, after importing into MariaDB, I receive a "Duplicate entry" error when inserting an address like kardiologia@..., because MariaDB's default collations (utf8mb4_unicode_ci, utf8mb4_general_ci, etc.) are accent-insensitive and fold characters like ó into o. This means MariaDB considers the two addresses equivalent at the index level.

To resolve this, I am considering changing the email column and the related UNIQUE index to use COLLATE utf8mb4_bin

This would ensure that email addresses are compared strictly based on their binary/Unicode code points and would match PostgreSQL's behavior.

Before I make this change, I want to check with the Roundcube team and community:

1) Is using utf8mb4_bin on collected_addresses.email safe and compatible with Roundcube's expected behavior?
2) Are there any pitfalls, side effects, or Roundcube features that may break when using binary collation on this column?

Any guidance, recommendations, or experiences would be greatly appreciated.
Thank you in advance.

Yes, 1.4.15 runs great for me!  To keep my woo hoo custom animated emojis, I Don't want to upgrade for as long as possible!   😎

Thank you John, will do!

Roundcube is not a service but free software which somebody installed for you. Please contact your internet hosting provider or IT responsible instead. If you don't know who this might be, please review your bills and find out who you're paying for email services.

I'm not receiving emails and received a server error. I'm accessing my email account by logging into the Webmail business site on Chrome.  I'm not having any internet issues or any issues receiving email to my personal gmail account. Any guidance on next steps? Thanks!

There seems to be a more recent open source "scheduled_sending" plugin https://github.com/texxasrulez/scheduled_sending

I haven't used it myself but it looks promising.

How f#Ck!Ng cheap or poor do you have to be to fucking charge for a scheduled send/delay send service when your an email platform??

Have no hopes in competeing w/ Microsoft or Alphabet I take it...

Solved.

In the errors.log of RC there was a line I didn't see before (my bad):
Peer certificate CN=`mail.xxxx.lan' did not match expected CN=`imap.xxxx.lan'

The dovecot certificate is for mail.xxxx.lan and in the RC config file there was imap.xxxx.lan

After changing that in the RC config file I could login using RC.
Also changed imap_auth_type from LOGIN to PLAIN.
Don't know if that is necessary or not.

Thanks for your help.

OK that's helpful, I think we're past the issue with the certificate. Can you try changing your imap host from ssl://... to tls://... and see if that works?

The error changed after I changed the the permission.
Setting verify_peer to false didn't make any difference.

Never logged in successfully with Roundcube. Thunderbird works.