Problems finding parts of mysql on FreeBSD
I didn't pick the operating system( I don't know it well at all ), and didn't do the install of mysql on this system, but now I have to figure out where things are and how to fix it. What I am use to, is installing on Red Hat with the rpm. ( if someone knows the differences in the operating systems and the setup of mysql, you can see why I am confused) The rpm is nice enough to put mysqld in the /etc/init.d and respective places on Red Hat The FreeBSD doesn't even have these locations, nor does it have a mysqld anywhere We have the server rebooting every Monday morning ( why are we rebooting the server? don't know, its the specifications set from above ) from a cron job So, the mysql server is not starting up. Is there supposed to be some version of the mysqld somewhere? Or am I expected just to call safe_mysqld myself from cron? Can someone please point me in the right direction? (unfortunately I don't have time to learn the nature of FreeBSD at the moment) Luc Foisy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems finding parts of mysql on FreeBSD
In the last episode (Feb 21), Luc Foisy said: I didn't pick the operating system( I don't know it well at all ), and didn't do the install of mysql on this system, but now I have to figure out where things are and how to fix it. What I am use to, is installing on Red Hat with the rpm. ( if someone knows the differences in the operating systems and the setup of mysql, you can see why I am confused) The rpm is nice enough to put mysqld in the /etc/init.d and respective places on Red Hat The FreeBSD doesn't even have these locations, nor does it have a mysqld anywhere Assuming you are using the mysql port (ports/packages are FreeBSD's equivalent to RPMs. See http://www.freebsd.org/ports ), the startup scripts are in /usr/local/etc/rc.d, and mysqld lives in /usr/local/libexec. If you did not build using the port, then no startup scripts were installed and you'll probably have to run mysqld_safe yourself from /etc/rc.local. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problems finding parts of mysql on FreeBSD
020221 13:12:19 mysqld started 020221 13:12:20 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020221 13:12:20 mysqld ended also it would be important to note /etc/my.cnf [mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/tmcdbs01.mysql.pid ahh could be a permission problem, the directories require an executable tag correct? drw-rw 2 mysql mysql512 Jan 18 18:51 mysql -rw-rw 1 mysql mysql 0 Jan 18 18:45 host.MYD -rw-rw 1 mysql mysql 1024 Jan 18 18:45 host.MYI -rw-rw 1 mysql mysql 8958 Jan 18 18:45 host.frm -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 1:46 PM To: Luc Foisy Cc: MYSQL-List (E-mail) Subject: Re: Problems finding parts of mysql on FreeBSD In the last episode (Feb 21), Luc Foisy said: Ok. I do indeed have /usr/local/etc/rc.d/mysql-server.sh And oops I do have /usr/local/libexec/mysqld Are these supposed to be started up automatically? I tried to run /usr/local/etc/rc.d/mysql-server.sh start TMCBSD101# mysql-server.sh start mysql-server.sh: Command not found. TMCBSD101# ./mysql-server.sh start TMCBSD101# ps -ax TMCBSD101# mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) Take a look at /var/db/mysql/hostname.log and hostname.err; it looks like mysql might have exited immediately after it was started. /usr/local/bin/safe_mysqld -user=mysql /dev/null will load the mysql server. So why is this not performed at start up? And if this script is used, what is mysqld used for?? safe_mysqld calls mysqld and loops so that if mysqld died unexpectedly it is restarted. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php