Uwe Grauer wrote: > 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.
Not for testing. The only reason I am doing this is to help paul create a test environment. I have no interest in using a FB server for my apps, so the only interest in FB I have is to reduce the amount of work Paul has to do, and maybe add some value to dabo by running tests. As long as I am doing something, I will also try to add value to the ubuntu project. I would be surprised if the ubuntu packages are not sufficient for the dabo tests. Given that, I am not interested in a gui. (I missed that flamerobin was the gui.) So if you can provide scripts that can setup a test db, including removing a previous one, I will run them. Carl K _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
