Successful installation with godaddy webhost
zeus182 - July 6, 2006 - 17:58
Can someone who has successfully set up a drupal site on the godaddy webhost please give me instructions for installing drupal. I set up my database through godaddy, but drupal appears to be unable to connect even though I'm sure I have all the database name, userid, password, etc. correct. I have used the mysql database set-up before with other php programs with no problems. I have read some of the past posts on go daddy and on installation, but all posts have just a little info--I need some complete instructions. I've watched the installation tutorial, but with godaddy I don't have the same set-up options that are shown in the tutorial. Can anyone help?
Don't bother with GoDaddy
GoDaddy is a piece of junk of a webhost--my company has a site hosted by them, and they're ridiculous. They are running mySQL 3!... I can't remember which version of PHP. Also, our script times out connecting to MySQL all the time... God knows why. Probably their server is overloaded.
Save yourself a lot of time and get a better host. Also, GD is so freaking huge that they won't give you any help or personal attention.
A couple of hosts that are good:
DreamHost.com
BlueHost.com
I have personally been with BlueHost for about a year now and I've been very happy with them. Also, BlueHost (and probably DreamHost) has Fantastico which will install Drupal and dozens of other blogs, cms, galleries, with one click. The interface is also way simpler, faster, and easier to get around.
So I think you should dump GoDaddy and get a better host. Then this will go way more smoothly.
-dgp
GoDaddy works great!
I have been using GoDaddy for about a year and have had absolutely no problems with them. I installed Drupal and everything went FLAWLESSLY. I didn't need to change any settings or code, it just worked right away.
Successfull GoDaddy Installation (almost)
I was able to install Drupal on GoDaddy (www.greatbigtelephonepole.com & www.doansrus.com).
It took me a while to figure it out.
1. I uploaded all the files in the Drupal download using Filezilla.
2. I created the database in the GoDaddy hosting site.
3. I uploaded the database/database.4.0.mysql file to the database to create the tables.
4. I edited the sites/default/settings.php file by adding the database name, password and location, etc.
After that, it just worked. I did it twice: once with the free hosting that came with the domain name, and one with the deluxe hosting that I pay for.
My hosting service is Linux.
The only problem I'm having is that the search function gives me a big red error that looks like something is missing in the MySQL database. (If anyone knows what that's all about, I would be happy to take suggestions.)
Geremia Doan
Mysql permissions
The Drupal mysql user must have permission to create temporary tables and lock tables on the database you're using.
* user warning: Access denied for user: 'GBTPCOM@%' to database 'GBTPCOM' query: CREATE TEMPORARY TABLE temp_search_sids SELECT i.type, i.sid, SUM(i.score * t.count) AS relevance, COUNT(*) AS matches FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid WHERE n.status = 1 AND (i.word = 'foo') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 in /home/content/G/B/T/GBTPCOM/html/includes/database.mysql.inc on line 120.* user warning: Table 'GBTPCOM.temp_search_sids' doesn't exist query: SELECT MAX(relevance) FROM temp_search_sids in /home/content/G/B/T/GBTPCOM/html/includes/database.mysql.inc on line 120.
Re: MySQL Permissions in GoDaddy Hosting
Oh...
I have been digging through the forum, and I am certain that GoDaddy won't give me permission to create lock tables.
I guess I'll turn off the search function until I can figure something else out.
Geremia Doan
Fix for search problem
I have a site on GoDaddy, and yes, the permissions thing mentioned messes up the search. But the SQL Search module (found here ) WILL work. You also need the Poor Man's Cron module (found here ) to get around the cron limitations.
The Definitive Guide to Installation using GoDaddy Linux Hosting
I moved to the 2.0 Linux Setup before I even installed Drupal
Directions for setting up Drupal on a GoDaddy Site:
You can ignore step one in the INSTALL.txt file because you will be following a slightly different procedure for setting up the database.
1. upload all the drupal installaion files and directories (I made a folder called drupal and put everything in that).
2. Set up a SQL database from the Linux Hosting Control Panel by clicking MySQL, clicking "Create New Database", choose a username and password (used by the settings.php and for PHPMyAdmin file NOT used by the Drupal user). Then review settings and click "Create Database". You probably have to wait awhile for the database to be set up.
3. Refer to the File "INSTALL.txt" that comes with the installation for more guidance and instructions. When the database is set up (Open Manager is available from the Control Panel), Click "Open Manager" and use the user and pass you chose in #2 to login to PHPMyAdmin.
4. Load the database file for MySQL 4.0 or lower (database.4.0.mysql) by clicking the SQL Query Window button (SQL icon). Click the "Import Files" tab.
5. Modify (and upload) settings.php with changes to the $db_url variable (read comments in settings.php).
6. You are all set up. Go to the url for your site.
Notes: I set up special subdomains for my sites such as http://blog.jbchurchill.com/ and http://guestbook.bartonhighalumni.com/. When I set up those subdomains through domain management on the control panel, I set them ALL up to point to the same location on the server (my drupal folder where the drupal installation resides).
Then (as described in the settings.php file itself !) in the sites folder I create a new folder (see example folder names below) and copy my settings.php file into the new folder and modify the $db_url variable as described in the comments within settings.php to reflect the new database settings.
$db_url = 'mysql://username:password@localhost/databasename'
on godaddy localhost is something like mysql###.secureserver.net (where the ###'s are some number that you get) also the username and database name are going to be the same username and password you gave when you set that up in the control panel in step 2 (above).
example folder names:
blog.jbchurchill.com
guestbook.bartonhighalumni.com
Best of Luck to anyone doing this. I found it very easy to install using version 4.7 !!!
J.B. Churchill
My Sites:
http://www.jbchurchill.com/ (static)
http://blog.jbchurchill.com/ (drupal)
http://blog.al.umces.edu/jchurchill (drupal)
Ahhh!
Nevermind.. Signed up with bluehost and it works perfectly. Don't use godaddy!
godaddy install
Thanks JB! Your instructions were a lifesaver, I knew I had to get some tables into my database, but i just couldn't figure out how to do it. Its very easy once you find the posts about changing the settings.php and importing the tables into the database...
update these instructions for drupal 5.1 please?
greetings,
can you update this info for how to make drupal 5.1 work with linux shared hosting on godaddy.com
you might just save my life if you do!
thanks so much!
agenthandy
----------------------------------agenthandy
handyaway@yahoo.com
GoDaddy Manual Install of Drupal 5.2
I did a manual Drupal install, instead of the automatic Metropolis install.
My client is running GoDaddy's Deluxe Hosting - Linux - 1 year package and I've been relatively impressed
with the options. You are allowed to select MySQL 4 or MySQL 5 (preferred) and enabling there Hosting 2.0 configuration
will allow PHP4 or PHP5 (preferred).
Drupal's .htaccess worked without any configuration issues, so it appears Apache mod_rewrite and rewrite_module
are enabled by default. Which is good, because I haven't seen where you can edit the Apache Configuration
(httpd.conf). It also offers a somewhat restricted version of phpMyAdmin. The restriction is you can't change MySQL
user permissions, so there is just one full privilege MySQL user account for each database.
Steps I followed for a manual install. Again, the link above discusses an automated install. I prefer to have
control over things, so I went this route.
1) Setup GoDaddy Deluxe Hosting - Linux (or similar shared hosting package). Actually, this was already setup for me by the client.
2) FTP to your domain and upload the latest version of Drupal in the root of the server.
3) Login to GoDaddy and select Hosting & Servers >> My Hosting Plans
4) In the list of your domains, click the "Open" link under the "Control Panel" column for the domain where Drupal files were FTP'ed.
5) This opens the Hosting Control Center. Go to Databases >> MySQL
6) Click the Create Database button
7) Enter a description, username/database, password, and select MySQL 5.0. Then click OK and wait a few minutes for the database to be created. The username and database name are the same (which you can't change). This value will be used in step 10 (the Drupal install/setup).
8) Press the Home link and see the Account Summary section. Ensure the Hosting Configuration: shows 2.0. If not, follow these instructions on how to To upgrade to Hosting Configuration 2.0
9) In the top/root level folder of the FTP (where you uploaded Drupal files), edit the .htaccess file and follow these instructions on How do I use htaccess to manage my PHP file extensions. This will make PHP5 the default. Simply paste those two lines of code somewhere near the top of the .htaccess.
10) Visit your site to get to the Drupal Install page. Note, GoDaddy does not use "localhost" for the database connection. Instead, follow these instructions to learn What Server I Should Use in My Code to Connect to My Database?.
The rest of the steps should be as described in the Drupal install.txt, with a few exceptions.
- MySQLi connections don't appear to be available, which is preferred with MySQL5, but not necessary.
- The database host name will not be "localhost", but instead will be a unique value, as described in step in step 10 above. It will be something like ***mysql**.secureserver.net
OrangeCoat.com
@instructions
That was flawless, perfect. Thank you very much, it saved me a lot a time. ^_^
---------------------------------------------------
:: http://www.federicopistono.org
Fro Drupal 5.2, my problem was the Windows Server & PHP 4.1.
I did all the steps as above with a Windows Server & MySQL 4.1, No go.
I switched it to Linux and MySQL 5.0 while modifying the .htaccess file. PERFECT!
Thanks for saving me a few days hastle and money switching to a new host.
Perfect instructions. Thank
Perfect instructions. Thank you very much for the post.
update for drupal 5.1 please?
greetings,
can you update this info for how to make drupal 5.1 work with linux shared hosting on godaddy.com
thanks so much!
agenthandy
----------------------------------agenthandy
handyaway@yahoo.com
Godaddy and Drupal 5.1
agenthandy -
This is what i came up with. I'm new with drupal, but with the help above I got it working for 5.1. Upload all the files and create the table in your godaddy hosting. The trick is to make sure your settings.php file is set up correct. You may have to go into your godaddy account and set up a username and password for your database (may not generate this automatically when you create the database originally). Then, make sure to put your username and password for your database into the settings.php file (in the $db_url variable) along with godaddy's equivalent for localhost (not localhost, godaddy is a bit different). You can find the correct terminology in your hosting information. If you go to your control panel for your godaddy account, then go to mysql and then click on your database name it will show you the "host." This is what you type into the settings.php in place of localhost. Then I tried to access my drupal site and it worked. Let me know if this helped! The install.inc should automatically run and set up all necessary entries in your database.
help to port over a drupal5.1 to godaddy
Hi agenthandy,
Please help, I am in a similar situation.
* I have a drupal 5.1 site on my localhost that needs to be ported to my godaddy hosting account. Note- not a new install.
* I have ftp all files to godaddy.
* godaddy is Host Config 2.0
* I have created a blank Mysql database in godaddy.
* I have customized the setting.php with the correct $db_url.
* I have then tried to import the file database.mysql.inc from my drupal/includes to create the tables needed. This creates an Error page.
* I am unable to find within the drupal 5.1 a /database folder nor the database.4.0.mysql or database4.1.mysql files. I have re-downloaded a drupal 5.1 and there is still no reference to the mentioned files. Am i missing something important here? My localhost drupal 5.1 site works fine without any errors on my computer. Are these files only relevant to earlier drupal releases? Then how does one port over a drupal 5.1 with database to a host?
I have searched the drupal.org and most comments are old and mainly refer to earlier drupal versions. It would be nice to find a how-to for 5.1. Can you help?
This is the error message i am getting in godaddy;-
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 1
STR: <?
SQL: <?php
// $Id: database.mysql.inc,v 1.66.2.1 2007/01/22 02:20:50 unconed Exp $
/**
* @file
* Database interface code for MySQL database servers.
*/
/**
* @ingroup database
* @{
*/
/**
* Report database status.
*/
function db_status_report($phase) {
$t = get_t();
SQL query:
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?php
// $Id: database.mysql.inc,v 1.66.2.1 2007/01/22 02:20:50 unconed Exp $
' at line 1
=-=
database.mysql.inc is a PHP program not a SQL program!
You don't find a SQL program with the SQL statements to create the tables like in drupal 4.x, because now the tables are created by the install program...
Have you tried to point your browser to your-base-url/install.php?
Thanks!
Hey brei2007,
This worked for me, after I ran install.php and update.php. (http://drupal.org/node/86865#comment-242505)
Thanks Much!
-NP
drupal 5.1 and godaddy
Hi I am trying to setup drupal on godaddy. I changed the setting.php file as previously described in many posts. However I get an error and I don't know how to import the mysql database with drupal 5.1 with a file to import to mysql. Anyone know how I can get past this. I get this error:
Warning: Table 'drupalharvestime.access' doesn't exist query: SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('71.239.31.154') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1 in /home/content/c/d/h/cdhf2632/html/includes/database.mysql.inc on line 172
Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/content/c/d/h/cdhf2632/html/includes/database.mysql.inc:172) in /home/content/c/d/h/cdhf2632/html/includes/bootstrap.inc on line 811
Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/content/c/d/h/cdhf2632/html/includes/database.mysql.inc:172) in /home/content/c/d/h/cdhf2632/html/includes/bootstrap.inc on line 811
Warning: Table 'drupalharvestime.cache' doesn't exist query: SELECT data, created, headers, expire FROM cache WHERE cid = 'variables' in /home/content/c/d/h/cdhf2632/html/includes/database.mysql.inc on line 172
Warning: Table 'drupalharvestime.variable' doesn't exist query: SELECT * FROM variable in /home/content/c/d/h/cdhf2632/html/includes/database.mysql.inc on line 172
Warning: Table 'drupalharvestime.cache' doesn't exist query: LOCK TABLES cache WRITE in /home/content/c/d/h/cdhf2632/html/includes/database.mysql.inc on line 172
=-=
Point your browser to base_url/install.php, this way the install program get executed (it will create the tables for you).
Hosting drupal on godaddy ... a clarification needed.
I would like to know if Godaddy provides cron access in their web hosting packages. This is because in drupal the search function works only with the help of cron.
If the people hosting godaddy account can kindly clarify this doubt it would be fine.
Cheers
--
http://linuxhelp.blogspot.com
GoDaddy does not have cron
GoDaddy does not have cron access, but I've had success with Poor Man's Cron (http://drupal.org/project/poormanscron).
The only thing on GoDaddy that I'm having problems with is Clean URLs. I had Drupal installed on a subdirectory, and Clean URLs worked fine, but now that I've moved it to the root directory, they don't work. Has any one had a similar experience?
I've played with the RewriteBase line in .htaccess, but that hasn't changed anything. I read one comment that GoDaddy has an .htaccess cache that's probably getting in the way. Is this true? Do I just need to wait for the cache to clear?
what does clean urls look like on drupal?
or what does non-clean urls look like? i have clean urls turned on w/ my godaddy hosted acct, but don't notice any difference in urls. can someone point me to an example of either/both?
Clean URLs
Hey shmooth,
Clean URLs removes the "?q=" from your paths. (www.yoursite.com/?q=admin vs. www.yoursite.com/admin)
This helps search engines (and people!) find your pages more easily.
http://drupal.org/node/15365
-NP
didnt even know that.
i am new to everything. i am trying to add a ratings module to my godaddy hosted drupal based website.
i downloaded the module, then downloaded a program to unzip it. this took three days to figure out.
then i went to the control panel within godaddy, then file manager. i created a new folder under the modules folder called rating, i then uploaded all the files that came with the module downloaded from drupal. this didnt work, so i started to delete some of the files and finally had a combination that began to upadate on my site, it took about an hour and half, so i refreshed the page, and now it will not upload again.
help
Hope this helps
Hey SlickJimmy,
I'm kind of a noob here, myself, and I don't have a direct answer to your question.
Here are some things that might help making Drupal work better for you:
A great open source program for uncompressing files is 7-zip. You can download the .tar, move it to a folder on your harddrive and "extract here." I have a local library of modules; if you install and unistall as much as I do (or build multiple sites) it's a lot quicker to reference locally than redownloading each time you'd like to use it. Be sure to check your modules for updates periodically! It's also a great idea to check out the readme file. Most modules are a single download, but a few I've seen require additional files. The readme will tell you where to find them.
Rather than creating folders via the GoDaddy interface, I'd recommend using a FTP program. I use FireFTP which is a free FireFox plug in, but if you search the net for "Free FTP," you'll have more choices than you'd ever need.
Contributed modules should not be placed in the core modules folder (I know, this confused me, too!) Instead, create sites/all/modules. This will help you when it's time to update to a new version of Drupal.
Here is my process for installing modules: (see http://drupal.org/node/70151)
I download the module to my hard drive
I uncompress it
I upload the folder extracted from the module to sites/all/modules
I enable it at administer/modules
I run update.php
I check permissions
As for the problem at hand; What files did you delete? If they are contributed modules, I don't know why removing them would crash your site (although in the future, I'd be certain to disable via administer/modules before you delete.) You might want to check your list of modules and uncheck any you've deleted. (Don't know if they would be listed; could there be code that hangs on after an active module is deleted?) If they are core, I'd have to start from a fresh Drupal install rather than troubleshoot which files are missing.
I've never done it, but I know it is possible to backup your database, reinstall Drupal, and reconnect. (Click the "Open Manager" link next to your GoDaddy database to launch myPhpAdmin.) This way you won't loose any data.
I hope this helps!
-NP
thanks
i did not crash my site. i upload all the files that came with the rating module, and when it didnt work on update.php, i checked some of the other modules and saw they only the .info, .module, and .install files with a few .png too, so i deleted the .dat and other files.
when you say to create sites/all/modules, where? is it new folder? on my harddrive or godaddy account?
also, would i have to run update.php before enable it at administer/modules?
thank you for all the info, i understand this stuff a little better now.
Hey
Hey SlickJimmy,
>when you say to create sites/all/modules, where? is it new folder? on my harddrive or godaddy account?
These would be folders. If you are working on a localhost, it would be on your harddrive, if your working on a live site, it would be on your webserver. Check out #3 for more info: http://drupal.org/node/70151.
>also, would i have to run update.php before enable it at administer/modules?
I'd enable the module first. When you do, there will be a note at the top of your page telling you to run update.php.
-NP
There is a cron manager in
There is a cron manager in the hosting control center under content. I was able to trigger Drupal's maintenance tasks with the command of "curl -silent -compressed http://yoursite.com/cron.php" (without quotes).
Thanks manerhabe
This worked perfectly with my GoDaddy shared hosting.
GoDaddy Cron Job / Tabs
I haven't used it yet, but there appears to be a configuration page for Content >> Cron Manager
within GoDaddy's Hosting Control Center.
Has anyone successfully used
Has anyone successfully used domain masking with multiple domains and multisite? The auto install of drupal on GoDaddy creates a ./drupal folder in the root, and I'm having some problems with multisite and multiple domains.
See: http://drupal.org/node/185239#comment-284209
Thanks,
B
Installing Drupal in GoDaddy Hosting
Just to let you all know that it is an easy and straightforward installation.
All went well and no road bumps in the process.
More credit to Drupal's architecture than Godaddy's service.
Cron works
Clean URLS
Themes , the works.
No problems. Maybe they read your comments and improved the service. LOL
Andre
Worked great, thanks so
The manual install ( http://drupal.org/node/72477#comment-273069 ) worked great, thanks so much!
Clean URL not working - Godaddy/Multiple domains in one hosting
I installed Drupal on a Godaddy hosting account. This account is used by several domain names and Clean URL's is working only when using the main domain. I'm not talking about subdomains, it's about several domains pointing the same account: XXX.com/YYY.com/ZZZ.com all pointing the same hosting account.
When I run the Clean URL test using XXX.com it runs flawlessly. When I change the domain name it returns 400 bad request.
Drupal was installed automatically by Godaddy and pointing to the right domain in a subdirectory (RewriteBase changed).
Status report:
Drupal 5.5
Configuration file Protected
Cron maintenance tasks Last run 33 min 15 sec ago
You can run cron manually.
Database schema Up to date
File system Writable (public download method)
MySQL database 5.0.45
PHP 4.3.11
Unicode library Standard PHP
Operations on Unicode strings are emulated on a best-effort basis. Install the PHP mbstring extension for improved Unicode support.
Web server Apache
Contributed Modules missing frm Admin->sitebuilding->modules
Hi
I am having goaddy linux hosting. The fresh install of drupal was fine, but when I add modules to sites/all/modules , e.g. , taxonomy_breadcrumbs etc. they don't appear in the
administer -> site building -> module
Any idea what I am missing. It seems to be a problem with godaddy because on my localhost the modules appeared automatically after adding the module directory to sites/all/modules.
Please help
Trouble installing drupal on godaddy caused by collapsible
I am having trouble installing drupal 5.7 on godaddy. For some reason when I get to the Database Configuration page the advanced options can not be shown.
This is a problem as the mysql server is not on the same server as the web server. Anyone have any idea what might be causing this? The godaddy provided 6.x version works fine but does not need to be configured and 6.x is still very limited in the module support so I would prefer to use 5.7 for now.
Thanks
In godaddy when you click
In godaddy when you click that pencil next to a database , it shows you the real url you need for the database (it is not the p3mysqladmin page).
You can set the location,password and username of your db manually in drupal by browing to drupal folder/sites/default/settings.php. Just replace the values in db_url variable with your values.
$db_url = 'mysql://YOURUSERID:YOURPASSWORD@THELOCATION.NET/YOURUSERID';
In Godaddy usually the user name and database name are always the same.
Ali Hammad Raza
WordsValley
The answer AT LAST!
Many thanks to alihammad for the KEY to ending many hours of frustration and unproductive time on the phone with GoDaddy support (at least they DO answer the phone and talk to you!).
The following fix template was THE ANSWER where all other attempts failed miserably:
$db_url = 'mysql://YOURUSERID:YOURPASSWORD@THELOCATION.NET/YOURUSERID';