Forums (Obsolete)

Member

PG - 9/16/2008 10:57:16 AM

Godaddy Database

Hi,
I am trying to deploy Kentico on Godaddy.
I have successfully copied all files, created a SQL Server database and made the necessary web.config update as outlined in http://www.kentico.com/docs/devguide/index.html?installation_on_shared_hosting.htm. However in the second step of the installation, I keep getting the message "The database 'xxx' doesn't exist!". I know for sure that all the parameters I have put in are correct, but for some reason, Kentico cannot "see" the database. How can I go ahead with the installation? Is there a way I can create an external db with the objects and publish it, update the connection string and proceed from there?

Any help would be much appreciated. Thx.

Member

pallu-geocities - 9/16/2008 5:15:58 PM

RE:Godaddy Database

I finally succeeded in setting it up on GoDaddy. I created a site on the local m/c just as it is outlined in the http://www.kentico.com/docs/devguide/index.html?installation_on_shared_hosting.htm. However, I created a sample site and then with the help of the Database Publishing Wizard, I exported the local database to GoDaddy. After that I copied all the files from the local machine to GoDaddy, made the necessary connection string and the extra key change in web.config and I was up and running!

Member

Elijah - 10/8/2008 7:25:52 PM

RE:Godaddy Database

I had the same problem. I eventually tracked it down to the function in the installation function library - it runs some sql to determine if the database exists by checking the sysdatabases table in the master db.

Godaddy refuses to return your real database in the list. Kentico receives this info and concludes that the database doesn't exist.

I've contacted support and let them know of the issue; they've graciously accepted my information and plan to find some way to help the issue in future versions.

To get mine working, I had to modify the check procedure to always return true for my database name - it's a silly thing to do in the long term, but it got it working!


Member	scowalters - 1/23/2009 12:02:19 AM RE:Godaddy Database How did you modify the check procedure? I use sql server 2008 so the csv export is pretty tedious, using powershell it still takes a long time. I would rather just modify a sql script and use the zip file that was exported. I am also on GoDaddy shared hosting and have this problem. They haven't had a fix for it, unfortunately.

Member

Elijah - 1/23/2009 8:44:56 AM

RE:Godaddy Database

Disclaimer: Make changes to the Kentico-provided code at your own risk. Triple check everything you do before deploying, and document your changes properly.

For Kentico 3.1a:

App_Code\CMSDesk\InstallerFunctions.cs

At line 152 there's a method called DatabaseExists. I just put in some code at the top of the method to check the input value for my database name and return true if it matches. It's assuming the database exists based on the exact name instead of checking with the server. It's a dangerous way to run, but in a controlled environment, it works.


Member	scowalters-gmail - 1/23/2009 2:38:24 PM RE:Godaddy Database yeah there's no way the name can change so that sounds like a good idea. thanks man