Thread: Re: How to install login_hook in Postgres 10.5

Re: How to install login_hook in Postgres 10.5

From
pavan95
Date:
Hello Community,

While I was searching for logon trigger in postgres similar to that of
Oracle, I came across "login_hook", which can be installed as a  Postgres
database extension to mimic a logon trigger.

But I tried to install but failed. Error is that it could not find its .so
file.  Could you please help me in installing this login_hook ??

Looking forward to hear from you. Any suggestions would be of great help!

Thanks & Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html



Re: How to install login_hook in Postgres 10.5

From
legrand legrand
Date:
Hello,

This extension https://github.com/splendiddata/login_hook
seems very interesting !
But I didn't test it myself and maybe the best place to ask 
support is there
https://github.com/splendiddata/login_hook/issues

For information there is something equivalent in core
"[PATCH] A hook for session start"
https://www.postgresql.org/message-id/flat/20171103164305.1f952c0f%40asp437-24-g082ur#d897fd6ec551d242493815312de5f5d5

that finished commited
"pgsql: Add hooks for session start and session end"

https://www.postgresql.org/message-id/flat/575d6fa2-78d0-4456-8600-302fc35b2591%40dunslane.net#0819e315c6e44c49a36c69080cab644d

but was finally rollbacked because it didn't pass installcheck test
...

Maybe you are able to patch your pg installation, 
it would be a solution of choice (there is a nice exemple 
of extension included)

Showing interest for this may also help getting this feature back ;o)

Regards
PAscal




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html



Re: How to install login_hook in Postgres 10.5

From
Michael Paquier
Date:
On Mon, May 13, 2019 at 01:06:10PM -0700, legrand legrand wrote:
> that finished commited
> "pgsql: Add hooks for session start and session end"
>
https://www.postgresql.org/message-id/flat/575d6fa2-78d0-4456-8600-302fc35b2591%40dunslane.net#0819e315c6e44c49a36c69080cab644d
>
> but was finally rollbacked because it didn't pass installcheck test
> ...
>
> Maybe you are able to patch your pg installation,
> it would be a solution of choice (there is a nice exemple
> of extension included)

You will need to patch Postgres to add this hook, and you could
basically reuse the patch which has been committed once.  I don't
think that it would be that much amount of work to get it working
correctly on the test side to be honest, so we may be able to get
something into v13 at this stage.  This is mainly a matter of
resources though, and of folks willing to actually push for it.
--
Michael

Attachment

Re: How to install login_hook in Postgres 10.5

From
Joe Conway
Date:
On 5/13/19 8:32 PM, Michael Paquier wrote:
> On Mon, May 13, 2019 at 01:06:10PM -0700, legrand legrand wrote:
>> that finished commited
>> "pgsql: Add hooks for session start and session end"
>>
https://www.postgresql.org/message-id/flat/575d6fa2-78d0-4456-8600-302fc35b2591%40dunslane.net#0819e315c6e44c49a36c69080cab644d
>>
>> but was finally rollbacked because it didn't pass installcheck test
>> ...
>>
>> Maybe you are able to patch your pg installation,
>> it would be a solution of choice (there is a nice exemple
>> of extension included)
>
> You will need to patch Postgres to add this hook, and you could
> basically reuse the patch which has been committed once.  I don't
> think that it would be that much amount of work to get it working
> correctly on the test side to be honest, so we may be able to get
> something into v13 at this stage.  This is mainly a matter of
> resources though, and of folks willing to actually push for it.


I am interested in this, so if Andrew wants to create a buildfarm module
I will either add it to rhinoceros or stand up another buildfarm animal
for it. I am also happy to help push it for v13.

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


Attachment

Re: How to install login_hook in Postgres 10.5

From
Andrew Dunstan
Date:
On 5/14/19 8:34 AM, Joe Conway wrote:
> On 5/13/19 8:32 PM, Michael Paquier wrote:
>> On Mon, May 13, 2019 at 01:06:10PM -0700, legrand legrand wrote:
>>> that finished commited
>>> "pgsql: Add hooks for session start and session end"
>>>
https://www.postgresql.org/message-id/flat/575d6fa2-78d0-4456-8600-302fc35b2591%40dunslane.net#0819e315c6e44c49a36c69080cab644d
>>>
>>> but was finally rollbacked because it didn't pass installcheck test
>>> ...
>>>
>>> Maybe you are able to patch your pg installation, 
>>> it would be a solution of choice (there is a nice exemple 
>>> of extension included)
>> You will need to patch Postgres to add this hook, and you could
>> basically reuse the patch which has been committed once.  I don't
>> think that it would be that much amount of work to get it working
>> correctly on the test side to be honest, so we may be able to get
>> something into v13 at this stage.  This is mainly a matter of
>> resources though, and of folks willing to actually push for it.
>
> I am interested in this, so if Andrew wants to create a buildfarm module
> I will either add it to rhinoceros or stand up another buildfarm animal
> for it. I am also happy to help push it for v13.
>


I've just been looking at this again. I think the right way to test it
is not to use the regression framework but to use a TAP test that would
preload the test module. Then it would just happen as part of all the
other TAP tests with no extra buildfarm module needed.


cheers


andrew


-- 
Andrew Dunstan                https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services




Re: How to install login_hook in Postgres 10.5

From
legrand legrand
Date:
Hello,

shouldn't we update associated commitfest entry
https://commitfest.postgresql.org/15/1318/

to give it a chance to be included in pg13 ?

Regards
PAscal



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html



Re: How to install login_hook in Postgres 10.5

From
Michael Paquier
Date:
On Thu, Aug 01, 2019 at 05:01:17AM -0700, legrand legrand wrote:
> Shouldn't we update associated commitfest entry
> https://commitfest.postgresql.org/15/1318/
>
> to give it a chance to be included in pg13 ?

Well, it is mainly a matter of finding somebody willing to do the
legwork, in which case I would let the past commit fest entry as it
is, and create a new one once a new patch is ready to be reviewed.
--
Michael

Attachment

Re: How to install login_hook in Postgres 10.5

From
legrand legrand
Date:
pavan95 wrote
> Hello Community,
> 
> While I was searching for logon trigger in postgres similar to that of
> Oracle, I came across "login_hook", which can be installed as a  Postgres
> database extension to mimic a logon trigger.
> 
> But I tried to install but failed. Error is that it could not find its .so
> file.  Could you please help me in installing this login_hook ??
> 
> Looking forward to hear from you. Any suggestions would be of great help!
> 
> Thanks & Regards,
> Pavan
> 
> 
> 
> --
> Sent from:
> http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

issue
ERROR:  could not access file "login_hook.so": No such file or directory
has been fixed see:
https://github.com/splendiddata/login_hook/issues/1

Regards
PAscal



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html