diff options
Diffstat (limited to 'rpkid/doc/MySQL-Setup')
| -rw-r--r-- | rpkid/doc/MySQL-Setup | 75 |
1 files changed, 0 insertions, 75 deletions
diff --git a/rpkid/doc/MySQL-Setup b/rpkid/doc/MySQL-Setup deleted file mode 100644 index 4b3638cd..00000000 --- a/rpkid/doc/MySQL-Setup +++ /dev/null @@ -1,75 +0,0 @@ -RPKI Engine  1.0 - -* MainÂ_Page -* RelatedÂ_Pages -* Packages -* Classes -* Files -* [Search ] - -* RPKI_Engine_Reference_Manual - -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.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. |