Deploy to Azure

[geekpgh]

We need to actually get the system running on Azure.

[geekpgh]

I have GitHub deploying to Azure, but the site crashed immediately. You can see the error by going to http://homebrew.azurewebsites.net/

Any idea why? Seems to be an XML config issues. Maybe we need to do something to set up the database?

[geekpgh]

It won't show me the real error, I tried enabling customErrors in the webconfig , but it doesn't seem to have any effect.

[steveplatz]

It looks like the error has to do with the database. If you check the page now, you'll see the full stack trace of the error. Would you be able to set up a sql azure instance as well, Jon?

[steveplatz]

I think you are correct. I'm in the project now… want me to try it out?

Steve Platz

On Friday, July 5, 2013 at 3:51 PM, geekpgh wrote:

I created a database here are the details. We have to setup the webconfig somehow I think. databse name: brewersbuddy user: brewersbuddy password: t3@m3Rocks!
I think maybe we need to make the webconfig.release use it?

— Reply to this email directly or view it on GitHub (https://github.com/geekpgh/mastersproject/issues/51#issuecomment-20536156).

[geekpgh]

I found the connection strings. Not sure whihc to use.

ADO.NET: Server=tcp:j80li1ch8a.database.windows.net,1433;Database=brewersbuddy;User ID=brewersbuddy@j80li1ch8a;Password={your_password_here};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;

ODBC: Driver={SQL Server Native Client 10.0};Server=tcp:j80li1ch8a.database.windows.net,1433;Database=brewersbuddy;Uid=brewersbuddy@j80li1ch8a;Pwd={your_password_here};Encrypt=yes;Connection Timeout=30;

I think we need to make our site use the ADO.net one. I need to head to my sister's rehearsal dinner so I won't be able to change it today.

[steveplatz]

If it's using SQL 2012, I think it needs to look like this:

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Steve Platz

On Friday, July 5, 2013 at 3:53 PM, geekpgh wrote:

I found the connection strings. Not sure whihc to use. ADO.NET:
Server=tcp:j80li1ch8a.database.windows.net (http://j80li1ch8a.database.windows.net),1433;Database=brewersbuddy;User ID=brewersbuddy@j80li1ch8a;Password={your_password_here};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;
ODBC: Driver={SQL Server Native Client 10.0};Server=tcp:j80li1ch8a.database.windows.net (http://j80li1ch8a.database.windows.net),1433;Database=brewersbuddy;Uid=brewersbuddy@j80li1ch8a;Pwd={your_password_here};Encrypt=yes;Connection Timeout=30;
I think we need to make our site use the ADO.net (http://ADO.net) one. I need to head to my sister's rehearsal dinner so I won't be able to change it today.

— Reply to this email directly or view it on GitHub (https://github.com/geekpgh/mastersproject/issues/51#issuecomment-20536249).

[geekpgh]

I got those strings out of Azure itself. It has a "Your connection string page". Not sure if they are correct, but that is what azure claims we should use.

j80li1ch8a is the server name, it generated it.

[steveplatz]

Nevermind… We probably need to use the Azure approach (I've never used it before)

This site probably has the syntax as need to use: http://www.connectionstrings.com/sql-azure

Steve Platz

On Friday, July 5, 2013 at 3:55 PM, Steve Platz wrote:

If it's using SQL 2012, I think it needs to look like this:

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Steve Platz

On Friday, July 5, 2013 at 3:53 PM, geekpgh wrote:

I found the connection strings. Not sure whihc to use. ADO.NET:
Server=tcp:j80li1ch8a.database.windows.net (http://j80li1ch8a.database.windows.net),1433;Database=brewersbuddy;User ID=brewersbuddy@j80li1ch8a;Password={your_password_here};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;
ODBC: Driver={SQL Server Native Client 10.0};Server=tcp:j80li1ch8a.database.windows.net (http://j80li1ch8a.database.windows.net),1433;Database=brewersbuddy;Uid=brewersbuddy@j80li1ch8a;Pwd={your_password_here};Encrypt=yes;Connection Timeout=30;
I think we need to make our site use the ADO.net (http://ADO.net) one. I need to head to my sister's rehearsal dinner so I won't be able to change it today.

— Reply to this email directly or view it on GitHub (https://github.com/geekpgh/mastersproject/issues/51#issuecomment-20536249).

[steveplatz]

Go with what Azure said. I've never used it before and just assumed it was identical to SQL Server without fully thinking it through.

Steve Platz

On Friday, July 5, 2013 at 3:56 PM, geekpgh wrote:

I got those strings out of Azure itself. It has a "Your connection string page". Not sure if they are correct, but that is what azure claims we should use. j80li1ch8a is the server name, it generated it.

— Reply to this email directly or view it on GitHub (https://github.com/geekpgh/mastersproject/issues/51#issuecomment-20536358).

[steveplatz]

Just a thought, but since this project is public, its probably not best to put connection information in config files or discuss usernames and passwords in public places. I'm going to try to see if there's a good way to do this using a public github repo or if we'll need to include some manual steps. Once I figure that out, I'm going to delete the messages with the credentials.

[steveplatz]

The azure deployment is working. I followed the instructions located at https://github.com/projectkudu/kudu/wiki/Managing-settings-and-secrets in order to set up the connection string so we don't have to include it in our public configuration files.