Sandbox database server registration questions

Created:

2016-11-16 13:07:47 UTC

Modified:

2017-08-16 17:25:57 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Sandbox database server registration questions

Applicable to:

  • Plesk 12.0 for Windows

Symptoms

Sandbox DB server has been registered properly in the system according to guide .

But when attempt to create a DB via cmd the error appears:

& '"%plesk_bin%"\\database.exe' --create cnolanDB -domain example.com -server 1.1.1.1 -print-id...

database.exe : Unable to create database: No such database server registered in Plesk
At line:1 char:1
+ & 'C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\database.exe' --create...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (Unable to creat...stered in Plesk:String) [], RemoteException
+ FullyQualifiedErrorId : NativeCommandError

It doesn't show up in the Plesk panel so it would seem the CLI is our only option for adding the database through Plesk.

How to make sure sandbox DB server is properly installed?How to create database and make it available in Plesk?

Resolution

There are few points bellow about sandbox DB server for Plesk that should be noted:

  1. If the sandbox server was configured - this means it was configured properly. Otherwise it shows error on registration step.

To make sure settings are implemented you can check the details in database:

    "%plesk_bin%"\\dbclient.exe --direct-sql --sql="select * from misc where param like \\"sandbox%\\""

param val
sandbox_mssql_server_admin sa
sandbox_mssql_server_db_server_network_backup_dir \\\\1.1.1.1.\\d$\ emp
sandbox_mssql_server_db_server_network_backup_pwd $AES-128-CBC$c...k+yMUk1I9w
sandbox_mssql_server_db_server_network_backup_usr 1.1.1.1\\example
sandbox_mssql_server_db_server_temp_backup_dir d:\ emp
sandbox_mssql_server_host 1.1.1.1\\MSSQLSERVER2012
sandbox_mssql_server_passwd $AES-128-CBC$c...kdfdkAAsdw
  1. The Sandbox server if configured is never used during database creation neither from GUI nor from CLI.
  2. The sandbox server is not supposed to be used for hosting customers database or even be listed in the list of the configured databases servers. The Sandbox server feature is designed to use intermediate temporary server connected with "sysadmin" role to fix customers' database dumps is being restored on MSSQL servers connected with user without sysadmin role.

Attachments:

Have more questions? Submit a request
Please sign in to leave a comment.