Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049749Openbravo ERP01. General setuppublic2022-07-07 08:162022-10-11 11:58
Reportergowthamveeramuthu 
Assigned Toablasco 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR22Q4 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0049749: Email Smtp Server Password is not allowed to save 60 characters but allows to enter 60 character.
DescriptionHi Team,

in client window, Email configuration tab. Smtp Server Password is allowed to enter 60 characters.
so we have filled the password with 60 character but while saving it, it shows error of

"Saving failed. EmailServerConfiguration.Smtp Server Password: Value too long. Length 88, maximum allowed 60 [d59V6pwWCuBemCJaTgs3yDCfPAWe7WkWt4ORY5/VbWFKkYBQVRtMwnefVeqcFgrgXpgiWk4LN8iiz1Ew15/FNA==]"
Steps To Reproduce1. open client window.
2. Email configuration tab -> fill the value of "Smtp Server Password" with 60 characters.
3. its failed to save.
Proposed Solution
Additional Information
TagsNOR
Relationships
related to defect 0049798 closed ablasco API change: SmtpServerPasswod length from 60 to 200 in c_poc_configuration 
related to defect 0050477 new ablasco Email Smtp Server Password is not allowed to save 60 characters but allows to enter 60 character. 
Attached Filespng Screen Shot 2022-07-07 at 11.44.34 AM.png (75,833) 2022-07-07 08:16
https://issues.openbravo.com/file_download.php?file_id=17282&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2022-07-07 08:16gowthamveeramuthuNew Issue
2022-07-07 08:16gowthamveeramuthuAssigned To => AugustoMauch
2022-07-07 08:16gowthamveeramuthuFile Added: Screen Shot 2022-07-07 at 11.44.34 AM.png
2022-07-07 08:16gowthamveeramuthuModules => Core
2022-07-07 08:16gowthamveeramuthuTriggers an Emergency Pack => No
2022-07-08 14:43cbernerAssigned ToAugustoMauch => ablasco
2022-07-08 14:43cbernerStatusnew => acknowledged
2022-07-08 14:44cbernerStatusacknowledged => scheduled
2022-07-12 11:18hgbotNote Added: 0139267
2022-07-13 13:58ablascoRelationship addedrelated to 0049798
2022-07-14 09:02hgbotResolutionopen => fixed
2022-07-14 09:02hgbotStatusscheduled => closed
2022-07-14 09:02hgbotFixed in Version => PR22Q4
2022-07-14 09:02hgbotNote Added: 0139319
2022-07-14 09:02hgbotNote Added: 0139320
2022-08-05 15:52rafarodaTag Attached: NOR
2022-10-11 11:58Irune_MonrealIssue cloned0050477
2022-10-11 11:58Irune_MonrealRelationship addedrelated to 0050477

Notes
(0139267)
hgbot   
2022-07-12 11:18   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/645 [^]
(0139319)
hgbot   
2022-07-14 09:02   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 2793c1c5269f935ff06c95bb8dd6991f9bd888f2
Author: Adrián Blasco <adrian.blasco@openbravo.com>
Date: 14-07-2022 07:02:08
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/2793c1c5269f935ff06c95bb8dd6991f9bd888f2 [^]

Fixes ISSUE-49749: SMTP Password expanded to 200 characters in order to avoid limit 60 due to encryption

Length has been expanded on the column smptpassword due to this being encrypted, it will allow passwords as long as 0000242:0000140 characters, which should be more than needed for most cases.

---
M src-db/database/model/tables/C_POC_CONFIGURATION.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0139320)
hgbot   
2022-07-14 09:02   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/645 [^]