External database connection config set
Default localistaion of config file to enable access to external database is located in procesy5 system config
Default syntax of config file for external database connection is as follows:
.cnf--zasob_RESOURCE_ID-PROCESY5_INSTALLED_DOMAIN.ini.php
Main config controller function class file /SE/se-lib/Config/INI.php
The file should contains such text data:
;<?php
;die(); // For further security
type="TYPE_OF_EXTERNAL_DATABASE"
host="HOST_ADDRESS_OF_EXTERNAL_DATABASE"
port="PORT_FOR_EXTERNAL_DATABASE"
user="USERNAME_FOR_EXTERNAL_DATABASE"
pass="PASSWORD_FOR_EXTERNAL_DATABASE"
database="DATABASE_NAME_OF_EXTERNAL_DATABASE"
names=""
namespace=""TARGET_NAMESPACE_FOR_BUSINESS_OBJECTS
prefix=""NAMESPACE_PREFIX_FOR_BUSINESS_OBJECTS
zasob_id="zasob_id"
system_UUIDs="system_UUIDs"
;//names="utf8
Values explained:
- TYPE_OF_EXTERNAL_DATABASE could be:
- "mysql" for Mysql or MariaDB database
- "pgsql" for PostgreSQL database
- "mssql" form MSql database (not fully supported)
- HOST_ADDRESS_OF_EXTERNAL_DATABASE could be or IP address or hostname of database
- TARGET_NAMESPACE_FOR_BUSINESS_OBJECTS - is used in Namespace Binding to Storage and conforms to TargetNamespacestandard. It is used to
correctly interpret defined Business Data Object in Procesy5 Business Object Templates Repository. For Namespace Binding Data Business Object to Local Storage is expected to be
http//biuro.biall-net.pl/xmlschema_procesy5/default_db
for system installed in domainbiuro.biall-net.pl
- see Instalation and Upgrades - NAMESPACE_PREFIX_FOR_BUSINESS_OBJECTS - is expected prefix for Business Data Object Definitions and conforms NameSpace Prefix standard