I cannot access my database

[Guest Diana]

Hello,

 

Is there someone who can help me?

 

I Installed Fedora 1 on my computer.

After doing this I deinstalled Mysql and php.

I want to install the source code (tar) instead of rpm

So I did it.

 

1) I copy the mysql-3.23.58.tar.gz file in the directory: usr/local/src/mysql

2) cd usr/local/src/mysql

3) gunzip mysql-3.23.58.tar.gz

4) tar -xvf mysql-3.23.58.tar

5) cd mysql-3.23.58

6) ./configure --prefix=/usr/local/mysql/src/mysql

7) make

8) make install

9) make clean

 

After this all, I go to the root and type: service mysqld status

 

but I am getting the message: mysqld: unrecognized service

 

Can someone tell me what the problem is?

 

Thanks

 

Diana

 

[moved from software - tyme]

[tyme]

Simple question to start off: Is there a reason you are using such an old version of Fedora? I believe FC is up to 6 now.

 

Also note that the scripts used to start services with the service command are usually created by the distributors and not part of the source package that you've compiled.

 

To start it, you probably need to find the mysql daemon, I'm not sure what the name of the executable is but I would guess mysqld - it is likely in /usr/bin or /usr/sbin.

[Guest Diana]

Hello Tyme,

 

Thank you for your reply.

 

I was looking for the mysqld but I did not find it in those directory.

 

I found mysqld in:

 

/etc/rc.d/init.d

 

/usr/libexec

 

/etc/logrotate.d

 

/var/run

 

------------------------------------------------------------------------------------------------------------

question1:

 

Which command I should give to look at the status or to start mysql?

 

------------------------------------------------------------------------------------------------------------

question2:

 

In which directory mysql, apache and php must be installed when you are doing it manually?

 

------------------------------------------------------------------------------------------------------------

 

 

I made a directory mysql

In this directory I put the below rpm files:

 

?€? mysql-3.23.58-4.i386.rpm

?€? mysql-server-3.23.58-4.i386.rpm

?€? mysql-devel-3.23.58-4.i386.rpm

?€? mysql-bench-3.23.58-4.i386.rpm

?€? mod_auth_mysql-20030510-3.i386.rpm

?€? php-mysql-4.3.3-6.i386.rpm

 

 

I installed them:

 

 

 

[root@toc mysql]# ls -l

total 8328

-rw-r--r-- 1 root root 13159 Oct 28 2003 mod_auth_mysql-20030510-3.i386.rpm

-rw-r--r-- 1 root root 5978569 Oct 28 2003 mysql-3.23.58-4.i386.rpm

-rw-r--r-- 1 root root 540407 Oct 28 2003 mysql-bench-3.23.58-4.i386.rpm

-rw-r--r-- 1 root root 588374 Oct 28 2003 mysql-devel-3.23.58-4.i386.rpm

-rw-r--r-- 1 root root 1344624 Oct 28 2003 mysql-server-3.23.58-4.i386.rpm

-rw-r--r-- 1 root root 28354 Oct 28 2003 php-mysql-4.3.3-6.i386.rpm

[root@toc mysql]# rpm -ivh mysql-3.23.58-4.i386.rpm

warning: mysql-3.23.58-4.i386.rpm: V3 DSA signature: NOKEY, key ID 4f2a6fd2

Preparing... ########################################### [100%]

1:mysql ########################################### [100%]

[root@toc mysql]# rpm -ivh mysql-server-3.23.58-4.i386.rpm

warning: mysql-server-3.23.58-4.i386.rpm: V3 DSA signature: NOKEY, key ID 4f2a6fd2

Preparing... ########################################### [100%]

1:mysql-server ########################################### [100%]

[root@toc mysql]# rpm -ivh mysql-devel-3.23.58-4.i386.rpm

warning: mysql-devel-3.23.58-4.i386.rpm: V3 DSA signature: NOKEY, key ID 4f2a6fd2

Preparing... ########################################### [100%]

1:mysql-devel ########################################### [100%]

[root@toc mysql]# rpm -ivh mysql-bench-3.23.58-4.i386.rpm

warning: mysql-bench-3.23.58-4.i386.rpm: V3 DSA signature: NOKEY, key ID 4f2a6fd2

Preparing... ########################################### [100%]

1:mysql-bench ########################################### [100%]

[root@toc mysql]# rpm -ivh mod_auth_mysql-20030510-3.i386.rpm

warning: mod_auth_mysql-20030510-3.i386.rpm: V3 DSA signature: NOKEY, key ID 4f2a6fd2

Preparing... ########################################### [100%]

1:mod_auth_mysql ########################################### [100%]

[root@toc mysql]# rpm -ivh php-mysql-4.3.3-6.i386.rpm

warning: php-mysql-4.3.3-6.i386.rpm: V3 DSA signature: NOKEY, key ID 4f2a6fd2

error: Failed dependencies:

php = 4.3.3-6 is needed by php-mysql-4.3.3-6

 

 

------------------------------------------------------------------------------------------------------------

question3:

 

Can you tell met what the error below means?

 

warning: php-mysql-4.3.3-6.i386.rpm: V3 DSA signature: NOKEY, key ID 4f2a6fd2

error: Failed dependencies:

php = 4.3.3-6 is needed by php-mysql-4.3.3-6

 

 

Thank you in advanced

 

 

------------------------------------------------------------------------------------------------------------

[tyme]

the important part is this:

error: Failed dependencies:
php = 4.3.3-6 is needed by php-mysql-4.3.3-6

you need to grab an rpm for php 4.3.3-6, and install it, before installing php-mysql. if you installed this version of php with the source method you used for mysql, it will not be picked up by the rpm program. you would be better off installing it from an rpm.

[neddie]

Your last question is relatively easy:

error: Failed dependencies:

php = 4.3.3-6 is needed by php-mysql-4.3.3-6

That means that it failed to install php-mysql because that package says it requires php (version 4.3.3-6) and your system hasn't got that package installed. However you probably only need php-mysql if you actually want to use php. If you just want to use mysql then I guess you don't need the php bit.

 

Another question - where are these rpms from? Are they Mandriva rpms, or Fedora 6 rpms, or Fedora 1 rpms? And why are you installing an rpm for "mysql-3.23.58-4.i386.rpm" when I thought you wanted to compile mysql from source? Or did you make these rpms yourself?

[Guest Diana]

Your last question is relatively easy:

error: Failed dependencies:

php = 4.3.3-6 is needed by php-mysql-4.3.3-6

That means that it failed to install php-mysql because that package says it requires php (version 4.3.3-6) and your system hasn't got that package installed. However you probably only need php-mysql if you actually want to use php. If you just want to use mysql then I guess you don't need the php bit.

 

Another question - where are these rpms from? Are they Mandriva rpms, or Fedora 6 rpms, or Fedora 1 rpms? And why are you installing an rpm for "mysql-3.23.58-4.i386.rpm" when I thought you wanted to compile mysql from source? Or did you make these rpms yourself?

 

The rpms are from Fedora1.

Sorry, I must install the rpms.

 

Thank you all