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
ADVERTISEMENT
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
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
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
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 xxx.xxx.xxx.xx
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
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
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
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
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
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
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
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/Response
TIME
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
Code:
/usr/local/psa/admin/bin/httpdmng --reconfigure-all
/usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh 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
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
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
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
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
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
Dec 27, 2007
Our new server crashes about every 30',causing high high load(80!)
After mysql restart,everything its ok.
System:
Dual Core @ 3Ghz
1GB Ram
Sata Drives
Centos 5
---
My.Cnf config:
--
Code:
[mysqld]
socket = /var/lib/mysql/mysql.sock
safe-show-database
old-password=1
max_connections=500
interactive_timeout=100
wait_timeout=30
connect_timeout=30
thread_cache_size=8
key_buffer=32M
join_buffer=8M
max_allowed_packet=32M
table_cache=1024
sort_buffer=32M
record_buffer=8M
thread_cache_size=128
max_user_connections=30
thread_concurrency=4
myisam_sort_buffer_size=64M
query_cache_limit=2M
query_cache_size=32M
query_cache_type=1
old-passwords = 1
[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=32M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_bufer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
----
Top Process,showing in whm and status2k:
--
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server3.zaxihosting.com.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock
View 11 Replies
View Related
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
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
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
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
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
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
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
ModuleFastCgiModule
NotificationExecuteRequestHandler
HandlerPHP5-FastCGI-php
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
