Tutorial: How to run vBulletin onto your PC

[JakeC]

Ah! firepages.com (http://www.firepages.com) by it's self was getting me to some racing page. Thanks for clearing that up.

JakeC

[JAYEMULE]

Thanks for the tutorials indeed ! Great idea and very thoughtful of you.
May I ask something that may sound dumb ? I am just now dipping my toes into the water here and I wanted to try this out. However, when I went to the MYSQL page I got confused. I could not find a file called mysql windows installation. Yes I know, go ahead and chuckle and roll your eyes. But I want to learn and to learn I have to ask right ? I have had a few hacks installed on my board by other and now want to learn how myself. So if you could point me in the right direction, like which mysql is it exactly, I will toddle on down this hacked trail you folks have forged.

Thanks Kindly,
JAYEMULE

[JakeC]

Thanks for the tutorials indeed ! Great idea and very thoughtful of you.
May I ask something that may sound dumb ? I am just now dipping my toes into the water here and I wanted to try this out. However, when I went to the MYSQL page I got confused. I could not find a file called mysql windows installation. Yes I know, go ahead and chuckle and roll your eyes. But I want to learn and to learn I have to ask right ? I have had a few hacks installed on my board by other and now want to learn how myself. So if you could point me in the right direction, like which mysql is it exactly, I will toddle on down this hacked trail you folks have forged.

Thanks Kindly,
JAYEMULE

It's a little ways down the page past the linux box. You will see this inside:

"MySQL 3.23.54 Windows 95/98/NT/2000/XP (13.2M) Download"

This is the one I used anyway. Hope it helps.

JakeC

[JAYEMULE]

Thank you , I was able to find and download the file.
Now going to get my feet wet :)
Wish me luck and maybe keep a life ring handy ;)

JAYEMULE

[Serge]

I'm still having problems with trying to get into my admin CP and entering my username and password and it just showing me the login page again and it keeps going around in a loop like that forever.

I'm using the cookie workaround and put it frist like someone said you should do. I also tried it at the end and still no good. The version I'm using are as follows:

Apache: 2.0.43
PHP: 4.3.0
MySQL: 3.23.49

And I'm running on Windows XP Home.

Could anyone help please?

[Jadelit]

delete all of your cookies and clear your cache

[Serge]

Well I did that and it still sends me into the loop

[Jadelit]

Are you logging in with the right user info?

double check.

[Serge]

Yes I am. It might be happening because I tried transfering my database files to my PC SQL database and then something was correpted. So I will just go back to a fresh install.

[infuzeon]

i did everything in the instructions but apache refuses to start.. and when i go to http://localhost i just get a page cannot be displayed.. im running windows xp.. anyone help?

[TECK]

Quote from the first post:
"There have been some problems with the php4ts.dll library. If you cannot restart your Apache server, download [this file] and replace your current one."

[infuzeon]

i just did that, still doesnt start up.. if i try to start it up from the Service Monitor it says "The requested operatoin failed!".. i also tried restarting but doenst work either.. any ideas?

[Bitsys]

Originally posted by infuzeon
i just did that, still doesnt start up.. if i try to start it up from the Service Monitor it says "The requested operatoin failed!".. i also tried restarting but doenst work either.. any ideas?

I was having the same problem a while ago. I downloaded the fixed file from the link in the first post and it still didn't work. I went to the PHP bug thread at http://bugs.php.net/bug.php?id=18129.

I read the whole thread and finally tried the file at http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

That file seemed identical to the one linked in the first post, but I tried it anyway and it worked. You can give it a shot, if nothing else.

[infuzeon]

i just gave that a shot.. doesnt seem to work for me though.. maybe its not that particular file thats screwing it up? is there something else that can mess it up?

[JakeC]

Ok, I got it to work fine and restored the database from my online vB to my localhost. It worked perfectly except, when I try to login as a user to the localhost vB it takes me directly to my online vB instead of my localhost. I turned off my internet connection and tried to log in again and it times out trying to access my online vb. Any ideas? Thanks.

JakeC

[TECK]

Is because you have to set the right options onto your localhost vBulletin options.
If you look at your settings you will see that the bburl is your online site, not the localhost one.
When you updated your database, it changed those settings to your online ones.

[JakeC]

Ok, I changed the vbulletin options to what you see below. It is still taking me to the www vB instead of the localhost vB when I login as a user. Thanks in advance.

Jake

[JakeC]

Never mind I got it. I had been doing some fooling around with my login prompt and to make a long story short, I had the http:/www.homebuiltairplanes.com/forums/member.php hard coded into the form code instead of /forums/member.php. Anyway, I got it. It makes me wonder what else I did that to. Thanks.

JakeC

[Jadelit]

what configuration would I have to do to make this accessable from the internet via IP address..?

[neocorteqz]

Originally posted by Jadelit
what configuration would I have to do to make this accessable from the internet via IP address..?

you have to configure apache somehow... I have managed to get it working for one person... but when I give the address out to another person it doesn't work for him.. coincedentally, the person it works for uses the same ISP and lives not even 2 minutes away from me. but it doesn't work for anyone else. but anyways.....


if your ISP allows the use of port 80 then cool, if not you have to set it to another port, the next typical port is 8080, i also set listen to my ip address,

Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, in addition to the default. See also the <VirtualHost>
# directive.


all in the httpd.conf file.

Of course this could be dumb luck seeing as i have no knowledge of apache..Well cept fot the port.. I know that much :p

[Jadelit]

Yup setting it to your.ip.add.ress:8080 works

How would I go about installing perl?

[TECK]

Originally posted by Jadelit
How would I go about installing perl?
Please open a new thread related to PERL.

[Nairb2003]

ummmm.. nakkid, i added you to my msn hoping you could help me out...

It's not working... I tried 3 times, following all the instructions...

i'm on win 98... any suggestions?

when i try to go to http://localhost/
i get HTTP 500 Internal server error....

PLEASE HELP!

[TECK]

Quote from the first post:
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.

[Nairb2003]

damn... guess I should reinstall XP.... :(

Thanks anyways

[drives fast]

well...I followed the first post to the tee and I installed apache, mysql and php successfully as I can figger

here is what is happening to me.....when I browse to http://localhost/forum/admin/install.php...the page comes up (as did the php test page) but when I click on the "Click here to continue with the next step -->" link it flashes and the page does not change.

any idea what I have done wrong?

I tried lots of things I saw posted throughout this thread but none were related to my problem and I am back to exactly where I was.

suggestions?

BTW
Windoze2000 pro
PHP Version 4.3.0-dev
mysql 3.23.55
apache 2.0.43
IIS not installed (never has been)

[drives fast]

Here is what I did....

I manually created all the tables and inserted the data but like others I have seen here...when I go to login to my control panel...it just flashes and is back to the login screen again. I have read every post in here and even tried everything suggested with no success.

I was successful in using phpmyadmin on my local machine to do everything so it makes no sense why the site won't function.

I noticed that tere are php installers and this thread mentions "installing php" but the first post says nothing about an installation...only put some file here and edit them.

If php wans't working....why am I able to view pages?

What am I/we doing wrong?

I have un-installed and re-installed everything as well.

[drives fast]

is there no more help being offered in this thread?

It would seem that cookies are my problem but the cookie workaround thing doesn't work for me.

is there any help for me on this.....please?

[drives fast]

hint taken

thanks anyway

[Logik]

Thank God for this. I love this. Not only run vB locally. But also test my scripts/hacks before i upload them or release. :)

[JakeC]

Got a question for you. When I try to restore the database I get this error:ERROR 1050 at line 11: Table 'access' already exists.
Any ideas what I am doing wrong? I am having my hosting company make a backup nightly and it is in the .sql.gz format. I'm using WinZip to extract it and it appears to extract it fine. It ends up as a text document with a .sql extension. My username and password are correct.

Jake

[mr e]

just to post this, if you have norton installed TURN IT OFF or apache wont work right, took me all day to figure this out

[Nairb2003]

I get this message:

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

The installation went well, except for when I was editing the httpd conf file for apache, I couldnt find the first step....
So I added it under all the other "LoadModules"

[TECK]

I just did the full install few days ago. Followed the exact same steps listed here.
I have no idea why is not working for some people because for me works always... never had a prob.

[formerEVO?]

i had no problems except for ONE,

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

I couldnt follow that step...because "DirectoryIndex index.html index.html.var" wasnt in my config file. And i'm guessing that's why i dont get directed to index.php when i go to my forums directory or my phpMyAdmin directory. How can i fix that?

[Corrupter]

Superb job mate...

Obviously we also need to be able to send emails from the board... is that something that is easily setup?

Can anyone help with that?

[Corrupter]

^^

[Mystic Gohan]

I have gotten the whole thing to pretty much work on my Win98 with PHPTriad because the other way wont work for me. I get everything to work but this error when I try to install vBulletin Warning: Unlink failed (No such file or directory) in c:\apache\htdocs\admin\install.php on line 305

It does let me install it and all but yea I wanna know what is up with that

[Mystic Gohan]

I have it installed now and it all works fine but I still get that error in the install.php?step2 when you connect to the database.

Also is there anyway to get shtml pages to show up right? That means is there a way to enable ssi?

[TECK]

<a href="http://www.teckwizards.com/forum/showthread.php?s=&threadid=823" target="_blank">http://www.teckwizards.com/forum/sho...=&threadid=823</a>

[Units]

unable to contact HOME error

[Skyrender]

The php zip file doesn't work when I try to download it can somebody upload to their server and give it to me?

[Jadelit]

TECk, you are going to update your instructions for mysql4?

[Jadelit]

TECk, you are going to update your instructions for mysql4?

[Jadelit]

TECk, you are going to update your instructions for mysql4?

[sonic3d]

it was working fine yesterday but know whne i log into the admin cp i get this error/warning.

Warning: Cannot modify header information - headers already sent by (output started at C:\Network\Apache2\htdocs\forum\admin\index.php:1) in C:\Network\Apache2\htdocs\forum\admin\functions.ph p on line 1767

i looked into the code and it something about cookies. i aleady put the cookie code thas in the first post.

ne ideas.

l8er
sonic

[Dean C]

There is a tutorial about the error made by Logician in this forum - take a look at it ;)

- miSt

[leitel]

Succeeded in a fresh install. My FIRST!

Now I need to copy everything off current live site over to my localhost. I'm used to using MSFrontpage. Is it possible to use frontpage extensions on an apache server? Or do I need to use a FTP package?

Also, the mySQL database files, do I just download them to my local machine and run?

Once I have the SAME site running locally (with the already installed hacks) I can continue from there.

Thanks! :)

[leitel]

Everything is now loaded from live site. I go to run the site on my localhost and I get:

Warning: mysql_pconnect(): Access denied for user: 'root@localhost' (Using password: YES) in C:\Network\Apache2\htdocs\vbforums\admin\db_mysql. php on line 38

I've tried the user and pass from live site, local and none with same results. Where should I look?

[TECK]

Search my web site for an answer related to this problem, I posted this there, in MySQL forum.

[leitel]

I searched your site using a variety of words used in the error, etc and couldn't find anything. :(

[NyCwill]

i cant access my vb...it said page not found.... only is by goin through "C:\Network\Apache2\htdocs\forums\" ... but when i go there dreamweaver poped up

[cirisme]

You need to go through a webbrowser with an HTTP address.

So, for instance, if your computer name is "foo", you would need to goto http://foo/forum/. You can set the computer name through Windows.

[NyCwill]

it still dun work

[dstruct2k]

See, I've taken this hack one step farther, and am using this configuration as my production environment. The only problem I expect to have once my forum grows is bandwidth.... But I'm sure I can compensate somehow.

Oh, and I did all this before ever coming to vbulletin.org. Thanks for showing others how to do this amazingly simple thing and make it work properly!

[Black Vivi]

it's not working for me, i installed apache, mysql and php.

Ill post the things it says:

1. When I open WinMySQL Admin

[Black Vivi]

it says about phpDev, but I don't have it installed on my HD...

2. When I open up apache console thingy...

[Black Vivi]

nevermind, I got it working now

[Black Vivi]

nuther problem
and someone, plz reply this time...

whenever i start Apache, it comes up with this:

Socket operation on non-socket: make no listing sockets available, shutting down
Unable to open logs

[kdog316]

on this step

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

do i create the vbulletin folder in C:\Network\MYSQL\bin

or

C:\Network\MySQL\bin\data

because there is no data folder in the bin folder

[Black Vivi]

C:\Network\MySQL\data

[Marzas]

i get this error

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

[Marzas]

I fixed the php error for everyone.
I just forgot to reset the apache, and when i did it, it worked.
I just right click on it in the taskbar on the bottom right handcorner and then click reset for the people who dont know.

hope this solves some problems.

cheerz
marzas

[sonic3d]

how do i make the forum online?

l8er
sonic

[bigk]

May I copy this tutorial?

[TECK]

No.

[S.Shady]

05-23-03 at 09:38 AM sonic3d said this in Post #314 (https://vborg.vbsupport.ru/showthread.php?postid=398931#post398931)
how do i make the forum online?

l8er
sonic


put your ip were localhost is. it will eb online but dont run a copy of vb off your comp (online) unless its legal :)

[S.Shady]

haha i finally got the damned thing to install perfect. Thanks teck i didnt like phpdev. anyway plus im going to classes nextyear in highschool were we will learn computer networking. one of the topics the the pamflit was learning how to set up a localhost.

this will help me as ive learned how to do it now after about 1 1/2 days getting ++++ed at the mysql. btw you sould link to the latest stable release the one its linked to now was giving me alot of trouble for some reaons i tried the latest stable and worked 1st time.

kids dont try to install this under the influence of marijuana

[Salazar]

Hello!

I did exactly as you described, but I have a problem:

It worked until step 2 of the installation script.

I used the following:

server: localhost
hostname: localhost
username: root
password: password
db-name: vbulletin (I created this database with phpmyadmin)

BUT, it says:

Warning: main(./db_localhost.php): failed to open stream: No such file or directory in C:\Network\Apache2\htdocs\forum\admin\install.php on line 334

Warning: main(): Failed opening './db_localhost.php' for inclusion (include_path='.;c:\php4\pear') in C:\Network\Apache2\htdocs\forum\admin\install.php on line 334

Fatal error: Cannot instantiate non-existent class: db_sql_vb in C:\Network\Apache2\htdocs\forum\admin\install.php on line 336

What have I done wrong?

[Marzas]

I keep getting this error, i have tried to install/re-install
i followed all the instuction there, mysql seems to be started, php is working. I have Apache 2.0.4 and mysql 4.0.13 and php 4.3.2

this is the error

Warning: mysql_pconnect(): Access denied for user: 'root@localhost' (Using password: YES) in C:\Network\Apache2\htdocs\forum\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\forum\admin\db_mysql.php on line 47

no matter what i do, change database, new password, i even thought it to be my firewall, i took it down, restarted a 100 times, no matter what it doesnt work.

please i need help

cheerz

marzas

[Marzas]

I keep getting this error, i have tried to install/re-install
i followed all the instuction there, mysql seems to be started, php is working. I have Apache 2.0.4 and mysql 4.0.13 and php 4.3.2

this is the error

Warning: mysql_pconnect(): Access denied for user: 'root@localhost' (Using password: YES) in C:\Network\Apache2\htdocs\forum\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\forum\admin\db_mysql.php on line 47

no matter what i do, change database, new password, i even thought it to be my firewall, i took it down, restarted a 100 times, no matter what it doesnt work.

please i need help

cheerz

marzas

[Marzas]

I keep getting this error, i have tried to install/re-install
i followed all the instuction there, mysql seems to be started, php is working. I have Apache 2.0.4 and mysql 4.0.13 and php 4.3.2

this is the error

Warning: mysql_pconnect(): Access denied for user: 'root@localhost' (Using password: YES) in C:\Network\Apache2\htdocs\forum\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\forum\admin\db_mysql.php on line 47

no matter what i do, change database, new password, i even thought it to be my firewall, i took it down, restarted a 100 times, no matter what it doesnt work.

please i need help

cheerz

marzas

[Dean C]

Look through the last few pages and there are easier alternatives with no such errors :) ^^

Phpdev is what i'm referring to

- miSt

[TWTCommish]

I don't suppose anyone has a PHPTriad-style solution to installing the GD image-manipulation extensions?

[Kane Da Don]

06-23-03 at 09:26 PM Salazar said this in Post #319 (https://vborg.vbsupport.ru/showthread.php?postid=412019#post412019)
Hello!

I did exactly as you described, but I have a problem:

It worked until step 2 of the installation script.

I used the following:

server: localhost
hostname: localhost
username: root
password: password
db-name: vbulletin (I created this database with phpmyadmin)

BUT, it says:



What have I done wrong?
just giving a guess here because i had that problem some wat like that to but once i installed php4 it worked fine so it may but be that you dont have php4 installed on your localhost

[mitomcua]

Hi guys,

If i connect to my testboard at http://localhost/forum/index.php everything works Great !

However if i use my dns http://mitomcua.myftp.org/forum/index.php everything works fine except for the : Option (Vbulletin options) in the Admin cp, when i click on it and i can see the screen flashing very quick but it end up "the page can not be displayed "?
I dont know what i did wrong....




Can some one help me to look into this?

Thanks,
M

[mitomcua]

Anyone? I cant figure this out? please help

Thanks,
M

[CBGrafix]

my MySQL doesn't work ?_?'

I have tried a lot to get it to work, followed the instructions exactly.

I used a mysql test file to check it.

here is the error


Fatal error: Call to undefined function: mysql_connect() in C:\Network\Apache2\htdocs\mysqltest.php on line 9


the coding i used



<html>
<head>
<title>MySQL Test</title>
</head>
<body>
<h2>

<?php
$connection = mysql_connect("localhost","root","password")
or die("Sorry - unable to connect to to MySQL");
echo("Congratualations - you connected to MySQL");
?>

</h2>
</body>
</html>

[CBGrafix]

my MySQL doesn't work ?_?'

I have tried a lot to get it to work, followed the instructions exactly.

I used a mysql test file to check it.

here is the error


Fatal error: Call to undefined function: mysql_connect() in C:\Network\Apache2\htdocs\mysqltest.php on line 9


the coding i used



<html>
<head>
<title>MySQL Test</title>
</head>
<body>
<h2>

<?php
$connection = mysql_connect("localhost","root","password")
or die("Sorry - unable to connect to to MySQL");
echo("Congratualations - you connected to MySQL");
?>

</h2>
</body>
</html>

[assassingod]

Try this;


<?php
$user = "root";
$connection = mysql_connect( "localhost", $user, "password" );
if($connection) {
$msg="Connected to MySQL, $user";
} else {
$msg="Failed";
}
?>
<html>
<head>
<title>MySQL Test</title>
</head>
<body>
<h2>

<?php
echo("$msg");
?>
</h2>
</body>
</html>

[CBGrafix]

nope, that didn't work =/
seems like it doesn't know mysql is installed..i'll redo it again, see what happens then.

[assassingod]

Yeah, I don't think you've installed MySQL properly 'cos it worked for me.

[CBGrafix]

i have it working, in the end i used phpDev5 :)

[FilmoreSlim]

Awesome post .. very insiteful, thanks so much. It works without a hitch :nervous:

[Hialls]

great idea this, although can i legally run a test server on my pc, and 1 on my website..

[Hialls]

great idea this, although can i legally run a test server on my pc, and 1 on my website..

[xQuEeNzNaZcHox]

Attempting to attach to database...

Warning: mysql_pconnect(): Access denied for user: 'root@localhost' (Using password: YES) in C:\Network\Apache2\htdocs\forum\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\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.

Click to go to the vBulletin website

[groovesalad]

I get this:

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

When I go here:

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

Any ideas?

[hagan]

I have the prob that when calling my index.php it will not show up in the explorer.Instead of this i get the directoryview and a popup for downloading the php file.

Anyone an idea ?

[hagan]

Restarted Apache and works now.No prob anymore.

[assassingod]

08-28-03 at 04:26 PM xQuEeNzNaZcHox said this in Post #337 (https://vborg.vbsupport.ru/showthread.php?postid=429254#post429254)
Attempting to attach to database...


Warning: mysql_pconnect(): Access denied for user: 'root@localhost' (Using password: YES) in C:\Network\Apache2\htdocs\forum\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\forum\admin\db_mysql.php on line 47


Try not using a password.

[assassingod]

Yesterday at 07:43 PM groovesalad said this in Post #338 (https://vborg.vbsupport.ru/showthread.php?postid=429768#post429768)
I get this:

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

When I go here:

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

Any ideas?

You havent installed PHP properly, try re-installing it.

[hagan]

I cant connect to mysql on localhost.
i tried it with phpmyadmin and a php file with a mscql connect script.
Mysql says access denied.

But username and password are correct in both, the php script and the PHPmyadmin config file.

Anyone an idea ?

[groovesalad]

Today at 10:55 AM assassingod said this in Post #342 (https://vborg.vbsupport.ru/showthread.php?postid=429962#post429962)
You havent installed PHP properly, try re-installing it.

I've done all of this:


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.


is there something else I need to be doing? I never actually double clicked an install.exe on PHP, do I have do download the Windows Installer and actually install it? Or does unzipping it to a certain folder, moving and copying a few files in my Windows directory do the trick? If so, PHP still isn't working for me.

[assassingod]

I never used TECKs guide so I can't help any further. You may have to configure apache to work with PHP.

[blakkboy]

sry for not screening all pages for this but....

could this be done on windows me??????

[Dean C]

sry for not screening all pages for this but....

could this be done on windows me??????
I would have though so yes :)

Side note: I installed apache2 and php4 on xp pro about a week ago without using this tutorial. It's pretty easy :)

[blakkboy]

damn i cant even find my system root directory

i have windows me and it should be C:/WINDOWS but i cant find it, can someone help me out or point me to help

[Dean C]

Go to Start > Run and type in:

%SYSTEMROOT%

It should take you there :)

[blakkboy]

nope it didnt do that for me.. im running windows me

[blakkboy]

06. Restart Apache Server.

ok i got all this figured out... except how to restart the server...??? can someone tell me how to restart the Apache server

[SonicB]

I have everything installed and working . Only problem im having is connecting to the VB data base it keeps giving me

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 ideas ?

[SonicB]

Fixed :)

[blakkboy]

i still need to know how to restart the apache server in step 6

[blakkboy]

can someone with some time on there hands pm me and drop an aim so i can contact you so that someone can help me step by step installing this

[blakkboy]

how do i fill in these

Database server type: ????????????

Database server hostname / IP address: localhost (?)

Database username: my username

Database password: my password

Database name: vbulletin

Technical email: my email

i dont know the server type

[Dean C]

As you would with your normal site. Just changing the username,pass and database name and technical email :) ^^

[blakkboy]

what would be the server type though...... MySQL???

[blakkboy]

whats this mean

Warning: Unlink failed (No such file or directory) in c:\apache\htdocs\forum\admin\install.php on line 305

Attempting to attach to database...

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

Warning: Supplied argument is not a valid MySQL-Link resource in c:\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.

Click to go to the vBulletin website

[Dean C]

That means you have the wrong password for mysql :)

But you don't need a password on root btw unless you manually set one using a GRANT query :)

[blakkboy]

so i shouldnt put anything for the password???? damn im getting confused

[Azhrialilu]

I didn't put a password and it works great :) if that's any help at all LOL

[Dean C]

so i shouldnt put anything for the password???? damn im getting confused
Yes :)

[blakkboy]

i get this now when chossing the updating config.php on the install page

Warning: Unlink failed (No such file or directory) in c:\apache\htdocs\forum\admin\install.php on line 305

Attempting to attach to database...

Warning: Can't connect to MySQL server on 'localhost' (10061) in c:\apache\htdocs\forum\admin\db_mysql.php on line 32

Warning: Supplied argument is not a valid MySQL-Link resource in c:\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.

Click to go to the vBulletin website

[Spyke1]

i prefer using phpdev5

http://www.firepages.com.au/

Download, Install, Start Apache And Mysql The Upload The Vbulletin Fies, Use PHP My Admin To Make A Database And Install.

its easier, just 1 download and 1 install

[Dean C]

I used to use phpdev but it's no longer updated. They use old versions of php, mysql and apache. It's far better to install manually :)

[chrisvonc]

This was a GREAT thread, thank you!

[kill_emma]

alright, here's my problem.

i used this thread to dev my php site, and so far it's working, i wrote a news script, and that all works fine. until i noticed one problem.


<?php
if ($page != "")
{
include ("$page.html");
}
else
{
include("news/news.php");
}
?>


if you know anything about php, you know what that does. my problem is, when i go to index.php?page=stuff, it's still giving me news/news.php, no change. at all.

so to troubleshoot this problem, i installed apache2triad. the code works. i tryed reinstalling the localhost using this thread. no change, the problem is still there.

can someone help?

[Dean C]

You probably have register globals turned off. You can't use $action = page to create a query string. You need to use $_REQUEST['page'] == 'whatever'

- miSt

[kill_emma]

ok, so now i'm using:


<?php
if ($_REQUEST['page'] != "")
{
include ("$page");
}
else
{
include("news/news.php");
}
?>


this is an improvment. now the page changes when i go to index.php?page=stuff
now my only problem is that i get this error:

Warning: main(): Failed opening '' for inclusion (include_path='.;c:\php4\pear') in C:\network\Apache2\htdocs\index.php on line 39


line 39 is
include ("$page");

[assassingod]

ok, so now i'm using:


<?php
if ($_REQUEST['page'] != "")
{
include ("$page");
}
else
{
include("news/news.php");
}
?>


this is an improvment. now the page changes when i go to index.php?page=stuff
now my only problem is that i get this error:


line 39 is
include ("$page");
Try using single quotes rather than double

[Dean C]

No you can't use single quotes. It has to be double quotes. You don't have have the $page variable set. That's why it's not working buddy ;)

[kill_emma]

thanks :)

eDiT:
hey bastard :D

[assassingod]

No you can't use single quotes. It has to be double quotes. You don't have have the $page variable set. That's why it's not working buddy ;)
Single quotes have worked for me :shrug:

@kill_emma: heya prick:p ;)

[Dean C]

Cut that out both of you :)

Steve you can't single quote a variabe inside a function. Single quotes = complete parsing as text. Double quotes = parsing text + variables :)

[assassingod]

Ah right, I didn't see that variable in there.

[kill_emma]

hah, did i not tell you such things bastard?

[assassingod]

Yead m, but i dints likook at the code mcuhn

[Dean C]

hah, did i not tell you such things bastard?
Please refrain from making such rude remarks in future towards any members here at vBulletin.org

[kill_emma]

sorry, lol. it wasnt meant as a rude remark, its our uninomial nomenclature, or private nicknames if you will. i change my name alot and it's our way of knowing who we are ;)

[assassingod]

YEAH, Its a nick anme, mist, chilolll out man

[kill_emma]

-_- dude, dont post uness your sober, it makes you look really stupid when you dont.

[assassingod]

don tlel e hjow to ack m
m

[Denko]

Thanks, I'm on xp - followed your directions and it all worked perfectly despite knowing zero about Apache, MySQL and Php.

[TheLab]

Forget the post.. it was an error on my pc..

[Exero]

you could do this but then you can always get a server with PHP, MySQL& perl preinstalled
http://bandit.myftp.org/gts
its called Fireserv...i use it...

[kill_emma]

i think it's pretty much useless to keep mentioning software that will do it for you. this thread is to tell users how, and provide support if it doesnt work.

[TECK]

Thanks Emma. :)

[Dean C]

Btw Floren - remember sometime ago we trivialised on msn on how to get this working on my machine. It was to do with a proxy in internet explorer and my firewall. I actually installed apache2, php + mysql on my laptop the other week :)

[CarolinaKid]

THis might be the wrong place for this but we will see i followed you instructions and I think got everything setup right with apache, php, and Mysql. But then when I try to install forum i get errors

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\Network\Apache2\htdocs\forum\includes\db_mysql. php on line 333

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\Network\Apache2\htdocs\forum\includes\db_mysql. php on line 334

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\Network\Apache2\htdocs\forum\includes\db_mysql. php on line 133

I pretty sure i got config file set up right

$servername = '192.168.1.100'; <<< also tried local host
$dbusername = 'root';
$dbpassword = 'password';
$dbname = 'vbulletin';

Now the ? is what am i doing wrong

[assassingod]

For the servername try 127.0.0.1 or localhost

[CarolinaKid]

tryed localhost and 127.0.0.1 same results thanks for reply

[kill_emma]

make sure you check dbmysql.php on the specified lines, so that you get an idea of why you are getting the errors. if you cant find it from there, then make sure that your mysql is running, or possibly restart apache. beyond that, you may have to reinstall the entire thing.

[CarolinaKid]

I got it going thanks for all the help.

[MindTrix]

Im using php Triad and yeah i know its very very old :p But for some reason vb3 and vb2 etc work fine on it. Is it still ok to use do you think?

[kill_emma]

i would just uninstall triad, not only because you use the old version, but because installing it yourself helps you learn, which means that it will be easier for you to troubleshoot, instead of comming here ^_^

[assassingod]

Plus, if you ever plan on learning PHP, older version don't have as many functions as the current ones.

[Josh Combs]

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.
[b]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.

I have done this and I still get the 1045 and 1044 errors.... Any help? I am using XP Home and using the cmd here feature to log into MySQL thanks for anyhelp.

Josh

[Josh Combs]

I got my problem fixed by using -uroot -p [nothing] to log into mysql :) Thanks for the awesome tutorial on how to install all of this stuff Teck!

[MindTrix]

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

Could not find the following codes in the file so i couldnt do the step :s any ideas?

[MindTrix]

My php version i installed was php-4.3.4-Win32

And the apache was apache_1.3.28-win32-x86-no_src

[Anoutsider]

Attempting to attach to database...

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user: 'root@localhost' (Using password: YES) in C:\network\Apache2\htdocs\forums\admin\db_mysql.ph p on line 38

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\network\Apache2\htdocs\forums\admin\db_mysql.ph p 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.

Click to go to the vBulletin website

i get that error can some 1 help

[Anoutsider]

their is 99 members online and not 1 to help me

[Josh Combs]

did you make a database folder? plus how are you trying to log in?

[Anoutsider]

i did make the folder

i will be trying to install all of it again

[Anoutsider]

well i just did and it works perfect:

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!

[Dean C]

I wouldn't recommend anyone using phptriad or phpdev anymore - neither of them are running the latest stable releases of php or mysql or apache and these older versions are plagued with bugs and i'm guessing security holes. Even though you're running it offline it still means you may find bugs which are due to your php/mysql/apache versions and not your code :)

[kill_emma]

my goddess have we heard enough? this thread is NOT and advertizment thread, it is STRICTLY for support, not to go telling people to use phptriad or phpdev or whatever the hell you want to use.

GOT IT?!

[Anoutsider]

lol

[TECK]

Attempting to attach to database...


Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user: 'root@localhost' (Using password: YES) in C:\network\Apache2\htdocs\forums\admin\db_mysql.ph p on line 38

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\network\Apache2\htdocs\forums\admin\db_mysql.ph p 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.

Click to go to the vBulletin website





i get that error can some 1 help
Do this:
Open a CMD prompt in the /bin folder and type:
\bin> mysql --user=root mysql
Press ENTER. Type:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'your_password' WITH GRANT OPTION;

[sabret00the]

someone should make a vB localhost installed (php dev style) ;)

[kill_emma]

you know you use your localhost too much when you:

#1 Reason - You see someone talking about the root account on a thread and believe that they are reffering to you.

:P

[TheAnt]

or

#2 Reason - You continually try linking people to localhost to view stuff your workin on offline

[kill_emma]

w00t! i've done both :P ask Steve

[TECK]

I just installed following the tut with the latest software available for download (php, mysql, etc) and it works perfectly.

[gldtn]

Me too Teck :), Had a few problems at first, but then I got it working after the 2nd install.

Also, if anyone wants to install phpMyAdmin along with this tutorial.. do the following:

1. Download the lastest [zip] stable version : http://www.phpmyadmin.net
2. Extract the zip file that you just downloaded to 'c:\Network\Apache2\htdocs
3. Rename the folder that you extracted to something easier to remember. I.E MyAdmin
4. Browse to MyAdmin, or whatever you name it on step #3, and locate 'config.inc.php'.
5. Right click it and open it with you favorite editor. *note some editors, such as notepad makes the file messy and hard to read and edit it.. # I use EditPlus (http://www.editplus.com), a great text editor.
6. Locate this line > $cfg['PmaAbsoluteUri'] = ''; and in the '', add the url location to where you installed phpMyAdmin. I.E $cfg['PmaAbsoluteUri'] = 'http://localhost/MyAdmin';
7. Still in config.inc.php, locate this line > $cfg['Servers'][$i]['user'] = 'root'; // MySQL user, and replace 'root' with the username you specified during MySQL installation.
8. Again in config.inc.php, edit the line below the one you just edit on step #7 with the password you set for root or whatever username you gave access to.
9. Launch you favorite browser and point it to http://loacalhost/MyAdmin (or whatever you named it to) and you should see phpMyAdmin saying "Welcome to phpMyAdmin".

your done! :)

[sabret00the]

done that php my admin bit and i just get this

<?php
/* $Id: main.php,v 1.146 2003/09/17 13:16:46 nijel Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:

/**
* Don't display the page heading
*/
define('PMA_DISPLAY_HEADING', 0);

/**
* Gets some core libraries and displays a top message if required
*/
if (!defined('PMA_GRAB_GLOBALS_INCLUDED')) {
include('./libraries/grab_globals.lib.php');
}
if (!defined('PMA_COMMON_LIB_INCLUDED')) {
include('./libraries/common.lib.php');
}
// Puts the language to use in a cookie that will expire in 30 days
if (!isset($pma_uri_parts)) {
$pma_uri_parts = parse_url($cfg['PmaAbsoluteUri']);
$cookie_path = substr($pma_uri_parts['path'], 0, strrpos($pma_uri_parts['path'], '/'));
$is_https = (isset($pma_uri_parts['scheme']) && $pma_uri_parts['scheme'] == 'https') ? 1 : 0;
}
setcookie('lang', $lang, time() + 60*60*24*30, $cookie_path, '', $is_https);
// Defines the "item" image depending on text direction
$item_img = 'images/item_' . $text_dir . '.png';
// Handles some variables that may have been sent by the calling script
if (isset($db)) {
unset($db);
}
if (isset($table)) {
unset($table);
}
$show_query = '1';
require('./header.inc.php');
if (isset($message)) {

what did i do wrong?

[sabret00the]

any help about?

[sabret00the]

i tried to restore my database and nothing happened, any ideas?

[Preech]

Step 2) Connect to the database

Attempting to attach to database


Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\Network\Apache2\htdocs\forum\includes\db_mysql. php on line 140

The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.


BUT EVERYTHING IS RIGHT :( :(

what could I have missed?

if i take out the password I get a totally different error some kind of 1044 error...but if i modify the username and keep a pass it doesnt matter whether or not the information i put in is correct or not i get the same error, i really dont understand what could be wrong...and i dont see anyone else with this error :(

im running the vb3 rc2

// ****** DATABASE SERVER NAME ******
// This is the hostname or IP address of the database server.
// It is in the format HOST:PORT. If no PORT is specified, 3306 is used.
// If you are unsure of what to put here, leave it at the default value.
$servername = 'localhost';

// ****** DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$dbusername = 'root@localhost';
$dbpassword = 'password';

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'vbulletin';

and there is what i have in config.php currently I have tried about every combination of username and password and i have changed localhost to the IP address of my machine and also the 127.0.0.1...it doesnt matter what i changed it to i can change it to any word and i still get the same error

oooooooooo please help :)

[Preech]

I fully reinstalled MySQL, and changed the login information in my config.php file to username: root with no password and it worked...hmph go figure it was that simple...figured i would share that with everyone in case someone else has the same problem

[Kyle0515]

hmm... I worked on this for 2 days and couldn't get it to work. When I went to bed last night, it still wasn't working. But, when I got on today and tried it, everything was working fine.... Weird. You gotta love a computer that fixes itself... lol

Anyway... Everything is working great. Thanks

[Sadie Frost]

Working great for me - the two snags I had (in case it helps anyone) is that when I opened the cmd to add the users, I needed a space before the mysql --user bit, and as Preech said in the config.php file I needed to leave the password blank. :) This is going to help so much - wish I'd found it sooner! :D

[KayJay]

What can I say...Fantastic. So much easier than doing it online. many thanks for a great tutorial.

[ButchGal]

Great Tutorial. Thank you.

One question :)

I have done a mysql dump for my online forum.

I want to restore this to my local forum.

When I try to run restore procedure, I get a message that table is already created.
Which of course it is.

What have I done wrong?

[X-Sector]

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;

I'm trying to use a CMD prompt but l couldn't access my network folder in C:
I dunno why

I did a tut of how to access network folder via CMD prompt but l couldn't get it to working, i need help!

Also.. I don't know how to set up any users :(

[mitomcua]

To make life easier for you go here : http://www.easyphp.org/?lang=en and download the easy php 1.7 which includes and configures :Apache 1.3.27, php 4.3.3, MySQL 4.0.15 ...

[Andreas]

Or take XAMPP form www.apachefriends.org which includes preconfigured Apache 2.0.48, MySQL 4.0.17, PHP 4.3.4 + mod_php 4.3.4, Perl 5.8.2 + mod_perl 1.99_12,
Openssl 0.9.7c + mod_ssl 2.0.48 & PHPMyAdmin 2.5.5 pl1 :)

[X-Sector]

How do you set up any users?

[X-Sector]

how do u get it to connect from ur mysql db? cuz it doesn't work for me.

[X-Sector]

Well, I just tried to connect to my database without a user and password but l got this error..

Attempting to attach to database...

Connect failed: unexpected error from the database.

Error number: 1044

Error description: Access denied for user: '@localhost' to database 'vbulletin'

Please ensure that the database and server is correctly configured and try again.

Click to go to the vBulletin website

I tried to connect to my database with a user and password but it said that it cant connect to my database. What did l do?

[blakkboy]

this is where im stuck

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;

i dont understand what the CMD window is and where to set your users

also mysql admin is not on for some reason....... its running a red light and i take it that the light is supposed to be greeen

[Dean C]

I think in the mysql > bin folder there's an exe where you can execute mysql queries within a DOS interface :)

[blakkboy]

^^^ ok thanx i seem to have gotten it now

[blakkboy]

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!


im having trouble trying to restore my sql file from my real boards to my test ones.

-root -password vbulletin < blakkboy_vb.sql

that is what im typing into the prompt but its saying that its not restoring.

can someone help me out who used triad to set this up?

[blakkboy]

could someone let me know what exactly i did wrong so i can import my db to my computer forums

[Andreas]

Try

mysql -u root -p vbulletin < blakkboy_vb.sql

[blakkboy]

^^^^^^^^ your a life saver, thanx buddy

[Lexx]

Hi

I'm working on getting a handle on vB3 and have it running on my local computer so I can make forums and adjust "things".

A fresh untouched vB3 is sitting on a remote live server with several test messages on it.

What files and/directories do I need to upload from my home computer with the modified forums to update the live vb3 on my remote server so it looks and act like my finished version from my home computer?

I want the appearance of the remote vB3 to be the same as the "adjusted" home version of vB3, but I don't want the new adjusted vB3 (with new forums etc.) to mess up the database on the live server

How do I handle this merging of live database on the remote server with the newly adjusted vB3 uploaded from my localhost machine?

Any help is appreciated. I'm pretty new at this stuff

Thanks

[Andreas]

I'd do the following:

1) Make sure both run the same version
2) Shut down the live board
3) Make a backup of all files and the database (just in case anything goes wrong)
4) Upload all files form your test board
5) Export style & language from your testbord
6) Import both at your live board
7) If you made changes to the database structue do the same changes to the live system
8) Check if everything is ok
9) Open the live board

[Lexx]

I'd do the following:

1) Make sure both run the same version
2) Shut down the live board
3) Make a backup of all files and the database (just in case anything goes wrong)
4) Upload all files form your test board
5) Export style & language from your testbord
6) Import both at your live board
7) If you made changes to the database structue do the same changes to the live system
8) Check if everything is ok
9) Open the live board

Kirby

Thanks for the reply.

I'm new so please be patient.

Numbers 1-4) I understand.

Numbers 5-6) I assume this is done through Styles and Templates --> Download / Upload Styles. Correct?

Number 7) is the puzzler for me. When you say make changes to the database, how do I do that? Do I have to manually re-enter all the new forums I made on my testbed computer?

How do I get the "live" database on the remote server to recognize the new forums I made on the testbed computer, and have just uploaded to the live server. How do I "mesh" the new vBulletin styles and forums with the old existing data base?

Your's or anyone's comments are certainly appreciated as I try to get a handle on this program.

Thanks again

[TECK]

To make life easier for you go here : http://www.easyphp.org/?lang=en and download the easy php 1.7 which includes and configures :Apache 1.3.27, php 4.3.3, MySQL 4.0.15 ...
Ya, it's easier but how do you learn to program your apps, not to mention upgrade them?
Use my method to do it the right way.

[glo]

Hi TECK,

Thanks for this tutorial!

[X-Sector]

How do you edit the file that contains settings (root withpassword) that correspond to the default MySQL privileged account. My MySQL server is running with this default, is open to intrusion? please help!

[glo]

if you are referring to the creation of accounts ie monty, admin and dummy, change monty to the user name u want to use. ie admin and set the password.

as the instructions were a sample of how to do it. hope this helps

[X-Sector]

Atucally.. it doesn't work for me anymore.. the windows was flashed when clicking it.

[glo]

I have installed this hack successfully, but i need to import a file into my database.

The instructions for another hack says:
Import the file 'install.sql' into your database through phpmyadmin.

This file is located in the admin folder and does not have to be uploaded!
This file do all the database changes + it installs all the templates!

But we are using winmysql instead of phpmyadmin.

All help is appreciated.

[Jakor Sevel]

the only thing i can open in /bin is C:\Network\MySql\bin\mysql.exe
and everytime i type the command in it says there is an error

[glo]

I have installed this hack successfully, but i need to import a file into my database.

The instructions for another hack says:
Import the file 'install.sql' into your database through phpmyadmin.

This file is located in the admin folder and does not have to be uploaded!
This file do all the database changes + it installs all the templates!


But we are using winmysql instead of phpmyadmin.

All help is appreciated.

Its all sorted now..

[Gizmo]

Thanx for the tutorial, it may help me one day :)

[33x9519181]

Never worked with MySQL and PHP on my own computer.
But thanks mate, great tutorial !!
Works now on my own computer !!
But I have a question...
Is it also online when my computer is off ?
:)

[DMZman]

when i run the install.php it open it as if im opening it in notepad , I done all the php steps, but still with no luck...

[neocorteqz]

when i run the install.php it open it as if im opening it in notepad , I done all the php steps, but still with no luck...
after making any changes to httpd.conf, you have to restart Apache. it's still opening php files as a text file.

if you did this, then I'm not sure of the exact problem.

[neocorteqz]

Never worked with MySQL and PHP on my own computer.
But thanks mate, great tutorial !!
Works now on my own computer !!
But I have a question...
Is it also online when my computer is off ?
:)
When your computer is off, there is no possible way to connect to it.
on a side not
As far as I know, it'll only allow connections from 127.0.0.1 (localhost) unless you change the actual listening port. and most host don't allow port 80 anyways, so unless you are running it on a different port, I wouldn't worry too much, and you may always restrict it via a Firewall to your IP address if you want to feel secure. :)

[neocorteqz]

the only thing i can open in /bin is C:\Network\MySql\bin\mysql.exe
and everytime i type the command in it says there is an error


what is the error message outputed?

[DMZman]

How do i restart apache just close it and reopen it? Because i tried that and it didnt work, Still opens php as a text file...

And now, it wont even load any page, Just gives me page cannot be found errors, any help here?

[SemperFidelis]

DMZman,

If your talking about in WinXP
Control Panel -> Admin Tools -> Services
Locate Apache
And restart it

[DMZman]

Ok i done that, then clikced start and got this error

Windows could not start the apache 2 server etc

[TECK]

Apache could not start because you missed something either in the conf file or you did not copied the needed php files into the /system32 folder.
I make sometimes this mistake also, is normal... my wife won't let me concentrate... :p

[Bounce]

just what ive been lookin for for ages,now the hard bit of installing it all as i'm useless..lol

thank C

[Karthick]

Honestly, this is too tedious.

I just install PHPDEV (in 1 minute) from firepages.com.au and I have Apache server with PHP+MySQL and Perl ready to go.

[Intex]

Honestly, this is too tedious.

I just install PHPDEV (in 1 minute) from firepages.com.au and I have Apache server with PHP+MySQL and Perl ready to go.
LOL - the standard installation is a breeze. Whilst PHPDEV might be quick to install it is non-comparable to the power of vB.

[Karthick]

What the hell are you talking about, PHPDEV is a system to get Apache, PHP, MySQL, Perl onto your computer in one click. And it is just as powerful as installing each individual program manually.

How can you compare vB and PHPDEV? vB is forum software and PHPDEV just packages Apache PHP MySQL Perl.........

[Intex]

Yes, you're quite right, some some reason I mixed that up with PHPNuke.

[Crank]

i am having trouble getting it to work with php3 files. it just shows the php code.
it works with php but i need it to recognize php3 any help please?

[Dean C]

PHP3 was stopped a long time ago. Maybe its time to upgrade the scripts to PHP4 standards :)

Anyways the reason for this is the php3 extension. Find this line in your apache config file (httpd.conf):


AddType application/x-httpd-php .php


And below it place:


AddType application/x-httpd-php .php3


And replace this:


DirectoryIndex index.php index.html index.php.var index.html.var


With this:


DirectoryIndex index.php index.php3 index.html index.php.var index.html.var index.php3.var


This is untested but it should work :)

[Crank]

thank you very much dean.
you are a life saver.
also ill work on upgrading to the PHP4 as well. thanks for the heads up.

[Dean C]

You're welcome :)

[liang]

Hi,

I install FoxServ (http://www.foxserv.net) which include apache, mysql and PhP. The installation of VB(3.0.1) is perfectly.

The problem is , after install, the first step is login to Admin Cp, but it keep asking my username/password after click login. I am sure its not cookie's setting cos its working perfect when i browsing my online forum.

Anyone got idea how to fix it? :nervous: :nervous: :nervous:

Ps. FoxServ is really good, just one easy click install, and you dont have to do any httpd.conf setting.

[msimplay]

Hi,

I install FoxServ (http://www.foxserv.net) which include apache, mysql and PhP. The installation of VB(3.0.1) is perfectly.

The problem is , after install, the first step is login to Admin Cp, but it keep asking my username/password after click login. I am sure its not cookie's setting cos its working perfect when i browsing my online forum.

Anyone got idea how to fix it? :nervous: :nervous: :nervous:

Ps. FoxServ is really good, just one easy click install, and you dont have to do any httpd.conf setting.
its a cookie problem if you had the vbulletin installed at a different domain prior you have to run this (http://www.vbulletin.com/forum/showthread.php?p=486257#post486257) script
it will reset cookie domain

it would also be a good idea to clear cookies

[liang]

its a cookie problem if you had the vbulletin installed at a different domain prior you have to run this (http://www.vbulletin.com/forum/showthread.php?p=486257#post486257) script
it will reset cookie domain

it would also be a good idea to clear cookies


Yes , I did run that script but still no luck. :tired: :tired: :tired:

Did I mention that this VB is gonna be installed on my local computer for testing purpose?

Below is the step9 of the installation.


http://www.1stweb.tv/step9.gif


is there anything wrong with it ( cookie path?)

Thanks

Liang

[TECK]

Use the real install method that I posted, not some all-in-one pre-made installers. That's one of the reasons I recommended people to do it the simple and clean way...
That will fix your problem.

[MindTrix]

I installed php5 and changed little bits to hopefully make it work.

Ummmmmm went ok with no errors but now no page loads, and was just giving me a blank white page. So i reset windows and now apache doesnt work, i attached a screenshot of the error i got.

Also i skipped doing


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;


cause i didnt know how to open the command window :rolleyes:

Umm im guessing that wouldnt matter at all would it?

[TECK]

I'm running PHP 5 solid, no problems. The only problem you will have is when you run it under IIS, instead of Apache... but that's an easy fix also.
Simply replace php5isapi.dll from final version with the one from RC2.
That should fix the nasty errors like:
"PHP has encountered an Access Violation"... damn MS. ;)

To open a CMD window, press the Window Key + R.
Type CMD and press Enter.
Type CD C:\yourdirectory

[MindTrix]

Thank you for that finally got that done. Now what values should i enter into the config.php because the ones i have are giving me database errors. Do i need to use this monty stuff from the first page?

[glo]

Hi,

Im just setting this up on XPpro SP2 and am stuck here.



Click on OK.

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.



as i cant see my computer name. What should i try???

[glo]

Hi,

Im just setting this up on XPpro SP2 and am stuck here.




as i cant see my computer name. What should i try???

OK, i can see it now,

However, I have chosen to install it on the E: instead of C:

I presume that it makes little difference. Tell me if its not.

[glo]

Can someone please post the current links to the correct Apache, Mysql and php versions we should be using?

Thanks :ermm:

[khaleel]

Just wanted to say you can get phpTriad which is an exe file, you click one button an instant linux power! :)

[Allen Mead]

Hi guys,

Can someone tell me exactly which file versions of PHP, Apache Server and MySQL to download, as I've had a look at the links and there's loads of different versions, getting a bit lost.

Thanks!

PS, everything was going fine until i tried the Grant permissions in the CMD window and I got the following error messages:

C:\NETWORK\MYSQL\BIN>mysql --user=root mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

C:\NETWORK\MYSQL\BIN> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
'GRANT' is not recognized as an internal or external command,
operable program or batch file.

I'm using winXP.

[glo]

uninstall everything, mae sure you clear the PHP and MySQL properly then use this link (https://vborg.vbsupport.ru/showthread.php?t=69215) as it not only lets you run vB on your PC but also sets up a virtual host on your PC so you can run other web applications too like Photopost or PhpMyAdmin etc etc

[Allen Mead]

Hi fella. I've now cleared out all previous installations of MySQL, Apache and PHP and re-installed, worked perfectly!

Only thing is, in the first post under MySQL Binary Installation instruction no 03. I do not have a data folder in C:\network\MySQL\bin\ Instead, it's at C:\network\MySQL\

I created this data folder where it is supposed to be according to the instructions and created a folder called vbulletin as stated.

I've re-set the Apache server, all ok.

I have uploaded the files as instructed for vbulletin and modifed my config.php so that the command for the database is :
$dbname = 'C:\network\MySQL\bin\data\vbulletin'

Now, when I go to http://localhost/forum, I get the parent directory stuff with all the files and folders listed, brilliant, click on the install folder, nothing appears, strange as there are files and folder there. If I type the full url, http://localhost/forum/install/install.php IE finds the file, but instead of executing the scripts, it opens the file as a txt file :mad:

Hmmm, normal html files seem to be ok

just one other thing, where under the PHP Binary Installation instruction 05. SMTP = smtp.myisp.com - Should that actually be my real isp? or should thar say smtp = smtp.localhost.com ?

Thanks in advance

[glo]

Hi Allen,

yes you need to use your smtp server there.

From memory you have to amend the location of some folders as the instructions pertain to earlier versions.

Goodluck

[Atomicide]

i cant get it to work with my licence number, when i input it, it just brings me back to the main page :/

[glo]

your licence number is only needed when accessing the download from vBulletin.com.

To run vB on your own pc for testing, you dont need to put in the lic#, (unless things have changed for vB3.

[neocorteqz]

your licence number is only needed when accessing the download from vBulletin.com.

To run vB on your own pc for testing, you dont need to put in the lic#, (unless things have changed for vB3.
when running the vB install/upgrade script, you do need your license #. Well for vB 3.x

[Silverstangs]

This is a very very very useful thread, thanks alot!!!!!!!!

[andrew67]

I can't logon to phpmyadmin or into mysql from CMD...

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) Any ideas where I remove that password?

The password is still 'password' but i can't login to phpmyadmin :P mySQL in CMD seems to be working now though.

[Cryo]

Just installed this on a 2nd PC I had laying around... which is now a dedicated development server running NT 2k Pro. :) Worked great, thank you very much!

Any ideas where I remove that password?Did you make sure your grants were run correctly? If you did a grant all for monty you need to login with monty and not root as well.

[josef1]

I run vb under windows xp and 2003 but i have to run apache first
where I like to run IIS so

does Vbulletin works under IIS ?? or only under apache and if it can work under IIS what things to be done ?/

I was looking everywhere for this and no body tell us how he can do that :speechless:

[NFLForums]

I'm new to this, obviously...So please bear with me a little here...

I have followed the instructions...I run the mysqladmin.exe & it doesn't ask for a password. I tried uninstalling & reinstalling both mysql & apache, as well as deleting the my.ini file & uninstallin/reinstalling both...Still no go...

I tried the same again, only this time using the mysql configuration wizard dealio, and still no go! I'm getting a little frustrated with it & myself, as I normally don't have this many problems with things - especially when I'm following directions, line for line (I even copied it to a notepad file & printed it out so I can mark off what I've done!)

Any *quick* help would be appreciated. However, please do not link me to a different tutorial that uses a different process - I would like to learn how to do this "the old fashioned way"...Even if it means I need to put a few mattresses outside my window so when my computer goes flying, it won't completely be ruined! ;)

*restarting*
I'm crossing my fingers to hope this works this time...

**Just noticed in the PHP zip file - there is both a php.ini-dist and a php.ini-recommended file...I've been using the dist file, as shown in the tutorial -- but would a switch to the "recommended" one have a huge difference?**

[playboy]

I'm just wondering (1) this will work with vBulletin 3.0.7 and (2) can I test hacks, and install skins while being OFFLINE?

[angelicGrace]

I found it was just so much easier to use a precompiled package. I used wamp server package. It has the PHP, MySQL, PHPMyAdmin, and Apache all rolled into one very easy windows installer. Took maybe 5 min to download and install (and it is totaly free).

I went into phpmyadmin and created a database.

Then put the files that are for upload from the vb package inside a folder int he www section of the wamp file folder.

Ran the vb install and la te da one sharply running test server/database/vb!

[playboy]

I Cant Go To That Link For The Apache Thing, Its Says I'm Forbidden On This Server :S. Any Suggestions?

[glo]

I'm just wondering (1) this will work with vBulletin 3.0.7 and (2) can I test hacks, and install skins while being OFFLINE?

Offline from your web host YES.
However your web browser must be online (not neccesarily connected to the net) to access your index page. You are essentially creating a dummy server on your desktop or laptop.

What you are actually doing is installing PHP and MySQL onto your own PC in order to install the vB software and any other PHP program.

Then you can test your scripts and hacks without being connected to the Net.

Note that once you have tried the hacks and they run properly, you need to upload the modified files upto your live server.

Good luck

[playboy]

Thank You.

What Exactly Do I need To Download From Apache.org Because The Link On The First Post Of This THread Just Takes Me To The Apache.org Homepage :S

[glo]

try the link in my earlier post https://vborg.vbsupport.ru/showpost.php?p=562942&postcount=481

It will save you time!

[MrGoodbyte]

I've a little problem with MYSQL, hope somebody's able to help or has advice:

mySQL-help says this:

http://www.busepa.de/pics/sql1.jpg

I'd think, it must look like this if i want to create a database, right? But my mySQL looks like this :

http://www.busepa.de/pics/sql2.jpg

It's the same look if I'm clicking on my computer-name or on mySQL or on test ... So: What's wrong with it?

Thx for help! :)

https://vborg.vbsupport.ru/

[geevest.com]

error
There seems to have been a problem with the database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.
why?

[Barteken]

I got a cookie problem. When i login it says i'm logged in but then it just brings me to where i started and i have to login again. I added the notice to my config, still doesn't work...