September 2012 - db-help - mailman.ripe.net

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