[08:33] <IrcsomeBot1> <RikMills> @myfenris, nothing in plasma depends on mysql
[08:42] <IrcsomeBot1> <myfenris> opss sorry .... i mean akonadi
[08:54] <IrcsomeBot1> <RikMills> it seems that you can't build against 5.7 any more, so seems we might
[08:55] <IrcsomeBot1> <myfenris> @RikMills, anyone already take in the milestone?
[09:04] <IrcsomeBot1> <RikMills> not that I know of
[09:05] <IrcsomeBot1> <RikMills> 1st thing. see if it even builds!
[10:19] <IrcsomeBot1> <RikMills> Looks like mysql 8 breaks akonadi
[10:35] <RikMills> mariadb works
[10:35] <RikMills> hmmmm
[11:49] <BluesKaj> Howdy all
[16:07] <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:08] <RikMills> Opensuse/arch/debian all default to that now
[16:08] <RikMills> tested an upgrade with an existing database, and it seemed ok
[17:06] <IrcsomeBot1> <myfenris> @RikMills, i've tried before .. then i rollback to 5.7
[17:06] <IrcsomeBot1> <myfenris> @RikMills, owh ...
[17:12] <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:13] <RikMills> it seemed to be able to run with either
[17:13] <RikMills> new installs would have mariadb. existing ones mysql for now
[17:14] <IrcsomeBot1> <myfenris> @RikMills, so i need to install mariadb to make it work after upgrading mysql 8?
[17:15] <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:16] <IrcsomeBot1> * myfenris let me try
[17:17] <IrcsomeBot1> <myfenris> okie .. its remove all the 5.7 related :)
[17:27] <IrcsomeBot1> <myfenris> mariadb cant start :(
[17:29] <RikMills> it started ok in a Eoan VM
[17:31] <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:32] <IrcsomeBot1> <myfenris> cant purge mysql else will removed all related packages with mysql
[17:32] <crydotsnake-M> What is the problem
[17:33] <IrcsomeBot1> <RikMills> are you using KCI?
[17:33] <IrcsomeBot1> <myfenris> @RikMills, yups
[17:33] <IrcsomeBot1> <myfenris> kci stable
[17:34] <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:36] <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:38] <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:39] <IrcsomeBot1> <myfenris> https://paste.ubuntu.com/p/THXWcZqWWw/
[17:43] <IrcsomeBot1> <RikMills> I'll have to set up a KCI VM
[17:56] <IrcsomeBot1> <myfenris> reinstalling 5.7 also failed to start :(
[18:00] <IrcsomeBot1> <RikMills> what is the output of 'akonadictl start'
[18:02] <blaze> usually it helps to delete the index file
[18:11] <IrcsomeBot1> <myfenris> https://paste.ubuntu.com/p/p8Xv3DjNxc/
[18:14] <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:15] <IrcsomeBot1> <myfenris> is this the one u mention related to apparmor ?
[18:20] <IrcsomeBot1> <RikMills> that is something else
[18:21] <IrcsomeBot1> <myfenris> okie sorry
[18:47] <IrcsomeBot1> <myfenris> @RikMills can u share your /etc/apparmor.d/usr.sbin.mysqld ?
[18:47] <IrcsomeBot1> <myfenris> @RikMills, 👆🏻
[18:49] <IrcsomeBot1> <RikMills> https://git.launchpad.net/~kubuntu-packagers/kubuntu-packaging/+git/akonadi/tree/debian/usr.sbin.mysqld-akonadi?h=kubuntu_eoan_archive
[18:50] <IrcsomeBot1> <RikMills> I am remaking the VM at the moment. will have to be later
[18:51] <IrcsomeBot1> <myfenris> it was emptied on my usr.sbin.mysqld
[18:51] <IrcsomeBot1> <myfenris> apparmor="DENIED" shown on the log
[18:52] <IrcsomeBot1> <myfenris> i guess its the cause
[18:53] <IrcsomeBot1> <RikMills> does it work if you put it in complain mode?
[18:58] <IrcsomeBot1> <myfenris> https://paste.ubuntu.com/p/vdc3Cp8wF7/
[19:01] <IrcsomeBot1> <RikMills> oh, that is usr.sbin.mysqld, not usr.sbin.mysqld-akonadi
[19:02] <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:03] <IrcsomeBot1> <myfenris> https://paste.ubuntu.com/p/4TZ5CgGSST/
[19:06] <IrcsomeBot1> <myfenris> akonadi server cant start
[19:07] <IrcsomeBot1> <myfenris> https://paste.ubuntu.com/p/8SJZw8hyCD/
[19:11] <IrcsomeBot1> <RikMills> not good
[19:13] <IrcsomeBot1> <myfenris> @RikMills, mean ?
[19:13] <IrcsomeBot1> <RikMills> I don't think that is related to apparmor
[19:14] <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:15] <IrcsomeBot1> <myfenris> using mariadb
[19:27] <IrcsomeBot1> <myfenris> hmmm after restart
[19:28] <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:31] <IrcsomeBot1> <RikMills> sudo apt-get install apparmor-utils
[19:31] <ejat> apparmor-utils is already the newest version (2.13.2-9ubuntu7)
[19:32] <IrcsomeBot1> <RikMills> sudo aa-complain /etc/apparmor.d/usr.sbin.mysql-akonadi
[19:33] <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:34] <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:35] <ejat> but now .. my mariadb can't start :( 
[19:37] <RikMills> wtf?
[19:38] <IrcsomeBot1> <RikMills> (Photo, 1280x760) https://irc-attachments.kde.org/nTMYRR4S/file_17364.jpg
[19:38] <IrcsomeBot1> <RikMills> In my Eoan ^^^
[19:39] <IrcsomeBot1> <RikMills> after switching to mariadb
[19:39] <ejat> can u share your usr.sbin.mysqld
[19:39] <ejat> or whats in it 
[19:40] <IrcsomeBot1> <RikMills> there isn't one, which is correct for mariadb
[19:42] <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:45] <IrcsomeBot1> <RikMills> do you have a usr.sbin.mysqld still?
[19:46] <IrcsomeBot1> <myfenris> @RikMills, removed that 1 line i added ..
[19:46] <IrcsomeBot1> <RikMills> you should lose the whole profile with mariadb
[19:49] <ejat> i asked in ubuntu-server .. 
[19:56] <RikMills> might be an idea. it all just works here for me!!
[19:57] <ejat> what is it .. 
[19:57] <crydotsnake-M> I tested the Kubuntu 19.10 Iso Today, and everything was working just fine :)
[20:02] <RikMills> crydotsnake-M: great. thanks!
[20:02] <crydotsnake-M> No Problem! :). I just want to help :)))