admin has written 153 articles

Connecting remotely to MySQL

Overview By default, MySQL permissions only permit same-server access for clients. This protects your database by preventing external access, but also precludes desktop database utilities like Navicat, MySQL Workbench, and Eclipse from managing your database schema. Solution Create a new MySQL user within the control panel under Databases > MySQL Manager. Enter a user under Name Remember:…

Listening on ports

Overview Some applications require persistence to continue to run after a page view has concluded. Node.js or other backend socket/server pairs connect a front-end process, like a web page view, with a backend process such as data crunching. For such circumstances, clients with Developer+ packages may run daemons necessary for their web site to operate – please no…

Compiling programs

Overview Custom programs may be compiled on Developer+ accounts, which is also bundled with terminal access. Custom programs may be installed under /usr/local. Per-Language C/C++ For C/C++ applications, supplying a –prefix=/usr/local during ./configure, i.e. ./configure –prefix=/usr/local && make && make install. In particular, this is negotiated not by C itself, but rather make/gmake and autoconf applications that are used in…

Improving mail filter performance

Overview E-mail that flows into the server goes through several phases of filtering before final delivery, including: DNSBL lookups on handshake Deep protocol inspection DomainKeys/SPF validation SpamAssassin filtering Whitelist management Hash-sharing systems (DCC & Razor) Token-based regex matching Markup filtering Bayesian filtering All steps in the filtering process are automated, except for Bayesian filtering that works by…

Empty mailbox

Overview Whenever a user exceeds his or her storage, an e-mail client may report zero e-mails present despite there actually being mail in the mailbox. Cause The mail server, Dovecot, uses a few cache files to speed up mailbox access on your account. In certain circumstances, these caches can become corrupted due to lack of storage.…

Enabling write-access

Overview The web server operates in a dual-user mode for enhanced security. In order for a web application to access your filesystem, specific permissions must be granted. Solution Change permissions on necessary files to 717 or 777. For WordPress, wp-content/uploads/ and wp-content/themes/  should be changed recursively to allow media uploads and theme editing in-browser. If plugin…

Displaying errors on-screen for debugging

Overview During early development of a PHP application or to debug a problem, errors should be displayed in-browser to help spot typos, undefined variables, misconfiguration, and other logic flaws. Solution Enable display_errors and increase verbosity in error_reporting within PHP. As an example, configuration within a .htaccess  would be: php_flag display_errors On php_value error_reporting 9999999 Caveats Some applications may use a separate…

Warning: An unexpected error occurred.

Overview When attempting to install a plugin or update WordPress, the process will complete successfully with the following message: Warning: An unexpected error occurred. Something may be wrong with WordPress.org or this server’s configuration. If you continue to have problems, please try the support forums. (WordPress could not establish a secure connection to WordPress.org. Please contact…