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
|
<?php
/*
*
* Service Provider Example -- Installation Script
*
* Copyright (C) 2004 Entr'ouvert
* http://lasso.entrouvert.org
*
* Authors: Christophe Nowicki <cnowicki@easter-eggs.com>
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include "config.php.inc";
require_once 'DB.php';
print "Setup script for L.A.S.S.O (Liberty Alliance Single Sign On)\n";
lasso_init();
print "$server_dump_filename: ";
# Create XML Server Dump
if (file_exists($server_dump_filename))
{
print "file already exists.\n";
}
else
{
$server = lasso_server_new(
"/home/cnowicki/mcvs/lasso/tests/data/sp1-la/metadata.xml",
"/home/cnowicki/mcvs/lasso/tests/data/sp1-la/public-key.pem",
"/home/cnowicki/mcvs/lasso/tests/data/sp1-la/private-key-raw.pem",
"/home/cnowicki/mcvs/lasso/tests/data/sp1-la/certificate.pem",
lassoSignatureMethodRsaSha1);
lasso_server_add_provider($server,
"/home/cnowicki/mcvs/lasso/tests/data/idp1-la/metadata.xml",
"/home/cnowicki/mcvs/lasso/tests/data/idp1-la/public-key.pem",
"/home/cnowicki/mcvs/lasso/tests/data/ca1-la/certificate.pem"
);
$dump = lasso_server_dump($server);
$fd = fopen($server_dump_filename, "w");
fwrite($fd, $dump);
print "wrote.\n";
fclose($fd);
}
print "Create User Database.\n";
print "DSN : $dsn\n";
$options = array(
'debug' => 2,
);
$db = &DB::connect($dsn, $options);
if (DB::isError($db)) {
die($db->getMessage());
}
# Drop user_id_seq
print "DROP user_id_seq.\n";
$query = "DROP SEQUENCE user_id_seq";
$res =& $db->query($query);
if (DB::isError($res))
die($res->getMessage());
# Create user_id_seq
print "Create user_id_seq Sequence.\n";
$query = "CREATE SEQUENCE user_id_seq";
$res =& $db->query($query);
if (DB::isError($res))
die($res->getMessage());
/* print "DROP users.\n";
$query = "DROP TABLE users CASCADE";
$res =& $db->query($query);
if (DB::isError($res))
die($res->getMessage()); */
# Create local data base
print "Create users Table.\n";
$query = "CREATE TABLE users (
user_id varchar(100) primary key,
identity_dump text,
first_name varchar(50),
last_name varchar(50),
created timestamp)";
$res =& $db->query($query);
if (DB::isError($res))
die($res->getMessage());
/* print "DROP nameidentifiers.\n";
$query = "DROP TABLE nameidentifiers";
$res =& $db->query($query); */
if (DB::isError($res))
die($res->getMessage());
print "Create nameidentifiers Table.\n";
$query = "CREATE TABLE nameidentifiers (
name_identifier varchar(100) primary key,
user_id varchar(100),
FOREIGN KEY (user_id) REFERENCES users (user_id))";
$res =& $db->query($query);
if (DB::isError($res))
die($res->getMessage());
$db->disconnect();
lasso_shutdown();
?>
|
