Posted by rotnme on July 8, 2009 at 11:12pm
I'm currently trying to set up a local host using mamp. I have it installed and running. Brought in drupal 6.13. Am currently trying to install it. I have created a copy of default.settings.php and created a new folder settings.php and put it in there. On the copy I changed the permissions thru get info to read/write. Still getting an error message and i cannot continue the install. Any thoughts? Thanks in advance.
Mark
Comments
Database?
What is the error message? Did you already create a database in phpMyAdmin?
Last issue taken care of. I
Last issue taken care of. I just put it in the wrong place. However...........now, I exported my live database to my desktop, created a database on mamp, imported the desktop db to mamp one but I get error message #1050 - Table 'access' already exists. Thoughts? Much appreciated.
Mark
Are you importing over the drupal default db?
Firstly, caveat lector. Anytime anyone tells you to delete anything, be warned. I wash my hands of any bad things that might happen.
I presume you're seeing this error in phpmyadmin? If so:
If you're doing a db default overwrite with an existent db from another host (I'm drawing a pretty big lattice of presumptions here), MySQL lets you export tables with a "drop tables" option. This is helpful when importing the db you want over the db you don't need. Re-export your data with "Drop tables" enabled and you should be able to import.
If my presumptions are wrong, please provide more info.
ta da
that did it. thanks so much. question, should I have exported/imported information_schema? On mamp I just clicked on the db singling that out and imported over that.
Mark
No
I never had and never had a negative impact, but just for kicks, I looked it up and the answer was always this: http://drupal.org/node/494560 (no, not relevant)
hmmmm
any help is greatly appreciated: try to get on my site local and this is what appears:
warning: call_user_func_array() [function.call-user-func-array]: First argument is expected to be a valid callback, 'views_access' was given in /Applications/MAMP/htdocs/drupal/includes/menu.inc on line 452.
warning: call_user_func_array() [function.call-user-func-array]: First argument is expected to be a valid callback, 'imce_access' was given in /Applications/MAMP/htdocs/drupal/includes/menu.inc on line 452.
warning: call_user_func_array() [function.call-user-func-array]: First argument is expected to be a valid callback, 'views_access' was given in /Applications/MAMP/htdocs/drupal/includes/menu.inc on line 452.
with a body block and blue square with question mark. I'm lost........
Mark
Too much fun, no?
Two thoughts:
ls /Applications/MAMP/logs:
apache_error_log mysql_error_log php_error.log
Load the site and note the errors in each. I moved a hosted site locally and the php_error log helped me around the "WSOD"
Here's an interesting set of tips on moving your drupal db from one host to another that might help: http://www.clearlysecure.com.au/node/29
Hope it goes well!
arggggghhhhhh......
Fun? God no. I'm losing my mind. Three steps forward five back. Question in regards to error. When I imported my existing db using phpmyadmin it seemed to have worked. As I begin to go another round with this thing I'm looking at the mamp start page, there is a tab at the top sqlitemanager. It has fields to create a db and upload a db. Rather than using phpmyadmin should I have used this? I don't know I grasping at straws at this point. I am just dreading the thought of getting into this, especially truncating, error logs, have no idea about either one of them. Thanks in advance. Hmmmm, does anyone want to fix this remotely? LOL
Mark
next meet up soon hopefully.....
In desperate need of help. Just looked thru the error logs.
apache: file does not exist:/applications/mamp/htdocs/sites, referer: http://local host.8888/drupal/
php: include_once() [function.include]: failed opening './sites/default/settings.php' for inclusion (include_path='.:/applications/mamp/bin/php5/lib/php') in /applications/mamp/htdocs/drupal/includes/bootstrap.inc on line 322
mysql: [warning] you have forced lower_case_table_names to 0 through a command-line option, even though your file system '/applications/mamp/db/mysql/' is case insensitive. this means that you can corrupt a myisam table by accessing it with different cases. you should consider changing lower_case_table_names to 1 or 2
[warning] one can only use the --user switch if running as root
???????????????????
the next sound you hear is my head exploding........... thanks all
mark
First Step
I think you're trying to do too many things at once.
Blow out your local copy of the code and database. Do a fresh install of Drupal (as in run install.php) with a brand new DB.
Now, put in your live code files, but use the DB settings from the newly-generated settings.php.
As the last step, import your old data. You should blow out the new (local) database's tables entirely before you do so, so you don't get trash.
edit: The point is to make each step actually work before moving on, so you can figure out where the problem is.
Ken Winters
www.coalmarch.com
Ken Winters
localhost
http://localhost:8888/ is the default MAMP location, btw. It looks like you might have a space in there...
Ken Winters
www.coalmarch.com
Ken Winters
basically start over from
basically start over from scratch. I thought everything was fine. installed drupal, created a db and then imported mine over it allowed me ti install drupal and set it up but then, well. ok I'll start over. Silly question, live code files? I actually went into terminal and changed the root password and changed the php memory from 8 to 128. Should I have? I don't want to make the same mistakes this time around. Thanks in advance.
Mark
Scattershot
Ken's right about approaching slowly and methodically. Be careful of tangencies, such as your discovery of the "SQLLiteManager" SQLLite is a different database system altogether and has no relevance here.
Ken's right about the poorly formed URL, if there's a space in there. That's why the logs are so invaluable. I have had the case-dependency issue of MySQL hit me in another context (Ruby on Rails) but it was a different configuration issue than whether case-dependency was enabled.
If you don't have a deadline, your best bet is to wait for one of our meet-ups, although self-discovery is an excellent if harsh teacher.
Ken, if I read rotnme's posts correctly, he had followed your recipe. However, he's learning the joys of being your own host AND developer.
Oh believe me, I am very
Oh believe me, I am very methodical and hesitate to do anything before I think it over. However, I an architect/general contractor. This is wayyyyyyy out of my comfort zone. The sqlite I figured was something I did not want to touch. Not sure what you mean by the poorly formed url. I really don't have a deadline, just trying to take advantage of a lull in business to get this up. Actually it is up but I am about to "experiment" with some css and did not want to do it on my live site. That is what has brought me to this debacle. I am sooooooo wanting and looking forward to the next meet up. Hopefully soon. Thanks for all the help.
Mark
Follow the instructions at
Follow the instructions at http://drupal.org/node/66187 if you aren't already. It includes changing the memory limit.
By "Live code" I meant whatever you had in the drupal folder you were working out of previously, including all the modules you downloaded.
If you set the database host as "local [space] host" instead of "localhost" that could easily break it.
Ken Winters
www.coalmarch.com
Ken Winters
wampserver
I use wampserver - http://www.wampserver.com/en/
http://drupal.ls.net/node/51
The advantages of a virtual server are numerous, not least of which is that you can run many local instances.
Installing on Ubuntu
Now a bit dated but ...http://drupal.ls.net/node/47
going real slow, step by step
started all over and everything is fine. This is the point where everything fell apart before. Drupal is in, set up, DB is named, localhost:888 page show fine and I can navigate around it. What I did notice and I don't know if it's critical, upon loading localhost page message at top in yellow stated that php memory was at 8M. I changed all of this per node/66187, actually went back and checked, it was all at 128M. So not to screw this up again per Kens post above:
"Now, put in your live code files, but use the DB settings from the newly-generated settings.php."
"As the last step, import your old data. You should blow out the new (local) database's tables entirely before you do so, so you don't get trash."
How exactly. Wouldn't importing my DB bring in all my downloaded modules and everything else? Waiting albeit somewhat patiently for a reply BEFORE I do another thing. Thanks all.
Mark
You probably didn't restart
You probably didn't restart MAMP, which would be required to load in the new PHP / Apache config files.
Move the files first. You will then have all of the modules / code available, but largely inactive because modules default to off. If you site still works after this, it mostly just means the file copy didn't break your settings.php, file permissions, etc.
The thing about importing a database backup is that it will usually leave trash data in tables that the backup doesn't contain. So, if you drop all of the tables in the DB (or drop the db and remake) then you won't get any trash. Any time you get weird errors after a backup restore, it's something to try.
Ken Winters
www.coalmarch.com
Ken Winters
Makes sense, thanks.
Makes sense, thanks. Hopefully this is on track, In htdocs in the drupal folder I have created sites/all/modules and placed all modules that I am using. Also created sites/all/themes and put in abarre. On localhost:8888/drupal/admin under site building the only thing listed is blocks. Correct? Again, thanks.
Mark
If you don't use the exact
If you don't use the exact same version of core / etc. on your local machine as on the server, you will have problems down the line.
Ken Winters
www.coalmarch.com
Ken Winters
Oh mannnnnnnnn
Turns out that I had to switch versions, thanks for the tip, didn't even think of it. I put 6.13 in and my live server uses 6.12. After I did that and got my local page, go to admin and get error message that there is an update available to 6.13, shouldn't be a big deal. However the problem still exists that under site building I have no modules section, no core modules, nada, no menu section, just one clickable item, blocks. Shouldn't the core modules show even though I have not imported any modules that I'm using? Very perplexed.
Mark
done......
I'm beaten. My live host does not load.
"If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.
The mysqli error was: Access denied for user 'dcu0916007064491'@'97.74.144.154' (using password: YES)."
I have not a clue at this point. Anyone? Help. Meet up, get me straightened out. I'm on my last nerve. Have not a clue what to do. Anybody available for coffee and hopefully to straighten this mess out?
Tired, beaten and drupaled out
Mark
settings.php does not match priviledges in MySQL
Can you get to the privileges for your database?
If you didn't change the db
If you didn't change the db line in settings.php, chances are mysql is just down.
Ken Winters
www.coalmarch.com
Ken Winters
Still can't get on to live
Still can't get on to live site. Same message. I don't think I touched settings.php. The only thing that comes to mind, and I could be wrong, is could working on mamp and configuring the password from root to something else have any effect on the live site? Spoke to cust support at go daddy last night and best he could tell was that something has changed. He had me on my site yesterday mid-day, which I was not. Hmmmmm, what to do. There has to be some correlation between setting up the local and what has happened to the live, I just don't know what. Thanks all.
can you access your godaddy phpmyadmin?
can you access your godaddy phpmyadmin for your db? If so, we can step through next steps.
Yup. Just got off the phone
Yup. Just got off the phone with go daddy. They ran all sorts of diagnostics. Everything seems good on their end. They narrowed it down to a password issue, which is what I'm thinking. So that being said, WHAT DO I DO???????? All help is most appreciated.
It's simple
$db_url in sites/default/settings.php does not match the privileges of your database.
You must know or find out what those are.
You may be able to do that through your control panel.
Drupal 5 update or reload?
My guess is that you overloaded a Drupal 5 instance and wiped out settings.php (there is one more $db_url line, those are the examples).
If you are responsible, you have a backup of that file somewhere. If not, you must, and I emphasize must, know the server, username, password and database.
Reset your password
Reset your mysql password using your GoDaddy control panel. Then confirm your settings.php mysqli url and THEN you should be good to go.
How it changed, or how your settings.php changed, is odd. I'm no fan of GD, but I've never had that type of mishap there.
in phpmyadmin, can't find a
in phpmyadmin, can't find a reset password or anything similar.
hold on, sorry found it in
hold on, sorry found it in different location. changed it still can't access site.
wow......... Database URL
wow.........
this is what i found in settings.php. ????
I am so lost right now