By mdowsett on

The install instructions make it sounds so easy! So I thought I would try it but I have no PHP or MySQL experience so what do I expect.

Anyways, I have made some progress but still getting stuck. I have successfully got Apache, php and MySQL installed on my OS X machine and am trying to host a Drupal site off of my machine for testing before I put it on my web server. I am using phpMyAdmin and have that successfully going (http://70.68.166.65/phpMyAdmin/) - as it states here, MySQL is running...

I am following install instructions at:
http://drupal.org/node/260
and am stuck on Step 4

I believe I have changed the conf.php file properly:

$db_url = "mysql://mdowsett:drupaltest@70.68.166.65/drupal";
$base_url = "http://70.68.166.65/drupal";

But when I go to http://70.68.166.65/drupal, it takes a while to try to connect to it and then comes back with an error saying: "Can't connect to MySQL server on '70.68.166.65' (4)"

So now I am stuck...anybody have any ideas? Feel free to email me as well at mark@dowsett.ca

Comments

sepeck’s picture

sepeck commented

Have you tried

$db_url = "mysql://mdowsett:drupaltest@localhost/drupal";

IIRC that @localhost is more related to your mySQL account name than to the server you are running on.

Also, check out this article (it's for 4.4 but it may give you some leads) http://maczealots.com/tutorials/drupal/

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

mdowsett’s picture

mdowsett commented

seems like one step forward...two steps back...

I changed the $db line you mentioned. I get the following error:

strict warning: var: Deprecated. Please use the public/private/protected modifiers in /Library/WebServer/Documents/drupal/themes/engines/xtemplate/xtemplate.inc on line 42.

And it repeats the error, changing the line # each time in increments of one until line 70

It then gives me what I assume is the standard first login instructions for drupal. I try putting in a number of users (ones I have already set up in phpMyAdmin and also new ones I have never tried before) and none work.

When I try, it gives me an error "Sorry, unrecognized user name or password"...and the instructions are to create your first user name...I am surprised a new one doesn't work either then.

I then thought I would take on the other instructions you listed on your advice above. i get through to the PHP testing part and that doesn't work...no error, just opens a finder window to the /Library/WebServer/Documents folder when attempting to access the index.php file I try to create.

I take it my PHP is now not working...great...

I also then try to access my phpMyAdmin that I successfully used before (to create thedrupal databse and import the tables) and it also gives me an error:

"Welcome to phpMyAdmin 2.6.0-pl2
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server."

Now what...? Have I screwed things up beyond fix? How on Earth to you start over with all the config files I have changed...?

thanks for your help - I do appreciate the effort.

killes@www.drop.org’s picture

killes@www.drop.org commented

The warnings are just warnings and not that important. They are due to the fact that you use PHP 5 and will only occur with the xtemplate based themes.

If you can't create users, I recommend to clear the database, start anew, and list all the steps that you did here.

--
If you have troubles with a particular contrib project, please consider to file a support request. Thanks.

--
Drupal services
My Drupal services