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 1st February 2006, 15:31
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
Default Cant connect to MYSQL database from Dreamweaver

Hi.

I have a Breezy Badger ISPConfig runnig all ok, im trying to connect to a database from Dreamweaver MX2004, but i cant, i use the following settings in connection:

Connetion:Test
MySQL server: www.xxx.com
User: Web9_u4 or root
Password: mypass
Database: Web9_db4
I allways get an "2013 Lost Connection to MYSQL server during query" error.
Can you help me to fix this problem pls.

Hector

PD i´ve set remote access in ISPConfig to yes for this database.
Reply With Quote
Sponsored Links
  #2  
Old 1st February 2006, 16:53
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
Default

Hi.

Me again...i tryied to connect from the odbc connector and got same results.....pls help me

Hector

PD [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'xxx.com' (10061)

Last edited by toyito; 1st February 2006 at 16:55.
Reply With Quote
  #3  
Old 1st February 2006, 17:36
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,490
Thanks: 835
Thanked 5,525 Times in 4,346 Posts
Default

Is mySQL listening on all IP addresses? Please post the output of:

netstat -tap
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 1st February 2006, 17:40
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
Default

Hi Till

Output of netstat -tap

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost.localdo:mysql *:* LISTEN 6290/mysqld
tcp 0 0 *:81 *:* LISTEN 6488/ispconfig_http
tcp 0 0 server1.example.:domain *:* LISTEN 15368/named
tcp 0 0 localhost.locald:domain *:* LISTEN 15368/named
tcp 0 0 *:ftp *:* LISTEN 4855/proftpd: (acce
tcp 0 0 localhost.localdoma:953 *:* LISTEN 15368/named
tcp 0 0 *:smtp *:* LISTEN 4938/master
tcp6 0 0 *:imaps *:* LISTEN 6200/couriertcpd
tcp6 0 0 *op3s *:* LISTEN 6235/couriertcpd
tcp6 0 0 *op3 *:* LISTEN 6215/couriertcpd
tcp6 0 0 *:imap2 *:* LISTEN 6180/couriertcpd
tcp6 0 0 *:www *:* LISTEN 12109/apache2
tcp6 0 0 *:ssh *:* LISTEN 6428/sshd
tcp6 0 0 ip6-localhost:953 *:* LISTEN 15368/named
tcp6 0 0 *:https *:* LISTEN 12109/apache2
tcp6 0 1796 server1.example.com:ssh ::ffff:10.22.0.172:4845 ESTABLISHED15607/0
Reply With Quote
  #5  
Old 1st February 2006, 17:46
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

Quote:
Originally Posted by toyito
tcp 0 0 localhost.localdo:mysql *:* LISTEN 6290/mysqld
MySQL is listening only on 127.0.0.1.
Please comment out the line
Code:
bind-address            = 127.0.0.1
in /etc/mysql/my.cnf 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
  #6  
Old 1st February 2006, 17:52
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
 
Default


Thank you....thanks a lot

Hector
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
Client Website MySQL Database Names Lister Installation/Configuration 4 12th January 2008 18:21
Mail System doesnt work! crichton Installation/Configuration 3 18th September 2007 00:49
Limit mysql database size ddelbia Feature Requests 14 25th April 2006 22:42
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04
Failed at MySQL lhatle Installation/Configuration 4 29th November 2005 02:26


All times are GMT +2. The time now is 20:33.


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