Re: [gentoo-server] mysql start fails / but there are processes after start

[mRyOuNg]

Hi there, I had a problem at boot with mysql starts. As you, it fails, but when the system was booted up, i checked what was wrong about mysql, everything was up, and running perfecly. In fact, for me, the problem was related to the nss_ldap update. As mysqld was started before slapd, it fails for an strange reason. To correct it, i have added to /etc/init.d/mysql a service dependency with slapd. -- after slapd (which ask mysql to start after slapd) -- And now, everything works nicely. Hope this will help. byebye! . mRyOuNg . [ SoundBomb . Syn[Rj] ] . mail: [EMAIL PROTECTED] web : mryoung.soundbomb.net Michael Decker wrote: Hi, perhaps somebody coul help me by this problem. I start mysql with "/etc/init.d/mysql start", this failed, but there are active mysqld processes after this. The problem is, that this problem starts after a reboot. Before was all right (I'm installing that machine now) and I had tested with some daemon restart commands. So I don't understand, what is happend. --- SNIP --- # /etc/init.d/mysql start * ... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0) # cat /var/log/mysql/mysqld.err 060719 19:31:20 InnoDB: Started; log sequence number 0 43655 060719 19:31:23 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.22-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 Gentoo Linux mysql-5.0.22 060719 19:34:11 [Note] /usr/sbin/mysqld: Normal shutdown 060719 19:34:11 InnoDB: Starting shutdown... 060719 19:34:19 InnoDB: Shutdown completed; log sequence number 0 43655 060719 19:34:19 [Note] /usr/sbin/mysqld: Shutdown complete 060719 19:34:54 InnoDB: Started; log sequence number 0 43655 060719 19:34:57 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.22-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 Gentoo Linux mysql-5.0.22 # ps -Al | grep mysql 4 S 60 10819 1 0 77 0 - 26428 - ? 00:00:00 mysqld 1 S 60 10822 10819 0 76 0 - 26428 - ? 00:00:00 mysqld 1 S 60 10823 10822 0 80 0 - 26428 rt_sig ? 00:00:00 mysqld 1 S 60 10824 10822 0 76 0 - 26428 rt_sig ? 00:00:00 mysqld 1 S 60 10825 10822 0 76 0 - 26428 rt_sig ? 00:00:00 mysqld 1 S 60 10826 10822 0 80 0 - 26428 rt_sig ? 00:00:00 mysqld 1 S 60 10879 10822 0 76 0 - 26428 - ? 00:00:00 mysqld 1 S 60 10880 10822 0 76 0 - 26428 - ? 00:00:00 mysqld 1 S 60 10881 10822 0 76 0 - 26428 rt_sig ? 00:00:00 mysqld 1 S 60 10882 10822 0 78 0 - 26428 rt_sig ? 00:00:00 mysqld 1 S 60 10883 10822 0 80 0 - 26428 rt_sig ? 00:00:00 mysqld # cat /etc/mysql/my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysql] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqladmin] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlcheck] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqldump] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlimport] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlshow] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [myisamchk] character-sets-dir=/usr/share/mysql/charsets [myisampack] character-sets-dir=/usr/share/mysql/charsets [mysqld_safe] err-log = /var/log/mysql/mysql.err [mysqld] character-set-server = utf8 default-character-set = utf8 user = mysql port = 3306 socket = /var/run/mysqld/mysqld.sock pid-file = /var/run/mysqld/mysqld.pid log-error = /var/log/mysql/mysqld.err basedir = /usr datadir = /var/lib/mysql skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M language = /usr/share/mysql/english skip-networking bind-address = 127.0.0.1 set-variable=local-infile=0 log-bin = gentoo-04-bin server-id = 1 tmpdir = /tmp/ innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 5M innodb_log_buffer_size = 8M set-variable = innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout --- SNAP --- Thanks a lot, Michael Decker -- gentoo-server@gentoo.org mailing list