conjure.sh server: Wrong user name or password [28000-162] (execute.clj:0)

[Pål de Vibe]

Hi,

After upgrading from conjure 0.8.0 to 0.8.7 I copied over
db_config.clj from the conjure source to replace src/config/
db_config.clj.

I get the following error:

Exception in thread "main" org.h2.jdbc.JdbcSQLException: Wrong user
name or password [28000-162] (execute.clj:0)

After digging around in the code it seems to me that this is caused by
drift-db-h2 not supporting username and password anymore and my h2
database having been created with username and password. Am I correct
to assume that drift-db-h2 no longer supports username and password
(judging from flavor.clj, function h2-flavor).

How can I work around this or strip username and password from my
existing database to allow it to be used with conjure 0.8.7?

Pål de Vibe

[Matthew Courtney]

Yes drift-db-h2 does not support username and password anymore. I'm not
sure what happened, but I couldn't get username and password to work
with h2 anymore.

The only way I know of to migrate from a database with a password to one
without is to get a dump of the data from the password protected one and
drop it into the non-password protected one. I'm not sure if there is an
h2 dump utility. If not, you'll have to write one for your own project.

-Matt Courtney

> P�l de Vibe

[Pål de Vibe]

OK.

I tried expanding drift-db-h2 to use username and password but
couldn't get it working either. I will start from scratch again as we
hadn't too much anyway.

Pål