Roundcube Database error
DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator. Fix: For a plesk server, remove and reinstall roundcube
DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator. Fix: For a plesk server, remove and reinstall roundcube
http://kb.sp.parallels.com/en/122785
http://dev.mysql.com/doc/refman/5.0/en/how-to-avoid-table-scan.html http://dev.mysql.com/doc/refman/5.0/en/explain.html http://www.percona.com/blog/2014/03/14/tools-and-tips-for-analysis-of-mysqls-slow-query-log/
Rootkit Hunter (rkhunter) is a Unix-based tool that scans for rootkits, backdoors and possible local exploits. Rootkits are self-hiding toolkits secretly installed by a malicious intruder to allow that user to gain access to the server. Rootkit Hunter offers protection by comparing SHA-1 hashes of important files with known good ones in a online database … Read more
There is a nice tool like Percona’s ‘pt-query-digest’ tool at http://www.percona.com/doc/percona-toolkit/2.2/pt-query-digest.html, which will automatically parse the slow_query_log and analyze it for the slowest queries. you run the command Wich should output a summary and a list of the longest-to-execute queries.
Usage: With files: With folders:
Running a script on WHM server Add curl SSL support in WHM or curl
Once you have entered the values correctly, press Ctrl+Enter to save it with the current filename, then press Ctrl+X to exit the editor. Provided you entered your values correctly, verify the new settings by retyping the cat command: Apply setting to Interface After you have determined the values entered are correct, restart networking with the … Read more
Create an index to a mysql table. Say there is a product_id column: Add to existing table
Checking the log shows: Check the processlist on a plesk server: Kill the process: Create an index on the table