On 03/08/2015 01:54 PM, Nico Haslberger wrote: > Am Samstag, 7. März 2015 10:36:57 UTC+1 schrieb Marco van Wieringen: >> On 03/ 7/15 10:20 AM, Bruno Friedmann wrote: >>> On Friday 06 March 2015 14.21:55 Nico Haslberger wrote: >>>> Am Donnerstag, 5. März 2015 21:21:51 UTC+1 schrieb Bruno Friedmann: >>>>>>>> Which should use the localhost/socket connection. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> I modified the config as you said. >>>>>>> The thing is now: >>>>>>> My the fd that is running on the machine where the dir runs is able to >>>>>>> backup, but every remote fd terminates with the same sql error :\ >>>>>>> >>>>>>> greetings >>>>>>> Nico >>>>>> any other ideas? >>>>> you mean that when you do a status client client=remote-fd the console >>>>> failed with mysql error? >>>>> and not when doing status client=local-fd ??? >>>>> >>>>> Dude I'm happy to use a real database like postgresql then :-))) >>>>> >>>>> But I'm still confident this is mostly a configuration trouble, somewhere >>>>> somewhat, but where and what depend of your changes. >>>>> >>>> No the thing is, status is working fine for every client, but when I try >>>> to start a backup job of a remote client it is failing with the described >>>> sql error. >>>> >>>> Oh god I hate postgres, but I think I will change to MariaDB, because >>>> MySQL is crap since Oracle. :D >>>> >>>> I´m absolutely speechless for this issue and I have no idea whats wrong >>>> here. I didn´t changed my config the issue suddenly appeard one day. >>>> >>>> greetings >>>> Nico >>> So it's mostly happening when the director is inserting the files attr in >>> the database. But then I don't understand why it would success when it's >>> saving the local client. >>> >>> speechless too. >>> >> As it gives an error 111 that seems to indicate >> >> #define ECONNREFUSED 111 /* Connection refused */ >> >> Given this is a unix socket its most likely that mysql either puts its >> socket somewhere >> else or for whatever reason cannot open it by the mysql process and as >> such you have no >> connectivity. Tried the windows approach ? e.g. reboot the server. You >> could also have >> a look with lsof and see if any of the mysql processes have a unix >> socket open and which >> one. >> >> -- >> Marco van Wieringen [email protected] >> Bareos GmbH & Co. KG Phone: +49-221-63069389 >> http://www.bareos.com >> >> Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 >> Komplementär: Bareos Verwaltungs-GmbH >> Geschäftsführer: Stephan Dühr, M. Außendorf, J. Steffens, >> P. Storz, M. v. Wieringen > > Yes I rebooted the server several times but no changes: > Here is the output of sudo lsof | grep mysql: > https://paste.ee/p/zGdmg > > Now some of the clients are working but: > All differential jobs are working fine, but neither the inceremtial jobs are > working nor the full backup jobs: > > Director´s fd Full: > https://paste.ee/p/Kp4cA > > Director´s fd Differential: > https://paste.ee/p/bZTvl > > Director´s fd Incremental: > https://paste.ee/p/AQgtk > > greetings > Nico >
any error messages in /var/log/mysql/error.log ? Are automatic unattended updates enabled? As described in https://help.ubuntu.com/lts/serverguide/automatic-updates.html That would not be a good idea, because it may update mysql and restart it, which requires director restart. Regards -- Stephan Dühr [email protected] Bareos GmbH & Co. KG Phone: +49 221-630693-90 http://www.bareos.com Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Komplementär: Bareos Verwaltungs-GmbH Geschäftsführer: S. Dühr, M. Außendorf, J. Steffens, Philipp Storz, M. v. Wieringen -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
