starred/anonaddy

Fork 0

mirror of https://github.com/anonaddy/anonaddy.git synced 2026-04-25 06:05:55 +03:00

[GH-ISSUE #277] failed delivery code column too long causing SQL error #799

New issue

Closed

opened 2026-03-14 10:39:54 +03:00 by kerem · 5 comments

kerem commented

2026-03-14 10:39:54 +03:00

Owner

Originally created by @makua104 on GitHub (Mar 14, 2022).
Original GitHub issue: https://github.com/anonaddy/anonaddy/issues/277

This happened in a self-hosted v10.1 instance when trying to send to a google workspace address' alias.

I sent an email to a google workspace address' alias bbbbb+aaaaa@xxxxxxxxx.xxxx.xx instead of aaaaa+bbbbb@xxxxxxxxx.xxxx.xx causing a failed delivery.

The beginning of the error in the AnonAddy storage logs looks like this

production.ERROR: SQLSTATE[xxxxx]: String data, right truncated: 1406 Data too long for column 'code' at row 1`
(SQL: insert into failed_deliveries (recipient_id, alias_id, bounce_type, remote_mta, sender, email_type, status, code, attempted_at, user_id, id, updated_at, created_at)
...

The contents of the code column were

smtp; 550-5.1.1 The email account that you tried to reach does     not exist. Please try 550-5.1.1 double-checking the recipient's email     address for typos or 550-5.1.1 		unnecessary spaces. Learn more at 550 5.1.1     https://support.google.com/mail/?p=NoSuchUser     xxx-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xx - gsmtp

Originally created by @makua104 on GitHub (Mar 14, 2022). Original GitHub issue: https://github.com/anonaddy/anonaddy/issues/277 This happened in a self-hosted v10.1 instance when trying to send to a google workspace address' alias. I sent an email to a google workspace address' alias `bbbbb+aaaaa@xxxxxxxxx.xxxx.xx` instead of `aaaaa+bbbbb@xxxxxxxxx.xxxx.xx` causing a failed delivery. The beginning of the error in the AnonAddy storage logs looks like this ``` production.ERROR: SQLSTATE[xxxxx]: String data, right truncated: 1406 Data too long for column 'code' at row 1` (SQL: insert into failed_deliveries (recipient_id, alias_id, bounce_type, remote_mta, sender, email_type, status, code, attempted_at, user_id, id, updated_at, created_at) ... ``` The contents of the code column were ``` smtp; 550-5.1.1 The email account that you tried to reach does not exist. Please try 550-5.1.1 double-checking the recipient's email address for typos or 550-5.1.1 unnecessary spaces. Learn more at 550 5.1.1 https://support.google.com/mail/?p=NoSuchUser xxx-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xx - gsmtp ```

kerem closed this issue

2026-03-14 10:40:00 +03:00

kerem commented

2026-03-14 10:40:06 +03:00

Author

Owner

@willbrowningme commented on GitHub (Mar 14, 2022):

The diagnostic code is already limited in ReceiveEmail.php - https://github.com/anonaddy/anonaddy/blob/master/app/Console/Commands/ReceiveEmail.php#L321

What version of MariaDB are you using and what charset?

@willbrowningme commented on GitHub (Mar 14, 2022): The diagnostic code is already limited in `ReceiveEmail.php` - https://github.com/anonaddy/anonaddy/blob/master/app/Console/Commands/ReceiveEmail.php#L321 What version of MariaDB are you using and what charset?

kerem commented

2026-03-14 10:40:11 +03:00

Author

Owner

@makua104 commented on GitHub (Mar 14, 2022):

Oh that's strange.

Version from mariadb --version is 15.1
Output of select @@character_set_database; of the AnonAddy db is utf8mb4

Is that what you're looking for?

@makua104 commented on GitHub (Mar 14, 2022): Oh that's strange. - Version from `mariadb --version` is `15.1` - Output of `select @@character_set_database;` of the AnonAddy db is `utf8mb4` Is that what you're looking for?

kerem commented

2026-03-14 10:40:16 +03:00

Author

Owner

@willbrowningme commented on GitHub (Mar 14, 2022):

Is the distribution output from that command Distrib 10.5.15-MariaDB?

@willbrowningme commented on GitHub (Mar 14, 2022): Is the distribution output from that command `Distrib 10.5.15-MariaDB`?

kerem commented

2026-03-14 10:40:21 +03:00

Author

Owner

@makua104 commented on GitHub (Mar 14, 2022):

Yes

@makua104 commented on GitHub (Mar 14, 2022): Yes

kerem commented

2026-03-14 10:40:26 +03:00

Author

Owner

@willbrowningme commented on GitHub (Mar 14, 2022):

I've just pushed a new release that should fix this - https://github.com/anonaddy/anonaddy/releases/tag/v0.11.1

@willbrowningme commented on GitHub (Mar 14, 2022): I've just pushed a new release that should fix this - https://github.com/anonaddy/anonaddy/releases/tag/v0.11.1

No labels

bug

pull-request

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/anonaddy#799

No description provided.

Rows
Columns