Re: [opensuse] Akonadi runs wild

newer
Re: [opensuse] Anyone running...

older
[opensuse] XEN is being weird

Constant Brouerius van Nidek

22 Mar 2010 22 Mar '10

07:05

On Sun, 21 Mar 2010 19:02:37 +0100 Will Stephenson wrote:

...

On Sunday 21 March 2010 16:52:42 constant@indo.net.id wrote:

...
Did what you proposed.Advance KDE Resourc. Contacts The >>Akonadi address book is disabled now.Nepomuk Semantic Desktop is

Otherwise let me have a look at the logs, and thanks for persevering with kmail while we troubleshoot this - this ensures we will have a good kmail experience when 11.3 comes out.

BTW if it does all get too much for you, you can switch back to KDE 4.3.5 kmail etc with "zypper rm akonadi-runtime" - the relevant kdepim packages only will be downgraded, keeping the 4.4.1 desktop.

Will Kmail is one of my favorites and I am for the moment not planning to abandon it ;) . A switch back is not a question now as I can temporary handle my email with Crawl. Worked on the Akonadi server and saved the output of akonadictl start in a file which I attach. Hope that this kind of information helps. Thanks for the assistance.

Attachments:

serverstart.a (application/octet-stream — 11.3 KB)

Show replies by thread

Will Stephenson

22 Mar 22 Mar

09:08

New subject: [opensuse] Akonadi runs wild

On Monday 22 March 2010 08:05:44 Constant Brouerius van Nidek wrote:

...

On Sun, 21 Mar 2010 19:02:37 +0100

Will Stephenson wrote:

...
On Sunday 21 March 2010 16:52:42 constant@indo.net.id wrote:

...
Did what you proposed.Advance KDE Resourc. Contacts The >>Akonadi address book is disabled now.Nepomuk Semantic Desktop is

Otherwise let me have a look at the logs, and thanks for persevering with kmail while we troubleshoot this - this ensures we will have a good kmail experience when 11.3 comes out.

BTW if it does all get too much for you, you can switch back to KDE 4.3.5 kmail etc with "zypper rm akonadi-runtime" - the relevant kdepim packages only will be downgraded, keeping the 4.4.1 desktop.

Will Kmail is one of my favorites and I am for the moment not planning to abandon it ;) . A switch back is not a question now as I can temporary handle my email with Crawl. Worked on the Akonadi server and saved the output of akonadictl start in a file which I attach. Hope that this kind of information helps. Thanks for the assistance.

According to the log, Akonadi fails to start because its MySQL instance refuses to start as root. Are you running KDE as root by any chance? Will -- 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

Constant Brouerius van Nidek

10:54

New subject: [opensuse] Akonadi runs wild

On Mon, 22 Mar 2010 10:08:16 +0100 Will Stephenson wrote:

...

On Monday 22 March 2010 08:05:44 Constant Brouerius van Nidek wrote:

...
On Sun, 21 Mar 2010 19:02:37 +0100

Will Stephenson wrote:

...
On Sunday 21 March 2010 16:52:42 constant@indo.net.id wrote:

...
Did what you proposed.Advance KDE Resourc. Contacts The

...
...
Akonadi address book is disabled now.Nepomuk Semantic Desktop is

Otherwise let me have a look at the logs, and thanks for persevering with kmail while we troubleshoot this - this ensures we will have a good kmail experience when 11.3 comes out.

BTW if it does all get too much for you, you can switch back to KDE 4.3.5 kmail etc with "zypper rm akonadi-runtime" - the relevant kdepim packages only will be downgraded, keeping the 4.4.1 desktop.

Will Kmail is one of my favorites and I am for the moment not planning to abandon it ;) . A switch back is not a question now as I can temporary handle my email with Crawl. Worked on the Akonadi server and saved the output of akonadictl start in a file which I attach. Hope that this kind of information helps. Thanks for the assistance.

According to the log, Akonadi fails to start because its MySQL instance refuses to start as root. Are you running KDE as root by any chance?

No, just as a normal user. Solution? RPM -e and reinstall MySQL? and see if that cures the problem? -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Will Stephenson

11:49

New subject: [opensuse] Akonadi runs wild

On Monday 22 March 2010 11:54:47 Constant Brouerius van Nidek wrote:

...

On Mon, 22 Mar 2010 10:08:16 +0100

Will Stephenson wrote:

...
On Monday 22 March 2010 08:05:44 Constant Brouerius van Nidek wrote:

...
On Sun, 21 Mar 2010 19:02:37 +0100

Will Stephenson wrote:

...
On Sunday 21 March 2010 16:52:42 constant@indo.net.id wrote:

...
Did what you proposed.Advance KDE Resourc. Contacts The

...
>Akonadi address book is disabled now.Nepomuk Semantic Desktop >is

Otherwise let me have a look at the logs, and thanks for persevering with kmail while we troubleshoot this - this ensures we will have a good kmail experience when 11.3 comes out.

BTW if it does all get too much for you, you can switch back to KDE 4.3.5 kmail etc with "zypper rm akonadi-runtime" - the relevant kdepim packages only will be downgraded, keeping the 4.4.1 desktop.

Will Kmail is one of my favorites and I am for the moment not planning to abandon it ;) . A switch back is not a question now as I can temporary handle my email with Crawl. Worked on the Akonadi server and saved the output of akonadictl start in a file which I attach. Hope that this kind of information helps. Thanks for the assistance.

According to the log, Akonadi fails to start because its MySQL instance refuses to start as root. Are you running KDE as root by any chance?

No, just as a normal user. Solution? RPM -e and reinstall MySQL? and see if that cures the problem?

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 ;). Will -- 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

Rajko M.

23:36

New subject: [opensuse] Akonadi runs wild

On Monday 22 March 2010 06: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 ;).

In openSUSE user must run mysql_secure_installation before MySQL can be used. See http://en.opensuse.org/Mysql section "Running MySQL on openSUSE for the first time". I guess that I would have no problems with Akonadi as MySQL is already installed using above instructions. -- Regards Rajko, -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Will Stephenson

23 Mar 23 Mar

08:21

New subject: [opensuse] Akonadi runs wild

On Tuesday 23 March 2010 00:36:24 Rajko M. wrote:

...

On Monday 22 March 2010 06: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 ;).

In openSUSE user must run mysql_secure_installation before MySQL can be used. See http://en.opensuse.org/Mysql section "Running MySQL on openSUSE for the first time".

I guess that I would have no problems with Akonadi as MySQL is already installed using above instructions.

Don't guess, Rajko ;). Those instructions are for server installations of mysql running system wide at boot. Akonadi runs in a user session like any other KDE app and spawns its own mysql process as a user using a custom config file* that starts mysql stripped down , without networking, communicating with Akonadi over a private socket. Effectively it should be as private and opaque to you as Kaffeine or Digikam's uses of sqlite. Thus, reconfiguring the system mysql with mysql_secure_installation will have no effect on Akonadi. Will * $HOME/.local/share/akonadi/mysql.conf -- Will Stephenson, openSUSE 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

Will Stephenson

08:30

New subject: [opensuse] Akonadi runs wild

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 -- Will Stephenson, openSUSE 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

Constant Brouerius van Nidek

11:49

New subject: [opensuse] Akonadi runs wild

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? 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 ;) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Will Stephenson

12:57

New subject: [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 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

Constant Brouerius van Nidek

13:28

New subject: [opensuse] Akonadi runs wild

On Tue, 23 Mar 2010 13:57:21 +0100 Will Stephenson wrote:

...

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

...

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

My output differs slightly from yours: -rwxr-xr-x 1 root root 8460292 2009-10-24 12:46 /usr/sbin/mysqld -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Will Stephenson

14:21

New subject: [opensuse] Akonadi runs wild

On Tuesday 23 March 2010 14:28:48 Constant Brouerius van Nidek wrote:

...

My output differs slightly from yours: -rwxr-xr-x 1 root root 8460292 2009-10-24 12:46 /usr/sbin/mysqld

I'm on x86_64, you're on i586. Noting significant about those differences. -- 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

Constant Brouerius van Nidek

26 Mar 26 Mar

16:23

New subject: [opensuse] Akonadi runs wild

On Tuesday 23 March 2010 19:57:21 Will Stephenson wrote:

...

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, Forgot to inform you that after I deleted the above files my KMail is working close to expectations. I still have to start KMail for a second time after I get the information that Akonadi works but that is no big problem. Thanks for the hands on help. Constant -- Linux User 183145 using a Pentium III , powered by openSUSE 11.2 (i586) Kernel: 2.6.31.12-0.2-desktop KDE Development Platform: 4.4.1 (KDE 4.4.1) "release 228" 23:18pm up 0:26, 3 users, load average: 0.37, 0.68, 1.14 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Will Stephenson

29 Mar 29 Mar

10:18

New subject: [opensuse] Akonadi runs wild

On Friday 26 March 2010 17:23:08 Constant Brouerius van Nidek wrote:

...

On Tuesday 23 March 2010 19:57:21 Will Stephenson wrote:

...
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,

Forgot to inform you that after I deleted the above files my KMail is working close to expectations. I still have to start KMail for a second time after I get the information that Akonadi works but that is no big problem. Thanks for the hands on help.

Hi Constant I've been Working at Akonadi self-tests this weekend and there is definitely a race condition in the self-test dialog that causes a false negative. On the second start attempt everything has settled down and kmail runs. I'll post when I have a fix... Will -- 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

Constant Brouerius van Nidek

3 Apr 3 Apr

09:43

New subject: [opensuse] Akonadi runs wild

On Monday 29 March 2010 17:18:09 Will Stephenson wrote:

...

On Friday 26 March 2010 17:23:08 Constant Brouerius van Nidek wrote:

...
On Tuesday 23 March 2010 19:57:21 Will Stephenson wrote:

...
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,

Forgot to inform you that after I deleted the above files my KMail is working close to expectations. I still have to start KMail for a second time after I get the information that Akonadi works but that is no big problem. Thanks for the hands on help.

Hi Constant

I've been Working at Akonadi self-tests this weekend and there is definitely a race condition in the self-test dialog that causes a false negative. On the second start attempt everything has settled down and kmail runs. I'll post when I have a fix...

Will, Could it be that the fix is there? ;) -- Linux User 183145 using a Pentium III , powered by openSUSE 11.2 (i586) Kernel: 2.6.31.12-0.2-desktop KDE Development Platform: 4.4.2 (KDE 4.4.2) "release 234" 16:42pm up 0:24, 2 users, load average: 0.66, 1.05, 1.24 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

5162

Age (days ago)

5174

Last active (days ago)

List overview

Download

13 comments

3 participants

participants (3)

Constant Brouerius van Nidek
Rajko M.
Will Stephenson