An FTP errot as occured

[nashr64589528]

I have tried to connected to my database in 127.0.0.1:8088 am getting an error message "An FTP error occurred- cannot make connection to the host. Internal data error. Failed to receive network data."

I have made exceptions in my eset nod 32 smart security 9 firewall for Dreamweaver CC 2017.

[Preran]

Can you try the solutions in Troubleshoot FTP issues in Dreamweaver  and let us know if they helped?

Thanks,

Preran

[nashr64589528]

I have tried all these methods and I have also uninstalled all Microsoft servers products and IIS, I have made exceptions in the Firewall but still I get the same message.

Filezilla is not connecting either to my localhost.

[Nancy OShea]

Filezilla is an FTP client.  It has nothing whatsoever to do with database connectivity.   For that you need server-side code.

Can you please explain exactly what you're trying to do?

Nancy

[nashr64589528]

Nancy i have tried all methods of troubleshooting as Preran recommended including using Filezilla, kindly read above messages with Preran you will understand my problem.

[Nancy OShea]

Do you have a local testing server?

Which one?

Is your local testing server fully defined in DW yet?  Can we see your screenshots?

Have you created a SQL/MySQL database in your local testing server yet?

Have you created the server-side code to connect to that database?

Filezilla plays no part in any of this.   A File Transfer Protocol client is used to upload files to your remote server.  It does not perform SQL/MySQL data transfers.

Nancy

[pziecina]

What exactly are you trying to do?

Are you trying to use your remote database to see its content in Dw, or are you trying to upload files to it?

[nashr64589528]

Am getting this message from DW ""An FTP error occurred- cannot make connection to the host. Internal data error. Failed to receive network data." when am trying to connect to my localhost 127.0.0.1:3306. This occurs when I was testing the connection. I earlier explained am using Eset Nod 32 Smart Security 9. I have made all the necessary exceptions, Am also using a router to access my internet. Please not am not trying to use a remote server, am trying to use my localhost. 

[pziecina]

You do not use ftp to connect to a localhost server on your drive, this is a little old but see -

http://www.extendstudio.com/blog/2010/03/how-to-make-a-testing-server-work/

[nashr64589528]

Nancy I have done all that, I have created Apache 2.4 server on xammp. but i cant access it as I have indicated in the error produced during testing

[Nancy OShea · Accepted solution]

Define your local testing server in DW.  See screenshots below.  In my example, I'm using Wamp server and my default web directory is www.   Yours is xampp and htdocs.

Servers > Basic tab

Advanced Tab

Final screen

[nashr64589528]

That is the error message I got after applying the instructions you gave me.

[pziecina]

Please check which version of php you are using.

If you are using php 7, then this will not work with the server behaviours that you are using. You will have to use php 5.6 or less for those to work.

[nashr64589528]

[pziecina]

This shows that you are probably using PHP 7, and as the MySQL module is not supported by PHP 7, it will not be loaded.

You will have to use a version of PHP that is 5.6 or less, but you should be aware that unless your hosting server is your own dedicated server you will be living on borrowed time with regards to the continued use of the Dreamweaver server behaviours.

Once a hosting provider updates to PHP 7, the server behaviours will stop working.

You should look into using PHP::PDO or PHP MySQLi as replacements, which the server behaviours do not support.

3rd party solutions are available, but must be paid for. My recommendation would be -

https://www.dmxzone.com/go/22151/database-connectivity-collection-php?utm_source=Extensions&utm_medi...

[Nancy OShea]

Copy & paste the following MySQLi (improved) connection code into a new PHP file.  Save to server as test.php, adjust values in bold accordingly.

<?php 

$conn = new mysqli('localhost' , 'database' , 'password' , 'table_name');

echo "<h1>Success in database connection! Happy Coding!</h1>"; 

// if no success the script would have died before this message

?>

<?php phpinfo() ?>

When viewed in your browser, the phpinfo function will tell you exactly which version of PHP you have on your server.

Nancy