Installation of Firebird and METDATA ==================================== (At all later places %%% means some version number, replace it with the one of the installation files.) Please note, that the METDATA software was developed and tested with Firebird 1.5.2 only. 1) Download the Software --------------------- www.firebirdsql.org --> download-section -> get the SuperServer variant, fitting your system (32bit NTPL? / 64bit) iblsoft.com --> METDATA --> download 2) Migrate from Firebird-32bit to -64bit ------------------------------------- If you already used METDATA and switched it to another server which is a 64bit system instead the previous used 32bit system you may have installed the FirebirdSS-%%%.amd64.rpm (although the 32bit version will work on a 64bit system). In this case you have to migrate the METDATA database as the one which comes with the installation package is created on a 32bit system. a) make a system architecture independent backup of the "old" database: gbak -user mw -password mw -B $METDATA-DIR/database/metdata-db.fdb \ metdata.fbk b) For security reasons you should make a copy of the database file too. (In case anything goes wrong) cp -p $METDATA-DIR/database/metdata-db.fdb metdata-db.fdb.32bit 3) Install ------- Firebird.rpm will install in /opt/firebird as default and start as service. -> root privileges are required. a) Firebird: If an old version is already installed and you want to upgrade, firebird has to de-installed first: rpm -e Firebird-%%% After that you can install the new version: rpm -ivh FirebirdSS-%%%.rpm cd /opt/firebird/bin Check the SYSDBA password: cat ../SYSDBA.password Use the previously password here: ./gsec -user sysdba -password *** GSEC> add mw -pw mw GSEC> display Is the user MW shown? GESC> quit b) METDATA: Create the directory METDATA-Monitor at a convenient place, i.e. the home-dir of the user you intend to use running METDATA. Switch to the user which should run the METDATA. java -jar metdata-monitor-%%%.jar -> In the GUI enter the previously created path where METDATA should be installed in. -> de-check the checkbox for the installation of Firebird (as we already did the installation ourselves) Proceed with the installation. If you don't want to use the default port 8081 for the web-server component you can change it editing the file: $METDATA-DIR/config/webserver.xml Change the line: 8081 At last change the access rights for: $METDATA-DIR/database/metdata-db.fdb Make sure that the user firebird (the one the Firebird server is running under) can access the complete path to the database. 4) If step 2 was done: Restore the METDATA-database ------------------------------------------------ gbak -C metdata.fbk $METDATA-DIR/database/metdata-db.fdb This will re-create the database (in system dependent architecture form), overwriting an existing file! 5) Configure METDATA ----------------- Now you should access METDATA (after starting it) using your web-browser going to http://server:port, where server is the system you intalled METDATA on and port is either the default port 8081 or the one you changed it to at step 3b.