Re: [Phptest-users] login problem

[Brandon Tallent]

Hi Dan, 

Sorry to hear you're having so many problems.  Yes,
phpTest 0.6.0 is flawed in many ways, I rushed the
release and indeed there were many bugs.  As you can
probably tell this is my first large software project
so I'm learning as I go.  I had the thought for
regression testing as well, and in fact a phptest user
has volunteered to work on that aspect since he has
some experience with it.  As for you being unable to
login, take a look at the documentation in the docs
directory.  There's an option to use mysql's password
encryption instead of the builtin php crypt function
which seems to solve the problem in most cases.  You
might just want to pull the latest version from cvs as
that has all of the bugs you've mentioned fixed, as
well as some other stuff added.

Thanks for the feedback,
Brandon

--- Dan Kegel <address@hidden> wrote:
> Hey, it looks like there's some portability problem.
>  I'm
> running phptest-0.6.0 on www.pair.com, which uses
> freebsd.
> 
> The passwords in the users table I generate when
> adding
> a user are so long they seem to get truncated...
> here's a log:
> 
> 2002-07-29 02:43:18 Query: INSERT INTO users
> (username, password, email, 
> real_name, date_joined, admin) VALUES ('qwerty', 
> '$1$KGktWeHX$.BsZ1b9CNiJefEiLpF4tW1', '', '', NOW(),
> 0)
> 2002-07-29 02:43:18 Insert ID is 29
> 2002-07-29 02:43:18 Query: SELECT g_id FROM groups
> WHERE description = 
> 'visitors'
> 2002-07-29 02:43:18 Query: INSERT INTO user_groups
> (user_id, g_id) 
> VALUES (29, 20)
> 2002-07-29 02:43:18 --- Connected to mysql---
> 2002-07-29 02:43:40 --- Connected to mysql---
> 2002-07-29 02:43:40 Query: SELECT password FROM
> users WHERE username = 
> 'qwerty'
> 2002-07-29 02:43:40 Numrows is 1
> 2002-07-29 02:43:40 Query: SELECT * FROM users WHERE
> username = 'qwerty' 
> AND password = '$1$KGktWeHX$.BsZ1b9CNiJefEiLpF4tW1'
> 2002-07-29 02:43:40 Numrows is 0
> 
> My, my -- password was same but no matchy -- could
> it be the table 
> truncates the value, causing the compare to fail? 
> Here's the table
> contents:
> 
> mysql> select * from users;
>
+---------+----------+--------------------------------+------------------+---------------------+---------------------+-------+
> | user_id | username | password                     
>  | email 
>   | real_name           | date_joined         |
> admin |
>
+---------+----------+--------------------------------+------------------+---------------------+---------------------+-------+
> |       1 | admin    |
> $1$LiQsrgDg$9aZjbQKQWCI15YsxfQ | none 
>   | Administrative user | 2002-04-05 10:14:31 |    
> 1 |
> |      26 | pink     | tO7t1xqN0kmpo                
>  | address@hidden 
>   | Mr. Pink            | 2002-06-14 14:55:28 |    
> 0 |
> |      25 | brown    | twaR3fBd1S0i2                
>  | address@hidden 
> | Ms. Brown           | 2002-06-14 14:51:14 |     0
> |
> |      27 | green    | tJmnGO9JuPrFI                
>  | address@hidden 
> | Mr. Green           | 2002-06-14 14:56:00 |     0
> |
> |      28 | dank     |
> $1$HwcygUOV$aUPg//8e7BD7f0OfP9 | 
>   |                     | 2002-07-29 02:40:45 |    
> 0 |
> |      29 | qwerty   |
> $1$KGktWeHX$.BsZ1b9CNiJefEiLpF | 
>   |                     | 2002-07-29 02:43:18 |    
> 0 |
>
+---------+----------+--------------------------------+------------------+---------------------+---------------------+-------+
> 
> What do you think?
> 
> I'm just a beginner at php + mysql, I have no
> idea...
> 
> Thanks,
> Dan
> 
> 
> _______________________________________________
> Phptest-users mailing list
> address@hidden
>
http://mail.freesoftware.fsf.org/mailman/listinfo/phptest-users


__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com