LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 05-12-2003, 04:31 PM   #1
Csneeky
LQ Newbie
 
Registered: May 2003
Posts: 4

Rep: Reputation: 0
status of MySQL on slack 8.1


I am new to MySQL and I noticed that when you install everything on the slackware 8.1 disk you get some files that have to do with MySQL. Auusing that I have not touched anything and it is a fresh installation of clask 8.1, is MySQL installed? Or are those files there waiting for me to install them? Or (as is usually the answer) is it a 3rd reason? Thanks.
 
Old 05-12-2003, 05:18 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Well ... the first place in Slack to check
whether something has actually been installed
during the initial installation or not is

/var/log/packages

The next statements assume that mysqls
packet name is all lowercase ;}

If ls -l /var/log/packages/mysql* spits
out a result it's been installed ...

As for how to set it up... I wouldn't have a clue
since I use postgreSQL... but to find mysqls
files if it has been installed, just do a
less /var/log/packages/mysql<tab>

Cheers,
Tink

P.S.: You should keep your threads together, btw...
I think I replied to another one of your mysql
threads.... :tsk::tsk::tsk:
 
Old 05-12-2003, 07:33 PM   #3
Alan Hicks
LQ Newbie
 
Registered: Jun 2002
Location: Lizella Georgia
Distribution: Slackware
Posts: 7

Rep: Reputation: 0
A little google searching never hurt anybody. In the future, give it a shot before asking around. You'll be surprised at what you can find.

Now, since this is a hard to find thing, I did the legwork for you.

Pat's own way of starting mysql for the first time.

In general, it's a great idea to search alt.os.linux.slackware at groups.google.com for answers to your questions.
 
Old 05-12-2003, 07:52 PM   #4
chemzar
LQ Newbie
 
Registered: May 2003
Location: Storrs, CT
Distribution: Slackware 9.0
Posts: 13

Rep: Reputation: 0
The documentation provided my MySQL is excellent. And I believe that MySQL is fully installed on slack 8.1. If not you can download it off of http://www.mysql.com. They are up to version 4.0.12 and I just did a source compile today and it wasn't bad at all. The install section in the documentation for mysql is superb (http://www.mysql.com/documentation/m...ter/index.html).

Your best bet is to look there and find out what MySQL can offer you. If you have PHP installed on a webserver try using phpMyAdmin 2.5 to configure and add stuff to the database via the web. It is really nice and easy to use and set up. You can find it here : http://www.phpmyadmin.net/

Any questions reply back, I'll keep checking for the next couple of days while I'm "studying" for final exams.
 
Old 05-20-2003, 03:56 AM   #5
johnvoisey
Member
 
Registered: Jun 2002
Location: UK
Distribution: Used many over the years, main ones now "CentOS", Slackware and Arch
Posts: 31

Rep: Reputation: 15
Slackware 9.0.0's not so good though !

Downloaded the iso for Slackware 9. Ran through the setup, told it to install mysql amongst others. Before I go any further, the file /etc/slackware-version proclaims it's Slackware 9.0.0

In /var/log/packages I see a listing for mysql-3.23.56-i386-1 and from this I see tjhe slackware installation has put stuff in /usr/bin,
some sample cnf's in /etc, the manual in /usr/doc..., headers in /usr/include, libraries in /usr/lib..., manuals in /usr/man and a load of stuff on character sets in /usr/share ...

I did a few checks and sure enough the files are where the logfile says they are.

However I don't have an rc.mysql or anything like it nor do I seem to have a /usr/anything/mysql directory tree to change the permissions on recursively ;-(

I have tried running the mysql_install_db and safe_mysqld from where the slackware setup put it, but all I get is an immediate halt and an error in /var/lib/mysql/<hostmachine>.err telling me something like

mysqld started
/usr/libexec/mysqld can't find file ./mysql/host.frm error 13
mysqld ended


I have read the manual on the mysql site and from the directory installed on my machine by the slackware setup script. I am having problems understanding the relationship (if any !!!) between the processes that have already been carried out by the slackware setup and the commands in the mysql manual which clearly refer to installing a binary disto from a tarball.

I am beginning to wonder if the best thing would be to invoke pkgtool to remove the mysql "installation" that slackware has dome and start again by downloading the tarball from the mysql site and following their instructions......
 
Old 05-22-2003, 11:34 PM   #6
Stoked
LQ Newbie
 
Registered: May 2003
Posts: 1

Rep: Reputation: 0
I just installed Slack 9.0 and installed the mysql-3.23.56-i386-1 package.

johnvoisey I got the same error as you. You are close but not quite there. The trick is to do a 'chmod -R mysql.mysql /var/lib/mysql'

As far as an rc.mysql, I did this:
Create the file with one line in it:
/usr/bin/safe_mysqld &

Then I edited rc.M and added:
if [ -x /etc/rc.d/rc.mysqld ]; then
. /etc/rc.d/rc.mysqld
fi
 
Old 05-23-2003, 03:28 AM   #7
johnvoisey
Member
 
Registered: Jun 2002
Location: UK
Distribution: Used many over the years, main ones now "CentOS", Slackware and Arch
Posts: 31

Rep: Reputation: 15
Thanks for the help.

A little while after I posted the question, I went off to play with the "official" mysql tarball on another slackware partition I keep on my system for experiments like that !

I followed mysql's online installation instructions to the letter and although it seemed to spray files everywhere, safe_mysqld worked and I had a working mysql database.

I was just about to destroy the slackware 'pkgtool' installation on my 'main' partition and install the "official" tarball (and thereby kiss goodbye to all hope of ever being aboe to do a controlled uninstall) when I saw your post.

I think you meant 'chown' not 'chmod' but yes I all I had to do was change the ownership of that directory tree and presto the safe_mysqld script worked.

As for an rc.mysql file, my experiments with the 'official' tarball were far from wasted. It includes a mysql daemon start/stop script for use in redhat-style /etc/rc... systems. I copied that to /etc/rc.d as rc.mysql, and then I grepped around to see how the system started and stopped the apache webserver. I found that rc.0 and rc.M as installed included checks for existence of an /etc/rd.d/rc.httpd script which is then invoked with stop /start and I just copied that example to start and stop mysql.

Yippee ! And thanks again for pointing me in the right direction.
 
  


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 in Slack 10 Philter Slackware 3 12-31-2004 08:15 AM
Starting mysql in slack 10 kmoffat Slackware 1 07-11-2004 04:07 AM
mysql logs on a slack dominant Slackware 6 06-21-2004 02:02 AM
slack 9 mysql no worky Finlay Slackware 2 08-16-2003 10:22 AM
mysql N slack 9 huno Slackware 1 04-26-2003 11:16 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 06:24 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