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
|
= RPKI Engine MySQL Setup =
[[TracNav(doc/RPKI/TOC)]]
You need to install MySQL and set up the relevant databases before
starting rpkid, irdbd, or pubd.
See the [[Installation|Installation Guide]] for details on
where to download MySQL and find documentation on installing it.
See the [[Configuration|Configuration Guide]] for details on
the configuration file settings the daemons will use to find and
authenticate themselves to their respective databases.
Before you can (usefully) start any of the daemons, you will need to
set up the MySQL databases they use. You can do this by hand, or
you can use the {{{rpki-sql-setup}}} script, which prompts you for your
MySQL root password then attempts to do everything else
automatically using values from rpki.conf.
Using the script is simple:
{{{
#!sh
$ rpki-sql-setup
Please enter your MySQL root password:
}}}
The script should tell you what databases it creates. You can use
the -v option if you want to see more details about what it's doing.
If you'd prefer to do the SQL setup manually, perhaps because you
have valuable data in other MySQL databases and you don't want to
trust some random setup script with your MySQL root password, you'll
need to use the MySQL command line tool, as follows:
{{{
#!sh
$ mysql -u root -p
mysql> CREATE DATABASE irdb_database;
mysql> GRANT all ON irdb_database.* TO irdb_user@localhost IDENTIFIED BY 'irdb_password';
mysql> CREATE DATABASE rpki_database;
mysql> GRANT all ON rpki_database.* TO rpki_user@localhost IDENTIFIED BY 'rpki_password';
mysql> USE rpki_database;
mysql> SOURCE $top/schemas/sql/rpkid.sql;
mysql> COMMIT;
mysql> quit
}}}
where {{{irdb_database}}}, {{{irdb_user}}}, {{{irdb_password}}},
{{{rpki_database}}}, {{{rpki_user}}}, and {{{rpki_password}}} match
the values you used in your configuration file.
If you are running pubd and are doing manual SQL setup, you'll also
have to do:
{{{
#!sh
$ mysql -u root -p
mysql> CREATE DATABASE pubd_database;
mysql> GRANT all ON pubd_database.* TO pubd_user@localhost IDENTIFIED BY 'pubd_password';
mysql> USE pubd_database;
mysql> SOURCE $top/schemas/sql/pubd.sql;
mysql> COMMIT;
mysql> quit
}}}
where {{{pubd_database}}}, {{{pubd_user}}} {{{pubd_password}}} match the
values you used in your configuration file.
Once you've finished configuring MySQL, the next thing you should
read is the instructions for the [[UI|user interface tools]].
|
