This archive is retained to ensure existing URLs remain functional. It will not contain any emails sent to this mailing list after July 1, 2024. For all messages, including those sent before and after this date, please visit the new location of the archive at https://mailman.ripe.net/archives/list/[email protected]/
[db-wg] please help, can't start whoisserver
- Previous message (by thread): [db-wg] please help, can't start whoisserver
- Next message (by thread): [db-wg] Mike Simkins is out of the office.
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Katie Petrusha
katie at ripe.net
Mon May 29 16:23:20 CEST 2006
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 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 -- Katie Petrusha RIPE NCC -------------- next part -------------- Index: create.tables.sql.in =================================================================== RCS file: /srv/pubcvs/cvs/cvsroot/whoisserver/src/SQL/create.tables.sql.in,v retrieving revision 1.6 retrieving revision 1.8 diff -r1.6 -r1.8 252c253 < PRIMARY KEY (interface_v6_lsp,interface_v6_lsp,interface_v4,object_id) --- > PRIMARY KEY (interface_v6_msp,interface_v6_lsp,interface_v4,object_id)
- Previous message (by thread): [db-wg] please help, can't start whoisserver
- Next message (by thread): [db-wg] Mike Simkins is out of the office.
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
[ db-wg Archives ]