Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
4
Heyas,
I have an issue that I need resovled quickly and I have tried many things.
I am trying to put an OUTFILE into a directory that has full permissions for MySQL and Apache and I am unable to do so. the query is being called from PHP, so gave Apache permissions to access the directory, but it didn't work.
Error Code 13
Can anyone help me please?
6 replies to this topic
Back to top|
|
|
#2
Posted 19 September 2010 - 10:37 PM
dbug
-
- Members
-
- 155 posts
Programmer
Error 13 is permission denied. If you don't show us something where we can see exactly what are you doing it's very hard to know what could be happening. Without more information, the simplest answer is that you are trying to write where you can't.
#3
Posted 20 September 2010 - 02:06 AM
gokuajmes
-
- Members
-
- 518 posts
Programming God
So dBug is on a posting spree, Good to know CodeCall's got some awesome new members
#4
Posted 20 September 2010 - 06:47 PM
Drew
-
- Members
-
- 42 posts
Learning Programmer
I am simply calling '... OUTFILE /directory/directory/mysql/filename.csv ...'
What else is there needing to be known other than what I posted?
I told who has permissions on the folder, as well as what is using the proceedure to create the file, and the fact that it was forbidding the creation due to to permissions by me saying that I gave Apache and MySQL both permissions to access the folder.
If there is something that I am missing from my description, then please, let me know what you need to know.
Because it's a permission issue, I don't know what's wrong, because I changed permissions to allow everything to use it that could access the folder, but it still couldn't create the file because permissions were denied.
Gokuajmes,
there may be people on a posting spree, but wether they actually read the previous post, and don't post back with nothing to help, or querying when there is nothing to query by asking what I have already written, then they are not really helping much. Since I can't provide more information than what I have already given, due to the fact that there isn't anything else to say, I don't understand what they are trying to ask me for.
dbug,
Could you please provide me with specifications as to the information that you require from me to assist me with this issue?
What else is there needing to be known other than what I posted?
I told who has permissions on the folder, as well as what is using the proceedure to create the file, and the fact that it was forbidding the creation due to to permissions by me saying that I gave Apache and MySQL both permissions to access the folder.
If there is something that I am missing from my description, then please, let me know what you need to know.
Because it's a permission issue, I don't know what's wrong, because I changed permissions to allow everything to use it that could access the folder, but it still couldn't create the file because permissions were denied.
Gokuajmes,
there may be people on a posting spree, but wether they actually read the previous post, and don't post back with nothing to help, or querying when there is nothing to query by asking what I have already written, then they are not really helping much. Since I can't provide more information than what I have already given, due to the fact that there isn't anything else to say, I don't understand what they are trying to ask me for.
dbug,
Could you please provide me with specifications as to the information that you require from me to assist me with this issue?
#5
Posted 20 September 2010 - 11:52 PM
dbug
-
- Members
-
- 155 posts
Programmer
You say you have done everything well, but it doesn't work. The error message says that there is a problem with permissions. You say that you have set all the permissions correctly. I can't say anything else.
There are a lot of ways of generating and copying data to some place. If I don't know how are you doing this, I can't help.
There are a lot of ways of generating and copying data to some place. If I don't know how are you doing this, I can't help.
#6
Posted 21 September 2010 - 12:41 AM
Alexander
-
- Moderators
-
- 4,118 posts
It's Science!
- Location:Vancouver, Eh! Cleverness: 200
What are the results of `ls -ld` in each of the directories the PHP script is running in, and you are copying to? It's useless to assume when you can check if permissions and owners are what you said they are.
This is more helpful then "it gives me an error".
This is more helpful then "it gives me an error".
Be sure to read the updated FAQ! || Health is achieved through the same 10,000 steps.
If a suggested code/method fails, informing us is less important than telling us why or what errors occurred.
If a suggested code/method fails, informing us is less important than telling us why or what errors occurred.
#7
Posted 21 September 2010 - 04:28 PM
Drew
-
- Members
-
- 42 posts
Learning Programmer
Hiya Null
If you read my first post, I have given full permissions to both MySQL AND Apache.
Owner as MySQL and Apache as Group.
The permissions are set to 775 on the directories.
Where the script is running is just Apache Web Server access allowed, because that's only where the script is being executed.
Is there anything else you would need to know Null?
Sincerely,
Drew.
dbug,
I told you what you are querying there.
The fact that you are asking what you are asking means that you must not have read what I wrote.
If you read my first post, I have given full permissions to both MySQL AND Apache.
Owner as MySQL and Apache as Group.
The permissions are set to 775 on the directories.
Where the script is running is just Apache Web Server access allowed, because that's only where the script is being executed.
Is there anything else you would need to know Null?
Sincerely,
Drew.
dbug,
I told you what you are querying there.
The fact that you are asking what you are asking means that you must not have read what I wrote.
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
