Plesk 11.x / Windows :: List Of Suspend Domains From Mysql
May 27, 2014
I need to get a list of suspend domains from mysql. The domains are suspend because they exceeded quota.So far I have done this query:
#############
select domains.id,
domains.name as domena,
Round(((sum(domains.real_size))/1048576),2) realMB,
(select Round((limits.value/1048576),2) from limits left join (domains, subscriptions, subscriptionproperties) on (domains.id=subscriptions.object_id and subscriptions.id=subscriptionproperties.subscription_id and subscriptionproperties.value=limits.id) where subscriptionproperties.name='limitsId' and limits.limit_name='disk_space' and domains.name=domena) quotaMB
from domains
where domains.status='2' and
(select (sum(domains.real_size)))>0
group by domains.cl_id;
but I didnt managed to get only those that exceed the quota.
View 3 Replies
ADVERTISEMENT
Jan 12, 2015
Impossible to find a way to show, by default, all domains and websites...
When I log on the Plesk Admin, I come first on a list of websites and domains, but they are not «all» listed. I have to go to the full bottom of the page to click on «Show all».
I didn't find a preference or anything else to change that, and I don't understand why all domains are not listed.
View 3 Replies
View Related
Oct 23, 2008
Is there any way that Summary Report can show me the list of all domains with domain templates? Or any other way (not Summary Report)?
I need a list of all domains with information about hosting packages (domain templates)...
View 2 Replies
View Related
Aug 25, 2014
After a migration I did this weekend I mis a couple of the migrated domains in the subscription list. The domains are working great, but I cannot find them in Plesk.
I got this errors in the migration manager:
Info:
The password was generated for user 'Domain Administrator (domain.com)'. New password is 'GA66QgQ'
Warning:
Execution of /opt/psa/admin/plib/api-cli/user.php --create domain.com -owner admin -guid cfa43606-e8b0-444c-a005-660984840498 -cname Domain Administrator (domain.com) -passwd '' -status disabled -domain-admin true -email '' -external-email true -role Domain Administrator (domain.com) -country NL -legacy-user false -subscription-name domain.com -ignore-nonexistent-options failed with return code 1.
Stderr is
Error during user creation: Owner with id 1 has not subscription with id 69
Warning: domain "domain.com"
Execution of /opt/psa/admin/bin/backup_restore_helper --restore-legacy-dlu domain.com -dlu-info /opt/psa/PMM/tmp/deployer_legacy_dluIrjcWa -ignore-nonexistent-options failed with return code 1.
Stderr is
Unable to create Account object: Account: unable to select: no such row in the tableClick to expand...
View 1 Replies
View Related
Jul 24, 2015
In my documents I have command:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select name from domains" | grep -v 'name' > domains.txt; while read i; do echo $i; /usr/local/psa/bin/domain_pref -i $i | grep nonexistent; done < domains.txtClick to expand...
View 2 Replies
View Related
Oct 15, 2014
I'm looking for a way to get a report of the top domains that are continuously greylisted so I can determine which ones need to be put on the "domains- whitelist" because they use different IPs when resending, causing very long delays (hours/days/never) for each message sent.We're using Plesk11 on CentOS 6.4 with Postfix and the Plesk built-in Greylisting option enabled.
# /usr/local/psa/bin/grey_listing --info-server
Grey listing configuration.
Grey listing checking enabled
Grey interval 5 minutes
Expire interval 51840 minutes
Penalty interval 2 minutes
Penalty disabled
Personal grey listing
configuration allowed
[code]....
Black domains patterns list:
SUCCESS: Gathering of server wide information complete.Click to expand...
View 4 Replies
View Related
Nov 19, 2013
How can I configure "Backup manager" to clear checkbox "During the backup process, website visitors will be redirected to the custom error document page with the search engine friendly 503 HTTP code" for default (for subscribers, customers, etc.)
View 1 Replies
View Related
Apr 12, 2014
How to take output of Subscriptions in txt or csv...
I want only primary domain names which are listed under subscription...
In domains table subdomain as well as addon domains are also included so i cant use domains table...
View 1 Replies
View Related
Aug 23, 2012
I install the net4.0 and plesk only show version 2.0. How can I show all versions (2.0,3.0,4.0)
View 2 Replies
View Related
Sep 10, 2014
While accessing plesk it says "ERROR: PleskMainDBException: DB query failed: Unknown column 'description' in 'field list' (db.php:61)" , Plesk 12 windows server.
View 2 Replies
View Related
Nov 6, 2009
Is it possible to get a list of domains that are using a specific pair of nameservers?
We've purchased several hosting companies over the years, and would like to consolidate the nameservers we are using and need to manage.
Thus.. we need to figure out which customers are using which nameservers.
So getting a list of which domains are using the nameservers we don't want to use any more would be a nice easy way. Then we can contact those specific customers only.
View 4 Replies
View Related
Dec 2, 2014
When trying to migrate from one 12.0.18 Update #26 to another, I got always the same error:
Details
Error:
Unable to download dump files to local store.
Error:
The network path was not found
View 5 Replies
View Related
Mar 31, 2014
I've installed the Plesk Panel onto a windows 2008 server. It's all good, web sites are flowing and I'm really happy with the software. The issue I'm having is a customer has an asp site with an access database. After I uploaded their site, they couldn't write to the database, so I had to manually go and set the permission on the database for the "Plesk IIS Anonymous Account (IUSR_xxx)" user to have modify access on the file.
So my question is this, how can I set up the default hosting account to already allow this and so I don't have to go an waste time tweaking the folders manually trying to find the right permissions?
Also, why is it the Plesk IIS Anonymous account that needed to have it's permissions tweaked and not the "Default Plesk application pool user (IWAM_plesk(default))" which is the user who's configured on the application pool in IIS? I can't see where the Plesk IIS Anon user is being used.
View 1 Replies
View Related
Jun 6, 2014
Any user that logs in, even with the format domainusername, get's the following error message: 530 User cannot log in.I have already tried the following:
net stop MSFTPSvc
net start MSFTPSvc
View 1 Replies
View Related
Jun 20, 2013
I'm trying to rename a domain in my panel and keep getting the following error:
Code:
Error: Execute websrvmng --rename-vhost "--old-name=domainb.com" "--new-name=domaina.com" failed with error code 1: External component has thrown an exception. In IIS7NativeProvider module Exception type: System.Runtime.InteropServices.SEHException at _CxxThrowException(Void* , _s__ThrowInfo* ) at IIS7ApplicationPools.copy(IIS7ApplicationPools* , auto_ptr<IApplicationPool>* , basic_string<wchar_t,std::char_traits<wchar_t>,std::allocator<wchar_t> >* srcName, basic_string<wchar_t,std::char_traits<wchar_t>,std::allocator<wchar_t> >* dstName)
Running
Code:
websrvmng --rename-vhost "--old-name=domainb.com" "--new-name=domaina.com"
In the Windows command line gives the following error:
Code:
Cannot find domain by name 'domaina.com'
Haven't found many leads on the web as to what this might be.
View 2 Replies
View Related
May 17, 2015
I need to create more than a 1000 domains and i'm hoping to do this using an automated process. I can create them individually through the command line interface on our windows server but this will take a lot of time and effort.
View 1 Replies
View Related
Jul 31, 2012
I have a dedicated server here in the UK with fasthosts (win 2008 server, IIS 7), which which has been running fine for nearly a year. it was running plesk 9.2, and then out of the blue it got errors creating a new domain saying that PHP wasn't installed.
PHP was/is installed on the server, and is still running fine within my 12+ domains/websites. at the point of the error it was running 5.3.8 - i had manually upgraded the version outside of Plesk, but it had seen the new version when installing new domains.
When Plesk stopped seeing that PHP was installed, my hosts asked me to upgrade Plesk, as it would solve the issue. I used that ai.exe program, and choose v11.
The control panel installed OK - but I did lose my websites for a while, due to it downgrading my PHP to v5.2, and installing an older MySQL version which tried to use the same ports etc (I also have manually installed mysql v5.5 and have 1gig databases in that installation!).
After chosing the upgrade to 5.3 option in the Plesk control panel, and turning the Plesk installed Mysql v5.1 service off and to disabled in windows services - 'revealing' my 5.5 version, I could at least get my websites up and running once again!
Once all those were running (the priority), I have found that v11 Plesk has the same problem as v9.2, namely that it doesn't think that PHP is installed and available.
The error on installing a new domain;
Error: Failed domain creation: Unable to update domain data: Execute websrvmng --add-domain "--domain-name=testkrispy.co.uk" failed with error code 1: PHP 5 is not installed
Oddly it does see PHP 5.3.15 in the Service components screen, and it's ticked 'green' in that page, so all looks well.
On trying to install a new domain using plesk I get this;
And also on pages such as webmail - it also shows 'PHP not installed' against those webmail clients which would need PHP to run.
Any way to 'force' Plesk to see that the PHP 5.3.15 version that it itself installed (and I've removed the component and re-installed using Plesk).
My list on the server components page;
ASP 7.0.6002.18276
ASP.NET 2.0.50727.4016
FastCGI Support 7.0.6002.22343
Perl v5.10.1 built for MSWin32-x86-multi-thread
PHP 5.3.15
Python 2.6.5.12
SSI 7.0.6001.18000
I've tried something found on this forum (under the 10.4 area), but that hasn't fixed it;
"C:ParallelsInstallerparallelsPANEL-WIN_11.0.9dist-msi-Microsoft-2003-i386php53.msi" you will have an option for "repair" - ran that, no difference.
So as it stands, Plesk 11 is running, and most functions work, it just doesn't recognise the PHP install that it put in place... so I can't add software which requires PHP through Plesk, nor add new domains. All existing domains are running and using PHP fine - so it's installed OK.
One error I've noticed on startup - within the PHP error log, is the following - which I'm guessing is coming from the Plesk's own PHP executable (I can see it uses a 5.3.10 version in it's own admin area, with an extended php.ini file? ) I'm guessing the plesk's php.ini extension is trying to double load some dlls (which isn't a problem?) but seems to not find the php_sockets.dll - although that file is in the directory specified!? If it's a php dll around network sockets, maybe it is trying to use those to communicate with a running php instance? (Just guessing here?)
[30-Jul-2012 15:56:42 UTC] PHP Warning: Module 'mbstring' already loaded in Unknown on line 0
[30-Jul-2012 15:56:43 UTC] PHP Warning: Module 'mysql' already loaded in Unknown on line 0
[30-Jul-2012 15:56:43 UTC] PHP Warning: Module 'mysqli' already loaded in Unknown on line 0
[30-Jul-2012 15:56:44 UTC] PHP Warning: Module 'pdo_mysql' already loaded in Unknown on line 0
[30-Jul-2012 15:56:44 UTC] PHP Warning: Module 'pdo_sqlite' already loaded in Unknown on line 0
[30-Jul-2012 15:56:44 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'C:pleskAdditionalPleskPHP53extphp_sockets.dll' - The specified procedure could not be found. in Unknown on line 0
View 3 Replies
View Related
May 28, 2014
I got this error without any kind of explanation and I cannot identified where is the problem:
Error: Call to a member function getIpAddresses() on a non-object (PleskDataManager.php:1280)
View 8 Replies
View Related
Oct 1, 2014
I need move "Manual Move" all the email content from different domains.
For example i have the domain:
xxx3.com
with the emails:
info@xxx3.com
sales@xxx3.com
network@xxx3.com
I like know how i can move the email content from every email from one Panel to another Panel without the Transfer Manager. Because the account is created on the other server with different configurations, but i need backup only the old email.
View 2 Replies
View Related
Nov 11, 2014
I noticed that IETF had not been enabled initially in the DNS template. This has been corrected but we now have numerous domains without that enabled. I would like to enable this on all those domains. Doing so from the GUI would be too time consuming for that number of domains.
So is there a cli switch that will turn this on for all domains or that I can run against all the domains?
View 1 Replies
View Related
Dec 14, 2014
I migrate to 12.0.18 Actualización #28, última actualización Dic 11, 2014 02:12 PM.
When I try to Access to the domains in a specific client I´m geting this error:
Internal error: D:Plesk wes.escarmerieradomenech.com is out of webspace
MessageD:Plesk wes.escarmerieradomenech.com is out of webspace
File Webspace.php
Line401
TypePleskFatalException
View 5 Replies
View Related
Nov 27, 2013
After upgrading the panel from 10.4.4 to 11.5.30 Update #23, I am not able to sort domains based on the "Renewal Date" column. With 10.4.4, I was able to sort. Is there anyway I can do this on 11.5.30?
View 7 Replies
View Related
Apr 29, 2014
We have the Windows version of Plesk 11.5 installed. I've removed the "Management of access to the server over Remote Desktop" but two of my sites (there's only 4 so far) still have the remote desktop button available if you log into the user account and switch to those two domains. Switching to the other two doesn't display the icon. I'm not sure if there's another place where it gets turned on/off as I've tested creating a new subscription with the "Management of access to the server over Remote Desktop" ticked and it's not giving me the desktop icon there.
View 1 Replies
View Related
Sep 13, 2013
how to make backups separately of all domains and clients, without going into their panel and configuring one by one?
View 2 Replies
View Related
Jul 9, 2014
I have somewhere at 2000 domains.
I need to change path to vhost from W:host to D:vhost
I copied all files from W to D drive and created symbollinks. Now all files stored in D:vhost and symbollincs pointing to W:vhost.
If I will use reconfigurator, will it recopy existing files or just will skip them? Because I have millions files in my vhost dir
Also i thought about change drive letter in windows OS. It wil be enough to just stop IIS service and plesk services for switching disk letter?
Can i just some how say plesk that he should search all vhost files in D:vhost? With out process of copying files,becouse thay already exist there are.
View 2 Replies
View Related
Jun 24, 2013
I have a server with Plesk Panel 11.
When I create a domain, I created the folder:
c: inetpub vhosts.
I need to change the folder, since in that hard drive partition I'm running out of space.
How I can change the location of the folder where Plesk creates domains?
View 2 Replies
View Related
May 29, 2009
I have Linux and Windows server with Plesk 8.6 as the control panel and now the issue is that there is no option to auto suspend the accounts which are using over the quota(Diskspace or Traffic). All I have to manually check the accounts and to suspend, which I think not good. Is there any option to get the accounts auto suspended once they reached the limits. In the Notifications area, sending mails to clients regarding the quota, but no option to suspend the accounts.
View 8 Replies
View Related