Conventions

Yes, I’m using Debian Stretch.

At this point I’m too lazy to write more details.

Setup PostgreSQL

1
echo "deb http://kambing.ui.ac.id/postgresql/repos/apt/ stretch-pgdg main" | sudo tee /etc/apt/sources.list.d/postgresql.list
2
wget --quiet -O - http://kambing.ui.ac.id/postgresql/repos/apt/ACCC4CF8.asc | sudo apt-key add -
3
sudo apt update
4
sudo apt install postgresql-10

Create new user and database.

1
sudo -u postgres createuser -D -A -P casig
2
sudo -u postgres createdb -O casig casigdb

Add access for all remote clients.

1
sudo tee -a /etc/postgresql/10/main/pg_hba.conf << EOF
2
host    all             all              0.0.0.0/0                       md5
3
host    all             all              ::/0                            md5
4
EOF

Restart PostgreSQL server.

1
sudo /etc/init.d/postgresql restart

CAS Service Registry

Add to CAS’ gradle build dependencies:

1
compile "org.apereo.cas:cas-server-support-jdbc-drivers:${project.'cas.version'}"
2
compile "org.apereo.cas:cas-server-support-jpa-service-registry:${project.'cas.version'}"

Add to etc/cas/config/cas.properties:

1
cas.serviceRegistry.jpa.url=jdbc:postgresql://192.0.2.9/casigdb
2
cas.serviceRegistry.jpa.user=casig
3
cas.serviceRegistry.jpa.password=cimeiwoh7pee4eeg0kae6Jaeyee3Oof7
4
cas.serviceRegistry.jpa.ddlAuto=update
5
cas.serviceRegistry.jpa.driverClass=org.postgresql.Driver
6
cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.PostgreSQL95Dialect

Don’t forget the dialect or later we would not have DDL.

Default services

This would install default service for HTTPS/IMAPS. It should be automatically installed by CAS on the first run. But, hey, may be something goes wrong and we need to make our own service.

1
insert into regexregisteredservice (id, name, serviceid, evaluation_order)
2
  values (1, 'Generic HTTPS and IMAPS', '^(https?|imaps?|http?)://.*', 0);

Test

1
casigdb=> \dt
2
                          List of relations
3
 Schema |                    Name                    | Type  | Owner
4
--------+--------------------------------------------+-------+-------
5
 public | regexregisteredservice                     | table | casig
6
 public | regexregisteredserviceproperty             | table | casig
7
 public | registeredservice_contacts                 | table | casig
8
 public | registeredserviceimpl_props                | table | casig
9
 public | registeredserviceimplcontact               | table | casig
10
 public | samlregisteredservice_attributenameformats | table | casig
11
(6 rows)

References

JDBC Drivers, PostgreSQL Configuration Properties, Database Service Registry

CAS Service Registry with PostgreSQL Backend

Conventions

Setup PostgreSQL

CAS Service Registry

Default services

Test

References

Related Articles

CAS Redis Ticket Storage

CAS with LDAP Authentication

CAS Case Study, Wordpress