Are you a Google Analytics enthusiast?
More SEO Content
Connecting To Mysql With Mx Help!
Posted 11 February 2005 - 12:24 PM
I have now spent the best part of 2 days trying to connect to MySQL on my host servers using DW 2004MX. (passwords and privalleges are set up)
When I attempt to connect with DW MX it reaches the 'testing connection' stage and thats where it stays.
On all the databases I have set up (Host is using Linux Svs) they all contain content but on MX they show NO TABLES?! So no connection is being made.
I can connect and display using PHP but not with MX which will help me no end with regards to time saving.
Any idea's out there this is driving me bonkers as I have tried every config under the sun, Macro forums, etc
Posted 11 February 2005 - 01:30 PM
The reason I ask is because I don't, period end of discussion. It's simply too risky from a security stand point for me to open that up even a tiny, tiny crack.
That would be my first guess.
Posted 11 February 2005 - 01:49 PM
yep I'm seeing that more and more with hosts too...
Posted 11 February 2005 - 01:55 PM
Posted 11 February 2005 - 05:13 PM
they have arranged it for us. They run a security check over a 72 hour period and confirm that you have a static IP address (which we have)
So that was the first issue and prior to us being added to their 'permitted list' we were getting the 403 message. Now we are 'connecting' of sorts but not getting past the 'test connection' screen on MX
I have inputted most of my data now via phpmyadmin and just looking around for php tips to get the queries/selects to sit in the right columns on my page and not just one big mass...
The main reason for the topic is that DW MX would make our updating and designing so much easier with the recordset usage and the internal interface (plus my limited php skills?! )
Posted 11 February 2005 - 06:47 PM
Make sure that your database name, database user/password and such are all correct. Remember that Windows will allow upper- or lowercase and still connect just fine. *nix won't. So if your database username on the server is "abc" and you have it in your MX as "ABC" it's going to be rejected.
Also pay particular attention to your own local firewall software. It too might be blocking something. The easiest way I can think of to do that is to simply Whitelist the IP number of your server on all ports and for all type of connections.
I looked around for a tutorial for MX using PHP/MySQL, but most of them suggest connecting to a local database and then upload everything. That's not very useful for what you're trying to do. A couple of them did mention that you may need additional MySQL drivers on your local machine to make it all work. So if you didn't install any of those that might be something to look into.
Not sure if this will help, however here is one of the few tutorials I found in a couple of searches that talks about sync'ing up with a remote database.
Posted 12 February 2005 - 05:20 AM
The firewall has been set to allow the connection and all data is correct. I can only think that there is something at my hosts end preventing this (even though they have 'allowed' my IP through their firewall)
will battle on...and as before use the old phpmyadmin and php in MX, seems the only way I am going to get this going, and after a swift intro (into the wee small hours today) it seems quite rapid to action anyway.
Just need to config my css to make it all sit right on the page now
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users