scotch-io / scotch-box-pro

Scotch Box Pro is a preconfigured Vagrant Box with a full array of LAMP Stack features to get you up and running with Vagrant in no time.
MIT License
77 stars 27 forks source link

Sequel Pro not working like instructions for Mysql #17

Open ivcreative opened 6 years ago

ivcreative commented 6 years ago

I can manually get onto SSH with vagrant ssh command line, I can do any command line for MySQL, but when I try the suggested software to manage the database as mentioned on https://box.scotch.io/common-questions/:

WHY NO PHPMYADMIN?

You'll need to download either Sequel Pro or Navicat or some other desktop database client. Switching to one of these from phpMyAdmin will be a life changing experience so just do it already.

No matter what I do I keep getting this message:

The SSH Tunnel has unexpectedly closed.

has any setting need to be done since the last update it use to work with scothbox version 2 but having so many issues with version 3 now.

whatnickcodes commented 6 years ago

Can you post your settings?

ivcreative commented 6 years ago

Hi whatnickcodes

the settings for vagratn are:

`# -- mode: ruby --

vi: set ft=ruby :

Vagrant::DEFAULT_SERVER_URL.replace('https://vagrantcloud.com')

Vagrant.configure("2") do |config|

config.vm.box = "scotch/box-pro"
config.vm.hostname = "scotchbox"
config.vm.network "forwarded_port", guest: 80, host: 8080
config.vm.network "private_network", ip: "192.168.33.10"
config.vm.synced_folder ".", "/var/www", :mount_options => ["dmode=777", "fmode=666"]
#config.vm.synced_folder ".", "/var/www", :nfs => { :mount_options => ["dmode=777","fmode=666"] }
config.vm.provision "shell", inline: <<-SHELL
   echo 'echo "upload_max_filesize = 100M" >> /etc/php/7.2/apache2/conf.d/user.ini' | sudo -s
   echo 'echo "post_max_size = 100M" >> /etc/php/7.2/apache2/conf.d/user.ini' | sudo -s
   sudo service apache2 restart

SHELL

# Optional NFS. Make sure to remove other synced_folder line too
#config.vm.synced_folder ".", "/var/www", :nfs => { :mount_options => ["dmode=777","fmode=666"] }

end`

and for the sequelpro are

MySQL Host: 127.0.0.1 Login: root Pass: root SSH Host: 127.0.0.1 Login: vagrant Password: vagrant port: 2222

I have also tried with the vagrant SSH key

/Users/wtfuser/web2/projectname/.vagrant/machines/default/virtualbox/private_key

jedifunk commented 5 years ago

i've got this exact issue... SSH Tunnel closed. Has this been resolved?