Am Montag, 2. März 2015 16:39:29 UTC+1 schrieb Bruno Friedmann: > On Monday 02 March 2015 05.28:26 Nico Haslberger wrote: > > > Am Donnerstag, 26. Februar 2015 14:25:33 UTC+1 schrieb Nico Haslberger: > > > > 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) > > > > " > > > > > > > > I tried the configured user and password combination with the mysql > > > client tools and they are working fine. > > > > > > > > Whats wrong here? > > > > > > > > greetings > > > > Nico > > > > > > Ok unfortunatelly the issue is not solved: > > > I´m able to restart the bareos-dir and all is working fine, but when I try > > to run a job I´m getting the following error: > > > http://paste.ee/p/94GdK > > > What the hack is wrong here? > > > > > > greetings > > > Nico > > > > Could be related to which real ip and protocol mysql is listening now. > > In the past mysql was not able to handle ipv6 connection which happend by > default on dual stack. > > Now perhaps they can. > > > > What I don't understand in your setup is the why using localhost thus using > socket connection would not work. > > In any case it would be better than the overload create by tcp connections. > > > > checking connections and open port with ss -tanp will give who is connected > to what. > > try to compare bareos-dir <-> mysql connection with normal mysql client > connected. > > > > Also review your catalog definition with > > > > # Generic catalog service > > Catalog { > > Name = MyCatalog > > dbdriver = "mysql" > > dbname = "bareos" > > dbuser = "bareos" > > dbpassword = "yourpassword" > > } > > > > Which should use the localhost/socket connection. > > > > -- > > > > Bruno Friedmann > > Ioda-Net Sàrl www.ioda-net.ch > > > > openSUSE Member & Board, fsfe fellowship > > GPG KEY : D5C9B751C4653227 > > irc: tigerfoot > >
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 -- 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.
