Need help testing and working through an ecto3 and sqlite adapter

I got this error:

==> exqlite
mkdir -p /tmp/mix_installs/elixir-1.12.0-dev-erts-12.0/d3fdf3d0ae84916ee0aaf0dc561b4c17/_build/dev/lib/exqlite/priv
make: *** Brak reguł do zrobienia obiektu 'sqlite3/sqlite3.c', wymaganego przez '/tmp/mix_installs/elixir-1.12.0-dev-erts-12.0/
d3fdf3d0ae84916ee0aaf0dc561b4c17/_build/dev/lib/exqlite/priv/sqlite3_nif.so'. Stop.
could not compile dependency :exqlite, "mix compile" failed. You can recompile this dependency with "mix deps.compile exqlite",
update it with "mix deps.update exqlite" or clean it with "mix deps.clean exqlite"                                             
** (Mix.Error) Could not compile with "make" (exit status: 2).
You need to have gcc and make installed. If you are using
Ubuntu or any other Debian-based system, install the packages
"build-essential". Also install "erlang-dev" package if not
included in your Erlang/OTP version. If you're on Fedora, run
"dnf group install 'Development Tools'".

(mix 1.12.0-dev) lib/mix.ex:452: Mix.raise/2
(elixir_make 0.6.2) lib/mix/tasks/compile.make.ex:143: Mix.Tasks.Compile.ElixirMake.run/1
(mix 1.12.0-dev) lib/mix/task.ex:394: Mix.Task.run_task/3
(mix 1.12.0-dev) lib/mix/tasks/compile.all.ex:90: Mix.Tasks.Compile.All.run_compiler/2
(mix 1.12.0-dev) lib/mix/tasks/compile.all.ex:70: Mix.Tasks.Compile.All.compile/4
(mix 1.12.0-dev) lib/mix/tasks/compile.all.ex:57: Mix.Tasks.Compile.All.with_logger_app/2
(mix 1.12.0-dev) lib/mix/tasks/compile.all.ex:35: Mix.Tasks.Compile.All.run/1
(mix 1.12.0-dev) lib/mix/task.ex:394: Mix.Task.run_task/3

Then tried to run make manually:

$ LC_ALL=en MIX_APP_PATH=. make clean all
rm -f ./priv/sqlite3_nif.so
mkdir -p priv
make: *** No rule to make target 'sqlite3/sqlite3.c', needed by 'priv/sqlite3_nif.so'.  Stop.

After that I have removed sqlite3/sqlite3.c from Makefile:

# SRC = sqlite3/sqlite3.c c_src/sqlite3_nif.c
SRC = c_src/sqlite3_nif.c

# …

Finally I have this error:

==> exqlite
mkdir -p /tmp/mix_installs/elixir-1.12.0-dev-erts-12.0/d3fdf3d0ae84916ee0aaf0dc561b4c17/_build/dev/lib/exqlite/priv
cc -g -O3 -Wall -I"/home/eiji/.asdf/installs/erlang/24.0-rc1/erts-12.0/include" -Isqlite3 -Ic_src -DSQLITE_THREADSAFE=1 -DSQLITE_USE_URI -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_GEOPOLY -DSQLITE_OMIT_DEPRECATED -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_RBU -DNDEBUG=1 -shared -fPIC -fvisibility=hidden -Wl,-soname,libsqlite3.so.0 c_src/sqlite3_nif.c -o /tmp/mix_installs/elixir-1.12.0-dev-erts-12.0/d3fdf3d0ae84916ee0aaf0dc561b4c17/_build/dev/lib/exqlite/priv/sqlite3_nif.so
Compiling 5 files (.ex)

03:04:35.140 [warn]  The on_load function for module Elixir.Exqlite.Sqlite3NIF returned:
{:error,
 {:load_failed,
  'Failed to load NIF library: \'/tmp/mix_installs/elixir-1.12.0-dev-erts-12.0/d3fdf3d0ae84916ee0aaf0dc561b4c17/_build/dev/lib/exqlite/priv/sqlite3_nif.so: undefined symbol: sqlite3_bind_int64\''}}

Generated exqlite app
** (ArgumentError) adapter Ecto.Adapters.Exqlite was not compiled, ensure it is correct and it is included as a project dependency
    (ecto 3.5.8) lib/ecto/repo/supervisor.ex:60: Ecto.Repo.Supervisor.compile_config/2
    ecto_example.exs:4: (module)
    ecto_example.exs:3: (file)

So I have checked it by ldd:

$ ldd sqlite3_nif.so 
        linux-vdso.so.1 (0x00007ffe94eb1000)
        libc.so.6 => /usr/lib/libc.so.6 (0x00007f3220a46000)
        /usr/lib64/ld-linux-x86-64.so.2 (0x00007f3220c41000)

Please notice that I had no errors on cc compilation.

@Eiji was this installing with mix or cloning the repository and running mix compile?

I have used: Mix.install([:ecto_sql, :exqlite]) from elixir’s master branch. It’s like mix deps.get, but for single file scripts.

Interesting … This is error from cloned repo:

$ LC_ALL=en MIX_APP_PATH=. make clean all
rm -f ./priv/sqlite3_nif.so
mkdir -p priv
cc -g -O3 -Wall -I"" -Isqlite3 -Ic_src -DSQLITE_THREADSAFE=1 -DSQLITE_USE_URI -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_GEOPOLY -DSQLITE_OMIT_DEPRECATED -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_RBU -DNDEBUG=1 -shared -fPIC -fvisibility=hidden -Wl,-soname,libsqlite3.so.0 sqlite3/sqlite3.c c_src/sqlite3_nif.c -o priv/sqlite3_nif.so
/bin/sh: warning: setlocale: LC_ALL: cannot change locale (en)
c_src/sqlite3_nif.c:5:10: fatal error: erl_nif.h: No such file or directory
    5 | #include <erl_nif.h>
      |          ^~~~~~~~~~~
compilation terminated.
make: *** [Makefile:55: priv/sqlite3_nif.so] Error 1

Edit: mix compile on cloned repository compiled without any error.

ok, I found it - it’s simple sqlite3 directory is not included in hex

Odd indeed. Once we knock out some of the outstanding issues in the repo, I’ll cut a release.

Can you submit a PR for the fix?

sure

https://github.com/warmwaffles/exqlite/pull/20

I appreciate the help.