aboutsummaryrefslogtreecommitdiff
path: root/doc/doc.RPKI.CA.MySQLSetup
diff options
context:
space:
mode:
authorRob Austein <sra@hactrn.net>2016-07-28 21:03:09 -0400
committerRob Austein <sra@hactrn.net>2016-07-28 21:03:09 -0400
commit83fce9376139aac61522030ad4ff11cfe5de6139 (patch)
tree1c6d9175e9bfdb33d6280d25228bc07742e0a9da /doc/doc.RPKI.CA.MySQLSetup
parent794705b7cde7ab8eade9d38ddd15cfbf5de5ebd8 (diff)
Drop in documentation extracted from wiki.rpki.net. See README for details.
Diffstat (limited to 'doc/doc.RPKI.CA.MySQLSetup')
-rw-r--r--doc/doc.RPKI.CA.MySQLSetup62
1 files changed, 0 insertions, 62 deletions
diff --git a/doc/doc.RPKI.CA.MySQLSetup b/doc/doc.RPKI.CA.MySQLSetup
deleted file mode 100644
index 344d9693..00000000
--- a/doc/doc.RPKI.CA.MySQLSetup
+++ /dev/null
@@ -1,62 +0,0 @@
-****** RPKI Engine MySQL Setup ******
-
-You need to install MySQL and set up the relevant databases before starting
-rpkid, irdbd, or pubd.
-
-See the Installation Guide for details on where to download MySQL and find
-documentation on installing it.
-
-See the 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:
-
- $ 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:
-
- $ 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:
-
- $ 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 user interface tools.