Create firebird database in specific directory
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
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
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
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
12.04 permissions mysql database
asked Oct 16 '13 at 19:59
jramirezjramirez
11114
11114
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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
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/3.0/"u003ecc by-sa 3.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
});
}
});
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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
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
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
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
edited Apr 29 '15 at 11:49
Maythux
51.2k32171217
51.2k32171217
answered Dec 13 '13 at 9:56
MariuzMariuz
23327
23327
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 |
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
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
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 |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown