Hello,
I have been using your PosgresQL backup tool for free for some time and it was working nice. Now I upgraded to your “SQLBackupand FTP” software, because I need to backup some MySQL databases too, but it does not work. MySQL backups works nice, but with PostgreSQL backup,i recieved error. Test connection to the DB server is OK, connection to the storage is OK, but the backup job fail with error " * ERROR: Job execution error: Access is denied Computer name: “my_server”".
I have enabled advanced log and it shows this:
“2019-01-12 00:27:50.1079|DEBUG|43|SqlBak.Job.PostgreSql.Business.Def.PostgreSqlDef|GetPostgreSqlFilePath. ConnectionInfo: “SqlBak.Job.PostgreSql.Impl.PostgreSqlConnectionInfo”; FileName: “pg_dump.exe”
2019-01-12 00:27:50.1079|DEBUG|43|SqlBak.Job.PostgreSql.Business.Def.PostgreSqlDef|GetPostgreSqlFilePath. PathToBinFolder: “”; FileName: “pg_dump.exe”
2019-01-12 00:27:50.1079|DEBUG|43|SqlBak.Job.PostgreSql.Business.Def.PostgreSqlDef|GetPostgreSqlFilePath. Return: “C:\Program Files (x86)\SQLBackupAndFTP\DBMS\PostgreSql”
2019-01-12 00:27:50.1079|DEBUG|43|SqlBak.Job.PostgreSql.Business.Def.PostgreSqlDef|GetPostgreSqlFilePath. Return: “C:\Program Files (x86)\SQLBackupAndFTP\DBMS\PostgreSql”
2019-01-12 00:27:50.1079|ERROR|43|Net.Pranas.SqlBak.Job.Business.Base.JobBase|Run|System.ComponentModel.Win32Exception (0x80004005): Access is denied
at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
at SqlBak.Job.PostgreSql.Impl.Operations.PostgreSqlDatabaseOperation.GetBackupToolsInfo()
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupDatabases(IJob job, IDatabaseHandler dbHandler, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters runParameters, WorkingFolders folders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Dictionary2 archiveFileNames, Nullable1 customMaxFileSize, IDestinationHandler destinationHandler)
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupObjects(IJob job, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters parameters, WorkingFolders workingFolders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Nullable1 maxFileSize, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler) at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupJob(IJob job, IJobRunInfo runInfo, IScriptExecutor scriptsExecutor, IJobInfo jobInfo, WorkingFolders workingFolders, JobRunParameters parameters, JobRunReport result, DestinationBackupHelper[] destinations, ApplicationType applicationType, Boolean& scriptsAfterRun, ICleanupHandler cleanupHandler, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler) at Net.Pranas.SqlBak.Job.Business.Base.JobBase.Run(IJobRunInfo runInfo, JobPlanViolationsInfo jobPlanViolationsInfo) 2019-01-12 00:27:50.1079|DEBUG|170|Pranas.Net.SqlBak.Service.SBF.DesktopAppService|LoadDeltaJobLogDetail. Return: "IsSuccess: True; Error: ""; Value: "SBF.Channel.Contract.DataContract.JobLogDetailDelta"" 2019-01-12 00:27:50.1079|DEBUG|148|Pranas.Net.SqlBak.Service.SBF.Logging.SilentSbfLog.SilentLogHandler|TraceAppError. LogSource: "Application"; Message: "Access is denied"; StackTrace: " at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo) at System.Diagnostics.Process.Start(ProcessStartInfo startInfo) at SqlBak.Job.PostgreSql.Impl.Operations.PostgreSqlDatabaseOperation.GetBackupToolsInfo() at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupDatabases(IJob job, IDatabaseHandler dbHandler, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters runParameters, WorkingFolders folders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Dictionary2 archiveFileNames, Nullable1 customMaxFileSize, IDestinationHandler destinationHandler) at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupObjects(IJob job, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters parameters, WorkingFolders workingFolders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Nullable1 maxFileSize, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler)
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupJob(IJob job, IJobRunInfo runInfo, IScriptExecutor scriptsExecutor, IJobInfo jobInfo, WorkingFolders workingFolders, JobRunParameters parameters, JobRunReport result, DestinationBackupHelper[] destinations, ApplicationType applicationType, Boolean& scriptsAfterRun, ICleanupHandler cleanupHandler, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler)
at Net.Pranas.SqlBak.Job.Business.Base.JobBase.Run(IJobRunInfo runInfo, JobPlanViolationsInfo jobPlanViolationsInfo)”
2019-01-12 00:27:50.1079|DEBUG|148|Net.Pranas.SqlBak.Context.Context.Data.ProfileDatabaseHandler|LoadSendErrorReportEnabled
2019-01-12 00:27:50.1079|DEBUG|148|Net.Pranas.SqlBak.Context.Context.Data.ProfileDatabaseHandler|LoadSendErrorReportEnabled. Return: “True”
2019-01-12 00:27:50.1079|TRACE|148|Pranas.Net.SqlBak.Service.SBF.Logging.SilentSbfLog.SilentLogHandler|TraceError. IsSendErrorReportEnabled: “True”
2019-01-12 00:27:50.1079|TRACE|148|Pranas.Net.SqlBak.Service.SBF.Logging.SilentSbfLog.SilentLogHandler|TraceError. For this installation forbidden send log
2019-01-12 00:27:50.1079|DEBUG|148|Pranas.Net.SqlBak.Service.SBF.Logging.SilentSbfLog.SilentLogHandler|TraceAppError. Return
2019-01-12 00:27:50.1079|DEBUG|43|Net.Pranas.SqlBak.Log.Core.Logger|Serialize. Limit: “8192”|System.ComponentModel.Win32Exception (0x80004005): Access is denied
at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
at SqlBak.Job.PostgreSql.Impl.Operations.PostgreSqlDatabaseOperation.GetBackupToolsInfo()
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupDatabases(IJob job, IDatabaseHandler dbHandler, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters runParameters, WorkingFolders folders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Dictionary2 archiveFileNames, Nullable1 customMaxFileSize, IDestinationHandler destinationHandler)
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupObjects(IJob job, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters parameters, WorkingFolders workingFolders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Nullable1 maxFileSize, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler) at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupJob(IJob job, IJobRunInfo runInfo, IScriptExecutor scriptsExecutor, IJobInfo jobInfo, WorkingFolders workingFolders, JobRunParameters parameters, JobRunReport result, DestinationBackupHelper[] destinations, ApplicationType applicationType, Boolean& scriptsAfterRun, ICleanupHandler cleanupHandler, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler) at Net.Pranas.SqlBak.Job.Business.Base.JobBase.Run(IJobRunInfo runInfo, JobPlanViolationsInfo jobPlanViolationsInfo) 2019-01-12 00:27:50.1079|TRACE|43|Net.Pranas.SqlBak.Job.Business.Base.JobBase|Run. Trace event. JobId: "{LocalId:3; GlobalId:3}"; Severity: "Error"; ActionType: "SqlBak_JobError4". 2019-01-12 00:27:50.1269|DEBUG|170|Pranas.Net.SqlBak.Service.SBF.LocalNetPipeService.LocalJobTraceService|TraceBackupLog. LocalBackupId: "9"; Severity: "Error"; ActionType: "SqlBak_JobError4" 2019-01-12 00:27:50.1269|DEBUG|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. LocalBackupId: "9"; ActionType: "SqlBak_JobError4"; BackupLogKey: "594441095200c1ab119e518f18c91a16" 2019-01-12 00:27:50.1269|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting record into [BackupLog] table. LocalBackupId: "9" 2019-01-12 00:27:50.1849|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. A record of [BackupLog] table has successfully inserted. BackupLogId: "119" 2019-01-12 00:27:50.1849|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting "5" records into [BackupLogParam] table 2019-01-12 00:27:50.1849|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting a record into [BackupLogParam] table. BackupLogId: "119"; ParamName: "Code"; ParamValue: "JOB-BAK:2001#1" 2019-01-12 00:27:50.2139|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting a record into [BackupLogParam] table. BackupLogId: "119"; ParamName: "Error"; ParamValue: "Access is denied" 2019-01-12 00:27:50.2699|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting a record into [BackupLogParam] table. BackupLogId: "119"; ParamName: "AgentId"; ParamValue: "0" 2019-01-12 00:27:50.3469|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting a record into [BackupLogParam] table. BackupLogId: "119"; ParamName: "AgentName"; ParamValue: "ALPHACOOL" 2019-01-12 00:27:50.4389|TRACE|170|Net.Pranas.SqlBak.Context.Context.Data.RoutinesDatabaseHandler|TraceBackupLog. Inserting a record into [BackupLogParam] table. BackupLogId: "119"; ParamName: "_exception"; ParamValue: "System.ComponentModel.Win32Exception (0x80004005): Access is denied at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo) at System.Diagnostics.Process.Start(ProcessStartInfo startInfo) at SqlBak.Job.PostgreSql.Impl.Operations.PostgreSqlDatabaseOperation.GetBackupToolsInfo() at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupDatabases(IJob job, IDatabaseHandler dbHandler, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters runParameters, WorkingFolders folders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Dictionary2 archiveFileNames, Nullable1 customMaxFileSize, IDestinationHandler destinationHandler) at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupObjects(IJob job, IJobInfo jobInfo, IJobRunInfo runInfo, JobRunParameters parameters, WorkingFolders workingFolders, JobRunReport runReport, DestinationBackupHelper[] destinations, ApplicationType applicationType, Nullable1 maxFileSize, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler)
at Net.Pranas.SqlBak.Job.Core.JobHandler.BackupJob(IJob job, IJobRunInfo runInfo, IScriptExecutor scriptsExecutor, IJobInfo jobInfo, WorkingFolders workingFolders, JobRunParameters parameters, JobRunReport result, DestinationBackupHelper[] destinations, ApplicationType applicationType, Boolean& scriptsAfterRun, ICleanupHandler cleanupHandler, IDestinationHandler destinationHandler, IDatabaseHandler databaseHandler)
at Net.Pranas.SqlBak.Job.Business.Base.JobBase.Run(IJobRunInfo runInfo, JobPlanViolationsInfo jobPlanViolationsInfo)""
I have checked premissions on pg_dump and looks ok. I have checked premissions on the temp folder, and it looks OK. What am I doing wrong ? I just wanted to order standard licence for backing up everytning, but I dont know how to solve this.
Thank you.