PDA

View Full Version : DB Connection Issue


otech
05-29-2004, 05:27 PM
My issue is:

I am unable to connect to any mySQL DB on any website we host on our VPS using DreamWeaverMX on OS X 10.3.3. I can log into the remote testing server on these website's and I am able to FTP files to directories using DW.

Dreamweaver asks the following to config a DB connection:

mySQL Server Name:
Username:
Password:
Database:

I enter what I believe is the correct information and the error message I receive is:

550 /_mmServerScripts: Permission Denied

(All DB's have users assigned.)

From the "HOWTO Articles" I read this:

Moving Files Around: Setting up FTP

FTP (File Transfer Protocol) is a common way of moving files between computers.* By default your RimuHosting server will not have FTP enabled.* To enable FTP, first edit the vsftpd.conf file (e.g. vi /etc/vsftpd/vsftpd.conf).* Then:

Uncomment the "write_enable=YES" line (else you'll get an error like '550 Permission denied.' from your FTP client when you upload a file or create a directory)

I cannot find the file, vsftpd.conf on my VPS server and I'm unsure if this is really the issue. Do I need to config mySQL for user rights or something of this nature?

Thanks in advance.

Fred

arthur
05-29-2004, 09:42 PM
hi, if you are able to ftp with dw then i suspect that the vsftpd.conf file is allready okay and the server can take ftp's. the file should be in /etc/vsftpd/vsftpd.conf (the vi that you see in the article is actually just the unix editor)(Sorry if you already knew that!) i am not up to date on mysql, but a couple of things come to mind
1. have you rebooted the server at all and/or checked that the ftp is automatically running on boot up?
2. try using the 'passive ftp' option in dw mx, that does usually help in a lot of ftp problems.
3. you may need to create a new user for mysql to actually run
4. check the mysql db's owner permissions to see if they are wrong
i did find an article at macromedia that might help you, it is at;
http://www.macromedia.com/support/dreamweaver/ts/documents/designtimeruntime.htm
for troubleshooting ftp probs;
http://www.macromedia.com/support/dreamweaver/ts/documents/troubleshooting_ftp.htm
hope that helps.
regards, arthur

MauricioF
12-23-2004, 03:37 AM
Hi:
I use SCP with DreamWeaver MX, this is more secure than ftp and easy to use, rimuhosting is ssh enabled.

You don't need to configure anything on the server.


http://www.macssh.com/

There is a progran to test the conection before configure DreamWeaver.

Then just change the protocol in DreamWeaver.


Regards


[/i]