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

Reply via email to