[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[GNUnet-SVN] r24840 - gnunet/doc
From: |
gnunet |
Subject: |
[GNUnet-SVN] r24840 - gnunet/doc |
Date: |
Thu, 8 Nov 2012 15:06:40 +0100 |
Author: grothoff
Date: 2012-11-08 15:06:40 +0100 (Thu, 08 Nov 2012)
New Revision: 24840
Removed:
gnunet/doc/README.mysql
Log:
-updated and moved to https://gnunet.org/mysql-setup
Deleted: gnunet/doc/README.mysql
===================================================================
--- gnunet/doc/README.mysql 2012-11-08 13:07:53 UTC (rev 24839)
+++ gnunet/doc/README.mysql 2012-11-08 14:06:40 UTC (rev 24840)
@@ -1,95 +0,0 @@
-How to setup the MySQL database for GNUnet.
-
-NOTE: This db module does NOT work with mysql before 4.1 since we need
-prepared statements. We are generally testing the code against MySQL
-5.0 at this point.
-
-HIGHLIGHTS
-
-Pros
- + On up-to-date hardware where mysql can be used comfortably, this
- module will have better performance than the other db choices
- (according to our tests).
- + Its often possible to recover the mysql database from internal
- inconsistencies. The other db choices do not support repair
- (gnunet-check cannot fix problems internal to the dbmgr!).
- For example, we have seen several cases where power failure
- has ruined a gdbm database beyond repair.
- + much faster (for one of the key benchmarks -- content migration
- -- we have measure mysql taking 2s for an operation where
- sqlite takes 150s).
-Cons
- - Memory usage (Comment: "I have 1G and it never caused me trouble")
- - Manual setup
-
-MANUAL SETUP INSTRUCTIONS
-
- 1) in /etc/gnunet.conf, set
- DATABASE = mysql
-
- 2) Then access mysql as root,
- $ mysql -u root -p
- and do the following. [You should replace $USER with the username
- that will be running the gnunetd process].
-
- CREATE DATABASE gnunet;
- GRANT select,insert,update,delete,create,alter,drop,create temporary
tables
- ON gnunet.* TO address@hidden;
- SET PASSWORD FOR address@hidden('$the_password_you_like');
- FLUSH PRIVILEGES;
-
- 3) In the $HOME directory of $USER, create a ".my.cnf" file
- with the following lines
-
- [client]
- user=$USER
- password=$the_password_you_like
-
- Thats it. Note that .my.cnf file is a security risk unless its on
- a safe partition etc. The $HOME/.my.cnf can of course be a symbolic
- link. Even greater security risk can be achieved by setting no
- password for $USER. Luckily $USER has only priviledges to mess
- up GNUnet's tables, nothing else (unless you give him more,
- of course).
-
- 4) Still, perhaps you should briefly try if the DB connection
- works. First, login as $USER. Then use,
-
- $ mysql -u $USER
- mysql> use gnunet;
-
- If you get the message "Database changed" it probably works.
-
- [If you get "ERROR 2002: Can't connect to local MySQL server
- through socket '/tmp/mysql.sock' (2)" it may be resolvable by
- "ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock"
- so there may be some additional trouble depending on your mysql setup.]
-
- 5) If you want to run the testcases, you must create a second
- database "gnunetcheck" with the same username and password.
- This database will then be used for testing ("make check").
-
-
-REPAIRING TABLES
-
-- Its probably healthy to check your tables for inconsistencies
- every now and then, especially after system crashes.
-- If you get odd SEGVs on gnunetd startup, it might be that the mysql
- databases have been corrupted.
-- The tables can be verified/fixed in two ways;
- 1) by shutting down mysqld (mandatory!) and running
- # myisamchk -r *.MYI
- in /var/lib/mysql/gnunet/ (or wherever the tables are stored).
- Another repair command is "mysqlcheck". The usable command
- may depend on your mysql build/version. Or,
- 2) by executing
- mysql> REPAIR TABLE gn090;
-
-
-PROBLEMS?
-
-If you have problems related to the mysql module, your best friend is
-probably the mysql manual. The first thing to check is that mysql is
-basically operational, that you can connect to it, create tables,
-issue queries etc.
-
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [GNUnet-SVN] r24840 - gnunet/doc,
gnunet <=