Ticket #3457 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

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

Changed 3 years ago by msmitherdc

  • owner changed from aboudreault to dmorissette

Changed 3 years ago by dmorissette

  • cc dmorissette added
  • owner changed from dmorissette to aboudreault

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.

Changed 3 years ago by aboudreault

  • status changed from new to closed
  • resolution set to fixed

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.

Note: See TracTickets for help on using tickets.