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