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. 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]
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]
apache1.3 mysql and php
I'd like to give phpBB (kind of a php driven userboard) a change. This means I'll have to change my apache 1.3.33 server into a PHP, MySQL Apache1.3.33 server. I will do the reading, but I appreciate some links on how to set up this combination from ports. I googled but got lost in the information _not_ exactly being what I looked for ;-( -- dick -- http://www.nagual.st/ -- PGP/GnuPG key: F86289CE ++ Running FreeBSD 4.10 ++ Debian GNU/Linux (Woody) + Nai tiruvantel ar vayuvantel i Valar tielyanna nu vilja ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
MySQL
From: Joshua Lokken [EMAIL PROTECTED] Date: Wed, 5 Jan 2005 18:16:40 -0600 Subject: Re: MySQL To: Leon [EMAIL PROTECTED] Cc: Questions freebsd-questions@freebsd.org On Wed, 05 Jan 2005 16:03:08 -0500, Leon [EMAIL PROTECTED] wrote: Hi, I have a 5.3 version of FreeBSD. I want to install MySQL Can you please tell me what version of MySQL I should install? And where can I get installation and configuration instruction? Thanks, Leon. While I certainly don't mind being mailed off-list, I'll assume that you intended to submit this question to the FreeBSD questions mailing list. I have forwarded it appropriately. I would recommend you use the ports collection to install MySQL and any other software that you need. In order to ensure that you have the most recent ports collection, you should learn to use cvsup. There is excellent information on this in the Handbook: http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/ports-using.html http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/cvsup.html I believe that versions 3.23, 4.0, 4.1, and even a version of 5 of MySQL exist in the ports collection. I have experience only with 4.1, so I can't attest to which you _should_ use, also I don't know what your intended use is, but 4.1 should be just fine. Once you have the ports collection up-to-date, you can install MySQL by doing: # cd /usr/ports/databases/mysql41-server # make install clean HTH, -- Joshua Lokken Open Source Advocate ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
migrating from mysql 4.0 to 4.1 best practice?
Hi All, What is the best practice to upgrade from Mysql 4.0.X to 4.1.X, using the ports system naturally? I have searched, but not come up with any definitive solutions. Is the solution to backup, un-install, then install the other? Please cc, as I'm not subscribed to questions. Thanks, -Jev ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: migrating from mysql 4.0 to 4.1 best practice?
Hi All, What is the best practice to upgrade from Mysql 4.0.X to 4.1.X, using the ports system naturally? I have searched, but not come up with any definitive solutions. Is the solution to backup, un-install, then install the other? I've followed this documentation with success: http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html -- Regards, Doug ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Problems with MySQL and SNORT after Reboot
Hi,
Thanks for the fast response.
I did run REPAIR TABLE event from phpmyadmin and there where no
problems with that. No Error here.
But when I point my browser to my snort page and select the timeframe
for the alerts to all I get the error message after a few seconds:
Warning: mysql_query(): Unable to save result set in
/usr/local/www/snortreport/DB_mysql.php on line 38
Got error 127 from table handler
However if i select a day as a time frame it works and I can select up
to forteen days. If i select thirty days or every thing logged I get the
error above.
From phpmyadmin if I select the database named snort and I click on
the table event i get an warning/error message that are as following:
More than one INDEX key was created for column `timestamp`
Is that anything serious?
So I hope I have described enought to make any conclutions about this. I
have also restared both mysql and snort but that does not help either.
Thanks in advance and a happy new year!
Hello,
You need to login to mysql command prompt and do a REPAIR TABLE event; in
that database, and it will clear it right up.
Sincerely,
Scott Kupferschmidt
ISPrime, Inc.
866.502.4678 ext. 3
AIM: Scott ISPrime - ICQ: 174337249
On Fri, 31 Dec 2004, [ISO-8859-1] Mattias Björk wrote:
Dear list,
After a power failure and my computers went down, I have been starting
to get error messages in sys log and on the console:
Dec 28 19:50:52 setiathome snort: database: mysql_error: Can't open
file: 'event.MYI'. (errno: 145) SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '10', '4', '2004-12-28
19:50:52.597+001')
Im not an expert on SQL and database servers etc and have followed this
guide to make snort work with MySQL:
http://bsdguides.org/guides/freebsd/security/snortreport.php
I didn't find that too hard and it worked when I did it some months ago.
But now after the reboot/restart of the system, the fault that I
described abow have arised. I have had similar power failures before and
that did not create this problem.
And I have checked in /var/db/mysql/snort after the file event.MYI and
its there:
setiathome/var/db/mysql/snort# ls -l event.* 9:35PM
-rw-rw 1 mysql mysql 560343 Dec 28 13:27 event.MYD
-rw-rw 1 mysql mysql 1786880 Dec 28 16:38 event.MYI
-rw-rw 1 mysql mysql 8642 Nov 13 18:29 event.frm
setiathome/var/db/mysql/snort#
So Im clueless to what could be causing the problem that I have. Perhaps
its the wrong list to send this mail. But I thought that its the closest
that I could think off.
Best regards Mattias Björk
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to
[EMAIL PROTECTED]
Best regards Mattias Björk
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Problems with MySQL and SNORT after Reboot
Dear list,
After a power failure and my computers went down, I have been starting
to get error messages in sys log and on the console:
Dec 28 19:50:52 setiathome snort: database: mysql_error: Can't open
file: 'event.MYI'. (errno: 145) SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '10', '4', '2004-12-28
19:50:52.597+001')
Im not an expert on SQL and database servers etc and have followed this
guide to make snort work with MySQL:
http://bsdguides.org/guides/freebsd/security/snortreport.php
I didn't find that too hard and it worked when I did it some months ago.
But now after the reboot/restart of the system, the fault that I
described abow have arised. I have had similar power failures before and
that did not create this problem.
And I have checked in /var/db/mysql/snort after the file event.MYI and
its there:
setiathome/var/db/mysql/snort# ls -l event.* 9:35PM
-rw-rw 1 mysql mysql 560343 Dec 28 13:27 event.MYD
-rw-rw 1 mysql mysql 1786880 Dec 28 16:38 event.MYI
-rw-rw 1 mysql mysql 8642 Nov 13 18:29 event.frm
setiathome/var/db/mysql/snort#
So Im clueless to what could be causing the problem that I have. Perhaps
its the wrong list to send this mail. But I thought that its the closest
that I could think off.
Best regards Mattias Björk
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Problems with MySQL and SNORT after Reboot
Hello,
You need to login to mysql command prompt and do a REPAIR TABLE event; in
that database, and it will clear it right up.
Sincerely,
Scott Kupferschmidt
ISPrime, Inc.
866.502.4678 ext. 3
AIM: Scott ISPrime - ICQ: 174337249
On Fri, 31 Dec 2004, [ISO-8859-1] Mattias Björk wrote:
Dear list,
After a power failure and my computers went down, I have been starting
to get error messages in sys log and on the console:
Dec 28 19:50:52 setiathome snort: database: mysql_error: Can't open
file: 'event.MYI'. (errno: 145) SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '10', '4', '2004-12-28
19:50:52.597+001')
Im not an expert on SQL and database servers etc and have followed this
guide to make snort work with MySQL:
http://bsdguides.org/guides/freebsd/security/snortreport.php
I didn't find that too hard and it worked when I did it some months ago.
But now after the reboot/restart of the system, the fault that I
described abow have arised. I have had similar power failures before and
that did not create this problem.
And I have checked in /var/db/mysql/snort after the file event.MYI and
its there:
setiathome/var/db/mysql/snort# ls -l event.* 9:35PM
-rw-rw 1 mysql mysql 560343 Dec 28 13:27 event.MYD
-rw-rw 1 mysql mysql 1786880 Dec 28 16:38 event.MYI
-rw-rw 1 mysql mysql 8642 Nov 13 18:29 event.frm
setiathome/var/db/mysql/snort#
So Im clueless to what could be causing the problem that I have. Perhaps
its the wrong list to send this mail. But I thought that its the closest
that I could think off.
Best regards Mattias Björk
___
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]
mysql setup question
I'm running 4.10 stable. I copied /usr/local/share/mysql/my-medium.cnf to /etc/my.cnf. I uncommented the lines about innodb and restarted mysqld by running /usr/local/etc/rc.d/mysql-server.sh I'm running a web server that accesses a mysql database. Is there a way that I can verify that mysql is using /etc/my.cnf? Also does this seem like the correct procedure for running mysql with a web server? Bob -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.6.3 - Release Date: 12/21/2004 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
bind+postfix+courier+sals+amavis+spamassian+pop3+mysql+apache+smtp-auth
Hmmzz yep, I want to do this but my packet version conflicted.. FreeBSD 5.3 stable Mysql-server-5.0.1 Bind9-9.3.0 (for only dns cahe) Postfix-2.2.20041008,2 (also for GUI postfix-admin) Courier-Imap-3.0.8.1 Cyrus-sasl-2.1.20 Apache-2.0.52_3 Amavisd (clamav + spamassassin) Sqwebmail (for webmail and also very important that is user must be change his/her passwd) I saw openwebmail its very nice but passwd change options hasnt been in packet so I give up using this. why all packet is conflict each other I couldnt understantd A lots of virtual host and I must find POP3 competible with courier-imap and also very very important point is SMTP-AUTH in POP3 for virtual users and quota for virtual user and they can be change their passwd from webmail. and also I had look a lots of document such as http://www.high5.net/howto/ http//yocum.org/faqs/postfix-tls-sasl.html http://www.delouw.ch/linux/Postfix-Cyrus-Web-cyradm-HOWTO/Postfix-Cyrus-Web-cyradm-HOWTO.pdf shortly I have a lots of virual user that must reach webmail also POP3 and prevent their mailbox from spam and virus and also they must change own passwd and pop3 deamond must be smtp-aut depens on their username and passwd. AND also my stafff may manage webtools (with GUI) they can create new virtual user and may give quota and aliases virtusertable etc...and important point I dont want to use sendmail. :(( On Sat, 18 Dec 2004 21:27:12 +0100, martin hudec [EMAIL PROTECTED] wrote: Hello, On Sat, Dec 18, 2004 at 10:10:22PM +0200 or thereabouts, tethys ocean wrote: I set that but I need pop3 because we have got a lots of virtual host I must look for pop3 competible with courier-imap isnt it?! courier-imap is able to serve its maildirs (no, not mbox) using IMAP and POP3, both with secure variants. You can use mysql as authentication backend with sasl. I am using this solution with postfix as smtp server (also with user and virtual data in mysql), amavisd (clamav + spamassassin) as spam/virus filter. I am just bit sad that openwebmail is not working with maildirs, so I use horde/imp application instead to provide webmail services. Cheers, Martin -- martin hudec * 421 907 303 393 * [EMAIL PROTECTED] * http://www.aeternal.net Nothing travels faster than the speed of light with the possible exception of bad news, which obeys its own special laws. Douglas Adams, The Hitchhiker's Guide to the Galaxy ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
bind+postfix+courier+sals+amavis+spamassian+pop3+mysql+apache+smtp-auth
Hi all, I want to setup a mail server Freebsd 5.3 bind 9.0 (dnscahce) +mysql4.0+postfix2.2.20040829,2+courier+sasl etc in the beginning of my installation I am taking such error message courier-mysql-0.45.4 conflicts with installed pakages(s) postfix-2.2.20040829,2 They install files into the same places. Please remover.. What can I do? I looked a lots of document but I coulnt actual solutions.. any comment?! Thanks a lots ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
bind+postfix+courier+sals+amavis+spamassian+pop3+mysql+apache+smtp-auth
Hello, On Sat, Dec 18, 2004 at 09:38:52PM +0200 or thereabouts, tethys ocean wrote: I want to setup a mail server Freebsd 5.3 bind 9.0 (dnscahce) +mysql4.0+postfix2.2.20040829,2+courier+sasl etc in the beginning of my installation I am taking such error message courier-mysql-0.45.4 conflicts with installed pakages(s) postfix-2.2.20040829,2 you want probably to have complex mail solution, and you would like to use mail/courier-imap port, right? Standard mail/courier can be used as smtp server, so it is obvious that it would conflict with your installed postfix (or qmail, etc.). Look into Makefile for conflicting packages. Cheers, Martin -- martin hudec * 421 907 303 393 * [EMAIL PROTECTED] * http://www.aeternal.net Nothing travels faster than the speed of light with the possible exception of bad news, which obeys its own special laws. Douglas Adams, The Hitchhiker's Guide to the Galaxy pgpsICg8qIIfG.pgp Description: PGP signature
bind+postfix+courier+sals+amavis+spamassian+pop3+mysql+apache+smtp-auth
Hi, I check confiliction package mysql pakages confilict and I found this document http://www.syntheticzero.com/howto/vmail.php and also in this paragraph Notes for FreeBSD users: The courier-imap port in freebsd is kinda messed up with regards to getting the mysql auth stuff to compile... find .if !defined(WITH_MYSQL) in the Makefile and change this: PLIST_SUB+= MYSQLFLAG= endif to this: PLIST_SUB+= MYSQLFLAG= CONFIGURE_ARGS+= \ --with-authmysql --with-mysql-libs=/usr/local/lib/mysql/ \ --with-mysql-includes=/usr/local/include/mysql endif I set that but I need pop3 because we have got a lots of virtual host I must look for pop3 competible with courier-imap isnt it?! H.O. On Sat, 18 Dec 2004 20:58:21 +0100, martin hudec [EMAIL PROTECTED] wrote: Hello, On Sat, Dec 18, 2004 at 09:38:52PM +0200 or thereabouts, tethys ocean wrote: I want to setup a mail server Freebsd 5.3 bind 9.0 (dnscahce) +mysql4.0+postfix2.2.20040829,2+courier+sasl etc in the beginning of my installation I am taking such error message courier-mysql-0.45.4 conflicts with installed pakages(s) postfix-2.2.20040829,2 you want probably to have complex mail solution, and you would like to use mail/courier-imap port, right? Standard mail/courier can be used as smtp server, so it is obvious that it would conflict with your installed postfix (or qmail, etc.). Look into Makefile for conflicting packages. Cheers, Martin -- martin hudec * 421 907 303 393 * [EMAIL PROTECTED] * http://www.aeternal.net Nothing travels faster than the speed of light with the possible exception of bad news, which obeys its own special laws. Douglas Adams, The Hitchhiker's Guide to the Galaxy ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
recover from var deletion; mysql apache
Hello, 4.10-PRERELEASE FreeBSD 4.10-PRERELEASE #0: Mon May 3 16:59:48 PDT 2004 I am working to recover a computer whose /var filesystem, a separate mount point, was entirely deleted. I've put in a new /var using mergemaster, and I'm now trying to restore the mysql databases from dumps. With the original /var/db/mysql gone I've tried making a new one, but when I do something like sudo mysql mysql mySQL.mysql.dump I get an error of ERROR 1049: Unknown database 'mysql' I'm unable to create an empty 'mysql'. How can I reinitialize mysql to the state that I can use my dump files to restore the system? Also, although the web server is up and running, trying to use apachectl gives the following error, /usr/libexec/ld-elf.so.1: Shared object libmm.so.13 not found I have a similar error from vim. Can anyone help me with this? thanks, -- Sean ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
bind+postfix+courier+sals+amavis+spamassian+pop3+mysql+apache+smtp-auth
Hello, On Sat, Dec 18, 2004 at 10:10:22PM +0200 or thereabouts, tethys ocean wrote: I set that but I need pop3 because we have got a lots of virtual host I must look for pop3 competible with courier-imap isnt it?! courier-imap is able to serve its maildirs (no, not mbox) using IMAP and POP3, both with secure variants. You can use mysql as authentication backend with sasl. I am using this solution with postfix as smtp server (also with user and virtual data in mysql), amavisd (clamav + spamassassin) as spam/virus filter. I am just bit sad that openwebmail is not working with maildirs, so I use horde/imp application instead to provide webmail services. Cheers, Martin -- martin hudec * 421 907 303 393 * [EMAIL PROTECTED] * http://www.aeternal.net Nothing travels faster than the speed of light with the possible exception of bad news, which obeys its own special laws. Douglas Adams, The Hitchhiker's Guide to the Galaxy pgpaOGqdKLD0F.pgp Description: PGP signature
Re: recover from var deletion; mysql apache
On Sat, Dec 18, 2004 at 12:20:27PM -0800, Sean Ellis wrote: I am working to recover a computer whose /var filesystem, a separate mount point, was entirely deleted. sudo mysql mysql mySQL.mysql.dump I get an error of ERROR 1049: Unknown database 'mysql' Also, although the web server is up and running, trying to use apachectl gives the following error, /usr/libexec/ld-elf.so.1: Shared object libmm.so.13 not found mysql is now cooperating after running mysql_install_db and then being restarted, . But I am left with these other errors (apachectl etc). I do not want restart apache before clearing this up. Any suggestions? -- thanks, Sean ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: recover from var deletion; mysql apache
On Sat, Dec 18, 2004 at 01:26:13PM -0800, Sean Ellis wrote: On Sat, Dec 18, 2004 at 12:20:27PM -0800, Sean Ellis wrote: /usr/libexec/ld-elf.so.1: Shared object libmm.so.13 not found mysql is now cooperating after running mysql_install_db and then being restarted, . But I am left with these other errors (apachectl etc). I do not want restart apache before clearing this up. Any suggestions? Running ldconfig cleared up the shared object errors. -- cheers, Sean ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: postfix mysql 4.0.22
did you also try WITH_MYSQL_VER=4 ? It's pretty uncommon that one has to include the minor version if building a port ... Cristi Tauber schrieb: Hello people, I have a little problem setting up postfix with mysql. My ports.cvs looks like this : madalina# cat /root/ports.cvs *default host=cvsup7.freebsd.org *default base=/usr *default prefix=/usr *default release=cvs tag=. *default compress *default delete use-rel-suffix ports-all - I cvsup'ed to get the latest ports. I installed mysql server 4.0.22. Now i try to install postfix with mysql backend. So : cd /usr/ports/mail/postfix make install and i get this error : === Installing for mysql-client-3.23.58_3 === mysql-client-3.23.58_3 conflicts with installed package(s): mysql-client-4.0.22 They install files into the same place. Please remove them first with pkg_delete(1). *** Error code 1 but i got mysql 4.0.22 not 3.xx so i try with this : make install WITH_MYSQL_VER=4.0.22 but i get ... === postfix-2.1.5_1,1 is marked as broken: unknown MySQL version: 4.0.22. the same happens with postfix-current . What's wrong with my installation ? Thank you, Cristi --- This message and its contents have been scanned and certified for transmission as being free from malicious code by eTrust Antivirus. This message may contain confidential, privileged or other legally protected information. It is intended for the addressee(s) only. If you are not the addressee, or someone the addressee authorized to receive this message, you are prohibited from copying, distributing or otherwise using it. Please notify the sender and return it.Thank you. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] !DSPAM:41c28e33342605758010407! -- Mit freundlichen Gruessen / With kind regards Daniel S. Haischt | phone:+49 -7032-992909 Grabenstrasse 11| +49 -700-DHAISCHT | fax: +49 -7032-992910 D-71083 Herrenberg | fax2mail: +49 -7032-7999738 GERMANY | cell: +49 -172-7668936 email: [EMAIL PROTECTED] web: http://www.daniel.stefan.haischt.name/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
MySQL cluster on FreeBSD AMD-64 ?
Hi guys, A few days ago I asked for experiences you all might have with optimising MySQL for large DB applications under FreeBSD. Well, the plot thickens, and hardware and OS-wise I think I now am well on my way of finding a very promising solution. The idea is to use FreeBSD 5.3 AMD-64, using MySQL cluster. Has anybody already done this? If so, could they perhaps let me know their experiences and/or any potential pitfalls (either on-list or off-list)? Thanks heaps in advance, and 'ave a great weekend! Olafo ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Is Mysql accessible through Jailshell??
On Thu, Dec 16, 2004 at 09:26:11PM +0530, Akhthar Parvez. K wrote: Hi all, I am not able to access mysql from jailshell. Is it allowed or a bug? I got mysql error 61( Connection refused) when I tried the same. Comments are welcomed. Quick question: are you trying to access MySQL on a TCP or local Unix socket? If it is through a Unix socket, then the MySQL socket has to exist within the jail filesystem root. By default, the MySQL server opens a Unix socket under either /tmp or /var/run, which cannot be seen by any jail on the system. G'luck, Peter -- Peter Pentchev [EMAIL PROTECTED][EMAIL PROTECTED][EMAIL PROTECTED] PGP key:http://people.FreeBSD.org/~roam/roam.key.asc Key fingerprint FDBA FD79 C26F 3C51 C95E DF9E ED18 B68D 1619 4553 This sentence claims to be an Epimenides paradox, but it is lying. pgp77S6ktUYpX.pgp Description: PGP signature
Mysql 4.0 startup script
I have mysql 4.0.22 installed on FreeBSD 4.10-RELEASE-p5. Whenere I run /usr/local/etc/rc.d/mysql-server.sh start, it drops into a shell under the username of mysql and does not start. Anyone else having this problem or know how to fix it? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 12/15/2004 ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
postfix mysql 4.0.22
Hello people, I have a little problem setting up postfix with mysql. My ports.cvs looks like this : madalina# cat /root/ports.cvs *default host=cvsup7.freebsd.org *default base=/usr *default prefix=/usr *default release=cvs tag=. *default compress *default delete use-rel-suffix ports-all - I cvsup'ed to get the latest ports. I installed mysql server 4.0.22. Now i try to install postfix with mysql backend. So : cd /usr/ports/mail/postfix make install and i get this error : === Installing for mysql-client-3.23.58_3 === mysql-client-3.23.58_3 conflicts with installed package(s): mysql-client-4.0.22 They install files into the same place. Please remove them first with pkg_delete(1). *** Error code 1 but i got mysql 4.0.22 not 3.xx so i try with this : make install WITH_MYSQL_VER=4.0.22 but i get ... === postfix-2.1.5_1,1 is marked as broken: unknown MySQL version: 4.0.22. the same happens with postfix-current . What's wrong with my installation ? Thank you, Cristi --- This message and its contents have been scanned and certified for transmission as being free from malicious code by eTrust Antivirus. This message may contain confidential, privileged or other legally protected information. It is intended for the addressee(s) only. If you are not the addressee, or someone the addressee authorized to receive this message, you are prohibited from copying, distributing or otherwise using it. Please notify the sender and return it.Thank you. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Is Mysql accessible through Jailshell??
Hi all, I am not able to access mysql from jailshell. Is it allowed or a bug? I got mysql error 61( Connection refused) when I tried the same. Comments are welcomed. -- With Regards, Akhthar Parvez.K - I was brilliant when I was born, Education spoiled it!! ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
How to distribute MySQL over various machines (or otherwise up its performance)?
Hi, I have been asked to assist in a most interesting challenge: getting rid of a Win2K server (running MySQL) on which MySQL takes up around 100% of the CPU. :) I have near total freedom in suggesting a replacement architecture (within some reasonable finacial limits, of course), and I am considering suggesting a solution that involves one or more FreeBSD MySQL DB servers, in order to speed up the database performance. Now, there are various strategies that spring to mind, and I was hoping someone could perhaps tell me some more about this from personal experience or hearsay. Regardless of what the eventual suggestion will be, first I'll tune the current DB by assigning a proper DB scheme and by properly using indexes. I've got a gut feeling that these guys set up the DB without paying proper attention to that (in this case probably due to a lack of experience with this), so hopefully a lot can already be gained by doing so. Nonetheless: for setting up a more robust and fast DB server (or server cluster?) I'd like to take matters a step further, by using a fast hardware set-up as well (note: in any and all proposed architecture, I'll propose to use plenty of memory). Now, here comes the bit with which I do not have any experience, so I'm hoping perhaps someone can help me getting started on the proper path. The following is what I'm considering as potential steps: -The guys for whom this will be done mentioned having acquired 64-bit motherboards (I do not yet know the exact type), they do not mind installing multiple processors on it. Question: which FreeBSD version can best be used in order to optimally make use of a 64-bit and/or multi processor architecture? -RAID: for performance and security matters, I _think_ a RAID 10 architecture would be a very good choice. By using a proper U320 SCSI hardware set-up, running in RAID 10 mode, I think much can be gained. Cost is somewhat of an issue, but not all too much. I'm considering the Adaptec 2200S RAID controller, with 15K U320 drives (like the Maxtor 15K 36 GB drives or so). Questions: does it really make sense to use U320 (and 15K instead of 10K) instead of U160? I'm not certain what the speed is of the PCI slots that are present on the motherboards that are to be used, but am I right that if it's the normal speed (being 133MHz), that virtually nothing is gained by using U320 over U160 (as U160 would then already be faster than the bus speed anyway)? Also: does anyone have an insight in actual DB performance gain by using striping? RAID 0 is not an option, it'll have to be fault tolerant. I'm somewhat suspicious of RAID 50 and the likes, hence the idea of using RAID 10... -Using multiple machines. Questions: is there something like a 'MySQL load balancer'? Is this a good idea at all, or will a fast machine (e.g. dual processor) + enough memory (1GB? 2GB?) + a fast hardware RAID 10 set-up already be more than sufficient to do the job? I realise this is a long mail, so sorry for that. :) I hope someone can give me some good pointers and/or other general information for how to best handle this... Thanks in advance, and cheerz! Olafo ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql connect problems
On Sat, 11 Dec 2004 09:23:52 +, Peter Risdon [EMAIL PROTECTED] wrote: When I specify a value for MySQL server and for DB root password on the MediaWiki 1.3.8 installation page, I get Couldn't connect to database with a script note MySQL error 1250: Client does not support authentication protocol requested by server; consider upgrading MySQL client. When I omit the root password value, so it can connect with the user wikiuser, it says Check name/pass or enter root password below, with notes # MySQL error 1045: Access denied for user: 'root'@'localhost' (Using password: NO) and Trying regular user... need password. OK, but is this a mysql problem? It's certainly beginning to seem _not_ to be, isn't it. Can you connect as the relevant users from the command line? Yes. Which would seem to affirm your suspicion above. And I've tried every possible combination of information on the MediaWiki install page, but nothing works. If there are no more suggestions on how to fix this, how about recommendations for a different wiki package? Preferably, one that won't be quite as much of a bear to set up Thanks. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql connect problems
John DeStefano wrote: [...] When I specify a value for MySQL server and for DB root password on the MediaWiki 1.3.8 installation page, I get Couldn't connect to database with a script note MySQL error 1250: Client does not support authentication protocol requested by server; consider upgrading MySQL client. When I omit the root password value, so it can connect with the user wikiuser, it says Check name/pass or enter root password below, with notes # MySQL error 1045: Access denied for user: 'root'@'localhost' (Using password: NO) and Trying regular user... need password. OK, but is this a mysql problem? Can you connect as the relevant users from the command line? Peter. -- the circle squared network systems and software http://www.circlesquared.com ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
Yes, was in my original message but you caught us half-way: # grep mysql /etc/rc.conf mysql_enable=YES I'm using the mysql from ports. I'm going from memory here as I'm not in front of my BSD machine but isn't it mysqld_enable=YES? Not according to the script, but I'll try it anyway: --- $ grep enable /usr/local/etc/rc.d/mysql-server.sh # 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. ..snip.. --- Nope, still no dice. Changed it back to mysql_enable but it still won't start up on boot. Anyone have any other ideas of what it could be? I tried recompiling mysql_server but still no go. The only error I get is: --- 041210 07:33:27 mysqld started 041210 7:33:27 [ERROR] Can't find messagefile '/usr/local/share/mysql/english/e rrmsg.sys' 041210 7:33:27 [ERROR] Aborting 041210 07:33:27 mysqld ended --- However when I start it directly it starts up just fine. Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
Vonleigh Simmons [EMAIL PROTECTED] was heard to say: Nope, still no dice. Changed it back to mysql_enable but it still won't start up on boot. Anyone have any other ideas of what it could be? I can't help you any further if you want to understand what's going wrong. However, if you just want mysqld to show up in your process list, swallow your pride and install the package. Works for me. regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with mhoenicka) http://www.mhoenicka.de ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
Vonleigh Simmons wrote: After updating to 5.3 MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its own after I reboot. However doing: # /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/my_hostname.pid Ok forget that last question, I found the answer, check the startup script is running the correct command, I found that in the start up script the command wasnt right ie. command=/usr/local/bin/safe_mysqld So I changed it to: command=/usr/local/bin/mysqld_safe Regards, Gary Hayers ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
It still won't start up on its own after I reboot. However doing: # /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/my_hostname.pid Ok forget that last question, I found the answer, check the startup script is running the correct command, I found that in the start up script the command wasnt right ie. command=/usr/local/bin/safe_mysqld So I changed it to: command=/usr/local/bin/mysqld_safe That's not it either: # grep command /usr/local/etc/rc.d/mysql-server.sh command=/usr/local/bin/mysqld_safe This is very strange. The command I'm using I pulled almost copying and pasting from the script, so it should be the same; yet it still won't start on bootup. Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql connect problems
On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: select user, password, host from user; on 'mysql' returned 3 'root' entries using 2 different passwords (localhost, %, and the actual host name), 2 anon entries (localhost and host name), 2 'mtuser' entries (one on localhost w/o pw, one on '%'), and one 'wikiuser' entry (localhost w/o pw). I changed the root passwords so they all use the same one, and changed the 'mtuser' entry that didn't have a password so its password matches that of the other entry. Have you issued the command similair like GRANT ALL PRIVILEGES ON *.* TO '[EMAIL PROTECTED]'; Yes: I ran both of these commands as root: GRANT ALL ON wikidb.* TO wikiuser; GRANT ALL ON mtdb.* TO mtuser; FLUSH PRIVILEGES; It still didn't work in either case. However, I logged off as I had to leave for a bit, later opened a new SSH session, and now can log in to mysql as both users, AND Mobile Type is now working! I have no idea what changed. And MediaWiki is still saying Couldn't connect to database. Running show databases; as 'wikiuser' shows the proper database (plus the 'test' database). I'm stuck. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql connect problems
On Fri, 10 Dec 2004 14:13:40 -0500, John DeStefano wrote On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: select user, password, host from user; on 'mysql' returned 3 'root' entries using 2 different passwords (localhost, %, and the actual host name), 2 anon entries (localhost and host name), 2 'mtuser' entries (one on localhost w/o pw, one on '%'), and one 'wikiuser' entry (localhost w/o pw). I changed the root passwords so they all use the same one, and changed the 'mtuser' entry that didn't have a password so its password matches that of the other entry. Have you issued the command similair like GRANT ALL PRIVILEGES ON *.* TO '[EMAIL PROTECTED]'; Yes: I ran both of these commands as root: GRANT ALL ON wikidb.* TO wikiuser; GRANT ALL ON mtdb.* TO mtuser; FLUSH PRIVILEGES; AFAIK you must type '[EMAIL PROTECTED]' (including the quotes). If that doesn't work, then I don't know it either. Perhaps somebody else on the list has an idea? Jorn. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql connect problems
Jorn Argelo wrote: On Fri, 10 Dec 2004 14:13:40 -0500, John DeStefano wrote On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: select user, password, host from user; on 'mysql' returned 3 'root' entries using 2 different passwords (localhost, %, and the actual host name), 2 anon entries (localhost and host name), 2 'mtuser' entries (one on localhost w/o pw, one on '%'), and one 'wikiuser' entry (localhost w/o pw). I changed the root passwords so they all use the same one, and changed the 'mtuser' entry that didn't have a password so its password matches that of the other entry. Have you issued the command similair like GRANT ALL PRIVILEGES ON *.* TO '[EMAIL PROTECTED]'; Yes: I ran both of these commands as root: GRANT ALL ON wikidb.* TO wikiuser; GRANT ALL ON mtdb.* TO mtuser; FLUSH PRIVILEGES; AFAIK you must type '[EMAIL PROTECTED]' (including the quotes). If that doesn't work, then I don't know it either. Perhaps somebody else on the list has an idea? I have found it's best to connect to the database you want to grant the privileges on before issuing the GRANT command. This doesn't seem to be the way it's documented, but it works for me. You might also consider using passwords... mysql\u wikidb mysqlGRANT ALL on wikidb.* to [EMAIL PROTECTED] IDENTIFIED BY 'password'; mysql\u mtdb mysqlGRANT ALL on mtdb.* to [EMAIL PROTECTED] IDENTIFIED BY 'password'; Peter. -- the circle squared network systems and software http://www.circlesquared.com ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
Vonleigh Simmons wrote: Yes, was in my original message but you caught us half-way: # grep mysql /etc/rc.conf mysql_enable=YES I'm using the mysql from ports. I'm going from memory here as I'm not in front of my BSD machine but isn't it mysqld_enable=YES? Not according to the script, but I'll try it anyway: --- $ grep enable /usr/local/etc/rc.d/mysql-server.sh # 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. ..snip.. --- Nope, still no dice. Changed it back to mysql_enable but it still won't start up on boot. Anyone have any other ideas of what it could be? I tried recompiling mysql_server but still no go. The only error I get is: --- 041210 07:33:27 mysqld started 041210 7:33:27 [ERROR] Can't find messagefile '/usr/local/share/mysql/english/e rrmsg.sys' 041210 7:33:27 [ERROR] Aborting 041210 07:33:27 mysqld ended --- However when I start it directly it starts up just fine. What command are you issuing to start it directly? Regards, Gary Hayers ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql connect problems
On Fri, 10 Dec 2004 00:15:10 +0100, Jorn Argelo [EMAIL PROTECTED] wrote:
On Thu, 9 Dec 2004 17:18:38 -0500, John DeStefano wrote
[snip]
At a prompt, if I try to connect to mysql using the '-p' option like
this:
# mysql -u root -p
... I can connect.
Which makes sense. Because the -p option is for entering a password. And I
don't think you'll have an empty root password ;)
I assumed p meant password in some respect, but didn't realize
until you pointed it out that it actually meant _prompt_ for
password, and that no password must inherently be assumed (which
doesn't sound very secure).
But if I try to connect without '-p' like this:
# mysql -u root
... I get an error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root'@'localhost' (Using password:
NO)'
What you're trying to do now is connecting with an empty password, and thus it
refuses to connect. You always have to imply the -p option unless the password
of your user is empty, but you DON'T want that.
But this seems to work only for root: when I try the same command
specifying one of the users I created:
# mysql -u wikiuser -p
Enter password:
...it doesn't work:
ERROR 1045 (28000): Access denied for user: 'mtuser'@'localhost'
(Using password: YES)
From what I can gather, this has to do with setting passwords for
different aliases or incarnations of the host for a single user
(root). I've tried every solution I've found for adding additional
connection settings for root (including more than one method for
changing the root password). When I log into mysql as root, use the
mysql database, and run 'select user, password, host from user;' I
see multiple entries for root for different 'host' values
('localhost', the actual host name, and '%').
Well, I have checked it as well, and I have just the root user on localhost
(with a different password then the one on the system though) and two
anonymous users (so no username and no password) for localhost and the FQDM
without any permissions. So I'm not really sure if the % is good or not.
Perhaps you're running a different version then I am (I use 4.1.7).
Yes: I'm running 5.0.0-alpha (at least that's what I get back from
mysqladmin -u root -p version). So, do you recommend I try to
remove those extra root entries?
Also, how do I get these Web-based clients to connect to the accounts
and databases they require? I have created a database for each
application, and a user and password for each, and tried to grant
permissions for each to connect to the respective database. But it's
not working: both Web clients return can't connect errors.
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql connect problems
On Fri, 10 Dec 2004 09:54:56 -0500, John DeStefano wrote
On Fri, 10 Dec 2004 00:15:10 +0100, Jorn Argelo [EMAIL PROTECTED] wrote:
On Thu, 9 Dec 2004 17:18:38 -0500, John DeStefano wrote
[snip]
At a prompt, if I try to connect to mysql using the '-p' option like
this:
# mysql -u root -p
... I can connect.
Which makes sense. Because the -p option is for entering a password. And I
don't think you'll have an empty root password ;)
I assumed p meant password in some respect, but didn't realize
until you pointed it out that it actually meant _prompt_ for
password, and that no password must inherently be assumed (which
doesn't sound very secure).
A little side note, you can always type mysql -u root -pyourpassword (note
that there is no space between the two) as well.
But if I try to connect without '-p' like this:
# mysql -u root
... I get an error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root'@'localhost' (Using password:
NO)'
What you're trying to do now is connecting with an empty password, and
thus it
refuses to connect. You always have to imply the -p option unless the
password
of your user is empty, but you DON'T want that.
But this seems to work only for root: when I try the same command
specifying one of the users I created:
# mysql -u wikiuser -p
Enter password:
...it doesn't work:
ERROR 1045 (28000): Access denied for user: 'mtuser'@'localhost'
(Using password: YES)
You have to make sure that the user has access to login. Unless you are using
this database on an important machine, you can always change the root password
like this:
set password = password(yournewpassword);
Like that, you won't have problems with permissions and such, but people who
put security at a top priority will not like this method.
From what I can gather, this has to do with setting passwords for
different aliases or incarnations of the host for a single user
(root). I've tried every solution I've found for adding additional
connection settings for root (including more than one method for
changing the root password). When I log into mysql as root, use the
mysql database, and run 'select user, password, host from user;' I
see multiple entries for root for different 'host' values
('localhost', the actual host name, and '%').
Well, I have checked it as well, and I have just the root user on
localhost
(with a different password then the one on the system though) and two
anonymous users (so no username and no password) for localhost and the
FQDM
without any permissions. So I'm not really sure if the % is good or not.
Perhaps you're running a different version then I am (I use 4.1.7).
Yes: I'm running 5.0.0-alpha (at least that's what I get back from
mysqladmin -u root -p version). So, do you recommend I try to
remove those extra root entries?
It's probably the best thing not to touch anything regarding the MySQL
configuration unless you're sure what you're doing.
Also, how do I get these Web-based clients to connect to the accounts
and databases they require? I have created a database for each
application, and a user and password for each, and tried to grant
permissions for each to connect to the respective database. But it's
not working: both Web clients return can't connect errors.
Probably the same problem as stated before. If you are going to use one global
root user, do make sure that you only use the web-based interface in a LAN
enviroment, or add mod_ssl to your apache configuration. You don't want to
send such sensible passwords over the net in plain text.
If you want more information regarding the MySQL console, I would suggest you
try the MySQL documentation located on their website. It's just as great as
the FreeBSD handbook is ;)
Cheers,
Jorn
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql connect problems
On Fri, 10 Dec 2004 16:09:20 +0100, Jorn Argelo [EMAIL PROTECTED] wrote:
You have to make sure that the user has access to login. Unless you are using
this database on an important machine, you can always change the root password
like this:
set password = password(yournewpassword);
Like that, you won't have problems with permissions and such, but people who
put security at a top priority will not like this method.
I logged into mysql as root over a PuTTy/SSH connection and performed
this command, specifying a new password. But the result was Query
OK, 0 rows affected (0.01 sec). I believe this is because there are
multiple 'root' entries in the user table with different 'host'
values. I was able to change these values when I specified which
entry I wanted to change:
mysql UPDATE user SET password=PASSWORD(''new_password')
- WHERE user='root' and host='host_entry';
Yes: I'm running 5.0.0-alpha (at least that's what I get back from
mysqladmin -u root -p version). So, do you recommend I try to
remove those extra root entries?
It's probably the best thing not to touch anything regarding the MySQL
configuration unless you're sure what you're doing.
Are these extra root user entries in the mysql database, which I
believe I've entered myself while trying different solutions,
considered part of the MySQL configuration?
select user, password, host from user; on 'mysql' returned 3 'root'
entries using 2 different passwords (localhost, %, and the actual host
name), 2 anon entries (localhost and host name), 2 'mtuser' entries
(one on localhost w/o pw, one on '%'), and one 'wikiuser' entry
(localhost w/o pw). I changed the root passwords so they all use the
same one, and changed the 'mtuser' entry that didn't have a password
so its password matches that of the other entry.
'mtuser' can not log in to mysql locally:
# mysql -u mtuser -p
Enter password:
ERROR 1045 (28000): Access denied for user: 'mtuser'@'localhost'
(Using password: YES)
A similar error is returned by the Movable Type System Loader page
(which is to be expected, since he/she can't log in locally):
Access denied for user: 'mtuser'@'%' to database 'mtdb' at
/usr/www/mt-static/mt-load.cgi line 195.
'wikiuser' can log in to mysql locally, but the MediaWiki 1.3.8
installation page reports it Couldn't connect to database, no mater
whether I specify localhost, the actual host name, or leave the 'MySQL
server' field blank.
If you want more information regarding the MySQL console, I would suggest you
try the MySQL documentation located on their website. It's just as great as
the FreeBSD handbook is ;)
I agree: the MySQL docs are comprehensive, extensive, and very
well-organized. But for an inexperienced user like me, browsing
through the troubleshooting sections to find an answer is like...
well, trying to install Mobile Type. ;)
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql connect problems
On Fri, 10 Dec 2004 11:07:17 -0500, John DeStefano wrote
On Fri, 10 Dec 2004 16:09:20 +0100, Jorn Argelo [EMAIL PROTECTED] wrote:
You have to make sure that the user has access to login. Unless you are
using
this database on an important machine, you can always change the root
password
like this:
set password = password(yournewpassword);
Like that, you won't have problems with permissions and such, but people
who
put security at a top priority will not like this method.
I logged into mysql as root over a PuTTy/SSH connection and performed
this command, specifying a new password. But the result was Query
OK, 0 rows affected (0.01 sec).
That is good, because you changed your password now :)
I believe this is because there are
multiple 'root' entries in the user table with different 'host'
values. I was able to change these values when I specified which
entry I wanted to change:
mysql UPDATE user SET password=PASSWORD(''new_password')
- WHERE user='root' and host='host_entry';
Yes: I'm running 5.0.0-alpha (at least that's what I get back from
mysqladmin -u root -p version). So, do you recommend I try to
remove those extra root entries?
It's probably the best thing not to touch anything regarding the MySQL
configuration unless you're sure what you're doing.
Are these extra root user entries in the mysql database, which I
believe I've entered myself while trying different solutions,
considered part of the MySQL configuration?
Ah. I was not aware that you entered users yourself. Then you should delete
the amends you made yourself.
select user, password, host from user; on 'mysql' returned 3 'root'
entries using 2 different passwords (localhost, %, and the actual
host name), 2 anon entries (localhost and host name), 2 'mtuser' entries
(one on localhost w/o pw, one on '%'), and one 'wikiuser' entry
(localhost w/o pw). I changed the root passwords so they all use the
same one, and changed the 'mtuser' entry that didn't have a password
so its password matches that of the other entry.
Have you issued the command similair like GRANT ALL PRIVILEGES ON *.* TO
'[EMAIL PROTECTED]';
See http://dev.mysql.com/doc/mysql/en/GRANT.html for more info.
'mtuser' can not log in to mysql locally:
# mysql -u mtuser -p
Enter password:
ERROR 1045 (28000): Access denied for user: 'mtuser'@'localhost'
(Using password: YES)
A similar error is returned by the Movable Type System Loader page
(which is to be expected, since he/she can't log in locally):
Access denied for user: 'mtuser'@'%' to database 'mtdb' at
/usr/www/mt-static/mt-load.cgi line 195.
'wikiuser' can log in to mysql locally, but the MediaWiki 1.3.8
installation page reports it Couldn't connect to database, no mater
whether I specify localhost, the actual host name, or leave the
'MySQL server' field blank.
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql connect problems
On Fri, 10 Dec 2004 21:43:19 +, Peter Risdon [EMAIL PROTECTED] wrote: AFAIK you must type '[EMAIL PROTECTED]' (including the quotes). If that doesn't work, then I don't know it either. Perhaps somebody else on the list has an idea? I have found it's best to connect to the database you want to grant the privileges on before issuing the GRANT command. This doesn't seem to be the way it's documented, but it works for me. You might also consider using passwords... mysql\u wikidb mysqlGRANT ALL on wikidb.* to [EMAIL PROTECTED] IDENTIFIED BY 'password'; mysql\u mtdb mysqlGRANT ALL on mtdb.* to [EMAIL PROTECTED] IDENTIFIED BY 'password'; Thank you both. Certainly makes sense, but it didn't work (If it _had_ worked, I'd be suspicious as to why I needed to do this for MediaWiki, and not for Mobile Type (which works now).). When I specify a value for MySQL server and for DB root password on the MediaWiki 1.3.8 installation page, I get Couldn't connect to database with a script note MySQL error 1250: Client does not support authentication protocol requested by server; consider upgrading MySQL client. When I omit the root password value, so it can connect with the user wikiuser, it says Check name/pass or enter root password below, with notes # MySQL error 1045: Access denied for user: 'root'@'localhost' (Using password: NO) and Trying regular user... need password. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
On Wed, 8 Dec 2004 12:22:53 -0800, Vonleigh Simmons [EMAIL PROTECTED] wrote: Since you didn't mention which mysql version you are using..I will say this. In the /usr/ports/UPDATING...there is a paragraph. 20041031: AFFECTS: users of databases/mysql40-server AUTHOR: [EMAIL PROTECTED] The MySQL Daemon must now be enabled / disabled in rc.conf. See the script for details. Is there such an entry in the rc.conf? Yes, was in my original message but you caught us half-way: # grep mysql /etc/rc.conf mysql_enable=YES I'm using the mysql from ports. I'm going from memory here as I'm not in front of my BSD machine but isn't it mysqld_enable=YES? ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
mysql connect problems
I wanted to give a try at enhancing my knowledge and improving my Web
server/sites by adding blog (Mobile Type) and wiki (MediaWIki)
applications. If you've ever tried to install/configure either of
these two apps on FreeBSD, perhaps you already know the frustration
I've met over the past 24 hours: multiple dependencies, modules,
untold configurations, etc., especially in the case of Mobile Type.
In fact, if you've got a better suggestion in either case, I wouldn't
be adverse to scrapping one or both packages and starting from scratch
with something else.
Anyway, after much Googling and tinkering, I made some advances but
seem to have come up against a problem in the vein of a very common
theme: MySQL connections in FreeBSD. Not that I'm blaming the
operating system; I'm quite aware this is more an 'operator error'
than anything else. Just appears that a lot of FBSD users just
starting out with MySQL or MySQL-dependent packages run into this.
Neither of the two above-mentioned applications can connect to my
MySQL services (access denied in both cases). I have created
databases and appropriate users for each, and I've tried to grant the
appropriate permissions. All that seemed to work, but I still can't
connect properly.
At a prompt, if I try to connect to mysql using the '-p' option like this:
# mysql -u root -p
... I can connect. But if I try to connect without '-p' like this:
# mysql -u root
... I get an error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root'@'localhost' (Using password: NO)'
From what I can gather, this has to do with setting passwords for
different aliases or incarnations of the host for a single user
(root). I've tried every solution I've found for adding additional
connection settings for root (including more than one method for
changing the root password). When I log into mysql as root, use the
mysql database, and run 'select user, password, host from user;' I see
multiple entries for root for different 'host' values ('localhost',
the actual host name, and '%').
I'd appreciate any help at all with this. Thanks very much.
~John
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql connect problems
On Thu, 9 Dec 2004 17:18:38 -0500, John DeStefano wrote
[snip]
At a prompt, if I try to connect to mysql using the '-p' option like
this:
# mysql -u root -p
... I can connect.
Which makes sense. Because the -p option is for entering a password. And I
don't think you'll have an empty root password ;)
But if I try to connect without '-p' like this:
# mysql -u root
... I get an error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root'@'localhost' (Using password:
NO)'
What you're trying to do now is connecting with an empty password, and thus it
refuses to connect. You always have to imply the -p option unless the password
of your user is empty, but you DON'T want that.
From what I can gather, this has to do with setting passwords for
different aliases or incarnations of the host for a single user
(root). I've tried every solution I've found for adding additional
connection settings for root (including more than one method for
changing the root password). When I log into mysql as root, use the
mysql database, and run 'select user, password, host from user;' I
see multiple entries for root for different 'host' values
('localhost', the actual host name, and '%').
Well, I have checked it as well, and I have just the root user on localhost
(with a different password then the one on the system though) and two
anonymous users (so no username and no password) for localhost and the FQDM
without any permissions. So I'm not really sure if the % is good or not.
Perhaps you're running a different version then I am (I use 4.1.7).
I'd appreciate any help at all with this. Thanks very much.
~John
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
Vonleigh Simmons [EMAIL PROTECTED] was heard to say: After updating to 5.3 MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its own after I reboot. However doing: I'm sitting in front of a Windows box right now, so please excuse me that I reply from memory. AFAIK there is an example start script in /usr/local/etc/init.d/ which you have to rename to mysql.sh. regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with mhoenicka) http://www.mhoenicka.de ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
After updating to 5.3 MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its own after I reboot. However doing: I'm sitting in front of a Windows box right now, so please excuse me that I reply from memory. AFAIK there is an example start script in /usr/local/etc/init.d/ which you have to rename to mysql.sh. I do have a file in rc.d: # ll -d /usr/local/etc/rc.d/mysql-server.sh -rwxr-x--- 1 root wheel 1405 Dec 6 20:28 /usr/local/etc/rc.d/mysql-server.sh Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
Vonleigh Simmons writes: /usr/local/etc/init.d/ which you have to rename to mysql.sh. I do have a file in rc.d: Ah, sure. init.d is linuxish. It just so happened that I installed a 5.3 box from scratch in the last couple of days. MySQL wasn't installed yet, so I grabbed the packages mysql-server-4.1.5.tbz and mysql-client-4.1.5.tbz. After adding them, there were the following start scripts in /usr/local/etc/rc.d: 000.mysql-client.sh mysql-server.sh I did not edit any config file but went right ahead to reboot the box. mysqld came up as intended. Do you use ports or a different MySQL version, by any chance? What happens if you run /usr/local/etc/rc.d/mysql-server.sh start manually? Does the log file enlighten you (/var/db/mysql/[boxname].err)? regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with mhoenicka) http://www.mhoenicka.de ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
What happens if you run /usr/local/etc/rc.d/mysql-server.sh start manually? Does the log file enlighten you (/var/db/mysql/[boxname].err)? I think you may have found it. I was able to stop mysql using the rc script. However starting it back up did nothing: # /usr/local/etc/rc.d/mysql-server.sh start Starting mysql. Yet mysql never started up, here is the error log: --- 041208 14:07:26 mysqld started 041208 14:07:26 [ERROR] Can't find messagefile '/usr/local/share/mysql/english/errmsg.sys' 041208 14:07:26 [ERROR] Aborting 041208 14:07:26 mysqld ended --- I do have the file it's complaining about: # ll -d /usr/local/share/mysql/english/errmsg.sys -r--r--r-- 1 root wheel 16568 Dec 6 20:28 /usr/local/share/mysql/english/err msg.sys If I start it up with mysql_safe using what I think the script is using as startup: # /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/alpargata.net.pid Then it starts up just fine: --- 041208 14:07:32 mysqld started 041208 14:07:32 InnoDB: Started; log sequence number 0 43912 /usr/local/libexec/mysqld: ready for connections. Version: '4.1.7' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-4.1.7 --- So I'm really not sure what's going on. Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: mysql won't start on boot
Someone broke the silence: What happens if you run /usr/local/etc/rc.d/mysql-server.sh start manually? Does the log file enlighten you (/var/db/mysql/[boxname].err)? I think you may have found it. I was able to stop mysql using the rc script. However starting it back up did nothing: # /usr/local/etc/rc.d/mysql-server.sh start Starting mysql. Yet mysql never started up, here is the error log: --- 041208 14:07:26 mysqld started 041208 14:07:26 [ERROR] Can't find messagefile '/usr/local/share/mysql/english/errmsg.sys' 041208 14:07:26 [ERROR] Aborting 041208 14:07:26 mysqld ended --- I do have the file it's complaining about: # ll -d /usr/local/share/mysql/english/errmsg.sys -r--r--r-- 1 root wheel 16568 Dec 6 20:28 /usr/local/share/mysql/english/err msg.sys If I start it up with mysql_safe using what I think the script is using as startup: # /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/alpargata.net.pid Then it starts up just fine: --- 041208 14:07:32 mysqld started 041208 14:07:32 InnoDB: Started; log sequence number 0 43912 /usr/local/libexec/mysqld: ready for connections. Version: '4.1.7' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-4.1.7 --- So I'm really not sure what's going on. Since you didn't mention which mysql version you are using..I will say this. In the /usr/ports/UPDATING...there is a paragraph. 20041031: AFFECTS: users of databases/mysql40-server AUTHOR: [EMAIL PROTECTED] The MySQL Daemon must now be enabled / disabled in rc.conf. See the script for details. Is there such an entry in the rc.conf? Chris Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
Since you didn't mention which mysql version you are using..I will say this. In the /usr/ports/UPDATING...there is a paragraph. 20041031: AFFECTS: users of databases/mysql40-server AUTHOR: [EMAIL PROTECTED] The MySQL Daemon must now be enabled / disabled in rc.conf. See the script for details. Is there such an entry in the rc.conf? Yes, was in my original message but you caught us half-way: # grep mysql /etc/rc.conf mysql_enable=YES I'm using the mysql from ports. Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
On Wed, 8 Dec 2004 12:05:13 -0800, Vonleigh Simmons [EMAIL PROTECTED] wrote: What happens if you run /usr/local/etc/rc.d/mysql-server.sh start # /usr/local/etc/rc.d/mysql-server.sh start Starting mysql. Yet mysql never started up, here is the error log: --- 041208 14:07:26 mysqld started 041208 14:07:26 [ERROR] Can't find messagefile '/usr/local/share/mysql/english/errmsg.sys' 041208 14:07:26 [ERROR] Aborting 041208 14:07:26 mysqld ended --- The documentation specifies that the above is not the way to start mysql. If I start it up with mysql_safe using what I think the script is using as startup: # /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/alpargata.net.pid Then it starts up just fine: --- 041208 14:07:32 mysqld started 041208 14:07:32 InnoDB: Started; log sequence number 0 43912 /usr/local/libexec/mysqld: ready for connections. Version: '4.1.7' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-4.1.7 --- And you found the correct way. However, I do not know why it is not starting at boot time. -- Joshua Lokken Open Source Advocate ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
Joshua Lokken [EMAIL PROTECTED] was heard to say: On Wed, 8 Dec 2004 12:05:13 -0800, Vonleigh Simmons [EMAIL PROTECTED] wrote: What happens if you run /usr/local/etc/rc.d/mysql-server.sh start # /usr/local/etc/rc.d/mysql-server.sh start Starting mysql. Yet mysql never started up, here is the error log: --- 041208 14:07:26 mysqld started 041208 14:07:26 [ERROR] Can't find messagefile '/usr/local/share/mysql/english/errmsg.sys' 041208 14:07:26 [ERROR] Aborting 041208 14:07:26 mysqld ended --- The documentation specifies that the above is not the way to start mysql. That's interesting. Why on earth would the mysql package use exactly this way to start up the server (see my previous post) if it is all wrong? regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with mhoenicka) http://www.mhoenicka.de ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
mlock setgid mail mysql
After updating to 5.3 I'm running into the following two problems: 1. I'm getting the following error in my mail log over and over: usr/local/libexec/mlock[755]: (64) not setgid mail I'm assuming it's an ownership problem, but what of? 2. MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its own after I reboot. However doing: # /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/my_hostname.pid Works just fine (which I assume is what the startup script should do). Any pointers as to why this isn't working as it should? Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
mysql won't start on boot
After updating to 5.3 MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its own after I reboot. However doing: # /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/my_hostname.pid Works just fine (which I assume is what the startup script should do). Any pointers as to why this isn't working as it should? Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeRadius and Mysql server ports
Jermaine McBean [EMAIL PROTECTED] writes: I have problem adding MySQL server to FreeBSD with FreeRadius. Since I already installed FreeRadius /w Mysql client, I cannot do a pkg_add Mysql-server because of the FreeRadius' dependancy on a older mysql client (mysql-client-4.0.21). Is there a way to upgrade the client so I can install pkg_add -r mysql41-server. If there is any better way to combine them, it would be helpful. I'm a newbie at this The sysutils/portupgrade port is quite helpful with these sorts of issues... ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Suport for MySQL and Postgresql in PHP
Hi, Sorry for this newbie question :( I've installed Apache-PHP sucessfully, but PHP lacks suport for MySQL and Postgresql. Are there any ports for that, or must i edit PHP's Makefile to include suport for both databases ? I've searched all around the ports colection, but didn't find anything :( Any help would be apreciated. Warm Regards. -- Mário Gamito Administração de sistemas e desenvolvimento Netual - Multimédia e Telecomunicações, Lda. Rua João Afonso, Nº1 3800-198 Aveiro - Portugal Tel. +351 234 371 431 / Fax. +351 234 371 438 E-mail: [EMAIL PROTECTED] www.netual.pt ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Suport for MySQL and Postgresql in PHP
Mário Gamito wrote: Hi, Sorry for this newbie question :( I've installed Apache-PHP sucessfully, but PHP lacks suport for MySQL and Postgresql. Are there any ports for that, or must i edit PHP's Makefile to include suport for both databases ? I've searched all around the ports colection, but didn't find anything :( Any help would be apreciated. Warm Regards. According to /usr/ports/UPDATING: 20040719: AFFECTS: users of PHP AUTHOR: [EMAIL PROTECTED] The old lang/php4 and lang/php5 ports have been splitted into 'base' PHP, PEAR, and shared extensions to allow more flexibility and add new features. Upgrading your current PHP installation will result in a 'base' PHP installation (no PEAR and no extensions). PEAR can be found in the new devel/php4-pear and devel/php5-pear ports, while the set of PHP extensions to install can be choosen via the meta-ports lang/php4-extensions and lang/php5-extensions, or installing singular extensions individually. If you have a previous php.ini configuration file, be sure to comment out the extension_dir parameter, since the correct path is statically compiled into the PHP binary. For an overview of the modules used with the old PHP binary, use the command php -m. Now, according to /usr/ports/lang/php4-extensions/Makefile, installing this port will get you support for MySQL. # cd /usr/ports/lang/php4-extensions # make install clean However, PostGres support is optional, so if you want both: # cd /usr/ports/lang/php4-extensions # make WITH_PGSQL install clean HTH, Kevin Kinsey ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
FreeRadius and Mysql server ports
I have problem adding MySQL server to FreeBSD with FreeRadius. Since I already installed FreeRadius /w Mysql client, I cannot do a pkg_add Mysql-server because of the FreeRadius' dependancy on a older mysql client (mysql-client-4.0.21). Is there a way to upgrade the client so I can install pkg_add -r mysql41-server. If there is any better way to combine them, it would be helpful. I'm a newbie at this Jermaine ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
MYSQL connection problem
Hello Everyone; I have two machines: 1) Free 4.10 / mysql (5.0.0) listening on port 5006 2) Free 5.3 Release / mysql (5.0.0) listening on port 5007 On both, no firewalls, blocks or anything of that sort. Both machines have the same configuration. Both mysql were compiled from the ports with the same options. The only difference between the two machines is the Free version and port mysql is listening on. Here are the outputs of the following commands on machine 1): telnet localhost 5006 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 9 5.0.0-alpha}l'zRjBG,!js%Zxl6fp3 (after a few seconds...) Connection closed by foreign host. - mysql -u root -P 5006 -h 127.0.0.1 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 to server version: 5.0.0-alpha Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql ** Now, here are the outputs of the same commands on machine 2): ]telnet localhost 5007 Trying ::1... Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. Connection closed by foreign host. (no wait for this line to show!) mysql -u root -P 5007 -h 127.0.0.1 -p Enter password: ERROR 2013 (HY000): Lost connection to MySQL server during query (no wait for the above line to show either!) ** I can only connect on machine 2) if I use a mysql.sock file. Any attempt to connect via TCP/IP doesn´t work !! command line client, java connectors (all possible versions) none work. I´ve been into every single link google returned to me on the ERROR 2013 above for 2 days now and none of them had any info to get this working. Believe me, I tried every hint of suggestion there was. I really hope someone here has any clues to what is going on. I´ve posted this to hackers but no clues so far. thanks, -- //| //|| // | // || -//--//---|| ARIO LOBO // //|| - [EMAIL PROTECTED] http://www.ipad.com.br ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
MYSQL connection problem (added info)
Adding the tcpdump output after changing mysqld to port 5004 (just a try :(( ) and issuing: [~]mysql --port=5004 --host=127.0.0.1 --user=xxx database -p [~]tcpdump -vv -i lo0 port 5004 tcpdump: listening on lo0, link-type NULL (BSD loopback), capture size 96 bytes 08:57:04.755597 IP (tos 0x0, ttl 64, id 5384, offset 0, flags [DF], length: 64) localhost.58972 localhost.5004: S [tcp sum ok] 1832068379:1832068379(0) win 65535 mss 16344,nop,nop,sackOK,nop,wscale 1,nop,nop,timestamp 77449669 0 08:57:04.755654 IP (tos 0x0, ttl 64, id 5385, offset 0, flags [DF], length: 64) localhost.5004 localhost.58972: S [tcp sum ok] 87927240:87927240(0) ack 1832068380 win 65535 mss 16344,nop,wscale 1,nop,nop,timestamp 77449669 77449669,nop,nop,sackOK 08:57:04.755685 IP (tos 0x0, ttl 64, id 5386, offset 0, flags [DF], length: 52) localhost.58972 localhost.5004: . [tcp sum ok] 1:1(0) ack 1 win 35840 nop,nop,timestamp 77449669 77449669 08:57:04.756399 IP (tos 0x0, ttl 64, id 5387, offset 0, flags [DF], length: 52) localhost.5004 localhost.58972: F [tcp sum ok] 1:1(0) ack 1 win 35840 nop,nop,timestamp 77449670 77449669 08:57:04.760855 IP (tos 0x8, ttl 64, id 5388, offset 0, flags [DF], length: 52) localhost.58972 localhost.5004: . [tcp sum ok] 1:1(0) ack 2 win 35840 nop,nop,timestamp 77449674 77449670 08:57:04.761035 IP (tos 0x8, ttl 64, id 5389, offset 0, flags [DF], length: 52) localhost.58972 localhost.5004: F [tcp sum ok] 1:1(0) ack 2 win 35840 nop,nop,timestamp 77449674 77449670 08:57:04.761067 IP (tos 0x0, ttl 64, id 5390, offset 0, flags [DF], length: 52) localhost.5004 localhost.58972: . [tcp sum ok] 2:2(0) ack 2 win 35839 nop,nop,timestamp 77449674 77449674 7 packets captured 7 packets received by filter 0 packets dropped by kernel I hope this helps, -- //| //|| // | // || -//--//---|| ARIO LOBO // //|| - [EMAIL PROTECTED] http://www.ipad.com.br -- First post /* === I have two machines: 1) Free 4.10 / mysql (5.0.0) listening on port 5006 2) Free 5.3 Release / mysql (5.0.0) listening on port 5007 On both, no firewalls, blocks or anything of that sort. Both machines have the same configuration. Both mysql were compiled from the ports with the same options. The only difference between the two machines is the Free version and port mysql is listening on. Here are the outputs of the following commands on machine 1): telnet localhost 5006 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 9 5.0.0-alpha}l'zRjBG,!js%Zxl6fp3 (after a few seconds...) Connection closed by foreign host. - mysql -u root -P 5006 -h 127.0.0.1 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 to server version: 5.0.0-alpha Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql ** Now, here are the outputs of the same commands on machine 2): ]telnet localhost 5007 Trying ::1... Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. Connection closed by foreign host. (no wait for this line to show!) mysql -u root -P 5007 -h 127.0.0.1 -p Enter password: ERROR 2013 (HY000): Lost connection to MySQL server during query (no wait for the above line to show either!) ** I can only connect on machine 2) if I use a mysql.sock file. Any attempt to connect via TCP/IP doesn´t work !! command line client, java connectors (all possible versions) none work. I´ve been into every single link google returned to me on the ERROR 2013 above for 2 days now and none of them had any info to get this working. Believe me, I tried every hint of suggestion there was. I really hope someone here has any clues to what is going on. I´ve posted this to hackers but no clues so far. thanks, -- //| //|| // | // || -//--//---|| ARIO LOBO // //|| - [EMAIL PROTECTED] http://www.ipad.com.br ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MYSQL connection problem (added info)
On Wed, 1 December, 2004 12:16, [EMAIL PROTECTED] said: Adding the tcpdump output after changing mysqld to port 5004 (just a try :(( ) and issuing: [~]mysql --port=5004 --host=127.0.0.1 --user=xxx database -p [~]tcpdump -vv -i lo0 port 5004 tcpdump: listening on lo0, link-type NULL (BSD loopback), capture size 96 bytes 08:57:04.755597 IP (tos 0x0, ttl 64, id 5384, offset 0, flags [DF], length: 64) localhost.58972 localhost.5004: S [tcp sum ok] 1832068379:1832068379(0) win 65535 mss 16344,nop,nop,sackOK,nop,wscale 1,nop,nop,timestamp 77449669 0 08:57:04.755654 IP (tos 0x0, ttl 64, id 5385, offset 0, flags [DF], length: 64) localhost.5004 localhost.58972: S [tcp sum ok] 87927240:87927240(0) ack 1832068380 win 65535 mss 16344,nop,wscale 1,nop,nop,timestamp 77449669 77449669,nop,nop,sackOK 08:57:04.755685 IP (tos 0x0, ttl 64, id 5386, offset 0, flags [DF], length: 52) localhost.58972 localhost.5004: . [tcp sum ok] 1:1(0) ack 1 win 35840 nop,nop,timestamp 77449669 77449669 08:57:04.756399 IP (tos 0x0, ttl 64, id 5387, offset 0, flags [DF], length: 52) localhost.5004 localhost.58972: F [tcp sum ok] 1:1(0) ack 1 win 35840 nop,nop,timestamp 77449670 77449669 08:57:04.760855 IP (tos 0x8, ttl 64, id 5388, offset 0, flags [DF], length: 52) localhost.58972 localhost.5004: . [tcp sum ok] 1:1(0) ack 2 win 35840 nop,nop,timestamp 77449674 77449670 08:57:04.761035 IP (tos 0x8, ttl 64, id 5389, offset 0, flags [DF], length: 52) localhost.58972 localhost.5004: F [tcp sum ok] 1:1(0) ack 2 win 35840 nop,nop,timestamp 77449674 77449670 08:57:04.761067 IP (tos 0x0, ttl 64, id 5390, offset 0, flags [DF], length: 52) localhost.5004 localhost.58972: . [tcp sum ok] 2:2(0) ack 2 win 35839 nop,nop,timestamp 77449674 77449674 7 packets captured 7 packets received by filter 0 packets dropped by kernel I hope this helps, -- //| //|| // | // || -//--//---|| ARIO LOBO // //|| - [EMAIL PROTECTED] http://www.ipad.com.br -- First post /* =I have two machines: 1) Free 4.10 / mysql (5.0.0) listening on port 5006 2) Free 5.3 Release / mysql (5.0.0) listening on port 5007 On both, no firewalls, blocks or anything of that sort. Both machines have the same configuration. Both mysql were compiled from the ports with the same options. The only difference between the two machines is the Free version and port mysql is listening on. Here are the outputs of the following commands on machine 1): telnet localhost 5006 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 9 5.0.0-alpha}l'zRjBG,!js%Zxl6fp3 (after a few seconds...) Connection closed by foreign host. - mysql -u root -P 5006 -h 127.0.0.1 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 to server version: 5.0.0-alpha Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql ** Now, here are the outputs of the same commands on machine 2): ]telnet localhost 5007 Trying ::1... Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. Connection closed by foreign host. (no wait for this line to show!) mysql -u root -P 5007 -h 127.0.0.1 -p Enter password: ERROR 2013 (HY000): Lost connection to MySQL server during query (no wait for the above line to show either!) ** I can only connect on machine 2) if I use a mysql.sock file. Any attempt to connect via TCP/IP doesn´t work !! command line client, java connectors (all possible versions) none work. I´ve been into every single link google returned to me on the ERROR 2013 above for 2 days now and none of them had any info to get this working. Believe me, I tried every hint of suggestion there was. I really hope someone here has any clues to what is going on. I´ve posted this to hackers but no clues so far. I may (and probably am!) be way off on this but could you post the contents of /etc/hosts and /etc/resolv.conf for both machines please. Cheers, David ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MYSQL connection problem
On Wed, Dec 01, 2004 at 08:23:51AM -0300, [EMAIL PROTECTED] wrote: Hello Everyone; I have two machines: 1) Free 4.10 / mysql (5.0.0) listening on port 5006 2) Free 5.3 Release / mysql (5.0.0) listening on port 5007 On both, no firewalls, blocks or anything of that sort. Both machines have the same configuration. Both mysql were compiled from the ports with the same options. The only difference between the two machines is the Free version and port mysql is listening on. [---snip---] I can only connect on machine 2) if I use a mysql.sock file. Any attempt to connect via TCP/IP doesn?t work !! command line client, java connectors (all possible versions) none work. I?ve been into every single link google returned to me on the ERROR 2013 above for 2 days now and none of them had any info to get this working. Believe me, I tried every hint of suggestion there was. I had similar problems recently. Edit the port's Makefile, removing the line: --with-libwrap \ and rebuild the port. This worked for me - but there is probably a better way to deal with it. Dan -- Daniel Bye PGP Key: ftp://ftp.slightlystrange.org/pgpkey/dan.asc PGP Key fingerprint: 3B9D 8BBB EB03 BA83 5DB4 3B88 86FC F03A 90A1 BE8F _ ASCII ribbon campaign ( ) - against HTML, vCards and X - proprietary attachments in e-mail / \ pgpBBSrDpkmNi.pgp Description: PGP signature
Re: MYSQL connection problem (SOLVED)
On Wed, Dec 01, 2004 at 10:40:14AM -0300, [EMAIL PROTECTED] wrote: YSS !!! IT WORKED !! Thanks a million Daniel. What exactly does with-liwrap do? It causes the MySQL package to be linked against the libwrap library - which is used for host access control through the /etc/hosts.allow mechanism. For this reason, now you have MySQL built without it, you should use some other means of controlling where connections are allowed from. Check out hosts_access in section 3 of the manual for more details. Dan -- Daniel Bye PGP Key: ftp://ftp.slightlystrange.org/pgpkey/dan.asc PGP Key fingerprint: 3B9D 8BBB EB03 BA83 5DB4 3B88 86FC F03A 90A1 BE8F _ ASCII ribbon campaign ( ) - against HTML, vCards and X - proprietary attachments in e-mail / \ pgpue9QFd7nmA.pgp Description: PGP signature
how to (automatically) start MySQL server?
Hi all, after successfully compiling installing MySQL server 4.0 I wanted to start it ... but there is no mysql.sh (or similar) in /usr/local/etc/rc.d/ So I have some questions: - what's the FreeBSD (4.10) way to start MySQL server? - how to setup initial mysql database under FreeBSD? - how to automatically start MySQL server during bootup? TIA! Greetings, Matthias -- Marge: I would love you if you weighed 1,000 pounds but ... Homer: Beautiful. G'night. King-Size Homer ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: how to (automatically) start MySQL server?
-- quoting Matthias F. Brandstetter -- Hi all, after successfully compiling installing MySQL server 4.0 I wanted to start it ... but there is no mysql.sh (or similar) in /usr/local/etc/rc.d/ So I have some questions: - what's the FreeBSD (4.10) way to start MySQL server? - how to setup initial mysql database under FreeBSD? - how to automatically start MySQL server during bootup? ok sorry folks, just saw that I forgot to install server, I just installed client ... sorry! -- Reverend Lovejoy: Homer, this is really low. Homer: Not as low as my low, low prices! Mr. Plow ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Mysql Error 1135
Akhthar Parvez. K [EMAIL PROTECTED] writes: I am getting following error message while accessing mysql. ERROR 1135: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug What could be the problem? I know that the problem is due to resources are temporarily unavaliable. But how can I fix this issue so that it won't come back. Well, first you need to figure out if you have run out of system memory or not. If so, then add a swap file. If not, then see if there are process limits affecting you. NOTHING IS IMPOSSIBLE Because Impossible itself says I'M POSSIBLE Let me know when you have FreeBSD running on an abacus. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Cyrus-SASL2-2.1.20 MySQL crypt'ed passwords
Hi, Could anyone make this setup work? The patch for 2.1.19 applies cleanly to the ports tree and I can build sasl, but it ignores the settings on smtpd.conf (mainly password_format: crypt). I can auth @ SMTP using the encrypted password I find at the database, but no luck using the plaintext password (which cyrus-sasl should then crypt and check vs the database). -- Meaning the patch is having no effect, it is only checking the password feeded vs the database... Is there any way to have SMTP auth working with MySQL / crypt-stored passwords using postfix+cyrus-sasl2 ? ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Cyrus-SASL2-2.1.20 MySQL crypt'ed passwords
Could anyone make this setup work? The patch for 2.1.19 applies cleanly to the ports tree and I can build sasl, but it ignores the settings on smtpd.conf (mainly password_format: crypt). I can auth @ SMTP using the encrypted password I find at the database, but no luck using the plaintext password (which cyrus-sasl should then crypt and check vs the database). -- Meaning the patch is having no effect, it is only checking the password feeded vs the database... Is there any way to have SMTP auth working with MySQL / crypt-stored passwords using postfix+cyrus-sasl2 ? smtpd.conf pwcheck_method: auxprop mech_list: PLAIN LOGIN auxprop_plugin: sql srp_mda: md5 password_format: crypt sql_engine: mysql sql_hostnames: localhost sql_database: postfix sql_user: X sql_passwd: X sql_verbose: yes sql_select: SELECT password FROM mailbox WHERE username = '[EMAIL PROTECTED]' - ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Cyrus-SASL2-2.1.20 MySQL crypt'ed passwords
That is exactly my smtpd.conf , I don't understand why it doesn't work :/ The password_format directive was incorporated on 2.1.20 ? Could anyone make this setup work? The patch for 2.1.19 applies cleanly to the ports tree and I can build sasl, but it ignores the settings on smtpd.conf (mainly password_format: crypt). I can auth @ SMTP using the encrypted password I find at the database, but no luck using the plaintext password (which cyrus-sasl should then crypt and check vs the database). -- Meaning the patch is having no effect, it is only checking the password feeded vs the database... Is there any way to have SMTP auth working with MySQL / crypt-stored passwords using postfix+cyrus-sasl2 ? smtpd.conf pwcheck_method: auxprop mech_list: PLAIN LOGIN auxprop_plugin: sql srp_mda: md5 password_format: crypt sql_engine: mysql sql_hostnames: localhost sql_database: postfix sql_user: X sql_passwd: X sql_verbose: yes sql_select: SELECT password FROM mailbox WHERE username = '[EMAIL PROTECTED]' - ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Cyrus-SASL2-2.1.20 MySQL crypt'ed passwords
It is accessing the database properly. SASL isn't even trying to check vs an encrypted password, if I feed it (at the SMTP auth) with the encrypted password I find at the database, it will accept it (like if it was a plaintext-password) That is exactly my smtpd.conf , I don't understand why it doesn't work :/ The password_format directive was incorporated on 2.1.20 ? smtpd.conf pwcheck_method: auxprop mech_list: PLAIN LOGIN auxprop_plugin: sql srp_mda: md5 password_format: crypt sql_engine: mysql sql_hostnames: localhost sql_database: postfix sql_user: X sql_passwd: X sql_verbose: yes sql_select: SELECT password FROM mailbox WHERE username = '[EMAIL PROTECTED]' - In this setup Sasl expects the passwords MD5 encrypted, not standaard UNIX crypt. Restart MySQL with the parameter --log and see what activity is logged. ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Mysql Error 1135
Hi All, I am getting following error message while accessing mysql. ERROR 1135: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug What could be the problem? I know that the problem is due to resources are temporarily unavaliable. But how can I fix this issue so that it won't come back. -- With Regards, Akhthar Parvez.K - NOTHING IS IMPOSSIBLE Because Impossible itself says I'M POSSIBLE ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mailinglist with postfix+mysql
+++ Martin Hudec [freebsd] [22-11-04 17:49 +0100]: | Hello, | | I am using postfix with mysql backend to provide mail | delivery services. Is there any mailinglist with support | for mysql stored subscribers addresses, and if is, which one | can you generally recommend to me? http://www.google.co.in/search?q=mailman+%2B+mysqlstart=0start=0ie=utf-8oe=utf-8client=firefoxrls=org.mozilla:en-US:unofficial Regards, Shantanoo ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: MySQL problems on FBSD 5.2.1
I have it working, but don't know if it is the right answer.
Some of the info I got hinted at rebuilding in a different order. So
I uninstall apache2, mod_php4, and mysql4. Then rebuilt the ports in
this order MySQL, then apache, and last mod_php. The problem still
existed. I found another port /usr/ports/databases/php4-mysql. After
a reboot that solved the problem.
Is the right way to fix my problem I don't know, but it does appear to
of fixed the problem.
Thanks all for their input.
Steve B.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of steveb99
Sent: Friday, November 19, 2004 9:39 AM
To: [EMAIL PROTECTED]
Subject: MySQL problems on FBSD 5.2.1
I installed mod_PHP which installed Apache 2 from ports. All that
works fine. I then install MySQL4 port and have it working fine
standalone. What I can't get to work is calling MySQL from
PHP code.
The code hits the call to MySQL functions and does nothing,
just stops
at that line and the web server puts up a blank screen. I
have looked
at http error logs and nothing. I have put debug statements
in the PHP code and it does execute up to the first MySQL
line trying to connect.
$db = MySQL_pconnect('localhost', 'mysqlacct', 'mysqlpw');
What am I missing. I have been reading articles on the internet
and
everything is talking about old versions or doing it from source not
ports. I assume this can be done from ports? From reading
I get the
feeling I installed in the wrong order, or there is more
configuration I am missings.
Can someone help point me to what I am missing here.
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
MySQL problems on FBSD 5.2.1
I installed mod_PHP which installed Apache 2 from ports. All that
works fine. I then install MySQL4 port and have it working fine
standalone. What I can't get to work is calling MySQL from PHP code.
The code hits the call to MySQL functions and does nothing, just stops
at that line and the web server puts up a blank screen. I have looked
at http error logs and nothing. I have put debug statements in the PHP
code and it does execute up to the first MySQL line trying to connect.
$db = MySQL_pconnect('localhost', 'mysqlacct', 'mysqlpw');
What am I missing. I have been reading articles on the internet and
everything is talking about old versions or doing it from source not
ports. I assume this can be done from ports? From reading I get the
feeling I installed in the wrong order, or there is more configuration I
am missings.
Can someone help point me to what I am missing here.
Thanks,
Steve B.
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL problems on FBSD 5.2.1
Don't know if the ports automaticly compile PHP with MySQL support.
Maybe install PHP from source with the --with-mysql parameter?
(Since version 5 of PHP it does not include MySQL support from its own.)
Good luck,
Zeroke
[EMAIL PROTECTED]
- Original Message -
From: steveb99 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 19, 2004 6:39 PM
Subject: MySQL problems on FBSD 5.2.1
I installed mod_PHP which installed Apache 2 from ports. All that works
fine. I then install MySQL4 port and have it working fine standalone.
What I can't get to work is calling MySQL from PHP code. The code hits
the call to MySQL functions and does nothing, just stops at that line and
the web server puts up a blank screen. I have looked at http error logs
and nothing. I have put debug statements in the PHP code and it does
execute up to the first MySQL line trying to connect.
$db = MySQL_pconnect('localhost', 'mysqlacct', 'mysqlpw');
What am I missing. I have been reading articles on the internet and
everything is talking about old versions or doing it from source not
ports. I assume this can be done from ports? From reading I get the
feeling I installed in the wrong order, or there is more configuration I
am missings.
Can someone help point me to what I am missing here.
Thanks,
Steve B.
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to
[EMAIL PROTECTED]
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL problems on FBSD 5.2.1
On Fri, Nov 19, 2004 at 06:49:37PM +0100, Zeroke wrote: Don't know if the ports automaticly compile PHP with MySQL support. No - it doesn't. Look for the entry tagged 20040719 in /usr/ports/UPDATING. It will tell you all about it. Dan -- Daniel Bye PGP Key: ftp://ftp.slightlystrange.org/pgpkey/dan.asc PGP Key fingerprint: 3B9D 8BBB EB03 BA83 5DB4 3B88 86FC F03A 90A1 BE8F _ ASCII ribbon campaign ( ) - against HTML, vCards and X - proprietary attachments in e-mail / \ pgpSzjdnoSR99.pgp Description: PGP signature
