[CentOS] [OT] Oracle->MySQL ODBC via SSL using: stock MySQL, mysql-connect or-odbc-3.51.27-0, Oracle XE [SOLVED]
Jason Pyeron
jpyeron at pdinc.us
Thu May 21 19:58:28 UTC 2009
> -----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
>
More information about the CentOS
mailing list