sqlite temporary storage path should point to PyBitmessage config directory

[PeterSurda]

Mentioned in bitmessage chan. Needs to be checked if reproducible. Could be sqlite is createing a temp file in a different directory during VACUUM:

I got the following error while trying to start PyBM

---

ERROR: The msgpack package is not available.It is highly recommended for messages coding.
ERROR: If your package manager does not have this package, try running "pip install msgpack-python".
Loading config files from same directory as program.
Using default logger configuration
2018-05-02 08:53:07,236 - ERROR - /home/me/.namecoin/namecoin.conf unreadable or missing, Namecoin support deactivated
2018-05-02 08:53:13,627 - CRITICAL - (While VACUUM) Alert: Your disk or data storage volume is full. sqlThread will now exit.

---

I really had very little free space in / partition
but actually I was running BM in portable mode in the /home partition which had 6 GiB free space.. so it should work..
I have just freed some space in / so I can start PyBM and send this message

Thanks
NourEddineX

[g1itch]

sqlite uses /tmp for vacuum. I had the same problem on openwrt. Another way is to export SQLITE_TMPDIR (not worked for me) or use PRAGMA:
https://www.sqlite.org/tempfiles.html

[navjotcis]

I have tried to reproduce the same issue but I was not able to get any issue even on my system I have 7gb of space is free and I have also tried to find the /tmp directory in my Linux system but I am not able to find out so can anyone let me know the exact case when you are facing the issue.