How to get baloo to index .sql files? Config not applying [Solved]

Nikolai5 · 2024-05-29 14:10:11

Hi,

I'm running KDE Plasma with baloo and I want it to index SQL files.

By default it appears it applies a filter to not index them, I have tried to remove the "*.sql" entry from ~/.config/baloofilerc however that had no effect. The entry is no longer in that file though, nothing has put it back in even after restarts.

I have also tried removing the filter using balooctl6.
If I run

balooctl6 config list excludeFilters | grep sql

it returns an entry for *.sql

I tried to remove it using:

balooctl6 config remove excludeFilters '*.sql'

However, when listing the excludeFilters again it appears its still and running it without the grep shows it at the bottom of the list as if it has been added in after being removed.

The service was disabled and suspended while doing this. Does anyone have any suggestions about how to proceed with this one? Is it looking at a config file somewhere else on the system? I've tried to run a find to locate it but no luck.

Edit: Solved in comment 6

Last edited by Nikolai5 (2024-05-30 12:16:42)

Lithium Sulfate · 2024-05-30 06:40:29

Taking a quick look at baloo's source code, it seems that for some reason the default filters are always reapplied if the "exclude filters version" value in your baloofilerc is below a certain threshold:

    // make sure we always keep the latest default exclude filters
    // TODO: there is one problem here. What if the user removed some of the default filters?
    if (m_settings->excludedFiltersVersion() < defaultExcludeFilterListVersion()) {
        filters += defaultExcludeFilterList();

(Note the TODO comment in particular)

I can't tell you whether this is the intended solution, but at least as a workaround, if you increase the "exclude filters version" value in your config file to be greater or equal than the default (which at this current point in time is 9), it appears that the default filters will not be re-added.

Last edited by Lithium Sulfate (2024-05-30 11:37:35)

Nikolai5 · 2024-05-30 09:01:22

Nice find and worth noting if for anyone else, but in my case I don't think its that as my current list looks like this:

➜  ~ balooctl6 config list excludeFilters          
*~
*.part
*.o
*.la
*.lo
*.loT
*.moc
moc_*.cpp
qrc_*.cpp
ui_*.h
cmake_install.cmake
CMakeCache.txt
CTestTestfile.cmake
libtool
config.status
confdefs.h
autom4te
conftest
confstat
Makefile.am
*.gcode
.ninja_deps
.ninja_log
build.ninja
*.csproj
*.m4
*.rej
*.gmo
*.pc
*.omf
*.aux
*.tmp
*.po
*.vm*
*.nvram
*.rcore
*.swp
*.swap
lzo
litmain.sh
*.orig
.histfile.*
.xsession-errors*
*.map
*.so
*.a
*.db
*.qrc
*.ini
*.init
*.img
*.vdi
*.vbox*
vbox.log
*.qcow2
*.vmdk
*.vhd
*.vhdx
*.sql.gz
*.ytdl
*.class
*.pyc
*.pyo
*.elc
*.qmlc
*.jsc
*.fastq
*.fq
*.gb
*.fasta
*.fna
*.gbff
*.faa
po
CVS
.svn
.git
_darcs
.bzr
.hg
CMakeFiles
CMakeTmp
CMakeTmpQmake
.moc
.obj
.pch
.uic
.npm
.yarn
.yarn-cache
__pycache__
node_modules
node_packages
nbproject
.venv
venv
core-dumps
lost+found
*.tfstate*
.terraform
*.placeholder
*.placeholder2
*.sql

This matches what is in the baloofilerc minus the *.sql at the bottom there, but you can see that even though I added those two placeholders to the end of the list in the file, and they've appeared at the end there, its still putting *.sql at the bottom.

But it seems they prevent duplications and this comment: "make sure we always keep the latest default exclude filters"
suggests that you simply can't remove these defaults, which is a shame.

Thanks for pointing me towards that code though, it does seem to be culprit, I'm just not sure there's a way around it.

Lithium Sulfate · 2024-05-30 10:34:43

Could you share the exact contents of your current baloofilerc please?

Nikolai5 · 2024-05-30 10:40:46

Here you go:

/home/me/.config/baloofilerc

[General]
dbVersion=2
exclude filters=*~,*.part,*.o,*.la,*.lo,*.loT,*.moc,moc_*.cpp,qrc_*.cpp,ui_*.h,cmake_install.cmake,CMakeCache.txt,CTestTestfile.cmake,libtool,config.status,confdefs.h,autom4te,conftest,confstat,Makefile.am,*.gcode,.ninja_deps,.ninja_log,build.ninja,*.csproj,*.m4,*.rej,*.gmo,*.pc,*.omf,*.aux,*.tmp,*.po,*.vm*,*.nvram,*.rcore,*.swp,*.swap,lzo,litmain.sh,*.orig,.histfile.*,.xsession-errors*,*.map,*.so,*.a,*.db,*.qrc,*.ini,*.init,*.img,*.vdi,*.vbox*,vbox.log,*.qcow2,*.vmdk,*.vhd,*.vhdx,*.sql.gz,*.ytdl,*.class,*.pyc,*.pyo,*.elc,*.qmlc,*.jsc,*.fastq,*.fq,*.gb,*.fasta,*.fna,*.gbff,*.faa,po,CVS,.svn,.git,_darcs,.bzr,.hg,CMakeFiles,CMakeTmp,CMakeTmpQmake,.moc,.obj,.pch,.uic,.npm,.yarn,.yarn-cache,__pycache__,node_modules,node_packages,nbproject,.venv,venv,core-dumps,lost+found,*.tfstate*,.terraform,*.placeholder,*.placeholder2
exclude filters version=8
folders[$e]=$HOME/

Note that *.sql.gz is there, I'm fine with that.
Removing *.sql and adding those two placeholders at the end to see if they were applied is all I've done to this document.

Lithium Sulfate · 2024-05-30 11:36:57

Try setting

exclude filters version=9

which should stop the default filters from being added.

Nikolai5 · 2024-05-30 12:16:03

Thanks a lot that worked. Changed to version 9 as described and made it reindex which picked up all the files I wanted. Appreciate it

Arch Linux

#1 2024-05-29 14:10:11

How to get baloo to index .sql files? Config not applying [Solved]

#2 2024-05-30 06:40:29

Re: How to get baloo to index .sql files? Config not applying [Solved]

#3 2024-05-30 09:01:22

Re: How to get baloo to index .sql files? Config not applying [Solved]

#4 2024-05-30 10:34:43

Re: How to get baloo to index .sql files? Config not applying [Solved]

#5 2024-05-30 10:40:46

Re: How to get baloo to index .sql files? Config not applying [Solved]

#6 2024-05-30 11:36:57

Re: How to get baloo to index .sql files? Config not applying [Solved]

#7 2024-05-30 12:16:03

Re: How to get baloo to index .sql files? Config not applying [Solved]

Board footer