Problems and Doubts with Mysql

kensai · 2013-03-09 02:27:28

Hi guys,

I'm here again because I have one problem and one doubt.

1. I use my web server running archlinux64 of course, to host an Electronic Health Record called OpenEMR. The thing is it has a feature where it loads some files and install them automatically, which are the ICD9 and ICD10 codes health care providers need. Well, I configured my /etc/mysql/my.cnf to enable local-infile which this procedures need because what it does is query a Load Data Local Infile to retrieve and install this files, but every time I try to install this codes it spits out an error.

/etc/mysql/my.cnf wrote:

# The MySQL server
[mysqld]
port = 3306
socket = /run/mysqld/mysqld.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
local-infile
## Further down
[mysql]
auto-rehash
local-infile

and the error I get from trying to use load data local infile

ERROR: query failed: LOAD DATA LOCAL INFILE '/tmp/ICD9/CMS30_DESC_LONG_SG.txt' INTO TABLE icd9_sg_long_code FIELDS TERMINATED BY '' (@var) SET revision = 0, sg_code = trim(Substring(@var, 1, 4)),long_desc = trim(Substring(@var, 6, 300))
Error: The used command is not allowed with this MySQL version

2. I see this warning somewhere else in the web application

Your PHP MySQL library version mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $ differs from your MySQL server version 5.5.30. This may cause unpredictable behavior.

Do I have to worry about this one, is it ok?

- Thanks in advance guys

Last edited by kensai (2013-03-09 02:28:43)

litemotiv · 2013-03-09 09:33:29

kensai wrote:

# The MySQL server
[mysqld]
port            = 3306
socket          = /run/mysqld/mysqld.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
local-infile
## Further down
[mysql]
auto-rehash
local-infile
and the error I get from trying to use load data local infile
ERROR: query failed: LOAD DATA LOCAL INFILE '/tmp/ICD9/CMS30_DESC_LONG_SG.txt' INTO TABLE icd9_sg_long_code FIELDS TERMINATED BY '' (@var) SET revision = 0, sg_code = trim(Substring(@var, 1, 4)),long_desc = trim(Substring(@var, 6, 300))
Error: The used command is not allowed with this MySQL version

Slightly silly question, but did you restart Mysql after making your config changes? Also, this seems to suggest it could make a difference in which order Apache and Mysql are started for this to work.

2. I see this warning somewhere else in the web application
Your PHP MySQL library version mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $ differs from your MySQL server version 5.5.30. This may cause unpredictable behavior.
Do I have to worry about this one, is it ok?

The php-mysql native driver is a bit old, is your system up to date? I don't think it's likely that the 'not allowed' error is caused by it though...

kensai · 2013-03-09 13:42:46

1. Yeah, I have tried resetting the services even in different orders and nothing seems to fix it, is like there is something missing for load data local infile to be enabled. But all I have searched and read indicated that the change I made to my.cnf is all I need. That is very strange.

2. Well, all I have found it doesn't cause problems, and yes my system is up to date.

kensai · 2013-03-09 22:38:43

I uploaded the codes manually, but I'm still puzzled as to why load data local infile query can't be activated on Arch Linux, anyone that uses MYSQL and has local-infile enabled and working fine?

Arch Linux

#1 2013-03-09 02:27:28

Problems and Doubts with Mysql

#2 2013-03-09 09:33:29

Re: Problems and Doubts with Mysql

#3 2013-03-09 13:42:46

Re: Problems and Doubts with Mysql

#4 2013-03-09 22:38:43

Re: Problems and Doubts with Mysql

Board footer