Am Dienstag, 3. März 2015 15:27:27 UTC+1 schrieb Nico Haslberger: > 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
any other ideas? -- 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 bareos-users+unsubscr...@googlegroups.com. To post to this group, send email to bareos-users@googlegroups.com. For more options, visit https://groups.google.com/d/optout.