Vbulletin bulk importer can't find PG database

Continuing the discussion from Importers for large forums:

I’m sure I’m doing something silly, but I’m trying to run the vbulletin bulk importer and for some reason it can’t find the postgres database.

/home/pfaffman/.rbenv/versions/2.4.2/lib/ruby/gems/2.4.0/gems/pg-0.20.0/lib/pg.rb:56:in `initialize': fe_sendauth: no password supplied (PG::ConnectionBad)

It looks like it should get it here:

https://github.com/discourse/discourse/blob/master/script/bulk_import/base.rb#L15-L19

I ran a standard importer and it didn’t have any trouble.

What am I missing?

Edit: I’m not the only one: https://meta.discourse.org/t/fe-sendauth-no-password-supplied-in-bulk-importer/76276?u=pfaffman

Did you ever figure this out?

No. But I’ve not tried again.

Changing

https://github.com/discourse/discourse/blob/master/script/bulk_import/base.rb#L60

to

@raw_connection = PG.connect(dbname: db[:database], host: db[:host_names]&.first, port: db[:port], password: "discourse")

(where discourse is the password for discourse_development database)

should fix this issue. I think this issue is specific to Linux and works fine on macOS.

3 Likes