OSDev.org

hey chris,
This is the error I get when I complete the install.php

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in C:\indigoperl\apache\htdocs\yabbse\install.php on line 357

Cannot connect to database server with given data!
Please check the information you provided, and then try again.

when I use mysql password

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\indigoperl\apache\htdocs\yabbse\install.php on line 357

Cannot connect to database server with given data!
Please check the information you provided, and then try again.

I figured yabbse would be a good place to start deciphering some php scripts and understanding the relationship between databases and php. It's an environment that I am used to visiting and one I thought that I could get up and running quickly,

as far as mysql goes, I have been able to open and explore my two current databases (mysql, test) so I am fairly confident that it is installed correctly but when I try to access the attatched script on my localhost (it's inside my cgi-bin folder) which came with, not one of my creations, I get this error.

MySQL Sample Test Script V1.0 on Thu Apr 28 15:00:14 2005

------------------------------------------------------------
Can't connect to the mysql server.
dbih_getcom given an undefined handle (perhaps returned from a previous call which failed) at C:/indigoperl/apache/cgi-bin/mysqlsamp.pl line 68.

everything seems to work fine seperately but nothing wants to work together :-\

Well how did you install mysql? What version of mysql did you use? Was it a pre made package from another site? Or did you download it from mysql.com?

Because some server packages that install it for you change the default username and password for mysql. Such as apache2triad, the username is still root for it, but the default password is triad2pass instead of blank.

If you or a program has changed the default user/password you should use those instead of the ones I listed above. The ones I listed is the default user and password when you install mysql 4.0 and lower.

So if you set a new password when you where installing it or after you installed it, use that password instead.

So uhm today was a very productive day, I have broken everything I just installed to the point I have decided to uninstall everything (just finished). Then start again, the closest version I had working was a package from indigoperl which had php, perl and apache packaged together (but older versions of all), so now when the reinstall takes place, I will be using:

-Apache 2.0.54
-PHP 5.0.4
-ActivePerl-5.8.6.811 (probably wait on this on, since I decided to focus on PHP)
-mysql 4.1.10a
- oh yeah and mysql-adminisrtator 1.0.20

In that order. but this was the first setup I tried and i got less far with this than the indigloperl package.

SO before I start, Is it better to place these (amp) directly in the c: drive, I read somewhere that PHP? might be prone to crash if it were in a spaced directory like "Program Files". The package installer also placed the php files, and the perl files inside the apache directory, is this suggested, or is it all a matter of setting the correct paths in the httppdpessdd file.

I love it when I have to install the same software four or five times, it's always a real boost to the ego.

Well I don't recommend using mysql 4.1.10a, the 4.1 branch isn't fully stable and supported. 4.0 is the standard right now.

Do you want to use a package to install things? Or would you rather install them all seperatly?

If you want a package I recommend:
http://sourceforge.net/project/showfile ... _id=314750

This will install apache, mysql, php, perl, python, and ssl. It will also install alot of scripts for you to help you manage the server such as phpmyadmin, awstats, and other cool things.

Using a package has one benefit, it will make all these things work together... but it has a con as well, the programs arn't always the latest versions.

Of course if you know what your doing you can modify it after the package is installed to put in the latest versions of software.

Anyway as for the location of the stuff, my setup is like this:

C:\apache for apache
C:\apache\php for php
C:\apache\mysql for mysql
C:\apache\perl for perl

And so forth, you can put them wherever you want really, just as long as you change paths in the configuration to link them up.

Stable is good, and cohesion is better.

I will definately give this package a look. From your description it has what I need and more. At this point I don't plan to do any hosting out of my box so a good stable development area is all I am looking for, and if it's what you use, nuff said.

and thanks for the tree, I will definately follow your example there, that way you'll be in a position to possibly help with the configutation.

But I suppose, until then I had better start downloading. ungh it's a big one, dial up

Yeah that's one of the biggest downfalls to this specific package, it's size. Takes me a little bit on a cable modem.

I think you will like it, it's the best server package I have ever seen. I use it myself(before I found it I always installed each peice of software myself seperately), although I use the cutting edge version rather than the stable version one since I am more comfortable with configuring and getting things to work, plus I wanted postgresql for my forum development.

The only real difference between the 2 versions is newer software, and a few new software programs like postgresql and a few new tools and a new control panel.

But the stable is all you really need because I don't think you would need the features in the cutting edge version.

And yes it does make a wonderfull development and testing area, which is what I use it for. I have it disabled to the public so only I can use the server.

Wow so that was much easier. ;D

Everything is running, I have even viewed the initial yabbse post so I guess now it is just ime to get my hands dirty. I was surprised when it created a new user on my computer, it doesn't appear to ever actually reference this new user "apache2triad" in the config so I think I can just remove it. Other than that, perfect.

Thanks chris, this package may have hit the mark. :-*

The new user it creates on the computer is for postgresql. So it's safe to remove that user unless you want to use postgresql sometimes in the future.

Anyway glad you like it. And if you have any questions about YaBBSE or php feel free to ask.