| 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 |
To migrate calendar data, I would export to an ical file and then reimport it. |
| 99 |
|
| 100 |
For contacts, use vcf. |
| 101 |
|
| 102 |
Both of these are mostly human readable and allow for simple editing if necessary. |
| 103 |
|
| 104 |
I am not certain this will work. I would suggest testing with a temporary user first. |
| 105 |
|
| 106 |
-- |
| 107 |
Joost |
| 108 |
-- |
| 109 |
Sent from my Android device with K-9 Mail. Please excuse my brevity. |
Archives