firebird-checkins — CVS checkins

[Firebird-checkins] CVS: interbase/firebird/fsg/TCS dump_gtcs.pl,1.3,1.4 fix_it.sql,1.1,1.2 howto.txt,1.1,1.2 import_all,1.1,1.2 import_gtcs.pl,1.1,1.2

[Frank Schlottmann-G. <fs...@us...>]

Update of /cvsroot/firebird/interbase/firebird/fsg/TCS
In directory slayer.i.sourceforge.net:/tmp/cvs-serv17129/interbase/firebird/fsg/TCS

Modified Files:
	dump_gtcs.pl fix_it.sql howto.txt import_all import_gtcs.pl 
Log Message:
Changes to handle <null> values correctly


Index: dump_gtcs.pl
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/fsg/TCS/dump_gtcs.pl,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** dump_gtcs.pl	2000/11/07 16:04:07	1.3
--- dump_gtcs.pl	2000/11/10 14:43:13	1.4
***************
*** 162,166 ****
          foreach $Fields (@row)
          {
!              
             if ($st->{Datatypes}[$i] eq 'BLOB')
             # Dump the blob to a file and print a reference
--- 162,171 ----
          foreach $Fields (@row)
          {
!            if ($st->{Nulls}[$i])
!            {
!              print OUT "<null>;";
!            }
!            else
!            {
             if ($st->{Datatypes}[$i] eq 'BLOB')
             # Dump the blob to a file and print a reference
***************
*** 191,194 ****
--- 196,200 ----
               } 
               print OUT "$Fields;";
+            }
             }
         ++$i;

Index: fix_it.sql
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/fsg/TCS/fix_it.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** fix_it.sql	2000/11/07 16:04:07	1.1
--- fix_it.sql	2000/11/10 14:43:13	1.2
***************
*** 1,10 ****
  set sql dialect 3;
- update tests set EDIT_BY='NN' where EDIT_BY is null;
  update tests set "DATE"='01.01.80' where "DATE"<'01.01.80';
- update series_comment set EDIT_BY='NN' where EDIT_BY is null;
- update series_comment set CREATED_BY='NN' where CREATED_BY is null;
- update series_comment set "DATE"='01.01.80' where "DATE" is null;
- update series_comment set EDIT_DATE='01.01.80' where EDIT_DATE is null;
- 
  commit;
  exit;
--- 1,4 ----

Index: howto.txt
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/fsg/TCS/howto.txt,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** howto.txt	2000/11/07 16:04:07	1.1
--- howto.txt	2000/11/10 14:43:13	1.2
***************
*** 4,8 ****
  database.
  
! This would make it possible to place the tests under 
  cvs control.
  
--- 4,8 ----
  database.
  
! This would make it possible to place a test pool under 
  cvs control.
  
***************
*** 22,26 ****
  
  5. If you like your newly created gtcs.gdb, copy it to
!    your tests directory.
  
  
--- 22,31 ----
  
  5. If you like your newly created gtcs.gdb, copy it to
!    your tests directory. 
!  
!    Sorry, at the moment the TCS will not work correctly 
!    with this new gtcs.gdb. I'm working on this.
! 
! Frank
  
  

Index: import_all
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/fsg/TCS/import_all,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2

Index: import_gtcs.pl
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/fsg/TCS/import_gtcs.pl,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** import_gtcs.pl	2000/11/07 16:04:07	1.1
--- import_gtcs.pl	2000/11/10 14:43:13	1.2
***************
*** 69,76 ****
        {
           open(FILEHANDLE,"./export/global/$Field");
!          sysread(FILEHANDLE, @data[$i], 1000000);
         #  @data[$i]='BLOB';
        }     
! #      print "@data[$i], ";
        ++$i;
      } 
--- 69,80 ----
        {
           open(FILEHANDLE,"./export/global/$Field");
!          sysread(FILEHANDLE, $data[$i], 1000000);
         #  @data[$i]='BLOB';
        }     
! 
!       if ($Field eq '<null>')
!       {
!          $data[$i]=undef;
!       }
        ++$i;
      } 
***************
*** 78,84 ****
      while ($i > @data)
      {
!     @data=(@data,'');
      }
- #    print "\n";
      if ($st->execute( @data ) < 0)
      {
--- 82,87 ----
      while ($i > @data)
      {
!        @data=(@data,undef);
      }
      if ($st->execute( @data ) < 0)
      {

[Firebird-checkins] CVS: interbase/utilities guard.c,1.2,1.3 ibmgr.c,1.2,1.3 ibmgr.h,1.2,1.3 ibmgrswi.h,1.1.1.1,1.2 srvrmgr.c,1.1.1.1,1.2

[Frank Schlottmann-G. <fs...@us...>]

Update of /cvsroot/firebird/interbase/utilities
In directory slayer.i.sourceforge.net:/tmp/cvs-serv13842/interbase/utilities

Modified Files:
	guard.c ibmgr.c ibmgr.h ibmgrswi.h srvrmgr.c 
Log Message:
Added -s switch to guardian to ignore startup errors 
and related changes to ibmgr and svrmgr


Index: guard.c
===================================================================
RCS file: /cvsroot/firebird/interbase/utilities/guard.c,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** guard.c	2000/10/16 16:09:48	1.2
--- guard.c	2000/11/10 14:08:07	1.3
***************
*** 16,24 ****
   * All Rights Reserved.
   * Contributor(s): ______________________________________.
   */
! /* contains the main() and not shared routines for ibguard */
  
  #define FOREVER		1
  #define ONETIME		2
  #define NORMAL_EXIT	0
  
--- 16,26 ----
   * All Rights Reserved.
   * Contributor(s): ______________________________________.
+  * $Id$
   */
!  /* contains the main() and not shared routines for ibguard */
  
  #define FOREVER		1
  #define ONETIME		2
+ #define IGNORE          3
  #define NORMAL_EXIT	0
  
***************
*** 82,87 ****
                  option = ONETIME;
                  break;
              default  :
! 		ib_fprintf (ib_stderr, "Usage: %s [-onetime | -forever (default)]\n",
  			 prog_name);
  		exit (-1);
--- 84,92 ----
                  option = ONETIME;
                  break;
+             case 'S':
+                 option = IGNORE;
+                 break;
              default  :
! 		ib_fprintf (ib_stderr, "Usage: %s [-signore | -onetime | -forever (default)]\n",
  			 prog_name);
  		exit (-1);
***************
*** 151,156 ****
                  prog_name, server_args [1] ? server_args [1] : 
                     SUPER_SERVER_BINARY, ret_code);
! 	    done = TRUE; /* do not restart we have a startup problem */
! 
  	    }
  	else
--- 156,175 ----
                  prog_name, server_args [1] ? server_args [1] : 
                     SUPER_SERVER_BINARY, ret_code);
! 	    if (option == IGNORE)
! 	        {
! 	         gds__log ("%s: %s terminated due to startup error (%d)\n Trying again\n",
! 	                    prog_name, server_args [1] ? server_args [1] :
! 	                    SUPER_SERVER_BINARY, ret_code);
! 	                                                 
! 	        done = FALSE; /* Try it again, Sam (even if it is a startup error) FSG 8.11.2000*/
!                 }
!             else
!                 {
!                 gds__log ("%s: %s terminated due to startup error (%d)\n",
!                           prog_name, server_args [1] ? server_args [1] :
!                           SUPER_SERVER_BINARY, ret_code);
!                                                          
!                 done = TRUE;  /* do not restart we have a startup problem */
!                 } 
  	    }
  	else
***************
*** 159,163 ****
  		server_args [1] ? server_args [1] : SUPER_SERVER_BINARY,
  		ret_code);
! 	    if (option == FOREVER)
  	        done = FALSE;
  	    }
--- 178,182 ----
  		server_args [1] ? server_args [1] : SUPER_SERVER_BINARY,
  		ret_code);
! 	    if (option == FOREVER || option == IGNORE)
  	        done = FALSE;
  	    }

Index: ibmgr.c
===================================================================
RCS file: /cvsroot/firebird/interbase/utilities/ibmgr.c,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** ibmgr.c	2000/10/16 16:09:48	1.2
--- ibmgr.c	2000/11/10 14:08:07	1.3
***************
*** 21,24 ****
--- 21,25 ----
   * All Rights Reserved.
   * Contributor(s): ______________________________________.
+  * $Id$
   */
  
***************
*** 412,415 ****
--- 413,417 ----
  	    case IN_SW_IBMGR_ONCE:
  	    case IN_SW_IBMGR_FOREVER:
+ 	    case IN_SW_IBMGR_SIGNORE:
  	    case IN_SW_IBMGR_SHUT:
  	    case IN_SW_IBMGR_NOW:
***************
*** 605,608 ****
--- 607,611 ----
  	    case IN_SW_IBMGR_ONCE:
  	    case IN_SW_IBMGR_FOREVER:
+ 	    case IN_SW_IBMGR_SIGNORE:
  	    case IN_SW_IBMGR_NOW:
  	    case IN_SW_IBMGR_NOAT:
***************
*** 639,643 ****
  		    case IN_SW_IBMGR_ONCE:
  		    case IN_SW_IBMGR_FOREVER:
! 			if (ibmgr_data->operation != OP_START)
  			    {
  			    err_msg_no = MSG_INVSWOP;
--- 642,647 ----
  		    case IN_SW_IBMGR_ONCE:
  		    case IN_SW_IBMGR_FOREVER:
!                     case IN_SW_IBMGR_SIGNORE:
!                     if (ibmgr_data->operation != OP_START)
  			    {
  			    err_msg_no = MSG_INVSWOP;
***************
*** 646,649 ****
--- 650,655 ----
  			if (in_sw == IN_SW_IBMGR_ONCE)
  			    ibmgr_data->suboperation = SOP_START_ONCE;
+ 			else if (in_sw == IN_SW_IBMGR_SIGNORE)
+ 			    ibmgr_data->suboperation = SOP_START_SIGNORE;
  			else
  			    ibmgr_data->suboperation = SOP_START_FOREVER;
***************
*** 796,800 ****
  ib_fprintf (OUTFILE, "or		ibmgr<RETURN>\n");
  ib_fprintf (OUTFILE, "		IBMGR> command [-option [parameter]]\n\n");
! ib_fprintf (OUTFILE, "Commands are:	start [-once|-forever]	start server\n");
  ib_fprintf (OUTFILE, "		shut  [-now]		shutdown server\n");
  ib_fprintf (OUTFILE, "		show			show host and user\n");
--- 802,806 ----
  ib_fprintf (OUTFILE, "or		ibmgr<RETURN>\n");
  ib_fprintf (OUTFILE, "		IBMGR> command [-option [parameter]]\n\n");
! ib_fprintf (OUTFILE, "Commands are:	start [-once|-signore|-forever]	start server\n");
  ib_fprintf (OUTFILE, "		shut  [-now]		shutdown server\n");
  ib_fprintf (OUTFILE, "		show			show host and user\n");
***************
*** 806,810 ****
  ib_fprintf (OUTFILE, "as an option switches for commands like start or shut.\n");
  ib_fprintf (OUTFILE, "For example, to shutdown server you can: \n\n");
! ib_fprintf (OUTFILE, "ibmgr -shut -password <password>\n\ \n");
  ib_fprintf (OUTFILE, "or\n\n");
  ib_fprintf (OUTFILE, "ibmgr<RETURN>\n");
--- 812,816 ----
  ib_fprintf (OUTFILE, "as an option switches for commands like start or shut.\n");
  ib_fprintf (OUTFILE, "For example, to shutdown server you can: \n\n");
! ib_fprintf (OUTFILE, "ibmgr -shut -password <password>\n\n");
  ib_fprintf (OUTFILE, "or\n\n");
  ib_fprintf (OUTFILE, "ibmgr<RETURN>\n");

Index: ibmgr.h
===================================================================
RCS file: /cvsroot/firebird/interbase/utilities/ibmgr.h,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** ibmgr.h	2000/10/16 16:09:48	1.2
--- ibmgr.h	2000/11/10 14:08:07	1.3
***************
*** 20,23 ****
--- 20,24 ----
   * All Rights Reserved.
   * Contributor(s): ______________________________________.
+  * $Id$
   */
  
***************
*** 74,78 ****
  #define SOP_SHUT_IGN		6
  #define SOP_PRINT_POOL		7
! 
  
  /* Flags that are used in "par_entered" field of the IBMGR_DATA.
--- 75,79 ----
  #define SOP_SHUT_IGN		6
  #define SOP_PRINT_POOL		7
! #define SOP_START_SIGNORE        8
  
  /* Flags that are used in "par_entered" field of the IBMGR_DATA.

Index: ibmgrswi.h
===================================================================
RCS file: /cvsroot/firebird/interbase/utilities/ibmgrswi.h,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -r1.1.1.1 -r1.2
*** ibmgrswi.h	2000/08/03 20:54:27	1.1.1.1
--- ibmgrswi.h	2000/11/10 14:08:07	1.2
***************
*** 20,23 ****
--- 20,24 ----
   * All Rights Reserved.
   * Contributor(s): ______________________________________.
+  * $Id$
   */
  
***************
*** 47,50 ****
--- 48,52 ----
  #define IN_SW_IBMGR_PRINT	17	/* Print Stats */
  #define IN_SW_IBMGR_POOL	18	/* Print pool */
+ #define IN_SW_IBMGR_SIGNORE      19      /* start server, restart when it dies, even if it was a start up error */
  
  #define IN_SW_IBMGR_AMBIG	99	/* ambiguous switch */
***************
*** 54,57 ****
--- 56,60 ----
      IN_SW_IBMGR_ONCE,		0,	"ONCE",		0, 0, 0, FALSE,	0,	1,	NULL,	/* start server once */
      IN_SW_IBMGR_FOREVER,	0,	"FOREVER",	0, 0, 0, FALSE,	0,	1,	NULL,	/* restart when server dies */
+     IN_SW_IBMGR_SIGNORE,         0,     "SIGNORE",      0, 0, 0, FALSE, 0,      1,      NULL,   /* dito, ignore start up error */
      IN_SW_IBMGR_SHUT,		0,	"SHUT",		0, 0, 0, FALSE,	0,	3,      NULL,   /* shutdown server */
      IN_SW_IBMGR_NOW,		0,	"NOW",		0, 0, 0, FALSE,	0,	3,      NULL,   /* immidiate shutdown */

Index: srvrmgr.c
===================================================================
RCS file: /cvsroot/firebird/interbase/utilities/srvrmgr.c,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -r1.1.1.1 -r1.2
*** srvrmgr.c	2000/08/03 20:54:29	1.1.1.1
--- srvrmgr.c	2000/11/10 14:08:07	1.2
***************
*** 21,24 ****
--- 21,25 ----
   * All Rights Reserved.
   * Contributor(s): ______________________________________.
+  * $Id$
   */
   
***************
*** 486,489 ****
--- 487,492 ----
  if (data->suboperation == SOP_START_ONCE)
      argv[1] = "-o";
+ else if (data->suboperation == SOP_START_SIGNORE)
+     argv[1] = "-s";
  else
      argv[1] = "-f";

[Firebird-checkins] CVS: interbase/firebird/fsg/TCS fix_it.sql,NONE,1.1 gtcs.gdl,NONE,1.1 howto.txt,NONE,1.1 import_all,NONE,1.1 import_gtcs.pl,NONE,1.1 dump_gtcs.pl,1.2,1.3

[Frank Schlottmann-G. <fs...@us...>]

Update of /cvsroot/firebird/interbase/firebird/fsg/TCS
In directory slayer.i.sourceforge.net:/tmp/cvs-serv972/interbase/firebird/fsg/TCS

Modified Files:
	dump_gtcs.pl 
Added Files:
	fix_it.sql gtcs.gdl howto.txt import_all import_gtcs.pl 
Log Message:
Added some scripts to import and export test data


--- NEW FILE ---
set sql dialect 3;
update tests set EDIT_BY='NN' where EDIT_BY is null;
update tests set "DATE"='01.01.80' where "DATE"<'01.01.80';
update series_comment set EDIT_BY='NN' where EDIT_BY is null;
update series_comment set CREATED_BY='NN' where CREATED_BY is null;
update series_comment set "DATE"='01.01.80' where "DATE" is null;
update series_comment set EDIT_DATE='01.01.80' where EDIT_DATE is null;

commit;
exit;

--- NEW FILE ---
define database "./import/gtcs.gdb"
	{
Note: The definition for LTCS.GDB is a subset of the
      definition for GTCS.GDB.  GTCS has the additional
      relation "AUDIT".

      1995-January-26 David Schnepper
	
}
	page_size 4096;


/*	Global Field Definitions	*/

define field BUG_NO short;
define field CATEGORY varying [20];
define field COMMENT blob segment_length 80;
define field COUNT short;
define field CREATED_BY char [20];
define field DATE date;
define field DIFFERENCES blob segment_length 80;
define field EDIT_BY char [20];
define field EDIT_DATE date;
define field FAIL_COUNT short;
define field HOST_INFO char [60];
define field INIT_BY char [20];
define field INIT_DATE date
	edit_string "dd-mmm-yy";
define field META_SERIES_NAME varying [20];
define field NAME char [20];
define field NOTE blob segment_length 80;
define field NO_INIT_FLAG short
	valid if (no_init_flag = 1 or
	no_init_flag = 0 or
	no_init_flag missing)
	missing_value is 0;
define field NO_RUN_FLAG short;
define field OUTPUT blob segment_length 80;
define field PYXIS$FORM blob segment_length 80;
define field PYXIS$FORM_NAME char [31];
define field PYXIS$FORM_TYPE char [16];
define field QLI$PROCEDURE blob segment_length 80 sub_type text
	system_flag 2;
define field QLI$PROCEDURE_NAME char [31]
	system_flag 2;
define field RDB$31 varying [10];
define field RDB$33 varying [10];
define field RDB$35 varying [10];
define field RDB$37 varying [10];
define field RESULT long;
define field RUN char [20];
define field RUN_BY char [20];
define field RUN_DATE date;
define field RUN_STOP date;
define field SCRIPT blob segment_length 80;
define field SEQUENCE short;
define field SERIES_NAME char [20];
define field STATUS short;
define field TEST_NAME varying [20];
define field TIME long;
define field TIMESTAMP date;
define field VERSION varying [8];


/*	Relation Definitions	*/


define relation AUDIT
    TESTER based on NAME	position 1,
    TEST_NAME based on NAME	position 2
	query_name NAME,
    RUN_NAME based on RUN	position 3
	query_name RUN,
    DATE	position 5,
    HOST_INFO	position 6,
    VERSION based on RDB$37	position 8;

define relation BOILER_PLATE
    BOILER_PLATE_NAME based on NAME	position 1
	query_name NAME,
    SCRIPT	position 2,
    CREATED_BY	position 3,
    DATE	position 4;

define relation CATEGORIES
    CATEGORY	position 1;

define relation ENV
    ENV_NAME based on NAME	position 1
	query_name NAME,
    PROLOG based on SCRIPT	position 2,
    EPILOG based on SCRIPT	position 3,
    CREATED_BY	position 4,
    DATE	position 5;

define relation FAILURES
    TEST_NAME based on NAME	position 1
	query_name NAME,
    RUN	position 3,
    DATE	position 4,
    OUTPUT	position 5,
    DIFFERENCES	position 6,
    ENV_NAME based on NAME	position 7,
    BOILER_PLATE_NAME based on NAME	position 8,
    RUN_BY	position 9,
    VERSION based on RDB$33	position 11;

define relation INIT
    TEST_NAME based on NAME	position 1
	query_name NAME,
    OUTPUT	position 3,
    INIT_BY	position 4,
    INIT_DATE	position 5,
    BOILER_PLATE based on NAME	position 6,
    ENV_NAME based on NAME	position 7,
    VERSION based on RDB$35	position 9;

define relation KNOWN_FAILURES
    TEST_NAME based on NAME	position 1
	query_name NAME,
    VERSION	position 2,
    INIT_BY	position 4,
    INIT_DATE	position 5,
    BOILER_PLATE_NAME based on NAME	position 6,
    ENV_NAME based on NAME	position 7,
    STATUS	position 8,
    BUG_NO	position 9,
    COMMENT	position 10,
    RUN	position 11;

define relation META_SERIES
    META_SERIES_NAME based on NAME	position 1
	query_name NAME,
    SERIES_NAME based on NAME	position 2,
    SEQUENCE	position 3;

define relation META_SERIES_COMMENT
    META_SERIES_NAME based on NAME	position 1
	query_name NAME,
    COMMENT	position 2,
    CREATED_BY	position 3,
    DATE	position 4,
    EDIT_BY	position 5,
    EDIT_DATE	position 6;

define relation NOTES
    TEST_NAME based on NAME	position 1
	query_name NAME,
    NOTE	position 2;

define relation PYXIS$FORMS
	system_flag 2
    PYXIS$FORM_NAME	position 1,
    PYXIS$FORM_TYPE	position 2,
    PYXIS$FORM	position 3;

define relation QLI$PROCEDURES
	system_flag 2
    QLI$PROCEDURE_NAME	position 0
	system_flag 2,
    QLI$PROCEDURE	position 1
	system_flag 2;

define relation SERIES
    SERIES_NAME based on NAME	position 1
	query_name NAME,
    TEST_NAME based on NAME	position 2,
    CREATED_BY	position 3,
    SEQUENCE	position 3;

define relation SERIES_COMMENT
    SERIES_NAME based on NAME	position 1
	query_name NAME,
    COMMENT	position 2,
    CREATED_BY	position 3,
    DATE	position 4,
    EDIT_BY	position 5,
    EDIT_DATE	position 6;

define relation TESTS
    TEST_NAME based on NAME	position 1
	query_name NAME,
    SCRIPT	position 3,
    CATEGORY	position 4,
    CREATED_BY	position 5,
    DATE	position 6,
    EDIT_BY	position 7,
    EDIT_DATE	position 8,
    NO_RUN_FLAG	position 9,
    COMMENT	position 10,
    VERSION based on RDB$31	position 12,
    NO_INIT_FLAG,
    CREATED_DATE date computed by (date);

define relation TIMES
    TEST_NAME based on NAME	position 1
	query_name NAME,
    DATE	position 2,
    TIME	position 3;

define relation WORKLIST
    SERIES_NAME based on NAME	position 1,
    SEQUENCE	position 2,
    STATUS	position 3,
    MACHINE based on NAME	position 4,
    START_TIME based on TIMESTAMP	position 5,
    END_TIME based on TIMESTAMP	position 6,
    PASSED based on RESULT	position 7,
    FAILED based on RESULT	position 8,
    NOT_RUN based on RESULT	position 9,
    KILLED based on RESULT	position 10,
    BOILER_PLATE_NAME based on NAME	position 11,
    FAILED_KNOWN based on RESULT	position 12,
    FAILED_UNINIT based on RESULT	position 13,
    SKIPPED_FLAGGED based on RESULT	position 14,
    SKIPPED_NOTFOUND based on RESULT	position 15,
    CONFIGURATION based on CATEGORY	position 16;


/*	Index Definitions	*/


define index AUDIT_1 for AUDIT 
	TESTER,
	TEST_NAME;

define index BP_1 for BOILER_PLATE unique
	BOILER_PLATE_NAME;

define index ENV_1 for ENV unique
	ENV_NAME;

define index FAILURES_1A for FAILURES 
	TEST_NAME;

define index FAILURES_2 for FAILURES 
	RUN;

define index INIT_1 for INIT unique
	TEST_NAME,
	VERSION;

define index KNOWN_1 for KNOWN_FAILURES 
	TEST_NAME;

define index META_1 for META_SERIES unique
	META_SERIES_NAME,
	SERIES_NAME,
	SEQUENCE;

define index NOTES_INDEX for NOTES 
	TEST_NAME;

define index QLI$PROCEDURES_IDX1 for QLI$PROCEDURES unique
	QLI$PROCEDURE_NAME;

define index SERIES1 for SERIES 
	SERIES_NAME;

define index SERIES2 for SERIES 
	TEST_NAME;

define index CATEGORY for TESTS 
	CATEGORY;

define index TEST_1 for TESTS unique
	TEST_NAME,
	VERSION;

define index WORKLIST_SEQUENCE for WORKLIST unique
	SEQUENCE;

/*	Add Security Classes to Defined Objects	*/





define trigger BOILER_PLATE$STORE for BOILER_PLATE
	pre store 0:
begin
        if new.created_by MISSING
	    new.created_by = rdb$user_name;

	if new.date MISSING
	    new.date = 'now';
end;

	
	end_trigger;

define trigger ENV$MODIFY for TESTS
	pre modify 0:
begin
	    new.edit_by = rdb$user_name;
	    new.edit_date = 'now';
end;

	
	end_trigger;

define trigger ENV$STORE for ENV
	pre store 0:
begin
        if new.created_by MISSING
	    new.created_by = rdb$user_name;

	if new.date MISSING
	    new.date = 'now';
end;

	
	end_trigger;

define trigger FAILURES$STORE for FAILURES
	pre store 0:
new.run_by = rdb$user_name;

	
	end_trigger;

define trigger INIT$MODIFY for INIT
	pre modify 0:
if (new.init_date != old.init_date or
	    new.init_date not missing and old.init_date missing)
		new.init_by = rdb$user_name;

	
	end_trigger;

define trigger INIT$MODIFY2 for INIT
	pre modify 0:
begin
	if (new.init_date MISSING)
	    new.init_date = "NOW";
	if (new.init_by missing)
	    new.init_by = rdb$user_name;
	end
	
	end_trigger;

define trigger INIT$STORE2 for INIT
	pre store 0:
begin
	if (new.init_date MISSING)
	    new.init_date = "NOW";
	if (new.init_by missing)
	    new.init_by = rdb$user_name;
	end
	
	end_trigger;

define trigger KNOWN_FAILURES$MODIFY for KNOWN_FAILURES
	pre modify 0:
begin
	if ((new.init_date != old.init_date) or
	    (new.init_date not missing and old.init_date missing))
		new.init_by = rdb$user_name;

	if new.init_date MISSING
	    new.init_date = 'now';
	if new.init_by MISSING
	    new.init_by = rdb$user_name;
end;
	
	
	end_trigger;

define trigger KNOWN_FAILURES$STORE for KNOWN_FAILURES
	pre store 0:
begin
        if new.init_by MISSING
	    new.init_by = rdb$user_name;

	if new.init_date MISSING
	    new.init_date = 'now';
end;
	
	
	end_trigger;

define trigger TESTS$STORE for TESTS
	pre store 0:
begin
        if new.created_by MISSING
	    new.created_by = rdb$user_name;

	if new.date MISSING
	    new.date = 'now';
end;

	
	end_trigger;

***** Error reading new file: (2, 'No such file or directory')
***** Error reading new file: (2, 'No such file or directory')
***** Error reading new file: (2, 'No such file or directory')
Index: dump_gtcs.pl
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/fsg/TCS/dump_gtcs.pl,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** dump_gtcs.pl	2000/11/06 15:14:03	1.2
--- dump_gtcs.pl	2000/11/07 16:04:07	1.3
***************
*** 3,7 ****
  # dump_gtcs.pl - dumps data from gtcs.gdb to disk.
  #
! # Copyright 2000 FSG.
  
  use IBPerl;
--- 3,18 ----
  # dump_gtcs.pl - dumps data from gtcs.gdb to disk.
  #
! # Copyright 2000 FSG
! # This is based on the example select.pl
! # from Bill Karwin.
! # As I have no idea how to write perl programs
! # this may be ugly, buggy or whatsoever
! # tested with IBPerl-0.8p3
! #
! # use fix_it.sql before you try to export from
! # an original gtcs.gdb, otherwise
! # import_gtcs won't work as expected
! #
! #
  
  use IBPerl;
***************
*** 119,126 ****
      
       
!     $outname= ">".$EXPORTPATH.$table.".dat";
      open(OUT,$outname) || die "can't create file $outname";
!     print OUT $table . "\n";
!     print "Processing ".$table."\n";  
      while (1)
      {
--- 130,137 ----
      
       
!     $outname= ">".$EXPORTPATH.$table.".csv";
      open(OUT,$outname) || die "can't create file $outname";
!     print OUT "$table\n";
!     print "Processing $table\n";  
      while (1)
      {
***************
*** 140,144 ****
           foreach $_ (@row) 
           {
!            print OUT $st->{Columns}[$i]. ";";
             ++$i;  
            }
--- 151,155 ----
           foreach $_ (@row) 
           {
!            print OUT "\"$st->{Columns}[$i]\";";
             ++$i;  
            }
***************
*** 155,160 ****
             # Dump the blob to a file and print a reference
             {
!              $outname= "@"."$table.$st->{Columns}[$i].$keyname.blob";
!              print OUT $outname; 
               open (BLOB, ">".$EXPORTPATH.$outname);
               print BLOB $Fields;
--- 166,171 ----
             # Dump the blob to a file and print a reference
             {
!              $outname= "@"."$table.$st->{Columns}[$i].$keyname.".$count.".blob";
!              print OUT "$outname;"; 
               open (BLOB, ">".$EXPORTPATH.$outname);
               print BLOB $Fields;
***************
*** 179,183 ****
                 }
               } 
!              print OUT $Fields . ";";
             }
         ++$i;
--- 190,194 ----
                 }
               } 
!              print OUT "$Fields;";
             }
         ++$i;

[Firebird-checkins] CVS: interbase/firebird/patrickgriffin/proposed_patches - New directory

[Patrick J. P. G. <pat...@us...>]

Update of /cvsroot/firebird/interbase/firebird/patrickgriffin/proposed_patches
In directory slayer.i.sourceforge.net:/tmp/cvs-serv18186/proposed_patches

Log Message:
Directory /cvsroot/firebird/interbase/firebird/patrickgriffin/proposed_patches added to the repository

[Firebird-checkins] CVS: interbase/firebird/fsg/TCS dump_gtcs.pl,1.1,1.2

[Frank Schlottmann-G. <fs...@us...>]

Update of /cvsroot/firebird/interbase/firebird/fsg/TCS
In directory slayer.i.sourceforge.net:/tmp/cvs-serv22141

Modified Files:
	dump_gtcs.pl 
Log Message:
tried it again


Index: dump_gtcs.pl
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/fsg/TCS/dump_gtcs.pl,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** dump_gtcs.pl	2000/11/06 15:04:28	1.1
--- dump_gtcs.pl	2000/11/06 15:14:03	1.2
***************
*** 11,15 ****
  my $EXPORTPATH='./export/global/';
  
- 
  # Connect to database
  
--- 11,14 ----

[Firebird-checkins] CVS: interbase/firebird/fsg/TCS dump_gtcs.pl,NONE,1.1

[Frank Schlottmann-G. <fs...@us...>]

Update of /cvsroot/firebird/interbase/firebird/fsg/TCS
In directory slayer.i.sourceforge.net:/tmp/cvs-serv21496

Added Files:
	dump_gtcs.pl 
Log Message:
perl script to dump tests from gtcs.gdb (needs IBperl)


***** Error reading new file: (2, 'No such file or directory')

[Firebird-checkins] CVS: interbase/firebird/fsg/TCS - New directory

[Frank Schlottmann-G. <fs...@us...>]

Update of /cvsroot/firebird/interbase/firebird/fsg/TCS
In directory slayer.i.sourceforge.net:/tmp/cvs-serv21290/fsg/TCS

Log Message:
Directory /cvsroot/firebird/interbase/firebird/fsg/TCS added to the repository

[Firebird-checkins] CVS: interbase/firebird/fsg - New directory

[Frank Schlottmann-G. <fs...@us...>]

Update of /cvsroot/firebird/interbase/firebird/fsg
In directory slayer.i.sourceforge.net:/tmp/cvs-serv21090/fsg

Log Message:
Directory /cvsroot/firebird/interbase/firebird/fsg added to the repository

[Firebird-checkins] CVS: interbase/jrd common.h,1.5,1.6

[Patrick J. P. G. <pat...@us...>]

Update of /cvsroot/firebird/interbase/jrd
In directory slayer.i.sourceforge.net:/tmp/cvs-serv15595/jrd

Modified Files:
	common.h 
Log Message:
Eliminate the following interbase.log error message in the AIX and AIX PPC builds:

'Pipe Server read pipe error 82'

In AIX /usr/include/errno.h:

/* ERESTART is used to determine if the system call is restartable */
#define ERESTART        82      /* restart the system call */

This same change may also apply to LINUX and the other builds that
define SIGACTION_SUPPORTED.

...pat…pat


Index: common.h
===================================================================
RCS file: /cvsroot/firebird/interbase/jrd/common.h,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** common.h	2000/10/12 02:52:17	1.5
--- common.h	2000/11/06 02:48:54	1.6
***************
*** 566,569 ****
--- 566,570 ----
  #define MOVE_FASTER(from,to,length)     memcpy (to, from, (int) (length))
  #define MOVE_CLEAR(to,length)           memset (to, 0, (int) (length))
+ #define SYSCALL_INTERRUPTED(err)        (((err) == EINTR) || ((err) == ERESTART)) /* pjpg 20001102 */
  #define INTL
  #define VOLATILE	volatile
***************
*** 587,590 ****
--- 588,592 ----
  #define MOVE_FASTER(from,to,length)     memcpy (to, from, (int) (length))
  #define MOVE_CLEAR(to,length)           memset (to, 0, (int) (length))
+ #define SYSCALL_INTERRUPTED(err)        (((err) == EINTR) || ((err) == ERESTART)) /* pjpg 20001102 */
  #define INTL
  #define VOLATILE	volatile

[Firebird-checkins] CVS: interbase/firebird/patrickgriffin/tcs_tests bug_112177_12,1.1,1.2

[Patrick J. P. G. <pat...@us...>]

Update of /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests
In directory slayer.i.sourceforge.net:/tmp/cvs-serv10780/firebird/patrickgriffin/tcs_tests

Modified Files:
	bug_112177_12 
Log Message:
Correct header in bug_112177_12.

...pat


Index: bug_112177_12
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests/bug_112177_12,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** bug_112177_12	2000/11/06 02:25:46	1.1
--- bug_112177_12	2000/11/06 02:37:54	1.2
***************
*** 1,4 ****
  /*
! **  Name:		bug_112177_11
  **  Series:		bugs
  **  Meta-Series:
--- 1,4 ----
  /*
! **  Name:		bug_112177_12
  **  Series:		bugs
  **  Meta-Series:

[Firebird-checkins] CVS: interbase/firebird/patrickgriffin/tcs_tests bug_112177_05,NONE,1.1 bug_112177_06,NONE,1.1 bug_112177_07,NONE,1.1 bug_112177_08,NONE,1.1 bug_112177_09,NONE,1.1 bug_112177_10,NONE,1.1 bug_112177_11,NONE,1.1 bug_112177_12,NONE,1.1 bug_112177_01,1.1,1.2 bug_112177_02,1.1,1.2 bug_112177_03,1.1,1.2 bug_112177_04,1.1,1.2

[Patrick J. P. G. <pat...@us...>]

Update of /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests
In directory slayer.i.sourceforge.net:/tmp/cvs-serv3780/firebird/patrickgriffin/tcs_tests

Modified Files:
	bug_112177_01 bug_112177_02 bug_112177_03 bug_112177_04 
Added Files:
	bug_112177_05 bug_112177_06 bug_112177_07 bug_112177_08 
	bug_112177_09 bug_112177_10 bug_112177_11 bug_112177_12 
Log Message:
Additional tests useful in exercising the different aspects
of the 112177, GBAK fails with non-english defaults, change proposal.

..pat



--- NEW FILE ---
/*
**  Name:		bug_112177_05
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test where SET NAMES specifies a different
**                      character set from the default literal.
**
**  Expected result:	GBAK shouldn't abort.
**			Final select * should only include 2nd RÇlph (from win1251 set.)
**
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
set names win1252;
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s char(30) character set WIN1251
   default _WIN1251 'RÇbert'
   not null
   collate PXW_CYRL,
i smallint default '1234' not null
); 

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_06
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test where SET NAMES specifies a different
**                      character set and no collate has been specified.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
set names win1252;
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s char(30) character set WIN1251
   default _WIN1251 'RÇbert'
   not null,
i smallint default '1234' not null
); 

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_07
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test where no SET NAMES.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s char(30) character set WIN1251
   default _WIN1251 'RÇbert'
   not null
   collate PXW_CYRL,
i smallint default '1234' not null
); 

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_08
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test where no SET NAMES, and no collate.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s char(30) character set WIN1251
   default _WIN1251 'RÇbert'
   not null,
i smallint default '1234' not null
); 

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_09
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test Alter table command.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s char(30) character set WIN1251
   default _WIN1251 'RÇbert'
   not null,
i smallint default '1234' not null
); 

alter table bug_bugbase
  add t char(30) default _win1251 'Ç New Column';

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_10
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test default from domain.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create domain abc
    char(30)
    default _WIN1251 'Ç Domain Default'
    not null;

create table bug_bugbase ( 
   s  abc,
   i smallint default '1234' not null
); 

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_11
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test Alter domain command.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create domain abc
    char(30)
    default _WIN1251 'Ç Domain Default'
    not null;

create table bug_bugbase ( 
   s  abc,
   i smallint default '1234' not null
); 

alter domain abc
    set default _WIN1251 'Ç New Domain Default';

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_11
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test processing of string introducer for DDL
**			statement.
**
**  Expected result:	ISQL should reject the invalid character set.
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create domain abc
    char(30)
    default _POKEMON 'Ç Domain Default'
    not null;

create table bug_bugbase ( 
   s  char(30) default _POKEMON 'Electric Rat' not null,
   i smallint default '1234' not null
); 

exit;

$ ISQL -e -m -input cf_test.sql
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql

Index: bug_112177_01
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests/bug_112177_01,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** bug_112177_01	2000/11/02 07:12:46	1.1
--- bug_112177_01	2000/11/06 02:25:46	1.2
***************
*** 4,9 ****
  **  Meta-Series:
  **  Dependencies:	None
! **  Description:	Backup and restore a database with a default
! **                      field containing non-english characters.
  **
  **  Expected result:	GBAK shouldn't abort.
--- 4,9 ----
  **  Meta-Series:
  **  Dependencies:	None
! **  Description:	Load a non-english default value and
! **                      do a gbak backup and restore.
  **
  **  Expected result:	GBAK shouldn't abort.
***************
*** 32,37 ****
  $ ISQL -m -input cf_test.sql
  $ GBAK -b WHERE_GDB:cf.gdb cf.gbak
! $ RUN drop_gdb WHERE_GDB:cf.gdb
  $ GBAK -r cf.gbak WHERE_GDB:cf.gdb
! $ RUN drop_gdb WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf.gbak
--- 32,37 ----
  $ ISQL -m -input cf_test.sql
  $ GBAK -b WHERE_GDB:cf.gdb cf.gbak
! $ DROP WHERE_GDB:cf.gdb
  $ GBAK -r cf.gbak WHERE_GDB:cf.gdb
! $ DROP WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf.gbak

Index: bug_112177_02
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests/bug_112177_02,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** bug_112177_02	2000/11/02 07:12:46	1.1
--- bug_112177_02	2000/11/06 02:25:46	1.2
***************
*** 51,54 ****
  $ ISQL -m -input cf_test3.sql
  $ ISQL -m -input cf_test2.sql
! $ RUN drop_gdb WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql
--- 51,54 ----
  $ ISQL -m -input cf_test3.sql
  $ ISQL -m -input cf_test2.sql
! $ DROP WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql

Index: bug_112177_03
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests/bug_112177_03,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** bug_112177_03	2000/11/02 07:12:46	1.1
--- bug_112177_03	2000/11/06 02:25:46	1.2
***************
*** 58,61 ****
  $ ISQL -m -input cf_test2.sql
  $ ISQL -m -input cf_test3.sql
! $ RUN drop_gdb WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql
--- 58,61 ----
  $ ISQL -m -input cf_test2.sql
  $ ISQL -m -input cf_test3.sql
! $ DROP WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql

Index: bug_112177_04
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests/bug_112177_04,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** bug_112177_04	2000/11/02 07:12:46	1.1
--- bug_112177_04	2000/11/06 02:25:46	1.2
***************
*** 57,60 ****
  $ ISQL -m -input cf_test2.sql
  $ ISQL -m -input cf_test3.sql
! $ RUN drop_gdb WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql
--- 57,60 ----
  $ ISQL -m -input cf_test2.sql
  $ ISQL -m -input cf_test3.sql
! $ DROP WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql

[Firebird-checkins] CVS: interbase/firebird/patrickgriffin/tcs_tests bug_112177_01,NONE,1.1 bug_112177_02,NONE,1.1 bug_112177_03,NONE,1.1 bug_112177_04,NONE,1.1 bug_116579_01,NONE,1.1

[Patrick J. P. G. <pat...@us...>]

Update of /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests
In directory slayer.i.sourceforge.net:/tmp/cvs-serv20368/firebird/patrickgriffin/tcs_tests

Added Files:
	bug_112177_01 bug_112177_02 bug_112177_03 bug_112177_04 
	bug_116579_01 
Log Message:
Test scripts, in TCS format.

Usefull in testing for:

bug 112177 error with non-english column defaults
bug 116579 generators in computed by columns will return wrong results

...pat


--- NEW FILE ---
/*
**  Name:		bug_112177_01
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Backup and restore a database with a default
**                      field containing non-english characters.
**
**  Expected result:	GBAK shouldn't abort.
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
set names win1251;
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s varchar(20) character set win1251 default 'RôbértNélsôn' not null collate win1251,
i smallint default '1234' not null
); 

insert into bug_bugbase (s) values('BruceNélsôn');
insert into bug_bugbase (s) values('narf');
insert into bug_bugbase (i) values(4321);

exit;

$ ISQL -m -input cf_test.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ RUN drop_gdb WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ RUN drop_gdb WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak

--- NEW FILE ---
/*
**  Name:		bug_112177_02
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Invoke default values that include non-english
**                      characters
**
**  Expected result:	ISQL shouldn't abort and second "select * ..."
**                      should show six rows, not three.
**                      The three additional rows should show the default
**                      value from the table definition.
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
set names win1251;
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s varchar(20) character set win1251 default 'RôbértNélsôn' not null collate win1251,
i smallint default '1234' not null
); 

insert into bug_bugbase (s) values('BruceNélsôn');
insert into bug_bugbase (s) values('narf');
insert into bug_bugbase (i) values(4321);

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";
select * from bug_bugbase;
exit;

$ CREATE cf_test3.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (i) values(1);
insert into bug_bugbase (i) values(2);
insert into bug_bugbase (i) values(3);

exit;

$ ISQL -m -input cf_test.sql
$ ISQL -m -input cf_test2.sql
$ ISQL -m -input cf_test3.sql
$ ISQL -m -input cf_test2.sql
$ RUN drop_gdb WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf_test2.sql cf_test3.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_03
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Create a stored procedure that uses a national character set,
**                      and then use it for the first time in an ISQL session
**                      using the NONE character set.
**
**  Expected result:	"select * ..." should report 4327.00
**			
**  Author:		Patrick J. P. Griffin 
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
set names win1251;
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s varchar(20) character set win1251 default 'RôbértNélsôn' not null collate win1251,
i smallint default '1234' not null
); 

insert into bug_bugbase (s) values('BruceNélsôn');
insert into bug_bugbase (s) values('narf');
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (i) values(1);
insert into bug_bugbase (i) values(2);
insert into bug_bugbase (i) values(3);

exit;

$ CREATE cf_test2.sql
set names win1251;
connect 'WHERE_GDB:cf.gdb';
set term !! ;
create procedure fetch_some_rows returns ( tot_i DECIMAL(12,2))
  as
  begin
    select sum(I) 
    from bug_bugbase
    where s = 'RôbértNélsôn'
    into :tot_i;
    suspend;
  end !!
set term ; !!
exit;

$ CREATE cf_test3.sql
connect "WHERE_GDB:cf.gdb";
select * from fetch_some_rows;
exit;

$ ISQL -m -input cf_test.sql
$ ISQL -m -input cf_test2.sql
$ ISQL -m -input cf_test3.sql
$ RUN drop_gdb WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf_test2.sql cf_test3.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_04
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Create a stored procedure that uses a national character set,
**                      and then use it in an ISQL session using the NONE
**                      character set.
**
**  Expected result:	"select * ..." should reflect that all names have been
**                      changed to 'RôbértNélsôn'
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
set names win1251;
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s varchar(20) character set win1251 default 'RôbértNélsôn' not null collate win1251,
i smallint default '1234' not null
); 

insert into bug_bugbase (s) values('BruceNélsôn');
insert into bug_bugbase (s) values('narf');
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (i) values(1);
insert into bug_bugbase (i) values(2);
insert into bug_bugbase (i) values(3);

set term !! ;
create procedure alter_some_rows (i_value smallint)
  as
  begin
    update bug_bugbase
    set s = 'RôbértNélsôn'
    where i = :i_value;
  end !!
set term ; !!
exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";
execute procedure alter_some_rows 1234;
exit;

$ CREATE cf_test3.sql
connect "WHERE_GDB:cf.gdb";
select * from bug_bugbase;
exit;

$ ISQL -m -input cf_test.sql
$ ISQL -m -input cf_test2.sql
$ ISQL -m -input cf_test3.sql
$ RUN drop_gdb WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf_test2.sql cf_test3.sql

--- NEW FILE ---
/*
**  Name:		genid_arguments_01
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	This test is a test for the proper handling of gen_id and
**                      it's arguments
**			
**			This test calls gen_id a computed field as an argument of the
**			built-in function GEN_ID.
**
**  Expected result:	See comments below
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		116579 generators in computed by columns will return wrong results
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create generator gen1;
set generator gen1 to 999;
show generator gen1;

create generator gen2;
set generator gen2 to 199;
show generator gen2;

create generator gen3;
set generator gen3 to 29;
show generator gen3;

create table t0 (
	a integer, 
	genid_field1 computed by (gen_id(gen1, 1)),
	genid_field2 computed by (gen_id(gen2, genid_field1)),
	genid_field3 computed by (gen_id(gen3, genid_field2))
);

show table t0;
insert into t0(a) values(4);
insert into t0(a) values(1);

/* first row:
   a:  4
   genid_field3:=genid3+(genid2+(genid1+1))
               :=29+(199+(999+1)
               :=29+(199+1000)
               :=29+1199
               :=1228
   second row:
   a: 1
   genid_field3:=genid3+(genid2+(genid1+1))
               :=1228+(1199+(1000+1)
               :=1228+(1199+1001)
               :=1228+(2200)
               :=3428
*/
select a,genid_field3 from t0;

/* first row:
   a:  4
   genid_field3:=genid3+(genid2+(genid1+1))
               :=3428+(2200+(1001+1)
               :=3428+(2200+1002)
               :=3429+3202
               :=6630
   genid_field2:=genid2+(genid1+1)
               :=3202+(1002+1)
               :=3202+1003
               :=4205
   genid_field1:=genid1+1
               :=1003+1
               :=1004

   second row:
   a:  1
   genid_field3:=genid3+(genid2+(genid1+1))
               :=6630+(4205+(1004+1))
               :=6630+(4205+1005)
               :=6630+5210
               :=11840
   genid_field2:=genid2+(genid1+1)
               :=5210+(1005+1)
               :=5210+1006
               :=6216
   genid_field1:=genid1+1
               :=1006+1
               :=1007
*/

select * from t0;

exit;

$ ISQL -e -m -input cf_test.sql
$ DELETE cf_test.sql
$ RUN drop_gdb WHERE_GDB:cf.gdb

[Firebird-checkins] CVS: interbase/firebird/patrickgriffin/tcs_tests - New directory

[Patrick J. P. G. <pat...@us...>]

Update of /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests
In directory slayer.i.sourceforge.net:/tmp/cvs-serv19594/firebird/patrickgriffin/tcs_tests

Log Message:
Directory /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests added to the repository

[Firebird-checkins] CVS: interbase/firebird/patrickgriffin - New directory

[Patrick J. P. G. <pat...@us...>]

Update of /cvsroot/firebird/interbase/firebird/patrickgriffin
In directory slayer.i.sourceforge.net:/tmp/cvs-serv19477/firebird/patrickgriffin

Log Message:
Directory /cvsroot/firebird/interbase/firebird/patrickgriffin added to the repository

[Firebird-checkins] CVS: interbase/firebird/skywalker - New directory

[Mark O. <sky...@us...>]

Update of /cvsroot/firebird/interbase/firebird/skywalker
In directory slayer.i.sourceforge.net:/tmp/cvs-serv7754/skywalker

Log Message:
Directory /cvsroot/firebird/interbase/firebird/skywalker added to the repository

[Firebird-checkins] CVS: interbase/firebird/skywalker/install/super SSchangePasswd.sh,1.1,1.2 SSpostinstall.sh,1.1,1.2

[Mark O. <sky...@us...>]

Update of /cvsroot/firebird/interbase/firebird/skywalker/install/super
In directory slayer.i.sourceforge.net:/tmp/cvs-serv9340/super

Modified Files:
	SSchangePasswd.sh SSpostinstall.sh 
Log Message:
Small script for autoupdating SYSDBA password in /etc/rc.d/init.d/firebird


Index: SSchangePasswd.sh
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/skywalker/install/super/SSchangePasswd.sh,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** SSchangePasswd.sh	2000/10/22 10:32:05	1.1
--- SSchangePasswd.sh	2000/10/22 10:47:51	1.2
***************
*** 31,35 ****
        then
          ed $InitFile <<EOF
! /ISC_PASSWORD/s/ISC_PASSWORD:=.*\}/ISC_PASSWORD=$NewPasswd\}/g
  w
  q
--- 31,35 ----
        then
          ed $InitFile <<EOF
! /ISC_PASSWORD/s/ISC_PASSWORD:=.*\}/ISC_PASSWORD:=$NewPasswd\}/g
  w
  q

Index: SSpostinstall.sh
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/skywalker/install/super/SSpostinstall.sh,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** SSpostinstall.sh	2000/10/22 10:32:05	1.1
--- SSpostinstall.sh	2000/10/22 10:47:51	1.2
***************
*** 82,86 ****
        then
          ed $InitFile <<EOF
! /ISC_PASSWORD/s/ISC_PASSWORD:=.*\}/ISC_PASSWORD=$NewPasswd\}/g
  w
  q
--- 82,86 ----
        then
          ed $InitFile <<EOF
! /ISC_PASSWORD/s/ISC_PASSWORD:=.*\}/ISC_PASSWORD:=$NewPasswd\}/g
  w
  q

[Firebird-checkins] CVS: interbase/firebird/skywalker/install SSrpmscript,1.1,1.2

[Mark O. <sky...@us...>]

Update of /cvsroot/firebird/interbase/firebird/skywalker/install
In directory slayer.i.sourceforge.net:/tmp/cvs-serv9340

Modified Files:
	SSrpmscript 
Log Message:
Small script for autoupdating SYSDBA password in /etc/rc.d/init.d/firebird


Index: SSrpmscript
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/skywalker/install/SSrpmscript,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** SSrpmscript	2000/10/22 10:32:05	1.1
--- SSrpmscript	2000/10/22 10:47:51	1.2
***************
*** 388,392 ****
        then
          ed $InitFile <<EOF
! /ISC_PASSWORD/s/ISC_PASSWORD:=.*\}/ISC_PASSWORD=$NewPasswd\}/g
  w
  q
--- 388,392 ----
        then
          ed $InitFile <<EOF
! /ISC_PASSWORD/s/ISC_PASSWORD:=.*\}/ISC_PASSWORD:=$NewPasswd\}/g
  w
  q

[Firebird-checkins] CVS: interbase/firebird/skywalker/install/classic CSTarInstall.sh,NONE,1.1 CSTarKullFiles.sh,NONE,1.1 CSinstall.sh,NONE,1.1 CSpostinstall.sh,NONE,1.1 CSpostuninstall.sh,NONE,1.1 CSpreinstall.sh,NONE,1.1 CSpreuninstall.sh,NONE,1.1 CSrpmfiles.txt,NONE,1.1 CSrpmheader.txt,NONE,1.1

[Mark O. <sky...@us...>]

Update of /cvsroot/firebird/interbase/firebird/skywalker/install/classic
In directory slayer.i.sourceforge.net:/tmp/cvs-serv8525/classic

Added Files:
	CSTarInstall.sh CSTarKullFiles.sh CSinstall.sh 
	CSpostinstall.sh CSpostuninstall.sh CSpreinstall.sh 
	CSpreuninstall.sh CSrpmfiles.txt CSrpmheader.txt 
Log Message:
New files related to the firebird install for linux/unix


--- NEW FILE ---


#------------------------------------------------------------------------
# Prompt for response, store result in Answer

Answer=""

AskQuestion() {
    Test=$1
    DefaultAns=$2
    echo -n "${1}"
    Answer="$DefaultAns"
    read Answer
}

#------------------------------------------------------------------------
# Prompt for yes or no answer - returns non-zero for no

AskYNQuestion() {
    while echo -n "${*} (y/n): "
    do
        read answer rest
        case $answer in
        [yY]*)
            return 0
            ;;
        [nN]*)
            return 1
            ;;
        *)
            echo "Please answer y or n"
            ;;
        esac
    done
}


#------------------------------------------------------------------------
# Run process and check status


runAndCheckExit() {
    Cmd=$*

#    echo $Cmd
    $Cmd

    ExitCode=$?

    if [ $ExitCode -ne 0 ]
      then
        echo "Install aborted: The command $Cmd "
        echo "                 failed with error code $ExitCode"
        exit
    fi
}

#------------------------------------------------------------------------
# Check for a previous install 


checkInstallUser() {

    if [ "`whoami`" != "root" ];
      then
        ehco ""
        echo "--- Warning ----------------------------------------------"
        echo ""
        echo "    You need to be 'root' user to install"
        echo ""
        exit
    fi
}



#== Main Program ==========================================================


InteractiveInstall=1
export InteractiveInstall


checkInstallUser

# Ok, here we are installing from a CVS tree

if [ -e firebird ]
  then
    ScriptsSrcDir=./firebird/skywalker/install

    ( $ScriptsSrcDir/super/CSpreinstall.sh )

    cp $ScriptsSrcDir/misc/README interbase

    ($ScriptsSrcDir/super/CSinstall.sh)

    ($ScriptsSrcDir/super/CSpreinstall.sh)
fi

# Here we are installing from a install tar.gz file

if [ -e scripts ]
  then
    echo "Extracting install data"
    runAndCheckExit "tar -xzf interbase.tar.gz"

    (./scripts/CSpreinstall.sh)
    (./scripts/CSinstall.sh)
    (./scripts/CSpostinstall.sh)

    rm -rf interbase
fi

echo "Install completed"


--- NEW FILE ---
#!/bin/sh

IBRootDir=`pwd`/interbase
IBBin=$IBRootDir/bin
RunUser=root


chown -R $RunUser.$RunUser $IBRootDir

cd $IBBin

for i in gds_lock_mgr gds_drop gds_inet_server
  do
    chmod ug+s $i
  done



cd $IBRootDir

rm -f isc_init1*
rm -f isc_lock1*

chmod ugo=rw isc4.gdb

rm -f inetd.conf.isc install


--- NEW FILE ---
#!/bin/sh

# Script to install files from the build/transport area

#    cd InterBase


# A little bit of tidying up of some odd files not in the original build
# These files will exist in the CVS tree.  
# If this is a tar.gz install rather than the result of a build then
# We assume the files have already been copied here manually.


    if [ -z "$InteractiveInstall" ] 
      then
        ScriptsSrcDir=firebird/skywalker/install
        cp $ScriptsSrcDir/misc/README interbase/
    fi

# The guts of the tranfer of files to /opt and other directories

    if [ -d /opt/interbase ] 
      then 
        rm -rf /opt/interbase 
    fi 
    mkdir /opt/interbase 
    mkdir /opt/interbase/bin 
    mkdir /opt/interbase/examples 
    mkdir /opt/interbase/help 
    mkdir /opt/interbase/include 
    mkdir /opt/interbase/intl 
    mkdir /opt/interbase/lib 
    mkdir /opt/interbase/doc 
    mkdir /opt/interbase/UDF 


    cp -f interbase/bin/gds_inet_server /opt/interbase/bin/gds_inet_server 

    cp interbase/bin/gbak /opt/interbase/bin/gbak 
    cp interbase/bin/gdef /opt/interbase/bin/gdef 
    cp interbase/bin/gds_lock_print /opt/interbase/bin/gds_lock_print 
    cp interbase/bin/gds_drop /opt/interbase/bin/gds_drop 
    cp interbase/bin/gds_lock_mgr /opt/interbase/bin/gds_lock_mgr 
    cp interbase/bin/gds_pipe /opt/interbase/bin/gds_pipe 
    cp interbase/bin/gfix /opt/interbase/bin/gfix 
    cp interbase/bin/gpre /opt/interbase/bin/gpre 
    cp interbase/bin/gsec /opt/interbase/bin/gsec 
    cp interbase/bin/gsplit /opt/interbase/bin/gsplit 
    cp interbase/bin/gstat /opt/interbase/bin/gstat 
    cp interbase/bin/isc4.gbak /opt/interbase/bin/isc4.gbak 
    cp interbase/bin/isql /opt/interbase/bin/isql 
    cp interbase/bin/qli /opt/interbase/bin/qli 
    cp interbase/examples/v5/*.[ceh] /opt/interbase/examples 
    cp interbase/examples/v5/*.sql /opt/interbase/examples 
    cp interbase/examples/v5/*.gbk /opt/interbase/examples 
    cp interbase/examples/v5/*.gdb /opt/interbase/examples 
    cp interbase/examples/v5/makefile /opt/interbase/examples 
    cp interbase/help/help.gbak /opt/interbase/help 
    cp interbase/help/help.gdb /opt/interbase/help 
    #cp -r interbase/doc /opt/interbase 
    cp interbase/interbase.msg /opt/interbase/interbase.msg 
    cp interbase/isc4.gdb /opt/interbase/isc4.gdb 
    cp interbase/isc_config /opt/interbase/isc_config

    cp -f interbase/include/gds.h /usr/include/gds.h 
    cp -f interbase/include/iberror.h /usr/include/iberror.h 
    cp -f interbase/include/ibase.h /usr/include/ibase.h 
    cp -f interbase/include/ib_util.h /usr/include/ib_util.h 

    cp interbase/include/gds.f /opt/interbase/include 
    cp interbase/include/gds.hxx /opt/interbase/include 
    cp interbase/include/*.h /opt/interbase/include 

    cp -f interbase/lib/gds.so /usr/lib/libgds.so.0 
    if [ -L /usr/lib/libgds.so ]
      then
        rm -f /usr/lib/libgds.so
    fi
    ln -s libgds.so.0 /usr/lib/libgds.so

    cp -f interbase/lib/gds.a /usr/lib/libgds.a 
    cp -f interbase/lib/ib_util /usr/lib/libib_util.so 
    cp -f interbase/lib/gds_pyxis.a /usr/lib/libgds_pyxis.a 

    cp interbase/intl/gdsintl /opt/interbase/intl/gdsintl 
    cp interbase/UDF/ib_udf /opt/interbase/UDF/ib_udf 

    cp interbase/services.isc /opt/interbase/services.isc
    cp interbase/README /opt/interbase/README

    # June 23 2000, 6:00AM 
    #TIMESTAMP="200006230600.00" 
    #cd /opt/interbase/ 
    #touch -t $TIMESTAMP `find . -print` 


--- NEW FILE ---
#!/bin/sh

# The post install script for Firebird Classic


#------------------------------------------------------------------------
# Prompt for response, store result in Answer

Answer=""

AskQuestion() {
    Test=$1
    DefaultAns=$2
    echo -n "${1}"
    Answer="$DefaultAns"
    read Answer
}


#------------------------------------------------------------------------
# add a service line in the (usually) /etc/services or /etc/inetd.conf file
# Here there are three cases, not found         => add service line,
#                             found & different => ask user to check
#                             found & same      => do nothing
#                             

replaceLineInFile() {
    FileName=$1
    newLine=$2
    oldLine=$3

    if [ -z "$oldLine" ] 
      then
        echo "$newLine" >> $FileName

    elif [ "$oldLine" != "$newLine"  ]
      then
        echo ""
        echo "--- Warning ----------------------------------------------"
        echo ""
        echo "    In file $FileName found line: "
        echo "    $oldLine"
        echo "    Which differs from the expected line:"
        echo "    $newLine"
        echo ""

#        AskQuestion "Press return to update file or ^C to abort install"

        cat $FileName | grep -v "$oldLine" > ${FileName}.tmp
        mv ${FileName}.tmp $FileName
        echo "$newLine" >> $FileName
        echo "Updated."

    fi
}


#------------------------------------------------------------------------
#  Generate new sysdba password - this routine is used only in the 
#  rpm file not in the install acript.


generateNewDBAPassword() {

    DBAPasswordFile=$IBRootDir/SYSDBA.password
    NewPasswd=`mkpasswd -l 8`
    echo "Firebird generated password " > $DBAPasswordFile
    echo "for user SYSDBA is : $NewPasswd" >> $DBAPasswordFile
    echo "generated on `hostname` at time `date`" >> $DBAPasswordFile
    echo "(For superserver you will also want to check the password in the" >> $DBAPasswordFile
    echo "daemon init routine in the file /etc/rc.d/init.d/firebird)" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo "Your password can be changed to a more suitable one using the" >> $DBAPasswordFile
    echo "/opt/interbase/bin/gsec program as show below:" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo ">cd /opt/interbase" >> $DBAPasswordFile
    echo ">bin/gsec -user sysdba -password <password>" >> $DBAPasswordFile
    echo "GSEC>modify sysdba -pw <newpassword>" >> $DBAPasswordFile
    echo "GSEC>quit" >> $DBAPasswordFile
    chmod u=r,go= $DBAPasswordFile

    $IBBin/gsec -user sysdba -password masterkey <<EOF
modify sysdba -pw $NewPasswd
EOF

}

#------------------------------------------------------------------------
#  Change sysdba password - this routine is interactive and is only 
#  used in the install shell script not the rpm one.


askUserForNewDBAPassword() {

    NewPasswd=""

    while [ -z "$NewPasswd" ]
      do
# If using a generated password
#         DBAPasswordFile=$IBRootDir/SYSDBA.password
#         NewPasswd=`mkpasswd -l 8`
#         echo "Password for SYSDBA on `hostname` is : $NewPasswd" > $DBAPasswordFile
#         chmod ga-rwx $DBAPasswordFile

          AskQuestion "Please enter new password for SYSDBA user: "
          NewPasswd=$Answer
          if [ ! -z "$NewPasswd" ]
            then
             $IBBin/gsec -user sysdba -password masterkey <<EOF
modify sysdba -pw $NewPasswd
EOF
              echo ""
          fi
          
      done
}


#------------------------------------------------------------------------
#  Change sysdba password - this routine is interactive and is only 
#  used in the install shell script not the rpm one.


changeDBAPassword() {

    if [ -z "$InteractiveInstall" ]
      then
        generateNewDBAPassword
      else
        askUserForNewDBAPassword
    fi
}


#= Main Post ===============================================================

    # Make sure the links are in place 
    if [ ! -L /opt/interbase -a ! -d /opt/interbase ] 
      then 
    # Main link and... 
        ln -s $RPM_INSTALL_PREFIX/interbase /opt/interbase 
    fi 


    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin
    RunUser=root


    # Update /etc/services


    FileName=/etc/services
    newLine="gds_db          3050/tcp  # InterBase Database Remote Protocol"
    oldLine=`grep "^gds_db" $FileName`

    replaceLineInFile "$FileName" "$newLine" "$oldLine"



    # Update the /etc/inetd.conf


    FileName=/etc/inetd.conf
    newLine="gds_db  stream  tcp     nowait.30000      $RunUser $IBBin/gds_inet_server gds_inet_server # InterBase Database Remote Server"
    oldLine=`grep "^gds_db" $FileName`

    replaceLineInFile "$FileName" "$newLine" "$oldLine"


    # Update ownership and SUID bits for programs.

    chown -R $RunUser.$RunUser $IBRootDir

    cd $IBBin

    for i in gds_lock_mgr gds_drop gds_inet_server
      do
        chmod ug+s $i
      done


    # Get inetd to reread new init files.

    if [ -f /var/run/inetd.pid ]
      then
        kill -HUP `cat /var/run/inetd.pid`
    fi




    # Lock files
    # remember isc_guard1 in addition for super

    cd $IBRootDir

    for i in isc_init1 isc_lock1 isc_event1 
      do
        FileName=$i.`hostname`
        touch $FileName
        chmod uga+rw $FileName
      done

    touch interbase.log
    chmod uga+rw interbase.log



    # Change sysdba password

    changeDBAPassword




--- NEW FILE ---
#!/bin/sh

# The post uninstall routine for Firebird Classic.


#------------------------------------------------------------------------
# remove line from config file if it exists in it.

removeLineFromFile() {
    FileName=$1
    oldLine=$2

    if [ ! -z "$oldLine" ] 
      then
        cat $FileName | grep -v "$oldLine" > ${FileName}.tmp
        mv ${FileName}.tmp $FileName
        echo "Updated."

    fi
}


#= Main PostUn ============================================================

    if [ -L /usr/lib/libgds.so ] 
      then 
        rm /usr/lib/libgds.so 
    fi 

    if [ "$1"=0 ] 
      then 

        # Lose the gds_db line from /etc/services 

        FileName=/etc/services
        oldLine=`grep "^gds_db" $FileName`
        removeLineFromFile "$FileName" "$oldLine"

        # Next, lose the gds_db line from /etc/inetd.conf

        FileName=/etc/inetd.conf
        oldLine=`grep "^gds_db" $FileName`
        removeLineFromFile "$FileName" "$oldLine"

        # Get inetd to reread new inetd.conf file

        if [ -f /var/run/inetd.pid ]
          then
            kill -HUP `cat /var/run/inetd.pid`
        fi
    fi

--- NEW FILE ---
#!/bin/sh


# The pre install routine for Firebird Classic


#------------------------------------------------------------------------
# Prompt for response, store result in Answer

Answer=""

AskQuestion() {
    Test=$1
    DefaultAns=$2
    echo -n "${1}"
    Answer="$DefaultAns"
    read Answer
}


#------------------------------------------------------------------------
#  stop super server if it is running 
#  Also will only stop firebird, since that has the init script


stopServerIfRunning() {

    checkString=`ps -efww| egrep "(ibserver|ibguard)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        if [ -f /etc/rc.d/init.d/firebird ]
          then
            /etc/rc.d/init.d/firebird stop
        fi
    fi
}

#------------------------------------------------------------------------
#  stop server if it is running


checkIfServerRunning() {


    stopServerIfRunning

# Check is server is being actively used.

    checkString=`ps -efww| egrep "(ibserver|ibguard)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        echo "An instance of the Firebird/InterBase Super server seems to be running." 
        echo "Please quit all interbase applications and then proceed"
        exit 1 
    fi

    checkString=`ps -efww| egrep "(gds_inet_server|gds_pipe)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        echo "An instance of the Firebird/InterBase server seems to be running." 
        echo "Please quit all interbase applications and then proceed." 
        exit 1 
    fi



# Stop lock manager if it is the only thing running.

    for i in `ps -efww | grep "gds_lock_mgr" | grep -v "grep" | awk '{print $2}' `
     do
        kill $i
     done


}

#------------------------------------------------------------------------
# Run process and check status


runAndCheckExit() {
    Cmd=$*

#    echo $Cmd
    $Cmd

    ExitCode=$?

    if [ $ExitCode -ne 0 ]
      then
        echo "Install aborted: The command $Cmd "
        echo "                 failed with error code $ExitCode"
        exit $ExitCode
    fi
}


#------------------------------------------------------------------------
#  Display message if this is being run interactively.


displayMessage() {

    msgText=$1
    if [ ! -z "$InteractiveInstall" ]
      then
        echo $msgText
    fi
}


#------------------------------------------------------------------------
#  Archive any existing prior installed files.
#  The 'cd' stuff is to avoid the "leading '/' removed message from tar.
#  for the same reason the DestFile is specified without the leading "/"


archivePriorInstallSystemFiles() {

    oldPWD=`pwd`
    archiveFileList=""

    cd /


    DestFile="opt/interbase"
    if [ -e "$DestFile"  ]
      then
        echo ""
        echo ""
        echo ""
        echo "--- Warning ----------------------------------------------"
        echo "    The installation target directory: $IBRootDir"
        echo "    Already contains a prior installation of InterBase/Firebird."
        echo "    This and files found in /usr/include and /usr/lib will be"
        echo "    archived in the file : ${ArchiveMainFile}"
        echo "" 

        if [ ! -z "$InteractiveInstall" ]
          then
            AskQuestion "Press return to continue or ^C to abort"
        fi

        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
    fi


    for i in gds.h ibase.h iberror.h ib_util.h
      do
        DestFile=usr/include/$i
        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
      done

    for i in gds_pyxis.a gds.a libgds.so.0 libgds.so ib_util.so
      do
        DestFile=usr/lib/$i
        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
      done

      if [ ! -z "$archiveFileList" ]
        then

          displayMessage "Archiving..."

          runAndCheckExit "tar -czf $ArchiveMainFile $archiveFileList"


          displayMessage "Done."
          displayMessage "Deleting..."

          for i in $archiveFileList
            do
              rm -rf $i
            done

          displayMessage "Done."

      fi
    cd $oldPWD

}


#------------------------------------------------------------------------
#  Check for installed RPM package

checkForRPMInstall() {
    PackageName=$1

    rpm -q $PackageName
    STATUS=$? 
    if [ $STATUS -eq 0 ]
      then 
        echo "Previous version of $PackageName is detected on your system." 
        echo "this will conflict with the current install of Firebird"
        echo "Please unistall the previous version `rpm -q $PackageName` and then proceed." 
        exit $STATUS 
    fi 

}



#= Main Pre ================================================================

    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin
    ArchiveDateTag=`date +"%Y%m%d_%H%M"`
    ArchiveMainFile="${IBRootDir}_${ArchiveDateTag}.tar.gz"



# Ok so any of the following packages are a problem
# these don't work at least in the latest rpm manager, since it 
# has the rpm database locked and it fails.

#    checkForRPMInstall InterBase
#    checkForRPMInstall FirebirdCS
#    checkForRPMInstall FirebirdSS


    checkIfServerRunning

# Failing that we archive any files we find

    archivePriorInstallSystemFiles



--- NEW FILE ---
#! /bin/sh

# The pre uninstall routines for Firebird Classic

#------------------------------------------------------------------------
#  stop server if it is running


checkIfServerRunning() {

# Check is server is being actively used.

    checkString=`ps -ef| egrep "(gds_inet_server|gds_pipe)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        echo "An instance of the Firebird/InterBase server seems to be running." 
        echo "Please quit all interbase applications and then proceed." 
        exit 1 
    fi



# Stop lock manager if it is the only thing running.

    for i in `ps -ef | grep "gds_lock_mgr" | grep -v "grep" | cut -d' ' -f3`
     do
        kill $i
     done

}


#= Main PreUn ================================================================
# This is a bit simple, but should work for now.  
# cron will remove files in /tmp after a while. 

    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin

    checkIfServerRunning

    cd $IBRootDir
    
    if [ -f isc4.gdb ] 
      then 
        cp isc4.gdb /tmp 
        echo "Saved a copy of isc4.gdb in /tmp" 
    fi 
    
    for i in isc_init1* isc_event1* isc_lock1* interbase.log SYSDBA.password
      do
        if [ -f $i ]
          then
            rm -f $i
        fi
      done

--- NEW FILE ---
%dir /opt/interbase 
%dir /opt/interbase/bin 
%dir /opt/interbase/lib 
%dir /opt/interbase/UDF 
%dir /opt/interbase/intl 
%dir /opt/interbase/help 

/opt/interbase/bin/gds_inet_server 
/opt/interbase/bin/gbak 
/opt/interbase/bin/gdef 
/opt/interbase/bin/gds_lock_print 
/opt/interbase/bin/gds_lock_mgr 
/opt/interbase/bin/gds_pipe 
/opt/interbase/bin/gds_drop 
/opt/interbase/bin/gfix 
/opt/interbase/bin/gpre 
/opt/interbase/bin/gsec 
/opt/interbase/bin/gsplit 
/opt/interbase/bin/gstat 
/opt/interbase/bin/isc4.gbak 
/opt/interbase/bin/isql 
/opt/interbase/bin/qli 

/opt/interbase/examples 

/opt/interbase/help/help.gbak 
%attr(666, -, -) /opt/interbase/help/help.gdb 

/opt/interbase/include 

/usr/include/gds.h 
/usr/include/iberror.h 
/usr/include/ibase.h 
/usr/include/ib_util.h

#/opt/interbase/doc 

/opt/interbase/README
/opt/interbase/interbase.msg 
%attr(666, -, -) /opt/interbase/isc4.gdb 
/opt/interbase/isc_config 

/usr/lib/libgds.so.0 
/usr/lib/libgds.so
/usr/lib/libib_util.so 
/usr/lib/libgds_pyxis.a 
/usr/lib/libgds.a 
/opt/interbase/intl/gdsintl 
/opt/interbase/UDF/ib_udf 
/opt/interbase/services.isc 







--- NEW FILE ---
Summary: Firebird Relational Database Server and Client tools.
Name: FirebirdCS 
Version: 0.9
Release: 1 
Copyright: Distributable 
Group: Applications/Databases 
Source: FirebirdCS0.9src.tar.gz 
URL: http://firebird.sourceforge.net 
Prefix: /opt 
AutoReqProv: no 
# BuildRoot: /var/tmp/%{name}-buildroot

%description
Firebird is a powerful, high-performance relational database designed to be embedded into
applications on multiple platforms.  

[Firebird-checkins] CVS: interbase/firebird/skywalker/install/super SSTarInstall.sh,NONE,1.1 SSchangePasswd.sh,NONE,1.1 SSinstall.sh,NONE,1.1 SSpostinstall.sh,NONE,1.1 SSpostuninstall.sh,NONE,1.1 SSpreinstall.sh,NONE,1.1 SSpreuninstall.sh,NONE,1.1 SSrpmfiles.txt,NONE,1.1 SSrpmheader.txt,NONE,1.1

[Mark O. <sky...@us...>]

Update of /cvsroot/firebird/interbase/firebird/skywalker/install/super
In directory slayer.i.sourceforge.net:/tmp/cvs-serv8525/super

Added Files:
	SSTarInstall.sh SSchangePasswd.sh SSinstall.sh 
	SSpostinstall.sh SSpostuninstall.sh SSpreinstall.sh 
	SSpreuninstall.sh SSrpmfiles.txt SSrpmheader.txt 
Log Message:
New files related to the firebird install for linux/unix


--- NEW FILE ---


#------------------------------------------------------------------------
# Prompt for response, store result in Answer

Answer=""

AskQuestion() {
    Test=$1
    DefaultAns=$2
    echo -n "${1}"
    Answer="$DefaultAns"
    read Answer
}

#------------------------------------------------------------------------
# Prompt for yes or no answer - returns non-zero for no

AskYNQuestion() {
    while echo -n "${*} (y/n): "
    do
        read answer rest
        case $answer in
        [yY]*)
            return 0
            ;;
        [nN]*)
            return 1
            ;;
        *)
            echo "Please answer y or n"
            ;;
        esac
    done
}


#------------------------------------------------------------------------
# Run process and check status


runAndCheckExit() {
    Cmd=$*

#    echo $Cmd
    $Cmd

    ExitCode=$?

    if [ $ExitCode -ne 0 ]
      then
        echo "Install aborted: The command $Cmd "
        echo "                 failed with error code $ExitCode"
        exit
    fi
}

#------------------------------------------------------------------------
# Check for a previous install 


checkInstallUser() {

    if [ "`whoami`" != "root" ];
      then
        ehco ""
        echo "--- Warning ----------------------------------------------"
        echo ""
        echo "    You need to be 'root' user to install"
        echo ""
        exit
    fi
}



#== Main Program ==========================================================


InteractiveInstall=1
export InteractiveInstall

checkInstallUser


# Ok, here we are installing from a CVS tree

if [ -e firebird ] 
  then
    ScriptsSrcDir=./firebird/skywalker/install

    ( $ScriptsSrcDir/super/SSpreinstall.sh )

    cp $ScriptsSrcDir/misc/firebird interbase
    cp $ScriptsSrcDir/misc/README interbase


    ($ScriptsSrcDir/super/SSinstall.sh)

    ($ScriptsSrcDir/super/SSpostinstall.sh)
fi


# Here we are installing from a install tar.gz file

if [ -e scripts ]
  then
    echo "Extracting install data"
    runAndCheckExit "tar -xzf interbase.tar.gz"

    (./scripts/SSpreinstall.sh)
    (./scripts/SSinstall.sh)
    (./scripts/SSpostinstall.sh)

    rm -rf interbase
fi

echo "Install completed"


--- NEW FILE ---
#! /bin/sh


# This shell script changes both the SYSDBA user and the firebird 
# install script.

#------------------------------------------------------------------------
# Prompt for response, store result in Answer

Answer=""

AskQuestion() {
    Test=$1
    DefaultAns=$2
    echo -n "${1}"
    Answer="$DefaultAns"
    read Answer
}


#------------------------------------------------------------------------
#  changeInitPassword


changeInitPassword() {

    NewPasswd=$1

    InitFile=/etc/rc.d/init.d/firebird
    if [ -f $InitFile ] 
      then
        ed $InitFile <<EOF
/ISC_PASSWORD/s/ISC_PASSWORD:=.*\}/ISC_PASSWORD=$NewPasswd\}/g
w
q
EOF
    chmod u=rwx,g=rx,o= $InitFile

    fi
}

#------------------------------------------------------------------------
#  Generate new sysdba password


generateNewDBAPassword() {

    DBAPasswordFile=$IBRootDir/SYSDBA.password
    NewPasswd=`mkpasswd -l 8`
    echo "Firebird generated password " > $DBAPasswordFile
    echo "for user SYSDBA is : $NewPasswd" >> $DBAPasswordFile
    echo "generated on `hostname` at time `date`" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo "(For superserver you will also want to check the password in the" >> $DBAPasswordFile
    echo "daemon init routine in the file /etc/rc.d/init.d/firebird)" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo "Your password can be changed to a more suitable one using the" >> $DBAPasswordFile
    echo "/opt/interbase/bin/gsec program as show below:" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo ">cd /opt/interbase" >> $DBAPasswordFile
    echo ">bin/gsec -user sysdba -password <password>" >> $DBAPasswordFile
    echo "GSEC>modify sysdba -pw <newpassword>" >> $DBAPasswordFile
    echo "GSEC>quit" >> $DBAPasswordFile

    chmod u=rw,go= $DBAPasswordFile

    $IBBin/gsec -user sysdba -password masterkey <<EOF
modify sysdba -pw $NewPasswd
EOF

    changeInitPassword "$NewPasswd"


}


#------------------------------------------------------------------------
#  Change sysdba password - this routine is interactive and is only 
#  used in the install shell script not the rpm one.


askUserForNewDBAPassword() {

    OrigPasswd=""
    while [ -z "$OrigPasswd" ]
      do
          AskQuestion "Please enter current password for SYSDBA user: "
          OrigPasswd=$Answer
          
      done

    NewPasswd=""

    while [ -z "$NewPasswd" ]
      do
          AskQuestion "Please enter new password for SYSDBA user: "
          NewPasswd=$Answer
          if [ ! -z "$NewPasswd" ]
            then
             $IBBin/gsec -user sysdba -password $OrigPasswd <<EOF
modify sysdba -pw $NewPasswd
EOF
              echo ""

              changeInitPassword "$NewPasswd"

          fi
          
      done
}


#------------------------------------------------------------------------
#  Change sysdba password - this routine is interactive and is only 
#  used in the install shell script not the rpm one.


changeDBAPassword() {

    if [ -z "$InteractiveInstall" ]
      then
        generateNewDBAPassword
      else
        askUserForNewDBAPassword
    fi
}


#= Main Post ===============================================================


    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin
    RunUser=root

    InteractiveInstall=true
    export InteractiveInstall

    changeDBAPassword

--- NEW FILE ---
#! /bin/sh


# Script to install files from the build/transport area


#    cd interbase 




# The guts of the tranfer of files to /opt and other directories


    if [ -d /opt/interbase ] 
      then 
        rm -fr /opt/interbase 
    fi 
    mkdir /opt/interbase 
    mkdir /opt/interbase/bin 
    mkdir /opt/interbase/examples 
    mkdir /opt/interbase/help 
    mkdir /opt/interbase/include 
    mkdir /opt/interbase/intl 
    mkdir /opt/interbase/lib 
    mkdir /opt/interbase/doc 
    mkdir /opt/interbase/UDF 

    cp interbase/bin/gbak /opt/interbase/bin/gbak 
    cp interbase/bin/gdef /opt/interbase/bin/gdef 
    cp interbase/bin/gds_lock_print /opt/interbase/bin/gds_lock_print 
    cp interbase/bin/gfix /opt/interbase/bin/gfix 
    cp interbase/bin/gpre /opt/interbase/bin/gpre 
    cp interbase/bin/gsec /opt/interbase/bin/gsec 
    cp interbase/bin/gsplit /opt/interbase/bin/gsplit 
    cp interbase/bin/gstat /opt/interbase/bin/gstat 
    cp interbase/bin/isc4.gbak /opt/interbase/bin/isc4.gbak 
    cp interbase/bin/isql /opt/interbase/bin/isql 
    cp interbase/bin/qli /opt/interbase/bin/qli 
    cp interbase/bin/ibmgr.bin /opt/interbase/bin/ibmgr.bin 
    #cp interbase/bin/ibmgr /opt/interbase/bin/ibmgr 
    cp interbase/bin/ibserver /opt/interbase/bin/ibserver 
    cp interbase/bin/ibguard /opt/interbase/bin/ibguard 

    cp interbase/examples/v5/*.[ceh] /opt/interbase/examples 
    cp interbase/examples/v5/*.sql /opt/interbase/examples 
    cp interbase/examples/v5/*.gbk /opt/interbase/examples 
    cp interbase/examples/v5/*.gdb /opt/interbase/examples 
    cp interbase/examples/v5/makefile /opt/interbase/examples 
    cp interbase/help/help.gbak /opt/interbase/help 
    cp interbase/help/help.gdb /opt/interbase/help 
    #cp -r interbase/doc /opt/interbase 
    cp interbase/interbase.msg /opt/interbase/interbase.msg 
    cp interbase/isc4.gdb /opt/interbase/isc4.gdb 
    cp interbase/isc_config /opt/interbase/isc_config 

    cp -f interbase/include/gds.h /usr/include/gds.h 
    cp -f interbase/include/iberror.h /usr/include/iberror.h 
    cp -f interbase/include/ibase.h /usr/include/ibase.h 

    cp interbase/include/gds.f /opt/interbase/include 
    cp interbase/include/gds.hxx /opt/interbase/include 
    cp interbase/include/*.h /opt/interbase/include 

    cp -f interbase/lib/gds.so.1 /usr/lib/libgds.so.0 
    if [ -L /usr/lib/libgds.so ]
      then
        rm -f /usr/lib/libgds.so
    fi
    ln -s libgds.so.0 /usr/lib/libgds.so
    cp -f interbase/lib/ib_util /usr/lib/libib_util.so 
    cp -f interbase/lib/gds_pyxis.a /usr/lib/libgds_pyxis.a 

    cp interbase/intl/gdsintl /opt/interbase/intl/gdsintl 
    cp interbase/UDF/ib_udf /opt/interbase/UDF/ib_udf 

    cp interbase/services.isc /opt/interbase/services.isc 
    #cp interbase/license.txt /opt/interbase/license.txt 
    #cp interbase/license.html /opt/interbase/license.html 
    #cp interbase/ReleaseNotes.pdf /opt/interbase/ReleaseNotes.pdf 


    cp interbase/README /opt/interbase/README
    cp  interbase/firebird /etc/rc.d/init.d

    # June 23 2000, 6:00AM 
    #TIMESTAMP="200006230600.00" 
    #cd /opt/interbase/ 
    #touch -t $TIMESTAMP `find . -print`



--- NEW FILE ---
#! /bin/sh


#------------------------------------------------------------------------
# Prompt for response, store result in Answer

Answer=""

AskQuestion() {
    Test=$1
    DefaultAns=$2
    echo -n "${1}"
    Answer="$DefaultAns"
    read Answer
}

#------------------------------------------------------------------------
# add a service line in the (usually) /etc/services or /etc/inetd.conf file
# Here there are three cases, not found         => add service line,
#                             found & different => ask user to check
#                             found & same      => do nothing
#                             

replaceLineInFile() {
    FileName=$1
    newLine=$2
    oldLine=$3

    if [ -z "$oldLine" ] 
      then
        echo "$newLine" >> $FileName

    elif [ "$oldLine" != "$newLine"  ]
      then
        echo ""
        echo "--- Warning ----------------------------------------------"
        echo ""
        echo "    In file $FileName found line: "
        echo "    $oldLine"
        echo "    Which differs from the expected line:"
        echo "    $newLine"
        echo ""

#        AskQuestion "Press return to update file or ^C to abort install"

        cat $FileName | grep -v "$oldLine" > ${FileName}.tmp
        mv ${FileName}.tmp $FileName
        echo "$newLine" >> $FileName
        echo "Updated."

    fi
}

#------------------------------------------------------------------------
# remove line from config file if it exists in it.

removeLineFromFile() {
    FileName=$1
    oldLine=$2

    if [ ! -z "$oldLine" ] 
      then
        cat $FileName | grep -v "$oldLine" > ${FileName}.tmp
        mv ${FileName}.tmp $FileName
        echo "Updated."

    fi
}



#------------------------------------------------------------------------
#  changeInitPassword


changeInitPassword() {

    NewPasswd=$1

    InitFile=/etc/rc.d/init.d/firebird
    if [ -f $InitFile ] 
      then
        ed $InitFile <<EOF
/ISC_PASSWORD/s/ISC_PASSWORD:=.*\}/ISC_PASSWORD=$NewPasswd\}/g
w
q
EOF
    chmod u=rwx,g=rx,o= $InitFile

    fi
}

#------------------------------------------------------------------------
#  Generate new sysdba password


generateNewDBAPassword() {

    DBAPasswordFile=$IBRootDir/SYSDBA.password
    NewPasswd=`mkpasswd -l 8`
    echo "Firebird generated password " > $DBAPasswordFile
    echo "for user SYSDBA is : $NewPasswd" >> $DBAPasswordFile
    echo "generated on `hostname` at time `date`" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo "(For superserver you will also want to check the password in the" >> $DBAPasswordFile
    echo "daemon init routine in the file /etc/rc.d/init.d/firebird)" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo "Your password can be changed to a more suitable one using the" >> $DBAPasswordFile
    echo "/opt/interbase/bin/gsec program as show below:" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo ">cd /opt/interbase" >> $DBAPasswordFile
    echo ">bin/gsec -user sysdba -password <password>" >> $DBAPasswordFile
    echo "GSEC>modify sysdba -pw <newpassword>" >> $DBAPasswordFile
    echo "GSEC>quit" >> $DBAPasswordFile

    chmod u=rw,go= $DBAPasswordFile

    $IBBin/gsec -user sysdba -password masterkey <<EOF
modify sysdba -pw $NewPasswd
EOF

    changeInitPassword "$NewPasswd"


}


#------------------------------------------------------------------------
#  Change sysdba password - this routine is interactive and is only 
#  used in the install shell script not the rpm one.


askUserForNewDBAPassword() {

    NewPasswd=""

    echo "" 
    while [ -z "$NewPasswd" ]
      do
          AskQuestion "Please enter new password for SYSDBA user: "
          NewPasswd=$Answer
          if [ ! -z "$NewPasswd" ]
            then
             $IBBin/gsec -user sysdba -password masterkey <<EOF
modify sysdba -pw $NewPasswd
EOF
              echo ""

              changeInitPassword "$NewPasswd"

          fi
          
      done
}


#------------------------------------------------------------------------
#  Change sysdba password - this routine is interactive and is only 
#  used in the install shell script not the rpm one.


changeDBAPassword() {

    if [ -z "$InteractiveInstall" ]
      then
        generateNewDBAPassword
      else
        askUserForNewDBAPassword
    fi
}


#= Main Post ===============================================================

    # Make sure the links are in place 
    if [ ! -L /opt/interbase -a ! -d /opt/interbase ] 
      then 
    # Main link and... 
        ln -s $RPM_INSTALL_PREFIX/interbase /opt/interbase 
    fi 


    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin
    RunUser=root


    # Update /etc/services


    FileName=/etc/services
    newLine="gds_db          3050/tcp  # InterBase Database Remote Protocol"
    oldLine=`grep "^gds_db" $FileName`

    replaceLineInFile "$FileName" "$newLine" "$oldLine"




    # remove any gds_db line in the /etc/inetd.conf


    FileName=/etc/inetd.conf
    oldLine=`grep "^gds_db" $FileName`

    removeLineFromFile "$FileName" "$oldLine"


    # Get inetd to reread new init files.

    if [ -f /var/run/inetd.pid ]
      then
        kill -HUP `cat /var/run/inetd.pid`
    fi


    # Update ownership of programs

    chown -R $RunUser.$RunUser $IBRootDir

    cd $IBBin


    # Create the ibmgr shell script.
    cat > ibmgr <<EOF
#!/bin/sh
INTERBASE=$IBRootDir
export INTERBASE
exec \$INTERBASE/bin/ibmgr.bin \$@
EOF

    chmod u=rwx,go=rx *

    # These two should only be executed by firebird user.
    chmod u=rwx,go= ibguard ibserver




    # Lock files

    cd $IBRootDir

    for i in isc_init1 isc_lock1 isc_event1 isc_guard1
      do
        FileName=$i.`hostname`
        touch $FileName
        chmod ug=rw,o= $FileName
      done

    touch interbase.log
    chmod u=rw,go= interbase.log


    chmod ug+rx,o= /etc/rc.d/init.d/firebird

    # This will start it at runlevel defined within the firebird file itself.

    /sbin/chkconfig --add firebird


    # start the db server so we can change the password

    (cd /etc/rc.d/init.d; ./firebird start)

    # Change sysdba password

    changeDBAPassword

--- NEW FILE ---
#! /bin/sh


#------------------------------------------------------------------------
# remove line from config file if it exists in it.

removeLineFromFile() {
    FileName=$1
    oldLine=$2

    if [ ! -z "$oldLine" ] 
      then
        cat $FileName | grep -v "$oldLine" > ${FileName}.tmp
        mv ${FileName}.tmp $FileName
        echo "Updated."

    fi
}



#= Main ProstUn ===============================================================

    
    if [ -L /usr/lib/libgds.so ]
      then
        rm -f /usr/lib/libgds.so
    fi

    # Update /etc/services


    FileName=/etc/services
    oldLine=`grep "^gds_db" $FileName`

    removeLineFromFile "$FileName" "$oldLine"


--- NEW FILE ---
#! /bin/sh


#------------------------------------------------------------------------
# Prompt for response, store result in Answer

Answer=""

AskQuestion() {
    Test=$1
    DefaultAns=$2
    echo -n "${1}"
    Answer="$DefaultAns"
    read Answer
}

#------------------------------------------------------------------------
#  stop super server if it is running
#  Also will only stop firebird, since that has the init script


stopServerIfRunning() {

    checkString=`ps -efww| egrep "(ibserver|ibguard)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        if [ -f /etc/rc.d/init.d/firebird ]
          then
            /etc/rc.d/init.d/firebird stop
        fi
    fi
}

#------------------------------------------------------------------------
#  Check if server is running


checkIfServerRunning() {


    stopServerIfRunning

    checkString=`ps -efww| egrep "(ibserver|ibguard)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        echo "An instance of the Firebird/InterBase Super server seems to be running." 
        echo "Please quit all interbase applications and then proceed"
        exit 1 
    fi



    checkString=`ps -efww| egrep "(gds_inet_server|gds_pipe)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        echo "An instance of the Firebird/InterBase server seems to be running." 
        echo "Please quit all interbase applications and then proceed." 
        exit 1 
    fi



# Stop lock manager if it is the only thing running.

    for i in `ps -efww | grep "gds_lock_mgr" | grep -v "grep" | awk '{print $2}' `
     do
        kill $i
     done


}


#------------------------------------------------------------------------
# Run process and check status


runAndCheckExit() {
    Cmd=$*

#    echo $Cmd
    $Cmd

    ExitCode=$?

    if [ $ExitCode -ne 0 ]
      then
        echo "Install aborted: The command $Cmd "
        echo "                 failed with error code $ExitCode"
        exit $ExitCode
    fi
}


#------------------------------------------------------------------------
#  Display message if this is being run interactively.


displayMessage() {

    msgText=$1
    if [ ! -z "$InteractiveInstall" ]
      then
        echo $msgText
    fi
}


#------------------------------------------------------------------------
#  Archive any existing prior installed files.
#  The 'cd' stuff is to avoid the "leading '/' removed message from tar.
#  for the same reason the DestFile is specified without the leading "/"


archivePriorInstallSystemFiles() {

    oldPWD=`pwd`
    archiveFileList=""

    cd /


    DestFile="opt/interbase"
    if [ -e "$DestFile"  ]
      then
        echo ""
        echo ""
        echo ""
        echo "--- Warning ----------------------------------------------"
        echo "    The installation target directory: $IBRootDir"
        echo "    Already contains a prior installation of InterBase/Firebird."
        echo "    This and files found in /usr/include and /usr/lib will be"
        echo "    archived in the file : ${ArchiveMainFile}"
        echo "" 

        if [ ! -z "$InteractiveInstall" ]
          then
            AskQuestion "Press return to continue or ^C to abort"
        fi

        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
    fi


    for i in gds.h ibase.h iberror.h ib_util.h
      do
        DestFile=usr/include/$i
        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
      done

    for i in gds_pyxis.a gds.a libgds.so.0 libgds.so ib_util.so
      do
        DestFile=usr/lib/$i
        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
      done

      if [ ! -z "$archiveFileList" ]
        then

          displayMessage "Archiving..."

          runAndCheckExit "tar -czf $ArchiveMainFile $archiveFileList"


          displayMessage "Done."
          displayMessage "Deleting..."

          for i in $archiveFileList
            do
              rm -rf $i
            done

          displayMessage "Done."

      fi
    cd $oldPWD

}


#------------------------------------------------------------------------
#  Check for installed RPM package

checkForRPMInstall() {
    PackageName=$1

    rpm -q $PackageName
    STATUS=$? 
    if [ $STATUS -eq 0 ]
      then 
        echo "Previous version of $PackageName is detected on your system." 
        echo "this will conflict with the current install of Firebird"
        echo "Please unistall the previous version `rpm -q $PackageName` and then proceed." 
        exit $STATUS 
    fi 

}



#== Main Pre =================================================================

    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin
    ArchiveDateTag=`date +"%Y%m%d_%H%M"`
    ArchiveMainFile="${IBRootDir}_${ArchiveDateTag}.tar.gz"



# Ok so any of the following packages are a problem
# these don't work at least in the latest rpm manager, since it 
# has the rpm database locked and it fails.

#    checkForRPMInstall InterBase
#    checkForRPMInstall FirebirdCS
#    checkForRPMInstall FirebirdSS


    checkIfServerRunning


# Failing that we archive any files we find

    archivePriorInstallSystemFiles


--- NEW FILE ---
#! /bin/sh



#------------------------------------------------------------------------
#  stop server if it is running


stopServerIfRunning() {

    checkString=`ps -ef| egrep "(ibserver|ibguard)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        /etc/rc.d/init.d/firebird stop
    fi
}



#= Main PreUn ================================================================



    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin


    stopServerIfRunning

    /sbin/chkconfig --del firebird


    cd $IBRootDir
    if [ -f isc4.gdb ] 
      then 
        cp isc4.gdb /tmp 
        echo "Saved a copy of isc4.gdb in /tmp" 
    fi 
        

    for i in isc_init1* isc_event1* isc_lock1* isc_guard* interbase.log SYSDBA.password
      do
        if [ -f $i ]
          then
            rm -f $i
        fi
      done


    rm -f $IBBin/ibmgr







--- NEW FILE ---
    %dir /opt/interbase 
    %dir /opt/interbase/bin 
    %dir /opt/interbase/lib 
    %dir /opt/interbase/UDF 
    %dir /opt/interbase/intl 
    %dir /opt/interbase/help 
    /opt/interbase/bin/gbak 
    /opt/interbase/bin/gdef 
    /opt/interbase/bin/gds_lock_print 
    /opt/interbase/bin/gfix 
    /opt/interbase/bin/gpre 
    /opt/interbase/bin/gsec 
    /opt/interbase/bin/gsplit 
    /opt/interbase/bin/gstat 
    /opt/interbase/bin/isc4.gbak 
    /opt/interbase/bin/isql 
    /opt/interbase/bin/qli 
    /opt/interbase/bin/ibmgr.bin 
    /opt/interbase/bin/ibserver 
    /opt/interbase/bin/ibguard 
    /opt/interbase/examples 
    /opt/interbase/help/help.gbak 
    /opt/interbase/help/help.gdb 
    /opt/interbase/include 
    /usr/include/gds.h 
    /usr/include/iberror.h 
    /usr/include/ibase.h 
    /opt/interbase/doc 
    /opt/interbase/interbase.msg 
    /opt/interbase/isc4.gdb 
    /opt/interbase/isc_config 
    /usr/lib/libgds.so.0 
    /usr/lib/libgds.so 
    /usr/lib/libib_util.so 
    /usr/lib/libgds_pyxis.a 
    /opt/interbase/intl/gdsintl 
    /opt/interbase/UDF/ib_udf 
    /opt/interbase/services.isc 
    /opt/interbase/README

    /etc/rc.d/init.d/firebird


--- NEW FILE ---
Summary: Firebird Database Server and Client tools. 
Name: FirebirdSS 
Version: 0.9
Release: 1 
Copyright: Distributable 
Group: Applications/Databases 
Source: FirebirdSS0.9src.tar.gz 
URL: http://firebird.sourceforge.net 
Prefix: /opt 
AutoReqProv: no 

%description
Firebird is a powerful, high-performance relational database designed to be embedded into
applications on multiple platforms.  

[Firebird-checkins] CVS: interbase/firebird/skywalker/install CSrpmscript,NONE,1.1 Makefile,NONE,1.1 SSrpmscript,NONE,1.1

[Mark O. <sky...@us...>]

Update of /cvsroot/firebird/interbase/firebird/skywalker/install
In directory slayer.i.sourceforge.net:/tmp/cvs-serv8525

Added Files:
	CSrpmscript Makefile SSrpmscript 
Log Message:
New files related to the firebird install for linux/unix


--- NEW FILE ---
Summary: Firebird Relational Database Server and Client tools.
Name: FirebirdCS 
Version: 0.9
Release: 1 
Copyright: Distributable 
Group: Applications/Databases 
Source: FirebirdCS0.9src.tar.gz 
URL: http://firebird.sourceforge.net 
Prefix: /opt 
AutoReqProv: no 
# BuildRoot: /var/tmp/%{name}-buildroot

%description
Firebird is a powerful, high-performance relational database designed to be embedded into
applications on multiple platforms.  


%prep

%build

%install

%files
%dir /opt/interbase 
%dir /opt/interbase/bin 
%dir /opt/interbase/lib 
%dir /opt/interbase/UDF 
%dir /opt/interbase/intl 
%dir /opt/interbase/help 

/opt/interbase/bin/gds_inet_server 
/opt/interbase/bin/gbak 
/opt/interbase/bin/gdef 
/opt/interbase/bin/gds_lock_print 
/opt/interbase/bin/gds_lock_mgr 
/opt/interbase/bin/gds_pipe 
/opt/interbase/bin/gds_drop 
/opt/interbase/bin/gfix 
/opt/interbase/bin/gpre 
/opt/interbase/bin/gsec 
/opt/interbase/bin/gsplit 
/opt/interbase/bin/gstat 
/opt/interbase/bin/isc4.gbak 
/opt/interbase/bin/isql 
/opt/interbase/bin/qli 

/opt/interbase/examples 

/opt/interbase/help/help.gbak 
%attr(666, -, -) /opt/interbase/help/help.gdb 

/opt/interbase/include 

/usr/include/gds.h 
/usr/include/iberror.h 
/usr/include/ibase.h 
/usr/include/ib_util.h

#/opt/interbase/doc 

/opt/interbase/README
/opt/interbase/interbase.msg 
%attr(666, -, -) /opt/interbase/isc4.gdb 
/opt/interbase/isc_config 

/usr/lib/libgds.so.0 
/usr/lib/libgds.so
/usr/lib/libib_util.so 
/usr/lib/libgds_pyxis.a 
/usr/lib/libgds.a 
/opt/interbase/intl/gdsintl 
/opt/interbase/UDF/ib_udf 
/opt/interbase/services.isc 







%pre
#!/bin/sh


# The pre install routine for Firebird Classic


#------------------------------------------------------------------------
# Prompt for response, store result in Answer

Answer=""

AskQuestion() {
    Test=$1
    DefaultAns=$2
    echo -n "${1}"
    Answer="$DefaultAns"
    read Answer
}


#------------------------------------------------------------------------
#  stop super server if it is running 
#  Also will only stop firebird, since that has the init script


stopServerIfRunning() {

    checkString=`ps -efww| egrep "(ibserver|ibguard)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        if [ -f /etc/rc.d/init.d/firebird ]
          then
            /etc/rc.d/init.d/firebird stop
        fi
    fi
}

#------------------------------------------------------------------------
#  stop server if it is running


checkIfServerRunning() {


    stopServerIfRunning

# Check is server is being actively used.

    checkString=`ps -efww| egrep "(ibserver|ibguard)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        echo "An instance of the Firebird/InterBase Super server seems to be running." 
        echo "Please quit all interbase applications and then proceed"
        exit 1 
    fi

    checkString=`ps -efww| egrep "(gds_inet_server|gds_pipe)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        echo "An instance of the Firebird/InterBase server seems to be running." 
        echo "Please quit all interbase applications and then proceed." 
        exit 1 
    fi



# Stop lock manager if it is the only thing running.

    for i in `ps -efww | grep "gds_lock_mgr" | grep -v "grep" | awk '{print $2}' `
     do
        kill $i
     done


}

#------------------------------------------------------------------------
# Run process and check status


runAndCheckExit() {
    Cmd=$*

#    echo $Cmd
    $Cmd

    ExitCode=$?

    if [ $ExitCode -ne 0 ]
      then
        echo "Install aborted: The command $Cmd "
        echo "                 failed with error code $ExitCode"
        exit $ExitCode
    fi
}


#------------------------------------------------------------------------
#  Display message if this is being run interactively.


displayMessage() {

    msgText=$1
    if [ ! -z "$InteractiveInstall" ]
      then
        echo $msgText
    fi
}


#------------------------------------------------------------------------
#  Archive any existing prior installed files.
#  The 'cd' stuff is to avoid the "leading '/' removed message from tar.
#  for the same reason the DestFile is specified without the leading "/"


archivePriorInstallSystemFiles() {

    oldPWD=`pwd`
    archiveFileList=""

    cd /


    DestFile="opt/interbase"
    if [ -e "$DestFile"  ]
      then
        echo ""
        echo ""
        echo ""
        echo "--- Warning ----------------------------------------------"
        echo "    The installation target directory: $IBRootDir"
        echo "    Already contains a prior installation of InterBase/Firebird."
        echo "    This and files found in /usr/include and /usr/lib will be"
        echo "    archived in the file : ${ArchiveMainFile}"
        echo "" 

        if [ ! -z "$InteractiveInstall" ]
          then
            AskQuestion "Press return to continue or ^C to abort"
        fi

        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
    fi


    for i in gds.h ibase.h iberror.h ib_util.h
      do
        DestFile=usr/include/$i
        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
      done

    for i in gds_pyxis.a gds.a libgds.so.0 libgds.so ib_util.so
      do
        DestFile=usr/lib/$i
        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
      done

      if [ ! -z "$archiveFileList" ]
        then

          displayMessage "Archiving..."

          runAndCheckExit "tar -czf $ArchiveMainFile $archiveFileList"


          displayMessage "Done."
          displayMessage "Deleting..."

          for i in $archiveFileList
            do
              rm -rf $i
            done

          displayMessage "Done."

      fi
    cd $oldPWD

}


#------------------------------------------------------------------------
#  Check for installed RPM package

checkForRPMInstall() {
    PackageName=$1

    rpm -q $PackageName
    STATUS=$? 
    if [ $STATUS -eq 0 ]
      then 
        echo "Previous version of $PackageName is detected on your system." 
        echo "this will conflict with the current install of Firebird"
        echo "Please unistall the previous version `rpm -q $PackageName` and then proceed." 
        exit $STATUS 
    fi 

}



#= Main Pre ================================================================

    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin
    ArchiveDateTag=`date +"%Y%m%d_%H%M"`
    ArchiveMainFile="${IBRootDir}_${ArchiveDateTag}.tar.gz"



# Ok so any of the following packages are a problem
# these don't work at least in the latest rpm manager, since it 
# has the rpm database locked and it fails.

#    checkForRPMInstall InterBase
#    checkForRPMInstall FirebirdCS
#    checkForRPMInstall FirebirdSS


    checkIfServerRunning

# Failing that we archive any files we find

    archivePriorInstallSystemFiles



%post
#!/bin/sh

# The post install script for Firebird Classic


#------------------------------------------------------------------------
# Prompt for response, store result in Answer

Answer=""

AskQuestion() {
    Test=$1
    DefaultAns=$2
    echo -n "${1}"
    Answer="$DefaultAns"
    read Answer
}


#------------------------------------------------------------------------
# add a service line in the (usually) /etc/services or /etc/inetd.conf file
# Here there are three cases, not found         => add service line,
#                             found & different => ask user to check
#                             found & same      => do nothing
#                             

replaceLineInFile() {
    FileName=$1
    newLine=$2
    oldLine=$3

    if [ -z "$oldLine" ] 
      then
        echo "$newLine" >> $FileName

    elif [ "$oldLine" != "$newLine"  ]
      then
        echo ""
        echo "--- Warning ----------------------------------------------"
        echo ""
        echo "    In file $FileName found line: "
        echo "    $oldLine"
        echo "    Which differs from the expected line:"
        echo "    $newLine"
        echo ""

#        AskQuestion "Press return to update file or ^C to abort install"

        cat $FileName | grep -v "$oldLine" > ${FileName}.tmp
        mv ${FileName}.tmp $FileName
        echo "$newLine" >> $FileName
        echo "Updated."

    fi
}


#------------------------------------------------------------------------
#  Generate new sysdba password - this routine is used only in the 
#  rpm file not in the install acript.


generateNewDBAPassword() {

    DBAPasswordFile=$IBRootDir/SYSDBA.password
    NewPasswd=`mkpasswd -l 8`
    echo "Firebird generated password " > $DBAPasswordFile
    echo "for user SYSDBA is : $NewPasswd" >> $DBAPasswordFile
    echo "generated on `hostname` at time `date`" >> $DBAPasswordFile
    echo "(For superserver you will also want to check the password in the" >> $DBAPasswordFile
    echo "daemon init routine in the file /etc/rc.d/init.d/firebird)" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo "Your password can be changed to a more suitable one using the" >> $DBAPasswordFile
    echo "/opt/interbase/bin/gsec program as show below:" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo ">cd /opt/interbase" >> $DBAPasswordFile
    echo ">bin/gsec -user sysdba -password <password>" >> $DBAPasswordFile
    echo "GSEC>modify sysdba -pw <newpassword>" >> $DBAPasswordFile
    echo "GSEC>quit" >> $DBAPasswordFile
    chmod u=r,go= $DBAPasswordFile

    $IBBin/gsec -user sysdba -password masterkey <<EOF
modify sysdba -pw $NewPasswd
EOF

}

#------------------------------------------------------------------------
#  Change sysdba password - this routine is interactive and is only 
#  used in the install shell script not the rpm one.


askUserForNewDBAPassword() {

    NewPasswd=""

    while [ -z "$NewPasswd" ]
      do
# If using a generated password
#         DBAPasswordFile=$IBRootDir/SYSDBA.password
#         NewPasswd=`mkpasswd -l 8`
#         echo "Password for SYSDBA on `hostname` is : $NewPasswd" > $DBAPasswordFile
#         chmod ga-rwx $DBAPasswordFile

          AskQuestion "Please enter new password for SYSDBA user: "
          NewPasswd=$Answer
          if [ ! -z "$NewPasswd" ]
            then
             $IBBin/gsec -user sysdba -password masterkey <<EOF
modify sysdba -pw $NewPasswd
EOF
              echo ""
          fi
          
      done
}


#------------------------------------------------------------------------
#  Change sysdba password - this routine is interactive and is only 
#  used in the install shell script not the rpm one.


changeDBAPassword() {

    if [ -z "$InteractiveInstall" ]
      then
        generateNewDBAPassword
      else
        askUserForNewDBAPassword
    fi
}


#= Main Post ===============================================================

    # Make sure the links are in place 
    if [ ! -L /opt/interbase -a ! -d /opt/interbase ] 
      then 
    # Main link and... 
        ln -s $RPM_INSTALL_PREFIX/interbase /opt/interbase 
    fi 


    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin
    RunUser=root


    # Update /etc/services


    FileName=/etc/services
    newLine="gds_db          3050/tcp  # InterBase Database Remote Protocol"
    oldLine=`grep "^gds_db" $FileName`

    replaceLineInFile "$FileName" "$newLine" "$oldLine"



    # Update the /etc/inetd.conf


    FileName=/etc/inetd.conf
    newLine="gds_db  stream  tcp     nowait.30000      $RunUser $IBBin/gds_inet_server gds_inet_server # InterBase Database Remote Server"
    oldLine=`grep "^gds_db" $FileName`

    replaceLineInFile "$FileName" "$newLine" "$oldLine"


    # Update ownership and SUID bits for programs.

    chown -R $RunUser.$RunUser $IBRootDir

    cd $IBBin

    for i in gds_lock_mgr gds_drop gds_inet_server
      do
        chmod ug+s $i
      done


    # Get inetd to reread new init files.

    if [ -f /var/run/inetd.pid ]
      then
        kill -HUP `cat /var/run/inetd.pid`
    fi




    # Lock files
    # remember isc_guard1 in addition for super

    cd $IBRootDir

    for i in isc_init1 isc_lock1 isc_event1 
      do
        FileName=$i.`hostname`
        touch $FileName
        chmod uga+rw $FileName
      done

    touch interbase.log
    chmod uga+rw interbase.log



    # Change sysdba password

    changeDBAPassword




%preun
#! /bin/sh

# The pre uninstall routines for Firebird Classic

#------------------------------------------------------------------------
#  stop server if it is running


checkIfServerRunning() {

# Check is server is being actively used.

    checkString=`ps -ef| egrep "(gds_inet_server|gds_pipe)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        echo "An instance of the Firebird/InterBase server seems to be running." 
        echo "Please quit all interbase applications and then proceed." 
        exit 1 
    fi



# Stop lock manager if it is the only thing running.

    for i in `ps -ef | grep "gds_lock_mgr" | grep -v "grep" | cut -d' ' -f3`
     do
        kill $i
     done

}


#= Main PreUn ================================================================
# This is a bit simple, but should work for now.  
# cron will remove files in /tmp after a while. 

    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin

    checkIfServerRunning

    cd $IBRootDir
    
    if [ -f isc4.gdb ] 
      then 
        cp isc4.gdb /tmp 
        echo "Saved a copy of isc4.gdb in /tmp" 
    fi 
    
    for i in isc_init1* isc_event1* isc_lock1* interbase.log SYSDBA.password
      do
        if [ -f $i ]
          then
            rm -f $i
        fi
      done

%postun
#!/bin/sh

# The post uninstall routine for Firebird Classic.


#------------------------------------------------------------------------
# remove line from config file if it exists in it.

removeLineFromFile() {
    FileName=$1
    oldLine=$2

    if [ ! -z "$oldLine" ] 
      then
        cat $FileName | grep -v "$oldLine" > ${FileName}.tmp
        mv ${FileName}.tmp $FileName
        echo "Updated."

    fi
}


#= Main PostUn ============================================================

    if [ -L /usr/lib/libgds.so ] 
      then 
        rm /usr/lib/libgds.so 
    fi 

    if [ "$1"=0 ] 
      then 

        # Lose the gds_db line from /etc/services 

        FileName=/etc/services
        oldLine=`grep "^gds_db" $FileName`
        removeLineFromFile "$FileName" "$oldLine"

        # Next, lose the gds_db line from /etc/inetd.conf

        FileName=/etc/inetd.conf
        oldLine=`grep "^gds_db" $FileName`
        removeLineFromFile "$FileName" "$oldLine"

        # Get inetd to reread new inetd.conf file

        if [ -f /var/run/inetd.pid ]
          then
            kill -HUP `cat /var/run/inetd.pid`
        fi
    fi

--- NEW FILE ---
.PHONY: all CSrpmscript SSrpmscript csinstall ssinstall



ClassicSrcDir=classic/
SuperSrcDir=super/


all: CSrpmscript SSrpmscript csinstall ssinstall

CSrpmscript: 
	echo $@
	cat $(ClassicSrcDir)CSrpmheader.txt > $@
	echo "" >> $@
	echo "%prep" >> $@
#	cat $(ClassicSrcDir)CSprepinstall.sh >> $@
	echo "" >> $@
	echo "%build" >> $@
#	cat $(ClassicSrcDir)CSbuildinstall.sh >> $@
	echo "" >> $@
	echo "%install" >> $@
#	cat $(ClassicSrcDir)CSinstall.sh >> $@
	echo "" >> $@
	echo "%files" >> $@
	cat $(ClassicSrcDir)CSrpmfiles.txt >> $@
	echo "" >> $@
	echo "%pre" >> $@
	cat $(ClassicSrcDir)CSpreinstall.sh >> $@
	echo "" >> $@
	echo "%post" >> $@
	cat $(ClassicSrcDir)CSpostinstall.sh >> $@
	echo "" >> $@
	echo "%preun" >> $@
	cat $(ClassicSrcDir)CSpreuninstall.sh >> $@
	echo "" >> $@
	echo "%postun" >> $@
	cat $(ClassicSrcDir)CSpostuninstall.sh >> $@

SSrpmscript: 
	echo $@
	cat $(SuperSrcDir)SSrpmheader.txt > $@
	echo "" >> $@
	echo "%prep" >> $@
#	cat $(SuperSrcDir)SSprepinstall.sh >> $@
	echo "" >> $@
	echo "%build" >> $@
#	cat $(SuperSrcDir)SSbuildinstall.sh >> $@
	echo "" >> $@
	echo "%install" >> $@
#	cat $(SuperSrcDir)SSinstall.sh >> $@
	echo "" >> $@
	echo "%files" >> $@
	cat $(SuperSrcDir)SSrpmfiles.txt >> $@
	echo "" >> $@
	echo "%pre" >> $@
	cat $(SuperSrcDir)SSpreinstall.sh >> $@
	echo "" >> $@
	echo "%post" >> $@
	cat $(SuperSrcDir)SSpostinstall.sh >> $@
	echo "" >> $@
	echo "%preun" >> $@
	cat $(SuperSrcDir)SSpreuninstall.sh >> $@
	echo "" >> $@
	echo "%postun" >> $@
	cat $(SuperSrcDir)SSpostuninstall.sh >> $@


CSTarInstallDir=csinstall

csinstall:
	mkdir -p $(CSTarInstallDir)/scripts
	cp $(ClassicSrcDir)CSpreinstall.sh $(CSTarInstallDir)/scripts
	cp $(ClassicSrcDir)CSinstall.sh $(CSTarInstallDir)/scripts
	cp $(ClassicSrcDir)CSpostinstall.sh $(CSTarInstallDir)/scripts
	cp $(ClassicSrcDir)CSTarInstall.sh $(CSTarInstallDir)/install.sh

SSTarInstallDir=ssinstall

ssinstall:
	mkdir -p $(SSTarInstallDir)/scripts
	cp $(SuperSrcDir)SSpreinstall.sh $(SSTarInstallDir)/scripts
	cp $(SuperSrcDir)SSinstall.sh $(SSTarInstallDir)/scripts
	cp $(SuperSrcDir)SSpostinstall.sh $(SSTarInstallDir)/scripts
	cp $(SuperSrcDir)SSTarInstall.sh $(SSTarInstallDir)/install.sh

--- NEW FILE ---
Summary: Firebird Database Server and Client tools. 
Name: FirebirdSS 
Version: 0.9
Release: 1 
Copyright: Distributable 
Group: Applications/Databases 
Source: FirebirdSS0.9src.tar.gz 
URL: http://firebird.sourceforge.net 
Prefix: /opt 
AutoReqProv: no 

%description
Firebird is a powerful, high-performance relational database designed to be embedded into
applications on multiple platforms.  


%prep

%build

%install

%files
    %dir /opt/interbase 
    %dir /opt/interbase/bin 
    %dir /opt/interbase/lib 
    %dir /opt/interbase/UDF 
    %dir /opt/interbase/intl 
    %dir /opt/interbase/help 
    /opt/interbase/bin/gbak 
    /opt/interbase/bin/gdef 
    /opt/interbase/bin/gds_lock_print 
    /opt/interbase/bin/gfix 
    /opt/interbase/bin/gpre 
    /opt/interbase/bin/gsec 
    /opt/interbase/bin/gsplit 
    /opt/interbase/bin/gstat 
    /opt/interbase/bin/isc4.gbak 
    /opt/interbase/bin/isql 
    /opt/interbase/bin/qli 
    /opt/interbase/bin/ibmgr.bin 
    /opt/interbase/bin/ibserver 
    /opt/interbase/bin/ibguard 
    /opt/interbase/examples 
    /opt/interbase/help/help.gbak 
    /opt/interbase/help/help.gdb 
    /opt/interbase/include 
    /usr/include/gds.h 
    /usr/include/iberror.h 
    /usr/include/ibase.h 
    /opt/interbase/doc 
    /opt/interbase/interbase.msg 
    /opt/interbase/isc4.gdb 
    /opt/interbase/isc_config 
    /usr/lib/libgds.so.0 
    /usr/lib/libgds.so 
    /usr/lib/libib_util.so 
    /usr/lib/libgds_pyxis.a 
    /opt/interbase/intl/gdsintl 
    /opt/interbase/UDF/ib_udf 
    /opt/interbase/services.isc 
    /opt/interbase/README

    /etc/rc.d/init.d/firebird


%pre
#! /bin/sh


#------------------------------------------------------------------------
# Prompt for response, store result in Answer

Answer=""

AskQuestion() {
    Test=$1
    DefaultAns=$2
    echo -n "${1}"
    Answer="$DefaultAns"
    read Answer
}

#------------------------------------------------------------------------
#  stop super server if it is running
#  Also will only stop firebird, since that has the init script


stopServerIfRunning() {

    checkString=`ps -efww| egrep "(ibserver|ibguard)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        if [ -f /etc/rc.d/init.d/firebird ]
          then
            /etc/rc.d/init.d/firebird stop
        fi
    fi
}

#------------------------------------------------------------------------
#  Check if server is running


checkIfServerRunning() {


    stopServerIfRunning

    checkString=`ps -efww| egrep "(ibserver|ibguard)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        echo "An instance of the Firebird/InterBase Super server seems to be running." 
        echo "Please quit all interbase applications and then proceed"
        exit 1 
    fi



    checkString=`ps -efww| egrep "(gds_inet_server|gds_pipe)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        echo "An instance of the Firebird/InterBase server seems to be running." 
        echo "Please quit all interbase applications and then proceed." 
        exit 1 
    fi



# Stop lock manager if it is the only thing running.

    for i in `ps -efww | grep "gds_lock_mgr" | grep -v "grep" | awk '{print $2}' `
     do
        kill $i
     done


}


#------------------------------------------------------------------------
# Run process and check status


runAndCheckExit() {
    Cmd=$*

#    echo $Cmd
    $Cmd

    ExitCode=$?

    if [ $ExitCode -ne 0 ]
      then
        echo "Install aborted: The command $Cmd "
        echo "                 failed with error code $ExitCode"
        exit $ExitCode
    fi
}


#------------------------------------------------------------------------
#  Display message if this is being run interactively.


displayMessage() {

    msgText=$1
    if [ ! -z "$InteractiveInstall" ]
      then
        echo $msgText
    fi
}


#------------------------------------------------------------------------
#  Archive any existing prior installed files.
#  The 'cd' stuff is to avoid the "leading '/' removed message from tar.
#  for the same reason the DestFile is specified without the leading "/"


archivePriorInstallSystemFiles() {

    oldPWD=`pwd`
    archiveFileList=""

    cd /


    DestFile="opt/interbase"
    if [ -e "$DestFile"  ]
      then
        echo ""
        echo ""
        echo ""
        echo "--- Warning ----------------------------------------------"
        echo "    The installation target directory: $IBRootDir"
        echo "    Already contains a prior installation of InterBase/Firebird."
        echo "    This and files found in /usr/include and /usr/lib will be"
        echo "    archived in the file : ${ArchiveMainFile}"
        echo "" 

        if [ ! -z "$InteractiveInstall" ]
          then
            AskQuestion "Press return to continue or ^C to abort"
        fi

        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
    fi


    for i in gds.h ibase.h iberror.h ib_util.h
      do
        DestFile=usr/include/$i
        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
      done

    for i in gds_pyxis.a gds.a libgds.so.0 libgds.so ib_util.so
      do
        DestFile=usr/lib/$i
        if [ -e $DestFile ]
          then
            archiveFileList="$archiveFileList $DestFile"
        fi
      done

      if [ ! -z "$archiveFileList" ]
        then

          displayMessage "Archiving..."

          runAndCheckExit "tar -czf $ArchiveMainFile $archiveFileList"


          displayMessage "Done."
          displayMessage "Deleting..."

          for i in $archiveFileList
            do
              rm -rf $i
            done

          displayMessage "Done."

      fi
    cd $oldPWD

}


#------------------------------------------------------------------------
#  Check for installed RPM package

checkForRPMInstall() {
    PackageName=$1

    rpm -q $PackageName
    STATUS=$? 
    if [ $STATUS -eq 0 ]
      then 
        echo "Previous version of $PackageName is detected on your system." 
        echo "this will conflict with the current install of Firebird"
        echo "Please unistall the previous version `rpm -q $PackageName` and then proceed." 
        exit $STATUS 
    fi 

}



#== Main Pre =================================================================

    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin
    ArchiveDateTag=`date +"%Y%m%d_%H%M"`
    ArchiveMainFile="${IBRootDir}_${ArchiveDateTag}.tar.gz"



# Ok so any of the following packages are a problem
# these don't work at least in the latest rpm manager, since it 
# has the rpm database locked and it fails.

#    checkForRPMInstall InterBase
#    checkForRPMInstall FirebirdCS
#    checkForRPMInstall FirebirdSS


    checkIfServerRunning


# Failing that we archive any files we find

    archivePriorInstallSystemFiles


%post
#! /bin/sh


#------------------------------------------------------------------------
# Prompt for response, store result in Answer

Answer=""

AskQuestion() {
    Test=$1
    DefaultAns=$2
    echo -n "${1}"
    Answer="$DefaultAns"
    read Answer
}

#------------------------------------------------------------------------
# add a service line in the (usually) /etc/services or /etc/inetd.conf file
# Here there are three cases, not found         => add service line,
#                             found & different => ask user to check
#                             found & same      => do nothing
#                             

replaceLineInFile() {
    FileName=$1
    newLine=$2
    oldLine=$3

    if [ -z "$oldLine" ] 
      then
        echo "$newLine" >> $FileName

    elif [ "$oldLine" != "$newLine"  ]
      then
        echo ""
        echo "--- Warning ----------------------------------------------"
        echo ""
        echo "    In file $FileName found line: "
        echo "    $oldLine"
        echo "    Which differs from the expected line:"
        echo "    $newLine"
        echo ""

#        AskQuestion "Press return to update file or ^C to abort install"

        cat $FileName | grep -v "$oldLine" > ${FileName}.tmp
        mv ${FileName}.tmp $FileName
        echo "$newLine" >> $FileName
        echo "Updated."

    fi
}

#------------------------------------------------------------------------
# remove line from config file if it exists in it.

removeLineFromFile() {
    FileName=$1
    oldLine=$2

    if [ ! -z "$oldLine" ] 
      then
        cat $FileName | grep -v "$oldLine" > ${FileName}.tmp
        mv ${FileName}.tmp $FileName
        echo "Updated."

    fi
}



#------------------------------------------------------------------------
#  changeInitPassword


changeInitPassword() {

    NewPasswd=$1

    InitFile=/etc/rc.d/init.d/firebird
    if [ -f $InitFile ] 
      then
        ed $InitFile <<EOF
/ISC_PASSWORD/s/ISC_PASSWORD:=.*\}/ISC_PASSWORD=$NewPasswd\}/g
w
q
EOF
    chmod u=rwx,g=rx,o= $InitFile

    fi
}

#------------------------------------------------------------------------
#  Generate new sysdba password


generateNewDBAPassword() {

    DBAPasswordFile=$IBRootDir/SYSDBA.password
    NewPasswd=`mkpasswd -l 8`
    echo "Firebird generated password " > $DBAPasswordFile
    echo "for user SYSDBA is : $NewPasswd" >> $DBAPasswordFile
    echo "generated on `hostname` at time `date`" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo "(For superserver you will also want to check the password in the" >> $DBAPasswordFile
    echo "daemon init routine in the file /etc/rc.d/init.d/firebird)" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo "Your password can be changed to a more suitable one using the" >> $DBAPasswordFile
    echo "/opt/interbase/bin/gsec program as show below:" >> $DBAPasswordFile
    echo "" >> $DBAPasswordFile
    echo ">cd /opt/interbase" >> $DBAPasswordFile
    echo ">bin/gsec -user sysdba -password <password>" >> $DBAPasswordFile
    echo "GSEC>modify sysdba -pw <newpassword>" >> $DBAPasswordFile
    echo "GSEC>quit" >> $DBAPasswordFile

    chmod u=rw,go= $DBAPasswordFile

    $IBBin/gsec -user sysdba -password masterkey <<EOF
modify sysdba -pw $NewPasswd
EOF

    changeInitPassword "$NewPasswd"


}


#------------------------------------------------------------------------
#  Change sysdba password - this routine is interactive and is only 
#  used in the install shell script not the rpm one.


askUserForNewDBAPassword() {

    NewPasswd=""

    echo "" 
    while [ -z "$NewPasswd" ]
      do
          AskQuestion "Please enter new password for SYSDBA user: "
          NewPasswd=$Answer
          if [ ! -z "$NewPasswd" ]
            then
             $IBBin/gsec -user sysdba -password masterkey <<EOF
modify sysdba -pw $NewPasswd
EOF
              echo ""

              changeInitPassword "$NewPasswd"

          fi
          
      done
}


#------------------------------------------------------------------------
#  Change sysdba password - this routine is interactive and is only 
#  used in the install shell script not the rpm one.


changeDBAPassword() {

    if [ -z "$InteractiveInstall" ]
      then
        generateNewDBAPassword
      else
        askUserForNewDBAPassword
    fi
}


#= Main Post ===============================================================

    # Make sure the links are in place 
    if [ ! -L /opt/interbase -a ! -d /opt/interbase ] 
      then 
    # Main link and... 
        ln -s $RPM_INSTALL_PREFIX/interbase /opt/interbase 
    fi 


    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin
    RunUser=root


    # Update /etc/services


    FileName=/etc/services
    newLine="gds_db          3050/tcp  # InterBase Database Remote Protocol"
    oldLine=`grep "^gds_db" $FileName`

    replaceLineInFile "$FileName" "$newLine" "$oldLine"




    # remove any gds_db line in the /etc/inetd.conf


    FileName=/etc/inetd.conf
    oldLine=`grep "^gds_db" $FileName`

    removeLineFromFile "$FileName" "$oldLine"


    # Get inetd to reread new init files.

    if [ -f /var/run/inetd.pid ]
      then
        kill -HUP `cat /var/run/inetd.pid`
    fi


    # Update ownership of programs

    chown -R $RunUser.$RunUser $IBRootDir

    cd $IBBin


    # Create the ibmgr shell script.
    cat > ibmgr <<EOF
#!/bin/sh
INTERBASE=$IBRootDir
export INTERBASE
exec \$INTERBASE/bin/ibmgr.bin \$@
EOF

    chmod u=rwx,go=rx *

    # These two should only be executed by firebird user.
    chmod u=rwx,go= ibguard ibserver




    # Lock files

    cd $IBRootDir

    for i in isc_init1 isc_lock1 isc_event1 isc_guard1
      do
        FileName=$i.`hostname`
        touch $FileName
        chmod ug=rw,o= $FileName
      done

    touch interbase.log
    chmod u=rw,go= interbase.log


    chmod ug+rx,o= /etc/rc.d/init.d/firebird

    # This will start it at runlevel defined within the firebird file itself.

    /sbin/chkconfig --add firebird


    # start the db server so we can change the password

    (cd /etc/rc.d/init.d; ./firebird start)

    # Change sysdba password

    changeDBAPassword

%preun
#! /bin/sh



#------------------------------------------------------------------------
#  stop server if it is running


stopServerIfRunning() {

    checkString=`ps -ef| egrep "(ibserver|ibguard)" |grep -v grep`

    if [ ! -z "$checkString" ] 
      then
        /etc/rc.d/init.d/firebird stop
    fi
}



#= Main PreUn ================================================================



    IBRootDir=/opt/interbase
    IBBin=$IBRootDir/bin


    stopServerIfRunning

    /sbin/chkconfig --del firebird


    cd $IBRootDir
    if [ -f isc4.gdb ] 
      then 
        cp isc4.gdb /tmp 
        echo "Saved a copy of isc4.gdb in /tmp" 
    fi 
        

    for i in isc_init1* isc_event1* isc_lock1* isc_guard* interbase.log SYSDBA.password
      do
        if [ -f $i ]
          then
            rm -f $i
        fi
      done


    rm -f $IBBin/ibmgr







%postun
#! /bin/sh


#------------------------------------------------------------------------
# remove line from config file if it exists in it.

removeLineFromFile() {
    FileName=$1
    oldLine=$2

    if [ ! -z "$oldLine" ] 
      then
        cat $FileName | grep -v "$oldLine" > ${FileName}.tmp
        mv ${FileName}.tmp $FileName
        echo "Updated."

    fi
}



#= Main ProstUn ===============================================================

    
    if [ -L /usr/lib/libgds.so ]
      then
        rm -f /usr/lib/libgds.so
    fi

    # Update /etc/services


    FileName=/etc/services
    oldLine=`grep "^gds_db" $FileName`

    removeLineFromFile "$FileName" "$oldLine"

[Firebird-checkins] CVS: interbase/firebird/skywalker/install/misc README,NONE,1.1 firebird,NONE,1.1

[Mark O. <sky...@us...>]

Update of /cvsroot/firebird/interbase/firebird/skywalker/install/misc
In directory slayer.i.sourceforge.net:/tmp/cvs-serv8525/misc

Added Files:
	README firebird 
Log Message:
New files related to the firebird install for linux/unix


--- NEW FILE ---
Firebird 1.0 Classic Server for Linux


More information can be found about the Firebird 
database engine from: 
http://firebird.sourceforge.net

or affiliated sites: 

http://www.ibphoenix.com
http://www.interbase2000.com



The Firebird database engine is derived from the
InterBase(tm) product currently owned by Inprise.  
The documentation for InterBase v 6.0 applies also to
the current FireBird release.  InterBase documentation 
is available in Adobe Acrobat format from 
http://www.interbase.com.


--- NEW FILE ---
#!/bin/sh

# chkconfig: 345 20 80
# description: Start/Stop firebird database server
#
# This file belongs in /etc/rc.d/init.d where it will be run
# on system startup and shutdown to start the background
# Firebird/interbase database server daemon 

# Source function library.
. /etc/rc.d/init.d/functions


: ${INTERBASE:=/opt/interbase}
: ${ISC_USER:=SYSDBA}
: ${ISC_PASSWORD:=masterkey}
: ${FBRunUser:=root}
# WARNING: in a real-world installation, you should not put the 
# SYSDBA password in a publicly-readable file. 
# Eventually this file should not need to contain any passwords.
# as root user alone should be sufficient privledge to stop/start 
# the server. 


export INTERBASE 
export ISC_USER
export ISC_PASSWORD


# Check the file is there and is executable.
[ -x $INTERBASE/bin/ibmgr ] || exit 0



# See how we were called.
case "$1" in
  start)
	echo -n "Starting Firebird server: "
	daemon --user $FBRunUser $INTERBASE/bin/ibmgr -start -forever
#    echo '$INTERBASE/bin/ibmgr -start -forever' | su $FBRunUser
	RETVAL=$?
	;;
  stop)
	echo -n "Stopping Firebird server: "
    $INTERBASE/bin/ibmgr -shut
#	killproc ibserver
	RETVAL=$?
#	echo
#	[ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/identd
	;;
  status)
	status ibserver
	RETVAL=$?
	;;
  restart|reload)
	$0 stop
	$0 start
	RETVAL=$?
	;;
  *)
	echo "Usage: identd {start|stop|status|restart|reload}"
	exit 1
esac

exit $RETVAL

[Firebird-checkins] CVS: interbase/firebird/skywalker/install/misc - New directory

[Mark O. <sky...@us...>]

Update of /cvsroot/firebird/interbase/firebird/skywalker/install/misc
In directory slayer.i.sourceforge.net:/tmp/cvs-serv8323/misc

Log Message:
Directory /cvsroot/firebird/interbase/firebird/skywalker/install/misc added to the repository

[Firebird-checkins] CVS: interbase/firebird/skywalker/install/classic - New directory

[Mark O. <sky...@us...>]

Update of /cvsroot/firebird/interbase/firebird/skywalker/install/classic
In directory slayer.i.sourceforge.net:/tmp/cvs-serv8323/classic

Log Message:
Directory /cvsroot/firebird/interbase/firebird/skywalker/install/classic added to the repository

[Firebird-checkins] CVS: interbase/firebird/skywalker/install/super - New directory

[Mark O. <sky...@us...>]

Update of /cvsroot/firebird/interbase/firebird/skywalker/install/super
In directory slayer.i.sourceforge.net:/tmp/cvs-serv8323/super

Log Message:
Directory /cvsroot/firebird/interbase/firebird/skywalker/install/super added to the repository

[Firebird-checkins] CVS: interbase/firebird/skywalker/install - New directory

[Mark O. <sky...@us...>]

Update of /cvsroot/firebird/interbase/firebird/skywalker/install
In directory slayer.i.sourceforge.net:/tmp/cvs-serv7851/install

Log Message:
Directory /cvsroot/firebird/interbase/firebird/skywalker/install added to the repository