[TYPO3-windows] TYPO3-windows Digest, Vol 47, Issue 3

Tue Sep 11 13:01:57 CEST 2007

Thank you guys for your suppport.
The problem was (or was it?) with mysql.
My instalation of mysql has had STICT SQL MODE enabled in the configuration
file, my.ini.
Because of this fact, the installation of be_users data failed.
I executed a SELECT * FROM BE_USERS statement and i got an empty set.
I executed an INSERT INTO BE_USERS (USERNAME,PASSWORD) VALUES
('LIVIU','COLDPLAY') statement that
failed because the usergroup field did not have a default value.
*So the reason is in how the table is declared, not with mysql*.
However,I edited the my.ini file and commented out the line which enables
STRICT SQL MODE, then
I restarted mysql.
I executed again INSERT INTO BE_USERS (USERNAME,PASSWORD) VALUES
('LIVIU','COLDPLAY') ,this time
without error,then I succeded to login as LIVIU.
I hope that the people in charge will acknowledge this and will make the
necessary chnge in the
way the ables are declared(specifically, the tables should be declared with
default values for each field).
Thank again

Regards,
Liviu Macoviciuc

On 9/11/07, typo3-windows-request at lists.netfielders.de <
typo3-windows-request at lists.netfielders.de> wrote:
>
> Send TYPO3-windows mailing list submissions to
>        typo3-windows at lists.netfielders.de
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-windows
> or, via email, send a message with subject or body 'help' to
>        typo3-windows-request at lists.netfielders.de
>
> You can reach the person managing the list at
>        typo3-windows-owner at lists.netfielders.de
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of TYPO3-windows digest..."
>
>
> Today's Topics:
>
>   1. Re: installation problem (Liviu Macoviciuc) (Nick Cohn)
>   2. Re: installation problem (Erik Svendsen)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 10 Sep 2007 22:51:15 +0200
> From: "Nick Cohn" <nickcohn at gmail.com>
> Subject: Re: [TYPO3-windows] installation problem (Liviu Macoviciuc)
> To: <typo3-windows at lists.netfielders.de>
> Message-ID:
>        <mailman.3420.1189457467.17142.typo3-windows at lists.netfielders.de>
> Content-Type: text/plain;       charset="us-ascii"
>
> Liviu,
>
> When I installed typo3 (more than a year ago now) I had the same problem.
> It
> turned out that typo3 just doesn't work with MySQL 5+. See:
> http://bugs.typo3.org/view.php?id=2059 . This may have been solved in
> newer
> versions - I don't know...  I run:
>
> Typo3 3.4
> ImageMagick 4.2.8
> PHP 5.1.2
> MySQL 4.0.28
> Http server: IIS 6
> On Windows Server 2003
>
> and it runs perfectly. I originally installed Typo3 4.0 but found that the
> image processing didn't work correctly, so I went back to 3.4. With 3.4 I
> did have to try different settings for image processing but I got it
> sorted
> out in the end.
>
> I also had problems logging in to Install Tool. I found that giving the
> password via:
>
> <domain name or ip address>/typo3/install/index.php?password=<your
> password>
>
> allowed me to bypass the login page.
>
> Good luck!
>
> Nick Cohn
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 10 Sep 2007 22:00:59 +0000 (UTC)
> From: Erik Svendsen <erik at linnearad.no>
> Subject: Re: [TYPO3-windows] installation problem
> To: typo3-windows at lists.netfielders.de
> Message-ID:
>        <mailman.1.1189461656.13079.typo3-windows at lists.netfielders.de>
> Content-Type: text/plain; charset=windows-1252; format=flowed
>
> 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
>
>
>
>
> ------------------------------
>
> _______________________________________________
> TYPO3-windows mailing list
> TYPO3-windows at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-windows
>
> End of TYPO3-windows Digest, Vol 47, Issue 3
> ********************************************
>