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 -- 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.
