Plesk Reference

From 5dollarwhitebox.org Media Wiki

Jump to: navigation, search

Contents

[edit]

Plesk MySQL Database Queries

[edit]

Plesk 7.5.4

[edit]

List all email addresses with passwords

mysql> select concat(mail_name,'@', domains.name) as `e-mail`, password from domains 
       left join mail on domains.id=mail.dom_id left join accounts on mail.account_id = accounts.id where postbox='true';


[edit]

List FTP Usernames and Password

select domains.id, domains.name, sys_users.login, sys_users.passwd from domains, sys_users where domains.id = sys_users.id;



[edit]

Plesk 5.0.5

[edit]

List FTP/Shell Usernames and Passwords

mysql> SELECT domains.id, domains.name, sys_users.login, sys_users.passwd FROM domains, sys_users where domains.id = sys_users.id;


[edit]

Plesk as a Backup MX

* Ensure the domain is in 'rcpthosts' and that mail is enabled in plesk (no email addresses)

* Ensure there are no email addresses configured for the domain

* Add the following to /var/qmail/control/smtproutes
** domain.com:ip_of_primary_mx_server

* Remove the domain from '/var/qmail/control/virtualdomains'


[edit]

Plesk Webmail Redirect

Uh... this is just annoying because servers that have '/webmail' going to say SquirrelMail and people can't figure out how to go to 'webmail.domain.com' for Horde or whatever... yeah, this is just for me really:

</pre> <?php

$server_name = $_SERVER['SERVER_NAME']; $server_name = preg_replace('|www\.|', , $server_name);

header("Location: http://webmail.$server_name"); ?> </pre>

Retrieved from "http://www.5dollarwhitebox.org/wiki/index.php/Plesk_Reference"
Personal tools