How to enable access from all machines for mysql user.
To create a user who has access from all machines in a given domain (for example, serverbuddies.com), you can use the “%” wildcard character in the host part of the account name:
mysql> CREATE USER ‘myname’@'%.serverbuddies.com’ IDENTIFIED BY ‘mypass’;
To do the same thing by modifying the grant tables directly, do this:
mysql> INSERT INTO user (Host,User,Password,…)
-> VALUES(’%.serverbuddies.com’,'myname’,PASSWORD(’mypass’),…);
mysql> FLUSH PRIVILEGES;
Postfix uses database files for access control
Postfix uses database files for access control, address rewriting and other purposes.
Here is a common example of how Postfix invokes a database:
/etc/postfix/main.cf:
virtual_alias_maps = hash:/etc/postfix/virtual
Whenever you make a change to the main.cf or master.cf file, execute the following command as root in order to refresh a running mail system:
Removing Reseller’s Access to Server’s Shared IP in DirectAdmin
As an Admin, you can give Resellers the ability to create User web sites using the Server’s Shared (main) IP address. At this time, you cannot remove this ability through the control panel.
To solve the problem manually, remove the desired IP address from the ip.list file in the Reseller’s DirectAdmin config directory
Reseller’s DirectAdmin config directory
/usr/local/directadmin/data/users/username/ip.list
This change will not affect the Reseller’s current Users (if they are using the server’s main IP, they will continue to do so.
Source & credit - http://www.directadmin.com
Managing Access to System Services in Plesk
For each system service, you can choose whether to allow or deny all incoming communications, or allow only communications coming from specific IP/network addresses.
To allow or restrict access to a service on your Parallels Plesk Panel server:
1. Go to Modules > Firewall > Edit Firewall Configuration.
2. Click the service name.
3. Do any of the following:
* To allow all incoming connections, select the Allow option and click OK.
* To deny all incoming connections, select the Deny option and click OK.
* To deny access to a service from specific IP/network addresses, select the Allow from selected sources, deny from others option, specify the IP address or network address from which access to the selected service is allowed, and click Add. After you specify the required addresses, click OK.
4. To apply all changes to the firewall configuration, click Activate, and then click Activate again.
Source : http://parallels.com/
Blocking Access to Updater Functions from the Control Panel Linux Hosting
If you delegate server administration tasks to other users, but do not want them to use the Updates function or change the updating settings from the control panel, you can remove the screens related to Updater settings and the Updates icon from the control panel.
To do this, use the following MySQL command:
echo ‘REPLACE misc SET param=”disable_updater”, val=”true”‘ | mysql psa -uadmin -p`cat /etc/psa/.psa.shadow`
To restore the Updates icon and screens in the control panel, use the following MySQL command:
echo ‘REPLACE misc SET param=”disable_updater”, val=”false”‘ | mysql psa -uadmin -p`cat /etc/psa/.psa.shadow`
Reference : parallels.com/Plesk/
