TYPO3 Board

andesig · Joined: 01 Dec 2005 Posts: 3

I get the following message when I try to login to back end with default settings after the 1-2-3 installation:

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

This is with a totally fresh local test installation of 3.8.1 Quickstart. Here are my versions, and yes I know they're bleeding edge but if anyone has any ideas I'd be grateful. I'm not expecting a fix, just hoping for some insight into where to look for a solution.

Windows XP SP2
Apache 2.0.55
MySQL 5.0.15
PHP 5.1.1

All my other CMS test sites work fine (J**la, e1*7, Xa**ya, OSCo****ce etc). If anyone knows whether the problem is likely to be PHP, Apache, MySQL or my stupidity (be gentle with me) I'd be grateful.

shadowdragon · Joined: 08 Dec 2005 Posts: 3

I am facing the exact same problem and have been searching the net like crazy, I also have the same version of apache,windows and mysql. my php version is 5.0.5. Everything else works fine. I hope the admin here can solve the problem

I have also noticed that if I try to create a new admin user from the installation, the new user is not entered in the database. the default user: admin and pass:password is not working. I have tried other users in the db(there seems to be 3 more) but I can't login.

steveo · Joined: 13 Oct 2005 Posts: 86

http://www.typo3board.com/fpost153.html#153

shadowdragon · Joined: 08 Dec 2005 Posts: 3

I check the http referer thing and no difference.

As for the file system thing, I am on windows xp so no such problems

mrmiles · Joined: 08 Dec 2005 Posts: 2

hi everyone,

i am experiencing a similar problem. i installed the quickstart package (install B for windows) and upon reaching the point where i am to log in to the backend, nothing seems to happen. i set a new admin user, to no avail.

i am at a loss as to what is going wrong. i have cookies and java enabled.

i am a total newbie at typo3 and bid forgiveness if i oversaw some obvious configuration (to my knowledge, i followed the installation steps to a tee)

regards,
M.

carrelet · Joined: 11 Oct 2005 Posts: 56

First of all, my recommendation: Don't use MySQL 5...

try this:
1. Ensure you have empty database.

2. Go to t3lib/stddb/ and import tables.sql using `mysql` command line
utility manually.

3. Go to install tool (/typo3/install/) and select COMPARE for the
database and update database. This will properly update existing tables
and add a number of new ones. Import static data.

4. Create admin user using install tool.

5. Login to BE.

shadowdragon · Joined: 08 Dec 2005 Posts: 3

I think the problem is with mysql 5, I installed 4.1 and everything is working great.

Also if you are facing more problems try using phperl3.0. It has apache,php and mysql all integrated perfectly. here's the link for download http://phperl2.sourceforge.net/

mrmiles · Joined: 08 Dec 2005 Posts: 2

thanks a bunch shadowdragon!

phperl works a charm!

carrelet, i tried what you suggested, yet i fear my limited knowledge in this area prevented me from success.

again many thanks

regards,
M.

andesig · Joined: 01 Dec 2005 Posts: 3

Does anyone know if the upcoming version 4 will support MySQL5?

rengucha · Joined: 27 Dec 2005 Posts: 4 Location: Detroit MI

Hi All

I also went through the same pains in getting 3.8 working with mysql 5. Then
I started going back in mysql versions.

Finally had success with mySQL 4.1 PHP4.4.1 Apache 2.0.55(win32)

Thanks

qwallis · Joined: 03 Mar 2006 Posts: 7 Location: Germany

Assuming that you are using the correct login details and you are using a new version of MySql, then it will most likely be caused by password hashing changes.

Quote from MySql5 docs:
“The password hashing mechanism was updated in MySQL 4.1 to provide better security and to reduce the risk of passwords being intercepted. However, this new mechanism is understood only by MySQL 4.1 (and newer) servers and clients, which can result in some compatibility problems. A 4.1 or newer client can connect to a pre-4.1 server, because the client understands both the old and new password hashing mechanisms. However, a pre-4.1 client that attempts to connect to a 4.1 or newer server may run into difficulties.”

You can change this on a user basis, but the easiest fix is to add:

old_passwords

to the mysql config file (normally my.ini in the folder MySql was installed to).
Just add it in the “# SERVER SECTION”

When I tried this originally, the information I found said just to stop and re-start the server etc, but as I understand it, it makes the server use the “old” hashing system on the passwords as they are set up, so I didn’t have any luck until I re-entered the password in mysql (tip: using the MySql Administrator tool makes everything a shed load easier if you are not used to entering mysql commands at the command line level.

imhbl · Joined: 19 Jun 2006 Posts: 1

Hello,

I've got similar problems and found out what it was. Information acout "incorrect login/password" is misleading. In my case the problem was with mysql (I use mysql5). I found out that insert to table be_sessions throws an error while having ses_data marked as not null without default value. When I switched this field to nullable, I could log in.

The problem comes there again while saving new pages - because table TT_content also has many blob/text fields without default value

Hope this helps.

Jakub