SQL error log can't create/write to fileWrite rows to CSV from SQL Server TriggerSQL Log, can I delete this file? SQLDump10000.txtCan't conect to SQL 2008 R2 Express with Encrypt connection checked (Microsoft SQL Server, Error: 11001)PC can't log into SQL Server on different peer networkERROR 1 (HY000): Can't create/write to file (Error code :13)Moving SQL Server 2008 R2 Logs Causing Access Denied ErrorDaily postgresql cron error log fileFlush Privileges in My SQL gives HY0000 Unknown ErrorWrite errors because two different users could create a log filemysqld: Can't create/write to file '/home/mysqltmp/ibXXX' Permission denied
Pressure inside an infinite ocean?
Is latino sine flexione dead?
String won't reverse using reverse_copy
Why doesn't WotC use established keywords on all new cards?
What was the design of the Macintosh II's MMU replacement?
What is the name of this hexagon/pentagon polyhedron?
Missing Piece of Pie - Can you find it?
Can there be a single technologically advanced nation, in a continent full of non-technologically advanced nations?
Should I mention being denied entry to UK due to a confusion in my Visa and Ticket bookings?
How do I overfit?
Would Hubble Space Telescope improve black hole image observed by EHT if it joined array of telesopes?
Can Infinity Stones be retrieved more than once?
I have a unique character that I'm having a problem writing. He's a virus!
Why Isn’t SQL More Refactorable?
Which module had more 'comfort' in terms of living space, the Lunar Module or the Command module?
Position of past participle and extent of the Verbklammer
Did we get closer to another plane than we were supposed to, or was the pilot just protecting our delicate sensibilities?
How was the quadratic formula created?
Why wasn't the Night King naked in S08E03?
How important is people skills in academic career and applications?
BOOM! Perfect Clear for Mr. T
What is the most remote airport from the center of the city it supposedly serves?
Why is "Vayechulu" said 3 times on Leil Shabbat?
What are the differences between credential stuffing and password spraying?
SQL error log can't create/write to file
Write rows to CSV from SQL Server TriggerSQL Log, can I delete this file? SQLDump10000.txtCan't conect to SQL 2008 R2 Express with Encrypt connection checked (Microsoft SQL Server, Error: 11001)PC can't log into SQL Server on different peer networkERROR 1 (HY000): Can't create/write to file (Error code :13)Moving SQL Server 2008 R2 Logs Causing Access Denied ErrorDaily postgresql cron error log fileFlush Privileges in My SQL gives HY0000 Unknown ErrorWrite errors because two different users could create a log filemysqld: Can't create/write to file '/home/mysqltmp/ibXXX' Permission denied
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I'm quite new to server administration but a keen learner, so if I miss anything or you need any extra info let me know and I'll do my best to provide it ASAP :)
I'm running WordPress on a developer plan VPS over at media temple (meaning I have root access, everything is managed by me etc). My OS is Fedora, Apache is latest version and am using MariaDB for MySQL.
When trying to read/write menus from the WP admin panel Apache writes this to its error log:
[Fri Dec 13 04:28:59.296672 2013] [:error] [pid 11195] [client (my IP, omitted)] WordPress database error Can't create/write to file '/var/tmp/#sql_1ff_0.MAI' (Errcode: 2) for query (**lots of different queries**)
This error repeats for about 20 different queries, and I've checked with perror that error code 2 for SQL means "No such file or directory".
I would contact my host about this problem, but as I said I'm on a developer plan meaning they won't help me with anything. Generally from Googling around I can find an answer or solution but in this case I've come up with nothing.
permissions sql
edited Dec 13 '13 at 12:28
MadHatter
70.6k11146207
asked Dec 13 '13 at 9:48
aaaaaa
62
add a comment |
I'm quite new to server administration but a keen learner, so if I miss anything or you need any extra info let me know and I'll do my best to provide it ASAP :)
I'm running WordPress on a developer plan VPS over at media temple (meaning I have root access, everything is managed by me etc). My OS is Fedora, Apache is latest version and am using MariaDB for MySQL.
When trying to read/write menus from the WP admin panel Apache writes this to its error log:
[Fri Dec 13 04:28:59.296672 2013] [:error] [pid 11195] [client (my IP, omitted)] WordPress database error Can't create/write to file '/var/tmp/#sql_1ff_0.MAI' (Errcode: 2) for query (**lots of different queries**)
This error repeats for about 20 different queries, and I've checked with perror that error code 2 for SQL means "No such file or directory".
I would contact my host about this problem, but as I said I'm on a developer plan meaning they won't help me with anything. Generally from Googling around I can find an answer or solution but in this case I've come up with nothing.
permissions sql
edited Dec 13 '13 at 12:28
MadHatter
70.6k11146207
asked Dec 13 '13 at 9:48
aaaaaa
62
add a comment |
I'm quite new to server administration but a keen learner, so if I miss anything or you need any extra info let me know and I'll do my best to provide it ASAP :)
I'm running WordPress on a developer plan VPS over at media temple (meaning I have root access, everything is managed by me etc). My OS is Fedora, Apache is latest version and am using MariaDB for MySQL.
When trying to read/write menus from the WP admin panel Apache writes this to its error log:
[Fri Dec 13 04:28:59.296672 2013] [:error] [pid 11195] [client (my IP, omitted)] WordPress database error Can't create/write to file '/var/tmp/#sql_1ff_0.MAI' (Errcode: 2) for query (**lots of different queries**)
This error repeats for about 20 different queries, and I've checked with perror that error code 2 for SQL means "No such file or directory".
I would contact my host about this problem, but as I said I'm on a developer plan meaning they won't help me with anything. Generally from Googling around I can find an answer or solution but in this case I've come up with nothing.
permissions sql
edited Dec 13 '13 at 12:28
MadHatter
70.6k11146207
asked Dec 13 '13 at 9:48
aaaaaa
62
I'm quite new to server administration but a keen learner, so if I miss anything or you need any extra info let me know and I'll do my best to provide it ASAP :)
I'm running WordPress on a developer plan VPS over at media temple (meaning I have root access, everything is managed by me etc). My OS is Fedora, Apache is latest version and am using MariaDB for MySQL.
When trying to read/write menus from the WP admin panel Apache writes this to its error log:
[Fri Dec 13 04:28:59.296672 2013] [:error] [pid 11195] [client (my IP, omitted)] WordPress database error Can't create/write to file '/var/tmp/#sql_1ff_0.MAI' (Errcode: 2) for query (**lots of different queries**)
This error repeats for about 20 different queries, and I've checked with perror that error code 2 for SQL means "No such file or directory".
I would contact my host about this problem, but as I said I'm on a developer plan meaning they won't help me with anything. Generally from Googling around I can find an answer or solution but in this case I've come up with nothing.
permissions sql
permissions sql
edited Dec 13 '13 at 12:28
MadHatter
70.6k11146207
asked Dec 13 '13 at 9:48
aaaaaa
62
edited Dec 13 '13 at 12:28
MadHatter
70.6k11146207
asked Dec 13 '13 at 9:48
aaaaaa
62
edited Dec 13 '13 at 12:28
MadHatter
70.6k11146207
edited Dec 13 '13 at 12:28
MadHatter
70.6k11146207
edited Dec 13 '13 at 12:28
MadHatter
70.6k11146207
70.6k11146207
asked Dec 13 '13 at 9:48
aaaaaa
62
asked Dec 13 '13 at 9:48
aaaaaa
62
asked Dec 13 '13 at 9:48
aaaaaa
62
62
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You can use the perror command to get an explanation on system errors:
~]$ perror 2
OS error code 2: No such file or directory
It may be that the directory /var/tmp/ does not exist.
Alternatively the WordPress MySQL user may not have been granted sufficient permissions to create files. You may need to GRANT FILE and/or CREATE TEMPORARY TABLES priviliges to the WordPress user. Refer to the the GRANT manual page.
answered Dec 13 '13 at 12:15
HBruijnHBruijn
57.3k1190153
1
Or the permissions on/var/tmpmay be wrong (should be 1777).
– MadHatter
Dec 13 '13 at 12:29
@HBruijn /var/tmp does exist (from root, that's where I presume you're referring to). Additionally, my WordPress MySQL user has access toFILEandCREATE TEMPORARY TABLESprivs. @MadHatter The permissions on /var/tmp are 1777 and I've even changed the ownership to mysql[27].
– aaa
Dec 13 '13 at 12:53
I would love to hear any other suggestions though, because I'm exhausted. I've spent over 18 hours researching and trying to fix this 1 stupid problem
– aaa
Dec 13 '13 at 12:57
1
More reasons not being able to write could be a full partition (df), read-only volume (mount) or possibly SELinux related (getenforce).
– HBruijn
Dec 13 '13 at 13:10
All mounts have loads of space, the file system is not read-only because I am able to create folders/files manually, and getenforce=disabled. This whole problem is getting to be a bit of a joke.. Would it be worth trying setting a tmpdir in my.cnf for SQL (I've tried once, yes I made sure mysql had permissions for the new directory but it still didnt work)? Is there any more detailed method of debugging this error to find out more info?
– aaa
Dec 13 '13 at 13:23
|
show 1 more comment
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
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%2fserverfault.com%2fquestions%2f561117%2fsql-error-log-cant-create-write-to-file%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 use the perror command to get an explanation on system errors:
~]$ perror 2
OS error code 2: No such file or directory
It may be that the directory /var/tmp/ does not exist.
Alternatively the WordPress MySQL user may not have been granted sufficient permissions to create files. You may need to GRANT FILE and/or CREATE TEMPORARY TABLES priviliges to the WordPress user. Refer to the the GRANT manual page.
answered Dec 13 '13 at 12:15
HBruijnHBruijn
57.3k1190153
1
Or the permissions on/var/tmpmay be wrong (should be 1777).
– MadHatter
Dec 13 '13 at 12:29
@HBruijn /var/tmp does exist (from root, that's where I presume you're referring to). Additionally, my WordPress MySQL user has access toFILEandCREATE TEMPORARY TABLESprivs. @MadHatter The permissions on /var/tmp are 1777 and I've even changed the ownership to mysql[27].
– aaa
Dec 13 '13 at 12:53
I would love to hear any other suggestions though, because I'm exhausted. I've spent over 18 hours researching and trying to fix this 1 stupid problem
– aaa
Dec 13 '13 at 12:57
1
More reasons not being able to write could be a full partition (df), read-only volume (mount) or possibly SELinux related (getenforce).
– HBruijn
Dec 13 '13 at 13:10
All mounts have loads of space, the file system is not read-only because I am able to create folders/files manually, and getenforce=disabled. This whole problem is getting to be a bit of a joke.. Would it be worth trying setting a tmpdir in my.cnf for SQL (I've tried once, yes I made sure mysql had permissions for the new directory but it still didnt work)? Is there any more detailed method of debugging this error to find out more info?
– aaa
Dec 13 '13 at 13:23
|
show 1 more comment
You can use the perror command to get an explanation on system errors:
~]$ perror 2
OS error code 2: No such file or directory
It may be that the directory /var/tmp/ does not exist.
Alternatively the WordPress MySQL user may not have been granted sufficient permissions to create files. You may need to GRANT FILE and/or CREATE TEMPORARY TABLES priviliges to the WordPress user. Refer to the the GRANT manual page.
answered Dec 13 '13 at 12:15
HBruijnHBruijn
57.3k1190153
1
Or the permissions on/var/tmpmay be wrong (should be 1777).
– MadHatter
Dec 13 '13 at 12:29
@HBruijn /var/tmp does exist (from root, that's where I presume you're referring to). Additionally, my WordPress MySQL user has access toFILEandCREATE TEMPORARY TABLESprivs. @MadHatter The permissions on /var/tmp are 1777 and I've even changed the ownership to mysql[27].
– aaa
Dec 13 '13 at 12:53
I would love to hear any other suggestions though, because I'm exhausted. I've spent over 18 hours researching and trying to fix this 1 stupid problem
– aaa
Dec 13 '13 at 12:57
1
More reasons not being able to write could be a full partition (df), read-only volume (mount) or possibly SELinux related (getenforce).
– HBruijn
Dec 13 '13 at 13:10
All mounts have loads of space, the file system is not read-only because I am able to create folders/files manually, and getenforce=disabled. This whole problem is getting to be a bit of a joke.. Would it be worth trying setting a tmpdir in my.cnf for SQL (I've tried once, yes I made sure mysql had permissions for the new directory but it still didnt work)? Is there any more detailed method of debugging this error to find out more info?
– aaa
Dec 13 '13 at 13:23
|
show 1 more comment
You can use the perror command to get an explanation on system errors:
~]$ perror 2
OS error code 2: No such file or directory
It may be that the directory /var/tmp/ does not exist.
Alternatively the WordPress MySQL user may not have been granted sufficient permissions to create files. You may need to GRANT FILE and/or CREATE TEMPORARY TABLES priviliges to the WordPress user. Refer to the the GRANT manual page.
answered Dec 13 '13 at 12:15
HBruijnHBruijn
57.3k1190153
You can use the perror command to get an explanation on system errors:
~]$ perror 2
OS error code 2: No such file or directory
It may be that the directory /var/tmp/ does not exist.
Alternatively the WordPress MySQL user may not have been granted sufficient permissions to create files. You may need to GRANT FILE and/or CREATE TEMPORARY TABLES priviliges to the WordPress user. Refer to the the GRANT manual page.
answered Dec 13 '13 at 12:15
HBruijnHBruijn
57.3k1190153
answered Dec 13 '13 at 12:15
HBruijnHBruijn
57.3k1190153
answered Dec 13 '13 at 12:15
HBruijnHBruijn
57.3k1190153
answered Dec 13 '13 at 12:15
HBruijnHBruijn
57.3k1190153
57.3k1190153
1
Or the permissions on/var/tmpmay be wrong (should be 1777).
– MadHatter
Dec 13 '13 at 12:29
@HBruijn /var/tmp does exist (from root, that's where I presume you're referring to). Additionally, my WordPress MySQL user has access toFILEandCREATE TEMPORARY TABLESprivs. @MadHatter The permissions on /var/tmp are 1777 and I've even changed the ownership to mysql[27].
– aaa
Dec 13 '13 at 12:53
I would love to hear any other suggestions though, because I'm exhausted. I've spent over 18 hours researching and trying to fix this 1 stupid problem
– aaa
Dec 13 '13 at 12:57
1
More reasons not being able to write could be a full partition (df), read-only volume (mount) or possibly SELinux related (getenforce).
– HBruijn
Dec 13 '13 at 13:10
All mounts have loads of space, the file system is not read-only because I am able to create folders/files manually, and getenforce=disabled. This whole problem is getting to be a bit of a joke.. Would it be worth trying setting a tmpdir in my.cnf for SQL (I've tried once, yes I made sure mysql had permissions for the new directory but it still didnt work)? Is there any more detailed method of debugging this error to find out more info?
– aaa
Dec 13 '13 at 13:23
|
show 1 more comment
1
Or the permissions on/var/tmpmay be wrong (should be 1777).
– MadHatter
Dec 13 '13 at 12:29
@HBruijn /var/tmp does exist (from root, that's where I presume you're referring to). Additionally, my WordPress MySQL user has access toFILEandCREATE TEMPORARY TABLESprivs. @MadHatter The permissions on /var/tmp are 1777 and I've even changed the ownership to mysql[27].
– aaa
Dec 13 '13 at 12:53
I would love to hear any other suggestions though, because I'm exhausted. I've spent over 18 hours researching and trying to fix this 1 stupid problem
– aaa
Dec 13 '13 at 12:57
1
More reasons not being able to write could be a full partition (df), read-only volume (mount) or possibly SELinux related (getenforce).
– HBruijn
Dec 13 '13 at 13:10
All mounts have loads of space, the file system is not read-only because I am able to create folders/files manually, and getenforce=disabled. This whole problem is getting to be a bit of a joke.. Would it be worth trying setting a tmpdir in my.cnf for SQL (I've tried once, yes I made sure mysql had permissions for the new directory but it still didnt work)? Is there any more detailed method of debugging this error to find out more info?
– aaa
Dec 13 '13 at 13:23
1
1
Or the permissions on
/var/tmp may be wrong (should be 1777).– MadHatter
Dec 13 '13 at 12:29
Or the permissions on
/var/tmp may be wrong (should be 1777).– MadHatter
Dec 13 '13 at 12:29
@HBruijn /var/tmp does exist (from root, that's where I presume you're referring to). Additionally, my WordPress MySQL user has access to
FILE and CREATE TEMPORARY TABLES privs. @MadHatter The permissions on /var/tmp are 1777 and I've even changed the ownership to mysql[27].– aaa
Dec 13 '13 at 12:53
@HBruijn /var/tmp does exist (from root, that's where I presume you're referring to). Additionally, my WordPress MySQL user has access to
FILE and CREATE TEMPORARY TABLES privs. @MadHatter The permissions on /var/tmp are 1777 and I've even changed the ownership to mysql[27].– aaa
Dec 13 '13 at 12:53
I would love to hear any other suggestions though, because I'm exhausted. I've spent over 18 hours researching and trying to fix this 1 stupid problem
– aaa
Dec 13 '13 at 12:57
I would love to hear any other suggestions though, because I'm exhausted. I've spent over 18 hours researching and trying to fix this 1 stupid problem
– aaa
Dec 13 '13 at 12:57
1
1
More reasons not being able to write could be a full partition (
df), read-only volume (mount) or possibly SELinux related (getenforce).– HBruijn
Dec 13 '13 at 13:10
More reasons not being able to write could be a full partition (
df), read-only volume (mount) or possibly SELinux related (getenforce).– HBruijn
Dec 13 '13 at 13:10
All mounts have loads of space, the file system is not read-only because I am able to create folders/files manually, and getenforce=disabled. This whole problem is getting to be a bit of a joke.. Would it be worth trying setting a tmpdir in my.cnf for SQL (I've tried once, yes I made sure mysql had permissions for the new directory but it still didnt work)? Is there any more detailed method of debugging this error to find out more info?
– aaa
Dec 13 '13 at 13:23
All mounts have loads of space, the file system is not read-only because I am able to create folders/files manually, and getenforce=disabled. This whole problem is getting to be a bit of a joke.. Would it be worth trying setting a tmpdir in my.cnf for SQL (I've tried once, yes I made sure mysql had permissions for the new directory but it still didnt work)? Is there any more detailed method of debugging this error to find out more info?
– aaa
Dec 13 '13 at 13:23
|
show 1 more comment
Thanks for contributing an answer to Server Fault!
- 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%2fserverfault.com%2fquestions%2f561117%2fsql-error-log-cant-create-write-to-file%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
