On 16 February 2013 20:54, philippe makowski <[email protected]> wrote: > mateuszloskot [2013-02-15 13:53] : >> [...] >> Firebird installation: >> >> sudo dpkg-reconfigure firebird2.5-super >> >> My first question is, how can I install, configure and run Firebird >> without interactive steps? >> >> I have found that someone asked similar question to mine, >> followed with suggestion to set ENABLE_FIREBIRD_SERVER in >> /etc/default/firebird2.5 file [2]. >> Then, my travis.yml config file [3] can execute: >> >> sed /ENABLE_FIREBIRD_SERVER=/s/no/yes/ -i /etc/default/firebird2.5 >> >> Is this the recommended way to do it? > First this more a Debian problem than a Firebird problem
Yes, I understand that. > Second it seems that it solved : > https://github.com/travis-ci/travis-cookbooks/issues/43 I pointed to that too, it's in discussion on travis-ci forum I linked to in my first post: https://groups.google.com/forum/#!topic/travis-ci/UxlnE5t9sTE/discussion But, it seems it's never been released on Travis CI the hosted at travis-ci.org. IOW, it's of little use for end users. >> Next, I will have to create a new empty database which tests runner >> will connect to, using required connection string, >> and run tests against the database. >> >> What's the recommended way to create a database non-interactively? >> > isql with a sql script > http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/isql-switches.html > > in that script you can write : > CREATE DATABASE ... Got it, thanks. Anyway, with little help from folks on #firebird IRC channel, I managed to set up Firebird for my project. It basically involves the following steps executed from .travis.yml (https://github.com/SOCI/soci/blob/master/.travis.yml): - sudo apt-get update -qq - sudo apt-get install -qq firebird2.5-super firebird2.5-dev - sudo sed /ENABLE_FIREBIRD_SERVER=/s/no/yes/ -i /etc/default/firebird2.5 - sudo service firebird2.5-super start - echo 'CREATE DATABASE "LOCALHOST:/tmp/soci_test.fdb" PAGE_SIZE = 16384;' > /tmp/create_soci_test.sql - isql-fb -u SYSDBA -p masterkey -i /tmp/create_soci_test.sql -q Then, I feed my tests runner with the folliwing connection string: "service=LOCALHOST:/tmp/soci_test.fdb user=SYSDBA password=masterkey" Everything works well. Best regards -- Mateusz Loskot, http://mateusz.loskot.net
