Bugs item #3088218, was opened at 2010-10-15 13:12
Message generated for change (Comment added) made by libertytrek
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=3088218&group_id=191583
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: https://www.google.com/accounts ()
Assigned to: Nobody/Anonymous (nobody)
Summary: Field size tweaking per RFC 2821 section 4.5.3.1
Initial Comment:
In summary, if it's an email address, it should be 320 characters, if it's a localpart, it should be 64 characters.
For table alias, the address column should be varchar(320)
for table admin, the username column should be varchar(320) for consistency
for table domain_admins, the username column should be varchar(320) for consistency
for table quota2, the username column should be varchar(320)
for table fetchmail, the username and src_user columns should be varchar(320)
for table vacation, the email column should be varchar(320)
for table log, the username column should be varchar(320)
for table quota, the username column should be varchar(320)
for table mailbox, the username column should be varchar(320), the local_part column should be varchar(64)
for table vacation_notification, the on_vacation and notified columns should be varchar(320)
doman.transport probably needs to be tweaked as well, but I've not had the opportunity to read the postfix documentation and source to determine that limit (I'm thinking max_length_transport_type + 1 (separator) + 255 (destination domain))
----------------------------------------------------------------------
Comment By: Charles (libertytrek)
Date: 2010-10-15 13:16
Message:
If these are changed hopefully appropriate error-checking and error
messages will also be provided... (I wish I could do it myself, but alas, a
programmer I am not)...
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=3088218&group_id=191583
|