search

AlexCovizzi / vscode-sqlite

VSCode extension to explore and query SQLite databases.
Apache License 2.0
199 stars 23 forks source link

Can't open database #83

Closed ingun37 closed 4 years ago

ingun37 commented 4 years ago

When I try to open sqlite file I get 

Unable to find a valid SQLite command. Fallback binary is not valid.

and

[2:37:39 AM][vscode-sqlite][ERROR] Unable to find a valid SQLite command. Fallback binary is not valid.

I saw a very similar closed issue that occurred in CentOS. It's said that it is fixed by some ad-hoc solution specific for CentOS. I suspect the same reason and it can be fixed in the same way but this time for Debian 10?

The issue is referenced below.

Should be fixed in version 0.7.1 There were a couple of problems: It failed to recognize if the SQLite binaries were not supported (it's needed at least version 3.9), and on CentOS the binaries provided throw an error when started, but work fine after that. I fixed the first problem and added a workaround for the second. If there are other errors feel free to reopen this issue.

Originally posted by @AlexCovizzi in https://github.com/AlexCovizzi/vscode-sqlite/issues/71#issuecomment-504095860

vaMuchenje commented 4 years ago

@AlexCovizzi I am getting the same error as well. I am running 0.8.0 of your extension on Ubuntu 18.04 and it doesn't work.

AlexCovizzi commented 4 years ago

Hi, can you set the log level to DEBUG (in the settings set "sqlite.logLevel": "DEBUG") and post here the output? Thanks

ingun37 commented 4 years ago

@AlexCovizzi 

[2:13:29 PM][vscode-sqlite][INFO] Activating extension vscode-sqlite v0.8.0...
[2:13:29 PM][vscode-sqlite][DEBUG] 'sqlite3' is not a valid SQLite command: /bin/sh: 1: sqlite3: not found

[2:13:29 PM][vscode-sqlite][DEBUG] Fallback SQLite binary found: '/home/ingun/.vscode-server/extensions/alexcvzz.vscode-sqlite-0.8.0/bin/sqlite-v3.26.0-linux-x64'.
[2:13:29 PM][vscode-sqlite][DEBUG] '/home/ingun/.vscode-server/extensions/alexcvzz.vscode-sqlite-0.8.0/bin/sqlite-v3.26.0-linux-x64' is not a valid SQLite command: /home/ingun/.vscode-server/extensions/alexcvzz.vscode-sqlite-0.8.0/bin/sqlite-v3.26.0-linux-x64: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory

[2:13:29 PM][vscode-sqlite][ERROR] Unable to find a valid SQLite command. Fallback binary is not valid.
[2:13:29 PM][vscode-sqlite][INFO] Extension activated.
AlexCovizzi commented 4 years ago

Does the sqlite executable (... /extensions/alexcvzz.vscode-sqlite-0.8.0/bin/sqlite-v3.26.0-linux-x64) work if your run it from terminal?

ingun37 commented 4 years ago

I wasn't sure which arguments to give so I tried just executing the binary and I got this message.

ingun@debian ~/m/excel> /home/ingun/.vscode-server/extensions/alexcvzz.vscode-sqlite-0.8.0/bin/sqlite-v3.26.0-linux-x64
/home/ingun/.vscode-server/extensions/alexcvzz.vscode-sqlite-0.8.0/bin/sqlite-v3.26.0-linux-x64: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory

It was ran in terminal.

AlexCovizzi commented 4 years ago

Does it work anyway afterward, or it showed the error and then exited?

ingun37 commented 4 years ago

It exited right away. After I read the error message I tried installing sqlite3 using apt and it worked. I'm happy with the solution so I would close the issue.

AlexCovizzi commented 4 years ago

Thanks for the help, unfortunately there is not much I can do to solve the issue, the only solutions seems to be to install the missing library or sqlite.

bssjbassj commented 4 years ago

Follow this tutorial https://www.sqlitetutorial.net/download-install-sqlite/ and configure the extension to locate of the folder in the Sqlite: Sqlite3 put in eg. C:\sqlite\sqlite3

joao-gabriel-gois commented 4 years ago

Hi, I just had the same issue. I'm using Ubuntu 18.04.4 LTS.

Just to add, this solution that @ingun37 mentioned also worked for me:

It exited right away. After I read the error message I tried installing sqlite3 from apt and it worked. I'm happy with the solution so I can close the issue but I'm also happy to support for you to fix this issue. Let me know if you need anything.

But differently from others, my output could not identifies sqlite3 in my /bin/sh, and tried to run inside .vscode/extensions respective extension bin directory, found it but got permission denied. Even when it finds the binary, in cases like mine, it wasn't running. Hope this info helps, in case if wasn't expected.

In case of someone gets the same output I had, installing through apt works.

Output logs:

[00:53:50][vscode-sqlite][INFO] Activating extension vscode-sqlite v0.8.2...
[00:53:50][vscode-sqlite][ERROR] Unable to find a valid SQLite command. Fallback binary is not valid.
[00:53:50][vscode-sqlite][INFO] Extension activated.
[01:05:32][vscode-sqlite][DEBUG] 'sqlite3' is not a valid SQLite command: /bin/sh: 1: sqlite3: not found
[01:05:32][vscode-sqlite][DEBUG] Fallback SQLite binary found: '/home/pudou/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64'.
[01:05:32][vscode-sqlite][DEBUG] '/home/pudou/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64' is not a valid SQLite command: /bin/sh: 1: /home/pudou/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64: Permission denied
[01:05:32][vscode-sqlite][ERROR] Unable to find a valid SQLite command. Fallback binary is not valid.
gabrielrra commented 4 years ago

Vlw @joao-gabriel-gois salvou minha NextLevelWeek

ggbellotti commented 4 years ago

Parece besteira, mas além de instalar o pacote via apt sudo apt install sqlite3, reiniciei o VSCode e tentei abrir novamente o arquivo, mas deu o mesmo erro Unable to find a valid SQLite command. Fallback binary is not valid. Então, selecionei o arquivo na mão, ao invés de usar a sugestão que estava aparecendo e funcionou hahaha. 🚀

W3ND31 commented 4 years ago

Guys, u don't need this. If u enabled "sqlite.logLevel":"DEBUG" on VsCode JSON Settings, look for the file like "/home/wendel/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64"

Go to terminal and type "chmod +x /home/wendel/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64"

And the issue is resolved without installing anything else.

I think that this will happen only on unix SO's.

joao-gabriel-gois commented 4 years ago

@W3ND31 You're right, totally make sense.

I had no issues or limitation to install sqilite3, but yes, I think in order to isolate as a solution only for the vscode extension to work, your solution is better.

chmod +x <extension-binary-path>

PS: pros BR, também to na next level, avuaaaa! :rocket: :rocket: :rocket:

Guys, u don't need this. If u enabled "sqlite.logLevel":"DEBUG" on VsCode JSON Settings, look for the file like "/home/wendel/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64"

Go to terminal and type "chmod +x /home/wendel/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64"

And the issue is resolved without installing anything else.

I think that this will happen only on unix SO's.

ricardovasconcelos commented 4 years ago

I got the same error, I solved installing apt-get install sqlite3 and apt-get install libsqlite3-dev and it worked as well

matias2018 commented 4 years ago

Add permissions didn't work for me. I had SQLite installed previously too. I'm using Ubuntu 18.04. The file is being used and working, but I can't (humanly) read it on VSCode.

Any suggestions, please? Screenshot from 2020-06-18 23-05-22

ricardovasconcelos commented 4 years ago

@matias2018 try to install sqlite extension on vscode and run with ctrl + shift + p and select SQLite: Open database

You should see something like this image

matias2018 commented 4 years ago

Thank you! I'll try it.

A quinta, 18/06/2020, 23:24, Ricardo Vasconcelos notifications@github.com escreveu:

@matias2018 https://github.com/matias2018 try to install sqlite extension on vscode and run with ctrl + shift + p and select SQLite: Open database

You should see it like this [image: image] https://user-images.githubusercontent.com/61828136/85077604-134ac000-b199-11ea-82be-22de56865407.png

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/AlexCovizzi/vscode-sqlite/issues/83#issuecomment-646335626, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIW4QCJC6NUWZD42RDTEV5DRXKH3XANCNFSM4JQ3GCWQ .

SrAmaral commented 4 years ago

Parece besteira, mas além de instalar o pacote via apt sudo apt install sqlite3, reiniciei o VSCode e tentei abrir novamente o arquivo, mas deu o mesmo erro Unable to find a valid SQLite command. Fallback binary is not valid. Então, selecionei o arquivo na mão, ao invés de usar a sugestão que estava aparecendo e funcionou hahaha.

Solved my problem, as I just needed to install sqlite3 with sudo apt .... thanks

douglasmatosdev commented 4 years ago

@ingun37 @vaMuchenje @guilhermebellotti @AlexCovizzi @W3ND31 @SrAmaral @matias2018 @ricardovasconcelos @joao-gabriel-gois

I decided by doing: sudo apt-get install sqlite3 libsqlite3-dev

Then, in settings.json sets the path to the sqlite3 binary: "sqlite.sqlite3": "/usr/bin/sqlite3"

LuisHenriqSilva commented 4 years ago

@douglasmatosdev muito obrigado pela dica, thanks for the help @douglasmatosdev

Jlblacklion commented 4 years ago

@matias2018 try to install sqlite extension on vscode and run with ctrl + shift + p and select SQLite: Open database

You should see something like this image

it worked for me, but I had to install Sqlite3 and the development dependencies, like the guy shows above

LacerdaAlexandre commented 4 years ago

It exited right away. After I read the error message I tried installing sqlite3 using apt and it worked. I'm happy with the solution so I would close the issue.

Salvou minha NextLevelWeek também Saved my NLW too tks a lot

lucasrafaele commented 4 years ago

you helped me, thanks =)

ajvideira commented 4 years ago

@ingun37 @vaMuchenje @guilhermebellotti @AlexCovizzi @W3ND31 @SrAmaral @matias2018 @ricardovasconcelos @joao-gabriel-gois

I decided by doing: sudo apt-get install sqlite3 libsqlite3-dev

Then, in settings.json sets the path to the sqlite3 binary: "sqlite.sqlite3": "/usr/bin/sqlite3"

Thanks @douglasmatosdev ! TMJ!

dazzag24 commented 2 years ago

Same problem here on WSLv2 using an Ubuntu20.04 image.

[12:05:20 PM][vscode-sqlite][ERROR] Failed to open database '/home/xxx/code/apollographql/fullstack-tutorial/final/server/store.sqlite': SQLite process failed to start: The argument 'file' cannot be empty. Received ''

In a terminal I then 

> cd /home/xxx/.vscode-server/extensions/alexcvzz.vscode-sqlite-0.14.0/bin
> ./sqlite-v3.26.0-linux-x64 --help
./sqlite-v3.26.0-linux-x64: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory
> ldd ./sqlite-v3.26.0-linux-x64
        linux-vdso.so.1 (0x00007ffe6591a000)
        libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f5d8cacc000)
        libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f5d8caa9000)
        libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f5d8c95a000)
        libtinfo.so.5 => not found
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f5d8c768000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f5d8cadf000)

Looking at the libs on my Ubuntu system:

> ls -l /usr/lib/x86_64-linux-gnu/libtinfo*
-rw-r--r-- 1 root root 306676 Feb 26  2020 /usr/lib/x86_64-linux-gnu/libtinfo.a
lrwxrwxrwx 1 root root     35 Feb 26  2020 /usr/lib/x86_64-linux-gnu/libtinfo.so -> /lib/x86_64-linux-gnu/libtinfo.so.6
lrwxrwxrwx 1 root root     15 Feb 26  2020 /usr/lib/x86_64-linux-gnu/libtinfo.so.6 -> libtinfo.so.6.2
-rw-r--r-- 1 root root 192032 Feb 26  2020 /usr/lib/x86_64-linux-gnu/libtinfo.so.6.2

It seems I have libtinfo.so.6 but not libtinfo.so.5.

ValeriyDP commented 1 year ago

still valid issue for version 0.14.1 out of the box

~/.vscode/extensions/alexcvzz.vscode-sqlite-0.14.1/bin/sqlite-v3.26.0-linux-x64: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory

To fix that in Ubuntu 20.04 I had to execute the command below

sudo apt install libncurses5
engperini commented 1 year ago

It exited right away. After I read the error message I tried installing sqlite3 using apt and it worked. I'm happy with the solution so I would close the issue.

just to help someone else, i had this issue now on raspberry pi4B 64b coding from ssh using VSCODE and this answer save my day.