title: Firebird create database in specific directory
body: <p>I want to be able to create a firebird database in a specific directory. I know that the firebird user needs to have r/w/x permissions to the directory where I want to create the db. I created a group called 'tracker' and I added my user and the firebird user to that group.</p>
  
  <pre><code>firebird@ubuntu:/$ groups firebird
  firebird tracker
  </code></pre>
  
  <p>I created a main directory called 'tracker'</p>
  
  <pre><code>drwxrwx---   3 me tracker  4096 Oct 16 10:40 tracker
  </code></pre>
  
  <p>Inside the 'tracker' directory I created an 'fdb' directory where I want the firebird DB's to be created. </p>
  
  <pre><code>drwxrwx--- 2 firebird firebird 4096 Oct 16 11:35 fdb
  </code></pre>
  
  <p>Now when I try to create the database using the following command:</p>
  
  <pre><code>CREATE DATABASE 'localhost:/tracker/fdb/test.fdb' page_size 8192 user 'SYSDBA' password 'foobar' DEFAULT CHARACTER SET UTF8;
  </code></pre>
  
  <p>I get the following error:</p>
  
  <pre><code>Statement failed, SQLSTATE = 08001
  I/O error during "open O_CREAT" operation for file "/tracker/fdb/test.fdb"
  -Error while trying to create file
  -Permission denied
  </code></pre>
  
  <p>If a change the 'tracker' directory to belong to the 'firebird' group then it creates the database, which makes sense, but since the firebird user belongs to the 'tracker' group, it shouldn't have any permission problems.</p>
  
  <p>What am I missing here?? </p>
  
  <p>I'm using Ubuntu and firebird 2.5.</p>
  
  <p>Thanks</p>