By lever on

I was wondering if there is a tutorial that exists that would help me with an install of Drupal, MySQL, and PHP for my web server. Everthing that I find shows how to set it up for a web server through a hosting service. My server is in my house on a Win2000 box with all updates. I have Apache up and running (its kinda hard to screw that up) and my DNS forwarding software is working correctly. If I go to my website from another computer everything functions fine. I can install PHP and MySQL but Im not sure I am setting it up correctly. If I add the MySQL extension for PHP I start getting a lot of errors from Apache. Error such as: "The dynamic link library LIBMYSQL.dll could not be found in the specified path". I have tried installing all the software in different order and still get these errors. Also when installing drupal I get a message stating: "Your web server does not appear to support any common database types". I do have a database created with MySQL but I am guessing it is not installed correctly. Any help with this would be greatly appreciated!

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

investigate something like WAMP which packages Apache, MySQL and PHP together in one install and installs and configures them all.

Most here on the forums use a flavor of Linux on their server environments, Win2000 is pretty old at this point in the game, personally, I'd lose it and use Linux which gives you much more support here on the d.o forums.

lever’s picture

lever commented

Well I have used Ubuntu before but I am very well versed in all flavors of Windows. Nothing against Linux, just dont know it that well. For someone not that familiar with Linux how hard would it be setting up a webisite, mainly a blog, from Linux?

vm’s picture

vm commented

considering that most hosts these days use linux, I can't image it that difficult.

I didn't find it difficult to install & use linux, but everyones skillset and desire to learn is different.

You can continue to push through with a windows server if you choose, however, as I mentioned, you are limited with support using a win server as not many here on d.o do. There are some however and I'd still advise using a package like WAMP or Apache2Triad to created your Apache, MySQL and PHP installation.

jonfhancock’s picture

jonfhancock commented

If you install ubuntu server, it's extremely simple to set up a server.

Once you've installed Ubuntu, run the following command in the terminal:

sudo atp-get update && sudo apt-get install apache2 php5 mysql-server-5.0 phpmyadmin

That will download, install and configure apache, php5 mysql5 and phpMyAdmin (optional) on your server.

Then you can edit your apache conf by typing cd /etc/apache2 use the command nano followed by a file name to open it for editing.

Your web root folder is /var/www

With that said, you will save yourself tons of time and headaches just using a paid host. They're dirt cheap, and usually more reliable than your home server could be. I served a site from my home on a windows machine (using apache) for about 8 months and realized that it sucked, then moved to another host. Now, I have a Virtual Private Server (running Linux of course), and I wouldn't even think of going back to a home windows server.

I do have a web server running on all my linux machines though for easy access to files.

gpk’s picture

gpk commented

If I add the MySQL extension for PHP I start getting a lot of errors from Apache. Error such as: "The dynamic link library LIBMYSQL.dll could not be found in the specified path"... Also when installing drupal I get a message stating: "Your web server does not appear to support any common database types". I do have a database created with MySQL but I am guessing it is not installed correctly.

You have it in 1. PHP can't talk to MySQL for whatever reason (and I know little about this! but search the web for your error messages should bring up useful results.

Agree that a paid webhost is "cheaper" in the long run. Another WAMP package called XAMPP is very good, but not secure enough for production use. Your current approach is reasonable if it's a hobby site and you want to learn how to do this stuff...

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

lever’s picture

lever commented

Well I finally got it running. I tried WAMP and after installing it, drupal installed like a dream. I may end up going with a hosting service, put for the time being, I can play around for free. I appreciate all the help. Now the fun begins. Learning drupal.

drupaljohngo’s picture

drupaljohngo commented

Hi

I was wanting to do the same thing. I experimented with Xampp and used dyndns on Windows 7 to create my own web site. I somewhat understand what I'm doing however I am finding the support for linux better but there is a learning curve. I ran into problems when wanting to use Ruby scripts, some PHP scripts from hot scripts, and simply trying to understand Web min as a noob.

I did a dual boot of Ubuntu 64 bit desktop edition and turned to VirtualBox to use The Drupal appliance. I love the appliances because it installs so well. I am a bit confused as to how to get Drupal on my home server. I'm running into file sharing issues, certificate problems, and other noob issues.

Lever, if you have any advice I'd like to test my server if you are willing to help. For me it is a matter of configuring the IP numbers. Do I port forward thru the router? for example the local numbers from the appliance are 192.168.1.106 (these numbers may be different later) and my xampp server when my windows 7 is running is 76.178.221.76

I intsalled apache in Ubuntu and I think apache is in the Webmin of the Drupal appliance. I am willing to make a screencast and serve it on Youtube if anyone is willing to help.

Sincerely

Johngo