Skip to content

"ERROR 1148 (42000) at line 1: The used command is not allowed with this MySQL version" after upgrade percona version 5.5.35-33.0 to 5.5.36-34.2

So the setup is the following, debian squeeze and percona version 5.5.35-33.0.
I had done an upgrade from 5.5.35-33.0 to 5.5.36-34.2-648.squeeze and the following error created an red monitor on my jenkins.

ERROR 1148 (42000) at line 1: The used command is not allowed with this MySQL version

After searching on the web, i found this entry on the web.
sudo vim /etc/mysql/my.cnf
# add follwing entry to fitting locations
[mysql]
local-infile=1
[mysqld]
local-infile=1 # /etc/init.d/mysql restart

Get your current used version?
# mysql --user=root --password=
SHOW VARIABLES LIKE "%version%";

Check if changes are working?
# mysql --user=root --password=
SHOW VARIABLES LIKE '%local%';

raspberry pi, xbmc and the new amazon prime

Since amazon bundles its prime with the video steaming, i wanted to check if i can use my raspberry pi with this amazon service also. I searched for some howtos on the web but only found outdated entries.
At the end, it turned out it was working in the past and it is working in the present for windows pcs with a lot of horsepower under the hood. Since amazon bundles a lot of DRM-sh*t, it is impossible to get something done on a pi so far.