3 # This is test set that tests configurable SQL PIP engine. It uses sample data from MySQL world database
5 # http://dev.mysql.com/doc/world-setup/en/index.html
7 # The Policy was created using the PAP Admin Tool.
12 # Default XACML Properties File
13 # Standard API Factories
15 xacml.dataTypeFactory=com.att.research.xacml.std.StdDataTypeFactory
16 xacml.pdpEngineFactory=com.att.research.xacmlatt.pdp.ATTPDPEngineFactory
17 xacml.pepEngineFactory=com.att.research.xacml.std.pep.StdEngineFactory
18 xacml.pipFinderFactory=com.att.research.xacml.std.pip.StdPIPFinderFactory
19 xacml.traceEngineFactory=com.att.research.xacml.std.trace.LoggingTraceEngineFactory
21 # AT&T PDP Implementation Factories
23 xacml.att.evaluationContextFactory=com.att.research.xacmlatt.pdp.std.StdEvaluationContextFactory
24 xacml.att.combiningAlgorithmFactory=com.att.research.xacmlatt.pdp.std.StdCombiningAlgorithmFactory
25 xacml.att.functionDefinitionFactory=com.att.research.xacmlatt.pdp.std.StdFunctionDefinitionFactory
26 xacml.att.policyFinderFactory=com.att.research.xacmlatt.pdp.std.StdPolicyFinderFactory
29 # NOTE: If you are testing against a RESTful PDP, then the PDP must be configured with the
30 # policies and PIP configuration as defined below. Otherwise, this is the configuration that
31 # the embedded PDP uses.
36 xacml.rootPolicies=sql
37 sql.file=src/test/resources/xacml/frequency_limiter_1.xml
39 # PIP Engine Definition
41 xacml.pip.engines=sql1
43 sql1.classname=com.att.research.xacml.std.pip.engines.jdbc.JDBCEngine
45 sql1.description=World Database from MySQL website. Copyright Statistics Finland, http://www.stat.fi/worldinfigures.
46 # This will be the default issuer for the resolvers. NOTE: Issuer only used for attributes provided by the engine.
47 sql1.issuer=com:att:research:xacml:test:sql
49 # This is the configuration for JDBC. You will have to setup the database and run the data\world*.sql script to
50 # create the tables and load the data.
55 #sql1.jdbc.driver=org.postgresql.Driver
56 #sql1.jdbc.url=jdbc:postgresql://localhost:7778/postgres
57 #sql1.jdbc.conn.user=postgres
58 #sql1.jdbc.conn.password=
61 sql1.jdbc.driver=org.mariadb.jdbc.Driver
62 sql1.jdbc.url=jdbc:mariadb://localhost:7779/policy
63 sql1.jdbc.conn.user=root
64 sql1.jdbc.conn.password=lmpg
67 # This is the configuration for JNDI datasource.
70 #sql1.datasource=jdbc/xacml
74 sql1.resolver.langer.classname=com.att.research.xacml.std.pip.engines.jdbc.ConfigurableJDBCResolver
75 sql1.resolver.langer.name=Language
76 sql1.resolver.langer.description=This returns the number of previous operations within the given time window
78 # Query for Postgres DB
79 #sql1.resolver.langer.select=select count(*) from operationshistory where actor=? and operation=? and target=? and endtime between now()::timestamp with time zone - (interval '1000000000s') and now()::timestamp with time zone
82 #sql1.resolver.langer.select=select count(*) as count from operationshistory where actor=? and operation=? and target=? and convert_tz(endtime,@@session.time_zone,'-05:00') between date_sub(convert_tz(now(),@@session.time_zone,'-05:00'),interval 100 hour) and convert_tz(now(),@@session.time_zone,'-05:00')
83 sql1.resolver.langer.select=select count(*) as count from operationshistory9 where actor=? and operation=? and target=? and endtime between date_sub(now(),interval 100 hour) and now()
85 sql1.resolver.langer.fields=count
86 sql1.resolver.langer.field.count.id=com:att:research:xacml:test:sql:resource:operations:count
87 sql1.resolver.langer.field.count.datatype=http://www.w3.org/2001/XMLSchema#integer
88 sql1.resolver.langer.field.count.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
91 #You can override the default issuer that is set in the JDBCEngine definition if you want.
92 #sql1.resolver.langer.field.language.issuer=com:att:research:xacml:test:sql
93 sql1.resolver.langer.parameters=actor,operation,target
95 sql1.resolver.langer.parameter.actor.id=urn:oasis:names:tc:xacml:1.0:actor:actor-id
96 sql1.resolver.langer.parameter.actor.datatype=http://www.w3.org/2001/XMLSchema#string
97 sql1.resolver.langer.parameter.actor.category=urn:oasis:names:tc:xacml:1.0:subject-category:access-subject
99 sql1.resolver.langer.parameter.operation.id=urn:oasis:names:tc:xacml:1.0:operation:operation-id
100 sql1.resolver.langer.parameter.operation.datatype=http://www.w3.org/2001/XMLSchema#string
101 sql1.resolver.langer.parameter.operation.category=urn:oasis:names:tc:xacml:3.0:attribute-category:action
103 sql1.resolver.langer.parameter.target.id=urn:oasis:names:tc:xacml:1.0:target:target-id
104 sql1.resolver.langer.parameter.target.datatype=http://www.w3.org/2001/XMLSchema#string
105 sql1.resolver.langer.parameter.target.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
108 # These properties are for an attribute generator to build into requests.
110 xacml.attribute.generator=generate_subjectid
112 xacml.attribute.generator.generate_subjectid.file=generate.data
113 xacml.attribute.generator.generate_subjectid.attributes=city
115 xacml.attribute.generator.generate_subjectid.attributes.city.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
116 xacml.attribute.generator.generate_subjectid.attributes.city.datatype=http://www.w3.org/2001/XMLSchema#string
117 xacml.attribute.generator.generate_subjectid.attributes.city.id=urn:oasis:names:tc:xacml:1.0:resource:resource-id
118 xacml.attribute.generator.generate_subjectid.attributes.city.field=0