RE: Help...I am desparate
No...One machine eventually worked on port 1000, and another I changed the port back to the standard port 3306. I have run into this before and don't know what makes it finally run. My security folks asked me to run on port 1000 or another port less than 1024. Fortunately the machine they were concerned about did finally work on 1000...but I do not know why. Thanks for everyone's suggestions, Connie Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-2879 Happiness is found along the way, not at the end of the road, and 'IF' is the middle word in life. -Original Message- From: Caroline Jen [mailto:[EMAIL PROTECTED] Sent: Thursday, January 05, 2006 10:13 AM To: Logg, Connie A. Subject: Re: Help...I am desparate Is there anything in your PC listening to Port 1000? It seems that there is a conflict. --- Logg, Connie A. [EMAIL PROTECTED] wrote: I am trying to start mysql and I keep getting the following error. There is no other server or anything else using port 1000. I have checked netstat and the port is not active. 60103 15:54:02 mysqld started 060103 15:54:02 InnoDB: Started; log sequence number 0 386242 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? 060103 15:54:02 [ERROR] Aborting 060103 15:54:02 InnoDB: Starting shutdown... 060103 15:54:04 InnoDB: Shutdown completed; log sequence number 0 386242 060103 15:54:04 [Note] /usr/sbin/mysqld: Shutdown complete 060103 15:54:04 mysqld ended My /etc/my.cnf file is: [EMAIL PROTECTED] v3src]$ more /etc/my.cnf [mysqld] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [mysqld.server] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [client] socket=/home/iepm/mysql/mysql.sock port=1000 The system had crashed and burned because of a disk error so I have loaded it with the following rpms [EMAIL PROTECTED] v3src]$ rpm -qa | grep -i mysql MySQL-client-standard-5.0.18-0.rhel3 MySQL-server-standard-5.0.18-0.rhel3 MySQL-standard-debuginfo-5.0.18-0.rhel3 MySQL-shared-standard-5.0.18-0.rhel3 MySQL-devel-standard-5.0.18-0.rhel3 The machine is running: Linux socrates.xxx.xxx.xxx 2.4.21-27.0.2.ELsmp #1 SMP Tue Jan 18 19:25:35 CST 2005 i686 i686 i386 GNU/Linux And the release is: [EMAIL PROTECTED] v3src]$ more /etc/redhat-release Scientific Linux SL Release 3.0.4 (SL) [EMAIL PROTECTED] v3src]$ I have not been able to load the perl DBD bundle either. I do: /usr/bin/perl -MCPAN -e 'install::DBD::mysql' and it complains because the server isn't running. I actually am having this problem also on a system running mysql Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686) It will not sucessfully install the perl bundle there. I have run into these problems several times in the past, and eventually tried everything I have tried today, and something usually breaks it loose...but I have had no luck for several days now. Any help you can provide will be greatly appreciated. Connie Logg Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-2879 Happiness is found along the way, not at the end of the road, and 'IF' is the middle word in life. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Yahoo! DSL - Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help...I am desparate
I suppose you could set the suid bit on mysqld binary. But that itself will be a security risk. I am not sure why your security folks are insisting on ports below 1024. I hope they realize anything running under 1024 must be run as root. And anything running root can pose a serious security risk. On 1/5/06, Logg, Connie A. [EMAIL PROTECTED] wrote: No...One machine eventually worked on port 1000, and another I changed the port back to the standard port 3306. I have run into this before and don't know what makes it finally run. My security folks asked me to run on port 1000 or another port less than 1024. Fortunately the machine they were concerned about did finally work on 1000...but I do not know why. Thanks for everyone's suggestions, Connie Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-2879 Happiness is found along the way, not at the end of the road, and 'IF' is the middle word in life. -Original Message- From: Caroline Jen [mailto:[EMAIL PROTECTED] Sent: Thursday, January 05, 2006 10:13 AM To: Logg, Connie A. Subject: Re: Help...I am desparate Is there anything in your PC listening to Port 1000? It seems that there is a conflict. --- Logg, Connie A. [EMAIL PROTECTED] wrote: I am trying to start mysql and I keep getting the following error. There is no other server or anything else using port 1000. I have checked netstat and the port is not active. 60103 15:54:02 mysqld started 060103 15:54:02 InnoDB: Started; log sequence number 0 386242 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? 060103 15:54:02 [ERROR] Aborting 060103 15:54:02 InnoDB: Starting shutdown... 060103 15:54:04 InnoDB: Shutdown completed; log sequence number 0 386242 060103 15:54:04 [Note] /usr/sbin/mysqld: Shutdown complete 060103 15:54:04 mysqld ended My /etc/my.cnf file is: [EMAIL PROTECTED] v3src]$ more /etc/my.cnf [mysqld] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [mysqld.server] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [client] socket=/home/iepm/mysql/mysql.sock port=1000 The system had crashed and burned because of a disk error so I have loaded it with the following rpms [EMAIL PROTECTED] v3src]$ rpm -qa | grep -i mysql MySQL-client-standard-5.0.18-0.rhel3 MySQL-server-standard-5.0.18-0.rhel3 MySQL-standard-debuginfo-5.0.18-0.rhel3 MySQL-shared-standard-5.0.18-0.rhel3 MySQL-devel-standard-5.0.18-0.rhel3 The machine is running: Linux socrates.xxx.xxx.xxx 2.4.21-27.0.2.ELsmp #1 SMP Tue Jan 18 19:25:35 CST 2005 i686 i686 i386 GNU/Linux And the release is: [EMAIL PROTECTED] v3src]$ more /etc/redhat-release Scientific Linux SL Release 3.0.4 (SL) [EMAIL PROTECTED] v3src]$ I have not been able to load the perl DBD bundle either. I do: /usr/bin/perl -MCPAN -e 'install::DBD::mysql' and it complains because the server isn't running. I actually am having this problem also on a system running mysql Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686) It will not sucessfully install the perl bundle there. I have run into these problems several times in the past, and eventually tried everything I have tried today, and something usually breaks it loose...but I have had no luck for several days now. Any help you can provide will be greatly appreciated. Connie Logg Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-2879 Happiness is found along the way, not at the end of the road, and 'IF' is the middle word in life. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Yahoo! DSL - Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- http://chatter.mirislam.com/
Help...I am desparate
I am trying to start mysql and I keep getting the following error. There is no other server or anything else using port 1000. I have checked netstat and the port is not active. 60103 15:54:02 mysqld started 060103 15:54:02 InnoDB: Started; log sequence number 0 386242 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? 060103 15:54:02 [ERROR] Aborting 060103 15:54:02 InnoDB: Starting shutdown... 060103 15:54:04 InnoDB: Shutdown completed; log sequence number 0 386242 060103 15:54:04 [Note] /usr/sbin/mysqld: Shutdown complete 060103 15:54:04 mysqld ended My /etc/my.cnf file is: [EMAIL PROTECTED] v3src]$ more /etc/my.cnf [mysqld] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [mysqld.server] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [client] socket=/home/iepm/mysql/mysql.sock port=1000 The system had crashed and burned because of a disk error so I have loaded it with the following rpms [EMAIL PROTECTED] v3src]$ rpm -qa | grep -i mysql MySQL-client-standard-5.0.18-0.rhel3 MySQL-server-standard-5.0.18-0.rhel3 MySQL-standard-debuginfo-5.0.18-0.rhel3 MySQL-shared-standard-5.0.18-0.rhel3 MySQL-devel-standard-5.0.18-0.rhel3 The machine is running: Linux socrates.xxx.xxx.xxx 2.4.21-27.0.2.ELsmp #1 SMP Tue Jan 18 19:25:35 CST 2005 i686 i686 i386 GNU/Linux And the release is: [EMAIL PROTECTED] v3src]$ more /etc/redhat-release Scientific Linux SL Release 3.0.4 (SL) [EMAIL PROTECTED] v3src]$ I have not been able to load the perl DBD bundle either. I do: /usr/bin/perl -MCPAN -e 'install::DBD::mysql' and it complains because the server isn't running. I actually am having this problem also on a system running mysql Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686) It will not sucessfully install the perl bundle there. I have run into these problems several times in the past, and eventually tried everything I have tried today, and something usually breaks it loose...but I have had no luck for several days now. Any help you can provide will be greatly appreciated. Connie Logg Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-2879 Happiness is found along the way, not at the end of the road, and 'IF' is the middle word in life. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help...I am desparate
Hi Connie, 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? You can't bind to a port less than 1024 unless you're running as root. I suspect that's the problem here. Try another port, higher than 1024. I'm kind of curious why you aren't running it on the standard 3306? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help...I am desparate
I was asked (told) by my security people to use a port 1024. I am running with 1000 other places, and was running with 1000 on both of these machines. -Original Message- From: Jeremy Cole [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 03, 2006 4:25 PM To: Logg, Connie A. Cc: mysql@lists.mysql.com Subject: Re: Help...I am desparate Hi Connie, 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? You can't bind to a port less than 1024 unless you're running as root. I suspect that's the problem here. Try another port, higher than 1024. I'm kind of curious why you aren't running it on the standard 3306? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help...I am desparate
Logg, Connie A. wrote: I was asked (told) by my security people to use a port 1024. I am running with 1000 other places, and was running with 1000 on both of these machines. -Original Message- From: Jeremy Cole [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 03, 2006 4:25 PM To: Logg, Connie A. Cc: mysql@lists.mysql.com Subject: Re: Help...I am desparate Hi Connie, 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? You can't bind to a port less than 1024 unless you're running as root. I suspect that's the problem here. Try another port, higher than 1024. I'm kind of curious why you aren't running it on the standard 3306? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 This might work... 1. Follow the steps in http://dev.mysql.com/doc/refman/4.1/en/changing-mysql-user.html 2. Run the mysql init script as root. However, if MySQL drops privileges before binding to its sockets, then it won't work. I'm afraid I don't know that much about MySQL's internals. --Ludwig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
