event_return not working ?

[Irving C]

Perhaps I'm missing something but once you enable event_return in the master should all events going forward be stored in the returner (in my case the postgres db)?  I'm using postgres but the salt_events table is empty?  If I run a command like salt '*' test.ping --return postgres that does return the results to salt_returns table however.  I see no errors in the master or minion log.  Any ideas?  

[Phipps, Thomas]

did you restart the master after you made the config change?

On Sat, Feb 13, 2021 at 11:00 AM Irving C <bc2...@gmail.com> wrote:

Perhaps I'm missing something but once you enable event_return in the master should all events going forward be stored in the returner (in my case the postgres db)?  I'm using postgres but the salt_events table is empty?  If I run a command like salt '*' test.ping --return postgres that does return the results to salt_returns table however.  I see no errors in the master or minion log.  Any ideas?  

--
You received this message because you are subscribed to the Google Groups "Salt-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to salt-users+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/salt-users/cf4e8d23-75bc-40f9-ae86-e4bd80c678c8n%40googlegroups.com.

[Irving C]

Yes I did.  Both the minion and master.  Here is the config on the master:

returner.postgres.host: 'localhost'

returner.postgres.user: 'salt'

returner.postgres.passwd: 'salt'

returner.postgres.db: 'salt'

returner.postgres.port: 5432

[Irving C]

Argh!  Sorry... here is the config:

event_return: postgres

returner.postgres.host: 'localhost'

returner.postgres.user: 'salt'

returner.postgres.passwd: 'salt'

returner.postgres.db: 'salt'

returner.postgres.port: 5432

[Phipps, Thomas]

i just noticed that you said `salt '*' test.ping --return postgres` works. that would imply the configuration is on the minion not the master. as --return happens minion side, not master side. 

where did you put the configuration?

To view this discussion on the web visit https://groups.google.com/d/msgid/salt-users/bc39de4e-caab-4880-bd4a-d67c11a12248n%40googlegroups.com.

[Phipps, Thomas]

Once confirmed that the config is in /etc/salt/master or a *.conf file in /etc/salt/master.d. You should increase the logging. it could be the master doesn't have psycopg2 installed, or some other thing like that.

To view this discussion on the web visit https://groups.google.com/d/msgid/salt-users/bc39de4e-caab-4880-bd4a-d67c11a12248n%40googlegroups.com.

[Irving C]

Actually I have it in both but on the minion there is no event_return .  I did have an issue with psycopg2 but did manage to fix that and the log no longer complains about it.  Let me try increasing the logging.   Thanks.