To solve this issue, first ensure that you already have the nuget packages for SQLite are installed:

Add these lines in machine.config:

    <system.data>
        <DbProviderFactories>
			  <remove invariant="System.Data.SQLite.EF6" />
			  <remove invariant="System.Data.SQLite" />
			  <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
			  <add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />
    
		</DbProviderFactories>
    </system.data>

We can find machine.config in:

1. C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config
2. C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

That’s all friends. I hope it helps!

Did you know that in USA, one of the way to support duck conservation is by buying duck stamps? I didn’t. Thanks to Last Week Tonight with John Oliver’s latest episode, now I do. Every year, a new duck stamp is released. To do so, there is an annual nationwide art contest to design duck stamp. And boy, it’s a serious business. By serious, I mean it has fierce competitions, rivalry and drama.

John and his team submitted 5 duck stamp designs. Funny enough, two were disqualified due to the art has numbers on it, and three were out without receiving any votes from the judges. As a revenge, John put these paintings on auction at bestduckingstamps.com. All the proceeds will be donated to Federal Duck Stamp program.

As of 1st Oct 2021 Singapore Time, I’m impressed with number of bids and value!

1. Leading the pack with 141 bids at $21,100.00 value is “Duck Hunt” by Eric Joyner.

   

2. Trailing behind the leader, with 89 bids at $17,500.00 value is “Duck Judges” by Bill Mayer.

   

3. On third position with 59 bids at $15,100.00 value is “Duck Hunting Hunters” by Josie Morway

   

4. On fourth position with 74 bids at $12,433.00 value is “Duck with a Pearl Earring” by Omar Rayyan

   

5. Last but not least, with 102 bids at $5,700.00 value is “Feuding Artist Handshake” by Roberto Parada

   

The full bids:

Today I notice that this blog’s disk usage is exceeding 50%.

So a maintenance is in order. One of the area that I can clean of is the logs. To check how much disk usage consumed by logs:

du -h /var/log

We can see which one consume the most:

104K    /var/log/apt                                                                                         
80K     /var/log/letsencrypt                                                                                 
4.0K    /var/log/apache2                                                                                     
32K     /var/log/mysql                                                                                       
80K     /var/log/unattended-upgrades                                                                         
44K     /var/log/exim4                                                                                       
4.0K    /var/log/samba                                                                                       
8.0K    /var/log/openvpn                                                                                     
1.1G    /var/log/journal/78571dd6ca7745fd883930edfbc1aec0                                                    
1.1G    /var/log/journal                                                                                     
880K    /var/log/nginx                                                                                       
1.2G    /var/log      

So the main culprit is /var/log/journal. But is it safe to remove the journal’s log? According to THIS, it’s perfectly safe.

With that in mind, let’s empty it out. But before deleting anything, let’s check the content:

ls /var/log/journal/78571dd6ca7745fd883930edfbc1aec0/

Looks like a number of journal files:

system.journal                                                                                               
system@e09f493f5d9543ccac3a01a18a5a7966-0000000000000001-0005c912944622d1.journal                            
system@e09f493f5d9543ccac3a01a18a5a7966-0000000000027cda-0005c9db59ac33c2.journal                            
system@e09f493f5d9543ccac3a01a18a5a7966-000000000004f9c8-0005ca3f9fdef072.journal                            
system@e09f493f5d9543ccac3a01a18a5a7966-0000000000078054-0005ca79a740fa97.journal                            
system@e09f493f5d9543ccac3a01a18a5a7966-00000000000a1c80-0005cb04b06080bc.journal                            
system@e09f493f5d9543ccac3a01a18a5a7966-00000000000ce097-0005cb2b4509171f.journal                            
system@e09f493f5d9543ccac3a01a18a5a7966-00000000000f8e58-0005cbabe81428d7.journal                            
system@e09f493f5d9543ccac3a01a18a5a7966-0000000000124d00-0005cbdc50807f36.journal                            
user-1000.journal

Let’s remove them all:

rm /var/log/journal/78571dd6ca7745fd883930edfbc1aec0/*.journal

Now verify the disk usage after:

du -h /var/log

It’s much less now:

104K    /var/log/apt                                                                                         
80K     /var/log/letsencrypt                                                                                 
4.0K    /var/log/apache2                                                                                     
32K     /var/log/mysql                                                                                       
80K     /var/log/unattended-upgrades                                                                         
44K     /var/log/exim4                                                                                       
4.0K    /var/log/samba                                                                                       
8.0K    /var/log/openvpn                                                                                     
4.0K    /var/log/journal/78571dd6ca7745fd883930edfbc1aec0                                                    
8.0K    /var/log/journal                                                                                     
884K    /var/log/nginx                                                                                       
62M     /var/log

Looks like we can clean further /var/log. Let’s find the offending files:

ls -l -S /var/log

And the culprits are:

-rw-rw----  1 root        utmp            18732672 Aug 31 02:22 btmp.1                                       
-rw-rw----  1 root        utmp            16121472 Sep 30 01:23 btmp                                         
-rw-r-----  1 syslog      adm             10247924 Sep 26 02:19 mail.log.1                                   
-rw-r-----  1 syslog      adm              9098913 Sep 27 02:20 auth.log.1                                   
-rw-r-----  1 syslog      adm              2289106 Sep 30 09:19 mail.log                                     
-rw-r-----  1 syslog      adm              1152534 Sep 13 02:20 auth.log.3.gz                                
-rw-r-----  1 syslog      adm              1069630 Sep 30 09:19 auth.log                                     
-rw-r-----  1 syslog      adm               972616 Sep  6 02:13 mail.log.4.gz                                
-rw-r-----  1 syslog      adm               744907 Sep 30 02:20 syslog.1                                     
-rw-r-----  1 syslog      adm               659046 Sep 12 02:20 mail.log.3.gz                                
-rw-r-----  1 syslog      adm               518091 Sep  5 02:20 auth.log.4.gz                                
-rw-r-----  1 syslog      adm               444680 Sep 20 02:19 mail.log.2.gz

We can use rm command to clean them.

That’s all friends! I hope it helps.