LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
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 04-11-2009, 02:02 AM   #1
Allanitto Newbee
Member
 
Registered: Oct 2007
Location: Montreal
Distribution: Slackware12;Slackware13
Posts: 106

Rep: Reputation: 15
Installing mysql in Slackware 12


I downloaded different version of Mysql from their site but unable to complete the installation. from 4.0 to 5.1 seem to have missing file. I downloaded non-rpm file but not sure exactly which one is right for my slackware. every time I try to do "make" it says "make: *** No targets specified and no makefile found. Stop."

Please help I don't know what to do.
 
Old 04-11-2009, 04:04 AM   #2
Karu
Member
 
Registered: Jul 2007
Location: Estonia
Distribution: Slackware
Posts: 53

Rep: Reputation: 16
Quote:
Please help I don't know what to do.
Maybe you can use mysql that is part of slackware
12.2 has:

Code:
% ls /var/log/packages|g mysql
mysql-5.0.67-i486-1
 
Old 04-11-2009, 06:17 AM   #3
Eternal_Newbie
Member
 
Registered: Jun 2005
Location: The Pudding Isles
Distribution: Slackware
Posts: 573

Rep: Reputation: 59
Slackware 12.0 has MySQL 5.0.51 in /patches/packages. If you want to use a more recent version, I would suggest downloading the the contents of /patches/source/mysql from a Slackware mirror, and using the slackbuild to compile the source of the version you want. Remember to change the version number in the slackbuild, and anywhere else it need changing.

Slackbuilds.org has instructions on using slackbuilds.

Last edited by Eternal_Newbie; 04-11-2009 at 06:18 AM.
 
Old 04-11-2009, 10:47 AM   #4
Allanitto Newbee
Member
 
Registered: Oct 2007
Location: Montreal
Distribution: Slackware12;Slackware13
Posts: 106

Original Poster
Rep: Reputation: 15
Okay I found one in /var/log/packages and it's mysql-5.0.37-i486-1. What should I do next? is it only a log of all the packages included in my distro? I tried to locate the package itself but I couldn't find it. I'm trying to make a lamp in my slackware. apache and php went well during installation except php complains "re-install mysql distribution" I knew I'm gonna have that problem coz mysql installation didn't went through.


thanks for all the help.
 
Old 04-11-2009, 11:27 AM   #5
Eternal_Newbie
Member
 
Registered: Jun 2005
Location: The Pudding Isles
Distribution: Slackware
Posts: 573

Rep: Reputation: 59
If its in /var/log/packages it is installed.

You probably need to copy one of the example config files to /etc/my.cnf (my-medium.cnf is probably adequate for now), start mysql, initialise the database and set the root MySQL password. Unfortunately that is as far as my MySQL knowledge stretches.

http://dev.mysql.com/doc/refman/5.0/...tallation.html will be of help.

Last edited by Eternal_Newbie; 04-11-2009 at 11:55 AM. Reason: removed possibly confusing 2nd link.
 
Old 04-11-2009, 11:37 AM   #6
vitalstrike82
Member
 
Registered: Oct 2007
Location: Singapore
Distribution: OpenSuse, Slackware, Redhat
Posts: 318

Rep: Reputation: 40
Hi,

which type of file have you download from mysql? i download version 5.1,the source download for installation and managed to install successfully.

You can download from here: http://dev.mysql.com/downloads/mysql/5.1.html

Then scroll down to the very bottom and download the Compressed GNU TAR archive (tar.gz) type.

To install:

1)tar -zxvf <name of the mysql file>
2) cd into the folder
Next type the commands below to set the configure file
Code:
./configure –prefix=/usr/local/mysql –localstatedir=/usr/local/mysql/data –disable-maintainer-mode –with-mysql-user=mysql –enable-large-files-without-debug
Type this command to make the make file
Code:
make
Next, proceed to install
Code:
make install
You may also need the require libraries to install mysql. I dun remember them but you can find the libraries in http://slackbuilds.org/

Last edited by vitalstrike82; 04-11-2009 at 11:39 AM.
 
1 members found this post helpful.
Old 04-11-2009, 12:50 PM   #7
BCarey
Senior Member
 
Registered: Oct 2005
Location: New Mexico
Distribution: Slackware
Posts: 1,639

Rep: Reputation: Disabled
A full installation of Slackware includes apache, php and mysql. So if you install Slackware you already have lamp. If you install your own versions, you will have trouble. If for some reason you need a newer version of one of these components, then you should use the SlackBuild from the /source tree to compile.

So if you just re-install the Slackware packages you should be all set.

/var/log/packages is a record of Slackware packages installed on your system. Each file in the directory is named for the package/version installed, and contains a list of all of the files installed by the package. So if you want to know where something is installed, you can just look in the file for the package. Software installed using configure/make/make install will not show up here.

Brian
 
Old 04-11-2009, 05:51 PM   #8
Allanitto Newbee
Member
 
Registered: Oct 2007
Location: Montreal
Distribution: Slackware12;Slackware13
Posts: 106

Original Poster
Rep: Reputation: 15
I'm starting to understand it. I want to install a fresh copy of SLAMP so I would like to uninstall all that I have in my slackware right now. I want to learn from a to z that's why I want it the hard way. 1.)As BCarey said it's already installed so I want to uninstall it. 2.)VitalStrike82 has the link and I believe it's the right version I need(the compressed one right at the bottom) so I'm going to grab it.

I even want to uninstall APACHE and PHP that I just installed last night just to make it exact the way I want it.

Very important thing I need to know now is how am I going to cleanly uninstall what I had just installed last night as well as the packages that I have included installing during initial setup of my slackware 12.

My success is all in your hands guys

 
Old 04-11-2009, 06:29 PM   #9
bgeddy
Senior Member
 
Registered: Sep 2006
Location: Liverpool - England
Distribution: slackware64 13.37 and -current, Dragonfly BSD
Posts: 1,810

Rep: Reputation: 232Reputation: 232Reputation: 232
Quote:
Very important thing I need to know now is how am I going to cleanly uninstall what I had just installed last night as well as the packages that I have included installing during initial setup of my slackware 12.
I'm not quite sure what you have installed/done but the standard Slkackware packages may be removed with :
Code:
su -c "removepkg {php,mysql,httpd}"
Although I'm not sure why you'd want to do this.
 
Old 04-11-2009, 09:40 PM   #10
Allanitto Newbee
Member
 
Registered: Oct 2007
Location: Montreal
Distribution: Slackware12;Slackware13
Posts: 106

Original Poster
Rep: Reputation: 15
I only to remove php, mysql and apache so I can re-install a fresh copy of them.

I'll let you guys know....
 
Old 04-11-2009, 10:16 PM   #11
Allanitto Newbee
Member
 
Registered: Oct 2007
Location: Montreal
Distribution: Slackware12;Slackware13
Posts: 106

Original Poster
Rep: Reputation: 15
update 11:10pm 4/11/09

successfully installed mysql 5.1 though had a warning "unrecognized option: --without-bench"
I guess nothing important I'll deal with it later.

next installation: Apache 2
 
Old 04-11-2009, 10:41 PM   #12
Allanitto Newbee
Member
 
Registered: Oct 2007
Location: Montreal
Distribution: Slackware12;Slackware13
Posts: 106

Original Poster
Rep: Reputation: 15
oppsss!!!! my bad I had an error saying
/usr/lib/gcc/i486-slackware-linux/4.1.2/../../../../i486-slackware-linux/bin/ld: cannot find -lgcc_s
collect2: ld returned 1 exit status
make[3]: *** [mysqld] Error 1
make[3]: Leaving directory `/freshdown/mysql-5.1.33/sql'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/freshdown/mysql-5.1.33/sql'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/freshdown/mysql-5.1.33/sql'
make: *** [all-recursive] Error 1

Anybody?
should I proceed doing make install anyways??

thanks
 
Old 04-12-2009, 04:18 AM   #13
vitalstrike82
Member
 
Registered: Oct 2007
Location: Singapore
Distribution: OpenSuse, Slackware, Redhat
Posts: 318

Rep: Reputation: 40
Quote:
Originally Posted by Allanitto Newbee View Post
oppsss!!!! my bad I had an error saying
/usr/lib/gcc/i486-slackware-linux/4.1.2/../../../../i486-slackware-linux/bin/ld: cannot find -lgcc_s
From that error prompt out, i think it cant find this library libgcc_s.so

You can take a look at this link as it shows how to find the libraries in your system: http://www.linuxquestions.org/questi...-linux-681026/

and btw, in your previous post, you mention you have successfully install the mysql. So actually u manage to install the mysql from the tarball succssfully or using the slack mysql?
 
Old 04-12-2009, 04:29 AM   #14
vitalstrike82
Member
 
Registered: Oct 2007
Location: Singapore
Distribution: OpenSuse, Slackware, Redhat
Posts: 318

Rep: Reputation: 40
Hi,
i have google for you and find that you also need to have gcc install. Installing gcc will install the libraries as well.

If the system have the library but no gcc is install, it will not find the library too. can be view from this link: http://linux.derkeiler.com/Newsgroup...5-10/1966.html
 
Old 04-12-2009, 09:50 AM   #15
Allanitto Newbee
Member
 
Registered: Oct 2007
Location: Montreal
Distribution: Slackware12;Slackware13
Posts: 106

Original Poster
Rep: Reputation: 15
It's from the tarball but I thought I did already. It was only up to ./configure I've done and I thought I passed the major problem already so I post It was successful but it wasn't.

there were two sets of ./configure I threw in.

First is this one which COMPLAINT about the: "cannot find -lgcc_s" during "make" command.

./configure --prefix=/usr/local/mysql --localstatedir=/home/mysql --enable-assembler --enable-thread-safe-client --with-unix-socket-path=/var/run/mysql/mysql.pid --with-mysqld-user=mysql --with-extra-charsets=none --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --without-debug --without-bench --without-docs

This is the second one which brings me up to ./scripts/mysql_install_db, that means the "make" and "makefile" were successful but when I threw this "chown -R mysql:mysql /usr/local/mysql/data" it says "data" not found or something like that.

Here it is.

./configure
--prefix=/usr/local/mysql
--localstatedir=/usr/local/mysql/data
--disable/maintainer-mode
--with-mysqld-user=mysql
--with-unix-socket-path=/tmp/mysql.sock
--without-comment
--without-debug
--without-bench

There's a note from where I took this instruction saying
"if you get an error message about the data directory not existing, etc., something went wrong in the mysql_install_db step above. Go back and review that; make sure you didn't get some sort of error message when you ran it, etc.

This is what I get actually

WARNING: The host 'ALIEN_SLACK_12' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
090412 10:48:53 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--skip-federated'
090412 10:48:53 [ERROR] Aborting

090412 10:48:53 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete


Installation of system tables failed! Examine the logs in
/local/mysql/data for more information.

You can try to start the mysqld daemon with:

shell> /usr/local/mysql/libexec/mysqld --skip-grant &

and use the command line tool /usr/local/mysql/bin/mysql
to connect to the mysql database and look at the grant tables:

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

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /local/mysql/data 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 are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script!


Thanks for the time....
 
  


Reply



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
Having problems installing MySQL on red hat 9. Cannot find mysql.sock oferu Linux - Newbie 3 05-27-2008 07:13 PM
Installing mysql-5.0.51.tar.gz on Slackware properganda Slackware 11 01-18-2008 06:28 AM
Installing MySQL on Slackware properganda Linux - Newbie 5 01-16-2008 12:55 PM
Installing ruby with rails+mysql+apache on Slackware 10.2 from source paultoytoy Slackware 1 09-08-2006 12:01 PM
Error in installing MySQL on Slackware linux kernelvn Slackware 1 08-14-2004 06:46 AM

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

All times are GMT -5. The time now is 06:37 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
Open Source Consulting | Domain Registration