Installing Drupal On A Localhost
Submitted by learnbythedrop on Mon, 12/22/2008 - 14:11
Lesson One of my special Getting Started With Drupal series of instructional videos.
This video shows how to install Drupal to a localhost on a Windows based computer. Wampserver is used to create the proper environment.
Bookmark or Share Post- learnbythedrop's blog
- 11364 reads
Comments
Thanks a Lot !!!
I'm fighting about a week trying to install with xampp, no success.
This video is great, it is simple and working finally!
Now i can start messing with the real things.
So, keep introducing great videos, I'll be watching for sure.
Roy
downloaded WAMP server ok - but cannot see localhost/phpmyadmin page - it's just blank. Any ideas what my problem might be? Have IIS loaded previously - could this be interfering?
Thanks for any help anyone can give....
I saw a post on the Wampserver forum that recommended removing IIS if you have any problems running the app.
http://www.wampserver.com/phorum/read.php?2,45928
Removed IIS when disabling it didn't seem to do anything. Still can't get get it to work.... should be a simple thing???
Anyone else got any ideas/ Thanks
Siona
Mine did the same and I couldn't get it to work but I restarted my computer and after firefox restored my sessions it popped up... Not sure if I did anything else to help it besides that...
i completed installation of wamp server but i cannot open the php my admin.....
i have sql server 2005 installed on my system
does this cause the problem..?
It's hard to say since everyone has a different system configuration as well as different applications installed. I've been looking on the Wampserver forums (http://www.wampserver.com/phorum/list.php?2) in order to help people with similar issues and it seems that this setup might not play well with previously installed web servers and sql databases. Perhaps try checking if the sql server 2005 service is running and stop it before trying again.
Hope this helps you too.
Spent days searching for useful help.
My problem:
installed Wampserver 2.0c on WinXP sp2 (all good) then:
Error message on http://localhost/phpmyadmin/:
phpMyAdmin 2.11.6 MySQL said:
#2003 - Can't connect to MySQL server on 'localhost' (10061)
mysql log said: (left-click on wampserver icon look under mysql)
Log file:
090114 7:58:44 InnoDB: Error: unable to create temporary file; errno: 22
090114 7:58:44 [ERROR] Default storage engine (InnoDB) is not available
090114 7:58:44 [ERROR] Aborting
090114 7:58:44 [Note] wampmysqld: Shutdown complete.
The fix: http://www.wampserver.com/phorum/read.php?2,46865
Changes to my.ini & my-template.ini files. It worked after restarting server.
1. Open file my.ini in folder C:\wamp\bin\mysql\mysql5.0.xx and find this line:
default-storage-engine=INNODB
Change to:
default-storage-engine=MyISAM
2.Open file my-template.ini in folder C:\wamp\bin\mysql\mysql5.0.xx and find this line:
default-storage-engine=<<{MIXED|INNODB:INNODB}{:MYISAM}>>
change to:
# The default storage engine that will be used when create new tables when
default-storage-engine=<<{MIXED|INNODB:INNODB}{:MYISAM}>>
default-storage-engine=MyISAM
cheers
This video is great, truly useful & on subject!! Namaste
ya boss i stopped the sql services and nothing is better...
when i tried to activate the rewrite module in apache as said in the videp it says "could not execute menu item[internal error... the service has not started"
well.. i use windows server 2003 os. is there any other way ...???
I think that the best place to get help on this would be the Wampserver forums. Wampserver is pretty new to me as well so beyond making sure that the Wampserver services are started and checking to see that older versions of SQL are removed I don't have anything to offer. Good luck.
ill be checking out the forums....thnx for ur help...
Hi,
first thanks for submitting this very useful video!
I see in your video php file are read, while I can't. When I look for my localhost it says server error...
Thanks a lot!
...managed!
That was very helpful. Much easier than the Drupal Documentation makes it.
thanks,
jc
Eveything works good until I try to enable modules. When I try to enable them I keep getting this message:
Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\themmat\includes\file.inc on line 891
Does anyone know how to correct this?
Thanks,
Sam
Perhaps changing the setting in php will work. http://www.php.net/set_time_limit
There's also an old thread on Drupal.org that discusses this issue. http://drupal.org/node/66105
Drupal services firm Acquia has added another tool that can help to make it easy to install Drupal on a localhost. It's called the Acquia Drupal stack installer.
Instructions: http://acquia.com/documentation/acquia-drupal-stack
Download: http://acquia.com/downloads
It may be useful, but this video is patronising as hell. Do you REALLY think that a community of people who are looking to test a php CMS offline need to be told that we have to use a zip utility....now if you go here and click on..eh download. That'll download it to your computer...once you have it installed, there should be an icon..um..a wamp icon on your desktop..NO FUCKING SHIT. Christ. You should write some "for dummies" books, because that's who it sounds like you're talking to.
You really have a poor attitude. In addition you really don't understand what's going on with Drupal these days. There are many people who are very new to web development looking to get involved with Drupal. Many of these people don't want to spend money on hosting but want to try it to see if they can get the hang of it. I know because I follow the Drupal forums and receive many emails and comments from people who are just starting out.
So I'd rather do things the way I've been doing them because it's going to help people learn and also help to grow the community that supports the Drupal platform. If you had an ounce of maturity you would understand the situation. And if you want someone to create books or tutorials specifically suited to your exact level of expertise at the current time then go pay someone to do it.
Next time you want to come on this site and hurl garbage at least have the guts to link to your website.
I'd just like to second that motion - grow up "Anonymous"!! Have you ever heard of the concept of lowest common denominator?!?!
Although I also personally past this part of the Drupal learning-curve quite a while ago, I fully support what Rob is doing for the community. The curve has been notoriously steep in the past, and Rob has single-handedly made it less so with this site.
I only wish that all the material on this site was around 15 months ago, I'd be even further along than I am now. And, that's coming from someone who's been involved with web development for 15 years in one capacity or another!
He doesn't get paid directly to provide this material and he volunteers his time to help people come into the community with less inertia than was ever possible in the past.
Kudos to you Rob - keep up the great work, and don't let negative-nancys like this poster detract from that!!
Just watched this video and got everything set up. Ran into an issue with my etc\hosts file but was able to edit it so I no longer received the http error that I was getting in my status report.
Great tutorial, I really appreciate it! Off to learn more about drupal and looking forward to learning more from you!
These are great tutorials and as a new comer I appreciate your time and effort.
I am encountering a problem at the very beginning which is quite frustrating. I get to the point where it calls for the renaming of the file in the sites folder;
"The Drupal installer requires that you create a settings file as part of the installation process.
Copy the ./sites/default/default.settings.php file to ./sites/default/settings.php."
I follow your instructions but I continue to get the same message and can't advance past this point. Any help would be greatly appreciated.
What you should have done was make a copy of the default.settings which may have resulted in the name "copy of default.settings.php" and then change that name to just settings.php. That file should be located in sites/default/settings. If that is what you have set right now then you should be good to go. You may be able to get additional help on this at the drupal.org forums.
Hi,
My local host suddenly started to say "The site is currently not available due to technical problems. Please try again later. Thank you for your understanding" I didn't make any changes, other than the fact that I didn't use it for 3 days. Any idea of what I can do to correct this?
I'm not 100% sure why you would see that message. The first thing I would do is to make sure that all the necessary parts of the local system are online. It's also possible that something else running on your computer (SQL Server maybe?) is causing the problem as well.
I have a feeling it is in this:
1.20 I receive the error "cannot load MySQL extension, please check PHP Configuration".
To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.
Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.
Any suggestions? Oh yeah, the step-by-step instruction is perfect! Don't change a thing.
I'm at a loss on this one as I'm definitely not a WAMP expert. You probably want to check the WAMPserver forums.
Excellent tutorials Rob. Keep up the good work. The guy compaining about them is a fool. He may be highly advanced technically but he's barely human. I'm new to Drupal and and getting my feet wet with PHP and CSS. I've searched high and low for tutorials as useful as yours. And I'm ecstatic that I've now found you. Please don't change a thing.
This is a good intro using wampserver, with which I have no experience. The only advantage I see of using wampserver over XAMPP is that it lets you toggle the apache modules on and off and provides some nice administration abilities through an interface. So rather than bookmarking phpmyadmin, making shortcuts to php.ini, httpd.conf, and etc/hosts and such, you can do it through the tray icon. Very nice, but lets you get away with not learning Apache or optimizing mysql thread and query caching / other optimizations you *should* learn for optimizing a Drupal application.
I have to admit, I was looking for something more, such as a way to fix the status update problem with fopen on xampp/localhost, which is yet unresolved for me on localhost drupal installations, despite my efforts going thru drupal.org's threads on the subject.
Im using wamp 2.0 on windows vista home premium. I get the following error when trying to install Drupal:
The Drupal installer requires that you create a settings file as part of the installation process.
Copy the ./sites/default/default.settings.php file to ./sites/default/settings.php.
Change file permissions so that it is writable by the web server. If you are unsure how to grant file permissions, please consult the on-line handbook.
More details about installing Drupal are available in INSTALL.txt.
I have renamed the php file, so i think the issue is with file permissions on vista. I have tried right clicking on the files and changing the read only property, but that doesnt work.
Anyone have any ideas on how to get past this?
Thanks
The issue may be Windows Vista specific. I did my localhost install on Windows XP. There's a post in the Wampserver forums that addresses something like this so you should probably look at that. http://www.wampserver.com/phorum/read.php?2,39616,50127
Since you're on Vista the new Microsoft web application framework may be a better option than wampserver. Check it out at http://www.microsoft.com/web/downloads/platform.aspx.
Will this work with Drupal?
The latest version of the Microsoft web platform 2.0 beta supports Acquia Drupal. http://www.microsoft.com/Web/gallery/AcquiaDrupal.aspx
hey boss..
its been a long tym since i ve been in this forum..
yet i cant go without thanking you. i initially had some problems with the IIS and sql. i formatted the system and loaded xp. to my excitement i found wampserver working perfectly well. your video lessons are of great help. keep up the gr8 work... hats off....!!!!
its great work boss.... hats off...!!
*seeker
Thank you so much! I spent hours trying to do this before I found your site! Keep up the good work.
Excellent tutorial Rob. I look forward to completing this series. I had previously installed xampp but also installed wamp. Encountered an error message when I tried to click on rewrite module, and went to google wamp error could not execute menu item, and it took me to a forum message in wamp that said I had to uninstall any other versions of php mysql, which I did (uninstalled xampp too bad I wish I could work with both), and now everything is cool...
regards,
i matua
do i need to have iis installed in my computer in order to install drupal on a localhost?
You don't need IIS. The Wampserver setup provides an alternative to IIS. You could also use the Microsoft Web Application Installer as well.
i almost gave up on drupal until i came upon your site. the structure of your tutorials are very effective especially for novices because it focuses only on what is needed and essential and incrementally progresses once you get the basic knowledge. it was rather frustrating for me the first time because i was intimidated with all that is to learn. thanks to you i found out that you don't need to learn the whole thing all at once to get the benefits of drupal. good luck and more power to you.
I had to re-install wamp and drupal after a hard drive crash. I found after re-install and following instructions here, localhost and phpmyadmin page were blank. I searched around on google and found at http://jlbn.net/ that if wamp is yellow and white when you turn it on, that your firewall (in my case mcafee and online armor) is blocking access. I did not turn off IIS administration. I allowed wamp full access on both firewalls and everything is fine on windows xp pro. Just a heads up for all of you who run into the problem.
I'm very impressed with your training videos!
Trying to install on localhost and have installed WAMPServer
When I run PHPMyAdmin I get the following error in the browser
Error
SQL query: Edit
SET CHARACTER SET 'utf8';
MySQL said: Documentation
#1115 - Unknown character set: 'utf8'
Having a lot of difficulty getting to bottom of this.
Any ideas? - is it a MySQL setup issue and what could I do to make it work?
Thanks
Graeme
I don't have a clue. Going to have to defer to Google on this one.
Rob,
First and foremost Thank you!
I was wondering whether you had an easy recipe to allow other computers on the local network to access the internal website I am creating. I am really having trouble finding a succinct answer that works. I am using windows xp with a typical tcp/ip obtaining ip addresses automatically.(the name eludes me) Anyways if its not to much trouble and you know off the top of your head I sure would appreciate it
Thanks again
Regards
Lowell
You're welcome Lowell. I don't have a recipe to allow other computers on the network access. I'm very weak on the topic of local area networks. The first thing that I would think to do is to make sure that the folder where the html files for Drupal are located is shared via the Windows explorer dialog. I believe that can be done by right clicking the folder, selecting the "properties" choice and then the "sharing" tab.
Hi, Please help:
"Your system or network configuration does not allow Drupal to access web pages, resulting in reduced functionality. This could be due to your webserver configuration or PHP settings..."
This message has just shown up ( again) in my status report. Actually, I had it when I first installed Wamp server and Drupal but it "disappeared" for a while... untill now. Any idea how I can fix this? Or maybe it's just normal because I'm running Drupal on a localhost...?
Thanks
Even before getting wamp, I could not install mysql. Finally did a drive-wide search for mysql, php, and apache and removed a bunch of obscure (leftover) settings from previous programs. All over the place.
Therafter, everything went swimmingly.
Bob
Hello
After I enter the name of the database, the username (root) and the password (none) and then click 'Save and continue' nothing happens - no message, the Database Configuration page just re-appears!
The database definitely exists!
Having trouble getting to the bottom of this.
Any help appreciated.
Graeme
I would check to see if everything is running. I also would make sure that you don't have Microsoft SQL Server on the machine as that seems to cause quite a few problems. Another option is to delete the database and start over. Finally, if nothing else works you may want to try the Acquia Drupal Stack Installer which installs everything (including Drupal) on your local machine in one shot.
Hi I can go to http://localhost/phpmyadmin it works fine
But when i write http://localhost/drupal it gives me this error:
Warning: require_once(./includes/bootstrap.inc) [function.require-once]: failed to open stream: No such file or directory in C:\wamp\www\drupal\index.php on line 15
Fatal error: require_once() [function.require]: Failed opening required './includes/bootstrap.inc' (include_path='.;C:\php5\pear') in C:\wamp\www\drupal\index.php on line 15
Please help:)
What I would do is unzip drupal again just to make sure all of the required files are present there.
I kept getting an error that ends with "service has not been started," with WAMP and in the end I looked at another thread and they said something about closing skype, I did it, it works perfectly...weird...
Many thanks,
works fine!
First of all congratulations and thanks, the videos are very usefull.
Here is my question: If I want to have more than one drupal site; I must copy all the process like in the video (where you created the folder drupal_2) and install drupal as many times as sites I want? Thanks
I've got no experience with multi-site installs so my approach would likely be a clumsy one. One way you could do it would be to put the second site install files in another folder. Create another database for the new site. Then when you go to the home page of the second site you should see the install page and you would point to the second database that you created. See the following node on Drupal.org for a lot more info on Drupal multi-site installs. http://drupal.org/node/43816
Thank you, Thank you, Thank you!
I have watched the video, absolutely brill and read the threads. This video is PERFECT for novices like myself and have not found you or it patronising in the slightest. Sometimes when you are new to techno stuff like this, the simplest of things quite often get overlooked and it is usually them that causes most of the problems and tends to get forgotten. A video this basic is idiot proof and saves me loads of hours of frustration when I forget to check the simplest of errors.
Thanks again for the fantastic video and getting me up and running so quickly.
Cheers!
After installing Drupal I get a "red box" msg saying there's a problem with the installation and prompting the "Status Report". Checking that gives me this:
HTTP request status Fails
Your system or network configuration does not allow Drupal to access web pages, resulting in reduced functionality. This could be due to your webserver configuration or PHP settings, and should be resolved in order to download information about available updates, fetch aggregator feeds, sign in via OpenID, or use other network-dependent services.
What's the fix? Thx.
Chuck
I don't know the answer. I think that the next steps would depend on your operating system (Win XP or Vista?) and the method you've used to install locally (Acquia Drupal Stack Installer or WAMP?)
hey rob
i ve ran into a problem. its about FCKeditor. as per your tutorial it should work pretty well but the buttons dont show up. when i try to add a blog post what i get is a clean text area with no buttons or formatting options. i checked with the drupal forums and then i used BUEditor. it worked fine but has only limited options.
any other editors ???
thnx
*seeker
If the buttons don't show up then either all the files have not been uploaded or the files are not in the correct location. So I would double check the locations of the the files. If that doesn't help try the alternate method of installing using the WYSIWYG API. http://learnbythedrop.com/drop/144
for some reason, sites/default/defaul/settings..php is a Microsoft Picture It folder instead of a php file. Something is defaulting the drupal files into Picture It files. Do you know what is going on? Do I need to download the Drupal 6.12 file again?
Got it figured out...Yeah!!!
I was going to recommend that you right click the file, select "open with" and then select "choose program". Sometimes Windows decides on its own how a file should be opened. It does not affect what's in the file just what program opens by default when you double click.
Great video Rob, thanks so much for doing this. At 4:30, your phpMyAdmin screen has a warning about not having a password for "root". I know you're not claiming security guru status, but you seem to have figured out enough to be confident in ignoring the bold red warning. How do I get there? I tried once to add a password for root, and I locked myself out of everything. (I feel a little deceived by the inviting drupal website.) Can you recommend a way to learn enough to have decent security and not destory my work? Please help me help myself, drupal's docs are driving me crazy.
When you're developing on the web you're going to have to have a root password for your database. On localhost the only reason it would be necessary is if other people have access to the computer or it is on a corporate network. When I work locally I don't have to deal with such issues so I don't set a root password for the database. So what level of security you use depends on how other people might gain access to your database.
The title says it all. I have struggled with other intro videos as I did not have Ftp or WAMP downloaded yet. This was great, thanks very much.
Hi
Just watched this video. Absolutely brilliant!! I was able to follow it exactly and get it all up and running. I have spent ages going round and round in circles until I came across this video.
Thank you so much for doing this video. I look forward to trying the other videos you have done.
Cheers....Mark
hi guys, This installation for drupal is very simple man... from past 2days i am fighting with servers and php and db to make it work together... messing around. but this one is very straight forward and simple.. .i will goahead and recommend this server to all my colleagues.
HI...
while installing drupal6.12 on after database configaration det enters i got an error like this
Warning: fopen(./sites/default/default.settings.php) [function.fopen]: failed to open stream: No such file or directory in D:\xampp\htdocs\drupal-6.12\includes\install.inc on line 188
Warning: Cannot modify header information - headers already sent by (output started at D:\xampp\htdocs\drupal-6.12\includes\install.inc:188) in D:\xampp\htdocs\drupal-6.12\includes\install.inc on line 618
Warning: Cannot modify header information - headers already sent by (output started at D:\xampp\htdocs\drupal-6.12\includes\install.inc:188) in D:\xampp\htdocs\drupal-6.12\includes\install.inc on line 619..
plz help
how can i add new theme?
Upload the new theme folder to the 'sites/all/themes' directory (it probably doesn't exist do just create it) then you can switch the theme via the administratio menu. The following video provides more details. http://learnbythedrop.com/drop/121
Hi, just wanted to thank you for your tutorial, really helped me out. I'm just stuck on one issue. I am on Windows XP, using Apache2.2, PHP 5 and phpMyAdmin 3.1.2 which I installed and set up seperately. I successfully installed Drupal, have the database set up, but when I am directed to the page "View your site" (once it has installed), if I click on any of the links under say 1)Configure your site website, instead of being directed to that page, I am sent to the Index of /drupal on my localhost....Just a white page, with the files in a column on the left. I am a bit stumped as to why I can't seem to navigate the Drupal set up site properly. Any suggestions would be much appreciated. Thanks.
If you say that you setup Apache, PHP, etc. separately I'm assuming that you did not use Wampserver. If that's the case then I think it probably has something to do with the way the environment (perhaps PHP or Apache) is set up. I have no idea off the top of my head what it could be.
I have managed to work it out, I had to reconfigure the Apache file as I had installed them all seperately. Thanks anyway, I now have an update to try to fathom out!! Cheers.
Post new comment