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. Graham _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
