Hi, I’ve a big board with a database of over 8GB size with vBulletin 4 and I’m evaluating to switch my forum to Discourse. So, I’m trying to convert my vB4 db to Discourse: how to do this? I’ve noticed the script at this link discourse/script/import_scripts/vbulletin.rb at main · discourse/discourse · GitHub but I don’t know how to execute it and what it needs. Is there any guide about vB4->Discourse conversion? (Actually, i’ve any experience with Ruby and Docker).

I’ve tryied with this guide: Increasing the Base Device Size on Docker Daemon Restart — Project Atomic But the only thing I got is to corrupt my Discourse container and also if I recreate it i get some strange errors and so I can’t bootstrap/start the container. How I can switch to the aufs storage driver?

I’m trying your fixed script, but I get this error: root@disc3-app:/# bundle exec ruby /var/www/discourse/script/import_scripts/vbulletin.rb /var/www/discourse/config/application.rb:2:in `require': cannot load such file -- rails/all (LoadError) from /var/www/discourse/config/application.rb:2:in ` ' from /var/www/discourse/config/environment.rb:2:in `require' from /var/www/discourse/config/environment.rb:2:in ` ' from /var/www/discourse/script/import_scripts/base.rb:14:in `require_relative' from /var/www/discourse/script/import_scripts/base.rb:14:in ` ' from /var/www/discourse/script/import_scripts/vbulletin.rb:2:in `require' from /var/www/discourse/script/import_scripts/vbulletin.rb:2:in ` '

Try entering the container using: ./launcher enter app

I also tried to login as discourse user (into the container): root@disc3-app:/var/www/discourse# su - discourse discourse@disc3-app:~$ cd /var/www/discourse/script/import_scripts discourse@disc3-app:/var/www/discourse/script/import_scripts$ ruby vbulletin.rb /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:661:in `rescue in connect': FATAL: database "discourse_development" does not exist (ActiveRecord::NoDatabaseError) from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:651:in `connect' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:242:in `initialize' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:44:in `new' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:44:in `postgresql_connection' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:438:in `new_connection' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:448:in `checkout_new_connection' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:422:in `acquire_connection' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:349:in `block in checkout' from /usr/local/lib/ruby/2.3.0/monitor.rb:214:in `mon_synchronize' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:348:in `checkout' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:263:in `block in connection' from /usr/local/lib/ruby/2.3.0/monitor.rb:214:in `mon_synchronize' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:262:in `connection' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:571:in `retrieve_connection' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_handling.rb:113:in `retrieve_connection' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_handling.rb:87:in `connection' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/attributes.rb:93:in `columns' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/attributes.rb:98:in `columns_hash' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `block in find_by' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `each' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `all?' from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `find_by' from /var/www/discourse/lib/discourse.rb:282:in `system_user' from /var/www/discourse/script/import_scripts/base.rb:477:in ` ' from /var/www/discourse/script/import_scripts/base.rb:20:in ` ' from /usr/local/lib/ruby/2.3.0/rubygems/core_ext/kernel_require.rb:55:in `require' from /usr/local/lib/ruby/2.3.0/rubygems/core_ext/kernel_require.rb:55:in `require' from vbulletin.rb:2:in ` ' If I try with “./launcher enter app” i get this error: root@disc3-app:/var/www/discourse# bundle exec ruby script/import_scripts/vbulletin.rb script/import_scripts/vbulletin.rb:1:in `require': cannot load such file -- mysql2 (LoadError) from script/import_scripts/vbulletin.rb:1:in ` '

Keep using the enter method, Add mysql gem to the Gemfile, run a bundle install, run the script.

[image] Falco: Keep using the enter method, Add mysql gem to the Gemfile, run a bundle install, run the script. For “enter method” you intend the ./launcher enter app bundle exec ruby script/import_scripts/vbulletin.rb or launch with su - discourse cd /var/www/discourse/script/import_scripts ruby vbulletin.rb

The first one, that’s the correct way.

I did the following steps: [root@disc3 ~]# cd /var/discourse [root@disc3 discourse]# ./launcher enter app which: no docker.io in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin) And after I added the mysql gem to gemfile root@disc3-app:/var/www/discourse# echo "gem 'mysql2'" >> Gemfile root@disc3-app:/var/www/discourse# sudo gem install mysql2 Building native extensions. This could take a while... Successfully installed mysql2-0.4.4 1 gem installed Something surprising happened when I did the bundle install: root@disc3-app:/var/www/discourse# bundle install --no-deployment Don't run Bundler as root. Bundler can ask for sudo if it is needed, and installing your bundle as root will break this application for all non-root users on this machine. Fetching gem metadata from https://rubygems.org/............ Fetching version metadata from https://rubygems.org/.. Fetching dependency metadata from https://rubygems.org/. Resolving dependencies... Installing rake 11.2.2 Installing i18n 0.7.0 **_[...]_** Bundle complete! 100 Gemfile dependencies, 179 gems now installed. Gems in the group development were not installed. Use `bundle show [gemname]` to see where a bundled gem is installed. Post-install message from certified: IMPORTANT: Remember to use the included executable `certifed-update` regularly to keep your certificate bundle up to date. 179 gems installed, wow. But when I try to start the converter, this happens: root@disc3-app:/var/www/discourse# bundle exec ruby script/import_scripts/vbulletin.rbURGENT: FATAL: Peer authentication failed for user "discourse" Failed to initialize site default /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:651:in `initialize': FATAL: Peer authentication failed for user "discourse" (PG::ConnectionBad) from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:651:in `new' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:651:in `connect' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:242:in `initialize' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:44:in `new' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:44:in `postgresql_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:438:in `new_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:448:in `checkout_new_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:422:in `acquire_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:349:in `block in checkout' from /usr/local/lib/ruby/2.3.0/monitor.rb:214:in `mon_synchronize' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:348:in `checkout' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:263:in `block in connection' from /usr/local/lib/ruby/2.3.0/monitor.rb:214:in `mon_synchronize' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:262:in `connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:571:in `retrieve_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_handling.rb:113:in `retrieve_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_handling.rb:87:in `connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/attributes.rb:93:in `columns' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/attributes.rb:98:in `columns_hash' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `block in find_by' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `each' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `all?' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `find_by' from /var/www/discourse/lib/discourse.rb:282:in `system_user' from /var/www/discourse/script/import_scripts/base.rb:477:in ` ' from /var/www/discourse/script/import_scripts/base.rb:20:in ` ' from script/import_scripts/vbulletin.rb:2:in `require' from script/import_scripts/vbulletin.rb:2:in ` '

[image] Matheeus: sudo gem install mysql2 Don’t do this. The bundle install is sufficient. [image] Matheeus: bundle exec ruby script/import_scripts/vbulletin.rb Try RAILS_ENV=production bundle exec ruby script/import_scripts/vbulletin.rb

[image] Falco: [image] Matheeus: sudo gem install mysql2 Don’t do this. The bundle install is sufficient. [image] Matheeus: bundle exec ruby script/import_scripts/vbulletin.rb Try RAILS_ENV=production bundle exec ruby script/import_scripts/vbulletin.rb Nothing to do, same error root@disc3-app:/var/www/discourse# RAILS_ENV=production bundle exec ruby script/import_scripts/vbulletin.rb URGENT: FATAL: Peer authentication failed for user "discourse" Failed to initialize site default /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:651:in `initialize': FATAL: Peer authentication failed for user "discourse" (PG::ConnectionBad) from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:651:in `new' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:651:in `connect' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:242:in `initialize' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:44:in `new' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:44:in `postgresql_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:438:in `new_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:448:in `checkout_new_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:422:in `acquire_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:349:in `block in checkout' from /usr/local/lib/ruby/2.3.0/monitor.rb:214:in `mon_synchronize' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:348:in `checkout' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:263:in `block in connection' from /usr/local/lib/ruby/2.3.0/monitor.rb:214:in `mon_synchronize' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:262:in `connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:571:in `retrieve_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_handling.rb:113:in `retrieve_connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_handling.rb:87:in `connection' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/attributes.rb:93:in `columns' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/attributes.rb:98:in `columns_hash' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `block in find_by' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `each' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `all?' from /usr/local/lib/ruby/gems/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/core.rb:173:in `find_by' from /var/www/discourse/lib/discourse.rb:282:in `system_user' from /var/www/discourse/script/import_scripts/base.rb:477:in ` ' from /var/www/discourse/script/import_scripts/base.rb:20:in ` ' from script/import_scripts/vbulletin.rb:2:in `require' from script/import_scripts/vbulletin.rb:2:in ` '

How to convert vBulletin 4 database to Discourse?

Product Support

mpalmer (Matt Palmer) September 14, 2016, 8:22pm 29

Step 11 in this howto might help you.

Topic		Replies	Views
Migrate a vBulletin 4 forum to Discourse Sysadmins how-to	183	34950	November 9, 2025
Migrate a bbPress WordPress plugin forum to Discourse Migrating to Discourse how-to	33	13621	January 10, 2024
Use an import script that requires MySQL Sysadmins how-to	51	13852	December 12, 2023
Migrate a MyBB forum to Discourse Sysadmins how-to	21	9406	March 21, 2023
vBulletin import_script bug in importing children categories Product Support	20	1460	March 11, 2020

How to convert vBulletin 4 database to Discourse?

Related topics