Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Extremeley slow domain addition #141

Open
kdovale opened this issue Apr 11, 2023 · 17 comments
Open

Extremeley slow domain addition #141

kdovale opened this issue Apr 11, 2023 · 17 comments

Comments

@kdovale
Copy link

kdovale commented Apr 11, 2023

Describe the bug
Now we have upgraded to 1.4.9 from 1.4.8 which was working 100%, we see that, when adding a domain, it sits with the adding domain popup for up to 5 minutes before updating the page and showing the domain was added. However if we check on the database, the domain has been added, the domain is also added to the server, and dns is setup within 2 seconds of the create button being pressed. However the popup saying adding domain remains, and only completes the domain addition some 4 minutes later. This delay does not change if you turn off enable dns, or create website, etc it remains the same.

To Reproduce
Steps to reproduce the behavior:

  1. Go to 'domains' and add a domain

Expected behavior
The domain should add within a few seconds normally.

Screenshots
image

SolidCP Info

  • SolidCP Version: [e.g. 1.4.9]

Desktop (please complete the following information):

  • OS: Win11
  • Browser [e.g. chrome, safari, firefox]
    Latest

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

@berkut1
Copy link
Contributor

berkut1 commented Apr 17, 2023

Did you try a fresh install of 1.4.9?

@kdovale
Copy link
Author

kdovale commented Apr 17, 2023 via email

@berkut1
Copy link
Contributor

berkut1 commented Apr 17, 2023

You or someone said on the forum that there could probably be a problem with the database here after the upgrade.
Can you check that everything works correctly on a fresh install?

If you think that it's a db issue, try to check:

  1. What is the size of your MSSQL DB now?
  2. How fragmented is the db? (you can check that and defragment it from mssql management studio)

If you use a free version of MSSQL - it has some limitation that can slow your DB, if it use expensive queries - https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16#Cross-BoxScaleLimits

@kdovale
Copy link
Author

kdovale commented Apr 18, 2023

Hi,

the db is 96mb in size, and we running on mssql 2016 full version, as I mentioned in the forum, the additions to the db and the zones on ms is almost immediate, but the cp sits and waits for about 4 mins and then completes.

@RickyKleinhempel
Copy link
Contributor

I think this is due to the whois lookup to "whois.iana.org" on port 43. Could you check the firewall rules on your server?

@kdovale
Copy link
Author

kdovale commented May 26, 2023

with firewalls off it still exists, adding the domain takes ages. This all worked 100% until we updated to 1.4.9

@RickyKleinhempel
Copy link
Contributor

Can you please run the following command in a Powershell console?
Test-NetConnection whois.iana.org -port 43
To check the connection. The following picture is my result.
image

@kdovale
Copy link
Author

kdovale commented May 27, 2023

tests fine

PS C:\Users\Administrator> Test-NetConnection whois.iana.org -port 43

ComputerName : whois.iana.org
RemoteAddress : 192.0.47.59
RemotePort : 43
InterfaceAlias : Ethernet
SourceAddress : 196.22.190.36
TcpTestSucceeded : True

@kdovale
Copy link
Author

kdovale commented May 27, 2023

is this in the enterprise, console portal server ? that is where im running it.

@itmnetworks
Copy link

itmnetworks commented May 27, 2023 via email

@kdovale
Copy link
Author

kdovale commented Aug 7, 2023

Just a follow up on this issue with some more info regarding this problem, as we are still seeing this issue

  1. If I add a user account, ie manually add a hosting account and provide a domain name and then let the system create it. the whole process takes around 10 seconds and its done, domain added etc no issues.
  2. If I add a domain to an account, ie just add a domain, and I monitor the account via another browser session in a different browser, ie as the client. The moment I add the domain , in the clients account I can see the domain is added, the dns is created and the domain is made active within 15 seconds. However the admin account is still showing its adding the domain.
  3. This slow addition is also seen from the clients account if they add the domain.
  4. On the actual servers involved the dns are added and activated almost instantly without a delay. but the website is showing its still busy for about 2 minutes..
  5. When adding if you just say add domain, and dont select create website or enable dns gives the same issue.
  6. Deleting the domain happens immediately

I cant see why when adding with a user account vs adding a domain by itself incurrs a delay.

@kdovale
Copy link
Author

kdovale commented Sep 6, 2023

anyone ?

@kdovale
Copy link
Author

kdovale commented Oct 19, 2023

Hi Guys Im still having this issue despite reloading the files of the portal and enterprise server and asp 4.5 on the servers, the domain is created immediately on the dns but waits about 3 minutes still in the webpage before continuing on.. somewhere there must be a way to check what is causing this..

@kdovale
Copy link
Author

kdovale commented Oct 19, 2023

ok after checking all the software across all of the servers, there is no difference across any of them, but if I add an international tld, ie test.com, 1.dev, 1.xyz, etc it takes around 20-30 secs to add the domain and the page refershs, but if I do any south african, ie 1.co.za domain it takes 4 minutes to refresh, the domain is added immediately to the dns server, but the web page still takes 4 mins to refresh..

@kdovale
Copy link
Author

kdovale commented Nov 1, 2023

ok here is the weird part..... on the control server, we had put in the port 43 into the firewall to allow this traffic outbound... tun this rule off, and viola the .co.za domains get added in within 5 seconds..... why is this. ?? the other domains .com, etc they also now only take 5 secs to add... what is the cp doing in the back with this iana lookup??

@FuseCP-TRobinson
Copy link
Member

@kdovale Is this still an issue or was you able to solve it?

@kdovale
Copy link
Author

kdovale commented Nov 14, 2024

the way I have solved it it to stop solidcp, from allowing port 43 outbound, when port 43 is allowed it makes a call to whois.iana.org, if the port is opened it takes about 70 seconds before it adds any co.za domains, if its disabled, it takes 5 seconds.
I can see it adds the domain to dns provider, ie msdns immediately and sets up the dns pointers, regardless on how the port is active or not, so its seems its related to a lookup that times out. this port is on the control server, ie enterprise and portal are on it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants