Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
MySQL backup will not STOR Options · View
swaptoo
#1 Posted : Sunday, October 30, 2016 5:40:17 AM
Rank: Newbie

Groups: Registered

Joined: 10/30/2016
Posts: 3
Location: Netherlands
Hi,

I just installed MySQLbackupFTP on one server to test if the program is working before licensing it. But we get errors backing up the database.

It all starts with the testing of the FTP location. While examining the log files of the FTP server i can see that the backup solution is connecting to the FTP server it logs in and asked for the size of a test file that does not exist. it will keep asking for the size and eventually stops. by then we can see an error in the backup software.

If we start running the real backup this problem also is visible. but only now we can see in the backup log window:

- Uploading (name).zip to ftp://(IP)
- a connection attempt had failed because the connecting party did not anwser......

But after that the backup solution reconnects tries to find the size of a file that does not exist and ties and tries...

My question is this:

- What is happening here? if i use wireshark i only see the connection that gives the error. before that there are no TCP packets leaving the server, it seems the first attempt is not made?
- Maybe it is an solution to check if a ZIP file exist and is not re-upload the file to start again. Now it will get stuck in a loop and will fail.


With regards,

Aron
Alexander Omelchenko
#2 Posted : Monday, October 31, 2016 4:26:45 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 348
Hi,

To solve this issue, please open your backup job and go to your backup destination menu. Open "FTP Settings" window, click "Advanced FTP settings" and set "Data connection" to "Passive (PASV)". Also, please check off "Write FTP session to log". Then run the backup job. If you still have this issue please send us the .log file.
Alexander Omelchenko attached the following image(s):
FTP Settings 2016-10-31 11.25.21.png
swaptoo
#3 Posted : Monday, October 31, 2016 11:09:21 AM
Rank: Newbie

Groups: Registered

Joined: 10/30/2016
Posts: 3
Location: Netherlands
It seems that PASV mode was already chosen.

Here is the log.
DETAILED LOG:
10/31/2016 16:34:55 Creating backup of kasku to E:\Pranas.NET\MySqlBF\ee3g2r3g
10/31/2016 16:44:05 WARNING: mysqldump: [Warning] Using a password on the command line interface can be insecure.
10/31/2016 16:44:05 Compressing (internal zip) kasku201610311634.sql to E:\Pranas.NET\MySqlBF\ee3g2r3g
10/31/2016 16:59:54 Compression completed (archive size: 6.368.772 KB)
10/31/2016 16:59:54 Removing kasku201610311634.sql from E:\Pranas.NET\MySqlBF\ee3g2r3g
10/31/2016 16:59:54 Connecting to ftp://IP:21/
10/31/2016 16:59:54 Uploading kasku201610311634.zip to ftp://IP:21/ (kasku201610311634.zip)
10/31/2016 16:59:54 < 220 What you wanna do?
10/31/2016 16:59:54 > USER USERNAME
10/31/2016 16:59:54 < 331 Password required for USERNAME
10/31/2016 16:59:54 > PASS ***
10/31/2016 16:59:54 < 230 Logged on
10/31/2016 16:59:54 > PWD
10/31/2016 16:59:54 < 257 "/" is current directory.
10/31/2016 16:59:54 > TYPE I
10/31/2016 16:59:54 < 200 Type set to I
10/31/2016 16:59:54 > SIZE kasku201610311634.zip
10/31/2016 16:59:54 < 550 File not found
10/31/2016 16:59:54 > PASV
10/31/2016 16:59:54 < 227 Entering Passive Mode (84,25,95,69,3,224)
10/31/2016 17:00:17 WARNING: Een verbindingspoging is mislukt omdat de verbonden party niet correct heeft geantwoord na een bepaalde tijd, of de gemaakte verbinding is mislukt omdat de verbonden host niet heeft geantwoord IP:992
10/31/2016 17:00:19 < 220 What you wanna do?
10/31/2016 17:00:19 > USER USERNAME
10/31/2016 17:00:19 < 331 Password required for USERNAME
10/31/2016 17:00:19 > PASS ***
10/31/2016 17:00:19 < 230 Logged on
10/31/2016 17:00:19 > CWD /
10/31/2016 17:00:19 < 250 CWD successful. "/" is current directory.
10/31/2016 17:00:19 > TYPE I
10/31/2016 17:00:19 < 200 Type set to I
10/31/2016 17:00:19 > SIZE kasku201610311634.zip
10/31/2016 17:00:19 < 550 File not found
10/31/2016 17:00:19 WARNING: "SBFDS3006": Ftp destination exception > Request: SIZE kasku201610311634.zip
Response: 550 File not found

After this it keeps gooing and gooing until it gives up with the SIZE request.
Alexander Omelchenko
#4 Posted : Tuesday, November 1, 2016 9:16:18 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 348
Please try to connect with UseControlAddressForPassive property.
1. Close MySQLBackupFTP application.
2. Open the .mjobx file with notepad.
3. Change the file (bold text):
<Destination pranas:Type="FTP" Uri="ftp://XXXXXXXXXXXXXXXXX/" Port="XXX" Path="" UserName="XXX" Password="SBFCode:XXXXXXXXXXXXXXXXXXX" DataConnection="Passive" Protocol="Ftp" TraceLog="false" PartLength="8388608" UseControlAddressForPassive="true" Id="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXxx">
<KeepInfo KeepMonths="6" KeepDays="0" />
</Destination>
4. Save the .mjobx file.
5. Open the .mjobx file with MySQLBackupFTP application and try to connect to the FTP server.
swaptoo
#5 Posted : Wednesday, November 2, 2016 5:49:01 AM
Rank: Newbie

Groups: Registered

Joined: 10/30/2016
Posts: 3
Location: Netherlands
It works! :)
Alexander Omelchenko
#6 Posted : Wednesday, November 2, 2016 8:06:44 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 348
Great! Please feel free to contact us on any issues or concerns.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com