going crazy over mysql rpm distro on RH 8

bigswifty75 · 08-02-2003, 10:35 PM

This is driving me nuts.
usualy I can find the answer to these kinds of questions, but this whole mysql documentation fiasco is killin me.

I have mysql running on RH8 and all current updates are onboard.

mysql works like a dream, as long as a user is logged into the server (the RH8 box) the minute you log out the server stops accepting connections from remote users.
apache works fine and so does php, just not mysql

Now heres where the pain starts to grow,
lots of info exists on how to auto start and run the service right after boot, all the pages and documentation refer to the mysql.server file.

The problem is that the RPMs for RH8 stick the whole distribution in wildly different directory locations then the docs say, well no biggy I can do a search.. hey wait, no mysql.server on my box??? no mysql safe either?
all I can find is the mysqld file.
ok dont panic, download a binary from mysql and extract the mysql.server file, holy crap its not here either!

ok so what the heck is going on? Im not a stupid fellow by any means. where is the msql.server file?????

rch · 08-02-2003, 11:04 PM

rpm -qil mysql
gives the location of the files rpm of mysql saved
I hoped that you could continue from here!

bigswifty75 · 08-02-2003, 11:12 PM

well heres the results, so Im not crazy, there is no file named mysql.server in the rpm, why would they leave out this script essential to the autostart function? at least all the docs say its needed to autostart the service.

Name : mysql Relocations: (not relocateable)
Version : 3.23.56 Vendor: Red Hat, Inc.
Release : 1.80 Build Date: Mon 24 Mar 2003 10:28:29 AM EST
Install date: Sat 07 Jun 2003 07:40:25 PM EDT Build Host: daffy.perf.redhat.com
Group : Applications/Databases Source RPM: mysql-3.23.56-1.80.src.rpm
Size : 15050500 License: GPL/LGPL
Signature : DSA/SHA1, Tue 29 Apr 2003 01:02:24 PM EDT, Key ID 219180cddb42a60e
Packager : Red Hat, Inc. <http://bugzilla.redhat.com/bugzilla>
URL : http://www.mysql.com
Summary : MySQL client programs and shared library.
Description :
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. This package
contains the MySQL client programs, the client shared library, and
generic MySQL files.
/etc/my.cnf
/usr/bin/comp_err
/usr/bin/isamchk
/usr/bin/isamlog
/usr/bin/msql2mysql
/usr/bin/my_print_defaults
/usr/bin/myisamchk
/usr/bin/myisamlog
/usr/bin/myisampack
/usr/bin/mysql
/usr/bin/mysql_config
/usr/bin/mysql_convert_table_format
/usr/bin/mysql_find_rows

/usr/bin/mysql_fix_privilege_tables
/usr/bin/mysql_install_db
/usr/bin/mysql_setpermission
/usr/bin/mysql_zap
/usr/bin/mysqlaccess
/usr/bin/mysqlbinlog
/usr/bin/mysqlbug
/usr/bin/mysqlcheck
/usr/bin/mysqld_multi
/usr/bin/mysqldump
/usr/bin/mysqldumpslow
/usr/bin/mysqlhotcopy
/usr/bin/mysqlimport
/usr/bin/mysqlshow
/usr/bin/mysqltest
/usr/bin/pack_isam
/usr/bin/perror
/usr/bin/replace
/usr/bin/resolve_stack_dump
/usr/bin/resolveip
/usr/lib/mysql
/usr/lib/mysql/libmysqlclient.so.10
/usr/lib/mysql/libmysqlclient.so.10.0.0
/usr/lib/mysql/libmysqlclient_r.so.10
/usr/lib/mysql/libmysqlclient_r.so.10.0.0
/usr/share/doc/mysql-3.23.56
/usr/share/doc/mysql-3.23.56/COPYING
/usr/share/doc/mysql-3.23.56/COPYING.LIB
/usr/share/doc/mysql-3.23.56/INSTALL-SOURCE
/usr/share/doc/mysql-3.23.56/README
/usr/share/doc/mysql-3.23.56/manual.html
/usr/share/doc/mysql-3.23.56/manual.texi
/usr/share/doc/mysql-3.23.56/manual.txt
/usr/share/doc/mysql-3.23.56/manual_toc.html
/usr/share/doc/mysql-3.23.56/mysqld_error.txt
/usr/share/info/mysql.info.gz
/usr/share/man/man1/isamchk.1.gz
/usr/share/man/man1/isamlog.1.gz
/usr/share/man/man1/mysql.1.gz
/usr/share/man/man1/mysql_zap.1.gz
/usr/share/man/man1/mysqlaccess.1.gz
/usr/share/man/man1/mysqladmin.1.gz
/usr/share/man/man1/mysqld.1.gz
/usr/share/man/man1/mysqld_multi.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqlshow.1.gz
/usr/share/man/man1/perror.1.gz
/usr/share/man/man1/replace.1.gz
/usr/share/man/man1/safe_mysqld.1.gz
/usr/share/mysql
/usr/share/mysql/charsets
/usr/share/mysql/charsets/Index
/usr/share/mysql/charsets/README
/usr/share/mysql/charsets/cp1251.conf
/usr/share/mysql/charsets/cp1257.conf
/usr/share/mysql/charsets/croat.conf
/usr/share/mysql/charsets/danish.conf
/usr/share/mysql/charsets/dec8.conf
/usr/share/mysql/charsets/dos.conf
/usr/share/mysql/charsets/estonia.conf
/usr/share/mysql/charsets/german1.conf
/usr/share/mysql/charsets/greek.conf
/usr/share/mysql/charsets/hebrew.conf
/usr/share/mysql/charsets/hp8.conf
/usr/share/mysql/charsets/hungarian.conf
/usr/share/mysql/charsets/koi8_ru.conf
/usr/share/mysql/charsets/koi8_ukr.conf
/usr/share/mysql/charsets/latin1.conf
/usr/share/mysql/charsets/latin2.conf
/usr/share/mysql/charsets/latin5.conf
/usr/share/mysql/charsets/swe7.conf
/usr/share/mysql/charsets/usa7.conf
/usr/share/mysql/charsets/win1250.conf
/usr/share/mysql/charsets/win1251.conf
/usr/share/mysql/charsets/win1251ukr.conf
/usr/share/mysql/czech
/usr/share/mysql/czech/errmsg.sys
/usr/share/mysql/czech/errmsg.txt
/usr/share/mysql/danish
/usr/share/mysql/danish/errmsg.sys
/usr/share/mysql/danish/errmsg.txt
/usr/share/mysql/dutch
/usr/share/mysql/dutch/errmsg.sys
/usr/share/mysql/dutch/errmsg.txt
/usr/share/mysql/english
/usr/share/mysql/english/errmsg.sys
/usr/share/mysql/english/errmsg.txt
/usr/share/mysql/estonian
/usr/share/mysql/estonian/errmsg.sys
/usr/share/mysql/estonian/errmsg.txt
/usr/share/mysql/french
/usr/share/mysql/french/errmsg.sys
/usr/share/mysql/french/errmsg.txt
/usr/share/mysql/german
/usr/share/mysql/german/errmsg.sys
/usr/share/mysql/german/errmsg.txt
/usr/share/mysql/greek
/usr/share/mysql/greek/errmsg.sys
/usr/share/mysql/greek/errmsg.txt
/usr/share/mysql/hungarian
/usr/share/mysql/hungarian/errmsg.sys
/usr/share/mysql/hungarian/errmsg.txt
/usr/share/mysql/italian
/usr/share/mysql/italian/errmsg.sys
/usr/share/mysql/italian/errmsg.txt
/usr/share/mysql/japanese
/usr/share/mysql/japanese/errmsg.sys
/usr/share/mysql/japanese/errmsg.txt
/usr/share/mysql/korean
/usr/share/mysql/korean/errmsg.sys
/usr/share/mysql/korean/errmsg.txt
/usr/share/mysql/norwegian
/usr/share/mysql/norwegian-ny
/usr/share/mysql/norwegian-ny/errmsg.sys
/usr/share/mysql/norwegian-ny/errmsg.txt
/usr/share/mysql/norwegian/errmsg.sys
/usr/share/mysql/norwegian/errmsg.txt
/usr/share/mysql/polish
/usr/share/mysql/polish/errmsg.sys
/usr/share/mysql/polish/errmsg.txt
/usr/share/mysql/portuguese
/usr/share/mysql/portuguese/errmsg.sys
/usr/share/mysql/portuguese/errmsg.txt
/usr/share/mysql/romanian
/usr/share/mysql/romanian/errmsg.sys
/usr/share/mysql/romanian/errmsg.txt
/usr/share/mysql/russian
/usr/share/mysql/russian/errmsg.sys
/usr/share/mysql/russian/errmsg.txt
/usr/share/mysql/slovak
/usr/share/mysql/slovak/errmsg.sys
/usr/share/mysql/slovak/errmsg.txt
/usr/share/mysql/spanish
/usr/share/mysql/spanish/errmsg.sys
/usr/share/mysql/spanish/errmsg.txt
/usr/share/mysql/swedish
/usr/share/mysql/swedish/errmsg.sys
/usr/share/mysql/swedish/errmsg.txt
/usr/share/mysql/ukrainian
/usr/share/mysql/ukrainian/errmsg.sys
/usr/share/mysql/ukrainian/errmsg.txt