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