"mysql2 is not part of bundle" error while running rails server

[grvsachdeva]

Hi!

I updated my local master, ran bundle install and got the below error on running rails s

I also ran bundle install --without production mysql after deleting Gemfile.lock but got same error.

Solution which worked for me:

I added gem 'activerecord-mysql2-adapter' to the gemfile, deleted Gemfile.lock, ran bundle install, ran rails s and error gone.

Here's a snippet from Gemfile

which states running bundle install --without production mysql should not require need to include the activerecord-mysql2-adapter but it didn't worked.

Any idea @jywarren @siaw23 @publiclab/reviewers @publiclab/plots2-reviewers?

@siddhishree has also reported the same error in the Gitter channel:

I've been trying to setup local plots2 development environment while follwing https://github.com/publiclab/plots2#installation, and while on step 7 I face issue https://pastebin.com/AbL6a7Cw, I tried installing mysql2 on gem but no changes, I'm a bit inexperienced in ruby, so if anyone can help

[SidharthBansal]

I am also receiving similar error. Thanks for posting Gaurav.

…

On Thu, Mar 7, 2019, 9:24 PM Gaurav Sachdeva ***@***.***> wrote: Hi! I updated my local master, ran bundle install and got the below error on running rails s [image: mysql2_error] <https://user-images.githubusercontent.com/20878070/53969213-60c72900-411e-11e9-8841-ee7126c55ff7.png> I also ran bundle install --without production mysql after deleting Gemfile.lock but got same error. *Solution which worked for me:* I added gem 'activerecord-mysql2-adapter' to the gemfile, deleted Gemfile.lock, ran bundle install, ran rails s and error gone. Here's a snippet from Gemfile [image: gemfile] <https://user-images.githubusercontent.com/20878070/53969507-ee0a7d80-411e-11e9-8b46-277b00f09239.png> which states running bundle install --without production mysql should not require need to include the activerecord-mysql2-adapter but it didn't worked. Any idea @jywarren <https://github.com/jywarren> @siaw23 <https://github.com/siaw23> @publiclab/reviewers <https://github.com/orgs/publiclab/teams/reviewers> @publiclab/plots2-reviewers <https://github.com/orgs/publiclab/teams/plots2-reviewers>? @siddhishree <https://github.com/siddhishree> has also reported the same error in the Gitter channel: I've been trying to setup local plots2 development environment while follwing https://github.com/publiclab/plots2#installation, and while on step 7 I face issue https://pastebin.com/AbL6a7Cw, I tried installing mysql2 on gem but no changes, I'm a bit inexperienced in ruby, so if anyone can help — You are receiving this because you are on a team that was mentioned. Reply to this email directly, view it on GitHub <#4936>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AUACQ4pLQHHt60FE6aLHz4Scj-kfnXgjks5vUTYdgaJpZM4bjhXr> .

[grvsachdeva]

You can add gem 'activerecord-mysql2-adapter' to Gemfile @SidharthBansal as a temporary fix. Let's see what others think about this fix. Thanks!

[siaw23-retired]

Application is configured to use Passenger. So instead of rails s to start the server you should be running passenger start instead. That way you don't need gem 'activerecord-mysql2-adapter' in the Gemfile.

[CleverFool77]

I followed your method for temp fix but the error isn't gone.

[grvsachdeva]

Application is configured to use Passenger. So instead of rails s to start the server you should be running passenger start instead. That way you don't need gem 'activerecord-mysql2-adapter' in the Gemfile.

Ah, although I prefer to use Webrick as for development it has been sufficient for me and haven't thrown such error. I also tried passenger but same error

[CleverFool77]

@gauravano While doing rake:db: setup. It's showing the same error even after adding gem 'activerecord-mysql2-adapter' in Gemfile and deleting lock file and running install bundle.

[siaw23-retired]

There's a bunch of solutions here. I haven't taken time to look into this as I'd have to first but I'm sure the SO thread should have a at least one fix for this that you can try.

[cesswairimu]

Got the same error about two days ago after pulling master. I normally use sqlite3 . Adding gem 'mysql2', '>= 0.4.4' on the list of main gems removed the error for me. Not a smart fix though.

[siaw23-retired]

@cesswairimu i've had 'mysql2', '>= 0.4.4' in the main gem list from the start but don't check it in. That's the main reason I was trying to push for a one-DB system. It's like to work with the project like this...at least for me.

[cesswairimu]

Aha! I see do u use mysql as your local db and if so were you getting this error @siaw23 ?

[siaw23-retired]

I've never seen this error before. Everything works fine for me except the hustle of having to juggle different db systems. So I use mysql (MariaDB variant) for this project and all is fine.

[jywarren]

I seem to remember (but am not sure of it) some PR that may have changed the gemfile's mysql setup recently. I feel like i look at a lot of PRs so I could be mixed up with MapKnitter. But also it's hard to skim the changes to the Gemfile now because dependabot is helping us update it all the time. Is there a quick commandline way to skim all the diffs to the Gemfile to look for "mysql" and see if anything's changed in the past month or so? https://github.com/publiclab/plots2/commits/master/Gemfile

…

On Thu, Mar 7, 2019 at 12:57 PM Cess ***@***.***> wrote: Got the same error about two days ago after pulling master. I normally use sqlite3 . Adding gem 'mysql2', '>= 0.4.4' on the list of main gems removed the error for me. Not a smart fix though. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#4936 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABfJ239RLdmBQQn-m2-GumqGVQWMoR6ks5vUVLtgaJpZM4bjhXr> .

[sashadev-sky]

@siaw23 @cesswairimu I did the same as both of you for a bit and then got rid of it somehow just need to remember exactly what I did! Try putting it back into production, removing activerecord-mysql2-adapter (maybe even uninstall it from the CLI) and deleting the .bundle folder rm -r .bundle and running bundle install again.

@siaw23 I only use rails s and I avoid activerecord-mysql2-adapter completely so I don't know if it has to do with that but I could be wrong it gets difficult to keep track of exactly whats running when.

can someone possibly check if they get it in mapknitter too just to see if its plots2 specific? I may have gotten it and then fixed it there too. I have a pending PR for a mysql update there so I would want to note this issue there