Re: prefsdir-relative path in url_shortener_cache_dsn ?

["Kevin A. McGrail" <km...@apache.org>]

I am pretty sure that will need to be a feature request.  I don't remember
any code to address that type of scenario. -KAM
--
Kevin A. McGrail
Member, Apache Software Foundation
Chair Emeritus Apache SpamAssassin Project
https://www.linkedin.com/in/kmcgrail - 703.798.0171


On Sun, Aug 28, 2022 at 3:02 PM Matus UHLAR - fantomas <uh...@fantomas.sk>
wrote:

> Hello,
>
> I'm trying to set up url_shortener_cache_dsn globally, but spamassassin is
> run by multiple different users.
>
> is it possible to specify  url_shortener_cache_dsn relative according to
> user_prefs directory?
>
> setting it to:
>
> dbi:SQLite:dbname=~/.spamassassin/DecodeShortURLs.sqlite
>
> or:
>
> dbi:SQLite:dbname=$HOME/.spamassassin/DecodeShortURLs.sqlite
>
> did not work, complained
>
> using only:
>
> dbi:SQLite:dbname=DecodeShortURLs.sqlite
>
> created the file in current directory.
>
> --
> Matus UHLAR - fantomas, uhlar@fantomas.sk ; http://www.fantomas.sk/
> Warning: I wish NOT to receive e-mail advertising to this address.
> Varovanie: na tuto adresu chcem NEDOSTAVAT akukolvek reklamnu postu.
> Fucking windows! Bring Bill Gates! (Southpark the movie)
>

Re: prefsdir-relative path in url_shortener_cache_dsn ?

[Matus UHLAR - fantomas <uh...@fantomas.sk>]

On 29.08.22 12:36, Kevin A. McGrail wrote:
>I am pretty sure that will need to be a feature request.  I don't remember
>any code to address that type of scenario. -KAM

I was hoping for default path in ~/.spamassassin/ since bayes_path and 
auto_welcomelist_path (possibly other options) use that directory by 
default.

this might be different because of url shortener cache only supports DBI for 
now.

looking at https://www.sqlite.org/uri.html and 
https://www.sqlite.org/c3ref/open.html#urifilenamesinsqlite3open it seems 
that expanding filename is not possible at sqlite level.

would it make sense to support berkeley DB here?

>On Sun, Aug 28, 2022 at 3:02 PM Matus UHLAR - fantomas <uh...@fantomas.sk>
>wrote:
>> I'm trying to set up url_shortener_cache_dsn globally, but spamassassin is
>> run by multiple different users.
>>
>> is it possible to specify  url_shortener_cache_dsn relative according to
>> user_prefs directory?
>>
>> setting it to:
>>
>> dbi:SQLite:dbname=~/.spamassassin/DecodeShortURLs.sqlite
>>
>> or:
>>
>> dbi:SQLite:dbname=$HOME/.spamassassin/DecodeShortURLs.sqlite
>>
>> did not work, complained
>>
>> using only:
>>
>> dbi:SQLite:dbname=DecodeShortURLs.sqlite
>>
>> created the file in current directory.

-- 
Matus UHLAR - fantomas, uhlar@fantomas.sk ; http://www.fantomas.sk/
Warning: I wish NOT to receive e-mail advertising to this address.
Varovanie: na tuto adresu chcem NEDOSTAVAT akukolvek reklamnu postu.
REALITY.SYS corrupted. Press any key to reboot Universe.