Problem with "login"

Comment of : Problem with "login"

Sebastien Jourdain — 2007-02-26T11:56:56+01:00

You can try something like that with the postgres driver in you classpath.

Class.forName("org.postgresql.Driver");
Connection con = DriverManager.getConnection( "jdbc:postgresql://localhost:5432/libresource", "demo","");Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM nodes_");
while (rs.next()) {
         System.out.println(rs.getString(0));
	}

Comment of : Problem with "login"

Sebastien Jourdain — 2007-02-26T11:35:20+01:00

Are you sure that you postgres is rightly configured ?

I mean, are you sure that a user demo with no password can access to the libresource database ?

You can give a try to run java code with JDBC and the postgresql driver available in JONAS_ROOT/lib/ext/xxx.jar

Comment of : Problem with

Momo — 2007-02-26T11:00:18+01:00

Hi, I even have problems with the login. When i create a user and i try login after the system see me the error: "login failed!" I create a user named "Demo" on the postgreSQL database but i don't solve the problem.

Another theme is: when i open de page http://localhost:9000 and i clicking on the "login" it leaves an error to me:

HTTP Status 500----
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
java.lang.NullPointerException
	org.esupportail.cas.server.handlers.database.LSDatabaseHandler.authenticate(Unknown Source)
	org.esupportail.cas.server.GenericHandler.authenticate(Unknown Source)
	edu.yale.its.tp.cas.servlet.Login.doGet(Unknown Source)
	edu.yale.its.tp.cas.servlet.Login.doPost(Unknown Source)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	sun.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
	java.security.AccessController.doPrivileged(Native Method)
	javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
	org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
	org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.15 logs.

This is normal? if i want to login on the system i click on that link, is it true? I need help!

Comment of : Problem with "login"

Sebastien Jourdain — 2007-02-22T15:24:51+01:00

When you use the libresource installer, you need to have a postgres user named demo with no password which should have access to the libresource database. This is required by the CAS server. The installer don't patch dynamically the CAS package.

This is written and specified on the download page.

But you can fix it by hand if you like to play with war files… ;-)

To do so :

unzip the cas war file.
patch the text configuration file that specify the user and the password for the database connection. (search for jdbc:postgresql://localhost:5432/libresource)
re-zip the file.
rename it as a war.
run config.bat

Comment of : Problem with "login"

Momo — 2007-02-22T15:02:18+01:00

Hi, i change the path on the file configxxx.properties, because the slash was inverted. But now when i create, correctly, the user and i try to login, the explores see me the next mesage: "Login failed ! You need to allow cookies for the authentication. " But all the cookies are allowed...some idea?

Comment of : Problem with "login"

Sebastien Jourdain — 2007-02-21T11:21:37+01:00

If the problem come from the first back-slash missing, then you will need to reconfigure the LibreSoure package.

To do so, follow the coming steps:

Edit the libresource configuration file. (should be something like ls-configxxxx.properties)
Fix the file path in that file. use / instead of back-slash or put 2 back-slash.
Run the config.bat script.
start your Libresource with the start.bat script.

Comment of : Problem with "login"

Sebastien Jourdain — 2007-02-21T11:12:32+01:00

Does the file path exist ?