Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0028566
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformminorhave not tried2015-01-12 14:172017-01-11 13:02
ReportershuehnerView Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0028566: ad_session.websession column is too small

DescriptionThat column is defined as varchar(40) and standard tomcat session id seems to be 32chars (32 hex-chars).
Which fits nicely.

However when using jvmRoute parameter of tomcat this adds some suffix to the session-id values.
So they look like
aa<32chars>.suffix

With the '.' separator that only leaves 7 chars available for the suffix which can easily overflow depending on the admin chosen suffix.



Steps To Reproduce-
Proposed SolutionIncrease length of the websession column to i.e. varchar(64).

Note that qualifies as a api-change. Albeit a probably harmless one as not even inside the ERP anyone uses that column (used for helping debugging)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on feature request 00346543.0PR17Q2 closedalostale some performance improvements in DBSM tasks 
related to design defect 0034490 acknowledgedplatform [clustering] Support clustering 
related to defect 0033621 closedalostale Increase the size of the ad_alert.record_id from 100 to 2000 

-  Notes
(0073426)
shuehner (administrator)
2015-01-12 14:23

Note: length of getId is undefined in spec (implementation dependent) but as we only target tomcat 60 compared to observed 32 should be more then enough for now.

- Issue History
Date Modified Username Field Change
2015-01-12 14:17 shuehner New Issue
2015-01-12 14:17 shuehner Assigned To => AugustoMauch
2015-01-12 14:17 shuehner Modules => Core
2015-01-12 14:17 shuehner Triggers an Emergency Pack => No
2015-01-12 14:23 shuehner Note Added: 0073426
2015-01-12 14:23 shuehner Type defect => feature request
2015-01-12 15:37 alostale Target Version => 3.0PR15Q2
2015-03-31 14:24 alostale Target Version 3.0PR15Q2 => 3.0PR15Q3
2015-03-31 14:24 alostale Assigned To AugustoMauch => platform
2015-03-31 14:24 alostale Status new => acknowledged
2015-06-29 13:32 alostale Target Version 3.0PR15Q3 =>
2016-12-13 07:51 alostale Relationship added related to 0034490
2017-01-11 13:02 alostale Relationship added depends on 0034654
2017-01-11 13:04 alostale Relationship added related to 0033621


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker