Hello to all!!!
Help me!!!
I am trying to use mysql with openwfe.
I would want to make to read to openwfe the info relative to the user
from a database.
1) Following the guide I have created the database "powfe" whith Mysql
and I have filled up the database it following the scripts in sql/
passwd.
2) I have modified the file worklist-configuration.xml inserting:
<service
name="SqlPasswd.dataSource"
class="openwfe.org.sql.ds.MysqlDataSource"
>
<param>
<param-name>url</param-name>
<param-value><![CDATA[jdbc:mysql://localhost/powfe?
user=powfe&password=powfe]]></param-value>
</param>
</service>
and:
<service
name="policyService"
class="openwfe.org.auth.PolicyService"
>
<param>
<param-name>passwdCodec</param-name>
<param-value>openwfe.org.auth.sql.SqlPasswdCodec</param-value>
</param>
<param>
<param-name>dataSource</param-name>
<param-value>SqlPasswd.dataSource</param-value>
</param>
<param>
<param-name>refreshEachTime</param-name>
<param-value>true</param-value>
</param>
</service>
and commenting the instructions of default.
3) Analogous I have made on the file engine-configuration.xml
When I try to enter like admin using WebApp the error is here:
Error : java.rmi.ServerException: RemoteException occurred in server
thread; nested exception is: java.rmi.RemoteException: login failed;
nested exception is: javax.security.auth.login.LoginException: No
policy service. Check application log for details
java.rmi.RemoteException: login failed; nested exception is:
javax.security.auth.login.LoginException: No policy service. Check
application log for details
javax.security.auth.login.LoginException: No policy service. Check
application log for details
In the worklist's log file:
2007-02-15 17:11:53,250 [main] DEBUG openwfe.org.sql.ds.OwfeDataSource
- releaseConnection()
2007-02-15 17:11:53,265 [main] INFO
openwfe.org.app.XmlApplicationContextBuilder - Failed to instantiate
service 'policyService'
openwfe.org.ServiceException: Failed to load Passwd
at openwfe.org.auth.PolicyService.loadPasswd(PolicyService.java:211)
at openwfe.org.auth.PolicyService.init(PolicyService.java:190)
at
openwfe.org.app.XmlApplicationContextBuilder.doBuild(XmlApplicationContextBuilder.java:
305)
at
openwfe.org.app.XmlApplicationContextBuilder.doBuild(XmlApplicationContextBuilder.java:
206)
at
openwfe.org.app.XmlApplicationContextBuilder.build(XmlApplicationContextBuilder.java:
151)
at
openwfe.org.app.XmlApplicationContextBuilder.build(XmlApplicationContextBuilder.java:
135)
at
openwfe.org.app.XmlApplicationContextBuilder.build(XmlApplicationContextBuilder.java:
97)
at openwfe.org.Application.main(Application.java:119)
Caused by: openwfe.org.auth.AuthException: failed to load passwd info
at
openwfe.org.auth.sql.SqlPasswdCodec.decodePasswd(SqlPasswdCodec.java:
232)
at openwfe.org.auth.PolicyService.loadPasswd(PolicyService.java:207)
... 7 more
Caused by: java.lang.NullPointerException
at
openwfe.org.auth.sql.SqlPasswdCodec.decodePermissions(SqlPasswdCodec.java:
419)
at
openwfe.org.auth.sql.SqlPasswdCodec.decodeGrants(SqlPasswdCodec.java:
381)
at
openwfe.org.auth.sql.SqlPasswdCodec.decodePasswd(SqlPasswdCodec.java:
225)
... 8 more
2007-02-15 17:11:53,312 [main] INFO
openwfe.org.rmi.LocalRemoteService - localInit() ServerName is set to
'umanSessionServer'
2007-02-15 17:11:53,312 [main] INFO
openwfe.org.rmi.session.ClassedWorkSessionServer - init()
RemoteSessionImplClass set to 'openwfe.org.uman.rmi.AdminSessionImpl'
2007-02-15 17:11:53,328 [main] INFO
openwfe.org.rmi.session.WorkSessionServerImpl - init()
callbackHandlerClass set to 'openwfe.org.auth.StupidCallbackHandler'
2007-02-15 17:11:53,328 [main] INFO
openwfe.org.rmi.LocalRemoteService - localInit() server class is
'openwfe.org.rmi.session.WorkSessionServerImpl'
2007-02-15 17:11:53,328 [main] DEBUG
openwfe.org.rmi.LocalRemoteService - init() Stored remote in context
under name 'local.umanSessionServer'
2007-02-15 17:11:53,328 [main] INFO
openwfe.org.rmi.LocalRemoteService - localInit() ServerName is set to
'umanSessionServer'
2007-02-15 17:11:53,343 [main] INFO
openwfe.org.rmi.session.ClassedWorkSessionServer - init()
RemoteSessionImplClass set to 'openwfe.org.uman.rmi.AdminSessionImpl'
2007-02-15 17:11:53,343 [main] INFO
openwfe.org.rmi.session.WorkSessionServerImpl - init()
callbackHandlerClass set to 'openwfe.org.auth.StupidCallbackHandler'
2007-02-15 17:11:53,343 [main] INFO
openwfe.org.rmi.LocalRemoteService - localInit() server class is
'openwfe.org.rmi.session.WorkSessionServerImpl'
2007-02-15 17:11:53,515 [main] INFO openwfe.org.rmi.RemoteService -
init() Service bound in rmi registry 7099 under name
'umanSessionServer'
2007-02-15 17:11:53,515 [main] INFO openwfe.org.rmi.RemoteService -
Serving on rmi port 7099
2007-02-15 17:11:53,531 [main] INFO
openwfe.org.app.XmlApplicationContextBuilder - bound service
'umanSessionService' (openwfe.org.rmi.RemoteService)
2007-02-15 17:11:53,531 [main] DEBUG openwfe.org.net.SocketService -
init() listening on port 7078
2007-02-15 17:11:53,562 [main] INFO
openwfe.org.app.XmlApplicationContextBuilder - bound service
'worklist.statusService' (openwfe.org.status.StatusService)
2007-02-15 17:11:53,562 [main] DEBUG openwfe.org.net.SocketService -
init() listening on port 6556
2007-02-15 17:11:53,593 [main] INFO
openwfe.org.app.XmlApplicationContextBuilder - bound service
'signalService' (openwfe.org.misc.SignalService)
2007-02-15 17:11:53,593 [main] INFO
openwfe.org.app.XmlApplicationContextBuilder - Application 'openwfe-
worklist' has been launched
What I must make? My S.O is Windows2000
Best regards,
Francesco
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"OpenWFE users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/openwfe-users?hl=en
-~----------~----~----~----~------~----~------~--~---
