|
Home > Archive > MySQL ODBC Connector > October 2005 > demon quits immediately...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
demon quits immediately...
|
|
| tom wible 2005-10-27, 7:46 am |
| >Description:
& #91;root@tomsEmachin
e mysql-standard-5.0.15-linux-i686-glibc23]# Starting
mysqld daemon with databases from
/usr/local/mysql-standard-5.0.15-linux-i686-glibc23/data
STOPPING server from pid file
/usr/local/mysql-standard-5.0.15-linux-i686-glibc23/data/tomsEmachine.pid
051024 18:36:32 mysqld ended
>Submitter-Id: airdrummer
>Originator: tom wible
>Organization:
>MySQL support: none
>Synopsis: demon quits immediately
>Severity: critical
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: sw-bug
>Release: mysql-5.0.15-standard (MySQL Community Edition - Standard
(GPL))
>C compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
>C++ compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux tomsEmachine 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:55:56 EDT
2005 i686 i686 i386 GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Using built-in specs.
Target: i386-redhat-linux
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--enable-checking=release --with-system-zlib --enable-__cxa_atexit
--disable-libunwind-exceptions --enable-libgcj-multifile
--enable- languages=c,c++,objc
,java,f95,ada --enable-java-awt=gtk
--with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre
--host=i386-redhat-linux
Thread model: posix
gcc version 4.0.0 20050519 (Red Hat 4.0.0-8)
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS=''
LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jun 19 21:47 /lib/libc.so.6 -> libc-2.3.5.so
-rwxr-xr-x 1 root root 1489572 May 30 08:05 /lib/libc-2.3.5.so
-rw-r--r-- 1 root root 2523698 May 30 08:44 /usr/lib/libc.a
-rw-r--r-- 1 root root 238 May 30 07:10 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Jun 19 23:31 /usr/lib/libc-client.a -> c-client.a
lrwxrwxrwx 1 root root 16 Jun 19 23:31 /usr/lib/libc-client.so ->
libc-client.so.0
-rwxr-xr-x 1 root root 773464 Mar 2 2005 /usr/lib/libc-client.so.0
Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr/local/mysql/data'
'--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community
Edition - Standard (GPL)' '--with-extra-charsets=complex'
'--with-server-suffix=-standard' '--enable-thread-safe-client'
'--enable-local-infile' '--enable-assembler' '--disable-shared'
'--with-big-tables' '--with-readline' '--with-archive-storage-engine'
'--with-innodb' 'CC=gcc' 'CXX=gcc'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Peter J Milanese 2005-10-27, 7:47 am |
| Logs?
-----------------
Sent from my NYPL BlackBerry Handheld.
----- Original Message -----
From: tom wible & #91;airdrummer@wheel
.org]
Sent: 10/24/2005 06:58 PM
To: mysql@lists.mysql.com
Cc: tewible4@verizon.net
Subject: demon quits immediately...
>Description:
& #91;root@tomsEmachin
e mysql-standard-5.0.15-linux-i686-glibc23]# Starting
mysqld daemon with databases from
/usr/local/mysql-standard-5.0.15-linux-i686-glibc23/data
STOPPING server from pid file
/usr/local/mysql-standard-5.0.15-linux-i686-glibc23/data/tomsEmachine.pid
051024 18:36:32 mysqld ended
>Submitter-Id: airdrummer
>Originator: tom wible
>Organization:
>MySQL support: none
>Synopsis: demon quits immediately
>Severity: critical
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: sw-bug
>Release: mysql-5.0.15-standard (MySQL Community Edition - Standard
(GPL))
>C compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
>C++ compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux tomsEmachine 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:55:56 EDT
2005 i686 i686 i386 GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Using built-in specs.
Target: i386-redhat-linux
Configured with: ../configure --prefix=3D/usr --mandir=3D/usr/share/man
--infodir=3D/usr/share/info --enable-shared --enable-threads=3Dposix
--enable-checking=3Drelease --with-system-zlib --enable-__cxa_atexit
--disable-libunwind-exceptions --enable-libgcj-multifile
--enable- languages=3Dc,c++,ob
jc,java,f95,ada --enable-java-awt=3Dgtk
--with-java-home=3D/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre
--host=3Di386-redhat-linux
Thread model: posix
gcc version 4.0.0 20050519 (Red Hat 4.0.0-8)
Compilation info: CC=3D'gcc' CFLAGS=3D'' CXX=3D'gcc' CXXFLAGS=3D''
LDFLAGS=3D'' ASFLAGS=3D''
LIBC:
lrwxrwxrwx 1 root root 13 Jun 19 21:47 /lib/libc.so.6 -> libc-2.3.5.so
-rwxr-xr-x 1 root root 1489572 May 30 08:05 /lib/libc-2.3.5.so
-rw-r--r-- 1 root root 2523698 May 30 08:44 /usr/lib/libc.a
-rw-r--r-- 1 root root 238 May 30 07:10 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Jun 19 23:31 /usr/lib/libc-client.a -> c-client.a
lrwxrwxrwx 1 root root 16 Jun 19 23:31 /usr/lib/libc-client.so ->
libc-client.so.0
-rwxr-xr-x 1 root root 773464 Mar 2 2005 /usr/lib/libc-client.so.0
Configure command: ./configure '--prefix=3D/usr/local/mysql'
'--localstatedir=3D/usr/local/mysql/data'
'--libexecdir=3D/usr/local/mysql/bin' '--with-comment=3DMySQL Community
Edition - Standard (GPL)' '--with-extra-charsets=3Dcomplex'
'--with-server-suffix=3D-standard' '--enable-thread-safe-client'
'--enable-local-infile' '--enable-assembler' '--disable-shared'
'--with-big-tables' '--with-readline' '--with-archive-storage-engine'
'--with-innodb' 'CC=3Dgcc' 'CXX=3Dgcc'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...ny
pl.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Michael McFadden 2005-10-27, 7:47 am |
| Hi.
Looks like the 'hosts' grant table is missing,
corrupt, or does not have permissions set correctly.
My examples come from version 4.1 I hope they apply,
or at least point you in the right direction.
My datadir is /var/lib/mysql - your's may be different
within the datadir there is another directory 'mysql'
- (/var/lib/mysql/mysql/) these are where the grant
tables live.
within that directory, you should have these:
-rw-rw---- 1 mysql mysql 9064 2005-10-24 15:21
host.frm
-rw-rw---- 1 mysql mysql 0 2005-10-24 15:21
host.MYD
-rw-rw---- 1 mysql mysql 1024 2005-10-24 15:21
host.MYI
make sure they
1) exsist
2) owned by the mysql user (in my case, 'mysql')
3) readable, writeable by 'mysql' (of course)
You can also attempt to rerun 'mysql_install_db' to
recreate the grant tables.
Please read
http://dev.mysql.com/doc/refman/5.0...stallation.html
for more information on the mysql_install_db script.
Also, if you are upgrading from 4.1 to 5.0, you may
need to run 'mysql_fix_privelage
_tables' to add
aditional columns to your existing tables. This is
probably not the case, tho.
Hope that helps you!
-Mike
--- tom wible <airdrummer@wheel.org> wrote:
>
> & #91;root@tomsEmachin
e
> mysql-standard-5.0.15-linux-i686]# Starting mysqld
> daemon with databases from
> /usr/local/mysql-standard-5.0.15-linux-i686/data
> STOPPING server from pid file
>
/usr/local/mysql-standard-5.0.15-linux-i686/data/tomsEmachine.pid
> 051024 19:52:09 mysqld ended
>
> & #91;root@tomsEmachin
e
> mysql-standard-5.0.15-linux-i686]# cat
> /var/lib/mysql/tomsEmachine.err
> 051024 18:38:27 mysqld started
> InnoDB: The first specified data file ./ibdata1 did
> not exist:
> InnoDB: a new database to be created!
> 051024 18:38:28 InnoDB: Setting file ./ibdata1 size
> to 10 MB
> InnoDB: Database physically writes the file full:
> wait...
> 051024 18:38:28 InnoDB: Log file ./ib_logfile0 did
> not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full:
> wait...
> 051024 18:38:29 InnoDB: Log file ./ib_logfile1 did
> not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full:
> wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: Creating foreign key constraint system
> tables
> InnoDB: Foreign key constraint system tables created
> 051024 18:38:29 InnoDB: Started; log sequence
> number 0 0
> 051024 18:38:29 [ERROR] Fatal error: Can't open and
> lock privilege
> tables: Table 'mysql.host' doesn't exist
> 051024 18:38:30 mysqld ended
>
> 051024 19:54:03 mysqld started
> 051024 19:54:03 InnoDB: Database was not shut down
> normally!
> InnoDB: Starting crash recovery.
> InnoDB: Reading tablespace information from the .ibd
> files...
> InnoDB: Restoring possible half-written data pages
> from the doublewrite
> InnoDB: buffer...
> 051024 19:54:03 InnoDB: Starting log scan based on
> checkpoint at
> InnoDB: log sequence number 0 36808.
> InnoDB: Doing recovery: scanned up to log sequence
> number 0 43655
> 051024 19:54:04 InnoDB: Starting an apply batch of
> log records to the
> database...
> InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12
> 13 14 15 16 17 18
> 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
> 36 37 38 39 40 41 42
> 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
> 60 61 62 63 64 65 66
> 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
> 84 85 86 87 88 89 90
> 91 92 93 94 95 96 97 98 99
> InnoDB: Apply batch completed
> 051024 19:54:04 InnoDB: Started; log sequence
> number 0 43655
> 051024 19:54:04 [ERROR] Fatal error: Can't open and
> lock privilege
> tables: Table 'mysql.host' doesn't exist
> 051024 19:54:04 mysqld ended
>
>
> Edition - Standard
> (GPL))
>
> Linux 3.2.3-52)
> Linux 3.2.3-52)
> <machine, os, target, libraries (multiple
> lines)>
> System: Linux tomsEmachine 2.6.11-1.1369_FC4 #1 Thu
> Jun 2 22:55:56 EDT
> 2005 i686 i686 i386 GNU/Linux
> Architecture: i686
>
> Some paths: /usr/bin/perl /usr/bin/make
> /usr/bin/gmake /usr/bin/gcc
> /usr/bin/cc
> GCC: Using built-in specs.
> Target: i386-redhat-linux
> Configured with: ../configure --prefix=/usr
> --mandir=/usr/share/man
> --infodir=/usr/share/info --enable-shared
> --enable-threads=posix
> --enable-checking=release --with-system-zlib
> --enable-__cxa_atexit
> --disable-libunwind-exceptions
> --enable-libgcj-multifile
> --enable- languages=c,c++,objc
,java,f95,ada
> --enable-java-awt=gtk
>
--with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre
> --host=i386-redhat-linux
> Thread model: posix
> gcc version 4.0.0 20050519 (Red Hat 4.0.0-8)
> Compilation info: CC='gcc' CFLAGS='' CXX='gcc'
> CXXFLAGS=''
> LDFLAGS='' ASFLAGS=''
> LIBC:
> lrwxrwxrwx 1 root root 13 Jun 19 21:47
> /lib/libc.so.6 -> libc-2.3.5.so
> -rwxr-xr-x 1 root root 1489572 May 30 08:05
> /lib/libc-2.3.5.so
> -rw-r--r-- 1 root root 2523698 May 30 08:44
> /usr/lib/libc.a
> -rw-r--r-- 1 root root 238 May 30 07:10
> /usr/lib/libc.so
> lrwxrwxrwx 1 root root 10 Jun 19 23:31
> /usr/lib/libc-client.a -> c-client.a
> lrwxrwxrwx 1 root root 16 Jun 19 23:31
> /usr/lib/libc-client.so ->
> libc-client.so.0
> -rwxr-xr-x 1 root root 773464 Mar 2 2005
> /usr/lib/libc-client.so.0
> Configure command: ./configure
> '--prefix=/usr/local/mysql'
> '--localstatedir=/usr/local/mysql/data'
> '--libexecdir=/usr/local/mysql/bin'
> '--with-comment=MySQL Community
> Edition - Standard (GPL)'
> '--with-extra-charsets=complex'
> '--with-server-suffix=-standard'
> '--enable-thread-safe-client'
> '--enable-local-infile' '--enable-assembler'
> '--disable-shared'
> '--with-big-tables' '--with-readline'
> '--with-archive-storage-engine'
> '--with-innodb' 'CC=gcc' 'CXX=gcc'
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=flipmcf@yahoo.com
>
>
____________________
______________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| David Ziggy Lubowa 2005-10-27, 7:47 am |
|
change the group
chown -R mysql.daemon /dir/name
try that
On Tuesday 25 October 2005 16:05, Michael McFadden wrote:
> Hi.
>
> Looks like the 'hosts' grant table is missing,
> corrupt, or does not have permissions set correctly.
>
> My examples come from version 4.1 I hope they apply,
> or at least point you in the right direction.
>
> My datadir is /var/lib/mysql - your's may be different
>
> within the datadir there is another directory 'mysql'
> - (/var/lib/mysql/mysql/) these are where the grant
> tables live.
>
> within that directory, you should have these:
> -rw-rw---- 1 mysql mysql 9064 2005-10-24 15:21
> host.frm
> -rw-rw---- 1 mysql mysql 0 2005-10-24 15:21
> host.MYD
> -rw-rw---- 1 mysql mysql 1024 2005-10-24 15:21
> host.MYI
>
> make sure they
> 1) exsist
> 2) owned by the mysql user (in my case, 'mysql')
> 3) readable, writeable by 'mysql' (of course)
>
> You can also attempt to rerun 'mysql_install_db' to
> recreate the grant tables.
>
> Please read
> http://dev.mysql.com/doc/refman/5.0...stallation.html
> for more information on the mysql_install_db script.
>
> Also, if you are upgrading from 4.1 to 5.0, you may
> need to run 'mysql_fix_privelage
_tables' to add
> aditional columns to your existing tables. This is
> probably not the case, tho.
>
> Hope that helps you!
>
> -Mike
>
> --- tom wible <airdrummer@wheel.org> wrote:
>
> /usr/local/mysql-standard-5.0.15-linux-i686/data/tomsEmachine.pid
>
>
> --with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre
>
>
> ____________________
______________
> Yahoo! FareChase: Search multiple travel sites in one click.
> http://farechase.yahoo.com
--
--
Fanaticism consists of redoubling your effort when you have forgotten your
aim.
-- George Santayana
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Gleb Paharenko 2005-10-27, 7:47 am |
| Hello.
> 051024 18:38:29 [ERROR] Fatal error: Can't open and lock privilege
> tables: Table 'mysql.host' doesn't exist
Have you launched mysql_install_db? See:
http://dev.mysql.com/doc/refman/5.0...stallation.html
tom wible wrote:
>
>
> & #91;root@tomsEmachin
e mysql-standard-5.0.15-linux-i686]# Starting mysqld
> daemon with databases from /usr/local/mysql-standard-5.0.15-linux-i686/data
> STOPPING server from pid file
> /usr/local/mysql-standard-5.0.15-linux-i686/data/tomsEmachine.pid
> 051024 19:52:09 mysqld ended
>
> & #91;root@tomsEmachin
e mysql-standard-5.0.15-linux-i686]# cat
> /var/lib/mysql/tomsEmachine.err
> 051024 18:38:27 mysqld started
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 051024 18:38:28 InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 051024 18:38:28 InnoDB: Log file ./ib_logfile0 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 051024 18:38:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 051024 18:38:29 InnoDB: Started; log sequence number 0 0
> 051024 18:38:29 [ERROR] Fatal error: Can't open and lock privilege
> tables: Table 'mysql.host' doesn't exist
> 051024 18:38:30 mysqld ended
>
> 051024 19:54:03 mysqld started
> 051024 19:54:03 InnoDB: Database was not shut down normally!
> InnoDB: Starting crash recovery.
> InnoDB: Reading tablespace information from the .ibd files...
> InnoDB: Restoring possible half-written data pages from the doublewrite
> InnoDB: buffer...
> 051024 19:54:03 InnoDB: Starting log scan based on checkpoint at
> InnoDB: log sequence number 0 36808.
> InnoDB: Doing recovery: scanned up to log sequence number 0 43655
> 051024 19:54:04 InnoDB: Starting an apply batch of log records to the
> database...
> InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
> 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
> 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
> 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
> 91 92 93 94 95 96 97 98 99
> InnoDB: Apply batch completed
> 051024 19:54:04 InnoDB: Started; log sequence number 0 43655
> 051024 19:54:04 [ERROR] Fatal error: Can't open and lock privilege
> tables: Table 'mysql.host' doesn't exist
> 051024 19:54:04 mysqld ended
>
>
>
> (GPL))
>
>
> <machine, os, target, libraries (multiple lines)>
> System: Linux tomsEmachine 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:55:56 EDT
> 2005 i686 i686 i386 GNU/Linux
> Architecture: i686
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
> /usr/bin/cc
> GCC: Using built-in specs.
> Target: i386-redhat-linux
> Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
> --infodir=/usr/share/info --enable-shared --enable-threads=posix
> --enable-checking=release --with-system-zlib --enable-__cxa_atexit
> --disable-libunwind-exceptions --enable-libgcj-multifile
> --enable- languages=c,c++,objc
,java,f95,ada --enable-java-awt=gtk
> --with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre
> --host=i386-redhat-linux
> Thread model: posix
> gcc version 4.0.0 20050519 (Red Hat 4.0.0-8)
> Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS=''
> LDFLAGS='' ASFLAGS=''
> LIBC:
> lrwxrwxrwx 1 root root 13 Jun 19 21:47 /lib/libc.so.6 -> libc-2.3.5.so
> -rwxr-xr-x 1 root root 1489572 May 30 08:05 /lib/libc-2.3.5.so
> -rw-r--r-- 1 root root 2523698 May 30 08:44 /usr/lib/libc.a
> -rw-r--r-- 1 root root 238 May 30 07:10 /usr/lib/libc.so
> lrwxrwxrwx 1 root root 10 Jun 19 23:31 /usr/lib/libc-client.a ->
> c-client.a
> lrwxrwxrwx 1 root root 16 Jun 19 23:31 /usr/lib/libc-client.so ->
> libc-client.so.0
> -rwxr-xr-x 1 root root 773464 Mar 2 2005 /usr/lib/libc-client.so.0
> Configure command: ./configure '--prefix=/usr/local/mysql'
> '--localstatedir=/usr/local/mysql/data'
> '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community
> Edition - Standard (GPL)' '--with-extra-charsets=complex'
> '--with-server-suffix=-standard' '--enable-thread-safe-client'
> '--enable-local-infile' '--enable-assembler' '--disable-shared'
> '--with-big-tables' '--with-readline' '--with-archive-storage-engine'
> '--with-innodb' 'CC=gcc' 'CXX=gcc'
>
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| tom wible 2005-10-27, 7:47 am |
| well, i've got /var/lib/mysql:
& #91;tomw@tomsEmachin
e mysql]$ ll /var/lib/mysql/
total 20524
-rw-rw---- 1 mysql mysql 10485760 Oct 24 18:38 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Oct 24 19:54 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Oct 24 18:38 ib_logfile1
-rw-rw---- 1 mysql root 2102 Oct 24 19:54 tomsEmachine.err
and /usr/local/mysql/data/mysql:
& #91;tomw@tomsEmachin
e data]$ ll /usr/local/mysql/data
total 12
drwxr-x--- 2 tomw mysql 4096 Oct 24 19:52 mysql
drwxr-x--- 2 tomw mysql 4096 Oct 17 07:21 test
-rw-rw---- 1 tomw mysql 666 Oct 24 19:54 tomsEmachine.err
note the identical datestamps on the 2 .err files...
anyway, i chown'd mysql:mysql /usr/local/mysql/data/mysql/* & reran
scripts/mysql_install_db and got this:
& #91;tomw@tomsEmachin
e mysql]$ ./scripts/mysql_install_db
mkdir: cannot create directory `/var/lib/mysql/mysql': Permission denied
chmod: cannot access `/var/lib/mysql/mysql': No such file or directory
mkdir: cannot create directory `/var/lib/mysql/test': Permission denied
chmod: cannot access `/var/lib/mysql/test': No such file or directory
Installing all prepared tables
051026 19:59:20 [Warning] Can't create test file
/var/lib/mysql/tomsEmachine.lower-test
Fill help tables
051026 19:59:20 [Warning] Can't create test file
/var/lib/mysql/tomsEmachine.lower-test
so i
chown'd mysql:mysql /usr/local/mysql (for some reason, i had 2 do that as root,
even tho i owned the dir tree...wtf?-)
su mysql
and ./scripts/mysql_install_db ran successfully, creating the /var/lib/mysql
datafiles.
and ./bin/mysqld_safe seems 2 have worked...
oh, wait: ./bin/mysqladmin -u root password '<newpassword>' gives me this:
../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!
bash-3.00$ ls -l /tmp/mysql.sock
ls: /tmp/mysql.sock: No such file or directory
bash-3.00$ ps -ef | grep mysql
root 2121 2092 0 20:15 pts/7 00:00:00 su mysql
mysql 2122 2121 0 20:15 pts/7 00:00:00 bash
mysql 2211 2122 0 20:21 pts/7 00:00:00 /bin/sh ./bin/mysqld_safe
mysql 2232 2211 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2233 2232 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2234 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2235 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2236 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2237 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2239 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2240 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2241 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2242 2233 0 20:21 pts/7 00:00:00 /usr/local/mysql/bin/mysqld
--basedir=/usr/local/mysql --datadir=/var/lib/mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 2294 2122 0 20:26 pts/7 00:00:00 ps -ef
mysql 2295 2122 0 20:26 pts/7 00:00:00 grep mysql
bash-3.00$ ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
fixed that;-)
oh, wait:
bash-3.00$ ./bin/mysqladmin -u root password '<new-passwd>'
bash-3.00$ ./bin/mysqladmin -u root -h tomsEmachine password '<new-passwd>'
../bin/mysqladmin: connect to server at 'tomsEmachine' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
thanx 4 all the help...weird how there were 2 sets of db files, the disconnect
on the .sock, and then the password fubar...but then that's what makes linux so
much not-read4primetime-fun;-}
David Ziggy Lubowa wrote:
> change the group
>
>
> chown -R mysql.daemon /dir/name
>
>
> try that
>
>
> On Tuesday 25 October 2005 16:05, Michael McFadden wrote:
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Logan, David 2005-10-27, 7:47 am |
| Hi Tom
Looks like you had an earlier version that had a
datadir=3D/usr/local/mysql/data. The new version was expecting the data
directory to reside in /var/lib/mysql (that can be seen on your mysqld
processes and also the mysql_install_db output).
You can change this in the /etc/my.cnf
(http://dev.mysql.com/doc/refman/5.0...tion-files.html) or on the
command line
(http://dev.mysql.com/doc/refman/5.0...er-options.html) to where
your real data lives. You can then run ./mysql_install_db and it will
create the database/tables in the correct spot.
Same problem with the socket. Different rpms/distributions put the
socket in different places and this was a little bit different. See
http://dev.mysql.com/doc/refman/5.0...-to-server.html
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-----Original Message-----
From: tom wible & #91;mailto:airdrumme
r@wheel.org]=20
Sent: Thursday, 27 October 2005 10:13 AM
To: dlubowa@bushnet.net
Cc: mysql@lists.mysql.com; Michael McFadden; PMilanese@nypl.org; Sheldon
Robinson
Subject: Re: demon quits immediately...
well, i've got /var/lib/mysql:
& #91;tomw@tomsEmachin
e mysql]$ ll /var/lib/mysql/
total 20524
-rw-rw---- 1 mysql mysql 10485760 Oct 24 18:38 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Oct 24 19:54 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Oct 24 18:38 ib_logfile1
-rw-rw---- 1 mysql root 2102 Oct 24 19:54 tomsEmachine.err
and /usr/local/mysql/data/mysql:
& #91;tomw@tomsEmachin
e data]$ ll /usr/local/mysql/data
total 12
drwxr-x--- 2 tomw mysql 4096 Oct 24 19:52 mysql
drwxr-x--- 2 tomw mysql 4096 Oct 17 07:21 test
-rw-rw---- 1 tomw mysql 666 Oct 24 19:54 tomsEmachine.err
note the identical datestamps on the 2 .err files...
anyway, i chown'd mysql:mysql /usr/local/mysql/data/mysql/* & reran=20
scripts/mysql_install_db and got this:
& #91;tomw@tomsEmachin
e mysql]$ ./scripts/mysql_install_db
mkdir: cannot create directory `/var/lib/mysql/mysql': Permission denied
chmod: cannot access `/var/lib/mysql/mysql': No such file or directory
mkdir: cannot create directory `/var/lib/mysql/test': Permission denied
chmod: cannot access `/var/lib/mysql/test': No such file or directory
Installing all prepared tables
051026 19:59:20 [Warning] Can't create test file=20
/var/lib/mysql/tomsEmachine.lower-test
Fill help tables
051026 19:59:20 [Warning] Can't create test file=20
/var/lib/mysql/tomsEmachine.lower-test
so i
chown'd mysql:mysql /usr/local/mysql (for some reason, i had 2
do that as root,=20
even tho i owned the dir tree...wtf?-)
su mysql
and ./scripts/mysql_install_db ran successfully, creating the
/var/lib/mysql=20
datafiles.
and ./bin/mysqld_safe seems 2 have worked...
oh, wait: ./bin/mysqladmin -u root password '<newpassword>' gives me
this:
../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!
bash-3.00$ ls -l /tmp/mysql.sock
ls: /tmp/mysql.sock: No such file or directory
bash-3.00$ ps -ef | grep mysql
root 2121 2092 0 20:15 pts/7 00:00:00 su mysql
mysql 2122 2121 0 20:15 pts/7 00:00:00 bash
mysql 2211 2122 0 20:21 pts/7 00:00:00 /bin/sh
../bin/mysqld_safe
mysql 2232 2211 0 20:21 pts/7 00:00:00
/usr/local/mysql/bin/mysqld=20
--basedir=3D/usr/local/mysql --datadir=3D/var/lib/mysql=20
--pid-file=3D/var/run/mysqld/mysqld.pid --skip-locking=20
--socket=3D/var/lib/mysql/mysql.sock
mysql 2233 2232 0 20:21 pts/7 00:00:00
/usr/local/mysql/bin/mysqld=20
--basedir=3D/usr/local/mysql --datadir=3D/var/lib/mysql=20
--pid-file=3D/var/run/mysqld/mysqld.pid --skip-locking=20
--socket=3D/var/lib/mysql/mysql.sock
mysql 2234 2233 0 20:21 pts/7 00:00:00
/usr/local/mysql/bin/mysqld=20
--basedir=3D/usr/local/mysql --datadir=3D/var/lib/mysql=20
--pid-file=3D/var/run/mysqld/mysqld.pid --skip-locking=20
--socket=3D/var/lib/mysql/mysql.sock
mysql 2235 2233 0 20:21 pts/7 00:00:00
/usr/local/mysql/bin/mysqld=20
--basedir=3D/usr/local/mysql --datadir=3D/var/lib/mysql=20
--pid-file=3D/var/run/mysqld/mysqld.pid --skip-locking=20
--socket=3D/var/lib/mysql/mysql.sock
mysql 2236 2233 0 20:21 pts/7 00:00:00
/usr/local/mysql/bin/mysqld=20
--basedir=3D/usr/local/mysql --datadir=3D/var/lib/mysql=20
--pid-file=3D/var/run/mysqld/mysqld.pid --skip-locking=20
--socket=3D/var/lib/mysql/mysql.sock
mysql 2237 2233 0 20:21 pts/7 00:00:00
/usr/local/mysql/bin/mysqld=20
--basedir=3D/usr/local/mysql --datadir=3D/var/lib/mysql=20
--pid-file=3D/var/run/mysqld/mysqld.pid --skip-locking=20
--socket=3D/var/lib/mysql/mysql.sock
mysql 2239 2233 0 20:21 pts/7 00:00:00
/usr/local/mysql/bin/mysqld=20
--basedir=3D/usr/local/mysql --datadir=3D/var/lib/mysql=20
--pid-file=3D/var/run/mysqld/mysqld.pid --skip-locking=20
--socket=3D/var/lib/mysql/mysql.sock
mysql 2240 2233 0 20:21 pts/7 00:00:00
/usr/local/mysql/bin/mysqld=20
--basedir=3D/usr/local/mysql --datadir=3D/var/lib/mysql=20
--pid-file=3D/var/run/mysqld/mysqld.pid --skip-locking=20
--socket=3D/var/lib/mysql/mysql.sock
mysql 2241 2233 0 20:21 pts/7 00:00:00
/usr/local/mysql/bin/mysqld=20
--basedir=3D/usr/local/mysql --datadir=3D/var/lib/mysql=20
--pid-file=3D/var/run/mysqld/mysqld.pid --skip-locking=20
--socket=3D/var/lib/mysql/mysql.sock
mysql 2242 2233 0 20:21 pts/7 00:00:00
/usr/local/mysql/bin/mysqld=20
--basedir=3D/usr/local/mysql --datadir=3D/var/lib/mysql=20
--pid-file=3D/var/run/mysqld/mysqld.pid --skip-locking=20
--socket=3D/var/lib/mysql/mysql.sock
mysql 2294 2122 0 20:26 pts/7 00:00:00 ps -ef
mysql 2295 2122 0 20:26 pts/7 00:00:00 grep mysql
bash-3.00$ ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
fixed that;-)
oh, wait:
bash-3.00$ ./bin/mysqladmin -u root password '<new-passwd>'
bash-3.00$ ./bin/mysqladmin -u root -h tomsEmachine password
'<new-passwd>'
../bin/mysqladmin: connect to server at 'tomsEmachine' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
thanx 4 all the help...weird how there were 2 sets of db files, the
disconnect=20
on the .sock, and then the password fubar...but then that's what makes
linux so=20
much not-read4primetime-fun;-}
David Ziggy Lubowa wrote:
> change the group
>=20
>=20
> chown -R mysql.daemon /dir/name
>=20
>=20
> try that
>=20
>=20
> On Tuesday 25 October 2005 16:05, Michael McFadden wrote:
>=20
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Ddavid.logan@hp.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|
|