[TYPO3-dev] TYPO3 on PostgreSQL experiances

[ries van Twisk]

As promised my experience to installed TYPO3 on PostgreSQL.

Basically I follow the installation manual on these site:

http://typo3.org/documentation/document-library/extension-manuals/dbal/0.9.9/view/1/4/

Modifying the localconf.php is relative painless and it connects to  
PostgreSQL (8.2) right away:

I will in my username/password and select my (already created)  
database (UTF-8)

First I hit this error:

ERROR: Query could not be parsed: "SQL engine parse ERROR: Still  
content in clause after parsing!: near "ENGINE=InnoDB "". Query:  
"CREATE TABLE cache_hash ( hash varchar(32) DEFAULT '' NOT NULL,  
content mediumblob NOT NULL, tstamp int(11) unsigned DEFAULT '0' NOT  
NULL, ident varchar(20) DEFAULT '' NOT NULL, PRIMARY KEY (hash) )  
ENGINE=InnoDB;"

Since InnoDB is vendor specific, I have to remove these entries, and  
can only be done from command line or using 'some' tool. So I remove  
the InnoDB  declaration.

Reloaded the page...

After that I get this message:

Warning: Invalid argument supplied for foreach() in /Users/rvt/Sites/ 
typo3_src-4.1.6/typo3/sysext/adodb/adodb/adodb-datadict.inc.php on  
line 266

Warning: Cannot modify header information - headers already sent by  
(output started at /Users/rvt/Sites/typo3_src-4.1.6/typo3/sysext/adodb/ 
adodb/adodb-datadict.inc.php:266) in /Users/rvt/Sites/typo3_src-4.1.6/ 
typo3/sysext/install/mod/class.tx_install.php on line 3644


After a other reload... I don't get that message anymore, so I am not  
sure what's the cause...



Checking the database I see 38 tables created, i didn't check if all  
types where properly created.

Logging in with on http://127.0.0.1/~rvt/pgtest/typo3/alt_main.php  
with admin/password just works

Create pages seems to work
Creating templates seems to work:


Clicking Task Center gives this:

Warning: Invalid argument supplied for foreach() in /Users/rvt/Sites/ 
typo3_src-4.1.6/typo3/sysext/dbal/class.ux_t3lib_db.php on line 968

Warning: Cannot modify header information - headers already sent by  
(output started at /Users/rvt/Sites/typo3_src-4.1.6/typo3/sysext/dbal/ 
class.ux_t3lib_db.php:968) in /Users/rvt/Sites/typo3_src-4.1.6/typo3/ 
template.php on line618

Warning: Invalid argument supplied for foreach() in /Users/rvt/Sites/ 
typo3_src-4.1.6/typo3/sysext/dbal/class.ux_t3lib_db.php on line 968

Downloading a new extension list works fine...


Installing tt_news brings me:

The running TYPO3 version (4.1.6) is higher than allowed (3.8.1)
      Ignore this version requirement

The running PHP version (5.2.4) is higher than allowed (5.0.5)
      Ignore this version requirement

going to ignore that


This is interesting because an 2.5.2 is available on TER, however  
2.2.24 was installed..



Going to install a other extension, this time RealURL:
Version 1.1.0 is going to be offered to be installed (funny because  
1.3.1 is available on TER):

During installation I get:
Warning: Invalid argument supplied for foreach() in /Users/rvt/Sites/ 
typo3_src-4.1.6/typo3/sysext/adodb/adodb/adodb-datadict.inc.php on  
line 266

Warning: Cannot modify header information - headers already sent by  
(output started at /Users/rvt/Sites/typo3_src-4.1.6/typo3/sysext/adodb/ 
adodb/adodb-datadict.inc.php:266) in /Users/rvt/Sites/typo3_src-4.1.6/ 
typo3/mod/tools/em/class.em_index.php on line 1939
Extension Manager
Extension: RealURL: URLs like normal websites (realurl)



I didn't test if these extensions actually work, but it looks like  
core TYPO3 seems reasonable works,
hurraay!! This is much better then the last time I tried (honestly it  
was already quite some time ago).
I will do that later, stay tuned.


As a side note...
One suggestion I would like to make is remove the reviewed extensions  
option in TER and just show the latest versions.
The reason I say this is because this is a security risk, TYPO3 offers  
old software that might be prone to SQL injects, X-Scripting and what  
not.
The note Enable extensions without review (basic security check) is  
quite misleading for new people.


Ries




Ries van Twisk
tags: Freelance TYPO3 JBoss JasperReports Flex Blaze-DS WebORB  
PostgreSQL DB-Architect
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk
Phone: + 1 810-476-4193