[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference azur::mcc

Title:	DECmcc user notes file. Does not replace IPMT.
Notice:	Use IPMT for problems. Newsletter location in note 6187
Moderator:	TAEC::BEROUD

Created:	Mon Aug 21 1989
Last Modified:	Wed Jun 04 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	6497
Total number of notes:	27359

1511.0. "SQL for Exporter in DECmcc for ULTRIX" by TOOK::MINTZ (Erik Mintz) Mon Sep 16 1991 16:17

Discussion moved from note 1486.5:

> 2) Unable to create exporter db during install. Said that createdb command
>    didn't exist, although it is in /usr/kits/sql/sql/bin on the system and
>    is recognized after sourcing the sqladmin.csh.
>
>    Where can I get more info on creating this db post install? Release notes
>    don't go into a lot of detail on this.

Yes, if you use SQL (which is required for Exporter, and so documented),
then you need to source /usr/kits/sql/sqladmin.csh.  I would suggest
using "setld -c MCRBMST122 install" to re-run the configuration
procedure.

Our bug is that the installation should have detected that SQL was not
available, and told you about it before you got the error.

T.R	Title	User	Personal Name	Date	Lines
1511.1	QAR'd	TOOK::MINTZ	Erik Mintz	`Mon Sep 16 1991 16:30`	2
	QAR 854 in MCC_INTERNAL
1511.2	we did	NSCRUE::KEANE	U.S. DNS Service Development and Delivery	`Mon Sep 16 1991 16:46`	20
	.cshrc and .profile set this up These are your ULTRIX/SQL processes: 514 ? I 0:00 iigcn II 585 ? I 0:00 iigcc II IB(4)OB(8) 624 ? I 0:00 iidbms II 1038 5807 p3 S 0:00 grep ii Checking for export database Creating export database mcc_exporter_rdb sh5: createdb: not found # echo $path /usr/kits/sql/sql/bin /usr/kits/sql/sql/utility /usr/ucb /bin /usr/bin /etc /etc /sec /usr/etc /usr/etc/sec /usr/local/bin /usr/new /usr/hosts . # sh # echo $PATH /usr/kits/sql/sql/bin:/usr/kits/sql/sql/utility:/usr/ucb:/bin:/usr/bin:/etc:/etc /sec:/usr/etc:/usr/etc/sec:/usr/local/bin:/usr/new:/usr/hosts:.
1511.3	If you installed SQL recently, try "rehash"	TOOK::MINTZ	Erik Mintz	`Mon Sep 16 1991 17:04`	7
	OK, this is really strange. Did you, perhaps, install SQL at the same time as MCC? If your path is set correctly (as you show), and you still can't see an executable, the only thing I can think of is that you might have t "rehash", if the executable was installed since you logged in.
1511.4		TOOK::SWIST	Jim Swist LKG2-2/T2 DTN 226-7102	`Mon Sep 16 1991 17:24`	2
	In addition to "echo $path", how about trying "createdb" outside the script?
1511.5	tried these	NSCRUE::KEANE	U.S. DNS Service Development and Delivery	`Mon Sep 16 1991 17:48`	10
	SQL had been on the system long before mcc install. We had tried the creatdb outside the script and it works OK. Comes back with an error that we didn't specify a db but does find the command. That is why I was asking for a method of creating the db outside of the install procedure. What db name, etc. should I use? Thanks for the quick replies. Scott
1511.6	Setting up export database manually	TOOK::MINTZ	Erik Mintz	`Mon Sep 16 1991 19:38`	11
	Extracted from the installation script: EXPORTDB=mcc_exporter_rdb echo "Creating export database ${EXPORTDB}" createdb ${EXPORTDB} ingsetenv ING_SET_${EXPORTDB} \ 'set lockmode session where level = table, readlock=nolock'
1511.7	that worked	NSCRUE::KEANE	U.S. NIS Service Development and Delivery	`Mon Sep 16 1991 20:19`	5
	Creating the db outside of the install script worked. I still don't understand why it didn't work inside the script. Scott