Carl Karsten wrote: > Uwe Grauer wrote: >> 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, > > from where? >
Carl, didn't you read my mail? You should be able to use google too. If you search for "flamerobin" you get it as first result. Quote from me: > Get flamerobin from http://flamerobin.org/ for a nice gui. > It's far better than using the command line thing. Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
