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 28th September 2005, 10:06
pontifex pontifex is offline
Member
 
Join Date: Aug 2005
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default mysql error - db not accessible.. from outside

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

Ciao
Pontifex
Reply With Quote
Sponsored Links
  #2  
Old 28th September 2005, 11:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Quote:
Originally Posted by pontifex
Hi everyone,
i turned on the option mysql db accessible from outside, but it is not reachable. current system ist debian sarge with mysql 4.1 what am i doing wrong?

Ciao
Pontifex
Make sure the firewall on your ISPConfig box allows connections 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 28th September 2005, 11:29
pontifex pontifex is offline
Member
 
Join Date: Aug 2005
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
Make sure the firewall on your ISPConfig box allows connections to port 3306 (MySQL).
hi, as far as it is concerend i did add the port 3306 to the firewall interface of ispconfig but it did not work.

nmap shows, that mysql listens on port 3306. when i looked at the howtos for sarge. everytime mysql 4.0 was mentioned. the cnf fo 4.1 differs a little bit. so where to add the #skip-networking info there? by default there is no such line in the cnf file...


show
PM
Reply With Quote
  #4  
Old 28th September 2005, 11:40
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Quote:
Originally Posted by pontifex
hi, as far as it is concerend i did add the port 3306 to the firewall interface of ispconfig but it did not work.

nmap shows, that mysql listens on port 3306. when i looked at the howtos for sarge. everytime mysql 4.0 was mentioned. the cnf fo 4.1 differs a little bit. so where to add the #skip-networking info there? by default there is no such line in the cnf file...


show
PM
Can you post the output of
Code:
netstat -tap
here?
If you have the following line in /etc/mysql/my.cnf:
Code:
bind-address            = 127.0.0.1
comment it out and restart 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
  #5  
Old 28th September 2005, 11:57
pontifex pontifex is offline
Member
 
Join Date: Aug 2005
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by falko
Can you post the output of
Code:
netstat -tap
here?
If you have the following line in /etc/mysql/my.cnf:
Code:
bind-address            = 127.0.0.1
comment it out and restart MySQL.
Hi,
the error was caused by the bind to address 127.0.0.1. After commenting it out, it works fine now...

cheers!


PM
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
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 09:41
Mysql ejs Installation/Configuration 5 12th August 2005 07:01
Error in Instalation (mysql header) juampi Installation/Configuration 2 5th August 2005 22:37
MySQL Privileges mcfly Server Operation 4 26th May 2005 19:00


All times are GMT +2. The time now is 17:46.


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