>Description: Attempted to follow instructions to install from source tarball as indicated in manual.pdf. I acquired manual.pdf from:
http://www.mysql.com/Documents/Manual/manual.pdf On Page 81 of manual.pdf I followed the 'To install a source distribution' Steps 1 through 6 went fine. However at step 7 that is where the install process halted. Step 1 - Pick directory to install distribution and move into it. # cd /usr/local Step 2 - Obtain a distribution file from one of the sites listed: Acquired 'mysql-max-3.23.55-pc-linux-i686.tar.gz' Step 3 - Berkeley DB tables disclaimer. Not interested at this time. Step 4 - Add a user and group for mysqld to run as: # <created user mysql with uid of 114 and group mysql with gid of 108> Step 5 - Unpack the distribution into current directory: # tar -zxvf /tmp/mysql-max-3.23.55-pc-linux-i686.tar.gz Step 6 - Change into the top-level directory of the unpacked distribution: # cd mysql-max-3.23.55-pc-linux-i686 Step 7 - Configure the release and compile everything: # ./configure --prefix=/usr/local/mysql This yielded: ========================================================================= NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables 030215 8:10:53 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h cvlxit2 password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version cvlxit2:/usr/local/mysql-max-3.23.55-pc-linux-i686# Starting mysqld daemon with databases from /usr/local/mysql-max-3.23.55-pc-linux-i686/data 030215 08:10:53 mysqld ended ========================================================================= Hmmm, well I acquired a source distribution and I ended up with a pre-compiled version. Oh well no matter, I guess I will continue on: So the output of 'configure' indicated to: ========================================================================= ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h cvlxit2 password 'new-password' ========================================================================= So I executed: ./bin/mysqladmin -u root password 'password' This yielded: ========================================================================= ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! ========================================================================= Hmmm, oh well lets continue on with the instructions from 'configure', so I executed: ./bin/mysqladmin -u root -h cvlxit2 password 'new-password' This yielded: ========================================================================= ./bin/mysqladmin: connect to server at 'cvlxit2' failed error: 'Can't connect to MySQL server on 'cvlxit2' (111)' Check that mysqld is running on cvlxit2 and that the port is 3306. You can check this by doing 'telnet cvlxit2 3306' ========================================================================= Hmmm, so mysqld is apparently not running, I confirmed this with the above example of telnet'ing to port 3306 and by executing 'ps -aef | grep -i mysql'. Well obviously something was seriously wrong, so I backed up in 'manual.pdf' to page 77 and started on the section '2.2.7 Installing a MySQL Binary Distribution'. On page 78 a detailed description of the steps required begins: Step 1 - Pick directory /usr/local Step 2 - Obtain distribution file from one of the sites Apparently I already have a distribution file. Step 3 - max suffix, Yes, then see Section 4.7.5 Section 4.7.5 indicates that mysqld-max is the MySQL server (mysqld) configured with the following options: -with-server-suffix=-max -with-innodb -with-bdb CFLAGS=-DUSE_SYMDIR Also indicates that the InnoDB table option can be enabled by editing the startup options. See Section 7.5.2 page 507. Section 7.5.2 indicates that I must specify the 'innodb_data_file_path' where I will specify the names and sizes of datafiles. Reading further, these parameters need to be set up before using the InnoDB options. Well I will do that, but first let me get the database server installed, & up and running. I wanted to find the executable with the 'max' extension so I executed the following: cd /usr/local/mysql find . | grep -i max Nothing found. Hmmm, well I downloaded the 'max' based binary, but no mysql-max installed??? Oh well, back to page 78 of 'manual.pdf' and setting up a MySQL from distribution binary. ------ Page 78 Step 4 - Add a user and group for mysqld to run as: Already done - uid 114, gid 108 Step 5 - Change to the intended installation directory: # cd /usr/local Step 6 - Unpack the distribution and create the installation directory: # tar -zxvf /tmp/mysql-max-3.23.55-pc-linux-i686.tar.gz # ln -s mysql-max-3.23.55-pc-linux-i686 mysql Step 7 - Change into the installation directory: # cd mysql Step 8 - How to change 'bin/mysqlaccess' to point to a non-standard place. I did not opt to change this to on to Step 9. Step 9 - Create the MySQL grant tables # scripts/mysql_install_db This yieldes: ========================================================================= Installing all prepared tables 030215 8:44:59 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h cvlxit2 password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com ========================================================================= Step 10 - Change ownerships of binaries to root and ownership of data directory to the user that you will run mysqld as: # chown -R root /usr/local/mysql/. # chown -R mysql /usr/local/mysql/data # chgrp -R mysql /usr/local/mysql/. Step 11 - Set up support for perl via the DBI/DBD interface. See section 2.7 [Perl support], page 139. Hmmm, about as clear as mud. Also referred me to section 8.2 [Perl] page 539. Looks like if I want to use Perl to interface with the mysqld daemon I need the DBD and DBI extension to perl. Since I was using Debian, I did a search for all Perl/Mysql .deb packages that related to DBI and DBD support. Installed all of them and continued on to Step 12. Step 12 - Setting up MySQL to start automatically at boot: Well, I'll get back to this. First off let me see if I can at least fire it up manually. Then the last part of Step 12 (the last step) indicates: ========================================================================= After everything has been unpacked and installed, you should initialise and test your distribution. You can start the MySQL server with the following command: shell> bin/safe_mysqld --user=mysql & Now proceed to Section 4.7.2 [safe_mysqld]. page 274, and See Section 2.4 [Post-installation], page 91. ========================================================================= Ok, one step at a time: # bin/safe_mysqld --user=mysql & This yeilded: ========================================================================= bin/safe_mysqld --user=mysql & [1] 5355 # Starting mysqld daemon with databases from /usr/local/mysql/data 030215 09:02:09 mysqld ended [1]+ Done bin/safe_mysqld --user=mysql ========================================================================= Hmmm, this looks familiar. So the mysqld still fails to start up. Well undaunted I thought I would check out section 4.7.2 and section 2.4 as indicated above. Section 4.7.2 makes mention of a log file where errors are recorded, however no indication of where possible helpful yet elusive log file might exist. This section goes on to describe how to add options to the 'my.cnf' file, and refers the read to Section 4.1.2 and Section 4.1.1 Well section 4.1.2 did not reveal the hiding place of the 'logfile' but it did describe the option '--debug[...]=' which referred me to yet another section 'Section E.1.2 [Making trace files], page 759.' This section indicated that to enable trace files the MySQL daemon had to be compiled with the '-debug' option. To check for this execute 'mysqld -V' and look for the version number that ends with -debug: # mysqld -V This yeilds ========================================================================= bin/mysqld Ver 3.23.55-max for pc-linux on i686 ========================================================================= No 'debug' here, so scratch the trace file idea. So then I thought I would look at section 2.4 [Post-installation], page 91 Section 2.4 has me re-execute steps 9 and 12 of the Binary distribution instructions again. Well I don't think this is going to help, but what the heck, I am trying to follow instructions. cd mysql_installation_directory # cd /usr/local/mysql The next step indicates the 'mysql_install_db' for a Binary distribution is located in the 'bin' directory. However the instructions on page 78 indicate the 'mysql_install_db' is located in the 'scripts' directory for a Binary distribution install. # ./bin/mysql_install_db There is no './bin/mysql_install_db' in the 'bin' directory for a Binary distribution install. So I re-executed the 'mysql_install_db' from the 'scripts' directory #./scripts/mysql_install_db Then executed: # ./bin/safe_mysqld --user=mysql & Same results as before. So then I searched for a logfile with: # cd /usr/local/mysql # find . | grep -i log Nothing!! So I am obviously just a tad frustrated with the install. Not sure what I did wrong or what part of the 833 page manual.pdf will help. If you could spare some time to help out a MySQL newbie, it would be greatly appreciated. Best Regards, John Griffin ========================================================================= ========================================================================= Submitter-Id: jpg Originator: jpg Organization: IT MySQL support: none Synopsis: Cannot install Severity: critical Priority: high Category:mysql Class: install Release: mysql-3.23.55-max (Official MySQL-max binary) Environment: System: Linux cvlxit2 2.4.21-pre3 #2 SMP Tue Jan 21 13:53:25 PST 2003 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Nov 10 06:12 /lib/libc.so.6 -> libc-2.2.5.so -rwxr-xr-x 1 root root 1153784 Sep 18 02:40 /lib/libc-2.2.5.so -rw-r--r-- 1 root root 2390970 Sep 18 02:41 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 18 02:41 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL-max binary' '--with-extra-charsets=complex' '--with-server-suffix=-max' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-berkeley-db' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc' --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php