Carl Karsten wrote: > Uwe Grauer wrote: >> Carl Karsten wrote: >>>> What I need to do is install a test Firebird and Postgres server so I >>>> can subject them to the unit testing, but in lieu of that at least we >>>> have your real application to test. >>>> >>> I was trying to setup firebird yesterday. one tip: the cli client isn't in >>> the >>> server package, it is in: >>> >>> http://packages.ubuntu.com/edgy/misc/firebird2-utils-classic >>> >>> and it is called isql-fb. (i think.) >>> >>> Uwe - can you give us the steps (script would be best) to create a db? >>> >>> Something like the bash script below would be great. >>> >>> Carl K >>> >> -- snip -- >> >> For firebird development firebird superserver is the easiest architecture. >> Some ubuntu users reported problems with the ubuntu packages. > > Any idea what? I have as much interest in fixing ubuntu packages as I do > testing dabo on firebird. I would hope that it isn't such a disaster that I > can't tell what is/isn't working. > >> That's why i always installed from the original binaries from >> firebirdsql.org. If you do this, you will find the SYSDBA psssword in a >> file called SYSDBA.password in the firebird folder (/opt/firebird). >> You can change this with the provided script "changeDBApassword.sh". > > apparently that does not come with the ubuntu package: > http://packages.ubuntu.com/edgy/misc/firebird2-super-server - click [list of > files] > > Any idea how if I installed the ubuntu package: > > $ sudo apt-get install firebird2-super-server > $ sudo apt-get install firebird2-utils-super > >> Get flamerobin from http://flamerobin.org/ for a nice gui. >> It's far better than using the command line thing. >> I know that mysql users tend to do DDL with bash-scripts. >> But with firebird you have to be more careful because >> doing DDL when other connections are open often doesn't work in fb. >> Besides of this you always should use transactions. >> You have to commit often when doing DDL. > > For testing, everything should be scripted. much easier to run the test > without > making a mistake, much easier to document what was done. > >> For a start you could use the firebird example database: >> /opt/firebird/examples/empbuild/employee.fdb > > also not included. > > This is as far as I have gotten: > > [EMAIL PROTECTED]:~$ isql-fb > Use CONNECT or CREATE DATABASE to specify a database > SQL> create database 'foo'; > Statement failed, SQLCODE = -902 > Your user name and password are not defined. Ask your database administrator > to > set up a Firebird login. > > I am guessing that means the server and a client are setup. > > Carl K >
Carl, if you don't trust what i say, you are on your own. As you just saw, there are reasons why i do not recommend using the ubuntu provided packages. I do not use ubuntu here, but i once tested it for Ed on ubuntu 6.06. It took about 10 min to download and install the databse server. I didn't use firebird isql for a long time because it's easier to use flamerobin for this. Download http://prdownloads.sourceforge.net/firebird/FirebirdSS-2.0.0.12748-0.nptl.i686.tar.gz extract into a newly created directory and "sudo install.sh". Get flamerobin, do a "sudo sh ./configure", "sudo make install" and you should have everything to get going. Here is a script to run in flamerobin after you where able to create an empty database: /* Please note that this script doesn't maintain proper order of creation for computed columns if they reference other tables. */ /********************* ROLES **********************/ /********************* UDFS ***********************/ /****************** GENERATORS ********************/ CREATE GENERATOR GEN_ALL_TYPES; /******************** DOMAINS *********************/ /******************* PROCEDURES ******************/ /******************** TABLES **********************/ CREATE TABLE ALL_TYPES ( XIID Numeric(18,0) NOT NULL, XCHAR Char(10) NOT NULL, XVARCHAR Varchar(20) NOT NULL, XINTEGER Integer NOT NULL, XSMALLINT Smallint NOT NULL, XNUMERIC Numeric(18,0) NOT NULL, XDECIMAL Decimal(10,0) NOT NULL, XBIGINT Numeric(18,0) NOT NULL, XFLOAT Float NOT NULL, XDOUBLE Double precision NOT NULL, XDATE Date NOT NULL, XTIME Time NOT NULL, XTIMESTAMP Timestamp NOT NULL, XBLOB Blob sub_type 0, PRIMARY KEY (XIID) ); /********************* VIEWS **********************/ /******************* EXCEPTIONS *******************/ /******************** TRIGGERS ********************/ SET TERM ^ ; CREATE TRIGGER SET_ALL_TYPES_IID FOR ALL_TYPES ACTIVE BEFORE INSERT POSITION 0 AS BEGIN if (new.XIID is null) then new.XIID = gen_id(gen_all_types, 1); END^ SET TERM ; ^ GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE ON ALL_TYPES TO SYSDBA WITH GRANT OPTION; Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
