Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 20th March 2006, 16:35
EL7oot EL7oot is offline
Junior Member
 
Join Date: Mar 2006
Posts: 24
Thanks: 1
Thanked 0 Times in 0 Posts
Default Cant connect to mysql server from outside

Hi everyone,
i turned on the option mysql db accessible from outside, but it is not reachable. current system ist Fedora Core 4 with mysql 4.1 what am i doing wrong?

i'm using "NAVICAT" program
host:82.129.14*.23*
user: web2_u1
pass:******

"errmsg"
cant connect to mysql on 82.129.14*.23* '10060'

this is my configuration

"netstat -tap"

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:imaps *:* LISTEN 1831/xinetd
tcp 0 0 *:32769 *:* LISTEN 1439/rpc.statd
tcp 0 0 *op3s *:* LISTEN 1831/xinetd
tcp 0 0 *:mysql *:* LISTEN 13672/mysqld
tcp 0 0 *op3 *:* LISTEN 1831/xinetd
tcp 0 0 *:imap *:* LISTEN 1831/xinetd
tcp 0 0 *:sunrpc *:* LISTEN 1421/portmap
tcp 0 0 *:10000 *:* LISTEN 2515/perl
tcp 0 0 *:81 *:* LISTEN 2237/ispconfig_http
tcp 0 0 82.129.14*.23*:domain *:* LISTEN 1518/named
tcp 0 0 192.168.0.101:domain *:* LISTEN 1518/named
tcp 0 0 82.129.14*.25*:domain *:* LISTEN 1518/named
tcp 0 0 server1.******.com:domain *:* LISTEN 1518/named
tcp 0 0 *:ftp *:* LISTEN 30747/proftpd: (acc
tcp 0 0 server1.*****.com:ipp *:* LISTEN 29460/cupsd
tcp 0 0 server1.*****.com:5335 *:* LISTEN 1739/mDNSResponder
tcp 0 0 server1.*****.com:rndc *:* LISTEN 1518/named
tcp 0 0 *:smtp *:* LISTEN 373/master
tcp 0 0 *:http *:* LISTEN 2381/httpd
tcp 0 0 *:ssh *:* LISTEN 1822/sshd
tcp 0 0 ::1:rndc *:* LISTEN 1518/named
tcp 0 0 *:https *:* LISTEN 2381/httpd
tcp 0 148 ::ffff:82.129.14*.25*:ssh ::ffff:82.129.14*.24*:3631 ESTABLISHED 26342/1
tcp 0 0 ::ffff:82.129.141.239:http rndgw1.beelinegprs.ru:6023 TIME_WAIT -
--------------------------------------------------------------------------
"/etc/my.cnf"
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
--------------------------------------------------------------------------
Note: i'm very new to linux

i'm using Fedora Core 4 with tow real ip's
thanx....

Last edited by EL7oot; 20th March 2006 at 18:35.
Reply With Quote
Sponsored Links
  #2  
Old 21st March 2006, 00:32
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Is maybe your firewall blocking requests to port 3306 (MySQL)?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 21st March 2006, 10:56
EL7oot EL7oot is offline
Junior Member
 
Join Date: Mar 2006
Posts: 24
Thanks: 1
Thanked 0 Times in 0 Posts
Default

firstly thank you for interesting ....

but no i have already created rule to accept the port 3306 and this is my firewall rules from ispconfig managment section

FTP 21 tcp yes
SSH 22 tcp yes
SMTP 25 tcp yes
DNS 53 tcp yes
DNS 53 udp yes
WWW 80 tcp yes
ISPConfig 81 tcp yes
POP3 110 tcp yes
SSL (www) 443 tcp yes
Webmin 10000 tcp yes
Mysqld 3306 tcp yes

NOTE: i have tried to log in with root account,
the program returned with this error
"1045 - access denied for user 'root@82.129.14*.24*' (using password:Yes )"

*this ip is for the client machine

have you any idea aboute this problem?

sorry aboute my bad english..,

Last edited by EL7oot; 21st March 2006 at 11:03.
Reply With Quote
  #4  
Old 21st March 2006, 12:08
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
Default

Quote:
Originally Posted by EL7oot
NOTE: i have tried to log in with root account,
the program returned with this error
"1045 - access denied for user 'root@82.129.14*.24*' (using password:Yes )"
If you want to access a database from outside which you created in ISPConfig, you must use the username and password you set in ISPConfig for this database, not the root user.

If you want to connect with root from outside, you will have to change the permissions for the root user in the mysql user database table and reload mysql.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 21st March 2006, 14:20
madlew madlew is offline
Junior Member
 
Join Date: Mar 2006
Location: Kent, UK
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I to get the same problem when trying to use mySQL-Front even on my internal networ.
__________________
The only thing I know about Linux is that I can spell it
Reply With Quote
  #6  
Old 21st March 2006, 15:59
brainz brainz is offline
Senior Member
 
Join Date: Feb 2006
Location: Sydney, Australia
Posts: 165
Thanks: 9
Thanked 3 Times in 1 Post
Default

Only a suggestion but if your in a NAT enviroment...

Usually wouldnt you need to either port forward port 3306 to the servers internal ip address and (im thinking rather then connecting to root@82.129.14*.24* the connection should be to something like this root@localhost or root@192.168.*.*) in your router and also if the router has a firewall to allow for external connections to port 3306

regards
brainz

Last edited by brainz; 21st March 2006 at 16:28.
Reply With Quote
  #7  
Old 21st March 2006, 17:46
EL7oot EL7oot is offline
Junior Member
 
Join Date: Mar 2006
Posts: 24
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by brainz
Only a suggestion but if your in a NAT enviroment...

Usually wouldnt you need to either port forward port 3306 to the servers internal ip address and (im thinking rather then connecting to root@82.129.14*.24* the connection should be to something like this root@localhost or root@192.168.*.*) in your router and also if the router has a firewall to allow for external connections to port 3306

regards
brainz
thanx braniz for ur suggestion but i'm using real ip address and i'm already connected with other db's on another servers on same port .

thanx every body for helping me

i have solved the problem ...

and i don't know how
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Statistic not working mzo Installation/Configuration 49 20th April 2011 13:19
error 2003: Can't connect to MySQL server jorge Installation/Configuration 1 2nd March 2006 07:25
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04
Email - Ueb-Miau mazhar Installation/Configuration 5 21st December 2005 11:01
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 03:30


All times are GMT +2. The time now is 04:00.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.