schema_migrations already exists

[Thiebo]

Hi,

I'm following the readme (http://rodauth.jeremyevans.net/rdoc/files/README_rdoc.html).

I put the migration for the app account in a directory and file called

./migrations/0001202204010824_auth.rb

I run the app account migration with this command :

sequel -m migrations postgres://copro_development@localhost/copro_development

That works fine. And then I put the migration for the ph account in a directory and file called

./migrations/0002202204010828_ph.rb

and run :

sequel -m migrations postgres://copro_development_password@localhost/copro_development

This runs into an error :

Error: Sequel::DatabaseError: PG::DuplicateTable: ERROR: relation « schema_migrations » already exists.

What am I doing wrong?

Many thanks

[Jeremy Evans]

With MySQL, you have to use a separate migrations table for the password account migrations.  This isn't possible to do from the command line.  You need to create the Sequel::Database object manually, and then run:

 Sequel::Migrator.run(DB, 'password_account_migrations_directory', :table=>'schema_migrations_password')

Apologies, this should be documented better.  I'll try to update the README before the next release.

Thanks,

Jeremy

[Thiebo]

Thanks Jeremy,

I'm not using mysql, but postgresql though.

[Jeremy Evans]

After additionally review, the README has the correct information.  Your error is that you ran the first migration as the regular account user and not the password account user.  As the README states (http://rodauth.jeremyevans.net/rdoc/files/README_rdoc.html#label-MySQL+Database+Setup): "You should run all migrations as the ph account, and GRANT specific access to the app account as needed.".  Sorry for the confusion.

Thanks,

Jeremy

[Jeremy Evans]

On Fri, Apr 1, 2022 at 8:30 AM Thiebo <thiebald...@gmail.com> wrote:

Thanks Jeremy,

I'm not using mysql, but postgresql though.

Doh!  Sorry about that.  Then the information in my original email is correct, and you need to use a separate table for the password migration, with something like:

Sequel::Migrator.run(DB, 'password_account_migrations_directory', :table=>'schema_migrations_password')

Thanks,

Jeremy

[Thiebo]

My wrong !

Many thanks Jeremy.

May I ask another question, or is it better to open a new thread? Re: configure emails that rodauth sends?