Another FTP issue since upgrade to 10.2

[Morkie]

I upgraded to 10.2 and it failed to start the FTP service and left it down without any warning.

I now get the following when I try to login to the panel:


Warning: For the Panel to work, you need to select the default components from the list below. Make sure that the components you select are properly installed and configured. It is possible to change your selection afterwards.

Then a choice of 4, FTP Publishing Service 6.0, Gene6 (not installed), Microsoft FTP Service (not installed), Serv-U (not installed)

None of these choices can be clicked on, they are all grayed out. I cannot proceed without choosing one, so I'm stuck. I do have the IIS FTP Service installed but I can't choose that option.

I don't own the third party software, we've been using the built in FTP since installing the server.

The upgrade was at tech supports requests to fix a backup issues they've been unable to help me with for weeks.

Thanks,

- Frank

 

[Morkie]

Sorry I didn't include this:

- Windows Server 2003 SP2
- Plesk 10.2

- Frank

 

[Vampi1977]

Hi,

Look here maybe you have the same bug I had. It took me some hours to find out and fix it.

http://forum.parallels.com/showthread.php?t=109815

The Problem is that the IPs do not match any more in the IpAddressCollections Table and the ip_pool got chaged too.

In the ip_pool you will have now the Number of your ipadresses +1 added to your main account.

There will be one row to much in ip_pool after you fixed the IpAddressCollections Table after I deleted that my FTP Server was working again but i still needed to fix all extries that they have the right IpAddressCollection ID.

Kind regards,

Mark.

 

[Morkie]

I'll take a look at that right now Mark, Thanks for the idea! I saw something like this in another thread but didn't match this to my problem.

- Frank

 

[Morkie]

I tried a few things with my limited knowledge of how the Plesk db looks using dbclient.

Running the query in the linked thread, I got about 130+ IDs back as an answer (Mark just had 1, ID 29).

I then ran this:

C:\Program Files\Parallels\Plesk\admin\bin>dbclient.exe --direct-sql --sql="sele
ct top 10 * from ipaddressescollections"
ipCollectionId ipAddressId
1 3
2 3
3 3
4 3
5 3
6 3
7 3
8 3
9 3
10 3

Looks to me all sites had an ipaddressid of 3.

C:\Program Files\Parallels\Plesk\admin\bin>dbclient.exe --direct-sql --sql="sele
ct * from IP_addresses"
id ip_address mask iface ssl_certificate_id default_domain_i
d ftps status
1 172.21.0.34 255.255.255.0 "Local Area Connection 1" 1
0 false 0

But seems I only have 1 IP address listed?

I'm not sure in which direction to go next. I opened a ticket and it was escalated to 2nd tier two hours ago but I haven't heard anything yet.

Thanks!

- Frank

 

[Vampi1977]

Hi Frank,

I had multiple IPs (10) so the query from PavelV did only show 29 becaouse I had only 1Domain on last IP
but in Fact all my IPs did not match any more to my IDs except the first one.

There are maybe differnet ways to fix the issue.

PavelV said you should make a second db and load a backup in.

If you have only one IP The Fix might be easy. But i am not sure if this is the wy you shoudl fix it. I had no way back becaouse I did not pay attation and the psa backup was overwritten .... My fault will not happen a second time.

It seems all your IpAddressId's start with 3 maybe you had 2 other IPs there before. To get the stuff fixed you can set all IpAddressIds to 1 instead of 3 and then you need to have a look at ip_pool the ip_addresss id to 1 too.

In the IP_pool you will maybe find already everthing with the ipaddress_id 1 then you will have to delete lots of rows... at me it was only one with ip_addresses_id 11..

Other way is that you change teh ip_addresses table that you insert the same values with ID 3 and delete the one with ID1 --- But i never tried that let the support confirm that this is working and make a backup first before you change anything.

King regards,

Mark.

 

[Morkie]

Thanks Mark. They ended up fixing it with:

%plesk_bin%\defpackage.exe" --get --force

I appreciate the replies!

- Frank