Jason Pyeron
2009-May-21 19:23 UTC
[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 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. 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.
Jason Pyeron
2009-May-21 19:58 UTC
[CentOS] [OT] Oracle->MySQL ODBC via SSL using: stock MySQL, mysql-connect or-odbc-3.51.27-0, Oracle XE [SOLVED]
> -----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 USGNWEBIt 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. 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 > lists.centos.org/mailman/listinfo/centos >