1 |
On 15 November 2015 17:32:07 CET, Mick <michaelkintzios@×××××.com> wrote: |
2 |
>On Thursday 12 Nov 2015 08:05:52 J. Roeleveld wrote: |
3 |
>> On Thursday, November 12, 2015 07:30:49 AM Mick wrote: |
4 |
>> > On Thursday 12 Nov 2015 04:48:49 J. Roeleveld wrote: |
5 |
>> > > On 11 November 2015 23:07:41 CET, Mick |
6 |
><michaelkintzios@×××××.com> |
7 |
>wrote: |
8 |
>> > > >On Wednesday 11 Nov 2015 20:28:07 Marc Joliet wrote: |
9 |
>> > > >> On Wednesday 11 November 2015 20:37:24 J. Roeleveld wrote: |
10 |
>> > > >> >I saw plenty of errors with mysql. |
11 |
>> > > >> > |
12 |
>> > > >> >After switching to Postgresql, they seem to have disappeared. |
13 |
>> > > >> |
14 |
>> > > >> FWIW, I use mariadb myself, which is also the virtual/mysql |
15 |
>default |
16 |
>> > > >> provider, last I checked. |
17 |
>> > > >> |
18 |
>> > > >> Greetings |
19 |
>> > > > |
20 |
>> > > >@Mark: Yes, same here, but the errors are produced by mariadb |
21 |
>too. |
22 |
>> > > > |
23 |
>> > > >@Joost: Is postgresql starting as a process by akonadi, or are |
24 |
>you |
25 |
>> > > >running it |
26 |
>> > > >independently and pointing akonadi to it? |
27 |
>> > > > |
28 |
>> > > >PS. I read somewhere that if mysql is running independently of |
29 |
>> > > >akonadi, then |
30 |
>> > > >the akonadi errors/corruptions are fewer, or not happen at all. |
31 |
>> > > |
32 |
>> > > As I use Postgresql also for other stuff, it's started |
33 |
>seperately. |
34 |
>> > > |
35 |
>> > > I also found this performs better, having it run "embedded" only |
36 |
>had a |
37 |
>> > > slightly better performance when compared to mysql (or mariadb, |
38 |
>don't |
39 |
>> > > remember) "embedded". |
40 |
>> > > |
41 |
>> > > A framework like akonadi should, IMO, also be able to be run on a |
42 |
>> > > server with clients connecting to there to allow different |
43 |
>machines to |
44 |
>> > > all use the same data. |
45 |
>> > > |
46 |
>> > > The current solution makes running with a shared home and logged |
47 |
>in |
48 |
>> > > from different clients simultaneously problematic (to say the |
49 |
>least) |
50 |
>> > > |
51 |
>> > > -- |
52 |
>> > > Joost |
53 |
>> > |
54 |
>> > Can you please explain how you have akonadi configured to use an |
55 |
>existing |
56 |
>> > db instance? Did you have to set up an akonadi db user and passwd? |
57 |
>> |
58 |
>> Yes. |
59 |
>> You need to create a user with password on the database where akonadi |
60 |
>can |
61 |
>> create the tables. |
62 |
>> |
63 |
>> Here is my akonadi-config: |
64 |
>> *** |
65 |
>> % cat .config/akonadi/akonadiserverrc |
66 |
>> [%General] |
67 |
>> Driver=QPSQL |
68 |
>> |
69 |
>> [QPSQL] |
70 |
>> Name=joost-akonadi |
71 |
>> Host=localhost |
72 |
>> Options= |
73 |
>> ServerPath=/usr/bin/pg_ctl |
74 |
>> InitDbPath=/usr/bin/initdb |
75 |
>> StartServer=false |
76 |
>> User=<username> |
77 |
>> Password=<password> |
78 |
>> Port=5432 |
79 |
>> |
80 |
>> [Debug] |
81 |
>> Tracer=null |
82 |
>> |
83 |
>> *** |
84 |
>> |
85 |
>> It also works with the database running on a different machine. |
86 |
>> |
87 |
>> -- |
88 |
>> Joost |
89 |
> |
90 |
>Thank you Joost. Did you export/import akonadi databases when you |
91 |
>moved over |
92 |
>from MySQL, or was it not necessary? |
93 |
> |
94 |
>One of the databases contains calendar data and I do not want to cause |
95 |
>loss of |
96 |
>it. |
97 |
|
98 |
I store my emails in IMAP (Cyrus) and my contacts and calendar are stored in Egroupware. |
99 |
|
100 |
IOW, I treat akonadi as a local cache and the server is the master copy being used by all other devices. |
101 |
|
102 |
-- |
103 |
Joost |
104 |
-- |
105 |
Sent from my Android device with K-9 Mail. Please excuse my brevity. |