[CentOS] [OT] Oracle->MySQL ODBC via SSL using: stock MySQL, mysql-connect or-odbc-3.51.27-0, Oracle XE [SOLVED]

Thu May 21 19:58:28 UTC 2009
Jason Pyeron <jpyeron at pdinc.us>

 

> -----Original Message-----
> From: centos-bounces at centos.org 
> [mailto:centos-bounces at centos.org] On Behalf Of Jason Pyeron
> Sent: Thursday, May 21, 2009 15:23
> To: CentOS mailing list
> Subject: [CentOS] [OT] Oracle->MySQL ODBC via SSL using: 
> stock MySQL,mysql-connect or-odbc-3.51.27-0, Oracle XE
> 
> I know this is very off topic, but getting MySQL and unix 
> ODBC to play nice via SSL on Centos has been a battle.
> 
> I finally have it working via isql but when I connect via 
> Oracle I get an error.
> 
> If I use the mysql odbc connector directly:
> 
> ORA-28500: connection from ORACLE to a non-Oracle system returned this
> message:
> [Generic Connectivity Using ODBC][MySQL][ODBC 3.51 Driver]SSL 
> connection error (SQL State: S1000; SQL Code: 2026)
> ORA-02063: preceding 2 lines from USGNWEB

It would help if the oracle user had permissions to read the certificate and key
files.

> 
> 
> If I connect via unixODBC:
> 
> 
> ORA-28500: connection from ORACLE to a non-Oracle system returned this
> message:
> [Generic Connectivity Using ODBC][unixODBC][MySQL][ODBC 3.51 
> Driver]SSL connection error (SQL State: S1000; SQL Code: 2026)
> ORA-02063: preceding 2 lines from USGNWEB
> 
> 
> My assumption is that I am missing some environment variable 
> in Oracle's environment, but what should I look for? What 
> information could I provide that would be helpful?
> 
> -Jason
> 
> --
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> -                                                               -
> - Jason Pyeron                      PD Inc. http://www.pdinc.us -
> - Principal Consultant              10 West 24th Street #100    -
> - +1 (443) 269-1555 x333            Baltimore, Maryland 21218   -
> -                                                               -
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This message is copyright PD Inc, subject to license 20080407P00.
> 
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>