This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

#1290 - The MySQL server is running with the --secure-file-priv
#1
#1290 - The MySQL server is running with the --secure-file-priv
HI Guys,

Trying to issue the following command

Code:
LOAD DATA INFILE '/var/sentora/hostdata/lairdexpertit/public_html/lairdexpertit_com/phonestats/csv/north.csv' INTO TABLE `north` FIELDS TERMINATED BY ',' ENCLOSED BY '\"' IGNORE 1 LINES


get the following error.

Code:
HostingSec advises against use of Sentora - The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

I do need this function any fixs please?
Reply
Thanks given by:
#2
RE: #1290 - The MySQL server is running with the --secure-file-priv
Can you use the LOAD DATA LOCAL INFILE ? Would that work for you?
My Sentora Resources
[Module] Mail Quota Count | Vagrant Box with Sentora

[Image: vanguardly-logo-micro.png]
Graphic and Web Design. Development.
www.vanguardly.com


Reply
Thanks given by:
#3
RE: #1290 - The MySQL server is running with the --secure-file-priv
LOCAL looks as though it will work ill have to alter my script to incorporate this
Reply
Thanks given by:
#4
RE: #1290 - The MySQL server is running with the --secure-file-priv
(06-15-2015, 06:05 PM)txt3rob Wrote: LOCAL looks as though it will work ill have to alter my script to incorporate this

You will have to either change your script or change Sentora.

Personally I would change the script as most web hosting servers are blacklisting the command for security reasons.

It's up to you Smile
My Sentora Resources
[Module] Mail Quota Count | Vagrant Box with Sentora

[Image: vanguardly-logo-micro.png]
Graphic and Web Design. Development.
www.vanguardly.com


Reply
Thanks given by:
#5
RE: #1290 - The MySQL server is running with the --secure-file-priv
secure-file privilege is security feature that MySQL need otherwise any mysql user will be able to drop files everywhere and you can then feel the pain.

Don't ever mess up with this feature.

What would preven any user in the server to do the same and grave any file in the server? That would be bad no?

M B
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask

10$ free to start your VPS
Reply
Thanks given by:
#6
RE: #1290 - The MySQL server is running with the --secure-file-priv
my server isnt hosting any one else's data apart my own.

any way i can turn off the secure priv as it's messing with my stats import unless any one has a way to import 20 .csv's each day to a mysqldb
Reply
Thanks given by:
#7
RE: #1290 - The MySQL server is running with the --secure-file-priv
Why you cant just edit the script?

This is not even a Sentora issue.

Also, if you are just hosting your files why use sentora? :\ I don't get it.
My Sentora Resources
[Module] Mail Quota Count | Vagrant Box with Sentora

[Image: vanguardly-logo-micro.png]
Graphic and Web Design. Development.
www.vanguardly.com


Reply
Thanks given by:
#8
RE: #1290 - The MySQL server is running with the --secure-file-priv
(06-17-2015, 10:30 PM)txt3rob Wrote: my server isnt hosting any one else's data apart my own.

any way i can turn off the secure priv as it's messing with my stats import unless any one has a way to import 20 .csv's each day to a mysqldb

In cas of a website hack. It can be used to escalate privilege easily. This is not even about you are the only user.

M B
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask

10$ free to start your VPS
Reply
Thanks given by: apinto


Possibly Related Threads…
Thread Author Replies Views Last Post
Server Crash rsthomas 3 7 ,963 05-18-2022, 09:26 AM
Last Post: Nigel
How to set up File Manger for Sentora? donaldaugust 1 3 ,784 01-11-2022, 05:01 AM
Last Post: Nigel
Server Vs. Workstation zHostingSolutions 4 9 ,188 09-14-2021, 06:30 AM
Last Post: sparkrack

Forum Jump:


Users browsing this thread: 2 Guest(s)