[CWB] Error # 1290 when trying to build metadata from file

[Hardie, Andrew]

Hmm, this is interesting. You are quite right that the correct thing to do is to disable secure_file_priv. I'm not sure why that didn't work for you. Did you restart the mysql daemon after changing the my.cnf file? The config file is only read at daemon startup.

I'll make sure to add a note on this to the manual along with all the other possible MySQL gotchas.

best

Andrew.

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Jiayue Wang
Sent: 01 December 2018 09:31
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: [CWB] Error # 1290 when trying to build metadata from file

Hi

I installed a new corpus successfully, but when I tried to "automatically run frequency-list setup" by selecting a metadata file, cqpweb threw the following message:


A MySQL query did not run successfully!


Original query: LOAD DATA INFILE
'/home/arthur/CWB_folders/temp/___install_temp_fxrd8ho8yc' INTO TABLE `text_metadata_for_bjl_corpus` FIELDS ESCAPED BY '' /* from User: admin 
| Function: create_text_metadata_from_file() | 2018-Dec-01 09:19:47 */


Error # 1290: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement


It seems that the error msg isn't related with the metadata file, for it 
is well-formed. I searched the internet for the 1290 error, but couldn't 
figure out what the lot of help means. In the ~/.my.cnf file I added the 
following:

[mysqld]
secure_file_priv               = ''

But the problems is still there.

Please help, thanks

Jiayue
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://liste.sslmit.unibo.it/mailman/listinfo/cwb