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
isamlog(1)							  MySQL database							isamlog(1)

NAME
isamlog - Write info about whats in a nisam log file. USAGE
isamlog [-?iruvIV] [-c #] [-f #] [-F filepath/] [-o #] [-R file recordpos] [-w write_file] [log-filename [table ...]] SYNOPSIS
isamlog [-?|-I] [-V] [-c] [-f] [-F] [-i] [-o] [-p #] [-r] [-R] [-u] [-v] [-w] DESCRIPTION
isamlog -?|-I info -V version -c do only # commands -f max open files -F file path -i extra info -o offset -p # remove # components from path -r recover -R file recordposition -u update -v verbose -w write file NOTE
If no file name is given isam.log is used One can give a second and a third '-v' for more verbose. Normaly one does a update (-u). If a recover is done all writes and all possibly updates and deletes is done and errors are only counted. If one gives table names as arguments only these tables will be updated SEE ALSO
isamchk(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi- lege_tables(1), mysqlshow(1), mysql_zap(1), perror(1), replace(1) For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online at http://www.mysql.com/doc/en/ BUGS
Please refer to http://bugs.mysql.com/ to report bugs. AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur- media.com) ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +--------------------+------------------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +--------------------+------------------------------------+ |Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt | +--------------------+------------------------------------+ |Interface Stability | External | +--------------------+------------------------------------+ NOTES
Source for mysql is available on http://opensolaris.org. MySQL 4.0 19 December 2000 isamlog(1)
All times are GMT -4. The time now is 09:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy