On Fri, Dec 18, 2009 at 1:14 AM, Chintana Wilamuna <[email protected]> wrote:
> 5) Login to Identity Server admin console by going to > http://localhost:9443/carbon. Username: admin, password: admin > > Click User Management -> Users -> Add New User > > For the moment make a user with uid:0 and a password of your choice. > You can use this to login to .Net trader client. Ideally Identity > Server user manager should be configured to talk to the MSSQL user > table. Configuring the User Manager component of the Identity Server to talk to the StockTraderDB user table. a) Download the latest JDBC MSSQL driver from - http://sourceforge.net/projects/jtds/files/ b) Copy jtds-x.x.x.jar to <identity server>\repository\components\lib and restart Identity Server c) Goto User Management -> Add External User Store and give the following values Connection URL: jdbc:jtds:sqlserver://localhost:1433/stocktraderdb Connection user name: trade Connection password: yyy Connection password repeat: yyy Driver name: net.sourceforge.jtds.jdbc.Driver SQL for retrieving a given user's password: select password from accountprofile where userid = ? SQL for listing users using "like": select userid from accountprofile where userid like ? SQL for selecting a single user given the user name: select userid from accountprofile where userid = ? SQL for retrieving a user list: select userid from accountprofile and click Finish. d) After clicking Finish, click the Test Connection to make sure the connection you just added works fine. You should see "Successfully connected to the user store" message. e) And you're done. Now you don't have to add users to the Identity Server, it'll just talk to the database and authenticate when you give username and password when you get redirected to the Identity Server passive STS. Identity Server is available here - http://wso2.com/products/identity-server/ Bye, -Chintana -- Blog: http://engwar.com/ Photos: http://flickr.com/photos/chintana
