Re: Part 2 of any progress on kmail in debian buster?

Paul,

I am attempting to switch to kmail2 to postgre sql and follow the advice in the email 
which you attached (quoted in full at the end of this email).

I first note that the email explains the opensuse way and I use debian buster. 

"root@johwhi:/home/johwhi# apt-get in postgresql-server libQt5Sql5-postgresql 


did not work so I installed postgre server from the debian repository.  I continued 
following the instructions, which worked, until I got to $ psql postgres when I got 
the following note, which I interpret as an error.

"postgres@johwhi:~$ psql postgres 
"

So, rather than risk messing up my email unnecessarily, I did not proceed further 
and decided to send you what I have done so far and see if you have any comment.

For your convenience, I now quote the opensuse instructions which I am attempting 
to follow:

"First we install all necessary packages for PostgreSQL and the Akonadi connection:
# zypper in postgresql-server libQt5Sql5-postgresql
Activate and start PostgreSQL Server:
# systemctl enable --now postgresql
Create Postgres user and database:
# su - postgres
$ createuser <your-username>
$ psql postgres
postgres=# alter user <your-username> createdb;
postgres=# \q;
# exit
Then we set up the database access with your regular user account:
$ createdb akonadi-<your-username>
Now we stop Akonadi and delete or move the settings. This is especially important if 
you have already had started Akonadi!
$ akonadictl stop
$ rm -rf ~/.local/share/akonadi
We adjust the connection to the database server in the file /~/.config/akonadi/
akonadiserverrc/ as follows:
[%General]
Driver=QPSQL

[QPSQL]
Host=/tmp/akonadi-<your-username>.hash
InitDbPath=/usr/bin/initdb
Name=akonadi
Options=
ServerPath=/usr/bin/pg_ctl
StartServer=true
Finally restart Akonadi and you are ready to go:
$ akonadictl start"

John



On Friday, September 27, 2019 3:16:03 AM PDT Paul Vixie wrote:
> John White wrote on 2019-09-26 23:06:
> > > ...
> > 
> > I am a fan of (and contributor to) kmail and KDE and Debian and
> > understand some of the problems unique to open source software. These
> > problems I am having with kmail are quite serious. I have many years of
> > kmails, easily searchable, and so I really don't want to leave. I notice
> > a discussion of the RID situation at
> > 
> > https://forum.kde.org/viewtopic.php?t=138233&start=45
> > 
> > but that discussion is way above my paygrade. I am quite afraid that my
> > trying something like that will cause me to lose emails.
> 
> please see two attached reruns from this mailing list's history.
> 
> > Is there anyone on or off this list whom I could contact offline for
> > some kmail help? I would be happy to pay a reasonable fee.
> 
> i am following the advice given in the attached, and i lose no e-mail.