[TYPO3-windows] backend login fail

[Pritesh Chandra]

Hi there,

thanks for the help.  I did what u stated.  changed the my.ini file
and i removed everything and started typo3 install again.  this time,
after the 123 steps were completed, i see that the be_users now has 1
record of user admin.

great i said.  so i went to the backend and tried to login using admin
and password but it failed and said "Your login attempt did not
succeed".

so now i went to the " 	Create admin user" and create a admin user
pritesh with password as pritesh also.
its says that "User created Username: pritesh Password: pritesh" and i
check the be_users table and see that in fact the account has been
created.

the sql is below...

*********************************
INSERT INTO `be_users` (`uid`, `pid`, `tstamp`, `username`,
`password`, `admin`, `usergroup`, `disable`, `starttime`, `endtime`,
`lang`, `email`, `db_mountpoints`, `options`, `crdate`, `cruser_id`,
`realName`, `userMods`, `allowed_languages`, `uc`, `file_mountpoints`,
`fileoper_perms`, `workspace_perms`, `lockToDomain`, `disableIPlock`,
`deleted`, `TSconfig`, `lastlogin`, `createdByAction`,
`usergroup_cached_list`, `workspace_id`, `workspace_preview`) VALUES
(1, 0, 1211836999, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 1, '',
0, 0, 0, '', '', '', 0, 1211836999, 0, '', '', '', '', '', 7, 1, '',
0, 0, '', 0, 0, '', 0, 1),
(2, 0, 1211837347, 'pritesh', 'd821e72d0b9f832d6cde431111057d96', 1,
'', 0, 0, 0, '', '', '', 0, 1211837347, 0, '', '', '', '', '', 7, 1,
'', 0, 0, '', 0, 0, '', 0, 1);

********************************
 but then now that i try to login at the backend, using pritesh as
username and password, its again unsuccessful.  i am confused now.  i
checked the logs and

************************
access_typo.log
127.0.0.1 - - [27/May/2008:09:34:21 +1200] "GET /typo3/typo3/index.php
HTTP/1.1" 200 5776
127.0.0.1 - - [27/May/2008:09:34:33 +1200] "POST
/typo3/typo3/index.php HTTP/1.1" 200 6020


error_typo.log
[Tue May 27 09:34:12 2008] [notice] Child 6824: Acquired the start mutex.
[Tue May 27 09:34:12 2008] [notice] Child 6824: Starting 250 worker threads.
[Tue May 27 09:34:12 2008] [notice] Child 6824: Starting thread to
listen on port 8085.
******************************

the logs has no error reported. so i dont know what went wrong.

Can u please help me in this area.  i am lost in fact.  and i do not
know where to go from here.

thanks


On Mon, May 26, 2008 at 9:18 PM, Andreas Gawelczyk <typo3 at gawelczyk.net> wrote:
> Hi,
>
> try to turn off the MySQL strict mode:
>
> Open your "my.ini" file within the MySQL installation directory, and
> look for the text "sql-mode".
> Find:
>
> # Set the SQL mode to strict
> sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
>
> Replace with:
>
> # Set the SQL mode to strict
> sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
>
>
>
> Pritesh Chandra schrieb:
>> hi there,
>>
>> I have php 5, apache 2 and mysql 5 and windows XP.
>>
>> configured apache port to have typo3 run on http://localhost:8085/typo3/
>>
>> I got typo3_src+dummy-4.2.0.zip from http://typo3.org/download/packages/
>>
>> I downloaded version 4.2.0
>>
>> then i extracted all the files to c:\project\typo3\
>>
>> went to http://localhost:8085/typo3/typo3/install.php
>>
>> In "2: Create new database (recommended):" filled typo3
>>
>> imported the database.
>>
>> Set the 123 steps was completed.  then i went to backend login and
>> used " (username may be: admin, password may be: password.)" but was
>> unsuccessful
>>
>> then went to the database and looked up the be_users table.  it had
>> zero records.  so i went to Database Analyser: and did "      Create
>> "admin" user" and
>> username: pritesh
>> password: pritesh and clicked the write to database
>>
>> it stats that
>> User created
>> Username: pritesh
>> Password: pritesh
>>
>> so i go back to the backend and login again using pritesh as username
>> and password but again no success.  I again checked the be_users table
>> and found zero records.
>>
>> CAN some one please help me.  I have read the documentations on
>> typo3.org but couldnt find any solution to my problem.  why cant i
>> login to backend.
>>
>> HELP needed.
>>
>> thanks
> _______________________________________________
> TYPO3-windows mailing list
> TYPO3-windows at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-windows
>