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. 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". 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 a start you could use the firebird example database: /opt/firebird/examples/empbuild/employee.fdb If you really need a testdatabase other than this, please let me know. If you get problems, just ask. Hope that helps, Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
