January 2007 - db-help - mailman.ripe.net

IP Address Management Tool
by berthy.vanderjagt＠kpn.com 30 Jan '07

30 Jan '07

Hullo All, This is my first call to the forum. I noticed on the RIPE site earlier discussions on a free ipdb tool which was supposed to be available through Global Crossing through the URL: http://www.freeipdb.org This URL gives me no joy however, is this all a joke? And has anyone good recommendations for an IP Management tool to handle the stockcontrol, allocations and assignments of Ipv4 and Ipv6 addresses for a telecoms company? We have been having no end of solutions presented to us which each just didn't quite do what promised :( Anybody out there with good experiences with any tool? Kind regards, Berthy van der Jagt KPN The Netherlands

4 3

inetnum object addition - error
by linux baby 09 Jan '07

09 Jan '07

Thanks for your help. Please help me to add the inetnum object. i have created the following RR1-SAMPLE, RR2-SAMPLE - person objects created SAMPLE-MNT - mntner object created I have the inetnum object input file like below --------------- cat /usr/local/src/nic/ipcheck.input inetnum: 10.11.12.0 - 10.11.12.255 netname: NIC-NETWORK descr: THIS IS TESTING RANGE country: IN admin-c: RR1-SAMPLE tech-c: RR2-SAMPLE status: ASSIGNED PA remarks: This network should never be routed outside an enterprise notify: raja(a)nic.in mnt-by: SAMPLE-MNT mnt-lower: SAMPLE-MNT mnt-routes: SAMPLE-MNT password: redhat123 source: SAMPLE changed: raja(a)nic.in 20070109 ------------ i checked the range available by whois -p 43001 -h knagalin.linux2all.net 10.11.12.0 - 10.11.12.255 [Querying knagalin.linux2all.net] [knagalin.linux2all.net] % This is the NIC Whois server. % Note: this output has been filtered. % Information related to '0.0.0.0 - 255.255.255.255' inetnum: 0.0.0.0 + - + 255.255.255.255 netname: + WHOLE-IPV4 + descr: The Whole IPv4 country: NL remarks: Country is really worldwide + admin-c: RDBM-SAMPLE # admin contact tech-c: RDBM-SAMPLE # tech contact status: ALLOCATED PI mnt-by: TEST-DBM-MNT source: SAMPLE # Filtered I try to add in my whois server database [root@knagalin whoisd]# ./bin/dbupdate -c ./conf/rip.config.sample -f /usr/local/src/nic/ipcheck.input SUMMARY OF UPDATE: Number of objects found: 1 Number of objects processed successfully: 0 Create: 0 Modify: 0 Delete: 0 No Operation: 0 Number of objects processed with errors: 1 Create: 1 Modify: 0 Delete: 0 Syntax Errors: 0 DETAILED EXPLANATION: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The following object(s) were found to have ERRORS: --- Create FAILED: [inetnum] 10.11.12.0 - 10.11.12.255 ***Info: Syntax check passed inetnum: 10.11.12.0 - 10.11.12.255 netname: NIC-NETWORK descr: THIS IS TESTING RANGE country: IN admin-c: RR1-SAMPLE tech-c: RR2-SAMPLE status: ASSIGNED PA remarks: This network should never be routed outside an enterprise notify: raja(a)nic.in mnt-by: SAMPLE-MNT mnt-lower: SAMPLE-MNT mnt-routes: SAMPLE-MNT source: SAMPLE changed: raja(a)nic.in 20070109 Please tell me where i am making mistake, Please help me to add the inetnum object in my whoisd server database. Waiting for your reply. regards Karthikeyan.N On 1/9/07, RIPE Database Manager <ripe-dbm(a)ripe.net> wrote: > > Dear Karthikeyan.N > > As I pointed out to you yesterday it will be a good idea to read the > > RIPE Database User Manual: Getting Started > http://www.ripe.net/ripe/docs/db-start.html > > This clearly explains how to create objects in the RIPE Database and how > to > query for them. It was written to help new users to get started. > > The answer to your specific problem below is the '# Filtered' comment on > the "source:" line. The update program will not accept updates with > filtered > query output. > > You may also want to check your database naming as you have used nic-hdls > like AA1-TEST with a source of SAMPLE. Maybe these should both be either > TEST or SAMPLE. > > -- > Regards, > Denis Walker > > RIPE Database Administration > > > On Tue, 9 Jan 2007 10:44:19 +0530, Linux Baby wrote: > * hi, > * Can you give me one example for dbupdate command to > * create/delete/update > * objects using commandline/webinterface. > * > * regards > * Karthikeyan.N >

1 0

update[inetnum] issue
by linux baby 09 Jan '07

09 Jan '07

hi, i am tring to do the addition of inetnum object using 'dbupdate'. input file: [root@knagalin whoisd]# cat /tmp/ipcheck.input inetnum: 10.10.10.0 - 10.10.10.255 netname: IANA-ABLK-RESERVED1 descr: Class A address space for private internets descr: See http://www.ripe.net/db/rfc1918.html for details country: EU # Country is really world wide admin-c: AA1-TEST tech-c: AA2-TEST status: ALLOCATED UNSPECIFIED remarks: This network should never be routed outside an enterprise remarks: See RFC1918 for further information mnt-by: TEST-DBM-MNT mnt-lower: TEST-DBM-MNT mnt-routes: TEST-DBM-MNT source: SAMPLE # Filtered changed: rsm(a)nic.in 20070107 ./bin/dbupdate -c ./conf/rip.config.sample -f /tmp/ipcheck.input ... Create FAILED: [inetnum] 10.0.0.0 - 10.255.255.255 ***Info: Syntax check passed inetnum: 10.0.0.0 - 10.255.255.255 netname: IANA-ABLK-RESERVED1 descr: Class A address space for private internets descr: See http://www.ripe.net/db/rfc1918.html for details country: EU # Country is really world wide admin-c: AA1-TEST tech-c: AA2-TEST status: ALLOCATED UNSPECIFIED remarks: This network should never be routed outside an enterprise remarks: See RFC1918 for further information mnt-by: TEST-DBM-MNT mnt-lower: TEST-DBM-MNT mnt-routes: TEST-DBM-MNT source: SAMPLE # Filtered changed: rsm(a)nic.in 20070107 ***Error: Cannot submit filtered whois output for updates. please help me to add the iprange object in inetnum. Thanks in advance. regards Karthikeyan.N

1 0

help sample - dbupdate
by linux baby 09 Jan '07

09 Jan '07

hi, Can you give me one example for dbupdate command to create/delete/update objects using commandline/webinterface. regards Karthikeyan.N

1 0

commandline howto
by linux baby 09 Jan '07

09 Jan '07

Hi, Can you help me howto add the users details in whoisd server either command line or webinterface and query the server. I tried syncupdates but there is no proper doc for the same, Please help me how to add the users details through commandline and howto check the whoisd server for the same. If possible, please help me to configure the syncupdates/webupdates in whoisd server. regards Karthikeyan.N

1 0

howto create database objects in whoisd
by linux baby 08 Jan '07

08 Jan '07

hi, can you help me how do i create the new objects in whois server. i have done the whois server and mysql setup and conf. please help me regards Karthikeyan.N

1 0

please help me - syncupdate
by linux baby 08 Jan '07

08 Jan '07

I have done the whoisd server installation, the port is listening. To create and update the information[records] using syncupdates to communicate with database, i didn't find doc for syncupdates and webupdates to configure with whoisd setup. Please help me to configure and use the syncupdates to my whoisd server to update the database regards Karthikeyan.N

1 0

whois-server crash
by ripe＠foobar.dk 08 Jan '07

08 Jan '07

Hi I'm currently trying to debug our whoisserver (version 3.3.0) running as a near real-time mirror running on a RedHat (2.6.9-42.0.3.EL). First - I did not setup the server myself so history is pretty short... Problem: The server starts, runs for a while sucking up all CPU and dies. The wrapper keeps restarting the server as long as $CRASHES -le 10 and then it shuts down. I been looking into the logs and I think there might be a problem with updating the database. When the server starts it complains about to undefined conf. variables : [cut..cut] 070103 14:02:07 whois-server started 070103 14:02:07 /usr/local/whoisserver/bin/whois-server -p /usr/local/whoisserver/bin/whois_rip.pid -c /usr/local/whoisserver/conf/rip.config.sample Configuration [/usr/local/whoisserver/conf/rip.config.sample]: Warning: undefined configuration variable: SAWFILE Warning: undefined configuration variable: UPDSOURCE Error: Incomplete configuration file. Was this intended ??? 2 configuration variables undefined. Mandatory variable(s) undefined <<<<<<<<<<<<<<< >>>>>>>>>>> Continuing ..... Warning: undefined configuration variable: SAWFILE Warning: undefined configuration variable: UPDSOURCE Error: Incomplete configuration file. Was this intended ??? 2 configuration variables undefined. [cut..cut] These variables seems to be missing (or commented out (UPDSOURCE)) in the rip.config.sample that is used as config file. I wonder if that causes problems ? It then checks the DB and reports OK, and then it goes into a NTRM mode and dies when trying to update: [cut..cut] Check the DB Checking the Database [RIPE]...[OK] STATUS: The Database is clean ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Source [RIPE] Mode NRTM [/usr/local/whoisserver/log/ripupd/ripupdlog_RIPE] Mode of operation: * dummy not allowed * NRTM * running as a server * NHR is maintained died: +781 modules/ud/ud_core.c 070103 14:05:48 whoisd crashed & restarted\n/usr/local/whoisserver/bin/whois-server -c /usr/local/whoisserver/conf/rip.config.sample.q\n 070103 14:05:49 /usr/local/whoisserver/bin/whois-server -p /usr/local/whoisserver/bin/whois_rip.pid -c /usr/local/whoisserver/conf/rip.config.sample.q [cut..cut] Looking in log/ripupd/<logfile> the crash triggers a severe warning : 20070103 14:05:47 whois_rip-13755/2914581424 UD-S-SEVERE query not defined for this type of attribute[74]\x0A So in modules/ud/ud_core.c [line 780] (attribute_type) is "x0A" when it crashes - but I get a little lost from here. It leaves me with a few questions: 0) "Mandatory variables" sounds mandatory to me - but it does not seem (in the first place) to cause the server to crash, but just warns. 1) Any good ideas for debugging further ? 2) Is there a good howto somewhere with a better description of the config values found in rip.config* and sources.config.sample*. I'm a little curious about SAW values etc... Best regards, Peter

2 1

syncupdates howto
by linux baby 08 Jan '07

08 Jan '07

Hi, I am new to whoisd server, i am doing the whoisd setup for my office, i have done the whoisd server installation, the port is listening. To create and update the information i am tring to use the syncupdates to communicate with database, there is no proper doc for syncupdates and webupdates to configure the whoisd setup. Please help me to configure and use the syncupdates to my whoisd server to update the database Regards Karthikeyan.N

1 0

syncupdate help
by linux baby 08 Jan '07

08 Jan '07

Hi, I am new to whoisd server, i am doing the whoisd setup for my office, i have done the whoisd server installation, the port is listening. To create and update the information i am tring to use the syncupdates to communicate with database, there is no proper doc for syncupdates and webupdates to configure the whoisd setup. Please help me to configure and use the syncupdates to my whoisd server to update the database regards Karthikeyan.N

1 0