Send netdisco-users mailing list submissions to
netdisco-users@lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
netdisco-users-requ...@lists.sourceforge.net
You can reach the person managing the list at
netdisco-users-ow...@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Netdisco Psql custom command (Muris)
2. Re: Netdisco Psql custom command (Andy Ruhl)
--- Begin Message ---
Hi Oliver, I get this
[netdisco@ bin]$ psql
bash: psql: command not found
From: Oliver Gorwits <oli...@cpan.org>
Date: Sunday, 30 August 2020 at 06:55
To: Muris <alcat...@gmail.com>
Cc: "netdisco-users@lists.sourceforge.net"
<netdisco-users@lists.sourceforge.net>
Subject: Re: [Netdisco] Netdisco Psql custom command
Hi,
I guess my first question would be: can you run just "psql" by itself as the
netdisco user? Perhaps the netdisco user needs to be added to a group, if not.
Netdisco literally just calls "psql" as you would do, at the command line:
https://github.com/netdisco/netdisco/blob/master/lib/App/Netdisco/Worker/Plugin/Psql.pm#L39
regards,
oliver.
On Sat, 29 Aug 2020 at 00:24, Muris <alcat...@gmail.com> wrote:
Hi,
I am used to using this query to get a status of devices scanned within the
last 2 weeks, but since I upgraded to postgresql 12, it stopped working.
How can I make it work again?
[netdisco@]$ ./netdisco-do psql -e "select ip, name from device where creation
> now() - interval '2 weeks'"
info App::Netdisco version 2.046002 loaded.
info psql: started at Sat Aug 29 08:47:55 2020
Can't exec "psql": Permission denied at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Psql.pm line 39.
info psql: finished at Sat Aug 29 08:47:55 2020
info psql: status done: psql session closed.
Thankyou
_______________________________________________
Netdisco mailing list
netdisco-users@lists.sourceforge.net
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
On Mon, Aug 31, 2020 at 2:46 AM Muris <alcat...@gmail.com> wrote:
>
> Hi Oliver, I get this
>
>
>
> [netdisco@ bin]$ psql
>
> bash: psql: command not found
Usually the Postgres server and client packages are separate. It could
be that during the upgrade of the server, the client package was
removed. Please investigate how to re-install the Postgres client
package on your operating system.
Andy
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
