ChipPC - Xcalibur W Wiki

For Server 2.14.x & Agent 2.14.x

User Tools

Site Tools


Sidebar

Getting Started

Server Software Installation

Client Software Installation

First Time Use

Enrolling Client Devices


Client Access Licenses

Discovering New Clients

Enrolling Client Devices

Manage Devices

Commands Glossary

Commands to Multiple Devices

Commands to Single Device

Library

Reporting Services

Monitoring and Preventive Maintenance

Automatic Policies

Notification

Manager Options

Plugins

Advanced

installation_guide:server_software_installation:manual_installation:creating_database:configuring_mysql

Configure MySQL


Script for Creating the Database

 CREATE DATABASE wp_manager;
 GRANT ALL PRIVILEGES ON wp_manager.* TO 'wpweb'@'localhost' IDENTIFIED BY 'Password-123' WITH GRANT OPTION; 
 FLUSH PRIVILEGES;

The Hibernate.cfg.xml File

The database configuration file is located in “C:\inetpub\wwwroot\XcaliburW\bin”. Open this file with a text editor and edit the following lines:

 <?xml version="1.0" encoding="utf-8"?>
 <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
   <!-- an ISessionFactory instance -->
   <session-factory xmlns="urn:nhibernate-configuration-2.2">
     ...here...
   </session-factory>
 </hibernate-configuration>

Configure MySQL Usage

Edit the following lines:

    <property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
    <property name="dialect">NHibernate.Dialect.MySQL5Dialect</property>

Connection String

Edit the following line:

 <property name="connection.connection_string">Server=127.0.0.1;Database=wp_manager;User=wpweb;Pwd=password;</property>

The value “password” corresponds to the password you chose during the creation of the wpweb account.

installation_guide/server_software_installation/manual_installation/creating_database/configuring_mysql.txt · Last modified: 2021/11/21 17:44 (external edit)