Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )



Advanced DNS Management
New ZoneEdit. New Managment.

FREE DNS Is Back

Sign Up Now
 
Reply to this topicStart new topic
> Removing Mysql
squirellplayingt...
post Jul 9 2004, 11:54 PM
Post #1


Whats this Lie-nix Thing?
*

Group: Members
Posts: 17
Joined: 22-May 04
Member No.: 3,008



I was following a lamps tutorial when I ran into some trouble. So my solution was to remove mysql and start over. I guess I didn't do it right. I did apt-get remove mysql-server and also removed some mysql directories in the /usr/local directory and the /usr/local/src/mysql-4.0.20 folder using the rm command. I downloaded 3.23.41 which is the one in the tutorial and now it says there already is a mysqld process running. I also did killall -9 mysqld, but still no change. I did not use an rpm to install it. How do I completely get rid of mysql so I can start over?
Go to the top of the page
 
+Quote Post
hughesjr
post Jul 10 2004, 03:25 PM
Post #2


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



the first thing you can do is find the process and kill it. Use the command:

ps -ef | grep -i mysql

That should give you the processes you need to kill.
----------------
You removed the SOURCE directory for mysql (where the code is built from)... but not the installed directories for mysql (where the code went).

What version were you building?

If you did a default install, most versions of mysql go into /usr/local/mysql ... but you could have specified a different location.
---------------


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
squirellplayingt...
post Jul 10 2004, 08:32 PM
Post #3


Whats this Lie-nix Thing?
*

Group: Members
Posts: 17
Joined: 22-May 04
Member No.: 3,008



After ps -ef | grep -i mysql I got:
root 1926 220 0 21:20 tty1 00:00:00 grep -i mysql

I was building from 4.0 when the problem occured.
I already deleted the /usr/local/mysql location.
Go to the top of the page
 
+Quote Post
hughesjr
post Jul 11 2004, 07:03 AM
Post #4


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



Then it seems mysql is gone and not running ... depending on the start script ... it may have put a lock file somewhere ... that contains the process ID.

Where that file might be is based on the way you started mysql ... try looking in /var/lock/subsystem/ (or just /var/lock) for something named mysqld or mysql

------------------
We have a LAMP install thread on debian HERE.
-----------------
If you are starting a server from scratch ... I would recommend that you do the LAMP server using a RedHat Enterprise Linux 3 Advanced Server clone like WhiteBox EL, CentOS, or TaoLinux.

Enterprise Linux has a long release cycle (18-24 months compared to 6 months for a normal distro). There are regular updates and Binary ISOs just like RedHat 9 / Fedora Core to do the installs.

I think CentOS is the best OS right now ... they have better faster update releases and they have more mirrors for the ISO downloads. You can get the ISOs from the closest mirror to you. (Pick a mirror ... then go to centos-3/3.1/isos/ ... then download either the DVD (if you can write DVDs) or CentOS-3.1-i386.disc1.iso, CentOS-3.1-i386.disc2.iso, CentOS-3.1-i386.disc3.iso. Burn the ISOs to CD.

Here is a howto I wrote on a minimal install for WhiteBox/CentOS/TaoLinux. You can certainly install more packages than that ... it is just for a NON-GUI minimal install to base other installs from.

Another howto to setup a LAMP server on those distros.


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
squirellplayingt...
post Jul 11 2004, 12:54 PM
Post #5


Whats this Lie-nix Thing?
*

Group: Members
Posts: 17
Joined: 22-May 04
Member No.: 3,008



There was nothing in the /var/lock or /var/lock/subsystem.

After snooping around the system some more I found a directory call /home/jag3k/webmin-1.150 which had a mysql directory. In this directory there were configuration files and a whole bunch of stuff. I'll ask the guy who helped me to set it up what this is.

Thanks for the links and the help.
Go to the top of the page
 
+Quote Post
dlab
post Jul 12 2004, 04:22 PM
Post #6


Grub-er
**

Group: Members
Posts: 30
Joined: 16-June 04
From: California, USA
Member No.: 3,175



Webmin is a web-based administration proggy. If it is running, open up a browser at localhost:10000 and you should see a nice little webmin login screen.


--------------------
The computer is the ultimate polluter, its s__t is indistinguishable from the food it produces.
user posted image--Found somewhere in the Fortune game.
Go to the top of the page
 
+Quote Post
squirellplayingt...
post Jul 13 2004, 12:48 PM
Post #7


Whats this Lie-nix Thing?
*

Group: Members
Posts: 17
Joined: 22-May 04
Member No.: 3,008



That looks neat, unfortunatly the guy who set it up doesn't remember the user name or password so I have to reinstall it. LoL. I hope I do it right. He also doesn't remember if he installed mysql so he told me to do apt-get install mysql. Then it said
QUOTE
Package mysql has no available version, but exists in the database. This typically means that the package was mentioned in a dependency and never uploaded, has been obsoleted or is not available with teh contents of sources.list
E:Package mysql has no installation candidate


Oy va.

EDIT: Got webmin working. Still having trouble with mysql sad.gif.
Go to the top of the page
 
+Quote Post
Robert83
post Jul 13 2004, 02:39 PM
Post #8


Its GNU/Linuxhelp.net
*******

Group: Support Specialist
Posts: 1,439
Joined: 3-January 04
From: Germany
Member No.: 2,069



If I remember it correctly

you need

apt-get install mysql-server


Sincerely
Robert B


--------------------
Robert Becskei
robert83@linuxhelp.net
--------------------
May the source be with us!
--------------------
AMD X2-3800 @ 2400Mhz
2048MB DDR 400Mhz
DFI Lanparty UT4 NF4 ULTRA-D
GeForce 7800GT
250GB+250GB
Pioneer DVD-RW
17inch Samsung Syncmaster 757NF
WinXP Pro (SP2)/ CentOS 4.3
--------------------
Go to the top of the page
 
+Quote Post
squirellplayingt...
post Jul 13 2004, 05:54 PM
Post #9


Whats this Lie-nix Thing?
*

Group: Members
Posts: 17
Joined: 22-May 04
Member No.: 3,008



I did that and got errors. I could not recreate it with webmin, but I got basically the same errors with apt-get install update.
QUOTE
Err http://ftp.us.debian.org stable/main Packages
  Something wicked happened resolving 'ftp.us.debian.org:http' (-3)
Err http://ftp.us.debian.org stable/main Release
  Something wicked happened resolving 'ftp.us.debian.org:http' (-3)
Err http://ftp.us.debian.org stable/main Sources
  Something wicked happened resolving 'ftp.us.debian.org:http' (-3)
Err http://ftp.us.debian.org stable/main Release
  Something wicked happened resolving 'ftp.us.debian.org:http' (-3)
Err http://non-us.debian.org stable/non-US/main Packages
  Something wicked happened resolving 'non-us.debian.org:http' (-3)
Err http://non-us.debian.org stable/non-US/main Release
  Something wicked happened resolving 'non-us.debian.org:http' (-3)
Err http://non-us.debian.org stable/non-US/main Sources
  Something wicked happened resolving 'non-us.debian.org:http' (-3)
Err http://non-us.debian.org stable/non-US/main Release
  Something wicked happened resolving 'non-us.debian.org:http' (-3)
Err http://security.debian.org stable/updates/main Packages
  Something wicked happened resolving 'security.debian.org:http' (-3)
Err http://security.debian.org stable/updates/main Release
  Something wicked happened resolving 'security.debian.org:http' (-3)
Failed to fetch http://ftp.us.debian.org/debian/dists/stab...y-i386/Packages  Something wicked happened resolving 'ftp.us.debian.org:http' (-3)
Failed to fetch http://ftp.us.debian.org/debian/dists/stab...ry-i386/Release  Something wicked happened resolving 'ftp.us.debian.org:http' (-3)
Failed to fetch http://ftp.us.debian.org/debian/dists/stab.../source/Sources  Something wicked happened resolving 'ftp.us.debian.org:http' (-3)
Failed to fetch http://ftp.us.debian.org/debian/dists/stab.../source/Release  Something wicked happened resolving 'ftp.us.debian.org:http' (-3)
Failed to fetch http://non-us.debian.org/debian-non-US/dis...y-i386/Packages  Something wicked happened resolving 'non-us.debian.org:http' (-3)
Failed to fetch http://non-us.debian.org/debian-non-US/dis...ry-i386/Release  Something wicked happened resolving 'non-us.debian.org:http' (-3)
Failed to fetch http://non-us.debian.org/debian-non-US/dis.../source/Sources  Something wicked happened resolving 'non-us.debian.org:http' (-3)
Failed to fetch http://non-us.debian.org/debian-non-US/dis.../source/Release  Something wicked happened resolving 'non-us.debian.org:http' (-3)
Failed to fetch http://security.debian.org/dists/stable/up...y-i386/Packages  Something wicked happened resolving 'security.debian.org:http' (-3)
Failed to fetch http://security.debian.org/dists/stable/up...ry-i386/Release  Something wicked happened resolving 'security.debian.org:http' (-3)
E:Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?


The E: is from the apt-get install mysql-server. The rest is from running apt-get update. The only difference is the website address. I also tried installing php4 but got the same errors! Is it something wrong in the apt list files?
sad.gif
Go to the top of the page
 
+Quote Post
hughesjr
post Jul 13 2004, 10:38 PM
Post #10


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



Looks like the sources.list file in /etc/apt/ is not formated correctly...this is on debian right?


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
squirellplayingt...
post Jul 14 2004, 12:01 AM
Post #11


Whats this Lie-nix Thing?
*

Group: Members
Posts: 17
Joined: 22-May 04
Member No.: 3,008



Yes it is. Debian 3.0 (woody).

I read a help file on apt-get and compared thier example sources.list file to mine.
CODE
We usually find the following in the default Debian sources.list:

    # See sources.list(5) for more information, especialy
    # Remember that you can only use http, ftp or file URIs
    # CDROMs are managed through the apt-cdrom tool.
    deb http://http.us.debian.org/debian stable main contrib non-free
    deb http://non-us.debian.org/debian-non-US stable/non-US main contrib non-free
    deb http://security.debian.org stable/updates main contrib non-free
   
    # Uncomment if you want the apt-get source function to work
    #deb-src http://http.us.debian.org/debian stable main contrib non-free
    #deb-src http://non-us.debian.org/debian-non-US stable/non-US main contrib non-free

That is what they said so I copies the top 2. Well I got even more errors. So I took them out.

Here is what my sources.list looks like.
CODE
#deb http://ftp.us.debian.org/debian/ stable main  
#deb-src http://ftp.us.debian.org/debian/ stable main  
#deb http://non-us.debian.org/debian-non-US stable/non-US main
#deb-src http://non-us.debian.org/debian-non-US stable/non-US main

deb http://security.debian.org/ stable/updates main

deb http://ftp.us.debian.org/debian/ stable main  
deb-src http://ftp.us.debian.org/debian/ stable main  
deb http://non-us.debian.org/debian-non-US stable/non-US main
deb-src http://non-us.debian.org/debian-non-US stable/non-US main
Go to the top of the page
 
+Quote Post
hughesjr
post Jul 14 2004, 07:19 AM
Post #12


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



That sources.list looks good ....

Your error discusses an inability in resolving names.

Are you sure that the network card is working and that this box can resolve internet names?

Use the command:

nslookup www.yahoo.com

and / or

dig www.yahoo.com

Do you get any results?


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
squirellplayingt...
post Jul 14 2004, 11:36 AM
Post #13


Whats this Lie-nix Thing?
*

Group: Members
Posts: 17
Joined: 22-May 04
Member No.: 3,008



I got errors.
CODE
> nslookup www.yahoo.com
sh: nslookup: command not found
> dig www.yahoo.com
sh: dig: command not found


I know the ping command works. But it doesn't ping. It was pinging saturday! And now it's not.
CODE
> ping www.yahoo.com
ping: unknown host www.yahoo.com

But I can recieve connections.

EDIT: After a nice rebooting of the system all is well and apt-get install mysql-server looks to be going ok.


Thanks for the help. This forums is very helpful to a linux noobie! And your nice about it.
Go to the top of the page
 
+Quote Post
Robert83
post Jul 14 2004, 11:58 AM
Post #14


Its GNU/Linuxhelp.net
*******

Group: Support Specialist
Posts: 1,439
Joined: 3-January 04
From: Germany
Member No.: 2,069



Hi

/etc/resolv.conf

you must put a nameserver into your /etc/resolv.conf file

use your ISP DNS server


Sincerely
Robert B


--------------------
Robert Becskei
robert83@linuxhelp.net
--------------------
May the source be with us!
--------------------
AMD X2-3800 @ 2400Mhz
2048MB DDR 400Mhz
DFI Lanparty UT4 NF4 ULTRA-D
GeForce 7800GT
250GB+250GB
Pioneer DVD-RW
17inch Samsung Syncmaster 757NF
WinXP Pro (SP2)/ CentOS 4.3
--------------------
Go to the top of the page
 
+Quote Post
squirellplayingt...
post Jul 15 2004, 02:21 PM
Post #15


Whats this Lie-nix Thing?
*

Group: Members
Posts: 17
Joined: 22-May 04
Member No.: 3,008



Ugg. Everything went ok with the apt-get install php4 and mysql-server but php isn't working with apache! I changed the doc_root of the php.ini to my public_html folder. But I just see the source of my test page. http://troop1910.homelinux.com:1910/test.php.
Quote from website.
QUOTE
And using vi create a file called test.php;
#vi test.php
Add the following line to the file;
<?php phpinfo(); ?>


I've searched google for php configuration with apache but all that I find is lamp tutorials that use the tar.gz unzip them and use the make install command and so forth. This also leads me to wonder if I have mysql set up correctly. I won't be using it for a while so I don't know how to test that, but I think the phpinfo() would give me that.
Go to the top of the page
 
+Quote Post
hughesjr
post Jul 15 2004, 04:49 PM
Post #16


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



install the packages php4-mysql, php4-cgi.


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
squirellplayingt...
post Jul 15 2004, 05:04 PM
Post #17


Whats this Lie-nix Thing?
*

Group: Members
Posts: 17
Joined: 22-May 04
Member No.: 3,008



No change. I also added extension = mysql to the php.ini like it told me to.
Go to the top of the page
 
+Quote Post
squirellplayingt...
post Jul 15 2004, 10:48 PM
Post #18


Whats this Lie-nix Thing?
*

Group: Members
Posts: 17
Joined: 22-May 04
Member No.: 3,008



Ok. I was talking to a friend and he had me do apt-get remove --purge all the php stuff and then install from a tar.gz. I did ./configure --enable-sockets --enable-ftp --with-apxs=/usr/local/apache/bin/apxs. This still hasn't fix the problem.
Go to the top of the page
 
+Quote Post
hughesjr
post Jul 17 2004, 06:42 AM
Post #19


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



Since you are installing on Debian ... take a look at my help in this thread ... I just redid this again with sarge and it worked.


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 14th December 2017 - 11:30 PM