ServerBuddies Support Blog

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:

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:

The database utility is used to manage databases and database users in Plesk through CLI. By using this utility, you can perform the following tasks:

* creating or deleting databases
* adding and removing database users
* adding or removing database access records for database users
* editing database user credentials
* setting charset for PostgreSQL databases

Example

The following command creates database buddies on a database server accessible at the IP address and port number 192.0.2.78:3838 and prints the created Plesk database ID:

To create the database buddies for the domain example.com on the local MySQL server:

To upload a backup file to backup repository:

Go to Domains > domain name > Backup Manager (in the Files group) > Database Backup Repository and click Upload Backup File.

Select the database in which repository you want to upload the backup file to in the Database name menu.

Click Browse… and select the required backup file.

Leave the Restore database backup immediately upon uploading check box selected if you want the database contents to be restored immediately after the backup file is uploaded.

Click OK.

The database backup file will be uploaded to the backup repository of the specified database.

Resource : http://parallels.com/Plesk/

Plesk login page shows “Unable to connect to database : saved admin password is incorrect”

When try to login to Plesk admin panel the following error is displayed.

Reason:

The main reason for the issue is the PSA database user password and the Plesk admin password mismatch.

Solution:

Step 1 : Confirm the Plesk admin password. You can get the current Plesk password with command below.

Step 2 : Edit the MySQL configuration file(my.ini - %plesk_dir%\mysql\data\).

[C:\Program Files\Parallels\Plesk\mysql\data\]

Add the skip_grant_tables=1 parameter and restart the Plesk SQL Server service.

Note : Add to the [PleskSQLServer] section, NOT to [Client] section.

Step 3 : Reset the password

Type the below command to get into the MySQL prompt,

Now from the MySQL prompt, type

where ‘current_password’ is the current Plesk password.

Step 4 : Revert the changes

Remove the parameter ’skip_grant_tables=1′ from the MySQL configuration file and restart service Plesk SQL Server.

You should get the plesk admin page.

Plesk login page shows “Unable to connect to database : saved admin password is incorrect”

When try to login to Plesk admin panel the following error is displayed.

Reason:

The main reason for the issue is the PSA database user password and the Plesk admin password mismatch.

Solution:

Step 1 : Confirm the Plesk admin password. You can get the current Plesk password with command below.

Step 2 : Edit the MySQL configuration file(my.ini - %plesk_dir%\mysql\data\).

Add the skip_grant_tables=1 parameter and restart the Plesk SQL Server service.

Note : Add to the [PleskSQLServer] section, NOT to [Client] section.

Step 3 : Reset the password

Type the below command to get into the MySQL prompt,

Now from the MySQL prompt, type

where ‘current_password’ is the current Plesk password.

Step 4 : Revert the changes

Remove the parameter ’skip_grant_tables=1′ from the MySQL configuration file and restart service Plesk SQL Server.

You should get the plesk admin page now