close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Still Getting Started..

Thread began 8/11/2011 5:01 am by SuzieQ | Last modified 8/18/2011 12:03 pm by Jason Byrnes | 771 views | 5 replies |

SuzieQ

Still Getting Started..

I realise this must seem mundane, but I'm pretty fresh at setting security assist up -- I have my SQL loaded, but won't have a database specialist here till Monday, so when I've tried to set up the fields, it says I need a database setup.

Is there anything I can do to set up my security assist pages without first setting up a database -- can that be added later?

I have already configured my buttons.

What I have done:
changed the extension on my page to .php (been told this won't change the page structure in my DM root)
Modified my buttons

Wondering how it all comes together?

Any step by step - fer dummies is mucho-appreciated!

Cheers

Sign in to reply to this post

Mike Perry

Originally Said By: SuzieQ
  I realise this must seem mundane, but I'm pretty fresh at setting security assist up -- I have my SQL loaded, but won't have a database specialist here till Monday, so when I've tried to set up the fields, it says I need a database setup.

Is there anything I can do to set up my security assist pages without first setting up a database -- can that be added later?

I have already configured my buttons.

What I have done:
changed the extension on my page to .php (been told this won't change the page structure in my DM root)
Modified my buttons

Wondering how it all comes together?

Any step by step - fer dummies is mucho-appreciated!

Cheers  


At the risk of sounding cheeky, until you set up the database there is nothing to secure. . .

:)

Sign in to reply to this post

Jason ByrnesWebAssist

like mike has stated, you cant do much with out the database.

to further explain this, lets break security assist down to the user experience.


a new user comes to the site and wants to register to gain access. they go to the registration page where they enter their personal information including email address and password. when the registration page submits, the information is stored in the users table of the database

a registered user will go to the login page. they enter their email address and password, when the login page submits, it will look in the users table of the database to see if the email address / password combination that was entered exists (checking to see if they have registered) if it does, the userID from the primary key column is stored in a session variable.

this userID session variable is used on any of the other protected pages to determine if the user should be allowed access or not.


without a database in place, there is no way for a user to register.

if the user cant register, they cant login.

if they cant login, there's no way to know if they should be allowed access to your pages.

Sign in to reply to this post

SuzieQ

mysql to security assist..

Okee - have created a table in mysql with records that match the fields in security assist -- now the confusing part, how do I marry the two? ie. How do I go from Table in mysql to functioning database in security assist?

I'm guessing, I have to fill in the following and not sure what is what:

Connection name:
MySQL server:
Username:
password:
database:

Can you explain if filling in these options will pull the records through? And do you have examples of what I need to use for these fields?

Sign in to reply to this post

SuzieQ

Still confused..

I tried to run the database to define pages and it said that an error has occurred and the create table statement has been stored. I'd paste the message here but the system does not allow for pasting images.

Help? Will SA create the tables for me? I thought they had to be created in mysql?

I've created my login/logout/update pages and I get a message saying I can use the following file to create my database: webassist/security_assist/localhost_pcms2_users.sql.

Can I open this file in sql workbench and create my table here? Is this an easier way of doing this? How do I create my table on this file if I'm only a beginner with sql workbench?

Sign in to reply to this post

Jason ByrnesWebAssist

yes, you can use the webassist/security_assist/localhost_pcms2_users.sql file to create the tables in the dfatabase.

see the "How to import a MySQL (.SQL) file to your database" tutorial on the learning resources page:
resources.php?utm_campaign=Forum_header&utm_medium=Forums&utm_source=WebAssistForums

Sign in to reply to this post

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