On Tuesday, 28 December 2021 09:31:46 GMT Josip Deanovic wrote: > On 2021-12-28 10:23, Graham Dicker wrote: > > On Monday, 27 December 2021 18:56:32 GMT Phil Stracchino wrote: > >> On 12/27/21 13:38, Graham Dicker wrote: > >> > On Monday, 27 December 2021 18:19:23 GMT Phil Stracchino wrote: > >> > > The blazes....? If mysql.user is a VIEW, something is VERY BADLY > >> > > WRONG. > >> > > Are you still using Akonadi's MySQL instance? > >> > > >> > Not as far as I can tell. I changed /etc/my.cnf to say: > >> > > >> > port = 3306 > >> > >> And you are certain that the mysqld listening on that port is NOT > >> Akonadi's? > >> > >> If Akonadi's mysqld is listening on port 3306, and you install a > >> second > >> mysqld, it will be unable to bind port 3306. You cannot have two > >> different processes listening on the same port. > >> > >> Try this command as root: lsof -i | grep 3306 > >> > >> and see which mysql process is listening on that port. Then look at > >> the > >> process tree (ps axf) and see what that process belongs to. > > > > The command > > > > lsof -i | grep 3306 > > > > as root returns nothing > > > > lsof -i -U | grep mysql > > > > returns this > > > > COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE > > NAME > > mysqld 1263 mysql 58u IPv4 35060 0t0 TCP > > localhost:mysql (LISTEN) > > mysqld 1263 mysql 59u unix 0xffff8c5c0484e600 0t0 35061 > > /run/ > > mysql/mysql.sock type=STREAM > > mysqld 1263 mysql 102u unix 0xffff8c5b56e50cc0 0t0 65617 > > /run/ > > mysql/mysql.sock type=STREAM > > mysqld 2511 graham 17u unix 0xffff8c5bce1d72c0 0t0 39643 > > /run/ > > user/1000/akonadi/mysql.socket type=STREAM > > mysqld 2511 graham 26u unix 0xffff8c5bdbc69540 0t0 39665 > > /run/ > > user/1000/akonadi/mysql.socket type=STREAM > > mysqld 2511 graham 123u unix 0xffff8c5bdbc6aa80 0t0 40731 > > /run/ > > user/1000/akonadi/mysql.socket type=STREAM > > mysqld 2511 graham 124u unix 0xffff8c5bce1d2640 0t0 39676 > > /run/ > > user/1000/akonadi/mysql.socket type=STREAM > > mysqld 2511 graham 125u unix 0xffff8c5bb77e4c80 0t0 43085 > > /run/ > > user/1000/akonadi/mysql.socket type=STREAM > > mysqld 2511 graham 126u unix 0xffff8c5b60ce0440 0t0 66284 > > /run/ > > user/1000/akonadi/mysql.socket type=STREAM > > mysqld 2511 graham 138u unix 0xffff8c5c05025d80 0t0 51606 > > /run/ > > user/1000/akonadi/mysql.socket type=STREAM > > mysql 3666 root 3u unix 0xffff8c5b56e550c0 0t0 60155 > > type=STREAM > > > > poking about in the process tree returns lots of cryptic commands. The > > number > > 3306 doesn't feature anywhere except /etc/my.cnf and bacula-dir.conf > > even > > though I'm running mysql, KMail and Bacula at the time. > > It would seem that you are not running "normal" mysql service. > It seems that you are running only the one started by akonadi. > > Could you please send the output of this command: > ps auxww | grep -i mysql
Yes of course - see below. But the mariadb service actually starts on boot. akonadi doesn't start at all until I run KMail, at which point it presumably connects to the already running mariadb/mysqldb. I have to do that because I need to have Bacula running long before I get out of bed and use KMail ;-). mysql 1263 0.0 1.6 1595128 128768 ? Ssl 08:41 0:00 /usr/sbin/ mysqld --defaults-file=/etc/my.cnf --user=mysql graham 2511 0.0 1.5 2484768 123896 ? Sl 08:43 0:01 /usr/sbin/ mysqld --defaults-file=/home/graham/.local/share/akonadi/mysql.conf -- datadir=/home/graham/.local/share/akonadi/db_data/ --socket=/run/user/1000/ akonadi/mysql.socket --pid-file=/run/user/1000/akonadi/mysql.pid Graham _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
