From jhryu@u.washington.edu Mon Sep 17 11:48:23 2001 Received: from mxu102.u.washington.edu (mxu102.u.washington.edu [140.142.32.15]) by lists.u.washington.edu (8.11.2+UW01.01/8.11.2+UW01.04) with ESMTP id f8HImI0110954 for ; Mon, 17 Sep 2001 11:48:18 -0700 Received: from mxu2.u.washington.edu (mxu2.u.washington.edu [140.142.32.9]) by mxu102.u.washington.edu (8.11.6+UW01.08/8.11.6+UW01.08) with SMTP id f8HImIE04291 for ; Mon, 17 Sep 2001 11:48:18 -0700 Received: FROM mxout2.cac.washington.edu BY mxu2.u.washington.edu ; Mon Sep 17 11:48:17 2001 -0700 Received: from mailhost2.u.washington.edu (mailhost2.u.washington.edu [140.142.33.2]) by mxout2.cac.washington.edu (8.11.6+UW01.08/8.11.6+UW01.08) with ESMTP id f8HImGs21275 for ; Mon, 17 Sep 2001 11:48:16 -0700 Received: from water5 (D-128-95-220-154.dhcp.washington.edu [128.95.220.154]) by mailhost2.u.washington.edu (8.11.6+UW01.08/8.11.6+UW01.08) with SMTP id f8HImGo02246 for ; Mon, 17 Sep 2001 11:48:16 -0700 From: "JAY HYUN RYU" To: Subject: RE: mySQL on dante... Date: Mon, 17 Sep 2001 11:47:55 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Dear Trevor: Thank you for your advice. But, I still get stucked in first step you suggested. I mean, I couldn't find mysql daemon after ps command. Even though I reinstalled mysql on vergil, it doesn't work. I attached what I have been done, please look at where I am wrong. === 1. configuring on safe_mysqld file == #Default communication ports MYSQL_TCP_PORT=90210 if test -z "$MYSQL_UNIX_PORT" then MYSQL_UNIX_PORT="/nfs/guido03/da29/d90/jhryu/mysql.sock" export MYSQL_UNIX_PORT fi export MYSQL_TCP_PORT # Does this work on all systems? ================================================= === 2. This is ~/.my.cnf file ======= [mysqld] port=3316 socket=/nfs/guido03/da29/d90/jhryu/mysql.sock basedir=/nfs/guido03/da29/d90/jhryu/mysql datadir=/nfs/guido03/da29/d90/jhryu/mysql/data [client] port= socket=/nfs/guido03/da29/d90/jhryu/mysql.sock password= ================================================= === 3. this is an error message I got, it was in /mysql/data/vergil01.err file. vergil01% cat vergil01.err mysqld started on Mon Sep 17 11:14:37 PDT 2001 010917 11:14:38 Can't start server : Bind on unix socket: No such file or directory 010917 11:14:38 Do you already have another mysqld server running on socket: /mysql.sock ? 010917 11:14:38 Aborting mysqld ended on Mon Sep 17 11:14:38 PDT 2001 mysqld started on Mon Sep 17 11:19:34 PDT 2001 010917 11:19:34 Can't start server : Bind on unix socket: No such file or directory 010917 11:19:34 Do you already have another mysqld server running on socket: /mysql.sock ? 010917 11:19:34 Aborting mysqld ended on Mon Sep 17 11:19:34 PDT 2001 mysqld started on Mon Sep 17 11:24:01 PDT 2001 /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/bin/mysqld: Too many parameters /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/bin/mysqld Ver 3.22.32 for ibm-aix4.2.1.0 on powerpc Copyright (C) 1979-2000 TcX AB & Monty Program KB & Detron HB. All rights reserved. Se the file PUBLIC for licence information. This software comes with ABSOLUTELY NO WARRANTY: see the file PUBLIC for details. Starts the mysql server Usage: /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/bin/mysqld [OPTIONS] -b, --basedir=path Path to installation directory. All paths are usually resolved relative to this --big-tables Allow big result sets by saving all temporary sets on file (Solves most 'table full' errors) --bind-address=IP Ip address to bind to --bootstrap Used by mysql installation scripts --chroot=path Chroot mysqld daemon during startup -h, --datadir=path Path to the database root --enable-locking Enable system locking -T, --exit-info Print some debug info at exit -?, --help Display this help and exit -L, --language=... Client error messages in given language. May be given as a full path -l, --log[=file] Log connections and queries to file --log-update[=file] Log updates to file.# where # is a unique number if not given. --log-isam[=file] Log all isam changes to file --log-long-format Log some extra information to update log --low-priority-insert Inserts has lower priority than selects --pid-file=path Pid file used by safe_mysqld -P, --port=... Port number to use for connection -n, --new Use very new possible 'unsafe' functions -o, --old-protocol Use the old (3.20) protocol --one-thread Only use one thread (for debugging under Linux) -O, --set-variable var=option Give a variable an value. --help lists variables -Sg, --skip-grant-tables Start without grant tables. This gives all users FULL ACCESS to all tables! --safe-mode Skip some optimize stages (for testing) --skip-locking Don't use system locking. To use isamchk one has to shut down the server. --skip-name-resolve Don't resolve hostnames. All hostnames are IP's or 'localhost' --skip-networking Don't allow connection with TCP/IP. --skip-new Don't use new, possible wrong routines. --skip-host-cache Don't cache host names --skip-thread-priority Don't give threads different priorities. --socket=... Socket file to use for connection -t, --tmpdir=path Path for temporary files -u, --user=user_name Run mysqld daemon as user -V, --version output version information and exit Default options are read from the following files in the given order: /etc/my.cnf /usr/local/mysql/var/my.cnf ~/.my.cnf The following groups are read: mysqld server The following options may be given as the first argument: --print-defaults Print the program argument list and exit --no-defaults Don't read default options from any options file --defaults-file=# Only read default options from the given file # To see what values a running MySQL server is using, type 'mysqladmin variables' instead of 'mysqld --help'. The default values (after parsing the command line arguments) are: basedir: /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/ datadir: /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/data/ tmpdir: /tmp/ language: /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/share/mysql/english/ pid file: /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/data/vergil01.pid TCP port: 3316 Unix socket: /nfs/guido03/da29/d90/jhryu/mysql.sock Possible variables for option --set-variable (-O) are: back_log current value: 5 connect_timeout current value: 5 delayed_insert_timeout current value: 300 delayed_insert_limit current value: 100 flush_time current value: 0 join_buffer current value: 131072 key_buffer current value: 8388600 long_query_time current value: 10 max_allowed_packet current value: 1048576 max_connections current value: 100 max_connect_errors current value: 10 max_delayed_insert_threads current value: 20 delayed_queue_size current value: 1000 max_join_size current value: 4294967295 max_sort_length current value: 1024 max_write_lock_count current value: 4294967295 net_buffer_length current value: 16384 record_buffer current value: 131072 sort_buffer current value: 2097144 table_cache current value: 64 tmp_table_size current value: 1048576 thread_stack current value: 65536 wait_timeout current value: 28800 mysqld ended on Mon Sep 17 11:24:01 PDT 2001 mysqld started on Mon Sep 17 11:24:11 PDT 2001 010917 11:24:11 /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/bin/mysqld: Table 'mysql.host' doesn't exist 010917 11:24:11 /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/bin/mysqld: Normal shutdown 010917 11:24:11 /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/bin/mysqld: Shutdown Complete mysqld ended on Mon Sep 17 11:24:11 PDT 2001 mysqld started on Mon Sep 17 11:24:33 PDT 2001 010917 11:24:33 /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/bin/mysqld: Table 'mysql.host' doesn't exist 010917 11:24:33 /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/bin/mysqld: Normal shutdown 010917 11:24:33 /da29/d90/jhryu/mysql-3.22.32-ibm-aix4.2.1.0-powerpc/bin/mysqld: Shutdown Complete mysqld ended on Mon Sep 17 11:24:33 PDT 2001 ============================================================================ =============== I appreciate your help Jay ryu -----Original Message----- From: LINUX-owner@u.washington.edu [mailto:LINUX-owner@u.washington.edu]On Behalf Of Trevor Leffler Sent: Monday, September 17, 2001 9:59 AM To: UW Linux Group Subject: Re: mySQL on dante... Jay Ryu, This problem could be a couple of things. First, your MySQL server may not even be running. Use the 'ps' command to find out. (Don't know how to use ps? Type 'man ps' at the prompt.) Also, did you follow the advice and look to see whether that mysql.sock file (actually, a socket) really exists? You should. If it doesn't, your server isn't started. If it does, see below. Second, you might be on a different dante than what you started your server on. There are something like 48 dantes. If you started the server on dante26, you can't access it from dante16 or any others for that matter. I would suggest that you're either very aware of which dante you're on, or use vergil, since there is only one of them at the moment. Next, Dejan mentioned something about permissions. Once you get your server running, you need to make sure that others can't access it with admin privileges, and that your programs can access the tables that they need. You can read all about this in Chapter 6 of the documentation at www.mysql.com. In fact, read this BEFORE you start any servers. Finally, I should mention that the binaries for the latest MySQL release are not compatible with UW's UA servers (dante, homer, etc). They are compiled for a different version of AIX (IBM's UNIX OS). So, you can either use the binaries for MySQL 3.22.XX or try compiling 3.23.XX on your own. And remember, you can't compile on dante or homer, use vergil or ovid. Thanks, -- Trevor Leffler, Software Developer PETTT / Ed-Tech Development Group University of Washington (206) 616-3406 / OUGL 230, Box 353080 JAY HYUN RYU wrote: > > Dear All > > After following the direction at > http://depts.washington.edu/mysql/mysql.html, > I got an error message below, > > dante13% ./bin/mysqladmin -u root '' > ./bin/mysqladmin: connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket '/mysql.sock' (2)' > Check that mysqld is running and that the socket: '/mysql.sock' exists! > dante13% > > Even though I tried to several ways, I couldn't make it. > I greatly appreciate your comment. > > Jay Ryu > > Dept. of Civil Engineering. > 206)616-1775 .