From be7b735fa44c0158d8ab0bc65157df45a7b45783 Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Thu, 16 Sep 2010 21:30:30 +0000 Subject: Preliminary version of rpkid et al with all the TLS code ripped out. Not quite ready for cutover yet, may need some conversion tools and instructions, but checking this into a branch (well, sort of) so that others can look at the code changes involved, try it out themselves, etc. At some point this will merge back into rpkid/ directory and there will be only one, without TLS, but converting the testbed is going to require a flag day, so need to keep the TLS version around until then. svn path=/rpkid.without_tls; revision=3449 --- rpkid.without_tls/doc/MySQL-Setup | 64 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 64 insertions(+) create mode 100644 rpkid.without_tls/doc/MySQL-Setup (limited to 'rpkid.without_tls/doc/MySQL-Setup') diff --git a/rpkid.without_tls/doc/MySQL-Setup b/rpkid.without_tls/doc/MySQL-Setup new file mode 100644 index 00000000..f4d82a7b --- /dev/null +++ b/rpkid.without_tls/doc/MySQL-Setup @@ -0,0 +1,64 @@ +****** 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 sql- +setup.py script, which prompts you for your MySQL root password then attempts +to do everything else automatically using values from myrpki.conf. + +Using the script is simple: + + $ python sql-setup.py + 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> USE irdb_database; + mysql> SOURCE $top/rpkid/irdbd.sql; + 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/rpkid/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/rpkid/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 myrpki_tool. -- cgit v1.2.3