IrcsomeBot1 | <RikMills> @myfenris, nothing in plasma depends on mysql | 08:33 |
---|---|---|
IrcsomeBot1 | <myfenris> opss sorry .... i mean akonadi | 08:42 |
IrcsomeBot1 | <RikMills> it seems that you can't build against 5.7 any more, so seems we might | 08:54 |
IrcsomeBot1 | <myfenris> @RikMills, anyone already take in the milestone? | 08:55 |
IrcsomeBot1 | <RikMills> not that I know of | 09:04 |
IrcsomeBot1 | <RikMills> 1st thing. see if it even builds! | 09:05 |
IrcsomeBot1 | <RikMills> Looks like mysql 8 breaks akonadi | 10:19 |
RikMills | mariadb works | 10:35 |
RikMills | hmmmm | 10:35 |
BluesKaj | Howdy all | 11:49 |
RikMills | santa_: akonadi doesn't start with mysql-8.0 that landed in release last night. I think I will switch us to mariadb by default? that works | 16:07 |
RikMills | Opensuse/arch/debian all default to that now | 16:08 |
RikMills | tested an upgrade with an existing database, and it seemed ok | 16:08 |
IrcsomeBot1 | <myfenris> @RikMills, i've tried before .. then i rollback to 5.7 | 17:06 |
IrcsomeBot1 | <myfenris> @RikMills, owh ... | 17:06 |
IrcsomeBot1 | <myfenris> if current using mysql 5.7 .. then akonadi change default to mariadb .. is it will auto migrate from mysql to mariadb ? or i need to rebuild akonadi again | 17:12 |
RikMills | it seemed to be able to run with either | 17:13 |
RikMills | new installs would have mariadb. existing ones mysql for now | 17:13 |
IrcsomeBot1 | <myfenris> @RikMills, so i need to install mariadb to make it work after upgrading mysql 8? | 17:14 |
RikMills | yes, I couldn't get it to work with mysql-8.0 | 17:15 |
IrcsomeBot1 | <myfenris> it will auto reindexing kmail into akonadi - mariadb ? | 17:15 |
RikMills | I think so | 17:15 |
IrcsomeBot1 | * myfenris let me try | 17:16 |
IrcsomeBot1 | <myfenris> okie .. its remove all the 5.7 related :) | 17:17 |
IrcsomeBot1 | <myfenris> mariadb cant start :( | 17:27 |
RikMills | it started ok in a Eoan VM | 17:29 |
IrcsomeBot1 | <myfenris> Aug 24 01:25:39 X240 systemd[1]: Starting MariaDB 10.3.17 database server... … Aug 24 01:25:40 X240 mysqld[14375]: 2019-08-24 1:25:40 0 [Note] /usr/sbin/mysqld (mysqld 10.3.17-MariaDB-1) starting as process 14375 ... … Aug 24 01:27:09 X240 systemd[1]: mariadb.service: Start operation timed out. Terminating. … Aug 24 01:27:10 X240 systemd[1]: mariadb.service: Failed with result 'timeout'. … Aug 24 01:27:10 X240 systemd | 17:31 |
IrcsomeBot1 | Failed to start MariaDB 10.3.17 database server. | 17:31 |
IrcsomeBot1 | <myfenris> cant purge mysql else will removed all related packages with mysql | 17:32 |
crydotsnake-M | What is the problem | 17:32 |
IrcsomeBot1 | <RikMills> are you using KCI? | 17:33 |
IrcsomeBot1 | <myfenris> @RikMills, yups | 17:33 |
IrcsomeBot1 | <myfenris> kci stable | 17:33 |
IrcsomeBot1 | <RikMills> @myfenris, that has a newer akonadi than eoan, so might need things like an apparmor tweak | 17:34 |
IrcsomeBot1 | <myfenris> @RikMills, is it causing the mariadb cant start ? | 17:34 |
IrcsomeBot1 | <RikMills> @myfenris, quite probably. Neon had to do an apparmor rule change when akonadi 19.08 landed | 17:36 |
IrcsomeBot1 | <myfenris> can advised what should i do ? | 17:36 |
IrcsomeBot1 | <myfenris> or reference site that i can follow about the apparmor .. let me search | 17:38 |
IrcsomeBot1 | <RikMills> um. seems we have that change from Neon. I will have to investigate more | 17:38 |
IrcsomeBot1 | <myfenris> https://paste.ubuntu.com/p/THXWcZqWWw/ | 17:39 |
IrcsomeBot1 | <RikMills> I'll have to set up a KCI VM | 17:43 |
IrcsomeBot1 | <myfenris> reinstalling 5.7 also failed to start :( | 17:56 |
IrcsomeBot1 | <RikMills> what is the output of 'akonadictl start' | 18:00 |
blaze | usually it helps to delete the index file | 18:02 |
IrcsomeBot1 | <myfenris> https://paste.ubuntu.com/p/p8Xv3DjNxc/ | 18:11 |
IrcsomeBot1 | <myfenris> https://bugs.launchpad.net/ubuntu/+source/mariadb-10.1/+bug/1806263 | 18:14 |
ubottu | Launchpad bug 1806263 in mariadb-10.1 (Ubuntu) "MariaDB 10.1 server won't start when MySQL 5.7 server has been previously installed" [Undecided,Confirmed] | 18:14 |
IrcsomeBot1 | <myfenris> is this the one u mention related to apparmor ? | 18:15 |
IrcsomeBot1 | <RikMills> that is something else | 18:20 |
IrcsomeBot1 | <myfenris> okie sorry | 18:21 |
IrcsomeBot1 | <myfenris> @RikMills can u share your /etc/apparmor.d/usr.sbin.mysqld ? | 18:47 |
IrcsomeBot1 | <myfenris> @RikMills, 👆🏻 | 18:47 |
IrcsomeBot1 | <RikMills> https://git.launchpad.net/~kubuntu-packagers/kubuntu-packaging/+git/akonadi/tree/debian/usr.sbin.mysqld-akonadi?h=kubuntu_eoan_archive | 18:49 |
IrcsomeBot1 | <RikMills> I am remaking the VM at the moment. will have to be later | 18:50 |
IrcsomeBot1 | <myfenris> it was emptied on my usr.sbin.mysqld | 18:51 |
IrcsomeBot1 | <myfenris> apparmor="DENIED" shown on the log | 18:51 |
IrcsomeBot1 | <myfenris> i guess its the cause | 18:52 |
IrcsomeBot1 | <RikMills> does it work if you put it in complain mode? | 18:53 |
IrcsomeBot1 | <myfenris> https://paste.ubuntu.com/p/vdc3Cp8wF7/ | 18:58 |
IrcsomeBot1 | <RikMills> oh, that is usr.sbin.mysqld, not usr.sbin.mysqld-akonadi | 19:01 |
IrcsomeBot1 | <myfenris> okie .. | 19:02 |
IrcsomeBot1 | <myfenris> just managed to get it work | 19:02 |
IrcsomeBot1 | <myfenris> adding : | 19:02 |
IrcsomeBot1 | <myfenris> in the apparmor | 19:02 |
IrcsomeBot1 | <myfenris> https://paste.ubuntu.com/p/4TZ5CgGSST/ | 19:03 |
IrcsomeBot1 | <myfenris> akonadi server cant start | 19:06 |
IrcsomeBot1 | <myfenris> https://paste.ubuntu.com/p/8SJZw8hyCD/ | 19:07 |
IrcsomeBot1 | <RikMills> not good | 19:11 |
IrcsomeBot1 | <myfenris> @RikMills, mean ? | 19:13 |
IrcsomeBot1 | <RikMills> I don't think that is related to apparmor | 19:13 |
IrcsomeBot1 | <myfenris> @RikMills, the akonadi ? | 19:14 |
IrcsomeBot1 | <myfenris> i added 1 line in apparmor then mariadb can start | 19:14 |
IrcsomeBot1 | <myfenris> but now akonadi still not working .. | 19:14 |
IrcsomeBot1 | <myfenris> using mariadb | 19:15 |
IrcsomeBot1 | <myfenris> hmmm after restart | 19:27 |
IrcsomeBot1 | <myfenris> Aug 24 03:27:05 X240 kernel: [ 355.233451] audit: type=1400 audit(1566588425.028:192): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/ld.so.cache" pid=19178 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=135 ouid=0 … Aug 24 03:27:05 X240 kernel: [ 355.233523] audit: type=1400 audit(1566588425.028:193): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" | 19:28 |
IrcsomeBot1 | name="/usr/lib/x86_64-linux-gnu/liblz4.so.1.9.1" pid=19178 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=135 ouid=0 | 19:28 |
IrcsomeBot1 | <myfenris> the line added not working :( | 19:28 |
IrcsomeBot1 | <RikMills> sudo apt-get install apparmor-utils | 19:31 |
ejat | apparmor-utils is already the newest version (2.13.2-9ubuntu7) | 19:31 |
IrcsomeBot1 | <RikMills> sudo aa-complain /etc/apparmor.d/usr.sbin.mysql-akonadi | 19:32 |
ejat | $ sudo aa-complain /etc/apparmor.d/usr.sbin.mysql-akonadi | 19:33 |
ejat | Profile for /etc/apparmor.d/usr.sbin.mysql-akonadi not found, skipping | 19:33 |
IrcsomeBot1 | <RikMills> maybe I mistyped | 19:34 |
ejat | $ sudo aa-complain /etc/apparmor.d/usr.sbin.mysqld-akonadi | 19:34 |
ejat | Setting /etc/apparmor.d/usr.sbin.mysqld-akonadi to complain mode. | 19:34 |
ejat | but now .. my mariadb can't start :( | 19:35 |
RikMills | wtf? | 19:37 |
IrcsomeBot1 | <RikMills> (Photo, 1280x760) https://irc-attachments.kde.org/nTMYRR4S/file_17364.jpg | 19:38 |
IrcsomeBot1 | <RikMills> In my Eoan ^^^ | 19:38 |
IrcsomeBot1 | <RikMills> after switching to mariadb | 19:39 |
ejat | can u share your usr.sbin.mysqld | 19:39 |
ejat | or whats in it | 19:39 |
IrcsomeBot1 | <RikMills> there isn't one, which is correct for mariadb | 19:40 |
ejat | Aug 24 03:42:04 X240 kernel: [ 1254.831902] audit: type=1400 audit(1566589324.606:196): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/ld.so.cache" pid=3309 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=135 ouid=0 | 19:42 |
ejat | Aug 24 03:42:04 X240 kernel: [ 1254.831949] audit: type=1400 audit(1566589324.606:197): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/usr/lib/x86_64-linux-gnu/liblz4.so.1.9.1" pid=3309 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=135 ouid=0 | 19:42 |
ejat | when i want to start mariadb | 19:42 |
IrcsomeBot1 | <RikMills> do you have a usr.sbin.mysqld still? | 19:45 |
IrcsomeBot1 | <myfenris> @RikMills, removed that 1 line i added .. | 19:46 |
IrcsomeBot1 | <RikMills> you should lose the whole profile with mariadb | 19:46 |
ejat | i asked in ubuntu-server .. | 19:49 |
RikMills | might be an idea. it all just works here for me!! | 19:56 |
ejat | what is it .. | 19:57 |
crydotsnake-M | I tested the Kubuntu 19.10 Iso Today, and everything was working just fine :) | 19:57 |
RikMills | crydotsnake-M: great. thanks! | 20:02 |
crydotsnake-M | No Problem! :). I just want to help :))) | 20:02 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!