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
i'm not familiar with cmake and postgresql but when having a look at the CMakeLists.txt shipped with the manager source package it looks like those files should be already copied and used correctly when installing OpenVAS and the postgresql backend. Regards, -- Christian Fischer | PGP Key: 0x54F3CE5B76C597AD Greenbone Networks GmbH | http://greenbone.net Neumarkt 12, 49074 Osnabrück, Germany | AG Osnabrück, HR B 202460 Geschäftsführer: Lukas Grunwald, Dr. Jan-Oliver Wagner > > 2017-04-24 10:00 GMT+01:00 Christian Fischer > <[email protected] <mailto:[email protected]>>: > > 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 anything online. > > most likely because both scripts and the .xls files are already > supporting Postgresql since quite some time and doesn't use INSERT OR > REPLACE when running Postgresql: > > > https://lists.wald.intevation.org/pipermail/openvas-commits/2014-October/020637.html > > <https://lists.wald.intevation.org/pipermail/openvas-commits/2014-October/020637.html> > > > https://lists.wald.intevation.org/pipermail/openvas-commits/2014-October/020601.html > > <https://lists.wald.intevation.org/pipermail/openvas-commits/2014-October/020601.html> > > So the question is why your environment is not using the Postgres > compatible .xls files > > Regards, > > -- > > Christian Fischer | PGP Key: 0x54F3CE5B76C597AD > Greenbone Networks GmbH | http://greenbone.net > Neumarkt 12, 49074 Osnabrück, Germany | AG Osnabrück, HR B 202460 > Geschäftsführer: Lukas Grunwald, Dr. Jan-Oliver Wagner > _______________________________________________ > Openvas-discuss mailing list > [email protected] > <mailto:[email protected]> > https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss > > <https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss> > > > > _______________________________________________ Openvas-discuss mailing list [email protected] https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss
