getRemoteUser is null

RicardoPereira · Sep 17, 2003

Hi,

I'am trying to get the username of windows 2000 using the getRemoteUser method but i'am having always the null value.
What could be the problem and how should i resolve them?

Thanks
Ricardo Pereira

palbano · Sep 17, 2003

Are you using HTTP Authentication? If not that header will not exist.

-pete

venur · Sep 17, 2003

Hi,

For anauthenticated users getRemoteUser() returns null. I have been trying to find a solution for this. May be we need to post this question under Jakarta-Tomcat forum.

This is could help you

http://www.caucho.com/support/resin-interest/0102/0476.html

Thanks,
venu

RicardoPereira · Sep 18, 2003

Look my validation code:

<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.text.*" %>

<%

Connection connection = null;
ResultSet SQLRetorno = null;
ResultSet SQLRetorno_cons = null;
Statement SQLQuery = null;
String consulta = null;

int erro = 0;
int errado = 0;
int certo = 0;
String erro_str = "erro";
String contador = "";
String user = "";

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver&quot

.newInstance();
connection = DriverManager.getConnection("jdbc

dbc:sqlintranet&quot

;
SQLQuery = connection.createStatement();

String host = request.getRemoteHost();
String remoteuser = request.getRemoteHost();

%>

<%
String consulta_cons="SELECT distinct COUNT(*),loginame,hostname FROM [master].[dbo].[sysprocesses] " +
" WHERE hostname ='" + host + "' group by loginame,hostname";
SQLRetorno_cons = SQLQuery.executeQuery( consulta_cons );

while ( SQLRetorno_cons.next() ) {
contador = SQLRetorno_cons.getString(1);
session.setAttribute("utilizador",SQLRetorno_cons.getString(2));
session.setAttribute("hostname",SQLRetorno_cons.getString(3));
}

%>

<%
if (!contador.equals("0&quot

){
session.setAttribute("nivel", host);

%>

<INPUT TYPE="hidden" NAME="username" VALUE="<%= user %>">
<INPUT TYPE="hidden" NAME="hostname" VALUE="<%= host %>">
<jsp:forward page="teste/index.jsp">
<jsp

aram name="username" value="<%= user %>" />
</jsp:forward>

<%
}
%>

<%
if (contador.equals("0&quot

){
%>

<INPUT TYPE="hidden" NAME="username" VALUE="<%= user %>">
<INPUT TYPE="hidden" NAME="hostname" VALUE="<%= host %>">
<jsp:forward page="teste/index1.jsp">
<jsp

aram name="username" value="<%= user %>" />
</jsp:forward>

<%
}
%>

<body>
<CENTER>
</CENTER>
</BODY>
</HTML>

palbano · Sep 18, 2003

>> String user = "";

the variable user is initialized to an empty string and never changed in the code you posted. Therefore it will be an empty string right? I don't understand your question.

-pete

RicardoPereira · Sep 18, 2003

Here is what i want:

I have one sql server 2000 database, webserver tomcat and i want to build an intranet with all permissions set on SQL server (one user to access sql server must be register in sql server with windows authentication).
When the user access the internet i want to get his windows username to establish the connection with sql server.
This coulb be possible if getRemoteUser() methot dont return null value. With null value i cannot estabelish permission for each type of user.

How can i get the windows username using the jsp?

palbano · Sep 18, 2003

You need to use HTTP Authentication (RFC 2616), respond to the browser request with 401 and a

http://WWW-Authenticate

header.

Start reading here:

http://java.sun.com/features/2002/11/hilevel_network.html

-pete

RicardoPereira · Sep 19, 2003

I just want to estabelish the connection with sql server using the windows authentication.
Where can i get an jdbc driver that allow trustedAuthentication ?

sedj · Sep 19, 2003

RicardoPereira,

I've got to say here, people are trying to help you and you are clearly not listening. Just posting your code and demanding people to look at it is not going to get you very far, nor will constantly restating your wishes.

As the other guys have said - you will not be able to authenticate your user unless http authentication is enabled.
Please read the suggestions others have given !

palbano · Sep 19, 2003

sedj
Amen brother

-pete

venur · Sep 19, 2003

Hi,

For establishing connection with SQL Server you can use
microsoft dirver. In your class path you need have the following jar files

mssqlserver.jar
msutil.jar
msbase.jar

Cheers,
venu

RicardoPereira · Sep 19, 2003

What i want is estabelish the connection with sql server 2000 using the windows 2000 definition. But i think the microsoft JDBC driver doesn't support trusted connections.
Anyone have a idea how to connect with trusted connection?

Thanks
Ricardo Pereira

venur · Sep 20, 2003

Hi,

I dont think this is the answer you are looking for, but It might help you.

You need to use SQL Server authentication and it sounds like your instance of SQLServer is configured for Windows authentication only. To change the authentication mode, from Enterprise Manager right click on the instance and
select properties. On the security tab, change the authentication mode to the SQL Server and Windows option.

Cheers
Venu

RicardoPereira · Sep 20, 2003

Thanks for the help venur but what i want is jsp authentication with windows definitions.
To do this i need an JDBC driver that support trusted connection. That's what i'm looking for.

palbano · Sep 21, 2003

>>But i think the microsoft JDBC driver doesn't support trusted connections.
>> Anyone have a idea how to connect with trusted connection?

First i don't know that the microsoft JDBC driver does not support trusted connection. However if that is correct then you can shop for a commercial third party driver that does. sun maintains a list of JDBC driver vendors at java.sun.com

Is that what you are looking for?

-pete

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

getRemoteUser is null

RicardoPereira

Programmer

palbano

Programmer

venur

MIS

RicardoPereira

Programmer

palbano

Programmer

RicardoPereira

Programmer

palbano

Programmer

RicardoPereira

Programmer

sedj

Programmer

palbano

Programmer

venur

MIS

RicardoPereira

Programmer

venur

MIS

RicardoPereira

Programmer

palbano

Programmer

Similar threads

Part and Inventory Search

Sponsor