- db-wg - mailman.ripe.net

please help, can't start whoisserver
by Nicolae Ghimbovschi 29 May '06

29 May '06

Hi everybody ! I'm a newbie in working with a whoisserver, and I can't start it, i get errors I have compiled and installed whoisserve-3.3.0 ,from RIPE site, under Fedora Core 5. #./build.sh --prefix=/opt/whoisd --disable-xmltest --disable-xslttest everything worked fine. But when I run to make the sample database I get errors. In files rip.conf.sample and sources.config.sample I have configured the following lines: in rip.conf.smaple RIPADMIN xmachine.fedora,3306,root,hello,RIPADMIN and in sources.conf.sample DATABASE SAMPLEDB host: xmachine.fedora port: 3306 trx_support: n user: root password: hello /DATABASE [root@xmachine bin]# ./make_db -c /opt/whois/conf/rip.config.sample -s SAMPLE -1 sqlhost=xmachine.fedora sqlport=3306 sqluser=root sqlpswd=hello sqldbname=SAMPLEDB npasses=1 = 10:27:16 Loading database [SAMPLEDB] (source [SAMPLE]) started = 10:27:16 Loading the database [SAMPLEDB] [see list in /dev/tty] *******************Sun May 28 10:27:17 EEST 2006****************** Creating tables\n Creating tables\n creating main database ERROR 1060 (42S21) at line 246: Duplicate column name 'interface_v6_lsp' creating RIPADMIN database Sun May 28 10:27:17 EEST 2006\n Making indexes\n ERROR 1146 (42S02) at line 1: Table 'SAMPLEDB.person_role' doesn't exist Sun May 28 10:27:18 EEST 2006\n Loading tables - 1 of 1 pass\n Sun May 28 10:27:18 EEST 2006 Loading /opt/whois/var/tmp/load/SAMPLE/sample.db.gz D: Making SQL connection to SAMPLEDB(a)xmachine.fedora ...OK starting processing stream Table 'SAMPLEDB.mntner' doesn't exist[SELECT object_id FROM mntner WHERE mntner='TEST-DBM-MNT' ] died: +315 modules/ud/ud_core.c ./load_all.sh: line 15: 3464 Done ${UNZIP1} ${object_file} 3465 | eval ${FILTER} 3467 Segmentation fault | $LOADER -L $1 -p ${PROPERTIES} -s ${SOURCE} *** ERROR: Loader failure [139]. Exiting\n ************** ERROR *************** *** 10:27:18 Error loading database=SAMPLEDB for source=SAMPLE, ./make_db exiting ************************************ ######################################################## ##when making an empty database I get the following ######################################################## [root@xmachine bin]# ./make_db -c /opt/whois/conf/rip.config.sample -s SAMPLE -0 sqlhost=xmachine.fedora sqlport=3306 sqluser=root sqlpswd=hello sqldbname=SAMPLEDB npasses=0 = 10:30:27 Loading database [SAMPLEDB] (source [SAMPLE]) started = 10:30:27 Loading the database [SAMPLEDB] [see list in /dev/tty] *******************Sun May 28 10:30:28 EEST 2006****************** Creating tables\n Creating tables\n creating main database ERROR 1007 (HY000) at line 1: Can't create database 'SAMPLEDB'; database exists ERROR 1060 (42S21) at line 246: Duplicate column name 'interface_v6_lsp' creating RIPADMIN database ERROR 1007 (HY000) at line 2: Can't create database 'RIPADMIN'; database exists Sun May 28 10:30:28 EEST 2006\n Making indexes\n ERROR 1146 (42S02) at line 1: Table 'SAMPLEDB.person_role' doesn't exist Sun May 28 10:30:28 EEST 2006\n Making more indexes\n Sun May 28 10:30:28 EEST 2006 creating indexes for aux tables ERROR 1146 (42S02) at line 4: Table 'SAMPLEDB.tech_c' doesn't exist Sun May 28 10:30:28 EEST 2006 creating indexes for leaf tables ERROR 1146 (42S02) at line 1: Table 'SAMPLEDB.names' doesn't exist Sun May 28 10:30:28 EEST 2006 saving CURRENTSERIAL=22 ERROR 1146 (42S02) at line 1: Table 'SAMPLEDB.serials' doesn't exist Finished Sun May 28 10:30:28 EEST 2006 = 10:30:29 Loading database [SAMPLEDB] (source [SAMPLE]) finished without errors ######################################################## ##when checking the database ######################################################## [root@xmachine bin]# ./whois-server -c /opt/whois/conf/rip.config.sample -p test.pid Configuration [/opt/whois/conf/rip.config.sample]: /opt/whois/log/riperr/riperrlog Check the DB Checking the Database [SAMPLEDB]...died: +230 modules/ud/ud_recover.c Segmentation fault [root@xmachine bin]# ./whoisd_start Starting whois-server daemon with configuration /opt/whois/conf/rip.config.sample from /opt/whois/bin ./whoisd_start: line 174: 3639 Segmentation fault $NOHUP_NICENESS $WHOISRIP -p $pid_file -c ${CONFIG} >>$err_log 2>&1 mv: cannot stat `core': No such file or directory ######################################### #from Error log: ######################################### Warning: undefined configuration variable: SAWFILE Warning: undefined configuration variable: RIR Error: Incomplete configuration file. Was this intended ??? 2 configuration variables undefined. died: +168 modules/sq/mysql_driver.c 060528 10:39:45 whoisd crashed & restarted\n/opt/whois/bin/whois-server -c /opt/whois/conf/rip.config.sample.q\n 060528 10:39:46 /opt/whois/bin/whois-server -p /opt/whois/bin/whois- server.pid -c /opt/whois/conf/rip.config.sample.q Configuration [/opt/whois/conf/rip.config.sample.q]: Warning: undefined configuration variable: SAWFILE Warning: undefined configuration variable: RIR Error: Incomplete configuration file. Was this intended ??? 2 configuration variables undefined. Mandatory variable(s) undefined <<<<<<<<<<<<<<< >>>>>>>>>>> Best Regards, Nicolae

2 1

Mike Simkins is out of the office.
by Mike.Simkins＠sungard.com 28 May '06

28 May '06

I will be out of the office starting 26/05/2006 and will not return until 30/05/2006. I will respond to your message when I return. If you have an urgent issue - please call the IOC at 1-800-41-1181 where someone will be able to help you immediately

1 0

RIPE 52 Draft Minutes of the DB WG meeting posted to web site
by Nigel Titley 26 May '06

26 May '06

Folks, The final draft minutes have been sent to the RIPE NCC webmaster for posting to the RIPE website. You *all* failed to spot that I misnumbered the action points as 51.n rather than 52.n (actually, so did I until I extracted the actions ready for uploading to the web site). Enjoy Nigel

1 0

RIPE 52 Draft Minutes of the DB WG meeting (Final Call)
by Nigel Titley 24 May '06

24 May '06

Folks, Having posted the 2nd draft of the minutes on the 8th May and having received no comments I am assuming that these are now acceptable as a record of the RIPE 52 meeting. I'll give it until the end of the week and then post the minutes and actions to the DB-WG website. Thanks to all who commented Nigel

1 0

Database query tool for ip allocations
by Fuat Demir (Garanti Teknoloji) 24 May '06

24 May '06

Hi, I'm looking for a tool that sends a query to the database whether the source ip is in the db or not. The database which will be looked up for the query should contain the ip allocations and ISP ip blocks of the all RIR's (RIPE, ARIN, LACNIC, APNIC, AfriNIC) and it must be keep updated in a period of time, for example, daily. The tool will give permission or restriction to the packets by sending query to the updated database and new allocations will not be discarded. How could i achieve this ? Thank you. Fuat Demir Garanti Technology This message and attachments are confidential and intended solely for the individual(s) stated in this message. If you received this message although you are not the addressee, you are responsible to keep the message confidential. The sender has no responsibility for the accuracy or correctness of the information in the message and its attachments. Our company shall have no liability for any changes or late receiving, loss of integrity and confidentiality, viruses and any damages caused in anyway to your computer system. Bu mesaj ve ekleri, mesajda gonderildigi belirtilen kisi/kisilere ozeldir ve gizlidir. Bu mesajin muhatabi olmamaniza ragmen tarafiniza ulasmis olmasi halinde mesaj iceriginin gizliligi ve bu gizlilik yukumlulugune uyulmasi zorunlulugu tarafiniz icin de soz konusudur. Mesaj ve eklerinde yer alan bilgilerin dogrulugu ve guncelligi konusunda gonderenin ya da sirketimizin herhangi bir sorumlulugu bulunmamaktadir. Sirketimiz mesajin ve bilgilerinin size degisiklige ugrayarak veya gec ulasmasindan, butunlugunun ve gizliliginin korunamamasindan, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan sorumlu tutulamaz.

1 0

Proposal for returning IRT objects
by Denis Walker 16 May '06

16 May '06

[Apologies for duplicate mails] Proposal for returning IRT objects Motivation ---------- The original proposal for the IRT object (ripe-254) did not make adequate provision for presenting the irt information to the user. A new query flag ("-c") was introduced. Because of the way this flag was implemented and the objects it returned, it was not considered intuitive or helpful. It can also cause confusion. A discussion held at the RIPE 51 meeting decided that the original implementation was a misunderstanding of the requirements. For more information, see AOB in the Database Working Group minutes: http://www.ripe.net/ripe/wg/db/minutes/ripe-51.html There was further discussion at the RIPE 52 meeting, details of which can be found at: http://www.ripe.net/ripe/maillists/archives/db-wg/2006/msg00052.html Objectives ---------- - To increase the availability of the irt information to users. - To promote the use of the IRT object. - To make it easier for third party tool writers to find the correct contacts. Background ---------- There has been confusion in the past about the implementation of the IRT object. We have been studying the concept and looking deep into the whois query code. Our understanding of how this works now, and how the community wants it to work in the future, has changed. This proposal outlines the current behaviour and what we now understand to be the desired behaviour. Current behaviour ----------------- A standard query for address space returns the queried inetnum and related objects. This does not include an IRT object, even if it is directly referenced by the queried INETNUM object. By using the "-r" flag, the related personal objects are filtered out but ROUTE objects are still returned. By using the "-c" flag, an INETNUM object is returned with a referenced IRT object and objects related to this INETNUM. This may not be the INETNUM in the query. No ROUTE objects are returned. If no (less specific) INETNUM references an IRT object, nothing is returned. By using the "-rc" flags, the related personal objects are filtered out, including the IRT object. The only object returned is the referencing INETNUM object, which may not be the one in the query. So it is not possible to find IRT objects without returning personal objects related to the referencing INETNUM object. New behaviour ------------- A standard query for address space returns the queried INETNUM and related objects. This does not include an IRT object, even if it is directly referenced by the queried INETNUM object. This is the same as the current behaviour. We propose to change this default behaviour at the second stage of implementation (see Implementation below). By using the "-r" flag, the related personal objects are filtered out but ROUTE objects are still returned. A standard query for address space including the "-c" query flag returns the queried inetnum and related objects. This will also include an IRT object referenced by the queried INETNUM object or the closest less specific INETNUM object, if one exists. It will also still include any ROUTE objects. By using the "-rc" flags, the related personal objects are filtered out. The IRT object will still be returned along with any ROUTE objects. When using any other address space query flags (lLmMxb) or querying for other object types, query behaviour remains the same as the current behaviour. If the "-c" query flag is used, it will be ignored. Implementation -------------- We propose a two stage implementation. The majority of the address space queries are made without any specific flags. We therefore propose to change the behaviour to return an IRT object by default (if one exists) only at the second stage. For the first stage, we propose changing the behaviour of the "-c" flag and the "-rc" flag combination as described above. This should not make any fundamental changes to the way the queries work. Existing tools and scripts should not fail. The web query form on www.ripe.net will add the "-c" flag to address space queries, making it a default. This only occurs if no other address space query flags (lLmMxbc) are present. At the second stage, the query server will add the "-c" flag to any address space query that does not include any of the address space query flags (lLmMxbc). This will make standard queries return IRT objects by default. This second stage changes the current behaviour of queries. This may break some tools and scripts. We can mitigate this by providing new query flags or using existing ones in different ways so that the behaviour resulting from the first stage of implementation can be reproduced. Tool writers ------------ Currently any third party tools that use the "-c" flag to find IRT objects run the risk of being blocked for returning too many personal objects. With the new behaviour, the "-rc" flags can be used to return the IRT objects without the personal objects. If only the IRT object is needed, "-rc -T irt" can be used. Notes ----- Any references to INETNUM and ROUTE objects also imply INET6NUM and ROUTE6. A consequence of this change is the return of an object with no direct reference from the queried object. With grouping turned on (default without "-G"), we assume that the IRT object should be grouped with the queried INETNUM object. -- Denis Walker Software Engineering Department RIPE NCC

1 0

Draft Minutes of the RIPE 52 DB-WG meeting
by Nigel Titley 15 May '06

15 May '06

Please find enclosed the first rough draft of the minutes. Please check your action points and make corrections to me. Thanks Nigel <<DB-minutes.txt>>

10 17

Maintenance announcement
by Trudy Prins 15 May '06

15 May '06

[Apologies for duplicate mails] Dear Colleagues, On Thursday, 18 May 2006 the following services will be unavailable from 05:00 - 06:00 GMT: - RIPE Whois Test Database - Internet Registry Information Service (IRIS) Server - Routing Registry Consistency Check (RRCC) Database These services will be unavailable while we perform important server maintenance work. We apologise in advance for any inconvenience. If you have any questions or concerns about this, please e-mail: <ripe-dbm(a)ripe.net>. Regards, Trudy Prins User Support Coordinator Software Engineering Department

1 0

whois update service was paused
by Trudy Prins 11 May '06

11 May '06

[Apologies for duplicate mails] Dear Colleagues, Yesterday, we deployed several bug fixes for the whois server software. The fixes should improve ORGANISATION object name handling. During the work, the whois update service was paused for around two hours. We apologise for the inconvenience. If you have any questions or concerns about this, please e-mail <ripe-dbm(a)ripe.net>. Regards, Trudy Prins User Support Coordinator Software Engineering Department

1 0

clients statistics
by md＠Linux.IT 10 May '06

10 May '06

I'd like to see published on the RIPE web site statistics about the -V parameter used by whois clients to identify themselves to the server. Does this need a formal proposal or is something which NCC staff can just implement quickly? -- ciao, Marco

1 0