Bsrgvty

Why are there never-ending wars in the Middle East?

How would a race of humanoids with tails design [vehicle] seats?

Will my familiar remember me when I re-summon it, or is it a new entity?

Is rent considered a debt?

Repair drywall and protect wires on back of electrical panel

Is this really played by 2200+ players?

Replacing each letter with the letter that is in the corresponding position from the end of the English alphabet

Are there any Baryons that have quark-antiquark combinations?

How to include conditional statements in NIntegrate?

Make a list of Fibonacci numbers less than 1000, whose index is in the form 3m+1. Verify that all these numbers are odd

Do neurons of a neural network model a linear relationship?

Matrix class in C#

What's the safest shape for homemade hard-candy

Which person is telling the truth?

Vertical Yagi spun at 1000 RPM: gain properties?

Should I respond to a sabotage accusation e-mail at work?

Why didn't Aboriginal Australians discover agriculture?

What does "he was equally game to slip into bit parts" mean?

10x10 grid with no unpainted hexominoes

How to run fortran77 program with inputs from file?

Automatically creating table with borders

For piano scales, should I let go of the previous key before I hit the next one?

Remove x last elements of an array and reinsert them before position y

What are the advantages to banks being located in the City of London (the Square Mile)?

Create firebird database in specific directory

Directory permissionHow to install Oracle Database 11g Express Edition on Ubuntu 12.10?MyISAM problem after moving datadir of a MySQL databaseUser in sudo group cannot perform sudo operationsMysql Error SQLSTATE[HY000] [1045] Access denied for user. While installing Drupal 7 in localhostusers in group can not create filesuser cannot open a specific directoryPermission denied after trying to create mysqldump, even after creating .my.cnf file

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;

2

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.

firebird@ubuntu:/$ groups firebird
firebird tracker

I created a main directory called 'tracker'

drwxrwx--- 3 me tracker 4096 Oct 16 10:40 tracker

Inside the 'tracker' directory I created an 'fdb' directory where I want the firebird DB's to be created.

drwxrwx--- 2 firebird firebird 4096 Oct 16 11:35 fdb

Now when I try to create the database using the following command:

CREATE DATABASE 'localhost:/tracker/fdb/test.fdb' page_size 8192 user 'SYSDBA' password 'foobar' DEFAULT CHARACTER SET UTF8;

I get the following error:

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

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.

What am I missing here??

I'm using firebird 2.5.

Thanks

12.04 permissions mysql database

share|improve this question

asked Oct 16 '13 at 19:59

jramirezjramirez

11111 silver badge44 bronze badges

add a comment
 | 

2

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.

firebird@ubuntu:/$ groups firebird
firebird tracker

I created a main directory called 'tracker'

drwxrwx--- 3 me tracker 4096 Oct 16 10:40 tracker

Inside the 'tracker' directory I created an 'fdb' directory where I want the firebird DB's to be created.

drwxrwx--- 2 firebird firebird 4096 Oct 16 11:35 fdb

Now when I try to create the database using the following command:

CREATE DATABASE 'localhost:/tracker/fdb/test.fdb' page_size 8192 user 'SYSDBA' password 'foobar' DEFAULT CHARACTER SET UTF8;

I get the following error:

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

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.

What am I missing here??

I'm using firebird 2.5.

Thanks

12.04 permissions mysql database

share|improve this question

asked Oct 16 '13 at 19:59

jramirezjramirez

11111 silver badge44 bronze badges

add a comment
 | 

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.

firebird@ubuntu:/$ groups firebird
firebird tracker

I created a main directory called 'tracker'

drwxrwx--- 3 me tracker 4096 Oct 16 10:40 tracker

Inside the 'tracker' directory I created an 'fdb' directory where I want the firebird DB's to be created.

drwxrwx--- 2 firebird firebird 4096 Oct 16 11:35 fdb

Now when I try to create the database using the following command:

CREATE DATABASE 'localhost:/tracker/fdb/test.fdb' page_size 8192 user 'SYSDBA' password 'foobar' DEFAULT CHARACTER SET UTF8;

I get the following error:

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

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.

What am I missing here??

I'm using firebird 2.5.

Thanks

12.04 permissions mysql database

share|improve this question

asked Oct 16 '13 at 19:59

jramirezjramirez

11111 silver badge44 bronze badges

firebird@ubuntu:/$ groups firebird
firebird tracker

drwxrwx--- 3 me tracker 4096 Oct 16 10:40 tracker

drwxrwx--- 2 firebird firebird 4096 Oct 16 11:35 fdb

CREATE DATABASE 'localhost:/tracker/fdb/test.fdb' page_size 8192 user 'SYSDBA' password 'foobar' DEFAULT CHARACTER SET UTF8;

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

share|improve this question

asked Oct 16 '13 at 19:59

jramirezjramirez

11111 silver badge44 bronze badges

share|improve this question

asked Oct 16 '13 at 19:59

jramirezjramirez

11111 silver badge44 bronze badges

asked Oct 16 '13 at 19:59

jramirezjramirez

11111 silver badge44 bronze badges

asked Oct 16 '13 at 19:59

jramirezjramirez

11111 silver badge44 bronze badges

1 Answer
1

active

oldest

votes

0

You can try first with firebird user if you can create a file in that directory

sudo su firebird

also you might check DatabaseAccess in firebird.conf , but by default it should be Full

share|improve this answer

edited Apr 29 '15 at 11:49

Maythux

55.4k3535 gold badges188188 silver badges230230 bronze badges

answered Dec 13 '13 at 9:56

MariuzMariuz

23322 silver badges77 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I did that and yes I can create a file in that directory. I will check DatabaseAccess. Thanks for the response.
  
  – jramirez
  Dec 17 '13 at 0:01
  

  
  
  
  

add a comment
 | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "89"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f360000%2fcreate-firebird-database-in-specific-directory%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You can try first with firebird user if you can create a file in that directory

sudo su firebird

also you might check DatabaseAccess in firebird.conf , but by default it should be Full

share|improve this answer

edited Apr 29 '15 at 11:49

Maythux

55.4k3535 gold badges188188 silver badges230230 bronze badges

answered Dec 13 '13 at 9:56

MariuzMariuz

23322 silver badges77 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I did that and yes I can create a file in that directory. I will check DatabaseAccess. Thanks for the response.
  
  – jramirez
  Dec 17 '13 at 0:01
  

  
  
  
  

add a comment
 | 

0

You can try first with firebird user if you can create a file in that directory

sudo su firebird

also you might check DatabaseAccess in firebird.conf , but by default it should be Full

share|improve this answer

edited Apr 29 '15 at 11:49

Maythux

55.4k3535 gold badges188188 silver badges230230 bronze badges

answered Dec 13 '13 at 9:56

MariuzMariuz

23322 silver badges77 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I did that and yes I can create a file in that directory. I will check DatabaseAccess. Thanks for the response.
  
  – jramirez
  Dec 17 '13 at 0:01
  

  
  
  
  

add a comment
 | 

You can try first with firebird user if you can create a file in that directory

sudo su firebird

also you might check DatabaseAccess in firebird.conf , but by default it should be Full

share|improve this answer

edited Apr 29 '15 at 11:49

Maythux

55.4k3535 gold badges188188 silver badges230230 bronze badges

answered Dec 13 '13 at 9:56

MariuzMariuz

23322 silver badges77 bronze badges

share|improve this answer

edited Apr 29 '15 at 11:49

Maythux

55.4k3535 gold badges188188 silver badges230230 bronze badges

answered Dec 13 '13 at 9:56

MariuzMariuz

23322 silver badges77 bronze badges

edited Apr 29 '15 at 11:49

Maythux

55.4k3535 gold badges188188 silver badges230230 bronze badges

edited Apr 29 '15 at 11:49

Maythux

55.4k3535 gold badges188188 silver badges230230 bronze badges

answered Dec 13 '13 at 9:56

MariuzMariuz

23322 silver badges77 bronze badges

answered Dec 13 '13 at 9:56

MariuzMariuz

23322 silver badges77 bronze badges