How to setup Shibboleth authentication using database

[Priyanka W Dhoble]

Thanks Peter for guiding me, it's a great help, but no logs are generated for this in Tomcat.



I have done the below steps, please let me know if I have done something wrong. Please note that I am trying to connect to SQL server rather than MYSQL.


1. Copied source from https://vcs.ics.muni.cz/repos/shibboleth

2. Created tagishauth.jar as per instructions given in "Makefile.txt"

3. Copied this file into Shib2IdP\lib folder

4. Rebuilt war file by executing install.bat again

5. Downloaded SQL data provider and copied sqljdbc4.jar to CaptiveTomcat 6.0\lib folder

6. Done following changes in the login.xml file



ShibUserPassAuth {

            com.tagish.auth.DBLogin required debug=true

            dbDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver"

            dbURL="jdbc:sqlserver://<db server ip>;user=<UserName>;password=<Password>;database=<DBName> "

            userTable="Users"

            userColumn="userName" userPasswd="userPassword";



};



7. Created table named "Users" in SQL server with 2 columns userName & userPassword and entered recor with password in plain text format.





Thanks,

Priyanka





-----Original Message-----
From: users-bounces at shibboleth.net [mailto:users-bounces at shibboleth.net] On Behalf Of Peter Schober
Sent: 11 November 2013 18:33
To: users at shibboleth.net
Subject: Re: How to setup Shibboleth authentication using database



* Priyanka W Dhoble <Priyanka.Dhoble at bitwiseglobal.com<mailto:Priyanka.Dhoble at bitwiseglobal.com>> [2013-11-11 13:44]:

> Thanks Peter. But somehow its not working and I am not able to debug

> it as no logs are created. Can you please let me know debugging steps

> for this.



Getting logs from the servlet container are probably your best bet.

-peter

--

To unsubscribe from this list send an email to users-unsubscribe at shibboleth.net<mailto:users-unsubscribe at shibboleth.net>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://shibboleth.net/pipermail/users/attachments/20131111/faf9c997/attachment.html