Christian
I looks like the make has put the postgres xsl files into
/usr/local/share/openvas, whereas the system seems to be using
/usr/share/openvas.
Possibly something I did wrong with the build?
This was my build command:- cmake -DCMAKE_INSTALL_PREFIX=/usr
-DSYSCONFDIR=/etc -DLOCALSTATEDIR=/v
Hi,
On 24.04.2017 14:43, Roger Davies wrote:
> Thanks Christian
>
> Brilliant, I've found those in the source directory.
>
> I can't see the process for installing these though, so I'll assume that
> I just rename the _pg.xsl ones into the /usr/share/openvas/scap and cert
> directories.
>
> Roger
Thanks Christian
Brilliant, I've found those in the source directory.
I can't see the process for installing these though, so I'll assume that I
just rename the _pg.xsl ones into the /usr/share/openvas/scap and cert
directories.
Roger
2017-04-24 10:00 GMT+01:00 Christian Fischer <
christian.f
Hi,
On 18.04.2017 10:03, Roger Davies wrote:
> Hi
>
> Just wondering if someone has a Postgres equivalent of
> greenbonde-scapdata-sync and greenbone-certdata-sync.
>
> The xsl SQL uses 'INSERT OR REPLACE" which is sqllite specific, so I get
> an error when running them.
>
> Can't seem to find
Thanks Matthew
I'm not an SQL specialist, it's been a while since I did any SQL. but I'll
see what I can come up with.
I am using Postgres 9.5+, so the upsert suggestion is also useful.
Roger
2017-04-21 22:19 GMT+01:00 Matthew Hall :
> On Tue, Apr 18, 2017 at 09:03:49AM +0100, Roger Davies wro
On Tue, Apr 18, 2017 at 09:03:49AM +0100, Roger Davies wrote:
> Just wondering if someone has a Postgres equivalent of
> greenbonde-scapdata-sync and greenbone-certdata-sync.
>
> The xsl SQL uses 'INSERT OR REPLACE" which is sqllite specific, so I get an
> error when running them.
Hi Roger,
It w
It should be much easier by using postgres 9.5+
https://hashrocket.com/blog/posts/upsert-records-with-postgresql-9-5
Am 18.04.2017 10:04 AM schrieb "Roger Davies" :
> Hi
>
> Just wondering if someone has a Postgres equivalent of
> greenbonde-scapdata-sync and greenbone-certdata-sync.
>
> The xs
Hi
Just wondering if someone has a Postgres equivalent of
greenbonde-scapdata-sync and greenbone-certdata-sync.
The xsl SQL uses 'INSERT OR REPLACE" which is sqllite specific, so I get an
error when running them.
Can't seem to find anything online.
Thanks
Roger