close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Can't setup Database Connection

Thread began 10/15/2016 12:07 pm by Paul | Last modified 10/17/2016 12:59 pm by Ray Borduin | 1728 views | 11 replies |

Paul

Can't setup Database Connection

I'm trying to remote connect with dreamweaver to a raspberry with mariadb, but for some reason webassist "Dynamic MySQL" and "Dynamic MySQLi" do not connect and result in an error. I have tried 192.168.2.30:3306 and without port but the error keeps returning. I can remote connect without a problem with Navicat and MySQL workbench.

See attachments

Do you have any suggestions?
Do i need to delete configuration files?

Sign in to reply to this post

Ray BorduinWebAssist

It may be an issue with the site definition in Dreamweaver. If you export and send me the site definition you are using (privately) then I can try to reproduce the problem and debug it. My guess is that the problem is elsewhere in your site definition.

Sign in to reply to this post
Did this help? Tips are appreciated...

Paul

Hi Ray, thanks for the fast reply and willing to look into it.
I have attached export DW site definition including local paths

Sign in to reply to this post

Ray BorduinWebAssist

You have your website url set to: http://printserver/

That isn't a working domain. It needs to be able to connect to the website in order to test and retrieve data from the database.

Sign in to reply to this post
Did this help? Tips are appreciated...

Paul

It's a local server and not a public server

Sign in to reply to this post

Ray BorduinWebAssist

Are you sure the local server is set up properly? I can't really test because I can't access it, so for me that is the issue.

Are you able to FTP to the server without problems? Does Live view work for your pages? If you create a page on the server with:

<?php
phpinfo();
?>

Does it appear to have MySQL installed?

Sign in to reply to this post
Did this help? Tips are appreciated...

Paul

Yes, i'm 100% sure webserver is working and installed with all webservices and modules (apache2 + vsftpd + php + mariadb) and i can use a different mysql client without a problem because this is a server behind LAN and not a public server.

Sign in to reply to this post

Ray BorduinWebAssist

The way dreamweaver tests a connection is this:

1) It uses the testing server settings to transfer files to the _mmServerScripts folder
2) It uses the url specified in the testing server to post data and access the files it uploaded which return xml with the results

The error you are getting means that it can't access the files once uploaded. Can you see the _mmServerScripts folder in the file system and confirm they were uploaded properly onto the testing server?

If you manually browse to one of those files using the url and appending the folder and one of the file names can it be accessed? For some reason Dreamweaver is unable to browse to that file. Is it possible it has a firewall that is blocking dreamweaver's browser?

Sign in to reply to this post
Did this help? Tips are appreciated...

Paul

See attachment (putty + dreamweaver ftp log)

Anwser is yes, mmServerScripts are uploaded to remote server.
Dreamweaver can access the ftp without a problem.

Sign in to reply to this post

Ray BorduinWebAssist

Can you browse to one of the files in the mmServerScripts folder in a browser?

Sign in to reply to this post
Did this help? Tips are appreciated...
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...