Galaxy password forgot

Question

[Ric]

I forgot my password for Galaxy and I thought I would be able to read the password with help of sqlite3 in database/universe.sqlite, but I am not able to SELECT any TABLE in sqlite3.

database $ sqlite3 universe.sqlite
sqlite> .schema galaxy_user
CREATE TABLE galaxy_user (
        id INTEGER NOT NULL,
        create_time DATETIME,
        update_time DATETIME,
        email VARCHAR(255) NOT NULL,
        password VARCHAR(255) NOT NULL,
        external BOOLEAN,
        deleted BOOLEAN,
        purged BOOLEAN,
        username VARCHAR(255),
        form_values_id INTEGER,
        disk_usage NUMERIC(15, 0), active BOOLEAN, activation_token VARCHAR(64),
        PRIMARY KEY (id),
        CHECK (external IN (0, 1)),
        CHECK (deleted IN (0, 1)),
        CHECK (purged IN (0, 1))
);
sqlite> select * from galaxy_user;
sqlite>

Why select does not show anything?

Answer 1

[John]

As its sqlite its probably not a permissions thing. It could simply be that there's no data in the table?

Try:

.headers on
.mode columns
SELECT COUNT(1) from `galaxy_user`;
SELECT * from `galaxy_user`;

If your SQLite file is not tiny and there are no rows, it could just be that until the database is VACCUM'd, the space will not be freed up - but the data is most likely gone or at best corrupt.