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?

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.

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?

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.

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.

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!!!

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.

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

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

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.