Home Server Question

[smack]

I install Abriasoft Merlin Server on my home computer runing windows XP.   I have a question, I have install boards like phpBB2, XMB, and many others that you must know there out there.  These board that I install work on my home server.   Now my question is I try to install SMF on my home testing machine and I get an Error....

Code Select Expand


Warning: Undefined variable: _SERVER in c:/program files/abria merlin/apache/htdocs/forum/install.php on line 359

Warning: Undefined variable: _SERVER in c:/program files/abria merlin/apache/htdocs/forum/install.php on line 362

Warning: Undefined variable: _SERVER in c:/program files/abria merlin/apache/htdocs/forum/install.php on line 362

Warning: Undefined variable: _SERVER in c:/program files/abria merlin/apache/htdocs/forum/install.php on line 369

Basic Settings
Just a few things for you to setup ;).
Forum name: 
This is the name of your forum, ie. "The Testing Forum".
Forum URL:

This is the URL to your forum without the trailing '/'!.
In most cases, you can leave the default value in this box alone - it is usually right.
Gzip Output:  Compress output to save bandwidth.

This function does not work properly on all servers, but can save you a lot of bandwidth.
Click here to test it. (it should just say "PASS".)
Database Sessions:  Use the database for sessions instead of using files.

This feature is almost always for the best, as it makes sessions more dependable.

MySQL Server Settings
These are the settings to use for your MySQL server. If you don't know the values, you should ask your host what they are.
MySQL server name:

This is nearly always localhost - so if you don't know, try localhost.
MySQL username:

Fill in the username you need to connect to your MySQL database here.
If you don't know what it is, try the username of your ftp account, most of the time they are the same.
MySQL password:

Here, put the password you need to connect to your MySQL database.
If you don't know this, you should try the password to your ftp account.
MySQL database name:

Fill in the name of the database you want to use for SMF to store its data in.
If this database does not exist, this installer will try to create it.
MySQL table prefix:

The prefix for every table in the database. Do not install two forums with the same prefix!
This value allows for multiple installations in one database.



I install in my hosting company and it works fine.  at http://www.airwarrioronline.com but Im just wondering why I can't install in my home testing machine I don't know much about setting up a home server but just wondering if there is something I need to setup on my home testing machine so I can get SMF to run.   Would be great to get it running on my local machine here so I can learn the layout and how to modified themes with out having to mess up my main site. 

All help on this would be at best.

[andrea]

What PHP version is on your home server? The "_SERVER" variable was introduced in a version 4.x, your server seems to be below that version.

[smack]

Yes my fault.  I just did some forum search and found out that it was the version.. it is PHP Version 4.0.4pl1  So now I have to learn how to upgrade it LOL.

[[Unknown]]

http://unknown.network32.net/tutorial.basic-server

-[Unknown]

[smack]

Thank You [Unknown]  You have a great board at work here.  Better than any of the big names, and with a little of more work who knows what you will cook up.  I will try that tutorial out and try to make it work.  I like this board is fast and love the add mod section best I seen yet.


Thank You [Unknown]  and thank you andrea for your time.

[smack]

Hello Thanks for the tutorial.

I did as you type on the tutorial,  I use Apache 2.xx and php5 for the install.   All work great  I can get phpinfo.php and I can see all the info in it.  Apache is loading with no problem.  I think I install the mysql-4.1.7-essential-win.msi and install it with no problem.

I test it PHP it works I tested Apache it works,  Now when I test MySQL connect it don't work,  I don't know if I install the wrong version or something is wrong.  I said let me try installing phpMyAdmin to see if it works.   I did as you show in your tutorial and I get this error message.

cannot load mysql extension,
please check PHP Configuration
Documentation

Now I click on the Documentation link and it tells me.

[1.20] I receive the error "cannot load MySQL extension, please check PHP Configuration".
To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.

Now I open the PHP.INI and check for

;extension=php_mssql.dll
;extension=php_msql.dll
;extension=php_mysql.dll <----- I guess this is the extension they talking about above?
;extension=php_oci8.dll
;extension=php_openssl.dll

I take out the ; <--- from behind it and I get error when I restart apache, extension not found.
I made sure this sis ok.
extension_dir = "./extensions/".

But when I browse for the php_mysql.dll is in c:\PHP\ext\php_mysql.dll
I change  to  extension_dir = "C:/PHP/ext/". and it still don't find it when I restart apache.  Im a little confuse with the MySQL setup on server.

[[Unknown]]

You may need to put some dlls in system32.  I have not updated my tutorial for PHP 5 (the release, I wrote it for beta 1) yet.

-[Unknown]

[andrea]

I always use this on my home pc:

http://www.apachefriends.org/en/

A few mouseklicks, and everything works flawless.

[smack]

Ok the extension part is now fix thanks to you guys.  Also I notice that the tutorial was not for php5 thingie so i look up on forum similar problems and found out about the ini file the windows dir.  So I copy the file and fix the ext path and done. 

I was a happy camper, but not for long..  I fire up smf and Input Basic Settings Info and MySQL Server Settings.. and click on Proceed.

Problem #3 :O)
Cannot connect to the MySQL database server with the supplied data.

If you are not sure about what to type in, please contact your host.
Client does not support authentication protocol requested by server; consider upgrading MySQL client

DUhh

[Oldiesmann]

http://www.simplemachines.org/community/index.php?topic=18671.0

[smack]

Cool I created a user with the shell and use that user insted of the main root.   Now it works I will have to do a lot of reading to get it going but I will succed    trying to learn the in and out of this so I can setup a server in the future if I learn it..