Issue with installing the mysql gem: solved, how to install mysql gem without issue

When tried to install mysql gem I got following error
[root@localhost purab]# sudo gem install mysql
Building native extensions. This could take a while…
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.

/usr/bin/ruby extconf.rb
checking for mysql_ssl_set()… yes
checking for rb_str_set_len()… no
checking for rb_thread_start_timer()… yes
checking for mysql.h… no
checking for mysql/mysql.h… no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.

Provided configuration options:
–with-opt-dir
–without-opt-dir
–with-opt-include
–without-opt-include=${opt-dir}/include
–with-opt-lib
–without-opt-lib=${opt-dir}/lib
–with-make-prog
–without-make-prog
–srcdir=.
–curdir
–ruby=/usr/bin/ruby
–with-mysql-config
–without-mysql-config

Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/mysql-2.8.1 for inspection.
Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.8.1/ext/mysql_api/gem_make.out

To find the mysql path on machine used following command
[root@localhost purab]# which mysql
/usr/bin/mysql

I tried following command:
[root@localhost purab]# sudo gem install mysql — –with-mysql-dir=/usr/bin/mysql

I Got the same error

[root@localhost purab]# sudo gem install mysql — –with-mysql-dir=/usr/bin/mysql
Building native extensions. This could take a while…
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.

/usr/bin/ruby extconf.rb
checking for mysql_ssl_set()… yes
checking for rb_str_set_len()… no
checking for rb_thread_start_timer()… yes
checking for mysql.h… no
checking for mysql/mysql.h… no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.

Provided configuration options:
–with-opt-dir
–without-opt-dir
–with-opt-include
–without-opt-include=${opt-dir}/include
–with-opt-lib
–without-opt-lib=${opt-dir}/lib
–with-make-prog
–without-make-prog
–srcdir=.
–curdir
–ruby=/usr/bin/ruby
–with-mysql-config
–without-mysql-config

Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/mysql-2.8.1 for inspection.
Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.8.1/ext/mysql_api/gem_make.out
ERROR: could not find gem — locally or in a repository
ERROR: could not find gem –with-mysql-dir=/usr/bin/mysql locally or in a repository

Then I checked the mysql-devel
[root@localhost purab]# yum list mysql-devel
Loaded plugins: refresh-packagekit
Available Packages
mysql-devel.i586 5.1.37-1.fc11 updates

Then I Installed the mysql-devel
[root@localhost purab]# yum install mysql-devel
Installed:
mysql-devel.i586 0:5.1.37-1.fc11
Complete!

Then I tried the mysql Gem installing…..I am able to install the mysql gem…
[root@localhost purab]# gem install mysql
Building native extensions. This could take a while…
Successfully installed mysql-2.8.1
1 gem installed
Installing ri documentation for mysql-2.8.1…
Installing RDoc documentation for mysql-2.8.1…
[root@localhost purab]#

Install Mysql cluster on Fedora box

Each MySQL Cluster host computer running an SQL node must have installed on it a MySQL. For management nodes and data nodes,
it is not necessary to install the MySQL server binary,
but management nodes require the management server daemon (ndb_mgmd) and data nodes require the data node daemon (ndbd).

It is also a good idea to install the management client (ndb_mgm) on the management server host.
This section covers the steps necessary to install the correct binaries for each type of Cluster node.

Important Note:
If you have mysql installed already than remove that from computer using following command
[root@localhost purab]# yum remove mysql mysql-server mysql-libs mysql-common

Open http://dev.mysql.com/downloads/
click on * MySQL Cluster url:
http://dev.mysql.com/downloads/select.php?id=14
Scoll down,
Under “Current Realeases” section
You will see the following text;
MySQL Cluster 7.0.8a GA
Select the Red Hat Enterprise Linux here and download following packages.

Select Operating System: Red Hat Enterprise Linux
As per linux edition(4 and 5) and computer and Os comptable(64bit or 32bit download the RPMs
I am using the Fedora 11 as OS and 32bit Intel machine.
I used or downloaded following RPM files from above URL:
MySQL-Cluster-gpl-debuginfo-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-embedded-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-server-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-7.0.8a-0.rhel5.src.rpm
MySQL-Cluster-gpl-7.0.8a-0.sles11.src.rpm
MySQL-Cluster-gpl-devel-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-tools-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-test-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-client-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-extra-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-storage-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-shared-7.0.8a-0.rhel5.i386.rpm
MySQL-Cluster-gpl-management-7.0.8a-0.rhel5.i386.rpm

SQL node installation — RPM files. On each machine to be used for hosting a cluster SQL node, install the Server RPM by executing the following command as the system root user, replacing the name shown for the RPM as necessary to match the name of the RPM downloaded from the MySQL web site:

How to repeat:
Make sure you have nothing in /var/lib/mysql and /var/lock/subsys/mysql.
The do :
rpm -i MySQL-client-5.1.25-0.glibc23.x86_64.rpm MySQL-server-5.1.25-0.glibc23.x86_64.rpm

[root@localhost MysqlClusterSoft]# rpm -iv MySQL-Cluster-gpl-*

Forcely install the above rpms again, for that use following command.
[root@localhost MysqlClusterSoft]# rpm -ivh –force MySQL-Cluster-gpl-server-7.0.8a-0.rhel5.i386.rpm

Following command you can use for uninstall the Mysql cluster.
[root@localhost MysqlClusterSoft]# rpm -e -F MySQL-Cluster-gpl-*

[root@localhost MysqlClusterSoft]# yum install mysql mysql-server

[root@localhost MysqlClusterSoft]# rpm -Uhv MySQL-Cluster-gpl-server-7.0.8a-0.rhel5.i386.rpm
Preparing… ########################################### [100%]
1:MySQL-Cluster-gpl-serve########################################### [100%]
091113 17:05:13 [Warning] Forcing shutdown of 3 plugins
091113 17:05:13 [Warning] Forcing shutdown of 3 plugins

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h localhost.localdomain password ‘new-password’

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available at http://www.mysql.com/
Support MySQL by buying support/licenses from http://shop.mysql.com/

[root@localhost MysqlClusterSoft]#

[root@localhost MysqlClusterSoft]# rpm -Uhv MySQL-Cluster-gpl-client-7.0.8a-0.rhel5.i386.rpm
Preparing… ########################################### [100%]
package MySQL-Cluster-gpl-client-7.0.8a-0.rhel5.i386 is already installed

After all installtion Please reboot the machine. and Run the nbdb server and load the sample data.
Use following article…
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-multi-load-data-queries.html

How to install mysql-connector-java / mysql-connector-odbc on fedora

I am using the Fedora9 for installation
I downloaded rmp file from this location.
http://rpm.pbone.net/index.php3/stat/4/idpl/7221422/com/mysql-connector-java-3.1.12-5.fc9.i386.rpm.html

If you are using the fedora 10 or 11, you can use this url;
http://www.rpmfind.net/linux/rpm2html/search.php?query=mysql-connector-java&submit=Search+…&system=fedora+9&arch=

[purab@localhost ]$ su
Password:
[root@localhost ]# rpm -Uvh mysql-connector-java-3.1.12-5.fc9.i386.rpm
Preparing… ########################################### [100%]
1:mysql-connector-java ########################################### [100%]
[root@localhost ]#

how to install mysql-connector-odbc on fedora

I downloaded rmp file from this location.
http://rpm.pbone.net/index.php3?stat=3&search=mysql-connector-odbc&srodzaj=3

[root@localhost Desktop]# rpm -Uvh mysql-connector-odbc-3.51.24r1071-1.fc9.i386.rpm
Preparing… ########################################### [100%]
1:mysql-connector-odbc ########################################### [100%]
[root@localhost Desktop]#

How to find the Mysql database engine type

You need to use this command for checking the engine type:

SHOW TABLE STATUS WHERE Name = ‘users’;

Or Use this command for checking the all table’s engine type.

SHOW TABLE STATUS;

Or You can use this command for database:

mysqlshow –status db_name;

I used following URL for creating this commands:

Source Article : http://wpapi.com/how-to-find-the-mysql-database-engine-type

http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html

5 vote down checkSHOW TABLE STATUS WHERE Name = 'xxx'