I'm trying to use Turbine with PGSql. I converted the
User_Roles_Permissions, and the text is appended to the end of this
message. The problem is that when I try to log in, I'm getting this
error:
java.lang.NullPointerException
at
org.apache.turbine.util.access.UserFactory.validateUser(UserFactory.java:168)
at
org.apache.turbine.util.access.UserFactory.getUser(UserFactory.java:83)
at
org.apache.turbine.actions.LoginUser.build(LoginUser.java:104)
at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:115)
at Turbine.doGet(Turbine.java:258)
at Turbine.doPost(Turbine.java:377)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:521)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at
org.apache.jserv.JServConnection.processRequest(JServConnection.java:314)
at
org.apache.jserv.JServConnection.run(JServConnection.java:188)
at java.lang.Thread.run(Thread.java)
It looks like the code is doing this:
if ( user.getPassword().equals(password) )
and getPassword is returning Null.
Is this a problem with some PGSQL stuff? I'll be glad to help with it
if someone points me in the right direction.
Here's the file I made: Postgresql_users_roles_permissions.sql
-----start
-- Turbine, a Servlet Framework for building Dynamic Websites
-- Copyright (C) 1999 Jon S. Stevens Brett McLaughlin
--
-- For licensing and use, please see the LICENSE.txt in this directory.
--
-- This is a schema for PostgreSQL for
-- the concept of Users/Roles/Permissions
--
-- Please see the Html documentation for more information
-- on this SQL. Equivalent contributions of this for other
-- databases are welcome.
--
-- You should create a new database for Turbine
-- use createdb Turbine at the command line.
--
-- @author Nissim Karpenstein
--
-- run this in the SID you want to use.
DROP SEQUENCE PERMISSION_SEQUENCE;
CREATE SEQUENCE PERMISSION_SEQUENCE;
DROP TABLE PERMISSION;
CREATE TABLE PERMISSION (
PERMISSIONID INT NOT NULL,
PERMISSION VARCHAR(99) NOT NULL,
CONSTRAINT PERMISSION_PK PRIMARY KEY (PERMISSIONID));
CREATE UNIQUE INDEX PERMISSION_NAME ON PERMISSION(PERMISSION);
DROP SEQUENCE ROLE_SEQUENCE;
CREATE SEQUENCE ROLE_SEQUENCE;
DROP TABLE USERROLE;
CREATE TABLE USERROLE (
ROLEID INT NOT NULL,
ROLENAME VARCHAR(99) NOT NULL,
CONSTRAINT ROLE_PK PRIMARY KEY (ROLEID));
CREATE UNIQUE INDEX ROLE_NAME ON USERROLE(ROLENAME);
DROP TABLE ROLEPERMISSION;
CREATE TABLE ROLEPERMISSION (
ROLEID INT NOT NULL,
PERMISSIONID INT NOT NULL,
CONSTRAINT ROLEPERMISSION_PK PRIMARY KEY (ROLEID,PERMISSIONID));
DROP SEQUENCE VISITOR_SEQUENCE;
CREATE SEQUENCE VISITOR_SEQUENCE;
DROP TABLE VISITOR;
CREATE TABLE VISITOR (
VISITORID INT NOT NULL,
LOGINID VARCHAR(32) NOT NULL,
PASSWORD_VALUE VARCHAR(32),
FIRST_NAME VARCHAR(99) NOT NULL,
LAST_NAME VARCHAR(99) NOT NULL,
ADDRESS1 VARCHAR(32),
ADDRESS2 VARCHAR(32),
CITY VARCHAR(32),
STATE VARCHAR(32),
POSTALCODE VARCHAR(32),
COUNTRY VARCHAR(32),
CITIZENSHIP VARCHAR(32),
PHONE VARCHAR(32),
ALTPHONE VARCHAR(32),
FAX VARCHAR(32),
CELL VARCHAR(32),
PAGER VARCHAR(32),
EMAIL VARCHAR(99),
MODIFIED DATE,
CREATED DATE,
LASTLOGIN DATE,
OBJECTDATA OID,
CONSTRAINT VISITOR_PK PRIMARY KEY (VISITORID));
CREATE UNIQUE INDEX VISITOR_LOGINID ON VISITOR(LOGINID);
INSERT INTO VISITOR
(VISITORID,
LOGINID,
PASSWORD_VALUE,
FIRST_NAME,
LAST_NAME)
VALUES(NEXTVAL('VISITOR_SEQUENCE'),
'turbine',
'turbine',
'system',
'adminstrator' );
DROP TABLE VISITORROLE;
CREATE TABLE VISITORROLE (
VISITORID INT NOT NULL,
ROLEID INT NOT NULL,
CONSTRAINT VISITORROLE_PK PRIMARY KEY (VISITORID, ROLEID));
-------end
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
