Hello,
I'm trying to get bacula 2.03 working on FreeBSD. I'm using mysql5 as
the database server and i'm getting an error that a connection can not be
made to /tmp/mysql.soc. I've confirmed the file does exist. Using the mysql
command i can log in to the bacula database. For my mysql install i've added
the skip-networking and wait_time options to my /etc/my.cnf file and i've
also added a password for the root user. I've checked the manual and in the
catalog resource there's a section for defining a db socket, bacula is using
the right one. Here's my catalog resource definition:
# Generic catalog service
Catalog {
Name = MyCatalog
dbname = bacula; user = bacula; password = ""
}
The full error is below, but the base problem seems to be that bacula can't
talk to mysql over the socket.
Thanks.
Dave.
#bconsole
Connecting to Director bacula.davemehler.com:9101
1000 OK: zeus-dir Version: 2.0.3 (06 March 2007)
Enter a period to cancel a command.
*run
Automatically selected Catalog: MyCatalog
Using Catalog "MyCatalog"
A job name must be specified.
The defined Job resources are:
1: BackupCatalog
2: RestoreFiles
3: zeus_Root_Usr
4: isos-dvd
Select Job resource (1-4): 4
Run Backup job
JobName: isos-dvd
Level: Incremental
Client: zeus-fd
FileSet: Iso Files
Pool: DVD-Pool (From Job resource)
Storage: DVD-Writer (From Pool resource)
When: 2007-04-14 06:17:12
Priority: 10
OK to run? (yes/mod/no): y
Job queued. JobId=16
You have messages.
*
*messages
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Fatal error: Network
error with FD during Backup: ERR=Broken pipe
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Fatal error: No Job
status returned from FD.
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Error: sql_update.c:194
sql_update.c:194 update UPDATE Job SET JobStatus='f',EndTime='2007-04-14
06:10:00',ClientId=1,JobBytes=0,JobFiles=0,JobErrors=3,VolSessionId=1,VolSessionTime=1176530713,PoolId=7,FileSetId=1,JobTDate=1176545400,RealEndTime='2007-04-14
06:10:00',PriorJobId=0 WHERE JobId=14 failed:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
14-Apr 06:10 zeus-dir: sql_update.c:194 UPDATE Job SET
JobStatus='f',EndTime='2007-04-14
06:10:00',ClientId=1,JobBytes=0,JobFiles=0,JobErrors=3,VolSessionId=1,VolSessionTime=1176530713,PoolId=7,FileSetId=1,JobTDate=1176545400,RealEndTime='2007-04-14
06:10:00',PriorJobId=0 WHERE JobId=14
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Warning: Error updating
job record. sql_update.c:194 update UPDATE Job SET
JobStatus='f',EndTime='2007-04-14
06:10:00',ClientId=1,JobBytes=0,JobFiles=0,JobErrors=3,VolSessionId=1,VolSessionTime=1176530713,PoolId=7,FileSetId=1,JobTDate=1176545400,RealEndTime='2007-04-14
06:10:00',PriorJobId=0 WHERE JobId=14 failed:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Fatal error:
sql_get.c:288 sql_get.c:288 query SELECT
VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId
FROM Job WHERE JobId=14 failed:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
14-Apr 06:10 zeus-dir: sql_get.c:288 SELECT
VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId
FROM Job WHERE JobId=14
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Warning: Error getting
job record for stats: sql_get.c:288 query SELECT
VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId
FROM Job WHERE JobId=14 failed:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Fatal error:
sql_get.c:663 sql_get.c:663 query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.Name='zeus-fd' failed:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
14-Apr 06:10 zeus-dir: sql_get.c:663 SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.Name='zeus-fd'
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Warning: Error getting
client record for stats: Client record not found in Catalog.
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Fatal error:
sql_get.c:893 sql_get.c:893 query SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolParts,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId
FROM Media WHERE VolumeName='DVD-0001' failed:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
14-Apr 06:10 zeus-dir: sql_get.c:893 SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolParts,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId
FROM Media WHERE VolumeName='DVD-0001'
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Warning: Error getting
Media record for Volume "DVD-0001": ERR=Media record for Vol=DVD-0001 not
found in Catalog.
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Fatal error:
sql_get.c:351 sql_get.c:351 query SELECT VolumeName,MAX(VolIndex) FROM
JobMedia,Media WHERE JobMedia.JobId=14 AND JobMedia.MediaId=Media.MediaId
GROUP BY VolumeName ORDER BY 2 ASC failed:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
14-Apr 06:10 zeus-dir: sql_get.c:351 SELECT VolumeName,MAX(VolIndex) FROM
JobMedia,Media WHERE JobMedia.JobId=14 AND JobMedia.MediaId=Media.MediaId
GROUP BY VolumeName ORDER BY 2 ASC
14-Apr 06:10 zeus-dir: isos-dvd.2007-04-14_02.17.47 Error: Bacula 2.0.3
(06Mar07): 14-Apr-2007 06:10:00
JobId: 14
Job: isos-dvd.2007-04-14_02.17.47
Backup Level: Full (upgraded from Incremental)
Client: "zeus-fd"
FileSet: "Iso Files" 2007-04-13 20:16:45
Pool: "DVD-Pool" (From Job resource)
Storage: "DVD-Writer" (From Pool resource)
Scheduled time: 14-Apr-2007 02:17:46
Start time: 14-Apr-2007 02:17:53
End time: 14-Apr-2007 06:10:00
Elapsed time: 3 hours 52 mins 7 secs
Priority: 10
FD Files Written: 0
SD Files Written: 0
FD Bytes Written: 0 (0 B)
SD Bytes Written: 0 (0 B)
Rate: 0.0 KB/s
Software Compression: None
VSS: no
Encryption: no
Volume name(s):
Volume Session Id: 1
Volume Session Time: 1176530713
Last Volume Bytes: 0 (0 B)
Non-fatal FD errors: 4
SD Errors: 0
FD termination status: Error
SD termination status: Error
Termination: *** Backup Error ***
14-Apr 06:10 zeus-dir: message.c:481 Mail prog: bsmtp: bsmtp.c:329 Fatal
connect error to localhost: ERR=Connection refused
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/bacula-users
