Skip to main content

Kerio Connect - SQLLite journal.db error

Today I noted that the Keio Connect mail server had thousands of error.log files with 75MB size filled up in the server. As always Google gave the answer.

The error looks some what like below.
[10/Aug/2011 10:49:35] SQLiteDbWriteCache.h: write_thread - file '/path/to/file/<user>/.journal.db', SQLite error: code 1, error SQLITE_ERROR[1]: no such table: journal_temp

The solution is as below


1. Delete the cache from the client's workstation
2. Delete the profile
3. Stop the server
4. Go to the server and navigate through the user's store folder
5. Delete the .journal.db (for Linux it is find . -name "FILE-TO-FIND"-exec rm -rf {} \;)
6. Start the server
7. Create a new profile for the clients workstation

With help from

Kerio Forum

Cyberciti

Comments

Popular posts from this blog

Take Action: Add Your Voice to Keep the Internet #Freeandopen - by Google

Tell the world's governments you support a free and open web at http://www.google.com/ takeaction . Starting December 3rd, the world's governments are meeting behind closed doors at the ITU to discuss the future of the Internet. Some governments want to use this meeting in Dubai to increase censorship and regulate the Internet.   Tell the world's governments you support a free and open web at http://www.google.com/ takeaction . Then spread the word with #freeandopen. It is ours and it is free. A free and open world   depends on a free and open web. And a free and open web depends on me.

Create Great looking diagrams - Gliffy.com

I was looking for an online diagram creating tool. Came across Gliffy.com where I could create actually great looking diagrams without much of learning curve. The tool is 1. Very easy to use 2. Has drag and drop of elements to your diagram 3. Collaboration (which I have not tested). 4. Works from anywhere on a browser with Internet connection (I used it in Google Chrome on Linux Mint 10) When you click on the "Try it now" a new screen will open as below. You can either create a blank page to create a diagram from scratch or select from a bunch of samples and work on them to create one for your requirement. There are options to export the diagrams you created to SVG, JPEG, PNG and XML format once you register for free on the website. Once you register you can save the diagrams that you created in the site itself and retrieve it at a later time by logging into the website. I made three diagrams and it was real easy and simple. The site has two kind of pa

Nodejs and NPM setup on Linux Mint

To install current version of Node js on Linux Mint or any Ubuntu derivatives 1. Install Node      $ curl -sL https://deb.nodesource.com/setup_11.x | sudo -E bash - 2. Check Node version     $ node -v         vxx.xx.x    $ npm -v         x.x.x 3. Verify the Node installation      var http = require('http');      http.createServer(function (req, res) {      res.writeHead(300, {'Content-Type': 'text/plain'});      res.end('Hello World...!!!');      }).listen(3001, "127.0.0.1");      console.log('Server running at http://127.0.0.1:3001/');     open your browser and type the URL  http://127.0.0.1:3001/    You can see the me ssage “Hello World…!!!” Source:  1. https://github.com/nodesource/distributions/blob/master/README.md 2.  https://medium.com/@shivraj.jadhav82/nodejs-and-npm-setup-on-linux-mint-19-696023d50247