0 Replies Latest reply on Sep 3, 2015 8:34 AM by Troja

    MWG and PostgreSQL failed

    Troja

      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