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

[Hardie, Andrew]

(and if all else fails just use the $mysql_has_file_access config variable - set to false, and an alternate mechanism will be used for reading files to the mysql daemon)

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Hardie, Andrew
Sent: 03 December 2018 05:39
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: Re: [CWB] Error # 1290 when trying to build metadata from file

You could try seeing what the setting of secure_file_priv is via the mysql client. (SHOW VARIABLES LIKE "secure_file_priv";)

You could also see if --secure-file-priv is specified in the startup command for mysqld. I *think* that would override the conf file.

Another possibility, maybe an additional config file is being read that overrides your change. The startup command for mysqld will show this (and/or include commands in  files within /etc/mysql/.) 

best

Andrew.


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

Thanks Andrew, I did restart mysql after editing .my.cnf, no luck. I also tried reinstalling the corpus. Is it possible to guess what the problem is by reading the error message? (I'm using v3.2.30 on Linux Mint 19, but it seems to be a MySQL problem though) Jiayue

On 12/3/18 3:54 AM, Hardie, Andrew wrote:
> 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
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
> 

--
College of Foreign Studies,
Guangxi University For Nationalities
Nanning, China 530006


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