Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Sequel Pro not working like instructions for Mysql #17

Open
ivcreative opened this issue Jun 5, 2018 · 3 comments
Open

Sequel Pro not working like instructions for Mysql #17

ivcreative opened this issue Jun 5, 2018 · 3 comments

Comments

@ivcreative
Copy link

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
Copy link
Member

Can you post your settings?

@ivcreative
Copy link
Author

ivcreative commented Jun 6, 2018

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
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants