Concerning PEAR::Auth
I can't tune interaction between PEAR::Auth and MySQL auth table .
Typical code from manual
<?php
$dbtype = 'mysql';
$dbhost = 'localhost';
$dbuser = '';
$dbpass = '';
$dbname = "cosmos";
$dsn = "$dbtype://$dbuser:$dbpass@$dbhost/$dbname";
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
require_once "Auth/Auth.php";
function loginFunction(){
echo "<form method=\"post\" action=\"" . $_SERVER['PHP_SELF'] . "\">";
echo "<input type=\"text\" name=\"username\">";
echo "<input type=\"password\" name=\"password\">";
echo "<input type=\"submit\">";
echo "</form>";
}
$a = new Auth("DB", $dsn, "loginFunction");
$a->start();
if ($a->getAuth()){
echo "OK";
}
?>
With typical SQL statement from manual:
CREATE TABLE auth(
username VARCHAR(50) default '' NOT NULL,
password VARCHAR(32) default '' NOT NULL,
PRIMARY KEY (username),
KEY (password));
I tried:
INSERT INTO auth VALUES ('qq', 'pp');
After submitting the login form the process buzzes on the procedure start();
I tried too:
INSERT INTO auth VALUES ('qq', PASSWORD('pp'));
I tried (using phpMyAdmin):
GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , INDEX , ALTER ON * . *
TO "qq"@ localhost" WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
But process buzzes on the procedure 'start()' as before;
Could you show me the simple
but concrete example of MySQL query
that make the above php-code working with
login (for instance) 'qq' and password 'pp'.
Thank you
Vlad Alivanov
