cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff de Vries <jdevr...@pfrog.com>
Subject Re: JDBCRealm alternatives... is there a Cayenne Realm around I could use?
Date Fri, 08 Sep 2006 15:49:30 GMT
This is what we use, and it works.  One difference I notice is where  
the login and password are located ...

>       <Realm  className="org.apache.catalina.realm.JDBCRealm"  
> debug="99"
>              driverName="org.postgresql.Driver"
>           connectionURL="jdbc:postgresql://dbhost/realmdb"
>          connectionName="<login-goes-here>"  
> connectionPassword="<passord-goes-here>"
>               userTable="users" userNameCol="uname"  
> userCredCol="pword"
>           userRoleTable="roles" roleNameCol="role"
>                  digest="MD5"  />

Hope that helps ...


On Sep 8, 2006, at 7:18 AM, Eric Lazarus wrote:

> Hi, Folks
>
> Up until now we have been using the memory realm to control user  
> access to our main application.
>
> The numbers of users is going to go up so we need to keep that info  
> somewhere and in the database seems like a good place.
>
> We are having some difficulty configuring a JDBCRealm, getting the  
> error you see at the bottom of this email but it occurs to me:
>
> All our other database access is via cayenne. Should I be doing  
> something more cayenne-ish rather than using the JDBCRealm?
>
>
> Thanks!
>
> Eric
>
> = = = = = = = = =
>
> Still having trouble connecting through tomcat's JDBC REALM.
>
> I am trying to use the tomcat JDBC REALM for user log-in.
> Here is the relevent portion of my server.xml file:
>
> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
>       driverName="org.postgresql.Driver"
>
> connectionURL="jdbc:postgres://localhost/PAX_2005? 
> user=paxlogin&amp;password=paxlogin"
>         serTable="loginuser" userNameCol="emailaddress"
> userCredCol="password"
>    userRoleTable="loginrole" roleNameCol="role" />
>
>
> HERE 'loginuser' and 'loginrole' are views in my postgres database.
> They are UNION queries that combine 3 tables of possible users,
> and distinguish them with different roles.
>
> 'paxlogin' is a user in this database who has 'select' privileges
> on these two views, and no other previleges.
>
> When I start tomcat, I get the following output, which essentially
> says that tomcat got an SQL Exception when it tired to connect.
>
> I would probably be able to solve this easier if I could see the
> text of the SQLException that is the 'root cause' of the error.
>
> Is this an authentication failure on the paxlogin user ?
> Is somthing wrong with the Views, or the privileges ?
>
>
> Using CATALINA_BASE:   /home/pax/2005/tomcat-base
> Using CATALINA_HOME:   /usr/local/tomcat/4.0.6
> Using CATALINA_TMPDIR: /home/pax/2005/tomcat-base/temp
> Using JAVA_HOME:       /usr/local/java/j2sdk1.4.2_06
> Starting service Tomcat-Standalone
> Apache Tomcat/4.0.6
> Catalina.start: LifecycleException:  Exception opening database
> connection:
> java.sql.SQLException: org.postgresql.Driver
> LifecycleException:  Exception opening database connection:
> java.sql.SQLException: org.postgresql.Driver
>     at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
>     at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
>     at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
>     at
> org.apache.catalina.core.StandardService.start(StandardService.java: 
> 388)
>     at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
>     at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
>     at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
>     at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     at
> sun.reflect.NativeMethodAccessorImpl.invoke 
> (NativeMethodAccessorImpl.java:39)
>     at
> sun.reflect.DelegatingMethodAccessorImpl.invoke 
> (DelegatingMethodAccessorImpl.java:25)
>     at java.lang.reflect.Method.invoke(Method.java:324)
>     at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
> ----- Root Cause -----
> java.sql.SQLException: org.postgresql.Driver
>     at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538)
>     at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613)
>     at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
>     at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
>     at
> org.apache.catalina.core.StandardService.start(StandardService.java: 
> 388)
>     at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
>     at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
>     at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
>     at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     at
> sun.reflect.NativeMethodAccessorImpl.invoke 
> (NativeMethodAccessorImpl.java:39)
>     at
> sun.reflect.DelegatingMethodAccessorImpl.invoke 
> (DelegatingMethodAccessorImpl.java:25)
>     at java.lang.reflect.Method.invoke(Method.java:324)
>     at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
>
>
>
> Eric
> +1 (917) 589-6579
>  		
> ---------------------------------
> Why keep checking for Mail? The all-new Yahoo! Mail shows you when  
> there are new messages.


Mime
View raw message