LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 05-18-2005, 11:48 PM   #1
tjulius
LQ Newbie
 
Registered: Apr 2005
Posts: 15

Rep: Reputation: 0
I just want to install MySQL!!


I'm relatively new to Linux/unix, and am just trying to get a server up and running.

I have RedHat Enterprise 3, and I need to get FTP and MySQL in in order to do the work (I embarked on this a month ago, and I'm still not up and running).

The FTP issue is for a separate post, but I'm trying to get MySQL in. I already wiped out everything and restarted once, and I'd rather not do that again.

I went to the MySQL site and downloaded the server and the shared libraries (RPMs) not realizing (1) what I wanted (I think) is server and client, and (2) that the client has to go in before the server.

So, server installation failed; I installed shared libraries (although I think they're not necessary) and then client failed because of a conflict with the shared libraries.

So I took - I think - ALL of the shared library references out. I did:

rpm -e MySQL-shared-standard-4.1.12-0.rhel3

which didn't complain, so it seemed to take it out. Then I did

rpm -qa | grep MySQL | sort

to list what was there, and I got

MySQL-python-0.9.1-6
perl-DBD-MySQL-2.1021-3
qt-MySQL-3.1.2-13

In other words, NO shared library (rhel3).

It just occurred to me now that rhel3 means "red hat enterprise linux 3"... if so, was this installed by the system?

Anyway, putting in MySQL client gives me the following raft of errors...

rpm -Uvh MySQL-client-4.1.12-0.i386.rpm
warning: MySQL-client-4.1.12-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
file /usr/bin/mysql from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/bin/mysql_find_rows from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/bin/mysqlaccess from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/bin/mysqlbinlog from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/bin/mysqlcheck from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/bin/mysqldump from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/bin/mysqldumpslow from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/bin/mysqlimport from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/bin/mysqlshow from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/share/man/man1/mysql.1.gz from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/share/man/man1/mysqlaccess.1.gz from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/share/man/man1/mysqladmin.1.gz from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/share/man/man1/mysqldump.1.gz from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1
file /usr/share/man/man1/mysqlshow.1.gz from install of MySQL-client-4.1.12-0 conflicts with file from package mysql-3.23.58-15.RHEL3.1

But another check...

rpm -qa | grep MySQL | sort
MySQL-python-0.9.1-6
perl-DBD-MySQL-2.1021-3
qt-MySQL-3.1.2-13

still shows no shared library installed. What am I missing here? It seems to be complaining about a conflict with an uninstalled package...?????

Note: the reason I restarted the installation from scratch was because last time I got MySQL installed fine (somehow) but ran into library conflicts on something else to the point that it just seemed easier to start clean. I've been developing software for 30 years, but have never seen anything like the library conflicts here. Is there some straightforward approach to solving these?
 
Old 05-19-2005, 01:05 AM   #2
mrcheeks
Senior Member
 
Registered: Mar 2004
Location: far enough
Distribution: OS X 10.6.7
Posts: 1,690

Rep: Reputation: 51
try rpm -e mysql-3.23.58-15.RHEL3.1 and try to install mysql again

you cannot install mysql-server 4.X and have mysql 3.X installed. Be sure to intall both mysql-client 4.X and mysql server 4.X.
 
Old 05-19-2005, 08:02 AM   #3
tjulius
LQ Newbie
 
Registered: Apr 2005
Posts: 15

Original Poster
Rep: Reputation: 0
Not so easy

I didn't realize I was putting in a version of 4 whereas the existing stuff was 3 - thanks for pointing that out.

Unfortunately trying to take out the 3.x shared libraries has its own problems:

rpm -e mysql-3.23.58-15.RHEL3.1
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) qt-MySQL-3.1.2-13
libmysqlclient.so.10 is needed by (installed) MyODBC-2.50.39-12
libmysqlclient.so.10 is needed by (installed) libdbi-dbd-mysql-0.6.5-5
libmysqlclient.so.10 is needed by (installed) MySQL-python-0.9.1-6
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-20030510-1.ent
libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.2-23.ent
mysql = 3.23.58 is needed by (installed) mysql-devel-3.23.58-15.RHEL3.1
mysql = 3.23.58 is needed by (installed) mysql-bench-3.23.58-15.RHEL3.1
mysql is needed by (installed) MySQL-python-0.9.1-6

It seems like I'd either have to take out all kinds of stuff, or upgrade all kinds of stuff (everything seems to depend on everything else).

Would I be better off just trying to install MySQL 3?

It seems like RedHat Linux Enterprise 3 has the shared libraries and stuff for MySQL 3 but not MySQL itself.
 
Old 05-19-2005, 12:07 PM   #4
tjulius
LQ Newbie
 
Registered: Apr 2005
Posts: 15

Original Poster
Rep: Reputation: 0
Uh oh

Okay, given that thinking, I decided to put 3.23 on instead of 4, but got errors. Finally I decided to wipe every trace of 3.23 off, and install 4. That did better (although I had a circular reference when trying to wipe 3.23, but got around it by telling it not to check dependencies). Finally, 3.23 is gone.

Installing 4 client goes okay.

Installing 4 server does not (!!):

rpm -Uvh MySQL-server-4.1.12-0.i386.rpm
warning: MySQL-server-4.1.12-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]
050519 12:00:23 [Warning] Asked for 196608 thread stack, but got 126976
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x85d71d0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbff5ed18, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x808df77
0x82e8af8
0x85d8760
0x80b3fe1
0x80a2c14
0x809c69e
0x82e62ac
0x830fc3a
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/Us...ack_trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x85f2900 = CREATE TABLE db ( Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Lock_tables_priv enum('N','Y') COLLATE utf8_genera
thd->thread_id=1
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
/usr/bin/mysql_create_system_tables: line 663: 31838 Broken pipe cat <<END_OF_DATA
use mysql;
set table_type=myisam;
$c_d
$i_d

$c_h
$i_h

$c_u
$i_u

$c_f
$i_f

$c_t
$c_c

$c_ht
$c_hc
$c_hr
$c_hk

$c_tzn
$i_tzn
$c_tz
$i_tz
$c_tzt
$i_tzt
$c_tztt
$i_tztt
$c_tzls
$i_tzls
END_OF_DATA

Installation of system tables failed!

Examine the logs in /var/lib/mysql for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
You can use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Starting MySQL...................................stty: standard input: Invalid argument
[FAILED]
 
Old 05-19-2005, 12:19 PM   #5
reddazz
LQ Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 74
Use yum to install mysql-server. As root do,
Code:
#yum install mysql-server
This will install whatever the sable version is for RHEL 3.x and resolve any dependencies.
 
Old 05-19-2005, 12:29 PM   #6
tjulius
LQ Newbie
 
Registered: Apr 2005
Posts: 15

Original Poster
Rep: Reputation: 0
Yum?

Where is that?
 
Old 05-19-2005, 01:19 PM   #7
reddazz
LQ Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 74
You need to run that command in a terminal emulator like konsole or gnome-terminal as root. YUM is a package management tool for Redhat/Fedora and distributions based on it. To find out about yum, you can do "man yum" in a terminal emulator.
 
Old 05-19-2005, 04:45 PM   #8
tjulius
LQ Newbie
 
Registered: Apr 2005
Posts: 15

Original Poster
Rep: Reputation: 0
Not so trivial either

I don't have YUM on the system, so I downloaded yum 2.2. The installation instructions are incredibly brief, saying "run make install if you're a masochist but you're better off making a rpm and doing that".

I don't know how to make an rpm, so I ran "make install", which did stuff without seeming complaint, but I'm not sure yum is on the system (if I type yum, I get:

Traceback (most recent call last):
File "/usr/bin/yum", line 6, in ?
import yummain
File "/usr/share/yum-cli/yummain.py", line 23, in ?
import yum
ImportError: No module named yum

I'm really trying to avoid "overfixing" the problem, installing more and more stuff in hopes of making something stick.

Since my system didn't have yum on it (and it may not have it now, and it's not trivial to install, I guess), working just with the rpms, how can I get MySQL installed? Should I go back to trying to get 3.x installed, or continue working with 4?

Thanks
 
Old 05-19-2005, 06:57 PM   #9
reddazz
LQ Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 74
YUM is shipped with every Fedora/Redhat release as default. By installing another copy you have basically hosed the default yum package. You will have to uninstall the version you installed, and reinstall the yum rpm from Fedora.
 
Old 05-19-2005, 07:34 PM   #10
tjulius
LQ Newbie
 
Registered: Apr 2005
Posts: 15

Original Poster
Rep: Reputation: 0
Not on my system

Before I had done this, I searched for yum, and found nothing.

I don't want to screw around with yum at this point, this is just making things worse. I'll start putting 3.23 on from scratch.
 
Old 05-19-2005, 09:44 PM   #11
reddazz
LQ Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 74
Unfortunately its not yum thas making things work, but you don't seem to understand how package management works in Redhat/Fedora systems. A package management tool such as YUM is included by default so that you don't have to mess around installing packages manually. I suggest you read a bit more about YUM and managing packages on Redhat before messing around further with your system. If you don't want to use a package manager you will have to download all packages and manually resolve all dependencies. If you happen to download rpms that are not compatible with your system, you will have problems fulfilling these dependencies or you will hose your system.
 
Old 05-19-2005, 11:28 PM   #12
tjulius
LQ Newbie
 
Registered: Apr 2005
Posts: 15

Original Poster
Rep: Reputation: 0
Sorry

Sorry that I don't understand how packet management works.

That is, of course, why I posted here in the newbie forum, hoping that fact might be taken into account.

And, no, there is no yum on my machine, no ability to do 'man yum' or otherwise invoke it and/or information about it. Seriously, there is no yum on my machine. I may be a linux newbie, but I have been through systems from tops-20 to CP/M to DOS to windows systems and os/9 and os/x internals and others. I don't always know the exact way to proceed but that doesn't mean I'm clueless.

I regret that knowing how packet management works is a requirement for the newbie forum. In the future I will become a versed user and then won't be inexperienced enough to post in the newbie forum.
 
Old 05-20-2005, 01:49 AM   #13
reddazz
LQ Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 74
I don't think there was any need for you to be sacarstic and offensive in your last post after I have spent a lot of my free time trying to help you sort out your problem. If you have anything to say, or disagree with my post, there are better ways of putting your views across to me.

Anyway after doing more research into your problem I found out that the official RHEL 3 has yum removed for some reason, so you can only upgrade via up2date. RHEL 4 has yum, so I don't know why it wasn't included with RHEL 3. Distributions that are based on RHEL 3 do ship with yum, but I don't know if installing their packages will affect your current RHEL licence.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 01:42 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
DBD::MySQL + MySQL install problems. Elleroth Linux - Software 4 03-24-2006 07:53 AM
MySQL 4 on Fedora can't install php-mysql kennyg Linux - Software 8 09-21-2004 07:54 PM
MySQL mysql-3.23.56-1.9, rpm install problem jacsmith510 Linux - Newbie 3 09-19-2003 03:02 PM


All times are GMT -5. The time now is 01:03 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration