Am Montag, 2. März 2015 11:04:07 UTC+1 schrieb Nico Haslberger: > Am Freitag, 27. Februar 2015 10:32:38 UTC+1 schrieb Bruno Friedmann: > > On Thursday 26 February 2015 10.55:32 Nico Haslberger wrote: > > > Am Donnerstag, 26. Februar 2015 14:37:00 UTC+1 schrieb [email protected]: > > > > Zitat von Nico Haslberger <[email protected]>: > > > > > > > > > Hello, > > > > > my bareos-dir can´t connect to mysql anymore: > > > > > > > > > > "26-Feb 14:22 Media-dir JobId 574: Fatal error: sql_get.c:621 > > > > > sql_get.c:621 query SELECT > > > > > PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge,MinBlocksize,MaxBlocksize > > > > > FROM Pool WHERE Pool.Name='Incremental' > > > > > failed: > > > > > Can't connect to local MySQL server through socket > > > > > '/var/run/mysqld/mysqld.sock' (111) > > > > > " > > > > > > > > That's the socket of MySQL... > > > > > > > > > I tried the configured user and password combination with the mysql > > > > > client tools and they are working fine. > > > > > > > > You are maybe trying to 127.0.0.1 (localhost) or at least not as user > > > > "bareos"? > > > > > > > > Check the socket permissions or configure Bareos to use TCP/IP > > > > directed to 127.0.0.1 > > > > > > > > Regards > > > > > > > > Andreas > > > > > > No I´m using an FQDN to connect, the user and the database is "bareos" 2 > > > days ago all worked well. > > > As I said I´m able to connect with the same settings an credentials using > > > the mysql client tool. > > > Any other ideas? > > > > > > > > > > There's few things to check > > An update of mysql could have restarted the daemon, and then bareos-dir is > > no more connected to it. > > > > the other is permissions changed to the socket location > > /var/run/mysqld/mysqld.sock > > check if that is still accessible to normal user like the one bareos is > > using. > > > > Another one, your mysql user bareos have no password before, and now is > > requiring one. > > (you said you're using fqdn which normally implies that you're using tcp > > connection in place of localhost socket) > > in mysql you could have no password for local socket and password for > > network connection > > > > > > -- > > > > Bruno Friedmann > > Ioda-Net Sàrl www.ioda-net.ch > > > > openSUSE Member & Board, fsfe fellowship > > GPG KEY : D5C9B751C4653227 > > irc: tigerfoot > > Yea, there was an mysql update a few days ago. > hmm the mysqld.sock service has the permissions mysql:mysql 777 so there > should be no problem with the permissions. > This is my catalog config: > http://paste.ee/p/xNQ3g > > Is there anything wrong in it? > greetings > Nico
Problem solved: I configured the fqdn on that machine on the interface ip address and mysql was not listening on that address. So I configured the fqdn also on the link-local address and all is working fine now! Thanks for your support! :) 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.
