I.   Environment
II.  Installation
III. Typical problems

[ver] - version i.e. for MySQL - 4.0.17

I. Mediator for MySQL/Linux environment
--------------------------------------------

All tests of Mediator for MySQL were made within the
environment specified below. Other versions of MySQL
server, ODBC drivers and ODBC manager may work as well
but haven't been tested yet. Let us know if you experience
problems with other software versions.

Specified software elements are required to run
Mediator for MySQL on Linux server:

We are prefere to download source version, and compile them.

  1. iODBC version 3.0.6/3.51.0 or a newer one
	Download: 	http://www.iodbc.org/

	or

     UnixODBC
	Download:	http://www.unixodbc.com/


	All Mediator libraries actually are linked with iODBC libraries.


  2. MySQL server version 4.0 or a newer one
	Download:	http://www.mysql.com/
			(http://dev.mysql.com/downloads/)


  3. ODBC driver for MySQL version 3.51 or a newer one
	Download:	http://www.mysql.com/
			(http://dev.mysql.com/downloads/)
	

  4. Mediator version 4.1.0 or a newer one
	Download:  wwww.otc.pl/download





II. Installation
----------------

1. MySQL server installation

Download MySQL sources, binary or .rpm distribution, and install server.
Installation instructions (file INSTALL, INSTALL-SOURCE or INSTALL-BINARY)
are included in downloaded software after uncompressing.



2. Installing and configuring iODBC manager.

Download sources (see section I for download sources)

Uncompress the downloaded archive and follow instructions in
libiodbc-[ver].tar.gz/INSTALL

	root# tar -zxvf libiodbc-[ver].tar.gz
	root# cd libiodbc-[ver].tar.gz

Short installation (iODBC will be installed in
/usr/local/(bin, lib, include) directories):

	root# ./configure
	root# make
	root# make install

Attention:
To ensure iODBC libraries are visible enter

	export LD_LIBRARY_PATH=/usr/local/lib

or add path /usr/local/lib to /etc/ld.so.conf file and
execute command	 /sbin/ldconfig -v



3. Installing and configuring myodbc driver.

Download sources, binary or .rpm distribution, and install myodbc driver.
Uncompress the downloaded archive and follow instructions in downloaded software - 
files INSTALL or INSTALL-SOURCE or INSTALL-BINARY.

After installing, you need to set up ODBC data source which Mediator server will use
to access MySQL server. Either run iodbcadm-gtk administration
program which comes with iODBC manager or manually edit .odbc.ini file.

User datasources are configured in either the file $ODBCINI points to
or $HOME/.odbc.ini.
We recommend to copy .odbc.ini file to mysql home directory (/home/mysql),
or to any other home directory of user that will use myodbc driver.
You can also specify ODBCINI environment variable as (i.e.)
	
	export ODBCINI=/home/mysql/myodbc3/odbc.ini

Sample ODBC configuration files (.iodbc.ini) are included in MyODBC installation,
and also listed below:

;
;  odbc.ini configuration for MyODBC and MyODBC 3.51 Drivers
;

[ODBC Data Sources]

myodbc      = MySQL ODBC 2.50 Driver DSN 
myodbc3     = MySQL ODBC 3.51 Driver DSN 



[myodbc]
Driver       = /usr/local/lib/libmyodbc.so
Description  = MySQL ODBC 2.50 Driver DSN
SERVER       = localhost
PORT         =
USER         = root
Password     =
Database     = test
OPTION       = 3
SOCKET       = 


[myodbc3]
Driver       = /usr/local/lib/libmyodbc3.so
Description  = MySQL ODBC 3.51 Driver DSN
SERVER       = localhost
PORT         =
USER         = root
Password     =
Database     = test
OPTION       = 3   
SOCKET       = 


[Default]
Driver       = /usr/local/lib/libmyodbc3.so
Description  = MySQL ODBC 3.51 Driver DSN
SERVER       = localhost
PORT         =
USER         = root
Password     =
Database     = test
OPTION       = 3
SOCKET       = 




Testing ODBC installation.
To ensure your ODBC source is correctly configured run odbctest program
(installed with iODBC manager) specifying required parameters such as
"DSN=data_source_name;UID=db_user_name;PWD=db_user_password"

Example:
	mysql$ ./odbctest "DSN=test;UID=mysql"


5. Mediator

To install Mediator server for MySQL/Linux
follow instructions from msvmsqlxen.txt file attached
to Mediator server installation file.



III. Typical problems
---------------------

1. ODBC driver does not compile.

Possible reason: no sql.h
Solution: Install iODBC manager before installing ODBC driver.