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