- db-help - mailman.ripe.net

Parsing responses from the syncupdates-API
by Moritz Lenz 11 Jan '13

11 Jan '13

Hi all, for my current work I occasionally patch the Net::Whois::Object Perl module (http://search.cpan.org/perldoc?Net%3A%3AWhois%3A%3AObject) which supports talking to the RIPE syncupdates API. Now I'm facing the challenge of parsing the response when creating an object. For example when creating a new handle, the response used to include something along the lines of *** Info: Authorisation for [TS34027-RIPE] from which I could easily extract the handle (which I don't know in advance, because the request I sent contained AUTO-1 as the handle). Now the response doesn't include that information anymore, and instead I get Create SUCCEEDED: [person] TS34027-RIPE Thomas Schoeller from which I don't know how to extract the new handle. I've considered simply using the first word after the [person] block (as regex, \[.*?\]\s+(\S+) or something similar), but that won't work for an inetnum, where the primary key contains spaces. Is there any robust approach on how to extract the primary key from the response? (If person records are the only ones where the primary key is generated from the database, I can special-case that, but it still feels rather fragile). Cheers, Moritz P.S. I should add that so far, I've been pretty amazed by the quality of responses on this mailing list, and from RIPE in general. Thanks everybody, and keep up the good work!

2 1

Error no. 32 while creating inet6num objects
by Moritz Lenz 19 Dec '12

19 Dec '12

Hi, I've tried to create some inet6num objects via https://apps.db.ripe.net/webupdates/create-field.html# in the TEST database. This is what happened: - From-Host: 193.0.1.204 - Date/Time: Wed Dec 19 16:47:04 2012 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: [inet6num] 2001:780:130::/48 ***Info: Authorisation passed ***Info: Syntax check passed inet6num: 2001:780:130::/48 netname: MAT-IT-V6-NET descr: MAT IT-Solutions country: DE admin-c: ML98-TEST tech-c: ML98-TEST mnt-by: NORIS-MNT mnt-routes: TEST status: ASSIGNED remarks: remarks: changed: mlenz(a)noris.net source: TEST ***Warning: Date '20121219' added to changed: attribute 'mlenz(a)noris.net' ***Error: Please contact database admin: Error no 32 ***Info: Authorisation for parent [inet6num] 2001:780::/29 using mnt-lower: authenticated by: NORIS-MNT ***Info: Authorisation for [inet6num] 2001:780:130::/48 using mnt-by: authenticated by: NORIS-MNT ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The RIPE Database is subject to Terms and Conditions: http://www.ripe.net/db/support/db-terms-conditions.pdf For assistance or clarification please contact: RIPE Database Administration <ripe-dbm(a)ripe.net> Generated by RIPE WHOIS Update version 1.47.4 on WHOIS3 Handled sync update (TEST, LGC, 2012-12-19 16:47:04) Any idea what's wrong? I've tried to duplicate the allocation of 2001:780::/29 from the RIPE database in the TEST database, not sure if that worked well enough. Cheers, Moritz

2 1

Object update FAILED
by Milan Obuch 20 Nov '12

20 Nov '12

Hello, I tried to update object in RIPE db as below, but failed. Couple of minutes before I updated domain object 74.245.84.in-addr.arpa (and others before as well) with no error, using identical data (domain attribute changed, of course). Could you help me with this? I can't find any reference to this error. Regards, M. Obuch Begin forwarded message: Date: Mon, 19 Nov 2012 13:47:42 +0100 (CET) From: RIPE Database Administration <unread(a)ripe.net> To: Milan Obuch <milan(a)netlab.sk> Subject: FAILED: > From: Milan Obuch <milan(a)netlab.sk> > Subject: > Date: Mon, 19 Nov 2012 13:47:36 +0100 > Reply-To: Milan Obuch <milan(a)netlab.sk> > Message-ID: <20121119134734.1fb2d265(a)zeta.dino.sk> 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: 0 Modify: 1 Delete: 0 Syntax Errors: 0 DETAILED EXPLANATION: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The following object(s) were found to have ERRORS: --- Modify FAILED: [domain] 75.245.84.in-addr.arpa ***Info: Authorisation passed ***Info: Syntax check passed domain: 75.245.84.in-addr.arpa descr: Reverse delegation for SWAN, a. s. descr: Netlab network admin-c: SWAN1-RIPE tech-c: SWAN1-RIPE zone-c: SWAN1-RIPE nserver: auth1.ns.swan.sk nserver: auth2.ns.swan.sk notify: lir(a)netlab.sk mnt-by: NETLABPLUS-MNT mnt-by: SWAN-MNT changed: milan(a)netlab.sk source: RIPE ***Warning: Date '20121119' added to changed: attribute 'milan(a)netlab.sk' ***Info: Authorisation for existing [domain] 75.245.84.in-addr.arpa using mnt-by: authenticated by: NETLABPLUS-MNT ***RDNS: (related to 75.245.84.in-addr.arpa) ERROR: Nameserver 217.75.71.143 does not do DNSSEC extra processing. ***RDNS: (related to 75.245.84.in-addr.arpa) ERROR: Nameserver 217.75.71.144 does not do DNSSEC extra processing. ***Error: RDNS Authorisation failed ***Info: Authorisation for [domain] 75.245.84.in-addr.arpa using mnt-by: authenticated by: NETLABPLUS-MNT ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The RIPE Database is subject to Terms and Conditions: http://www.ripe.net/db/support/db-terms-conditions.pdf For assistance or clarification please contact: RIPE Database Administration <ripe-dbm(a)ripe.net> Generated by RIPE WHOIS Update version 1.42 on WHOIS1 Handled mail update (RIPE, LGC, 2012-11-19 13:47:42)

2 1

Sample db for ripe whois server problem
by a.gadelshin＠primereg.ru 26 Sep '12

26 Sep '12

Hello. I've install a latest version of whois server, but can't install sample data. There is sample.db, which contain text information, but there isn't bin/SQL/create.first-stage, bin/SQL/create.second-stage etc. Where I can find them? /opt/whois/bin/make_db -c /opt/whois/conf/rip.config -s SAMPLE -0 *******************Wed Sep 26 18:04:42 MSK 2012****************** Creating tables\n Creating tables\n ./load_all.sh: line 37: ./create.first-stage: No such file or directory Wed Sep 26 18:04:42 MSK 2012\n Making indexes\n ./load_all.sh: line 53: ./create.second-stage: No such file or directory Wed Sep 26 18:04:42 MSK 2012\n Making more indexes\n ./load_all.sh: line 79: ./create.third-stage: No such file or directory Will now convert the DB into InnoDB type Converting tables: abuse_mailbox already uses the 'MYISAM' engine; Ignored admin_c already uses the 'MYISAM' engine; Ignored ... and /opt/whois/bin/make_db -c /opt/whois/conf/rip.config -s SAMPLE -1 *******************Wed Sep 26 18:35:41 MSK 2012****************** Creating tables\n Creating tables\n ./load_all.sh: line 37: ./create.first-stage: No such file or directory Wed Sep 26 18:35:41 MSK 2012\n Making indexes\n ./load_all.sh: line 53: ./create.second-stage: No such file or directory Wed Sep 26 18:35:41 MSK 2012\n Loading tables - 1 of 1 pass\n Wed Sep 26 18:35:41 MSK 2012 Loading /opt/whois/var/tmp/load/SAMPLE/sample.db.gz D: Making SQL connection to ripe_root@localhost ...OK starting processing stream Object cannot be retrieved:[mntner: TEST-DBM-MNT descr: Mntner for DB objects. admin-c: + RDBM-SAMPLE tech-c: RDBM-SAMPLE upd-to: bitbucket(a)ripe.net mnt-nfy: bitbucket(a)ripe.net auth: CRYPT-PW re45C38li6ADw mnt-by: TEST-DBM-MNT referral-by: TEST-DBM-MNT # something new changed: bitbucket(a)ripe.net 20001208 source: SAMPLE ] *** died: +976 modules/ud/ud_process_stream.c *** Backtrace with command line ./load_all.sh: line 15: 13094 Done ${UNZIP1} ${object_file} 13095 | eval ${FILTER} 13096 Segmentation fault | $LOADER -L $1 -p ${PROPERTIES} -s ${SOURCE} *** ERROR: Loader failure [139]. Exiting\n ************** ERROR *************** *** 18:35:41 Error loading database=ripe_root for source=SAMPLE, /opt/whois/bin/make_db exiting ************************************ -- Thx for the help

1 0

SMTP fail
by David Freedman 19 Sep '12

19 Sep '12

-- From: Mail Delivery System <Mailer-Daemon(a)ripe.net> A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed: dbase(a)whois-update.db.ripe.net -- Anybody else getting this?

2 2

Allocations in the test database
by Moritz Lenz 19 Sep '12

19 Sep '12

Hi all, currently I'm integrating automatic assignment of subnets into an application, and face an issue while testing it. The idea was to use the RIPE test database while developing the application. However the test database doesn't have the same allocations as the real database, so the subnets I am trying to assign are directly below the net 0.0.0.0 - 255.255.255.255. Which of course has a different maintainer, and I can't use PGP authentication for that maintainer either. I've tried to simply create the allocations in the test database, but it failed with the message "ALLOCATED inetnum objects require the administrative maintainer." What's the best way to do deal with that problem? Cheers, Moritz

3 5

Source "RIPE" not recognised
by David Freedman 13 Jul '12

13 Jul '12

>***Error: Source [RIPE] not recognised. Well, this is a new one for me, did something change and I just wasn't well enough informed? Dave.

3 3

Re: rdns multiple objects change
by Nathalie Trenaman 02 Jul '12

02 Jul '12

Hi Jan, > Hi Nathalie :) > > Maybe you could help me with multiple "domain" object changes - I know > you can create multiple ones with range option (0-255), but my question > is - can you also change multiple objects with this trick? > > Simobil is moving DNS servers to different IP space and they would also > like to add third rdns server option to all their "domain" objects - and > that might hurt if "ranges" are not supported... > > >> >> Now, about the rev dns objects, no good news there either, im afraid... >> You cant do a 0-255 update. The fastest way to update a batch of domain >> objects is copy-paste them in sync-update and edit them that way. I know, >> not ideal.... > > Oh dear... any chance to get this sorted out? No idea, I don't think so. But I've included the DB gurus from db-help here, maybe they have a good idea :) > >> >> Have a good weekend anyway and dont work to hard ;)) > > I tried :S :) > > Cheers, Jan Cheers, Nathalie

1 0

'E-mail Client Testing for S/MIME' Translation
by Mario Pozner 14 Jun '12

14 Jun '12

Hello, I found interesting your page E-mail Client Testing for S/MIME which I googled on http://ripe.net/internet-coordination/news/announcements/e-mail-client-test…! I'd love to use it in a project I'm involved with called "SOFTcann", so I'm seeking your permission for translation to Ukraine language. SOFTcann is a freemium-model non-English language orientated startup with collection of articles, personal notes etc. that edited by me since 2011. If you agree, I will credit you for your work in the resulting translation's references by stating that it was used with your permission, and by mentioning the name of my project back to your page. Thank you for your time and patience. -- Best wishes, Mario Pozner

2 1

Re: Inserting objects in the ripe test
by Ishwinder Singh 06 Apr '12

06 Apr '12

Hi Colin, That worked. Thanks a lot for the help. I created an inet range 10.11.12.0 - 10.11.12.255 in test db. Now when i go to creating a domain object in test db, I specify the domain as :12.11.10.in-addr-arpa but i get an error message which says that "there is no parent object" even after owning the inet range. Are there some domain values that can be used in test db for testing purposes? Thanks. On Fri, Apr 6, 2012 at 1:47 PM, Colin Davis <colin(a)serverunit.co.uk> wrote: > > Hi, > > The error message suggests TEST-DBM-MNT password has not been stored in > session. > > The password is "emptypassword" without the quotes. Try adding that then > having another go. > > Regards, > Colin. > > > > On 06/04/12 02:58, Ishwinder Singh wrote: > > Hi All, > > I am trying to create an inetnum type of object in the ripe test > database but i am unable to get past the eternal authorization error. The > Maintainer in the test db that i am using is IS-MNT and i am requesting the > ip range 193.0.0.0 - 193.0.0.255 (I am not sure if this should be a valid > range for test db purposes but i assume that i should be able to get an > inetnum in test db at any range). I have tried with > maintainer IS11260-MNT(organization's maintainer) as well to no relief. I > am sure that i have entered the correct session password on the passwords > list. After doing all this i keep getting the following error: > > rom-Host: 124.253.3.194 > - Date/Time: Fri Apr 6 09:43:11 2012 > > > 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] 193.0.0.0 - 193.0.0.255 > ***Error: Authorisation failed > ***Info: Syntax check passed > > inetnum: 193.0.0.0 - 193.0.0.255 > netname: Test-Network > descr: Testing for IS > country: NL > admin-c: IS1-TEST > tech-c: IS1-TEST > status: ASSIGNED PA > mnt-by: IS-MNT > mnt-by: IS11260-MNT > changed: ishwinder(a)enbake.com > source: TEST > ***Warning: Date '20120406' added to changed: attribute 'ishwinder(a)enbake.com' > > > ***Info: Authorisation for parent [inetnum] 0.0.0.0 - 255.255.255.255 > using mnt-lower: > not authenticated by: TEST-DBM-MNT > > ***Info: Authorisation for [inetnum] 193.0.0.0 - 193.0.0.255 > using mnt-by: > authenticated by: IS-MNT, IS11260-MNT > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > The RIPE Database is subject to Terms and Conditions:http://www.ripe.net/db/support/db-terms-conditions.pdf > > > For assistance or clarification please contact: > RIPE Database Administration <ripe-dbm(a)ripe.net> > > > Can someone guide on what i am doing wrong here and how i can create a inetnum object? Thanks in advance > > > -- > Thanks & Regards, > > > -- Thanks & Regards, Ishwinder Singh Enbake Consulting. Phone: +91-987-28-20737 Skype: enbake.

3 3