On Tuesday 23 March 2010 12:49:27 Constant Brouerius van Nidek wrote:
On Tue, 23 Mar 2010 09:30:39 +0100
Will Stephenson
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@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org