Interesting things about PLESK Control panel, Joomla & Unix Hosting

Bulk create emails accounts in PLESK 12

I recently had to create over 40 email accounts for a client. Obviously i did not want to add them one by one.

Here is a little bash script I found that made the entire process a 30sec event.

Continue reading
744 Hits
0 Comments

Plesk WordPress nginx directive

  Authentication required.

This is a password protected blog, please kindly enter the password into the password field below to view the blog.

Plesk: Find all databases and login credentials

If you need to list all of the MySQL databases managed by Plesk along with their corresponding domains and login credentials, you can use this handy query.

SELECT domains.name AS domain_name,
data_bases.name AS database_name, db_users.login, accounts.password
FROM data_bases, db_users, domains, accounts
WHERE data_bases.dom_id = domains.id
AND db_users.db_id = data_bases.id
AND db_users.account_id = accounts.id
ORDER BY domain_name;

You will now a full list of all the databases, user names and passwords.

Continue reading
1270 Hits
0 Comments

Plesk: show all FTP accounts and passwords

I recently had a request to retrive all the ftp passwords for a domain that had a number of different FTP accounts configured in PLESK.

Here's a query i used to retrieve all the FTP account information from the Plesk internal database.
It will show you every username and password of all accounts that have been created via the Plesk panel.

Continue reading
1447 Hits
0 Comments

RSForm! Pro: Regex syntax to exlcude default values

  Authentication required.

This is a password protected blog, please kindly enter the password into the password field below to view the blog.

Howto set Roundcube as the default webmail client in plesk 11

I recently noticed that about 255 domains hosted on one of my Plesk 11.5 servers that had Horde set as the default webmail client. I personally dont like Horde and prefer that all domains use Roundcube.

Instead of manually updating each domain, this is what I did to do it all in one shot.

Continue reading
6052 Hits
0 Comments

Text seperators with multiple columns in yootheme templates

Working on a joomla website built on the yootheme warp framework 6 I needed to enable a multi column drop down menu on a text seperator.

The Yootheme documentation states you just need to add "columns-2" on the page class. But a text separators doesn't support this option.

The site looked weird without it so to achieve this we did the following:

Continue reading
4650 Hits
0 Comments

Leverage browser caching

Browser caching helps to speed up your Joomla website by using resources cached in your browser (this is different to the "Use Browser Caching" setting in the System - Cache plugin!).

This tutorial explains how you add Expires headers to your .htaccess file. This will help you improve the performance of your website, based on Google’s and Yahoo’s recommended performance guidelines.

Continue reading
3476 Hits
0 Comments

Plesk pop imap smtp SSL setup

  Authentication required.

This is a password protected blog, please kindly enter the password into the password field below to view the blog.

How to enable Apache graceful restart in Plesk

By default, Parallels Plesk Panel does not use Apache graceful restart for applying new settings. As result Apache will be restarted every time you change hosting settings through the Plesk GUI. This can lead to unwanted interruptions of sites operation.

Resolution
To enable graceful restart, you should add the parameter "restart_apache_gracefully" with a "true" value to the "misc" table of the "psa" database. It can be done by the following SQL query:

mysql> INSERT INTO misc VALUES ('restart_apache_gracefully', 'true');

APPLIES TO:
Parallels Plesk Panel 11.0 for Linux
Parallels Plesk Panel 10.4 for Linux/Unix
Parallels Plesk Panel 10.3 for Linux/Unix

Tags:
Continue reading
3209 Hits
0 Comments

RSForm! Pro: How to clear default value on click

  Authentication required.

This is a password protected blog, please kindly enter the password into the password field below to view the blog.

Check if a user is Super Administrator

Sometimes I need to show or hide specific modules from the Super Administrator.

If the user is the Super Admin

$user = JFactory::getUser();
$isAdmin = $user->get('isRoot');
if ($isAdmin) {

// code here

}

If the user is not Super Admin

if (!$isAdmin) {

 

Continue reading
2603 Hits
0 Comments

mod_fcgid: can't apply process slot

When I enable FastCGI on a domain it just throws up an Error 503 and shows "mod_fcgid: can't apply process slot for /var/www/cgi-bin/cgi_wrapper/cgi_wrapper" in the logs.

Resolution:

chown apache:apache var/run/mod_fcgid/sock

service httpd restart

Tags:
Continue reading
4925 Hits
0 Comments

Get email passwords using the command line

There is a built in command to get the email/passwords in plesk.
ssh to the server just run the following commands:

This will give you all the email accounts and password.

/usr/local/psa/admin/sbin/mail_auth_view

To get only the email accounts associated with a specific domain.

/usr/local/psa/admin/sbin/mail_auth_view | grep "demo-domain.co.za"
Continue reading
2950 Hits
0 Comments

Vulnerable extensions are lethal to your site security.

Vulnerable extensions are lethal to your site security.

Continue reading
2585 Hits
0 Comments

Joomla! use SMTP rather than the PHP mail function

By default, Joomla uses the php mail() function to send emails. However not all servers have the php mail() enabled and if you are using a local server like WAMP you will certainly get the Could not instantiate mail function erorr message.

To resolve this issue, I recommend setting up Joomla to use a SMTP.
This will also allow you to fully test your Joomla website on your local host and when you move it live the settings wont need to be changed.

Continue reading
5016 Hits
0 Comments