Sponsored Content
Full Discussion: MySQL client on RHEL
Special Forums UNIX and Linux Applications MySQL client on RHEL Post 302938278 by rsheikh01 on Friday 13th of March 2015 05:47:38 PM
Old 03-13-2015
MySQL client on RHEL

I have a statistical application running on RHEL 6.2. One of the data source is a MySQL 5.1 DB running on a WIN platform. I need to make ODBC or MySQL connection to retrieve data.

What I did:
I have checked yum and selected the appropriate unixOdbc and installed w/o problem.

downloaded MySQL yum repository, installed using yum, updated it, then used it to install odbc/connector.

Issue:
I only see a 0 size odbc.ini in /etc and i am not sure where to look for the odbc/connector.
Code:
Installed:
  unixODBC.x86_64 0:2.2.14-14.el6
Complete
---

Installed:
  mysql-connector-odbc.x86_64 0:5.3.4-1.el6
Complete!

I know that setting up environment variables is the next part and setting up DSN (odbc.ini) but I am not sure where to look (I have run searches using find cmds but not getting anything back)

Any insight is appreciated.

---------- Post updated at 04:47 PM ---------- Previous update was at 04:34 PM ----------

This is the yum list installed output so this is reporting mysql components were installed:
Code:
mysql.x86_64                     5.1.69-1.el6_4        @rhel-x86_64-server-6.4.z
mysql-community-release.noarch   el6-5                 @/mysql-community-release-el6-5.noarch
mysql-connector-odbc.x86_64      5.3.4-1.el6           @mysql-connectors-community
mysql-libs.x86_64                5.1.69-1.el6_4        @rhel-x86_64-server-6.4.z
mysql-server.x86_64              5.1.69-1.el6_4        @rhel-x86_64-server-6.4.z

...

unixODBC.x86_64                  2.2.14-14.el6         @rhel-6-server-eus-rpms

 

10 More Discussions You Might Find Interesting

1. Solaris

mysql client

Hi there I am writing a script that will gather information on each machine and send it off to a central mysql database. I want to install the mysql client on every box so that I can just connect to a remote database and insert some data ... but it seems that all that is downloadable from the... (1 Reply)
Discussion started by: hcclnoodles
1 Replies

2. Solaris

DBI with MySQL client library compile on Solaris

how dow you complie perl module DBI with mysql from /usr/local/mysql/bin keeps going to mysql client for /usr/sfw/bin is it the LD_PATH ???...:confused: error is # perl login.cgi DBI connect('customers;mysql_socket=/tmp/mysql.sock:localhost','root',...) failed: Client does not... (1 Reply)
Discussion started by: photon
1 Replies

3. Red Hat

Samba Client for RHEL 4

I am looking for a Samba Client for a redhat 4 installation. I can't find it anywhere on the web. Does anyone have a link where i can find a working version ? This is my version: Red Hat Enterprise Linux AS release 4 (Nahant Update 7) /usr/bin/file: ELF 32-bit LSB executable, Intel... (5 Replies)
Discussion started by: guidovans
5 Replies

4. Red Hat

Rhel Client v6 and Flash player problem

Hello, I use Redhat enterprise Client v6. Firefox and chrome doesn't run flash script. I download (final version) and install flash rpm package. After redhat downloaded flash player security update and installed. but, still can not run flash script. what can i do for running flash script... (0 Replies)
Discussion started by: oulutas
0 Replies

5. Red Hat

Apache,php,mysql, and jdk 1.6 update 20 installation on RHEL 5.5

I want to install Apache (version 2.2.X), php (version 5.3.X),mysql (version 5.5.X) on RHEL 5.5. Guide re. site address for download all rpm. X = latest version. Thanks in advance. (1 Reply)
Discussion started by: vasdaax
1 Replies

6. Red Hat

Does RHEL 5 provide a command to collect RHEL system log in single compress file?

Hi, I heard a command that can collect all RHEL 5 log in a single compress file before I forget. Does any body know...What the command is ? Thanks. (4 Replies)
Discussion started by: nnnnnnine
4 Replies

7. Red Hat

Error throwing while installing vsftpd package in rhel 6. using rhel 6 dvd.

Hi all, Im studying rhcsa as of now, so yum installation and dependencies are messing me to not workit out. i have dual os, win 7 & rhel 6. i have tried this installation of vsftpd package with rhel 6 dvd in VM rhel 6 in win 7 as well as host rhel 6.still the same issue. below error... (6 Replies)
Discussion started by: redhatlbug
6 Replies

8. Red Hat

RHEL 6, Spacewalk 2.3 unable to download RHEL 5 repo data

Hello all, I am having a bit of an issue on my Spacewalk installation. Some amplifying information is that it is Spacewalk 2.3 installed on a RHEL 6 machine and I am attempting to install/update a RHEL 5 channel/repository. I am fairly new to Spacewalk so I am still learning but this is what I... (3 Replies)
Discussion started by: jstone4646
3 Replies

9. Red Hat

Getting "-bash-3.2#" prompt after logging to RHEL client

Hi, I am getting the -bash-3.2# prompt whenever I am trying to logging in the RHEL machine # ssh mindnic-02 root@mindnic-02's password: Last login: Thu May 25 14:06:31 2017 from 10.250.107.81 Could not chdir to home directory /root: No such file or directory -bash-3.2# Please help... (7 Replies)
Discussion started by: muzaffar.k
7 Replies

10. Shell Programming and Scripting

Error installing MySQL 8 on RHEL 7

My yum install command is failing. I first did yum clean all I even tried with localinstall. Below is the error output: yum install mysql-community-server*.rpm Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered with an... (8 Replies)
Discussion started by: mohtashims
8 Replies
odbcinst(1)						       unixODBC manual pages						       odbcinst(1)

NAME
odbcinst - An unixODBC tool for manipulating configuration files SYNOPSIS
odbcinst ACTION OBJECT OPTIONS DESCRIPTION
odbcinst is a command line tool which has been created for allowing people who are developing the install scripts/RPMs for Drivers to be able to easily create/remove entries in odbc.ini and odbcinst.ini. This command line tool is a complement to the shared library of the same name (libodbcinst.so). This tool is a part of the odbcinst component of unixODBC. OPTIONS
ACTIONS -i Install (add section to config file) new OBJECT. -u Uninstall (remove section from config file) existing OBJECT. -q Query the config files and print the options for specified OBJECT. -j Prints current configuration of unixODBC, listing (among others) the paths to the configuration files. -c Calls SQLCreateDataSource -m Calls SQLManageDataSources --version Prints program version and exits. OBJECTS -d The ACTION affect drivers (and thus the odbcinst.ini configuration file). -s The ACTION affect data sources (and thus the user or system odbc.ini configuration file). OPTIONS -f FILE The FILE is template file, describing the configuration of installed OBJECT (only valid for the -i ACTION). -r Same as the -f OPTION, only take the standard input as the template file. -n NAME Specifies the NAME of the OBJECT. -v Turn off verbose mode. This turns off all information, warning and error messages. -l The specified data source is system-wide. Has any effect only with the -s OBJECT. -h The specified data source is user-specific. Has any effect only with the -s OBJECT. RETURN VALUES
This command returns zero on success and non-zero value on failure. FILES
/etc/odbinst.ini Configuration file containing all the database drivers specifications. See odbcinst.ini(5) for more details. /etc/odbc.ini System-wide data sources specifications. See odbc.ini(5) for more details. $HOME/.odbc.ini User-specific data sources specifications. See odbc.ini(5) for more details. SEE ALSO
odbcinst.ini(5), odbc.ini(5) AUTHORS
The authors of unixODBC are Peter Harvey <pharvey@codebydesign.com> and Nick Gorham <nick@easysoft.com>. For the full list of contributors see the AUTHORS file. COPYRIGHT
unixODBC is licensed under the GNU Lesser General Public License. For details about the license, see the COPYING file. version 2.3.1 Wed 26 Jun 2013 odbcinst(1)
All times are GMT -4. The time now is 06:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy