L'intégration d'ODBC n'est possible qu'avec la licence Merak
Professionnelle.
Les principales étapes sont :
- Création d'une base de données pour Merak
- Création d'un DSN (Data Source Name)
- Configuration de Merak pour qu'il utilise la base de
données ODBC
1. Creation of a Database for Merak
You have to create one database in MySQL which will be used by
Merak. You can get the MySQL command line by typing the "mysql -u
<username> password <password>" to a command prompt.
I created "example" DB.
2. Creation of a System DSN
Go to Control Panel - Administrative Tools - Data Sources
(ODBC) - System DSN - Add
The "Create New Data Source" dialog will open. Choose the ODBC
driver you installed (in that case the MyODBC):
Then the "DSN Configuration" will appear.
Fill it in according to your settings as it is described in
Help:
|
DSN Information |
Description |
|
Data Source Name |
Identifies the MySQL ODBC 3.51 Driver and enter the name
that you want to use it as a reference |
|
Description |
Description About the Data Source Name |
|
MySQL Connection Parameters |
Description |
|
Host/Server Name (IP) |
Enter the host name of the MySQL server, to which you
want to connect. By default it is 'localhost'. |
|
Database Name |
Enter the default MySQL database name (catalog name) to
be used |
|
User Name |
Enter the user name |
|
Password |
Password |
|
Port |
The TCP/IP port to use if it is not listening to the
default one, 3306 |
|
SQL Command On Connect |
Optional SQL statement that will be executed when
connected to server |
(C) MySQL AB, 1995-2002, www.mysql.com
I have set a user "zbynek" with some password "passw" after
the installation of MySQL on my server with full rights to database "example". I
filled in my information with the "DSN Configuration". I installed MySQL on the
same server as Merak is running. If I want to place my database on another
server, I would set the DSN on the server where Merak is running and point to
the DSN on the server where MySQL is running.
Of course, it is much better to have SQL server installed on
another server than Merak because it is much better for performance (you can
have dedicated server for SQL server). I used localhost in this example just
because of simplicity.
3. Switching Merak to use ODBC
Open Merak Configuration Console and go to System ->
Storage -> Accounts tab. Here switch Merak to ODBC (without apply, just to be
able to edit odbc settings) and set the right settings in the db.ini (click on
"DB.INI File" button)
Set the syntax according to the Example file for db.ini. In my
example I had to add:
MySQLSyntax=1
Now go to 'ODBC Settings' dialog and fill in the DSN name,
username and password you set up in your 'DSN Configuration' delimited by
semi-colon.
Test the connection and if everything is working fine, save
the settings by clicking 'OK' and go back to 'ODBC settings' and use 'Create
Tables' to create the table structure in your database.
Now you can import the domains/users to the ODBC by clicking
the 'Convert To ODBC' button. Press F5 to reload and now Merak will work with
your MySQL DB.
Vérifiez
