Hello Everyone,
Today I faced strange thing. I am monitoring my server with AIDE software. It detects changes in the filesystem structure, for example notifying me about file being created, changed or deleted. What I spotted was that sqlite.db file was created in my roundcube/bin directory. What's more when I check original location of the file which is roundcube/sqlite.db it was 11G in size! Is this normal? What is exactly stored in the file? I removed (previously backed up) both files and everything seems to be working OK. So I am wondering - did someone "visited" my server and did something nasty? Or is this suppose to happen and sqlite.db can grow to 11G over time?
Any help would be greatly appreciated. Thanks!
On Aug 21, 2009, at 3:56 PM, Michal Drozdziewicz wrote:
I check original location of the file which is roundcube/sqlite.db
it was 11G in size! Is this normal?
Seems big to me.
One thing to know about sqlite, it does not shrink the size of the on-
disk file when data is deleted from the database.
If you want sqlite to recreate the on-disk file with just the
existing data, you need to "vacuum" the database.
A command to do that would look something like :
/usr/bin/sqlite3 <sqlitefilename> 'vacuum <tablename>;'
where the values in angled brackets are something from your own system.
I use PostgreSQL for RC myself, however I do use a cron script
something like the above for maintaining the sqlite databases used by
our spam filtering solution.
What is exactly stored in the file?
User preferences, address book information, and if you have
configured it, a cache of the messages from the IMAP server.
Based on the size of that file, and that you are using sqlite, I
would recommend you disable the database caching.
So I am wondering - did someone "visited" my server and did something
nasty?
Probably not, that file likely contained a lot of old cached data.