Health status of this list is not showing. about pi-hole-for-android HOT 23 CLOSED

Updating sqlite3 and reinstalling Pi-hole seems to have fixed the issue. My RPM's are here

from pi-hole-for-android.

No need to restart pi-hole. Update the RPMs and run pihole -g. Web-UI shows the icons and status fine now.

from pi-hole-for-android.

No idea, but that's a lot of lists. Does it exhibit the same issue when you only have one list?

from pi-hole-for-android.

No idea, but that's a lot of lists. Does it exhibit the same issue when you only have one list?

Yes, the same even with one list.

from pi-hole-for-android.

Can confirm there's no status shown here. Only happening on this image/snapshot and doesn't happen if pi-hole is installed normally on a VM/Rpi/Linux Deploy (Debian/Ubuntu) etc.

from pi-hole-for-android.

Hello., Can you confirm the date and time are correct on your Android device?

from pi-hole-for-android.

Yes, definitely it's network synced.

from pi-hole-for-android.

Hello., Can you confirm the date and time are correct on your Android device?

Yes, date and time is correct.

from pi-hole-for-android.

Confirmed on my lab machine - This is an issue.

Does anyone know if this is happening on non-containerized CentOS 7 as well?

from pi-hole-for-android.

I can check that for you. Give me some time...

from pi-hole-for-android.

Happens on x86 as well. Seems like an upstream issue.

from pi-hole-for-android.

That's great. Is reinstalling pi-hole a must?

from pi-hole-for-android.

Not sure, you can give it a try. I was pretty heavy-handed with it, just ran p4a-install and let it do its thing.

from pi-hole-for-android.

Nice. What is the proper way to update sqlite3?

from pi-hole-for-android.

@DesktopECHO Okay, I'll try that on another device later. Don't wanna mess up my working instance right now.

from pi-hole-for-android.

Nice. What is the proper way to update sqlite3?

Just update the RPMs using rpm -Uvh sqlite*.rpm

from pi-hole-for-android.

Nice. What is the proper way to update sqlite3?

Download sqlite-libs-3.36.0-4.el7.armv7hl.rpm and sqlite-3.36.0-4.el7.armv7hl.rpm and install with rpm -Uvh

from pi-hole-for-android.

Happens on x86 as well. Seems like an upstream issue.

Thanks Ashish for verifying this!

from pi-hole-for-android.

@DesktopECHO Thank you for quickly identifying the fix. Seems like centos 7 is showing its age now. But then what choice do we have on kernel 3.0.x...

from pi-hole-for-android.

Download sqlite-libs-3.36.0-4.el7.armv7hl.rpm and sqlite-3.36.0-4.el7.armv7hl.rpm and install with rpm -Uvh

I'm getting "not an rpm package (or package manifest)" when trying to install those 2 packages.

from pi-hole-for-android.

How did you download the RPM’s? Can you show a list of the files and their sizes please?

from pi-hole-for-android.

How did you download the RPM’s? Can you show a list of the files and their sizes please?

Never mind, doing it like this worked perfectly:
rpm -Uvh https://github.com/DesktopECHO/CentOS7-ARMv7/raw/main/sqlite-libs-3.36.0-4.el7.armv7hl.rpm
rpm -Uvh https://github.com/DesktopECHO/CentOS7-ARMv7/raw/main/sqlite-3.36.0-4.el7.armv7hl.rpm

Not sure why it would not work if I downloaded the file first.

from pi-hole-for-android.

@DesktopECHO Thank you for quickly identifying the fix. Seems like centos 7 is showing its age now. But then what choice do we have on kernel 3.0.x...

Indeed! I'm glad they are still supporting CentOS 7 but I suspect this will be a recurring issue as it ages.

Are you sure you want to close Pi-hole #4580? This issue affects Ubuntu 16.04 as well, and I'm thinking the 'more correct' thing to do is fix this issue the same way Git was dealt with (in other words, make Pi-hole work with older versions of sqlite3 rather than requiring a library outside of the CentOS/EPEL/Remi repos.)

from pi-hole-for-android.