Re: Can't Bind to Port

[Christophe Gregoir]

Drew Jenkins wrote:
> ----- Original Message ----
> From: Borokov Smith <borokov@stripped>
> To: Drew Jenkins <drewjenkinsjr@stripped>
> Cc: mysql@stripped
> Sent: Friday, March 2, 2007 6:21:59 PM
> Subject: Re: Can't Bind to Port
>
>   
>> netstat -nlp | grep 3306
>>     
>
> Option p requires a protocol. What protocol should I give it?
> Drew
>   

Maybe on FreeBSD :)
do netstat -nl | grep 3306 then

it should show you which process is occupying port 3306.
and you can take it up from there.

greetz,

boro




> greetz,
>
> boro
>
> Drew Jenkins wrote:
>   
>> Hi;
>> I just installed MySQL from FreeBSD port. I specified using openssl. Outside of
> that, I changed nothing. I copied over the /etc/my.cnf as is, leaving the innodb stuff
> commented out. In preparing to install my database, I got this error:
>>
>> server312# mkdir /usr/local/localhost
>> server312# chown mysql:mysql /usr/local/localhost/
>> server312# /usr/local/libexec/mysqld -uroot -hlocalhost
> --max_allowed_packet=999M
>> InnoDB: The first specified data file ./ibdata1 did not exist:
>> InnoDB: a new database to be created!
>> 070302 15:58:29  InnoDB: Setting file ./ibdata1 size to 10 MB
>> InnoDB: Database physically writes the file full: wait...
>> 070302 15:58:29  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
>> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
>> InnoDB: Database physically writes the file full: wait...
>> 070302 15:58:29  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
>> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
>> InnoDB: Database physically writes the file full: wait...
>> InnoDB: Doublewrite buffer not found: creating new
>> InnoDB: Doublewrite buffer created
>> InnoDB: Creating foreign key constraint system tables
>> InnoDB: Foreign key constraint system tables created
>> 070302 15:58:29  InnoDB: Started; log sequence number 0 0
>> /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist
>> 070302 15:58:29 [ERROR] Can't start server: Bind on TCP/IP port: Address already
> in use
>> 070302 15:58:29 [ERROR] Do you already have another mysqld server running on
> port: 3306 ?
>> 070302 15:58:29 [ERROR] Aborting
>>
>> 070302 15:58:30  InnoDB: Starting shutdown...
>> 070302 15:58:32  InnoDB: Shutdown completed; log sequence number 0 46403
>> 070302 15:58:32 [Note] /usr/local/libexec/mysqld: Shutdown complete
>>
>> # ps wax|grep mysqld
>>  3986  p1- I      0:00.01 /bin/sh /usr/local/bin/mysqld_safe
>>  4034  p1- I      0:11.16 /usr/local/libexec/mysqld --basedir=/usr/local
> --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my
>>
>> server312# nmap localhost
>>
>> Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2007-03-02 16:02 UTC
>> Interesting ports on localhost.by2012.com (127.0.0.1):
>> Not shown: 1672 closed ports
>> PORT     STATE SERVICE
>> 22/tcp   open  ssh
>> 25/tcp   open  smtp
>> 110/tcp  open  pop3
>> 143/tcp  open  imap
>> 993/tcp  open  imaps
>> 3306/tcp open  mysql
>> 8021/tcp open  ftp-proxy
>> 8080/tcp open  http-proxy
>>
>> I presume everything went well here until it went to bind to the port. There's no
> other MySQL running on the server, so why can't it connect to the port? This server isn't
> yet set up with an URL, so if it's reading from rc.conf or what have you, that could be
> tripping it up. Please advise.
>> TIA,
>> Drew
>>
>>
>>
>>
>>  
>>
> ____________________________________________________________________________________
>> Finding fabulous fares is fun.  
>> Let Yahoo! FareChase search your favorite travel sites to find flight and hotel
> bargains.
>> http://farechase.yahoo.com/promo-generic-14795097
>>   
>>     
>
>
>
>
>
>
>
>
>  
> ____________________________________________________________________________________
> Looking for earth-friendly autos? 
> Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
> http://autos.yahoo.com/green_center/
>