Professional Web Applications Themes

Can not start mysqld on Solaris 9 - MySQL

Need your help on starting 5.0.24 on a Solaris 9 system. Installed it from mysql-standard-5.0.24-solaris9-sparc-64bit.pkg, then ran scripts/mysql_install_db but after that bin/mysqld_safe quits I see that "data/myhost.err" has the following message: [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist For /etc/my.cnf, I used the sample my-huge.cnf and uncommented the InnoDB lines. What am I doing wrong? Thanks for your help. Here are the relevant output: $ uname -a SunOS myhost 5.9 Generic_117171-17 sun4u sparc SUNW,UltraAX-MP $ bin/mysqld_safe Starting mysqld daemon with databases from /opt/mysql/mysql/data STOPPING server from pid file /opt/mysql/mysql/data/myhost.pid 070109 18:59:16 mysqld ended $ ...

  1. #1

    Default Can not start mysqld on Solaris 9

    Need your help on starting 5.0.24 on a Solaris 9 system.

    Installed it from mysql-standard-5.0.24-solaris9-sparc-64bit.pkg,
    then ran scripts/mysql_install_db but after that bin/mysqld_safe quits


    I see that "data/myhost.err" has the following message:
    [ERROR] Fatal error: Can't open and lock privilege tables: Table
    'mysql.host' doesn't exist

    For /etc/my.cnf, I used the sample my-huge.cnf and uncommented the
    InnoDB lines.

    What am I doing wrong?

    Thanks for your help.

    Here are the relevant output:

    $ uname -a
    SunOS myhost 5.9 Generic_117171-17 sun4u sparc SUNW,UltraAX-MP

    $ bin/mysqld_safe
    Starting mysqld daemon with databases from /opt/mysql/mysql/data
    STOPPING server from pid file /opt/mysql/mysql/data/myhost.pid
    070109 18:59:16 mysqld ended

    $ ls -la data
    total 41020
    drwxr-xr-x 4 mysql mysql 512 Jan 9 18:18 .
    drwxr-xr-x 14 root bin 512 Jan 9 18:16 ..
    -rw-rw---- 1 mysql mysql 5242880 Jan 9 18:18 ib_logfile0
    -rw-rw---- 1 mysql mysql 5242880 Jan 9 18:18 ib_logfile1
    -rw-rw---- 1 mysql mysql 10485760 Jan 9 18:18 ibdata1
    -rw-rw---- 1 mysql root 1025 Jan 9 18:18 myhost.err
    drwxr-xr-x 2 mysql mysql 512 Jan 9 18:16 mysql
    drwxr-xr-x 2 mysql mysql 512 Jan 9 18:16 test

    btw, data/mysql and data/test are empty directories

    $ pkginfo -l mysql
    PKGINST: mysql
    NAME: MySQL Community Edition - Standard (GPL)
    CATEGORY: application
    ARCH: sun4u
    VERSION: 5.0.24
    BASEDIR: /opt/mysql
    VENDOR: MySQL AB
    PSTAMP: MySQL AB Build Engineers
    INSTDATE: Jan 09 2007 18:15
    EMAIL: com
    STATUS: completely installed
    FILES: 1693 installed pathnames
    54 directories
    100 executables
    183787 blocks used (approx)

    $ cat data/myhost.err
    070109 18:18:51 mysqld started
    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    070109 18:18:51 InnoDB: Setting file ./ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    070109 18:18:52 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...
    070109 18:18:53 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
    070109 18:18:54 InnoDB: Started; log sequence number 0 0
    070109 18:18:54 [ERROR] Fatal error: Can't open and lock privilege
    tables: Table 'mysql.host' doesn't exist
    070109 18:18:54 mysqld ended


    --- begin /etc/my.cnf, from my-huge.cnf --------------------
    # Example MySQL config file for very large systems.
    #
    # This is for a large system with memory of 1G-2G where the system runs
    mainly
    # MySQL.
    #
    # You can copy this file to
    # /etc/my.cnf to set global options,
    # mysql-data-dir/my.cnf to set server-specific options (in this
    # installation this directory is /usr/local/mysql/data) or
    # ~/.my.cnf to set user-specific options.
    #
    # In this file, you can use all long options that a program supports.
    # If you want to know which options a program supports, run the program
    # with the "--help" option.

    # The following options will be passed to all MySQL clients
    [client]
    #password = your_password
    port = 3306
    socket = /tmp/mysql.sock

    # Here follows entries for some specific programs

    # The MySQL server
    [mysqld]
    port = 3306
    socket = /tmp/mysql.sock
    skip-locking
    key_buffer = 384M
    max_allowed_packet = 1M
    table_cache = 512
    sort_buffer_size = 2M
    read_buffer_size = 2M
    read_rnd_buffer_size = 8M
    myisam_sort_buffer_size = 64M
    thread_cache_size = 8
    query_cache_size = 32M
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency = 8

    # Don't listen on a TCP/IP port at all. This can be a security
    enhancement,
    # if all processes that need to connect to mysqld run on the same host.
    # All interaction with mysqld must be made via Unix sockets or named
    pipes.
    # Note that using this option without enabling named pipes on Windows
    # (via the "enable-named-pipe" option) will render mysqld useless!
    #
    #skip-networking

    # tion Master Server (default)
    # binary logging is required for tion
    log-bin=mysql-bin

    # required unique id between 1 and 2^32 - 1
    # defaults to 1 if master-host is not set
    # but will not function as a master if omitted
    server-id = 1

    # tion Slave (comment out master section to use this)
    #
    # To configure this host as a tion slave, you can choose between
    # two methods :
    #
    # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
    # the syntax is:
    #
    # CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
    # MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
    #
    # where you replace <host>, <user>, <password> by quoted strings and
    # <port> by the master's port number (3306 by default).
    #
    # Example:
    #
    # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
    # MASTER_USER='joe', MASTER_PASSWORD='secret';
    #
    # OR
    #
    # 2) Set the variables below. However, in case you choose this method,
    then
    # start tion for the first time (even unsuccessfully, for
    example
    # if you mistyped the password in master-password and the slave
    fails to
    # connect), the slave will create a master.info file, and any later
    # change in this file to the variables' values below will be ignored
    and
    # overridden by the content of the master.info file, unless you
    shutdown
    # the slave server, delete master.info and restart the slaver
    server.
    # For that reason, you may want to leave the lines below untouched
    # (commented) and instead use CHANGE MASTER TO (see above)
    #
    # required unique id between 2 and 2^32 - 1
    # (and different from the master)
    # defaults to 2 if master-host is set
    # but will not function as a slave if omitted
    #server-id = 2
    #
    # The tion master for this slave - required
    #master-host = <hostname>
    #
    # The username the slave will use for authentication when connecting
    # to the master - required
    #master-user = <username>
    #
    # The password the slave will authenticate with when connecting to
    # the master - required
    #master-password = <password>
    #
    # The port the master is listening on.
    # optional - defaults to 3306
    #master-port = <port>
    #
    # binary logging - not required for slaves, but recommended
    #log-bin=mysql-bin

    # Point the following paths to different dedicated disks
    #tmpdir = /tmp/
    #log-update = /path-to-dedicated-directory/hostname

    # Uncomment the following if you are using BDB tables
    #bdb_cache_size = 384M
    #bdb_max_lock = 100000

    # Uncomment the following if you are using InnoDB tables
    innodb_data_home_dir = /usr/local/mysql/data/
    innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
    innodb_log_group_home_dir = /usr/local/mysql/data/
    innodb_log_arch_dir = /usr/local/mysql/data/
    # You can set .._buffer_pool_size up to 50 - 80 %
    # of RAM but beware of setting memory usage too high
    innodb_buffer_pool_size = 384M
    innodb_additional_mem_pool_size = 20M
    # Set .._log_file_size to 25 % of buffer pool size
    innodb_log_file_size = 100M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 1
    innodb_lock_wait_timeout = 50

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates

    [isamchk]
    key_buffer = 256M
    sort_buffer_size = 256M
    read_buffer = 2M
    write_buffer = 2M

    [myisamchk]
    key_buffer = 256M
    sort_buffer_size = 256M
    read_buffer = 2M
    write_buffer = 2M

    [mysqlhotcopy]
    interactive-timeout

    --- end /etc/my.cnf, from my-huge.cnf ---------------------

    Easy Guest

  2. #2

    Default Re: Can not start mysqld on Solaris 9

    On 2007-01-10, Easy User <com> wrote: 

    [ ... ]
     
     

    If the mysql.host table doesn't exist and the mysql subdirectory is
    empty, I get the suspicion the mysql_install_db script did not run
    correctly. What output did it give and can you try running it again?

    --
    Riemer Palstra Amsterdam, The Netherlands
    com http://www.palstra.com/
    Riemer Guest

  3. #3

    Default Re: Can not start mysqld on Solaris 9

    Thanks for your message.

    The mysql_install_db did not show any error.

    But instead of trying it again with the same version, I removed
    the package, downloaded the pre-packaged 5.0.27 from sunfreeware.com,
    installed it and the new mysqld is now up and running.

    Thanks again.

    Riemer Palstra wrote: 
    >
    > [ ... ]


    >
    > If the mysql.host table doesn't exist and the mysql subdirectory is
    > empty, I get the suspicion the mysql_install_db script did not run
    > correctly. What output did it give and can you try running it again?
    >
    > --
    > Riemer Palstra Amsterdam, The Netherlands
    > com http://www.palstra.com/[/ref]

    Easy Guest

Similar Threads

  1. Replies: 2
    Last Post: September 24th, 04:25 PM
  2. Second "cfusion -start default" process launchesoccasonally on solaris
    By Jim Weller in forum Coldfusion Server Administration
    Replies: 0
    Last Post: June 23rd, 03:39 PM
  3. Too many mysqld instances
    By Jan Krumsiek in forum MySQL
    Replies: 3
    Last Post: February 12th, 10:39 PM
  4. Solaris 9 does not start rpc.yppasswdd for NIS+
    By krishania in forum Sun Solaris
    Replies: 6
    Last Post: August 17th, 03:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 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 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139