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