By rays on

Hi All,

Has anyone had experience with hosting Drupal on a Yahoo! Small Business hosting account? I have the web hosting "standard" level of service... which seems to support php-nuke, but makes no mention of Drupal. I've developed my site with the Yahoo! SiteBuilder software, but really need the features of Drupal. Any testimonials or thoughts would be appreciated.

Thanks,
Ray

Comments

sami_k’s picture

sami_k commented

It's relatively likely that if phpNuke runs fine Drupal will too.

--
Please read the handbook, search the forums, then ask...
http://drupal.etopian.net (Modules and Drupal Services)

purpleeor@purpleeor.com’s picture

purpleeor@purpleeor.com commented

I currently have two sites deployed on Yahoo! standard hosting. What information do you need? check out http://www.purpleeor.com and http://www.subrogator.com, then tell me what more information you need.

- Eor

rays’s picture

rays commented

Hi Eor!

Thanks for your reply. Nice work on the subrogator site! Glad to hear (and see) that someone has Drupal up and running on Yahoo. I'm inspired now! I have Drupal up and running in a WAMP5 environment... but having more difficulty getting a copy up and running on Yahoo. I'm sure it's a self inflicted wound now. :)

I can't get past an error "Lost connection to MySQL server during query" when I first hit my site. So Drupal never starts or, more accurately, presents me with a screen of any kind.

However, there is a likely suspect... the .htaccess file. I haven't figured out how to get it on the server with dropping the "dot" at it's beginning. My FTP software and Yahoo's File Manager can't handle a "dot" with nothing in front of it... I guess. That said, in reading some of the postings here, I get the impression that it is only used under certain circumstances... like clean URLs. But I could be wrong.

Any how, if you could let me know what software you used to upload the .htaccess file, that would be very helpful. Also, let me know if you have experienced the error message that I did.

Thanks again,
Ray

purpleeor@purpleeor.com’s picture

purpleeor@purpleeor.com commented

Ray,

I never did get the .htaccess files up on my site. I just deleted them. They are mainly useful for cleanURLs and limiting access to certian directories from the outside. I haven't yet figured out how to replicate those features some other way with Yahoo!, but I will.

As for the "Lost connection to MySQL server during query" error, the problem is that the host for the MySQL server is not 'localhost'. It is 'MySQL'. To make Drupal work with Yahoo!, you need to edit your sites\%site name%\settings.php. change the line that says: $db_url = 'mysql://username:password@localhost/database'; to $db_url = 'mysql://username:password@MySQL/database';.

The 'MySQL' needs to be exactly like that, and be sure to insert your correct database information.

Let me know if this helps.

- Eor

rays’s picture

rays commented

Hi Eor,

The change from localhost to MySQL is exactly what was needed. It works fine now! Thanks again for your help :)

Ray

rhinoceros’s picture

rhinoceros commented

Hi Eor,

Do you mind to list a short summary on how to install Drupal on Yahoo hosting?

What I have done is just to transfer all files in Druapl folder into my ftp folder, but I get something similar to Ray's previous error,
it is
"unable to select database"

thanks,

Jerry

sangamreddi’s picture

sangamreddi commented

Hi,

It works on yahoo hosting. i tried for my friend and all went well expect the clean urls.
Because yahoo won't accept .httaccess file while you upload. apart from that everything is fine.

I think we can ask the yahoo customer support to upload the .httaccess file.

Sunny
www.gleez.com

opensourcepal’s picture

opensourcepal commented

I am also thinking of using yahoo hosting.

But seems like they dont allow upload of .htaccess file:
http://help.yahoo.com/help/us/webhosting/glossary/glossary-08.html

You think the site will run smoothly without the .htaccess file?

sangamreddi’s picture

sangamreddi commented

Except few issues without .htaccess file it's ok.

U can't enable clean url's.
U can't have hotlink protection.

apart from these site will run smoothly.

Sunny
www.gleez.com

ospj’s picture

ospj commented

Hi all, I am just a visitor with a one day pass, and I found this thread on google search. I would like to request those that are hosting on Yahoo to help submit a support request to insist that they allow .htaccess. I don't think it makes any sense to block this totally, or otherwise, they should at least provide a properly documented alternative in the Help section. I feel being cheated to sign-up thinking that at least most AMP servers should be similar in the basic components, but looks like Yahoo is not up to the main stream standard in this area yet.

Sorry that I am not using Drupal, but some other os scripts. I believe it would benefit everyone that has signed up with Yahoo!

Cheers

ospj

Tookelso’s picture

Tookelso commented

I currently use myhosting.com, and cannot get the file upload or image modules to save a file.

I suspect it is because they're running PHP in "safe mode".

All I'm trying to do is add some images to my site. I would however, like to use the image upload feature if it makes it easier to slap images on my pages/stories, etc.

Thanks for any feedback.

I read on Yahoo's site that they support PHP version 4.3 or something (not PHP version 5). does anyone see problems with this either?

--Took

niteshade’s picture

niteshade commented

I too am trying to set up a drupal site on Yahoo. I'm wondering how late of a version has worked on Yahoo. Do I have to use Drupal 4.5?

Also, I'm a newb here... how to upload schema through Yahoo's phpMyAdmin? I'm used to using the "import" link in the phpMA control panel, but Yahoo appears to have it disabled. They also don't allow shell access.

thx

www.artechne.com

sangamreddi’s picture

sangamreddi commented

Hi,

Drupal 4.6.5 works on yahoo. U need to use phpmyadmin for installing DB.

It'll be usually something like this http://yoursite.com/db

Clean urls won't work on yahoo.

Sunny                      
www.gleez.com | www.sandeepone.com

rodart007’s picture

rodart007 commented

Hello, i´m currently trying to use drupal on yahoo but i have encountered the problem that i am unable to upload the .htaccess file to the sitefolder because (according to yahoo) such files are not supported. Can someone tell me how did they work arround this particular problem. My email address is rcalderon@chemsol.net

Thankyou very much.

rays’s picture

rays commented

I never did get the .htaccess files up on my site. I just deleted them. They are mainly useful for cleanURLs and limiting access to certian directories from the outside. I haven't yet figured out how to replicate those features some other way with Yahoo!, but I will.

As for the "Lost connection to MySQL server during query" error, the problem is that the host for the MySQL server is not 'localhost'. It is 'MySQL'. To make Drupal work with Yahoo!, you need to edit your sites\%site name%\settings.php. change the line that says: $db_url = 'mysql://username:password@localhost/database'; to $db_url = 'mysql://username:password@MySQL/database';.

The 'MySQL' needs to be exactly like that, and be sure to insert your correct database information.

Ray
sulsh.com

pigpen’s picture

pigpen commented

I'm trying to install drupal in a subdirectory of my yahoo root account. (To use ssl on yahoo, you have to place files in a directory called ssl). It looks like to install drupal in a subdirectory, you have to make some changes to the .htaccess file. (See http://drupal.org/node/9909). However, yahoo doesn't allow .htaccess files. Am I SOL trying to install drupal for a ssl site? Is there a way to enable secure admin and user login on a drupal site without having the whole site be behind ssl?

nawaaz_ahmed’s picture

nawaaz_ahmed commented

I am having a problem with installing drupal in a sub directory. Yahoo hosting does not allow .htaccess - so how do I install drupal in a sub directory? Is there any changes I can make to index.php in my main directory (like including something from the drupal sub directory) that will make this work?

I have been trying to move from Wordpress to Drupal and I am puzzled as to how Wordpress manages to get cleans URLS and install in a subdirectory without .htaccess but Drupal cannot.

Thanks!

AndrewJarvis’s picture

AndrewJarvis commented

I set up my client's site on a domain of my own - in anticipation of the lack of .htaccess files, I deleted them on my end, and had it running perfectly without clean urls.

So, I created the database on her Yahoo account, and uploaded the site into her Yahoo space, and set up the correct DB info in my settings.php. And it all worked fine. Except, whenever I try to log in, I get the following error:

user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' query: SELECT name FROM users WHERE status = 0 AND name = LOWER('andrew') in /includes/database.mysql.inc on line 172.
user warning: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'like' query: SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'user' AND LOWER('andrew') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1 in /includes/database.mysql.inc on line 172.
user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' query: SELECT * FROM users u WHERE LOWER(name) = LOWER('andrew') AND pass = '8c145468c713454354354b468435747e' AND status = 1 in /includes/database.mysql.inc on line 172.
Sorry, unrecognized username or password. Have you forgotten your password?

Trying to use the "request new password" feature gives me this error:

user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' query: SELECT * FROM users u WHERE LOWER(mail) = LOWER('liquidmethods@gmail.com') AND status = 1 in /includes/database.mysql.inc on line 172.
user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' query: SELECT * FROM users u WHERE LOWER(name) = LOWER('liquidmethods@gmail.com') AND status = 1 in /includes/database.mysql.inc on line 172.
Sorry, liquidmethods@gmail.com is not recognized as a user name or an email address.

Help! Any ideas I'll try!

AndrewJarvis’s picture

AndrewJarvis commented

Okay, got it to work! Had to get someone's help who used a pearl script to convert all my tables to a different collation - utf8! Fun! :)

BhaveshSEO’s picture

BhaveshSEO commented

Hi,

I am looking for a free web hosting company that provide free hosting with Drupal. I found one website Free Web Hosting but not sure if they support Drupal. Please let me know if you have any idea.

Regards,
Bhavesh Goswami,
Seo Consultancy

mattjabs’s picture

mattjabs commented

InMotionHosting.com isn't free, but it's darn close. It's like $7/month and their support is great. I have 4 Drupal sites up & running. They're all on Linux boxes & use the cPanel interface.

--
Matthew Jabs

Anonymous’s picture

Anonymous (not verified) commented

May i suggest you consider hosting your websites with a company like underdesign.co.uk who offer hosting specifically designed and configured for drupal sites?
Cheers,

AndrewJarvis’s picture

AndrewJarvis commented

My old host, www.1and1.com specifically claimed to support Drupal, but Drupal sites run sloooooow on it.

I switched to GoDaddy and it turned out to be pretty fast with Drupal.

pixel12345’s picture

pixel12345 commented

Hi all,
I have finally managed to get the front page of my drupal site working on yahoo (http://sooki.info/sustainabledesignfeedbacksite/index.php)

However none of the links from it work.!

I created a folder in my yahoo root folder and literally copied all the contents from the drupal folder on my local server to this.

any ideas on why the index.php is working but none of the links work?

JohnForsythe’s picture

JohnForsythe commented

Looks like your clean URLs aren't working properly, I was able to access articles by manually using normal URLs. Try disabling clean URLs.

http://sooki.info/sustainabledesignfeedbacksite/index.php?q=node/19

--
John Forsythe
Drupal Modules - Find the module you need for your project!

pixel12345’s picture

pixel12345 commented

I ran this command through the mysql settings in PHPmyadmin

UPDATE variable SET value = 's:1:"0";' WHERE name = 'clean_url';
DELETE FROM cache;

and now it seems to be working fine

many thanks for the tip.

axsubram’s picture

axsubram commented

Hi Ray,

I have a standard yahoo small business hosting account and want to install Drupal in it. I don't find the information from yahoo help.

Saw in this forum that you have successfully installed Drupal on yahoo hosting. Can you provide me a few pointers on where to start ?

thanks

Anand

kurtfm@gmail.com’s picture

kurtfm@gmail.com commented

You can't use Drupal 6 or the latest 5.x. I believe that the globals off requirement came in 5.6 so I downloaded 5.5

http://drupal.org/node/198523

and used that instead... it works excepting the .htaccess (so no pretty urls).

I know it's probably not the best but the option was using phpnuke or wordpress with the same setting. Since I am familiar with drupal customization (and already had a customized custom them worked up locally) I went for older version.

I also opened a ticket with Yahoo helpdesk. They said that they were aware that this was going to be something that more and more CMS and wiki packages will require... didn't say when it would change.

That's what I learned.... hope it helps.

sbutzel’s picture

sbutzel commented

When I tried to install Drupal 6, I got this message:

"The following error must be resolved before you can continue the installation process:
register_globals is enabled. Drupal requires this configuration directive to be disabled. Your site may not be secure when register_globals is enabled. The PHP manual has instructions for how to change configuration settings. (Currently using PHP register globals Enabled ('1'))"

Then I realized that my .htaccess file hadn't been allowed to be uploaded to Yahoo!, and that is the file that sets register_globals=0.

This sucks! I don't care about not getting to use cleanurls, as long as the rest of Drupal works. Is there another way to set register_globals=0? Or do I have to revert to an earlier version of Drupal altogether?

Thanks!

p.s. I'll see if I can set up another HelpDesk Ticket with Yahoo to help reinforce the need for a solution.

seanray’s picture

seanray commented

I would like recommend you to submit a ticket to Yahoo for help, this is suck if you cannot change the .htaccess.

Best Drupal Web Hosting | Reliable Affordable Web Hosting Review, Guide and Awards

peeds’s picture

peeds commented

I ran into the same issue and contacted Yahoo, and learned that there is nothing they can do about it for now. Details are in my post:

Drupal Installation Problems With Yahoo SB Web Hosting

I am hoping that they can fix this or give us a workaround in the near future, so that I don't have to move from Yahoo (which hosts my blog now) to another host to be able to use Drupal.