RE: Trouble starting MySQL [SOLVED?]
On Jan 12 at 11:17, Colin J. Raven launched this into the bitstream: On Jan 12 at 09:35, Walker, Michael suggested: I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error message is emitted, but no running instance of mysql either. snip Read /usr/loca/etc/rc.d/mysql-server.sh you now have to start mysqld from your rc.conf file. OK, I added the necessary stuff to /etc/rc.conf and attempted to start mysql via the mysql-server.sh script. Nothing doing. I rebooted the box, checked to see if mysql was running. It wasn't. I attempted once more to start it from the script - Nothing. OK, I'm back to where I started. BUT I pulled up webmin | Servers | MySQL Server adjusted paths to where stuff lives, hit Start MySQL Server and seemingly MySQL is now running. To wit: root 1329 0.0 0.1 1652 1208 ?? I11:26AM 0:00.01 /bin/sh /usr/local/bin/mysqld_safe --user=mysql mysql1347 0.0 2.5 55852 25832 ?? S11:26AM 0:00.14 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/ colin1359 0.0 0.1 1476 896 p2 S+ 11:26AM 0:00.00 grep mysql Good, but I'm just puzzled why/how this worked from webmin. It doesn't make sense. One thing, it started mysql as can be seen above from /usr/local/bin/mysqld_safe, which sure 'aint the script way. Then again, the script way from CLI didn't work. sigh -Colin ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Trouble starting MySQL [SOLVED?]
On Wed, Jan 12, 2005 at 11:33:21AM +0100, Colin J. Raven wrote: On Jan 12 at 11:17, Colin J. Raven launched this into the bitstream: On Jan 12 at 09:35, Walker, Michael suggested: I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error message is emitted, but no running instance of mysql either. snip Read /usr/loca/etc/rc.d/mysql-server.sh you now have to start mysqld from your rc.conf file. OK, I added the necessary stuff to /etc/rc.conf and attempted to start mysql via the mysql-server.sh script. Nothing doing. I rebooted the box, checked to see if mysql was running. It wasn't. I attempted once more to start it from the script - Nothing. OK, I'm back to where I started. BUT I pulled up webmin | Servers | MySQL Server adjusted paths to where stuff lives, hit Start MySQL Server and seemingly MySQL is now running. To wit: root 1329 0.0 0.1 1652 1208 ?? I11:26AM 0:00.01 /bin/sh /usr/local/bin/mysqld_safe --user=mysql mysql1347 0.0 2.5 55852 25832 ?? S11:26AM 0:00.14 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/ colin1359 0.0 0.1 1476 896 p2 S+ 11:26AM 0:00.00 grep mysql Good, but I'm just puzzled why/how this worked from webmin. It doesn't make sense. One thing, it started mysql as can be seen above from /usr/local/bin/mysqld_safe, which sure 'aint the script way. Then again, the script way from CLI didn't work. sigh I hear your frustration. I was asking about this on Dec. 18, 2004 and I did not get any answers. Look at this: http://lists.freebsd.org/pipermail/freebsd-questions/2004-December/068425.html I am still confused about /usr/local/etc/rc.d vs /etc/rc.conf. Can anyone educate us how this works on FreeBSD 4.10? I have nothing in rc.conf pertaining to mysql, but the mysql server starts just fine when I boot my FreeBSD 4.10 stable box? mysql-server-4.0.21 installed from ports. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Trouble starting MySQL [SOLVED?]
/usr/local/bin/mysqld_safe --user=mysql mysql1347 0.0 2.5 55852 25832 ?? S11:26AM 0:00.14 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/ colin1359 0.0 0.1 1476 896 p2 S+ 11:26AM 0:00.00 grep mysql Good, but I'm just puzzled why/how this worked from webmin. It doesn't make sense. One thing, it started mysql as can be seen above from /usr/local/bin/mysqld_safe, which sure 'aint the script way. Then again, the script way from CLI didn't work. sigh I hear your frustration. I was asking about this on Dec. 18, 2004 and I did not get any answers. Look at this: http://lists.freebsd.org/pipermail/freebsd-questions/2004-December/068425.html I am still confused about /usr/local/etc/rc.d vs /etc/rc.conf. Can anyone educate us how this works on FreeBSD 4.10? The only thing you should possibly have in /etc/rc.conf or maybe /etc/rc.conf.local are setting variables. Most things do not even need that. Do not _execute_ anything from rc.conf for startups. All startups should be in scripts in /usr/local/etc/rc.d. The main startup executes every script in /usr/local/etc/rc.d that ends in '.sh' and has execute permission set. I think the order is alphabetic sort order. Make your script take a 'start' as its first argument. Besides, most installs for ports put a usefully functioning xxx.sh startup script in /usr/local/etc/rc.d when you do the install. For some you have to change the permissions to allow it to execute. Check in the ports xxx.sh script to see how it starts and if you need to set any environment variables or change any addresses. This is all well documented if you look. jerry I have nothing in rc.conf pertaining to mysql, but the mysql server starts just fine when I boot my FreeBSD 4.10 stable box? mysql-server-4.0.21 installed from ports. ___ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Trouble starting MySQL [SOLVED] [CLOSED]
Earlier today I said: Greetings all, I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error message is emitted, but no running instance of mysql either. You may need to set a variable in /etc/rc.conf such as: MySQL=YES mysql_enable=yes That is mentioned in /usr/loca/etc/rc.d/mysql-server.sh It is now in /etc/rc.conf That however didn't solve the problem - or as far as I am or was aware. Instead I started the MySQL server from Webmin and it's running just fine. The next issue was getting php to recognize the existence of MySQL. Several steps later this is in essence what was done: I deinstalled php4 and also php4-extensions. Stopped httpd altogether. Reinstalled php4 and as many extensions as possible (although some libmagic thing halted the 100% installation of the extensions, so I sent debug info to the maintainer as directed by screen output) The reinstall was unremarkable, in that nothing that I could see varied from the first time out - OTHER THAN - as said, the halt in extensions that didn't happen first time. Restarted httpd and puled up a phpinfo.php page and suddenly there was some mention of mysql for the first time. I just don't have any clue what I did; a) wrongly at first and then b) correctly later So it *seems* matters are resolved, although I'm not 100% certain. I assume it's solved because phpinfo displays awareness of MySQL. Warm thanks to one and all who have jumped in on this today, it's now solved and closed (for the archives, that is) This wouldn't have happened without the list crew. Until the next problem then Regards, -Colin -- Colin J. Raven FreeBSD 5.3-RELEASE - http://www.FreeBSD.org - There can be only One Wed Jan 12 17:24:00 CET 2005 5:24PM up 6:12, 6 users, load averages: 0.00, 0.00, 0.00 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]