[db-wg] please help, can't start whoisserver

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 at 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 at 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 at 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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ripe.net/ripe/mail/archives/db-wg/attachments/20060528/f7d89e75/attachment.html>