Differences between current version and revision by previous author of RipeWhoisNotes.
Other diffs: Previous Major Revision, Previous Revision, or view the Annotated Edit History
| Newer page: | version 2 | Last edited on Wednesday, October 19, 2005 7:54:17 pm | by AristotlePagaltzis | |
| Older page: | version 1 | Last edited on Tuesday, October 18, 2005 11:52:59 pm | by MattBrown | Revert |
@@ -1,26 +1,38 @@
-Maybe you're trying to get the RIPE Whois Server going... It's kind of old and archaic in several respects it seems.
+Maybe you're trying to get the [
RIPE]
Whois Server going... It's kind of old and archaic in several respects it seems.
-Here is a list of hacks that I've had to do to get it working on Debian Sid so far, this is a work in progress.
+Here is a list of hacks that I've had to do to get it working on [
Debian]
Sid so far, this is a work in progress.
-! Segfault Errors
+!! SegmentationFault~s
-If you get a segfault
like
-<verbatim>
-died on SQ_execute_query(con, "LOCK TABLES " "route READ, inetnum READ, inet6num READ, " "inaddr_arpa READ, domain READ, ip6int READ ", NULL) == -1 in: +258 rp_load.c
-Segmentation fault
-</verbatim>
-or any other segfault when you try to run the whois server, chances are your database permissions are incorrect. The server doesn't seem to have the concept of error messages and will happily segfault if
-* You lack permissions to LOCK TABLES
-* The database server isn't running
-* You lack permissions to create temporary tables
-And probably many more cases
+If you get a SegmentationFault
like
-! Setting up the database user.
-I used the following mysql
commands as the make_user script is for an archaic mysql
version and the user table has many more fields now...
-<verbatim
>
-INSERT user (host, user, password, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, reload_priv, shutdown_priv, process_priv, file_priv, grant_priv, references_priv, index_priv, alter_priv) VALUES ('localhost', 'whois', PASSWORD('whois'), 'Y','Y','Y','Y','Y','Y','Y','N','Y','N','N','Y','Y','Y');
-INSERT user (host, user, password, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, reload_priv, shutdown_priv, process_priv, file_priv, grant_priv, references_priv, index_priv, alter_priv) VALUES ('<HOSTNAME>
', 'whois', PASSWORD('whois'), 'Y','Y','Y','Y','Y','Y','Y','N','Y','N','N','Y','Y','Y');
-update
user set
local_tables_priv='Y' where
user='whois';
-update
user set
Create_tmp_table_priv='Y' where
user='whois';
-flush privileges
-</verbatim
>
+ <verbatim>
+ died on SQ_execute_query(con, "LOCK TABLES " "route READ, inetnum READ, inet6num READ, " "inaddr_arpa READ, domain READ, ip6int READ ", NULL) == -1 in: +258 rp_load.c
+ Segmentation fault
+ </verbatim>
+
+or any other SegmentationFault when you try to run the whois server, chances are your DataBase permissions are incorrect. The server doesn't seem to have the concept of error messages and will happily crash if
+
+* you lack permissions to <tt>LOCK TABLES</tt>,
+* the DataBase server isn't running,
+* you lack permissions to create temporary tables,
+* you look at it wrong,
+* and probably many more cases.
+
+!
! Setting up the database user
+
+I used the following [MySQL]
commands as the <tt>
make_user</tt>
script is for an archaic [MySQL]
version and the user table has many more fields now...
+
+ <pre
>
+ INSERT user (host, user, password, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, reload_priv, shutdown_priv, process_priv, file_priv, grant_priv, references_priv, index_priv, alter_priv)
+
VALUES ('localhost', 'whois', PASSWORD('whois'), 'Y','Y','Y','Y','Y','Y','Y','N','Y','N','N','Y','Y','Y');
+
+ INSERT user (host, user, password, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, reload_priv, shutdown_priv, process_priv, file_priv, grant_priv, references_priv, index_priv, alter_priv)
+
VALUES ('__''yourhostname''__
', 'whois', PASSWORD('whois'), 'Y','Y','Y','Y','Y','Y','Y','N','Y','N','N','Y','Y','Y');
+
+ UPDATE
user SET
local_tables_priv='Y' WHERE
user='whois';
+
+ UPDATE
user SET
Create_tmp_table_priv='Y' WHERE
user='whois';
+
+ FLUSH PRIVILEGES
+ </pre
>
