Problem with new WinXP/Apache/PHP/mySQL installation...

[mrbaseball34]

Dev machine Configuration:
WinXP SP2
Apache 2.0.55
PHP Version 4.4.2
mySQL 4.1.18

I get this:

Notice: Undefined index: team in C:\Program Files\Apache Group\Apache2\htdocs\new_schedule.php on line 5
Notice: Undefined index: submit in C:\Program Files\Apache Group\Apache2\htdocs\new_schedule.php on line 6

/******************************************************************************
  Offending code:
$team   = $_GET['team'];   // offending line #5
$submit = $_GET['submit']; // offending line #6
******************************************************************************/

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\board\db\mysql.php on line 10

/******************************************************************************
  Offending code:
function connect($dbhost="localhost", $dbuser, $dbpw, $dbname, $pconnect=0) {
  if($pconnect) {
    mysql_pconnect($dbhost, $dbuser, $dbpw);
  } else {
    mysql_connect($dbhost, $dbuser, $dbpw); // offending line #10
  }
  mysql_select_db($dbname);
}
******************************************************************************/

Why the "does not support authentication protocol requested" error? I don't understand it. This
EXACT same code has worked for years on PHP 4.4.1 and mySQL 4.0.25.

[bpat1434]

that's a configuration issue. The connector PHP uses to communicate with the database is messing up (or incompatible). Not sure what the issue is, it's the first time I've seen this happen. Look into your php.ini file around the mySQL section. It's probably somethign in there....

As for the indexes, you reference the keys in the $GET array but they may not be there. Hence the warnings. I'd say put a simple if(isset($GET)){ $var = $_GET['key']; } in there....

[mrbaseball34]

Well, I only changed the default port, I didn't mess with any of the other values
below. Do I need to change any of them?

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
mysql.max_links = -1

; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysql.default_port = 3306

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host = 

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user = 

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password = 

; Maximum time (in seconds) for connect timeout. -1 means no limit
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off

[bpat1434]

Hmm.... I've seen the error before, but it's because the mySQL client is older (like 4.0.x). The mySQL client uses an "OLD"er password algorithm than the one PHP is using. That's where the error comes in, supposedly.

mySQL:: old client
That turned up via google..... should give some insight or ideas as to how to fix it....

PHP Support Doc

Some light reading for you....