Am Montag, 9. März 2015 10:47:09 UTC+1 schrieb Stephan Duehr: > 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
My mysql error.log tells me this: https://paste.ee/p/BNkpu No I´m doing my updates manually but this is the only database server that died after a minor security update... I´ll switch to mariadb and hope this runs better than the destroyed mysql (thx to oracle)... greetings Nico -- 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.
