Plesk 11.x / Linux :: MySQL Crashing / Not Loading Correctly

May 14, 2014

I have a Centos 6 server with Heart Internet, who yesterday had an issue with the issue and once back online have been struggling til now getting the mysql service working correctly again and have now refused to provide any further support and redirected me here.

I was following this article here: [URL] ....

I've gotten to point 4. "~# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` -A | sed '1iSET FOREIGN_KEY_CHECKS = 0;' > /root/dumpall.sql" however it's saying "got error: 145: table './avenue141_dabs/av_options' is marked as crashed and should be repaired when using LOCK TABLES and any attempts made to get into the DB to repair is giving me "error: 1045: Access denied for user 'root'@'localhost' (using password: NO)

This issue is urgent as we have a few websites on this server which use mysql databases for their website.

View 9 Replies


Plesk 11.x / Linux :: How To Partition SSD To HDD Correctly

Dec 6, 2014

I am running a CentOS 6.6 (Final) with Plesk 12.0.18 Update #27 on my dedicated server. I was advised to upgrade my server to one that has a SSD due to better performance. What they failed to tell me was that I would need to perform additional configurations so that Plesk stores the subscription files in the /HDD-var/ directory and NOT the /SDD-var/ directory. Current server

Here are my questions:

1. How difficult would it be (I am a quick learner and can follow exact steps or directions very well) to make Plesk store the files on the HDD rather than the SDD?
2. Is this something I should undertake or is this very difficult to do?
3. If I perform these changes, will they revert to the old way if I perform Plesk updates? Or will the changes I make become permanent?

SSH: df -h

Filesystem Size Used Avail Use% Mounted on
/dev/md1 4.0G 916M 3.1G 23% /
/dev/mapper/ssd-usr 3.9G 1.9G 1.8G 51% /usr
/dev/mapper/ssd-var 3.9G 3.7G 2.7M 100% /var (Plesk is storing data here)
/dev/mapper/ssd-home 3.9G 792M 2.9G 22% /home (Would also like this data to be on the HDD)

[Code] ....

View 3 Replies View Related

Plesk 12.x / Linux :: PSA-Firewall Not Working Correctly?

Aug 23, 2014

When I modify rules using the firewall panel it is not generating rules correctly when selecting allow from selected sources deny from others.

View 2 Replies View Related

Plesk 11.x / Linux :: Permission Correctly In Vhost?

Nov 25, 2014

I have domainA and domainB. domainA hosting files, for security ALL browser access should denied.. EXCEPT domainB make in php call with readfile() to a file on domainA. This should allowed.

domainB => readfile(http://domainA/myfile) => allowed ... all other access should denied.

So I set in vhost of domainA this:

<DirectoryMatch "^/var/www/vhosts/domainA/httpdocs/folder/">
Order deny,allow
Deny from all
Allow from 127
Allow from server-ipv4
Allow from server-ipv6/128
Allow from ::1/128
</DirectoryMatch>Click to expand...

View 3 Replies View Related

Plesk 12.x / Linux :: Firewall Not Generating Rules Correctly

Aug 17, 2014

I am using the plesk firewall and trying to set up SSH rule which only allows from my IP but deny from everywhere else. In previous versions this worked fine by adding an ip selecting Allow from selected sources, deny from others and the icon in the rules would be orange with the lines

allow incoming from
Deny incoming from all others

However this no longer works as the deny from all others is not appearing and is not being generated in the iptables by plesk.

View 1 Replies View Related

Plesk 12.x / Linux :: Request For Instruction On Correctly Installing APC

Oct 6, 2014

I would like to install APCu (Alternative PHP Cache) & ZendOptimizer on plesk v12, I just wanted to know if there is any instructions for installing it correctly in a manner that will not cause issues with plesk updates.

View 5 Replies View Related

Plesk 12.x / Linux :: Website Not Working Correctly - URL Rewrite

Sep 2, 2014

Latest Plex installed on a fresh machine. Have tried both Ubuntu 12.04 and 14.04 and cannot seem to have my website work correctly regarding URL rewrites. Its enabled in apache...

View 1 Replies View Related

Plesk 11.x / Linux :: PHP Not Loading For One Vhost

Feb 19, 2015

We have strange problem with our plesk 11.0.9 Update #62.

Have only 10 domains hosted and all except 1 is working fine.... This particular domain doesn't run PHP scripts at all and when we try to browse a php script from browser, the file starts downloading. I have tried to compare the php settings from other working vhosts but and found no change at all... tried with

/usr/local/psa/admin/bin/httpdmng --reconfigure-domain domainname-tld

/usr/local/psa/admin/bin/httpdmng --reconfigure-al

Also tried to create the vhost but no gain...

Also I tried to change the PHP setting from control panel so that the php file would be generated , but every time I reset the value, it reverts back and no value is preserved.

View 1 Replies View Related

Plesk 12.x / Linux :: System Policy For Incoming Traffic - Firewall Not Working Correctly

Jun 25, 2015

When I deny all other traffic for the "System policy for incoming traffic" to secure the server by only allowing the explicit ports I've requested to open, my server stops operating correctly.

It appears when I set the "System policy for incoming traffic" to deny, it appears to be disrupting various functions such as web traffic over ports 80/443, FTP, SSH, they either work extremely slow or don't work at all.

I brought this up with my Plesk license provider and they stated that the Plesk firewall doesn't add any tracking for ephemeral ports, therefore if you set the policy to drop for incoming/outgoing, it's not going to allow proper TCP communication since the return socket can't be opened. Also that the firewall is an explicit deny system rather than explicit allow based system.

Am I doing something wrong? All I want to do is to block all ports other than the ones I've set to allow. Is this how it is supposed to work?

View 1 Replies View Related

Plesk 12.x / Linux :: Add Or Remove Components Not Loading

Feb 20, 2015

I'm having the following issue:

Whenever I click on the Plesk panel link "Add or Remove Components" he will open a new browser window and runs into a timeout.

Browser: "Error code: ERR_TIMED_OUT"

I can't see any error messages in the panel.log and everything else from the panel is working fine.

System is running CentOS 5.11 with Plesk 12.0.18 Update #35

View 3 Replies View Related

Plesk 12.x / Linux :: Server Crashing Randomly With Out Of Memory Error

May 12, 2015

it's starting to kill child processes and eventually stops/hangs.

#plesk version
Product version: 12.0.18 Update #45
Update date: 2015/05/08 03:13
Build date: 2015/01/26 15:00
Build target: CentOS 7
Revision: 334346
Architecture: 64-bit
Wrapper version: 1.2

#free -m
total used free shared buff/cache available
Mem: 3782 647 2281 45 854 2875
Swap: 2047 0 2047

View 1 Replies View Related

Plesk 12.x / Linux :: Page Loading Time 50-60 Seconds

Jun 7, 2015

I have installed NGINX + PHP-FPM + PHP5Memcached + Memcached + APC on my VServer. My Problem is Page loading time of around 40-60 seconds. Installed is 12.0.18 Update #49

[URL] .....

Connection Setup: TIME
Stalled: 1.860 ms
Request sent: 0.214 ms
Waiting (TTFB): 47.08 s
Content Download: 41.757 ms
Explanation 47.12 

I have reconfigured the Domains but nothing changed and Bootstrap Repair

/usr/local/psa/admin/bin/httpdmng --reconfigure-all
/usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/ repair
If I disable Nginx and use "Apache Module" for PHP than the TTFB time is shorter but is not the prefered way. If I use "CGI" or "FASTCGI" without Nginx than the Page loading time is a little bit shorter but with Erros on the Website.

I tried to reinstall Nginx from Plesk but this gave me Error after enable it

root@vserver:/# /usr/local/psa/admin/sbin/nginxmng -e
[2015-06-08 00:26:12] ERR [util_exec] proc_close() failed
[2015-06-08 00:26:13] ERR [util_exec] proc_close() failed
[2015-06-08 00:26:15] ERR [panel] Apache config (14337159720.96731500) generation failed: Template_Exception: Destination directory '/etc/nginx/plesk.conf.d/vhosts' not exist
file: /opt/psa/admin/plib/Template/Writer/Webserver/Abstract.php
line: 75
code: 0
Destination directory '/etc/nginx/plesk.conf.d/vhosts' not existClick to expand...

View 3 Replies View Related

Plesk 12.x / Linux :: Roundcube Not Installed And Horde Not Loading?

Feb 22, 2015

In the list of available webmail clients there's only Horde. Why don't I have Roundcube? I thought it's preinstalled with Plesk 11.5 and higher.

When accessing Horde webmail, the page never loads till the end and all I get is the top menu, no e-mails.

View 1 Replies View Related

Plesk 12.x / Linux :: Brand New CentOS 6.5 Server Running 12.0.18 Crashing Randomly

Aug 19, 2014

I have a brand new A8i server from 1&1 that has crashed twice today and could only be rebooted through the 1&1 control panel (not Plesk). Out of the blue the server is not accessible from the Plesk CP and is not responding to pings. I have looked through the logs and do not see anything that stands out (I am not very Linux savvy). Is there somewhere specific that I can look that would tell me why it is locking up/crashing? I have only had the server about 2 weeks and am only running email on it (no websites besides webmail and Plesk CP). It is possible that there is a hardware issue, but I cannot have 1&1 check it until after hours tonight.

Server is an 8 core Intel Atom 2.6GHz with 8GB RAM.

View 8 Replies View Related

Plesk 12.x / Linux :: Tools And Settings Page Loading Icon

Aug 25, 2014

Is there any way to get rid of this loading icon every time you visit the tools and settings page (top right during page loading)? It only happens on our Plesk 12 servers that were not upgraded from Plesk 11.5.

Its irritating because the page layout jumps around after the loading is complete. It is the only page to do it and it happens regardless of the internet speed.

Disabling "Enable access to premium commercial apps on the Interface Management page fixed the issue in Plesk 11.5 but this does nothing in Plesk 12.

View 1 Replies View Related

Plesk 11.x / Linux :: How To Stop High Number Of Httpd Processes Crashing Server

May 17, 2014

Our server is running; Plesk 11.0.9 and CentOS 5.7 it has a Q8200 CPU @ 2.33GHz and 2GB of RAM. Now there are just two websites on the server plus a couple of redirects/forwarding domains, although lots of domains are still on the server but turned off in Plesk. Both websites are OSCommerce sites and I just need to keep these sites going until the end of the year when we will switch to our new Joomla based website.

We have seen an increasing number of server crashes and after various checks of the logs, fitting a new BIOS battery, check of the hardware by EasySpace who host the server, installation of ClamAV, LMD and RKHunter (which did find some Trojans and Suspect software), I have traced it down to some external Http activity that is taking all of my CPU time and RAM. Here is a screen capture of the Htop listing and when I killed these processes the CPU and RAM went back to normal. The problem is that I usually have to restart the HTTPD service and sometimes things get so bad that the server crashes and I have to request a power cycle.

View 8 Replies View Related

Mysql Keeps Crashing ...

Nov 2, 2009

Today on a server of mine mysql keeps crashing and I need to manually restart it over and over, the load as well keeps spiking quite high until I stop mysql for a few minutes. There isn't a extra load of traffic or anything as I have the same amount of users on several other servers doing more then this one.

How do I tell exactly whats happening from then how would I go about fixing it?

Basically it mysql crashes and needs to just be manually restarted via ssh.

View 13 Replies View Related

New Server Crashing After Some Minutes - Mysql

Dec 27, 2007

Our new server crashes about every 30',causing high high load(80!)

After mysql restart,everything its ok.

Dual Core @ 3Ghz
1GB Ram
Sata Drives
Centos 5
My.Cnf config:

socket = /var/lib/mysql/mysql.sock


old-passwords = 1



# Remove the next comment character if you are not familiar with SQL



Top Process,showing in whm and status2k:
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/ --skip-external-locking --socket=/var/lib/mysql/mysql.sock

View 11 Replies View Related

Mysql Loading Very Slow

Dec 28, 2008

I'm running a forum system on my server. Loading pages that don't connect to the forum database load normal. Whenever I browse any page that connects to the forum database on my forum, the page either takes ages to load or times out loading. I never exceed using 14% of one of my two cores, I'm using a quarter of my 1.5GB ram. It's only been loading slow like this since I've switched from running Windows to Ubuntu Server 8.10. I enabled logging slow queries on SQL, but nothing's been recorded. I've installed the server packages through Webmin,

when I access the server through its local IP address it's still very slow.

View 13 Replies View Related

Apache/MySQL/PHP Issue - PHP Not Loading

Jun 28, 2008

I've got a server that was running Apache 2.0/PHP 5.2.5 & MysQL 5.0 just fine, however I needed to upgrade to a newer version of MySQL.

So I uninstalled MySQL 5.0 and installed MySQL 5.1, copied the MySQLlibs over, and recompiled Apache/PHP with easyupdate. Apache & MysQL both start/run fine without errors, however PHP files don't load. Just get black pages (HTML works fine obviously).

I went ahead and updated to Apache 2.2 & PHP 5.2.6 while I was at it, but that doesn't change things. I'm not sure why uninstalling MysQL & reinstalling would break any dependencies, but looks like thats the case. Perhaps I need to reinstall some libraries?

Or would it be easier just to reinstall Apache/PHP entirely? I have no data.

View 4 Replies View Related

Plesk 11.x / Windows :: SQL Webadmin Not Installing Correctly?

Jul 1, 2014

Microsoft Windows Server 2012 Panel version 11.5.30 Update #47

The Webadmin app does not install all the folders it needs to run correctly. I have downloaded and repaired the install as noted in [URL] ..... This did not repair the install. All the folders that are needed in the application directory in the vhosts folder are still missing. I have attached the install log.

View 1 Replies View Related

Plesk Automation :: How To Correctly Change / Move Data Directory

Nov 14, 2013

I want to move the data directory to another partition on all nodes. Apache (vhost), IIS (vhost), MySQL (databases) and Postfix (mailbox content). What's the correct way to do this without breaking functionality of PPA?

View 5 Replies View Related

Plesk 12.x / Windows :: Domain Disk Usage Not Shown Correctly After Upgrade From 11.5 To 12

Jul 14, 2014

I have upgrade plesk to 12 version and after upgrade all the domains that have more than 2048 MB on the server are shown as 2048 MB.

If i go on the domain statistic the tab the total disk usage is 2048.1 MB but on the graph the services disk usage are shown correctly.

I have 2 print screen.

View 6 Replies View Related

Videos Not Loading/ Loading Very Slow

Dec 5, 2008

I have been having soooo many issues with this new server

It is nothing against my host; but now the videos aren't loading or loading so slow

What could be the issue? It would have to be a server issue, correct?

The site is nsfw but it is ftw (hint hint) , it is an adult site and I don't know if

View 11 Replies View Related

Plesk 11.x / Windows :: PHP Pages Not Loading - Error 500

May 22, 2014

My server is working fine for the last 13 months but since lst tuesday (may 20) it throws error 500. Here is the complete error message

Error Summary
HTTP Error 500.0 - Internal Server Error
File monitoring is enabled for a file which could not be found

Detailed Error Information
Error Code0x80070003
Requested URLhttp://mydomain:80/index.php
Physical PathC:Inetpubvhostsmydomainhttpdocsindex.php
Logon MethodAnonymous
Logon UserAnonymous

My Server Details
Panel version11.0.9 Update #61, last updated at May 5, 2014 12:52 AM
Windows Server 2008 Service pack 1 64bit
Intel Xeon 2.3 with 24GB Ram

For self diagnostic I delete all files on my root directory (C:Inetpubvhostsmydomainhttpdocs) and put only 2 files
index.php and index.html

When I browse for index.html. It display properly. When I browse for index.php the error persist. What could be wrong?

View 5 Replies View Related

Copyrights 2005-15, All rights reserved