[TYPO3-windows] installation problem

[Erik Svendsen]

Hello Liviu,

> Hi everybody,
> 
> I am a newbye to typo3 and I tried to install typo3 last stable
> version,testsite and quickstart.
> All is fine until I want to go to the backend admin page.
> I type user:admin and pass:password and I can't get acces.
> I created a new admin user, and tried to login as it.
> The same problem.
> I am using XP SP2,apache 2.2.4, php 5.2.3,mysql 5.0.45.
> I tried to connect with IE 6 and Firefox2.(I don't think that is a
> client
> side problem).
> Both are set to accept cookies from any site and have javascript
> enabled.
> Also, I 've configured the IUSR_machine acount as a member of POWER
> USERS
> group,which has plenty of rights.
> (By the way, can anybody tell me how can I manage filesystem acces in
> XP
> with a gui, such as in 2000/2003?)
> After a few attempts, apache crashed-in fact php- I found in the
> application
> log an entry saying that php5ts.dll was the cause.
> I am making the assumption that the problem might be with mysql.
> You see, mysql changed the way it stores password in version 4.1.1.
> Until then , it used a 16 byte hash.Since that version, it uses a 41
> byte
> hash.
> Can anyone tell me where exactly - in what table- the typo3 user
> accounts
> -both frontend and backend- are stored ?
> Thanks
>

First, as a newbie, you should try one of the installers. Look at http://typo3.org/download/installers/. 
I can recommend TYPO3 Winstaller. It also gives you all other programs needed. 
Before you try one of them, unistall apache, php and mysql from your computer. 
If not, you probably get problems.

The testsite and quickstart are made for version 3.8.1. And you should not 
use them. If you want to use them you have to upgrade the TYPO3 core as stated 
on the website. If you need a starter package, I can recommend the WEC Starter 
Package.

Second, IUSR_machine doesn't have any impact as you are using Apache. The 
rights for IUSR_machine are only important as long as you are using IIS 6 
as webserver. With one of the installers, you should not have any problems 
with the accessrights. You may have one problem, on my laptop install (TYPO3 
Winstaller), i have to use http://127.0.0.1:8080/ to open the site. You should 
also check if your IIS are running.

The MySQL problem is a TYPO3 3.8.1 problem, because the standard MySQL 5.x 
installation are using STRICT_TRANS (who aren't allowing making password 
from install tool). The password problem should not be any problem on a new 
installation (and I haven't had it on upgrades either). All of my TYPO3 installations, 
about 15 are running on MySQL 5.x. I have also had installations where MySQL 
has been upgraded from 4.0.x to 4.1.x and later to 5.x. Regarding to PHP 
5.2.3, there shouldn't be any problems as far as I know with TYPO3 4.1.2. 
TYPO3 Winstaller are using MySQL 4.1.21 though.

The tables for users are be_users and fe_users. 

You can also read this bug report (solved) http://bugs.typo3.org/view.php?id=2059 
(same as Nick Cohn refering to)

But I strongly advise not to use TYPO3 versions lower than 4.1.2 and 4.0.7. 
This is because of security issues.

Else, I have to say, that exept for my laptop install, I don't use TYPO3 
on windows any more. I have found the problems easier to handle on Linux 
servers.


WBR,
Erik Svendsen
www.linnearad.no