Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
/*
************************************************************************
**** C A N A D I A N A S T R O N O M Y D A T A C E N T R E *****
*
* (c) 2011. (c) 2011.
* National Research Council Conseil national de recherches
* Ottawa, Canada, K1A 0R6 Ottawa, Canada, K1A 0R6
* All rights reserved Tous droits reserves
*
* NRC disclaims any warranties Le CNRC denie toute garantie
* expressed, implied, or statu- enoncee, implicite ou legale,
* tory, of any kind with respect de quelque nature que se soit,
* to the software, including concernant le logiciel, y com-
* without limitation any war- pris sans restriction toute
* ranty of merchantability or garantie de valeur marchande
* fitness for a particular pur- ou de pertinence pour un usage
* pose. NRC shall not be liable particulier. Le CNRC ne
* in any event for any damages, pourra en aucun cas etre tenu
* whether direct or indirect, responsable de tout dommage,
* special or general, consequen- direct ou indirect, particul-
* tial or incidental, arising ier ou general, accessoire ou
* from the use of the software. fortuit, resultant de l'utili-
* sation du logiciel.
*
*
* @author adriand
*
* @version $Revision: $
*
*
**** C A N A D I A N A S T R O N O M Y D A T A C E N T R E *****
************************************************************************
*/
package ca.nrc.cadc.cert;
import java.io.IOException;
import javax.security.auth.x500.X500Principal;
import javax.sql.DataSource;
import org.apache.log4j.Logger;
import org.springframework.jdbc.core.JdbcTemplate;
import ca.nrc.cadc.auth.HttpPrincipal;
import ca.nrc.cadc.db.ConnectionConfig;
import ca.nrc.cadc.db.DBConfig;
import ca.nrc.cadc.db.DBUtil;
import ca.nrc.cadc.util.ArgumentMap;
/**
* Represents a AbstractCertGenAction that needs DB connections
*/
public abstract class DbCertGenAction extends AbstractCertGenAction
{
private static Logger LOGGER = Logger
.getLogger(DbCertGenAction.class);
// datasource to the database
protected DataSource ds;
protected static final String TMP_TABLE = "#tmptable";
public static final String GENERATE_DN_Q = "select dbo.genDN(?)";
@Override
public boolean init(final ArgumentMap argMap) throws IOException
{
if (!super.init(argMap))
{
return false;
}
initDbConnection(argMap);
return true;
}
/**
* Returns DN of a cadc user
*
* @param userId The HTTP Principal to get the DN for.
* @return X500Principal, or null.
*/
protected X500Principal getCADCUserDN(HttpPrincipal userId)
{
final JdbcTemplate jdbc = new JdbcTemplate(ds);
@SuppressWarnings("unchecked")
final String userDN = (String) jdbc.queryForObject(GENERATE_DN_Q,
new Object[]{
userId.getName()}, String.class);
return (userDN == null) ? null : new X500Principal(userDN);
}
private void initDbConnection(ArgumentMap argMap) throws IOException
{
if (argMap.getValue(Main.ARG_DB) != null)
{
database = argMap.getValue(Main.ARG_DB);
if (database.length() < 2)
{
throw new IllegalArgumentException("Argument "
+ Main.ARG_DB + "("
+ argMap.getValue(Main.ARG_DB)
+ ") invalid");
}
}
if (argMap.getValue(Main.ARG_SERVER) != null)
{
server = argMap.getValue(Main.ARG_SERVER);
if (server.length() < 2)
{
throw new IllegalArgumentException("Argument "
+ Main.ARG_SERVER + "("
+ argMap.getValue(Main.ARG_SERVER)
+ ") invalid");
}
}
final DBConfig dbrc = new DBConfig();
LOGGER.debug("dbrc=" + dbrc);
final ConnectionConfig conCfg = dbrc.getConnectionConfig(server,
database);
LOGGER.info("Database name: " + database);
LOGGER.info("Database server: " + server);
LOGGER.debug("conCfg=" + conCfg);
ds = DBUtil.getDataSource(conCfg);
LOGGER.debug("ds=" + ds);
}
}