[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. 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.
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@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@centos.org http://lists.centos.org/mailman/listinfo/centos
-
Jason Pyeron