Koozali.org: home of the SME Server
Legacy Forums => General Discussion (Legacy) => Topic started by: Kees Vonk on May 22, 2003, 07:29:19 PM
-
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
-
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
-
Kees, check this topic:
http://forums.contribs.org/index.php?topic=16344.msg63207#msg63207
Jeroen
-
Excellent, that was exactly what I was looking for,
Thank you very much,
Kees
-
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.
-
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
-
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.
-
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
-
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!!!
-
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
-
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
-
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.
-
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???????????
-
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
-
Sorry to say so but that didnt help. Same error ! :-((
-
I am sorry but I can't think off anything else that would be helpful to you. I am not an expert on PHP, MySQL or Dreamweaver. Maybe you could try a news dreamweaver news group (I can see two):
alt.macromedia.dreamweaver
macromedia.dreamweaver
I am sorry I could not be of any more help,
Kees
-
Kees thank you very much for all your help.
Too bad that it didnt work out but now I am trying to install a ver.5.5 ´cos Im sure that there are something in 5.6 that is causing all this.
Michael.