LinuxQuestions.org
Visit Jeremy's Blog.
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 07-17-2004, 02:17 AM   #1
axelmang
Member
 
Registered: Mar 2004
Location: Athens
Distribution: Fedora 9
Posts: 72

Rep: Reputation: 15
mysql installation problems


Hello!

I have a problem with Mysql installation and I need help! I am running RedHat 9, 2.4.20-8smp. I am bulding an aplication that needs stored procedures and as I read from http://www.mysql.com this is supported since mysql 5. So I downloaded all the relative rpms (server, client, shared etc)

before I begin the installation I check what mysql version is already installed on my system:

Code:
[root@localhost root] # rpm -q mysql
mysql-3.23.54a-11
then I begin by trying to install the new server (but I get the following error:

Code:
[root@localhost server] # rpm -Uvh MySQL-server-4.0.20-0.i386.rpm
warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
even if I try with --force I get the same

Code:
[root@localhost Server] # rpm --force -Uvh MySQL-server-5.0.0-0.i386.rpm
warning: MySQL-server-5.0.0-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
So I decide to install all packages so us to avoid circular dependencies (I read a few things about them) but still no luck:

Code:
[root@localhost foo] # rpm -Uvh MySQL-client-5.0.0-0.i386.rpm MySQL-devel-5.0.0-0.i386.rpm MySQL-server-5.0.0-0.i386.rpm MySQL-shared-5.0.0-0.i386.rpm
warning: MySQL-client-5.0.0-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        libcrypto.so.0.9.6 is needed by MySQL-shared-5.0.0-0
        libssl.so.0.9.6 is needed by MySQL-shared-5.0.0-0
        libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
Can you please help me out here because I am a bit lost! I don't know what elese to try!

Thanx a lot!
axelman
 
Old 07-17-2004, 02:46 AM   #2
btmiller
Senior Member
 
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,284

Rep: Reputation: 371Reputation: 371Reputation: 371Reputation: 371
Stored procedures are available in 4.1 not 4.0, so installing 4.0.20 won't help you anyway, I'm afraid. Your problem is that there are multiple MySQL RPMs (mysql, mysql-client. mysql-server, and possible others), and they all depend on each other so you need to install/upgrade them all at once. You may find it easier to simply compile MySQL from source, particularly if you can't find a 4.1.x RPM that works with your distro. BTW if you want to install an RPM and have it ignore dependencies use the --nodeps option to rpm. Why --force does not imply --nodeps is beyond me, but I guess it makes sense to the people who wrote rpm .
 
Old 07-17-2004, 06:25 AM   #3
axelmang
Member
 
Registered: Mar 2004
Location: Athens
Distribution: Fedora 9
Posts: 72

Original Poster
Rep: Reputation: 15
Quote:
Originally posted by btmiller
Stored procedures are available in 4.1 not 4.0, so installing 4.0.20 won't help you anyway, I'm afraid. Your problem is that there are multiple MySQL RPMs (mysql, mysql-client. mysql-server, and possible others), and they all depend on each other so you need to install/upgrade them all at once. You may find it easier to simply compile MySQL from source, particularly if you can't find a 4.1.x RPM that works with your distro. BTW if you want to install an RPM and have it ignore dependencies use the --nodeps option to rpm. Why --force does not imply --nodeps is beyond me, but I guess it makes sense to the people who wrote rpm .
Thanx for your immediate reply!

I did not try to install 4.0.20 but 5.0! But it makes no difference! I also tryed 4.0 and get the same error messages!

I already tried to install all at once, as you suggested, but still no luck! I get the same (more or less) error messaeg:

Code:
[root@localhost foo] # rpm -Uvh MySQL-client-5.0.0-0.i386.rpm MySQL-devel-5.0.0-0.i386.rpm MySQL-server-5.0.0-0.i386.rpm MySQL-shared-5.0.0-0.i386.rpm
warning: MySQL-client-5.0.0-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        libcrypto.so.0.9.6 is needed by MySQL-shared-5.0.0-0
        libssl.so.0.9.6 is needed by MySQL-shared-5.0.0-0
        libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
any more suggestions would be really helpfull!
Thanx again
axelman
 
Old 07-17-2004, 06:51 AM   #4
london_geezer
Member
 
Registered: Oct 2003
Location: London, UK
Distribution: Debian Sarge & Mac OS X 10.3.8
Posts: 31

Rep: Reputation: 15
I haven't used RH for a good while, but I remember the GUI package front end for RPM which listed items to install and checks the dependencies for you.
If you're quite new at linux stuff try with the GUI first.

I only say this because the RPM GUI manager I use on Manadrake 10 linux is very intuitive to use.

As a side note, I couldn't make my PHP content management system work with MySQL until I added the mod_php package for Apache.

Regards
LG
 
Old 07-17-2004, 02:17 PM   #5
axelmang
Member
 
Registered: Mar 2004
Location: Athens
Distribution: Fedora 9
Posts: 72

Original Poster
Rep: Reputation: 15
Hi again!

I have already been using the redhat gui package manager! I remove everything that has to do with mysql and then go to a console and the following is returned:

Code:
[axelman@localhost axelman]$ whereis mysql
mysql: /usr/bin/mysql /usr/lib/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
[axelman@localhost axelman]$ rpm -q mysql
mysql-3.23.54a-11
I kind of not get it! So redhat tells me that did not remove mysql? But I just did! what is mysql-3.23.54a-11 doing in my system?

any ideas?

thanx a lot
axelman
 
Old 07-19-2004, 12:23 PM   #6
axelmang
Member
 
Registered: Mar 2004
Location: Athens
Distribution: Fedora 9
Posts: 72

Original Poster
Rep: Reputation: 15
Hello again!

I finally managed to uninstall previous versions of mysql and install the last version (5) I also installed the fron end control center for mysql (mysqlcc-0.9.4-linux-glibc22), but I still have a major problem

when I try to view the contents of a table I get a very strange message!

ERROR 1146: Table 'mysql.1' doesn't exist

I have searched the official web site and I found the solutiuon for that! they say run the script "mysql_fix_extensions" and restart the server!

I tried that but nothing changed! whatever table I want to view I get the same error! Even If I create a new db and a new table, again the same!

can anyone help me?

Another thing: I have installed most of the stuff from mysql
To be more specific I have installed:

MySQL-server-5.0.0-0.i386.rpm
MySQL-client-5.0.0-0.i386.rpm
MySQL-bench-5.0.0-0.i386.rpm
MySQL-embedded-5.0.0-0.i386.rpm
MySQL-devel-5.0.0-0.i386.rpm

I cannot install the following rpms because of dependency errors

kmysqladmin-0.6.9-1.i386.rpm
Code:
[root@localhost foo] # rpm -Uvh kmysqladmin-0.6.9-1.i386.rpm
error: Failed dependencies:
        libmysqlclient.so.10 is needed by kmysqladmin-0.6.9-1
MySQL-Max-5.0.0-0.i386.rpm
Code:
root@localhost foo] # rpm -Uvh MySQL-Max-5.0.0-0.i386.rpm
warning: MySQL-Max-5.0.0-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        libcrypto.so.0.9.6 is needed by MySQL-Max-5.0.0-0
        libssl.so.0.9.6 is needed by MySQL-Max-5.0.0-0
MySQL-shared-5.0.0-0.i386.rpm
Code:
[root@localhost foo] # rpm -Uvh MySQL-shared-5.0.0-0.i386.rpm
warning: MySQL-shared-5.0.0-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        libcrypto.so.0.9.6 is needed by MySQL-shared-5.0.0-0
        libssl.so.0.9.6 is needed by MySQL-shared-5.0.0-0
Also does anyone now how to handle stored procedures from mysql control center? or any other fron end for mysql?

Maybe I am asking for too much, but plz helm me out because I am a bit lost!

thanx in advance
axelmangr
 
Old 07-19-2004, 12:25 PM   #7
axelmang
Member
 
Registered: Mar 2004
Location: Athens
Distribution: Fedora 9
Posts: 72

Original Poster
Rep: Reputation: 15
another thing I forgot to add
the table proc of the database mysql is empty! If I run a select all from shell I get no results, while in other tables I get something! does this mean anything?

thanx again
axelmangr
 
Old 08-28-2004, 06:31 PM   #8
pdeeparao
LQ Newbie
 
Registered: Aug 2004
Posts: 1

Rep: Reputation: 0
Hi Alex,
I'm facing the same problem i had mysql-server-3.23.54a-11, mysql-devel-3.23.54a-11, mysql-3.23.54a-11 installed. I could uninstall the first two but when i tried to uninstall the third one I got similar error message and that is
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
As you were successful in uninstalling the older version, could you please tell me how you could do it?
Thanks in advance.
-Deepa.
 
Old 08-30-2004, 12:41 PM   #9
axelmang
Member
 
Registered: Mar 2004
Location: Athens
Distribution: Fedora 9
Posts: 72

Original Poster
Rep: Reputation: 15
Sorry I could not reply earlier but I was not at home during the weekend.
Anyway try the following:
Code:
rpm -e mysql perl-DBD-MySQL
If this doesn't work (I honestly don't think that you will have any problem but if) let me know.
axelmang
 
  


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
Problems with MySQL on SuSE: Can't Connect (/var/lib/mysql/mysql.sock) neocookie Linux - Software 8 02-07-2008 11:48 PM
mysql-installation: Not enough space in /var/lib/mysql/ linus123 Linux - Software 8 11-10-2006 02:19 PM
MySQL 3.23.58-14 installation prolem - mysql.sock not found lightcom Linux - Software 4 02-23-2005 12:46 AM
Apache Perl Mysql installation problems ridge321 Linux - Newbie 1 02-15-2005 08:49 AM
php4 mysql, installation, php-pages with mysql info stay empty dnla Linux - Software 2 03-14-2004 02:54 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 08:58 AM.

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