TimWolla / docker-adminer

Database management in a single PHP file
https://hub.docker.com/_/adminer/
157 stars 69 forks source link

Can't get login-password-less working with SQLite file #116

Closed X1pheR closed 2 years ago

X1pheR commented 2 years ago

I used the docker compose and adminer is working. I am now trying to open an sqlite db file which does not have a password. I also cannot set a password on it because it is the database used by my home automation software Home Assistant. It creates a db file as root without password. I've read all documentation but perhaps I'm misunderstanding something.

I still get the error below in the container log image

It creates an empty file called 001-login-password-less.php in the folder. However I have the correct file created as below with the contents per the instructions. image

Contents of the file is image

Below is the relevant part of my docker compose file image

TimWolla commented 2 years ago

Remove the plugin from the environment variable ADMINER_PLUGINS. The environment variable is just for autoloading parameter-less plugins, it basically creates the file for you, instead you doing it manually.

TimWolla commented 2 years ago

Also: the hash you put there is not a valid hash. You'll need a BCrypt hash (or Argon2).

X1pheR commented 2 years ago

Thank you for the quick response! I removed it from the environment variable and changed the hash. But still not luck. No errors in the console.

This is now the contents of "login-password-less.php" in "plugins-enabled" folder.

<?php
require_once('plugins/login-password-less.php');
/** Set allowed password
    * @param string result of password_hash
    */
return new AdminerLoginPasswordLess(
    $password_hash = password_hash("", PASSWORD_BCRYPT)
);

image

TimWolla commented 2 years ago

Did you try with an actual password, instead of the empty string?

X1pheR commented 2 years ago

That worked! I tried it before but was still when I used md5 hash 😄 Thanks... Before you close this could I ask how to install other plugins/customization since the docker version works a little different? Like how would I get this working; https://github.com/natanfelles/adminer-bootstrap-like

TimWolla commented 2 years ago

Before you close this could I ask how to install other plugins/customization since the docker version works a little different? Like how would I get this working; https://github.com/natanfelles/adminer-bootstrap-like

That specific one will quite a bit of effort, because it consists of multiple files, some of which need to be served as static files from the file system, so I'm afraid there's no simple answer here.