[Bug 244949] deskutils/akonadiconsole: Cannot connect to MySQL server

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=244949

Adriaan de Groot <adridg at freebsd.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|New                         |Closed
         Resolution|---                         |Overcome By Events
                 CC|                            |adridg at freebsd.org

--- Comment #3 from Adriaan de Groot <adridg at freebsd.org> ---
I'm going to close this one as "overcome by events" since it's a year old. I'm
sorry we didn't have time and energy to chase it down -- I've had some
**similar** issues in the past where the mysql wouldn't start for Akonadi. I
forget what I did in such cases, though.

As a general debugging guide for this, let's take a belated look:

The log contains this:

```
org.kde.pim.akonadiserver: database server stopped unexpectedly
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial
connection!
org.kde.pim.akonadiserver: executable: "/usr/local/libexec/mysqld"
org.kde.pim.akonadiserver: arguments:
("--defaults-file=/home/gerard/.local/share/akonadi/mysql.conf",
"--datadir=/home/gerard/.local/share/akonadi/db_data/",
"--socket=/var/run/user/1001/akonadi/mysql.socket",
"--pid-file=/var/run/user/1001/akonadi/mysql.pid")
```

This says that **mysqld** itself didn't start; the place to look for problems
is therefore in the log of **that** program, not in akonadi. Looking at my
machine today (where Akonadi doesn't work either, but for totally different
reasons) I **do** see mysqld running:

```
10854  -  I     0:40.32 /usr/local/libexec/mysqld
--defaults-file=/home/adridg/.local/share/akonadi/mysql.conf
--datadir=/home/adridg/.local/share/akonadi/db_data/
--socket=/var/run/user/1001/akonadi/mysql.socket
--pid-file=/var/run/user/1001/akonadi/mysql.pid
```

In the *datadir* you can find the error log from mysqld, so that
would-have-been the place to look. With mysqld running, there's a socket you
can connect to to debug the database; without it running, there's a log file.

-- 
You are receiving this mail because:
You are the assignee for the bug.