Opened 14 years ago
Closed 14 years ago
#3457 closed defect (fixed)
MapServer throws internal server error when ora-28002 returns from Oracle connection
| Reported by: | msmitherdc | Owned by: | aboudreault |
|---|---|---|---|
| Priority: | normal | Milestone: | 6.0 release |
| Component: | Input - Native Oracle Spatial Support | Version: | svn-trunk (development) |
| Severity: | normal | Keywords: | oracle, ora-28002, pasword, warning, error |
| Cc: | dmorissette |
Description
ORA-28002 is a warning error message that the password is expiring. However, MapServer reports no error in the debug log and throws a 500 internal server error.
Change History (3)
comment:1 by , 14 years ago
| Owner: | changed from to |
|---|
comment:2 by , 14 years ago
| Cc: | added |
|---|---|
| Owner: | changed from to |
comment:3 by , 14 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
Since we're supposed to be able to use the connection in the grace period, I've taken a look if we couldn't allow it in MapServer. Unfortunately, the C API seems to consider this as an error and set the OCIEnv as invalid. The way I've found to by-pass that error would be to use an OCISession with a OCISessionBegin() call before the login... but we're not using them at all in our code. I don't think it's worth to change much code for that. Let me know if you don't agree.
Now, the error is reported and MapServer exits gracefully.
Fixed and comitted in r10195.
I'll reassign to Alan to look into this. Hopefully there is an easy way to force the password expiration to reproduce and test this.