Re: [Iodbc-applications] iodbctest tool fails to connect with mysql

[Tim H. <th...@op...>]

Sunil kumar Gundala wrote:

> i tried $ iodbctest "DSN=mysql;UID=mysql;PWD=mysql"  - failed
> 
> $ iodbc-config --odbcini
> gives /etc/odbc.ini
> 
> I also exported $ODBCINI to "/etc/odbc.ini" and tested . Again failed.
> 
> I checked with netstat and found that the server is listening on port 
> 3306/tcp
> 
> i modified the odbc.ini to have the variables you have set  and tested . 
> Failed
> [MySQL]
> Driver     = /usr/lib/libmyodbc3-3.51.09.so
> Host       = localhost
> Database   = mysql
> User       = mysql
> PWD        =mysql
> Port       = 3306

Right: is it always this same error message that it fails with?

> regarding connection using localhost ,mysql user id, i tried the same 
> with mysql administrator and it connects.
> 
> i had granted all the privileges by running the script specified by you.
> 
> I checked the connect.c but i may need to debug to find the real cause.
> Since i am a newcomer, it may take a long time for me.

Ah, that's just where it's coming from. There could be any number of 
macroscopic reasons why it's hitting that bit of myodbc driver code.

> Any other way of deciphering the problem would be helpful.

Next steps: can you run
$ ldd /usr/lib/libmyodbc3-3.51.09.so

and

$ strace -f -v -o foo.strace iodbctest "DSN=mysql;uid=mysql;uid=mysql"

and mail me the output and foo.strace file please?

Thanks,

~Tim
-- 
Tim Haynes
Product Development Consultant
OpenLink Software
<http://www.openlinksw.com/>