martin-rohwedder / MySQL-Backup-Manager

MySQL Backup Manager is a simple software solution for backing up MySQL Databases automatically. It uses a Windows service for the backup process and has an GUI attached for administrating which databases needs backup
http://martin-rohwedder.github.io/MySQL-Backup-Manager/
30 stars 33 forks source link

Error 1001 during setup #18

Open dtc13579 opened 10 years ago

dtc13579 commented 10 years ago

When attempting to install on Windows 7 Pro (SP1, 64bit), I receive "Error 1001" (see attached)

clipboard01

asiersanchez commented 10 years ago

Same error.....

Olito commented 10 years ago

Windows 7 Pro, 32bits. Same problem.....

martin-rohwedder commented 10 years ago

Hi, I haven't encountered that error, on any machine I have tested on. Can you explain a little more

Are you administrator when doing the install? Do you have Microsoft .Net Framework 4.5 installed on the computer?

dtc13579 commented 10 years ago

Yes, I tried running the setup as admin. Yes, 4.5 is installed.

On Thu, Jun 19, 2014 at 8:18 AM, Martin Rohwedder notifications@github.com wrote:

Hi, I haven't encountered that error, on any machine I have tested on. Can you explain a little more

Are you administrator when doing the install? Do you have Microsoft .Net Framework 4.5 installed on the computer?

— Reply to this email directly or view it on GitHub https://github.com/martin-rohwedder/MySQL-Backup-Manager/issues/18#issuecomment-46558553 .

martin-rohwedder commented 10 years ago

Ok, I'll see if I can find a solution :+1:

ghost commented 10 years ago

I got the same error. It is an error with the installer. I downloaded all versions from sourceforge and they all give the same error 1001.

The installer puts the files in the directory (program files(x86)\,...), then gives the error and then deletes the files again. Here a screenshot of the files (not pressed ok yet on the 1001 error). install_2

I copied the files before I pressed ok at the error 1001 and then it I can open the program (MySQLBackupManager.exe) but I it doesn't seem to make the backups.

Maybe it's a problem with installing the backupservice?

ghost commented 10 years ago

I tried installing MySQLBackupService.exe as a service and this is what I got:

[log] Installing assembly 'C:\Program Files (x86)\Rohwedder Software\Mysql Backup Manager\MySQLBackupService.exe'. Affected parameters are: logtoconsole = logfile = C:\Program Files (x86)\Rohwedder Software\Mysql Backup Manager\MySQLBackupService.InstallLog assemblypath = C:\Program Files (x86)\Rohwedder Software\Mysql Backup Manager\MySQLBackupService.exe Installing service MySQL Backup Service... Service MySQL Backup Service has been successfully installed. Creating EventLog source MySQL Backup Service in log Application... An exception occurred in the OnAfterInstall event handler of MySQLBackupService.ProjectInstaller. System.ArgumentNullException: Value cannot be null. Parameter name: value Rolling back assembly 'C:\Program Files (x86)\Rohwedder Software\Mysql Backup Manager\MySQLBackupService.exe'. Affected parameters are: logtoconsole = logfile = C:\Program Files (x86)\Rohwedder Software\Mysql Backup Manager\MySQLBackupService.InstallLog assemblypath = C:\Program Files (x86)\Rohwedder Software\Mysql Backup Manager\MySQLBackupService.exe Restoring event log to previous state for source MySQL Backup Service. Service MySQL Backup Service is being removed from the system... Service MySQL Backup Service was successfully removed from the system. [end log]

I think this is why we get the error 1001 during the installation. Something prevents it from being installed as a service. I tried executing MySQLBackupService.exe, but then it says it has to be installed as a service.

Edit: I added the program as a service using these commands: sc create MysqlBackupService binPath= "C:\Program Files (x86)\Rohwedder Software\Mysql Backup Manager\MySQLBackupService.exe" Displayname= "MysqlBackupService" start= auto

sc start MysqlBackupService

Now MysqlBackupService is running as a service, but it still doesn't create backups. :-(

P.S.: Maybe you can add a functionality to test if you can connect to a database?

flabbe commented 10 years ago

Windows 2008 same, error 1001

jamiew0w commented 10 years ago

Having same errors on 2012 r2.

Bobspadger commented 9 years ago

yep having this on win2008 standard

lenaicmignot commented 9 years ago

Same problem Windows 7 pro 64 bit.

fabrix77 commented 9 years ago

Hi Martin, I want suggest you a way for resolution of Error 1001 that I have found googling: http://geeks.vivavivu.com/2013/04/solving-error-1001-unable-to-get.html

dabros commented 9 years ago

Same issue here - the fix @fabrix77 quoted seems all developer side too. I did grab source files but had 'upgrade error' when i opened it in VS 2012, so figured even if i compiled it would give same error

cbaerike commented 9 years ago

I just had a look at the code - this happens in the AfterInstall event of the service, specifically in the library.GetMySQLBinLocation() method. If the "HKLM\SOFTWARE\Wow6432Node\MySQL AB" registry key does not exist (i.e. when you're not using the MySQL Installer, or when you're using MariaDB instead, or when you're using a 32-bit OS, or the 64-bit version of MySQL), then the Utilities.RetrieveMySQLInstallationBinPath() method causes a null reference error.

For everyone who's having the issue, here's a temporary workaround until Martin can fix this:

  1. Create a new registry key in HKLM\SOFTWARE\Wow6432Node, called "MySQL AB"
  2. In there, create a Subkey called "MySQL Server"
  3. In this key, create a String value called "Location"
  4. Set the value to your MySQL install folder (make sure it ends with a backslash!)

Here's a regedit export that makes it a bit easier (just edit the install location):

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\MySQL AB\MySQL Server]
"Location"="D:\\Temp\\"

Now, the installer finds the correct key, and adds the install folder + "bin\" to your PATH variable. This allows the service to find the mysqldump.exe file for backups.

cbaerike commented 9 years ago

Martin doesn't seem interested in the pull request. I've created a fork and released version 1.4 which fixes the issue: https://github.com/cbaerike/MySQL-Backup-Manager/releases

taisoftsa commented 8 years ago

I still got the error on Install. Its a windows server standar 2007. I dont know what else can i do

cbaerike commented 8 years ago

While most issues causing this error are fixed, there still seem to be instances where this can happen. This thread continues here: https://github.com/cbaerike/MySQL-Backup-Manager/issues/12