Andy,

I just saw your message. I don’t claim to know much here, as I am slogging my 
through this on my own, but here is the part of my setup that got me on the 
road to authenticating with mysql. I believe that the original out of the box 
war that I used already had the mysql connector included, so no build necessary.

The relevant part of my deployerConfigContext.xml is here:

<!--
        Adding the JDBC authentication related configuration
        -->
        <bean id="primaryAuthenticationHandler" 
class="org.jasig.cas.adaptors.jdbc.SearchModeSearchDatabaseAuthenticationHandler"
         abstract="false" lazy-init="default" autowire="default" >
                <property name="tableUsers"><value>main</value></property>
                <property name="fieldUser"><value>userid</value></property>
                <property name="fieldPassword"><value>ssn</value></property>
                <!--<property name="passwordEncoder" 
ref="defaultPasswordEncoder"/>-->
                <property name="dataSource" ref="dataSource"/>
        </bean>

        <!-- Data source definition -->
          <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
                <property name="driverClassName">
                  <value>com.mysql.jdbc.Driver</value>
                </property>
                <property name="url">
                  
<value>jdbc:mysql://address.of.mysqlserver:3306/mydatabasename</value>
                </property>
                <property 
name="username"><value>mysqlrootusername</value></property>
                <property 
name="password"><value>mysqlrootuserpassword</value></property>
          </bean>


Regards,

Christopher Adams

From: Andy Turner [mailto:[email protected]]
Sent: Tuesday, January 06, 2015 2:35 PM
To: [email protected]
Subject: Re:[cas-user] Building cas-server with mysql as a backend

same problem, wasted a week googling and trying things, no solution.

On Tuesday, November 18, 2014 4:35:32 PM UTC-6, Bricoleur wrote:
Hello,

I am attempting to get cas-server set up to use mysql as a backend. I have 
Tomcat running successfully, Maven installed, downloaded the mysql-connector 
and am now trying to build the .war file this way: 'mvn package install'. This 
is the result:

[ERROR] Failed to execute goal on project cas-server-webapp: Could not resolve 
dependencies for project org.jasig.cas:cas-server-webapp:war:4.0.0: Failure to 
find mysql:mysql-connector-java:jar:5.1.9-bin in 
http://developer.ja-sig.org/maven2 was cached in the local repository, 
resolution will not be reattempted until the update interval of 
jasig-repository has elapsed or updates are forced -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e 
switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please 
read the following articles:
[ERROR] [Help 1] 
http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR]   mvn <goals> -rf :cas-server-webapp


I would appreciate any help with this. I can post my pom.xml file or whatever 
else might be useful.

Many thanks.



--

You are currently subscribed to 
[email protected]<mailto:[email protected]> as: 
[email protected]<mailto:[email protected]>

To unsubscribe, change settings or access archives, see 
http://www.ja-sig.org/wiki/display/JSG/cas-user

-- 
You are currently subscribed to [email protected] as: 
[email protected]
To unsubscribe, change settings or access archives, see 
http://www.ja-sig.org/wiki/display/JSG/cas-user

Reply via email to