[Phptest-users] WG: Can't login to phptest ...

[Andreas Rainer]

I changed my.ini from mysql

from

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

to

sql-mode=

and restarted the service

then i deleted the old database and started an install with

/phptest/installscript

changed the admin pw

but can't login …

it says username or password incorrect

 

i created a new user, this works, it getting into mysql tables, but still can't login with it …

login: tester

pw: tester …

username or password incorrect :-(

 

and if i set it to blank password, i can't login … login window appears again, but no error …

 

Does somebody know whats wrong?

 

Von: Andreas Rainer [mailto:address@hidden
Gesendet: Samstag, 17. Februar 2007 23:44
An: 'address@hidden'
Betreff: Can't login to phptest ...

 

OS: Windows XP

Webserver: Sambar 6.4

Php 4.4.4

MySQL: 5.0.27

I copied the files to a directory called e:\intranet

->e:\intranet\phptest

installed mappings and edited config.inc.php

 

<?php

    // database configuration variables

    define('DB_HOST', 'localhost');   // hostname of database

    define('DB_USERNAME', 'root'); // username of database

    define('DB_PASSWORD', '');        // password of databsae

    define('DEFAULT_DB', 'phptest');  // name of database to use

    define('DB_TYPE', 'mysql');       // database type.  Mysql is the only supported db right now

    define('DB_USE_PCONNECT', 0);     // set this to 0 if your database doesn't support persistent connections

    // absolute path of your phptest installation

    define('ABSOLUTE_PATH', 'https://cobragraz.gotdns.org/intranet/phptest/');

?>

 

created a database phptest and installed the tables with /installscript/phptest.sql …

 

then i tried it …

login page appears, then as soon as i try login with

admin/123456

or

guest/guest

 

it says: Username or password incorrect

then i tried to register a new user

 

login: tester

Pw: tester

e-mail: address@hidden

 

and got:

 

There was an SQL error. The error message is:
Data too long for column 'password' at row 1
Please notify the site administrator.
The SQL Query that failed is: INSERT INTO users (username, password, email, real_name, date_joined, admin) VALUES ('tester', PASSWORD('tester'), 'address@hidden', 'tester', CURRENT_TIMESTAMP, 0)

 

whats wrong?

 

does somebody know the answer?

 

Other php Scripts like phpmyfaq or phpbb2 work with no problem … did i forgot something?