Re: [Bacula-users] bsockcore issue.
OH, just found out that this was due to a run in which the catalog was not mounted. Sorry for the confusion but I haven't realised that till now. But on the other hand the problem may be caused by wrong authorisation for user bacula to the bacula database. I can only access the database with user root NOT bacula. -- Erik P. Olsen - Copenhagen, Denmark Fedora 30/64 bit Linux xfce Claws-Mail POP3 Gramps 5.1.1 Bacula 9.4.4 On 2019-12-16 at 15:34:56 Alf Normann Klausen wrote: > Dear Eric, > > In your email of 7th of December I can see this output: > > Dec 7 11:04:00 Erik-PC bacula-dir[1196]: bacula-dir: dird.c:1234-0 > mysql.c:268 Unable > to connect to MySQL server. Dec 7 11:04:00 Erik-PC bacula-dir[1196]: > Database=bacula > User=bacula Dec 7 11:04:00 Erik-PC bacula-dir[1196]: MySQL connect failed > either > server not running or your authorization is incorrect. > > > Is this why your bacula-dir fails? > > > Regards, Alf > > > > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ignore ctime
> On Mon, 16 Dec 2019 14:20:52 +0100, Helmut Ritter said: > > Hi, > > afaics this is still valid: > > https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=497514 > > As a result if I run a nightly script to ensure proper permissions on > folders (e.g. /var/www) Bacula picks all those files up although nothing > (except ctime) changed. > > Can I configure bacula to ignore ctime changes (and as a goody: for > specific folders)? Yes, see the mtimeonly option in the FileSet resource. OTOH, fixing the script to make no changes if the permissions are correct is probably the better option because mtimeonly=yes will break incr/diff backups. __Martin ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bsockcore issue.
Thanks, that could very well be it: [erik@Erik-PC ~]$ mysql bacula -u bacula -p Enter password: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'bacula' [erik@Erik-PC ~]$ But then: [erik@Erik-PC ~]$ mysql bacula -u root -p Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 194 Server version: 10.3.20-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [bacula]> show databases; ++ | Database | ++ | bacula | | information_schema | | mysql | | performance_schema | | test | ++ 5 rows in set (0.001 sec) MariaDB [bacula]> quit; Bye [erik@Erik-PC ~]$ So it doesn't like user bacula. How can I change it to accept user bacula? -- Erik P. Olsen - Copenhagen, Denmark Fedora 30/64 bit Linux xfce Claws-Mail POP3 Gramps 5.1.1 Bacula 9.4.4 On 2019-12-16 at 15:34:56 Alf Normann Klausen wrote: > Dear Eric, > > In your email of 7th of December I can see this output: > > Dec 7 11:04:00 Erik-PC bacula-dir[1196]: bacula-dir: dird.c:1234-0 > mysql.c:268 Unable > to connect to MySQL server. Dec 7 11:04:00 Erik-PC bacula-dir[1196]: > Database=bacula > User=bacula Dec 7 11:04:00 Erik-PC bacula-dir[1196]: MySQL connect failed > either > server not running or your authorization is incorrect. > > > Is this why your bacula-dir fails? > > > Regards, Alf > > > > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bsockcore issue.
On 2019-12-16 at 13:59:07 Martin Simmons wrote: > It looks like nothing is listening on port 9101, which is why bconsole cannot > connect. > > What is the output of running lsof as root? E.g. where 4226 is the pid of > bacula-dir (check it again with pgrep before running this): > > lsof -p 4226 [erik@Erik-PC ~]$ pgrep -lf bacula-dir 3511 bacula-dir [erik@Erik-PC ~]$ lsof -p 3511 [erik@Erik-PC ~]$ -- Erik P. Olsen - Copenhagen, Denmark Fedora 30/64 bit Linux xfce Claws-Mail POP3 Gramps 5.1.1 Bacula 9.4.4 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bsockcore issue.
On 2019-12-16 at 07:08:07 Josh Fisher wrote: > There should be 3 listening ports, bacula-sd listening on tcp 9101, > bacula-fd listening on tcp 9102, and bacula-sd listening on 9103. > Bconsole connects to bacula-sd's port 9101, regardless of interface. > > Try netstat -nltp. It should show all 3 listening ports and the apps > that own them. It looks like bacula-dir is not running. erik@Erik-PC ~]$ netstat -nltp (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 127.0.0.1:17603 0.0.0.0:* LISTEN 2189/dropbox tcp0 0 0.0.0.0:33060.0.0.0:* LISTEN - tcp0 0 127.0.0.1:3310 0.0.0.0:* LISTEN - tcp0 0 0.0.0.0:91020.0.0.0:* LISTEN - tcp0 0 0.0.0.0:91030.0.0.0:* LISTEN - tcp0 0 0.0.0.0:111 0.0.0.0:* LISTEN - tcp0 0 0.0.0.0:631 0.0.0.0:* LISTEN - tcp0 0 0.0.0.0:17500 0.0.0.0:* LISTEN 2189/dropbox tcp0 0 127.0.0.1:17600 0.0.0.0:* LISTEN 2189/dropbox tcp6 0 0 :::111 :::*LISTEN - tcp6 0 0 :::80 :::*LISTEN - tcp6 0 0 :::631 :::*LISTEN - tcp6 0 0 :::17500:::*LISTEN 2189/dropbox [erik@Erik-PC ~]$ -- Erik P. Olsen - Copenhagen, Denmark Fedora 30/64 bit Linux xfce Claws-Mail POP3 Gramps 5.1.1 Bacula 9.4.4 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bsockcore issue.
Dear Eric, In your email of 7th of December I can see this output: Dec 7 11:04:00 Erik-PC bacula-dir[1196]: bacula-dir: dird.c:1234-0 mysql.c:268 Unable to connect to MySQL server. Dec 7 11:04:00 Erik-PC bacula-dir[1196]: Database=bacula User=bacula Dec 7 11:04:00 Erik-PC bacula-dir[1196]: MySQL connect failed either server not running or your authorization is incorrect. Is this why your bacula-dir fails? Regards, Alf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bsockcore issue.
It looks like nothing is listening on port 9101, which is why bconsole cannot connect. What is the output of running lsof as root? E.g. where 4226 is the pid of bacula-dir (check it again with pgrep before running this): lsof -p 4226 You may need to install the lsof package from Fedora. __Martin > On Sat, 14 Dec 2019 21:43:28 +0100, Erik P Olsen said: > > OK, I tried your suggestion and got: > > [erik@Erik-PC ~]$ pgrep -lf bacula-dir > 4226 bacula-dir > > [erik@Erik-PC ~]$ netstat -an |grep LISTEN|grep 910 > tcp0 0 0.0.0.0:91020.0.0.0:* LISTEN > > tcp0 0 0.0.0.0:91030.0.0.0:* LISTEN > > I suppose this is correct. Regarding tcpdump I have no idea how to use it. I > have never > had the need to use this tool before so I have no result from it. > > systemctl status for mariadb.service, bacula-dir.service, bacula-fd.service > and > bacula-sd.service show all services running correctly. Oddly my old desktop > which is at > the same level as my laptop is running the same software and does indeed do > backups > flawlessly. Diagnosing bacula has become a nightmare :-( > > -- > Erik P. Olsen - Copenhagen, Denmark > Fedora 30/64 bit Linux xfce Claws-Mail POP3 Gramps 5.1.1 Bacula 9.4.4 > > On 2019-12-05 at 14:25:23 Pierre Bernhardt wrote: > > > Am 05.12.19 um 13:59 schrieb Erik P. Olsen: > > > Yes, ports 9101-9103 are all open. > > > Do you have root access like with sudo? > > Check on director server: > > > > Check that director is really running: > > > > pgrep -lf bacula-dir > > 8473 bacula-dir > > > > If running is should be opened 9101 > > which you can check with netstat: > > > > netstat -an |grep LISTEN|grep 910 > > > > You can try with tcpdump that a communication > > is try to established: > > > > sudo tcpdump -ni port 9101 > > > > There should be something like this shown if you are starting a bconsole > > from another machine: > > > > sudo tcpdump -ni eth0 port 9101 > > tcpdump: verbose output suppressed, use -v or -vv for full protocol decode > > listening on eth0, link-type EN10MB (Ethernet), capture size 262144 bytes > > root@backup:/media# tcpdump -ni eth0 port 9101 > > tcpdump: verbose output suppressed, use -v or -vv for full protocol decode > > listening on eth0, link-type EN10MB (Ethernet), capture size 262144 bytes > > 14:20:15.645897 IP 192.168.2.202.43984 > 192.168.2.254.9101: Flags [S], seq > > 157316563, > > win 29200, options [mss 1460,sackOK,TS val 362236160 ecr 0,nop,wscale 7], > > length 0 > > 14:20:15.645931 IP 192.168.2.254.9101 > 192.168.2.202.43984: Flags [S.], seq > > 1935232238, ack 157316564, win 28960, options [mss 1460,sackOK,TS val > > 1402703476 ecr > > 362236160,nop,wscale 7], length 0 14:20:15.646116 IP 192.168.2.202.43984 > > > 192.168.2.254.9101: Flags [.], ack 1, win 229, options [nop,nop,TS val > > 362236160 ecr > > 1402703476], length 0 14:20:15.646547 IP 192.168.2.202.43984 > > > 192.168.2.254.9101: > > Flags [P.], seq 1:35, ack 1, win 229, options [nop,nop,TS val 362236160 ecr > > 1402703476], length 34 14:20:15.646598 IP 192.168.2.254.9101 > > > 192.168.2.202.43984: > > Flags [.], ack 35, win 227, options [nop,nop,TS val 1402703477 ecr > > 362236160], length 0 > > 14:20:15.646639 IP 192.168.2.254.9101 > 192.168.2.202.43984: Flags [P.], > > seq 1:60, ack > > 35, win 227, options [nop,nop,TS val 1402703477 ecr 362236160], length 59 > > 14:20:15.647063 IP 192.168.2.202.43984 > 192.168.2.254.9101: Flags [.], ack > > 60, win > > 229, options [nop,nop,TS val 362236160 ecr 1402703477], length 0 > > 14:20:15.647069 IP > > 192.168.2.202.43984 > 192.168.2.254.9101: Flags [P.], seq 35:62, ack 60, > > win 229, > > options [nop,nop,TS val 362236160 ecr 1402703477], length 27 > > 14:20:15.647114 IP > > 192.168.2.254.9101 > 192.168.2.202.43984: Flags [P.], seq 60:77, ack 62, > > win 227, > > options [nop,nop,TS val 1402703477 ecr 362236160], length 17 > > 14:20:15.647526 IP > > 192.168.2.202.43984 > 192.168.2.254.9101: Flags [P.], seq 62:119, ack 77, > > win 229, > > options [nop,nop,TS val 362236160 ecr 1402703477], length 57 > > 14:20:15.647567 IP > > 192.168.2.254.9101 > 192.168.2.202.43984: Flags [P.], seq 77:104, ack 119, > > win 227, > > options [nop,nop,TS val 1402703477 ecr 362236160], length 27 > > 14:20:15.647782 IP > > 192.168.2.202.43984 > 192.168.2.254.9101: Flags [P.], seq 119:136, ack 104, > > win 229, > > options [nop,nop,TS val 362236160 ecr 1402703477], length 17 > > 14:20:15.690505 IP > > 192.168.2.254.9101 > 192.168.2.202.43984: Flags [.], ack 136, win 227, > > options > > [nop,nop,TS val 1402703488 ecr 362236160], length 0 14:20:15.690896 IP > > 192.168.2.202.43984 > 192.168.2.254.9101: Flags [P.], seq 136:653, ack 104, > > win 229, > > options [nop,nop,TS val 362236171 ecr 1402703488], length 517 > > 14:20:15.690907 IP > > 192.168.2.254.9101 > 192.168.2.202.43984: Flags [.], ack 653, win 235, > > options > > [nop,nop,TS
Re: [Bacula-users] bsockcore issue.
On 12/16/2019 8:35 AM, Martin Simmons wrote: On Mon, 16 Dec 2019 07:08:07 -0500, Josh Fisher said: On 12/14/2019 3:43 PM, Erik P. Olsen wrote: OK, I tried your suggestion and got: [erik@Erik-PC ~]$ pgrep -lf bacula-dir 4226 bacula-dir [erik@Erik-PC ~]$ netstat -an |grep LISTEN|grep 910 tcp0 0 0.0.0.0:91020.0.0.0:* LISTEN tcp0 0 0.0.0.0:91030.0.0.0:* LISTEN There should be 3 listening ports, bacula-sd listening on tcp 9101, bacula-fd listening on tcp 9102, and bacula-sd listening on 9103. Bconsole connects to bacula-sd's port 9101, regardless of interface. I think you meant bacula-dir on 9101. Yes. Thank you. __Martin ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bsockcore issue.
> On Mon, 16 Dec 2019 07:08:07 -0500, Josh Fisher said: > > On 12/14/2019 3:43 PM, Erik P. Olsen wrote: > > OK, I tried your suggestion and got: > > > > [erik@Erik-PC ~]$ pgrep -lf bacula-dir > > 4226 bacula-dir > > > > [erik@Erik-PC ~]$ netstat -an |grep LISTEN|grep 910 > > tcp0 0 0.0.0.0:91020.0.0.0:* LISTEN > > tcp0 0 0.0.0.0:91030.0.0.0:* LISTEN > > > There should be 3 listening ports, bacula-sd listening on tcp 9101, > bacula-fd listening on tcp 9102, and bacula-sd listening on 9103. > Bconsole connects to bacula-sd's port 9101, regardless of interface. I think you meant bacula-dir on 9101. __Martin ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Ignore ctime
Hi, afaics this is still valid: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=497514 As a result if I run a nightly script to ensure proper permissions on folders (e.g. /var/www) Bacula picks all those files up although nothing (except ctime) changed. Can I configure bacula to ignore ctime changes (and as a goody: for specific folders)? Thank you! ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bsockcore issue.
On 12/14/2019 3:43 PM, Erik P. Olsen wrote: OK, I tried your suggestion and got: [erik@Erik-PC ~]$ pgrep -lf bacula-dir 4226 bacula-dir [erik@Erik-PC ~]$ netstat -an |grep LISTEN|grep 910 tcp0 0 0.0.0.0:91020.0.0.0:* LISTEN tcp0 0 0.0.0.0:91030.0.0.0:* LISTEN There should be 3 listening ports, bacula-sd listening on tcp 9101, bacula-fd listening on tcp 9102, and bacula-sd listening on 9103. Bconsole connects to bacula-sd's port 9101, regardless of interface. Try netstat -nltp. It should show all 3 listening ports and the apps that own them. It looks like bacula-dir is not running. I suppose this is correct. Regarding tcpdump I have no idea how to use it. I have never had the need to use this tool before so I have no result from it. systemctl status for mariadb.service, bacula-dir.service, bacula-fd.service and bacula-sd.service show all services running correctly. Oddly my old desktop which is at the same level as my laptop is running the same software and does indeed do backups flawlessly. Diagnosing bacula has become a nightmare :-( ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users