close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

error connecting to db

Thread began 4/05/2011 1:46 pm by tkendrickmail32213 | Last modified 8/12/2011 10:02 am by Jason Byrnes | 1845 views | 10 replies |

tkendrickmail32213

error connecting to db

I get "an unidentified error has occured" message when creating a db connection to use PowerCMS builder. I don't see how this could possibly connect to my database while using this in Dw from my local system.

I have "localhost" for the mysql server (I have tried putting the ip address here as well)
I have the username of the user for the database entered.
I have the password for my mysql database.
I have the database name entered.

This is not nearly as straightforward as using PowerCMS. I have already installed the beta build, and have deleted the dat file you always have people deleting. What next?

Sign in to reply to this post

Jason ByrnesWebAssist

are you creating the connection to your remote MySQL Database? Or to a local testing server?

If you are trying to create a connection to your remote mySQL Server, you should double check first with the host to see if the MySQL Server allows connections from outside computers.

Sign in to reply to this post

tkendrickmail32213

proper procedure

I have every intention to connection to remote database. I don't know if my host does or not. I have looked at WebAssist Documentation and see no help on using PowerCMS builder from within dreamweaver to get through this step.

With PowerCms, I uploaded it and walked through a wizard online. With PowerCMS Builder, I do it from an extension. So, how do I do this from Dreamweaver?

Sign in to reply to this post

Jason ByrnesWebAssist

creating a connection to the Remote host in Dreamweaver can sometimes be problematic.

First you need to contact your host to see if the connection will be allowed. Some hosts allow this, others dont.

If they allow the connection from the outside3 server, you will need to also know the MySQL Server name to use, this probably wont be localhost.


It's tough to give a "proper procedure" since it changes from host to host. the first step though to contact the host to find out if the connection will be allowed by the server, many hosts also have an FAQ that will give you the information on creating the connection in Dreamweaver.

Sign in to reply to this post

tkendrickmail32213

db

It has always been localhost for my other webassist connections (am trying ip address again). If this doesn't work, is there an alternative way like uploading the PowerCMS files? I have installed many PowerCMS and PowerGallery apps, and have not run into issues like this. My host has now allowed me remote access, and it still doesn't work.

I bought the super suite on the basis of this application being added to the suite.

Sign in to reply to this post

tkendrickmail32213

Is anyone there going to address this issue

Web assist does not provide documentation for PowerCMS Builder at the database connection level. PowerCMS worked well as a stand alone product, but this extension doesn't work. I bought The entire super suite based on this working. I left a message for Webassist to call back as I would like a full refund. I am not giong to lose a 3rd day of work trying to get this resolved!!!

Sign in to reply to this post

Jason ByrnesWebAssist

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Sign in to reply to this post

edrosenthal350859

unidentified error

i'm having some issues as well with this - on my local server, running wamp, i tried to make a connection and got the unidentified error.
i use root without a password, and tried that first. no joy.
i did a grant to username and tried that second, no joy.
any ideas?

i wanted to use this method to see if i could get the mxp from dw to generate the files
that i would then put online on remote server, since that server did not accept connections
( working with support on that issue ).
else i would just take the files from a previous install and upload them to the server in question...

also i should mention the help key took me to an adobe page that no longer existed.
JSH_connPHP

is there a way to get the complete collection of files that builder uses, so that i can have
that as a resource to upload files when all else fails?
presumably they are not the same as the cms powerbuilder files - i don't want to use those files since the install is then domain dependent, and the reason for owning the builder app was to be able to multi use these solutions...
thanks in advance again
e

Sign in to reply to this post

Jason ByrnesWebAssist

the database connect in power cms builder will require a password for the root user, it is intended t be used on remote servers where there will always be a root user password.

the power cms files can be found in the users configuration folder. for help locating the configuration folder, see the common installation issues FAQ:
common_installation_issues.pdf

once you locate the configuration folder, go to:
shared/webasist/poercms/cms

Sign in to reply to this post

edrosenthal350859

No root user

i guess when you say 'root' you are talking about the privileged user of the database yes? the one who is granted all privs and even other grant privileges? we had that information for the localhost and was not able to get in to that one, but the more pressing issue is finding the files that can be used for the total install. I was able to take the files from a folder where i did have a successful install, and was able to run the install_cms scripts ok. But some of the files must not have transferred, or i have missing files, because the template for the admin area, or the css files are incomplete. I will run ftp uploads on which files i think are missing, and see if that can complete a successful install. it is more important at this juncture to get the remote up and running, than to worry about the localhost right now.

Sign in to reply to this post
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...