RE: telnet localhost 3306 Connection refused [SOLVED]

[Daevid Vincent]

Yep. That was it. No firewall rules needed to change.  

> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, July 07, 2005 1:24 AM
> To: mysql@lists.mysql.com
> Subject: Re: telnet localhost 3306 Connection refused
> 
> Hello.
> 
> 
> 
> Are you sure that mysql is running? Is it possible that you have
> 
> skip_networking in your configuration file? See:
> 
>   http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
> 
> 
> 
> 
> 
> 
> 
> "Daevid Vincent" <[EMAIL PROTECTED]> wrote:
> 
> > What is causing me to have this problem in "mysql  Ver 
> 12.22 Distrib 4.0.24,
> 
> > for pc-linux-gnu (i686)". I am running shorewall, but that 
> shouldn't affect
> 
> > localhost should it? My firewall, web, and mySQL server are the same
> 
> > machine.
> 
> > 
> 
> > # telnet localhost 3306
> 
> > Trying 127.0.0.1...
> 
> > telnet: Unable to connect to remote host: Connection refused
> 
> > 
> 
> > I've tried to comment, uncomment and change to * this 
> 'bind-address' line in
> 
> > /etc/mysql/my.cnf
> 
> > # keep secure by default!
> 
> > #bind-address= 127.0.0.1
> 
> > #bind-address= *
> 
> > port= 3306
> 
> > 
> 
> > Of course, I can't connect from any of the other IP 
> addresses that my mySQL
> 
> > server is assigned either:
> 
> > 
> 
> > # telnet 192.168.1.1 3306
> 
> > Trying 192.168.1.1...
> 
> > telnet: Unable to connect to remote host: Connection refused
> 
> > 
> 
> > # telnet 10.10.10.1 3306
> 
> > Trying 10.10.10.1...
> 
> > telnet: Unable to connect to remote host: Connection refused
> 
> > 
> 
> > 
> 
> > # ifconfig
> 
> > eth1  Link encap:Ethernet 
> 
> >  inet addr:192.168.1.1  Bcast:192.168.1.255  
> Mask:255.255.255.0
> 
> > loLink encap:Local Loopback  
> 
> >  inet addr:127.0.0.1  Mask:255.0.0.0
> 
> > wlan0 Link encap:Ethernet
> 
> >  inet addr:10.10.10.1  Bcast:10.255.255.255  
> Mask:255.255.255.0
> 
> > 
> 
> > 
> 
> 
> 
> -- 
> For technical support contracts, goto 
> https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
><___/   www.mysql.com
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: telnet localhost 3306 Connection refused

[l'[EMAIL PROTECTED]]

Have you checked that the user failing to connect has the right privileges?
Check the user table of mysql database to see if that user has a select 
privilege in that table.


Laurie

At 01:01 AM 7/7/2005, Daevid Vincent wrote:

What is causing me to have this problem in "mysql  Ver 12.22 Distrib 4.0.24,
for pc-linux-gnu (i686)". I am running shorewall, but that shouldn't affect
localhost should it? My firewall, web, and mySQL server are the same
machine.

# telnet localhost 3306
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

I've tried to comment, uncomment and change to * this 'bind-address' line in
/etc/mysql/my.cnf
# keep secure by default!
#bind-address= 127.0.0.1
#bind-address= *
port= 3306

Of course, I can't connect from any of the other IP addresses that my mySQL
server is assigned either:

# telnet 192.168.1.1 3306
Trying 192.168.1.1...
telnet: Unable to connect to remote host: Connection refused

# telnet 10.10.10.1 3306
Trying 10.10.10.1...
telnet: Unable to connect to remote host: Connection refused


# ifconfig
eth1  Link encap:Ethernet
  inet addr:192.168.1.1  Bcast:192.168.1.255  Mask:255.255.255.0
loLink encap:Local Loopback
  inet addr:127.0.0.1  Mask:255.0.0.0
wlan0 Link encap:Ethernet
  inet addr:10.10.10.1  Bcast:10.255.255.255  Mask:255.255.255.0


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: telnet localhost 3306 Connection refused

[Gleb Paharenko]

Hello.



Are you sure that mysql is running? Is it possible that you have

skip_networking in your configuration file? See:

  http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html







"Daevid Vincent" <[EMAIL PROTECTED]> wrote:

> What is causing me to have this problem in "mysql  Ver 12.22 Distrib 4.0.24,

> for pc-linux-gnu (i686)". I am running shorewall, but that shouldn't affect

> localhost should it? My firewall, web, and mySQL server are the same

> machine.

> 

> # telnet localhost 3306

> Trying 127.0.0.1...

> telnet: Unable to connect to remote host: Connection refused

> 

> I've tried to comment, uncomment and change to * this 'bind-address' line in

> /etc/mysql/my.cnf

> # keep secure by default!

> #bind-address= 127.0.0.1

> #bind-address= *

> port= 3306

> 

> Of course, I can't connect from any of the other IP addresses that my mySQL

> server is assigned either:

> 

> # telnet 192.168.1.1 3306

> Trying 192.168.1.1...

> telnet: Unable to connect to remote host: Connection refused

> 

> # telnet 10.10.10.1 3306

> Trying 10.10.10.1...

> telnet: Unable to connect to remote host: Connection refused

> 

> 

> # ifconfig

> eth1  Link encap:Ethernet 

>  inet addr:192.168.1.1  Bcast:192.168.1.255  Mask:255.255.255.0

> loLink encap:Local Loopback  

>  inet addr:127.0.0.1  Mask:255.0.0.0

> wlan0 Link encap:Ethernet

>  inet addr:10.10.10.1  Bcast:10.255.255.255  Mask:255.255.255.0

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: telnet localhost 3306 Connection refused

[Ady Wicaksono]

Try

/sbin/iptables -L -n

make sure there's no rule that block connection to/from port 3306 (TCP)


Daevid Vincent wrote:


What is causing me to have this problem in "mysql  Ver 12.22 Distrib 4.0.24,
for pc-linux-gnu (i686)". I am running shorewall, but that shouldn't affect
localhost should it? My firewall, web, and mySQL server are the same
machine.

# telnet localhost 3306
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

I've tried to comment, uncomment and change to * this 'bind-address' line in
/etc/mysql/my.cnf
# keep secure by default!
#bind-address= 127.0.0.1
#bind-address= *
port= 3306

Of course, I can't connect from any of the other IP addresses that my mySQL
server is assigned either:

# telnet 192.168.1.1 3306
Trying 192.168.1.1...
telnet: Unable to connect to remote host: Connection refused

# telnet 10.10.10.1 3306
Trying 10.10.10.1...
telnet: Unable to connect to remote host: Connection refused


# ifconfig
eth1  Link encap:Ethernet 
 inet addr:192.168.1.1  Bcast:192.168.1.255  Mask:255.255.255.0
loLink encap:Local Loopback  
 inet addr:127.0.0.1  Mask:255.0.0.0
wlan0 Link encap:Ethernet
 inet addr:10.10.10.1  Bcast:10.255.255.255  Mask:255.255.255.0



 




--
Regards,
Ady Wicaksono
HP: +628562208680


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: telnet localhost 3306 Connection refused

[Philippe Poelvoorde]

Daevid Vincent wrote:

What is causing me to have this problem in "mysql  Ver 12.22 Distrib 4.0.24,
for pc-linux-gnu (i686)". I am running shorewall, but that shouldn't affect
localhost should it? My firewall, web, and mySQL server are the same
machine.


Shorewall can affect localhost as well
Try adding :

ACCEPT  fw  fw  udp 3306
ACCEPT  fw  fw  tcp 3306

in your /etc/shorewall/rules (where fw is the zone represented by your 
machine, it depends on your settings).

You should also add the settings for http ( port 80 ).

And eventually change the logging mode for dropped paquets, that should 
give you a clue.


--
Philippe Poelvoorde
COS Trading Ltd.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: telnet localhost 3306 Connection refused

[Louie Miranda]

ps ax|grep sql

if mysql is running. and if you telnet to that port (3306) and still you 
can't connect.

check if you have blocked your port on your firewall.

usually, firewall for linux are iptables and ipchains

flush them first and try.

HTH

On 7/7/05, Daevid Vincent <[EMAIL PROTECTED]> wrote:
> 
> What is causing me to have this problem in "mysql Ver 12.22 Distrib 4.0.24
> ,
> for pc-linux-gnu (i686)". I am running shorewall, but that shouldn't 
> affect
> localhost should it? My firewall, web, and mySQL server are the same
> machine.
> 
> # telnet localhost 3306
> Trying 127.0.0.1...
> telnet: Unable to connect to remote host: Connection refused
> 
> I've tried to comment, uncomment and change to * this 'bind-address' line 
> in
> /etc/mysql/my.cnf
> # keep secure by default!
> #bind-address = 127.0.0.1 
> #bind-address = *
> port = 3306
> 
> Of course, I can't connect from any of the other IP addresses that my 
> mySQL
> server is assigned either:
> 
> # telnet 192.168.1.1  3306
> Trying 192.168.1.1...
> telnet: Unable to connect to remote host: Connection refused
> 
> # telnet 10.10.10.1  3306
> Trying 10.10.10.1...
> telnet: Unable to connect to remote host: Connection refused
> 
> 
> # ifconfig
> eth1 Link encap:Ethernet
> inet addr:192.168.1.1  
> Bcast:192.168.1.255Mask:
> 255.255.255.0 
> lo Link encap:Local Loopback
> inet addr:127.0.0.1  Mask:255.0.0.0 
> wlan0 Link encap:Ethernet
> inet addr:10.10.10.1  
> Bcast:10.255.255.255Mask:
> 255.255.255.0 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


-- 
Louie Miranda
http://www.axishift.com -- under development

telnet localhost 3306 Connection refused

[Daevid Vincent]

What is causing me to have this problem in "mysql  Ver 12.22 Distrib 4.0.24,
for pc-linux-gnu (i686)". I am running shorewall, but that shouldn't affect
localhost should it? My firewall, web, and mySQL server are the same
machine.

# telnet localhost 3306
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

I've tried to comment, uncomment and change to * this 'bind-address' line in
/etc/mysql/my.cnf
# keep secure by default!
#bind-address= 127.0.0.1
#bind-address= *
port= 3306

Of course, I can't connect from any of the other IP addresses that my mySQL
server is assigned either:

# telnet 192.168.1.1 3306
Trying 192.168.1.1...
telnet: Unable to connect to remote host: Connection refused

# telnet 10.10.10.1 3306
Trying 10.10.10.1...
telnet: Unable to connect to remote host: Connection refused


# ifconfig
eth1  Link encap:Ethernet 
  inet addr:192.168.1.1  Bcast:192.168.1.255  Mask:255.255.255.0
loLink encap:Local Loopback  
  inet addr:127.0.0.1  Mask:255.0.0.0
wlan0 Link encap:Ethernet
  inet addr:10.10.10.1  Bcast:10.255.255.255  Mask:255.255.255.0


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]