This is my first time trying to install Drupal and I am very excited however I have run into an install problem.
I am at the 'set up database' stage and I get prompted with:
Failed to connect to your MySQL database server. MySQL reports the following message: Can't connect to MySQL server on 'localhost' (10061).
* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct database hostname?
* Are you sure that the database server is running?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.
I am a newbie as I focus(ed) on design most of the time but willing to learn. I may be leaving info out but my host is CrystalTech. Any insight would be great!
BC
Comments
Check to see where the MySQL
Check to see where the MySQL host is. On many shared servers SQL is hosted on a seperate machine. On my host they list the "Hostname" for databases.
found it but....
I found out where it is but drupal automatically defaults to 'localhost' in the options. I also changed the default.settings.php file and it still happens. Am I just missing something or have a forgotten to to change something else?
click on advanced options on
click on advanced options on the install page. You can set what you need to there.
Blessed be! This was
Blessed be! This was exactly what I needed! I had to mess around with it to see which portion of the string it wanted, but now it works! Hurrah!
(thank you!)
Also a Drupal Newbie on Crystal Tech
I'm having the same issue... what was the string exactly (I'm also on CrystalTech)? I feel like an idiot. I've gone through what I feel like every iteration possible and read through every google result for "CrystalTech" and "drupal".
The SQL server is "SQLB8.webcontrolcenter.com" and I've been entering that in the "Database host" field, well as 3306 for the port. I'm positive the database name, and my UN and PW are correct... Any help would be greatly appreciated.
EDIT: I've also tried changing the default/settings.php file to:
$db_url = 'mysql://[[[myusername:mypassword]]]@SQLB8.webcontrolcenter.com/[[[mydatabasename]]]';
but no luck.
update on crystaltech install
Okay, remember that part where I said I felt like and idiot? Well, I proved myself right. I was using a MSSQL database, not MySQL... I really need to increase my font sizes onscreen. Still had to change the default/settings.php file to get it to fly though.
I dont know how new you are
I dont know how new you are to drupal but I will run through it all. If you are editing this line in default/settings.php $db_url = 'mysql://user:password@localhost/database'; you should have no problems at all with database connection. This is If you are porting a drupal setup that you have worked on locally, before uploading. and only then should you edit settings.php.
Just check if your username and password are correct. Also be aware that drupal doesn't create the database for you, so you have to create it first either through the control panel of your service provider or phpMyAdmin. I am not sure how CrystalTech handles database creation.
Then when you are at the Set up database step.. click on the "advanced settings" just below the basic options and there you can enter the path to the sql server, and the port etc. If everything is entered correctly you should have no problem.
Let me know if this helps.
--
When God is with you, who can stand against you?
Thanks brucebanner! I am a
Thanks brucebanner! I am a newborn baby newbie to drupal - but, I tend to be a quick learner! I am not working on a drupal setup locally so I will edit the php file to its default settings. I set up the database and know what server it is on, it is the port, etc. info I need to find out - I think. Thanks a bunch and I am sure once I get one going everything else will be downhill. It is just getting the first one under my belt that is the issue.
No probs man.. Everyone has
No probs man.. Everyone has been a newbie once :)
Glad I could help..
--
When God is with you, who can stand against you?
different person, same problem
I have a similar problem, only editing the default.settings.php did not work. My host is nearlyfreespeech.net, and I have the same error when trying to connect to my database.
Would I replace the localhost section with ftp.phx.nearlyfreespeech.net? Does that sound correct? All of the rest of my information is correct as I can successfully connect to my database via phpmyadmin.
Any help would be appreciated.
Would I replace the
Almost certainly not.
See that 'ftp' at the beginning of the hostname? I'd expect 'mysql' or 'database' or something if anything. Although this is not required, or even incredibly likely.
But having FTP there mean almost certainly not.
Your host will have supplied you with the appropriate connection string on sign up ... or it'll be buried in their docs. Ask them or review your boring account emails.
But look hard at your phpmyadmin interface. The correct servername is probably in the title or header of your page as you use it.
Or look at the URL you use to get to phpmyadmin. It may (but may not) be the hostname you need.
.dan.
How to troubleshoot Drupal | http://www.coders.co.nz/
.dan. is the New Zealand Drupal Developer working on Government Web Standards
more
Just to clear a few things up...
in the area where I am supposed to enter a database name, it says to enter a mysqli database name. I am not sure if this is my problem, because I dont know the difference between mysql and mysqli.
As for my server name, it is just a .db name. I believe all of my information is correct, but Drupal is still leaving me hanging. Is there anything that I could be doing wrong in my editing the settings file? I entered each bit of information in the correct spot.
if it's not localhost, it's something else.
there's not much difference between mysqli and mysql. For your purposes, it means that that's the php extension/interface that's enabled on your host. Because they've chosen that, and they have also supplied you with the database, we can assume that that will fit together just fine.
What do you mean your servername is "just a .db name"?
Your servername, if not localhost, will be a.full.server.name.
Possibly database11.phx.nearlyfreespeech.net or something like that (I'm making it up, but that's what it'll look like.
Read the information supplied by your host as it will tell you how to connect to their database server.
However you made your database (there are a hundred methods, and they are mostly the province of your chosen web host - not Drupal) you will have ended up with a database name, a username, a password and a host. Enter those values where it asks for your database name, username, password and host.
If you have lost or otherwise mislaid that information - ask your host providers and they will point you to the FAQ page where they've published that info.
.dan.
How to troubleshoot Drupal | http://www.coders.co.nz/
.dan. is the New Zealand Drupal Developer working on Government Web Standards
still not working
I have entered the correct database server name, but still no success. My database is running fine, the only problem being drupal wont recognize it. Are there other factors that I am missing? It has taken me 3 days to set up the web server to handle drupal so I don't want to quit now.
i'm experiencing similar thing, except I get no errors
I'm having problems with the connection to the database, however I don't get any errors, it just clears all the database log in info....
It does give me a warning: "Operations on Unicode strings are emulated on a best-effort basis. Install the PHP mbstring extension for improved Unicode support. (Currently using Unicode library Standard PHP)" I'm hosinting it through webhost4life....
Any pointers on how to resolve this would be greately appreciated....
Operations on Unicode
Just at a glance I would say install php mbstring. are you running a localhost/which one?, or is this straight on the web?
--
When God is with you, who can stand against you?
Same problem using IIS.
Same problem using IIS. MySQL work fine , PHP work fine but i receive always the same error. I think that there's something wrong in the installation. So.. we need someone that let see us his php.ini and default.settings.php I think that we can learn more from these file.
thanks a lot from ITALY
how do you install php mbstring?
I'm really dumb. How do I install php mbstring?
Do I have to have the computer plugged in to do that? (joking)
This also happens when you
This also happens when you move the default.settings.php file instead of copying it.
See this blog post I could
See this blog post I could find: http://blog.donnael.com/2007/02/installing-drupal-on-webhost4life/
- Go to the Security tab of the Hosting Control Panel in WebHost4lIfe;
- Edit the folder of your Drupal Installation
- Give the IUSR_MACHINENAME user more liberal permissions than the default Read/Execute
- Try again
That is how I solved it.
Apache 2.2 server MySql 5
I am on local host, apache server and the drupal install.php stops after verify requirements and states
I am currently running the MySql server database and it shows up in the apache services list... where do i go from here please?
Apache services list? But
Apache services list?
But does it show up in your phpinfo() ?
see your php.ini and uncomment it.
.dan.
How to troubleshoot Drupal | http://www.coders.co.nz/
.dan. is the New Zealand Drupal Developer working on Government Web Standards
php.ini comment
OK,
I am a newb at this by the way.
No, mySQL doesn't show up in phpinfo.php.
I went to the php.ini file and extension=php_mysql.dll is uncommented already. is there another extension=php that i should also uncomment?
This might be on another note but under [MySQL] in the php.ini file - i don't have a default port or default socket set. should i be setting these?
~m
if not in phpinfo, that's
if not in phpinfo, that's your problem.
If it is uncommented, yes, it should be working.
BUT
Is your php.ini the real one? I found several fake versions and locations for php.ini to be living on windows systems.
At the top of your php.info there.s a line that says the full pathname of the ini file being used. Check it. It caused me great frustration with "Why are my changes not working?!"
And, of course, restart the apache when needed.
Last resort - check your extension_dir (as listed in tht phpinfo) and check that the DLL is really there. I imagine most bundles WILL, but it's something to check.
.dan.
How to troubleshoot Drupal | http://www.coders.co.nz/
.dan. is the New Zealand Drupal Developer working on Government Web Standards
my configuration :-
my configuration :- Apache/2.2.11 (Win32) PHP/5.2.10-dev
I have uncommented these two lines from php.ini file and its working fine now.
;extension=php_mbstring.dll
;extension=php_gd2.dll
Without gd2 you won't be able
Without gd2 you won't be able to do image manipulations. (unless it's built-in to the binary build)
The only way to tell it to look at your phpinfo. Do that and confirm the gd toolkit is available.
Unless you will never use resized images on your site.
.dan. is the New Zealand Drupal Developer working on Government Web Standards
installation problem
I am also having the same problem...I think its regarding some read and write permission.But dont know wat exactly??
IIS7 Drupal6 and sql server
solved problem I had previously installed sql and removed it. Cleaned registry.