luarocks install --local lsqlite3 - Access Denied You appear to be a robot. from lua.sqlite.org

[barzakov]

[root@hoi ~]# uptime
 08:58:19 up 3 min,  1 user,  load average: 0.29, 0.27, 0.11
[root@hoi ~]# dnf install epel-release -yq
Importing GPG key 0x1D997668:
 Userid     : "CentOS Extras SIG (https://wiki.centos.org/SpecialInterestGroup) <security@centos.org>"
 Fingerprint: 363F C097 2F64 B699 AED3 968E 1FF6 A217 1D99 7668
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-Extras-SHA512

Installed:
  epel-next-release-9-7.el9.noarch                                                                                                         epel-release-9-7.el9.noarch                                                                                                        

[root@hoi ~]# dnf config-manager --set-enabled crb
[root@hoi ~]# dnf install gcc make sqlite-devel lua lua-devel luarocks -yq
Importing GPG key 0x3228467C:
 Userid     : "Fedora (epel9) <epel@fedoraproject.org>"
 Fingerprint: FF8A D134 4597 106E CE81 3B91 8A38 72BF 3228 467C
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-9

Upgraded:
  libgcc-11.5.0-11.el9.x86_64                                                                                                           libgomp-11.5.0-11.el9.x86_64                                                                                                          
Installed:
  cpp-11.5.0-11.el9.x86_64                    gcc-11.5.0-11.el9.x86_64        glibc-devel-2.34-223.el9.x86_64       glibc-headers-2.34-223.el9.x86_64      kernel-headers-5.14.0-611.el9.x86_64      libmpc-1.2.1-4.el9.x86_64        libpkgconf-1.7.3-10.el9.x86_64     
  libxcrypt-devel-4.4.18-3.el9.x86_64         lua-5.4.4-4.el9.x86_64          lua-devel-5.4.4-4.el9.x86_64          luarocks-3.9.2-5.el9.noarch            make-1:4.3-8.el9.x86_64                   pkgconf-1.7.3-10.el9.x86_64      pkgconf-m4-1.7.3-10.el9.noarch     
  pkgconf-pkg-config-1.7.3-10.el9.x86_64      sqlite-3.34.1-8.el9.x86_64      sqlite-devel-3.34.1-8.el9.x86_64      unzip-6.0-59.el9.x86_64                zip-3.0-35.el9.x86_64                    

[root@hoi ~]# lua -v
luarocks --version
Lua 5.4.4  Copyright (C) 1994-2022 Lua.org, PUC-Rio
/bin/luarocks 3.9.2
LuaRocks main command-line interface

[root@hoi ~]# luarocks install --local lsqlite3

Error: The --local flag is meant for operating in a user's home directory.
You are running as a superuser, which is intended for system-wide operation.
To force using the superuser's home, use --tree explicitly.
[root@hoi ~]# useradd -m hoi
[root@hoi ~]# su - hoi
[hoi@hoi ~]$ luarocks install --local lsqlite3
Installing https://luarocks.org/lsqlite3-0.9.6-1.rockspec

Error: Failed extracting /tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-K3dKbe/lsqlite3_v096.zip: failed extracting /tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-K3dKbe/lsqlite3_v096.zip
[hoi@hoi ~]$ 
[hoi@hoi ~]$ luarocks install --local lsqlite3 --verbose 2>/dev/null |grep  'lsqlite3_v096.zip'
fs.download("https://lua.sqlite.org/home/zip/lsqlite3_v096.zip?uuid=v0.9.6", "lsqlite3_v096.zip", nil)
fs.use_downloader("https://lua.sqlite.org/home/zip/lsqlite3_v096.zip?uuid=v0.9.6", "lsqlite3_v096.zip", nil)
fs.absolute_name("lsqlite3_v096.zip")
fs.Q("https://lua.sqlite.org/home/zip/lsqlite3_v096.zip?uuid=v0.9.6")
fs.Q("/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip")
fs.quiet_stderr("curl -k -f -L --user-agent \"LuaRocks/3.9.2 linux-x86_64 via curl\" --connect-timeout 30 'https://lua.sqlite.org/home/zip/lsqlite3_v096.zip?uuid=v0.9.6' --output '/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip'")
fs.execute_string("curl -k -f -L --user-agent \"LuaRocks/3.9.2 linux-x86_64 via curl\" --connect-timeout 30 'https://lua.sqlite.org/home/zip/lsqlite3_v096.zip?uuid=v0.9.6' --output '/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip' 2> /dev/null")
fs.command_at("/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg", "curl -k -f -L --user-agent \"LuaRocks/3.9.2 linux-x86_64 via curl\" --connect-timeout 30 'https://lua.sqlite.org/home/zip/lsqlite3_v096.zip?uuid=v0.9.6' --output '/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip' 2> /dev/null")
os.execute: 	cd '/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg' && curl -k -f -L --user-agent "LuaRocks/3.9.2 linux-x86_64 via curl" --connect-timeout 30 'https://lua.sqlite.org/home/zip/lsqlite3_v096.zip?uuid=v0.9.6' --output '/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip' 2> /dev/null
fs.unpack_archive("lsqlite3_v096.zip")
fs.absolute_name("lsqlite3_v096.zip")
fs.unzip("/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip")
fs.execute_quiet("unzip -n", "/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip")
fs.Q("/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip")
fs.execute_string("unzip -n '/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip'")
fs.command_at("/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg", "unzip -n '/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip'")
os.execute: 	cd '/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg' && unzip -n '/tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip'
Archive:  /tmp/luarocks_luarocks-source-lsqlite3-0.9.6-1-J43tUg/lsqlite3_v096.zip


[hoi@hoi ~]$ curl -k -f -L --user-agent \"LuaRocks/3.9.2 linux-x86_64 via curl\" --connect-timeout 30 'https://lua.sqlite.org/home/zip/lsqlite3_v096.zip?uuid=v0.9.6'  2>/dev/null|grep "Access\|robot"
<h1 id="x1">Checking to see if you are a robot<span id="x2"></span></h1>
<span id="x7" style="visibility:hidden;">You appear to be a robot.</span></p>
function aaa(x){return document.getElementById(x);}function bbb(h,a){aaa("x4").value=h;if((a%75)==0){aaa("x2").textContent=aaa("x2").textContent+".";}var z;if(a>0){setTimeout(bbb,1,h+a,a-1);}else if((z=window.getComputedStyle(document.body).zIndex)==='0'||z===0){aaa("x3").style.visibility="visible";aaa("x2").textContent="";aaa("x1").textContent="All clear";aaa("x6").onsubmit=function(){aaa("x3").style.visibility="hidden";};aaa("x5").focus();}else{aaa("x7").style.visibility="visible";aaa("x2").textContent="";aaa("x3").style.display="none";aaa("x1").textContent="Access Denied";}}function ccc(a,b,c){return (a*852+b)*1006+c;}window.addEventListener('load',function(){bbb(ccc(145,763,10),477);},false);

[barzakov]

I also submit issue in :
http://lua.sqlite.org/home/tktview/d5edf03a23bf038ba2fe2531b7899fea702d254c

[bhhaskin]

This is pretty dumb. It breaks any CI and makes the package useless. I get that bots can be an issue for small hosts with limited resources, but there are better ways to handle it.

[bhhaskin]

For anyone who finds this in the future here is a working package:

https://luarocks.org/modules/bhhaskin/lsqlite3complete
https://github.com/bhhaskin/lsqlite3complete/tree/0.9.6-1

@javierguerragiraldez It might be best to do the same thing with the official package and remove the dependency from lua.sqlite.org all together.

@barzakov feel free to use.

[barzakov]

Thank you, unfortunately I will have to wait for official package.

[bhhaskin]

@barzakov no worries! Hopefully it gets resolved soon.

Here is lsqlite3 as well

https://luarocks.org/modules/bhhaskin/lsqlite3
https://github.com/bhhaskin/lsqlite3/releases/tag/0.9.6-1

[barzakov]

Thank you very much for your time and effort in helping to resolve this issue.