On Sun, May 28, 2006 at 10:44:08AM +0300, Nicolae Ghimbovschi wrote: Dear Nicolae, There is an error in the release version of SQL script to build the database. Please find the patch attached.
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@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
-- Katie Petrusha RIPE NCC