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

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

:)

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.

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?

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?

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