Translations:Works/To do/14/en

Subsystem DB

• DB gate

- implementation the local cache for the function fieldSeek() by the deep seeking to the XML-context on the remote part.

• DB by ODBC

- specific DBMS properties: quotes for names and values (there are generic and standard ones), ... ;

- OpenSCADA internal DB's layer function fieldStruct() implementation for generic SQL dialects and DBMS specific;

- OpenSCADA internal DB's layer functions fieldSeek(), fieldGet(), fieldDel() implementation for generic SQL dialects and DBMS specific;

- OpenSCADA internal DB's layer functions fieldDel() implementation for generic SQL dialects and DBMS specific;

- generic tests passing for: SQLite(there are some problems in allowed connectors), MySQL, PostgreSQL, FireBird;

- testing an ODBC connector for DBMS Oracle.

• Directory by LDAP

- expand the authentication mechanism by the storage functions (the DB object), that is virtual functions to TBD:

• auth() — direct checking the user authentication, through "bind" or ldap_whoami();
• passHash() — obtaining the password hash, to comparing, if auth() is missed, and changing the password by the function ldap_passwd() or see to the utility slappasswd.

- expand the "OSCADA-user" scheme:

• set the password field "PASS" as a synonym of "userPassword";
• make the own scheme dependent from "simpleSecurityObject";
• check of working with the field-type "userPassword".

|- |