Description:
After compiling the configuration below, mysqld_safe returns:
Starting mysqld daemon with databases from /usr2/people/niels/GOFFICE/Data_bases
Software/bin/mysqld_safe: line 311: /var/log/mysqld.log: No such file or directory
Software/bin/mysqld_safe: line 1: /var/log/mysqld.log: No such file or directory
STOPPING server from pid file /var/run/mysqld/mysqld.pid
tee: /var/log/mysqld.log: Permission denied
050404 12:29:06 mysqld ended
tee: /var/log/mysqld.log: Permission denied
This might be caused by my_print_defaults returning the following:
Software/Package_installs/MySQL/bin/my_print_defaults mysqld
--datadir=/var/lib/mysql
--socket=/var/lib/mysql/mysql.sock
--pid-file=/usr2/people/niels/GOFFICE/Admin/MySQL/yuma.pid
--port=3306
--socket=/usr2/people/niels/GOFFICE/Admin/MySQL/mysql.sock
--tmpdir=/usr2/people/niels/GOFFICE/Scratch
--datadir=/usr2/people/niels/GOFFICE/Data_bases
--skip-locking
--skip-networking
--ft_min_word_len=3
--ft_stopword_file=
--key_buffer=256M
--bulk_insert_buffer_size=128M
--max_allowed_packet=16M
--table_cache=512
--read_buffer_size=16M
--sort_buffer_size=16M
--myisam_sort_buffer_size=128M
--record_buffer=8M
--thread_cache=8
--read_rnd_buffer_size=16M
--query_cache_limit=5M
--query_cache_size=256M
--query_cache_type=1
--log=/usr2/people/niels/GOFFICE/Logs/MySQL/query.log
--log-error=/usr2/people/niels/GOFFICE/Logs/MySQL/error.log
--log-slow-queries=/usr2/people/niels/GOFFICE/Logs/MySQL/slow_query.log
--server-id=1
There are two datadir and socket lines, which I think upsets mysqld_safe.
How to repeat:
My configuration is
$options = "";
$options .= " --prefix=/usr2/people/niels/GOFFICE/Package_installs/MySQL";
$options .= " --localstatedir=/usr2/people/niels/GOFFICE/Admin/MySQL";
$options .= " --with-unix-socket-path=/usr2/people/niels/GOFFICE/Admin/MySQL/mysql.sock";
$options .= " --enable-assembler";
$options .= " --enable-local-infile";
$options .= " --enable-thread-safe-client";
$options .= " --disable-shared";
$options .= " --without-innodb";
$options .= " --with-isam";
$options .= " --with-pthreads";
$options .= " --with-raid";
$ENV{"CC"} = "gcc";
$ENV{"CFLAGS"} = "-O3";
$ENV{"CXX"} = "gcc";
$ENV{"CXXFLAGS"} = "-O3 -felide-constructors -fno-exceptions -fno-rtti";
Description: After compiling the configuration below, mysqld_safe returns: Starting mysqld daemon with databases from /usr2/people/niels/GOFFICE/Data_bases Software/bin/mysqld_safe: line 311: /var/log/mysqld.log: No such file or directory Software/bin/mysqld_safe: line 1: /var/log/mysqld.log: No such file or directory STOPPING server from pid file /var/run/mysqld/mysqld.pid tee: /var/log/mysqld.log: Permission denied 050404 12:29:06 mysqld ended tee: /var/log/mysqld.log: Permission denied This might be caused by my_print_defaults returning the following: Software/Package_installs/MySQL/bin/my_print_defaults mysqld --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/usr2/people/niels/GOFFICE/Admin/MySQL/yuma.pid --port=3306 --socket=/usr2/people/niels/GOFFICE/Admin/MySQL/mysql.sock --tmpdir=/usr2/people/niels/GOFFICE/Scratch --datadir=/usr2/people/niels/GOFFICE/Data_bases --skip-locking --skip-networking --ft_min_word_len=3 --ft_stopword_file= --key_buffer=256M --bulk_insert_buffer_size=128M --max_allowed_packet=16M --table_cache=512 --read_buffer_size=16M --sort_buffer_size=16M --myisam_sort_buffer_size=128M --record_buffer=8M --thread_cache=8 --read_rnd_buffer_size=16M --query_cache_limit=5M --query_cache_size=256M --query_cache_type=1 --log=/usr2/people/niels/GOFFICE/Logs/MySQL/query.log --log-error=/usr2/people/niels/GOFFICE/Logs/MySQL/error.log --log-slow-queries=/usr2/people/niels/GOFFICE/Logs/MySQL/slow_query.log --server-id=1 There are two datadir and socket lines, which I think upsets mysqld_safe. How to repeat: My configuration is $options = ""; $options .= " --prefix=/usr2/people/niels/GOFFICE/Package_installs/MySQL"; $options .= " --localstatedir=/usr2/people/niels/GOFFICE/Admin/MySQL"; $options .= " --with-unix-socket-path=/usr2/people/niels/GOFFICE/Admin/MySQL/mysql.sock"; $options .= " --enable-assembler"; $options .= " --enable-local-infile"; $options .= " --enable-thread-safe-client"; $options .= " --disable-shared"; $options .= " --without-innodb"; $options .= " --with-isam"; $options .= " --with-pthreads"; $options .= " --with-raid"; $ENV{"CC"} = "gcc"; $ENV{"CFLAGS"} = "-O3"; $ENV{"CXX"} = "gcc"; $ENV{"CXXFLAGS"} = "-O3 -felide-constructors -fno-exceptions -fno-rtti";