#1 ketl_ctrl cannot connect to Postgres

[Marcus Baker]

Hi.

Installed Postgres 8.1 on Linux (Centos 4, 64bit).

When connecting I get the following errors...

[ERROR]Thu Mar 22 17:08:50 GMT 2007 - [KETL Console] Error getting parameter list (ID = $INTERNAL): ERROR: relation "parameter_list" does not exist
checkConnection connection closed for reason unknown
[ERROR]Thu Mar 22 17:08:50 GMT 2007 - [com.kni.etl.Metadata@3411a] Error getting parameter list (name = CHECK): ERROR: relation "parameter" does not exist
checkConnection connection closed for reason unknown
[ERROR]Thu Mar 22 17:08:50 GMT 2007 - [KETL Console] Error getting parameter list (ID = $INTERNAL): ERROR: relation "parameter_list" does not exist
checkConnection connection closed for reason unknown
[ERROR]Thu Mar 22 17:08:50 GMT 2007 - [com.kni.etl.Metadata@3411a] Error getting parameter list (name = CHECK): ERROR: relation "parameter" does not exist
[INFO]Thu Mar 22 17:08:50 GMT 2007 - [Thread[KETL Console,5,main]] Creating new parameter $INTERNAL.CHECK
ERROR: Connecting to metadata - An I/O error occured while sending to the backend.

I can connect with JDBC without problem. Here is the metadata file...

<SERVERS DEFAULTSERVER="lala">

<SERVER NAME="lala">

    <USERNAME>ketlmd</USERNAME>

    <PASSWORD>ketlmd</PASSWORD>

    <NETWORKNAME>lala</NETWORKNAME>

    <DRIVER>org.postgresql.Driver</DRIVER>

    <PRESQL>set search\_path = 'ketlmd'</PRESQL>

    <URL>jdbc:postgresql://localhost/postgres?prepareThreshold=1</URL>

    <MDPREFIX></MDPREFIX>

    <PASSPHRASE>ZATXO+7vBD7k9uicS/JOlBtsuscFIA8bpWBHZcHYNrc=</PASSPHRASE>

</SERVER>

<SERVER NAME="localhost">

    <USERNAME>ketlmd</USERNAME>

    <PASSWORD>ketlmd</PASSWORD>

    <NETWORKNAME>localhost</NETWORKNAME>

    <DRIVER>org.postgresql.Driver</DRIVER>

    <PRESQL>set search\_path = 'ketlmd'</PRESQL>

    <URL>jdbc:postgresql://localhost/postgres?prepareThreshold=1</URL>

    <MDPREFIX></MDPREFIX>

    <PASSPHRASE>ZATXO+7vBD7k9uicS/JOlBtsuscFIA8bpWBHZcHYNrc=</PASSPHRASE>

</SERVER>

<SERVER NAME="localhostPG">

    <USERNAME>ketlmd</USERNAME>

    <PASSWORD>ketlmd</PASSWORD>

    <NETWORKNAME>localhost</NETWORKNAME>

    <DRIVER>org.postgresql.Driver</DRIVER>

    <PRESQL>set search\_path = 'ketlmd'</PRESQL>

    <URL>jdbc:postgresql://localhost/postgres?prepareThreshold=1</URL>

    <MDPREFIX></MDPREFIX>

    <PASSPHRASE>ZATXO+7vBD7k9uicS/JOlBtsuscFIA8bpWBHZcHYNrc=</PASSPHRASE>

</SERVER>

<SERVER NAME="localhostOR">

    <USERNAME>ketlmd</USERNAME>

    <PASSWORD>ketlmd</PASSWORD>

    <NETWORKNAME>localhost</NETWORKNAME>

    <DRIVER>oracle.jdbc.driver.OracleDriver</DRIVER>

    <URL>jdbc:oracle:thin:@localhost:1521:xe</URL>

    <MDPREFIX></MDPREFIX>

    <PASSPHRASE>ZATXO+7vBD7k9uicS/JOlBtsuscFIA8bpWBHZcHYNrc=</PASSPHRASE>

</SERVER>

</SERVERS>

Obviously I've sanitised the passwords. The KETL metadata is in a database ketlmd, schema is ketlmd.

Any ideas on how to proceed?

yours, Marcus

[Nobody/Anonymous]

Logged In: NO

It looks like you didn't run the metadata creation scripts.
Checkout the scripts in $KETLDIR/setup.

Here is a link to them in SVN.

http://ketl.svn.sourceforge.net/viewvc/ketl/KETLBuild/setup/PostgreSQL_metadata_repository/

[Nobody/Anonymous]

Logged In: NO

We did also find a problem with the default server option, which we just fixed. The default server wasn't being chosen under some circumstances.