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(a)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
