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? _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
