suggested working config to support Ubuntu 22.04

[itiligent]

Hi,

I've been doing a lot of testing in a bit of a niche this week - not sure if this is a pull request but I'll share to save others PAIN!

To enable the script to work on Ubuntu 22.04 we need to :

1. ensure libxslt1-dev libxml2 libxml2-dev are present.

2. we also need to downgrade Posgresql to version 13 at install. Here is a working config I've applied.... (this approach might also solve the kali postgresql issue I see in the comments?)

source /etc/os-release
if [[ $VERSION_CODENAME = "jammy" ]] || [[ $VERSION_CODENAME == "Some future realease" ]]; then
curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc|sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg
echo "deb http://apt.postgresql.org/pub/repos/apt/ lsb_release -cs-pgdg main" |sudo tee /etc/apt/sources.list.d/pgdg.list
apt-get update
apt-get -y install postgresql-13 postgresql-client-13 postgresql-contrib-13 postgresql-server-dev-all
else
apt-get -y install postgresql postgresql-client postgresql-contrib postgresql-server-dev-all
fi

I've had Ubuntu 22.04 / gvm 21.4.5 up and running on both raspi and x86 running a-ok for a day now with no issues with the above approach

[yu210148]

Thanks for the info and going through all that. It didn't occur to me that the posgres version would be a problem. Hopefully this helps folks in the future. Kev.

…

On Fri, Jul 15, 2022, 9:43 AM itiligent ***@***.***> wrote: Hi, I've been doing a lot of testing in a bit of a niche this week - not sure if this is a pull request but I'll share to save others PAIN! To enable the script to work on Ubuntu 22.04 we need to : 1. ensure libxslt1-dev libxml2 libxml2-dev are present. 2. we also need to downgrade Posgresql to version 13 at install. Here is a working config I've applied.... (this approach might also solve the kali postgresql issue I see in the comments?) Need to downgrade PostgreSQL with Ubuntu 22.04 and GVM 21.4.5 source /etc/os-release if [[ $VERSION_CODENAME = "jammy" ]] || [[ $VERSION_CODENAME == "Some future realease" ]]; then For Ubuntu 22.04 we need to downgrade to Postgresql 13 curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc|sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg echo "deb http://apt.postgresql.org/pub/repos/apt/ lsb_release -cs-pgdg main" |sudo tee /etc/apt/sources.list.d/pgdg.list apt-get update apt-get -y install postgresql-13 postgresql-client-13 postgresql-contrib-13 postgresql-server-dev-all else #Use the default repo packages apt-get -y install postgresql postgresql-client postgresql-contrib postgresql-server-dev-all fi I've had Ubuntu 22.04 / gvm 21.4.5 up and running on both raspi and x86 running a-ok for a day now with no issues with the above approach — Reply to this email directly, view it on GitHub <#87>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAKFY4KKMCNZ3JCMPISP4LDVUFTIZANCNFSM53VUTAUA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[itiligent]

No worries, it's a journey! Adding on since my last note I've found one issue with Ubuntu 22.04 that seems to happen only after several hours of running or after a day of updates. PGP keys seems to stop working which breaks the database connection, with pgp errors in the gvmd log . I have no idea why this would change only hours after install...perhaps after some update? The only way I can restore gvmd it to working and is to delete the gpg directory and it then recreates new keys on reboot .. but this might only delay the issue from coming back again. Still more work to do I think ! Cheers, Dave Sent from my iPhone On 16 Jul 2022, at 1:44 am, Kevin Lucas ***@***.***> wrote:  Thanks for the info and going through all that. It didn't occur to me that the posgres version would be a problem. Hopefully this helps folks in the future. Kev.

On Fri, Jul 15, 2022, 9:43 AM itiligent ***@***.***> wrote: Hi, I've been doing a lot of testing in a bit of a niche this week - not sure if this is a pull request but I'll share to save others PAIN! To enable the script to work on Ubuntu 22.04 we need to : 1. ensure libxslt1-dev libxml2 libxml2-dev are present. 2. we also need to downgrade Posgresql to version 13 at install. Here is a working config I've applied.... (this approach might also solve the kali postgresql issue I see in the comments?) Need to downgrade PostgreSQL with Ubuntu 22.04 and GVM 21.4.5 source /etc/os-release if [[ $VERSION_CODENAME = "jammy" ]] || [[ $VERSION_CODENAME == "Some future realease" ]]; then For Ubuntu 22.04 we need to downgrade to Postgresql 13 curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc|sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg echo "deb http://apt.postgresql.org/pub/repos/apt/ lsb_release -cs-pgdg main" |sudo tee /etc/apt/sources.list.d/pgdg.list apt-get update apt-get -y install postgresql-13 postgresql-client-13 postgresql-contrib-13 postgresql-server-dev-all else #Use the default repo packages apt-get -y install postgresql postgresql-client postgresql-contrib postgresql-server-dev-all fi I've had Ubuntu 22.04 / gvm 21.4.5 up and running on both raspi and x86 running a-ok for a day now with no issues with the above approach — Reply to this email directly, view it on GitHub <#87>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAKFY4KKMCNZ3JCMPISP4LDVUFTIZANCNFSM53VUTAUA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

— Reply to this email directly, view it on GitHub<#87 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AWTGATCXDQVBIGCXQEKW4TLVUGBPLANCNFSM53VUTAUA>. You are receiving this because you authored the thread.Message ID: ***@***.***>