TYPO3 Mailingliste: nicht fragen - lesen!

Hello!
After I've installed TYPO3 using the source and dummy packages,
everything looks promising.
But when I try to login to the backend (BE), the following error message
occur:

"Your login attempt did not succeed. Make sure to spell your username
and password correctly, including upper/lowercase characters."


Here's what I have:

- CAUSE1: Wrong username or password. CHECKED. I've created several
admin users in Database Analyzer in the TYPO3 Install Tool, but the
error remains.

- CAUSE2: The be_users table remains empty after "Create "admin" user".
CHECKED. It remained empty! So, I created a few new users in be_users
table with phpMyAdmin v2.9.1.1 and tried to login with those, but the
problem still remains.

- CAUSE3: register_globals=on ? CHECKED. The parameter in the php.ini
file is by default set to OFF, which is in my case the correct one.

- CAUSE4: Cookies needs to be enabled. CHECKED. Cookies ARE enabled in
my browser (FireFox v2.0.0.1)

- CAUSE5: Some suggests that the problem is with session management,
since $_SESSION['login_challenge'] is empty.
(ttp://bugs.typo3.org/view.php?id=3056) I haven't dug deeper into this..

I've searched the mailing-lists, and googled the problem, but no
definite solution have been found.

Main and related software versions:
- TYPO3 v4.0.4
- Windows XP Service Pack 2
- Apache HTTP Server v2.2.3
- PHP v5.1.6
- MySQL v5.0.27
- ImageMagick v6.3.0_Q16,
- FreeType v2.1.10

If anyone has ANY ideas, please post them.


Thanks in advance,

Best Regards

Christo

_______________________________________________
TYPO3-install mailing list
TYPO3-install (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-install

Christo Romberg wrote:

> - CAUSE2: The be_users table remains empty after "Create "admin" user".
> CHECKED. It remained empty! So, I created a few new users in be_users
> table with phpMyAdmin v2.9.1.1 and tried to login with those, but the
> problem still remains.

Known problem when using mysql 5.x
Open the my.ini with your favourite editor and search for sql_mode=...
replace the whole line with
sql_mode="MYSQL40"
restart mysql and the creation of users should succeed.

--
MfG, Christian Welzel

GPG-Key: http://www.camlann.de/key.asc
Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15
_______________________________________________
TYPO3-install mailing list
TYPO3-install (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-install

Hi Christian!

Indeed, that was the cause! I replaced the whole "sql-mode" directive with
sql_mode="MYSQL40", and now I also can login to the BE.

Thanks so very much for giving the solution!

Best Regards.
Christo

----------------------------------------------------------------------------

Christian Welzel skrev:
> Christo Romberg wrote:
>
>
>> - CAUSE2: The be_users table remains empty after "Create "admin" user".
>> CHECKED. It remained empty! So, I created a few new users in be_users
>> table with phpMyAdmin v2.9.1.1 and tried to login with those, but the
>> problem still remains.
>>
>
> Known problem when using mysql 5.x
> Open the my.ini with your favourite editor and search for sql_mode=...
> replace the whole line with
> sql_mode="MYSQL40"
> restart mysql and the creation of users should succeed.
>
>

_______________________________________________
TYPO3-install mailing list
TYPO3-install (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-install