cancel
Showing results for 
Search instead for 
Did you mean: 
Troja
Level 14

MWG and PostgreSQL failed

Hi all,

has anyone experience with MWG and postgres??

I configured MWG to query a small PostgreSQL database just for a POC. Note, i´m a PostgreSQL dummy! :-)

1) the first error was

[2015-09-03 14:39:05.544 +02:00] [ExternalListsFilterPlugin] [ExtListsError] Error in ExternalListsFilter: 'CDatabaseDataSource::Fetch: exception: Cannot establish connection to the database. could not open certificate file "/opt/mwg/.postgresql/postgresql.crt": No such file or directory FATAL: Ident authentication failed for user "postgres" FATAL: Ident authentication failed for user "postgres" '.

[2015-09-03 14:39:05.545 +02:00] [ExternalListsFilterPlugin] [ExtListsError] Error in ExternalListsFilter: 'CDatabaseDataSource::Fetch: SQL query: 'select * from "URLhost"''.

I modified the pg_hba.conf file and added the network where MWG is located.

2) Afterwards the changed the access rights.

[2015-09-03 15:09:31.534 +02:00] [ExternalListsFilterPlugin] [ExtListsError] Error in ExternalListsFilter: 'CDatabaseDataSource::Fetch: exception: ERROR: no access right Relation URLhost '.

[2015-09-03 15:09:31.534 +02:00] [ExternalListsFilterPlugin] [ExtListsError] Error in ExternalListsFilter: 'CDatabaseDataSource::Fetch: SQL query: 'select * from "URLhost"''.

3) I changed the login an i think the connection is now okay. But MWG shows this error.

[2015-09-03 15:25:23.229 +02:00] [ExternalListsFilterPlugin] [ExtListsError] Error in ExternalListsFilter: 'Error during data conversion'.

I changed the datatype in the database table to many different types, but nothing helps. Has anyone some information for me?

Cheers

0 Kudos