Tutorial: How to run vBulletin onto your PC

[TECK]

This tutorial is vBulletin.org and cPublisher.com copyrighted. All rights reserved.
Please ask permission in this thread to copy the tutorial. If granted, post a link that points to this page.

This tutorial will teach you how to install Apache, PHP and MySQL binaries in win2K and winXP, in order to install vBulletin directly onto your PC. It's useful because you can run your own board on your PC, to test code hacks, updates, etc before you put them to your live board.

UPDATES: To receive an email when this tutorial is updated, click here (https://vborg.vbsupport.ru/member2.php?s=&action=addsubscription&threadid=39482).

TOOLS NEEDED
- PHP windows .zip package (http://www.php.net/downloads.php) - 4.4MB (for more info, visit www.php.net)
- Apache Server no_ssl .msi binary (http://nagoya.apache.org/dist/httpd/binaries/win32/) - 3.2MB (for more info, visit www.apache.org)
- MySQL windows installation files (http://www.mysql.com/downloads/mysql-3.23.html) - 13.3MB (for more info, visit www.mysql.com)

NOTE: The have been some problems with the php4ts.dll library. If you cannot restart your Apache server, download this file (https://vborg.vbsupport.ru/showpost.php?s=&postid=326610) and replace your current one, or download latest PHP snap (http://snaps.php.net/win32/php4-win32-STABLE-latest.zip).

PC PREPARATION
Create a folder called Network in your local disk C: with the following 2 sub-folders:
|--[C:
|----[Network
|------[MySQL
|------[Php

PHP Binary INSTALLATION
01. Extract the contents of PHP .zip file to C:\Network\Php folder.

02. Copy the 'C:\Network\Php\php.ini-dist' file to your %SYSTEMROOT% directory (C:\WINDOWS for winXP; C:\WINNT for win2K).
In %SYSTEMROOT% folder, rename php.ini-dist to 'php.ini' and open it.

03. In php.ini, you will need to set the 'doc_root' to point to your web server(apache) document_root, like below:
; The root of the PHP pages, used only if nonempty.
; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
; if you are running php as a CGI under any web server (other than IIS)
; see documentation for security issues. The alternate is to use the
; cgi.force_redirect configuration below
doc_root = "c:\network\apache2\htdocs"

04. Still in php.ini, change the 'extension_dir' setting to point to your php-install-dir, like below:
; Directory in which the loadable extensions (modules) reside.
extension_dir = "c:\network\php"

05. Still in php.ini, change the 'mail function' setting to point to your ISP, like below:
[mail function]
; For Win32 only.
SMTP = smtp.myisp.com
; For Win32 only.
sendmail_from = johndoe@myisp.com

06. Save and close the php.ini file.

07. In C:\Network\Php folder, find php4ts.dll file. Move it to the %SYSTEMROOT%\system32 folder.

NOTE: Make sure you MOVE that file, DO NOT copy it only.

Apache Server INSTALLATION
01. Run the .msi file. Enter the value localhost for 'Network Domain' and 'Server Name'.

IMPORTANT: Make sure you select a custom setup and install Apache to C:\Network, not to 'C:\Program Files\Apache Group'. It will create automatically the 'Apache2' folder for you. There is no need to install the documentation, it is available online.

02. Go to your Apache conf file (C:\Network\Apache2\conf\httpd.conf) and find:
#LoadModule ssl_module modules/mod_ssl.so

BELOW this, add:
LoadModule php4_module c:/network/php/sapi/php4apache2.dll

03. Still in httpd.conf, find:
AddType application/x-tar .tgz

BELOW this, add:
AddType application/x-httpd-php .php

04. Still in httpd.conf, set the files that Apache will serve if a directory is requested. Find:
DirectoryIndex index.html index.html.var

REPLACE it with:
DirectoryIndex index.php index.html index.php.var index.html.var

05. Save and close the httpd.conf file.

06. Restart Apache Server.

MySQL Binary INSTALLATION
01. Extract the .zip binary to a temp folder. Run the Setup.exe file.

NOTE: Make sure you browse to C:\Network\MySQL folder, when you select the install location.

02. Go to C:\Network\MySQL\bin and run the 'winmysqladmin.exe' file. The WinMySQLadmin 1.3 database manager will start.
First, it will ask you to enter a new username and password. Enter the following information:
Username: root
Password: password

Click on OK.

03. Go to Go to C:\Network\MySQL\bin\data folder and create a new folder called vbulletin. That is your database.

04. Open a CMD window and change it's location to your current MySQL /bin folder.

05. Set your Users:
\bin> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO dummy@localhost;

NOTE: There is no need to do all GRANT 3 statements, the first one is more then enough. The other two were presented to you so you learn mode about the GRANT/REVOKE commands.

These GRANT statements set up three new users:
monty
A full superuser who can connect to the server from anywhere, but who must use a password 'some_pass' to do so.
Note that we must issue GRANT statements for both monty@localhost and monty@'%'.
If we don't add the entry with localhost, the anonymous user entry for localhost that is created by mysql_install_db will take precedence when we connect from the local host, because it has a more specific Host field value and thus comes earlier in the user table sort order.

admin
A user who can connect from localhost without a password and who is granted the RELOAD and PROCESS administrative privileges. This allows the user to execute the mysqladmin reload, mysqladmin refresh, and mysqladmin flush-* commands, as well as mysqladmin processlist . No database-related privileges are granted.
(They can be granted later by issuing additional GRANT statements.)

dummy
A user who can connect without a password, but only from the local host.
The global privileges are all set to 'N'?the USAGE privilege type allows you to create a user with no privileges. It is assumed that you will grant database-specific privileges later.

FINAL STEPS
01. Go to Start > Programs > Startup
Delete the 'Monitor Apache Servers' and 'MySQL Admin' tools. They waist your resources for nothing and are not needed. I personally moved the MySQL Admin tool to another folder, in case I want to create later another database.

02. The C:\Network\Apache2\htdocs folder is your web root. Create there a sub-folder called 'forum'.
You know the rest of VB installation drill... Once you are done, call your forum index.php at:
http://localhost/forum

NOTE: If you experience any cookie problems, add this line to your vBulletin config.php file:
define('USE_COOKIE_WORKAROUND', 1);

That's all. No more uploads needed to test the hacks. :)
Please post here if you were successful with the localhost installation. It works perfectly for me on winXP.
------------------------------------------------------

BACKUP-RESTORE ON localhost
(See also Velocd's tutorial (https://vborg.vbsupport.ru/showthread.php?postid=263071#post263071))

TOOLS NEEDED
- Open Command Window (http://download.microsoft.com/download/whistler/Install/2/WXP/EN-US/CmdHerePowertoySetup.exe) PowerToy - 0.5MB (for more info, visit Microsoft (http://www.microsoft.com/windowsxp/pro/downloads/powertoys.asp) site)

NOTE: This PowerToy adds an "Open Command Window Here" context menu option on file system folders, giving you a quick way to open a command window (cmd.exe) pointing at the selected folder.

BACKUP PROCEDURE
01. Create a new folder, called 'C:\sqlback'.

02. Right-click on the C:\Network\MySQL\bin folder and select 'Open Command Window Here'. A CMD window will open.

NOTE: You can also manually browse to the folder. Click on Start > Run > Type cmd in the 'Open:' area and hit Enter.
At the CMD prompt, type C: and hit Enter.
Type cd network and hit Enter.
Type cd mysql and hit Enter.
Type cd bin and hit Enter.

03. At the prompt, type:
mysqldump --opt -uUSERNAME -pPASSWORD DATABASENAME > c:/sqlback/bk060502.sql

NOTE: Change the highlighted values with your own. When done, you will see the command prompt.
060502: month date year (easier to remember the last date you backup your database). Change it with the corresponding date of your actual backup.

RESTORE PROCEDURE
This is useful if you want to import onto your localhost the live forum database.

01. Right-click on the C:\Network\MySQL\bin folder and select 'Open Command Window Here'.

02. At the prompt, type:
mysql -uUSERNAME -pPASSWORD DATABASENAME < c:/sqlback/bk060502.sql

NOTE: Change the highlighted values with your own. When done, you will see the command prompt.
------------------------------------------------------

OTHER TUTORIALS
- How to make a reliable database backup (https://vborg.vbsupport.ru/showthread.php?s=&threadid=39558)
- Upgrade your hacked board in less then 30 minutes (https://vborg.vbsupport.ru/showthread.php?s=&threadid=38545)

[TECK]

If you want to test your installation before you run vBulletin install, create a index.php file with the content:<?php phpinfo(); ?> and place it into your 'htdocs' folder. It will show you the server stats, etc.

[Sinecure]

First off, whos the person who rated this thread 1? It seems someone keeps doing this to Nakkids Threads.

I'd like to thank Nakkid for doing this, he helped me with this yesterday, and its a huge time saver, especially that little extra you gave me nakkid :)

[Lesane]

^- Display Thread Raters: Who rated how? (https://vborg.vbsupport.ru/showthread.php?s=&threadid=39406) ;)

Great tutorial Nakkid, i'm going into this tomorrow. Again, well done.

[Sinecure]

I'll ask Firefly if we can install it, its a very subtle but usefull hack :)

[Darren Lewis]

Originally posted by Sinecure
First off, whos the person who rated this thread 1? It seems someone keeps doing this to Nakkids Threads....

I've noticed this too :rolleyes:

Thanks nakkid for writing this. I've been having some trouble getting Apache 2 and PHP 4.2.1 running correctly.

Darren.

PS I've rated this thread as 5 :)

[Mystics]

Thank you!

I only needed the "PHP Binary INSTALLATION" and it worked perfect http://www.plauder-smilies.de/happy/xyxthumbs.gif

Mystics

[Chris M]

Thank you very much nakkid...

I not only added this to my Favourites, and rated it a 5, but I saved the target too!

Satan

[Darren Lewis]

What is the difference between MySQL and MySQL Max?

[TECK]

mysql-max includes support for Berkeley DB (BDB), InnoDB tables and much more. however, is not needed for intranet on Windows env.
for more info, read here:
http://www.mysql.com/doc/m/y/mysqld-max.html

[Brad]

i got a problem, its not seeing php or perl, but it will disply html pages right when i call them via localhost.


what i get for perl


Server error!
Error message:
couldn't create child process: 22503: C:/Network/Apache2/cgi-bin/ubb/cp.cgi
If you think this is a server error, please contact the webmaster
Error 500
localhost
05/15/02 10:40:47
Apache/2.0.36 (Win32)

and the vB install script says i do not have php installed, also phpinfo just comes up as text Oo. i fallowed the directions to the line


edit: forgot to add, that where i updated to XP corp from 2k pro my system folder is c:\winnt

[TECK]

lou, i dont know any configuration related to perl. you need to refer to the manual and add the right modules.
contact UBB for this matter.

regarding PHP, do you have 2 directories:
c:\windows and
c:\winnt ?

if you do, you need to do a clean install of your winXP. i had a similar problem with a customer a while ago. let me know. winNT and winXP dont mix at all. btw, this tutorial was tested so far in 12 pc's and it worked perfectly all the time.

[Brad]

no i just have c:\winnt, i only posted the perl because it was the only error i got, php would just go into html.

[TECK]

the perl modules are not installed by default. you need to configure your server to operate with cgi files also.

did you ran the Vb install? everything is ok? my concern is the VB installation only.

[Brad]

no the vB install will not work because its saying php is not installed, so the install steps cannot work, and the script tells me php is not installed.

[TECK]

i would double check one more time the steps. you missed one, by accident, i'm sure. it happened to me also few times. :)
i know is annoying, but try this. delete and uninstall everything and start from scratch.

another important step is to RESTART Apache, once you did all the install steps. let me know. i hate the fact that you are the only one who have problems. i will try my best to help you.
if you still have probs, please check my profile and contact me on msn. i am online now.

floren :)

[Brad]

i restarted it, i got it working, i just had to reinstall everything over, i think one of the scripts dident come over right, no matter, i got ubb,vb,phpbb,ikonboard,yabb,and postnuke all running now

[TECK]

you rock!! congrats.

[Velocd]

Great tutorial ;) This will defiantly save me time testing hacks, etc. Thnx a ton!

[Velocd]

ARGH!

I just tried to install this and it gave me the same error Anime-loo was experiencing above. I made sure to correct the mistakes he made, and reinstalled the whole thing again, but it still wont work!! 2 hours later and not a damn sign of improvement :(
It keeps telling me, when trying to run http://localhost/forums/admin/install.php, that PHP is not installed. I am running Windows XP Professional and have done everything correctly..to my understanding. Any help?

[Brad]

Originally posted by Velocd
ARGH!

I just tried to install this and it gave me the same error Anime-loo was experiencing above. I made sure to correct the mistakes he made, and reinstalled the whole thing again, but it still wont work!! 2 hours later and not a damn sign of improvement :(
It keeps telling me, when trying to run http://localhost/forums/admin/install.php, that PHP is not installed. I am running Windows XP Professional and have done everything correctly..to my understanding. Any help?


make sure you hacked the apache scripts.

[Admin]

Originally posted by Anime-loo
make sure you hacked the apache scripts.
lol, Hack Apache scripts. ;P

[Brad]

you know what i mean :p

[zachb]

great tut nakkid! i'm sorry people keep rating your threads badly, i think they are great. i'm gonna rate it a 5. :) thanks again!

[eiSecure]

nakkid, just a thought... phpTriad, a free download, automatically installs and configures (for the most part) Apache, MySQL, and PHP.

It's all in one, easy-to-setup package that will probably make it easier for users without as much technical knowledge.:)

Cheers,
Alex

[TECK]

can we have a url link alex? thanks :)

[eiSecure]

Sure.

Direct Download:
http://download.com.com/redir?pid=6474268&merid=73668&mfgid=73668&ltype=dl_dlnow&lop=link&edId=3&siteId=4&oId=3120-20-0&ontId=2165&destUrl=%2F3001-2165-6474268.html

Download.com search results page:
http://download.com.com/3120-20-0.html?qt=phptriad&tg=dl-2001&search=+Go%21+


-Alex

[TECK]

also:
http://sourceforge.net/projects/phptriad/

thanks for the tip. :)
however, i think they dont support php421 and the new apache20. correct me if i'm wrong.

[Brad]

id rather do it by hand anyway.

[TECK]

ya. same here. at least i know what options i put in there and customize it the way i want. ;)

[Velocd]

Well after many attempts on trying to get this working with your tutorial Nakkid I just couldn't get it to work, I've been doing everything perfectly. So I uninstalled everything, and I decided to try PhpTriad. And I must say, not only did it work (with 2.2.6), but it was MUCH easier to install ;)

---------------------------------------------------------------------------------

Quick little tutorial on how to get this working with PhpTriad:
1. Install PhpTriad (http://sourceforge.net/projects/phptriad/)
2. Goto C:\apache\mysql\bin\ and run winmysqladmin
3. If it asks you for a username or password, enter (using Nakkid example) root for username and password for the password.
4. Still in winmysqladmin, goto the databases tab, and right click on your computer name, then select create database. Call it vbulletin.
5. Now in C:\apache\htdocs create a folder called forums, then upload all the vbulletin stuff in there.
6. Goto your start menu > PHPtriad > Apache Console > Stop Apache. (this step might now even be needed, but was for me)
7. Now go to start menu > PHPtriad > Apache Console > Start Apache
8. Apache will come up in a window, simply minimize it.
9. Goto http://localhost/forums/admin/install.php, and you're done!

This doesn't require any moving files or file modifications, and didn't give me any errors either ;)
Thanks to eiSecure for providing the info on PHPtriad!

[eiSecure]

Good thing I mentioned it, huh?;)

[Velocd]

you're a life saver ;)
I'm sure there was just something messed up with my system that Nakkid's way wouldn't work, but either way PhpTriad worked perfectly and was much easier to install.

[TECK]

glad to got it up and running. the important thing is that is working right? :)

[eiSecure]

hmm... is there supposed to be a delay when replying to threads by email?:confused:

[Velocd]

I would think that it would be slower than usual replying, although I haven't used that feature yet. How slow of a delay?

[eiSecure]

Let's just say that I replied by email before I posted the post above, and obviousely, it still hasn't shown up yet.:D

[Velocd]

I've got 2 questions to ask ;)

Question: How do you backup/restore a database using an SSH Client like Putty if the database is on your PC? I've tried entering in the hostname field of putty "localhost" and also my IP address but no go, it says cannot make connection. Would I be able to just use phpmyadmin for this, since its on my computer maybe it will be more reliable than using it on the web?

Question 2: I've noticed a small problem trying to register a new user (using phptriad installation method) and thats that you get a apache error. Registering members on a local vbulletin is sorta pointless anyway, but I just wanted to know if this is an error or normal.

[Royal]

after using phptraid i still cant get the thing working

when i go to http://localhost/forums/admin/install.php i get the msg :

Connection refused

--------------------------------------------------------------------------------
Description: Connection refused
--------------------------------------------------------------------------------

and when i open the install.php in IE i get :
You are not running PHP - Please contact your system administrator.


what could be wrong ?? :eek:

[Velocd]

Uninstall everything, make sure you just don't delete the folders, but go into your Windows Control Panel and uninstall PHPTriad (apache, php, mysql) from there.

Now try reinstalling it again only following the steps I have in post #31, no file modification are needed as stated in post #1.

Try this and let me know how it works. Also, what operating system are you using?

[TECK]

Originally posted by Velocd
I've got 2 questions to ask ;)

Question: How do you backup/restore a database using an SSH Client like Putty if the database is on your PC? I've tried entering in the hostname field of putty "localhost" and also my IP address but no go, it says cannot make connection. Would I be able to just use phpmyadmin for this, since its on my computer maybe it will be more reliable than using it on the web?

Question 2: I've noticed a small problem trying to register a new user (using phptriad installation method) and thats that you get a apache error. Registering members on a local vbulletin is sorta pointless anyway, but I just wanted to know if this is an error or normal. 1. wrong thread. check the backup tutorial.

2. i dont recommend anyone to use phptriad. it removes you the ability to configure the way you want all the server options.
the old school way is always the best way... and it works perfectly. why? because with phptriad, if there is a new php, mysql or apache release, you must uninstall everything and lose all your settings and data.
in my humble oppinion, phptriad is for lazy people who dont like to take the time to configure their server the right way. if you use phptriad, you will never learn anything about any config file and settings related to apache, php and mysql.

remember, if is not working is because you missed a step. just an example, 99% of the people forget to restart Apache after they set all their options. this tutorial worked perfectly on every single pc i install it, so it must work also in yours.

[Admin]

Originally posted by nakkid
if you use phptriad, you will never learn anything about any config file and settings related to apache, php and mysql.
You also don't learn anything from just following someone else's tutorial and following instructions.

[TECK]

true. it took me a while to get it the right way the installation. you remember the DirectoryIndex tip you gave me long time ago?

[Admin]

Ok...

[Velocd]

Originally posted by nakkid
1. wrong thread. check the backup tutorial.

2. i dont recommend anyone to use phptriad. it removes you the ability to configure the way you want all the server options.
the old school way is always the best way... and it works perfectly. why? because with phptriad, if there is a new php, mysql or apache release, you must uninstall everything and lose all your settings and data.
in my humble oppinion, phptriad is for lazy people who dont like to take the time to configure their server the right way. if you use phptriad, you will never learn anything about any config file and settings related to apache, php and mysql.

remember, if is not working is because you missed a step. just an example, 99% of the people forget to restart Apache after they set all their options. this tutorial worked perfectly on every single pc i install it, so it must work also in yours.

1. *dies* That is the same point Firefly brought up. You see, you cannot use an SSH client like Putty to backup your forums installed on a localhost, like my pc. It wont connect for purposes that are probably logical--one being it is my pc and making a connection through putty to the very computer you type on seems silly. Still, I need a way to make a reliable backup so that when I finish with my forums on my computer I can transfer the backup to my webserver.

2. If I had a real server I would more than likely go your way Nakkid with doing by hand, ofcourse It's just my crappy Compaq Laptop and the only real purpose of it right now is for testing hacks on my vbulletin. Same reason I would never use a wysiwyg over regular text editors for any programming/authoring.

[FWC]

Originally posted by Velocd


1. *dies* That is the same point Firefly brought up. You see, you cannot use an SSH client like Putty to backup your forums installed on a localhost, like my pc. It wont connect for purposes that are probably logical--one being it is my pc and making a connection through putty to the very computer you type on seems silly. Still, I need a way to make a reliable backup so that when I finish with my forums on my computer I can transfer the backup to my webserver.
If you want to backup or restore databases on your home pc you can enter the same commands you would in an SSH client from the DOS command line. Navigate to your mysql directory and you can run them from there.

[Velocd]

Thanks for the help, that worked perfectly ;)

[FWC]

Originally posted by Velocd
Thanks for the help, that worked perfectly ;) Glad it worked for you. :)

[Velocd]

Quick Tutorial - How to backup/restore on a localhost

I thought I would make this because I fought alittle trying to get this working using the MSDOS shell, and found some things to be alittle different than from what backing up is usually like.
Once again, thanks to FWC for the tip, and also Logican from another post providing me some info

(note: done using Windows XP, should work on older OS also)

----------------------------------------------------------------------------------------

1. Copy and paste the following into your address bar, then hit enter: %SystemRoot%\system32\cmd.exe

2. Now depending on how you installed MySQL on your system, either with or without PHPTriad, you need to browse to that directory bin folder.

For example, if you did use PHPTriad, type cd c:\apache\mysql\bin.


3. For BACKING UP:

Type mysqldump -u username --opt database_name > backupfile.sql, filling in username and database_name with the correct values.

This method worked perfectly for me using the PHPTriad installation, should do the same with the other. If it asks you for a password, enter the password.


4. For RESTORING:

Type -u root -ppassword database_name < backupfile.sql in the command prompt.

You might get an error saying a table already exists, if so you need to clear your current database. Go into phpmyadmin and drop it that way. Be sure not to drop the whole database eliminating it, but just dropping the tables. Before doing this check your database backup you just created to make sure it actually created its and is not corrupt.

Thats it!

[TECK]

good tutorial.. :)
i will add it in the first post, if you dont mind. :D

[TECK]

apache 2.0.39 released. i updated the link.

[Velocd]

Originally posted by nakkid
good tutorial.. :)
i will add it in the first post, if you dont mind. :D

np ^_^

Originally posted by nakkid
apache 2.0.39 released. i updated the link.

Hmm..what changes can we expect in this apache from its previous versions Nakkid? ;)

[TECK]

they fixed a security bug in the routines which deal with invalid requests and also fixed some syntax code errors, like the korean language for example... and some extra misspells (araxis merge compariason). nothing that would affect us locally. the security bug was always present until 2.0.36. aparently they fix it in 2.0.39, but created another one related to php apache SAPI module.

i updated some useful info related to the current conflict between php and apache, here (https://vborg.vbsupport.ru/showthread.php?postid=257961#post257961).

[TECK]

i got it working guys with php421 and apache 2.0.39.
the fix is on the first post. :)

[DestyNova]

Great, many thanks for this excellent tutorial =)

I been use Kevin Yank's book instruction to set up these apache and PHP but yours are much more detail and clear (also up to date instruction). Again many thanks! I m going to set it up right away ;)

[DestyNova]

Nakkid

Can I have your permission to copy/paste these at my forum when it is ready and up? I dont know if non-license can post here if they want to comment or add etc.. Of course I ll credit you and non-modifity instructions. Thanks =) It is most simply and clear instruction on installing these server, I feel that it is more benefit for my members and friends than other instructions hover around thur internet.

-edit- forget to add, installion processing is perfect and error-free. Thanks!

[TECK]

non licensed people can post here... tell them to buy vB. :)
i would prefer to place a link here.

btw, what's the url for your forums?

[DestyNova]

Ok, I ll link to this forum then add thread so that they can comment or Q&A at my forum, thanks.

Certainly, I PM you about that but it is closed off due to editing and add, this vbulletin.org has tons of nice features, so it will take some while to edit and add etc.. =)

[DestyNova]

Originally posted by Nakkid
RESTORE PROCEDURE
This is useful if you want to import onto your localhost the live forum database.

01. Right-click on the C:\Network\MySQL\bin folder and select 'Open Command Window Here'.

02. At the prompt, type:
mysql -uUSERNAME -pPASSWORD DATABASENAME < c:/sqlback/bk060502.sql

NOTE: Change the highlighted values with your own. When done, you will see the command prompt.
------------------------------------------------------

I m curious about that... I m not sure if it is work or not, so if mysql spit out these results with different commands and is it work or what? I need to know before I can do that to my real forum at www

thanks I maybe not be clear about that..

Also when it spit out the .sql to backsql folder and I edit it with Ultraedit and find out it is empty but only Enter password: and 16 bytes is it normal? As ya aware, I m just start on PHP and MySQL when I bought a book off from sitepoints.com so excuse my noobie QQ =\

-edit- I forget to add that I m Win2k user and I dont need that XP tool, PowerToy but use old fashion way but still not unsure about that werid 16 bytes and Enter password: I figured out on command prompt. it come out alright and I undy what you mean by that but that bytes and Enter Password:? thanks

[TECK]

you dont edit nothing on the .sql file.
for a backup related to your live forums, see the other tut i made:
"how to make a reliable backup"
posted in this forum also.

[Velocd]

01. Right-click on the C:\Network\MySQL\bin folder and select 'Open Command Window Here'.


I've never noticed that before, and for good reason to because it's not showing up. Are you sure its just a regular right click, or maybe also with some key strokes?

[TECK]

ya... but you need to install the powertoy. i placed a download link...

[eiSecure]

Originally posted by Velocd


I've never noticed that before, and for good reason to because it's not showing up. Are you sure its just a regular right click, or maybe also with some key strokes? If it doesn't work, just do this:

1. Click on Start Menu --> Run
2. Type in 'cmd' and press enter.
3. type in 'C:' and press enter.
4. Type in 'cd Network' and press enter.
5. Type in 'cd MySQL' and press enter.
6. Type in 'cd bin' and press enter.

The old-school DOS way.:D

[TECK]

Originally posted by eiSecure
The old-school DOS way.:Dthat's the best way always. :)
I will add your instructions on the first post, eiSecure.

Actually I had it mentioned this method as a note. :)
But I updated the rest of the information you listed above...

[eiSecure]

Oh, I forgot... if you type in 'cmd' and press enter, if only works if you're on a NT platform.

For all other users, go to start menu, and select MS-DOS Prompt.:)

[TECK]

this tutorial is the NT platforms only... :)
in win98 you need to download an extra file and it doesnt work well anyway.

btw, "Start > Run > type command" for windoze98 :p

[N9ne]

Thanks for this Nakkid! this has made my life easier :)

[N9ne]

Erm does this work with winXP?

[DestyNova]

Originally posted by Tha Rock
Erm does this work with winXP?

Yes, Nakkid is XPuser (I think)


Nakkid, I think this two links should add to your tutorial but heck it is your thread so up to you if you want to add or not..

First one... "how to use PHP with .NET"

Using PHP with .NET (http://www.informit.com/isapi/product_id~{D52A041D-4FCB-44C9-BE8C-E2D446D3A999}/content/index.asp)

I make fake account so anyone can use and check this article out.


phptemp@hotmail.com - account name (fake email to avoid spams)
password - phpbuzz

It is very excellent article/tutorial by Andrew Stopford (who wrote the book, "PHP Programming for Windows")

Second... for who plan or want to use flash with/in Vbulletin....

Installing Apache 2.0 web server, PHP 4.2.0, MySQL 3.23, and PHPMyAdmin on windows for use with Flash (http://www.flashkit.com/tutorials/Backend/Installi-Jeffrey_-776/index.shtml)

A excellent tutorial to set up PHP server to work with Flash so that you can add Vbulletin with Flash effects etc.. Wrote by Jeffrey F. Hill His website (http://www.flash-db.com/)

I feel that it is somewhat benefit for any vb users to ulitize these tools.

Nakkid, Up to you if you want to add or delete my post, I just merely spree the information around for Vbulletin or PHP server users.

Have fun

[N9ne]

Everytime I go to http://localhost it takes me to localhost.com...starts telling me I have DNS problems...what am I doing wrong?!

[eiSecure]

Do you have a web server set up?

[N9ne]

a web server?

(sorry I'm a total n00b at this :()

[eiSecure]

Yeah, you need to follow the instructions on the first page to set up a web server.:)

[N9ne]

Well I did *everything* from the instructions in the first post...

[eiSecure]

Did you install apache, configure it correctly, and then start it up?

[N9ne]

I installed apache, started it up, what do you mean by configuring it correctly? Is that done via the php.ini file like in the instructions in the first post?

[eiSecure]

It should be configuring your apache configuration files.

I'm not too familiar with this, so I think Nakkid can probably help you better than I can.:):bunny:

[N9ne]

Ok I just tried it in Opera, and it works...however it does not work in IE6.

What setting in IE6 could be causing this? It takes me to localhost.com in IE6.

[N9ne]

Ok ignore my above post...

I have another problem!

After I register an user, when it shows it has sent an e-mail to the specified e-mail address...I get this at the top of the page...

Warning: Failed to Receive in c:\apache\htdocs\forum\register.php on line 517

what does this mean? how can it be fixed?

[TECK]

you dont have am email server installed in your pc. with the the settings mentioned in the tutorial, you can only send, not receive.

[N9ne]

So what do I need to do to get rid of that error message?

[TECK]

install a mail server. search on google for the ones compatible with apache and windoze OSs.

[Admin]

Or use your ISP's SMTP server.

[TECK]

step 5 on PHP Binary INSTALLATION...
but if i understood corectly, he's having a problem receiving, not sending.

[Admin]

Originally posted by Nakkid
step 5 on PHP Binary INSTALLATION...
but if i understood corectly, he's having a problem receiving, not sending.
A PHP file cannot receive an email, not by calling mail().

[Jadelit]

Originally posted by Anime-loo
i restarted it, i got it working, i just had to reinstall everything over, i think one of the scripts dident come over right, no matter, i got ubb,vb,phpbb,ikonboard,yabb,and postnuke all running now

where did you find the module variables?

[Seifer]

Originally posted by Nakkid
this tutorial is the NT platforms only... :)
in win98 you need to download an extra file and it doesnt work well anyway.

btw, "Start > Run > type command" for windoze98 :p

How bad is it on 98? I really need to learn php, and I can probably do it faster if I didn't have to load files to my server every time I want to check I'm doing something right.

Also, what is the extra file needed?

[TECK]

actually you dont need any extra file on win98, only win95. but i dont recommend you to run apache in win98. get at least win2k.

[TECK]

PHP v4.2.2-dev in the CVS. I added the link. It fixed some bugs...

[Jen]

I installed Apache, Mysql and PHP and more or less everything seems to be working good except in my vB admin.. every time I try to do something, it prompts me for my username and password again. This is real obvious with the hack auto-install scripts, some won't even run because of this. I have the same problem with phpNuke, except it won't seem to let me log in at all (I put in some debug statements in the login routine, its comparing user/pass properly and accepting it, but then fails to log in).

Any suggestions on what needs to be changed in the config files?

[eiSecure]

I'm guessing it's your browser's cookie settings?:confused:

[Jen]

negative.. it doesn't seem to have any problems with the browser. I've set the local computer to low security, cookies enabled, still the same problem. :(

In phpNuke I'm going in circles on the admin.. I log in, it shows me the admin menu, then when I click something, it goes right back to the login request.

My php.ini file is attached, I changed a few things which cleared up some of the form data issues, but now I can't seem to stay logged in.

[TECK]

yep, there is a bug in PHP. they are working on it:
http://bugs.php.net/bug.php?id=17826

[Jen]

Thanks Nakkid, I was beginning to think something was really screwed up in the config or elsewhere, but for the life of me couldn't figure out what it was.

[Mystics]

Originally posted by Jen
every time I try to do something, it prompts me for my username and password again.With adding this to your admin/config.php you can fix the Cookie problem with vBulletin:
define('USE_COOKIE_WORKAROUND', 1);

[TECK]

thanks for the tip, i will add it on the first post. :)

[DrkFusion]

Hey, You can use Jana Server which is easier to configure for new users :) you have to download php from php.net though for win.

MySQL samething, but i suggest you use phpmyadmin, the mysql manager is hard for new users.

Drk

[TECK]

The windows application that comes with MySQL is alot easier to use then phpmyadmin. In general, any web based application is not as reliable as the one built in your root.
The best way is to learn the commands that are explained in the MySQL manual and use them on a regular basis. I explained the basic ones in the first post, related to backup and restore.

[omegauk]

Hi, I have followed the instructions and installed my board locally, all perfect. Now I want to copy my live forum to this one so I can do my testing safely. How I do that?
I am running WinXP Pro.

[DestyNova]

Just download these files thur FTP then overwrite these files and be sure to modify templates that you change too.

Also queries mysql too. It will be lots of work, I do that too and successful without any problems

[omegauk]

I want to basically copy the forums style, images etc.. like the live ones, dont mind the hacks.

www.coverscene.com/forums

[DestyNova]

Ok, then go to AdminCP and look for Download/Upload under Styles, then you can download the style that you want and use your local vb to upload it to add that style and images too, download these to overwrite at your local vb

[omegauk]

yep, worked fine. Thanks. :D

[DestyNova]

=D NP

[TECK]

if you want also to import your users and posts, read this:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=39558

[nghiasi]

Nice tutorial Thank YOU!
but there a good short cut:
http://www.firepages.com.au
and download the phpdev that is already installed ehehhe.

[TECK]

Originally posted by Ang
Okay, so I followed the instructions for phptriad and it worked like a charm. I was able to install vbulletin with no problems. I then used the instructions to get a copy of my live database to be used and this worked - more or less. It completed, but then my computer locked and I had to restart.

Since I've restarted, neither the local version of vb nor the phpmyadmin scripts are able to access the mysql stuff. When I run winmysqladmin.exe it shows up as a red traffic light (not green like it was before). Is there anyway I can fix this?i personally never liked the idea of those type of premade installs.
the best way is always the old school way.
try to do it from scratch and everything will work just great.

to make a backup follow this tutorial (https://vborg.vbsupport.ru/showthread.php?s=&threadid=39558).

[Learner29]

my very minor contribution to this tutorial :

the MySQL zip file was corrupted when I downloaded it from mysql.com (I do not use any download acceleration software, just simple click through IE6)

I also used the Swiss Mirror of mysql.com (at sunsite) and SAME result.

I finally searched for the software on Google and could download it from ovh.net mirror, and that one, was great.

[Learner29]

Originally posted by Nakkid
Open Command Window (http://download.microsoft.com/download/whistler/Install/2/WXP/EN-US/CmdHerePowertoySetup.exe) PowerToy - 0.5MB (for more info, visit Microsoft (http://www.microsoft.com/windowsxp/pro/downloads/powertoys.asp) site)

This powertoy to which you made a link here Nakkid, is only for windows XP.

I am looking for the one for windows 2000, but microsoft's server is failing for the third time now on my search request.

[Dean C]

can i post this tutorial on fexboards.com (all credit will go to you nakkid :D)?

[TECK]

sure. please make sure you place a visible link that points here at the top of the tutorial.
also, please post the url of the tutorial here so i can take a look me to. thanks for letting me know.

[Dark Shogun]

Does this tuturial work with Windows ME? I tried to install everything and it didn't work. When I had to edit the file in c:/windows I think it is php.ini or something like that. I tried using wordpad and it wanted to save it as a text file so I tried notepad and it wouldn't let me type everything that needed typing because the document had so much text. I had someone do it for me. So I restarted that apache server and everything and it still doesn't work. I will try it again in the morning but does anyone know what if it actually works on Windows ME?

Dark Shogun

[TECK]

it can be done is winME but do yourself a big favour and either downgrade to win98 or upgrade to winXP. winME is the crappiest piece of software the MS ever made. it crashes simply by loading a driver, imagine running a server on it.

also use a decent text editor, not notepad etc.
i recommend www.textpad.com .

[Learner29]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Does this tuturial work with Windows ME? I tried to install everything and
it didn't work. When I had to edit the file in c:/windows I think it is
php.ini or something like that. I tried using wordpad and it wanted to save
it as a text file so I tried notepad and it wouldn't let me type everything
that needed typing because the document had so much text. I had someone do
it for me. So I restarted that apache server and everything and it still
doesn't work. I will try it again in the morning but does anyone know what
if it actually works on Windows ME?

Dark Shogun
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
use a real text editor, such as EditPlus2 and UltraEdit8
there are also some very good Free text editors such as NoteTabLight
you can download all of those from www.download.com

[Dark Shogun]

I can't afford to downgrade or upgrade right now.

Dark Shogun

[Glenn]

can anyone PLEASE help me with this? I'm using win XP home and when I install the msi, this is what shows up =(
in other words, the server wont go up, but it thinks its installed

ahhh wait I fixed it.

ok guys, when you reinstall the apache server make sure you delete the c:\network\apache2 directory and all subdirectories/files then reinstall. then you're good

ok wait wait...

I'm still getting errors restarting. I replaced the file and all that too, still dont work. any ideas?

[Koss]

hmm when I try to restart the apache i get the following error:

"The system cannot find the path specified"

any ideas? :(

[Koss]

ok i got it working, but when i try to access: http://localhost/forums/

I get a page that says "Index of /forums" and it list all the files in that folder. When I try to click on a file i get the "file download" prompt

is everyone else's like this?

[TECK]

you didnt installed properly php.

[Learner29]

hi guys.

everything in the installation procedure went silky smooth ... now I am left with one problem.

when I try to import my database, I have this error message :

ERROR 2006 at line 569: MySQL server has gone away

I turn mysql back on, and try again, but this process is killing the mysql server or something....

any help ??

[Aerith_Freak]

Apache does not work on my OS, it says that there are no listening sockets available. PHP and mySQL work fine but the Apache Server will never start.

[TECK]

it helps if you let us know what os you run.
turn off you firewalls before installing. i get you have norton installed...

[omegauk]

I did everything as described but when I call for Http://localhost nothing comes up. any ideas why?

[TECK]

before you do restart apache, double check all the steps, very carefully. dont take it for granted, ok i did this, i'm sure. this is where alot of people do mistakes...
let me know how it went.

[omegauk]

Few problems:

1. First, it will ask you to enter a new username and password. Enter the following information:
Username: root
Password: password

It didnt ask me nothing at all.

2. When I try restarting apache server I get an error saying " could not complete request"

[TECK]

1. you are talking about the mysql install right? that's because you did it several times.
go to your /windows or /winnt folder and delete the my.ini file then uninstall-reinstall mysql and apache.

[omegauk]

Originally posted by TECK
1. you are talking about the mysql install right? that's because you did it several times.
go to your /windows or /winnt folder and delete the my.ini file then uninstall-reinstall mysql and apache.

That worked, Thanks. Is there a way to upload a database to it.
I need to tranfer one of my forums there.

[TECK]

follow the BACKUP/RESTORE PROCEDURE listed on the first post.

[omegauk]

ok I just saw it, many thanks. :)

[omegauk]

When I go to my forum/index.php I get a prompt to download the file but the actual page does not come up? I am trying to restore a backup of my live forum onto it, do I need to install a copy of vb first?

also the backup file is 16mb size.

[omegauk]

I tried installing Vb and i get this message:

You are not running PHP - Please contact your system administrator.

[TECK]

before you attempt anything, just make sure you restart your apache. also, make a index.php file with the content:
<?php phpinfo(); ?>

when you get it to load that page, you installed corectly everything.
until then, i cannot help you much. please keep in mind that this tutorial was installed by alot of people. it's a little tricky sometimes but if you follow at letter all the instructions, it works flawlessly.

[omegauk]

I did that and this is what I got:

First it prompted me to save the index.php
Then it was a blank page, also when I restarted apache it said: " The requested operation had failed! "

[omegauk]

How can I just remove all the installations and start again step by step?

[TECK]

PHP 4.2.3 released. It fixes a huge list of bugs!! Make sure you update your files.
link is on the first post as usual...

[snyx]

hummmm, I have done it twice now.. and each time I get nothing showing up at http://localhost/ just dsn error?

my windows2k dir is winnt if that matters..

I got all servers running, and greenlight on mysql? huh..
ideas thx boys...

-myles

[TECK]

download the latest snapshot of php 4.3
that fixed all the probs for me. :)

http://snaps.php.net/win32/php4-win32-latest.zip

[spittingangels]

Originally posted by Aerith_Freak
Apache does not work on my OS, it says that there are no listening sockets available. PHP and mySQL work fine but the Apache Server will never start.

if you are running win2k or winxp, check to see if IIS (internet information services) is installed running, if it is, remove it via add/remove programs>windows components then uninstall and reinstall apache. this is also good advice if you follow the tutorial precisely and don't get localhost to show up--check for IIS, especially if localhost calls a microsoft page in your browser instead of apache.


Originally posted by Mystics
With adding this to your admin/config.php you can fix the Cookie problem with vBulletin:
define('USE_COOKIE_WORKAROUND', 1);

from my experience, i had this problem and added this code and it didn't work at first...just an addition...this code should be placed at the beginning of the file, before this code:

// type of database running

i tried initially to put it at the end of the file, not knowing where to place it and apparently it doesn't work there, just about every new page i called in the browser asked me to log in again. at the beginning of the file, it works great. might save someone else some extra troubleshooting.

[mli]

I have a problem. I downloaded the Triad one because Nakkid's instructions simply didn't work. Well my server worked fine, but now it doesn't work. So I installed again. And I can't edit the MySQL Database and the php files don't work. It can't access the database I guess.

[TECK]

my instructions work. Triad is a lazy way out. period.

[neocorteqz]

Having a small problem... I get the error when trying to install the board after entering all the necessary info.

Attempting to attach to database...


Warning: Access denied for user: 'root@127.0.0.1' (Using password: YES) in d:\apache\htdocs\forum\admin\db_mysql.php on line 38

Warning: Supplied argument is not a valid MySQL-Link resource in d:\apache\htdocs\forum\admin\db_mysql.php on line 47

The database has failed to connect because you do not have permission to connect to the server. Please go back to the last step and ensure that you have entered all your login details correctly.

:ermm:
What do i do?
I used the username and password suggested
which was admin and admin.
I'm a n00b to all of this so I don't have a full understanding of everything.
Thanks

edit: I'm using Win 98 SE :o :eek:

[neocorteqz]

Originally posted by TECK
my instructions work. Triad is a lazy way out. period.
They do work, granted I'm using the older version of apache.:)

I did have a small problem. I don't know if this fixed it or not(could have been blind luck;)) But...

underneath this:

#AddModule mod_ssl.c


I added this:

AddModule mod_php4.c




but in the version I'm using it didn't have that line. So i added both lines.
(This was in httpd.conf)

My problem was php files were prompting to download, instead of opening.

[TECK]

there is no need to add this module. php does it for you as ISAPI, as well as mysql. :)

[neocorteqz]

Originally posted by TECK
there is no need to add this module. php does it for you as ISAPI, as well as mysql. :) cool. thanks for that info..:)


I am having a different prob. The forum is running, but everytime I try and access the admin directory. The browser give me an Error

"HTTP 500 - Internal server error
Internet Explorer "

Have any ideas on that? the mod panel works fine. :confused:

[perrera]

I have a problem.
When I add this line to my Apache CONF file:

"LoadModule php4_module C:/Network/Php/sapi/php4apache2.dll"

Apache cannot restart the service... I haved added all the others lines but when add this... cannot start service. I haved cheched the path and the files.

BTW: My system is WinXP pro.

Help :confused:

[TECK]

it should work fine. make sure you get the latest php CVS version.
search this thread for a link.

[mli]

ok, I have another question. How do I run query's on the database this way? Because I tried it and it didn't work with the query.php file from FireFly.

[Chris M]

Download PhpMyAdmin:)

Satan

[David_McPherson]

Hello... Complete nub here...

I've gone throught the install proceedure 3 times. making sure that I've done each operation. On the 3rd time I wrote it all down on a check list... ;)

I cannot get the apache server to restart. I'm running windows XP pro.

You mention......

NOTE: Replace the php4apache2.dll library (in 'Php/sapi' folder) ONLY if you cannot restart your Apache server. The PHP devs will probably replace it in the zip file soon.


Where do I get this NEW file? From PHP?

[David_McPherson]

BELOW this, add:
LoadModule php4_module c:/network/php/sapi/php4apache2.dll


I added # before this line and it started... I don't know why It worked but it did. On to the next steps. Wish me luck... lol

[David_McPherson]

Ok.......

I've got the Green light for MYSQL, apache is hooked up and running....

Now.... How the heck do I get to the install.php file in my directories?

Its sitting here....

c:\network\apache2\htdocs\forum\admin\install .php

What do I type in my browser to access that?

[David_McPherson]

I tried this.... and a few other combonations.....


http://localhost/forum/admin/install.php

[The-SpEyE]

I've just gone throught the guide for the fifth time, and I've still got a problem.

For some reason, every time I go to a .php page, I get a 'do you want to download this file' dialog.

I've read somewhere that this is caused by an 'incorrect installation of PHP', but I've been through the guide god knows how many times, and installed it by the book.

I've got WinXP Home edn, with all the latest files.

Does anyone have any idea what I'm doing wrong?

[David_McPherson]

The-SpEyE....

You might want to check out this thread over here......

http://www.vbulletin.com/forum/showthread.php?s=&threadid=56595

Getting some good feedback there...

[groovesalad]

After I make the neccessary changes to the apache httpd.conf file, It says "The Requested Operation Has Failed!" once I try to restart my Apache server. Any ideas?

[groovesalad]

I narrowed it down. Once I do this step, Apache fails when I try to restart it:


02. Go to your Apache conf file (C:\Network\Apache2\conf\httpd.conf) and find:
#LoadModule ssl_module modules/mod_ssl.so

BELOW this, add:
LoadModule php4_module c:/network/php/sapi/php4apache2.dll

[Dean C]

in this step:


05. Still in php.ini, change the 'mail function' setting to point to your ISP, like below:
[mail function]
; For Win32 only.
SMTP = smtp.myisp.com
; For Win32 only.
sendmail_from = johndoe@myisp.com


If you myisp was freeserve... do i put smtp.freeserve.com ?

- miSt

[groovesalad]

If anyone is able to get Apache to restart after they put this in their httpd.conf file:

LoadModule php4_module c:/network/php/sapi/php4apache2.dll

Please let me know. I can't get mine to restart with that line of code.

[refertech]

Nor can I. It must be something to do with the version of php im using. I"ll look further, and im using the lastest version. php-4.2.3-Win32.zip.

Mark

[David_McPherson]

<a href="http://www.vbulletin.com/forum/showthread.php?s=&threadid=56595" target="_blank">http://www.vbulletin.com/forum/showt...threadid=56595</a>

Go there.... You will be happy you did... Got it all FIRST try!

[groovesalad]

Originally posted by David_McPherson
http://www.vbulletin.com/forum/showthread.php?s=&threadid=56595

Go there.... You will be happy you did... Got it all FIRST try!

I'm not sure how that helps me with my Apache problem not being able to restart.

[David_McPherson]

What I would do is maybe restart from scratch with that Tutorial. I don't want to disparage the originator of this tutorial but there have been some unanswered questions that perhaps only HE can answer. Try this link. and start from scratch. Uninstall everything. And re-download all nessary files.

http://www.vbulletin.com/forum/showthread.php?s=&threadid=56446

[groovesalad]

Do the versions of PHP and Apache affect the compatiblility of applying hacks on the message board that will be on my PC? The reason I want to do this is so I can install a hack on my PC to see if it runs correctly before I install it on my live message board.

[David_McPherson]

Thus far I've had no problems between the two services. My home is as setup in the above post. My hosted site is a 4.0x something. There have been no issues to date.

[groovesalad]

This is really frustrating. Neither one of those tutorials works. I wish that someone could post something that actually works.

[TECK]

groovesalad, the problem might be located between your monitor and your seat. ;)
the tutorial works. as usual, people are to comfy to pay attention to details and read every SINGLE line on it.
they go hushhh hushhh thorugh it thinking that is ok...

[David_McPherson]

Don't be frustrated. Pick ONE toot and start from the very beginning. Be sure to clear each and every file / change whatever... off your pc... So that your starting FRESH!!

[groovesalad]

Originally posted by TECK
groovesalad, the problem might be located between your monitor and your seat. ;)
the tutorial works. as usual, people are to comfy to pay attention to details and read every SINGLE line on it.
they go hushhh hushhh thorugh it thinking that is ok...

I bet you're right. The thing is, I've done your tutorial and another persons about 5 times each and still nothing. Would anyone be able to talk me through this? Now when I install Apache, the icon in the systray doesn't even show up anymore.

[David_McPherson]

Originally posted by TECK
groovesalad, the problem might be located between your monitor and your seat. ;)
the tutorial works. as usual, people are to comfy to pay attention to details and read every SINGLE line on it.
they go hushhh hushhh thorugh it thinking that is ok...

Nice.. :bored:

[groovesalad]

AIM: ChumKui
if anyone is so inclined

[groovesalad]

Tech, do you realize that your files we are supposed to download are out of date? There isn't an Apache that is 2.0.40. So which one should I get?

[TECK]

the latest version works fine always.. is not the file version that count, but how to install it.

[groovesalad]

TECH - After I do this set of instructions:


02. Go to your Apache conf file (C:\Network\Apache2\conf\httpd.conf) and find:
#LoadModule ssl_module modules/mod_ssl.so

BELOW this, add:
LoadModule php4_module c:/network/php/sapi/php4apache2.dll

03. Still in httpd.conf, find:
AddType application/x-tar .tgz

BELOW this, add:
AddType application/x-httpd-php .php

04. Still in httpd.conf, set the files that Apache will serve if a directory is requested. Find:
DirectoryIndex index.html index.html.var

REPLACE it with:
DirectoryIndex index.php index.html index.php.var index.html.var

05. Save and close the httpd.conf file.

06. Restart Apache Server.


When I try to restart the server, I get this:


Error-
The requested operation has failed


I have done everything your instructions said to do. What should I do to fix this problem? One problem I see is that there isn't an Apache 2.0.40 to download, you can only download Apache 2.0.43. Please advise.

[The-SpEyE]

Groovesalad

I had that problem too, just replace
LoadModule php4_module c:/network/php/sapi/php4apache2.dll
with
#LoadModule php4_module c:/network/php/sapi/php4apache2.dll

And you'll be able to restart the server fine

[edit]
If I add a hash (#) in front of a command in the httpf.conf file, does it comment it out? (I#m guessing the answer is yes, but I don't know)

[refertech]

yes it does. When done that way all i get is prompted for the file to be downloaded not opened. I'll still having the same problem as groovesalad but ill finally get it worked out after being pissed off about a hundred times. :) I"ll reply if i ever do.

Mark

[groovesalad]

Good, so at least I'm not the only one. I find it then, incredibly rude that Tech suggested that "the problem might be located between [my] monitor and [my] seat."

Thanks for all your help Tech, but obviously something has changed with the updated versions and it's throwing us all off course. I'd really like to see your tutorial updated.

[The-SpEyE]

Ok

First off, just so you know, there is a known bug in both Apache 2.0.4.x when working with the latest version of PHP, or a combination of the two.
I think this is the right thread (http://bugs.php.net/bug.php?id=18129), with all the necessary information in it.

To solve this use the 1.3.2.7 version of Apache, it'll run fine. (see the above thread for a download link etc).

I've got my server up and running, and its great to be able to play around with settings and hacks before implementing them.

Good job Tech and Filbert! ;)

[groovesalad]

Nothing works. Oh well. I guess I'll wait until someone writes something that does work.

[TECK]

:) you're cool. sorry it didnt go for you well. i installed this so many times.. and never had a prob.

[groovesalad]

Funny how we're all getting the same errors....you must have installed an old version or something.

[TECK]

ok.. i just installed the latest versions... everything is working as it supposed to be. i did the steps listed on the first post.
it's how you install php, that's where everyone have probs.

[refertech]

yea i agree it must be something with the way im installing php because my apache installs fine and works fine until i install php. I spend so much time in airports that this well be great for me and my labtop. :) If i get it working. :)

Mark

[groovesalad]

So, can you explain to us how we should set up PHP correctly? As soon as I put the LoadModule code in the httpd.conf file, Apache won't restart. I get an error.

[The-SpEyE]

Groovesalad - I had no problems getting it to work when I used Apache 1.3.2.7

Try downloading that, and using it instead of Apache 2.x.

Just use the same steps as in the guide, and it'll work fine.

Remember to change the line LoadModule php4_module c:/network/php/sapi/php4apache2.dll to [/i]LoadModule php4_module c:/network/php/sapi/php4apache.dll [/i], and it should work fine.

Hope this helps

[Dean C]

I couldn't get php installed properly either :(

- miSt

[refertech]

I figured it was something wrong with that module but i maybe wrong since Teck says it works for him. But im going to give 1.3.2.7 a try and see if it works better for me.

Mark

[Dean C]

let me know how you get on Mark :)

- miSt

[morey]

Don't feel to bad, I have been trying to get it to work for a couple of days now and still no avail.

[Dean C]

ive been trying to get it to work for 2 weeks... beat that!

- miSt

[morey]

miSt,

Got me beat but I am frustrated just the same. I did read somewhere that it might be a XP problem and SP1 would help to correct the problem. Did not help me though.

[refertech]

Let ask a question does the PHP installer create this directory for you guys? c:/network/php/sapi/php4apache2.dll This isnt even created with the msi. installer. But there is a zip file:

PHP 4.2.3 zip package [5,417Kb] - 6 September 2002
(CGI binary plus server API versions for Apache, Apache2 (experimental), ISAPI, NSAPI, Servlet and Pi3Web. MySQL support built-in, many extensions included, packaged as zip)

And this one has the directory and module when extracted but there is no .msi file for installation so im assuming that it must be placed and configured manually. And i know i dont have a problem between the monitor and my seat. :) But once i solve this and I will solve it, ill post back. Morey I am using XP Pro with SP1 and i was hoping it wasnt something wrong with SP1, but i wouldnt think so.

Mark

[refertech]

Humm, Apache 1.3 doesnt work either. :(
PHP is pissing me off. Back to the drawing board.

Mark

Well worst case sinario I use IIS. I know Ive had this working in the past with that server.

[morey]

Mark,

In researching this problem I ran across a post that suggested to register the .reg files that come with the PHP .zip. So I even did this but I still keep getting the can not find file error.

I hope that you can make some head way.

Morey

[Dean C]

well i have made no progress whatsoever with the installation of php...

It still says its not installed when i call install.php :(

Do you have any ideas Teck? or any way that you could help us?

- miSt

[Jacko]

- PHP v4.2.3 .zip (http://www.php.net/get_download.php?df=php-4.2.3-Win32.zip) binary - 4.4MB (for more info, visit www.php.net)
- Apache Server .msi binary (http://www.on-line.co.uk/mirrors/apache/dist/httpd/binaries/win32/apache_2.0.43-win32-x86-no_ssl.msi) - 3.2MB (for more info, visit www.apache.org)
- MySQL 4.0.3 Beta (http://mysql.he.net/Downloads/MySQL-4.0/mysql-4.0.3-beta-win.zip) .zip binary - 19.2MB (for more info, visit www.mysql.com)

mor up to date download links :glasses:

[refertech]

Well i had plenty of quit time in my hotel room lastnight and i set down and read Teck's post word for word 3 times to make sure i havent over looked anything.

I am curious Teck's what you meant by this:

NOTE: Replace the php4apache2.dll library (in 'Php/sapi' folder) ONLY if you cannot restart your Apache server. The PHP devs will probably replace it in the zip file soon.


Now i reinstalled PHP as described but i then installed apache 1.3 again, but when i edited the config file for apache i did everything the same but this line:

LoadModule php4_module c:/network/php/sapi/php4apache2.dll

I changed to this:

LoadModule php4_module c:/network/php/sapi/php4apache.dll

And now apache restarts fine but still getting prompted to download the php info file that i have put in my htdocs. Im at a ends here and IIS is calling my name. :(


Mark

[NTLDR]

Originally posted by refertech
Now i reinstalled PHP as described but i then installed apache 1.3 again, but when i edited the config file for apache i did everything the same but this line:

LoadModule php4_module c:/network/php/sapi/php4apache2.dll

I changed to this:

LoadModule php4_module c:/network/php/sapi/php4apache.dll

Haha :D You just made me think about why apache wouldn't restart for me ;)

Change the line to:

LoadModule php4_module c:/network/php/php4apache2.dll


That should do the trick :D

[refertech]

Oh, I have tried that method like a hundred times, the only way I can even get apache to start after I install PHP is to change to that module to (php4apache.dll) .

I'm doing all the steps right and there must be something like a service or something running that shouldnt be. Now im grasping for straws when i say that.

[NTLDR]

Thats what I changed and it worked for me, you do have apache 2 installed? and have the DLL in the location you have put in httpd.conf

Also do you have IIS disabled if its installed?

[refertech]

No i havent installed IIS yet, YET. :)

I tried apache 2 installed but it just wouldnt restart when i config it to point to the php4apache2.dll and i know my directory is correct that is what is strange about the whole thing, its like that dll is screwed up and wont work with apache2.

Mark

[Mystic Gohan]

I pretty much got nothin I downloaded all the stuff set it up and still nothin I am on Win 98 is that a prob?

[Mystic Gohan]

where I get IIS? and I dont even have the option to restart Apache all I get is OK and EXIT so yea

[Vile]

Originally posted by Mystic Gohan
where I get IIS?

Which operating system?

IIS comes with Windows:
Control Panel-->Add/Remove Programs-->Add/remove Windows Components-->Internet Information Services. (just check that)

The above is for XP btw, but is similar in Windows 9x.

[neocorteqz]

Originally posted by NTLDR


Haha :D You just made me think about why apache wouldn't restart for me ;)

Change the line to:

LoadModule php4_module c:/network/php/php4apache2.dll


That should do the trick :D


are you using a # in front of the loadmodule?

ie.

#loadmodule php4_module.......

I'm using phptriad, cause apparently, apache 2.0 doesn't like my system, and neither does the newest version of MySQL. I'm running 98SE... i'm going to try this on a clean install of 2k Pro soon. So i just wanted to know if you have to have that.

Thanks.

[refertech]

Well if you put the # in front of the module it wont load that module at all and you need it to load. I finally just went to IIS and used the PHP.msi installer. It configured its self to work with IIS and all works well for me now, which is all i really wanted anyway. Seems like i tried this before and couldnt ever get it to work. Either way IIS is working for me. If you want to install it you have to go to Add/Remove programs and choose Add/Remove Windows Components then put a check next to IIS and find you Windows CD. :)

Mark

[SilentKilla]

Didn't feel looking though all the post so here's my question
PHP Binary INSTALLATION

You say add the info in the file but i don't get where?

03. In php.ini, you will need to set the 'doc_root' to point to your webservers(apache) document_root, like below:
; The root of the PHP pages, used only if nonempty.
; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
; if you are running php as a CGI under any web server (other than IIS)
; see documentation for security issues. The alternate is to use the
; cgi.force_redirect configuration below
doc_root = "c:\network\apache2\htdocs"

04. Still in php.ini, change the 'extension_dir' setting to point to your php-install-dir, like below:
; Directory in which the loadable extensions (modules) reside.
extension_dir = "c:\network\php"

05. Still in php.ini, change the 'mail function' setting to point to your ISP, like below:
[mail function]
; For Win32 only.
SMTP = smtp.myisp.com
; For Win32 only.
sendmail_from = johndoe@myisp.com

[desmondw]

Thanks for posting this tutorial.

It is really helpful and useful :D

[Dynamic One]

Thanks for this nice Tut. Then you can test it before you use it on your real board. Very handy.

[Delw]

Where can I download the vb files inorder to put in on my pc... or do I have to be a registered user first?

Xenon gave me this link from the presale forum

Thanks
Delw

[Mr. X]

Does Apache NOT work at all with Windows XP sans Sp1? I really really dont want to install SP1, its still too early for me.

[NTLDR]

Apache will work with or without SP1.

[Mr. X]

Ok. I ask because it says here (http://nagoya.apache.org/dist/httpd/binaries/win32/#xpbug) that SP1 is required, but they dont say why.

[Mr. X]

ok, apache is up and running, but Im getting the same error about putting LoadModule php4_module c:/network/php/sapi/php4apache2.dll in the httpd.conf file, and Apache will not start. If I remove it, it will start. I've read this entire thread to see if there were any fixes and there arent. Is the php4apache2.dll file causing trouble? I cant go further on this tutorial until Apache starts with this file loaded.

[Mr. X]

Sweet, I have vB working right now. The php4ts.dll needed to be replaced with the latest snapshot for php4apache2.dll to work for some reason. Still alien to me, but it worked. I even installed phpmyadmin 2.3.3 RC1. I feel more l33t today. :)

Thanks for the tutorial. Finally I can test out things on my own PC before butchering my real forums :)

[Mr. X]

Damn. Well apparently something went seriously fubar, and when I rebooted, mysql would not start. I spent over an hour reading why, and gave up, reinstalled mysql cleanly. Made sure it worked, then rebooted, came back and its running again. Apparently it has a problem with starting from a service. Hope it doesnt come back because Im sure as hell not reinstalling it everytime it fails.

Also, how come the Create Database option doesnt show up? I just get Flush this and that, but no Create Database option. I had it before I reinstalled but now its gone. Im using the alpha of MySQLGUI which is pretty cool and I can create stuff fine there, but not in in the program that comes with the installation.

Oh yeah, why is my General Options page in the adminCP freaking out? It keeps refreshing like crazy. Wtf?

[TECK]

Create it manually. They changed some of the options. To do this, simply go to your /mysql/data and create there a folder named for example "vbulletin". That will be your database.
I also noticed that in some systems, apache will not load properly the php4apache2.dll module. The solve this issue, simply install either 2.0.36 or any 1.xx version. That will solve your compatibility problem.

[Mr. X]

Everything is up and running, and after several reboots, mysql starts fine. The winmysqladmin-nt program isnt a big deal. I installed phpmyadmin and the mysql control panel alpha so creating databases is no prob. Also I sovled my problem with php by installing a new version of php4ts.dll.

I installed vb and it runs great, the only problem Im having is when I click on General Options, and it refreshes crazy, going in a loop for some reason. Any ideas?

[TECK]

What apache version you used? And from what PHP version you grabbed the php4ts.dll file?
Attach it here, zipped, so I can upload it onto my site and link it onto the first post. :)

[Mr. X]

I setup Apache 2.0.43, MySQL 4.0.5 Beta and PHP 4.2.3. The php4ts.dll file was from some snapshot, but I cant remember which. I stumbled across it reading a plethora of mailing list posts about the bug. I'll try to track it down but in the mean time I've attached the file. As soon as I replaced this file, php4apache2.dll was able to load fine.

Still having issues though with AdminCP.

[Mike Gaidin]

Ok, I'm trying to do step 3 under the mysql installation...

03. Go to tab Databases. Right click on the name of your computer and select 'Create Database':
Database Name: vbulletin

Click on 'Create the Database' and close the window.

The only problem is that when I right click on the name of my computer it brings up a menu that says...

Flush Hosts
Flush Logs
Flush Tables
Flush Threads


What do I do? Or what am I doing wrong?

[TECK]

Did you read 3-4posts above?

[Mr. X]

I still havent been able to fix it, but it doesnt matter since I use phpmyadmin or the MySQL Control Panel alpha program to do stuff in.

But Im still not getting any help regarding the endless refreshing of the General Options page in Admin CP, not even on vbulletin.com's troubleshooting area.

[TECK]

Contact vBulletin Team for this. Is nothing related to your server.
Open a support ticket, don't just post onto the forums.

[Mr. X]

I sent in a TT a few days ago, and they said just to downgraded to Apache 1.3x. They did suggest I not use the latest mySQL beta, but since I've had no problems with it I kept it.

Downgrading to 1.3x wasnt as hard as I thought. A tad different here and there, but I get no problems at all with vB that I described above, so all I can say is that installing Apache 1.3 is much less of a headache than making 2.x and PHP 4 (Im using 4.2.3 btw) work nicely together.

[TORON]

Same problem here. Been at it for 5 hours a day for the last 3 days. No problem here between the screen and the seat.

If you follow the instructions that where provided in this thread it will not work.

Have the same problem with Apache not restarting.

Time to remove this thread and start over.
The information I'm sure was put here with good intention, no doubt about that but the fact remains is it is WRONG as it does not work with php4apache2.dll

15 pages of replies and still now solution.

Remove the thread and start over agian.

Anyone else want to give it a kick and post some real solution to this problem please do.

This thread is 5 month old and I'm sure countless others have tried it with the same results. No fix in 5 months .. remove the thread it does not help anyone.

[Mr. X]

Well I think this thread does help, I think the only real issue is the problem with php4apache2.dll which isnt Teck's fault, though with so many having either no luck with it, or it works fine, I just went with Apache 1.3 and all works well and dandy for me so thats all I can suggest.

[TECK]

Originally posted by TORON
Same problem here. Been at it for 5 hours a day for the last 3 days. No problem here between the screen and the seat.


If you follow the instructions that where provided in this thread it will not work.

Have the same problem with Apache not restarting.

Time to remove this thread and start over.
The information I'm sure was put here with good intention, no doubt about that but the fact remains is it is WRONG as it does not work with php4apache2.dll

15 pages of replies and still now solution.

Remove the thread and start over agian.

Anyone else want to give it a kick and post some real solution to this problem please do.

This thread is 5 month old and I'm sure countless others have tried it with the same results. No fix in 5 months .. remove the thread it does not help anyone.
Please... act mature, not like a 10years old person. You don't even bother to read the first post. The fix is there.

[FulsionV8]

I have a problem when doing this..when I open php files, it tries to save/download them, not open the file..what's wrong?

[eiSecure]

Did you install PHP?

[FulsionV8]

yep

[Mystic Gohan]

I guess I have a big problem from what everyone tells me that have tryed to help it cant be done from Win 98 and I also cant use PHPTriad so I cant do this :( maybe when I can convince my rents to upgrade the puter will i be able to do it.

[Dean C]

Ok TECK i didn't use this tutorial in the end because we could never get PHP functioning right could we :p

But just as a tip you could put in the starter thread..

If anyone gets this error when they goto http://localhost :


Server Error
The following error occurred:
An invalid URL was detected. The appliance cannot serve the request as entered. (BAD_URL)


--------------------------------------------------------------------------------
Please contact the administrator.


If you do get this error it should only be in IE so goto Tools > Internet Options..

In the tab select "Connections"

Then click "Settings" on your default connection (below the remove button)

Then untick the "Use a proxy server........" box..

That should solve that problem

- miSt

[DrkFusion]

I forgot thanks Mist for reminding me.

Would anyone know how to make Jana Server 2 work on WIN32 server with php, cgi, and mysql.

Thanks

[TECK]

You should be able to do it also in win98. See the php install.txt file on how to do it.
Originally posted by Mystic Gohan
I guess I have a big problem from what everyone tells me that have tryed to help it cant be done from Win 98 and I also cant use PHPTriad so I cant do this :( maybe when I can convince my rents to upgrade the puter will i be able to do it.

[Dean C]

I'm using phpdev... it's piss easy to install and everything works with a click of a button :p

www.firepages.com

[Chris M]

Bah:(

I get that error, but can't untick the box - Its either that error or No Internet:(

Satan

[Dean C]

What error do you get satan?

[Dean C]

Edit... if you get this error:


Server Error
The following error occurred:
An invalid URL was detected. The appliance cannot serve the request as entered. (BAD_URL)


--------------------------------------------------------------------------------
Please contact the administrator.


If you do get this error it should only be in IE so goto Tools > Internet Options..

In the tab select "Connections"

Then click "Settings" on your default connection (below the remove button)

Then add "http://localhost" to the list of exceptions..

That's the best way to do it..

- miSt

[Kars10]

Thank you so much Teck!!!
Works like a charm... ;)
My Rating 5/5

[JakeC]

Ok, I know this is going to be great once I get it going! I loaded PHP and I followed the directions to the T (as far as I can tell). Next I loaded Apache and at first it would not restart. I followed the instructions about replacing the file and now Apache is humming along. To see where I was at I created the index.php file you mentioned in order to check if apache and PHP are talking. I put it in htdocs and went to my browser and entered "http://localhost" . At this point I get the standard Apache confirmation page that tells me all is well with Apache. I then tried "http://localhost/index.php" even though I know I shouldn't have to and I get a 404 document not found error. I went back through all of the procedures again and I'm getting the same result. Here are the stats:

Windows XP SP1
Apache file used: apache_2.0.43-win32-x86-no_ssl
PHP file used: php-4.3.0-Win32

Any advice for a frustrated newbie :dead: ? Thanks in advance.

Jake C

[JakeC]

Never mind. I got it :banana: . The bad news is I?m an idiot. Here is what I had pointing to my doc root:
doc_root = "c:\network\php\apache2\htdocs
I must have looked at it 5 times. :lick: . Thanks for the great tut.

JakeC

[Dr Shark]

alright, i'm tired, and have no idea what the problem is.lol

i keep getting this error on the vbulletin install file

Warning: unlink() [function.unlink]: Permission denied in C:\Network\Apache2\htdocs\test\admin\install.php on line 305

Attempting to attach to database...

Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'localhost' (10061) in C:\Network\Apache2\htdocs\test\admin\db_mysql.php on line 38

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\Network\Apache2\htdocs\test\admin\db_mysql.php on line 47

The database has failed to connect because you do not have permission to connect to the server. Please go back to the last step and ensure that you have entered all your login details correctly.

any idea how to fix this, and do not say read the post again, i only looked at in 1,000x time's. :alien: lol

[Kars10]

Originally posted by Dr Shark
alright, i'm tired, and have no idea what the problem is.lol

i keep getting this error on the vbulletin install file

Warning: unlink() [function.unlink]: Permission denied in C:\Network\Apache2\htdocs\test\admin\install.php on line 305

Attempting to attach to database...


Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'localhost' (10061) in C:\Network\Apache2\htdocs\test\admin\db_mysql.php on line 38

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\Network\Apache2\htdocs\test\admin\db_mysql.php on line 47

The database has failed to connect because you do not have permission to connect to the server. Please go back to the last step and ensure that you have entered all your login details correctly.

any idea how to fix this, and do not say read the post again, i only looked at in 1,000x time's. :alien: lol

Just restart the Apache and your MYSql and it might work.
I get the same error as you and i did a restart and all went fine! ;)

[Dr Shark]

alright, i'm still haveing problem's, and now mysql won't even start, so i'm going to unintall php, mysql, apace, then install a old apache, php 4.30, and mysql.

Good luck to me. :lick:

[Dean C]

If all else fails try www.firepages.com

It worked for me in a matter of 30 seconds :)

- miSt

[JakeC]

I think you might mean firepages.org (http://www.firepages.org)

JakeC

[JakeC]

Thanks for a great tutorial Tech. Once I fixed my typos everything has worked perfectly. The only thing that I'm not to sure about is the fact that my firewall must be set to let apache access the internet for it to work. The page is denied if it is not set to act as a server and access the net. I'm using Zone alarm. I'm nervous about outside individuals accessing my localhost site. Any thoughts? Thanks again.

JakeC

[Jadelit]

No one can access your website because its on a localhost (127.0.0.1).

Unless you configured your Apache config to allow users to view it via your IP address, you should be fine allowing Apache access.

[JakeC]

Great, Thanks.

JakeC

[Mr. X]

Originally posted by JakeC
I think you might mean firepages.org (http://www.firepages.org)

JakeC


PHPDev is HERE (http://www.firepages.com.au/dev4.htm)

.com.au