When requesting information from a ldap server (search), size limits in the ldap server are preventing all information being returned to the client.
The hide page plugin can be used to overcome this issue. This extension works by performing a search with the max page size value set in the configuration panel. When the number of results returned by the server exceeds the value of the max page size limit, the plugin will do subsequent queries to retrieve the remaining results and will collate the response entries to present the results as a single set returned by the backend server.
For further information please refer to the Pagination - Hide Page Plugin available on the installation media in the folder docs | extensions.
Client obtains Error 51 (Busy) when sending amount of BINDS to an Active Directory.
00002024: LdapErr: DSID-0C060598, comment: No other operations may be performed on the connection while a bind is outstanding., data 0, v1db1
In fact, this is a limitation of the Active Directory. But, if we have few connections configured in the pool of BINDS (by default is set to 2) of the DataSource, it's possible that the directory don't have enough time to process them, generating the error.
Within the GUI: Output->DataSource->Connection Pooling
Increase the value of the 'Bind Pool Connections' parameter, for example to 10.
DataSources can be configured to use relational databases for data access. But before being able to use them, there are additional configuration steps needed at the environment, which depend on the type of database.
First of all, the UnixODBC tool must be installed, which implements the ODBC common API that enables ODBC database connections. Then, each different kind of database will need its own ODBC driver, so you only need to install the one you are planning to use. We have provided instructions for the most common ones:
ODBC driver for MySQL, available in the MySQL website
ODBC driver for MsSQL, through the FreeTDS driver
ODBC driver for Oracle, through the InstantClient driver from the Oracle website (two packages are needed)
Any other database can be configured as well by installing its own ODBC driver.
1) Choose a directory such as "/var/tmp/" to store temporal files and download "unixODBC-2.3.0.tar.gz" from:
http://www.unixodbc.org/
2) Uncompress, compile and install UnixODBC (you can find additional information in its README and INSTALL docs). You need to have installed tools such as "gcc", "make" and "tar":
cd /var/tmp/ tar xvzf unixODBC-2.3.0.tar.gz cd unixODBC-2.3.0 ./configure make sudo make install
3) In some environments you may need to add UnixODBC to the LD_LIBRARY_PATH:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
It should be possible to use the latest MySQL version, 3.51 is used as an example in this case.
1) Choose a directory such as "/var/tmp/" to store temporal files and download "mysql-connector-odbc-3.51.25-linux-x86-32bit" from the MySQL website:
http://downloads.mysql.com/archives.php?p=mysql-connector-odbc-3.51&v=3.51.25
2) Choose or create a directory
cd <PATH> tar xvfz mysql-connector-odbc-3.51.25-linux-x86-32bit.tar.gz
3) Register the MySQL ODBC driver:
cd mysql-connector-odbc-3.51.25-linux-x86-32bit/bin/ sudo ./myodbc3i -a -d -t"MySQL;Driver=<PATH>/mysql-connector-odbc-3.51.25-linux-x86-32bit/lib/libmyodbc3-3.51.25.so")
4) Append your MySQL configuration to /usr/local/etc/odbc.ini:
[MySQL-test] Description = mysql_description Trace = No Driver = MySQL Server = <HOST> Port = <PORT> Database = <DATABASE>
Where:
MySQL-test is the name of the ODBC connector to be referenced in the VDS configurations
MySQL is the driver name that was added to odbcinst.ini by myodbc3i
1) Choose a directory such as "/var/tmp/" to store temporal files and download "freetds-patched.tgz " from:
http://mirrors.ibiblio.org/freetds/stable/freetds-patched.tgz
2) Choose or create a directory
mkdir <PATH>
3) Uncompress, compile and install FreeTDS:
cd /var/tmp/ tar xvzf freetds-patched.tgz cd freetds-0.91 ./configure --prefix=<PATH>/0.91 --with-tdsver=7.1 --with-unixodbc=/usr/local make sudo make install
4) Create a file called "freetdsodbc.txt" with the following content and add it to "/usr/local/etc/odbcinst.ini" with odbcinst:
[FreeTDS] Description = v0.91 with protocol v7.1 Driver = <PATH>/0.91/lib/libtdsodbc.so sudo odbcinst -i -d -f freetdsodbc.txt
5) Append your MsSQL configuration to "/usr/local/etc/odbc.ini":
[MsSQL-test] Description = dbi_mssql_tests Trace = No Driver = FreeTDS Server = <HOST> Port = <PORT> Database = <DATABASE>
Where:
MsSQL-test is the name of the ODBC connector to be referenced in the VDS configurations
FreeTDS is the driver name that was added to odbcinst.ini by odbcinst
1) Choose a directory such as "/var/tmp/" to store temporal files and download both "instantclient-basic-linux-11.2.0.3.0.zip" and "instantclient-odbc-linux-11.2.0.3-0.zip" from:
http://www.oracle.com/technetwork/topics/linuxsoft-082809.html
2) Choose or create a directory
cd <PATH> unzip /var/tmp/instantclient-basic-linux-11.2.0.3.0.zip unzip /var/tmp/instantclient-odbc-linux-11.2.0.3-0.zip
3) You may need to add InstantClient to the LD_LIBRARY_PATH:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:<PATH>/instantclient_11_2
4) Create a file called "oracleodbc.txt" with the following content and add it to "/usr/local/etc/odbcinst.ini" with odbcinst:
[Oracle] Description = instant Oracle 11_2 Driver = <PATH>/instantclient_11_2/libsqora.so.11.1 sudo odbcinst -i -d -f oracleodbc.txt
5) Append your Oracle configuration to "/usr/local/etc/odbc.ini":
[Oracle-test] Description = dbi_oracle_tests Driver = Oracle ServerName = //<HOST>:<PORT>/<DATABASE>
Where:
Oracle-test is the name of the ODBC connector to be referenced in the VDS configurations
Oracle is the driver name that was added to odbcinst.ini by odbcinst
VDS is a 32 bit application. When installed in a 64 bit Linux environment, you can suffer some problems when starting the GUI or running the dsproxy component, involving error messages regarding the location of some libraries.
In order to make VDS work properly, you need to install additional packages. This is a common need for all 32 bits applications, so generic solutions for a certain environment should work for VDS as well.
In this solution we have provided examples we have verified to work in some distributions.
VDS is a 32 bit application and consequently it requires 32 bit libraries which are not available in a 64 bit Linux environment.
As administrator/root:
sudo apt-get install ia32-libs
yum install zlib.i686 yum install libgcc.i686 yum install libXtst.i686 yum install libXrender.i686
Depends on the packages installed by default. If you find trouble with some library location, the way to proceed is explained below:
The solution is not to add the /lib64 directory to LD_LIBRARY_PATH, because VDS doesn't work with 64 bit libraries. What you need is the library from a 32 bit package.
Open YaST Control Center -> Software Management (from Main Menu)
For example, if you are getting an error regarding the library libz.so.1, this library belongs to a package which is something like 'zlib...'
Go to the 'Search' tab and type 'zlib' and click Search.
The result should be that you have the 'zlib' package installed. You can see in the 'File List' tab (below the results screen) the /lib64/libz.so.1 library.
But you need the one which is included in the 'zlib-32bit' package which is pretty likely that it isn't installed.
So, install this package and the error shouldn't appear any more.
It is possible, that you get any other error messages regarding other libraries. The way to proceed is the same.
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
