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