Database Issues

You should be able to SSH in, then run your migrations.

Alternatively there's an option to run migrations on deploy. You can change your autodeploy script on forge manually if you'd like to do this.

You'll also need to set up the environment variables to connect to the db, again on forge. These variables are the same format as in your .env file but the password will have been emailed to you from forge when the server was set up.

Yeah you should just be able to add

php artisan migrate --force

to your deploy script to get Forge to fix migrations

Thanks for the replies. I didn't think to ssh in and run them. I do have the auto deploy script running with php artisan migrate --force but nothing shows up in the database.

Thanks.

Keith

@keithmichelson That might be if your environment variables aren't set :)

@taijuten they are set through forge and match the config file. Any other step I might be missing?

Thanks

Keith

@keithmichelson Are your manual migrations through SSH working?

@taijuten I just tried it and I get this: [PDOException]
SQLSTATE[HY000] [2002] No such file or directory

@keithmichelson Looks to me like your DB_HOST is incorrect.

On forge, this should be the IP address of the server

@taijuten It was, I redid it just to make sure. Same error. Thanks.

See this stackoverflow post: http://stackoverflow.com/questions/20723803/pdoexception-sqlstatehy000-2002-no-such-file-or-directory

Try restarting the mysql service through forge?

@taijuten I restarted it through digital ocean, I didn't see where in forge? Tried again same error, also tried that stackoverflow thing and same error. It's really weird.

@taijuten Found the problem, I had to add 'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock', to the config file to get mamp working a long time ago. I had completely forgotten that was breaking everything.

Thanks again for trying to figure this out.

Keith

Now are your migrations working?

When you say you can't create a user, are you talking MySQL user, or user on your app?

Yes they are! I edited that last one, the user registration is working as well, just had an article error. I think I'm good.

Keith