Hi, Am experiencing an error trying to update a database source to reflect new fields added to the database. My testing server is configured exactly the same as my live server including username, password, and database name. When I test the database connection it connects fine but as soon as I try to apply or via the source itself, refresh, I get the error 'Error Using This Database Connection Server Response:'
I have been through all my settings and checked my test server and live server. My database locally is exactly the same as my remote database. I use DB Forge and SQL Workbench and these connect just fine and show the new fields as they should do..
For now I have added the fields manually to the connections file used for the site but this is a workaround and not a solution.
I am having the same problem as you did and I am confused with what you meant about the connection file. DW creates a folder named as dmxconnections and puts php files in it. Did you mean that folder and file? I deleted it and tried to create a new connection after restarting servers but the problem still exists? I could not have created a connection from scratch. Do you have any suggestions?
Hi Ömer, If you are running a local test server and a hosted deployment server make sure they are configured exactly the same with regards to username, password and host details for the database. FTP in to your deployment server and open the dmxconnections folder and check the .php connections files match your database server credentials. If not edit as required.
You may also wish to check that your hosting allows for additional hosts to connect to the database if its away from your deployment environment (we run our database services on a separate server) and had to allow our deployment server IP to connect (rather than localhost we specify an IP).
I hope that helps? Please feel free to check and reply and I shall answer as best I can.
I really appreciate your kind help. I will pay close attention to your advice. However, the problem I am having now is that I could not have created a connection for my first demo app. MySQL is up and running and accepts connections with the same credentials that I use for DMX. I am using XAMPP as a local deployment server. Hence I don't need FTP for now. When I try to create the connection the very first time, I am getting the same error as you got in the screenshots. Therefore, I am not getting any connection php files filled with my credentials other than the generic dmxDatabase.php file which is a core file for managing operations I guess. Hence, I am kind of stuck and trying to find what might have been causing this problem. I have restarted servers and created a new site application from scratch but that's no help, either. Anyway, thanks a lot again for your quick response and help! Have a nice day!
OK try this Ömer, XAMPPs default SQL installation does not allow for over complex passwords. Try re-setting your database password to something simple like 'test' (without the quotes of course).
Then see if you can connect.
If you can connect with no problems its the password that is causing the issue. No problem! When you upload the production DMX connection files simply edit them and change the password to reflect the more complex live database environment password.
Sorry for the delay in my reply I have been working on E-mail parsing and it is driving me nuts hahahaha
No worries my friend am happy to help if I can. The support team at DMX are great. Sometimes I think their delay in replying is to allow us users to figure it out for ourselves (this is usually the case with myself lol).
I have just setup a new site and database, and I am getting this same error. I have been using the extension without problems on another site.
The local and testing servers are the same, I have removed and re-installed the extension, I have re-created the site in Dreamweaver, but still the 404 error when requesting dmxdatabase.asp exists, even though the file is there on the live server...
Hi Simon, Can you check that the connection file for the database contains the correct database credentials and that there is no issue with password complexity by changing the password on the remote server to something simple like 'test' (obviously change this after you confirm everything is good). Also check that your database user has the correct permissions. See if any of that helps...
I am not a DMX employee so they may have a better idea. Am just trying to offer some advice.
I can't even get to the stage where DW creates the connection file with the password in it. I open the Database Connection Dialog, enter my Data Source credentials etc, then the dmxdatabase.asp file is uploaded, then just before the connection file is created the 404 error comes back.
I even created an old basic Access DB with physical path, so it's nothing to do with mySQL permissions etc.
Hi, Please check you have a simple password for your database on XAMMP (as you are working locally there are no issues with security), something like password will do. You can also check the generated connection files that DMX creates.
Edit them to provide your new simplified password and just ascertain that they have all the correct details for your database connection.
Also make sure that the database user has the correct permissions (use PHPMyAdmin to do this by clicking on the Admin button inside the XAMMP control panel and clicking Users). If you are unsure add two users with the same name, one with the host set as % and the other as the host localhost (sometimes there can be issues with using the wildcard %), so to be sure add two users as I said.
Remember to either update your Database Connector with the new password/user or edit them manually.
When you deploy to a live environment (hosted) you can upload the connection files as normal and then edit them to add a new and complex password. Many hosts only allow passwords based on a complexity score of 100%. I usually find there is not an issue with complex passwords on hosted platforms but locally XAMMP does seem to have an issue with them.
Thanks for your quick reply! Just to tell that I am new in PHP! - I have only one file that DMX has created: dmxDatabase.php - I have a very simple password: 123 (as I am in local and it is for training with DMX extensions, so...)
I do not see the database nor the server nor the password in the generated file. Where can I put these informations please.
Sorry for bad english, I am french speekin Regards DS
Does the table have any fields? Remember the first field needs to be the Primary Key, set as INT and Auto Increment. Then maybe add a second field such as Name. Try inserting a test record through PHPMyAdmin and then try to re-create the DMX Zone Connection.
Sorry if you have already done this. I do not know your skill level with regards to MYSQL and am covering the basics.