Vbulletin v2.2.9 werkt niet

-----------------------------------------------------------------------
MySQL
-----------------------------------------------------------------------

Het installeren van MySQL is ontzettend simpel. Unzip het bestand naar een tijdelijke directory. (Bijvoorbeeld C:\Temp\MySQL_Install). Ga naar die map en start setup.exe. Verander de installatiemap van C:\mysql naar C:\apache\mysql. Kies als installatie 'Typical'. Klaar!

[ Voor 19% gewijzigd door Verwijderd op 01-03-2003 20:54 ]

MySQL User Names and Passwords
------------------------------

There are several distinctions between the way user names and passwords
are used by MySQL and the way they are used by Unix or Windows:

* User names, as used by MySQL for authentication purposes, have
nothing to do with Unix user names (login names) or Windows user
names. Most MySQL clients by default try to log in using the
current Unix user name as the MySQL user name, but that is for
convenience only. Client programs allow a different name to be
specified with the `-u' or `--user' options. This means that you
can't make a database secure in any way unless all MySQL user
names have passwords. Anyone may attempt to connect to the server
using any name, and they will succeed if they specify any name
that doesn't have a password.

* MySQL user names can be up to 16 characters long; Unix user names
typically are limited to 8 characters.

* MySQL passwords have nothing to do with Unix passwords. There is
no necessary connection between the password you use to log in to
a Unix machine and the password you use to access a database on
that machine.

* MySQL encrypts passwords using a different algorithm than the one
used during the Unix login process. See the descriptions of the
`PASSWORD()' and `ENCRYPT()' functions in *Note Miscellaneous
functions::. Note that even if the password is stored
'scrambled', and knowing your 'scrambled' password is enough to be
able to connect to the MySQL server!

MySQL users and their privileges are normally created with the `GRANT'
command. *Note GRANT::.

When you login to a MySQL server with a command-line client you should
specify the password with `--password=your-password'. *Note
Connecting::.

mysql --user=monty --password=guess database_name

If you want the client to prompt for a password, you should use
`--password' without any argument

mysql --user=monty --password database_name

or the short form:

mysql -u monty -p database_name

Note that in the last example the password is *not* 'database_name'.

If you want to use the `-p' option to supply a password you should do so
like this:

mysql -u monty -pguess database_name

On some systems, the library call that MySQL uses to prompt for a
password will automatically cut the password to 8 characters. Internally
MySQL doesn't have any limit for the length of the password.

[ Voor 166% gewijzigd door Verwijderd op 01-03-2003 21:37 ]

Microsoft Windows XP [versie 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>C:\Apache2\mysql\bin
C:\Apache2\mysql\bin wordt niet herkend als een interne
of externe opdracht, programma of batchbestand.

C:\Documents and Settings\Administrator>c:\
c:\ wordt niet herkend als een interne
of externe opdracht, programma of batchbestand.

C:\Documents and Settings\Administrator>c:

C:\Documents and Settings\Administrator>cd \Apache2\mysql\bin

C:\Apache2\mysql\bin>mysqladmin
mysqladmin Ver 8.23 Distrib 3.23.54, for Win95/Win98 on i32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Administration program for the mysqld daemon.
Usage: mysqladmin [OPTIONS] command command....

-#, --debug=... Output debug log. Often this is 'd:t:o,filename`
-f, --force Don't ask for confirmation on drop database; with
multiple commands, continue even if an error occurs
-?, --help Display this help and exit
--character-sets-dir=...
Set the character set directory
-C, --compress Use compression in server/client protocol
-h, --host=# Connect to host
-p, --password[=...] Password to use when connecting to server
If password is not given it's asked from the tty
-W, --pipe Use named pipes to connect to server
-P --port=... Port number to use for connection
-i, --sleep=sec Execute commands again and again with a sleep between
-r, --relative Show difference between current and previous values
when used with -i. Currently works only with
extended-status
-E, --vertical Print output vertically. Is similar to --relative,
but prints output vertically.
-s, --silent Silently exit if one can't connect to server
-S, --socket=... Socket file to use for connection
-u, --user=# User for login if not current user
-v, --verbose Write more information
-V, --version Output version information and exit
-w, --wait[=retries] Wait and retry if connection is down

Default options are read from the following files in the given order:
C:\WINDOWS\my.ini C:\my.cnf
The following groups are read: mysqladmin client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read

Possible variables for option --set-variable (-O) are:
connect_timeout current value: 0
shutdown_timeout current value: 3600

Where command is a one or more of: (Commands may be shortened)
create databasename Create a new database
drop databasename Delete a database and all its tables
extended-status Gives an extended status message from the server
flush-hosts Flush all cached hosts
flush-logs Flush all logs
flush-status Clear status variables
flush-tables Flush all tables
flush-threads Flush the thread cache
flush-privileges Reload grant tables (same as reload)
kill id,id,... Kill mysql threads
password new-password Change old password to new-password
ping Check if mysqld is alive
processlist Show list of active threads in server
reload Reload grant tables
refresh Flush all tables and close and open logfiles
shutdown Take server down
status Gives a short status message from the server
start-slave Start slave
stop-slave Stop slave
variables Prints variables available
version Get version info from server

[ Voor 92% gewijzigd door Verwijderd op 01-03-2003 21:48 ]

[ Voor 41% gewijzigd door Verwijderd op 01-03-2003 21:52 ]

<?php

/////////////////////////////////////////////////////////////
// Please note that if you get any errors when connecting, //
// that you will need to email your host as we cannot tell //
// you what your specific values are supposed to be //
/////////////////////////////////////////////////////////////

// type of database running
// (only mysql is supported at the moment)
$dbservertype='mysql';

// hostname or ip of server
$servername='localhost';

// username and password to log onto db server
$dbusername='root';
$dbpassword='';

// name of database
$dbname='vbulletin';

// technical email address - any error messages will be emailed here
$technicalemail='coenaarts@hotmail.com';

// use persistant connections to the database
// 0 = don't use
// 1 = use
$usepconnect=1;

?>

[ Voor 75% gewijzigd door Verwijderd op 01-03-2003 22:14 ]

[ Voor 25% gewijzigd door Verwijderd op 01-03-2003 22:22 ]

[ Voor 66% gewijzigd door Verwijderd op 01-03-2003 22:34 ]

C:\Apache2\mysql\bin\mysqld.exe: ready for connections

<?php
error_reporting(7);
// db class for mysql
// this class is used in all scripts
// do NOT fiddle unless you know what you are doing

class DB_Sql_vb {
var $database = "";

var $link_id = 0;
var $query_id = 0;
var $record = array();

var $errdesc = "";
var $errno = 0;
var $reporterror = 1;

var $server = "localhost";
var $user = "root";
var $password = "";

var $appname = "vBulletin";
var $appshortname = "vBulletin (cp)";

function connect() {
global $usepconnect;
// connect to db server

if ( 0 == $this->link_id ) {
if ($this->password=="") {
if ($usepconnect==1) {
$this->link_id=mysql_pconnect($this->server,$this->user);
} else {
$this->link_id=mysql_connect($this->server,$this->user);
}
} else {
if ($usepconnect==1) {
$this->link_id=mysql_pconnect($this->server,$this->user,$this->password);
} else {
$this->link_id=mysql_connect($this->server,$this->user,$this->password);
}
}
if (!$this->link_id) {
$this->halt("Link-ID == false, connect failed");
}
if ($this->database!="") {
if(!mysql_select_db($this->database, $this->link_id)) {
$this->halt("cannot use database ".$this->database);
}
}
}
}

function geterrdesc() {
$this->error=mysql_error();
return $this->error;
}

function geterrno() {
$this->errno=mysql_errno();
return $this->errno;
}

function select_db($database="") {
// select database
if ($database!="") {
$this->database=$database;
}

if(!mysql_select_db($this->database, $this->link_id)) {
$this->halt("cannot use database ".$this->database);
}

}

function query($query_string) {
global $query_count,$showqueries,$explain,$querytime;
// do query

if ($showqueries) {
echo "Query: $query_string\n";

global $pagestarttime;
$pageendtime=microtime();
$starttime=explode(" ",$pagestarttime);
$endtime=explode(" ",$pageendtime);

$beforetime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];

echo "Time before: $beforetime\n";
}

$this->query_id = mysql_query($query_string,$this->link_id);
if (!$this->query_id) {
$this->halt("Invalid SQL: ".$query_string);
}

$query_count++;

if ($showqueries) {
$pageendtime=microtime();
$starttime=explode(" ",$pagestarttime);
$endtime=explode(" ",$pageendtime);

$aftertime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];
$querytime+=$aftertime-$beforetime;

echo "Time after: $aftertime\n";

if ($explain and substr(trim(strtoupper($query_string)),0,6)=="SELECT") {
$explain_id = mysql_query("EXPLAIN $query_string",$this->link_id);
echo "</pre>\n";
echo "
<table width=100% border=1 cellpadding=2 cellspacing=1>
<tr>
<td><b>table</b></td>
<td><b>type</b></td>
<td><b>possible_keys</b></td>
<td><b>key</b></td>
<td><b>key_len</b></td>
<td><b>ref</b></td>
<td><b>rows</b></td>
<td><b>Extra</b></td>
</tr>\n";
while($array=mysql_fetch_array($explain_id)) {
echo "
<tr>
<td>$array[table] </td>
<td>$array[type] </td>
<td>$array[possible_keys] </td>
<td>$array[key] </td>
<td>$array[key_len] </td>
<td>$array[ref] </td>
<td>$array[rows] </td>
<td>$array[Extra] </td>
</tr>\n";
}
echo "</table>\n<BR><hr>\n";
echo "\n<pre>";
} else {
echo "\n<hr>\n\n";
}
}

return $this->query_id;
}

function fetch_array($query_id=-1,$query_string="") {
// retrieve row
if ($query_id!=-1) {
$this->query_id=$query_id;
}
if ( isset($this->query_id) ) {
$this->record = mysql_fetch_array($this->query_id);
} else {
if ( !empty($query_string) ) {
$this->halt("Invalid query id (".$this->query_id.") on this query: $query_string");
} else {
$this->halt("Invalid query id ".$this->query_id." specified");
}
}

return $this->record;
}

function free_result($query_id=-1) {
// retrieve row
if ($query_id!=-1) {
$this->query_id=$query_id;
}
return @mysql_free_result($this->query_id);
}

function query_first($query_string) {
// does a query and returns first row
$query_id = $this->query($query_string);
$returnarray=$this->fetch_array($query_id, $query_string);
$this->free_result($query_id);
return $returnarray;
}

function data_seek($pos,$query_id=-1) {
// goes to row $pos
if ($query_id!=-1) {
$this->query_id=$query_id;
}
return mysql_data_seek($this->query_id, $pos);
}

function num_rows($query_id=-1) {
// returns number of rows in query
if ($query_id!=-1) {
$this->query_id=$query_id;
}
return mysql_num_rows($this->query_id);
}

function num_fields($query_id=-1) {
// returns number of fields in query
if ($query_id!=-1) {
$this->query_id=$query_id;
}
return mysql_num_fields($this->query_id);
}

function insert_id() {
// returns last auto_increment field number assigned

return mysql_insert_id($this->link_id);

}

function close() {
// closes connection to the database

return mysql_close();
}

function halt($msg) {
$this->errdesc=mysql_error();
$this->errno=mysql_errno();
// prints warning message when there is an error
global $technicalemail, $bbuserinfo, $scriptpath, $HTTP_SERVER_VARS;

if ($this->reporterror==1) {
$message="Database error in " . $this->appname . " $GLOBALS[templateversion]:\n\n$msg\n";
$message.="mysql error: " . $this->errdesc . "\n\n";
$message.="mysql error number: " . $this->errno . "\n\n";
$message.="Date: ".date("l dS of F Y h:i:s A")."\n";
$message.="Script: $GLOBALS[bburl]" . (($scriptpath) ? $scriptpath : $HTTP_SERVER_VARS['REQUEST_URI']) . "\n";
$message.="Referer: ".$HTTP_SERVER_VARS['HTTP_REFERER']."\n";

if ($technicalemail) {
@mail ($technicalemail,$this->appshortname. " Database error!",$message,"From: $technicalemail");
}

echo "<html><head><title>$GLOBALS[bbtitle] Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>\n\n<!-- $message -->\n\n";

echo "</table></td></tr></table></form>\n<blockquote><p> </p><p><b>There seems to have been a slight problem with the $GLOBALS[bbtitle] database.</b><br>\n";
echo "Please try again by pressing the <a href=\"javascript:window.location=window.location;\">refresh</a> button in your browser.</p>";
echo "An E-Mail has been dispatched to our <a href=\"mailto:$technicalemail\">Technical Staff</a>, who you can also contact if the problem persists.</p>";
echo "<p>We apologise for any inconvenience.</p>";

if ($bbuserinfo['usergroupid']==6) {
echo "<form><textarea rows=\"12\" cols=\"60\">".htmlspecialchars($message)."</textarea></form>";
}

echo "</blockquote></body></head></html>";
exit;
}
}
}
?>