Re: [opensuse] Akonadi runs wild

On Tuesday 23 March 2010 12:49:27 Constant Brouerius van Nidek wrote:
On Tue, 23 Mar 2010 09:30:39 +0100

Will Stephenson <wstephenson@xxxxxxx> wrote:
On Monday 22 March 2010 12:49:20 Will Stephenson wrote:
No, that's not the issue. If you google for the mysql output
before it quits "Fatal error: Please read "Security" section of
the manual to find out how to run mysqld as root!" there are a lot
of other reports. I'll read them after lunch and see what they
mean - they can't all be running as root ;).

So all the other reports with this error message I looked at
yesterday were indeed users running akonadi as root. I don't know
another reason why mysql would output this error message, so I'm
going to look for ways it could be trying to run as root. In your
serverstart log file Akonadi is trying to use a database
in /home/constant112 so at least it has a user's $HOME environment.
Is your mysqld binary setuid root?

Also, I'm adding a 'not root' test to the Akonadi self test dialog to
make it clear to others that running as root is strongly discouraged.

Will
Looked at mysql and user and group are both root. That should be what?

/usr/bin/mysql is not /usr/sbin/mysqld for a start

it should be
$ ll /usr/sbin/mysqld
-rwxr-xr-x 1 root root 8588920 2009-10-24 07:51 /usr/sbin/mysqld

note no 's' in the permissions here. I doubt you would have a reason to make
mysqld setuid root, but there is such a lot of nonsense floating around on the
web to make make mysql installations work that 90% of it is either completely
wrong or useful information applied completely wrongly (as it gets bigger, the
Linux user help knowledgebase gets ever more like that of Windows :() - that I
could believe that someone told you to chmod u+s /usr/sbin/mysqld.

Anyway, aside from that digression, and assuming that your mysqld is not
setuid root, I'm running out of ideas. Let's try burning everything down -
delete $HOME/.local/share/akonadi and $HOME/.config/akonadi.

Will

Have to confess that I use midnight commander for such changes. Norton
Commander on my Dos machine :( . Easier than command line.
Do not know why but that was I suppose something which was done during
the (new) installation of 11.2 from the dvd month ago.
I have never worked with MySQL.
Fine that you did the reading because I was realy frustrated to find
out that people are already struggling with this kind of problem since
2003/ 2004. Seems to be a popular problem ;)

--
Will Stephenson, KDE Developer, openSUSE Boosters Team
SUSE LINUX Products GmbH - Nürnberg - AG Nürnberg - HRB 16746 - GF: Markus Rex
--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx

Relevant Pages

  • Re: [opensuse] Akonadi runs wild
    ... Will Stephenson wrote: ... Akonadi fails to start because its MySQL ... instance refuses to start as root. ...
    (SuSE)
  • Re: Trouble starting MySQL
    ... (mysqladmin -u root password 'yourpassword') ... it looks like your mysqld is not started trought.. ... but no running instance of mysql either. ... >but there is no password for user mysql yet...dunno if it's necessary, ...
    (freebsd-questions)
  • How to configure mysql server?
    ... I'm running mysqld version 5.0.22 under Fedora-5. ... When I try to set the password for user "root" on my desktop ... connect to server at 'localhost' failed ... Welcome to the MySQL monitor. ...
    (Fedora)
  • Re: MySQL FC3
    ... > Dave Foran wrote: ... the procedure for resetting the root password ... user that the mysqld server runs as. ... command; these cause the output of cat to be substituted into the kill ...
    (Fedora)
  • Re: Problem in MySQL
    ... [root@Ashish mysqld]# service mysqld stop ... shell> mysql -u root ... java leads to shockwave. ... And realaudio leads to suffering. ...
    (comp.os.linux.misc)