Hello,
i'm using a custom ntlm authorisation package using apache, mod_plsql and mod_ntlm in one of my applications. This works great on all but one user and his computer.
When the user tries to access my application he gets a 404 error.
In the apache access log i can see his login attemps:
xxx.xxx.xxx.xxx - - [27/Sep/2010:09:22:46 +0200] "GET / HTTP/1.1" 301 357
xxx.xxx.xxx.xxx - - [27/Sep/2010:09:22:46 +0200] "GET /pls/apex/f?p=200 HTTP/1.1" 401 519
xxx.xxx.xxx.xxx - - [27/Sep/2010:09:22:46 +0200] "GET /pls/apex/f?p=200 HTTP/1.1" 401 519
xxx.xxx.xxx.xxx - DOMAIN\\USERNAME [27/Sep/2010:09:22:46 +0200] "GET /pls/apex/f?p=200 HTTP/1.1" 302 5
xxx.xxx.xxx.xxx - - [27/Sep/2010:09:22:46 +0200] "GET /pls/apex/f?p=200:1 HTTP/1.1" 401 519
xxx.xxx.xxx.xxx - - [27/Sep/2010:09:22:46 +0200] "GET /pls/apex/f?p=200:1 HTTP/1.1" 401 519
xxx.xxx.xxx.xxx - DOMAIN\\USERNAME [27/Sep/2010:09:22:46 +0200] "GET /pls/apex/f?p=200:1 HTTP/1.1" 302 5
xxx.xxx.xxx.xxx - - [27/Sep/2010:09:22:46 +0200] "GET /pls/apex/f?p=200:1:1609475257699607 HTTP/1.1" 401 519
xxx.xxx.xxx.xxx - - [27/Sep/2010:09:22:46 +0200] "GET /pls/apex/f?p=200:1:1609475257699607 HTTP/1.1" 401 519
xxx.xxx.xxx.xxx - DOMAIN\\USERNAME [27/Sep/2010:09:22:46 +0200] "GET /pls/apex/f?p=200:1:1609475257699607 HTTP/1.1" 404 326
In the apache error.log i get this error message
mod_plsql: /pls/apex/f HTTP-404 ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: in "APEX_030200.F", line 279
ORA-06512: in line 31
Since the procedure f is wrapped i can't take a look at it to see what is wrong here. Apperently some string buffer is too small, but which one?
The authentication works, everytime the user tries to access the application a new session is created. I can find the session id in the apex views.
The strange thing is, if the user tries to access the application on another computer, it works fine.
I really don't know how to solve this issue.
Thanks for help in advance,
Dirk