[ZendTo] DestName limit

[Orion Poplawski]

One of our users hit a request error sending a dropoff.  The only user visible
error was "Sending a request to these addresses failed: ...."

However the log showed:

Error: Failed to add 661518051 to reqtable for greg at nwra.com. Error was Data
too long for column 'DestName' at row 1

Looks like the original name was 35 characters due to various suffixes like
"(Short Name) CTR (USA)"

which is longer than the 32 characters currently allowed:

> show columns from reqtable;
+------------+---------------+------+-----+---------+-------+
| Field      | Type          | Null | Key | Default | Extra |
+------------+---------------+------+-----+---------+-------+
| Auth       | varchar(64)   | NO   | PRI | NULL    |       |
| SrcName    | varchar(32)   | YES  |     | NULL    |       |
| SrcEmail   | text          | NO   |     | NULL    |       |
| SrcOrg     | varchar(256)  | NO   |     | NULL    |       |
| DestName   | varchar(32)   | YES  |     | NULL    |       |
| DestEmail  | text          | NO   |     | NULL    |       |
| Note       | text          | NO   |     | NULL    |       |
| Subject    | text          | NO   |     | NULL    |       |
| Expiry     | bigint(20)    | NO   |     | NULL    |       |
| Passphrase | varchar(1024) | NO   |     |         |       |
| Start      | bigint(20)    | NO   |     | 0       |       |
| Created    | bigint(20)    | NO   |     | 0       |       |
+------------+---------------+------+-----+---------+-------+

So, two requests:
* Might be good to bump that limit
* Can we get better error messages reported back to the user in these cases?

Thanks again for the very useful software,

Orion

-- 
Orion Poplawski
he/him/his  - surely the least important thing about me
Manager of IT Systems                      720-772-5637
NWRA, Boulder Office                  FAX: 303-415-9702
3380 Mitchell Lane                       orion at nwra.com
Boulder, CO 80301                 https://www.nwra.com/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4087 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://jul.es/pipermail/zendto/attachments/20250425/c3211acb/attachment-0001.p7s>