Skip to content

Instantly share code, notes, and snippets.

@nuhil
Last active May 11, 2016 10:21
Show Gist options
  • Save nuhil/7779e16a1d1c9f444bdf to your computer and use it in GitHub Desktop.
Save nuhil/7779e16a1d1c9f444bdf to your computer and use it in GitHub Desktop.
Virtual Box, Vagrant, Homestead, PuPHPet, Sequel Pro - Trouble Shooting!

VM Troubleshoots

Connect Homestead's mySQL through Sequel Pro


Host: 127.0.0.1
Username: homestead
Pass: secret
Port: 33060

Sequel Pro can't connect to Vagrant (Puphpet) Ubuntu's mySQL


Problem: If you can't connect with VM's mySQL through Sequel Pro, then it might be becasue of the lack of password of default vagrant user and on the other hand the id_rsa key file is not working somehow.
Solution: Enter into that VM using auto ssh and then change the password of the user vagrant by executing command passwd. Set new password for vagrant and use that password while connecting from Sequel Pro using SSH tunnel. SSH host would be VM's private IP address, user would be vagrant, password be new one, port would be default 22 or blank.
MySQL's host would be 127.0.0.1 and user would be root and default password 123

Known Hosts Issue Edit the file sudo vi ~/.ssh/known_hosts and remove the line starts with the IP that was previously associated with an deleted VM may be.

Apache header info is not being received by PHP in Vagrant box


Solution: Set Env section for adding allowing Authorization or other header info.

            ...
            setenvif:           
                - 'Authorization "(.*)" HTTP_AUTHORIZATION=$1'
            ...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment