Hi!

On OpenBSD 5.5 AMD64, I compile SQLightning as follows:

git clone https://github.com/LMDB/lmdb.git cd lmdb git checkout mdb.RE/0.9 cd libraries/liblmdb make sudo make install (On Linux: sudo ldconfig) cd ../../..

git clone https://github.com/LMDB/sqlightning.git cd sqlightning git checkout mdb ./configure

(trying "make" here complained that "mdb.c" doesn't exist on Linux and that "mdb.h" doesn't exist on OpenBSD, so I fixed this by "cp ../lmdb/libraries/liblmdb/* src/" and then):

make -j2 sudo make install (On Linux: sudo ldconfig)

I then try the newly built sqlite3 binary:

./sqlite3 /tmp/zz SQLite version 3.7.17 2013-05-20 00:56:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table a(b); Error: unable to open database "/tmp/zz": UNKNOWN ERROR

Equally so, sqlite3_open() fails with 2 = SQLITE_INTERNAL , http://www.sqlite.org/rescode.html#internal [1] .

Both SQLightning, LMDB and SQLite are built specifically to work on OpenBSD (except for in the read-only mmap+fwrite()+fsync() mode, how to switch that off or on is beyond my current knowledge).

How fix?

Thank you very much! Tinker

Links: ------ [1] http://www.sqlite.org/rescode.html#internal