I am using Plesk 11.5.30 Update #39. The statistics in not updating the mssql database size. It is always showing 0. I am attaching the screen shot. This account has 2 mssql 2008 database and uses 70MB. In plesk it is showing as 0 MB.
We are not able to block the account for mssql over usages.
I have attempted to update our plesk panel 10.4.4 to 12.0.18. I left it running overnight and in the morning it is still saying "Waiting . . ." with the progress as follows - has it finished, will it ever finish . . . should I switch off and start again?
Installation started in background
Determining the packages that need to be installed.
File downloading PANEL-WIN_12.0.18/dist-msi-Microsoft-2003-i386/panel.msi:
[Code].....
I restored some some databases outside of Plesk in a MSSQL 2008 instance. Plesk knows about the MSSQL intance but is not aware of the databases. I want to add them to Plesk so they will be backed up.
View 2 Replies View RelatedI have read about people wanting to change their database from MSSQL to MySQL. I however am wanting to change from MySQL to Microsoft SQL in our Plesk panel.
View 7 Replies View RelatedI have vps server with win server 2008 and Plesk 11.5.30. when i am trying to copy Mssql Database trough the panel i have an error: " Unable to copy database ". In the %plesk_dir%adminlogs under the php-error.log i have this error:
"[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Database cloning failed.
[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Task failed: id=163, pid=9700, type=db-clone, error=Unable to clone database."
We received the following request from customer in order for his website to function properly:
Go to the control panel of your Windows Server change Regional Settings so that the default language iS Greek.
Also, change the collation of Microsoft SQL Server to Greek-Accent Insensitive-Case Insensitive.
Will these create any problems to the rest of the websites that are hosted on the server? And if no, how to change the collation of the Microsoft SQL Server?
I am using connection string that written below but it does not work in your host.
<add name="LocalSqlServer" connectionString="Data Source=mssql.mydomain.at; Initial Catalog= mydb; User ID= myuserid; Password= mypassword; MultipleActiveResultSets=True;"/>
Any connection string instance for mssql webadmin ?
I have an account which used a remote MSSQL server which I have since deactivated, but before deactivating I forgot to remove the DB and Server from plesk.
So now I can't remove the remote MSSQL server from plesk as there is a DB associated with it, and I can't remove the DB because it obviously can't find the remote server! I'm now stuck in a loop!
How I can force remove the DB/User from plesk and then the remote server ? I'm now receiving errors whilst backing up the account, so needs to be done.
I have Plesk 12 on Windows Server 2012 and SQL 2014 Express, and I am unable to add the SQL server to Plesk. It looks like it is waiting for a long time for something, then I get this error:
Get database server version failed: mssqlmng failed: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Error code 1)Click to expand...
I'm looking for information about having EXTERNAL ms-sql 2008/2012 servers with MS-SQL Web Edition license connected to one or more Plesk servers.
We don't want to use the Express version coming with Plesk but use MS-SQL 2008 & 2012 (both accessible by clients if possible), on individual dedicated machines for SQL only.Of course we'd like to have all current functionality coming with Plesk Power Panel inc. backup/restore options from within Plesk.
After upgrading to Plesk Panel 12, when db user is created on MsSQL 2012 server, db user seems to be missing db_owner role which is causing a lot of hassle at the moment.
I was not able to locate any settings for such except for following option.
"Enable the db_backupoperator role membership for all Microsoft SQL Server database users"
Please note, this only applies to new db user created as Plesk 11.5 didn't have such problem and only seems to be related to SQL 2012 not 2008.
12.0.18 update #39
Server 2012r2
Logged into my panel today to run a database backup on a site I'm working on to be confronted with the following:
Unable to backup database 'XXXXXXXXXX'
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupXXXXXXXXX.co.nzdatabasesXXXXXXXXX-29 est'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.
(Error code 21)
I'm not sure why permissions would change on their own, I'm also not sure how to fix the permissions error. I get the same error on all databases.
PrivateTemp folder appears to have write permissions for Group MSSQLSERVER
I've an issue when i tried to create a backup repository by the client control panel, The backup already created but it's not affected on the client disk space !!
It's put in Crogram Files/Paralles/Plesk/Backup/reseller/resellername/clients/domain.com
Now, I have critical disk space usage because the one client has schedule daily backups and it's not affected on his account usage!!
1- I've check for permissions and repair plesk database.
2- I've make repair quota.
3- Updated plesk
PLesk v: 11.0.9
Windows server 2008 R2 Datacenter
My new plesk 12 windows server was not showing the application vault (even after login as admin user). Hence I have changed the entry enabled = on in the file
C:Program Files (x86)ParallelsPleskadminconfpanel panel.ini as per [URL] ..... Now the application vault is showing well.
My question is, whether this is a new procedure change for Plesk 11/12? I believe, I used to see application vault enabled as default in all my other old servers.
My one website & all it's sub-domains automatically showing Plesk Default Page . After checking further, I found websites were stopped on the server . I manually started them but after few hours again same status . I repeated the same thing several times but issue not fixed.
View 9 Replies View RelatedI am running plesk 11.05 Plesk on windows server. I have noticed this things twice...
While migrating accounts one server to another Smartermail not showing actual mail received date. For all accounts and emails Smartermail showing Migration date..
My more than 10000 emails showing migration date as received date..
I'm looking for a Windows VPS provider that offers .NET2 and MSSQL?
View 0 Replies View RelatedI've been paying $160 a month for a dedicated server that runs my web application and my mssql 2008 database.
Due to the economic times, I've been searching for a cheaper alternative... This gets me thinking... Wouldn't this be a good business plan for VPS companies?
Include 4-5 databases on a extreme, high-performance MSSQL server for all windows vps.
I know there are current setups like this, but no host really emphasizes the power of their mssql server. If they show how their db server is extremely fast, customers would be less likely to try and run their own express version on the vps. Thereby decreasing ram/cpu load on the vps, and increasing the overall efficiency of the dedicated server running the vps'.
Are there any hosts that currently market like this? If not, why don't you?
Any windows hosting provider with MSSQL database?
View 14 Replies View RelatedI've got MSSQL 2005 Enterprise running on Windows 2003 Standard R2 x64. The server has 12GB RAM.
Now, I've been trying to find some way to monitor how much RAM MSSQL takes up, but found two conflicting things.
One source says that MSSQL 2005 Enterprise can only use up to 4GB RAM on Windows Standard R2 x64. Another says Microsoft changed this to 32GB for Windows Standard R2 x64 only (i.e. not x86).
Could anyone confirm either of these? I'd find out myself if I knew how I could see how much it's using (it only shows 90mb in taskmanager).
we have a problem with internal statistics in one of our servers with plesk, statistics don't update, trying command line at server with "/usr/local/psa/ admin/sbin/statistics --calculate-one --domain-name=domain.tld" we have this result:
[2015-06-29 11:17:23] ERR [util_exec] proc_close() failed
WARNING during statistics_collector execution: : statistics[22087]: Statistics info parsing error: Number value is out of range for expected type. Error occured at offset 856, character '9'.
[2015-06-29 11:17:29] ERR [statistics[22087]: Statistics info parsing error: Number value is out of range for expected type. Error occured at offset 856, character '9'.] ERROR during statistics_collector execution:
We can update some domains from command line, but others fail and cron dont update any, maybe if one fail the cron command stop working?
I have one subscription that shows incorrect statistics for the log file size. In the statistics pane it reports 130MB, while on the server in the /var/www/vhosts/domain/logs I only see 1.7MB.
Are there any other locations where logs are kept that are included in the statistics?
The sql server I have my users use is on a different server from which plesk is installed. Plesk should include the size of the user's databases from the external server as well otherwise the user can have a database as large as he wants. It's no longer restricted by the plans limits.
View 7 Replies View RelatedWhen executing "statistics" these errors occur:
# /usr/local/psa/admin/sbin/statistics
WARNING during statistics_collector execution: : statistics_collector: Unable to get dir size of /var/lib/mailman/lists/14
System error 2: No such file or directory
statistics_collector: Unable to get dir size of /var/lib/mailman/archives/private/14.mbox
System error 2: No such file or directory
statistics_collector: Unable to get dir size of /var/lib/mailman/archives/private/14
System error 2: No such file or directoryClick to expand...
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...
I already have MSSQL 2005 on my server, one my the client requested us to install MSSQL express and they want to use the FOC version.
Can I run MSSQL server + MSSQL server express concurrently? Anybody can give me guidelines how to install it?
Do I need to uninstall MSSQL or it would be as easy as installing MSSQL express on top of MSSQL server.
how i could define a maximum size for a certain folder on my web hosting thus the folder size cannot exceed this ??
Also how could i set a maximum quota for an ftp account ?? provided that i have no cpanel im on GoDaddy host
want enable mssql_connect on php
plesk panel 11.0.9
centos
I want enable mssql_connect for php.
I renewed an SSL cert for one of my servers. After several hours, then days I noticed that the date had not updated to show the new expiration date.
When I do an ssl check through [URL] it shows the following when scanning https://webhost1.teksavvy.com:8443:
Valid from: 2014-Apr-11 00:00:00 GMT
Valid to: 2015-Apr-11 23:59:59 GMT
When scanning https://webhost1.teksavvy.com it shows:
[Code]....
We have change IP from NS server in Plesk.Why can we force refresh named.conf (for all domains) ? Informations stay with old IP.We can force one domain when we change an information in the DNS and we validate. But Hown can we change all domains?
Example:
Old
> NS server1.com (x.x.x.1)
New
> NS server1.com (x.x.x.2)
[code]....
My server admin already upgraded my OpenSSL to version 1.0.1m 19 Mar 2015 and he also upgraded Nginx to 1.6. I'm also running CentOS v5.11 and Plesk v11.5.
However, he tells me that he still can't get TLS 1.2 to work because he noticed that my server uses a different version of Nginx (sw-nginx), which he believes is part of Plesk. How we can get TLS 1.2 working on the Plesk copy of Nginx (sw-nginx)?