Error connecting to database, cannot repair

Same error. I tried pihole -r, still not working:

1 Like

ran debug but got error uploading?

"Gravity database not available" appears many times in tail of pihole-FTL.log

I ran pihole -r:

 [i] Existing PHP installation detected : PHP version 7.3.11-1~deb10u1                                                                              
  [i] Repair option selected                                                                                                                         
  [βœ“] Disk space check
  [βœ“] Update local cache of available packages
                                                                                                                                                     
  [βœ“] Checking apt-get for upgraded packages... up to date!
                                                                                                                                                     
  [i] Installer Dependency checks...                                                                                                                 
  [βœ“] Checking for dhcpcd5
  [βœ“] Checking for git
  [βœ“] Checking for iproute2
  [βœ“] Checking for whiptail
                                                                                                                                                     
  [i] SELinux not detected
  [i] Performing reconfiguration, skipping download of local repos                                                                                   
  [βœ“] Resetting repository within /etc/.pihole...
  [βœ“] Resetting repository within /var/www/html/admin...
  [i] Main Dependency checks...                                                                                                                      
  [βœ“] Checking for cron
  [βœ“] Checking for curl
  [βœ“] Checking for dnsutils
  [βœ“] Checking for iputils-ping
  [βœ“] Checking for lsof
  [βœ“] Checking for netcat
  [βœ“] Checking for psmisc
  [βœ“] Checking for sudo
  [βœ“] Checking for unzip
  [βœ“] Checking for wget
  [βœ“] Checking for idn2
  [βœ“] Checking for sqlite3
  [βœ“] Checking for libcap2-bin
  [βœ“] Checking for dns-root-data
  [βœ“] Checking for resolvconf
  [βœ“] Checking for libcap2
  [βœ“] Checking for lighttpd
  [βœ“] Checking for php7.3-common
  [βœ“] Checking for php7.3-cgi
  [βœ“] Checking for php7.3-sqlite3
  [βœ“] Checking for php7.3-xml
  [βœ“] Checking for php7.3-intl
                                                                                                                                                     
  [βœ“] Enabling lighttpd service to start on reboot...
  [βœ“] Checking for user 'pihole'
                                                                                                                                                     
  [i] FTL Checks...                                                                                                                                  
                                                                                                                                                     
  [βœ“] Detected 32bit (i686) architecture
  [i] Checking for existing FTL binary...                                                                                                            
  [i] Checksum of installed binary matches remote. No need to download!                                                                              
/etc/.pihole/automated install/basic-install.sh: line 1937: usermod: command not found                                                               
  [i] Testing if systemd-resolved is enabled                                                                                                         
  [i] Systemd-resolved is not enabled
  [βœ“] Restarting lighttpd service...
  [βœ“] Enabling lighttpd service to start on reboot...
  [i] Restarting services...                                                                                                                         
  [βœ“] Enabling pihole-FTL service to start on reboot...
  [βœ“] Restarting pihole-FTL service...
  [βœ“] Deleting existing list cache
  [i] Pi-hole blocking is enabled                                                                                                                    
  [i] Neutrino emissions detected...                                                                                                                 
  [βœ“] Pulling blocklist source list into range
                                                                                                                                                     
  [i] Target: raw.githubusercontent.com (hosts)                                                                                                      
  [βœ“] Status: Retrieval successful
                                                                                                                                                     
  [i] Target: mirror1.malwaredomains.com (justdomains)                                                                                               
  [βœ“] Status: Retrieval successful
                                                                                                                                                     
  [i] Target: sysctl.org (hosts)                                                                                                                     
  [βœ“] Status: Retrieval successful
                                                                                                                                                     
  [i] Target: s3.amazonaws.com (simple_tracking.txt)                                                                                                 
  [βœ“] Status: Retrieval successful
                                                                                                                                                     
  [i] Target: s3.amazonaws.com (simple_ad.txt)                                                                                                       
  [βœ“] Status: Retrieval successful
                                                                                                                                                     
  [i] Target: hosts-file.net (ad_servers.txt)                                                                                                        
  [βœ“] Status: Retrieval successful
                                                                                                                                                     
  [βœ“] Consolidating blocklists
  [βœ“] Extracting domains from blocklists
  [i] Number of domains being pulled in by gravity: 147096                                                                                           
  [βœ“] Removing duplicate domains
  [i] Number of unique domains trapped in the Event Horizon: 124205                                                                                  
  [i] Nothing to whitelist!                                                                                                                          
  [i] Number of regex filters: 0                                                                                                                     
  [βœ“] Parsing domains into hosts format
  [βœ“] Cleaning up stray matter
                                                                                                                                                     
  [βœ“] Force-reloading DNS service
  [βœ“] DNS service is running
  [βœ“] Pi-hole blocking is Enabled
                                                                                                                                                     
  [i] The install log is located at: /etc/pihole/install.log                                                                                         
Update Complete! 
                                                                                                                                                     
  Current Pi-hole version is v4.3.2-384-gbf01f72                                                                                                     
  Current AdminLTE version is v4.3.2-357-g3cac308                                                                                                    
  Current FTL version is vDev-ecbeb95

Problem resolved?

No sir, looking at the debug, this appear over and over:

 -----tail of pihole-FTL.log------                                                                                                                 
   [2020-01-19 20:30:45.661 4423] domain_in_list(odc-dm2304-meta.onedrive.akadns.net.l-0003.dc-msedge.net.l-0003.l-msedge.net): Gravity database not 
available                                                                                                                                            
   [2020-01-19 20:30:45.661 4423] domain_in_list(odc-dm2304-meta.onedrive.akadns.net.l-0003.dc-msedge.net.l-0003.l-msedge.net): Gravity database not 
available                                                                                                                                            
   [2020-01-19 20:30:45.661 4423] domain_in_list(odc-dm2304-meta.onedrive.akadns.net.l-0003.dc-msedge.net.l-0003.l-msedge.net): Gravity database not 
available                                                                                                                                            
   [2020-01-19 20:30:45.661 4423] domain_in_list(l-0003.l-msedge.net): Gravity database not available                                                
   [2020-01-19 20:30:45.661 4423] domain_in_list(l-0003.l-msedge.net): Gravity database not available                                                
   [2020-01-19 20:30:45.661 4423] domain_in_list(l-0003.l-msedge.net): Gravity database not available                                                
   [2020-01-19 20:30:50.774 4423] domain_in_list(tile-service.weather.microsoft.com): Gravity database not available                                 
   [2020-01-19 20:30:50.774 4423] domain_in_list(tile-service.weather.microsoft.com): Gravity database not available                                 
   [2020-01-19 20:30:50.774 4423] domain_in_list(tile-service.weather.microsoft.com): Gravity database not available                                 
   [2020-01-19 20:30:50.780 4423] domain_in_list(wildcard.weather.microsoft.com.edgekey.net): Gravity database not available                         
   [2020-01-19 20:30:50.780 4423] domain_in_list(wildcard.weather.microsoft.com.edgekey.net): Gravity database not available                         
   [2020-01-19 20:30:50.780 4423] domain_in_list(wildcard.weather.microsoft.com.edgekey.net): Gravity database not available                         
   [2020-01-19 20:30:50.780 4423] domain_in_list(e15275.g.akamaiedge.net): Gravity database not available                                            
   [2020-01-19 20:30:50.780 4423] domain_in_list(e15275.g.akamaiedge.net): Gravity database not available                                            
   [2020-01-19 20:30:50.780 4423] domain_in_list(e15275.g.akamaiedge.net): Gravity database not available                                            
   [2020-01-19 20:31:02.094 4423] domain_in_list(livetileedge.dsx.mp.microsoft.com): Gravity database not available                                  
   [2020-01-19 20:31:02.094 4423] domain_in_list(livetileedge.dsx.mp.microsoft.com): Gravity database not available                                  
   [2020-01-19 20:31:02.094 4423] domain_in_list(livetileedge.dsx.mp.microsoft.com): Gravity database not available                                  
   [2020-01-19 20:31:02.101 4423] domain_in_list(livetileedge.xbetservices.akadns.net): Gravity database not available                               
   [2020-01-19 20:31:02.101 4423] domain_in_list(livetileedge.xbetservices.akadns.net): Gravity database not available                               
   [2020-01-19 20:31:02.101 4423] domain_in_list(livetileedge.xbetservices.akadns.net): Gravity database not available                               
   [2020-01-19 20:31:02.101 4423] domain_in_list(livetileedge.dsx.mp.microsoft.com.edgekey.net): Gravity database not available                      
   [2020-01-19 20:31:02.101 4423] domain_in_list(livetileedge.dsx.mp.microsoft.com.edgekey.net): Gravity database not available                      
   [2020-01-19 20:31:02.101 4423] domain_in_list(livetileedge.dsx.mp.microsoft.com.edgekey.net): Gravity database not available                      
   [2020-01-19 20:31:02.101 4423] domain_in_list(e16646.dspg.akamaiedge.net): Gravity database not available                                         
   [2020-01-19 20:31:02.101 4423] domain_in_list(e16646.dspg.akamaiedge.net): Gravity database not available                                         
   [2020-01-19 20:31:02.101 4423] domain_in_list(e16646.dspg.akamaiedge.net): Gravity database not available                                         
   [2020-01-19 20:31:04.533 4423] domain_in_list(ad.doubleclick.net.58551.9318.302br.net): Gravity database not available                            
   [2020-01-19 20:31:04.533 4423] domain_in_list(ad.doubleclick.net.58551.9318.302br.net): Gravity database not available                            
   [2020-01-19 20:31:04.533 4423] domain_in_list(ad.doubleclick.net.58551.9318.302br.net): Gravity database not available                            
   [2020-01-19 20:31:04.557 4423] get_client_groupids(): Gravity database not available                                                              
   [2020-01-19 20:31:04.557 4423] get_client_groupids(): Gravity database not available                                                              
   [2020-01-19 20:31:04.557 4423] domain_in_list(ad.doubleclick.net.58551.9318.302br.net): Gravity database not available                            
   [2020-01-19 20:31:04.557 4423] domain_in_list(ad.doubleclick.net.58551.9318.302br.net): Gravity database not available                            
   [2020-01-19 20:31:04.557 4423] domain_in_list(ad.doubleclick.net.58551.9318.302br.net): Gravity database not available
root@tthr-nmsrv83:/etc/.pihole# ls -lh /etc/pihole                                                                                                   
total 82M                                                                                                                                            
-rw-r--r-- 1 root   root      313 Jan 19 20:23 adlists.list                                                                                          
-rw-r--r-- 1 root   root      662 Dec 23 22:52 adlists.list.old                                                                                      
-rw-r--r-- 1 pihole pihole    995 Jan 19 21:13 dhcp.leases                                                                                           
-rw-r--r-- 1 root   root      596 Dec  9 21:00 dns-servers.conf                                                                                      
-rw-r--r-- 1 root   root       13 Jan 19 19:47 ftlbranch                                                                                             
-rw-r--r-- 1 root   root       20 Jan 19 21:05 GitHubVersions                                                                                        
-rw-r--r-- 1 root   root     2.8M Jan 19 21:05 gravity.list                                                                                          
-rw-r--r-- 1 root   root        0 Jan 19 21:05 install.log                                                                                           
-rw------- 1 root   root     1.6M Jan 19 21:05 list.0.raw.githubusercontent.com.domains                                                              
-rw------- 1 root   root     581K Jan 19 21:05 list.1.mirror1.malwaredomains.com.domains                                                             
-rw------- 1 root   root     624K Jan 19 21:05 list.2.sysctl.org.domains                                                                             
-rw------- 1 root   root      613 Jan 19 21:05 list.3.s3.amazonaws.com.domains                                                                       
-rw------- 1 root   root      43K Jan 19 21:05 list.4.s3.amazonaws.com.domains                                                                       
-rw------- 1 root   root     1.7M Jan 19 21:05 list.5.hosts-file.net.domains                                                                         
-rw-r--r-- 1 root   root     2.8M Jan 19 21:05 list.preEventHorizon                                                                                  
-rw-r--r-- 1 root   root       38 Jan 19 21:10 localbranches                                                                                         
-rw-r--r-- 1 root   root       47 Jan 19 21:05 local.list                                                                                            
-rw-r--r-- 1 root   root       52 Jan 19 21:10 localversions                                                                                         
-rw-r--r-- 1 root   root      234 Dec  9 21:00 logrotate                                                                                             
-rw-r--r-- 1 pihole pihole   2.3M Jan 19 19:48 macvendor.db                                                                                          
-rw-rw-r-- 1 pihole root       33 Jan 12 13:25 pihole-FTL.conf                                                                                       
-rw------- 1 root   root       15 Jan 10 21:57 pihole-FTL.conf.save                                                                                  
-rw-rw-r-- 1 pihole root       15 Jan 10 21:57 pihole-FTL.conf.save.1                                                                                
-rw-r--r-- 1 pihole pihole    69M Jan 19 21:13 pihole-FTL.db                                                                                         
-rw-rw-r-- 1 pihole www-data    0 Dec  9 21:06 regex.list                                                                                            
-rw-r--r-- 1 root   root      790 Dec 30 22:26 setupVars.conf                                                                                        
-rw-r--r-- 1 root   root      300 Dec  9 20:55 setupVars.conf.update.bak

Is it me, or is gravity.db "missing"?:

root@tthr-nmsrv83:/etc/pihole# ls                                                                                                                    
adlists.list      gravity.list                               list.4.s3.amazonaws.com.domains  logrotate               regex.list                     
adlists.list.old  install.log                                list.5.hosts-file.net.domains    macvendor.db            setupVars.conf                 
dhcp.leases       list.0.raw.githubusercontent.com.domains   list.preEventHorizon             pihole-FTL.conf         setupVars.conf.update.bak      
dns-servers.conf  list.1.mirror1.malwaredomains.com.domains  localbranches                    pihole-FTL.conf.save                                   
ftlbranch         list.2.sysctl.org.domains                  local.list                       pihole-FTL.conf.save.1                                 
GitHubVersions    list.3.s3.amazonaws.com.domains            localversions                    pihole-FTL.db

For what it's worth:

I don't see this line when running pihole -r:

"Adding adlist with id X to database table"

Shouldn't that appear after, "[βœ“] Status: Retrieval successful"?

What operating system?

*** [ INITIALIZING ]
[i] 2020-01-19:23:02:22 debug log has been initialized.

*** [ INITIALIZING ] Sourcing setup variables
[i] Sourcing /etc/pihole/setupVars.conf...

*** [ DIAGNOSING ]: Core version
[i] Core: v4.3.2 (How do I update Pi-hole?)
[i] Branch: release/v5.0 (The pihole Command With Examples)
[i] Commit: v4.3.2-384-gbf01f72

*** [ DIAGNOSING ]: Web version
[i] Web: v4.3.2 (How do I update Pi-hole?)
[i] Branch: release/v5.0 (The pihole Command With Examples)
[i] Commit: v4.3.2-357-g3cac308

*** [ DIAGNOSING ]: FTL version
[βœ“] FTL: vDev-ecbeb95 (How do I update Pi-hole?)

*** [ DIAGNOSING ]: lighttpd version
[i] 1.4.53

*** [ DIAGNOSING ]: php version
[i] 7.3.11

*** [ DIAGNOSING ]: Operating system
[βœ“] Debian GNU/Linux 10 (buster)

*** [ DIAGNOSING ]: SELinux
[i] SELinux not detected

*** [ DIAGNOSING ]: Processor
[i] i686

Debug token mozufgbrm4

Looks like you are missing a default system utility called usermod. We need that to allow the pihole user access to the webserver and the database. That would explain why you have no database, it can't be created.

What is the output from groups pihole? And what user are you running pihole-FTL as?

groups pihole = pihole ; pihole www-data

FTL running under pihole

Resolved.

I googled the error and found this : command usermod not found

Reran β€œcore checkout” and all is well.

FYI I’m running Debian headless and interact with pihole via shellinabox