Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010122 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Z. Others | critical | always | 2009-07-30 09:48 | 2013-06-18 13:03 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | gorka_gil | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0010122: The oracle password should not expire automatically without any message | |||||||
| Description | The oracle password should expire automatically without any message, because it could happend that the production environment became inaccessible. | |||||||
| Steps To Reproduce | After a while working with the application the password of the user expires. | |||||||
| Proposed Solution | At least this functionality should be explained in the manual, and an option to disable the expiration should be explained. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||
|
|||||||||
 Relationships |
|
Notes |
|
|
(0018704) networkb (viewer) 2009-07-30 10:03 |
The expiration is defined in the profile: select resource_name, resource_type, limit from dba_profiles where profile='DEFAULT'; indicate how could be configured this profile depending on the clients requirements. |
|
(0018762) gorka_gil (administrator) 2009-07-31 12:57 |
The default behavior in oracle 11g (the ones that comes with obn 2.40) is an expiration time for passwords of 180 days plus 7 grace days. How to know that password is expired? - In sqlplus shows a clear message when you try to connect. - In web interface of Openbravo ERP shows an error saying it can't connect to database: javax.servlet.ServletException: @CODE=@There are no connections available in jdbc:apache:commons:dbcp:openbravo_myPool. Note: The web interface can work with the account expired till the next tomcat restart. For check when expires the accounts, you can execute this with dba privileges: set line 120 select username, account_status, expiry_date, lock_date from dba_users; For change the passwords: Execute sqlplus and connect with the user of Openbravo ERP and it will ask you to change the password. Also you need to enter with the "system" account to reset its password. If you change any of the password, remember to update the Openbravo.properties file. Note: You can set the same password again. For disable the password expiration. With dba privileges execute: ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; |
|
(0018774) gorka_gil (administrator) 2009-08-01 17:58 |
The missing documentation about oracle password expiration is here: http://wiki.openbravo.com/wiki/Openbravo_SMB_Network_One_Administrator%27s_Manual_2.40#Database_password_expiration [^] |
|
(0019445) priyam (administrator) 2009-09-03 13:12 |
Fixed in the appliance and available for QA to test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-07-30 09:48 | networkb | New Issue | |
| 2009-07-30 09:48 | networkb | Assigned To | => jpabloae |
| 2009-07-30 09:48 | networkb | OBNetwork customer | => Yes |
| 2009-07-30 10:03 | networkb | Note Added: 0018704 | |
| 2009-07-30 13:46 | networkb | Summary | The oracle password should expire automatically without any message => The oracle password should not expire automatically without any message |
| 2009-07-30 20:34 | gorka_gil | Assigned To | jpabloae => gorka_gil |
| 2009-07-31 12:57 | gorka_gil | Note Added: 0018762 | |
| 2009-08-01 17:57 | gorka_gil | Project | Openbravo Deployment Options => Documentation |
| 2009-08-01 17:57 | gorka_gil | Status | new => scheduled |
| 2009-08-01 17:57 | gorka_gil | fix_in_branch | => pi |
| 2009-08-01 17:58 | gorka_gil | Status | scheduled => resolved |
| 2009-08-01 17:58 | gorka_gil | Resolution | open => fixed |
| 2009-08-01 17:58 | gorka_gil | Note Added: 0018774 | |
| 2009-08-01 18:07 | gorka_gil | Relationship added | related to 0010149 |
| 2009-09-03 13:12 | priyam | Note Added: 0019445 | |
| 2009-11-10 12:55 | jpabloae | Category | SMB Network One => Z Other |
| 2011-03-31 11:45 | networkb | Status | resolved => closed |
| 2013-06-18 13:00 | psanjuan | Project | Documentation => Openbravo ERP |
| 2013-06-18 13:03 | psanjuan | Category | Z Other => Z. Others |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |