XML schema:
<xsd:complexType name=”Databases_Users”>
<xsd:sequence>
<xsd:element name=”user” type=”Databases_User”
maxOccurs=”unbounded” />
<xsd:element name=”defaultUser” type=”xsd:token” />
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name=”Databases_User”>
<xsd:sequence>
<xsd:element name=”login” type=”xsd:token” />
<xsd:element name=”password” minOccurs=”0”>
<xsd:complexType>
<xsd:simpleContent>
<xsd:extension base=”xsd:token”>
<xsd:attribute name=”encrypted” type=”xsd:boolean”
default=”false” use=”optional” />
</xsd:extension>
</xsd:simpleContent>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
Element/Attribute |
Optional |
Default Value |
Available since
|
Description |
|---|---|---|---|---|
user |
|
|
2.6.5 |
Database user. |
Login |
|
|
2.6.5 |
User name. Note: 1. User name will be extended during provisioning with the unique prefix. 2. The maximum length of the extended login (together with the prefix) is as follows for different database types: - MySQL: 16 characters - PostgreSQL: 63 characters - MS SQL: 128 characters |
Password |
* |
|
2.6.5 |
Password. The optional attribute @encrypted indicates if the password is in plain or in encrypted form. Note: Encrypted passwords for MS SQL and PostgreSQL databases are not supported. |
defaultUser |
|
|
2.6.5 |
Reference (by login) to the already defined database user. This user will be used by Web-based database management tools such as phpMySQL, phpPgSQL or myLittleAdmin. |
Example:
<mysql>
<name>testMyDB1</name>
<users>
<user>
<login>mylogin1</login>
<password>&hJ8)h</password>
</user>
<user>
<login>mylogin2</login>
<password>h&^J0)&</password>
</user>
<defaultUser>mylogin2</defaultUser>
</users>
<dsn>
<webspaceId>ws12</webspaceId>
<source>mySource</source>
</dsn>
<contentId>DB:MySQL:testMyDB1</contentId>
<accessHosts>
<host>172.16.55.1</host>
</accessHosts>
</mysql>