[TYPO3-linux] Typo3 - PostGres

linux at dyntronix.de linux at dyntronix.de
Wed Aug 16 14:12:07 CEST 2006


Hello,
I want to install typo3 4.01 with a postgres 8 db. I have a Apache 2 and PHP
 5 running.

I installed and linked the adodb an dbal so that connectioncheck accepts the
connection.

while trying to create the tables using
the /var/www/dummy-4.0.1/typo3_src-4.0.1/t3lib/stddb/tables.sql
errors occured although I changed the data types (int(11) => int8 etc..).
So I just insert the table: be_sessions and be_users.
be_users had an entry which was called Key parent (uid) ... I deleted this
entry because it wasn't accepted.

now the following error occurs while calling localhost/typo3:

Warning: pg_query() [function.pg-query]: Query failed: FEHLER:
Relation »be_sessions« existiert nicht
in
 /var/www/typo3_src-4.0.1/typo3/sysext/adodb/adodb/drivers/adodb-postgres7.in
c.php on line 115

Although the table exists.

I have entered the following stuff in the localconf :

$TYPO3_CONF_VARS['EXT']['extList']
=
 'adodb,dbal,tsconfig_help,context_help,extra_page_cm_options,impexp,sys_note
,tstemplate,tstemplate_ceditor,tstemplate_info,tstemplate_objbrowser,tstempla
te_analyzer,func_wizards,wizard_crpages,wizard_sortpages,lowlevel,install,bel
og,beuser,aboutmodules,setup,taskcenter,info_pagetsconfig,viewpage,rtehtmlare
a,css_styled_content,t3skin';

$TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array (
'_DEFAULT' => array(
'type' => 'adodb',
'config' => array(
'username' => 'typotest',
'password' => '&typotest',
'host' => '192.168.2.107',
'database' => 'typo3',
'driver' => 'postgres8'
)
)
);

$typo_db_username = 'typotest';
$typo_db_password = '&typotest';
$typo_db_host = '192.168.2.107';

so everything should work.
what have I done wrong.
can anyone give me a hint, or an SQL file which creates the db strcutre?


thx

-------------------------------------------------------



More information about the TYPO3-linux mailing list