I am trying to connect the hivemq ese to my postgres database and am getting the following error. The config file seems to match what you recommend. Here is the error list: 2023-07-30 23:13:49,812 INFO - Starting HiveMQ Enterprise Security Extension. 2023-07-30 23:13:49,826 INFO - Access log is…

Hi @brianstjean Welcome to the HiveMQ Community! We are pleased to see your interest in MQTT and the HiveMQ broker. Your presence is greatly appreciated. In your recent message, you mentioned that your config file appears to align with our recommendations. However, we were unable to locate the spe…

Dasha, Thanks for your reply, I have attached my config.xml. I have confirmed that the user and database are running and I was able to run the postgressql_create.sql and then the insert sql files to create default permissions and default roles. Thanks, Brian (Attachment config.xml is missing)

The system won’t let me send attachements so here is the text dump of the config.xml file. I am able to connect to the database using pgAdmin4 and look at the tables created. <?xml version="1.0" encoding="UTF-8" ?> <enterprise-security-extension xmlns:xsi= http://www.w3.org/2001/XMLSchema-instance …

Hi @brianstjean , Sorry, your XML is in unreadable form: [image] I suggest you quote your XML with triple ticks ``` to make it readable :slight_smile: Anyway, since you have pgAdmin, you can simply go to the menu, open the Query Tool (Menu → Tools → Query tool), and run the following query to c…

Dasha, Yes it is showing the hivemq user and the current_user. Brian

Yes the current user and password are correct. Here is the error log that is shown when I remove the ‘DISABLED’ file. 2023-07-31 14:19:27,759 DEBUG - username…“hivemq” 2023-07-31 14:19:27,759 DEBUG - validationTimeout…5000 2023-07-31 14:19:27,760 INFO - com.hivemq.extensions.ese.postgres.postgres…

Hey @brianstjean , Is HiveMQ broker running in a Docker container or directly on a Linux machine? Are there any special characters in the PASSWORD? Verify that your connection to the db succeeds when using the same username and password as in the config.xml. You can use psql command (you need to t…

Thanks Dasha, I discovered it was an issues with the pg_hba.conf file. I have it working now. Brian

ESE not connecting to postgres database

HiveMQ Extensions

Daria_H August 1, 2023, 7:18am 10

Hi @brianstjean,

Well done! If you need any further assistance, feel free to reach out.

Thank you and have a great day!

Best regards,
Dasha from HiveMQ Team

Topic		Replies	Views
Enterprise Security Extension SQL Auth HiveMQ Extensions	1	493	June 12, 2023
Cannot remove DISABLED file from ESE HiveMQ Extensions	5	535	August 20, 2023
Enterprise security extension sql based realm does not work, the broker allows unauthenticated users and unauthorized clients to publish/subscribe topics	26	743	November 29, 2023
I have 2 issues HiveMQ Commercial Offerings	7	865	September 16, 2022
How can I force reload hivemq ESE HiveMQ Extensions	9	629	September 26, 2023

ESE not connecting to postgres database

Related topics