I've been foraging through the forums for info about the GoDaddy situation. I have found several scattered threads about several different errors. What I can't seem to find is an installation guide for .net newbies.
I suspect with the help of others, I can compile a 1.2.3 walkthrough that would guide a user through the complete setup of the Club Site Starter Kit. I have access to GoDaddy hosting and have a test account that would be available.
Wish I would have had a walkthrough this morning. I was however able to muscle my way through most of it. However I would like to know how to do two things. One, if I cannot get access to the asp.net controls, how do I setup the smtp mail piece of the
club site. Two, GoDaddy has a database limit of 100mb for MS SQL. I plan to have a lot of albums and pictures on my site. How can I change the code so that the pictures do not reside in the database, rather and image folder?
Any help would be appreciated. Also if you would like some imput to the guide, let me know, I am willing to share the pains I endured...
I suspect that will probably fall outside of the scope of the initial version of the walkthrough. My goal will be to document those steps necessary to at least get the default site up and working. I'd like to see future versions of the walkthrough that
might add MaineOne's Admin functions, replace the News section with RSS feeds, etc.
Initially though, I felt it necessary to at least create a step by step walkthrough from download to publish. I think I have enough to publish the beta tomorrow. Then we'll have to have some way to check the steps and modify until we get a "finalized"
1.0 :)
I want to put thanks out ahead of time to MaineOne and btech_rohit for some critical pieces of info that I worked into my guide.
This has been a learning experience so far. I must say I called godaddy to see if they could identify what the issues are with loading the website and they provided no help.
Well thus far, I have been able to combine the databases and get the application to work on my local server.
However, I still could not get it to work on go daddy site.
I am not sure what I did after I got the site to work on the local server I have the following error
Message 1 Could not find schema information for the element 'http://schemas.microsoft.com/.NetConfiguration/v2.0:configuration'. C:\LOL3\LakesofLagunaHOA\Web.config 2 2 C:\LOL3\LakesofLagunaHOA\
Message 2 Could not find schema information for the element 'http://schemas.microsoft.com/.NetConfiguration/v2.0:location'. C:\LOL3\LakesofLagunaHOA\Web.config 3 3 C:\LOL3\LakesofLagunaHOA\
Message 3 Could not find schema information for the attribute 'path'. C:\LOL3\LakesofLagunaHOA\Web.config 3 12 C:\LOL3\LakesofLagunaHOA\
Message 4 Could not find schema information for the element 'http://schemas.microsoft.com/.NetConfiguration/v2.0:system.web'. C:\LOL3\LakesofLagunaHOA\Web.config 4 4 C:\LOL3\LakesofLagunaHOA\
Ok, here are the steps I took to get my site going at GoDaddy.
1. Make sure you have the ASP.net 2.0 runtime loaded.
2. Create your SQL Database with the ASP.Net 2.0 SQL Server Schema Features loaded.
3. Use the club-add.sql script in the App_Data folder of your club site (Assuming you haven't changed any of your tables) to create the tables in your db at GoDaddy using the query analyzer in you SQL Admin consel that GoDaddy provides.
4. After you have run your script you will notice that the table owners of the newly created tables belong to who the username you were logged in as rather than 'dbo'. This means you need to update your queries in you clubsite replacing the dbo.tablename
with godaddylogin.tablename.
5. Upload your site and the pages should load correctly. I do not think I am forgeting anything. You will need to use the role management pages that MaineOne created to manage the roles and assign them to users for your site. You will also need to modify
you mail settings in the web.config file. I posted something on this earlier in this forum.
FYI, after you change your query string as described above, it will not work locally. What I do is make changed locally and upload the updated pages to my GoDaddy site and test from there. If you have data in you local db that you need up to you GoDaddy
site, you will have to export them to a CSV or XML file and import them using the admin counsil. Good luck, the free SQL management tools that are available does not have export or import tools that I can find. Hope this help.
hey very good job on this, can't wait to try it myself
Have a Go Daddy / WWD question? PM Me!
Domains and Hosting at Airdepth.net - Free Web Software Install
Go Daddy / WWD Reseller Stores for less at Metrodatacenter.net with Personal Support
Sorry it took so long to get this posted. This is a step by step aimed for people who aren't all that familiar with this. This is geared to getting a default club site working on GoDaddy. I can't say its definitive, but it worked for me 3 times in row
from a scratch site. I'm also assuming you've downloaded VWD, club.vsi and the clubadd and clubremove scripts. It also assumes you'll be managing several different windows.
Create your site locally. Include AT LEAST 1 local admin account.
Run site using CTRL-F5.
Log into your GoDaddy hosting account and open the control panel.
Click on ASP.Net runtime and select 2.0
Click Databases > SQL Server > Create New Database.
Select
Check DSN (optional?)
Enter UserName (this will become the database name NOT your hosting login)
Enter Password (again, database password NOT hosting password)
Check "Install Schema Features"
Click Continue > Create Database (it WILL take some time for the database to create itself, you can refresh by clicking the SQL button in the left menu)
Once setup finishes, Click Pencil icon under actions > print this page.
Click Computer icon under actions > record the SQL Connection (.NET) strings
Click Open Manager
Click Connection > Enter the Username and Password from 6 above.
Once connected, expand Tools menu > Click Query Analyzer
Cut & Paste all text from club-add.sql into the Query Analyzer window
Click Submit (you should see many "command(s) completed successfully" below)
Go back to VWD and edit default.aspx
Go to Edit > Find & Replace > Quick Replace
Find dbo. (NOT Dbo. big difference)
Replace with <blank> (nothing, nada, zip, zero)
Look in: Current Document
Click Replace All (should be 12 or more) > Save default.aspx
Run CTRL-F5 again. (it will bring up a window with a server error, what you want is to look in the lower
left corner of the VWD window for "Build Successful")
Click Website > Copy Web Site > Connect
Input your hosting username and password (NOT you database uid and pwd)
Highlight all files from the left side and click right arrow to transfer.
Go to your public website and create an account for each admin you created on your local database. (make
sure the usernames and passwords are the same!!!)
Log back into Query Analyzer
Input
SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"
Copy bracketed response into a text document and include the brackets
Reset QA and Input
SELECT UserId FROM aspnet_Users WHERE UserName="username"
Copy each bracketed response to your text document.
Reset QA again and Input
INSERT INTO aspnet_UsersInRoles (RoleId, UserID) VALUES ('copied text from 29', 'copied text from 31')
Repeat 28-32 for each admin account.
Welcome to your club site on GoDaddy!
Thanks to MaineOne and btech_rohit for insight into this problem!
BoosterMan
Member
35 Points
7 Posts
GoDaddy Installation Walkthrough
Mar 08, 2006 05:53 PM|LINK
I've been foraging through the forums for info about the GoDaddy situation. I have found several scattered threads about several different errors. What I can't seem to find is an installation guide for .net newbies.
I suspect with the help of others, I can compile a 1.2.3 walkthrough that would guide a user through the complete setup of the Club Site Starter Kit. I have access to GoDaddy hosting and have a test account that would be available.
If there is such interest please let me know.
BoosterMan
hackneys
Member
215 Points
43 Posts
Re: GoDaddy Installation Walkthrough
Mar 08, 2006 10:05 PM|LINK
Wish I would have had a walkthrough this morning. I was however able to muscle my way through most of it. However I would like to know how to do two things. One, if I cannot get access to the asp.net controls, how do I setup the smtp mail piece of the club site. Two, GoDaddy has a database limit of 100mb for MS SQL. I plan to have a lot of albums and pictures on my site. How can I change the code so that the pictures do not reside in the database, rather and image folder?
Any help would be appreciated. Also if you would like some imput to the guide, let me know, I am willing to share the pains I endured...
Shane L. Hackney
BoosterMan
Member
35 Points
7 Posts
Re: GoDaddy Installation Walkthrough
Mar 09, 2006 03:28 AM|LINK
I suspect that will probably fall outside of the scope of the initial version of the walkthrough. My goal will be to document those steps necessary to at least get the default site up and working. I'd like to see future versions of the walkthrough that might add MaineOne's Admin functions, replace the News section with RSS feeds, etc.
Initially though, I felt it necessary to at least create a step by step walkthrough from download to publish. I think I have enough to publish the beta tomorrow. Then we'll have to have some way to check the steps and modify until we get a "finalized" 1.0 :)
I want to put thanks out ahead of time to MaineOne and btech_rohit for some critical pieces of info that I worked into my guide.
Look for the post tomorrow!
BoosterMan
hackneys
Member
215 Points
43 Posts
Re: GoDaddy Installation Walkthrough
Mar 09, 2006 01:03 PM|LINK
Ok, to answer my own question one, to solve the problem with email settings at GoDaddy, ad the following to the web.config file;
<system.net>
<defaultProxy>
<proxy usesystemdefault="False" proxyaddress="http://wc-v01.inet.mesa1.gdg:3128" bypassonlocal="False" />
</defaultProxy>
</system.net>
<system.net>
<mailSettings>
<smtp deliveryMethod="network" from="youemail@yourhost.com">
<network
host="relay-hosting.secureserver.net"
port="25"
defaultCredentials="true"
/>
</smtp>
</mailSettings>
</system.net>
Enjoy...
Shane L. Hackney
vb2006
Member
45 Points
9 Posts
Re: GoDaddy Installation Walkthrough
Mar 10, 2006 04:28 AM|LINK
hi everyone,
This has been a learning experience so far. I must say I called godaddy to see if they could identify what the issues are with loading the website and they provided no help.
Well thus far, I have been able to combine the databases and get the application to work on my local server.
However, I still could not get it to work on go daddy site.
I am not sure what I did after I got the site to work on the local server I have the following error
Message 1 Could not find schema information for the element 'http://schemas.microsoft.com/.NetConfiguration/v2.0:configuration'. C:\LOL3\LakesofLagunaHOA\Web.config 2 2 C:\LOL3\LakesofLagunaHOA\
Message 2 Could not find schema information for the element 'http://schemas.microsoft.com/.NetConfiguration/v2.0:location'. C:\LOL3\LakesofLagunaHOA\Web.config 3 3 C:\LOL3\LakesofLagunaHOA\
Message 3 Could not find schema information for the attribute 'path'. C:\LOL3\LakesofLagunaHOA\Web.config 3 12 C:\LOL3\LakesofLagunaHOA\
Message 4 Could not find schema information for the element 'http://schemas.microsoft.com/.NetConfiguration/v2.0:system.web'. C:\LOL3\LakesofLagunaHOA\Web.config 4 4 C:\LOL3\LakesofLagunaHOA\
and this goes onnnn.
Any suggestions on what I messed up?
hackneys
Member
215 Points
43 Posts
Re: GoDaddy Installation Walkthrough
Mar 10, 2006 01:22 PM|LINK
Ok, here are the steps I took to get my site going at GoDaddy.
1. Make sure you have the ASP.net 2.0 runtime loaded.
2. Create your SQL Database with the ASP.Net 2.0 SQL Server Schema Features loaded.
3. Use the club-add.sql script in the App_Data folder of your club site (Assuming you haven't changed any of your tables) to create the tables in your db at GoDaddy using the query analyzer in you SQL Admin consel that GoDaddy provides.
4. After you have run your script you will notice that the table owners of the newly created tables belong to who the username you were logged in as rather than 'dbo'. This means you need to update your queries in you clubsite replacing the dbo.tablename with godaddylogin.tablename.
5. Upload your site and the pages should load correctly. I do not think I am forgeting anything. You will need to use the role management pages that MaineOne created to manage the roles and assign them to users for your site. You will also need to modify you mail settings in the web.config file. I posted something on this earlier in this forum.
FYI, after you change your query string as described above, it will not work locally. What I do is make changed locally and upload the updated pages to my GoDaddy site and test from there. If you have data in you local db that you need up to you GoDaddy site, you will have to export them to a CSV or XML file and import them using the admin counsil. Good luck, the free SQL management tools that are available does not have export or import tools that I can find. Hope this help.
vb2006
Member
45 Points
9 Posts
Re: GoDaddy Installation Walkthrough
Mar 10, 2006 07:11 PM|LINK
Thanks for your help..
In your web config file. What did you use as your connections string to go daddy server?
<connectionStrings>
<add name="ClubSiteDbConnect" connectionString="
Server=whsql-v06.prod.mesa1.secureserver.net;
Database=DB_41701;
User ID=myid;
Password=myPassword;
Trusted_Connection=False" providerName="System.Data.SqlClient"/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="
Server=whsql-v06.prod.mesa1.secureserver.net;
Database=DB_41701;
User ID=myid;
Password=mypassword;
Trusted_Connection=False" providerName="System.Data.SqlClient"/>
</connectionStrings>
-->Thanks for your help.
hackneys
Member
215 Points
43 Posts
Re: GoDaddy Installation Walkthrough
Mar 13, 2006 01:38 PM|LINK
<
connectionStrings><
add name="ClubSiteDB" connectionString="Server=tcp:whsql-v07.prod.mesa1.secureserver.net; Database=DB_45532; User ID=myusername; Password='mypassword'; Trusted_Connection=False" providerName="System.Data.SqlClient" /><
remove name="LocalSqlServer"/><
add name="LocalSqlServer" connectionString="Server=tcp:whsql-v07.prod.mesa1.secureserver.net; Database=DB_45532; User ID=myusername; Password='mypassword'; Trusted_Connection=False" providerName="System.Data.SqlClient" /></
connectionStrings>mannyd
Member
560 Points
114 Posts
Re: GoDaddy Installation Walkthrough
Mar 15, 2006 03:47 AM|LINK
Domains and Hosting at Airdepth.net - Free Web Software Install
Go Daddy / WWD Reseller Stores for less at Metrodatacenter.net with Personal Support
BoosterMan
Member
35 Points
7 Posts
Re: GoDaddy Installation Walkthrough
Mar 17, 2006 02:33 AM|LINK
Sorry it took so long to get this posted. This is a step by step aimed for people who aren't all that familiar with this. This is geared to getting a default club site working on GoDaddy. I can't say its definitive, but it worked for me 3 times in row from a scratch site. I'm also assuming you've downloaded VWD, club.vsi and the clubadd and clubremove scripts. It also assumes you'll be managing several different windows.
<add name="ClubSiteDB" connectionString="Data Source=.\SQLExpress;
Integrated Security=true;
AttachDBFileName=|DataDirectory|Club.mdf;
User Instance=True" providerName="System.Data.SqlClient"/>
With new text
<add name="ClubSiteDB" providerName="System.Data.SqlClient"
connectionString="server=whsql-v04.prod.mesa1.secureserver.net;
database=DB_12345;
uid=myusername;
pwd=mypassword"/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" providerName="System.Data.SqlClient"
connectionString="server=whsql-v04.prod.mesa1.secureserver.net;
database=DB_12345;
uid=myusername;
pwd=mypassword"/>
Change <customErrors mode="Off" /> (optional)
Save!!!
Run CTRL-F5 again. (it will bring up a window with a server error, what you want is to look in the lower left corner of the VWD window for "Build Successful")
Click Website > Copy Web Site > Connect
Input your hosting username and password (NOT you database uid and pwd)
Highlight all files from the left side and click right arrow to transfer.
Go to your public website and create an account for each admin you created on your local database. (make sure the usernames and passwords are the same!!!)
Log back into Query Analyzer
Input
SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"
Copy bracketed response into a text document and include the brackets
Reset QA and Input
SELECT UserId FROM aspnet_Users WHERE UserName="username"
Copy each bracketed response to your text document.
Reset QA again and Input
INSERT INTO aspnet_UsersInRoles (RoleId, UserID) VALUES ('copied text from 29', 'copied text from 31')
Repeat 28-32 for each admin account.
Welcome to your club site on GoDaddy!
Thanks to MaineOne and btech_rohit for insight into this problem!
BoosterMan