[TYPO3-install] TYPO3-install Digest, Vol 55, Issue 2

[Pritesh Chandra]

hi Dmitriy ,

yes.  the DB user was root.  Well, that one problem has been fixed.
But something else is not happening.

I turned off the MYSQL strict mode in my.ini to
# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

After changing the my.ini file, 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 Tue, May 27, 2008 at 10:00 PM,
<typo3-install-request at lists.netfielders.de> wrote:
> Send TYPO3-install mailing list submissions to
>        typo3-install at lists.netfielders.de
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-install
> or, via email, send a message with subject or body 'help' to
>        typo3-install-request at lists.netfielders.de
>
> You can reach the person managing the list at
>        typo3-install-owner at lists.netfielders.de
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of TYPO3-install digest..."
>
>
> Today's Topics:
>
>   1. Re: backend login fail on install (Dmitriy Osadchiy)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 27 May 2008 10:30:52 +0300
> From: Dmitriy Osadchiy <dmi3 at clarity.kiev.ua>
> Subject: Re: [TYPO3-install] backend login fail on install
> To: TYPO3 install list <typo3-install at lists.netfielders.de>
> Message-ID:
>        <mailman.2951.1211873452.4573.typo3-install at lists.netfielders.de>
> Content-Type: text/plain; charset=us-ascii
>
> Hello Pritesh,
>
> Did you enter DB user which has correct permissions?
>
> --
> Best regards,
>  Dmitriy                            mailto:dmi3 at clarity.kiev.ua
>
> Monday, May 26, 2008, 12:15:28 AM, you wrote:
>
> PC> hi there,
>
> PC> I have php 5, apache 2 and mysql 5 and windows XP.
>
> PC> configured apache port to have typo3 run on http://localhost:8085/typo3/
>
> PC> I got typo3_src+dummy-4.2.0.zip from
> PC> http://typo3.org/download/packages/
>
> PC> I downloaded version 4.2.0
>
> PC> then i extracted all the files to c:\project\typo3\
>
> PC> went to http://localhost:8085/typo3/typo3/install.php
>
> PC> In "2: Create new database (recommended):" filled typo3
>
> PC> imported the database.
>
> PC> Set the 123 steps was completed.  then i went to backend login and
> PC> used " (username may be: admin, password may be: password.)" but was
> PC> unsuccessful
>
> PC> then went to the database and looked up the be_users table.  it had
> PC> zero records.  so i went to Database Analyser: and did "      Create
> PC> "admin" user" and
> PC> username: pritesh
> PC> password: pritesh and clicked the write to database
>
> PC> it stats that
> PC> User created
> PC> Username: pritesh
> PC> Password: pritesh
>
> PC> so i go back to the backend and login again using pritesh as username
> PC> and password but again no success.  I again checked the be_users table
> PC> and found zero records.
>
> PC> CAN some one please help me.  I have read the documentations on
> PC> typo3.org but couldnt find any solution to my problem.  why cant i
> PC> login to backend.
>
> PC> HELP needed.
>
> PC> thanks
> PC> _______________________________________________
> PC> TYPO3-install mailing list
> PC> TYPO3-install at lists.netfielders.de
> PC> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-install
>
>
>
> ------------------------------
>
> _______________________________________________
> TYPO3-install mailing list
> TYPO3-install at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-install
>
> End of TYPO3-install Digest, Vol 55, Issue 2
> ********************************************
>