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 30th May 2006, 17:04
The General The General is offline
Member
 
Join Date: Apr 2006
Location: U.K
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connecting to Mysql database from Dreamweaver

i have managed to set up a site in dreamweaver that is located on the ispconfig server and i can post files to and from the ispconfig folders. i have set up a database with remote access enabled for the domain, but i cant find any help on connecting to the database my dreamwever ip address is 192.168.0.1 my ISPconfig is on a DMZ on 192.168.1.2


Dreamwever Connection setting are

Connection name :Test
MySQL Server:192.168.1.2
Username:web3_u1
database:web3_db1

the netstat -tap is:

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:imaps *:* LISTEN 2216/xinetd
tcp 0 0 *:32769 *:* LISTEN 1855/rpc.statd
tcp 0 0 *op3s *:* LISTEN 2216/xinetd
tcp 0 0 *:mysql *:* LISTEN 2307/mysqld
tcp 0 0 *op3 *:* LISTEN 2216/xinetd
tcp 0 0 *:imap *:* LISTEN 2216/xinetd
tcp 0 0 *:sunrpc *:* LISTEN 1837/portmap
tcp 0 0 *:81 *:* LISTEN 2663/ispconfig_http
tcp 0 0 *:ftp *:* LISTEN 2966/proftpd: (acce
tcp 0 0 192.168.1.3:domain *:* LISTEN 2949/named
tcp 0 0 192.168.1.2:domain *:* LISTEN 2949/named
tcp 0 0 localhost.localdomai:domain *:* LISTEN 2949/named
tcp 0 0 localhost.localdomain:ipp *:* LISTEN 2172/cupsd
tcp 0 0 localhost.localdomain:5335 *:* LISTEN 2154/mDNSResponder
tcp 0 0 *:smtp *:* LISTEN 6566/master
tcp 0 0 localhost.localdomain:rndc *:* LISTEN 2949/named
tcp 0 0 localhost.localdomain:50284 localhost.localdomain:http TIME_WAIT -
tcp 0 0 localhost.localdomain:60087 localhost.localdomain:ftp TIME_WAIT -
tcp 0 0 *:http *:* LISTEN 2852/httpd
tcp 0 0 *:ssh *:* LISTEN 2207/sshd
tcp 0 0 *:https *:* LISTEN 2852/httpd


Any ideas cus my brain is exploding!... :-)

Last edited by The General; 30th May 2006 at 17:22.
Reply With Quote
Sponsored Links
  #2  
Old 31st May 2006, 00:22
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

Which hostname do you use to connect to MySQL? Is it one of the hostnames listed in the Host column in the mysql.users table?
__________________
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 31st May 2006, 15:01
The General The General is offline
Member
 
Join Date: Apr 2006
Location: U.K
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Default

sorry for the late reply,

well ive have tried ns1.***.com which is in the mysql.users file but i keep getting "ERROR 404" from dreamweaver i have tried the local IP address, net public ip address in fact i have even thought about trying my mothers maiden name!LOL.

if i put a PHP page up on the server and call it via internet explorer and code the login to mysql server as $host=localhost $user=root $password=*** it all works fine. i just cant get the connection between dreamweaver and Ispconfig's Mysql to work ... hO hum!
Reply With Quote
  #4  
Old 31st May 2006, 18:11
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,391
Thanks: 833
Thanked 5,486 Times in 4,318 Posts
Default

Quote:
Originally Posted by The General
sorry for the late reply,

well ive have tried ns1.***.com which is in the mysql.users file but i keep getting "ERROR 404" from dreamweaver i have tried the local IP address, net public ip address in fact i have even thought about trying my mothers maiden name!LOL.
Are you sure you get this error "ERROR 404" from mysql? This is an http error code.

Quote:
if i put a PHP page up on the server and call it via internet explorer and code the login to mysql server as $host=localhost $user=root $password=*** it all works fine. i just cant get the connection between dreamweaver and Ispconfig's Mysql to work ... hO hum!
The mysql is not from ISPConfig, it is the database package from your linux distribution. Did you check the "external access" checkbox as you created the database?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 31st May 2006, 22:11
The General The General is offline
Member
 
Join Date: Apr 2006
Location: U.K
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i don't get error "404" from MySQL i get it from Dreamweaver when i try to make a connection to the MySQL database on the server. I also know that Mysql seperate a seperate package to ISPConfig. I just cant understand why i cant make a connection to MySQL from Dreamweaver MX. I can log onto the server from Dreamweaver MX and get a display of the folders for the Site that i am working on but when i go to maje a datbase connection i just get the above error.

Thx
Reply With Quote
  #6  
Old 31st May 2006, 23:54
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

Does ns1.***.com exist in DNS? Please check with
Code:
dig ns1.***.com
__________________
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
  #7  
Old 1st June 2006, 13:28
The General The General is offline
Member
 
Join Date: Apr 2006
Location: U.K
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The "A record" points to my public IP address so i guess so! The only thing i was thinking was could it be because im on a differant network address as in Dreamweaver on GREEN 192.168.0.1 and Mysql on DMZ on 192.168.1.2

Last edited by The General; 1st June 2006 at 13:31.
Reply With Quote
  #8  
Old 1st June 2006, 17:04
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

Does your router forward port 3306 to your MySQL server?
__________________
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
  #9  
Old 1st June 2006, 23:19
The General The General is offline
Member
 
Join Date: Apr 2006
Location: U.K
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yep port is forwarded to server and firewall port on server is open
Reply With Quote
  #10  
Old 1st June 2006, 23:35
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,036
Thanks: 268
Thanked 153 Times in 133 Posts
 
Default

Try using the IP:3306 instead of the domainname.

** edit..
I see.. You've been doing it that way allready :-/

Quote:
Connection name :Test
MySQL Server:192.168.1.2
Username:web3_u1
database:web3_db1
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 17:21
Mail System doesnt work! crichton Installation/Configuration 3 17th September 2007 23:49
Limit mysql database size ddelbia Feature Requests 14 25th April 2006 21:42
Cant connect to MYSQL database from Dreamweaver toyito Installation/Configuration 5 1st February 2006 16:52
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 16:14.


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