Topic: MySQL and Dreamweaver MX

[Kees Vonk]

I am trying to get Dreamweaver MX to connect to a MySQL database on SME 5.6. However it keep complaining that it cannot find the test server. The error says:

=======================
HTTP Error Code 404 File Not Found.Here are some possible reasons for the problem:

1) There is no testing server running on the server machine.
2) The testing server specified for this site does not map to the https:///_mmServerScripts/MMHTTPDB.php URL. Verify that the URL Prefix maps to the root of the site.
========================

I am not sure what to do with this error as I am new to both php and MySQL. Can anyone help me out on this one please?

I have phpmyadmin installed (which I used to create the database).

Thank you very much,

Kees

[Jeroen]

Kees, you might want to search the forums/devinfo on this one. Believe that out of the box mysql won't let external boxes connect. There is a setting for that though somewhere.

good luck,

Jeroen

[Jeroen]

Kees, check this topic:
http://forums.contribs.org/index.php?topic=16344.msg63207#msg63207

Jeroen

[Kees Vonk]

Excellent, that was exactly what I was looking for,

Thank you very much,


Kees

[Michael Roed]

Hi Kees!

Did that work for you? I get an error trying to download the rpm's.
Can you connect with DreamWeaver??? If yes, what excatly did you do?

Thanx,
Michael.

[Kees Vonk]

Try this link:

http://forums.contribs.org/index.php?topic=6523.msg23456#msg23456

just remember to increase the version number from 42 to 43. I can then connect to with Dreamweaver MX (use FTP and not local/network access (of course FTP needs to be enabled)).

Kees

[Michael Roed]

Thanx kees but I get an error when finished retrieving the rpm saying "failed dependencies: glibc-common = 2.2.5-40 is needed by glibc-2.2.5-40" does that mean that I have to download glibc-2.2.5-40 first ???

Thanx,
Michael.

[Pete Edwards]

Hi,

Sounds like an mysql permissions issue to me. I'm an e-smith n00b, but taking a look at the box it looks like you can only connect locally. What you need to do is tell mysql to accept connections from your local network. You can do this by creating a user account in mysql.

Don't know how to do this via e-smith but it's a piece of cake via shell.
mysql -u -p mysql

INSERT INTO user VALUES('','',PASSWORD('your password for this connection>'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');\g
FLUSH PRIVILEGES;\g

Or to allow connections from anywhere... use: (% being a mysql wildcard)

INSERT INTO user VALUES('%','',PASSWORD('your password for this connection>'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');\g
FLUSH PRIVILEGES;\g

I would caution you that I probably know less than you about e-smith so may be unaware of the implications of doing this on e-smith. But I guess some guru will come and correct me.. All the best

[Michael Roed]

I am not very keen on trying your proposal Pete so I havent done anything.

I now get another error saying: 1045 Access denied for user: 'root@localhost' (Using password:YES)
According to mysql.com this error is when I use a wrong password but nomatter what user with the correct password i use, I keep getting the error.

Any ideas?!?!?

By the way if I try to upgrade glibc in any way I keep getting "Depending on 2.2.40" or something like that. So I cant upgrade like all other answers says in this forum!!!

[Kees Vonk]

The following is cut and paste'd straight out of the link I send you earlier (I did correct the version for you), if you have internet access and type exactly this it should work. The '' should be last character on the second line (no spaces after it)!!!!!!

Kees


R=ftp://rpmfind.net/linux/redhat/updates/7.3/en/os/i386
rpm -Uhv $R/glibc-common-2.2.5-43.i386.rpm \
$R/glibc-2.2.5-43.i386.rpm

[Michael Roed]

Kees I already did that but it doesnt work. After the rpm has downloaded I get the "depending on glibc-common 2.2....." error and then it all stops!

So there´s something other that is wrong...

Michael

[Kees Vonk]

That is strange, the '' at the end should escape the newline so the second and third line effectively become one and as you are downloading the right version of glibc as well it should not complain, try putting the second and third line on one line like this:


R=ftp://rpmfind.net/linux/redhat/updates/7.3/en/os/i386

rpm -Uhv $R/glibc-common-2.2.5-43.i386.rpm $R/glibc-2.2.5-43.i386.rpm


And if that doesn't work swap glibc-common and glibc, but shouldn't make a difference.

Kees


PS. just had a thought if the '' escapes the new line you could trying putting a space at the beginning of the next (the third) line to make sure both files are seperate arguments to rpm.

[Michael Roed]

OK that seem to work better and now I have installed the rpms BUT..........

Same error in Dreamweaver!!! "An unidentified error has occured" it says.

but why???????????

[Kees Vonk]

Michael Roed wrote:
>
> OK that seem to work better and now I have installed the rpms
> BUT..........
>
> Same error in Dreamweaver!!! "An unidentified error has
> occured" it says.
>
> but why???????????

This is a bit of a stab in the dark as I am not using Dreamweaver personally, but one of my colleagues does all the dreamweaver stuff. I have had a look at her Dreamweaver settings though. I hope this helps.


Kees


--------- setup -----------
e-smith 5.6
PHPMyAdmin
glibc and glibc-common updates

Windows ME
Dreamweaver MX

-------- e-smith ----------

Created ibay: testkees (enabled FTP)
Created Database in PHPMyAdmin (keesdb)
Created Database User in PHPMyAdmin (kees:password)

-------- windows -----------

Site Settings in Dreamweaver:

Local Info:
========
Site Name: test kees
Local Root Folder: C:\websites\testkees
HTTP Address: http://myserver/testkees
disable cache (don't know if this is necessary, but that is her setting).

Remote Info:
=========
none

Testing Server:
===========
Server Model: PHP MySQL
Access: FTP
FTP Host: myserver
Host Directory: /ibays/testkees/html
Login: kees
Password: password
Don't use Passive FTP
Don't use Firewall
URL Prefix: http://myserver/testkees/
Don't use SSH encrypted secure login

[Michael Roed]

Sorry to say so but that didnt help. Same error ! (