Cognos 10 + Redhut + MySQL

[admin.ibm@otipo.com]

Hi all,

I'm trying to make Cognos work with my application MySql database, and I fail to create the ODBC DataSource.

Setup description:
Server A - UBUNTU with my application and MySql 5.1 running on it.
Server B - Redhut 6 64, with Cognos 10.1 installed on it.

I have installed myodbc package on server B, and defined the following odbc.ini settings:

[ODBC Data Sources]
otipo = Otipo odbc connection

[otipo]
Driver = /usr/lib64/libmyodbc5.so
Description = ODBC for MySQL Otipo
SERVER  = xxx.yyy.zzz.rrr
PORT = 3306
USER = eeee
Password = cccc
Database = dbname

To test the settings I have activated
isql otipo

Every thing works well until now.

Next, I went  to Cognos -->Administration -->Configuration --> DataSource Connection
and no matter how I defined the DataSource, when I test it I get the same annoying result:
"DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit."

The stack trace is :
Handler trace back:
[the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler
[service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler
[load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
[lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler
[mdaChainHandler] com.cognos.pogo.handlers.logic.ChainHandler
[asyncMetadataServiceHandler] com.cognos.pogo.async.impl.AsyncHandler
[metadataServiceHandler] com.cognos.metadataService.bibusHandler.MDSRVHandler

In the cogserver log , I see this error message:
Process BmtMDProviderMain failed to start properly.

Is it an installation problem or an ODBC problem?

These are the connection  string I tried:

• ;LOCAL;OD;DSN=otipo;@ASYNC=0@0/0@COLSEQ=
• Driver=/usr/lib64/libmyodbc5.so;Server=the_server;User=the_user;Password=the_password;Database=db_name
• ;LOCAL;OD;DSN=OtipoDB;Server=the_server;Port=3306;Database=the_db;Uid=the_user;Pwd=the_password;@ASYNC=0@0/0@COLSEQ=

Any help will be appreciated.

Golan