/srv/irclogs.ubuntu.com/2019/08/23/#kubuntu-devel.txt

IrcsomeBot1<RikMills> @myfenris, nothing in plasma depends on mysql08:33
IrcsomeBot1<myfenris> opss sorry .... i mean akonadi08:42
IrcsomeBot1<RikMills> it seems that you can't build against 5.7 any more, so seems we might08:54
IrcsomeBot1<myfenris> @RikMills, anyone already take in the milestone?08:55
IrcsomeBot1<RikMills> not that I know of09:04
IrcsomeBot1<RikMills> 1st thing. see if it even builds!09:05
IrcsomeBot1<RikMills> Looks like mysql 8 breaks akonadi10:19
RikMillsmariadb works10:35
RikMillshmmmm10:35
BluesKajHowdy all11:49
RikMillssanta_: 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 works16:07
RikMillsOpensuse/arch/debian all default to that now16:08
RikMillstested an upgrade with an existing database, and it seemed ok16:08
IrcsomeBot1<myfenris> @RikMills, i've tried before .. then i rollback to 5.717: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 again17:12
RikMillsit seemed to be able to run with either17:13
RikMillsnew installs would have mariadb. existing ones mysql for now17:13
IrcsomeBot1<myfenris> @RikMills, so i need to install mariadb to make it work after upgrading mysql 8?17:14
RikMillsyes, I couldn't get it to work with mysql-8.017:15
IrcsomeBot1<myfenris> it will auto reindexing kmail into akonadi - mariadb ?17:15
RikMillsI think so17:15
IrcsomeBot1* myfenris let me try17:16
IrcsomeBot1<myfenris> okie .. its remove all the 5.7 related :)17:17
IrcsomeBot1<myfenris> mariadb cant start :(17:27
RikMillsit started ok in a Eoan VM17: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 systemd17:31
IrcsomeBot1Failed to start MariaDB 10.3.17 database server.17:31
IrcsomeBot1<myfenris> cant purge mysql else will removed all related packages with mysql17:32
crydotsnake-MWhat is the problem17:32
IrcsomeBot1<RikMills> are you using KCI?17:33
IrcsomeBot1<myfenris> @RikMills, yups17:33
IrcsomeBot1<myfenris> kci stable17:33
IrcsomeBot1<RikMills> @myfenris, that has a newer akonadi than eoan, so might need things like an apparmor tweak17: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 landed17: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 search17:38
IrcsomeBot1<RikMills> um. seems we have that change from Neon. I will have to investigate more17:38
IrcsomeBot1<myfenris> https://paste.ubuntu.com/p/THXWcZqWWw/17:39
IrcsomeBot1<RikMills> I'll have to set up a KCI VM17:43
IrcsomeBot1<myfenris> reinstalling 5.7 also failed to start :(17:56
IrcsomeBot1<RikMills> what is the output of 'akonadictl start'18:00
blazeusually it helps to delete the index file18:02
IrcsomeBot1<myfenris> https://paste.ubuntu.com/p/p8Xv3DjNxc/18:11
IrcsomeBot1<myfenris> https://bugs.launchpad.net/ubuntu/+source/mariadb-10.1/+bug/180626318:14
ubottuLaunchpad 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 else18:20
IrcsomeBot1<myfenris> okie sorry18: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_archive18:49
IrcsomeBot1<RikMills> I am remaking the VM at the moment. will have to be later18:50
IrcsomeBot1<myfenris> it was emptied on my usr.sbin.mysqld18:51
IrcsomeBot1<myfenris> apparmor="DENIED" shown on the log18:51
IrcsomeBot1<myfenris> i guess its the cause18: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-akonadi19:01
IrcsomeBot1<myfenris> okie ..19:02
IrcsomeBot1<myfenris> just managed to get it work19:02
IrcsomeBot1<myfenris> adding :19:02
IrcsomeBot1<myfenris> in the apparmor19:02
IrcsomeBot1<myfenris> https://paste.ubuntu.com/p/4TZ5CgGSST/19:03
IrcsomeBot1<myfenris> akonadi server cant start19:06
IrcsomeBot1<myfenris> https://paste.ubuntu.com/p/8SJZw8hyCD/19:07
IrcsomeBot1<RikMills> not good19:11
IrcsomeBot1<myfenris> @RikMills, mean ?19:13
IrcsomeBot1<RikMills> I don't think that is related to apparmor19:13
IrcsomeBot1<myfenris> @RikMills, the akonadi ?19:14
IrcsomeBot1<myfenris> i added 1 line in apparmor then mariadb can start19:14
IrcsomeBot1<myfenris> but now akonadi still not working ..19:14
IrcsomeBot1<myfenris> using mariadb19:15
IrcsomeBot1<myfenris> hmmm after restart19: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
IrcsomeBot1name="/usr/lib/x86_64-linux-gnu/liblz4.so.1.9.1" pid=19178 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=135 ouid=019:28
IrcsomeBot1<myfenris> the line added not working :(19:28
IrcsomeBot1<RikMills> sudo apt-get install apparmor-utils19:31
ejatapparmor-utils is already the newest version (2.13.2-9ubuntu7)19:31
IrcsomeBot1<RikMills> sudo aa-complain /etc/apparmor.d/usr.sbin.mysql-akonadi19:32
ejat$ sudo aa-complain /etc/apparmor.d/usr.sbin.mysql-akonadi19:33
ejatProfile for /etc/apparmor.d/usr.sbin.mysql-akonadi not found, skipping19:33
IrcsomeBot1<RikMills> maybe I mistyped19:34
ejat$ sudo aa-complain /etc/apparmor.d/usr.sbin.mysqld-akonadi19:34
ejatSetting /etc/apparmor.d/usr.sbin.mysqld-akonadi to complain mode.19:34
ejatbut now .. my mariadb can't start :( 19:35
RikMillswtf?19:37
IrcsomeBot1<RikMills> (Photo, 1280x760) https://irc-attachments.kde.org/nTMYRR4S/file_17364.jpg19:38
IrcsomeBot1<RikMills> In my Eoan ^^^19:38
IrcsomeBot1<RikMills> after switching to mariadb19:39
ejatcan u share your usr.sbin.mysqld19:39
ejator whats in it 19:39
IrcsomeBot1<RikMills> there isn't one, which is correct for mariadb19:40
ejatAug 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=019:42
ejatAug 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=019:42
ejatwhen 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 mariadb19:46
ejati asked in ubuntu-server .. 19:49
RikMillsmight be an idea. it all just works here for me!!19:56
ejatwhat is it .. 19:57
crydotsnake-MI tested the Kubuntu 19.10 Iso Today, and everything was working just fine :)19:57
RikMillscrydotsnake-M: great. thanks!20:02
crydotsnake-MNo Problem! :). I just want to help :)))20:02

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!