RE: Trouble starting MySQL
People should really check /usr/ports/CHANGES after synchronising the ports tree. One of the entries in the file is: (there are also entries for the other mysql versions) 20041019: AFFECTS: users of databases/mysql41-server AUTHOR: [EMAIL PROTECTED] The MySQL Daemon must now be enabled / disabled in rc.conf. See the script for details. I hope this helps ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Firman Sent: woensdag 12 januari 2005 15:10 To: freebsd-questions@freebsd.org Subject: Re: Trouble starting MySQL On Wed, Jan 12, 2005 at 09:35:21AM -, Walker, Michael wrote: 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. snip Read /usr/loca/etc/rc.d/mysql-server.sh you now have to start mysqld from your rc.conf file. I am confused. I run FreeBSD 4.10 stable with mysql-server-4.0.21 installed from the ports. I have nothing in my rc.conf file for mysql, but I do have a /usr/local/etc/rc.d/mysql-server.sh file. When I rebooted the machine last month, mysql started without anything in the rc.conf file. Why? ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ 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
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Colin J. Raven Sent: Wednesday, January 12, 2005 9:30 AM To: FreeBSD Questions Subject: Trouble starting MySQL 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. snip Read /usr/loca/etc/rc.d/mysql-server.sh you now have to start mysqld from your rc.conf file. HTH Mick Walker ** This email and any files transmitted with it are confidential, and may be subject to legal privilege, and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error or think you may have done so, you may not peruse, use, disseminate, distribute or copy this message. Please notify the sender immediately and delete the original e-mail from your system. Computer viruses can be transmitted by e-mail. Recipients should check this e-mail for the presence of viruses. The Capita Group and its subsidiaries accept no liability for any damage caused by any virus transmitted by this e-mail. *** ___ 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
Colin J. Raven wrote: 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. Two other possible options appeared to present themselves: - Option number one: /usr/local/libexec/mysqld Which yielded this output: 050112 01:19:57 [ERROR] Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 050112 01:19:57 [ERROR] Aborting 050112 01:19:57 [Note] /usr/local/libexec/mysqld: Shutdown complete Well, I didn't find the manual onboard, and looking at *a* manual at: http://dev.mysql.com/doc/mysql/en/mysql-config-wizard-security.html hasn't (thus far) unlocked the cryptic nature of the warning above. - OK, option number two: /usr/local/bin/mysqld_safe Starts a mysql process but also steals the command prompt from that screen window, so obviously although I have a running instance of mysql this isn't the way to do it. This is the result BTW root93521 0.0 0.1 1652 1260 p2 I+ 10:22AM 0:00.02 /bin/sh /usr/local/bin/mysqld_safe mysql 93538 0.0 2.6 55596 26704 p2 S+ 10:22AM 0:00.17 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/ (rest of the output on the previous line is buried at the end of the screen which is annoying because I'd like to see what it is) Oh yes, there is a user and group mysql (the installer did that, not me) but there is no password for user mysql yet...dunno if it's necessary, but even if so, not done - yet. Guidance from those who have been there before would be greatly appreciated. Regards, -Colin -- Colin J. Raven FreeBSD 5.3-RELEASE - http://www.FreeBSD.org - There IS only One - OS Wed Jan 12 10:27:00 CET 2005 10:27AM up 2 days, 13:56, 6 users, load averages: 0.06, 0.47, 0.65 Did you added mysql_enable=YES to /etc/rc.conf? ___ 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
On Jan 12 at 09:35, Walker, Michael launched this into the bitstream: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Colin J. Raven Sent: Wednesday, January 12, 2005 9:30 AM To: FreeBSD Questions Subject: Trouble starting MySQL 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. snip Read /usr/loca/etc/rc.d/mysql-server.sh you now have to start mysqld from your rc.conf file. HTH Yes it *did* help, but are you saying therefore that to start mysql righeously you have to reboot the box? I don't know any other way to make the OS re-read rc.conf. Many thenks for the light-speed response!!! -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
you SHOULD set a password root but that's not the problem releated with this error. (mysqladmin -u root password 'yourpassword') it looks like your mysqld is not started trought.. mysqld_safe --user=mysql your should check this. hope this help, M Colin J. Raven wrote: 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. Two other possible options appeared to present themselves: - Option number one: /usr/local/libexec/mysqld Which yielded this output: 050112 01:19:57 [ERROR] Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 050112 01:19:57 [ERROR] Aborting 050112 01:19:57 [Note] /usr/local/libexec/mysqld: Shutdown complete Well, I didn't find the manual onboard, and looking at *a* manual at: http://dev.mysql.com/doc/mysql/en/mysql-config-wizard-security.html hasn't (thus far) unlocked the cryptic nature of the warning above. - OK, option number two: /usr/local/bin/mysqld_safe Starts a mysql process but also steals the command prompt from that screen window, so obviously although I have a running instance of mysql this isn't the way to do it. This is the result BTW root93521 0.0 0.1 1652 1260 p2 I+ 10:22AM 0:00.02 /bin/sh /usr/local/bin/mysqld_safe mysql 93538 0.0 2.6 55596 26704 p2 S+ 10:22AM 0:00.17 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/ (rest of the output on the previous line is buried at the end of the screen which is annoying because I'd like to see what it is) Oh yes, there is a user and group mysql (the installer did that, not me) but there is no password for user mysql yet...dunno if it's necessary, but even if so, not done - yet. Guidance from those who have been there before would be greatly appreciated. Regards, -Colin -- Colin J. Raven FreeBSD 5.3-RELEASE - http://www.FreeBSD.org - There IS only One - OS Wed Jan 12 10:27:00 CET 2005 10:27AM up 2 days, 13:56, 6 users, load averages: 0.06, 0.47, 0.65 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ 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
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. Ideas? ___ 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
Colin J. Raven wrote: 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. Ideas? This email has been scanned for all viruses by the MessageLabs SkyScan service. Did you added mysql_enable=YES to /etc/rc.conf? ** This email and any files transmitted with it are confidential, and may be subject to legal privilege, and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error or think you may have done so, you may not peruse, use, disseminate, distribute or copy this message. Please notify the sender immediately and delete the original e-mail from your system. Computer viruses can be transmitted by e-mail. Recipients should check this e-mail for the presence of viruses. The Capita Group and its subsidiaries accept no liability for any damage caused by any virus transmitted by this e-mail. *** ___ 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
On Jan 12 at 10:20, Walker, Michael then said: Colin J. Raven wrote: 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. Ideas? Did you added mysql_enable=YES to /etc/rc.conf? Yes, it's in there, as per your instructions :-) ___ 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 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
On Jan 12, 2005, at 4:23 AM, Colin J. Raven wrote: On Jan 12 at 10:20, Walker, Michael then said: Colin J. Raven wrote: 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. Ideas? Did you added mysql_enable=YES to /etc/rc.conf? Yes, it's in there, as per your instructions :-) That is *actually* supposed to be mysqld_enable=YES. You're missing the 'd'. If you read the script located in /usr/local/etc/rc.d, you'll see a comment of the exact line to add to your rc.conf file. To start a server without rebooting the system, simply type the following (this example is for mysqld): # /usr/local/etc/rc.d/mysqld.sh start HTH ___ Eric F Crist I am so smart, S.M.R.T! Secure Computing Networks -Homer J Simpson PGP.sig Description: This is a digitally signed message part
Re: Trouble starting MySQL
On Jan 12 at 05:09, Eric F Crist launched this into the bitstream: Did you added mysql_enable=YES to /etc/rc.conf? Yes, it's in there, as per your instructions :-) That is *actually* supposed to be mysqld_enable=YES. You're missing the 'd'. If you read the script located in /usr/local/etc/rc.d, you'll see a comment of the exact line to add to your rc.conf file. To start a server without rebooting the system, simply type the following (this example is for mysqld): # /usr/local/etc/rc.d/mysqld.sh start Umm, this is snipped directly from the script: # Add the following line to /etc/rc.conf to enable mysql: # mysql_enable (bool): Set to NO by default. # Set it to YES to enable MySQL. Is that wrong? *Should* it be mysqld_enable-YES within the script? If so, that's a kind of major oversight on the mysql/freebsd teams' part no? I am in the company of gurus so I should really keep my n00b trap (mostly) shut - as is usually the case :) -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
On Jan 12, 2005, at 5:22 AM, Colin J. Raven wrote: On Jan 12 at 05:09, Eric F Crist launched this into the bitstream: Did you added mysql_enable=YES to /etc/rc.conf? Yes, it's in there, as per your instructions :-) That is *actually* supposed to be mysqld_enable=YES. You're missing the 'd'. If you read the script located in /usr/local/etc/rc.d, you'll see a comment of the exact line to add to your rc.conf file. To start a server without rebooting the system, simply type the following (this example is for mysqld): # /usr/local/etc/rc.d/mysqld.sh start Umm, this is snipped directly from the script: # Add the following line to /etc/rc.conf to enable mysql: # mysql_enable (bool): Set to NO by default. # Set it to YES to enable MySQL. Is that wrong? *Should* it be mysqld_enable-YES within the script? If so, that's a kind of major oversight on the mysql/freebsd teams' part no? I am in the company of gurus so I should really keep my n00b trap (mostly) shut - as is usually the case :) -Colin I would check the /var/log/messages log file for anything related to mysql, in this case. There's a reason it won't start, and it'll be indicated there. My bad on the syntax. After looking, I have a script called mysql-server.sh that doesn't require an entry in rc.conf. What version of mysql are you using? Was it installed from ports? What version of FreeBSD? Thanks. ___ Eric F Crist I am so smart, S.M.R.T! Secure Computing Networks -Homer J Simpson PGP.sig Description: This is a digitally signed message part
Re: Trouble starting MySQL
On Jan 12 at 05:36, Eric F Crist then said: On Jan 12, 2005, at 5:22 AM, Colin J. Raven wrote: I would check the /var/log/messages log file for anything related to mysql, in this case. There's a reason it won't start, and it'll be indicated there. There is nothing related to mysql in /var/log/messages - which now I come to think about it is odd. My bad on the syntax. After looking, I have a script called mysql-server.sh that doesn't require an entry in rc.conf. What version of mysql are you using? Was it installed from ports? What version of FreeBSD? No problem :) mysql-4.1.7 installed from ports FreeBSD 5.3-RELEASE -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
On Jan 12 at 12:46, I said: PHP 4.3.10 (cli) (built: Jan 11 2005 23:15:42) (DEBUG) mysql-4.1.7 both installed from ports FreeBSD 5.3-RELEASE When I take a look at a phpinfo page, it shows no mention that MySQL exists. AFAIK this ought not to be so. I installed php last night (again, from ports) and remembered that there oughtta be support for mysql. So this is how I built php, though now I'm wondering if I installed it correctly since it seems braindead to the existence of MySQL make with-mysql=yes install clean I'm beginning not to enjoy today at all (: Pointers would be gratefully received. -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
On Wed, Jan 12, 2005 at 09:35:21AM -, Walker, Michael wrote: 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. snip Read /usr/loca/etc/rc.d/mysql-server.sh you now have to start mysqld from your rc.conf file. I am confused. I run FreeBSD 4.10 stable with mysql-server-4.0.21 installed from the ports. I have nothing in my rc.conf file for mysql, but I do have a /usr/local/etc/rc.d/mysql-server.sh file. When I rebooted the machine last month, mysql started without anything in the rc.conf file. Why? ___ 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
[EMAIL PROTECTED] wrote: On Jan 12 at 12:46, I said: PHP 4.3.10 (cli) (built: Jan 11 2005 23:15:42) (DEBUG) mysql-4.1.7 both installed from ports FreeBSD 5.3-RELEASE When I take a look at a phpinfo page, it shows no mention that MySQL exists. AFAIK this ought not to be so. I installed php last night (again, from ports) and remembered that there oughtta be support for mysql. So this is how I built php, though now I'm wondering if I installed it correctly since it seems braindead to the existence of MySQL make with-mysql=yes install clean I'm beginning not to enjoy today at all (: Pointers would be gratefully received. -Colin ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] This email has been scanned for all viruses by the MessageLabs SkyScan service. I don't have a FreeBSD box at work with me at the moment. But check out the following (Im assuming one to be correct) /usr/ports/lang/php-extentions /usr/ports/lang/php4-extentions If both are wrong, it is somewhere very similar. HTH Mick Walker ** This email and any files transmitted with it are confidential, and may be subject to legal privilege, and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error or think you may have done so, you may not peruse, use, disseminate, distribute or copy this message. Please notify the sender immediately and delete the original e-mail from your system. Computer viruses can be transmitted by e-mail. Recipients should check this e-mail for the presence of viruses. The Capita Group and its subsidiaries accept no liability for any damage caused by any virus transmitted by this e-mail. *** ___ 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
On Jan 12 at 14:12, Walker, Michael said (somewhat confusingly): [EMAIL PROTECTED] wrote: On Jan 12 at 12:46, I said: PHP 4.3.10 (cli) (built: Jan 11 2005 23:15:42) (DEBUG) mysql-4.1.7 both installed from ports FreeBSD 5.3-RELEASE When I take a look at a phpinfo page, it shows no mention that MySQL exists. AFAIK this ought not to be so. I installed php last night (again, from ports) and remembered that there oughtta be support for mysql. So this is how I built php, though now I'm wondering if I installed it correctly since it seems braindead to the existence of MySQL make with-mysql=yes install clean I don't have a FreeBSD box at work with me at the moment. But check out the following (Im assuming one to be correct) /usr/ports/lang/php-extentions /usr/ports/lang/php4-extentions If both are wrong, it is somewhere very similar. I'm sorry, you probably think I'm being dense... but I (honestly) don't understand what you mean. Do you mean that one (or other, or both) must *also* be installed for php to have any clue that MySQL exists? A colleague has an identical setup and - AFAIK - didn't install either one on this or prior installations of FreeBSD/MySQL/php. If this is a dense and utterly silly question then please excuse the braindead nature of it. Today has been a long and frustrating day. Thanks for the ongoing help and advice -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
Hi Colin, I missed part of the thread, so I'm sorry if I'm dead wrong here. Do you mean that one (or other, or both) must *also* be installed for php to have any clue that MySQL exists? You need php4-mysql for that. php4-extensions is a meta-port. Read the pkg-descr in /usr/ports/lang/php4-extensions/. php4-extensions will install php4-mysql for you. HTH... Nico ___ 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
- Original Message - From: Colin J. Raven [EMAIL PROTECTED] To: Walker, Michael [EMAIL PROTECTED] Cc: Freebsd-Questions (E-mail) freebsd-questions@freebsd.org Sent: Wednesday, January 12, 2005 6:25 AM Subject: RE: Trouble starting MySQL On Jan 12 at 14:12, Walker, Michael said (somewhat confusingly): [EMAIL PROTECTED] wrote: On Jan 12 at 12:46, I said: PHP 4.3.10 (cli) (built: Jan 11 2005 23:15:42) (DEBUG) mysql-4.1.7 both installed from ports FreeBSD 5.3-RELEASE When I take a look at a phpinfo page, it shows no mention that MySQL exists. AFAIK this ought not to be so. I installed php last night (again, from ports) and remembered that there oughtta be support for mysql. So this is how I built php, though now I'm wondering if I installed it correctly since it seems braindead to the existence of MySQL make with-mysql=yes install clean I don't have a FreeBSD box at work with me at the moment. But check out the following (Im assuming one to be correct) /usr/ports/lang/php-extentions /usr/ports/lang/php4-extentions If both are wrong, it is somewhere very similar. I'm sorry, you probably think I'm being dense... but I (honestly) don't understand what you mean. Do you mean that one (or other, or both) must *also* be installed for php to have any clue that MySQL exists? yes and its /usr/ports/lang/php4-extentions when you run make install it will give you a listing of all the extions that you can install for php just slect mysql from the list A colleague has an identical setup and - AFAIK - didn't install either one on this or prior installations of FreeBSD/MySQL/php. Before i updated php to 4.3.10 i didnt have to any of the extions installed for my setup to work . then after i upgraded php i had all kinds of issues nuthing worked,I found out that for 4.3.10 to work the way i whanted it to i had to install just about every extion in the list. along with recompiling php its self to inable the extions that i needed. If this is a dense and utterly silly question then please excuse the braindead nature of it. not at all. Today has been a long and frustrating day. Thanks for the ongoing help and advice -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
On Jan 12 at 15:41, Nico Meijer launched this into the bitstream: Hi Colin, I missed part of the thread, so I'm sorry if I'm dead wrong here. Do you mean that one (or other, or both) must *also* be installed for php to have any clue that MySQL exists? You need php4-mysql for that. php4-extensions is a meta-port. Read the pkg-descr in /usr/ports/lang/php4-extensions/. php4-extensions will install php4-mysql for you. Hey Nico, long time, no see! Happy New Year. OK, I installed php4-extensions and it made precisely zero difference (selected every-damn-thing-on-the-list) I have *no* idea what to do next, none. As far as I can see, phpinfo.php shows no sign of MySQL. Thus, I assume php is still braindead to the existence of MySQL. (I restarted MySQL before running phpinfo.php again just in case) [mumble] ___ 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
Hi Colin, Hey Nico, long time, no see! Happy New Year. Ah, indeed! It took a while, but now my brain said click!. Same to you, thanks. Hope you are well (apart from the php/mysql problem) I have *no* idea what to do next, none. As far as I can see, phpinfo.php shows no sign of MySQL. Thus, I assume php is still braindead to the existence of MySQL. (I restarted MySQL before running phpinfo.php again just in case) I'll read the entire thread later tonight, but just in case: have you copied an example php.ini (-dist or -recommended) over your existing (/usr/local/etc/)php.ini (if there is one, dunno right now; back it up first). HTH... Nico ___ 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
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Colin J. Raven Sent: Wednesday, January 12, 2005 9:30 AM To: FreeBSD Questions Subject: Trouble starting MySQL 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 or some such or you may need to set execute permission on the /usr/loca/etc/rc.d/mysql-server.sh file - some ports seem to install it without execute to start so you can do your own tinkering before actually running it or some such thing. jerry snip Read /usr/loca/etc/rc.d/mysql-server.sh you now have to start mysqld from your rc.conf file. No No No. I don't see anything like that and it would be wrong - against the way the system works. HTH Mick Walker ** This email and any files transmitted with it are confidential, and may be subject to legal privilege, and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error or think you may have done so, you may not peruse, use, disseminate, distribute or copy this message. Please notify the sender immediately and delete the original e-mail from your system. Computer viruses can be transmitted by e-mail. Recipients should check this e-mail for the presence of viruses. The Capita Group and its subsidiaries accept no liability for any damage caused by any virus transmitted by this e-mail. *** ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ 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]
Re: Trouble starting MySQL
On Jan 12, 2005, at 5:46 AM, Colin J. Raven wrote: On Jan 12 at 05:36, Eric F Crist then said: On Jan 12, 2005, at 5:22 AM, Colin J. Raven wrote: I would check the /var/log/messages log file for anything related to mysql, in this case. There's a reason it won't start, and it'll be indicated there. There is nothing related to mysql in /var/log/messages - which now I come to think about it is odd. My bad on the syntax. After looking, I have a script called mysql-server.sh that doesn't require an entry in rc.conf. What version of mysql are you using? Was it installed from ports? What version of FreeBSD? No problem :) mysql-4.1.7 installed from ports FreeBSD 5.3-RELEASE If you haven't changed your syslog.conf file, you should have a /var/log/all.log. Take a look in there to see if you see anything related to mysql. ___ Eric F Crist I am so smart, S.M.R.T! Secure Computing Networks -Homer J Simpson PGP.sig Description: This is a digitally signed message part
Re: Trouble starting MySQL
On Jan 12 at 10:28, Eric F Crist said: mysql-4.1.7 installed from ports FreeBSD 5.3-RELEASE If you haven't changed your syslog.conf file, you should have a /var/log/all.log. Take a look in there to see if you see anything related to mysql. This is interesting. No I didn't change syslog.conf in any way (don't know enough to know what to change, nor why). But, that said, there's *no* /var/log/all.log. It doesn't exist. However, as you may see from another post I sent up a short time ago, this is solved and all is well. Everything appears to be working as it should. I won't say; is working that's pushing things a bit, instead appears to be working is much better!! :-) As I said in the [SOLVED] [CLOSED] post, many MANY thanks for the help during the course of this day. I've lost count of the number of people who have jumped in and tried to get me up and running. Regards, -Colin -- Colin J. Raven FreeBSD 5.3-RELEASE - http://www.FreeBSD.org - There can be only One Wed Jan 12 17:36:00 CET 2005 5:36PM up 6:24, 6 users, load averages: 0.01, 0.01, 0.00 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]