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

Tue Sep 11 14:21:33 CEST 2007

Hello Liviu,

First, which version of TYPO3 are you using. 

Second, as stated in my link to bug report. This problem is well known, and 
solved. And it's impossible to declare tables with default values for each 
field, and it doesn't solve any problems.The way it has been solved is to 
drop "Not null" for feilds who don't have any default value. It's even worse, 
in 5.x you can't use default values for fields of type TEXT and BLOB (and 
we have some of them). As long as TYPO3 installations are using different 
versions of MySQL, TYPO3 has to use statement who works on older versions to.

But as I wrote, I have no problem running on MySQL 5.x.

I had some problems on one Windows installation, because STRICT SQL MODE, 
who is impossible to use because of backwards compability to MySQL 4.x and 
a lot of different extensions. Most Linux installation don't use STRICT SQL 
MODE as standard. And as far as I know, you can choose it when installing 
on windows.

So the correct and easy solution is not to run mysql in STRICT SQL MODE, 
as you already has figured out. sql-mode="MYSQL40" is the best configuration. 
To get TYPO3 running om MySQL in STRICT SQL MODE is probably impossible, 
because of the share number of extensions who has to be checked and changed.

> 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
>> ********************************************
WBR,
Erik Svendsen
www.linnearad.no