[Bug 264383] akonadiserver uses ~/.my.cnf dangerously

[Ivan Vasin]

https://bugs.kde.org/show_bug.cgi?id=264383





--- Comment #2 from Ivan Vasin <nisavid gmail com>  2011-01-27 17:30:04 ---
(In reply to comment #1)
> Well the mysql manual states:
> --- (http://dev.mysql.com/doc/refman/5.1/en/option-files.html)
> The [client] option group is read by all client programs (but not by mysqld).
> This enables you to specify options that apply to all clients.
> ----
> so the behavior you got is the expected one.

it may be the expected behavior from the point of view, "how should
akonadiserver's mysql client behave if it is not configured to ignore MySQL
defaults?", but the point of this bug is that it is very much /not/ the
expected behavior from the point of view, "how can Akonadi function properly
without requiring the user to know about its internal workings and be aware of
them when configuring his or her personal MySQL settings?".

it is a usability issue if i--as a user of Akonadi--am required to understand
that it uses a MySQL client, that its MySQL client will read my MySQL settings
from ~/.my.cnf (which in any common use case i wouldn't set up for Akonadi to
use), and that as a result i effectively cannot use ~/.my.cnf for my personal
needs.  it is an even greater usability issue that i must find out that if i do
use ~/.my.cnf, akonadiserver will inspect and issue REPAIR TABLE on the tables
of my company's production database, which are certainly not related to Akonadi
in any way and should never be touched by it.

therefore this behavior is a bug from a user's point of view, whether or not it
is naively expected from a developer's point of view.

> However it might be possible to
> prevent akonadis mysql instance from using any system configured options by
> using the "--no-defaults" option.

can i configure my current installation of akonadiserver to use --no-defaults? 
could someone please make this a default setting?  many thanks!

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.