For Server 2.14.x & Agent 2.14.x
Xcalibur W supports various popular database engines, including
For the initial Xcalibur W installation, a database and several user accounts with appropriate permissions must be created before starting Xcalibur W.
Create two database user accounts:
Assign the following privileges to the accounts:
Note: Some databases assign users' privileges to a specific database or table. In this case, create the database first, and then create/assign the users.
1 CREATE USER 'wpadmin'@'%' IDENTIFIED BY 'password';
Create a database called “wp_manager”, and then assign the “wpadmin” and “wpweb” users to the database.
1 CREATE DATABASE wp_manager; 2 GRANT ALL PRIVILEGES ON wp_manager.* TO 'wpadmin'@'%' WITH GRANT OPTION; 3 FLUSH PRIVILEGES;
Using a client application compatible with your database engine, verify that all accounts can connect to the database, and that the wpadmin user can create tables within the database.
Client application list:
When the steps above are complete, you are ready to configure Xcalibur W Server to connect to your database.
Depending on the database in use, define the connection string (login/password/host:port/schema) as shown below:
For the first launch and for maintenance operations (updates, etc.), temporarily re-allocate the connection string from the wpweb account to the wpadmin account. Then, restart the web server and/or the web site.